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.

How to Use

Written documention on this is coming, at the moment consult the video above, which covers how the actuals section in the Forecast sheet works in detail, and read the notes in the model itself for line-by-line instructions.

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.