Gravity: AFR Completion Checklist

Annual Financial Report (AFR) Preparation Checklist

• Upload New Data

• Review Mapping and Adjustments

• Validate Data

• Review Pivot Views

• Refresh MDFM Imports

Upload New Data

To begin preparing an AFR, it is recommended that you have completed work on your ACFR is completed since your AFR will contain the same adjustments and rounding from the ACFR.

Reminder: The sample data file to upload to Gravity can be found in the Administration folder of any report under Data Integration Services.

Review Mapping and Adjustments

The AFR has its own set of hypercubes in the MDFM that needs to be maintained to accurately report your financial data. While implementation will have created local rules for the AFR, it is best practice to review all local rules and adjustments. All adjustments created in GF, PF and FF cubes will flow to the AFR cubes, provided they fill in the Class of Fund Groups and Global units. If additional adjustments are needed, they should be created in AFR cubes. 

Validate Data

Before preparing to review the automated tables created by the MDFM: 

1. Right click on the AFR hypercubes.

2. Click “Rollup”.

3. Repeat for every hypercube associated with the report.

4. Click on Pivot for all hypercubes. 

5. Review the table to verify that the totals are correct.

Review Pivot Views

Implementation will have already set up the pivot views in the AFR hypercubes or datasets, but it is best practice to review the pivot views to ensure they are reporting the correct information. To review the saved pivot views: 

1. Enter the AFR hypercubes.

2. Click on the chevron beside “Pivot”.

3. Change the period in saved pivot views. 

4. Review the saved views. 

Refresh MDFM Imports

To ensure that the most accurate data is present in the AFR, the MDFM Imports need to be refreshed. To refresh the MDFM imports: 

1. Click on the three dots to the right of the top-level folder.

2. Click on “Data”.

3. Then click on “Refresh MDFM Imports”.