cancel
Showing results for 
Search instead for 
Did you mean: 

How to identify the balance mismatch in Customer reconciliation GL and Age analysis report?

shreekumar
Participant
0 Kudos

Dear Expert,

Our business is facing balance mismatch between GL account and Customer age analysis. They do the reconciliation between customer reconciliation GL account with custom age analysis report. But every month we found some differences on that 2 balances. We debug the custom report and checked the table (BSID, BSAD, KNKK) one by one which is used on that report. But we couldn't identify the exact reason which causes the balance mismatch.

Could you please assist us with your ideas to resolve this issue soon?


Regards,

Shreekum

Accepted Solutions (0)

Answers (1)

Answers (1)

sanilbhandari
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi shreekumar

It is really difficult to say why there is a difference between the GL Balance and the customer ageing account. You need to provide more details:

1) What are the kind of postings you are looking at in the GL? Is this GL only a customer recon account that you are looking at or special GL Indicators are also involved? Do Special GL post to the same GL or other customer recon account? Have you considered them as well for reconciling the balances of GL and custom ageing report

2) The GL Account that you have mentioned has differences - Does it also include any kind of manual AR Adjustment accounts

3) Does the custom ageing report convert the Foreign currency balances into local currency and have you checked if the way data is represented as per your custom report and GL Balance the same considering exchange rate fluctuations

4) Was any customer recon adjustment performed during the time period when you are comparing the balances

5) Have you compared the GL Balances also with the standard ageing analysis reports for customer like S_ALR_87012168 - Due Date Analysis for Open Items? Have you compared the output in terms of line items in the custom ageing analysis and the standard report?

At the end of day, no one in community knows what is the logic which has been written in the custom ageing report and you have to figure out yourself for the same. However. the above points may help you to proceed and make progress to reconcile any differences

Hope this helps

Thanks & Regards

Sanil Bhandari