Customer Statement to include all items

[Sameera]

@peterhoar4133

A customer makes a nominal payment into his account that is not linked to specific invoices

Your bank reconciliation system allows you to allocate a payment to a customers account but it then does not show on the statement even though the money has been paid and the the entry is tagged

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.

Debtors ageing report re:Payment on account

Hi Glenn I have a client who has paid me in advance for the work. The invoice will be raised at the end of the project. The project is taking well over 3 -5 months. I have therefore logged these payments under the client and if you go to the client itself you will see their advance payment. I could also see this advance payment reflected in the Sales control account under the balance sheet. However, when i looked at the Debtors ageing report, i don’t see this anywhere. I could see the other o…

Debtors aging report

Dear Glenn I refer to the post below. I have just noticed that clients who don’t have any outstanding invoice but have a credit balance don’t show up on the report. At first I thought the credit balances were not being picked up at all. However, later i noticed that i have one client who has outstanding invoices that they have not paid, and they also have a credit balance for a separate job. Their credit balance does appear in the credit balance column

Similarly, if client statement is not picking up advance payments (which are not allocated to any invoice) then it’s not a correct statement.