Why Your Invoice Totals Don't Add Up (And How to Check Them)
You add up the rows on a bill. The sum is not the total on the page. Now what? When invoice totals don't match, the cause is most often small and dull. It is a tax line you missed, a fee, or one row read wrong.
This guide lists the top causes of a gap. It then gives you three fast checks to find it. The same checks are a good habit before you pay any bill. For the full habit, see how to check an invoice before you pay it.
A gap is not rare, and it is not a small thing. Pay a bill that is too high and the cash is gone; most firms will not hunt you down to give it back. Pay too low and you face late fees and a tense call. The good news: most gaps have a plain cause, and the cause leaves a clue in the size of the gap. Learn the clues and you can find most gaps in a few minutes.
Five common causes of a gap
Start with the dull truth: a gap is a fact, not a guess. Two sums that should match do not. Your job is to find which part of the bill breaks the match. Work from the most common causes down. In most cases, the cause is one of these five.
- Tax: the rows sum to the subtotal, but tax is added on top. The full total is then higher than your sum.
- A fee or ship cost: a small line for post or fees can sit far from the rows and is easy to miss.
- A discount: a cut in price can show as a line with a minus sign. If you skip it, your sum is too high.
- Rounding: each row is rounded to cents. On long bills, the cents can add up to a cent or two of drift.
- A plain slip: one digit typed or read wrong. A 6 read as an 8 can move a sum a lot.
None of these means the bill is a fraud. Most gaps are dull slips. But you can not know that till you find the cause. A gap you can not explain is a bill you should not pay yet.
The size of the gap points at the cause. Use it as your first clue:
Two more shapes show up in real piles. A credit note is a bill in reverse: its rows cut what you owe. If you add its rows as a plain bill, your sum jumps the wrong way. And a part bill — one of a run for one big job — shows a “this bill” sum and a “job to date” sum. Match your rows to the “this bill” sum. The job sum holds rows from bills you may not have. Both shapes look like gaps till you name them.
| Size of the gap | First suspect |
|---|---|
| A cent or two | Rounding drift on a long bill |
| A round sum, like 10 or 50 | A lost row or a missed fee line |
| The same as the tax sum | Tax counted twice, or not at all |
| The same as one row's sum | That row was lost, or read twice |
A worked example: find a gap by hand
Here is a real shape of gap, with the names changed. A bill comes in with six rows. The rows add up to 386.20. The printed subtotal is 386.20 too, so the rows are sound. The tax line says 30.90. Add them: 386.20 plus 30.90 is 417.10. But the printed total says 420.10. The gap is 3.00, a round sum.
A round gap points at a lost line. So scan the foot of the bill, below the tax line. There it is: a small line, “handling 3.00”, set apart from the rows. The bill was right; the first read missed the fee. Add the line to the sheet and the gap is gone. The whole hunt took two minutes, and most of it was knowing where to look.
Now a smaller one. A long bill has forty rows. The rows sum to 913.44. The subtotal says 913.46. The gap is two cents. That is the shape of rounding drift: each row was rounded to cents, and the drift shows in the sum. Two cents on forty rows is no fraud and no slip. Note it, and pay the bill. Small gaps have small causes. Big gaps get the full hunt.
Three checks that find the gap
Run these three checks in order. They catch most gaps in a minute or two.
By hand, do the first check in a sheet, not on a phone calc. Type the row sums in one column and add them. A sheet does not drop a row the way eyes do. If the sum in the sheet and the sum in your head differ, trust the sheet and find the row you skipped. Most row-sum gaps end at a lost or split row — the craft of getting each row out whole is in our guide on how to extract line items from an invoice PDF.
| Check | The math | What a gap means |
|---|---|---|
| Rows vs subtotal | Add all line totals | A row is wrong, lost, or added |
| Subtotal plus tax | Subtotal + tax = total | Tax rate or tax sum is off |
| Count times price | Qty × unit price per row | One row has a bad digit |
Our tool runs the first two checks on each bill you convert. It shows pass, warning, or fail with the exact gap. That way you do not have to add long columns by hand. You can run the totals check free on your next bill.
By hand or by tool?
You can run these checks with a calc and a sharp eye. For one bill a week, that is fine. The cost math turns as bills grow. Three checks on twenty bills is an hour of sums. An hour of sums is dull work, and dull work is where the next slip hides. There is a real chance you make a new gap while you hunt an old one — a row skipped in your own add-up, a digit hit wrong on the calc.
A tool flips the work. It runs the row sum and the tax sum on each bill in seconds and shows the gap, if any. Your time goes to the few bills that fail, not to the many that pass. You still use your eyes — but on the bills that need them, with the gap size in hand as your first clue. The checks are the same. The sweat is not.
Whichever way you run them, keep the order. Row sum first: it clears most bills at once. Tax sum next: it clears most of the rest. Row math last: it is slow, but it finds the one bad digit when the first two checks point at a row. Skip a step and you will redo work. Keep the order and each bill is a short, fixed path.
Gaps that mean stop and ask
Most gaps end with a dull cause and a quick fix. Some gaps should stop the bill cold. The rule is cheap to keep: if a gap has no plain cause, the bill does not get paid till a person at the firm explains it. Watch for these flags:
- The total is off by a large sum and no line on the bill explains it.
- The bill has rows for goods or work you never got.
- The tax rate is not the rate for your state or your kind of sale.
- The bill number, bank name, or account facts changed with no word from the firm.
- The same bill shows up twice with two bill numbers.
Fake bills are not common, but they do exist, and they lean on haste. A bill that wants fast pay and can not stand a two-minute check is a bill to hold. Call the firm on the phone number you have on file — not the one on the bill — and ask. A real firm will thank you for the care. A fake one will not call back.
It also helps to have a second pair of eyes on big bills. Set a line, like any bill over a fixed sum, where a second person runs the checks too. The point is not trust. The point is that two readers rarely miss the same row, and a lone reader at the end of a long day is where most slips slip through.
What to do when you find a gap
First, find which check fails. That tells you where to look. If the row sum fails, scan the rows for one odd value. If the tax check fails, look at the tax rate and the tax sum on the bill. Most gaps show up fast once you know where to look.
If the bill came from a scan, look at the digits with fresh eyes. A soft scan can turn a 3 into an 8, and one wrong digit is a whole gap. To see how scans get read and where they go soft, read how to turn a scanned invoice PDF into Excel.
If the bill itself is wrong, ask the firm to fix it and send a new one. Do not just pay the lower sum. A short, polite note with the math works well. If the slip is in your sheet, fix the field and save again.
Last, write down what the cause was, in one short line on the bill's record. “Gap of 3.00: handling fee missed on first read.” That one line is gold later. At tax time, or in a dispute, you can show the bill was checked, the gap was found, and the cause was plain. A checked bill with a note beats a clean bill with no past.
One more habit ties it off: when a vendor's bills fail the same check twice in a row, tell them. Most firms would rather fix their bill layout than field your calls each month. A short note with one flagged bill as the case in point often ends the run of gaps at the source. You are not just fixing sums — you are teaching your pile to be cleaner next month.
Your next step
Take one bill that once gave you a gap and run the three checks. Or convert it and let the tool flag the gap for you. Check the examples to see how a flagged bill looks on screen.
Make the checks a habit, not a hunt. Run them on each bill as it comes in, while the facts are fresh and the fix is one short note. A month of checked bills is a clean book. A year of them is a tax file you can face with calm.
Sources and further reading
- Fix text recognition errors in scanned PDFs — Adobe shows how to spot and fix words a scan read wrong — one plain cause of a digit that does not match.
- Enter bills in QuickBooks Online — Intuit walks through reading a bill field by field as you key it in, which is the same care the checks in this guide call for.