darikwaCash · Free · Works in your browser
13-week cash flow
Enter thirteen weeks of receipts and payments to see the closing cash each week, the lowest point and the weeks that dip below your buffer, before a VAT quarter or a supplier run catches you out.
It answers
- 1.The cash balance at the end of every week for the next quarter.
- 2.The lowest point, and the week it falls in.
- 3.Which weeks dip below your buffer or into overdraft.
- 4.Total cash in and out over the period.
Settings
Lowest point
£13,400
Buffer £15,000
Weeks below buffer
2
of 13 weeks
Closing cash, last week
£69,950
from £30,000 today
Net over the period
£39,950
£305,800 in, £265,850 out
Closing cash, week by week
Closing cashBuffer
13 rows · example data, replace it with yours
| # | Week commencing | Net | Closing cash | Status | Cash in | Cash out | Opening | Customer receipts (£) | Other income (£) | Supplier payments (£) | Payroll (£) | Rent and overheads (£) | VAT and tax (£) | Other payments (£) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| £5,500 | £35,500 | OK | £18,500 | £13,000 | £30,000 | |||||||||
| -£8,550 | £26,950 | OK | £17,200 | £25,750 | £35,500 | |||||||||
| £10,450 | £37,400 | OK | £16,800 | £6,350 | £26,950 | |||||||||
| -£15,650 | £21,750 | OK | £19,400 | £35,050 | £37,400 | |||||||||
| £11,900 | £33,650 | OK | £23,500 | £11,600 | £21,750 | |||||||||
| -£19,150 | £14,500 | Below buffer | £22,500 | £41,650 | £33,650 | |||||||||
| £12,250 | £26,750 | OK | £20,100 | £7,850 | £14,500 | |||||||||
| -£13,350 | £13,400 | Below buffer | £19,800 | £33,150 | £26,750 | |||||||||
| £6,800 | £20,200 | OK | £24,600 | £17,800 | £13,400 | |||||||||
| £20,850 | £41,050 | OK | £27,900 | £7,050 | £20,200 | |||||||||
| £11,850 | £52,900 | OK | £31,200 | £19,350 | £41,050 | |||||||||
| £250 | £53,150 | OK | £34,800 | £34,550 | £52,900 | |||||||||
| £16,800 | £69,950 | OK | £29,500 | £12,700 | £53,150 | |||||||||
Take it into Excel
The download carries your rows and the same rules as live Excel formulas, so it keeps working as you add lines: yellow cells for your data, blue-grey cells calculated, drop-down lists, red and amber flags, frozen headers and filters. Tabs: Start here · Settings (opening cash, buffer) · Weeks (running balance) · Summary.
Your data never leaves this browser: nothing is uploaded, and the workbook is built on your device. Copy rows from Excel or Google Sheets and paste into any cell; include the header row to match columns by name.
Want this running on live data? Retail Loom does it over your shop platform, accounts and stock system, every day. See Retail Loom or get in touch.