How to use Statement Engine: create a free 3-statement forecast

The opening BS is the balance sheet just before the forecast begins. Add cash, receivables, fixed assets, payables, debt, and equity so the linked PL, BS, and CF can start from a realistic base.

If you already have a trial balance CSV, use Import TB CSV instead of manual entry. Download the template from the import dialog if the required columns are unclear.

Opening BS date means the month-end balance used as the starting point. Forecast start is the next period. For example, if the opening BS date is 2025-12, the first forecast month is 2026-01.

Use monthly periods when cash timing matters. Use annual periods for a simpler multi-year planning view.

Choose the transaction type, period, amount, repeat count, and growth rate. Collection lag and payment lag help you model the difference between profit and cash flow.

Start with one row if you are new to the tool. Then add revenue, fixed costs, payroll, capex, loan repayment, and tax payment assumptions as your plan becomes clearer.

When a standard type does not fit, use Journal and choose a journal template. Filter by journal group, select the closest pattern, then review debit and credit accounts.

If the accounting direction feels wrong, run the forecast and check the Journals and Checks views. You can also report a journal issue from the input area.

Click Run to recalculate PL, BS, CF, projected journals, and Checks. If a BS balance or cash tie difference appears, check opening balance signs, transaction period, debit/credit direction, collection lag, and payment lag.

Roll Forward uses the latest forecast result as the next opening BS and advances the forecast start to the next period.

Web forecasting and review are free. Use Excel output when you need a file for bank submission, internal review, or archiving. The workbook includes Transaction_Rules, Projected_Journals, PL, BS, CF, and Checks.