This guide shows how to hold every line on a supplier invoice against the price agreement. The method is the same whether you do it by hand, in a spreadsheet or in a system. The examples are Danish: Danish builders' merchants, Danish standard terms and prices in Danish kroner (DKK). What typically goes wrong is described in 7 typical errors on supplier invoices (in Danish). If you buy from a food wholesaler, also read about the wholesaler's invoice in the restaurant (in Danish).
If you have no purchase order, the price agreement is the answer key. Why, and who approves what, is covered in approval of supplier invoices (in Danish). The agreement says what an item may cost, not whether it arrived. That the goods arrived is confirmed by the person who bought them. If something is missing, write to the supplier at once. Under the Danish builders' merchants' standard terms (DB26, clause 12.3), a quantity deviation you could see on receipt must be reported in writing, immediately and no later than 8 working days after delivery.
What to have ready
- The price agreements. The framework agreement and any project agreements, with the agreed price or discount rate for each item or discount group and the date the agreement applies from.
- The price file. A price file from the wholesaler (in Danish) in Excel or CSV is easier to look things up in than a PDF. Ask for the same item number and unit as on the invoice.
- The invoice. Preferably as an e-invoice or a PDF with an item number on every line.
- The latest invoices from the same supplier. They are the yardstick for items that are not in the agreement.
Step by step
1. Find the item in the agreement
Look the item up by its item number, not by its name. The item number can contain a shared number: at some builders' merchants, the DB number from ByggeBasen is part of the wholesaler's own item number. If the item is not in the agreement, compare with the price you have paid for it before.
Structural timber is identified by wood species, strength class, dimensions and treatment. If the timber line is not in the agreement under the same item number, find it by those four things. The name uses the nominal dimension: C24 rafter timber of 47×100 mm typically measures 45×95 mm planed. If the agreement states one dimension and the invoice the other, it can be the same item. «NTR klasse A/B» is the impregnation class NTR AB for timber without ground contact, not «A or B».
2. Check quantity and unit
Only compare prices in the same unit. A skirting board of 4.5 m, agreed at DKK 54.00 per piece, costs DKK 12.00 per metre. If you compare the price per metre with the price per piece without converting, one is 4.5 times the other. That number is the length of the skirting board, not an error. The price in a price file can also apply to 10 or 100 pieces at a time.
Then check that quantity times unit price gives the line amount. That is how you catch a number that has been read wrongly. On an e-invoice printed as a PDF, the full stop can be the decimal mark: «2.000 EA à 385.00 = 770.00» only adds up with 2 pieces. On the supplier's ordinary Danish invoice, the full stop is the thousands separator instead.
3. Find the price that applied when you bought
Which date locks the price is stated in the agreement or in the supplier's terms of sale. Under the Danish builders' merchants' standard terms (DB26, clauses 4.1–4.2), the price is the one in the current price list or in the order confirmation. Until you have accepted a quote, the supplier may change the price list without notice, unless otherwise agreed in writing. So keep the order confirmation. If you only have the invoice, use the invoice date.
A new price list applies from its start date, and purchases from before are measured against the old one. If the new list only contains the changed items, get confirmation that the old price applies to the rest. A price notice with a range, for example «roofing felt 12–25%», is not a new price. Ask for the price list, and see price notice from the supplier (in Danish). If you have both a framework agreement and a project agreement for the same item, check which one applies to the job.
4. Work out the agreed net price
If the agreement is a discount rate, the agreed net price is the gross price times (1 minus the discount rate). Some wholesalers print the gross price and the discount on the line: DKK 24.00 with a 15% discount gives a net price of DKK 20.40. If only a net price is shown, you cannot see on the line whether the rate has been deducted. Then you need the wholesaler's gross price from the same date. See gross price, net price and discount rate (in Danish).
An overall discount can appear as a single negative line at the bottom, for example «Kontantrabat» (cash discount) or «Samlerabat» (combined discount). It is deducted from the whole purchase, so include it before you say that a line is too expensive.
5. Work out the difference in kroner
The difference is (invoiced net price minus agreed net price) times the quantity. Take the item from step 4. If it is invoiced at DKK 24.00 with no discount, the difference is DKK 3.60 per piece. For 40 pieces that is DKK 144.00. Write down the difference for each line. That is what the claim to the supplier is built on.
6. Check the rest of the invoice
Freight, fees and a discount on the whole invoice sit outside the item lines, on an e-invoice in a field of their own. Hold them against the agreement, for example a threshold for free freight. Lines plus charges minus discount must give the total before VAT. Also check whether the invoice has arrived before: same supplier, invoice number and date. If the bank account number is different from last time, call the supplier on a number you already know. See invoice fraud with a new account number (in Danish).
7. Ask for a credit note
Send the supplier the line, the agreement and the difference in kroner as soon as you find the deviation, and no later than the due date. Ask for a credit note. When it arrives, check that it refers to your invoice and that the amount covers the difference. See credit note for an incorrect invoice (in Danish).
Checklist
| Check | What to look for |
|---|---|
| The item | Same item number as in the agreement; without an agreement: your last purchase |
| The unit | Piece, metre, pack and box converted to the same unit |
| The numbers | Quantity times unit price gives the line amount |
| The date | The agreement and price list that applied when the item was bought |
| The price | Invoiced net price against agreed net price |
| The discount | Line discount and overall discount deducted as agreed |
| Freight and fees | Only what the agreement allows |
| The total | Lines plus charges minus discount give the total before VAT |
| Duplicates | No earlier invoice with the same supplier, invoice number and date |
| Account number | The same as last time; a new number is confirmed on a phone number you know |
| The difference | Worked out in kroner per line and in total |
When to check, and where to start
Check the invoice before it is paid. If the deviation is found before payment, you ask for the credit note before the money goes out. If it is found afterwards, the method is the same, but now you are the one waiting for the money.
If you cannot get through them all, start with the suppliers you buy most from and the items agreed with a discount rate. That is where a missing discount is hardest to see when the invoice only shows the net price (step 4). If you only check the largest invoices, the rest are approved on trust, and errors in them are not found. See manual or automatic control (in Danish).
How DiFacto does it
DiFacto holds every item line on every invoice against your price agreements, and items without an agreement against what you have paid before. If the agreement is a percentage discount on a brand or range, and the invoice only shows the net price, the system cannot check the line against the rate. It is counted as unchecked. If you have both a framework and a project agreement for the same item, the system uses the lower of the two prices. Deviations are shown with the agreed price, the invoiced price and the difference in kroner, and you can dismiss a false alarm. The system also flags possible duplicates and, on invoices that arrive via your DiFacto email address (the AutoPilot add-on), a bank account number the supplier has not used before. If a credit note refers to the invoice, the system suggests which open claim it answers. You settle what has been paid back, and the rest stays as a claim. Invoices come in by upload or, with the AutoPilot add-on, via your own DiFacto email address, as a PDF, an image or an e-invoice.
In more than 50,000 manually reviewed invoices there were errors in more than 10% of the invoices, and typically 1.6% of the purchase total was over-invoiced. See DiFacto in English, and in Danish fakturakontrol and price agreements in DiFacto.