Debtors Balances - Prepayments

Accounting
1

Hi

We have a difference in the Balance sheet Debtors (and creditors) and the Debtors/Creditors reports. We have found it is the prepayments as per a previous query raised. Sadly all of our Debtors difference are dated pre 06/04/17 so VERY historical items

I have some questions:
Why are the prepayments are not showing on the Debtors accounts?
To correct this I assume I need to move the prepayments to sales?

Thank you

2

If you download excel report of historic debtors/creditors report section, you can have list of prepayments which you can use to fix it i.e add missing invoices or delete prepayment entries from bank if not applicable anymore

3

Hi

Thank you for taking the time to contact me and reply.
I understand finding the information on the Debtors/Creditors report history but can you help me understand why these are not showing as open items on the Debtors ledger?

Thank you

4

Open items on debtors listing would be unpaid invoices, prepayments are not invoices

5

Hi

Thank you again but surely if you were paid £125.00 for an invoice that was only £120.00 surely there should be £5.00 on the account to be used against future sales if applicable?

6

You can see that £5 as prepayment on customer account.
You can also all prepayments on debtors under Sales>all clients>Advance search with Prepayments option ticked.

QF wont show prepayments under debtors listing