Accounts Receivable Aging preview
AR Register sheet with invoice-level tracking columns for invoice number, customer name, dates, amounts, paid, outstanding, and aging bucket breakdowns. 1/4

About this accounts receivable aging spreadsheet template

This accounts receivable aging template gives finance teams and small business owners a structured system to track unpaid invoices, categorize them by days past due, and prioritize collection efforts. The workbook includes an AR Register for invoice-level detail, a Collections Queue ranked by priority, an Aging Dashboard with summary KPIs, and a Lists & Guide sheet with configurable aging controls and collections rules.

Every column, formula, and rule table is fully editable in WPS Office, Microsoft Excel, or Google Sheets. Replace the sample customer names, invoice data, collector assignments, and aging thresholds with your own portfolio to start managing receivables immediately.

4 interconnected sheets

AR Register, Collections Queue, Aging Dashboard, and Lists & Guide work together for end-to-end receivables management.

Aging bucket breakdown

Automatically categorize outstanding invoices into Current, 1-30, 31-60, 61-90, and 90+ day buckets.

Collections workflow built-in

Priority-ranked queue with collector assignments, promise dates, and recommended actions for each overdue invoice.

Standard XLSX format

Works with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers.

Frequently asked questions
The Accounts Receivable Aging template is designed for tracking outstanding customer invoices, monitoring days-past-due aging buckets, prioritizing collections, and reviewing AR health through a summary dashboard. Customize the sample data, aging rules, and other editable elements in WPS Office for your own business.
Use the native XLSX in WPS Office, Microsoft Excel, or Google Sheets. For Notion workflows, reuse the data and structure in a Notion database; for branded visual reports, adapt the content in Adobe Express.
Download the template, open it in WPS Office, and replace the sample invoice data, customer names, collector assignments, aging thresholds, and other editable elements with your own accounts receivable portfolio.
Yes. Select Download to get the editable XLSX file and open it in WPS Office or another compatible spreadsheet application.
Yes. Adapt it for accounts receivable tracking, cash flow monitoring, collections management, and month-end financial reviews. It is available for personal and commercial projects, subject to the applicable template license.