21 August 2026

When your vendor's invoice total does not match the sum of the line items

Your vendor's invoice says $1,028.00. You add the lines and the tax, and you get $1,027.99.

One cent. Nothing is wrong with the document, and nothing is wrong with your adding.

This is the most common reason an invoice total does not match the sum of the line items. Sales tax was rounded in two different places on the same page.

Where the cent comes from

Line Part / SKU Qty Unit price Extended 1 BRK-4410 25 5.75 143.75 2 HSE-0912 6 14.75 88.50 3 CLM-2200 22 9.65 212.30 4 WSH-0031 165 0.29 47.85 5 TUB-8800 48 8.25 396.00 6 GKT-1145 25 2.45 61.25 Subtotal 949.65 Tax 8.25% 78.34 Total 1,028.00

Six lines, each one correct. The rows and the tax come to 1,027.99. The page says 1,028.00.

Sales tax is a percentage. A percentage of a price is rarely a whole number of cents.

So it gets rounded. The only question is when.

One accounting system taxes each line and rounds each result. Another taxes the subtotal and rounds once. Both are correct.

Tax rounded on each line 143.75 x 8.25% = 11.859375 -> 11.86 88.50 x 8.25% = 7.301250 -> 7.30 212.30 x 8.25% = 17.514750 -> 17.51 47.85 x 8.25% = 3.947625 -> 3.95 396.00 x 8.25% = 32.670000 -> 32.67 61.25 x 8.25% = 5.053125 -> 5.05 ------ 78.34 Tax rounded once, on the subtotal 949.65 x 8.25% = 78.346125 -> 78.35

The tax box on the page came from the first method. The total was built from the second.

Each line can move by up to half a cent, up or down. Most of that cancels out.

What survives is a cent or two. On a twelve-line invoice you can see it.

Why the tolerance is two cents

Every document here is checked before a number reaches you. The lines and the tax have to reach the total.

With no tolerance at all, the document above fails. It is a correct document. So there is a tolerance, and it is two cents.

A percentage would be worse, and a percentage is the obvious thing to reach for.

Rounding error does not grow with the invoice. Half a cent per line is half a cent. That is true on a $4 line and on a $40,000 one.

One tenth of one percent sounds strict. On a $90,000 invoice it forgives a $90 gap. Ninety dollars is a missing line, not rounding.

Why two cents can be said exactly

Money here is never a decimal fraction in memory. It is a whole number of hundredths.

Amounts come off the page as text, exactly as your vendor printed them. They become whole hundredths once, by integer arithmetic, at the point they are read.

So two cents means two cents. It is a count, not an approximation, and nothing drifts.

The unit is a hundredth of whatever currency your vendor billed in. Two cents on a dollar invoice, two on a euro one.

Three-decimal currencies do not fit in hundredths. A Kuwaiti or Bahraini dinar document goes to a person. It is not quietly rounded to fit.

A gap bigger than two cents is not rounding

This is the more useful half. Above two cents, stop looking for a rounding explanation.

The size of the gap usually names the cause. Start with these four.

Freight, tax or a fuel surcharge sits in the summary box rather than as a row. You added the rows and missed it.
A line is missing. Compare the last line number on one page with the first on the next.
There is a credit or return line, printed as (92.50) or 92.50CR. Add it instead of subtracting it. You are then out by exactly twice that line.
Only part of the order shipped. Your vendor billed what left the dock, and your PO still lists everything you ordered.

Do the division before you re-key anything. Halve the gap, and see whether that number is a line on the page.

If it is, you have a credit line you added instead of subtracted. If the gap itself is a line total, that line is missing or on back-order. If it matches the freight box, freight is in the summary and not in the rows.

What happens here when it does not add up

Vendors do not agree on whether freight is a row or a box in the corner. So the check tries every defensible reading of the same document:

lines, plus tax, plus freight
lines plus tax, where freight is already one of the rows
item rows only, plus tax and freight
the lines on their own

Any one of them landing within two cents means the document is self-consistent. Which one balanced is recorded rather than assumed.

Forcing a single convention would fail perfectly good documents. That sends work to a person for nothing.

If no reading lands, the check fails, and this one blocks. The whole document stops. Nothing goes to your spreadsheet, and a person sees it first.

The message names both figures and the gap between them.

Line items add up to $966.74 but the document total says $1,028.00 — a difference of $61.26.

Line 6 never arrived. The gap is that line, 61.25, plus the cent of tax rounding.

It is one of eight checks that run on every document. Not a setting, and nothing to configure per vendor.

A total that does not reconcile means one of the numbers is wrong, and this check cannot say which. So the whole document waits. A separate check compares quantity times unit price on each row, and that one names the likely cause instead — line discounts and price breaks make a gap there both common and legitimate.

Try it on the one on your desk

Take the vendor invoice you are looking at and drop it in here. Every line comes back, with the arithmetic already done. Nothing is stored and there is no sign-up.