Report showing invoice details and date of payment

  • 1
  • Question
  • Updated 4 days ago
  • Answered

is there any way to have a report per supplier / customer that shows both the invoice details and the date the invoice was paid / payment was received?

I am aware of the history button but it is very time consuming doing this line by line. 

Hopefully there is a solution for this!
Photo of J White

J White

  • 466 Points 250 badge 2x thumb

Posted 2 years ago

  • 1
Photo of John Graetz

John Graetz

  • 18,994 Points 10k badge 2x thumb
Hi J  If you are referring to this information for a customer who you have billed and who is then paying you, you could run a statement for the customer and select the option Show tax invoice item details on statements and see if that covers what you are looking for.  I cannot readily determine if you are after this information for customers or suppliers or both.
John L G.
Photo of Bronwyn Reid

Bronwyn Reid

  • 60 Points
This is not a solution. I also need to have a simple report that shows:
Invoice #
Date of Invoice
Date payment received

If the report could have Invoice Due date as well that would be good.

Photo of John Graetz

John Graetz

  • 18,994 Points 10k badge 2x thumb
Bronwyn.  Have you tried running a Customer Transaction Detail Report, editing it to include your desired date range, and using the filter to select the customer, terms and due date fields?  This will give you the invoice number, the date of issuance of the invoice, the due date and the recorded date of payment.
John L G
Photo of Kayla O'Sullivan

Kayla O'Sullivan

  • 60 Points
Hi Bronwyn, did you find a solution to your question? I am also looking for a similar report. Having the date paid on the same line would be ideal.
The closest report I have been able to find is a 'Transaction List by Customer', but that has the payment transaction on a separate line to the tax invoice. When i try to add in 'Date Paid' column, nothing shows in the column.