Receivables Collection Scenario Calculator

Read the calculator result

An outstanding invoice is an amount owed to your business. It isn’t necessarily cash available for next week’s payroll. This calculator estimates how much of four invoice groups you expect to collect during one chosen period, then combines those receipts with opening cash and other inflows. The result shows whether the entered period’s planned outflows are covered.

The distinction between timing and loss matters. If an invoice remains unpaid at the end of your chosen month, it may still be collected later. This tool reports amounts remaining uncollected within the period. It doesn’t label them uncollectible, estimate a lifetime default probability, create an accounting allowance, or determine a tax deduction. The percentages are your scenario assumptions, not published collection benchmarks.

OpenStax’s discussion of receivables aging explains how outstanding accounts can be grouped by how long they are past due. Its accounting example uses aging to estimate uncollectible amounts. This calculator borrows the useful grouping structure but asks a different question: how much cash might arrive during the same explicitly chosen collection period?

Receivables collection: choose the period before entering percentages

Write down a snapshot date and a collection horizon before using the form. For example, take the invoices outstanding on October 31 and estimate receipts from those invoices during November. Every percentage should answer that same question. Mixing a current-invoice percentage for one month with an older-invoice percentage for six months produces a total with no consistent meaning.

Enter each invoice once. The four groups are current, 1–30 days past due, 31–60 days past due, and more than 60 days past due. Classify invoices using their due dates and the snapshot date, rather than silently substituting days since issue. A recently issued invoice can already be overdue under short payment terms, while an older invoice may still be current under longer terms.

Use the unpaid balance after payments and recognized adjustments. A partially settled invoice contributes only its remaining amount. Reconcile the four groups to the receivables report you intend to model. Keep a separate record explaining the treatment if you remove disputed balances or customer credits. The calculator can’t detect duplicated invoices, inconsistent signs, or an aging report exported before a recent payment was posted.

For each group, enter the fraction expected to arrive during the period. Support that assumption with your own payment history, customer commitments, disputes, and collection activity. A large customer can dominate a group, so a percentage based on a few small invoices may be unrepresentative. The model keeps the assumptions visible rather than treating an older balance as automatically lost.

How the calculator works

For each bucket, expected collection = outstanding balance × entered collection percentage ÷ 100. Uncollected balance equals that bucket’s starting balance minus expected receipts. Adding across the four groups gives total receivables, total modeled collections, and the amount that remains outside the chosen collection window.

The overall percentage is balance weighted: weighted collection percentage = total expected collections ÷ total receivables × 100. It isn’t the simple average of the four percentages. A $30,000 group should influence the result more than a $5,000 group. When total receivables are zero, the weighted percentage is undefined, while the separate cash calculation still works.

Available period cash equals starting cash plus other entered inflows plus expected collections. Subtract planned outflows to find ending cash. A negative result becomes the reported funding shortfall; a positive result becomes the cash surplus. The calculator doesn’t insert a loan to close a shortfall, charge interest on it, or assume unused receivables can be spent.

Receivables collection calculator example: $60,000 in receivables

The default scenario contains $30,000 current invoices, $15,000 that are 1–30 days overdue, $10,000 that are 31–60 days overdue, and $5,000 older than 60 days. Entered collection assumptions are 90%, 80%, 60%, and 30%, respectively. These figures illustrate the arithmetic; they don’t describe a typical U.S. business or a recommended collections target.

The four expected receipts add to $46,500. Dividing that amount by $60,000 gives 77.5%. Simply averaging 90%, 80%, 60%, and 30% would give 65%, which understates the modeled proportion because the largest balance has the highest entered collection rate. Multiplying the incorrect average by receivables would predict only $39,000.

Now add $5,000 opening cash and no other inflows. Available cash is $51,500. Planned outflows of $50,000 leave $1,500 at period end. The $13,500 of uncollected receivables is still outside that cash balance. A positive result doesn’t mean all invoices were paid or that the business can safely ignore the collection assumptions.

Stress the largest collection assumption

Reduce only the current-invoice rate from 90% to 80%. Receipts from that $30,000 bucket fall by $3,000, from $27,000 to $24,000. Total expected collections become $43,500, and ending cash becomes negative $1,500. The default’s apparent cushion disappears even though the overdue groups haven’t changed.

In this specific example, the other three groups contribute $19,500. Covering $50,000 of outflows with $5,000 opening cash therefore requires $25,500 from current invoices. That’s 85% of the $30,000 current balance. This manually derived threshold tells you which assumption deserves attention; it doesn’t prove that 85% is achievable.

If an independently supported $2,000 other inflow is added to the weaker 80% scenario, ending cash becomes $500. Identify the source and date before treating it as available. A loan advance, owner contribution, customer deposit, and sale of equipment have different consequences even when they add the same dollars to this period’s arithmetic.

Keep the original forecast alongside actual receipts when the period closes. For each group, compare the predicted dollars with the payments actually received from that same opening invoice population. A payment from a newly issued invoice belongs elsewhere in that comparison. This discipline helps distinguish a bad timing assumption from a changed starting balance, and provides a more relevant basis for the next forecast than judging accuracy from the final bank balance alone.

Read the original chart without double counting

The chart pairs each aging group’s balance with its expected receipts. Both bars refer to the same invoices: receipts are a portion of the balance, not an additional asset. The matching tables show exact bucket dollars, assumptions, and uncollected amounts. Don’t add balance bars and collection bars together to calculate available cash.

Changing the current-invoice percentage alters its receipt bar and the cash summary while leaving its starting-balance bar unchanged. That behavior helps distinguish an assumption about timing from a correction to the invoice ledger. A change to planned outflows affects the cash result but doesn’t change invoice collection bars, because the receivable inputs themselves are unchanged.

Check concentration and posting dates

Before using the result, identify the largest invoices within each group. A single payment can determine whether the expected amount arrives. You can run separate scenarios for a key customer paying in full, paying partly, or paying after the horizon. Record the actual dollar change rather than assuming the same percentage adjustment has equal significance in every bucket.

The calculator aggregates the whole period. A $1,500 positive month-end result can coexist with a midmonth shortage if bills precede customer payments. Use the cash-flow calendar to examine dated receipts and bills. Enter only supported timing assumptions, and remember that same-day netting in a daily model also can’t establish your bank’s intraday posting order.

Keep new sales separate from the opening receivables snapshot. If cash from new invoices is included in other inflows, don’t also include those same invoices in the opening balances. At the next review, rebuild the snapshot from the updated ledger. Rolling the previous uncollected amount forward without matching actual payments can gradually duplicate or omit balances.

Receivables collection calculator questions

Does 30% collected mean 70% will never be paid?

No. It means 30% is assumed to arrive within your chosen period. The remaining 70% may be delayed, disputed, partly settled later, or ultimately lost. Those possibilities require separate evidence. This calculator doesn’t convert a period timing assumption into an accounting loss estimate.

Can I use historical percentages without changing them?

You can enter them as a starting scenario, but check whether they measure the same horizon and invoice population. Changes in customer concentration, payment terms, disputes, seasonality, or collection procedures can make the old comparison less useful. Document what the historical percentage actually describes before applying it.

What if every aging balance is zero?

Expected collections are zero and the overall collection percentage is undefined. Starting cash and other inflows can still cover outflows. This is preferable to inventing a 100% collection rate for a business with nothing outstanding, or dividing by zero and presenting a meaningless result.

Which related calculator answers a different question?

The cash conversion cycle calculator measures entered average receivable, inventory, and payable days. The invoice factoring calculator examines an entered financing offer. Neither turns this collection estimate into guaranteed cash. Use each tool for its own decision, then reconcile the assumptions before combining results.