The cash collections formula is: cash collections = beginning accounts receivable + credit sales − ending accounts receivable. It tells you how much cash your customers actually paid you during a period. If you start the month owed $120,000 USD, invoice $200,000 USD on credit and finish the month owed $135,000 USD, you collected $185,000 USD.
That one line is the short answer. This guide goes further, because the formula is easy to get wrong once real ledgers get involved. Below you'll find four worked examples you can copy (a basic month, a month with write-offs and credit notes, a forward-looking collections schedule, and a collection effectiveness check), a table of the common variants, current benchmarks, and the mistakes that quietly inflate the number. The stakes are real: in Chaser's 2026 accounts receivable report, 92% of businesses said their invoices are typically paid after the due date.
What is the cash collections formula?
The cash collections formula measures the cash received from customers against invoices in a given period, usually a month or a quarter. It works because accounts receivable (AR) only moves in a few ways: it goes up when you invoice on credit, and it goes down when customers pay. Whatever you were owed at the start, plus what you invoiced, minus what you are still owed at the end, is what came in as cash.
The cash collections formula
Cash collections = beginning AR + credit sales − ending AR
- Beginning AR: the total your customers owed you on the first day of the period. It is the same number as last period's ending AR.
- Credit sales: everything you invoiced on credit during the period, net of any credit notes (returns and allowances). Cash sales are left out, because they never pass through AR.
- Ending AR: the total your customers still owed you on the last day of the period, including invoices that are not yet due.
This is the same logic accounting textbooks use to reconcile sales to cash. OpenStax's Principles of Accounting describes combining beginning accounts receivable with the period's sales to get the potential cash collected, then subtracting the ending accounts receivable balance to find the amount actually collected. The same roll-forward appears in its managerial accounting volume: beginning accounts receivable, plus sales, less cash collected, gives ending accounts receivable.
How to calculate cash collections: a worked example
Take a business with 30-day payment terms closing its books for September. Its figures come straight from the aged receivables report and the sales ledger.
| Line | September |
|---|---|
| Beginning AR (1 September) | $120,000 USD |
| Plus credit sales invoiced in September | $200,000 USD |
| Total available to collect | $320,000 USD |
| Minus ending AR (30 September) | $135,000 USD |
| Cash collections | $185,000 USD |
So $120,000 + $200,000 − $135,000 = $185,000 USD collected in September. Two simple ratios fall out of the same inputs, and both are worth tracking month to month:
- Collections as a share of what was available to collect: $185,000 ÷ $320,000 = 57.8%.
- Collections as a share of the month's credit sales: $185,000 ÷ $200,000 = 92.5%. This one can go above 100% in a month when you collect a lot of older debt.
If someone asks for your "collection rate" or "cash collection percentage", check which of these they mean before you answer, because the two numbers tell very different stories about the same month.
How to adjust the formula for write-offs and credit notes
The basic formula assumes the only thing that reduces AR is a customer paying. In a real ledger, two other things reduce AR without any cash arriving: credit notes (returns, allowances, and pricing corrections) and bad debts you write off. If you ignore them, the formula counts them as cash and overstates your collections.
AccountingTools flags exactly this weakness in the collection effectiveness index, which uses the same numerator: it assumes reductions in receivables are collections, while write-offs also reduce receivables and inflate the result. The Corporate Finance Institute lists sales returns and allowances as their own class of transaction, recorded as a credit to accounts receivable. The adjusted formula is:
Cash collections = beginning AR + credit sales − credit notes − bad debts written off − ending AR
Here is the same September, except this time the business issued $3,000 USD of credit notes and wrote off a $5,000 USD balance from a customer that became insolvent. Ending AR is therefore lower, at $127,000 USD.
| Line | Basic formula | Adjusted formula |
|---|---|---|
| Beginning AR | $120,000 USD | $120,000 USD |
| Plus credit sales | $200,000 USD | $200,000 USD |
| Minus credit notes | not deducted | $3,000 USD |
| Minus bad debts written off | not deducted | $5,000 USD |
| Minus ending AR | $127,000 USD | $127,000 USD |
| Cash collections | $193,000 USD | $185,000 USD |
The basic formula reports $193,000 USD, which is $8,000 USD of collections that never reached the bank. The adjusted formula gives the true figure of $185,000 USD. A quick way to check your answer is to reconcile it to your bank deposits from customers for the same period. If the two don't match, look for credit notes, write-offs, unallocated payments, or invoices posted to the wrong month.
Cash collections formula variants at a glance
"Cash collections" gets calculated several ways depending on what you are trying to answer. This table puts the common versions side by side, using the September figures above where they apply.
| Variant | Formula | Use it when |
|---|---|---|
| Basic collections | Beginning AR + credit sales − ending AR | You want a quick monthly figure and there were no write-offs or credit notes. |
| Adjusted collections | Beginning AR + credit sales − credit notes − write-offs − ending AR | You are reporting collections to leadership or reconciling to the bank. |
| Cash collected from customers (cash flow statement) | Sales revenue − increase in AR (or + decrease in AR) | You only have revenue and balance sheet figures, for example from annual accounts. Includes cash sales. |
| Schedule of expected cash collections | Sum of each month's sales × the share you expect to collect in this month | You are budgeting or forecasting future cash, not measuring the past. |
| Collection effectiveness index (CEI) | (Beginning AR + credit sales − ending total AR) ÷ (beginning AR + credit sales − ending current AR) × 100 | You want to judge how well the team collected what was actually due. |
| Days sales outstanding (DSO) | Ending AR ÷ credit sales for the period × days in the period | You want to know how many days of sales are sitting unpaid. |
A note on the cash flow statement version: if revenue includes cash sales, the result is all cash received from customers, not just collections from AR. In the September example, $15,000 USD of cash sales on top of $200,000 USD of credit sales gives revenue of $215,000 USD. With AR up $15,000 USD over the month, the cash flow statement figure is $215,000 − $15,000 = $200,000 USD, which is the $185,000 USD collected from AR plus the $15,000 USD of cash sales.
Want to see next month's collections before they happen?
Chaser's receivables forecast uses your live invoice data and each customer's actual payment behavior to show when cash is likely to arrive, weekly, monthly, or over a custom period.
See receivables forecastingHow to forecast cash collections with a collections schedule
The formula above looks backward. To look forward, finance teams build a schedule of expected cash collections: take each month's credit sales and spread them across the months in which you expect customers to pay. OpenStax describes the same method for budgeting: estimate how much is collected in the month of sale, the month after, two months after, and so on, and leave out the share you expect to be uncollectible.
Step 1: set your collection pattern from your own history
Use your aged receivables report and past payment dates to work out what share of a month's invoices is typically paid in the same month, the next month, and the month after. For this example, the pattern is 30% in the month of sale, 50% the following month, 18% two months later, and 2% never collected.
Step 2: apply the pattern to each month's credit sales
Credit sales were $180,000 USD in July, $200,000 USD in August and $220,000 USD in September, with $210,000 USD forecast for October and $190,000 USD for November.
| Source of cash | September (USD) | October (USD) | November (USD) |
|---|---|---|---|
| 30% of this month's sales | $66,000 | $63,000 | $57,000 |
| 50% of last month's sales | $100,000 | $110,000 | $105,000 |
| 18% of sales from two months ago | $32,400 | $36,000 | $39,600 |
| Expected cash collections | $198,400 | $209,000 | $201,600 |
The 2% that is never collected, for example $4,400 USD of September's sales, stays out of the schedule entirely and belongs in your bad debt provision instead.
Step 3: compare forecast to actual every month
At month end, run the backward-looking formula and compare the result with what the schedule predicted. A persistent gap usually means your pattern is out of date or one large customer is behaving differently from the rest. A single ledger-wide percentage hides that: a customer who always pays in 20 days and one who routinely pays in 70 days get averaged into a pattern that fits neither. Setting the pattern by customer, or at least by customer group, makes the schedule far more useful. This is the work receivables forecasting in Chaser automates, combining invoice data from your accounting system with average days-to-pay and past payment patterns for each customer.
How cash collections relate to CEI and DSO
Cash collections tells you how much came in. It doesn't tell you whether that was a good result, because a strong month of sales can hide a weak collections effort. Two metrics built on the same inputs answer that question.
Collection effectiveness index (CEI)
The Credit Research Foundation defines CEI as a measure of the effectiveness of collection efforts over time. Its numerator is the cash collections formula. Its denominator swaps ending total AR for ending current AR (invoices not yet due), so it measures collections against only what was actually collectible:
CEI = (beginning AR + credit sales − ending total AR) ÷ (beginning AR + credit sales − ending current AR) × 100
Back to September. Of the $135,000 USD still owed on 30 September, $95,000 USD is current and $40,000 USD is overdue. CEI = ($120,000 + $200,000 − $135,000) ÷ ($120,000 + $200,000 − $95,000) × 100 = $185,000 ÷ $225,000 × 100 = 82.2%. In plain terms, the team collected a little over four-fifths of the money that was due to be collected. For the full method, see the collection effectiveness index guide.
Days sales outstanding (DSO)
DSO converts your receivables into days of sales. The Credit Research Foundation formula is ending total receivables × number of days in the period ÷ credit sales for the period. Many teams use average receivables instead of the closing balance to smooth out month-end swings, which the DSO guide linked below explains. Using the CRF version for September, $135,000 × 30 ÷ $200,000 = 20.25 days. The CRF pairs this with "best possible DSO", which uses only current receivables: $95,000 × 30 ÷ $200,000 = 14.25 days. The gap between the two, 6 days, is the CRF's average days delinquent. For worked examples and how to read DSO against your payment terms, see the DSO formula guide.
The three metrics move together. Collect faster and cash collections rise, ending AR falls, DSO drops, and CEI climbs toward 100%. The difference is what each one isolates: cash collections is the amount, DSO is the speed, and CEI is the quality of the collection effort.
What is a good cash collections result?
There is no universal "good" cash collections figure, because it scales with your sales. Judge it through the ratios instead.
- CEI: the Credit Research Foundation's guidance is that the closer CEI is to 100 percent, the more effective the collection effort. Track your own trend month to month rather than chasing a single target.
- DSO: Allianz Trade's DSO and cash collection cycle report, published on 16 July 2026, put global DSO at 56.5 days in 2025 and UK DSO at 58 days. Compare your DSO with your own payment terms first. A DSO of 40 days is excellent on 45-day terms and poor on 14-day terms.
- Collections versus forecast: if you run a collections schedule, a month where actual collections land close to the forecast is a sign your collection pattern is realistic and your team is following up consistently.
Common mistakes when calculating cash collections
Most wrong answers come from the inputs, not the arithmetic. Check for these before you report the number.
- Using total sales instead of credit sales. Cash sales never go through AR. Adding them to the formula counts them as collections from customers who never owed you anything.
- Ignoring write-offs and credit notes. Both reduce ending AR without any cash arriving, so the basic formula overstates collections, as the $8,000 USD gap in the example above shows.
- Using net AR after a change in the bad debt provision. If your AR figure is shown net of a provision, a change in the provision moves ending AR even though no cash moved. Use gross customer balances.
- Mixing tax bases. If AR balances include sales tax or VAT, credit sales must include it too. Mixing the two distorts the answer.
- Mismatched periods. Beginning AR must be the balance on the first day of the same period your credit sales cover. Late-posted invoices or a period that closed early will skew the figure.
- Confusing collections with revenue. Revenue is recorded when you invoice. Collections are recorded when the cash arrives. A record sales month can be a weak collections month.
- Leaving unallocated cash out. A payment sitting in a suspense account hasn't reduced AR yet, so the formula won't count it until it is matched to invoices.
How to improve your cash collections
Every improvement shows up in the formula the same way: ending AR falls, so cash collections rise. To put a figure on it, a business with $200,000 USD of credit sales a month bills roughly $6,667 USD a day, so collecting five days faster on average releases about $33,000 USD of cash that would otherwise sit in AR. These are the levers that move it.
Follow up on every overdue invoice
In Chaser's 2026 accounts receivable report, businesses that follow up on 100% of overdue invoices were 76% more likely to be paid within one week of the due date than businesses that do not follow up on all of them. Consistency beats intensity: a reminder schedule that runs on every invoice does more than occasional chasing of the biggest balances.
Use more than one channel
The same report found that businesses combining SMS and email were 49% more likely to be paid within two weeks than businesses relying on email alone. Add a phone call for high-value or long-overdue accounts.
Automate the routine chasing
Businesses using accounts receivable automation software were 52% more likely to be paid within two weeks of the due date than those relying on manual processes, according to the same report. If you are comparing tools, the accounts receivable software comparison sets out the main options by business size.
Make paying you the easy option
Send accurate invoices promptly, include a payment link, and resolve disputes quickly, because a disputed invoice stays in ending AR until someone fixes it. If some customers still pay by paper check, accounts receivable conversion turns those checks into electronic payments so funds arrive sooner.
Know what late payment is costing you
In the UK, businesses can claim statutory interest on late business-to-business payments at 8% plus the Bank of England base rate, unless the contract sets a different rate. The late payment calculator works out the interest on any overdue invoice, which is useful both for claiming it and for showing customers what late payment costs.
FAQs
How do you calculate cash collections from accounts receivable?
Add beginning accounts receivable to credit sales for the period, then subtract ending accounts receivable. For example, $120,000 USD beginning AR plus $200,000 USD of credit sales minus $135,000 USD ending AR equals $185,000 USD collected. If you issued credit notes or wrote off bad debts in the period, subtract those too, because they reduce AR without bringing in cash.
How do you compute cash collected from customers?
For the statement of cash flows, cash collected from customers is sales revenue minus the increase in accounts receivable over the period, or plus the decrease. If revenue includes cash sales, the result covers all cash received from customers. If you only want collections from receivables, use beginning AR plus credit sales minus ending AR.
What is the formula for calculating the cash collection cycle?
The cash collection cycle, also called the cash conversion cycle, is days inventory outstanding plus days sales outstanding minus days payable outstanding. It shows how long cash spent on operations takes to come back as cash collected from sales. For a service business with no inventory, it reduces to DSO minus DPO.
How do you calculate daily cash collection?
Divide total cash collections for the period by the number of days in it. A business that collected $185,000 USD in a 30-day month averaged about $6,167 USD a day. For day-to-day tracking, total the customer receipts that land in the bank each day and compare them with the invoices that fell due.
What does cash collected mean in sales?
Cash collected is the money customers have actually paid, as opposed to the sales you have booked or invoiced. A sale on 30-day terms counts as revenue when you invoice it but only counts as cash collected when the payment arrives, which is why sales teams and finance teams can report very different numbers for the same month.
What happens when a company collects cash from accounts receivable?
The company debits cash and credits accounts receivable. One asset goes up and another goes down by the same amount, so total assets and revenue don't change. The revenue was already recorded when the invoice was raised. The collection simply turns the amount owed into cash in the bank.
What is the cash collection process?
The cash collection process is everything between issuing an invoice and matching the payment to it: sending an accurate invoice, reminding the customer before and after the due date, resolving queries and disputes, taking the payment, and allocating it to the right invoice. A consistent process that follows up on every overdue invoice brings cash in faster.
How do you prepare a schedule of expected cash collections?
Start with forecast credit sales for each month. Apply your historical collection pattern, for example 30% in the month of sale, 50% the next month, and 18% the month after. Add up the amounts falling in each month and leave out the share you expect never to collect, which belongs in your bad debt provision.
Collect more of what you're owed, every month
Chaser automates reminders by email, SMS, and phone, shows you which invoices are at risk of late payment, and forecasts when cash will arrive, so your collections number goes up and stays predictable.
Speak to an expert See receivables forecastingFormulas checked against OpenStax Principles of Accounting (volumes 1 and 2), AccountingTools, the Corporate Finance Institute, and the Credit Research Foundation's performance measures. DSO benchmarks from Allianz Trade's report of 16 July 2026. Late payment and follow-up figures from Chaser's 2026 accounts receivable report. Every worked example was recalculated before publication. Last reviewed 25 September 2026.