How to Calculate Cash Collections: Formula, Examples & AR Process
Cash collections are the payments a business receives from customers during a specific period. To calculate cash collections from accounts receivable, a commonly used simplified formula is:
Cash Collections = Beginning Accounts Receivable + Credit Sales − Ending Accounts Receivable
This formula works when there are no other material adjustments to accounts receivable. If the period includes write-offs, credit memos, returns, discounts, or other adjustments, those items must also be considered when reconciling accounts receivable to actual cash received.
Cash collections are important because they show how effectively a business converts credit sales and outstanding receivables into cash. Finance teams use collection data for liquidity planning, working capital management, cash forecasting, accounts receivable analysis, and evaluating the effectiveness of the accounts receivable process.
Cash Collections Formula
The simplest formula for calculating cash collections from accounts receivable is:
Cash Collections = Beginning AR + Credit Sales − Ending AR
| Variable | Meaning |
|---|---|
| Beginning AR | Accounts receivable balance at the start of the period |
| Credit Sales | Credit sales recorded during the period |
| Ending AR | Accounts receivable balance at the end of the period |
The formula works because accounts receivable generally increases when credit sales are recorded and decreases when customers pay. Therefore, the movement in AR can be used to estimate the cash collected during the period.
How to Calculate Cash Collections Step by Step
Step 1: Find Beginning Accounts Receivable
Start with the accounts receivable balance at the beginning of the reporting period. This represents the amount customers owed the business before the period’s new sales and collections occurred.
Step 2: Add Credit Sales
Add credit sales recorded during the same period. Credit sales increase accounts receivable because the customer has received the product or service but has not necessarily paid yet.
Step 3: Find Ending Accounts Receivable
Determine the accounts receivable balance at the end of the period.
Step 4: Apply the Simplified Formula
Subtract ending accounts receivable from beginning accounts receivable plus credit sales.
Cash Collections = Beginning AR + Credit Sales − Ending AR
Step 5: Reconcile Other AR Adjustments
If the business recorded credit memos, write-offs, returns, discounts, or other transactions that changed accounts receivable without representing customer cash collections, those items must be included in the reconciliation.
This distinction is important when calculating actual cash received rather than using the simplified formula as an approximation.
Cash Collections Calculation Example
Assume a company has the following balances for one accounting period:
- Beginning accounts receivable: $120,000
- Credit sales: $300,000
- Ending accounts receivable: $150,000
Using the simplified cash collections formula:
Cash Collections = $120,000 + $300,000 − $150,000
Cash Collections = $270,000
Based on these figures and assuming there are no other material AR adjustments, the company collected approximately $270,000 from customers during the period.
Cash Collections Formula With AR Adjustments
The simple formula should not be used in isolation when accounts receivable contains other transactions that affect the balance.
A more complete reconciliation starts with the relationship:
Ending AR = Beginning AR + Credit Sales − Cash Collections ± AR Adjustments
Therefore, actual cash collections can be derived by adjusting the calculation for transactions such as:
- Credit memos
- Customer returns
- Bad-debt write-offs
- Discounts and allowances
- Debit memos
- Other non-cash changes to accounts receivable
The exact treatment depends on how each transaction affects the AR ledger. For financial reporting and reconciliation, finance teams should use the underlying accounting records rather than assuming every change in AR represents cash received.
Cash Collected From Customers vs Revenue
Cash collected from customers is not the same as revenue.
Revenue may be recognized when goods or services are delivered under the applicable accounting rules, even when the customer has not yet paid. Cash collections occur when the customer actually settles the receivable.
| Revenue | Cash Collections |
|---|---|
| Represents revenue recognized during a period | Represents customer payments received |
| May be recorded before payment | Requires actual cash receipt |
| Can increase accounts receivable when sold on credit | Normally reduces accounts receivable when applied |
This distinction is particularly important when analyzing businesses with significant credit sales or long customer payment cycles.
How Accounts Receivable Affects Cash Collections
Accounts receivable represents amounts owed by customers. When a customer pays an outstanding invoice, the company records the cash receipt and reduces the corresponding receivable.
For example, if a customer pays a $25,000 invoice:
| Account | Debit | Credit |
|---|---|---|
| Cash | $25,000 | — |
| Accounts Receivable | — | $25,000 |
The transaction increases cash and decreases accounts receivable by the same amount.
Understanding what happens when a company collects cash from accounts receivable helps finance teams connect AR activity with actual cash movement.
Schedule of Expected Cash Collections
A schedule of expected cash collections is a forecasting tool that estimates when customer payments are expected to be received.
Unlike the historical cash collections formula, an expected collections schedule is forward-looking. It uses information such as outstanding receivables, credit sales, payment terms, historical payment behavior, and expected collection timing.
Typical Cash Collections Schedule
| Collection Period | Expected Cash Inflow |
|---|---|
| Current period | Payments expected during the current period |
| Within 30 days | Expected near-term customer payments |
| 31–60 days | Expected medium-term collections |
| 61–90 days | Expected later collections |
| 90+ days | Potentially higher-risk or delayed collections |
Companies use these schedules to estimate future cash availability and plan payroll, supplier payments, operating expenses, investments, and financing requirements.
How to Calculate Cash Collected From Accounts Receivable
To calculate cash collected from accounts receivable for a historical period, finance teams can follow this process:
- Obtain the beginning AR balance.
- Identify credit sales recorded during the period.
- Obtain the ending AR balance.
- Calculate collections using the simplified formula.
- Identify non-cash AR adjustments.
- Reconcile the result with cash receipts and bank records.
- Investigate differences and unresolved transactions.
The final reconciliation should agree with the organization’s cash receipts records after considering the relevant accounting adjustments.
How Cash Collections Appear in Financial Statements
Balance Sheet Impact
When a customer pays an outstanding receivable, cash increases and accounts receivable decreases.
The accounts receivable balance decreases while the cash balance increases. Total assets do not necessarily increase from the collection itself because one asset—receivables—is converted into another asset—cash.
Cash Flow Statement Impact
Customer collections contribute to operating cash flow. Under the indirect method, changes in accounts receivable are among the working-capital adjustments used to reconcile accrual-based net income to operating cash flow.
The operating section of the cash flow statement therefore provides another way to analyze the relationship between receivables and cash generated from operations.
A decrease in accounts receivable cash flow adjustment indicates that customers paid outstanding invoices, although the complete operating-cash-flow calculation also depends on other working-capital and operating adjustments.
Cash Collections and the Cash Flow Statement
Cash collections are an important component of operating cash flow because customer payments convert receivables into cash.
However, a company can have strong revenue growth without immediately generating the same amount of cash. If receivables increase faster than collections, more cash remains tied up in unpaid customer invoices.
This is why finance teams monitor both revenue growth and cash conversion.
Key Metrics for Measuring Collection Efficiency
Cash collections should be analyzed together with AR performance metrics to understand how efficiently a business converts receivables into cash.
Average Collection Period
The collection period for accounts receivable formula calculates the average number of days required to collect customer receivables.
Average Collection Period = Average Accounts Receivable ÷ Average Daily Credit Sales
A lower collection period generally indicates that receivables are being converted into cash more quickly, although the appropriate target depends on customer terms and industry conditions.
Days Sales Uncollected
Days sales uncollected estimates how many days of sales remain outstanding in accounts receivable.
Days Sales Uncollected = (Accounts Receivable ÷ Annual Credit Sales) × 365
This metric can help identify changes in customer payment behavior and collection performance.
Debtors Collection Formula
The debtors collection formula can be used to analyze customer payment behavior and collection performance. The exact formula used can vary depending on the accounting context and the metric being measured.
Cash Collections vs Cash Collection Rate
Cash collections measure the amount of customer cash received, while a cash collection rate is generally a performance ratio that compares collections with a relevant receivables or billing base.
These should not be treated as interchangeable metrics. A company may collect a large dollar amount while still experiencing weak collection performance if its receivables portfolio is growing even faster.
Cash Realizable Value of Accounts Receivable
Cash realizable value represents the estimated amount of accounts receivable that a business expects to collect after considering amounts that may not be recoverable.
This concept is different from actual cash collections. Cash collections represent money actually received, while cash realizable value is an estimate of what outstanding receivables are expected to generate.
Allowance for Doubtful Accounts
Companies may maintain an allowance account to estimate uncollectible receivables. The allowance helps financial statements reflect the estimated collectible value of receivables rather than assuming every outstanding invoice will be collected in full.
Cash Collection Management Best Practices
Effective cash collection management combines appropriate credit policies, accurate invoicing, customer communication, dispute resolution, payment tracking, cash application, and performance monitoring.
1. Establish Clear Credit Policies
Credit policies help determine appropriate customer terms, limits, approval requirements, and escalation procedures before sales are made on credit.
2. Invoice Accurately and on Time
Accurate invoices reduce avoidable disputes and give customers the information needed to make timely payments.
3. Use Proactive Payment Reminders
Payment reminders can be sent before and after due dates according to customer-specific collection strategies.
4. Resolve Disputes Quickly
Billing disputes, deductions, short payments, and service issues can delay otherwise collectible invoices. Structured dispute workflows help identify ownership and move cases toward resolution.
5. Apply Customer Payments Accurately
Receiving cash is only part of the process. Payments also need to be matched and posted correctly so customer balances and AR reporting remain accurate.
6. Monitor Collection KPIs
Track collection period, overdue receivables, DSO, days sales uncollected, unapplied cash, dispute volume, and other metrics relevant to the business.
Operational Cash Collection Process
The cash collection process connects invoicing, customer communication, payment receipt, cash application, reconciliation, and account settlement.
- Customer order: The customer places an order under agreed commercial and credit terms.
- Invoice generation: The business issues an invoice after delivering the relevant goods or services.
- Receivable recording: The invoice becomes an accounts receivable balance.
- Payment monitoring: Finance teams track the invoice against its due date.
- Collection follow-up: Reminders and collection activities occur when appropriate.
- Payment receipt: The customer submits payment through an applicable payment channel.
- Cash application: The payment is matched to the appropriate customer and invoice or invoices.
- Reconciliation: The transaction is reconciled with bank and accounting records.
- Account settlement: The customer’s receivable balance is updated or cleared.
Example of Cash Collections in an Enterprise AR Process
- A customer places an order.
- The business delivers the product or service.
- An invoice is issued and recorded as accounts receivable.
- The invoice reaches its due date.
- The collections team follows up according to the customer’s payment status.
- The customer submits payment.
- The payment is matched to the outstanding invoice.
- Cash is posted to the accounting system.
- The customer’s AR balance is reduced.
This workflow illustrates what happens when a company collects cash from accounts receivable and how the collection moves from customer payment to the accounting ledger.
Challenges in Managing Cash Collections
Delayed Customer Payments
Late payments can reduce liquidity, increase outstanding receivables, and make cash forecasting less predictable.
Manual Reconciliation
Manual reconciliation can increase processing time and make it harder to identify discrepancies between bank transactions, payments, invoices, and customer accounts.
Incomplete Payment Information
Missing or unclear remittance information can make it difficult to identify which invoices should be cleared, creating unapplied cash and additional manual work.
Disputes and Deductions
Disputes, deductions, short payments, and pricing differences can delay settlement even when a customer has already submitted a partial payment.
Fragmented Financial Data
When billing, ERP, bank, collections, and cash application information is spread across different systems, finance teams may lack a complete view of collection performance.
How Automation Can Improve Cash Collections
Automation can connect invoicing, collections, payment information, cash application, reconciliation, and reporting to reduce repetitive manual activities.
Automated Collections
Collections software can prioritize accounts, schedule follow-ups, automate reminders, and help collectors focus on higher-priority accounts. Emagia’s current collections platform, for example, describes risk-based dunning, customer segmentation, automated reminders, dispute management, and promise-to-pay tracking.
AI-Powered Payment Matching
AI-powered cash application can capture payment and remittance information, match payments against open invoices, identify exceptions, and post approved transactions into ERP systems. Emagia currently describes support for payments from banks, lockboxes, emails, PDFs, portals, and other sources, along with AI-based matching and ERP posting.
Predictive Collection Insights
Analytics and AI can help identify payment patterns, prioritize collection activities, and highlight accounts that may require earlier intervention. The value depends on the quality of the underlying data, configured strategies, and human oversight.
Real-Time Receivables Visibility
Integrated AR platforms can provide a consolidated view of receivables, collections, disputes, cash application, and customer payment behavior. This can help finance teams identify issues earlier and make more informed working-capital decisions.
How Emagia Helps Improve Cash Collections
Managing cash collections at enterprise scale requires coordinated processes across credit, invoicing, collections, cash application, disputes, and receivables reporting.
Emagia’s current accounts receivable platform combines AI-powered credit, collections, cash application, deductions, invoicing and analytics capabilities within an integrated AR environment.
Intelligent Receivables Automation
Emagia provides automation across receivables processes, including collections and cash application, with analytics designed to give finance teams greater visibility into AR performance.
AI-Driven Collection Prioritization
Emagia’s collections solution uses payment behavior, invoice aging, customer segmentation, and risk signals to prioritize collection activities and support automated dunning workflows.
AI-Powered Cash Application
Emagia’s cash application technology uses AI and machine learning to match incoming payments with invoices, extract remittance information, handle exceptions, and post approved cash into ERP systems.
Unified AR Visibility
Emagia brings credit, collections, cash application, deductions, and receivables analytics together so finance teams can analyze collection performance across the broader order-to-cash process.
These capabilities are most relevant to organizations managing high transaction volumes, multiple payment channels, complex receivables portfolios, and enterprise-scale O2C operations.
Frequently Asked Questions About Cash Collections
What is cash collection in accounting?
Cash collection is the receipt of money from customers for goods or services that have been sold. When a customer pays an outstanding invoice, the payment normally reduces accounts receivable and increases cash.
How do you calculate cash collections?
The simplified formula is Beginning Accounts Receivable + Credit Sales − Ending Accounts Receivable. If there are material AR adjustments such as credit memos, write-offs, returns, or other non-cash changes, those items should also be included in the reconciliation.
How do you calculate cash collected from accounts receivable?
Start with beginning accounts receivable, add credit sales, subtract ending accounts receivable, and then reconcile the result for other transactions that affected AR without representing customer cash collections.
What is a schedule of expected cash collections?
A schedule of expected cash collections is a forward-looking estimate of when customers are expected to pay outstanding invoices. It is used for cash forecasting and liquidity planning.
What happens when a company collects cash from accounts receivable?
When a customer payment is applied to an outstanding receivable, cash increases and accounts receivable decreases by the amount applied.
How does accounts receivable affect cash flow?
When customers pay outstanding receivables, cash increases. In the indirect cash-flow statement, changes in accounts receivable are also used as part of the reconciliation from accrual-based net income to operating cash flow.
What is cash realizable value?
Cash realizable value is the estimated amount of accounts receivable a company expects to collect after considering amounts that may be uncollectible. It is an estimate, not the same as actual cash collections.
What is the difference between cash collections and expected cash collections?
Cash collections are actual customer payments received during a period. Expected cash collections are forecasted payments that a company expects to receive in a future period.
How can businesses improve cash collections?
Businesses can improve collections by establishing appropriate credit policies, issuing accurate invoices on time, communicating payment expectations, resolving disputes quickly, prioritizing overdue accounts, and automating collections and cash application where appropriate.
What role does cash application play in cash collections?
Cash application identifies the customer and invoice associated with an incoming payment and records the payment against the appropriate receivable. Accurate cash application helps keep customer balances and collection reporting current.
Conclusion
How to calculate cash collections starts with understanding the relationship between accounts receivable and customer payments. The simplified formula—Beginning AR + Credit Sales − Ending AR—provides a useful starting point for calculating collections when there are no material additional AR adjustments.
For accurate financial analysis, finance teams should also reconcile credit memos, write-offs, returns, discounts, other AR adjustments, and actual bank receipts. Cash collections should then be analyzed alongside collection-period metrics, days sales uncollected, aging, disputes, and cash application performance.
For enterprise finance teams, automation can connect collections, payment matching, reconciliation, and receivables visibility, helping teams move from manually tracking customer payments to a more structured and data-driven cash collection process.
