Actuals Import
This article explains how to import historical actuals from QuickBooks Online into a Model Reef model after you have mapped the Chart of Accounts, and how those actuals populate your variables and statements.
You will learn how to:
Select the import date range and frequency.
Pull actuals per account, per period.
See how those actuals become Data Library series and variables.
Combine historical actuals with forward forecasts.
Choosing the actuals date range
In the QuickBooks integration panel:
Select Import Actuals.
Choose a start date and end date for the historical data you want.
Confirm the frequency to match your reporting (usually monthly).
Typical usage:
For an initial model build, import several years of history.
For updates, import from the end of the last import up to the current month or last closed period.
Pulling actuals from QuickBooks
When you run the import, Model Reef:
Requests trial balance or equivalent account level data from QuickBooks for the selected date range.
Computes per period values for each mapped account.
Builds a time series of actuals for each account.
These time series are then written into the Data Library as structured series with consistent units and frequency.
No changes are made in QuickBooks. The integration only reads data in for modelling purposes.
Creating and updating variables from actuals
For each mapped account, Model Reef will either:
Create a new variable if no variable exists yet for that account mapping.
Update an existing variable that is already linked to the account.
Each variable will:
Be placed in the branch chosen during COA mapping.
Use the variable type mapped from the QuickBooks account type (Revenue, COGS, Opex, Staff, Asset, Liability, Equity, Tax, Dividend).
Use the mapped categories and subcategories for reporting.
Reference the Data Library series that now holds the historical actuals.
Once created or updated, these variables immediately feed into:
P&L (historical actuals).
Balance Sheet (opening balances and flows).
Cashflow Statement and Cashflow Waterfall, via the timing engine.
Blending historical actuals with forecasts
With historical actuals in place, you can:
Set a model start date and horizon so earlier periods contain actuals.
Attach forecast logic (drivers, growth, seasonality) for periods beyond the imported range.
Allow Model Reef to blend historical and forward periods for each variable.
A typical pattern is:
Historical actuals populate from the import start date up to the most recent closed period.
From that point forward, modelled assumptions drive revenue, costs, assets, liabilities and tax.
Charts and reports display a continuous series combining both segments.
You can also set up scenarios that start from the same historical base but diverge in their forward assumptions.
Validating imported actuals
After each import, validate that the data matches QuickBooks by:
Comparing total revenue, key expense lines and net income for a sample month or quarter.
Checking key Balance Sheet lines such as cash, receivables, payables, loans and equity.
Looking at the Cashflow Statement and Waterfall to ensure the overall pattern aligns with expectations.
If there are differences, check:
COA mappings (type, category and branch).
Date range selection.
Whether any QuickBooks adjustments were made after your export or front end report generation.
You can adjust mappings and rerun the import for the affected period if needed.
Updating actuals over time
To keep your model updated with QuickBooks actuals:
Periodically rerun Import Actuals with a new end date (for example each month after close).
Model Reef will append new periods and update existing series if QuickBooks history has changed.
Auto created variables and linked statements will update automatically.
Forecast assumptions remain unchanged unless you decide to revise them in light of the new actuals.
Related articles
Last updated