Difference between trial balance and open transactions report

(0) Share

Report

Posted on by Community Member

Hi everyone,

Not sure if you have encountered a problem like this one before, but I would very much appreciate if someone could provide an opinion.

When running the trial balance report for period 01.01.2021 - 31.12.2021, the closing balance in accounting currency on the Accounts Receivable account does not match the balance in the Open transactions report.

However, the closing balance in trial balance matches the customer and ledger balance in the customer/ledger reconciliation report, no mismatch there.

Not sure what may be the issue here, since we have run FX revaluation from both AR and GL.

Any ideas?

Regards,

Teodora

I have the same question (0)

All responses (4)

Answers (1)

Community Member on at

Like (0)

Report

RE: Difference between trial balance and open transactions report

Thank you for your assistance Alireza.

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,612 Super User 2025 Season 2 on at

Like (0)

Report

RE: Difference between trial balance and open transactions report

Hi TeodoraMK,

Please check if it has posted som transactions directly against customer balance accounts (i.e. Account receivable accounts) that creates this difference.

You can find these accounts from customer posting profile:

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Difference between trial balance and open transactions report

Hi Alireza,

I checked the closing balance in 2020 for this account is the same as the opening balance in 2021.

The difference that we are getting between the trial balance and open transactions report is for only one account.

According to the customer transactions report, the sum in accounting currency for this specific account is 60,134,009, whereas the customer balance is 65,654,377.26.

Regards,

Teodora

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,612 Super User 2025 Season 2 on at

Like (0)

Report

RE: Difference between trial balance and open transactions report

Hi,

Please check if sum"Customer balance" on Customer/Ledger reconciliation is equal to Customer transactions report

Then you can compare it to you trial balance report against ledger account that have been used in the company posting profile. you can export the report to excel and create a new field for (Debit - Credit) to find the actual amount for the period. Please check if the amount is like.

Have you check if opening balance for 2021 is the same with closing balance on 2020? to make sure that there has not posted any record after the year-end-close process.

Was this reply helpful? Yes No