If your business sells products or services, then keeping track of sales tax is likely an important part of your business accounting operations. Most states in the U.S. charge a sales tax on products. Some assess sales taxes on services as well. Even if you don’t live in a state that charges sales taxes, if you do business with customers in other states you might be on the hook for collecting and remitting sales taxes and sales tax reports.
Fortunately, if you use QuickBooks as your accounting software, you can easily track sales taxes and run sales tax reports. In this guide, we’ll give a step-by-step walkthrough of how to run a QuickBooks sales tax report. But first, let’s clear up some misconceptions about sales taxes.
Sales Tax, Explained
Many business owners are confused about sales taxes. Unlike income taxes (taxes on the profits in your business or on your personal income), the money you collect for sales tax is never your business’s income. When you collect sales tax from your customers, you are acting as an agent for the state government.
There is no legal way to reduce your sales tax liability. True, most states that assess a sales tax offer exemptions, but those exemptions—with very few exceptions—apply to the purchaser, not the seller.
Let’s say your state assesses a 5% sales tax on purchases, and you sell a product for $10. The customer will pay you $10.50 ($10 for the product, and $0.50 for the sales taxes). Although the entire $10.50 will go into your business’s bank account, the accounting shows what’s really happening with this money:
Debit: Checking $10.50
Credit: Sales $10.00
Credit: Sales Tax Liability $0.50
This transaction shows your Checking account increasing by the entire $10.50 your customer paid you. But Sales—your business’s revenue—only increases by $10.00. The Sales Tax Liability account increases by $0.50. (Remember: Income and Liability accounts are increased by credits. Assets—like Checking—are increased by debits.)
Importance of Sales Tax Remittance
To be clear, not remitting the sales taxes you collect is theft. Your customers pay you the full amount for their purchases—including sales taxes—in good faith, expecting you to report and remit the sales tax portion as required. Sales taxes support numerous public benefits, and when businesses don’t report and remit them correctly, the sales tax rate increases for everyone in the community.
Sales tax authorities take proper sales tax collection, remittance, and reporting seriously. Failure to follow the law on sales taxes can result in a series of penalties, ranging from monetary to the revocation of your business license and your business’s closure, or in some cases even personal incarceration.
In short, if you are required to collect sales taxes, you absolutely must report them properly and pay them when due. With that in mind, let’s dive into how to run a QuickBooks sales tax report to help automate this process.
How to Run a QuickBooks Sales Tax Report
The process to run a sales tax report in QuickBooks is different in QuickBooks Desktop and QuickBooks Online. We’ll start with the Desktop version of QuickBooks first. Keep in mind that the user interface changes slightly with each version of QuickBooks Desktop, so your screens might look slightly different than the following screenshots.
In QuickBooks Desktop
1. Make sure sales taxes are enabled for your QuickBooks file. If you didn’t do this during your company file setup, click on Edit, then Preferences.
In the pop-up window, select Sales Tax from the left-hand menu, then click the Company Preferences tab at the top of the window.
Select the “Yes” radio button, and then follow the prompts on the rest of the pop-up window to set up your sales tax tracking. This is a multi-step process. Due to the number of variations between states and industries, we won’t go into detail here; consult with your accountant or your state’s sales tax authority for assistance with setting up sales tax tracking for your company.
When you have completed this setup, click the “OK” button to save your changes.
2. At the end of the sales tax period, you can easily run your QuickBooks sales tax report in a few simple steps. Start by clicking on the Manage Sales Tax icon on your home screen.
In the pop-up window, choose the sales tax report that will give you the information you need to complete your reporting with the state tax authority. For most businesses, this will be the Sales Tax Liability report.
3. After you’ve filed your sales tax return—either by completing a paper form or an electronic form on the state tax authority’s website—you will need to pay your sales taxes. To properly record the payment in QuickBooks and keep your liability account accurate, click the “Pay Sales Tax” button.
Note this does not actually send the payment to the sales tax authority. This step will allow you to process a check to send to the sales tax authority or to record a payment made electronically on the tax authority’s website.
In QuickBooks Online
1. Start by enabling your sales tax center in QuickBooks Online. From the left-hand menu, select Taxes.
Click the “Get Started” button on the setup screen.
Edit your business’s address if necessary by clicking on the pencil icon. Click the “Next” button when you’re done.
Now, match your sales tax rates to the correct agency or agencies. Click the “Next” button when done.
Review the rates, and click “Save” when you’ve verified everything is accurate. If you need to change anything, click the “Change” link next to the rate you need to adjust.
Click through the next two screens, which introduce you to the Sales Tax Center. You will now be taken through the setup for each applicable sales tax agency. This is a multi-step process. Due to the number of variations between states and industries, we won’t go into detail here; consult with your accountant or your state’s sales tax authority for assistance with setting up sales tax tracking for your company.
After you select your Filing Frequency, click on the “Next Agency” button (if you must file with multiple agencies) or the “Save” button (if you must only file with one, or once you have completed the setup for all sales tax authorities).
2. Now when you select Taxes from the left-hand menu, you will be taken to your Sales Tax Center. The dashboard will show you your sales tax liability due.
You can view your most recent return by clicking the “View Return” button. If you want to review an earlier period, change the “From” and “To” fields, then click Refresh.
The Upcoming section of the dashboard shows you the amount of sales tax you are accruing (accumulating), but do not yet owe.
3. You can also view a Sales Tax Liability report like the one produced in QuickBooks Desktop by clicking on Reports, then selecting Tax Liability Report.
4. When you are ready to pay your taxes, click the “View Return” button. The following pop-up window will appear; click the “Record Payment” button to properly record the payment and keep your liabilities accurate.
If you need to make an adjustment to your payment, click the “Add an Adjustment” link prior to recording your payment.
Automating Sales Taxes
If your sales tax requirements are relatively simple—meaning you only need to report and remit taxes for one or two states—you can easily use QuickBooks to help you manage your sales tax reporting and remittance. However, if you have nexus—or sales tax liability—in a number of states, you’ll likely want to automate this process.
Automating sales taxes can save you countless hours and help you prevent potentially costly errors. Some services will also help you set up the required sales tax accounts with the states in which you have nexus, saving you more time and preventing additional errors.
If you’re interested in automating your sales tax tracking, reporting, and payments, check out Avalara or TaxJar. Both services have a number of service options, ranging from tracking only to full automation. They also offer extensive education to help you stay informed about changes that affect your reporting requirements.
Why You Should Keep Sales Taxes Separate
One of the most common challenges business owners face is accidentally spending the sales tax they have collected on operating expenses. If you make spending decisions based on your bank account balance—and most business owners do—chances are you have either done this or eventually will.
For example, let’s say it’s the 10th of the month, and you have some vendor bills you need to pay. You check your bank account balance, and you notice you have $15,000—more than enough to pay your vendor bills and even have a little money left over.
However, you’ve forgotten about sales taxes, which are due on the 15th. When your accountant reminds you on the 13th to make your payment, you panic. You spent most of your available cash paying your bills, and now you don’t have the $7,000 due to your state tax authority.
There’s a simple way to avoid this: Set up a separate bank account for your sales taxes. Once a week, run a QuickBooks sales tax report and transfer the accruing funds for the week into this separate account.
This simple step will prevent you from getting into a pickle when your sales tax payment is due. It will also alleviate the stress of wondering whether you really have as much money to spend as your bank account balance indicates.
The Bottom Line
Most product-based and some service-based businesses are required to collect sales taxes. Both QuickBooks Desktop and QuickBooks Online make it easy to track your sales tax liabilities. Both software programs will also let you run sales tax reports to help you file your sales tax returns. The key, of course, is to set up the tracking properly.
Although QuickBooks makes tracking your sales taxes easy, sales tax itself is a tricky subject. Consult with your accountant or your state’s sales tax authority to ensure you are setting up your software to track your sales tax liabilities properly. You might also want to consider automating your sales tax reporting and payment requirements to take this task off your plate altogether.
Sales tax management is a no-profit activity for your business. It’s also not fun, but it is necessary. Setting up proper sales tax management systems—both for tracking and for making sure the cash is always available to pay your sales taxes—will give you peace of mind and let you focus on running your profitable business.
Billie Anne Grigg
Billie Anne Grigg is a contributing writer for Fundera.
Billie Anne has been a bookkeeper since before the turn of the century. She is a QuickBooks Online ProAdvisor, LivePlan Expert Advisor, FreshBooks Certified Beancounter, and a Mastery Level Certified Profit First Professional. She is also a guide for the Profit First Professionals organization.
Billie Anne started Pocket Protector Bookkeeping in 2012 to provide an excellent virtual bookkeeping and managerial accounting solution for small businesses that cannot yet justify employing a full-time, in-house bookkeeping staff.