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 Intuit QuickBooks Workforce
greene-gretchen-
Level 1

Some products were not taxed when already pre-programmed as taxable. We only noticed when a client made a partial return. We had to readjust for correct amount then.

How do we know if all past transactions have correctly applied tax to products?
1 Comment 1
LieraMarie_A
QuickBooks Team

Some products were not taxed when already pre-programmed as taxable. We only noticed when a client made a partial return. We had to readjust for correct amount then.

Let me share some reports you can utilize in identifying which products have tax applied, @greene-gretchen-.

 

You can view all your products and services by pulling up the Product/Service List report. Then, add the Taxable column to see if you've set them up as taxable or non-taxable items.
 

  1. Go to the Reports menu.
  2. In the Find report by name field, type in "Product/Service List." Then, press Enter.
  3. Click the Customize button.
  4. Go to the Rows/Columns section.
  5. Click Change columns, then select the Taxable checkbox.
    Capture.PNG
  6. Click Run Report.
     

Once done, you can edit your items and add the appropriate sales tax category if necessary.


Additionally, you can utilize the Sales by Product/Service Detail report to view all sales transactions. Then, customize it by adding the Taxable AmountTax Amount, and Tax Name columns. This way, you can verify if you've applied a tax to each of the items in all your transactions.


Here's how:

  1. Go to the Reports menu.
  2. In the Find report by name field, type in "Transaction List by Date." Then, press Enter.
  3. Click the Customize button.
  4. Select All Dates from the Report Period drop-down.
  5. Go to the Rows/Columns section, click Change columns.
  6. Select Taxable AmountTax Amount, and Tax Name.
    Capture.PNG
  7. Click Run Report.

 

You can read through these links to learn which reports are available for your version in QuickBooks Online:

 

Additionally, you can export them to Excel to help give you the flexibility to use them. Simply click the Export icon and select Export to Excel

 

Please let me know should you need further assistance with customizing your reports in the way your business needs. I'm always here to assist. Have a wonderful day.

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

Need to get in touch?

Contact us