Export Supplier Data

[Rebecca1]

Hi,

A client needs a report for the whole financial year to show how much has been spent with each supplier - I can’t see a report for this. Is there a way to get this information easily?

Many Thanks!!

[QFSteve]

Hello @Rebecca1

View the suppliers account and go to View > All Payments

You can then filter by date

[Rebecca1]

Thanks Steve - is there a quicker way at all? I can only get a max of 50 transactions per page and the whole report needs to be exported to analyse further.

[QFSteve]

Hello @Rebecca1 you can get the data in CSV format from a backup file

https://support.quickfile.co.uk/t/create-a-data-backup-schedule/8867

The backup will give you CSV exports of all of your ledgers You can then filter the Purchase Receipts report by date and supplier.

[Rebecca1]

Perfect, thank you!!