Mapping / Grouping Balances worksheet
View the current and prior year adjusting entry amounts for each map and group number. To access the worksheet, on the ribbon, click Account | Mapping/Grouping Balances.
Note: Calculated map numbers are not included in the totals.
Column | Description |
---|---|
Entity | Select the entity where the map/group number belongs. This column only displays in consolidated files. |
Number | Displays the map or group number assigned in the Mapping database or Grouping database. |
Name | Displays the name of the map/group number. |
Total before Map Adj |
Displays the final balance of the map/group number including consolidated balances and adjustments, but not including adjustments made directly to the map/group number. As map/group numbers contain amounts posted to the accounts assigned to them, adjusting entries made through the chart of accounts Trial Balance are included. |
Map Adjustments |
Displays the adjusting entries made directly to a map/group number without going through the chart of accounts. Double-click a map/group number in this column to see adjustment detail. |
Final | Displays the final adjusted balance for the map/group number. |
Prior Year 1-4 |
Displays the prior balance for each map/group number (for up to the last 4 years). |
Budget Year 1-5 |
Displays the budget balance for each map/group number (for up to the next 5 years). |
Forecast Year 1-5 |
Displays the forecast balance for each map/group number (for up to the next 5 years). |