You can make a copy of this order form template in Google Sheets for free. Don't request for permission to edit, simply go to File > Make a copy.
Below we explain how to use our order form template in Google Sheets:
Start by opening the Google Sheets purchase order template.
Find the cell next to "Purchase Order #" and type in your unique purchase order number. This helps in tracking and referencing.
Locate the cell next to "Date". Enter the current date or the date the order is being made.
Find the cells next to "Vendor Name" and "Vendor Address". Fill in the vendor's details accurately to ensure proper order processing and delivery.
Locate the cells next to "Buyer Name" and "Buyer Address". Input their corresponding details. In the cell next to "Delivery Date", you can specify the expected delivery timeline.
Item Number: Sequential number for identification.
Description: Brief but clear description of the item.
Quantity: How many units of the item you need.
Unit Price: Price per unit of the item.
Total: Automatically calculated as Quantity x Unit Price.
Below is an example:
After listing all items, the Subtotal cell will sum up the total cost. Input the shipping fee and the template should calculate the final Total Amount due.
Double-check the quantities, descriptions, and prices to ensure everything matches your order requirements.
We hope that this article has helped you and given you a better understanding of how to use our Google Sheets order form template. If you enjoyed this article, you might also want to check out our address label template and college budget template in Google Sheets.
