Custom reports for Invoice# dates paid

[billyblackbox]

Hi, I have had a look at creating a spreadsheet/csv file from Quickfile which includes the data below but struggling. Can support help on this one please.
Invoice#
date invoice issued
date invoice paid
Company
amount
currency

between a date range

Thanks

[QFSteve]

Hello @billyblackbox

You would generally not see this data on 1 report because of the below reasons

• An invoice could be paid off/credited with several payments
• A payment may be paying off several invoices

You could look at the debtor/creditor report for most of it (looking at paid invoices over a period) but payment dates would not be present.

You could look at Sales > View Payments (from payment perspective) to check what payments are paying off what invoices but invoice dates would not be present.

You could also extract data from a backup to build up your own report.

A backup provides you with exports of all your ledgers in csv format

Example backup