How to Read a Purchase Price Variance Report

Why price differences between receipt and bill go unnoticed

Goods are received at one cost and billed at another. A supplier raises a price after the order, a discount is not applied, or the bill is keyed with a different figure. Each difference is small, so nobody looks.

Added up across a quarter, those differences change your margins. Without a report, finding them means pulling receipts and bills side by side for every supplier and item.

The price variance report shows the difference on posted bills in a period, by supplier and item, with each bill line behind the totals. It tells you which suppliers and items to raise with the buyer, and the CSV lets you work the figures further. It only reads posted bills, so running it changes nothing in stock or accounts.

Why this happens

• Suppliers bill a higher price than the goods were received at.
• Agreed discounts or price breaks are missing from the bill.
• Small line differences are not reviewed one by one.
• Standard costs are out of date against what receipts actually cost.

Biznsbook addresses this through billed price against received cost, variance by supplier and item, every bill line, csv export in the Purchase module, on the same orders, receipts, bills and stock records.

Purchasing problems rarely start with one big mistake. They start with a price nobody checked, a bill keyed twice, or goods used before anyone looked at them. Recording each step where it happens removes those gaps.

Step-by-step: Read a Purchase Price Variance Report

Written for buyers, store keepers and accounts payable teams in small and mid-sized businesses. The steps follow Purchase in Biznsbook.

1. Open the report. Go to Purchasing → Reports → Price variance. The Purchasing reports need the Purchase licence and permission to view purchases.
2. Choose the period. The report covers posted bills dated in the period you choose. A bill counts in the period by its bill date.
3. Read the sign. A positive variance means the bill cost more than the goods were received at. A negative one means the bill cost less.
4. Start with suppliers and items. Look at the totals by supplier and by item to find where most of the difference comes from.
5. Drill into the bill lines. Each bill line is listed with its variance, so you can see which bill and which receipt the difference came from. Each line shows the billed price next to the unit cost the goods were received at.
6. Check standard-cost items. For items on standard cost, the report also shows each receipt's difference from standard. Those differences are taken by the date of the receipt.
7. Export to CSV. Use the CSV export to share the figures or work on them in a spreadsheet.

Review results after the first full monthly cycle. Adjust roles, mappings, or approvals where the same exception repeats.

Inside Biznsbook, each Purchasing screen explains its own steps. This article explains the business process behind those screens.

Common mistakes to avoid

• Mistake 1: Suppliers bill a higher price than the goods were received at. Repeating this each month usually shows up first in a supplier paid the wrong amount, late, or for goods that never arrived.
• Mistake 2: Agreed discounts or price breaks are missing from the bill. Repeating this each month usually shows up first in a supplier paid the wrong amount, late, or for goods that never arrived.
• Mistake 3: Small line differences are not reviewed one by one. Repeating this each month usually shows up first in a supplier paid the wrong amount, late, or for goods that never arrived.
• Mistake 4: Standard costs are out of date against what receipts actually cost. Repeating this each month usually shows up first in a supplier paid the wrong amount, late, or for goods that never arrived.

Each of these shows up later as a supplier balance nobody can explain. Fix it on the order, receipt or bill rather than in a side spreadsheet.

Best practices that hold up as you scale

• Open the report — Go to Purchasing → Reports → Price variance.
• Choose the period — The report covers posted bills dated in the period you choose.
• Read the sign — A positive variance means the bill cost more than the goods were received at.
• Start with suppliers and items — Look at the totals by supplier and by item to find where most of the difference comes from.
• Drill into the bill lines — Each bill line is listed with its variance, so you can see which bill and which receipt the difference came from.

Keep the order, the receipt and the bill linked, so every payment can be traced back to what was ordered and what arrived.

How Biznsbook supports this workflow

billed price against received cost is part of Biznsbook Purchase. It works on the same purchase orders, goods receipts and supplier bills, so stock, payables and the ledger stay in step.

variance by supplier and item is part of Biznsbook Purchase. It works on the same purchase orders, goods receipts and supplier bills, so stock, payables and the ledger stay in step.

every bill line is part of Biznsbook Purchase. It works on the same purchase orders, goods receipts and supplier bills, so stock, payables and the ledger stay in step.

csv export is part of Biznsbook Purchase. It works on the same purchase orders, goods receipts and supplier bills, so stock, payables and the ledger stay in step.

Access is permission-based: viewing, creating, editing and approving purchases are separate permissions. Purchase orders and goods receipts need the Inventory module; postings to accounts payable need Accounting.

Suggested implementation timeline

1. Week 1: Set up billed price against received cost and give buyers and accounts payable the permissions they need.
2. Week 2: Run one supplier end to end in Biznsbook only: order, receipt, bill and payment, with no side spreadsheet.
3. Week 3: Review the exceptions with the people involved and adjust the rules where they disagreed.
4. Month 2: Roll out to every supplier and retire the old tracking sheet.
5. Ongoing: Monthly review using acting on what the report shows.

Related guides

Cluster hub: Purchasing guides. Also see three-way match and, for approvals before an order, procurement guides.

The Purchase overview lists what the module includes; the Purchasing edition bundles it with receiving and accounting.

Industry: wholesale, manufacturing, retail.

Metrics to track monthly

• Open purchase order lines past their delivery date
• Bills waiting in bill matching
• Overdue supplier bills and bills due in the next 7 days
• Purchase price variance by supplier this month

Start with three metrics; trend direction matters more than a single point-in-time snapshot.

Spreadsheets and email vs Biznsbook Purchase

Compare a typical spreadsheet-and-email buying process with Biznsbook billed price against received cost and the related Purchase capabilities.

Acting on what the report shows

A variance is a starting point, not a correction. Where the supplier agrees they overcharged, record a supplier credit note with the reason Price correction, which is credited to purchase price variance. To stop overcharges before payment, turn on bill matching, which flags a bill priced above the order by more than the price tolerance. For a fuller view of spend by supplier, product group and month, use Purchasing → Reports → Spend analysis. Bill matching's settings sit at the bottom of the Bill matching page and need Approve purchases: the price tolerance defaults to 2% and line differences under 1.00 are ignored by default. Paying less than the order price is never flagged, and prices are compared only when the bill and order use the same currency. There is no variance view by GL account or cost center: bill lines carry neither, so purchasing reports group by supplier, product group and item.

Write the rule into your purchasing procedure so buyers, store keepers and accounts payable follow the same steps, and revisit it each quarter.

Frequently asked questions

How this differs by industry