Why your QuickBooks invoice is off by a cent

The order says 262.25. The invoice QuickBooks made says 262.26. One cent. It’s tempting to ignore it, but cents add up across a few hundred orders, and they make deposits and reconciliations come out slightly wrong in ways that are hard to trace.

Where the cent comes from

Almost always it’s rounding, done in a different order:

Per line or per invoice. A store can work tax out on each line and round each one, then add them up. QuickBooks works tax out on the taxable total and rounds once. Two lines at 0.125 each round to 0.13 + 0.13 = 0.26 one way, and to 0.25 the other.
Several rates. With a state rate and a county rate, QuickBooks rounds each rate separately. A store that rounds the combined rate can land a cent away.
Discounts spread over lines. A coupon divided across lines leaves fractions of a cent that one side rounds up and the other down.

When to absorb it

A difference of a cent or two that comes from rounding is not an error to fix; it’s an artifact to record. The clean way is a small rounding line on the invoice, on its own item, so the invoice equals the order exactly and the rounding is visible in one place you can report on.

When it’s not rounding

A bigger difference is a symptom, not a rounding artifact:

The tax rate differs between the store and QuickBooks (often after a rate change one side didn’t get).
Part of the order was paid with a gift card or store credit that isn’t on the invoice lines.
A product paired with a QuickBooks group item whose members are taxed differently from the product.

Absorbing those into a rounding line hides a real problem in your sales tax.

Draw the line in advance

Decide how much rounding you’ll accept before you see the differences, not after. A sensible rule is a cent per taxed line per tax rate, with a firm ceiling. Anything over the line should stop and be looked at.

In NemoWorks Sync

That is exactly the rule it uses: a rounding line of up to 1 cent for each taxed line and each tax rate (at least 2 cents, never more than $1.00), and anything larger stops the order before the invoice, with QuickBooks’ tax and the store’s side by side in the message. When an order doesn’t match shows an example.