Note: This post was last updated in March 25, 2019 to include a step-by-step video as shown below.
Compare the Accounts receivable ledger account(s) to the Customer aging report to reconcile the account or identify a discrepancy that needs to be reconciled.
In this example we will reconcile AR ledger account 130100 as of 4/30/15.
First find the ledger account balance through the Trial balance or Period balance form.
Second, check all Accounts receivable posting profiles to find out which customers/customer groups to run the Customer aging report for that should reconcile to the GL account being reconciled, 130100 in this case. Then run the Customer aging report and compare to the ledger account balance.
In this example below, there is a discrepancy of $10,100.00 as of 4/30/15:
|Ledger account 130100:||$8,471,198.03|
|Customer aging report:||$8,461,098.03|
For more information about Accounts Receivable Account and how you can Reconcile Accounts Receivable in Microsoft Dynamics AX2009, AX2012 R2, R3, D365 contact our Dynamics experts for training proposal, demos etc. on firstname.lastname@example.org.
If your organization is considering a move to Microsoft Dynamics 365 Finance & Operations you can watch this Dynamics 365 upgrade tutorial where Michael Oakes takes you through the different upgrade paths.
Book a free meeting and let us have a look at your opportunities with Microsoft Solutions
Discover how Avantiico helps you improve business processes, provide customers with a seamless experience and transform the way you do business.