Skip to main content
All CollectionsSupport IssuesTroubleshooting
Active L&R - Totals don't match sum of rounded numbers
Active L&R - Totals don't match sum of rounded numbers
Updated over a month ago

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?