Sage X3 Purchase Price Variance Review

By Phillip Hoffman, Founder and Principal Consultant· Updated October 17, 2026

Under standard costing, purchase price variance (PPV) is meant to answer a simple question: did we pay more or less than we expected for what we bought? When the standards are sound and the purchasing data is clean, PPV is one of the most useful numbers in the monthly results.

In practice, PPV often becomes a catch-all. Real price changes are mixed with unit of measure errors, outdated standards, exchange rate differences, freight, and invoice mismatches. The total is large, the explanations are vague, and the number gets reported without anyone being confident in what it means.

This guide explains where PPV comes from in Sage X3, how to separate the variances that reflect real business events from the ones caused by errors, and how to build a month-end review that produces explanations rather than estimates.

Talk to a Senior Sage X3 Consultant

Signs your PPV needs a closer look

PPV is large every month, even when supplier prices have not changed significantly.
The same products appear at the top of the variance list month after month.
Individual variances are many times the value of the purchase.
Favorable and unfavorable variances offset each other in total, hiding large movements underneath.
Nobody can say how much of the variance is price, currency, freight, or error.
Variances increase sharply after a standard cost update.

Where purchase price variance comes from

Under standard costing, stock is carried at the standard cost. When goods are received, Sage X3 values them at standard, and the difference between what the business pays and the standard is recorded as a variance rather than added to inventory value.

Depending on how the system is configured, the variance may be recognized in more than one step:

At receipt, based on the difference between the purchase order price and the standard.
At invoice, based on the difference between the invoice price and the price used at receipt.

Knowing which steps apply in your configuration matters, because it determines when the variance appears and which reports show it. If part of the variance is recorded at receipt and part at invoice, both need to be reviewed together to understand the full difference on a purchase.

The common causes

Real price changes

A supplier increased or reduced its price, a new supplier was used, or a different quantity break applied. These are the variances PPV is designed to show, and they are useful information for Purchasing and Finance.

Outdated standards

If the standard was set a year ago and prices have moved since, every receipt will produce a variance. This is not an error in purchasing. It is a sign that the standard no longer reflects current cost. Large, consistent variances on the same products usually point here.

Landed costs not included in standard

If freight, duty, and similar charges are paid on every receipt but are not included in the standard, they will appear as variance every month. This is predictable and should be either built into the standard or reported separately so it is not confused with supplier price changes. Our guide to validating standard cost updates covers this decision.

Currency

For foreign-currency purchases, the exchange rate used for the standard, the purchase order, the receipt, and the invoice may all differ. Currency movements can create significant variances even when the supplier's price in its own currency has not changed.

Unit of measure errors

If the purchase unit, the stock unit, or the conversion factor between them is wrong, the price per stock unit will be wrong by the same factor. These variances are often very large relative to the purchase value and are among the easiest to find once you look for them.

Purchase order price errors

An incorrect price on the purchase order, such as an old price, a typing error, or a price for a different unit, creates a variance at receipt that may partly reverse when the correct invoice is matched.

Invoice mismatches

Differences between the invoice and the receipt, including partial invoices, quantity differences, and additional charges, can create invoice-level variances. These often relate to the same issues that affect the receipts not invoiced balance.

Separate real variances from errors

The most important step in a PPV review is splitting the total into what it actually represents. A useful approach is to classify each significant variance into one of these groups:

Price: the supplier price changed, or a different supplier or price break applied.
Standard: the standard is out of date or was set incorrectly.
Landed cost: freight, duty, or similar charges not included in standard.
Currency: exchange rate differences.
Error: unit of measure, purchase order price, or invoice errors that need correction.

Price, standard, landed cost, and currency variances are business information to report and act on. Errors need to be corrected at the source, and often in the transactions themselves, so they do not distort results.

A month-end review that holds up

1. Confirm the period is complete.
Make sure receipts and invoices for the period have been posted and stock accounting has run.
2. Pull PPV by transaction.
Use a report that shows each receipt and invoice variance with product, supplier, quantity, standard cost, actual price, and variance amount. Totals by account alone do not support explanation.
3. Rank by absolute value.
Sort by the size of the variance regardless of sign, so large favorable variances are reviewed as carefully as large unfavorable ones.
4. Check the ratio of variance to purchase value.
A variance that is several times the purchase value is almost always an error, usually unit of measure or price.
5. Classify the top items.
Assign each significant variance to price, standard, landed cost, currency, or error.
6. Correct the errors.
Fix the purchase order, unit of measure, or invoice at the source, and decide with Finance how to correct the transactions already posted.
7. Explain the rest.
For real variances, record the reason, such as a supplier price increase or exchange rate movement, and share it with Purchasing.
8. Review trends.
Compare the month to prior months by product and supplier. A variance that repeats every month is a standard or landed cost issue, not a one-time event.

As with the other close reconciliations, this review is much faster with a custom report that brings the transaction detail, the standard, and the purchase data into one view. Reviewing variances product by product in the system is slow and makes patterns hard to see.

Reporting PPV

How PPV is presented matters as much as how it is calculated. Reporting a single total each month tells management very little. A more useful report shows:

PPV split into price, standard, landed cost, currency, and corrected errors
The largest variances by product and supplier, with a short explanation
The trend over recent months
Variances as a percentage of purchase value, not only in total

When PPV is material, the accounting treatment also deserves attention. Standard costs are expected to approximate actual cost, and large, sustained variances can mean that part of the variance relates to inventory still on hand rather than to goods already sold. Agree with your auditors how significant variances are treated at period end and at year-end.

Preventing avoidable variances

Update standards on a regular cycle, and review the inputs before each update.
Decide deliberately whether landed costs are included in standard, and apply the rule consistently.
Validate units of measure and conversion factors when new products or suppliers are set up.
Keep purchase order prices current, and review purchase orders with prices far from standard before they are approved.
Agree on how exchange rates are used for standards and purchase orders.
Review PPV monthly with Purchasing, not only Finance.

When to bring in help

Outside help is usually worthwhile when PPV is consistently large and unexplained, when the business has recently converted to standard costing, when a standard cost update has made variances worse, or when the accounting treatment of significant variances has been questioned by auditors. In those situations, the work involves reviewing standards, purchasing data, and configuration together.

Purchase price variance questions

What is purchase price variance under standard costing?

It is the difference between the standard cost of purchased items and the price actually paid. Inventory is carried at standard, and the difference is recorded as a variance rather than added to inventory value.

Why is our PPV so large every month?

The most common reasons are outdated standards, landed costs that are not included in standard, and currency movements. Unit of measure and purchase order price errors can also create very large individual variances.

Should PPV be recorded at receipt or at invoice?

It depends on your configuration and reporting needs. Recording at receipt shows the variance earlier, while invoice-level variances capture differences between the invoice and the purchase order. Whichever applies, review both together so the full variance on a purchase is understood.

How do we tell a real price change from an error?

Compare the variance to the value of the purchase. Real price changes are usually a modest percentage of the purchase value. Variances that are several times the purchase value usually indicate a unit of measure, price, or data entry error.

Does PPV need to be allocated to inventory?

When variances are significant, part of them may relate to inventory still on hand rather than to goods already sold. Discuss the treatment with your auditors, particularly at year-end.

Need help making sense of your PPV?

If your purchase price variance is large every month and the explanations are not convincing, a review of your standards, purchasing data, and reporting usually shows where the variances are really coming from. Schedule a discovery call to talk it through with a senior Sage X3 consultant.

How to Review Purchase Price Variances Under Standard Costing in Sage X3