By Your sales are growing. So why does your bank balance still feel low?
You may be making sales every week but still struggle to pay suppliers, cover bills, or pay yourself. The problem could be cash flow, not sales.
A simple Google Sheets tracker can help you see what money comes in, what goes out, and what you can actually afford. If you want a ready-made option, check this business income and expense tracker.
What Does Small Business Cash Flow Actually Mean?
Cash flow is the movement of money into and out of your business. Income includes customer payments you receive. Outflows include rent, inventory, software, shipping, payroll, and other bills you pay.
Money collected from customers
Expenses actually paid
Income minus expenses
Money customers still owe
Example figures for illustration only. Notice that unpaid invoices are not the same as money already received. A sale does not help you pay today’s bill until the customer pays you.
How to Track Cash Flow in Google Sheets
You do not need complicated accounting software to start. Create a spreadsheet with these columns:
| Date | Description | Category | Money In | Money Out | Status |
|---|---|---|---|---|---|
| Oct 2 | Customer payment | Sales | $1,200 | $0 | Received |
| Oct 4 | Stock purchase | Inventory | $0 | $350 | Paid |
| Oct 7 | Monthly software | Software | $0 | $50 | Paid |
| Oct 9 | Customer invoice | Sales | $0 | $0 | Unpaid |
Record actual payments in the Money In and Money Out columns. Keep unpaid invoices in your records, but do not count them as cash received yet.
Use These Simple Google Sheets Formulas
If Money In is column D and Money Out is column E, use these formulas for your totals:
Total cash received
=SUM(D2:D100)Total cash paid
=SUM(E2:E100)Net cash flow
=SUM(D2:D100)-SUM(E2:E100)Adjust the column letters and row numbers to match your own spreadsheet. These formulas calculate the totals for the rows included in the ranges.
Try This Cash Flow Calculator
Enter your figures to estimate how much cash remains after the period’s income and expenses.
Ending cash: $3,300
How to read the result: Positive net cash flow means you received more cash than you paid out during the period. Negative cash flow means you paid out more than you collected. A positive result does not automatically mean your business is profitable.
Cash Flow Is Not the Same as Profit
Profit measures revenue minus business costs under your accounting method. Cash flow tracks when money actually moves. These figures can differ because of unpaid invoices, loan repayments, equipment purchases, and other timing differences.
| Measure | What it tells you |
|---|---|
| Revenue | Sales earned during a period |
| Profit | Revenue minus applicable costs and expenses |
| Cash flow | Cash received minus cash paid |
For example, you might invoice a customer for $2,000 today but receive the payment next month. The sale may count toward revenue now, but the money is not available in your bank account yet.
How to Keep Track of Unpaid Invoices
Add a separate invoice list with the customer name, invoice number, amount due, due date, and payment status. Review it every week so overdue payments do not catch you by surprise.
Contact customers before the payment deadline.
Send a polite reminder and confirm the expected payment date.
Keep unpaid amounts separate from your cash-received total. This makes your available balance more realistic and helps you plan upcoming bills.
Is a Free Spreadsheet Enough?
A free Google Sheets template can work well if your transactions are limited and you are comfortable maintaining the formulas yourself. A ready-made tracker may be more practical when you want organized categories, payment-status dropdowns, and a dashboard without building everything from scratch.
Want the Tracking Sheets Already Organized?
This business tracker includes a dashboard for total revenue, expenses, net profit, and margins, plus income and expense sheets with category and payment-status dropdowns. It also includes a monthly cash flow statement and works with Google Sheets and Microsoft Excel.
View the Business TrackerBuild a Simple Weekly Cash Flow Routine
- Record new income and expenses.
- Match transactions against your bank activity.
- Check unpaid and overdue invoices.
- Review bills due in the next two to four weeks.
- Update your expected cash balance before making large purchases.
If you need ideas for improving your operations, explore our small business growth tips and use the business growth ideas generator to brainstorm your next steps.
Final Thoughts
You do not need a complicated financial system to understand where your money is going. Start with a spreadsheet, record real cash movements, monitor unpaid invoices, and review your balance every week. As your business grows, a structured tracker can save time and make your financial picture easier to understand.
