Finance | Project Operations, Human Resources, ...

Customer/Ledger reconcilation report

(0) Share

Report

Posted on by Peta Peta

Hello Guys, I am in need of a little clarity on the Customer/Ledger reconciliation report
Upon running the Customer/Ledger report, when I select different options I end up with different balances.

If I chose to run the report and Include details and differences, For a specific ledger account A, I end up with a total difference of -1,508,145.82

When I chose to run that same report and include difference only, The total differences on that account A sum up to -297,000

I get the same total difference when I run the report with just details excluding differences and when I exclude both details and differences.

I will like to know how these options work and which is a better reflection of the differences between the AR and the Ledger.

Note, the other total The Reconciliation report differences on the other accounts are the same in all 4 scenarios.

I have the same question (0)

All responses (6)

Answers (0)

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (1)

Report

Can you post images of the last page of both report versions? thanks

Was this reply helpful? Yes No
Peta Peta 59 on at

Like (0)

Report

Dear Frank,

For the first report scenario (Including details and differences) that gives specific ledger account 116020, the Customer balance is 2,193,000, while the ledger is reporting as 3,701,145.82. Hence a total difference of -1,508,145.82

While on the second (Include differences only) and other scenarios (Include details only, details and differences excluded) the Customer balance is --186,128,267.53, while the ledger is reporting as -185,831,267.53. Hence a total difference of --297,000

Was this reply helpful? Yes No
Suggested answer

Hana Xue Microsoft Employee on at

Like (1)

Report

Hi Anoghena,

If you click the ’Include details’ to yes, it will show the line, sorted by date.

If you click the ‘Differences only’ to yes, it will show only the lines that have differences, and any lines for which the vendor account and ledger account are both 0(zero).Clear this check box to show all lines, even those that balance.

Related information found for you is in the following link.

Customer currency conversion reconciliation report (CustLedgerReconciliation) | Microsoft Learn

Best Regards,

Hana

Was this reply helpful? Yes No
Peta Peta 59 on at

Like (0)

Report

Hi Hana

Thank you for your response.

My understanding of the report is regardless of the option I pick in running the report, the value of the balances should tally right?

I have 4 accounts who's balances do not tally with the ledger, 3 out of those accounts when I run the report in whatever scenario give the same amount in differences (with details, with just differences and without both). My issue here is an account 116020 whose difference doesn't tally whenever I run it with both details and differences. I am trying to kno2 what is the exact difference between the way the reports are run and if at any point will the differences differ across any scenario.

I hope I have been able to explain better.

Thank you

Was this reply helpful? Yes No
Hana Xue Microsoft Employee on at

Like (1)

Report

Hi Anoghena,

First the general ledger balance of "Accounts Receivable" should match the "Customer Balance" total, if they don't match we need to find the transaction with the discrepancy. To find transactions with variances, run the Customer Ledger Reconciliation report and select the ‘Differences only’ option.

The detailed report provides the transaction wise data for the filtered customer which will help to identify the actual transaction impacting the difference. On the other hand, customer balance list report can be used to generate the report by main account, and this is when “Include details” check box is marked in report dialog.

The reasons for the discrepancy and the steps to correct the discrepancy are mentioned in the links below, I hope it will help you sincerely.

Account Receivable Reconciliation Process - CloudFronts

Tips and Tricks for AR and AP reconciliation – Namith Hosmane's Blog (namithhosmanesblog.com)

Best Regards,

Hana

Was this reply helpful? Yes No
Peta Peta 59 on at

Like (0)

Report

Thanks, Hana once again for your responses, they have been really helpful. I have gone through the links and they are very informative.

But my issue remains, I am not searching for a way to reconcile the AR and the Ledger, I am clear on that, However, I cannot begin reconciliation when I am not sure of the values I am trying to reconcile, my issue is with the customer/ledger reconciliation report, I want to know what option to use in running the report since when I change the options on that same report, I end up with different balances for the account 110620.

What essentially I am asking is, how does the report work, If I pick the report to run with details, without details but differences, with both details and differences? am I not supposed to end up with the same amount as differences for the highlighted account

Was this reply helpful? Yes No