Finance | Project Operations, Human Resources, ...

Customer aging report is not matching with trial balance report

(1) Share

Report

Posted on by CU21101936-0

Customer aging balance is not matching with trial balancs report

Total of 130100 and 130110 main account is 1596135.95 however the customer balance on aging report showing 15,96,091.88

The variance is of 44.07 Euro in TB balance and customer aging balance.

There is no difference found in customer to ledger reconcilation report.

How can I find the cause of variance?

Is there any way to fix the 44.07 Euro varience without showing in customer to ledger reconcilation report?

I have the same question (0)

All responses (4)

Answers (0)

André Arnaud de Cal... 301,454 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Can you provide some more details, possibly some examples, and tell us your exact question, please? Without more details, we don't know your situation and will not be able to help you with a possible question.

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,799 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Like Andre mentioned we need some details to understand help you based on that.

Also, this topics was discussed in community forum in many questions, you can refer those and few common root cause of not matching the Customer Ageing and TB is as follows~

- Customer Group was changed when there was open transactions

-Customer ledger was used for manual posting entry

-Posting profile was changed during entry

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report
Copy link

Link copied!

Hi,
In addition to Andre and Ramit's feedback, could you also share screenshots of the 'Customer to Ledger Reconciliation Report' for the specific date interval? This will help us check if there are any discrepancies between the customer and ledger accounts.

Was this reply helpful? Yes No
CU21101936-0 13 on at

Like (0)

Report
Copy link

Link copied!

Total of 130100 and 130110 main account is 1596135.95 on TB balance, however the customer balance on aging report showing 15,96,091.88

The variance is of 44.07 Euro in TB balance and customer aging balance.

How can I find the cause of variance.

Was this reply helpful? Yes No