Purchase Order Template Excel
A purchase order you can send in a minute and a log that shows what is on order: pick the vendor from your list, fill the lines, and the subtotal, tax and total calculate; save as PDF and send. The PO log tracks status, open commitments and late deliveries.
Checkout opens on Stripe. The download page appears the moment payment goes through, and your receipt email carries the link. Digital files only; nothing is shipped.
- Excel Purchase-Order-Workbook-US.xlsx
- Excel Purchase-Order-Workbook-Metric-CA.xlsx
- PDF Purchase-Order-Quick-Start.pdf
Also sold on Etsy; buying here costs less and the files are the same.
A purchase order you can send in a minute and a log that shows what is on order: pick the vendor from your list, fill the lines, and the subtotal, tax and total calculate; save as PDF and send. The PO log tracks status, open commitments and late deliveries.
WHAT YOU GET
- Purchase Order Workbook, US file (US$) and Canadian file (CA$, 13% tax rate set): Settings, Vendors, Purchase order with vendor lookup and calculated totals, PO log with open commitments, received this year and late count, Start-here sheet
- Quick-start PDF
46 formulas across the two workbooks, recalculated and checked for errors before listing.
HOW TO USE
1. Buy, then download on the page that opens right after payment (your Stripe receipt email carries the same link).
2. Open the workbooks in Excel 2016 or later, Google Sheets or LibreOffice; the quick-start PDF opens in any PDF app.
3. Yellow cells are inputs, grey cells calculate. Replace the example rows with your own.
PLEASE NOTE
- Digital download only; nothing is shipped. Returns are not possible on digital files; if a file will not open, email [email protected] and it gets fixed.
- Works in Excel 2016 or later, Google Sheets and LibreOffice; drop-downs included. Change the tax rate and terms once in Settings.
- Templates are not legal, tax or insurance advice. Have agreements reviewed by your own counsel and follow your own operating rules.
- For use in one business. Not for resale or redistribution.
Designed by A3E Studio (Ontario, Canada) and generated by our own software; every formula is recalculated and checked before listing.
