Can you add the date paid to the invoice list report?

Hi,

I don't find Received Payments detailed report.

I would like to buil a report with invoice number, payment date, Customer and amount.

Could you please help me?

Thanks

To be precise, the "Transaction List by Date Report" or "Transaction Detail by Account Report"

corresponds but I would like the details of the payments to export in Excel for each account.
Even if I select group by "None", I get it summarised.
I'm more looking for a "received payment" report by customer.

Hi Sonia,

The 'Invoices and Received Payments' report shows the customer, invoice number, payment date and amount and is available on all QBO plans. Let me know if you have further questions.

- Kass

'Invoices and Received Payments' report is exactly what I'm looking for but I don't have it in reports.

Please show me where I can find it.

Here is another capture. I don't find the report I need.

Good day, Sonia Muller.

I appreciate the screenshots you've provided. Let me help you go over to your account and find the report you need.

You can find this report in the Reports section in QuickBooks Online. Here's how:

1. Click Reports in the left panel.
2. Search for Invoices and Received Payments report.
3. You can filter the dates to show all the information you need.

If you want to customise the report, you can refer to this article for your reference: Customise reports in QuickBooks Online.

You may want to take a look at these articles to know what reports are included to your QuickBooks Online subscription as well as memorising them:

• Memorise reports in QuickBooks Online
• Reports included in your QuickBooks Online subscription

There you have it. Please let me know if you still need help with QuickBooks reports. I'll be happy to help you out.

Hi,

I'm surprised that I don't have access to this report.

Could you tell what I have to do?
Is it a version problem or an account setup problem?

Many thanks,

Alain

Thanks for keeping me updated about the happenings on your end, @Sonia Muller.

Allow me to join this conversation and provide you with some insights about the visibility of the Invoices and Received Payments report in QuickBooks Online.

The Invoices and Received Payments report is not yet offered to all the regions in the world. This has been made available to selected counties. Rest assured that the AU version has it.

To get this issue sorted out, I recommend verifying your account if you are using the QuickBooks Online AU version. Once verified and the problem continues, I suggest accessing your account using a private window. It helps us identify if the issue is browser-related. 

If you're now able to see the report, you can go back to your regular browser and clear its cache. Too much collected data on the browser can cause odd behavior in the system like being unable to see the Invoices and Received Payments report. Removing them can prevent this problem from occurring in the future.

However, if doing this doesn't make a difference, I suggest contacting our Customer Care Team. They have the necessary tools like the remote-viewing session that can help determine the root cause of this matter. They can also open an investigation ticket if necessary.

In addition, here are links that you can check out about the reports that are included on your subscription for both AU and rest of the world versions:

• Reports included in your QuickBooks Online subscription (ROW)
• Reports included in your QuickBooks Online subscription (AU)

Know that I'm just a reply away if you have any other concerns. I'll make sure you're all set. Wishing you all the best and stay safe.

Hi,
I tried the AU version but I think when I login, I'm redirected.
Is there any way to add this report for us?
It's really mandatory for our business and it's really a basic requirement.
Many thanks,

Alain

I'll send feedback for this report may be added on the other regions, Sonia Muller.

As my colleague shared above, this report is offered to some regions. Rest assured, I'll bring up your idea to our developers, and they'll review this suggestion.

Feel free to browse this article on what reports are available in your region: Reports included in your subscription.

If you have additional ideas, feel free to post them here. I'll take note of it!

The invoices and payments report doesn't report payments and invoices correctly when you're using projects. It shows the top-level customer object, but the projects are not listed, even if you go to the filters and select them. 

C'mon Intuit, do you even test this stuff?

These could be a cache issue in your browser, @mtstl.

Thus, the report shows incorrect information and doesn't apply the filters you've selected. Let's access your QuickBooks Online (QBO) account via a private or incognito window to double-check. 

Data stored for some time causes unusual behavior to your browser and can affect the views and performance of your QBO. To start, you can use these keyboard shortcuts in opening a private or incognito window:

• Google Chrome: Ctrl + Shift + N
• Mozilla Firefox: Ctrl + Shift + P
• Safari: Command + Option + P 

If the report shows the correct data while using a private window, then we'll need to clear your regular browser's cache. This will delete all the data stored in the browser and prevents unusual behavior to occur.

However, if the issue persists, I recommend using other supported browser. This way we can check if this is a browser-related issue.

Also, I'm adding this great article that can guide you in generating reports to show the data you need: Customise reports in QuickBooks Online.

Know that you're always welcome to post here anytime you have other concerns. I'll be around to help. Take care and more success in your business!

Hi,

I think there is a misunderstanding.

I just want a classical report with at least 3 columns:

Invoice number, CUSTOMER, payment date.

Many thanks,

Alain 

I've got you covered today, Sonia Muller.

Thanks for adding clarifications to your concern. I want to make sure we find a solution for this.

In QuickBooks Online (QBO), you can run the report called Transaction List by Customer Report. This provides a list of all your income and expense transactions. Aside from that, you can also customize the columns to include the invoice number, customer and the payment date.

It's my pleasure to walk you through on how to do this:

1. Go to Reports.
2. Enter Transaction List by Customer in the search field.
3. Click the Gear icon from the report.
4. Under Change columns, check the boxes for  Date, Num and Customer.
   
5. Click Run report.

Here's a sample screenshot of how your report would look like after customizing the columns:

I've got this article to learn more about managing reports in QuickBooks Online (QBO): Customise Reports and Email.

Let me know if you need more help. I'm always happy to lend a hand. Wishing you the best of luck!

Hi Charies,

Thanks for your support.

My problem is when a payment concerns several invoices, I would like to have a report when I can see the operation and the invoices detail.

So for example 1 payment for 2 invoices, 1 of 1500 and 1 of 500 I would like a report:
Customer Payment_Date Amount Invoice_Number 

McCabe 1/04/2020 1500 € 2020-199

McCabe 1/04/2020    500 € 2020-200

 I'm not able to get that if I start fron an invoice report because, I'm not able to add the payment date.

Thanks for your help,

Sonja

I can think of one report, Sonia Muller.

You can pull up the Transaction List by Date report. We'll customize it to show invoices and payments only. This report will provide the date of the transactions. I'll guide you how:

1. Click Reports.
2. Enter Transaction List by Date in the Find report by name field.
3. Click Customise, then go to Filter.
4. Click the Transaction Type drop-down arrow, then select Invoice and Payment.
5. Select Run report.

You can also memorise this report. This way, you won't go to the same customisation process again. 

We're just around if you need more help with this. Just click the Reply button and we'll get back to you as soon as we can. 

Hi,

Thanks for your support but I'm still far from the expected result.

I just want to be able to have a Customer "Invoices List" and their "payment date", a simple basic report to see what has been paid and when.

Invoice number   Payment date
2020-133              01/04/2020

But the field "Payment date" is not available in this report.
Thank you for you help,

Alain

Hi Sonia,

If you are using a QuickBooks AU region file, the report mentioned above 'Invoices and Received Payments' will suit your needs and is available across all three subscriptions offered. If you are using a different region, you would need to reach out to their support for further troubleshooting as this is an AU thread and I am unable to advise what is or isn't available for your product. If you click on the flag at the top of the page, you should be able to change it to the region you need. 

-Kass

I'd like to add that this feature would be much appreciated!

Sonia - Did you ever get the result you were looking for? I spent about 2hrs yesterday messing around with QBO reports trying to obtain exactly what you describe. A simple report with three columns 1) Client 2) INV# 3) Date of payment. 

Thanks!

Jesse