How to know what your business earns without spreadsheets
To know what the business earns without spreadsheets you have to automatically connect the sources where money moves: bank, payment processors, tax authority and cards. Transactions arrive on their own, get categorized, and land on a dashboard showing what came in, what went out and what is coming due.
Why the number always arrives late
In a small business the money sits in four or five places that do not talk to each other. Getting the real monthly number means pulling them together, and that task always loses against whatever is urgent.
| Source | What it holds | How it gets consolidated by hand |
|---|---|---|
| Bank | Transfers, debits, deposits | Downloading the statement and copying into a spreadsheet |
| Payment processors | Charges, fees, withholdings | Another statement, another format |
| Cards | Settlements with discounts and terms | A PDF summary that has to be interpreted |
| Tax authority | Invoicing, due dates, obligations | Logging into the portal, one by one |
| Cash | What is not recorded anywhere | From memory or a notebook |
The typical outcome: the owner learns how the month went when the accountant closes it, two or three weeks later. By then the information is good for filing, not for deciding.
What can be automated and what cannot
- Automated: pulling transactions from the bank, payment processors and cards; reading PDF statements; categorizing income and expenses; flagging due dates; building the accountant export.
- Not fully automated: cash, which needs a quick entry from the phone, and ambiguous categorization calls, where the system proposes and you confirm.
Honesty matters here: no system takes the work to zero. What it does is turn several hours of manual entry into a few minutes of review.
The three questions a dashboard has to answer
A financial dashboard for a small business does not need twenty metrics. It needs to answer three questions, well:
- What came in and what went out this month? With the net figure visible, without adding anything up.
- What is coming due? Taxes, services and commitments, ordered by date.
- Where is the money going? Spending grouped by category, so you can see where to cut.
Everything else is decoration until the business grows enough to need it.