by martieLast Updated : May-13-2023
As a business owner, creating a purchase order and even purchase order forms can be daunting, especially if you are new to the procurement process. However, the process can become much easier and more streamlined with the right purchase order template. This article will provide you with everything you need to know about creating a purchase order using a free Google sheet template.
The purchase order template we will discuss in this article is a ready-to-use template for creating and tracking purchase orders.
The template is fully customizable to meet your specific needs and standard purchases.
Click on the link below to download Google Sheet Purchase Order Template
Get Google Sheet Purchase Order Template
Before we dive into the details of the purchase form template, let’s start with a brief introduction to purchase orders.
A purchase order is a document that a buyer sends to a seller to request goods or services. It is a legally binding agreement between the buyer and seller, outlining the purchase details such as the product or service, quantity, price, and delivery date.
A purchase order is an important part of the procurement process and your inventory management as it helps to ensure that the buyer and seller are on the same page and that the transaction runs smoothly. Without a purchase order, there is a higher risk of miscommunication, delayed deliveries, and disputes over pricing or quantities.
Creating a purchase order from scratch for typically simple purchases can be time-consuming and complicated, especially if you are unfamiliar with the process. Using a purchase order template can save time and reduce the risk of errors or omissions in the order.
A purchase order template provides a framework for creating a purchase order that includes all necessary information for your purchase order documents. It ensures you do not forget any essential details and makes organizing and tracking your purchases easier.
Additionally, a template can help maintain consistency across your purchase orders and other contract purchases. It ensures that all orders follow the same format, making it easier for vendors to understand and process them using a formal purchase control system.
To start, copy the purchase order spreadsheet to your Google Drive as google forms.
To do that, click on File and Make a copy+
The second step in customizing the purchase order template is to update the logo. This is an optional step, but it can help to give your purchase orders a more professional look.
To update the logo, open the template and click on the highlighted cell where the text “Your logo goes here” is located.
Delete the text in the cell.
Then, click the “Insert” tab in the main menu and select “Image” from the dropdown menu. Select the “Insert Image over Cells”.
Upload your logo and resize it as needed to fit the cell.
The next step is to update the purchase order header with the product details. This includes the date of the purchase order, the purchase order number, and any other relevant information.
No need to use any special software to do this. To update the header details, click on the relevant cell and enter the information. For example, to update the purchase order date, click on the cell where the date is located and enter the date in the correct format.
The next step is to update the vendor, billing, price per unit, and delivery details. This includes the vendor’s name and address, the vendor’s contact details, and the shipping information. Do not forget to include the delivery instructions as well.
Moving on, let’s delve into each section in more detail.
Providing the vendor’s details is a simple process. You will need to fill in the following information:
The “Ship To” section contains the recipient’s contact information and address details. Your company name and address should be specified here. Vendors will use this information to ship the product.
To ensure hassle-free delivery, it’s best to include additional details such as building number, suite, or floor number.
You can also include a contact person’s name and contact information for the courier or vendor in case they need assistance finding the location.
Although not mandatory, you can use the “Bill To” section to provide specific instructions on how to send the bill for the purchase order.
For instance, if your company doesn’t have a standardized process for receiving invoices, you can use this section to specify the instructions and drive compliance with your standard process.
You can include a mailing address for the bills, but we recommend providing instructions instead of an address.
For example, you can specify that all bills should be sent to ap@yourcompany.com, and paper bills will not be accepted for payment.
Billing email and contact information can also be included for clarity.
To prevent any other communication issues, make sure you include all the necessary detail to serve as an official record. Moving on, the following step involves entering any additional information that needs to be included in the purchase order.
This may comprise of the agreed payment terms with the vendor, delivery contact if it differs from the order contact, any special freight terms applicable to the purchase, and any special notes or comments for the supplier.
The next step is to update the line item details for the purchase orders in the simple spreadsheet template that we shared, which pertains to what is being purchased from the vendor.
The header fields are customizable and can be changed to match your exact headings for any digital purchase or electronic purchase.
The various fields in the line item details include the following:
This section involves any additional shipping and taxes that need to be added to the purchase order.
The template provided above automatically calculates the subtotal based on the line total. The taxes and any shipping charges are calculated and added to the spreadsheet. The template then calculates the order total based on the above three factors.
While not mandatory, many companies prefer to have an authorized signatory on the purchase order to ensure that it comes from the authorized buyer and not just anyone from the company.
The template above provides an option to include an authorized signatory.
Simply replace the image with the signatures of the authorized signatory by clicking on the image and hitting delete on the keyboard.
Then insert the image using the Insert -> Image -> Insert Image over cells option on the Google Sheet.
The last stage of the purchase order process is to send it to the supplier after completing all the necessary details. Luckily, we have made the entire process easier for you. All that’s left for you to do now is to print the purchase order and convert it into a PDF format for easy sending.
Then click on “Next” to continue.
3. You will then see the following screen:
Click on More setting, then click on “Open PDF in preview”. This will open a dialog box and you can save the PDF of the document.
And that’s it, you now have a purchase order. You can send this to the vendor or in case you need additional approvals, first get the approval and then send it to the the vendor.
Optionally, you can keep a track of your purchase orders to ensure timely delivery and payment. To update the purchase order tracker, navigate to the “Purchase Order Tracker” tab and fill in the following information:
Refer to the screenshot below for the fields that need to be filled:
Using a purchase order template can be the first step toward maintaining a detailed record of your company’s purchasing history.
The following are some of the key advantages of using this purchase order template:
While using a purchase order tracker in Google sheets has some obvious benefits, it also has a few disadvantages:
A purchase order template can be a great way to generate orders easily. If you’re not currently using any purchase orders, this is the simplest way to get started.
However, when you start generating more than 20 purchase orders per month, you’ll need a more robust system to create and manage purchase orders. More importantly, you must ensure that costs are controlled and that only approved purchases are sent to suppliers.
This is where ProcureDesk can help you. Our platform provides a central place to keep track of all your purchase order commitments and includes a cost-control process to ensure that only approved purchases are issued to suppliers.
If you want to see how ProcureDesk can help you, click the link below to schedule a free demo with one of our product specialists.
What you should do now
Whenever you’re ready… here are 4 ways we can help you scale your purchasing and Accounts payable process.