A good sales month can still be a difficult cash month if clients pay after your bills fall due. An irregular-income tracker should therefore answer a timing question: what happens to cash if this payment arrives later?
Use bank transactions for money already received and paid. Keep expected client receipts in a separate planning table, then build a weekly view that you can change without altering the bank record.
This worked example shows £2,000 of opening cash falling to £600 in a delayed-payment scenario. That early warning is more useful than a monthly average that hides the low point.
Reviewed on 1 November 2026. Figures are illustrative and are not recommended reserve levels or personalised financial advice.
Keep observed and planned numbers distinct
| Number | Example | Source |
|---|---|---|
| Actual receipt | £900 received from a client | Posted bank record |
| Expected receipt | £1,500 expected next week | Invoice and client information |
| Reserve allocation | £700 set aside for known obligations | Your planning decision |
| Cash balance | Money held at the review point | Verified account position |
Start with a cautious baseline
MoneyHelper's irregular-income guidance suggests planning around a low-income month, understanding essential outgoings and looking ahead to uneven costs. Use that principle to choose your assumptions; do not turn your best month into a guaranteed forecast.
Review enough history to understand the pattern. A new UK bank connection may only provide a recent window, so supplement it with appropriate bank exports if you need an annual view.
List obligations separately from optional spending. Keep business and household money clearly identified, and include any amounts already reserved for known commitments. This tracker does not calculate your tax liability; use your accountant or the relevant official calculation for that input.
Build the Excel input tables
Use the BankSync Excel integration to deliver source records to a OneDrive workbook. For UK accounts, confirm connection coverage and history in the UK bank guide.
Create a separate Expected receipts table with client, invoice reference, remaining amount, expected date, confidence note and payment status. An invoice date and an expected cash date are different fields.
When a payment arrives, link or reference the bank record and reduce the outstanding expected amount. Otherwise the forecast can count both the actual receipt and the still-open expectation.
Use a third table for planned outflows. Keep due date, amount, currency and owner visible. Do not mix a planned payment with a posted payment without a clear actual-versus-forecast rule.
Build a weekly cash view
Choose the review date
Start from a verified cash position for a clearly defined account scope.
Bucket future receipts
Place remaining expected payments into the week you currently expect to receive them.
Bucket future outflows
Place obligations into their expected payment weeks.
Roll cash forward
Closing cash equals opening cash plus receipts minus outflows; carry it into the next week.
Create a delayed case
Move uncertain receipts to later weeks and compare the lowest balance.
Replace estimates with actuals
As weeks complete, reconcile and update the remaining forecast.
Base case: payment arrives in week two
| Week | Opening | Receipts | Outflows | Closing |
|---|---|---|---|---|
| 1 | £2,000 | £0 | £800 | £1,200 |
| 2 | £1,200 | £1,500 | £600 | £2,100 |
| 3 | £2,100 | £0 | £900 | £1,200 |
Delayed case: the same payment arrives in week three
| Week | Opening | Receipts | Outflows | Closing |
|---|---|---|---|---|
| 1 | £2,000 | £0 | £800 | £1,200 |
| 2 | £1,200 | £0 | £600 | £600 |
| 3 | £600 | £1,500 | £900 | £1,200 |
Both scenarios finish week three at £1,200. Only the delayed case exposes the £600 low point in week two. Even these weekly closing figures can hide an intraday or midweek shortage, so inspect exact dates around tight periods.
For a simple worksheet, put Opening, Receipts and Outflows in B, C and D, with Closing in E. The first closing formula is:
=B2+C2-D2
The following week's opening cell references the previous closing cell. Use positive numbers in the Receipts and Outflows planning columns for this layout; do not subtract a negative outflow again.
Make the weekly review about decisions
Begin with expected receipts whose dates changed. Check the reason: a client confirmed a delay, an invoice is disputed, or an assumption was simply too optimistic.
Then look at the lowest projected cash point and the obligations around it. The tracker can help you identify when to follow up with a client or revisit discretionary plans. It does not tell you which legal or contractual payments you may defer.
Keep a note of the assumption changed and the date you changed it. This turns the forecast into a learning tool: over time, you can compare expected payment timing with what actually happened.
For a longer business horizon, the 13-week Excel forecast guide expands the same opening-plus-in-minus-out structure.
Test the tracker before relying on it
Check that completed weeks agree with the bank records for the chosen accounts. Confirm that a partially paid invoice contributes only its remaining expected amount to the future forecast.
Move one expected receipt by a week and make sure the right weeks change. Then return it to the reviewed assumption. Test a zero-income week and a large annual payment as well.
Keep separate currency views unless you have a documented conversion method. A clean-looking combined number is not useful if it adds pounds and euros as though they were the same unit.
Finally, label the forecast date and scenario. Readers should be able to tell which amounts are observed facts and which remain assumptions.