Prepayments not showing in Debtor (Clients) Ageing Report

[Sameera]

Some of the above discussion was discussed in the thread here:

Customer Statement to include all items

same thing with the debtors ageing report. Agree that advance payment is not a debt so will not show on the ageing report. We have had several discussions on this. We are looking for a debtors report (note: ageing excluded), whereby the balance (i.e. in the balance sheet) on any given date of the DEBTORS CONTROL ACCOUNT agrees with a list of debtors. This list of debtors is a debtors report… it would have both outstanding amounts and overpayments from customers. see post below. Similarl…

Hi Glenn/Mathew

Having seen the historical invoices report (recently), which seems to be more or less duplicating 'outstanding invoices; under SALES.

I feel the historical invoices is really a debtors report (the one that I have been asking for for a long time!).

The report is called historical invoices, but these are historic OUTSTANDING invoices only + the prepayments.
Which in accountant’s books is a debtors report (nothing to do with ageing) As you said, this report gives you the breakdown for the sales control account - which is exactly what a debtors report should be about.

Would the QF team consider renaming this report to Debtors report?

I am also wondering about the feature below, will it be implemented? Thanks

@Sameera

I suppose, it may be handy to have a further option when tagging a refund, where we could tag the refund direct to client account rather than it only being applied to an invoice? Not sure your system is designed for this?

No problem,

Bank tagging has some limitations, so you will be able to do 80% of the operations, but somethings (usually less common routines) will need to be done manually. Nonetheless I will pass your comments on to the development team to see if this can be done.
Thank you Mathew.

Many thanks
Sameera