Purchase order management is a huge task that comes with many challenges. From registering every supplier and their personal needs to processing all order requests per department and their special requests. Therefore, Sheetgo created this purchase order template in Google Sheets. You can easily combine every step of the process in an automated dashboard. As a result, you easily track your order status at any given time.

Purchase order template

This template automatically connects the data from different department order requests (“Order request #” spreadsheets) into one master spreadsheet “Purchase order management”. Inside this master spreadsheet, you can input your suppliers and orders received. Above all, it comes with a dashboard full of useful statistics on your orders, suppliers, and possible complaints.

Let’s get you started

Step 1. Install the template

Click on the button above and install your Purchase order template in Google Sheets. Login using your Google account. After authorizing, we simultaneously create your Sheetgo account. Once logged in, the system redirects you to the Sheetgo web app where you can find the template. Click on the ‘Use template’ button to install.

Purchase Order Management Template Overview

Step 2. Open all spreadsheets

As you can see on the Network View below, the different “Order request #” spreadsheets connect to the master spreadsheet “Purchase order management”. Click on each of these spreadsheet icons to open so you can use the template.

Example

Purchase Order Management: Network Illustration of Workflow and Conenctions

Step 3. Fill out the input spreadsheets

Inside the “Order request #” spreadsheets, you register all order requests by:

  • Order number (which is automatically generated)
  • Order date
  • Supplier code
  • Order name
  • Order description
  • Price per order
  • Amount of orders
  • Total cost (which is also automatically generated)

Example

Purchase Order Management: Order Request in Google Sheets

Step 4. Configure the template

To update the connection, go back to the Sheetgo Web Application and click on the play button ‘Run workflow’. This automatically brings the data from the input spreadsheets into the master spreadsheet “Purchase order management”. After that, you can easily track your orders, supplier costs, complaints, and delivery days.

Example

Purchase Order Template in Google Sheets: Dashboard

Congrats! 🙂

You’ve successfully set up your Purchase order template in Google Sheets. Feel free to customize the template according to your company needs and do not hesitate to contact us in case of any trouble.

Share This