Free Google Sheets Purchase Order Templates

By Andy Marker | July 6, 2024

We’ve compiled the most useful purchase order templates in Google Sheets to help you manage purchasing processes.

Included in this article, you’ll find the following:

Google Sheets Basic Purchase Order Template

Google Sheets Basic Purchase Order Template

Download the Basic Purchase Order Template for Google Sheets

When to Use This Template: This basic purchase order template is ideal for immediate and one-time purchases. Use this template to formalize and document purchase order processes.

Notable Template Features: This template includes fields for the purchase order number, date, customer number, vendor information, and shipping details. It also features space for item numbers, descriptions, quantities, prices, and total calculations.

Check out these free purchase order templates to help you standardize, streamline, and manage purchase order processes.

Google Sheets Blanket Purchase Order (BPO) Template

Google Sheets Blanket Purchase Order BPO Template

Download the Blanket Purchase Order (BPO) Template for Google Sheets

When to Use This Template: This template streamlines and consolidates recurring purchases into one purchase order with a single supplier. It helps reduce administrative workloads, improves efficiency, and strengthens supplier relationships.

Notable Template Features: This template details the terms and conditions, pricing, and length of the BPO agreement. It includes the quantity discount in total calculations and space for an authorization signature and date.

Check out these free purchase order templates in Excel to help standardize and manage purchasing processes. 
 

Google Sheets Contract Purchase Order (CPO) Template

Google Sheets Contract Purchase Order Template

Download the Contract Purchase Order (CPO) Template for Google Sheets

When to Use This Template: This template formalizes purchase orders with specific terms and conditions to demonstrate contractual compliance. It also enables strategic sourcing and helps secure long-term supplier relationships.

Notable Template Features: This template includes a contractual reference section with language showing that this purchase order follows the contractual purchase agreement. It has all the standard PO fields, including space for a dated authorization signature.

Learn more about managing and collaborating with vendors, reducing costs, and improving efficiency with this guide to building an effective vendor management process.

Google Sheets Planned Purchase Order (PPO) Template

Google Sheets Planned Purchase Order PPO Template

Download the Planned Purchase Order (PPO) Template for Google Sheets

When to Use This Template: This PPO template is ideal for scheduling deliveries based on predictable demand. It helps manage inventory levels, forecast spending, and consolidate orders into a single purchase order.

Notable Template Features: This template features space for tentative delivery dates and spreadsheet columns for item descriptions, quantities, and more. It also has a blank space for notes, terms, and conditions.

Learn more about receiving, tracking, and fulfilling orders with this ultimate guide to order management.

Google Sheets Service Purchase Order Template

Google Sheets Service Purchase Order Template

Download the Service Purchase Order Template for Google Sheets

When to Use This Template: This template is ideal for listing service terms and conditions, tying services to projects, and engaging service providers. It helps ensure that both parties understand the deliverables and expectations.

Notable Template Features: This PO template features specialized fields for service terms, acceptance criteria, and descriptions. It also has space for special instructions, authorization, and acceptance signatures and dates.
 

Google Sheets Manual Purchase Order Form Template

Google Sheets Manual Purchase Order Form Template

Download the Manual Purchase Order Form Template for Google Sheets

When to Use This Template: This template is ideal for small and medium-sized businesses that need a straightforward purchase order form for on-site work environments with limited online access and backup paper copies.

Notable Template Features: This printable template includes space for handwritten purchase order form information. It also includes the standard PO fields for documenting the details and ensuring accuracy in procurement.

Check out this collection of free order form templates to help fulfill and draft item, work, and service orders.

Google Sheets Consignment Purchase Order Template

Google Sheets Consignment Purchase Order Template

Download the Consignment Purchase Order Template for Google Sheets

When to Use This Template: Use this purchase order template when entering a consignment purchase agreement. It helps professionals optimize inventory levels and improve cash flow through delayed payments.

Notable Template Features: This PO template features consignment-specific sections for listing terms and conditions, payment terms, inventory management, replenishment details, and storage and handling requirements. These sections promote transparency by ensuring that both parties understand the consignment agreement.

Google Sheets Purchase Order Tracking Template

Google Sheets Purchase Order Tracking Template

Download the Purchase Order Tracking Template for Google Sheets

When to Use This Template: This template tracks important order details and provides an overview of all purchase orders. It promotes procurement efficiency, inventory management, and effective financial planning.

Notable Template Features: This comprehensive tracking template includes spreadsheet columns for the date, purchase order number, and vendor. It tracks the status of the order and details the amount due, the amount paid, and the balance for each purchase order.

Use this product inventory template for Google Sheets to help ensure that your inventory meets demand and achieves efficient inventory control.

Easily Manage and Track Purchase Orders in Smartsheet

Empower your people to go above and beyond with a flexible platform designed to match the needs of your team — and adapt as those needs change. 

The Smartsheet platform makes it easy to plan, capture, manage, and report on work from anywhere, helping your team be more effective and get more done. Report on key metrics and get real-time visibility into work as it happens with roll-up reports, dashboards, and automated workflows built to keep your team connected and informed. 

When teams have clarity into the work getting done, there’s no telling how much more they can accomplish in the same amount of time. Try Smartsheet for free, today.

 

 

Discover why over 90% of Fortune 100 companies trust Smartsheet to get work done.

Try Smartsheet for Free Get a Free Smartsheet Demo