Debtors ageing report

[dj611003]

When I run my debtors ageing report it does not show all balances. There is at least one customer with a prepayment balance that is not showing. I cannot find out how to run a report that shows the same totals as the trial balance. Crazy that I am using an accounting system and need to check it with my calculator

[FaradayKeynes]

Download debtors ageing report on excel , it will show prepayments as well

[dj611003]

Thanks for the tip, but when I downlod the excel/csv from the debtors ageing page it is still missing at least one customer with a prepayment balance. Is there another way to run the report?

[FaradayKeynes]

try Reports> Show all reports>under “Other Reports” try Debtor / Creditor Report with date you want and then download on excel

[dj611003]

Thanks, that did the trick. The problem is unallocated payments. There does not seem to be a reliable way of reporting for each account what the net balance is for each customer, taking into account unpaid invoices, unallocated amounts and pre-payments.