​
Overview

Francis relies on actuals data from your ERP. After closing the books each month, import this data into Francis to streamline your FP&A processes, including:

  • Importing new actuals data

  • Controlling

  • Re-forecasting

  • Analyzing variance

  • Creating management reports

​
Basics

​
Importing New Actuals

  1. Sync your connections (bottom left) to import your journal entries.

  2. Set Last close to the most recent closed month. This ensures Francis includes the latest actuals.

​
Controlling

Start by comparing forecasts and actuals to identify the largest variances. Then drill down into details, from forecast values to actual entries, to pinpoint the root causes.

Use the three toggle buttons to explore different views:

  • Compare: Displays the difference between forecast and actuals

  • Follow-up: Shows actual values

  • Transactions: Shows journal entries behind the selected cell

Viewing actuals on a month-by-month basis helps you spot trends and quickly address any discrepancies, such as bookkeeping errors.

​
Re-Forecasting

After reviewing and controlling your actuals, update the Forecast Start date so Francis replaces forecast values with the newly imported actuals. You can then adjust your forecasts as needed and save the updated version for later reference.

​
Variance Analysis

Open the Reports view to conduct variance analyses for the last month, year-to-date, and full year. Compare budgets, forecasts, actuals, and previous year’s actuals. You can configure which budget and forecast versions to reference. Charts are also available to visualize differences across various versions.

​
Management Reports

All month-by-month views, charts, and variance analyses can be exported as PDF packages for easy sharing and presentation.