Purpose
The Accounts Receivable (AR) Report gives your team a complete view of client balances. Use it to track unpaid invoices, aging debt, and credit balances. It’s organized into two tabs - AR with Aging and AR Invoice Balance - both filterable and exportable for deeper analysis.
Filters
Filter | Description |
Time Period | Select a range such as “Last Month End” to define your scope. |
Invoice Status | Filter by type: Active, Charges Complete, or Checked Out. |
Outstanding Balance | Show only clients/invoices with a positive remaining balance. |
Credit Balance | Show only clients/invoices with a negative remaining balance. |
Include Inactive Clients | Toggle to include clients no longer active. |
After selecting filters, click View Report.
Tabs and Columns
Tab 1: AR with Aging
Breaks down client debt by how long balances have been unpaid.
Column | Description |
Client Type | Lists defined client types |
Client Name & Contact Info | Full client profile details |
Client Status | Active/Inactive |
Last Payment Date | Date of last payment |
Last Paid Amount | Amount of last payment |
Aging Buckets | Amounts grouped into 0-30, 31-60, 61-90, 91-120, 120+ days |
Total Due / Credit | Final amount owed or credited per client |
Total Row: Combined totals for each aging group and balance category.
Tab 2: AR Invoice Balance
Summarizes each invoice line-by-line without aging breakdown.
Column | Description |
Client Type | Lists defined client types |
Client Full Name | Client name |
Production User | Provider(s) responsible for the invoice. |
Production User Initials | Provider(s) initials |
Invoice Number | Clickable link to open the invoice |
Invoice Date | Date of invoice |
Invoice Status | Active, Charges Complete, or Checked Out |
Financial Summary | Subtotal, discount, tax, refund, amount paid, total, and balance due. |
Last Payment & Days Aging | Tracks recent activity and overdue time. |
Total Row: Aggregated financial values, including outstanding balances.
Export Options
Each tab includes its own CSV export:
AR with Aging CSV
AR Invoice Balance CSV
Click Download on the relevant tab to export visible data.
Tips for Use
Scroll Horizontally - Both tabs are wide; use the scrollbar to see all columns.
Filter Strategically - Use Credit Balance to find overpayments, Outstanding Balance for collections.
Sort by Aging - Click Days Aging to prioritize oldest debts.
Use the Total Row - Quickly assess the scope of AR for your selected timeframe.
FAQs
Why are some totals negative?
Negative totals indicate overpayments, refunds, or adjustments resulting in a credit balance.
What does "Days Aging" mean?
The number of days since the invoice date. Higher values indicate older, unpaid invoices.
Can I include inactive clients?
Yes, toggle Include Inactive Clients to expand the scope.