You are here: Help Topics > Engagements > Mapping and grouping > Mapping database

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.

  • Balance Sheet (B)
  • Income Statement (I)
  • Statement of Cash Flow (S)
  • Performance (P)

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:

  • Current: Apply the foreign exchange rate of the current active period to the year-to-date balance. Previous rates are ignored. Current is the default foreign exchange rate for Balance Sheet and Performance accounts.
  • Historical: Apply the foreign exchange rate of each period to each period balance, then total all twelve periods. Historical is the default foreign exchange rate for Income Statement accounts.
Behavior

Select the mapping behavior:

  • Normal: Accounts can be assigned to the map number.
  • Calculated: Perform a calculation for accounts that have a calculated behavior in their map number. Individual accounts cannot be assigned to a calculated map number.
  • Unassignable: Accounts cannot be assigned to the map number. This will not affect sub map numbers, which must be changed individually.
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:

  • Corporation
  • S Corporation
  • Partnership
  • Non-Profit

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:

  • Corporation
  • S Corporation
  • Partnership

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:

  • The CS column represents a Statement of Cash Flow account number (account number format: S##). With this Statement of Cash Flow number intact, all credit amounts for the Balance Sheet or Income Statement account will automatically update the Statement of Cash Flow account.

If you've set the Type column to Statement of Cash Flow:

  • Active period (closing) balance (A): Calculate the balance using the active period (closing) balance of the Balance Sheet or Income Statement account.
  • Active period (closing) balance - negative (AN): Calculate the balance by reversing the active period (closing) balance of the Balance Sheet or Income Statement account.
  • Difference between active and prior period (D): Calculate the balance using the difference between the active and prior period balances of the Balance Sheet or Income Statement account.
  • Difference between active and prior period - negative (DN): Calculate the balance by reversing the sign of the difference between the active and prior period balances of the Balance Sheet or Income Statement account.
  • Prior period (opening) balance (P): Calculate the balance using the prior period (opening) balance.
  • Prior period (opening) balance - negative (PN): Calculate the balance by reversing the sign of the prior period (opening) balance
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:

  • The DS column represents a Statement of Cash Flow account number (account number format S##). With this Statement of Cash Flow number intact, all debit amounts for the Balance Sheet or Income Statement account will automatically update the Statement of Cash Flow account.

If you've set the Type column to Statement of Cash Flow:

  • N/A: You must enter the opening balance for the Statement of Cash Flow account in the Cash Flow worksheet. You can make adjustments to these balances as adjusting entries with a Type set to Statement of Cash Flow.
  • Automatically updated from accounts (A): Select to automatically calculate the balance of the Statement of Cash Flow account using Balance Sheet or Income Statement accounts linked to the Statement of Cash Flow account.
Tags Displays the mapping tags applied to the map number. Click + to add a new tag.