CYBER MONDAY SALE 70% OFF QuickBooks for 3 months*   Ends 12/5

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll

Reply to message

View discussion in a popup

Replying to:
NativeDen
Level 1

Reply to message

Took awhile but there is a way to do this.

 

Unfortunately, you may need QBO Advanced subscription which now has more enhanced reporting tools.

 

Sales by Product Service Detail report in the enhanced reporting. Run the report as Accounting Method "Cash" NOT "Accrual". The date showing will be the invoice payment date. Group by "Num" which is Invoice date. Add filters based on Product/Service, Class, etc to report specifically on the products, SKUS, Customer Names, etc you need. For Columns, go to "Transaction" and checkmark the box "Date". This will be the original Invoice date. Then just restructure the columns for how you want the report laid out and done!

 

Now your report should have everything you need including the Invoice date, customer, product/service and payment date of that invoice. There may be a way to further filter this to get payment dates grouped by product specifically and not invoice. But haven't tested it out yet. Looks like the options are available for it. 

Need to get in touch?

Contact us