Calculators

Invoice price variance and tolerance calculator

Invoice price variance is the gap between the PO unit price and the invoice unit price, multiplied by the quantity invoiced.

Invoice price variance calculator

Invoice price variance
$400.00
Variance
4.03%
Against the tolerance
Inside tolerance: would be paid

Formula: IPV = (invoice price − PO price) × quantity; variance % = (invoice price − PO price) / PO price

Example

PO unit price ($)
$12.40
Invoice unit price ($)
$12.90
Quantity invoiced
800
Price tolerance (%)
5%
Invoice price variance
$400.00
Variance
4.03%
Against the tolerance
Inside tolerance: would be paid

What the calculator works out

The calculator compares the unit price on an approved purchase order with the unit price on the vendor invoice and multiplies the difference by the quantity invoiced. It also expresses the difference as a percentage of the PO price. You enter four items: PO unit price, invoice unit price, quantity invoiced and price tolerance.

The PO unit price is the price per unit on the approved PO line. The invoice unit price is the price per unit shown on the vendor invoice line, before you apply any separate credit or adjustment. The quantity invoiced is the quantity billed on that invoice line, so check the unit of measure: a line billed in cases and a PO priced in eaches will produce a false variance. The price tolerance is the percentage your AP policy, approval matrix or vendor terms allow before a line is held for review.

The formulas are IPV = (invoice price − PO price) × quantity and variance % = (invoice price − PO price) / PO price. The output is the dollar variance and whether the line is inside or outside tolerance. A line inside tolerance normally goes to payment without review; a line outside tolerance should be held for a price check.

A worked example

Suppose the PO unit price is $12.40, the invoice unit price is $12.90, the quantity invoiced is 800 and the price tolerance is 5%.

With those inputs, the invoice price variance is $400.00, a $400 variance on the line. The variance is 4.03%. Against the tolerance: Inside tolerance: would be paid.

This is the ordinary case that deserves attention: the line is inside the 5% tolerance and would be paid, even though a $400 difference exists. The calculator does not decide whether the price is right; it shows the size of the gap and whether your tolerance rule would stop the line.

Reading the result

An inside-tolerance result means the line would be paid without review. That is the point of a tolerance, but it also means small overcharges add up across many lines. A $400 variance on one line is easy to miss when it sits under a 5% threshold.

Percentage tolerances have a scale problem. Tolerances set as a percentage let large-value lines through with large dollar differences; a dollar cap helps. A line for a high-value item can be inside a 5% tolerance while the dollar gap is far larger than the same percentage on a low-value line. Review the dollar result, not only the percentage.

Repeated variances with one supplier usually mean an outdated PO or price file. Check whether the PO revision, the vendor price file or the invoice price changed first. Overcharges found after payment are recovered as credits from the supplier. If you are comparing the cost of chasing a small balance with the cost of funds, use your own cost of funds as the benchmark.

Where the inputs go wrong

The most common input error is using an invoice price that is not the unit price you meant to test. A line may show a list price, a net price after a discount, or a price before freight, and pulling the wrong one changes the variance. Read the invoice line and the PO line at the same level: same item, same unit of measure, same price basis.

Another error is using an outdated PO. If the supplier issued a price change and the buyer did not revise the PO, the invoice will look wrong even when the invoice reflects the agreed price. Compare the PO revision and the price effective date before you treat the difference as an overcharge. For AR, the mirror error is checking a customer invoice against an old quote or price list.

Tolerance input errors also matter. Entering 5 as a dollar amount instead of 5% makes the rule behave differently, and entering 5% when the policy is a dollar cap will let the wrong lines through. Check the quantity and unit of measure last, because a quantity mismatch can make a good unit price look wrong. Your ERP or the vendor record may hold the price file, but the invoice line and the approved PO line are the records to compare.

Questions

What is invoice price variance?

Invoice price variance is the difference between the PO unit price and the invoice unit price, multiplied by the quantity invoiced. It is stated as a dollar amount, and the variance percentage divides the unit price difference by the PO price.

How do I calculate invoice price variance?

Use IPV = (invoice price − PO price) × quantity. For the percentage, use variance % = (invoice price − PO price) / PO price. Enter the PO unit price, invoice unit price and quantity invoiced from the line records.

What does price tolerance mean on an invoice?

Price tolerance is the percentage difference your AP policy or vendor terms allow before a line is held for review. A line inside tolerance is normally paid without review; a line outside tolerance should be stopped for a price check. A dollar cap can sit alongside the percentage to catch large-value lines.

Why does a small invoice price variance still matter?

A variance inside tolerance is paid without review, so small overcharges add up across many lines. Percentage tolerances can also let large-value lines through with large dollar differences. Repeated variances with one supplier usually point to an outdated PO or price file, and overcharges found after payment are recovered as credits from the supplier.

Updated Nov 9, 2026. Figures on this page are calculated by ERPSav from the definitions shown. The explanatory text is drafted with AI from those figures and checked automatically before it is published. General information only, not legal, tax or financial advice.