Skip to main content

Accounts Receivable Report

Track outstanding balances owed by clients, monitor aging invoices, and manage credit balances.

Updated over 2 weeks ago

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.

Did this answer your question?