cancel
Showing results for 
Search instead for 
Did you mean: 
DavidT56
Level 1

Quickbooks online would like to be able to run a sales tax revenue summary report any ideas?

 
9 Comments 9
Ashley H
QuickBooks Team

Quickbooks online would like to be able to run a sales tax revenue summary report any ideas?

Hello, @DavidT56.

 

Are you looking for a report that will show you the Sales Tax recorded in your QuickBooks Online account? No worries, I've got you covered!

 

Here's how you can run a Sales Tax Liability Report:

  1. Go to the Reports tab in the left-hand menu.
  2. In the Find report by name, type in Sales Tax Liability.
  3. You can customize this report to fit your needs by pressing on the Customize button at the top-right of the report.
  4. If needed, you can share this report by clicking on the icons on the top of the report.

That's all there's to it! Let me know if this works for you. I'll be here if you need anything else.

DavidT56
Level 1

Quickbooks online would like to be able to run a sales tax revenue summary report any ideas?

Hello Ashley

Thank you for your reply. I know how to run the sales tax Liability Report. We used to be able to run a "Sales T Revenue Summary" report but that is no longer one of the options. That report breaks down Non- Taxable sales and Labor.  I was using the "Sales Tax Center" to get that information, But now with the new Sales Tax format I haven't been able to find a path to the "Sales Tax Center"

Any help would be appreciated.  

Michael K
Moderator

Quickbooks online would like to be able to run a sales tax revenue summary report any ideas?

Thanks for touching base with us again, @DavidT56.

 

You can customize the Taxable Sales Summary Report to show non-taxable customers and products/services. Check it out:

 

  1. Go to Reports on the left menu.
  2. Search for Taxable Sales Summary.
  3. Within the report, hit the Customize button.
  4. Click on the arrow next to Filter to expand it, then tick Customer Taxable or Product/Service.
  5. From the drop-down next to each, choose Non-Taxable.
  6. Hit Run report.

 

That's it! For more information on making the most out of customized reports, I recommend checking out: Customize reports in QuickBooks Online

 

Reach back out to me if you have any other questions. I'm here to ensure your continued success. Have a great day!

D-Rack
Returning Member

Quickbooks online would like to be able to run a sales tax revenue summary report any ideas?

I am "attempting" to switch from Desktop to Online.  I had sales tax codes set up for taxable, non-taxable, Governmental, Industrial and Out of State.   In my state sales tax report I have to separate sales to each one of these.  So the Sales Tax Revenue Summary in Desktop worked perfectly for this.  The columns in this report were "Taxable Sales, "Governmental", "Industrial", Non-Taxable, Out of state and Total.   How can I get this report in QBO?

jenop2
QuickBooks Team

Quickbooks online would like to be able to run a sales tax revenue summary report any ideas?

Welcome to the Community, D-Rack. I'd be glad to share details and help with your question about tracking sales taxes.

 

QuickBooks Online (QBO) offers a feature that enables you to set up custom tax codes akin to what you have in the Desktop version. 

 

These customized rates can be applied when creating sales transactions to ensure they appear as separate lines in your sales tax reports.

 

Let's walk through the steps to set this up:

 

  1. Go to the Taxes menu and proceed to the Sales tax tab.
  2. Click Sales Tax Settings.
  3. Scroll down to the Custom rates section and click Add rate.
  4. Create your own tax codes and click Save

 

t1.PNG

 

After that, choose the codes you have generated in the Select tax rate section while creating sales transactions.

 

t2.PNG

 

These tax codes will also have their separate lines when running sales tax liability report.

 

tax report.PNG

 

Here's an article that has more details about this option: Edit Sales Tax Rate In QuickBooks Online.

 

Here are some extra references that could be helpful once you transition to QBO and when collecting sales tax as well:

 

 

Feel free to post any further questions in the forum or let me know if you need any other assistance, D-Rack. The community is always here to help you get the most out of QuickBooks Online!

D-Rack
Returning Member

Quickbooks online would like to be able to run a sales tax revenue summary report any ideas?

Thanks for the quick response.  However when I attempt this it is not showing the "Select Tax Rate" box that you have highlighted in the middle screen shot above.  The customer I tried to invoice was setup as an Industrial exempt tax code in QB Desktop and was setup as tax-exempt with Indust_Exempt in QBO.  Why am I not seeing the Select Tax rate?     Also, I saved the invoice and ran the report but it is not putting this into Industrial exempt.

FateCandylaneT
QuickBooks Team

Quickbooks online would like to be able to run a sales tax revenue summary report any ideas?

I appreciate your prompt response, D-Rack. Let me provide additional input when tracking sales taxes in your online account.

 

Beforehand, may I know if you're currently using QuickBooks Online through a mobile app or in the web browser? You can also share detailed screenshots of your end, so I can have a clearer view of your screen. Any additional details are much appreciated.

 

You may want to open and access your QBO account in a supported web browser to ensure the Select Tax Rate box is visible. This way, you can seamlessly manage and run sales tax reports in your file.

 

However, if the issue persists even when accessing this task in a web browser, let's consider performing some troubleshooting steps to help rectify the possibility of a browser issue. Please refer to these keyboard shortcuts to open one:

 

  • Google Chrome: Ctrl Shift N.
  • Mozilla Firefox and Microsoft Edge: Ctrl Shift P.
  • Safari: Command Shift N.

 

In addition to that, you may try opening your account in a different browser. This could be an issue with the browser that you're using. Once it works from there, go back to your regular browser and clear its cache.

 

Furthermore, you may want to utilize this reference on how QuickBooks collects sales taxes for you: Learn how QuickBooks Online calculates sales tax.

 

I'll be available anytime in this thread if there's anything else you need further assistance with when managing sales taxes. Just let me know, and I'll make sure to get you covered. Keep safe and have a good one!

D-Rack
Returning Member

Quickbooks online would like to be able to run a sales tax revenue summary report any ideas?

I tried all your suggestions above.  Clearing cache, Chrome, Edge and all results are the same.  I was using the QB App on my desktop PC  (I'm not using QB on mobile devices).  I have tried using just a browser.  See the screen shot of the invoice.  This customer is marked Non-taxable in their setup. (It would not allow me to post 2 images so I overlaid the customer settings on top of invoice in one screenshot.

 

 

ReymondO
QuickBooks Team

Quickbooks online would like to be able to run a sales tax revenue summary report any ideas?

Thanks for sharing the troubleshooting steps and adding a screenshot. 

 

Let me join in this conversation and provide additional info about the Sales tax rate feature in QuickBooks.

 

Based on what you've shared, it seems that you're using the new invoice layout. 

 

I want to inform you that the classic sales tax rate feature is unavailable in the new invoice experience. This functionality is only available in the old layout. This is why you're unable to see it in your invoice window.

 

For additional reference, please check this article: See what’s new with estimates and invoices in QuickBooks Online.

  

If you still see the option to get back to the old layout, I suggest switching back. This way, you can add a manual sales tax rate to your invoice.

 

Here are the steps to revert your invoice to the old layout:

 

  1. Click the +New.
  2. Select Invoice.
  3. On the top-right corner, click the Old layout button.
  4. Select Switch layout.
  5. Enter or select the necessary details and click Leave and submit.

 

See the screenshot below for your reference:

0456835a-94a6-4f92-9847-19ec9af6fa2c.default.png

If the option to switch back is no longer available on your end, I recommend sending feedback to our developers. They can review your suggestions and most likely include them in future updates.

 

Moreover, you can customize your sales transactions in QBO. It will let you decide what info your customers see and only add the details that matter most to your business.

 

Reach back out to me if you have any other questions about adding a sales tax rate to your invoices in QuickBooks. I'm here to ensure your continued success. Have a great day!

Need to get in touch?

Contact us