Sales Tax in QuickBooks Online

[#1]

This article takes a closer look at what to do to set up, record, and track sales tax for products you sell in QuickBooks Online.

Foremost, QuickBooks Online is accounting software, not tax software. You cannot file your taxes directly with QuickBooks. However, you will use QuickBooks to track the collection of sales tax. These financial records are also essential for reporting your income to the IRS. 

---

How to Set Up Sales Tax: Settings, Sales, & More

First, let’s make sure you’re set up to collect Sales Tax. All of your tax information is managed from the Tax Tab in QuickBooks Online. The first time you visit the Tax Tab, you will be prompted to complete an onboarding workflow.

Before completing this workflow, make sure you've selected your business’ accounting method in Account and Settings (Gear Icon > Account and Settings > Advanced > Accounting).  This step is very important – currently, the Automated Sales Tax Center feature in QuickBooks Online only calculates taxes using the accrual method, regardless of company accounting preferences.

The Automated Tax Center (using accrual method)

  If you are new to QuickBooks Online and you...

• ... set your accounting method to Cash BEFORE setting up your Sales Tax Center, your QuickBooks will use the Manual Sales Tax option and not the Automated Tax Center. Read the full article to learn more.  You may prefer to do this manually, and that’s perfectly fine. If so, follow the steps in the linked article and learn more about sales tax in general.  
  
  

The Automated Tax Center (using cash method)

• ... set your accounting method to Cash AFTER setting up Sales Tax, QuickBooks will calculate your sales tax, but your Sales Tax Center will only display using the accrual method. As a workaround, you can use Sales Tax Liability reports to calculate your sales tax payments.
  
  
• Remember, both methods require you to state where you sell your products in order to set the appropriate tax rate. 

The first time you begin the setup in the Tax Tab, you’ll be asked where you sell your products. By choosing your accounting method and specifying where you sell products, you're also deciding whether you want QuickBooks to automatically identify your state tax agency and calculate taxes for you.

Once you input your tax period start date and filing frequency, the Sales Tax feature is set permanently. 

---

 You should also check whether the products you sell are taxable. Generally, services are not taxable, but there are exceptions – if you’re unsure, reach out to a tax professional. When you’re in the Products and Services menu editing an item, you can choose to make it taxable. There are several Sales Tax Category options. Here’s the advice from our experts:

• From the "Sales tax" category drop-down, select the category that best fits your item. Example: Food and Drink
  
  
• From the "What you sell" drop-down, select the best description that provides specific details. Example: Soft Drinks Water
  
  

 
If you sell to tax-exempt customers (organizations, non-profits, or charities, to name a few), you can choose to not collect sales tax from them. By default, all customers are “taxable.” To change this setting, navigate to the Customers subtab and edit their account. Find the Tax info tab in the edit window and uncheck the box to exempt their account.

On taxes...

Still feeling a bit unsure? Here's the long-form guide for setting up taxes in Quick Books Online

Taxes are complicated territory. There are rules that are downright confusing. What makes these rules even trickier is that many are contextual, some only apply to certain types of business in certain circumstances. 

It’s best not to guess when it comes to tax laws. When in doubt, reach out to your accountant or a tax expert for advice. Prepare a list of questions and use your consultation to ask specific questions about your accounts. You can also reach out to the experts on the TurboTax community with your pressing questions about tax collection, exceptions, and categorizations.

---

How to Collect and Record Sales Tax

While setting up the Sales Tax Center takes a bit of planning, recording sales tax is very easy. The process is exactly the same for both Invoices and Sales Receipts. If a product is set as “taxable,” the sales tax option is automatically selected on the sales form.

 

Keep an eye on the tax column when you’re preparing sales forms so you aren’t accidentally collecting sales tax for non-qualifying products or services. A quick review of the total and subtotal is another simple way to prevent minor but nonetheless pesky errors. In general, most services are non-taxable, but it depends on your industry and where you live.

If you use the Automated Tax Center (and not the manual method), QuickBooks Online will calculate sales tax for you based on the customer’s address on file. If you need to change the tax rate, simply select the correct one from the drop-down. 

---

How to Track and Pay Sales Tax: Tracking, Recording, & Reports

You'll track sales tax throughout the quarter, but how do you use the collected data to actually make tax payments?

Tools like the Sales Tax Liability Report and Tax Tab will help you record tax payments made throughout the year, pull the numbers needed to make tax payments, and maintain accurate accounts once you’ve made tax payments. As the video mentions, you cannot pay or file your taxes directly using QuickBooks Online. Instead, you will...

• You use your sales data from QuickBooks to estimate how much state sales tax to pay so you can complete sales tax payments for each state you do business in (visit your state tax website for more on the actual payment process). 

• Once you’ve filed and made tax payments with each state tax agency, take time to review your accounts. You will make adjustments to the totals in QuickBooks for the actual amounts paid as well as the payment sources after you file (your estimates may be spot on and you will not need to make an adjustment). 
  
  

As long as you completed the workflow in the Sales Tax Center, your Sales Tax Liability Report will summarize taxable amounts from sales for each locality (state and local) you are responsible for filing sales taxes in.

Keep in mind... 

• Your accounting method matters! Depending on whether you are using cash or accrual method, your "sales" and thus collected sales tax are defined differently. Learn more about these accounting methods. 
  
  
• The totals on this report are recorded by state since you need to file taxes for each state you sell products to. 

With the information from the Sales Tax Liability Report in hand, go to the Tax Tab where you will see of all the returns you’ll need to file. Go through these returns one-by-one, using the figures from your Sales Tax Liability Report and the data in the Tax Tab to prepare your filings outside of QuickBooks. 

As needed, you can make adjustments so your accounts in QuickBooks so they match what you actually paid to each state. If everything looks good, click “Record Payment” and enter your tax payment information so the returns in QuickBooks are now marked as "paid." 

---

Learn everything you need to be successful

• How to Use the Undeposited Funds Account in QuickBooks Online 
• How to Record Bank Deposits in QuickBooks Online

Set up for Success in QuickBooks Online

• Adding Items, Customers and Products to Lists
• Financial Reports and Reporting Features
• Creating and Managing Accounts

Check your progress

• Am I Ready to Send an Invoice in QuickBooks Online?

[Wise Agbetsiafa]

Hi team;

Ghanaian Tax Laws stipulate the following scenario:

Total Sales       100.00

CST (6%)              6.00

NHIL (2.5%)         2.50

GETFund (2.5%) 2.50     

Sub-total   =   111.00 based on which we must compute VAT.

How do we do the Tax Groupings?  We did it but the VAT was being computed only on the Total Sales + only 1 of the above 3 Taxes

[Ktown808]

So, I decide to tryout Quickbooks online - I just spent hours putting in invoice data and now I see there is no tax added.  So I try to put on the automatic tax - but we have wholesale and retail customers.  I'm in Hawaii and we have General Excise tax and are supposed to charge; .50% excise for wholesale and 4.5% for all others - but the auto tax keeps charging 4.712% which our company does not use - If I try to change to tax exempt, it goes to zero (we need to charge .50% in those cases)  So, i would have to basically tell the employees when they make an invoice, they have to figure out who is wholesale/retail, then go and override and calculate the tax for .50 or 4.5 - this is going to cause so many errors that my head would explode:womanfrustrated:.  I just wish QBO would let you put in your own tax rates.  So I guess I am going back to my original software.

[jecalderon]

The tax center is an imposition turned into a nightmare.  By removing the option to allow the client create its OWN tax items, there is no way to create accurate invlices for clients withspecial tax rates.  Forexample,  in Puerto Rico allows some clients exemptions on city tax or to the state tax.  But QB Online is not breaking these taxes.  Even worse,  when an overwrite is selected,all it does is to incorrectly apply a % discount to each tax items.

[Karenb5]

I am in the new automated sales tax and cannot revert back to our old way. I collect and remit sales tax for multiple states however labor is taxable in some states and not in other states. I only have option to make labor taxable or not taxable. The system is not recognizing which states to tax or not tax labor. How can I fix??

[SG91]

I can't even access the automated sales tax center. It will only let me see the total amounts for each month but won't let me view the return. We are dealing with a mess from accounting, so being able to see these returns and make sure they are correct is important. Impossible to do if QuickBooks doesn't even work!

[LaMan5348]

Sales Tax in QB on Line For Louisiana not setup i would think the price we pay for QuickBooks it would have all the states setup. We have to do our  sales tax manually. 

[burnsm00]

How do I handle the sales tax payment coming in through the Bank Feed (and hitting a Sales tax expense account) when I have already recorded it in the Sales tax tab and it was properly recorded against the payable?  Do folks just not bring that payment amount over in the bank feed?

[SashaMC]

Hey burnsm00,

Thanks for reaching out to the Community. It will be my pleasure to shed some light on the matter. Since you record the sales tax payments manually already, the next step would be to match the transaction in your Bank Feed. Here's how:

1. Go to the Banking tab and select Banking.
2. Select For Review analyze each transaction.
3. Click the tile for the account you need to review.
4. Verify the information is correct and add information if needed, then select Match.

For more information, I recommend reviewing these articles for your edification:

• Categorize and match online bank transactions in QuickBooks Online

• Manage sales tax payments in QuickBooks Online

Please let me know if you have any questions or need clarification. My team and I will be here to assist you. Take care for now.