Run a customer aging report in Dynamics 365 Finance

Set the balance cutoff and aging date on the Customer aging report, then turn on transaction detail so the totals can be traced back to individual invoices.
Upload a case

Key facts

The balance date determines which transactions contribute to the report. The aging date and date basis determine where the open amounts appear.

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.

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.