Free tool

Cash flow tracker

List what comes in and what goes out, line by line, and see your net monthly cash flow, 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
Aug · one-offs land here+2,750€20,750
Sep1,250€19,500
Oct1,250€18,250
Nov1,250€17,000
Dec1,250€15,750
Jan1,250€14,500
Feb1,250€13,250
Mar1,250€12,000
Apr1,250€10,750
May1,250€9,500
Jun1,250€8,250
Jul1,250€7,000

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

The arithmetic under the ledger

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

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.

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?

No. A spreadsheet template works if someone maintains it, but most downloaded templates are abandoned within weeks because the formulas break quietly and the updating falls to nobody. This tracker does the same arithmetic in the browser and saves your lines locally on your device. For a business past a handful of line items, a tool that updates the numbers continuously is what replaces both.

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.

A tracker someone has to update is a tracker that goes stale

Plainhub is this ledger kept alive: money in and money out as named plans, with runway, burn and MRR recomputed the moment anything changes — not the next time somebody remembers the spreadsheet.