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.

Navigation:

Accounts Receivable→ Setup→ Customer Posting Profile

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

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

Navigation

General Ledger→ Reports→ Transactions→ Balance List

3
 

  • 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.

    Navigation

    Accounts Receivable→ Reports→ Status→ Customer Balance List

    6

  • 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

    Navigation

    General Ledger→ Reports→ Reconciliations→ Customer→ Customer

    8

  • 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.

    Summary:

    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

    CloudFronts

    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

    • Reading more then 10K records in D3FOE OData API

      11 July’ 2018

      Introduction: We all know Dynamics 365 Finance and Operations has limitation of 10K records to be fetched at a time usi...

      Read more
    • Paging in D365 Customer Engagement v9.0

      10 July’ 2018

      Introduction: The Xrm.retrieveMultipleRecords method is used to retrieve a collection of records in Dynamics 365 Custom...

      Read more
    • Set up Dynamics 365 connection in Microsoft Social Engagement

      10 July’ 2018

      Introduction: This blog explains how to Set up Dynamics 365 connection in Microsoft Social Engagement. Steps to be follo...

      Read more
    • Voice of the Customer failed to install

      10 July’ 2018

      Introduction: Many people face issues in installing Voice of Customer solution on v9 environment and trying repeatedly ...

      Read more
    • Scribe Insight AX as a Web Service Find Block issue

      10 July’ 2018

      Introduction: If we need to look up for any value from AX then we do it by using a Find Block in Scribe Insight Eg: Basi...

      Read more