BeyondERP.Newsletter
Menu

Report page · Accounts receivable

Customer to ledger reconciliation

A report that compares customer balances with the ledger balances in the summary account of the customer posting profile.

Business process
Manage accounts receivable
Menu item
Output:CustLedgerReconciliationPeriodicTask
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report that compares customer balances with the ledger balances in the summary account of the customer posting profile.
What you do hereUse this report after posting to help reconcile the balances of customer and ledger accounts.
ExampleAfter changing a customer posting profile or customer group, print the report with Differences only to see just the lines where customer and ledger balances differ.
Customer to ledger reconciliation page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processManage accounts receivable
Menu pathAccounts receivable › Periodic tasks › Customer to ledger reconciliation
Set up firstCustomer posting profiles Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itAfter posting, at period end, when you reconcile the customer subledger with the Accounts receivable summary accounts, run from the periodic tasks menu.
How oftenAt each period close, typically monthly.
Batch settingsRun it in the background for a long period or many customers.
What the output showsCustomer balances next to the ledger balance of the summary account in the customer posting profile, with the difference per line. A difference often comes from a posting profile or customer group that was changed after transactions were posted.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Accounts receivable > Periodic tasks > Customer to ledger reconciliation.
  2. Enter the From and To Date of the period you reconcile, and limit Voucher or Posting profile if you only want one summary account.
  3. Select the Currency and turn on Include details to see the transactions behind each balance.
  4. Turn on Differences only to list just the lines that differ, plus lines where both the customer and ledger balance are zero.
  5. Run the report and investigate each difference on the customer posting profile and customer group.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Differences onlyShows only lines with differences, plus lines where both customer and ledger balances are zero.Microsoft Learn
Solution architect

4Design impact

Can it be undoneNothing to undo: The reconciliation only reads balances; it posts nothing. Microsoft Learn
If you change it laterChanging a customer's posting profile or customer group after transactions are posted can make this report show differences between customer and ledger balances. Microsoft Learn
Technical architect

5Technical

Menu itemOutput:CustLedgerReconciliationPeriodicTask Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounting manager LedgerAccountingManagerFinancial controller LedgerFinancialControllerAuditor AuditPolicyManagerChief financial officer CompanyChiefFinancialOfficerGive people one of these roles. On this system, 6 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=Output:CustLedgerReconciliationPeriodicTask
Everyone

7Sources