Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi there, Hinton Painting.
For now, there's no option to add a column when the invoices are paid in the Invoice List report.
You might want to run the Invoices and Received Payments report instead. This report will show you when the payments were recorded or received in QBO.
I'll also send feedback to our engineers about being able to add a payment column in the Invoice List report. Most of the recent updates were actually based from customer's comments and suggestions shared here in the Community.
I'll be around if you have other questions.
Thanks - I thought as much. And I appreciate you passing on the feedback as I export the report to excel to manipulate the data further and the line format of the list report works best for this purpose. In the interim I have manually added the paid date to the spreadsheet sourced from the Invoices and Received Payments report. Doable but not time efficient - the option to add the paid date to other reports would be much more effective :)
Hi there, Hinton Painting.
For now, there's no option to add a column when the invoices are paid in the Invoice List report.
You might want to run the Invoices and Received Payments report instead. This report will show you when the payments were recorded or received in QBO.
I'll also send feedback to our engineers about being able to add a payment column in the Invoice List report. Most of the recent updates were actually based from customer's comments and suggestions shared here in the Community.
I'll be around if you have other questions.
Thanks - I thought as much. And I appreciate you passing on the feedback as I export the report to excel to manipulate the data further and the line format of the list report works best for this purpose. In the interim I have manually added the paid date to the spreadsheet sourced from the Invoices and Received Payments report. Doable but not time efficient - the option to add the paid date to other reports would be much more effective :)
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
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:
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:
There you have it. Please let me know if you still need help with QuickBooks reports. I'll be happy to help you out.
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:
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:
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:
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:
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
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
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here