Specifying the mapping rounding method
The balances for the financial statements are retrieved from the trial balance based on the mapping or grouping numbers. You can specify how the mapped/grouped balances round when inserted into the financial statements.
Procedure
- Open the Financial statements document and select the Global Setup tab
-
In the Global Setup tab, locate the Mapping rounding drop-down. This drop-down can be found in the Balances section of the tab
-
From the Mapping rounding drop-down, select the rounding method to use:
-
Add mapping numbers, then round: Add the map numbers and then apply rounding to the total. For example:
Account Value Mapped to 101 10.84 110.100 102 9.51 110.100 103 11.25 110.200 110.100 = 10.84+9.51=20.35 → 20.00
100.* = (10.84+9.51=20.35) + 11.25 = =31.60 → 32.00
-
Round each mapping number, then add: Round each map number and then add the map numbers. For example:
Account Value Mapped to 101 10.84 110.100 102 9.51 110.100 103 11.25 110.200 110.100 = 10.84+9.51=20.35 → 20.00
100.* = (10.84+9.51=20.35 → 20.00) + (11.25 → 11.00) = 31.00
- Round the total by entity: Enforce rounding by entity. Balances related to the entity are summed and then rounded.
- Round the grand total: Enforce rounding on the total of a map() or grp() function. The balances assigned to the map or group are totaled first and then rounded.
- Round each account, then add: Round each account individually. If rounding a group of accounts, each account is rounded and then the grouping is totaled.
-
Results
The selected mapping rounding method is used in the financial statements.
Note: If you are using rounding in notes and adding the balances to a table elsewhere, you may want to define linkable columns to link from the note balance directly.