TL;DR
Invoiced, collected, and recognized revenue are three different numbers that tell three different stories. Using the wrong one in your forecast produces plans built on money that has not arrived or money that may never come.
If you have ever looked at your accounting software and seen a revenue number that did not match what was in your bank account, you have already experienced this problem. There are three different revenue figures most small businesses generate, and they mean completely different things.
Confusing them in your forecast is not a minor error. It produces plans that are built on money that has not arrived, money that may never arrive, or money that arrived months ago and has nothing to do with your current trajectory.
What Each Number Actually Means
Invoiced revenue is what you have billed. You issued an invoice for $10,000. That invoice is now in accounts receivable. The work may or may not be done. The client has not necessarily paid. Invoiced revenue is a claim, not cash.
Collected revenue is what has hit your bank account. A client pays your invoice. The money moves. This is the cash basis number and the one your bank balance reflects.
Recognized revenue is what you have earned by delivering work, regardless of billing or payment. You do $10,000 of work in November, invoice in December, and collect in January. Under accrual accounting, the revenue is recognized in November because that is when you earned it.
The Common Mistake and What It Costs
The mistake is using invoiced revenue as the top-line number in a forward forecast. It feels intuitive because invoicing is visible and immediate. But invoiced revenue includes clients who will be slow to pay, clients who will dispute the bill, and retainers sent ahead of work that has not been done yet.
Suppose you invoice $50,000 in December across five clients. Two pay promptly, two pay in 45 days, and one disputes $5,000. Your forecast built on December invoiced revenue shows $50,000. Your January bank account shows $20,000. Your February shows another $20,000. You never see $10,000 at all. The plan was disconnected from reality before the month ended.
For a business with regular collection problems, this leads to decisions made on phantom revenue: hiring before cash arrives, paying bonuses based on billings rather than collections, and missing payroll because the forecast said things were fine.
Which Number Goes in the Forecast
The answer depends on what the forecast is trying to answer.
Cash flow forecast: use collected revenue. If the question is whether you can make payroll, pay your supplier, or fund a hire, the only number that matters is what will hit your bank account and when. A cash flow forecast maps invoice due dates against your DSO (days sales outstanding) to project actual inflows. Recognized or invoiced revenue sitting in AR does not pay bills.
Profitability forecast: use recognized revenue. If the question is whether your business model is working, whether pricing covers costs, or how margins are trending, recognized revenue is the right baseline. It matches revenue to the period when work was done so you can compare it to the costs incurred that period.
Pipeline and sales forecast: use invoiced or contracted revenue. If you are trying to understand what is in motion, what deals have closed, and what work is upcoming, invoiced and committed-but-not-yet-invoiced figures tell you the story. Just do not treat them as collected until they are.
An Illustrative Example
A consulting firm bills clients monthly on retainer. In any given month, they invoice $80,000. Historically, 90% collects within 30 days and 8% collects at 60-90 days. About 2% ends up written off.
Their cash flow forecast models collections at 90% of invoiced revenue in the following month, with a 8% lag to the second month and 2% never arriving. This means an $80,000 invoice month generates roughly $72,000 in cash the next month, another $6,400 the month after, and $1,600 that never shows up.
Their profitability forecast uses recognized revenue, which in their case is close to invoiced because work is done before billing. The two forecasts run separately and serve different purposes. They never mash them together into a single top-line number.
What to Do About It
- Decide what question your forecast is answering before you build it. Cash survival and profitability analysis are different questions that need different inputs.
- Calculate your DSO: divide total accounts receivable by average daily revenue. This tells you how long clients actually take to pay, not how long the invoice says they should.
- Apply your DSO to invoiced revenue to estimate when money will arrive. If your DSO is 45 days, a January invoice will largely land in mid-February.
- Track write-offs as a percentage of invoiced revenue over the past 12 months. Build that percentage into your collections forecast as a reduction. Do not assume every invoice will collect.
- Separate your cash flow forecast from your P&L forecast. Update both monthly. Flag when they diverge significantly, because divergence signals a timing or collection problem worth addressing.
The Bottom Line
Revenue is not one number. It is three, and each tells a different story. Using invoiced revenue in a cash flow forecast is like planning a road trip based on the distance you intend to drive rather than how much gas you actually have. Get the right number matched to the right question and your forecast becomes a tool instead of a story you tell yourself. To build this out for your business, book a free call at peterxiacpa.com/book.
Next step: see it in your free Instant CFO Snapshot.
Frequently Asked Questions
- What is the difference between recognized and collected revenue?
- Recognized revenue is what you have earned by delivering work, regardless of billing or payment. Collected revenue is cash that has actually arrived in your bank account. A business can recognize revenue in one period and collect it months later.
- What is days sales outstanding (DSO) and why does it matter for forecasting?
- DSO measures how long it takes clients to pay after you invoice them. You calculate it by dividing accounts receivable by average daily revenue. A high DSO means your cash arrives well after your invoicing, which matters enormously when projecting cash flow.
- Should I use cash basis or accrual accounting for my small business?
- Most small businesses in Canada start on cash basis and move to accrual as they grow. For tax purposes, either may be acceptable depending on your situation. For management decisions, accrual accounting gives a more accurate picture of profitability. Talk to your accountant about which method applies to your filing.
Get weekly CFO insights
No fluff. Real finance strategy for Canadian business owners. Unsubscribe any time.
Related Articles
Is Your Gross Margin Real? How Misclassified Costs Inflate Profit
Gross margin only means something if the right costs are in the right buckets. Misclassified costs inflate the number, distort your pricing, and can hide a structural problem until it is too late.
4 min readCorporate Tax Installments: When CRA Expects You to Pay Throughout the Year
If your corporation owes more than $3,000 in tax in a given year, CRA may require monthly installment payments throughout the following year. Missing them triggers interest even if you pay the full balance on time at year-end.
6 min readHow to Tell What Counts as Profit When Payroll and Bills Hit on Staggered Dates
A healthy bank balance mid-month doesn't mean you made money. When expenses hit on staggered dates, the balance swings constantly. Here's how to separate actual profit from temporary cash on hand.
5 min readNeed financial strategy for your business? Explore our CFO services or book a call.
