cancel
Showing results for 
Search instead for 
Did you mean: 
Hinton Painting
Level 2

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

 
Solved
Best answer July 14, 2019

Best Answers
JenoP
Moderator

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

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.

View solution in original post

Hinton Painting
Level 2

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

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 :)

View solution in original post

22 Comments 22
JenoP
Moderator

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

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.

Hinton Painting
Level 2

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

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 :)

Sonia Muller
Level 2

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

Sonia Muller
Level 2

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

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.

Kass_B - Product Champion
Content Creator

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

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

Sonia Muller
Level 2

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

'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.

Sonia Muller
Level 2

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

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

Rose-A
Moderator

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

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:

 

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

Sonia Muller
Level 2

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

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

BettyJaneB
QuickBooks Team

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

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.

Sonia Muller
Level 2

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

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

Adrian_A
Moderator

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

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!

mtstl
Level 2

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

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?

JasroV
QuickBooks Team

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

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!

Sonia Muller
Level 2

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

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 

Charies_M
Moderator

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

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!

Sonia Muller
Level 2

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

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

QBReport.pngQBReportSplit.pngQBReportInvoice.png

 

 

Kristine Mae
Moderator

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

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. 

Sonia Muller
Level 2

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

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

Kass_B - Product Champion
Content Creator

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

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

LaurensPP
Level 3

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

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

Jesse_F
Level 1

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

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