What is this page about: Light tracks AR aging at the customer level and organisation-wide, so you can see how overdue customer balances are at a glance. This page explains where to find the customer aging widget and the Aged Accounts Receivable report, how the aging buckets work, how to drill into a bucket's invoices, and answers common questions about the two views.
On this page
- What is AR aging in Light?
- Where can I find AR aging in Light?
- What do the AR aging buckets mean?
- How do I drill into an aging bucket?
- Frequently Asked Questions
- Related Articles
What is AR aging in Light?
AR aging (accounts receivable aging) is how Light tracks how overdue a customer's open invoices are. Light tracks AR aging at the customer level, with a customer aging widget that breaks open balances into standard aging buckets, and offers an organisation-wide Aged Accounts Receivable report for a company-wide view.
Where can I find AR aging in Light?
Per-customer view: the customer aging widget
The per-customer aging view in Light is the customer aging widget on each customer's overview page:
- Go to Revenue & Invoicing → Customers
- Open a customer
- The Overview tab shows the aging widget
Organisation-wide view: the Aged Accounts Receivable report
For an organisation-wide view, Light also provides an Aged Accounts Receivable report:
- Go to Planning & Reports → Reports
- Open the Aged Accounts Receivable report
The Aged Accounts Receivable report is generated per entity, as of a date you choose (defaulting to today), in either local or group currency. It summarises open balances by customer across Current, 1-30 Days, 31-60 Days, and Older than 60 Days columns, with totals. An invoice-level detail view is available and can be exported from Light as CSV. A matching Aged Accounts Payable report exists on the AP side for tracking what your company owes.
What do the AR aging buckets mean?
The customer aging widget categorises open invoices into 5 aging buckets:
| Bucket | Days past due |
|---|---|
| Current | Not yet due |
| 1-30 days | 1-30 days overdue |
| 31-60 days | 31-60 days overdue |
| 61-90 days | 61-90 days overdue |
| 90+ days | More than 90 days overdue |
The widget's 5 buckets are a more granular breakdown of the Aged Accounts Receivable report's 4 columns: the report's Older than 60 Days column corresponds to the widget's 61-90 days and 90+ days buckets combined.
How do I drill into an aging bucket?
In Light, clicking any bucket in the customer aging widget opens the Sales invoices list, pre-filtered to that aging range and that customer. This is the fastest way to see exactly which invoices make up a given bucket's balance.
Frequently Asked Questions
What's the difference between the customer aging widget and the Aged Accounts Receivable report?
The customer aging widget shows one customer's open balances in 5 buckets on that customer's Overview tab. The Aged Accounts Receivable report shows open balances across all customers in an entity, using 4 columns, and can be exported as CSV.
Does Light have an Aged Accounts Payable report too?
Yes. A matching Aged Accounts Payable report exists on the AP side, generated the same way as the Aged Accounts Receivable report.
Can I change the "as of" date on the Aged Accounts Receivable report?
Yes. The report can be generated as of any date you choose; it defaults to today.
Can I export AR aging data from Light?
Yes. The Aged Accounts Receivable report has an invoice-level detail view that can be exported from Light as a CSV file.
Related Articles
- Accounts Receivable Overview
- Tracking Payments and Outstanding Balances
- Customer Credits
- Reporting Overview
- AP Aging
Was this article helpful?
Thanks for the feedback!