Get 50% OFF QuickBooks for 3 months*

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:
Candice C
QuickBooks Team

Reply to message

Good evening, @penstruck

 

It's great to see you back in the Community! I'd be more than happy to help you figure out a report that works best for you and your business. 

 

With all the details you gave above, I recommend using the Sales by Customer Detail report and then customizing it. You'll need to add the "Sales Tax Amount" and "Paid Date" columns and filter to show only invoices and paid status if desired. Here's how: 

 

  1. Go to Reports from the top menu.
  2. Choose Sales and then Sales by Customer Detail.
  3. Click the Customize Report button.
  4. In the Display tab, select the following columns by searching or scrolling:
    • Invoice Date
    • Sales Tax Amount
    • Paid Date
    • Invoice Number (this is often in the Num column)
  5. Go to the Filters tab.
  6. Set the Transaction Type filter to Invoice to ensure you are only seeing invoice details.
  7. (Optional) Set the Paid Status filter to All to include both paid and unpaid invoices, or choose a different status if you only want to see specific types.
  8. Press OK to generate the report with the columns and filters you've selected.

 

Let me know if these steps worked for you or if we need to dig further to find you a different route. Have a great day! 

Need to get in touch?

Contact us