web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Difference between &qu...
Microsoft Dynamics AX (Archived)

Difference between "bank account details" and "chart of account"

(0) ShareShare
ReportReport
Posted on by Community Member

We have a bank reconcile process to be done every working day7-9, data from "chart of account" was matching with bank statement, so we can reconcile same amount in "bank account details",but this time there is difference"-2" when i reconcile bank, it never happened before, could you please help to check the reason? is it system issue?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Anubha Gaur,

    Can you provide some additional details of your process, what has been done and how you identified the difference?

    Have you already checked the bank-GL reconciliation report which allows you listing and investigating vouchers that caused a difference between the different ledger (GL & bank)?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    "chart of account":  General account-Common Forms-Chart of account Details-, can found that balance till 11/30 is 72,519,121

    "bank account details": Bank-Common Forms -Bank Account Details-Function-Account reconciliation-you can find the amount 72,519,121 which i inputed, but when u click transaction, u can find difference

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    Please run the following Report:

    GL/Reports/reconciliation/bank.

    When opening this report select 'differences only' and 'specification' and you should find the transaction that caused the difference.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi,

    Thank you . I will check and get back to you .

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Anubha Gaur,

    Have you found your difference with the help of the reconciliation report?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

     I generated the report you mentioned, but didn’t find the reason which caused this issue, the journal was posed by our client, they are also trying to find the reason, here I summarised the amount and currency related this issue, “chart of account” shows EUR and CHF, but “bank account details” shows JPY only, I checked the differ comes from 11/7 and 11/28, here I just summarised 11/28 as below, total of “chart of account” is 0, total of “bank account details” is 2, so the problem is Y it is not 0…, is it gain and loss between CHF and JPY? this journal was posted on 11/30. So I also mentioned the rate below.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Anubha Gaur,

    What does the report show? Can you share a screenprint?

    Can you also share Details of the two transactions that you found? I would especially be interested what is shown in the transaction origin form.

    Is that possible to attach those screenprints?

    Many thanks and best regards,

    ludwig

  • Community Member Profile Picture
    Community Member on at

    Chart of Account Report is correct but the from the ban end this difference is coming.

    And this difference is coming on dates 7th Nov and 28th Nov.

    Amount currency (Bank)  

    3,653.00

    9,132.00

    3,424.00

    8,675.00

    4,453.00

    3,424.00

    2,397.00

    81,276.00

    79,906.00

    31,963.00

    34,817.00

    54,793.00

    39,953.00

    43,149.00

    1,827.00

    18,150.00

    159,082.00

    181,125.00

    62,065.00

    166,638.00

    125,088.00

    8,220.00

    28,081.00

    43,949.00

    15,981.00

    52,281.00

    11,986.00

    53,537.00

    57,909.00

    18,835.00

    9,132.00

    8,220.00

    7,877.00

    9,361.00

    9,132.00

    6,850.00

    18,835.00

    20,433.00

    13,469.00

    2,215.00

    9,247.00

    3,310.00

    457.00

    16,438.00

    -1,540,741.00

    91.00

    45.00

    499.00

    45.00

    45.00

    -727.00

    Amount currency (COA)

    32.00

    80.00

    30.00

    76.00

    39.00

    30.00

    21.00

    712.00

    700.00

    280.00

    305.00

    480.00

    350.00

    378.00

    16.00

    159.00

    1,393.60

    1,586.70

    543.70

    1,459.80

    1,095.80

    72.00

    246.00

    385.00

    140.00

    458.00

    105.00

    469.00

    507.30

    165.00

    80.00

    72.00

    69.00

    82.00

    80.00

    60.00

    165.00

    179.00

    118.00

    19.40

    81.00

    29.00

    4.00

    144.00

    -13,497.30

    0.80

    0.40

    4.40

    0.40

    0.40

    -6.40

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    If you run the reconciliation report with the include retails parameter, then you should be able to identify the vouchers that caused the difference that you see.

    0535.br.png

    Once you have the voucher, you can check eetails such as the Audit Trial form to find out who recorded the transaction and when.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi,

    Thank you so much for your assistance we will try this out.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
GL-01081504-0 Profile Picture

GL-01081504-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans