Key Takeaways
- There are two distinct ways to calculate cash collections from accounts receivable: a retrospective method that tells you what you actually collected in a closed period, and a prospective method that forecasts what you expect to collect.
- The retrospective formula is Beginning AR plus Credit Sales minus Ending AR. It uses only figures already sitting in your balance sheet and income statement.
- The prospective formula is Cash Sales plus Estimated AR Collections, where the estimate comes from applying historical collection rates to an aging schedule.
- Cash collections and Days Sales Outstanding measure related but different things. DSO tells you how long collections take. Cash collections tells you how much cash actually lands.
- The most common calculation mistakes are using stale collection rates, ignoring bad debt write-offs, and treating every aging bucket as equally collectible.
If you have ever closed a month and had your cash balance come in lower than your AR aging report suggested it should, you already know why this calculation matters. Accounts receivable tells you what customers owe you. Cash collections tells you what you actually got paid. The two numbers are related, but they are not the same, and finance teams that only track one of them are usually the ones surprised by a cash shortfall two weeks before payroll.
A quick overview: this guide covers both ways to calculate cash collections from accounts receivable, walks through a full worked example for each, and explains when to use which method, before covering how the number connects to DSO, working capital planning, and the mistakes that most commonly throw the calculation off.
Two Ways to Calculate Cash Collections: Actual vs. Forecasted
Most guides online only show you one formula, which is part of why this calculation trips people up. There are actually two separate questions hiding inside "how do I calculate cash collections," and they call for two different formulas.
- Retrospective (actual): How much cash did we actually collect from AR last month, quarter, or year? This is a closed-period, backward-looking calculation built entirely from numbers you already have on your balance sheet and income statement.
- Prospective (forecast): How much cash do we expect to collect next month or next quarter? This is a forward-looking estimate built from your AR aging schedule and historical collection behavior.
Knowing which question you are actually trying to answer will tell you which formula to use, so the two get their own worked examples below.
Retrospective Method: Calculating Actual Cash Collected from AR
The retrospective formula is a straightforward rollforward of your accounts receivable balance:
Cash Collections = Beginning AR + Credit Sales − Ending AR
Every input comes from statements you already close every period:
- Beginning AR: your accounts receivable balance at the start of the period, from the balance sheet.
- Credit Sales: total sales made on credit during the period, from the income statement.
- Ending AR: your accounts receivable balance at the end of the period, from the balance sheet.
The logic is simple once you see it laid out: whatever receivables you started with, plus whatever new credit sales you added, minus whatever receivables are still outstanding at period end, has to be the cash you collected in between.
Worked example:
- Beginning AR: $50,000
- Credit Sales: $200,000
- Ending AR: $40,000
Cash Collections = $50,000 + $200,000 − $40,000 = $210,000 collected
This method is fast, requires no assumptions about collection behavior, and reconciles cleanly to your books, which is exactly why it is the better fit for closed-period reporting rather than planning ahead.
Prospective Method: Forecasting Future Cash Collections Using Aging Buckets
The forecast formula answers a different question: not what did we collect, but what should we expect to collect.
Cash Collections = Cash Sales + Estimated AR Collections
Cash Sales is the easy half, it is simply the cash revenue you expect in the period. Estimated AR Collections is the harder half, and it is built in four steps:
- Segment AR into aging buckets. Group outstanding receivables by how long they have been open, typically 0 to 30 days, 31 to 60 days, 61 to 90 days, and 90-plus days.
- Apply a historical collection rate to each bucket. Newer invoices collect at a much higher rate than older ones, so each bucket needs its own percentage based on what you have actually collected from similar invoices in the past.
- Multiply each bucket's balance by its collection rate. This gives you the expected collectible amount from that bucket alone.
- Sum the projected collections across all buckets, then add cash sales. That total is your forecasted cash collections for the period.
Worked example:
- 0 to 30 days: $300,000 outstanding, 90% historical collection rate = $270,000
- 31 to 60 days: $150,000 outstanding, 70% historical collection rate = $105,000
- 61 to 90 days: $80,000 outstanding, 40% historical collection rate = $32,000
- 90-plus days: $50,000 outstanding, 10% historical collection rate = $5,000
- Estimated AR Collections = $270,000 + $105,000 + $32,000 + $5,000 = $412,000
- Cash Sales for the period: $60,000
Cash Collections (forecast) = $60,000 + $412,000 = $472,000 expected
This method takes more work than the retrospective one, but it is the only one of the two that actually looks forward, which is the entire point of a cash forecast.
Which Method Should You Use
Use the retrospective formula when you are closing a period, reconciling actual cash inflow against your books, or reporting on what already happened. Use the prospective formula when you are building a cash forecast, planning working capital needs, or trying to anticipate a shortfall before it happens. Many finance teams end up running both every month: retrospective to check the prior period's actuals, prospective to plan the next one.
Cash Collections vs. Days Sales Outstanding (DSO)
Cash collections and DSO are frequently confused because they both describe how receivables turn into cash, but they answer different questions. DSO tells you the average number of days it takes to collect a receivable. Cash collections tells you the actual dollar amount you collected or expect to collect in a period. A company can have a stable DSO and still see its cash collections swing quarter to quarter if the volume of credit sales itself is changing. Tracking both together gives you a fuller picture than either number alone: DSO for collection speed, cash collections for collection volume.
Why Cash Collections Forecasting Matters for Working Capital Planning
The prospective calculation is not an academic exercise. Finance and treasury teams use it to decide whether they can cover payroll and vendor payments without drawing on a credit line, whether they are on track to meet a lender's working capital covenant, and how much cash is actually available for discretionary spending in a given month. A collections forecast that consistently overstates what will actually come in is one of the more common ways finance teams get blindsided by a cash crunch that their AR aging report, taken at face value, did not seem to predict.
Common Mistakes When Calculating Cash Collections
- Using stale collection rates. A collection rate calculated two years ago on a different customer mix will not reflect how your current customers actually pay. Refresh the rates at least quarterly.
- Ignoring bad debt write-offs. If you do not net out receivables you have already written off as uncollectible, your aging buckets overstate what is actually collectible.
- Treating every aging bucket as equally collectible. A flat collection rate applied across all buckets will systematically overstate collections from older, riskier receivables.
- Mixing up the two methods' inputs. Feeding a forecast-method input into the retrospective formula, or vice versa, is a common source of a number that looks plausible but does not reconcile to anything.
How to Automate Cash Collections Forecasting from Accounts Receivable
Both formulas above are only as good as the AR data feeding them, and that is usually where things break down at scale. Aging buckets built from a manual export get stale the moment a payment posts. Collection rates calculated in a spreadsheet rarely get refreshed often enough to reflect how customers are actually paying today. And when AR sits across multiple entities or ERPs, building one consolidated aging schedule is itself a manual project before the forecast even starts.
Bluecopa's AI-native finance operations platform keeps your AR aging schedule current in real time, continuously recalculates collection rates by bucket from your actual payment history, and rolls all of it up across entities so your cash collections forecast reflects what is happening today rather than what your data looked like at last month's close. For enterprise finance teams managing AR across multiple business units, that difference shows up directly in how much you can trust the forecast you are building working capital decisions on.
Frequently Asked Questions
1. What is the formula for cash collections from accounts receivable?
There are two. The retrospective formula is Beginning AR plus Credit Sales minus Ending AR, and it tells you what you actually collected in a closed period. The prospective formula is Cash Sales plus Estimated AR Collections, and it forecasts what you expect to collect based on an aging schedule and historical collection rates.
2. Why do I need two different formulas?
They answer two different questions. The retrospective formula is for reporting on a period that has already closed. The prospective formula is for forecasting a period that has not happened yet. Using the wrong one for the question you are actually asking is one of the more common sources of confusion with this calculation.
3. How do I build an AR aging schedule for the forecast method?
Segment your outstanding receivables into buckets based on how many days they have been open, typically 0 to 30, 31 to 60, 61 to 90, and 90-plus days, then apply a historical collection rate to each bucket based on what you have actually collected from similar invoices in the past.
4. Is cash collections the same as DSO?
No. DSO measures how long, on average, it takes to collect a receivable. Cash collections measures the actual dollar amount collected or expected in a given period. They are related but answer different questions, and tracking both gives a more complete view of AR performance.
5. How often should I recalculate my collection rates?
At least quarterly, and more often if your customer mix or payment terms change frequently. Collection rates calculated on outdated customer behavior will systematically skew your forecast.
