How to create a free 3-statement forecast in browser
This guide explains how to create a free 3-statement forecast in browser and how this differs from exporting Excel output. If your goal is “how can I create a free three-statement forecast,” this is the fastest on-ramp.
1) What this tool is for
Statement Engine is a web-native workflow to build linked PL (profit and loss), BS (balance sheet), and CF (cash flow) for business planning. The forecast logic runs in the browser-driven flow, while Excel output is provided as a paid product.
2) Quick setup: from opening BS to forecast start
Step 1: Enter opening balances
Add account lines in the Opening BS area. Assets should generally be positive. Liabilities and equity are typically negative, but consistency matters more than sign preference as long as your input is internally aligned.
Step 2: Set forecast start
Select the opening BS date and forecast start date. The tool auto-advances to the month after the opening balance month for forecast periods, which is suitable for most operational planning.
3) Add transaction logic (free web step)
In “Transaction” input, set:
- Transaction type (revenue, expense, payroll, capex, loan draw, debt payment, tax payment, journal)
- Month
- Amount, repeat count, and growth
- Lag settings for collection / payment timing
This is the “how to run a three-statement forecast in browser” workflow. You do not need Excel to perform this setup.
4) Read the linked result
How to run a three-statement forecast
Open the model, fill at least one transaction line, then click Run. The linked PL-BS-CF tables are generated together, and mismatches can be checked from the Checks view.
How to run scenario planning without advanced accounting
Start with one transaction row and one base scenario. You can then duplicate rows with different months to compare scenarios quickly.
5) Common questions
Can I use this without Excel?
Yes. The whole process is usable in the browser. Excel output is needed only when you want to keep a formula-linked workbook.
Can I import a trial balance CSV?
Yes. You can import trial balance CSV after entering opening balances or use manual input. For mapping details, use the CSV guide.