With Account Mapping, you now have the ability to create custom templates that can be saved and reused to highlight your key data every time.
If you're not sure how to make your first connection, see our article Creating a New Data Collection
1. Once your collection completes, you can click on the date to open up the page that contains the workbooks that Strongbox generated for you
2. There is a tab in the top right titled "Financial Statements" and you can click here to view the Income Statement and Balance sheets and interact with them right in your Strongbox portal.
Note: If you do not see the Financial Statements tab, Account Mapping has not yet been enabled for your portal. Please reach out to us for further details on adding this feature!
3. There are two types of Financial Statements that you can interact with and those are the Balance Sheet and the Income Statement. You can find those under the Statement Type drop-down.
4. You can choose to create a template using your Balance Sheet or your Income Statement.
5. You can filter your data by Account Number, Alphabetically, or you can opt to remove section headers, section footers, or detail accounts.
6. When you click on the inverted triangle icon next to the AZ, you can now check or uncheck the sections you'd like to keep/remove.
7. You can also add Classifications to further customize your template.
8. After clicking on Add Classification, a dialog box will open where you are only required to name your Footer but you can also opt to notate a Header, choose where you'd like to place your new classification, and choose if Credits or Debits are positive.
9. The Mapping feature also allows you to move line items to another section, reorganize the line items, add line items, rename sections, and delete line items/sections. Hovering your cursor over these icons also will tell you what they do!
TIP: Some headers, footers, and sections cannot be deleted until you have moved out or deleted line items that fall under the specific section.
10. Now you're ready to save your template so click on the down arrow on the Save button to Save as template
11. You're able to name your template whatever you like but depending on your organization, we recommend being specific in your naming convention since you will have access to all of the templates saved in your portal.
12. Your template is now ready to be used for future Balance Statements and Income Sheets in your Strongbox portal! Click on the Templates button to access your templates and select the one you would like to apply.
13. After applying your template to your Balance Statement or Income Sheet in your Strongbox portal, you can click the Generate Workbooks button to generate new workbooks in your portal
14. A status bar will appear at the top of your screen to let you know that new workbooks are now being generated.
15. When your 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. You can also find your newly generated workbooks with your original workbooks in your collection.
15. Your original workbooks will always be Revision 1 but each time you regenerate workbooks after applying a template, your new workbooks are grouped under their new revision number
