Using Actual Financials

How the models uses historical financials to create budget variances and rolling forecasts.

The Starter Financial Model, Standard Financial Model, and all Standard model variants offer the ability to pull in actual financial results from your accounting software and use it to create budget variances and rolling forecasts. The templates do not require historical financials, but if you have historical results you can use them to (a) create forecasted financials and (b) model budget variances from actuals.

How to Use

The video above covers how the actuals section in the Forecast sheet works in detail, and additional line-by-line instructions are in the model itself.

Common Modifications

You can use the model with or without using historical financials, it's purely optional. Initial setup to use actual results from your accounting software typically takes one hour. Once the model is setup to use actual results, it should take 15 minutes to roll over the forecast each month with new financials.