QBO Financial Statement Forecast
Many Small Business Owners utilize QuickBooks Online as an accounting solution for their financial and tax reporting. The basic subscription does not include an embedded forecasting tool which is a common expectation of small business owners who require assistance with interpreting their financial statements. This program utilizes the QuickBooks Accounting API to forecast a year-end Income Statement (P & L) and statement of cash flow using the seasonal naive + growth method — a simple, explainable approach suited for CFO-style reporting rather than a statistical/ML model.
How it works
Pulls monthly actuals from the QuickBooks Online Reports API for both the prior year (Jan–Dec) and the current year (Jan through the last fully closed month), for Profit & Loss and Cash Flow.
For each line item, calculates a year-over-year growth factor: this year's year-to-date total ÷ the same months' total last year.
Projects each remaining month of the current year as: last year's actual for that month × growth factor. This carries forward whatever seasonal shape existed last year (a slow Q1, a Q4 spike, etc.) while scaling it to how the business is actually trending this year.
Falls back to a flat run-rate (average of this year's actual months) for any line item with fewer than 3 months of prior-year data in the forecast window — this keeps sparse or newly-created accounts from projecting to zero.
Outputs interactive actual-vs-forecast charts (Plotly) for Total Income, Total Expenses, and Net Income, plus key Cash Flow metrics, and a full-year summary table comparing the forecast total to last year's actual.