AR Aging Reports and Collections Management

What Is an AR Aging Report?

An Accounts Receivable (AR) Aging Report organizes every unpaid customer invoice by how long it has been outstanding. QuickBooks produces two versions:

• Aging Summary — shows one total per customer, grouped into aging buckets (columns).
• Aging Detail — lists every individual open invoice, also grouped by bucket.

The standard aging buckets are Current, 1–30 days past due, 31–60 days past due, 61–90 days past due, and 91+ days past due (QuickBooks labels this last column "> 90"). The date QuickBooks uses to measure age is normally the invoice due date, not the invoice date, though you can change that setting.

Management uses the aging report to answer three questions: Who owes us money? How much? How late is it? Without this report, overdue balances hide inside a lump-sum AR balance and cash flow suffers.

Running the Report in QuickBooks

1. From the Reports menu choose Customers & Receivables, then A/R Aging Summary or A/R Aging Detail.

2. Set the Report Date to the "as-of" date your manager specifies. All aging is calculated from that date.

3. Confirm the Aging interval is set to 30 days (the default matches standard buckets).

4. Click Refresh or Run Report.

5. To print, choose File › Print Report or export to PDF. Never leave a printed aging report on an unattended desk — it contains confidential customer financial data. Shred or securely file paper copies when finished.

Reading the Aging Summary

Each row is one customer. Each column is one time bucket. The far-right Total column is that customer's total open balance. The bottom Total row sums every column — that grand total must match the AR balance in your general ledger. If it does not, a data-entry error or unapplied payment exists and must be corrected before collections work begins.

A quick way to prioritize: scan the 61–90 and > 90 columns first. Accounts in those buckets carry the highest risk of becoming uncollectible.

Allowance for Doubtful Accounts

Not every old receivable will be collected. Generally Accepted Accounting Principles (GAAP) require businesses to estimate and record bad debt expense before the loss is confirmed. The credit entry goes to a contra-asset account called Allowance for Doubtful Accounts (AFDA), which reduces net AR on the balance sheet.

A common method is the percentage-of-receivables (aging) approach: apply different loss rates to each bucket based on historical experience. For example, a business might estimate that 1% of current balances, 3% of balances 1–30 days past due, 10% of balances 31–60 days past due, and so on will be uncollectible. Multiply each bucket total by its rate, sum the products, and compare to the existing AFDA balance. If the AFDA is below the required amount, record an adjusting entry to increase it.

Collections Management Principles

Effective collections is professional, persistent, and documented. Best practice follows an escalating contact sequence:

1. Friendly reminder — sent a few days after the due date; assumes an oversight.

2. First follow-up — sent around 15–30 days past due; requests payment or a payment arrangement.

3. Firm notice — sent around 31–60 days past due; states consequences (late fees, service hold).

4. Final demand / referral — sent at 61–90+ days past due; may precede referral to a collection agency or legal counsel.

Document every contact: date, method, person reached, and outcome. QuickBooks lets you log notes inside a customer record.

Writing a Professional Collections Email

A collections email must be courteous but unambiguous. Use these conventions:

• Subject line: include the invoice number and balance due so the recipient can act immediately.
• Opening: greet the contact by name; reference the relationship positively.
• Body: state the amount owed, the original due date, and the number of days past due. Keep it factual — avoid accusatory language.
• Call to action: give a specific payment deadline and specify accepted payment methods.
• Closing: offer to answer questions and provide direct contact information.
• Tone: firm, respectful, and clear. Threats, ALL-CAPS, or sarcasm are unprofessional and can create legal liability.

Data Privacy and Security

AR data is sensitive business information. Observe these practices every session:

• Lock your workstation screen whenever you step away (Windows key + L).
• Do not email an aging report to a personal account or share login credentials.
• Paper printouts containing customer balances must be shredded after use — treat them like financial records, which they are.
• In a phone collections role-play, never share another customer's information; verify identity before discussing account details.

These habits protect the business and its customers, and they demonstrate the professional conduct employers expect from a Certified Bookkeeper.

Connecting to Your Credential Exams

QuickBooks Certified User exam objectives include running and interpreting customer reports, managing customer records, and understanding report settings — all practiced directly in this lab.

AIPB Certified Bookkeeper exam content includes adjusting entries for bad debts and the allowance method, which you practice in the analysis exercise.

Microsoft Office Specialist (Word/Outlook) competencies align with producing correctly formatted professional correspondence — exactly what the email-drafting activity develops.