This guide shows how to quickly assign unmapped fund accounts to the correct statement lines by creating simple, reusable local rules. It explains checking unmapped accounts, choosing fiscal period and statement structure, building rule conditions (like year and account code), linking those rules to statement lines, and repeating until all accounts are mapped. Follow it to streamline mapping across governmental, proprietary, or fiduciary fund statements.
Visual Step-By-Step Guide
Select Next to move through the guide. You can also zoom in and out of the image by selecting the Magnifying Glass in the bottom right-hand corner. You can view the full guide by selecting the External Link icon.
Step-By-Step Instructions
When starting to map your fund level statements, first check which accounts are in the Unmapped Accounts panel.
- Note: If needed, use the bottom scrollbar to scroll to the right to find Account Code.
After identifying which accounts need to be mapped, select the Fiscal Period to report on.
Select the Statement Structure.
Find and select the Statement Line you want to map these accounts to.
Pro-Tip: Confirm your selection by looking at the top bar on the mapping page.
Map Accounts
Select Local Rules.
To create a new local rule, select the blue plus (+) sign.
- Note: In most cases, you will simply have to add account or object codes to pre-existing rules; however, when creating a new local rule, you first have to specify which year to report on.
Select Add a row (+) button in the right-hand corner of the local rules menu.
Select the Fiscal Period under the Field column.
Under type, select equals.
In the value column, select the fiscal period you are reporting on.
Select Save and now, we can add the accounts.
Select Add a row (+) again.
Select account code in the Field column.
In the Field column, select equals.
- Note: If you have a series off accounts to add to a line, you can utilize the Starts with condition.
Select your desired account in the Value field.
Select Save.
Select OK when you are complete adding conditions to this local rule.
Repeat for all unmapped accounts and select the chain icon on the Local Rules tab to link accounts using your newly created rule.
Have more questions or need assistance?
Submit a Request