Cash Inflows
| Category |
|---|
| Total Inflows |
Cash Outflows
| Category |
|---|
| Total Outflows |
Weekly Summary
| Metric |
|---|
| Net Cash Movement |
| Closing Cash |
Cash Trajectory
Line shows closing cash. Bars show inflows and outflows.FAQs
How is closing cash calculated?
Closing cash equals prior closing plus current net movement. Net movement equals total inflows minus total outflows for that week. Week one starts from the opening cash you set above.
Can I change week dates?
Yes. Pick a start date then press Apply Dates. Labels update across all tables. Calculations still run on twelve consecutive weekly periods from that start.
How do I add custom categories?
Use the Add inflow or Add outflow button. Enter a short name. A new row appears with editable cells for all twelve weeks. Values are included in totals automatically.
What if I need to model taxes or payroll timing?
Enter specific amounts in the weeks those items occur. You can keep zeros where no payment or receipt happens. The model sums across categories each week.
Can I save my work?
Click Save Locally to store your forecast in the browser. Click Load Local to restore it. You can also export a CSV for sharing or backup.
Why does my closing turn negative?
This indicates a cash shortfall. Consider moving receipts earlier reducing outflows arranging short term financing or adding new funding to maintain a positive balance.
Is this a substitute for full budgeting software?
This tool focuses on near term cash timing and visibility. It complements but does not replace full financial planning general ledger records or statutory reporting.