11 Aug’15

Dynamics AXAccount Receivable Reconciliation Process

Accounts Receivable is process of matching customer account balances with the general ledger balance. The reconciliation should be done at least monthly as part of the month-end closing procedures so any adjustments needed can be included in the correct period.

Below are steps to process accounts receivable reconciliation.

1. The Ledger accounts to be checked in the ‘Customer Posting profile’ accounts.


Accounts Receivable→ Setup→ Customer Posting Profile

2. Summary accounts for Accounts Receivable should not be allowed for manual entry.

3. Run the report for ‘Balance List’ for the above ledger accounts.


General Ledger→ Reports→ Transactions→ Balance List


  • Enter the Start & End Date for the closing month.
  • Click ‘Select’
  • 4

  • Select all the ledger accounts required.
  • Click ‘Ok’.
  • Run the report with the selected ledger accounts.
  • 5

    4. Now run the Report for Customer Balance List.


    Accounts Receivable→ Reports→ Status→ Customer Balance List


  • Select From date, Report period start date and To date
  • Click OK
  • 7

  • The Total Ledger Balance for ‘Accounts Receivable’ should match with the total ‘Customer Balance’.
  • If they do not match, we need to find the transactions with discrepancies.
  • To find the transactions with discrepancies,
  • Run the report for ‘Customer-Ledger Reconciliation’.
  • 5. Run Customer-Ledger Reconciliation report


    General Ledger→ Reports→ Reconciliations→ Customer→ Customer


  • Select the Dates, Posting Profiles.
  • Select the check boxes for
    1. Include Details
    2. Differences only.
  • Click OK to get the transactions with discrepancies.
  • 9

    6. All the transactions with differences should be analysed to find the transactions.

    The reasons for the discrepancies can be as follows.

    1. The posting profile changes (Change of ledger accounts in the posting profile during that period)
    2. Manual entries to the Ledgers

        1. The posting profile changes

    1. Posting profile is a setup where the ledger accounts defined for the customer balances.
    2. A ledger account can be defined for all customers or for a group of customers or even for an individual customer.
    3. During a fiscal period, if the ledger account is changed for a customer in the posting profile; there arises a discrepancy in the customer account balances & their ledger balances.

        2. Manual Journal

    1. Another reason for a discrepancies is a manual entry to the ledger account for the customer.

    7. Steps to correct discrepancies

    1. A journal voucher can posted to transfer the balance from one ledger account
    2. For example:

      Suppose the ledger account defined for all customers is defined as ‘130100’ & after that for a specific customer group, a new ledger account is mapped; which is ‘130110’.

      When the ledger account is changed, all the transactions for the customer group before the change would show discrepancies.

      Solution: A journal voucher can be posted to transfer the balances between the two ledgers.

    1. The transactions with incorrect posting should be reversed & then they should be posted again.
    2. Solution: A manual journal is required to be posted to transfer balances between the two ledger accounts.


    1. You can use Account Reconciliation Process to check discrepancies before month end closing.
    2. Run Balance list report, Customer balance list and Customer reconciliation report to find discrepancies.
    3. Use journal to correct discrepancies or if possible then reverse posted transaction to correct discrepancies.


    Written by

    Team Member


    Leave a Reply

    Your email address will not be published. Required fields are marked *

    Time limit is exhausted. Please reload the CAPTCHA.

    Want to streamline your business processes?

    • This field is for validation purposes and should be left unchanged.

    Recent Articles

    • Dynamics 365 Client Diagnostics

      15 March’ 2018

      Main cause of Performance Issues: Bandwidth and latency are the primary characteristics which affects the performance o...

      Read more
    • Closing Blind Shift in MPOS and CPOS in Dynamics 365 for Retail

      15 March’ 2018

      Manual For closing Blind shift in POS: Blind shifts terminate the currently ongoing shift and when logged in a new shif...

      Read more
    • Persistent Filters in the Power BI Service

      13 March’ 2018

      Introduction: The feature is finally release, and it is power BI has announced general availability of persistent filt...

      Read more
    • Cause and Solution for Scribe MSMQ not receiving Message from AX

      10 March’ 2018

      Issue: Microsoft Message Queuing (MSMQ) service running on Server might be unable to receive messages. Therefore, messa...

      Read more
    • User Privileges on SharePoint – D365 Document Integration

      10 March’ 2018

      Overview: Often, we wonder what could be wrong where we see a generic error on Documents in Dynamics 365. Something lik...

      Read more