A difference of 0.0000001 is not a reconciling item. It is a formula problem.
Excel stores numbers in binary, so some decimal values are held very slightly inaccurately, and formulas that multiply or divide create long decimals. Round each calculated line with ROUND to two decimal places where the real amount is in cents or pence, compare rounded totals, and use a small tolerance only for display, never to hide real differences.
Excel stores numbers in a binary format that cannot hold some decimal values exactly. A sum of many values with cents can end up as 1234.5600000001 instead of 1234.56. The cell displays 1,234.56, but a check like =A1=B1 returns FALSE, and a difference column shows 0.00 while not actually being zero.
The second source is calculation: VAT or sales tax at a percentage, currency conversion, or allocations split by percentage produce values with many decimal places. Each line is then a fraction of a cent away from the amount the ledger or bank actually recorded.
Where the real-world amount is in cents or pence, round the calculation where it happens:
=ROUND(B2*C2,2)
Round each line, then total the rounded lines. That matches how invoices and ledgers work: each line is a real amount, and the total is the sum of real amounts. Rounding only the total can leave the lines summing to something slightly different.
For a reconciliation check, compare rounded totals:
=ROUND(SUM(LedgerAmounts),2)-ROUND(SUM(BankAmounts),2)
This returns exactly zero when the totals agree to the cent, so a status cell can test for zero reliably:
=IF(ROUND(D2,2)=0,"Agreed","Difference")
When you split an amount across cost centres by percentage, the rounded parts may not add back to the total. Calculate every part except the last with ROUND, and make the last part the balance:
Last part: =Total-SUM(previous rounded parts)
The allocation then always adds back to the cent, and any rounding lands in one predictable place.
Some teams treat any difference under a small amount as agreed. That is reasonable for genuine rounding on currency conversion, but a tolerance applied to the total can hide two real errors that almost cancel out. If you use one:
Avoid the "Set precision as displayed" option in Excel. It permanently changes stored values across the whole workbook and cannot be undone. Rounding in formulas is visible and reversible.
A difference that is a round number, or exactly the size of one transaction, is not rounding. Investigate it as a reconciling item. See reconciling items.
The behaviour is the same in every country. Tax rules on rounding VAT or sales tax (per line or per invoice) differ; check the current rules from HMRC, your state or your local tax authority before deciding which method your invoices follow.
Reviews every balance sheet reconciliation with an on-device AI and 20 review tests, flags vague and wrong-account reconciling items, and builds a risk-ranked review queue. Runs in your browser on your own computer: nothing is uploaded.
Paste or upload your invoice list and see likely duplicates in seconds. Runs in your browser; nothing is uploaded.
The Balance Sheet Reconciliation Library covers the balance sheet with nine working papers: a known error blocks sign-off, every supported balance needs an evidence reference and every aged item needs an owner and a next action. Excel, no macros, one-time price.
The value is a tiny fraction such as 0.0000000001 that displays as 0.00. Compare rounded values with ROUND(value,2).
ROUND follows normal rounding rules and matches most systems. Use ROUNDUP or ROUNDDOWN only where your policy or a system you are matching does the same.
MROUND rounds to a multiple, for example to the nearest 0.05 where cash rounding applies. For cents and pence, ROUND to 2 decimals is enough.
Last updated 04 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.