Invoice data entry errors: the five that cause mismatched bills
Bills that disagree with the invoice usually trace back to five errors: transposed or misread digits, misplaced decimals, a missing or mis-signed charge, tax entered twice or not at all, and a wrong header field such as the date or invoice number. Each has a quick check. Re-adding the invoice from the lines up catches most of the first four.
General information for bookkeepers, not accounting, tax or legal advice. Rules and software screens differ by country and change over time.
Why check before you save
A bill that disagrees with its invoice rarely shows itself on entry. It surfaces at payment, at statement reconciliation or at month-end, when the fix means voiding and re-entering. The cheapest moment to catch an error is before you save the bill, and most checks need only a calculator. Two habits make it stick: run the checks in the same order every time, and note the printed total before you start keying, so you test your entry against a fixed number.
The five errors and the check for each
| Error | What it looks like | The check that catches it | Does arithmetic catch it? |
|---|---|---|---|
| 1. Transposed or misread digits | 1,260.00 keyed as 1,620.00, or a 3 read as an 8. | Multiply each line, add the lines, compare with the printed total. A difference that divides evenly by 9 often points to swapped digits. | Usually |
| 2. Misplaced decimal or separator | 150.00 keyed as 15.00, or 1.234,56 read as 1.23456. | Compare the number of digits in each amount with the paper, and check which number style the supplier's country uses. | Usually |
| 3. Missing or mis-signed charge | Freight left off, or a discount added instead of subtracted. | Subtotal + tax + charges − discounts must equal the printed total. | Yes, against the printed total |
| 4. Tax entered twice or not at all | Tax-inclusive prices keyed as exclusive, so tax is added on top. | Tax ÷ taxable amount should give the printed rate, and the total should match. | Yes, against the total |
| 5. Wrong header field | Day and month swapped, a PO number keyed as the invoice number, a look-alike supplier. | Match the supplier to your list, the number to its label on the invoice, and the date to a plausible range. | No |
A five-minute check before you save
-
Read the header against the paper
Supplier, invoice number, invoice date and due date. Say the date aloud as a day, a month name and a year, which removes the 03/04 doubt.
-
Multiply each line
Quantity × unit price must equal the line amount, to the cent.
-
Add the lines
They must equal the printed subtotal. With no subtotal, compare their sum with the total less tax.
-
Add tax and charges
Subtotal + tax + shipping and fees − discounts must equal the printed total.
-
Compare the saved bill with the invoice
The total your software shows should equal the invoice total. Do not accept the entry screen's own sum as proof, because it adds what you typed.
-
Search for a duplicate
Look up the supplier and invoice number before you post. See duplicate invoice detection.
A worked example
Take an invoice with three lines: 12 × 8.50 = 102.00, 4 × 24.75 = 99.00 and 1 × 310.00 = 310.00. The subtotal is 511.00, freight is 18.50, tax at 7% on the goods is 35.77, and the total is 565.27. Here is how four slips show up against it.
- 310.00 keyed as 301.00. The lines add to 502.00, which is 9.00 below the printed subtotal. A gap of 9 points to swapped digits.
- Freight keyed as 1.85. The total comes out 16.65 short. That is 9 × 1.85, so suspect a decimal slip.
- Freight left off. The total is 18.50 short, and the shortfall matches a printed line.
- Tax keyed twice. The total is 35.77 too high, exactly the printed tax.
In each case the gap is a number you can find on the paper. That is what makes re-adding fast.
What the checks cannot catch
Arithmetic proves that the figures agree with each other. It cannot prove they are the right figures.
Errors that cancel
One line keyed 10.00 too high and another 10.00 too low leave every total intact.
A wrong figure that still adds up
A misread number outside any sum, such as an invoice number, breaks nothing. Neither does a price the supplier printed wrongly.
Wrong account or tax code
The bill ties to the cent but is coded to the wrong place. That needs a coding review, not arithmetic.
Checking only when something looks off
Errors rarely look off. Run the same checks on every bill, scanned or keyed, as in supplier invoice OCR checks.
How BillToCSV helps
BillToCSV runs the arithmetic in steps 2 to 4 on every bill it reads: quantity × unit price against each line, lines against the subtotal, and subtotal plus tax and charges against the total. Rows that do not tie turn amber with the numbers shown, and a bill that does not tie starts unticked. It cannot catch a misread that still adds up, so check the invoice number, date and supplier yourself. Try the converter. Free: 1 file per day, up to 10 pages, no account. See pricing.
Questions people ask
What is the most common invoice data entry error?
Digit and decimal slips are the typical ones, because they are easy to make and look plausible. Both usually break a sum, which is why re-adding the invoice catches most of them.
Why does a difference divisible by 9 suggest swapped digits?
Swapping two adjacent digits changes a number by a multiple of 9, so a difference of 36.00 or 540 is a clue. A decimal point one place out also gives a multiple of 9. It is a clue, not proof.
Should I trust the total printed on the invoice?
Treat it as a figure to test. Suppliers make arithmetic errors too. If the lines do not add up to the printed total, query the supplier before paying, and note what you agreed.
How much difference between my total and the invoice is acceptable?
Tax calculated per line instead of per invoice can leave a cent or two. Beyond that, find the cause. Set a written tolerance for your firm rather than judging each bill on its own.
Do scanned or OCR-read invoices need the same checks?
Yes. Software misreads digits just as people do, and some misreads are more subtle. Run the same checks, and read the guide on what to check after OCR.
What about invoices with handwritten changes?
Treat the written figure as unverified until the supplier confirms it. Scanners and OCR cannot read it reliably, and the printed lines will no longer add up to it.