×
Menu
  • Mapping the Trial Balance

Mapping the Trial Balance

 
Think of mapping as your firm chart of accounts.  We use mapping to bring information from the CaseWare databases into CaseView templates.  Mapping provides a constant link to the data found in CaseWare.  We cannot control the client chart of accounts, but we can control map numbers. 
 
Because we use mapping, we do not have to design reports over and over again to accommodate different client account numbers.
 
Our map numbers follow an easy to understand format: XXX.XXXX.XX.
 
 
 
For example, for the map 221.2781.15 (current portion of due to individual shareholder #1).
 
Not only does mapping provide a reliable link to CaseWare, it also allows you to control the properties assigned to accounts on the trial balance.
 
When you assign a map number to the client account (Account > Assign Mapping Numbers) the properties found in the map structure (Engagement > Mapping) are applied to the client’s accounts on the trial balance. 
 
This facilitates consistency across your client files and facilitates your firm to setting firm standards in advance which leadsheet, GIFI number, tax code, ratio code, etc. should be applied to certain accounts.
 
 

 

Map Number Sign Property

 
The map number Sign property should not be changed on the Working trial balance. Changing this property may affect the rounding of the Jazzit financial statements. Jazzit will automatically flip the debit and credit balances where applicable.
 
Ensure that all the signs are selected as follow:
 
Map number
 
Sign
1xx.xxxx.xx
Assets
Debit
2xx.xxxx.xx
Liabilities & Equity
Credit
3xx.xxxx.xx
Revenue
Credit
4xx.xxxx.xx
Cost of Sales
Debit
5xx.xxxx.xx
Expenses
Debit
8xx.xxxx.xx
Tax & Other
Debit