Reports Debtors/Creditors

Idea suggested by Amy Habashi 13 years ago

When you click on to a amount in the report, it takes you to all the Invoices/Bills and you have to work out what invoices/bills are overdue. It would make life much easier if when you clicked on the amount it takes you through to ONLY the invoices/bills that are overdue.

2 Replies

i would like to print a detailed debtors report , can you help

Hi Peter

The aged debtors report only gives the total outstanding and you will have drill into it to see the detail behind the numbers.

However you can go to Tools>Export>and choose Sales Ledger in the drop down box and the specify the dates you wish to export the information for. You then need to tick the small check box and when you press Go, system downloads the sales invoices as a csv file.

https://s3-eu-west-1.amazonaws.com/uploads-eu.hipchat.com/36185/2368368/cGIu2rmybzsYFci/upload.png

You can save this csv as an excel work book and then create a filter on the status column and choose only unpaid invoices. You can then sort this report by company which will give you the list of all invoices by customer outstanding with the days they are overdue.

https://s3-eu-west-1.amazonaws.com/uploads-eu.hipchat.com/36185/2368368/JAS0Q7bsjH4LIQV/upload.png

I have attached screen shots from a demo account to give you an idea.

Hope this will help you get a detailed debtors listing.

Best regards

Latha

Reply to this idea

Attach images by dragging and dropping or upload
 

Your comments will be public and can be answered by anyone in the Clear Books community.

Find out what we do and who we are