Fill in these first
- Business and currency: [e.g. wholesale garment trader, INR]
- Opening cash balance and start date: [amount, date of week 1]
- Minimum cash to keep: [the buffer you never want to go below]
- Expected receipts: [customer payments with amount and expected week, typical delay in collecting from customers, other income]
- Expected payments: [salaries, rent, supplier payments with due dates, loan EMIs, tax payments, bonuses, one-time purchases]
- Credit available: [overdraft or credit line limit, or none]
Task
Build a 13-week cash flow forecast and show where the business will run short.
Output format
- | Week | Week starting | Opening cash | Receipts | Payments | Net flow | Closing cash | Below minimum? |
- Weeks below the minimum or negative, with the main cause for each.
- Assumptions list: every timing and amount that was estimated rather than given.
- Actions to close each gap, such as chasing a named receivable, moving a payment date, or drawing on credit, with the cash effect of each.
- A CSV version of the table in a code block for pasting into a spreadsheet.
Rules
- Closing cash of one week is the opening cash of the next; check that the chain is unbroken.
- Use only amounts and dates from the inputs; mark any estimate clearly.
- Receipts land when cash is expected in the bank, not when the invoice is raised.
- Do not give tax or legal advice; list tax payments only as provided.
Example
Week 6 | 9 Nov | 3,10,000 | 1,20,000 | 4,85,000 | -3,65,000 | -55,000 | Yes, Diwali bonus and supplier payment fall in the same week






