Resolve rounding differences in financial statements

Keep the underlying trial balance and supporting schedules at their source precision. Decide separately how the statements will display amounts, such as whole currency units or thousands. Record the convention in the report and apply it consistently. A display difference should not become an accounting entry solely to make a printed table add.

Distinguish actual rounding from a missing amount. Compare the unrounded source totals first. If they disagree, investigate the data or mapping before applying a presentation adjustment. A large difference can look small after scaling, and an unexplained difference of one displayed unit can still represent a genuine posting problem.

Rounding individual rows and then adding them can produce a different result from adding exact values and rounding the total. In a hypothetical table shown in whole dollars, two amounts of $1.40 each display as $1 and $1. Their exact total of $2.80 displays as $3. Both calculations follow a rounding operation, but they create different visible expectations.

Agree a presentation policy with the statement preparer. If a displayed rounding allocation is used, keep it in the reporting layer, document the affected line, and avoid obscuring a material category. If the report instead retains a small addition difference with an explanatory convention, confirm that the intended users and applicable reporting requirements permit that approach.

Use the same underlying amount and rounding convention wherever a value repeats. A debt total in a note, a statement, and commentary should not vary because one author rounded an already rounded subtotal. Calculate percentages from the approved underlying values unless the report explicitly defines another method. Preserve enough precision to explain the displayed result.

In an illustrative report, $49,600 divided by $100,400 is about 49.4%. Dividing displayed amounts of $50,000 by $100,000 instead gives 50.0%. The difference comes from the input precision. State the report's unit and avoid recalculating ratios from simplified display figures when the full amounts are available.

ICAEW recommends checks that expose inconsistencies within financial spreadsheets. For a statement workbook, retain one check for exact source agreement and another for displayed addition. A single zero-check cannot tell a reviewer which precision it tested.

Label any manual display allocation and protect it from becoming part of the next period's opening balance. Where a workbook automatically distributes differences, review the rule and test a small example. The allocation should remain identifiable after amounts change, including when a line becomes zero or changes sign. Avoid placing the difference in an unrelated account without explanation.

Review the exported statements for units, decimal places, parentheses, and zero conventions. A label saying amounts in thousands should cover the intended tables and should not accidentally apply to share counts or percentages. Check comparative columns at the same scale and verify that notes use the same currency convention as the statement they explain.

Retain the exact source totals, the approved display approach, and any allocation record with the final package. If a recipient asks why rounded components differ from a total, the preparer should be able to reproduce the difference without adjusting the ledger. An unexplained amount that exceeds the expected rounding range should return to the accounting investigation.