LIMITED TIME 90% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
rjerome
Level 1

What should be a simple report...

Hi, 

I am trying to pull what should be a common/simple data set each month, and QB Online just doesn't seem to have any way to do it. 

 

All I am trying to get, is a report that gives me the Invoice date AND the payment date, along with the Service/Product Detail and basic customer info.  The 'Sales by Product Detail' report is the closest, but QB in it's infinite wisdom doesn't seem to allow you to simply get both the invoice and payment dates.  And, i cannot locate any type of build your own report from scratch option anywhere. 

Any suggestions?  This should be so easy. 

3 Comments 3
MichelleBh
Moderator

What should be a simple report...

I have the closest report that will show you the specific information you need, @rjerome. I'd be delighted to outline the complete steps to achieve your task with you.

 

You can customize the Invoices and Received Payments and Sales by Customer Detail report one at a time. Then export it to excel to combine the Invoice Date, Payments Date, Service/Product, and other customer info. 

 

Proceed with the following steps:

 

  1. Go to the Reports menu on the upper left side. 
  2. Type the mentioned report in the search box one at a time. 
  3. Select the Customize button.
  4. In the Invoices and Received Payments reportchoose: 

 

  • Report period
  • Date
  • Transaction Type
  • Amount

 

5. In the Sales by Customer Detail, select

 

  • Customer Name, Transaction Type
  • Product/Service
  • Amount 

 

6. Hit Run report

7. Click the export icon and pick Export to Excel

8. Manually edit the data. 

reports.PNG

reportss.PNG

 

For more details about customizing reports, see this link: Customize reports in QuickBooks Online.

 

Moreover, check out these articles below to find out the different reports in your QuickBooks subscription and how to memorize them: 

 

 

I'll be here if you have any other queries about QuickBooks reports or invoices. I'm available to you at all times. Be safe.

oceanbeachesglass
Level 5

What should be a simple report...

Wait a minute...  I had an "answer" regarding a different report a couple weeks ago, with a similar recommendation to "export to Excel, then manually edit the data".  I don't think that's any sort of solution at all.  Anyone can manually cobble together an Excel report, but it seems that the whole point of having reports available in a software package is to NOT have to do that!  I don't think there's as much credibility in a manually-edited/created spreadsheet as in a stock, fixed report - at least not if you're planning on sharing it with management or with customers.

SashaMC
Moderator

What should be a simple report...

Hello oceanbeachesglass,

 

Thanks for chiming in! What I can do is submit feedback to our Developers about expanding our Reports and adding additional features. I encourage you to do the same by selecting this link!

 

Please let me know if you have any questions! I will do my best to address them. 

 

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us