Report containing transaction from pending and final invoices

I can help you generate the report that you need, @jam99.

You can run the Average Days to Pay Summary report. This will show you how many days does it take a customer or customers to pay you.

Follow these steps:

1. Go to the Reports menu, hover to Customers & Receivables and click on Average Days to Pay Summary.
2. Click the Customize Report button to set the Display, Filters, Header/Footer, and Fonts & Numbers.

To further guide you in customizing your report, check out this article: Customize reports in QuickBooks Desktop.

Please also keep in mind the accounting method used in your report. An accrual-basis report shows income whether or not your customers have paid your invoices and expenses whether or not you have paid all of your bills. While the cash basis considers your revenue and expenses when you receive a payment or pay a bill.

You can refer to this article for more information about the difference between cash and accrual basis: Differentiate Cash and Accrual basis.

If you have any follow-up questions or concerns about your reports, please don't hesitate to leave a reply below. Take care and have a wonderful rest of the week.

Hi Mary,

Thank you for the reply. I did follow your suggestion, but what resulted was nothing close to what I am looking for.

Is there a way to either report (or export to .csv) all transaction detail (specifcally the items within an invoice)?

Hi there, jam99.

I appreciate you for following the details shared above and for coming back to the thread to add further details about your concern. With this, I'll be sharing information to ensure you're able to get a detailed report showing the invoice with the items, service date, etc associated with the invoice. Then, able to export them to a .csv file or Excel.

QuickBooks Desktop provides different reports that cater to your business needs. A report is a set of instructions that the program uses to display data from your company file. With this, I suggest running the Income by Customer Detail report and customize it. This way, you can personalize the page to view all invoices either pending or cleared and the date of services including the items.

Here's how:

1. Click the Reports menu at the top.
2. Choose Company & Financial.
3. Select Income by Customer Detail.
4. Click the Customize Report button.
5. Choose the Display button. Then, select Item, Item Description, Clr, Deliv date/Ship Date in the Columns search box.
6. Click the Filters tab.
7. Choose Item. Then, All items.
8. Click OK.
9. Choose the Excel drop-down arrow to start exporting.

For additional details on how you can customize any report that you generate, you can click on this article: Customize reports in QuickBooks Desktop.

Lastly, please refer to this article to see a table list that contains different reports group and their details that are available in QuickBooks Desktop: Understand reports.

If there's anything else that I can help you further with running reports, please let me know in the comments. I'll be here to lend a hand. Stay safe!

See below.

Hi,

Thank you for your reply. I followed your instructions and am now getting the individual line items (thank you!). 

However, there are some issues that make it unusable.

• Only closed invoices and sales receipts appear in the report. Pending invoices do not. Is there a way to include those?
• Closed invoices have the same ship date for every line item.
• The dates that appear under "ship date" for closed invoices do not match up with any data associated with the invoice as far as I can tell. For example, on one closed invoice, the "ship date" is 8/23 on all items, the "invoice date" is 9/30 and the dates of the line items range from 9/2 to 9/28. This particular invoice has not been emailed. I am puzzled.

Also, the field I am trying to use is the "Service Date" field that's been renamed to "Test Date" for the dates of the individual services performed.  This column (neither service date or test date) does not appear anywhere (neither "service date" nor "test date") in the customize list in the report customization.

Any ideas?

a quick note - I was able to get the pending invoices to show up by changing the posting status filter to "either". It defaults to "posting."

I still can’t seem to get invoices (eithe posting or non-posting to show dates of line items.

Happy to see you here in the QuickBooks Community today, @jam99. 

I appreciate you following the details shared above and coming back to add further information about your concern. Allow me to help share information to add service dates on your reports in QuickBooks Desktop (QBDT). 

Currently, the service date option is unavailable in QuickBooks. You can manually add the service date column to your reports. But before you proceed, make sure to edit the invoice template and add the service date column.

To add the column to your template, here's how:

1. Go to the List menu.
2. Select Templates.
3. Choose the invoice template you want to edit and select Edit Template from the Templates drop-down menu.
4. Click Additional Customization.
5. Select the Columns tab.
6. Put a checkmark in the Service Date section. 
7. Click OK.

After that, add the service date information to your customer's profile.

1. Click the Customer tab on the upper menu.
2. Select Customer Center.
3. Double-click the customer name, go to the Additional Info tab.
4. Click Define Fields, enter Service Date. 
5. Tick if it's Customer, Vendor, or Employee. 
6. Click OK. 

Lastly, run and customize a report to show the service date on the column.

1. Click Reports on the upper menu.
2. Select Customers & Receivables.
3. Choose Transaction List by Customer.
4. Click Customize Report. 
5. Under the Display tab, type Service Date and tick the box. 
6. Click OK. 

In addition, to learn more about running reports in QBDT, you may check this article: Understand reports. 

For more information, you can also check out these articles for future reference:

• Use QuickBooks Desktop custom fields.
• Export report from QuickBooks Desktop to Microsoft Excel.

Let me know if you have other concerns with managing reports in QuickBooks. I'll get back to you right away. Have a great day.

Thank you.

I already had the service date field active in my template. I had renamed it to "Test Date" and have been using it for every line item for several months. This is the field that I want to show up in the report.

I did go in and add the custom field to the customer "define fields" as you mentioned. That put the new field in the "header" section of the invoice customization section. 

I have created a "Test Data Data" column that I will have to manually type in the date (in both the service date, which is what I've been using, and the Test Date Data column that I will use for the reporting I need) in order to work-around the inexplicable limitation of this software.

If I am doing something incorrectly, please let me know.

Thank you for getting back, @jam99. Let me share with you some additional information about running QuickBooks reports for your invoice transactions.

The system uses the transaction's date on the reports. At this time, adding the Service Date or the Test Date Data column is currently unavailable. As a workaround, you can either input the details on the Memo field.

1. Open the invoice transaction.
2. Add the service date information to the Memo section.
3. Save the invoice.

Or, export your report to Excel, then add the column needed from there. You can use this link as your reference: Export reports as Excel workbooks in QuickBooks Desktop.

For more tips while handling your other customer entries in the future, you can also review the topics from this article: Get started with customer transaction workflows in QuickBooks Desktop.

If you have other questions while running your reports, please click the Reply button below. I'll be right here to provide additional assistance whenever you need it. Keep safe!

The transaction’s date being the date of the invoice?

I can see the importance of showing the correct details in the report, jam99.

The system uses the invoice date on the reports. With this, I'd recommend sending a feature request directly to our Product Development team. This helps us improves your experience with the program. 

Here's how:

1. Go to the Help menu and then select Send Feedback Online.
2. Click Product Suggestion.
3. Choose a feedback type and product area on the QuickBooks Feedback window.
4. Enter your suggestion.
5. Once done, click on the Send Feedback button.
   

Additionally, I've added these articles that'll help you personalize your reports in QuickBooks. This ensures you're able to customize them based on your business needs.

• Customize Vendor Reports
• Customize Company and Financial Reports
• Customize Customer, Job, and Sales Reports

I'm only a few clicks away if you need assistance running and personalizing reports in QuickBooks, jam99. It's always my pleasure to help you out again.