Profit is an opinion; cash is a fact. A business can show a profit on paper and still miss payroll because a big customer pays in 60 days and the rent is due in 10. A cash flow sheet is the one piece of finance every owner should look at weekly, and it takes a spreadsheet, not an accountant.
Thirteen weeks is a quarter: far enough to see trouble coming, near enough to be accurate. Each column is a week; each row is money in or out. The bottom line is your bank balance at the end of each week — and if it dips below zero in week nine, you know today.
| Section | Rows |
|---|---|
| Opening balance | Cash in the bank at the start of the week |
| Money in | Card and cash sales · Invoices due to be paid · Other income (grants, refunds, loans) |
| Money out | Rent · Wages · Suppliers and stock · Software and subscriptions · Marketing · Loan repayments · Tax set aside · Owner's pay |
| Net | Money in minus money out |
| Closing balance | Opening + net — becomes next week's opening |
Describe the sheet and it appears, formulas and all:
"Build a 13-week cash flow spreadsheet starting next Monday. Rows: opening balance, card sales, invoice payments, rent 2,500 on the 1st, wages 6,000 every 4th Friday, suppliers 1,800 weekly, software 320 monthly, loan 900 monthly, tax set-aside 15% of sales, owner pay 2,000 monthly. Opening balance 9,400. Average weekly sales 4,200, 20% lower in weeks 6–8. Highlight any week where the closing balance is below 5,000."
Each week, paste in your actual figures and ask it to roll the sheet forward and flag what changed. Export your bank statement and let it categorise the transactions.
No. A budget is what you plan to spend over a year. A cash flow is when money actually moves. You need both, but the cash flow is the one that stops surprises.
It is excellent for what has happened. The 13-week sheet is about what is coming, and it is yours to look at every Monday.
Volnyn's AI Spreadsheets build the sheet from a description, update it from your statements and explain the numbers in plain language. Start free at volnyn.com.