Difference in amount of Customer Aging and trail Balance report

(0) Share

Report

Posted on by Rohin

4,624

Hi,

I am checking the trail balance and customer aging report as on 31 may 2017, but unfortunately both reports are showing different closing balance as on 31 may 2017.

Trail Balance is showing as below: $827,275.21

1881.1.PNG

But Customer Aging is showing: $847623.47

0333.2.PNG 3056.3.PNG

Then i checked Customer balance list with credit limit and it showing me same balance as Trail balance: $827875.21

2308.4.PNG

Please advice how can i identify which report showing incorrect balance?

*This post is locked for comments

I have the same question (0)

All responses (55)

Answers (3)

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi Visvash Walia,

There can be many reasons why you see different Balance.

Can you first check the following:

1. Whether the customer balance list and the open customer transaction reports show the same balance?

2. Whether the GL customer reconciliation reports show a difference between the customer and GL balances?

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

DavidGunawan 1,381 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I think you can use customer balance list report as the baseline. Because the report simply just sum up the customer transaction. Regarding the difference amount with aging report, I believe there is invoice that has been paid but has not been settled. The report consider whether the invoice has been settled or not.

Best regards.

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report
Copy link

Link copied!

Thanks for Prompt response Ludwig,

1. customer Balance and customer Open transactions , both reports are showing same balance :$827,875.21

2. Please see below customer reconcilliation report:

it showing above transations with zero amount during 1 jan 2017 to 31 may 2017.

Please suggest what to do next?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi Visvash Walia,

It is good that the customer balance and the open transaction reports match and that the reconciliation report does not show a difference, which indicates that your data are consistent.

Regarding the difference between the Trial Balance and the customer aging report:

- As your data seem to be consistent there can only be some filter issues that cause this seemingly difference.

- Can you double check that your trial balance and customer aging report are run for the same period(s)?

- Can you start the customer aging report as of the beginning of the year (start date: 01 January)? As you are looking on balance sheet transactions the filter for the period of May might cause the trouble if the Trial Balance shows the balance from January-May.

Best regards,

Ludwig

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report
Copy link

Link copied!

Thanks Ludwig & David for reply,

@Ludwig: Yes, i fetched both reports from start Jan to May but showing same result( Trail balance :827,875.21 and Customer Aging Report: 847,623.47)

One interesting thing that i found now , I run customer Aging report with parameter include Negative balance options and now its showing balance ($ 833,374.02 )

Now difference between Trail Balance and Customer Aging Report is : Trail Balance($827,875.21) - customerAging($833,374.02) = $5498.81

The difference of $5498.21 has been identified from one customer .The voucher xx-LTR-4001575 is settled by xx-RFV-3008962 but voucher xx-RFV-3008962 is showing balance even it was settled as shown below:

Please suggest me how can i correct this?

Was this reply helpful? Yes No
Suggested answer

DavidGunawan 1,381 on at

Like (0)

Report
Copy link

Link copied!

Hi Visvash,

I believe the transaction is not settled yet. The check box "Settlement" doesn't indicate whether the transaction has been settled or not. You can check the settlement status by

1. Go to "Settlement" tab. In the tab contains information about the last settlement of the transactions. If the transaction is fully settled then the "closed date" the settlement status.

2. Click History button to view the other transaction (payment or credit note) that settle the transaction.

Best regards,

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report
Copy link

Link copied!

Please see the my last comment which i have edited. Please comment on this

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I check the settlement tab for first voucher(xx-RFV-3008962) , its not showing me any closed date but second voucher(xx-LTR-4001575 ) is showing me closed date.

Note: First Voucher is showing me open transactions as shown below:

and its history is shown below:

Please suggest whats wrong & how can i correct?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Visvash Walia,

Can you share your aging period definition?

I suspect that it does not cover all periods and 'cuts' (excludes) either some Transactions at the lower or upper end of the aging period definition.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report
Copy link

Link copied!

Thanks Ludwig,

Please see below:

Was this reply helpful? Yes No