This guide shows how to map accounts to a Government-Wide Statements line by line, ensuring your fiscal period and activity type (functions/programs) are correctly assigned. It walks you through creating or editing local mapping rules, adding conditions (like fiscal year and statement structure), saving those conditions, and linking accounts to the chosen statement line. Follow it to ensure accurate, auditable mapping that distinguishes between net position and activities reporting.
Video Overview
This video overview will walk you through mapping the Statement of Net Position.
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.
This step-by-step guide will walk you through mapping the Statement of Activities.
Note: Similar steps can be utilized for both the Statement of Net Position and Statement of Activities. However when it comes to the Statement of Activities, consider the following:
- Consider if the formula for Net (Expense) Revenue needs to be added if new function or fund appears (copy from previous line and update arguments).
- If everything is mapped, but there is still a difference in the Statement of activities check that Beginning balance for Net Position in Reconciliation (R.1.04.03.01) matches prior year Reconciliation to Statement of Net Position from published ACFR.
Step-by-Step Instructions
To start mapping your Government Wide Statement of Activities, select "Map" in the appropriate section.
Select a Statement Line
In the mapping menu, select the statement line you want to map to.
Once you have select the statement line, click "Functions/Programs" and select the type of activity these accounts qualify as.
- Note: This is an important distinction between the Government Wide Statement of Net Position and the Statement of Activities.
Having select the activity type, select "Periods" and choose the fiscal year you are reporting on.
Once you have select the statement line, the activity type, and fiscal period. You will see this confirmed in the top right-hand corner.
Map Accounts
Select "Local Rules" to begin mapping these accounts. Here, you can either edit an existing rule to include the new statement lines or accounts.
Select the blue plus sign in the top right-hand corner.
Select the plus sign to add a condition.
Build a Condition
For your first condition, start by referencing the year. Select the fiscal period field.
Select the appropriate year in the value field.
Select the Save (floppy disc) icon to save this condition.
Add another condition by selecting the plus sign again. This time we will set the Statement Line to reference.
In the field drop down menu, select a item that has the Statement Structure in the title.
Select the "equals" condition.
Select the Value field and select the statement line you want linked to this line.
Save the line by clicking on the floppy disc icon.
When satisfied, click "OK".
Finalize the Mapping
Build conditions as many times as needed. To finish linking the accounts to the line you have select, click on the chain icon.
Have more questions or need assistance?
Submit a Request