Creditors are showing payments in advance

We are trying to complete our end of year accounts and we have an amount showing as payments in advance in creditors which we cannot get to the bottom off. I have searched the amount and it is not showing up anywhere, any thoughts on what to do?
Many thanks

Hi @CFMCandMM

If you view your list of clients (or suppliers) and click on “Advanced Search”, you can enable the prepayments column. This will show you what’s assigned within your date range.
image
You can also export the data from a Debtors / Creditors Report which lists all invoices and the pre-payments too.

Hope that helps!

thanks
it is in the creditors control account - the net balance is showing up as follows
‘NET Value: -158.18 (1218 items)’

  • is there any way I can match the discrepancies without going through 36 pages of inserts?
    Thanks

It’s worth noting that the balance is only for the period in that report. So if you’re viewing it for 01/01/2019 - 31/12/2019, anything outside this range is excluded.

The creditors / debtors report will show you the balances as of a certain date. If you export this, it gives you a full breakdown too, including pre-payments etc.

This topic was automatically closed after 7 days. New replies are no longer allowed.