Manual entries

Overview

You can manually input actuals in case you need to import actuals from non-supported data sources or overwrite actuals imported from your accounting system.

Basics

Actuals overwrite

There are instances where the actuals imported from your accounting system may not perfectly represent your current financial situation. Overwriting actuals might be necessary when adjustments are required due to errors in the source data.

We recommend addressing data issues at their source. Overwriting actuals is not a sustainable solution but can serve as a short-term option to mitigate bookkeeping errors or similar issues that may obstruct your modeling or reporting efforts.

Importing actuals from non-supported data sources

Manual entries also accommodate data imports from unsupported data sources. Whether it's importing general ledger data from non-supported accounting systems or inputting actuals for drivers, manual entries ensure that all information is organized in one place, enabling unified modeling, variance analysis, and reporting.

One key example of this is assumptions and drivers, which are fundamental to forecasting. If you merely work with forecasted drivers, they can guide P&L and balance sheet forecasts. However, since you won't have actuals for your drivers, you'll only be able to do variance analysis on P&L and balance sheet items. If you input actuals for your drivers, you can go beyond the P&L and balance sheet and also perform variance analysis (e.g., budget vs. actuals) for drivers.

Due to Francis' spreadsheet-like behavior, you can copy-paste business data from other spreadsheets into Francis when manually importing actuals.