Purchase order management is a huge task that comes with many difficulties. From registering every supplier and their personal needs to processing all order requests per department and their special requests. With this template in Google Sheets, you can easily combine every step of the process in an automated dashboard for you to easily track your order status.
How the system works
This template is designed to automatically connect 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. A dashboard is provided there, with useful statistics on your orders and suppliers and possible complaints.
Let’s get you started
Step 1. Install the template
Click on the button above to install your Purchase order management template in Google Sheets. You will be asked to log in using your Google account. Your
Step 2. Open all spreadsheets
As seen on the Network View below, the different “Order request #” spreadsheets are connected to the master spreadsheet “Purchase order management”. To start using this template, click on the spreadsheet icons to open.
Step 3. Fill out the input spreadsheets
Inside the “Order request #” spreadsheets, you can 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 management 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.