Cash Receipts from Accounts Receivable Calculator

Calculator

Currency Symbol

Beginning Accounts Receivable

Gross Credit Sales

Sales Returns

Sales Allowances

Cash Discounts

Bad Debt Write-Offs

Other Receivable Debits

Other Non-Cash Credits

Ending Accounts Receivable

Recovered Written-Off Cash

Period Days

Target Collection Rate (%)

Formula Used

Net Credit Sales = Gross Credit Sales − Sales Returns − Sales Allowances − Cash Discounts

Receivables Available = Beginning A/R + Gross Credit Sales + Other A/R Debits − Returns − Allowances − Discounts

Cash Receipts from Current A/R = Receivables Available − Write-Offs − Other Non-Cash Credits − Ending A/R

Total Cash Receipts = Cash Receipts from Current A/R + Recovered Written-Off Cash

A/R Turnover = Net Credit Sales ÷ Average Accounts Receivable

Days Sales Outstanding = Ending A/R ÷ Net Credit Sales × Period Days

How to Use This Calculator

Enter the beginning accounts receivable balance.
Add gross credit sales for the selected period.
Enter returns, allowances, discounts, and write-offs.
Add other receivable debits or non-cash credits if needed.
Enter the ending accounts receivable balance.
Add recovered written-off cash if it applies.
Set period days and target collection rate.
Press calculate to view cash receipts and efficiency ratios.
Use CSV or PDF buttons to save the report.

Example Data Table

Input	Example Value	Meaning
Beginning A/R	$50,000	Customer balance at period start.
Gross Credit Sales	$180,000	Sales made on account.
Returns and Allowances	$9,000	Credits that reduce customer balances.
Cash Discounts	$2,500	Discounts granted for early payment.
Write-Offs	$4,000	Receivables removed without cash collection.
Ending A/R	$62,000	Customer balance at period end.
Recovered Written-Off Cash	$1,200	Cash from previously written-off accounts.

Understanding Cash Receipts from Receivables

Cash receipts from accounts receivable show how much cash a business collected from credit customers during a period. The figure links sales activity with bank movement. It is important because revenue can rise while cash stays weak. A company may sell more on account, but customers may still pay late.

Why This Calculation Matters

Managers use this calculation to test collection performance. Accountants use it when preparing cash flow statements. Lenders may review it to judge liquidity. The method starts with opening receivables. It then adds credit sales. It subtracts non cash reductions, write offs, and the closing receivable balance. The remainder is the estimated cash received from customers.

Good receivable control protects working capital. It reduces borrowing pressure. A high collection amount means invoices are being converted into cash. A low result may signal disputed invoices, weak follow up, poor customer terms, or slow approval processes. The calculator shows turnover, average receivables, and days sales outstanding. These measures help explain the result.

Using Advanced Inputs

This tool accepts returns, allowances, cash discounts, bad debt write offs, other receivable debits, and non cash credits. These items are important. They change accounts receivable without creating cash. For example, a write off lowers receivables but does not bring money into the bank. A discount reduces the invoice amount collected. A return reverses part of a sale.

The recovered written off amount is shown separately. It represents cash collected on balances removed in an earlier period. You can include it when you want total cash related to customer receivables. You can exclude deposits or cash sales because they do not start as accounts receivable.

Interpreting the Output

The final cash receipt figure should be compared with bank deposits, customer ledger reports, and cash flow schedules. Small differences can occur because of timing, bank charges, taxes, or posting cut offs. Large differences need review. Check whether credit sales are net or gross. Check whether returns and discounts were already deducted.

Use the collection rate and target gap for planning. A strong rate supports short term cash needs. A weak rate may require stricter credit checks, clearer payment terms, or faster reminders. Review the result every month for solid control.

FAQs

What are cash receipts from accounts receivable?

They are cash collections received from customers who previously bought goods or services on credit. The amount helps connect receivable balances with real cash flow.

Why are write-offs subtracted?

Write-offs reduce accounts receivable, but they do not create cash. They must be removed so the calculator does not overstate customer collections.

Should I enter credit sales as gross or net?

Enter gross credit sales if you also enter returns, allowances, and discounts. If your sales figure is already net, set those adjustment fields to zero.

What is recovered written-off cash?

It is money collected from an account that was written off in a prior period. This calculator adds it separately to total receivable-related cash receipts.

What does collection rate show?

Collection rate compares estimated cash receipts with receivables available for collection. It helps judge how effectively credit balances turned into cash.

What does days sales outstanding mean?

Days sales outstanding estimates how many days of credit sales remain in ending receivables. A lower value often means faster collection.

Can this replace accounting records?

No. It is an estimation and analysis tool. Always compare results with customer ledgers, bank deposits, and official accounting reports.

Why might the result be negative?

A negative result may mean ending receivables are too high, adjustments were duplicated, or sales were entered incorrectly. Review all input fields carefully.