A 13-week cash calendar is one page with thirteen rows: each week gets an opening balance, the money you expect in, the money you must pay out, and a closing balance. You build it from your invoice terms, not from your bank balance, and you update it every Friday. It answers one question — which week do I run out — and it answers it before the week arrives.
Thirteen weeks is not arbitrary. It is the length of a quarter, it is longer than most overdue invoices stay overdue, and it is short enough to be roughly accurate. A twelve-month forecast is guessing; a weekly plan for three months is arithmetic.
Why your bank balance is the wrong starting point
The balance in your account today tells you what has cleared. It does not tell you that a $9,000 invoice due in eleven days will land on day nineteen because that client always pays late, and it does not tell you that payroll leaves on the 15th whatever happens. Owners who manage from the balance discover the problem on the day it arrives. The calendar moves that discovery forward by three to five weeks, which is exactly the window in which you can still do something.
The rule that makes it work: money counts in the week it lands, not the week you invoiced it. If your terms are net 14 and the client reliably pays on day 24, then day 24 is the week. Anything else is a wish with a date on it.
Build it in six columns
| Column | What goes in it |
|---|---|
| Week | The Monday date. Thirteen of them. |
| Opening | Last week’s closing figure. Week 1 is your cleared cash today. |
| In | Invoices you expect to land this week, using that client’s real payment behaviour. |
| Out | What leaves this week: payroll, rent, suppliers, card payments, tax set-asides. |
| Closing | Opening + In − Out. This is the number that matters. |
| Note | One line on the biggest assumption in the row. |
A worked example, with every number made up
The figures below are an example, not a benchmark. Your job is to replace them with yours; the arithmetic is the part worth copying.
| Week | Opening | In | Out | Closing |
|---|---|---|---|---|
| 1 | $8,000 | $2,400 | $6,100 | $4,300 |
| 2 | $4,300 | $0 | $1,900 | $2,400 |
| 3 | $2,400 | $0 | $2,050 | $350 |
| 4 | $350 | $0 | $6,400 | −$6,050 |
| 5 | −$6,050 | $9,000 | $1,800 | $1,150 |
Read week 4 again. The month looks fine on average — money in over five weeks is $11,400 against $18,250 out is still negative, but the shape is the point: the hole is one week wide, and it is caused by a single $6,400 payroll landing one week before a $9,000 invoice clears. Two fixes exist and neither is “sell more”: move that invoice’s due date earlier by asking for a deposit, or move the payroll date by a few days if your pay cycle allows it. Both are visible only because the row was written down.
That is the whole return on the exercise: it turns a bad month into a bad Wednesday you can plan for.
Three rules that keep it honest
- Book receipts when they land. Use each client’s actual payment history, not your terms. If you do not know their history yet, put the money one week later than the terms promise.
- Group outflows by certainty. Payroll, rent and tax are certain. Supplier payments and card balances move. Put the certain ones first and let the uncertain ones absorb the plan.
- Update it on a fixed day. Friday afternoon, ten minutes. A cash calendar that is a month stale is worse than none, because you will trust it.
What it does not do
It is not a profit statement. A week can close positive while you are losing money, and a week can close negative while you are profitable — the second is the normal state of a growing business with slow-paying clients. If you want the profit question, that is a different page: costs and pricing, not timing.
It also does not replace a bookkeeper. It replaces the feeling of being surprised.
The Friday checklist
- Thirteen rows, dates on the left, nothing older than a week.
- Every expected invoice tied to a client name and that client’s real pay pattern.
- Payroll, rent and tax set-asides in the week they leave, not the month.
- The first negative closing balance identified, and one action written next to it.
- One sentence at the bottom: the single assumption that would break this plan if it were wrong.
If the last one is hard to write, the plan is guessing somewhere you have not looked.