How to Run and Export the Aged Accounts Receivable Report in Dynamics 365 Business Central

Late payment is the normal state of B2B receivables, not the exception. Atradius found that 43% of the value of B2B sales in the United States was overdue in 2025, and the only way to know how much of that is sitting in your own ledger is the aging report. If your company runs on Dynamics 365 Business Central, that report exists in two versions, hides behind a search box rather than a menu, and exports in four formats plus an API. This guide covers all of it: which version to run, how to export a clean file, the settings that change what the numbers say, and how to turn the file into a collections list. It is part of a series; the QuickBooks version of this guide, the Xero version, and the NetSuite version cover the same workflow in those systems.

To run the aging report in Business Central, select the Tell Me search icon, type Aged Accounts Receivable, and open the Excel report (report 4402). Set Aged As Of and Period Length, then choose Download. For the legacy report, open Aged Accounts Receivables (report 120) and use Send to for PDF, Word, or Excel. Both draw on customer ledger entries.

What Is the Aged Accounts Receivable Report in Business Central?

The Aged Accounts Receivable report lists every open customer balance in Business Central, bucketed by how long it has been outstanding as of a date you choose. Business Central builds it from customer ledger entries, which means the report reflects posted invoices, credit memos, and payments, not anything still sitting unposted in a journal.

Two versions of the same report

Business Central ships a legacy report, Aged Accounts Receivables (report 120), and a newer Excel report, Aged Accounts Receivable Excel (report 4402). Microsoft's documentation for the Excel report is now the recommended route, and the legacy report page itself carries a note steering users toward the Excel version. The legacy report still runs, still previews on screen, and still prints, so plenty of finance teams keep using it. The difference is what you get at the end: a formatted document from report 120, a live pivot-table workbook from report 4402.

Who uses it and for what

Microsoft's own use cases split three ways. Accounts receivable staff use the report to reconcile the customer subledger against the receivables accounts in the general ledger. Collections specialists use it to identify overdue accounts and prioritize follow-up by how overdue each one is. Credit analysts use it to read payment history and recommend credit limits and terms. The rest of this guide is written for the second group, because that is where an export turns into recovered cash.

How Do You Run the Aged Accounts Receivable Excel Report?

The Excel report is the version to reach for when the file is going to be worked, not just read.

Find it through Tell Me

Business Central does not put reports in a fixed menu tree. Select the Tell Me icon, the lightbulb in the top bar, type Aged Accounts Receivable, and pick the Excel report from the results. A request page opens with the report's options and filters. If your administrator has saved settings for the report, the Use default values from field at the top lets you load them, and Last used options and filters is always available so you can repeat your previous run.

Set the aging parameters

The Excel report aggregates and buckets customer ledger entries according to two parameters on the request page: Aged as of, the date the report ages from, and Period length, the size of each bucket. For a standard month-end collections read, set Aged as of to today and Period length to one month. If your customers sit on net 60 terms, a one-month first bucket is mostly noise; lengthen it so the first bucket means genuinely past due.

Download instead of Preview

Reports that use an Excel layout do not show the Printer field or the Print and Preview buttons. You get a Download option instead. Select it and the workbook downloads to your computer, or, if your organization has configured OneDrive for system features, it opens directly in Excel for the web.

Read the four worksheets

The workbook opens with four worksheets. By period (LCY) shows balances in your local currency by customer, with a date hierarchy you can collapse from year down to day on the due date. By Period (FCY) does the same in foreign currency, with a currency-code filter. Due by Currencies rolls balances up by currency code. CustomerAgingData holds the aggregated dataset behind the pivots; it does not show individual transactions, so if you need invoice-level rows you will want a different route, covered below.

If the workbook opens empty

The report does its calculations inside Excel with Power Query when the workbook opens. If a banner about external data connections appears, choose Enable content so the data loads; the report does not connect to any external source, the banner is just Excel being cautious. If a pivot still looks stale, right-click it and choose Refresh.

How Do You Run and Export the Legacy Aged Accounts Receivables Report?

The legacy report is still the fastest way to get a PDF for a bank, an auditor, or a month-end pack.

The request page options

Open Aged Accounts Receivables (report 120) through Tell Me. The request page asks for the date to age as of, the period length, and whether to age by due date, posting date, or document date. For collections, age by due date, because aging from the invoice date quietly overstates lateness for any customer on longer terms. The report generates three equal-length periods from the date you specify and shows each customer's balance in each period plus anything due before or after them. A detail option switches from one summed line per customer to a breakdown of every outstanding document, and a heading option lets you label the buckets by date range or by number of days.

Send to, not Print

With the request page open, choose Send to from the Send to menu and pick PDF Document, Microsoft Word Document, Microsoft Excel Document, or XML Document. The file downloads, or opens in Word or Excel for the web when OneDrive is configured. There is also a Microsoft Excel Document (data only) option that skips the layout and gives you raw report data, which is the better choice when the file is headed for a spreadsheet model or another system rather than a human reader.

Schedule it so nobody has to remember

Under Send to, choose Schedule to add the report to the job queue. You pick the output type, the date and time, and a recurrence; Microsoft's example is a Next Run Date Formula of D4 for every Thursday. When a scheduled report saves to a file, the finished file lands on the Report Inbox page on your Role Center. To change a scheduled report later, open Job Queue Entries, set the entry On Hold, edit it, then set the status back to Ready.

What Are the Other Ways to Get Aging Data Out of Business Central?

Two more routes matter when the report itself is not the right shape.

Open the customer ledger entries in Excel

Any list page in Business Central, including Customer Ledger Entries, can be opened in Excel from the Share menu. Filter the list to open entries first, then export. This is the route for invoice-level detail, because the Excel report's data sheet is aggregated and the legacy report's detail view is a document, not a table. You get one row per open entry with document number, due date, remaining amount, and the customer it belongs to.

Pull it through the API

For anything automated, Business Central exposes an agedAccountsReceivable API resource. Each record carries the customer number and name, currency code, total balance due, the current amount, three period amounts with their labels, the aged-as-of date, and the period length filter. It is a summary per customer rather than per invoice, which makes it ideal for a daily risk snapshot and less ideal for a dialing list. APIs need to be enabled by an administrator before anything can call them.

Choosing the route

Which Settings Change What the Report Says?

Four choices decide whether two people running the same report get the same numbers.

Aging basis

Due date, posting date, and document date produce three different reports from the same ledger. Due date is the only one that measures lateness as your customer understands it. Agree on one basis across the team and write it into the saved report settings so nobody has to remember.

Period length

One month is the default assumption, and it matches net 30. On net 60 or net 90 books, the first one or two buckets fill with balances that are not late in any way the customer recognizes, and the team wastes reminders on them. Match the period to your dominant terms.

Currency

If you invoice in more than one currency, decide whether you are reading local-currency or foreign-currency amounts before you sort anything. A mixed column sorted naively will rank a small balance above a large one, and the Excel report keeps them on separate worksheets for exactly that reason.

Dimensions

The Excel report summarizes data by the two global dimensions. If your dimensions map to branches, regions, or business lines, that split is already in the workbook, and it is the quickest way to hand each collector the slice of the book they own.

What Do You Do With the Export?

An aging report nobody acts on is a spreadsheet. The export earns its keep when it drives a next touch on every overdue account.

Build the worklist

Take the invoice-level export from Customer Ledger Entries, keep only open entries, and sort by days past due and then by remaining amount within each bucket. Collapse it by customer before anyone dials, so one call covers every open invoice on the account. Set a floor so nobody spends an hour on a small balance.

Assign an action per bucket

Recently past due gets a polite reminder, and automated is fine. The middle buckets get a reminder plus a call on the larger balances. Past sixty days, the conversation is about a payment plan or an escalation decision. Log every promise to pay with a date, and re-run the report weekly so a customer cannot drift a whole bucket between reads.

Or feed it to an agent that works the list

This is exactly the file Abivo consumes. Kate, Abivo's AI agent, takes the aging export, or connects through Abivo's Dynamics 365 integration so no export is needed, and works every overdue account by email, text, and phone. She escalates to your team only when a customer disputes, negotiates, or needs a judgment call, so the routine follow-up stops depending on anyone's afternoon while Business Central stays the system of record. Get started at https://arcollects.com/sign-up/get-started

Curious what this sounds like in practice? Here's a 98-second sample call: https://arcollects.com/#live-demo

Practical Takeaways for Business Central Users

Reach the report through Tell Me, not a menu. Use the Excel report (4402) for analysis and the legacy report (120) with Send to for PDFs. Age by due date, match the period length to your terms, and keep currencies on separate sheets. For an invoice-level collections list, open Customer Ledger Entries in Excel filtered to open entries; for a daily automated snapshot, use the agedAccountsReceivable API. Schedule the report to the job queue so the file arrives on its own, then give every bucket an owner and a next date.

FAQ

Where is the aged accounts receivable report in Business Central?

Select the Tell Me search icon, type Aged Accounts Receivable, and choose either the Excel report (report 4402) or the legacy Aged Accounts Receivables report (report 120). Reports also appear in the Reports menu on related pages such as the Customer list.

How do I export a Business Central report to Excel or PDF?

On the report's request page, choose Send to and pick PDF, Word, Excel, or XML. Reports with an Excel layout show a Download button instead. With OneDrive configured, Excel and Word files open in the browser rather than downloading.

What is the difference between the Excel and legacy aging reports?

The Excel report (4402) produces a workbook with pivot tables in local and foreign currency plus an aggregated data sheet. The legacy report (120) produces a formatted document with three aging periods and an optional per-document breakdown. Microsoft recommends the Excel report.

Why does the aging report not show individual invoices?

The Excel report's CustomerAgingData sheet is aggregated by design. For invoice-level rows, run the legacy report with the detail option, or open Customer Ledger Entries in Excel filtered to open entries.

Can Business Central send the aging report automatically?

Yes. Choose Send to, then Schedule, and set a recurrence with a date formula. The report runs from the job queue and the file appears in the Report Inbox on your Role Center.