An aged payables report lists what you owe each supplier, grouped by how overdue each bill is. What is accounts payable?
Before you start
- Finance permissions
The Business Central way
Where to find it: Aged Accounts Payable report (Excel layout) and Power BI Aged Payables (Back Dating)
- Search for Aged Accounts Payable Excel (report ID 4403) and run it.
- On the request page set Aged as of and Period length. The report buckets vendor ledger entries by those and summarises by the two global dimensions.
- Open the Excel workbook. It has worksheets By period (LCY), By Period (FCY) and Due by Currencies, plus a data sheet.
- For a look back at a past date, open the Power BI Aged Payables (Back Dating) report.
- For a quick view, open Vendor Ledger Entries and switch on Data Analysis to group what you owe by due date.
Limits in Business Central
- The older Aged Accounts Payable report (ID 322) and Vendor - Summary Aging (305) are marked as legacy in the report list.
Good to know in Business Central
- Data analysis on Vendor Ledger Entries gives a quick view by due date.
- Vendor - Balance to Date (321) shows vendor balance at the end date of a range. Vendor - Detail Trial Balance (304) lists all ledger entries in a date filter.
- Payments on Hold (319) lists vendor ledger entries where the On Hold field is not blank.
- Payment Practice (page 687) shows how quickly you pay vendors, by period or by vendor size. Some countries require it.
- Report Explorer lists the finance reports in one place.
Words Business Central uses
- Dimension. A tag on a transaction, such as department or project, used to report cost without extra accounts.
Common mistakes
- Running the report with the wrong aging date basis.
- Using the current report for an old date. The Power BI back dating report is for that.
More help
- How to run the AP Aging report in MYOB Acumatica
- How to run the supplier ageing report in Sage 200
- How to run the Aged Payables report in Sage 300
- How to apply a purchase credit memo to a purchase invoice in Business Central
- How to close the month in accounts payable in Business Central
- All Business Central how-to guides
- Pulsify setup guides
Sources
Last checked 2026-10-19. Confidence: confirmed.
Common questions
Which report shows aged payables?
Run the Aged Accounts Payable Excel report. Pick the aging date basis and period lengths.
Can I look back at a past date?
Yes. Use the Power BI Aged Payables (Back Dating) report.
Is there a quick view?
Data analysis on Vendor Ledger Entries gives a quick view by due date.
Does Pulsify run this report?
No. Run it in your accounting system.
Want this done for you?
Book a call to see how Pulsify handles supplier bills in Business Central.