Microsoft Dynamics AX (Archived)

Bank and Ledger reconciliation report

(0) Share

Report

Posted on by imran ul haq

4,017

Hi all

While generating the Bank/Ledger reconciliation report, i am getting the difference:

3175.111.jpg

I compare the ledger transaction list report with the bank statement, it is matching, and bank statement with the trail balance it is matching. And the amount mention in the report under bank balance, i haven't found this amount. Please advise how i can reconcile and find out the mismatch amount.

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Imran,

You can find the bank balance in the Cash and Bank Management module - bank accounts - balance tab. In the report section of the Cash and Bank Management module there is also a bank account balance report available that gives you the same result.

All the best,

Ludwig

Was this reply helpful? Yes No
imran ul haq 4,017 on at

Like (0)

Report

Thanks Ludwig for your reply.

Yes you are right we can check the balance but this is the running balance only and which is fine. But i want to reconcile my bank and the General Ledger for the particular period, for that i generate the report in GL module, report section , reconciliation then bank, this report shows me the difference (what i mention in my post with the image). Or may be i am reconciling with the wrong report, then this report is for what, please advise.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Imran,

Have you also tried running the bank statement report (cash and bank banagement - reports - transactions - bank statement? This report should give you the balance as of the closing date you specify?

Yet, as you have already the bank reconciliation report available, I would recommend investigating the voucher that is shown in your report above. Simply open the voucher by clicking the voucher link and then check what happened and caused the difference between bank and GL.

All the best,

Ludwig

Was this reply helpful? Yes No
imran ul haq 4,017 on at

Like (0)

Report

Yes i generate the bank statement report as per the closing date and match the closing balance of the ledger account mapped with the bank, and both the values are coming fine.

Then i reconcile the bank statement report with the GL account transaction list by using the vlookup, all the voucher which are posted from the modules are present in both the report no more or less.

If i will just see these two report it is matching but when i generate the reconciliation report from the GL, i am not understanding why it is showing this difference or may be i am not understanding the report.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Imran,

The reconciliation report actually only compares transactions that are recorded on your bank accounts with those that have been posted on the main accounts that are linked to your bank accounts in the currency management tab of the bank accounts form.

If nobody posted something manually on the main accounts linked to your banks no difference should arise.

Yet, there can be many reasons why differences arise e.g. if the main accounts setup for your bank accounts are changed later on or if a currency revaluation is run for the main accounts linked to your bank accounts. Probably have a look at the transaction origin of the voucher indicated above to find out more details.

If nothing helps, try running the GL Transaction origin reconciliation Report (GL-Reports-Reconciliation-Specification-Transaction origin). Select ledger and bank as Transactions and check what caused the variance.

Hope it helps,

Ludwig

Was this reply helpful? Yes No
imran ul haq 4,017 on at

Like (0)

Report

I generate the transaction origin report and this voucher entry is showing two time.

I think this is the problem, can u suggest me how to fix this issue

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Imran,

If you compare the voucher with the reconciliation report shown above something looks strange. Can you open the journal in which the voucher "20-BJ15...34" was recorded and post it here?

Ludwig

Was this reply helpful? Yes No
imran ul haq 4,017 on at

Like (0)

Report

Hi Ludwig, here is the journal

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Imran,

All what you have posted looks good to me. The transaction origin report shows the same data that are posted in your journal; only the bank reconciliation report looks strange as it doubles amounts in the bank balance column. I think we reached a point where you need to get a developer involved who takes a look at the bank reconciliation report as there seems to be something wrong with this report and the data it retrieves for your bank balances.

Best regards,

Ludwig

Was this reply helpful? Yes No
imran ul haq 4,017 on at

Like (0)

Report

ok, i will check with the technical guy.

And thank you very much for your usual support really appreciated.

Was this reply helpful? Yes No