Small Business Cash & Profit
Separate profit from cash received and forecast a year.
Profit is not collection: an invoice may earn profit before cash reaches the bank.
Who it is for
For small businesses issuing invoices.
Your outcome
Monthly profit and cash with shortage warnings.
What is inside
- Calculator that separates profit from cash collected and forecasts the balance for a year with shortage warnings.
- Monthly profit and cash table and comparison chart.
- Analysis adding growth, bad debts, supplier credit, quarterly tax, an equipment purchase and your drawings, with a bridge explaining the gap between profit and cash, the lowest balance and its month, temporary funding needed, seven stress tests and four charts.
- Bilingual Excel file: monthly profit versus cash with the gap between them, a sales invoice register with due dates and lateness, a supplier payables register, a controls sheet, a full-year schedule, seven stress tests and a decision dashboard with the bridge, four charts and recommendations.
Before you begin
Your figures and results inside the kit are in US dollars, and you can switch currency to match your country.
Supporting your chances of success
This kit combines precise calculations with guidance and organisation to help you work towards your goal. We help you organise inputs, understand options and assess strengths and risks, then suggest practical steps suited to its subject — such as pricing, cash flow or marketing.
Guidance supports decisions, not guaranteed success; estimates depend on the accuracy of your inputs.
Understand the kit step by step
This kit explains how a profitable business can still struggle to pay bills. Sales create revenue but customers may pay later. It compares monthly profit with cash after collection delays and shows the annual balance impact. Use it when invoicing on credit or paying delivery costs before customer receipts.
What to prepare before starting
Prepare opening cash, monthly invoiced sales, delivery costs, fixed expenses, collection delay and growth. Distinguish invoice issue from payment receipt.
From information to a decision
- Enter sales and costs to estimate profit.
- Specify collection delay and cash available for the opening months.
- Read profit and cash together; test deposits or faster collection if a gap appears.
- Add growth, bad debts, supplier credit, opening balances, sales tax, the equipment purchase, your drawings and the safety buffer, then read the monthly schedule, the profit-to-cash bridge and the seven stress tests.
A simple example to explain the idea
Opening cash of 5,000, monthly sales of 10,000 and total costs of 8,000 produce 2,000 profit. But a one-month delay with no earlier receivables means first-month cash is 5,000 − 8,000 = −3,000. In the full calculator example — opening cash 20,000, sales of 12,000 growing 2% a month, costs of 9,000, one-month collection, 2% bad debts, 5% tax, 12,000 of equipment in month 4 and drawings of 1,500 a month — profit for the year is 47,765 but cash rises only 13,007. The bridge explains the gap: depreciation +1,800, higher customer balances −9,353, higher supplier balances +600, unpaid tax +2,194, equipment −12,000, drawings −18,000. The lowest balance is 8,554 in month 4, 1,446 below the 10,000 safety buffer. If customers pay one month later the balance falls to −4,293, and to −18,936 in the combined worst case.
These figures are illustrative, not approved prices or guaranteed forecasts; they may differ from the worked example below.
How to interpret and use the result
A shortfall indicates funding or earlier collections are needed despite profit. Review the lowest balance and payment timing, not annual profit alone.
A common mistake to avoid
Do not count an invoice as cash on issue and again on payment. This simplified analysis does not replace accounting records.
The included Excel file and how to use it
The Excel file has a monthly sheet comparing accounting profit with cash movement, showing the gap and the balance, a sales invoice register with due date, status and days late, and a supplier payables register built the same way, with average payment terms on each side so you can compare what you give customers with what you get from suppliers, using a fixed review date and overdue totals. It adds a controls sheet with fifteen validated inputs, a full-year monthly schedule of collections, payments, quarterly tax, equipment, drawings, bad debts and depreciation, seven stress tests that recalculate the year, and a decision dashboard with a checked profit-to-cash bridge, four charts and recommendations. The example matches the calculator figure for figure.
First-week actions after calculating
- Record all open sales invoices and unpaid supplier bills.
- Compare average customer terms with average supplier terms; if customer terms are longer, negotiate to shorten them.
- Enter the last three months in the monthly sheet and find the month where the gap between profit and cash widened.

