Client story and review analysis
MCA Debt and Unpaid Invoices: Building an Accounts Receivable Aging Report
An invoice is not available cash until the customer pays. An aging report helps a business see which receipts are late, which are disputed and which dates remain uncertain. MCA withdrawals can continue while those invoices remain unpaid.
The aim of this guide is to make accounts receivable aging usable in an ordinary business review. Start with a small worksheet, check the inputs and connect the result to a real decision. Keep hypothetical arithmetic separate from your own records and from any customer story used for context.
Distinguish overdue from doubtful
Age alone does not tell the whole collection story. A recent invoice may be disputed, while an older invoice may have a documented payment plan. Add a short status note beside each major balance and separate the amount from the expected collection date. If part of an invoice has been paid, show only the unpaid balance in the aging total. Check for credit notes so that the report does not overstate the cash the business expects to collect.
Use the report to prioritize action, not to assume every old invoice is lost. Assign a follow-up based on the actual cause of delay and bring material uncertainty into the forecast. This helps the business avoid treating its receivables total as cash available for the next MCA withdrawal.
Set up the analysis
List each open invoice once, with its due date, unpaid balance and payment status. Use buckets based on days past due, not simply days since the invoice was issued. Keep not-yet-due invoices in their own group.
Worked illustration
A company has $30,000 open: $12,000 not yet due, $8,000 one to thirty days late, $6,000 thirty-one to sixty days late and $4,000 older. Those buckets total $30,000. They do not mean $30,000 will arrive this week.
All figures in this illustration are hypothetical and chosen to show the calculation. They are not results achieved by Coastal Debt Resolve or any named customer. Replace them with current records and include other relevant costs before relying on a model for an actual commitment.
Build a working record
Use the following headings in a private worksheet. Fill the cells with the business’s own records, not guessed figures or facts borrowed from another customer. Keep the source alongside the answer so a partner or adviser can follow the reasoning. A blank cell is a useful signal that a question remains open.
| Field | What to record | How to use it |
|---|---|---|
| Customer and invoice | The actual customer and invoice for your business, with its source and date. | Establish the starting point before comparing options. |
| Amount unpaid | The actual amount unpaid for your business, with its source and date. | Check the underlying record and resolve differences. |
| Contractual due date | The actual contractual due date for your business, with its source and date. | Carry the confirmed information into the next discussion. |
| Days past due | The actual days past due for your business, with its source and date. | Identify the assumption that could change the decision. |
| Collection action | The actual collection action for your business, with its source and date. | Assign a practical next action and review date. |
Keep estimates visibly labeled. If a figure changes, preserve the earlier value and note the reason for the revision. This is especially helpful when a partner joins the discussion later and needs to understand why the current position differs from the first version. The worksheet is a working aid, not a substitute for the underlying documents.
A practical sequence
- Reconcile the total to the receivables ledger.
- Identify disputes and missing approvals.
- Assign a realistic collection follow-up date.
- Move expected cash into the forecast only with an explicit assumption.
Complete the sequence in order. If an early input is missing, identify that gap before giving a later calculation more precision than it deserves. A rough estimate can still be useful when it is labeled honestly and tested for sensitivity. A precise result built from an unsupported input can be much less useful.
Use actual cash dates
A plan for accounts receivable aging needs a calendar as well as totals. Record when receipts are likely to clear and when cash is expected to leave. A monthly total can look workable while a payment falls due before the supporting receipt arrives. In particular, connect customer and invoice and collection action to actual dates where that information is available.
Keep the most important timing assumptions visible. A customer’s expected payment date should be described as expected until the cash clears. If the date slips, update the forecast and the action list together. Moving the date without changing the operating response can conceal the same shortfall in a later week.
Check capacity as well as affordability
An apparently affordable plan for accounts receivable aging may still depend on staff time, supplier availability or customer demand that the business does not have. Review the operational limit alongside the cash calculation. A positive forecast cannot make an unavailable resource appear.
Discuss the plan with the people responsible for delivering it. Ask what must happen first and what could interrupt the sequence. This can reveal overlooked training, setup, approval or delivery costs before they become urgent. Bring material changes back into both the operating estimate and the cash calendar.
Model one change at a time
A scenario is easier to understand when the first test changes one important input. If price, volume, costs and timing all move together, the owner may not know which assumption caused the result. Start with the input most likely to affect the decision, then add a combined downside case if useful.
Record the original value, the changed value and the reason for the test. The result should identify a practical sensitivity rather than produce a dramatic number. A business might discover that collection timing matters more than a small cost saving, or that a modest price reduction removes most of the available contribution. Use that finding to focus the next discussion.
Keep internal transfers out of revenue
Moving money between the business’s accounts does not create a new customer receipt. Similarly, funding proceeds should not be confused with sales. Identify these movements separately so the review shows whether ordinary operations are generating cash or whether the balance is being supported by transfers and financing.
Reconcile the classification with the underlying transactions. The distinction matters when an owner evaluates whether a change in pricing, collections or costs is working. A higher bank balance after new funding may provide temporary room, but it does not establish that the operating model has improved. Keep the operating result and the financing movement visible so that the next decision uses the right explanation.
Distinguish demand from available capacity
A business may have the staff and equipment to sell more without having customers ready to buy. It may also have strong demand but lack the resources to deliver it. Keep those two constraints separate in the plan. Solving one does not automatically solve the other.
Use actual orders, pipeline evidence and delivery information where available. Label speculative demand clearly and include the cost of winning and serving it. The owner can then test whether a proposed investment addresses the real limit. This helps avoid spending cash on capacity that remains idle or accepting work that the business cannot complete to the promised standard.
A relevant customer account to examine
XLT Construction’s original interview and transcript provides a concrete point of reference. The owner describes waiting two or three months for some customer payments while payroll and materials could not wait. He reports improved room for operations. The interview does not establish identical results for another contractor.
For accounts receivable aging, use the recording to identify a question rather than to predict a result. Read the surrounding transcript before relying on a short excerpt. The customer’s circumstances, the date of the account and the stage described all affect how the example can be used. A reported experience can be informative without being a promise about a new engagement.
Where a debt-service discussion fits
The worksheet can help a business explain its position when speaking with Coastal Debt Resolve about MCA or commercial debt. Bring the actual agreements, recent payment activity and the assumptions used in the calculation. A customer interview supplies context for the discussion; it does not establish that a proposed arrangement will solve the operating issue or that a creditor will accept particular terms.
Questions to take into the next discussion
Which invoices can I verify today?
Start with the underlying records and identify the specific decision the answer would change. For accounts receivable aging, the answer should relate to the business’s own circumstances. Mark any estimate or unverified statement so that it cannot be mistaken for a confirmed fact.
Which customers need a different follow-up?
Ask for the relevant explanation in a form that can be checked later. A short written summary with the source, assumptions and responsible person is often more useful than a broad reassurance. If the answer depends on missing information, record what is needed and who will obtain it.
What happens if the oldest balance does not arrive this month?
Identify the practical next action and when it needs to happen. If the question involves legal rights, tax treatment or an urgent deadline, consult an appropriately qualified professional. Keep that professional advice separate from general educational material and customer testimonials.
Turn the calculation into an operating decision
A useful review of accounts receivable aging ends with an action, an owner and a reason. Identify what the business will do next, which information supports that action and what would cause a reassessment. Keep the worksheet simple enough to update when the important inputs change. If the result suggests a shortfall, address the timing and the underlying cause rather than assuming additional funding will remove both.
Watch the source interview
The recording is the source for the attributed customer experience. Read the full interview page and transcript for context. The practical examples in this article are editorial illustrations, separate from the customer’s account.
Sources and further reading
Planning note: This guide concerns accounts receivable aging. Illustrations are hypothetical, and customer experiences are not forecasts. Accounting classifications, contracts, taxes and legal options require advice appropriate to the business. Do not change contractual payments solely on the basis of an educational worksheet.
A related question from the existing library
For another practical angle on accounts receivable aging, see Business Cash Flow After Clients Leave: Questions From an Office Provider’s Story. Read it alongside the original interview when deciding which question to bring into your own business discussion.