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.