How to create a business cash flow tracker in Excel

What is cash flow (and why it matters)

Cash flow is the movement of money in and out of your business. Money in is payments you receive. Money out is everything you spend to keep things running.

Cash flow vs. profit

Profit is what you’ve earned after expenses. Cash flow is what’s actually available in your bank account right now. That difference matters because timing matters.

For example, you can invoice a client today and technically be “up” for the month, but if they don’t pay for 30 days, that money won’t help you cover rent or payroll this week. Tracking cash flow keeps you grounded in what you can pay for now, not just what you’ve earned on paper.

Cash flow vs. revenue

Revenue is what you earn on paper. Cash flow is what you actually have available to spend. If clients pay late or expenses land early, your revenue can look great while your bank account feels tight.

That’s why many people find a simple cash flow tracker to be a relief. It helps you plan for slower months, avoid surprises, and make smarter decisions, especially when income comes in waves.

Tip: If you’re freelancing or running a side hustle, separate business and personal spending as early as you can. Even one dedicated bank account or card makes your Excel tracker easier to maintain, and your numbers easier to trust.

What to include in an Excel cash flow template

At its core, a cash flow tracker can be built with a handful of columns. You don’t need anything fancy to start. If you don’t want to build it from scratch, you can also ask Copilot in Excel¹ to create a simple cash flow template for you based on the columns you want to track, then tweak it to fit your business.

A simple Excel cash flow template should include:

• Date
• Description (client name, bill, subscription, etc.)
• Money in (income)
• Money out (expenses)
• Running balance

Here’s what it might look like in practice:

• Jan 5 | Client invoice #104 paid | $800 | $0 | $2,350
• Jan 6 | Software subscription | $0 | $59 | $2,291

That running balance is the key. It turns your spreadsheet into a basic cash flow statement: a clear, ongoing view of your cash position, not just a snapshot at the end of the month. Think of it as a living cash flow statement that updates every time money moves.

How to track cash flow in Excel (step-by-step)

Step 1: Set up your business cash flow spreadsheet

Open Excel and create the columns above (Date, Description, Money In, Money Out, Running Balance). Then decide how you want to organize your rows:

• One row per transaction (recommended): easiest to maintain and best for a true running balance
• One row per day/week with totals: works if you prefer fewer entries

Most small business owners do best with one row per transaction because it mirrors your bank activity and makes it easy to spot what caused your balance to rise or fall.

Step 2: Enter your income and expenses

Start adding real transactions. Include anything that affects your cash position.

Income examples:

• Sales
• Invoices paid
• Freelance project payments
• Side gig income

Expense examples:

• Rent or workspace costs
• Software subscriptions
• Supplies
• Marketing and ads
• Contractor payments
• Shipping and materials

To keep your cash flow statement accurate, only record money when it actually enters or leaves your account—not invoices you haven’t been paid yet. If you want to track unpaid invoices, keep that in a separate sheet so it doesn’t distort your cash flow.

Step 3: Calculate your running balance

This is what turns your spreadsheet into a real cash flow tracker. Your running balance updates with every transaction so you always know how much cash you have on hand.

1) Enter your starting cash

In your first Running Balance cell (for example, E2), type your starting cash amount.

Example:

• If you’re starting the month with $1,550, enter 1550 in E2.

2) Add the running balance formula

In the next balance cell (for example, E3), enter this formula:

=E2 + C3 – D3

Here’s what it means:

• E2 = your previous balance
• C3 = money in (income)
• D3 = money out (expenses)

3) Copy the formula down

Once that formula is in place, copy it down the column for as many rows as you need. Excel will automatically calculate the balance for each new transaction.

After this, you only have to enter income and expenses. Your cash flow template will keep the running total for you.

Pro tip: Use conditional formatting in Excel to make low balances stand out automatically. For example, you can set a rule so any balance under $0 (or under $500) is highlighted, which makes it much easier to catch problems quickly, without combing through every row.

Step 4: Update your business cash flow spreadsheet weekly

This is where most people fall off, so keep it realistic. A weekly update is often enough for freelancers and small businesses. The goal is a habit you can maintain, not daily perfection. A cash flow tracker only works if it stays current.

Pick a time:

• Every Friday afternoon
• Every Monday morning
• The first of each month (minimum)

Even 10 minutes a week can help you feel more informed about your cash position. If you’re short on time, start by entering only your largest expenses and all income, then fill in the smaller line items later.

Turn data into insights with Excel

Make better decisions backed by data and insights

Learn more

How a cash flow statement helps you make decisions

Once your tracker is up to date, Excel becomes more than a log. It becomes a decision tool.

A simple cash flow statement helps you:

• Spot slow months early (before they hurt)
• Know when you can reinvest in equipment, marketing, or hiring
• Cut costs before you’re forced to
• Plan for taxes and busy seasons

It also helps you see patterns you can act on.

Worth doing: At the end of each month, review totals, not just transactions. You’ll catch things like subscriptions creeping up, income dips that happen every summer, or marketing costs rising without a payoff. That’s the difference between “I think we’re okay” and “I know where we stand.”

Start using your cash flow tracker today

Cash flow tracking doesn’t need to be complicated to change how you run your business. When you track cash flow in Excel, you stop relying on gut instinct, catch shortfalls earlier, and make decisions based on what’s actually in motion, not what you hope will happen.

Ready to get started? Open Excel in Microsoft 365 and set up your cash flow tracker today. Update it once a week for the next month, and you’ll have a clear view of your money, and what you can do next.

---