Skip to main content

Aged Receivables (AR) Summary

Updated over 2 weeks ago

What Is The Aged Receivables (AR) Summary Report?

The Aged Receivables (AR) Summary report shows outstanding client balances in Canopy, grouped by how long invoices have been unpaid.


Why This Matters

The AR Summary helps firms understand expected cash flow, identify overdue balances, and prioritize collections. It’s a core report for monitoring financial health and reducing aging receivables before they become uncollectible.


Table Of Contents


What’s Included In The AR Summary

The AR Summary does include balances associated with:

  • Active clients

  • Archived clients

  • Deleted clients

Because archived or deleted clients may still have active invoices, those invoices can continue to appear on the AR Summary until the invoices themselves are archived or deleted.


What’s Not Included In The AR Summary

The AR Summary does not include:

  • Archived invoices

  • Deleted invoices

Once an invoice is archived or deleted, it is immediately removed from AR aging reports.


Report Columns And Definitions

The Aged Receivables Summary displays a high-level view of outstanding balances using the following columns:

  • Client

    • The client associated with the outstanding balance

  • Current

    • Balances that are still within payment terms

  • Aging Buckets

    • Amounts overdue based on how many days past due the invoice is (for example, 31–60 days, 61–90 days)

  • Total

    • The total outstanding balance across all aging buckets, including applicable credits


Permissions And Access

  • Report location: Billing > Reports > Aged Receivables

  • Required access:

    • Billing reports

    • Assigned client access

Users will only see balances for clients they are permitted to view.


How Aging Is Calculated

Invoices are grouped into aging buckets based on how many days they are past due.

  • The system calculates aging by comparing:

    • Invoice date and payment terms

    • Against the current date

  • Each invoice is placed into the appropriate bucket:

    • Current

    • 31–60 days overdue

    • 61–90 days overdue

    • Over 90 days overdue

  • Totals are calculated per bucket, then summed to show total receivables


Example AR Summary

If a firm has the following outstanding balances:

  • $5,000 current

  • $3,000 overdue by 31–60 days

  • $2,000 overdue by 61–90 days

  • $1,000 overdue by over 90 days

The AR Summary would show:

  • Current: $5,000

  • 31–60 Days: $3,000

  • 61–90 Days: $2,000

  • Over 90 Days: $1,000

  • Total Receivables: $11,000

This view helps firms quickly assess risk and prioritize follow-ups.



Removing Deleted Clients Or Invoices From AR Reports

If a deleted client appears in the AR Summary unexpectedly, it means at least one associated invoice is still active.

Option 1: Remove Via The Aged Receivables Detail Report

  1. Navigate to Billing > Reports > Aged Receivables Detail.

  2. Click Customize and filter for the specific client.

  3. Select the invoice to open it.

  4. Use the three-dot menu and choose Archive.

    • Archiving removes the invoice from AR aging immediately.

  5. If full deletion is required:

    • Go to Archived Invoices

    • Delete the invoice from there



Option 2: Remove Directly From A Linked Invoice

  1. Open the Aged Receivables Detail report.

  2. Select the hyperlinked invoice associated with the deleted client.

  3. Archive or delete the invoice.

  4. Once the invoice is removed, the client will no longer appear on the AR Summary.


Additional Notes On Archiving

  • Archiving Preserves Financial History

    • Invoices remain accessible for records and audits while staying out of active AR reports.

  • Client Deletion Is Non-Cascading

    • Deleting a client does not automatically delete invoices to prevent accidental loss of financial data.

    • Invoices must be archived or deleted individually.


Summary

The Aged Receivables Summary report provides a clear snapshot of what clients owe and how long balances have been outstanding. Understanding what’s included, how aging is calculated, and how archiving affects AR reports helps firms keep receivables accurate, actionable, and audit-ready.


Need Help?

Contact Support or ask Penny, our AI Support Bot, for assistance.

Did this answer your question?