Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainPurchasing & ProcurementPurchase Order Log

SpreadsheetPurchasing & ProcurementFree

Purchase Order Log

Every purchase order from approval to delivery, invoice and payment, with late-delivery flags, invoice matching, open commitments and spend by supplier.

Shown with sample data

Colour

Purchase Order Log

Every purchase order from approval to delivery, invoice and payment, with late-delivery flags, invoice matching, open commitments and spend by supplier.

Open commitments
$10,820
Approved, not yet invoiced
Late deliveries
3
Still waiting
On-time delivery
67%
Of POs received
Invoice mismatches
1
Spend by supplier
  • TechSource$16,020
  • CloudNine$6,000
  • OfficeHub$5,480
  • PrintWorks$5,250
  • PackRight$4,480
  • SafeGuard$680
Committed spend by month
  • Sep$23,400
  • Oct$11,590
  • Nov$2,920

How to use it

  1. 1Add a row when a PO is approved: number, date, supplier, description, budget code, amount and expected delivery.
  2. 2Type the received date when goods arrive, then the invoice number, amount and date paid as they happen.
  3. 3Chase anything flagged Late and query any Invoice mismatch before paying.
  4. 4Use Open commitments on the By supplier sheet for budget forecasting and accruals.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Keep control of spending commitments. Log each PO with supplier, amount, budget code and expected delivery, then fill in the received, invoice and payment details as they happen: the stage updates itself from those dates. The log flags late deliveries and invoices that do not match the PO, totals open commitments not yet invoiced, and roll-ups show spend, on-time delivery and open orders by supplier and by month.

Who it’s for

  • Small procurement and finance teams
  • Operations managers approving spend
  • Month-end accruals and budget tracking

What’s included

  • POs sheet: Purchase orders with delivery, invoice and payment.
  • By supplier sheet: Spend, open commitments and delivery performance by supplier.
  • By month sheet: Spend committed each month, by the month the PO was raised.

How to use it

  1. 1Add a row when a PO is approved: number, date, supplier, description, budget code, amount and expected delivery.
  2. 2Type the received date when goods arrive, then the invoice number, amount and date paid as they happen.
  3. 3Chase anything flagged Late and query any Invoice mismatch before paying.
  4. 4Use Open commitments on the By supplier sheet for budget forecasting and accruals.

Tips

  • Never pay an invoice that does not match the PO and the goods received (the three-way match).
  • Set Cancelled to Yes rather than deleting a PO, so the number sequence stays complete.

Questions

How is the stage decided?

From the dates you fill in: Ordered until goods are received, then Received, Invoiced and Paid. Cancelled overrides everything.

What is an open commitment?

The value of POs that are approved but not yet invoiced: money you have promised to spend.

Related searchespurchase order logprocurementpo trackerpurchasingthree-way matchopen commitments

Details

Format
Spreadsheet
Category
Purchasing & Procurement
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetPurchasing & ProcurementFree

Purchase Order Log

Every purchase order from approval to delivery, invoice and payment, with late-delivery flags, invoice matching, open commitments and spend by supplier.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Purchasing & Procurement
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More purchasing & procurement templates

View all
Vendor Quote Comparison2 sheets

Quotes compared

5

Lowest landed cost

$6,050

Spread, lowest to highest

$640

ABCD
1SupplierTypeQuantityUnit price
2Northfield SupplyExisting supplier500$12.40
3Apex ComponentsNew supplier500$11.60
4Brightline LtdNew supplier500$12.10
5Coastal TradingExisting supplier500$13.20
Quotes
SpreadsheetPurchasing & Procurement

Vendor Quote Comparison

Compare supplier quotes on total landed cost, lead time and terms, with a weighted score.

10 min setupPreview

PURCHASE ORDER

Your Company · Address · Phone · purchasing@company.com

ItemQtyUnit price
PKG-0206$64.00
PKG-0214$21.50
DocumentPurchasing & Procurement

Purchase Order

A formal purchase order with supplier, delivery details, line items and terms.

10 min setupPreview

Request for Quotation

RFQ number: RFQ-0000 Issue date: Date Quotes due: Date and time, time zone

From: Your company, Address Contact: Name, email, phone

1. Introduction

Your company invites you to quote for the supply of the items below. This is a request for quotation only and does not commit us to purchase.

2. Items required

LineDescription and specificatioQuantity
1Item, grade, size, standardQty
2ItemQty

3. Delivery

DocumentPurchasing & Procurement

Request for Quotation (RFQ)

Ask suppliers for comparable prices: specification, quantities, delivery, terms and how quotes are judged.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ