Monthly Financial Model
Build a connected Income Statement, Balance Sheet and Cash Flow model by month.
Monthly statements · Jan–Feb 2026
Preview · Illustrative values · EUR thousandsIncome Statement
| Line item | Jan 2026 | Feb 2026 |
|---|---|---|
| Revenue | 1,080.0 | 1,080.0 |
| Net income | 143.2 | 143.2 |
Balance Sheet
| Line item | Jan 2026 | Feb 2026 |
|---|---|---|
| Total assets | 12,684.6 | 12,806.3 |
| Cash & Cash Equivalents | 3,104.7 | 3,186.7 |
Cash Flow Statement
| Line item | Jan 2026 | Feb 2026 |
|---|---|---|
| Cash flow from operations | 175.6 | 175.6 |
| Change in cash | 82.0 | 82.0 |
Free · No signup · Choose granularity in the model
Model all three statements monthly
Review monthly revenue and costs alongside receivables, inventory, debt and cash. The statements share one accounting model: a collection assumption can change the Balance Sheet and operating cash flow without changing the recorded sale. Explore the connections between the three statements before refining your forecast.
Start with an annual model and move to monthly detail
Opening a Monthly view shows values derived from the existing model; it does not replace the assumptions behind a line. To model that line directly by month, choose Monthly as its source in the modeling controls. Review the confirmation before replacing an existing source. Initialization preserves the modeled branch; subsequent monthly edits can change its economics and cash timing.
One source per modeled line
An independently modeled line has one forecast source: Annual, Quarterly, Monthly or Weekly. Its other views derive from that source. Changing the source replaces the former source setup rather than leaving two forecasts to maintain. Use Go to source to reach the controlling inputs. The model period reference explains source changes and period boundaries.
Use the detail that each business line needs
A subscription revenue line can use monthly assumptions while another business line remains annual or quarterly. Parent totals aggregate their children; a mixed parent points you to its sources. Choose modeling methods that explain each activity instead of forcing every line into the same frequency. For a shorter planning interval, explore weekly financial modeling.
Monthly results reconcile with annual results
Monthly flows sum to the annual ledger result. Balance-sheet stocks use the appropriate opening or closing boundary; margins and returns are calculated from their underlying values, not added together. Annual totals remain connected to the same model. A quarterly financial model offers a broader review interval when month-by-month detail is unnecessary.
Keep scenarios and adjustments connected
Monthly planning stays within the existing scenario and adjustment workflows. Scenario-specific source changes remain separate from Base, and inherited assumptions stay visible. Review scenario behavior before comparing cases. This is useful for budgets, hiring plans and collection timing; the financial model reference describes the wider workflow.
Frequently asked questions
Can I build a financial model by month?
Yes. Activate Monthly in the financial model and use monthly sources for supported modeled lines. Income, balance-sheet and cash-flow outputs remain connected.
Can I move an annual model to monthly modeling?
Yes. View its monthly derived outputs first, then replace selected lines’ Annual sources with Monthly after reviewing the confirmation. Other lines can keep their current sources.
Can different business lines use different granularities?
Yes. Independently modeled business lines can use different sources; parent totals aggregate their values.
Does monthly modeling create a second annual forecast?
No. Annual outputs derive from the same ledger. Flows aggregate by sum, while stocks and ratios follow their own financial measure rules.