What this page is about: This article covers the Aged Accounts Payable report, how bills are grouped into age buckets, how to track bills with a scheduled payment, and how the report handles multiple entities and foreign currency bills. It's written for anyone who needs to see what the business owes and how overdue it is, whether you're chasing a vendor payment or reviewing payables during close.
On this page
- Aged Accounts Payable report
- Bills Scheduled tab
- Entity and currency handling
- Related articles
The Aged Accounts Payable report shows what your business owes, split into buckets by how overdue each bill is. Use it with the Bills list to catch overdue vendor payments before they slip further behind.
Aged Accounts Payable report
Open Light and go to Planning & Reports → Reports, then open the Aged Accounts Payable report.
The report is one row per vendor, with your open bills split into columns by how overdue they are:
- Current
- 1-30 Days
- 31-60 Days
- Older than 60 Days
- Total
- Total (Transaction Currency)
Rather than grouping vendors within each bucket, each vendor gets a single row, with the aging buckets and totals laid out as columns across it, so you can scan one vendor's full exposure at a glance, or compare across vendors within a given bucket.
Light also has a separate Aged AP Detail report, which breaks the same buckets down bill by bill instead of summarising by vendor. Use the summary view above for a quick read on vendor exposure, and the detail report when you need to trace a specific balance.
See Reporting overview for general navigation of the reports module.
Bills Scheduled tab
The Bills Scheduled tab lists bills that already have a payment scheduled against them. Rather than one flat list, it's split into three sections:
- Ready for release
- Awaiting approval
- Released
Within each section, bills are sorted by payment date. Use it to confirm what's about to go out, alongside the aging report's view of what's already overdue.
Entity and currency handling
The Aged Accounts Payable report runs per entity. It does not have a consolidated view across entities, so check each entity's payables separately if you operate more than one.
Bills in a foreign currency convert to the entity's local currency using the exchange rate that applied when the bill was booked, not the rate on the day you run the report. This keeps the aging report consistent with the amounts already recorded in your ledger.
The Total (Transaction Currency) column shows each vendor's balance in the currency the bill was originally issued in (e.g. "EUR 500.00"), rather than converted to your entity's local currency. Use it alongside the Total column to reconcile a vendor's balance directly against their statement, especially when a vendor bills you in a currency other than your entity's local currency.
See Multi-entity AP for how entity scoping works across payables.
Related Articles
Also searched as: AP aging report, accounts payable aging, aged payables, vendor aging, overdue bills, aging buckets, bills past due, aged AP detail.