See more

Disclosure Studio - Roll your ACFR Forward

This article is intended for: Administrators of the Disclosure Studio.

Use this article after: You have completed your ACFR reporting cycle.

Rolling your ACFR Forward in Disclosure Studio

Learn the essential steps to successfully roll forward your financial reports in Disclosure Studio.

This guide will walk you through how to roll forward your ACFR. There are six steps to do so:

Creating New Fiscal Period

To get started rolling your report forward, click "MDFM".

Inside the MDFM, select "Admin".

Select "Dimensions".

Click "Global Periods".

Select the pencil icon to edit the fiscal years for your ACFR.

Select the plus sign in the top right-hand corner of the table.
From there, enter your new fiscal year information the "Name" and "Code" columns. Once complete, click on the save icon.

Uploading New ACFR Data

After you have created your new fiscal period, click upload in the top left-hand corner and upload your financial data for the next fiscal year.

Rolling Forward the MDFM

After uploading your data, select "Roll Forwards" from the Admin menu.

Select which modules related to your report that should be rolled forward.
In this guide, we will select ACFR.

Then click "Validate".

Select "Next".

Enter in the fiscal year you are rolling from and the year you are rolling to.
Note: You can choose to rollover adjustments from one year to the next.
If you are rolling the MDFM forward for the second time, for any reason, make sure to uncheck the "Rollover Rules" box.

Ensure that the prior period is locked in this menu.

Move the fiscal year for formulas to the next year.

When complete, click "Execute".

You will see that the rollover will be completed.

Updating Pivot Views

To maintain the functionality of the pivot tables, we will need to update the pivot table dates.
To begin, select "Tables".

Select the view you want to update.

Click "Choose Fields"

Click the filter button beside Periods in the filter fields.

Deselect the prior year.

Select the current fiscal year.

Click "OK"

Click "Close"

Right click anywhere on the table.

Select "Save".
You will have to repeat these steps for every pivot view in every model you are utilizing in your ACFR.

Rolling the Report Forward

To roll the report forward, we need to navigate to the home screen of Disclosure Studio.

Select "Settings".

Select "Roll Forward".

Select the report you want to roll forward.

Then click "Next".

Click "Next".

Click the "Select period" field and select your next fiscal period.

Click "Next"

Select the pencil icon to edit the fiscal year variables.

You will have to repeat this process for as many fiscal year variables that you utilize in your report. Doing this will automate all fiscal years inside of your report.

Once complete, click "Next".

Review all details of the roll forward. To edit any fields, select the pencil icons.

Click "Execute Roll Forward".

You will see a notification that the roll forward process was initiated.

To check on the status of the roll forward, select "Activity Log" in the Settings menu.

Congratulations! You have rolled your ACFR forward.

Have more questions or need assistance? Submit a Request