How to track cash flow: 6 steps to see the squeeze before it hits

Cash flow means two things

Net cash flow is total inflow minus total outflow over a period. Positive means you ended the month with more than you started; negative means you used savings or credit to cover the gap.

Timing is whether the money is there on the day each bill is due. You can be positive for the month and still overdraw on the 12th because rent leaves before payday. Many people who feel short of money have a timing problem more than a total problem, and a monthly total hides it.

Both differ from net worth, which is everything you own minus everything you owe. Net worth moves slowly; cash flow decides whether you get through this month without fees.

Step 1: Gather 90 days of transactions

Three months is enough to see your normal pattern: one month can be unusual, three show what repeats. Download the statement files from online banking for every account you use, including credit cards. Online banking usually lets you download CSV, and some banks also offer OFX or QFX; this guide to importing bank statements walks through the formats.

Step 2: Split every flow into four groups

1. 01
   Regular income. Salary or benefits on known dates. Only this part is safe to plan around.
2. 02
   Fixed costs. Rent, loan payments, insurance, phone. Known amount, known date.
3. 03
   Variable costs. Groceries, transport, eating out. Use a three-month average, since a single month can mislead.
4. 04
   Periodic costs. Annual subscriptions, car maintenance, gifts. Divide the yearly total by 12 and set it aside monthly in a sinking fund so it never lands as a surprise.

If your income is irregular, treat freelance or commission payments as a separate line and plan on the lower months. Our guide to budgeting on an irregular income shows how.

Step 3: Calculate net cash flow for each month

Add up the inflows, add up the outflows and subtract. A worked example with round numbers:

Example figures for illustration only. Month 2 went negative because of one annual payment, which a sinking fund would have spread across the year.

Step 4: Find the lowest balance between paydays

Lay the month out by date: starting balance, then each inflow and outflow on the day it actually happens. The lowest point of that running balance is your real cash flow risk. A month that ends at +$400 but touches −$150 on the 12th has a problem the monthly total conceals. Fixes are usually about dates: ask for a different due date on a bill, move a transfer to the day after payday, or keep a buffer equal to that low point.

Step 5: Look ahead, then stress-test

Project at least to the next two paydays so a full bill cycle is visible. Then subtract a plausible surprise, such as a $300 repair, and check the low point again. If one ordinary surprise pushes you below zero, the buffer is too thin; that is the signal to act before the squeeze. How AI cash flow forecasting works explains how an app does this projection for you.

Step 6: Review once a week

Net worth can wait for a quarterly check; cash flow moves too fast for that. A five-minute weekly look is enough: record or import the new transactions, check that the next low point still clears zero, and adjust one thing if it does not. By the time a monthly review comes round, the negative day has already happened.

Spreadsheet or app

A spreadsheet works if you keep it up: one tab of transactions, one tab with the four groups, one running-balance column by date. The weak points are categorising by hand and rebuilding the forecast every week; the trade-offs are covered in spreadsheet vs budgeting app.

In Finman the same steps run on your records:

• Transactions come from a connected monobank account, from CSV, OFX or QFX files (RBC, TD, Scotiabank, BMO, CIBC, Tangerine, Wealthsimple Cash, EQ Bank, Revolut, Wise) or from manual entry, including offline.
• Imported transactions get a category from the merchant category code or from keywords in the description; your own rules sort what the guess leaves in Other with one Apply rules click. More on that in how to track expenses.
• Recurring charges are detected in your transactions, so fixed costs and subscriptions surface without a separate list.
• The balance is projected up to 90 days ahead, with the lowest balance marked, and the AI CFO chat answers questions about your own accounts and transactions.

Related reading: AI cash flow forecasting · Choosing a forecasting app · How to make a budget · Living paycheck to paycheck