Month-by-month

Overview

Comparing actual results with budgeted figures is a crucial component of the month-end closing process. Besides the traditional budget variance view, Francis also offers a detailed month-by-month comparison of actuals versus budgets. This feature specifically addresses ad-hoc queries related to variances, enabling users to use transaction drill-downs to better understand variances.

Basics

Updating Last Close

After completing the month-end closing process, update the Last Close setting to indicate your accounting system's most recently closed month. This tells Francis which months' actuals must be overlaid on your budget for comparison purposes.

To compare actuals against the budget, set the Last Close to a date that is later than the Forecast Start. Essentially, your budget needs to start before the most recently closed month in your accounting system. Otherwise, there will be no budget to compare your actuals against.

Follow-up on actuals

After updating the Last Close, you can overlay actuals onto your model by activating the Follow-up feature, accessible from the top bar in your Model view. You can switch between the follow-up view and the regular model view to compare your budget and actuals.

Activating the follow-up view will not initiate a re-computation of your rolling forecast with updated actuals. This view is temporary and only overlays actuals onto your model. You'll need to update the Forecast Start to forecast based on recent actuals. For more information, please refer to our documentation on date settings.

Compare with budget

In addition to the follow-up view, Francis supports a Compare feature, which presents a month-over-month analysis showing the specific variances from your budget. By enabling Compare, you can view discrepancies within your model, enabling you to quickly identify and evaluate differences between actuals and budget.