What it means
Every business has a bank balance, but a balance only tells you about today. Tracking builds a forward view by listing expected receipts and payments week by week, then rolling the actual results back in so the forecast improves each time it is refreshed.
The core discipline is comparing what you expected with what happened. When a forecast receipt of $80,000 arrives as $50,000, the tracker updates the balance, pushes the remaining $30,000 into a later week and immediately shows whether that delay creates a problem downstream.
Thirteen weeks is the common horizon because it covers a full quarter of supplier terms, payroll runs and tax dates without demanding guesses so far ahead that they become fiction. Businesses with heavy seasonality often run a thirteen week detailed view alongside a twelve month summary view.
Good tracking separates operating movements from financing and investing ones. Mixing a loan drawdown in with customer receipts hides the fact that trading itself is consuming cash, which is precisely the signal the exercise is meant to surface.
Tooling matters less than cadence. A spreadsheet updated every Monday morning beats sophisticated software refreshed once a quarter, because the value comes from noticing a gap while there is still time to chase an invoice, delay an order or arrange a facility.
In practice
Real-world examples.
Example
A restaurant group tracks daily takings against weekly supplier payment runs and spots that Tuesday settlements consistently land before the weekend banking clears. Moving the payment run to Thursday removes a recurring overdraft charge without changing a single supplier relationship.
Example
A civil engineering contractor updates a thirteen week tracker every Friday and sees that a $600,000 certified payment has slipped a month. The commercial director escalates with the client three weeks before the shortfall would have hit payroll.
Example
A subscription software company tracks receipts by cohort and notices that annual renewals cluster in January and July. Knowing this, the finance lead schedules the year's major equipment purchases for February and August, when the balance is highest.
Think of it
“Cash flow tracking is watching your actual cash versus plan-monitoring in real time.
Formula
Calculation
Closing cash = opening cash + cash received - cash paid, applied week by week
A design agency starts week one with $185,000 in the bank. It expects receipts of $420,000 and payments of $365,000, so closing cash is $185,000 + $420,000 - $365,000 = $240,000.
Week two opens with that $240,000. Receipts are $310,000 and payments, which include a quarterly tax bill, are $395,000, so closing cash is $240,000 + $310,000 - $395,000 = $155,000. Week three brings receipts of $500,000 against payments of $340,000, giving $155,000 + $500,000 - $340,000 = $315,000.
Checking the three weeks together confirms the arithmetic: total receipts of $1,230,000 less total payments of $1,100,000 gives a net increase of $130,000, and $185,000 + $130,000 = $315,000. The dip to $155,000 in week two is the useful output, because it tells the agency exactly how much headroom it needs before the tax payment falls due.Case study
Seen in the real world.
This illustrative example uses a fictional company. Marlowe Print Group, an invented commercial printer, had grown to $9,000,000 of revenue while managing cash by checking the online banking screen each morning. Twice in two years it had missed a supplier payment and had to negotiate an emergency extension, each time discovering the problem only days beforehand.
The new financial controller introduced a simple thirteen week tracker covering payroll, tax dates, the four largest suppliers and the twenty largest customers, refreshed every Monday. Within a month it revealed a predictable trough in the third week of each quarter, caused by tax and quarterly rent landing together while the biggest customer paid on the twenty eighth.
Marlowe's fictional management negotiated a shift of the rent date by ten days and agreed staged payments with its paper supplier. The overdraft peak fell by roughly $250,000 and no further emergency extensions were needed, all from visibility rather than from any new financing.
Watch out
Common mistakes.
- Building a tracker from the profit and loss forecast without adjusting for payment terms, so revenue appears as cash in the month it is invoiced rather than when it is collected.
- Forgetting irregular but certain outflows such as quarterly tax, annual insurance and holiday pay, which are the items that most often cause an unexpected shortfall.
- Preparing the forecast but never comparing it with actual results, which means the assumptions never improve and the tracker slowly loses credibility.
Questions
People also ask.
How often should a small business update its tracker?
Weekly is the practical standard for most, though businesses close to their facility limit often move to daily until the position is comfortable.
Is a spreadsheet good enough?
For most companies under roughly $20,000,000 of revenue, yes, provided one named person owns it and updates it on a fixed day each week.
Should the tracker include VAT or sales tax?
Yes, because those amounts genuinely move through the bank account, and excluding them is a common cause of forecasts that look fine yet still run short.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%