The Accounts Receivable Report gives a comprehensive overview of client balances, helping your team track unpaid invoices, aging debt, and credit balances. It is organized into a single report with two tabs: AR with Aging and AR Invoice Balance, both of which can be filtered and exported.
🛠 Report Setup Options
Before generating the report, you’ll select a few key parameters at the top:
Time Period: Choose a date range like “Last Month End” to scope your data.
Invoice Status: Filter by invoice type - Active, Charges Complete, or Checked Out.
Filter By:
Outstanding Balance: Shows only clients who owe money.
Credit Balance: Shows clients with credits on their account.
Include Inactive Clients: Toggle to include clients no longer active.
Click View Report once your filters are set.
📑 Report Tabs
🔹 Tab 1: AR with Aging
This tab breaks down client debt by age, helping you track how long balances have been unpaid.
Column | Description |
Client Name & Contact Info | Full client profile details. |
Invoice Info | Includes invoice number, date, and status. |
Financial Details | Subtotal, discount, tax, paid, refund, and balance due. |
Days Aging | Number of days since the invoice was issued. |
Aging Buckets | Shows outstanding amounts grouped into 0–30, 31–60, 61–90, 91–120, and 120+ day brackets. |
Total Due / Credit | Final amount owed or credited per client. |
📌 Total Row: Bottom of the table shows combined totals for each aging group and balance category.
🔹 Tab 2: AR Invoice Balance
This tab gives a line-by-line summary of each invoice, regardless of aging.
Column | Description |
Client Info | Includes client name and type. |
Production User | Lists the provider(s) responsible for the invoice. |
Invoice Status | Whether the invoice is Active, Checked Out, or Charges Complete. |
Financial Summary | Shows subtotal, discount, tax, refund, amount paid, total, and balance due. |
Last Payment & Days Aging | Helps track recent activity and how long payment has been overdue. |
📌 Totals Row: Summary line at the bottom aggregates key financial values like total outstanding balances and aging.
📂 Download & Export Options
Each tab includes its own CSV export link:
AR with Aging CSV
AR Invoice Balance CSV
Click the Download button to export the visible data for further analysis or accounting use.
🔍 Best Practices & Tips
Scroll Horizontally: Both tabs are wide — use the scrollbar to view all columns.
Filter Strategically: Use “Credit Balance” to find clients with overpayments and “Outstanding Balance” to focus on collections.
Sort by Aging: Click the Days Aging column to quickly prioritize the oldest debts.
Use the Total Row: The totals at the bottom of both tabs help you track the full scope of AR for the selected timeframe.
❓FAQs
Q: Why are some totals negative?
A: Negative totals indicate overpayments, refunds, or adjustments resulting in a credit balance.
Q: What does "Days Aging" mean?
A: This is the number of days since the invoice date. Higher values indicate older, unpaid invoices.
Q: Can I include inactive clients in the report?
A: Yes, toggle the Include Inactive Clients option to expand the scope.