Free tool

Cash flow tracker

A cash flow tracker is an itemized record of the money coming in and going out of a business. Net monthly cash flow is calculated as money in minus money out, and next month's balance as this month's balance plus that net. List each line here and see the balance twelve months ahead and the month you would hit zero. Saved in your browser only. Nothing leaves this page.

Starting point
Money in
Money out
Net cash flow
−€1,250
per month, recurring lines only
Money in / month
€9,500
plus €4,000 one-off
Money out / month
€10,750
recurring

This ledger loses €1,250 a month. At that pace, the cash you start with plus the one-offs reaches zero in about 17.6 months — that number is your runway, and the cash runway calculator shows what moves it.

MonthNetBalance
Oct · one-offs land here+€2,750€20,750
Nov−€1,250€19,500
Dec−€1,250€18,250
Jan−€1,250€17,000
Feb−€1,250€15,750
Mar−€1,250€14,500
Apr−€1,250€13,250
May−€1,250€12,000
Jun−€1,250€10,750
Jul−€1,250€9,500
Aug−€1,250€8,250
Sep−€1,250€7,000

Your lines are saved in this browser only — nothing is sent anywhere. clears them and restores the example.

Keep cash, burn and runway updating as you record money.Build your modelTry the live demo

The arithmetic under the ledger

Net cash flow is money in minus money out, and next month's balance is this month's balance plus that net. The tracker applies those two lines for twelve months. Itemize each line instead of estimating a total, because totals hide where a cut would land, and treating a one-off project payment as recurring income flatters the picture.

net cash flow = money in − money out
next month's balance = this month's balance + net cash flow

Two lines, applied twelve times. The reason to itemize rather than estimate is that aggregates hide the levers: “we spend €10,750 a month” suggests nothing, while a ledger showing payroll, rent, software and ads as separate lines shows exactly where a cut or a raise would land.

One-off items get their own cadence because treating a single project payment as recurring income is the fastest way to build a picture that flatters you. The tracker lands one-offs in the current month and lets the recurring lines carry the projection.

When the recurring net is negative, the balance line becomes a countdown, and the months until it crosses zero are your runway. That single number deserves more attention than the rest of the ledger combined. The cash runway calculator works it against your real burn, and when will you run out of cash covers what actually moves it. If the ledger keeps coming out negative and you want the causes rather than the arithmetic, the cash flow problems guide names the usual five.

Tracking or forecasting: which one you need

Track first, forecast second. Tracking is the itemized ledger of what actually came in and went out; forecasting projects monthly totals forward with a growth assumption. A forecast is only as good as its totals, and a maintained ledger is where those totals come from, so itemize your lines before you project twelve months ahead.

Tracking and forecasting get conflated because both end in a balance projection, but they answer different questions. Tracking is itemized and present-tense: which lines, how much, what net they produce: this page. Forecasting is aggregate and future-tense: given monthly totals and a growth assumption, where does the balance go. The cash flow forecast's job, including the growth compounding this ledger deliberately leaves out. Start with tracking; the totals a forecast needs are what a maintained ledger produces.

Both run at monthly grain, which is right until cash gets tight. Inside a hard month, the order of payments matters as much as their sum: payroll on the 25th with the big invoice landing on the 28th is a crisis a monthly view cannot see. That is what the 13-week cash flow forecast exists for: the same arithmetic at weekly grain, over the quarter where you can still act. The habit that keeps any of these honest is a fixed monthly business review: thirty minutes, same day each month, ledger first. And when a page you retype each month stops being enough (more lines than patience, or a number other people depend on), the comparison of dedicated cash forecasting software covers what the step up buys and what it assumes you have.

Common questions

How do I track cash flow?

List every source of money in and every destination of money out, each with its amount and whether it repeats monthly or happens once. Money in minus money out is your net cash flow for the month; add it to your bank balance month after month and you have a running picture of where cash is heading. The discipline that makes it work is updating the list when reality changes, a tracker that is three months stale is a photograph, not a tracker.

What is a cash flow tracker?

A cash flow tracker is an itemized record of the money coming into and going out of a business, kept current so you can see your net position and where it is trending. It differs from an accounting system in scope and purpose: accounting records everything for compliance and reporting, while a tracker keeps the handful of numbers that decide survival, cash, inflows, outflows, visible at a glance.

What is the difference between a cash flow tracker and a cash flow forecast?

A tracker is the itemized ledger view: each source of money in and money out, line by line, with the net they produce. A forecast is the projection view: it takes aggregate monthly figures and rolls them forward to show where the balance goes. You track to know what is true now, and forecast to know what it implies. In practice the tracker feeds the forecast, the aggregates a forecast needs are exactly what a maintained ledger produces.

Do I need Excel or a template to track cash flow?

A spreadsheet works if you keep its entries and formulas current. This tracker provides the calculations in your browser and saves your lines locally on this device. Update amounts and recurring status when they change; it cannot read transactions from your bank.

How often should I update a cash flow tracker?

When something changes, and at minimum once a month: a fixed monthly review is the cadence that catches drift before it compounds. When cash is genuinely tight, professionals move to weekly grain, because inside a tight month the order of payments matters as much as their sum.

Keep recording the changes that matter

Keep cash movements and recurring costs in the same model as your customers and team, with runway recalculated from your entries. You enter changes yourself, since Plainhub does not connect to your bank. Draft plans let you test a hire before committing to another monthly cost.