{"id":14766,"date":"2026-11-14T16:00:00","date_gmt":"2026-11-14T16:00:00","guid":{"rendered":"https:\/\/cashflowinventory.com\/blog\/?p=14766"},"modified":"2026-11-13T07:42:20","modified_gmt":"2026-11-13T07:42:20","slug":"purchase-order-template-excel","status":"publish","type":"post","link":"https:\/\/cashflowinventory.com\/blog\/purchase-order-template-excel\/","title":{"rendered":"Purchase Order Template (Excel) With Automatic Totals, Tax and Terms"},"content":{"rendered":"<p>A purchase order template in Excel is a sheet where you list each item, quantity and unit price, and formulas work out the line discount, the net amount, the tax, the freight and the order total for you. You send it to the supplier as your written commitment to buy. Later you check the delivery and the supplier&#8217;s bill against it before you pay.<\/p>\n<p>On this page you get a free downloadable file with three sheets: the PO lines, the PO totals and a receive-and-bill match. Every formula is explained, so you can also build the file yourself. You also get a fully worked example with numbers that add up, and a checklist of what every purchase order must say. After that come the mistakes and edge cases that cause most supplier disputes, and how the same process runs in Cash Flow Inventory once a spreadsheet stops being enough.<\/p>\n<div class=\"download-section\">\n<p class=\"download-title\"><strong>Free download: Purchase order template with automatic totals<\/strong><\/p>\n<p>An Excel file (.xlsx, 13 KB) with the formulas already in place and the example from this guide filled in. It opens in Excel, Google Sheets (File \u203a Import), Numbers and LibreOffice. No sign-up needed.<\/p>\n<p><a class=\"btn btn-gold\" href=\"https:\/\/cashflowinventory.com\/blog\/wp-content\/uploads\/cfi-guides\/purchase-order-template-excel\/purchase-order-template-with-automatic-totals.xlsx\" download>Download the spreadsheet<\/a><\/p>\n<\/div>\n<div class=\"takeaways-section\">\n<h2>Key takeaways<\/h2>\n<ul>\n<li>Every computed cell should be a formula: net = quantity \u00d7 unit price \u00d7 (1 \u2212 discount), tax = net \u00d7 rate, total = net + tax. Never type a total by hand.<\/li>\n<li>Put the tax rate on each line, not once at the bottom, so mixed rates and freight tax come out right.<\/li>\n<li>A PO is only useful if it states the terms: delivery date, delivery terms, payment terms, units of measure, and the instruction that the invoice must quote the PO number.<\/li>\n<li>Do not pay a bill until it matches the order and what actually arrived. Quantity and price differences are where money leaks.<\/li>\n<li>When orders, partial deliveries and bills start to overlap, move to a system that makes the bill from the receipt, so the three can never drift apart.<\/li>\n<\/ul>\n<\/div>\n<h2>What a purchase order template in Excel should calculate<\/h2>\n<p>A purchase order does two jobs. It tells the supplier exactly what you want and on what terms. It also gives you a fixed reference to check the delivery and the bill against. A good template does the arithmetic so the second job is easy.<\/p>\n<div class=\"sheet-spec\" id=\"ss-purchase-order-template-excel-1\" data-sheet-spec>\n<div class=\"sheet-spec__sheets\">\n<div class=\"sheet-spec__sheet\" id=\"ss-purchase-order-template-excel-1-s1\" data-sheet-name=\"PO lines\">\n<p role=\"heading\" aria-level=\"3\" class=\"sheet-spec__name\" id=\"ss-purchase-order-template-excel-1-s1-h\"><span class=\"sheet-spec__icon\" aria-hidden=\"true\"><\/span>PO lines <span class=\"sheet-spec__kind\">sheet<\/span><\/p>\n<p class=\"sheet-spec__lead\">The file has a sheet called <strong>PO lines<\/strong> with these columns. You type the first seven and the tax rate. The rest are formulas.<\/p>\n<div class=\"sheet-spec__scroll\" tabindex=\"0\" role=\"region\" aria-label=\"PO lines sheet: columns and formulas (What a purchase order template in Excel should calculate)\">\n<table class=\"sheet-spec__table\" role=\"table\">\n<caption class=\"screen-reader-text\">Columns of the PO lines sheet: header, what it holds, the example in row 2 and the formula<\/caption>\n<thead role=\"rowgroup\">\n<tr role=\"row\">\n<th scope=\"col\" role=\"columnheader\" class=\"sheet-spec__c-col\">Col<\/th>\n<th scope=\"col\" role=\"columnheader\">Header<\/th>\n<th scope=\"col\" role=\"columnheader\">What it holds<\/th>\n<th scope=\"col\" role=\"columnheader\" class=\"sheet-spec__c-ex\">Example <span class=\"sheet-spec__row\">row 2<\/span><\/th>\n<th scope=\"col\" role=\"columnheader\">Formula <span class=\"sheet-spec__row\">row 2<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody role=\"rowgroup\">\n<tr role=\"row\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>A<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Line<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> <span class=\"sheet-spec__dim\">You type it<\/span><\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> 1<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell is-empty\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__dim\" aria-label=\"no formula\">\u2014<\/span><\/td>\n<\/tr>\n<tr role=\"row\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>B<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Item code<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> <span class=\"sheet-spec__dim\">You type it<\/span><\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> KW-101<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell is-empty\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__dim\" aria-label=\"no formula\">\u2014<\/span><\/td>\n<\/tr>\n<tr role=\"row\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>C<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Description<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> <span class=\"sheet-spec__dim\">You type it<\/span><\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> Stainless saucepan 20 cm<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell is-empty\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__dim\" aria-label=\"no formula\">\u2014<\/span><\/td>\n<\/tr>\n<tr role=\"row\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>D<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Unit<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> <span class=\"sheet-spec__dim\">You type it<\/span><\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> each<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell is-empty\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__dim\" aria-label=\"no formula\">\u2014<\/span><\/td>\n<\/tr>\n<tr role=\"row\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>E<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Qty<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> <span class=\"sheet-spec__dim\">You type it<\/span><\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> 24<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell is-empty\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__dim\" aria-label=\"no formula\">\u2014<\/span><\/td>\n<\/tr>\n<tr role=\"row\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>F<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Unit price<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> <span class=\"sheet-spec__dim\">You type it<\/span><\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> 18.50<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell is-empty\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__dim\" aria-label=\"no formula\">\u2014<\/span><\/td>\n<\/tr>\n<tr role=\"row\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>G<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Discount %<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> <span class=\"sheet-spec__dim\">You type it<\/span><\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> 0.0%<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell is-empty\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__dim\" aria-label=\"no formula\">\u2014<\/span><\/td>\n<\/tr>\n<tr role=\"row\" class=\"is-calc\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>H<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Net amount<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> <code>Net amount = ROUND(Qty \u00d7 Unit price \u00d7 (1 \u2212 Discount %), 2)<\/code><\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> 444<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__fx\"><code class=\"sheet-spec__f\" data-cell=\"H2\">=ROUND(E2*F2*(1-G2),2)<\/code><\/span> <\/td>\n<\/tr>\n<tr role=\"row\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>I<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Tax rate<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> <span class=\"sheet-spec__dim\">You type it<\/span><\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> 15.0%<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell is-empty\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__dim\" aria-label=\"no formula\">\u2014<\/span><\/td>\n<\/tr>\n<tr role=\"row\" class=\"is-calc\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>J<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Tax amount<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> <code>Tax amount = ROUND(Net amount \u00d7 Tax rate, 2)<\/code><\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> 66.60<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__fx\"><code class=\"sheet-spec__f\" data-cell=\"J2\">=ROUND(H2*I2,2)<\/code><\/span> <\/td>\n<\/tr>\n<tr role=\"row\" class=\"is-calc\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>K<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Line total<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> <code>Line total = Net amount + Tax amount<\/code><\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> 510.60<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__fx\"><code class=\"sheet-spec__f\" data-cell=\"K2\">=H2+J2<\/code><\/span> <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"sheet-spec__notes\">\n<p>In Excel, row 2 reads the formulas above in column H, column J and column K. Copy the row down for every new line.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"sheet-spec__foot\">\n<p class=\"sheet-spec__fill\"><strong>Filling down:<\/strong> each formula is shown for the first row of data. Copy it down the column and the spreadsheet moves the row numbers for you (B2 becomes B3, B4 \u2026); references with $ signs stay fixed.<\/p>\n<\/div>\n<div class=\"sheet-spec__outro\">\n<p>The <strong>PO totals<\/strong> sheet pulls everything together:<\/p>\n<p class=\"formula-line\"><code>Goods before discounts = SUMPRODUCT(Qty, Unit price)<\/code><\/p>\n<p class=\"formula-line\"><code>Line discounts = Goods before discounts \u2212 Net goods<\/code><\/p>\n<p class=\"formula-line\"><code>PO total = Net goods + Freight + Tax on goods + Tax on freight<\/code><\/p>\n<p class=\"formula-line\"><code>Balance to bill = PO total \u2212 Advance paid<\/code><\/p>\n<p>Freight sits on the totals sheet as a separate cost line with its own tax rate. Freight is often taxed differently from the goods, and it may arrive on a different bill.<\/p>\n<\/div>\n<p class=\"sheet-spec__dl\"><a class=\"btn btn-gold\" href=\"https:\/\/cashflowinventory.com\/blog\/wp-content\/uploads\/cfi-guides\/purchase-order-template-excel\/purchase-order-template-with-automatic-totals.xlsx\" download>Download the spreadsheet<\/a><span class=\"sheet-spec__dlmeta\">.xlsx, 13 KB \u00b7 formulas and the worked example filled in \u00b7 Excel, Google Sheets, Numbers, LibreOffice<\/span><\/p>\n<\/div>\n<h2>Worked example: a purchase order with discounts, mixed tax and freight<\/h2>\n<div class=\"example-section\">\n<p><strong>Example: a shop selling kitchenware online and in store<\/strong> orders from a cookware wholesaler. This is a hypothetical business. Amounts are in any currency, and the tax rates (15% standard, 5% reduced on books) are illustrative only, so use your own. The supplier gives 5% off frying pans and 10% off chopping boards.<\/p>\n<div class=\"table-responsive\" tabindex=\"0\" role=\"region\" aria-label=\"Table: Line (scrolls sideways)\">\n<table>\n<thead>\n<tr>\n<th>Line<\/th>\n<th>Item<\/th>\n<th>Qty<\/th>\n<th>Unit price<\/th>\n<th>Disc.<\/th>\n<th>Net<\/th>\n<th>Tax rate<\/th>\n<th>Tax<\/th>\n<th>Line total<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>1<\/td>\n<td>KW-101 Stainless saucepan 20 cm<\/td>\n<td>24<\/td>\n<td>18.50<\/td>\n<td>0%<\/td>\n<td>444.00<\/td>\n<td>15%<\/td>\n<td>66.60<\/td>\n<td>510.60<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>KW-102 Non-stick frying pan 28 cm<\/td>\n<td>36<\/td>\n<td>22.00<\/td>\n<td>5%<\/td>\n<td>752.40<\/td>\n<td>15%<\/td>\n<td>112.86<\/td>\n<td>865.26<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>KW-205 Chef&#8217;s knife 20 cm<\/td>\n<td>20<\/td>\n<td>31.75<\/td>\n<td>0%<\/td>\n<td>635.00<\/td>\n<td>15%<\/td>\n<td>95.25<\/td>\n<td>730.25<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>KW-310 Bamboo chopping board<\/td>\n<td>50<\/td>\n<td>7.40<\/td>\n<td>10%<\/td>\n<td>333.00<\/td>\n<td>15%<\/td>\n<td>49.95<\/td>\n<td>382.95<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>KW-412 Silicone spatula set<\/td>\n<td>60<\/td>\n<td>5.25<\/td>\n<td>0%<\/td>\n<td>315.00<\/td>\n<td>15%<\/td>\n<td>47.25<\/td>\n<td>362.25<\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>KW-520 Recipe book<\/td>\n<td>15<\/td>\n<td>12.00<\/td>\n<td>0%<\/td>\n<td>180.00<\/td>\n<td>5%<\/td>\n<td>9.00<\/td>\n<td>189.00<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><strong>Lines total<\/strong><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><strong>2,659.40<\/strong><\/td>\n<td><\/td>\n<td><strong>380.91<\/strong><\/td>\n<td><strong>3,040.31<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>The totals sheet then adds freight and the advance:<\/p>\n<div class=\"table-responsive\" tabindex=\"0\" role=\"region\" aria-label=\"Table: Item (scrolls sideways)\">\n<table>\n<thead>\n<tr>\n<th>Item<\/th>\n<th>Amount<\/th>\n<th>How it is worked out<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Goods before discounts<\/td>\n<td>2,736.00<\/td>\n<td>Sum of qty \u00d7 unit price<\/td>\n<\/tr>\n<tr>\n<td>Line discounts<\/td>\n<td>76.60<\/td>\n<td>2,736.00 \u2212 2,659.40 (39.60 on pans, 37.00 on boards)<\/td>\n<\/tr>\n<tr>\n<td>Net goods<\/td>\n<td>2,659.40<\/td>\n<td>Sum of net amounts<\/td>\n<\/tr>\n<tr>\n<td>Freight<\/td>\n<td>120.00<\/td>\n<td>Quoted by supplier<\/td>\n<\/tr>\n<tr>\n<td>Tax on freight (15%)<\/td>\n<td>18.00<\/td>\n<td>120.00 \u00d7 0.15<\/td>\n<\/tr>\n<tr>\n<td>Tax on goods<\/td>\n<td>380.91<\/td>\n<td>Sum of line tax<\/td>\n<\/tr>\n<tr>\n<td>Total tax<\/td>\n<td>398.91<\/td>\n<td>380.91 + 18.00<\/td>\n<\/tr>\n<tr>\n<td><strong>PO total<\/strong><\/td>\n<td><strong>3,178.31<\/strong><\/td>\n<td>2,659.40 + 120.00 + 398.91<\/td>\n<\/tr>\n<tr>\n<td>Advance paid with order<\/td>\n<td>1,000.00<\/td>\n<td>Deposit agreed with supplier<\/td>\n<\/tr>\n<tr>\n<td>Balance to bill<\/td>\n<td>2,178.31<\/td>\n<td>3,178.31 \u2212 1,000.00, if everything arrives as ordered<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>A quick check: the lines total of 3,040.31 plus freight with its tax of 138.00 also gives 3,178.31. If those two routes ever disagree in your sheet, a formula has been overwritten.<\/p>\n<\/div>\n<h2>What every purchase order must say: a copy-ready checklist<\/h2>\n<p>The numbers are the easy part. Most supplier disputes come from what the PO did not say. Check each order against this list before you send it.<\/p>\n<div class=\"checklist-section\">\n<ul>\n<li><strong>PO number and date<\/strong>, unique and never reused. Add a revision number (PO-1042 rev 2) if you change it after sending.<\/li>\n<li><strong>Your legal name, billing address and tax registration number<\/strong>, plus the <strong>delivery address<\/strong> if it is different.<\/li>\n<li><strong>Supplier&#8217;s legal name, address and tax number<\/strong>, as they appear on their invoices.<\/li>\n<li><strong>For each line<\/strong>: your item code, the supplier&#8217;s code, a description, the unit of measure (each, case of 6, kg), quantity, unit price, discount and tax rate.<\/li>\n<li><strong>Currency<\/strong>, and whether prices include or exclude tax.<\/li>\n<li><strong>Required delivery date<\/strong>, and whether partial deliveries are accepted.<\/li>\n<li><strong>Delivery terms<\/strong>: who pays freight and who carries the risk in transit. For cross-border orders, name an <a href=\"https:\/\/iccwbo.org\/business-solutions\/incoterms-rules\/\" target=\"_blank\" rel=\"noopener\">Incoterms rule from the International Chamber of Commerce<\/a> and a named place.<\/li>\n<li><strong>Payment terms<\/strong> (for example 30 days from invoice), and any advance or deposit.<\/li>\n<li><strong>Invoice instruction<\/strong>: &#8220;Quote this PO number on every invoice and delivery note.&#8221;<\/li>\n<li><strong>Quality and returns<\/strong>: what happens to damaged, short or substituted goods.<\/li>\n<li><strong>Approval<\/strong>: who approved it and up to what amount.<\/li>\n<\/ul>\n<\/div>\n<p>If your orders begin as internal requests from staff, record those first as a <a href=\"https:\/\/cashflowinventory.com\/blog\/purchase-requisition\/\">purchase requisition<\/a>, then raise the PO from the approved request. Check supplier minimums before you finalise quantities. Our guide to <a href=\"https:\/\/cashflowinventory.com\/blog\/minimum-order-quantity\/\">minimum order quantity<\/a> covers how to handle MOQs that exceed what you need.<\/p>\n<h2>How to fill in and send the purchase order template, step by step<\/h2>\n<ol>\n<li>Save a copy of the file under the PO number, for example <em>PO-1042 Cookware Wholesale.xlsx<\/em>. Never overwrite a PO you have already sent.<\/li>\n<li>On <strong>PO lines<\/strong>, delete the example rows except row 2. Enter your first line, then copy row 2 down for each further line so the formulas follow.<\/li>\n<li>Enter quantities in the supplier&#8217;s selling unit. If they sell cases of 6 and you count singles, order in cases and note the conversion in the description.<\/li>\n<li>Enter each line&#8217;s tax rate as a decimal formatted as a percentage (0.15 shows as 15%).<\/li>\n<li>On <strong>PO totals<\/strong>, enter freight, its tax rate and any advance. Make sure the SUM ranges cover all your lines if you added more than six.<\/li>\n<li>Check that the lines total plus freight and freight tax equals the PO total.<\/li>\n<li>Have the order approved if it is above your limit, then export it to PDF and send it. Send the PDF, not the editable file.<\/li>\n<li>File the sent PDF where the person checking bills can find it.<\/li>\n<\/ol>\n<p>Quantities should come from your stock position, not a guess. If you track stock in a sheet, our <a href=\"https:\/\/cashflowinventory.com\/blog\/inventory-spreadsheet-template\/\">inventory spreadsheet template with reorder alerts<\/a> tells you what to order. The <a href=\"https:\/\/cashflowinventory.com\/tools\/reorder-point-calculator.php\">reorder point calculator<\/a> tells you when to order.<\/p>\n<h2>The receive-and-bill match: checking delivery and invoice against the PO<\/h2>\n<p>The PO only protects you if you compare it with what arrived and what you were billed. This is often called a three-way match: order, goods receipt, bill. The third sheet in the file, <strong>Receive and bill match<\/strong>, does it line by line.<\/p>\n<div class=\"sheet-spec\" id=\"ss-purchase-order-template-excel-2\" data-sheet-spec>\n<div class=\"sheet-spec__sheets\">\n<div class=\"sheet-spec__sheet\" id=\"ss-purchase-order-template-excel-2-s1\" data-sheet-name=\"Receive and bill match\">\n<p role=\"heading\" aria-level=\"3\" class=\"sheet-spec__name\" id=\"ss-purchase-order-template-excel-2-s1-h\"><span class=\"sheet-spec__icon\" aria-hidden=\"true\"><\/span>Receive and bill match <span class=\"sheet-spec__kind\">sheet<\/span><\/p>\n<p class=\"sheet-spec__lead\"> Its first columns pull from the PO lines sheet. You type in three things. Formulas then show the rest.<\/p>\n<div class=\"sheet-spec__scroll\" tabindex=\"0\" role=\"region\" aria-label=\"Receive and bill match sheet: columns and formulas (The receive-and-bill match: checking delivery and invoice against the PO)\">\n<table class=\"sheet-spec__table\" role=\"table\">\n<caption class=\"screen-reader-text\">Columns of the Receive and bill match sheet: header, what it holds, the example in row 2 and the formula<\/caption>\n<thead role=\"rowgroup\">\n<tr role=\"row\">\n<th scope=\"col\" role=\"columnheader\" class=\"sheet-spec__c-col\">Col<\/th>\n<th scope=\"col\" role=\"columnheader\">Header<\/th>\n<th scope=\"col\" role=\"columnheader\">What it holds<\/th>\n<th scope=\"col\" role=\"columnheader\" class=\"sheet-spec__c-ex\">Example <span class=\"sheet-spec__row\">row 2<\/span><\/th>\n<th scope=\"col\" role=\"columnheader\">Formula <span class=\"sheet-spec__row\">row 2<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody role=\"rowgroup\">\n<tr role=\"row\" class=\"is-calc\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>B\u2013E<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Item code, quantity ordered, PO unit price and discount<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> Pull from the PO lines sheet<\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> <span class=\"sheet-spec__cell\">B<\/span> KW-101<br \/><span class=\"sheet-spec__cell\">C<\/span> 24<br \/><span class=\"sheet-spec__cell\">D<\/span> 18.50<br \/><span class=\"sheet-spec__cell\">E<\/span> 0.0%<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__fx\"><span class=\"sheet-spec__cell\">B2<\/span> <code class=\"sheet-spec__f\" data-cell=\"B2\">='PO lines'!B2<\/code><\/span> <span class=\"sheet-spec__fx\"><span class=\"sheet-spec__cell\">C2<\/span> <code class=\"sheet-spec__f\" data-cell=\"C2\">='PO lines'!E2<\/code><\/span> <span class=\"sheet-spec__fx\"><span class=\"sheet-spec__cell\">D2<\/span> <code class=\"sheet-spec__f\" data-cell=\"D2\">='PO lines'!F2<\/code><\/span> <span class=\"sheet-spec__fx\"><span class=\"sheet-spec__cell\">E2<\/span> <code class=\"sheet-spec__f\" data-cell=\"E2\">='PO lines'!G2<\/code><\/span> <\/td>\n<\/tr>\n<tr role=\"row\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>F<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Qty received<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> The quantity received (from the delivery count)<\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> 24<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell is-empty\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__dim\" aria-label=\"no formula\">\u2014<\/span><\/td>\n<\/tr>\n<tr role=\"row\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>G<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Qty billed<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> The quantity on the supplier&#8217;s bill<\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> 24<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell is-empty\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__dim\" aria-label=\"no formula\">\u2014<\/span><\/td>\n<\/tr>\n<tr role=\"row\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>H<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Billed unit price<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> Unit price on the supplier&#8217;s bill<\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> 18.50<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell is-empty\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__dim\" aria-label=\"no formula\">\u2014<\/span><\/td>\n<\/tr>\n<tr role=\"row\" class=\"is-calc\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>I<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Received vs ordered<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> <code>Received vs ordered = Qty received \u2212 Qty ordered<\/code><\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> 0<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__fx\"><code class=\"sheet-spec__f\" data-cell=\"I2\">=F2-C2<\/code><\/span> <\/td>\n<\/tr>\n<tr role=\"row\" class=\"is-calc\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>J<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Billed vs received<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> <code>Billed vs received = Qty billed \u2212 Qty received<\/code><\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> 0<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__fx\"><code class=\"sheet-spec__f\" data-cell=\"J2\">=G2-F2<\/code><\/span> <\/td>\n<\/tr>\n<tr role=\"row\" class=\"is-calc\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>K<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Price difference<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> <code>Price difference = Billed unit price \u2212 PO unit price<\/code><\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> 0<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__fx\"><code class=\"sheet-spec__f\" data-cell=\"K2\">=H2-D2<\/code><\/span> <\/td>\n<\/tr>\n<tr role=\"row\" class=\"is-calc\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>L<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Value at issue<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> <code>Value at issue = ROUND((Qty billed \u00d7 Billed price \u2212 Qty received \u00d7 PO price) \u00d7 (1 \u2212 Discount %), 2)<\/code><\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> 0<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__fx\"><code class=\"sheet-spec__f\" data-cell=\"L2\">=ROUND((G2*H2-F2*D2)*(1-E2),2)<\/code><\/span> <\/td>\n<\/tr>\n<tr role=\"row\" class=\"is-calc\">\n<th scope=\"row\" role=\"rowheader\" class=\"sheet-spec__col\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Column <\/span>M<\/th>\n<td role=\"cell\" class=\"sheet-spec__h\">Status<\/td>\n<td role=\"cell\" class=\"sheet-spec__w\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">What it holds<\/span> A status column reads &#8220;Match&#8221;, &#8220;Check quantity&#8221;, &#8220;Check price&#8221; or &#8220;Check qty and price&#8221;.<\/td>\n<td role=\"cell\" class=\"sheet-spec__x\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Example, row 2<\/span> Match<\/td>\n<td role=\"cell\" class=\"sheet-spec__fcell\"><span class=\"sheet-spec__lbl\" aria-hidden=\"true\">Formula<\/span> <span class=\"sheet-spec__fx\"><code class=\"sheet-spec__f\" data-cell=\"M2\">=IF(AND(G2=F2,H2=D2),\"Match\",IF(AND(G2&lt;&gt;F2,H2&lt;&gt;D2),\"Check qty and price\",IF(G2&lt;&gt;F2,\"Check quantity\",\"Check price\")))<\/code><\/span> <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"sheet-spec__foot\">\n<p class=\"sheet-spec__fill\"><strong>Filling down:<\/strong> each formula is shown for the first row of data. Copy it down the column and the spreadsheet moves the row numbers for you (B2 becomes B3, B4 \u2026); references with $ signs stay fixed.<\/p>\n<p class=\"sheet-spec__links\"><strong>How the sheets link:<\/strong> <strong>Receive and bill match<\/strong> column B (Item code) reads <strong>PO lines<\/strong> (another sheet in the file). <strong>Receive and bill match<\/strong> column C (Qty ordered) reads <strong>PO lines<\/strong> (another sheet in the file). <strong>Receive and bill match<\/strong> column D (PO unit price) reads <strong>PO lines<\/strong> (another sheet in the file). <strong>Receive and bill match<\/strong> column E (Discount %) reads <strong>PO lines<\/strong> (another sheet in the file).<\/p>\n<\/div>\n<\/div>\n<div class=\"example-section\">\n<p><strong>Continuing the kitchenware example.<\/strong> The delivery arrives with 30 frying pans instead of 36. The supplier&#8217;s bill charges for all 36, and it charges 32.50 per chef&#8217;s knife instead of the agreed 31.75. Everything else matches.<\/p>\n<div class=\"table-responsive\" tabindex=\"0\" role=\"region\" aria-label=\"Table: Item (scrolls sideways)\">\n<table>\n<thead>\n<tr>\n<th>Item<\/th>\n<th>Ordered<\/th>\n<th>Received<\/th>\n<th>Billed<\/th>\n<th>PO price<\/th>\n<th>Billed price<\/th>\n<th>Value at issue<\/th>\n<th>Status<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>KW-102 Frying pan<\/td>\n<td>36<\/td>\n<td>30<\/td>\n<td>36<\/td>\n<td>22.00<\/td>\n<td>22.00<\/td>\n<td>125.40<\/td>\n<td>Check quantity<\/td>\n<\/tr>\n<tr>\n<td>KW-205 Chef&#8217;s knife<\/td>\n<td>20<\/td>\n<td>20<\/td>\n<td>20<\/td>\n<td>31.75<\/td>\n<td>32.50<\/td>\n<td>15.00<\/td>\n<td>Check price<\/td>\n<\/tr>\n<tr>\n<td>Other four lines<\/td>\n<td>149<\/td>\n<td>149<\/td>\n<td>149<\/td>\n<td>\u2014<\/td>\n<td>\u2014<\/td>\n<td>0.00<\/td>\n<td>Match<\/td>\n<\/tr>\n<tr>\n<td colspan=\"6\"><strong>Total before tax<\/strong><\/td>\n<td><strong>140.40<\/strong><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>The pan figure is 6 \u00d7 22.00 \u00d7 0.95 = 125.40. The knife figure is 20 \u00d7 0.75 = 15.00. With 15% tax on both, the overcharge is 140.40 + 21.06 = 161.46. Without the match, that money goes out with the next payment run.<\/p>\n<\/div>\n<h3>Decision rules for mismatches<\/h3>\n<ul>\n<li><strong>Billed more than received:<\/strong> do not pay the extra. Ask for a credit note or a corrected invoice, or pay only for what arrived if your terms allow it.<\/li>\n<li><strong>Received less than ordered:<\/strong> decide whether the rest is still coming. If it is not, close the line short in writing so nobody expects it later.<\/li>\n<li><strong>Price differs from the PO:<\/strong> the PO price stands unless you agreed a change. Small differences may come from rounding. Set a tolerance in advance, for example a few units of currency per bill, so staff are not chasing pennies.<\/li>\n<li><strong>Received more than ordered:<\/strong> accept it only if someone with buying authority agrees. Otherwise return the extra or hold it unpaid.<\/li>\n<\/ul>\n<div class=\"tip-section\">\n<p><strong>Tip from practice:<\/strong> count the delivery before you open the invoice. If the person receiving goods sees the billed quantities first, they tend to confirm them instead of counting. A blind count, against the PO and not the bill, catches far more short deliveries.<\/p>\n<\/div>\n<h2>Common purchase order mistakes in Excel<\/h2>\n<ul>\n<li><strong>Typing over a formula.<\/strong> Someone types a &#8220;corrected&#8221; total into column K, and the sheet stops adding up. Lock formula cells with sheet protection once the layout is final.<\/li>\n<li><strong>SUM ranges that miss new rows.<\/strong> Add line 7 below a SUM that stops at row 7 and it is silently left out. Insert new rows inside the range, or widen the ranges on the totals sheet.<\/li>\n<li><strong>One tax rate for the whole order.<\/strong> This breaks as soon as one item or the freight is taxed differently.<\/li>\n<li><strong>Editing a sent PO without a revision number.<\/strong> The supplier ships version 1 and bills version 2, and nobody can prove which was agreed.<\/li>\n<li><strong>Ambiguous units.<\/strong> &#8220;10 knives&#8221; when the supplier sells in boxes of 6 leads to 60 knives and a bill to match.<\/li>\n<li><strong>Paying from the invoice alone.<\/strong> The PO and the delivery count are the evidence. The invoice is only the claim.<\/li>\n<li><strong>Rounding drift.<\/strong> Rounding tax on each line, then rounding the total differently, leaves a few cents&#8217; difference against the supplier&#8217;s bill. Follow your tax authority&#8217;s rules on invoice rounding. In the UK, for example, HMRC&#8217;s guidance on <a href=\"https:\/\/www.gov.uk\/vat-record-keeping\" target=\"_blank\" rel=\"noopener\">VAT record keeping<\/a> covers what invoices and records must show.<\/li>\n<\/ul>\n<h2>Edge cases the basic template does not cover<\/h2>\n<h3>Prices that include tax<\/h3>\n<p>Some suppliers quote tax-inclusive prices. Convert them before entering: net unit price = inclusive price \u00f7 (1 + tax rate). Otherwise you will tax the tax.<\/p>\n<h3>An order-level discount<\/h3>\n<p>If the supplier gives 3% off the whole order rather than off lines, apply it before tax. Spread it across lines in proportion to their net value, so each item&#8217;s cost and tax stay right. Putting it as one negative line at the bottom understates your stock cost per item.<\/p>\n<h3>Imports, duty and freight from a different company<\/h3>\n<p>For imports, duty and import tax are usually paid to customs or through a broker, and freight is often billed by a forwarder. These belong in the true cost of the goods but not on the supplier&#8217;s PO. Track them as separate cost lines and allocate them to items, typically by value or weight.<\/p>\n<h3>Foreign currency<\/h3>\n<p>Write the PO in the supplier&#8217;s currency and note the rate you used for budgeting. The bill will be booked at the rate on its date, so expect a difference.<\/p>\n<h3>Partial deliveries and substitutions<\/h3>\n<p>A second delivery against the same PO needs its own receipt line. The match sheet then compares the cumulative received quantity with the ordered quantity. A substituted item, such as a 26 cm pan instead of 28 cm, is a new line at an agreed price, not a silent swap.<\/p>\n<h3>Blanket orders and price breaks<\/h3>\n<p>If you agree annual quantities at fixed prices and call off deliveries, each call-off is its own PO. Track what is left on the agreement in a separate sheet, or the spreadsheet will let you order past it.<\/p>\n<h2>How to do this in Cash Flow Inventory<\/h2>\n<p>A spreadsheet works for a handful of orders a month. Once deliveries arrive in parts, bills cover several receipts and more than one person approves spending, a system that links order, receipt and bill avoids the gaps. The full procedure is in the <a href=\"https:\/\/cashflowinventory.com\/documentation\/guides\/purchase-orders\/\">purchase orders guide<\/a>. In short:<\/p>\n<ol>\n<li>In <strong>Settings \u203a Purchase<\/strong>, set <strong>Purchase process<\/strong> to <strong>Order \u2192 receive \u2192 bill \u2192 payment<\/strong>. Choose a <strong>Purchase order approval<\/strong> rule: approve each order by hand, approve automatically, or approve automatically up to an amount. Under <strong>What purchase documents carry<\/strong>, switch on Cost lines (freight, duty and other charges), Landed cost and Advance payments if you use them.<\/li>\n<li>Open <strong>Purchasing \u203a Purchase orders<\/strong>, choose <strong>New order<\/strong>, and pick the supplier and the location the goods go to.<\/li>\n<li>Add items and quantities. If you keep supplier prices in <strong>Purchasing \u203a Agreements &amp; prices<\/strong>, lines are priced for you, using the highest quantity break at or under the line&#8217;s quantity.<\/li>\n<li>Add cost lines such as freight or duty, and an advance if you pay part before the bill. Save.<\/li>\n<li>The order waits for approval unless your rule approves it. Approvers can act from the <a href=\"https:\/\/cashflowinventory.com\/documentation\/guides\/approvals-centre\/\">approvals centre<\/a>.<\/li>\n<li>Use <strong>Send to supplier\u2026<\/strong> in the row menu to e-mail it, or print or download the PDF.<\/li>\n<li>When goods arrive, choose <strong>Receive goods<\/strong> in the row menu and enter what actually came on each line. Leave a line at zero if nothing came. See <a href=\"https:\/\/cashflowinventory.com\/documentation\/guides\/receiving\/\">receiving goods<\/a> for lots, expiry dates and serials.<\/li>\n<li>Saving the receipt adds the stock and makes the supplier&#8217;s bill as a draft for what was received, plus a draft cost bill for each other cost on the order. Each line comes into stock at its landed unit cost, which takes in its share of the order discount and of the order&#8217;s other costs.<\/li>\n<li>Open <strong>Purchasing \u203a Bills<\/strong> and check the draft against the supplier&#8217;s invoice before approving. If the supplier&#8217;s price is wrong, use <strong>Hold payment\u2026<\/strong> while you resolve it. If your recorded price needs fixing, use <strong>Correct prices\u2026<\/strong> on the bill. The <a href=\"https:\/\/cashflowinventory.com\/documentation\/guides\/bills-ap\/\">bills and accounts payable guide<\/a> covers both.<\/li>\n<li>If the rest of a short delivery is not coming, use <strong>Close order<\/strong> and choose the reason, such as <strong>Supplier delivered short<\/strong>.<\/li>\n<\/ol>\n<p>In the kitchenware example, receiving 30 pans would make a draft bill for 30. The supplier&#8217;s invoice for 36 shows up as a difference before anything is owed. That is the receive-and-bill match done by the system rather than by a formula.<\/p>\n<div class=\"download-section\">\n<p class=\"download-title\"><strong>Free download: Purchase order template with automatic totals<\/strong><\/p>\n<p>An Excel file (.xlsx, 13 KB) with the formulas already in place and the example from this guide filled in. It opens in Excel, Google Sheets (File \u203a Import), Numbers and LibreOffice. No sign-up needed.<\/p>\n<p><a class=\"btn btn-gold\" href=\"https:\/\/cashflowinventory.com\/blog\/wp-content\/uploads\/cfi-guides\/purchase-order-template-excel\/purchase-order-template-with-automatic-totals.xlsx\" download>Download the spreadsheet<\/a><\/p>\n<\/div>\n<h2>Frequently asked questions<\/h2>\n<h3>How do I make a purchase order in Excel that calculates automatically?<\/h3>\n<p>Give each line a net amount formula, <code>=ROUND(Qty*Price*(1-Discount),2)<\/code>, then a tax formula and a line total. Sum the lines on a totals section and add freight with its own tax. The downloadable file above already has these formulas, ready to copy down.<\/p>\n<h3>What should a purchase order include?<\/h3>\n<p>At minimum: a unique PO number and date, both parties&#8217; legal names and tax numbers, the delivery address, and each item&#8217;s code, unit, quantity, price, discount and tax rate. Add the currency, the delivery date, the delivery and payment terms, and an instruction that invoices quote the PO number. The checklist above is ready to copy.<\/p>\n<h3>What is the difference between a purchase order and an invoice?<\/h3>\n<p>A purchase order is what you send to a supplier to commit to buying. An invoice, or bill, is what the supplier sends you to ask for payment after delivering. You check the invoice against the PO and the goods received before paying.<\/p>\n<h3>What is three-way matching in purchasing?<\/h3>\n<p>It means comparing three documents before paying: the purchase order (what you agreed), the goods receipt (what arrived) and the supplier&#8217;s bill (what you are charged). Quantities and prices should agree across all three, within any tolerance you set. Differences are resolved with the supplier before payment.<\/p>\n<h3>Does this template work in Google Sheets?<\/h3>\n<p>Yes. Upload the file to Google Drive and open it with Google Sheets. The functions used (SUM, SUMPRODUCT, ROUND, IF, AND) work the same way there.<\/p>\n<h3>Should freight go on the purchase order?<\/h3>\n<p>Yes, if the supplier is charging it, because it is part of what you agreed to pay and part of the goods&#8217; true cost. Give it its own line and tax rate. If a separate carrier bills you, note the expected amount on the PO but match it against the carrier&#8217;s own invoice.<\/p>\n<p>The template will carry you a long way if you keep the formulas intact and match every bill before paying it. When you want orders, receipts and bills linked so they cannot drift apart, see how <a href=\"https:\/\/cashflowinventory.com\/purchase-order-software.php\">Cash Flow Inventory&#8217;s purchase order software<\/a> handles approvals, partial deliveries and bills, or <a href=\"https:\/\/cashflowinventory.com\/signup.php\">start a free trial<\/a> and enter your next order there.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A free Excel purchase order that adds itself up: line discounts, mixed tax rates, freight and advances. It includes a checklist of what every PO must say and a sheet that matches the delivery and the supplier&#8217;s bill against the order.<\/p>\n","protected":false},"author":1,"featured_media":14767,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[120,131,130,103,132],"class_list":["post-14766","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-inventory","tag-accounts-payable","tag-excel-templates","tag-purchase-orders","tag-purchasing","tag-three-way-match"],"jetpack_featured_media_url":"https:\/\/cashflowinventory.com\/blog\/wp-content\/uploads\/cfi-guides\/purchase-order-template-excel\/purchase-order-template-excel.webp","_links":{"self":[{"href":"https:\/\/cashflowinventory.com\/blog\/wp-json\/wp\/v2\/posts\/14766","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cashflowinventory.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cashflowinventory.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cashflowinventory.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cashflowinventory.com\/blog\/wp-json\/wp\/v2\/comments?post=14766"}],"version-history":[{"count":2,"href":"https:\/\/cashflowinventory.com\/blog\/wp-json\/wp\/v2\/posts\/14766\/revisions"}],"predecessor-version":[{"id":15912,"href":"https:\/\/cashflowinventory.com\/blog\/wp-json\/wp\/v2\/posts\/14766\/revisions\/15912"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cashflowinventory.com\/blog\/wp-json\/wp\/v2\/media\/14767"}],"wp:attachment":[{"href":"https:\/\/cashflowinventory.com\/blog\/wp-json\/wp\/v2\/media?parent=14766"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cashflowinventory.com\/blog\/wp-json\/wp\/v2\/categories?post=14766"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cashflowinventory.com\/blog\/wp-json\/wp\/v2\/tags?post=14766"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}