Templates Practice Management Accounts Receivable Aging Report
Universal
Practice Management
Blank Document PRO
From Template
Upload Document Word (.docx) & Markdown files
PRO
Ready to Edit
Accounts Receivable Aging Report - Free Editor

ACCOUNTS RECEIVABLE AGING REPORT

Law Firm Name: [________________________________]

Report Date: [__/__/____]

Reporting Period: [__/__/____] to [__/__/____]

Prepared By: [________________________________]

Reviewed By: [________________________________]

EXECUTIVE SUMMARY

Metric Amount
Total Accounts Receivable $[________________]
Current (0-30 Days) $[________________]
31-60 Days Past Due $[________________]
61-90 Days Past Due $[________________]
91-120 Days Past Due $[________________]
Over 120 Days Past Due $[________________]
Average Days Outstanding [____] days
Collection Rate (%) [____]%

AGING SUMMARY BY CATEGORY

Aging Category Amount % of Total # of Invoices # of Clients
Current (0-30 Days) $[________] [____]% [____] [____]
31-60 Days $[________] [____]% [____] [____]
61-90 Days $[________] [____]% [____] [____]
91-120 Days $[________] [____]% [____] [____]
121-180 Days $[________] [____]% [____] [____]
181-365 Days $[________] [____]% [____] [____]
Over 365 Days $[________] [____]% [____] [____]
TOTAL $[________] 100% [____] [____]

DETAILED ACCOUNTS RECEIVABLE AGING

Client 1

Field Information
Client Name [________________________________]
Client ID [________________________________]
Matter(s) [________________________________]
Responsible Attorney [________________________________]
Billing Contact [________________________________]
Contact Phone [________________________________]
Contact Email [________________________________]
Invoice # Invoice Date Due Date Original Amount Payments Balance Days Outstanding Aging Category
[______] [__/__/____] [__/__/____] $[________] $[________] $[________] [____] [____________]
[______] [__/__/____] [__/__/____] $[________] $[________] $[________] [____] [____________]
[______] [__/__/____] [__/__/____] $[________] $[________] $[________] [____] [____________]

Client Total: $[________________]

Collection Status: ☐ Current ☐ Reminder Sent ☐ Second Notice ☐ Phone Contact ☐ Payment Plan ☐ Collections ☐ Write-Off Pending

Notes: [________________________________]

Client 2

Field Information
Client Name [________________________________]
Client ID [________________________________]
Matter(s) [________________________________]
Responsible Attorney [________________________________]
Billing Contact [________________________________]
Contact Phone [________________________________]
Contact Email [________________________________]
Invoice # Invoice Date Due Date Original Amount Payments Balance Days Outstanding Aging Category
[______] [__/__/____] [__/__/____] $[________] $[________] $[________] [____] [____________]
[______] [__/__/____] [__/__/____] $[________] $[________] $[________] [____] [____________]
[______] [__/__/____] [__/__/____] $[________] $[________] $[________] [____] [____________]

Client Total: $[________________]

Collection Status: ☐ Current ☐ Reminder Sent ☐ Second Notice ☐ Phone Contact ☐ Payment Plan ☐ Collections ☐ Write-Off Pending

Notes: [________________________________]

Client 3

Field Information
Client Name [________________________________]
Client ID [________________________________]
Matter(s) [________________________________]
Responsible Attorney [________________________________]
Billing Contact [________________________________]
Contact Phone [________________________________]
Contact Email [________________________________]
Invoice # Invoice Date Due Date Original Amount Payments Balance Days Outstanding Aging Category
[______] [__/__/____] [__/__/____] $[________] $[________] $[________] [____] [____________]
[______] [__/__/____] [__/__/____] $[________] $[________] $[________] [____] [____________]
[______] [__/__/____] [__/__/____] $[________] $[________] $[________] [____] [____________]

Client Total: $[________________]

Collection Status: ☐ Current ☐ Reminder Sent ☐ Second Notice ☐ Phone Contact ☐ Payment Plan ☐ Collections ☐ Write-Off Pending

Notes: [________________________________]

Client 4

Field Information
Client Name [________________________________]
Client ID [________________________________]
Matter(s) [________________________________]
Responsible Attorney [________________________________]
Billing Contact [________________________________]
Contact Phone [________________________________]
Contact Email [________________________________]
Invoice # Invoice Date Due Date Original Amount Payments Balance Days Outstanding Aging Category
[______] [__/__/____] [__/__/____] $[________] $[________] $[________] [____] [____________]
[______] [__/__/____] [__/__/____] $[________] $[________] $[________] [____] [____________]
[______] [__/__/____] [__/__/____] $[________] $[________] $[________] [____] [____________]

Client Total: $[________________]

Collection Status: ☐ Current ☐ Reminder Sent ☐ Second Notice ☐ Phone Contact ☐ Payment Plan ☐ Collections ☐ Write-Off Pending

Notes: [________________________________]

Client 5

Field Information
Client Name [________________________________]
Client ID [________________________________]
Matter(s) [________________________________]
Responsible Attorney [________________________________]
Billing Contact [________________________________]
Contact Phone [________________________________]
Contact Email [________________________________]
Invoice # Invoice Date Due Date Original Amount Payments Balance Days Outstanding Aging Category
[______] [__/__/____] [__/__/____] $[________] $[________] $[________] [____] [____________]
[______] [__/__/____] [__/__/____] $[________] $[________] $[________] [____] [____________]
[______] [__/__/____] [__/__/____] $[________] $[________] $[________] [____] [____________]

Client Total: $[________________]

Collection Status: ☐ Current ☐ Reminder Sent ☐ Second Notice ☐ Phone Contact ☐ Payment Plan ☐ Collections ☐ Write-Off Pending

Notes: [________________________________]

AGING BY RESPONSIBLE ATTORNEY

Attorney Name Current 31-60 Days 61-90 Days 91-120 Days Over 120 Days Total
[________________________________] $[______] $[______] $[______] $[______] $[______] $[______]
[________________________________] $[______] $[______] $[______] $[______] $[______] $[______]
[________________________________] $[______] $[______] $[______] $[______] $[______] $[______]
[________________________________] $[______] $[______] $[______] $[______] $[______] $[______]
[________________________________] $[______] $[______] $[______] $[______] $[______] $[______]
FIRM TOTAL $[______] $[______] $[______] $[______] $[______] $[______]

AGING BY PRACTICE AREA

Practice Area Current 31-60 Days 61-90 Days 91-120 Days Over 120 Days Total
[________________________________] $[______] $[______] $[______] $[______] $[______] $[______]
[________________________________] $[______] $[______] $[______] $[______] $[______] $[______]
[________________________________] $[______] $[______] $[______] $[______] $[______] $[______]
[________________________________] $[______] $[______] $[______] $[______] $[______] $[______]
FIRM TOTAL $[______] $[______] $[______] $[______] $[______] $[______]

COLLECTION ACTIVITY SUMMARY

Actions Taken This Period

Action Number Amount Affected
First Reminder Letters Sent [____] $[________]
Second Notice Letters Sent [____] $[________]
Phone Collection Calls Made [____] $[________]
Payment Plans Established [____] $[________]
Accounts Sent to Collections [____] $[________]
Accounts Written Off [____] $[________]

Payments Received This Period

Source Amount
Current Invoices Paid $[________]
Past Due Invoices Collected $[________]
Payment Plan Payments $[________]
Collection Agency Recoveries $[________]
Total Payments Received $[________]

BAD DEBT ANALYSIS

Allowance for Doubtful Accounts

Aging Category Balance Estimated Uncollectible % Allowance Amount
Current (0-30 Days) $[________] [____]% $[________]
31-60 Days $[________] [____]% $[________]
61-90 Days $[________] [____]% $[________]
91-120 Days $[________] [____]% $[________]
121-180 Days $[________] [____]% $[________]
181-365 Days $[________] [____]% $[________]
Over 365 Days $[________] [____]% $[________]
TOTAL ALLOWANCE $[________]

Write-Off Candidates

Client Matter Invoice # Amount Days Outstanding Reason
[________________] [________] [______] $[______] [____] [________________]
[________________] [________] [______] $[______] [____] [________________]
[________________] [________] [______] $[______] [____] [________________]

Total Pending Write-Offs: $[________________]

KEY PERFORMANCE INDICATORS

Metric Current Period Prior Period Change Target
Days Sales Outstanding (DSO) [____] days [____] days [____] days [____] days
Collection Rate [____]% [____]% [____]% [____]%
Realization Rate [____]% [____]% [____]% [____]%
Write-Off Rate [____]% [____]% [____]% [____]%
AR Turnover Ratio [____] [____] [____] [____]
% Over 90 Days [____]% [____]% [____]% [____]%

ACTION ITEMS

Immediate Priority (Over 90 Days)

☐ [________________________________] - Responsible: [____________] - Due: [__/__/____]

☐ [________________________________] - Responsible: [____________] - Due: [__/__/____]

☐ [________________________________] - Responsible: [____________] - Due: [__/__/____]

This Week

☐ [________________________________] - Responsible: [____________] - Due: [__/__/____]

☐ [________________________________] - Responsible: [____________] - Due: [__/__/____]

☐ [________________________________] - Responsible: [____________] - Due: [__/__/____]

This Month

☐ [________________________________] - Responsible: [____________] - Due: [__/__/____]

☐ [________________________________] - Responsible: [____________] - Due: [__/__/____]

☐ [________________________________] - Responsible: [____________] - Due: [__/__/____]

NOTES AND OBSERVATIONS

[________________________________]

[________________________________]

[________________________________]

[________________________________]

APPROVALS

Prepared By: [________________________________] Date: [__/__/____]

Reviewed By: [________________________________] Date: [__/__/____]

Approved By: [________________________________] Date: [__/__/____]

This report should be generated and reviewed monthly. Receivables must be actively pursued until paid or determined to be uncollectible. Prompt follow-up on aging accounts is essential to maintain healthy cash flow.

AI Legal Assistant
$49 one-time

Need help customizing this document?

Get 3 days of intelligent editing. Tailor every section to your specific case.

See how AI customizes your document (DEMO)

Accounts Receivable Aging Report
All changes saved
Save
Export
Export as DOCX
Export as PDF
Generating PDF...
accounts_receivable_aging_universal.pdf
Ready to export as PDF or Word
AI is editing...

ACCOUNTS RECEIVABLE AGING

GENERAL TEMPLATE

Effective Date: [DATE]
Party A: [PARTY A NAME]
Address: [PARTY A ADDRESS]
Party B: [PARTY B NAME]
Address: [PARTY B ADDRESS]
Governing Law: [GOVERNING STATE]
This document is entered into by and between [PARTY A NAME] and [PARTY B NAME], effective as of the date set forth above, subject to the terms and conditions outlined herein and the laws of [GOVERNING STATE].
Chat
Review

Customize this document with Ezel

$49 one-time · No subscription

  • AI-Powered Editing
    Tell the AI what to change and watch it edit your document in real time.
  • 3 Days of Access
    Revise as many times as you need. Download as Word or PDF.
  • State-Specific Law
    AI understands your jurisdiction's legal requirements.
Secure checkout via Stripe
Need to customize this document?

Related Legal Templates

More Practice Management Templates

Annual Attorney/Firm Compliance Checklist Associate Attorney Performance Review Form Client Billing Statement / Invoice Client Intake Log Client Trust Account Ledger Conflict Check Form Browse all

Do more with Ezel

This free template is just the beginning. See how Ezel helps legal teams draft, research, and collaborate faster.

AI Document Editor

AI that drafts while you watch

Tell the AI what you need and watch your document transform in real-time. No more copy-pasting between tools or manually formatting changes.

  • Natural language commands: "Add a force majeure clause"
  • Context-aware suggestions based on document type
  • Real-time streaming shows edits as they happen
  • Milestone tracking and version comparison
Learn more about the Editor
AI Chat for legal research
AI Chat Workspace

Research and draft in one conversation

Ask questions, attach documents, and get answers grounded in case law. Link chats to matters so the AI remembers your context.

  • Pull statutes, case law, and secondary sources
  • Attach and analyze contracts mid-conversation
  • Link chats to matters for automatic context
  • Your data never trains AI models
Learn more about AI Chat
Case law search interface
Case Law Search

Search like you think

Describe your legal question in plain English. Filter by jurisdiction, date, and court level. Read full opinions without leaving Ezel.

  • All 50 states plus federal courts
  • Natural language queries - no boolean syntax
  • Citation analysis and network exploration
  • Copy quotes with automatic citation generation
Learn more about Case Law Search

Ready to transform your legal workflow?

Join legal teams using Ezel to draft documents, research case law, and organize matters — all in one workspace.

Customize This Document — $49 Full Platform — $249/mo
Request a Demo