Mapping database
Use this database to create your organizations master chart of accounts.
To access the Mapping database, on the ribbon, click Engagement | Mapping. To display hidden columns, right-click a column header and click Reorder Columns.
Notes:
- Click the Report tab to access the Report worksheet.
- If you modify a map number that is already assigned accounts, you must perform an autofill on the map number in order to update the assigned accounts with property changes. To perform an autofill, click Tools | Options | Autofill. Select the applicable autofill options and click Autofill Now.
- You can copy map numbers from the database to other files using Copy Components
- If a map number's properties (e.g. Sign, Map No (Flip), Flip Type) change, the corresponding adjustment records will update in associated automatic documents. However, the Map No and Map No (Flip) must be set in a pair.
Column | Description |
---|---|
Map No | Enter a unique map number containing up to 40 alphanumeric characters. |
Name |
Enter a name for the map number. Click ... to enter an extended description. |
Title | Select to use the map number as a title in reports. You cannot assign accounts to title map numbers. Changing an existing map number to a title will unassign any assigned accounts. |
Type |
Select the type of statement where the map number is applicable.
Adjusting journal entries made directly to an Income Statement type map number will be included in the Net Income on all automatic documents that are grouped by that particular mapping. If the map number type is changed to or from Income Statement, then a full repost is completed to update the Net Income adjusting entry. |
Sign | Select a normal sign for the map number, either Credit or Debit. |
Rate Type |
Select the type of exchange rate to use:
|
Behavior |
Select the mapping behavior:
|
L/S | Select a leadsheet number where you want to display the map number. |
Class | Select the ratio class to use for calculating financial ratios, conducting analytical review, and preparing the Summary of Uncorrected Misstatements document. For more information, see Ratio classes. |
Group 2-10 | Select a group number to display this map number on the grouping schedule. The heading of the column displays the name entered for the group found in Tools | Options | Groupings. |
Tax Export Code |
Select a tax export code to assign to the map number (if applicable). |
M3 Code (USA only) | Select an M3 code to assign to the map number. |
Tx Exp Cd [Entity] (USA only) |
Select a tax export code to assign to the predefined tax entity:
Data will be exported according to the tax entity and the assigned tax code. |
M3 Exp Cd [Entity] (USA only) |
Select a M3 code to assign to the predefined tax entity:
Data will be exported according to the tax entity and the assigned M3 code. |
GIFI (Canada only) |
Select a GIFI code to assign to the map number. |
Units | If applicable, select a unit of measure for the performance account. You can create new units of measure from Tools | Options | Units. |
Map No (Flip) |
Select the applicable map number to use if an account is flipped. |
Calculation | Enter a calculation to assign multiple accounts or a range of accounts to the map number. |
L/S (Flip) | Select the applicable leadsheet to use if an account is flipped. |
Group 2-10 (Flip) | Select the applicable group to use if an account is flipped. |
Units 2 | If applicable, select a second unit of measure for the performance account. You can create new units of measure from Tools | Options | Units. |
Rate | Enter a foreign exchange rate for the map number (if applicable). |
Flip Type |
Select a display method for the flip number. For more information, see Set up flips. |
Autofill | Select to include the map number when performing an autofill (Tools | Options | Autofill). |
CS (Credit Statement of Cash Flow) |
Options in this column vary depending on the selection in the Type column. If you've set the Type column to Balance Sheet or Income Statement:
If you've set the Type column to Statement of Cash Flow:
|
DS (Debit Statement of Cash Flow) |
Options in this column vary depending on the selection in the Type column. If you've set the Type column to Balance Sheet or Income Statement:
If you've set the Type column to Statement of Cash Flow:
|
Tags | Displays the mapping tags applied to the map number. Click + to add a new tag. |