With Account Mapping, custom templates can be saved and reused to highlight your key data every time.
Note: If you do not see the Financial Statements tab, Account Mapping has not yet been enabled for your portal. Please reach out to your Customer Success Manager for more information.
If you're not sure how to make your first connection, see our article Creating a New Data Collection
Once the collection completes, there are two ways to access the Account Mapping:
Within the Workspace
Two types of Financial Statements can be mapped: Balance Sheet and Income Statement. Click the Statement Type to switch between types.
Select the Reporting Period
Filter the data by Account Number, Alphabetically, or opt to remove section headers, section footers, or detail accounts.
The inverted triangle icon next to the AZ allows the user to check or uncheck the Section Headers, Section Footers, and Detail Accounts
You can also add Classifications to further customize your template.
After clicking on Add Classification, a dialog box will open. A Footer name is required, and a Header name is optional. Select Classify under and choose if either Credit or Debits are positive. Once complete, click Add.
The Mapping feature also allows moving line items to another section, reorganizing the line items, adding line items, renaming sections, and deleting line items/sections. Hovering the cursor over these icons will also provide more information.
Note: Some headers, footers, and sections cannot be deleted until they have been moved out or the line items that fall under the specific section have been deleted.
Save the template by clicking on the down arrow on the Save button to Save as template
Give the template a unique name. Be specific in the naming convention, as all templates are accessible in the portal for the firm.
The template is now ready to be used for future Balance Statements and Income Sheets in the portal! Click on the Templates button to access the templates and select the one you would like to apply.
After applying the template to the Balance Statement or Income Sheet in the portal, click the Generate Workbooks button to generate new workbooks in the Workspace
A status bar will appear at the top of the screen to let you know that new workbooks are now being generated.
When the workbooks have been generated, the status bar will let you know that they have been Successfully Completed, and a Go to revision button will show up. The newly generated workbooks can be found with the original workbooks in the Workspace.
The original workbooks will always be Revision 1, but each time the workbooks are regenerated after applying a template, the new workbooks are grouped under their new revision number
