What is accounts receivable aging?

Accounts receivable aging groups unpaid invoice balances by how long they have been outstanding or overdue, using a stated date basis. It helps identify balances that need attention. The buckets alone do not explain why an invoice is unpaid, so pair the report with payment terms, recent activity and any unresolved customer question.

An aging report can measure time since invoice date or time past due. Those are different views. A recently issued invoice with immediate terms may already be overdue, while an older invoice with longer agreed terms may still be current. Label the basis clearly at the top of the review.

For a due-date view, use an as-of date and subtract each invoice's due date. Keep not-yet-due balances in a current category. Then choose consistent intervals for overdue items. For example, a business might use 1–30, 31–60, 61–90 and more than 90 days past due. These are example categories, not ServicePro IQ feature claims or required industry thresholds.

Also decide how to handle missing due dates. Do not silently classify those invoices as current. Mark the missing information for review and confirm the agreed terms. A precise-looking aging table is only as useful as the dates and balances behind it. Preserve the as-of date so another person can reproduce the result.

Suppose you are preparing a hypothetical review as of June 30. A $500 invoice due June 15 has a $200 payment recorded, leaving $300 outstanding and 15 days past due. Its remaining balance belongs in the 1–30 days past-due group under the example policy.

A separate $1,000 invoice due July 15 is still current on June 30, even if it was issued earlier. This illustrates why invoice age and overdue status should not be confused. Use outstanding amounts rather than original invoice totals, or partial payments will be ignored and receivables overstated.

Check credits, adjustments and payment postings before contacting customers. If an amount is disputed, record the reason separately from the age. A balance can be old because of an incorrect billing contact, missing paperwork, an unresolved service concern or a payment problem. The category tells you where to investigate; it does not prove which explanation applies.

For each priority item, confirm the customer, invoice, remaining balance, due date and most recent action. Then choose the next step and assign it to someone who can complete it. A reminder to the correct contact may resolve an administrative issue. A scope dispute may require the estimator or service manager.

For a roofing project, agreed payment stages may explain why a balance needs further documentation. For a recurring cleaning customer, the issue may be a billing contact change. Keep the conversation factual and verify that recent payments have been applied before sending another request. Use the customer's agreed terms as the basis for discussion.

Review the field service profitability guide to separate job earnings from cash collection. Profitable work can still leave money uncollected. Keep notes of promises, disputes and follow-up dates in your established process. The goal is a reliable next action, not simply moving an invoice into an older bucket at the next review.

Aging describes individual balances by date category. Days sales outstanding is a ratio relating receivables to sales over a period. A ratio can move because sales changed even when an old invoice remains unpaid. That makes the two views complementary rather than interchangeable.

ServicePro IQ's approved A/R details include total outstanding balance, days outstanding over the last 365 days, balance over time and outstanding invoices. Those facts do not establish an automatic due-date aging table. Use the relevant invoice dates and payment terms from your records when you need the bucketed calculation described here.

The service business KPI guide can help connect collection measures to the wider review. Keep the aging method stable across periods and note any corrected dates or balances. When the total changes, inspect whether customers paid, credits were issued or the data was corrected. Those changes have different implications for the collection process and should not all be described as payment improvement.

ServicePro IQ's A/R page shows the total outstanding balance, days outstanding over the last 365 days, the outstanding balance over time and a list of outstanding invoices. Its days outstanding calculation is outstanding balance divided by revenue, multiplied by 365, over the last 365 days. Keep that definition attached to the number when discussing it.

Use the invoice list to choose records for further review. Add the due-date, dispute and follow-up context you need from your business records before deciding what action to take. A total balance alone does not tell you whether a particular customer has missed an agreed payment date.

The Housecall Pro integration requires a Housecall Pro MAX account. ServicePro IQ reads your data without changing anything in Housecall Pro. Job and revenue figures refresh hourly at 20 minutes past the hour, and your contact tells you when reports are ready after connection. See pricing and use the free 7-day trial to review outstanding invoices alongside your own collection process.