Sales were good this month, the team worked hard and, even so, on the day to pay suppliers the money doesn’t add up. The owner opens the spreadsheet and finds three tabs, broken formulas and numbers that don’t match the bank statement. Without knowing where the money went, it is hard to decide anything.
Cash flow is the record of all the money coming into and going out of the business, day by day, with what has already happened and what is expected over the coming weeks. To manage your finances without a messy spreadsheet, the path is: separate the business account from your personal one, record each inflow and outflow with a date and category, register what is coming due and check everything against the bank statement. When that means typing the same data in several places, a system does the heavy lifting.
What cash flow is
It is a picture of the business’s money over time: opening balance, plus inflows, minus outflows, equals closing balance. It has two parts that need to go together:
- Actuals: what really came into and left the account, checked against the statement.
- Forecast (or projection): what will come in and go out over the coming weeks, based on accounts receivable and payable.
The actuals show where the money went. The forecast shows whether you will run short before you do. It is the forecast that warns you, in advance, that in two weeks there is a large bill and little money coming in.
When finance is only part of the mess and sales, inventory and purchasing also live in separate spreadsheets, custom software brings it all together and lets the cash flow feed itself.
Cash is not profit
A business can be profitable and run out of money, or have money in the account and be losing money. It is the most common confusion for anyone starting to manage their finances.
| SITUATION | WHAT HAPPENS TO CASH |
|---|---|
| Sale paid in installments by card or boleto (bank slip) | The profit belongs to the month of the sale, but the money comes in bit by bit |
| Large inventory purchase | The money goes out now, but the goods only turn into sales later |
| Loan received | Money comes into the account, but it is not revenue: it is debt |
| Receivables advance | The money arrives earlier, minus a fee |
That is why cash flow uses the date the money actually comes in or goes out, not the date of the sale. To see profit, there is the income statement, which the accountant helps put together. The two views complement each other.
How to build your cash flow, step by step
1. Separate business money from personal money
A bank account of its own for the business and a defined owner’s draw (the pró-labore, in Brazil). If the household grocery bill comes out of the business account, no report will make sense.
2. Define the categories
Group inflows and outflows into a few categories that make sense for your business: sales, services, suppliers, payroll, taxes, rent, marketing, card fees, partners’ draws. This set is called a chart of accounts. A few categories used well are worth more than a huge list nobody follows.
3. Enter the opening balance
Start with the real balance of the bank accounts and the physical cash on a set day. From then on, everything starts from that number.
4. Record each inflow and each outflow with a date and category
Including the small ones: bank fees, card fees, fuel, lunch with a client. These are what make the spreadsheet balance not match the bank’s.
5. Register accounts payable and receivable
Bills, installments, payroll, taxes and credit sales, each with its due date. That is what turns a record of the past into a projected cash flow.
6. Reconcile with the statement
Bank reconciliation means checking, entry by entry, whether what is in your records is what appears on the statement. Done often, it catches typos, wrong charges and forgotten payments.
7. Look ahead every week
Set a fixed time to look at the coming weeks: how much comes in, how much goes out, on which day the balance is tightest. That is when you can renegotiate a deadline, hold back a purchase or chase whoever is late, before the squeeze.
Common business financial control mistakes
- Mixing personal and business accounts: the balance never reflects the business.
- Recording only when there is time left over: at the end of the month, nobody remembers what each payment was.
- Forgetting fees: bank fees, card fees and advances reduce what really comes in.
- Counting credit sales as money in the account: the sale was made, but the money hasn’t arrived yet.
- Only looking back: without the forecast, the squeeze is discovered on the due date.
- A spreadsheet with several versions: one on the office computer, another on a partner’s phone.
Inventory also weighs on cash: idle stock is idle money. If your business buys goods to sell, see how to organize inventory control.
Spreadsheet or system: when to switch
A spreadsheet works while there are few entries and one person handles everything; a system pays off when finance depends on data that already exists elsewhere. The most common signs that the spreadsheet has become part of the problem:
- Sales copied by hand from the sales system, the card machine or WhatsApp.
- Broken formulas that nobody dares to touch.
- Several bank accounts checked one by one, by eye.
- No due date alerts: the bill is only remembered when the collection notice arrives.
- Reports that take days to be ready and are already out of date.
- Only one person understands the file, and finance stops when they go on vacation.
| SPREADSHEET | FINANCIAL SYSTEM |
|---|---|
| Sale typed in later, by hand | A sale recorded in the system becomes a receivable |
| Due dates remembered from memory | Alert before each due date |
| Statement checked by eye | Statement imported and reconciled with the entries |
| Projection built separately | Forecast cash flow updated with every entry |
| One file per person | A single source of information, with access per user |
An off-the-shelf financial system works well when the business’s process is similar to most. When finance needs to talk to inventory, sales, the CRM or to its own rules for commissions and payouts, a system built for your process avoids double data entry. The criteria are in off-the-shelf ERP or custom system.
Conclusion
Managing cash flow means knowing today whether you will run short of money two weeks from now. With a separate business account, simple categories, same-day entries, accounts payable and receivable registered and reconciliation with the statement, finance stops being an end-of-month scare.
JIM builds custom management systems, with finance, cash flow and integration with sales, inventory and whatever your business already uses. See how custom software works and, if your question is what a complete system needs to have, read business management system.
Frequently asked questions
What is the difference between cash flow and an income statement?
Cash flow records money on the day it enters or leaves the account. The income statement (the P&L) shows whether the business made a profit or a loss in the period, counting sales and expenses in the month they happened, even if the money comes in later. One answers whether there will be money to pay the bills; the other, whether the business is profitable.
How often should I update the cash flow?
Ideally, record income and expenses every day, or at most every few days, and check them against the bank statement. The longer the gap between entries, the more gets lost and the harder it is to make the numbers add up.
Can I do cash flow in Excel or Google Sheets?
You can, and for many small businesses it is a good start. The spreadsheet starts to fail when there are many bills to pay and receive, several bank accounts, more than one person entering data and when sales data has to be copied from another system every day.
Does cash flow replace the accountant?
No. Cash flow is day-to-day management, done by whoever runs the business. The accountant handles the tax and accounting side. A well-organized cash flow actually makes the accountant's work, and your conversations with them, easier.



