Aged Creditors listing

[gokartparty]

Hello, I am trying to get a list of my creditors balances as at our year end which was 31/10/21. How can I now get a list that agrees with the closing balance on the creditors ledger at 31/10/21?

Thanks

[QFSteve]

Hello @gokartparty

You can go to Reports > Show All Reports > Creditors / Debtors Report
Enter the date you want the report to run up to.

[gokartparty]

Hi Steve,

Thanks very much, but this report shows “Invoice balance £1,908.46 less Prepayment £1,564.52 Total £343.94” The Total of £343.94 is the same balance as per the trial balance, but I have no idea how this “prepayment” amount of £1,564.52 is made up. Can you advise what this is or where I can get the detail of it please.

Thanks & Regards

Gerard

[rhc]

Hi,
At the end of each line is a down arrow. You can see a breakdown by clicking that down arrow

Hope that helps

[QFSteve]

Hello @gokartparty

If you click Export Data in the top right, you will get a full breakdown of the invoices and the prepayments in the CSV file.

[gokartparty]

Hi Steve,

Customer feedback, thats a lot of work to get a simple listing.

Thanks again for your help.

Kind regards

Gerard

[QFSteve]

Hello @gokartparty

Thank you for the feedback,

I have passed this to the development team to look in to.

[alan_mcbrien]

Prepayments held on client/supplier accounts can be viewed via doing a search in either “View clients” or “View suppliers” and ticking “prepayments” in the search area and sorting the prepayments column…