Free purchase order generator Excel
A free purchase order generator Excel file does one job. You type quantity and unit price. Each line total is quantity times price. The order total adds those lines. Pale cells are yours. Green cells are the math. The purchase order generator Excel workbook is purchase-order-template-excel.xlsx.
Free Excel purchase order template
The free Excel purchase order template opens in Excel for Windows, Excel for Mac, and Google Sheets. Upload the same .xlsx to Drive if you want Sheets. You do not need a second file, and the page does not ask for an email.
If your supplier includes tax in the unit price, type the price they quoted. Do not also add a tax the sample does not have.
Free purchase order template versus an invoice
Use this free purchase order template before the goods arrive. Use the free invoice template after you have done work for a client. Stock you are waiting on belongs next to the free Excel inventory template, not on the customer bill.
- Open the free purchase order template and download the workbook.
- Replace BrightPaper Supply with your supplier.
- Type quantity and unit price only.
- Read the order total. Do not type it.
- Sending the purchase order to a customer as if it were an invoice.
- Typing the order total over the green cell.
- Adding a row under the total and expecting the SUM to see it.
Get the purchase order format Excel free download from the free purchase order template page. More guides are on the blog.