Run a customer aging report in Dynamics 365 Finance
Key facts
The balance date determines which transactions contribute to the report. The aging date and date basis determine where the open amounts appear.
This guide is not legal advice and laws/rules may change; consult a qualified professional for personalized assistance. Use at your own risk.
Set the report dates
For a month-end close, start by setting both Balance as of and Aging as of to the close date. Choose Due date as the criteria when the question is how late each invoice is. Use the period definition your team reconciles against, and retain the field selections with the export.
Check the vendor’s current options in Microsoft’s Customer aging report reference.
Read the invoice detail
Turn on Details. If you include foreign currency, keep the accounting-currency column for reconciliation and the transaction-currency column for follow-up. Check whether the first column shows unsettled payments because Payment positioning is enabled.
Separate the close file from the call list
An invoice open on October 31 may have been paid on November 3. Keep it in the October close evidence if it was outstanding at the cutoff. Before contacting the customer, check the current invoice and receipt postings. Keep the original close report so the change can be explained.
For the wider collection workflow, see the accounts receivable guide.


.webp)