Skip to main content

Active L&R - Totals don't match sum of rounded numbers

Issue: By default, the total of a financial table is calculated based on actual values and then rounded independently, rather than summing all of the rounded line items in the financial table.


​
​


​
For example, if we total the rounded numbers in the table (to the nearest dollar) from the report (2 + 3,579 + 50,115), it should equal $53,696. However, totaling the actual numbers in the GL results in $53,697, which is technically correct.
​
​Cause: By default, the total is based on actual values rather than the rounded values shown in the table.

Resolution: If the client prefers to total only the rounded values displayed in the table, they can use the bottom two fields in the rounding options section to designate a rounding account. This account will capture any (rounding) differences, ensuring that the totals match the report amounts instead of the actual amounts.
​
​


​Result: The totals will align with the displayed, rounded values, ensuring accuracy in the reported amounts.
​
​

Did this answer your question?