Month-end close with Cube

After the accounting team finishes closing the books, it’s time to update your financial statements.

Cube makes preparing your month-end closing package easy by following the steps below.

1. Update source data

Because Cube maintains your data rules for consolidation and mappings, the first step is to log in to Cube to update any new accounts that may have been added in the past month.

Click on Source Data in your Cube Web Portal to get started.

1. Re-sync the connection.
2. Map new accounts to Cube Dimensions.
3. Import the past month.

Learn how to update source data.

2. Tie out the data

Compare month in the system source to Cube to capture discrepancies and ensure accuracy. If this is your first time doing this with Cube, see our article on how to tie out data.

Sometimes discrepancies may lie in formulas; while some will automatically update, others may need to be recalculated. Learn how to recalculate a Formula.

3. Make changes

Once data is tied out, next, compare the data between what you budgeted/forecasted and what actually happened. 

If any changes are being made to your plans or budgets, update the values and Publish the data back to your Cube. 

See how to publish data to Cube for detailed support.

4. Update forecast(s)

Now that your data is tied out and changes are accounted for, update any forecasts to account for changes. 

For example, if there were a change in expenses or otherwise, you'd want to update your rolling forecast.

1. From the Web portal, select Dimensions and then the Scenario tab.
2. Click Merge Scenarios to overwrite existing values with your actuals data. 

If you're tracking historical forecasts, duplicate your Scenario first. 

5. Finalize month-end close package

Now that you have everything ready to go, you're ready to package and share your updated financials.

If you have decks that include forecasts, update them to show the changes and drivers behind them. 

If you've yet to templatize your month-end close package in Cube:

1. From the Add-On, under Publish select Template and give it a name.
   • See how to create templates for quick reporting
2. Determine if you'd like to share access with other Cube users
3. Select Publish Template
4. Link or embed your workbook in your presentation
   • Instructions for Microsoft users
   • Instructions for Google users
   • Using Excel, but your deck is on Google? Open your template in Sheets, Fetch the data, and customize the layout based on your brand preferences.