Purchase Price Variance: Formula, Causes, and Fixes
Jul 10, 2026
Jul 10, 2026
Convert a purchase order to Excel, CSV, or JSON
Submit your purchase orders
Drop documents here, or click to file
Up to 50 files per batch
Uploading...
Purchase price variance (PPV) is the difference between the price you actually paid for an item and the price you expected to pay, multiplied by the quantity purchased. The formula is PPV = (actual price minus standard price) x actual quantity. A positive result means you paid more than expected, which is unfavorable. A negative result means you paid less, which is favorable. It is the single clearest number for whether your negotiated prices are surviving contact with the invoice.
Last updated July 2026.
Calculating PPV requires two numbers per line: the price on the purchase order or standard cost, and the price on the invoice. When purchase orders arrive as PDFs, getting the first number into a spreadsheet is where the analysis usually dies. The tool above pulls the PO number, supplier, and every line with its unit price in about ten seconds, which is what makes a line-level variance report possible at all.
PPV = (Actual Price minus Standard Price) x Actual Quantity
The standard price is your benchmark. Depending on how your company runs, it is either the standard cost set in the ERP at the start of the year, or the price agreed on the purchase order. Both are defensible. Pick one and be consistent, because comparing invoices against standard cost and against PO price answer different questions.
The actual price is what the supplier billed, per unit, on the invoice. The actual quantity is what you bought, not what you planned to buy. Using planned quantity here is a common error that mixes a price problem with a volume problem.
Work it through. You budgeted a standard cost of $10 per unit for a component. You bought 5,000 units and the invoice shows $10.40 each.
PPV = ($10.40 minus $10.00) x 5,000 = $2,000 unfavorable.
Two thousand dollars sounds small. Multiply it across a few hundred SKUs and a full year of buying and it becomes the difference between hitting a gross margin target and explaining why you missed it.
A favorable variance means you paid less than standard. Finance teams like the sign of the number and then stop asking questions, which is a mistake. Favorable PPV comes from several places, and only some of them are wins:
That last one is the most common and the most corrosive. A standard cost that is never refreshed turns PPV from a control into decoration. If your variances are consistently favorable across every category, the problem is probably the benchmark, not the buying.
| Cause | What it looks like | Who can fix it |
|---|---|---|
| Off-contract buying | Someone bought outside the negotiated agreement, at list price | Procurement, through policy and PO controls |
| Contract not honored | The supplier quoted one price and invoiced another | Accounts payable, by catching it at the match |
| Rush and small-lot orders | Expedited freight and broken-case pricing on urgent buys | Planning, by forecasting further out |
| Volume assumptions missed | Tier pricing assumed a volume the company never reached | Finance and procurement, jointly |
| Commodity or FX movement | Raw material or currency shifts under a long contract | Nobody, but it should be isolated and reported separately |
| Stale standard cost | Everything shows a variance in the same direction | Finance, at the annual cost roll |
The useful discipline is separating the causes you control from the ones you do not. A PPV report that lumps a currency swing together with a buyer who ignored the contract tells a CFO nothing actionable.
These get used interchangeably and they should not be. Purchase price variance compares the purchase order price to the standard cost, and it is recognized when the goods are received. Invoice price variance (IPV) compares what the supplier invoiced to what the purchase order said, and it is recognized when the invoice is matched.
The distinction matters because they point at different people. A large PPV is a procurement conversation: the buyer agreed to a price above standard. A large IPV is an accounts payable conversation: the supplier billed something other than what was agreed, and somebody paid it. Systems that only track one number lose that signal entirely.
Under standard costing, inventory is carried at standard. So when the invoice differs from standard, something has to absorb the difference, and that something is the purchase price variance account.
You buy 5,000 units at an invoiced $10.40, against a $10.00 standard:
Inventory stays on the books at standard, which is the whole point of standard costing, and the variance flows to the income statement. A favorable variance credits the PPV account instead. If you accrued for the receipt before the invoice arrived, the clearing entry works the same way, with the purchase order accrual being relieved at PO value and the difference landing in variance.
Reducing PPV is mostly about catching the difference early enough to do something about it, and that means having the PO price and the invoice price side by side before payment goes out.
All five of those require line-level data. A variance calculated on invoice totals hides the item that quietly moved 18 percent, because it nets against the item that fell 3 percent across a large volume. You need unit prices per SKU, which means the line-item table from the purchase order has to exist as rows.
The practical blocker is that half the inputs live in PDFs. Purchase order line item extraction turns each order into rows with the SKU, quantity, and agreed unit price, and bulk purchase order upload clears a quarter of orders in one pass so the analysis covers everything rather than a sample. Export it with the PO PDF to Excel converter and pivot on supplier and item, or push it into the ledger through NetSuite or SAP. Procurement leaders who want the rolled-up view start at purchase order data for procurement leaders.
The other half of the comparison is the invoice, and the invoiced unit prices have the same problem: they sit in a PDF nobody wants to retype. Reading the line data off supplier invoices automatically is what lets you put the two columns next to each other and calculate a variance per line instead of per document.
Purchase price variance is the difference between the actual price paid for a purchased item and its standard or expected price, multiplied by the quantity bought. It measures whether purchasing is buying at the prices the business planned for. It is reported as favorable when the actual price is lower and unfavorable when it is higher.
Subtract the standard price from the actual price, then multiply by the actual quantity purchased. If you paid $10.40 for 5,000 units against a $10.00 standard, PPV is $0.40 x 5,000, or $2,000 unfavorable. Always use the actual quantity bought, not the planned quantity, or you mix a price variance with a volume variance.
A favorable purchase price variance means you paid less per unit than the standard cost, so the calculation returns a negative number. It is not automatically good news. It can signal a genuine negotiation win, a falling commodity market, a stale standard cost, or a switch to lower-quality material that will cost more later in production.
The most common causes are buying outside a negotiated contract, suppliers invoicing above the agreed price, rush and small-lot orders carrying premium pricing, volume tiers that assumed purchases the company never made, commodity or currency movement, and standard costs that have not been refreshed. Only some of those are within a buyer's control.
Under standard costing you debit inventory at standard cost, debit purchase price variance for an unfavorable difference (or credit it for a favorable one), and credit accounts payable for the amount the supplier actually invoiced. Inventory stays valued at standard and the variance flows through to the income statement.
No. Purchase price variance compares the purchase order price against standard cost and is recognized at goods receipt. Invoice price variance compares the invoiced price against the purchase order price and is recognized at invoice matching. PPV points at a procurement decision, while IPV points at a supplier billing something other than what was agreed.
Keep standard costs current, match every invoice against the purchase order and the receipt before paying, enforce purchase order controls so buying happens on contract, and report variance by supplier and buyer rather than as a single total. Report commodity and currency effects separately so buyers are measured on what they actually influenced.
Yes, provided the standard cost is credible and the report goes to line level. Tracked properly it tells you whether negotiated pricing is being honored and where off-contract buying is happening. Tracked against a stale benchmark, or only in total, it becomes a number that moves without telling anyone why.
PurchaseOrders is a data-capture tool. It does not calculate variances, post journal entries, or perform the three-way match. It reads supplier purchase orders and returns structured line-level fields, so the analysis your finance team runs is built on data nobody had to retype.