Free Cash Flow Tracker (Excel)

Profit on paper and cash in the bank are not the same thing — a profitable month can still leave you unable to make payroll. This free tracker shows money in, money out, and your running balance by month, so you can see a cash crunch coming before it happens.

Download Free — XLSX See the Full Library

No email required · Works in Excel or Google Sheets · Includes a built-in AI prompt

Who this is for

Business owners who’ve been profitable on paper but tight on cash
Freelancers with irregular, lumpy income
Anyone planning a big purchase or hire and checking the cash impact first
Students learning why cash flow and profit are different things

What's included

Monthly Cash In and Cash Out sections
Automatic running cash balance calculation
Room to separate operating, investing, and financing cash flows
Built-in AI prompt that flags upcoming cash crunches based on your trend

Why use a template instead of starting from scratch?

Tracking cash flow in your head, or worse, just watching the bank balance, means you find out about a shortfall the week it happens — too late to plan around it. This template forces monthly discipline and shows the trend line, so a dip is visible weeks or months before it becomes a real problem.

How to Use This Template

Download and open in Excel or Google Sheets

Works identically in either — no macros or add-ins needed.

Enter your starting cash balance

Use your actual bank balance as of the first day of the period you’re tracking.

Log cash in and cash out by month

Only include actual cash movement — not invoiced revenue you haven’t been paid yet.

Watch the running balance column

This is the number that actually matters — it shows you exactly when cash gets tight, not just whether you were profitable that month.

Run the built-in AI prompt on a few months of data

Attach the saved file to ChatGPT or Claude and ask what the trend suggests about the next few months.

Built-in AI prompt

Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on whether your cash trend is heading toward a shortfall, and what’s driving the biggest swings month to month, no accounting background required.

Common Mistakes to Avoid

Tracking invoiced revenue instead of cash actually received

A cash flow tracker only counts money that has actually moved — an unpaid invoice is not cash yet, no matter how confident you are it’ll be paid.

Forgetting irregular annual or quarterly expenses

Insurance renewals, annual software licenses, and quarterly tax payments can blindside a cash forecast if they’re not planned for in the specific month they hit.

Confusing this with a P&L

A P&L shows profit over a period; this tracker shows literal cash movement. A business can show a profit and still run out of cash, which is exactly what this template is built to catch.

Only checking it when cash already feels tight

The value is in watching the trend proactively, monthly, not just pulling it out during a scare.

Frequently Asked Questions

What’s the difference between cash flow and profit?

Profit (from your P&L) counts revenue when it’s earned and expenses when they’re incurred, regardless of when cash actually changes hands. Cash flow only counts money that has physically moved in or out of your bank account. A business can be profitable and still run out of cash if customers pay slowly.

How often should I update a cash flow tracker?

Monthly at minimum. If cash is tight or the business is growing fast, weekly tracking catches problems even earlier.

What are the three types of cash flow?

Operating (day-to-day business activity), investing (buying or selling equipment/assets), and financing (loans, owner contributions, distributions). This template gives you room to separate them if you want that level of detail.

Is this template really free?

Yes, completely free, no email required. iLuvAccounting also has a paid Tools Club with 70+ templates, including a full Statement of Cash Flows if you need the formal version.

Can I use this to forecast future cash flow, not just track the past?

Yes — add projected months alongside actuals using your best estimate of upcoming invoices and expenses, and update them with real numbers as the month closes.

What if my cash balance goes negative in a future month?

That’s the entire point of tracking ahead of time — it gives you weeks or months of runway to cut costs, delay a purchase, follow up on receivables, or arrange financing before it actually happens.

Should I include personal cash flow if I’m a sole proprietor?

Keep them separate wherever possible — track business cash flow here, and your personal finances in a separate tool. Draws you take out of the business should show as a cash-out line, but personal bills shouldn’t mix into the business tracker.

Related Templates

Related Resources

Want the Full Template Library?

70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.

Join the Tools Club