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
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.
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)
Step 4. Configure the template
To update the connection, go back to the
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.