Report showing invoice details and date of payment

  • 1
  • Question
  • Updated 1 month ago
  • Answered
Hi,

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

  • 23,414 Points 20k 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:
Customer:Job
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

  • 22,222 Points 20k 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.
Photo of Carmel Demery

Carmel Demery

  • 60 Points
Did you come up with a solution?  To have the invoice date and paid date on the same line?  I need this to calculate average days to pay by customer for the new AASB9 standard.
Photo of John Graetz

John Graetz

  • 22,222 Points 20k badge 2x thumb
HI Carmel.  I gave details above of the type of report that you could run to get the information that you are looking for.  The only problem was that I should have said to run a CUSTOM Transaction Detail Report and not CUSTOMER.  You can find the basics of this report under Reports> Customer Transaction Detail Report.
When you run this report and select what information you need, you will get the invoice details, including terms, due date, on one line and the date of the payment on the next/another line.
John L G