Setting up sales tax in QuickBooks Online (QBO) could not be easier.  The most recent update to the program makes the work simple.  QBO finds your state’s rate and even connects you to the corresponding Department of Revenue’s website right from within the program.  Much of this set-up is automatic.  Of course, in some states, sales tax is far from simple.  This post addresses the most simplest of sales tax setup.  One state, one rate.   If you live in a state like New York, with complex state, city, local tax, I highly recommend using the app, Alavara.  Alavara also is a great resource (see their blog) to learn about sales tax and the varying laws throughout the country.

Start with clicking tax in the left toolbar….

Sales Tax Center:    This is where you manage all your sales tax tasksAdd multiple sales tax rates, including combined rates (details on this to come in a future tutorial)View sales tax liability reports that you can customize by date, agency and moreRecord sales tax return and payments in the Sales Tax Center so you can see all your recent payments in one place

Questions to ask yourself when you get started…

  • Do your products or services require sales tax in your state?
  • What’s your sales tax rate(s)?
  • What agencies do you need to pay your sales tax to?
  • How often do you have to make sales tax payments?

Where to find these answers….

The government website for your state. Often you’ll find a section that contains detailed information about taxes in the state.  For Florida, click here or for a list of everywhere else, click here.

If you are completely lost after all of the above, contact a professional.  When you collect sales tax, you are their agent.  Sales tax can be complex, confusing and you can be audited.

How sales tax works in QuickBooks…..

QBO calculates sales tax from the settings you enter in Sales Tax Center. After creating your items that you sell, your first step is to indicate whether all new products and services are taxable. Then, you add your sales tax rates and agencies.QBO adds a sales tax field to your sales forms, like invoices and sales receipts as well as customer credit memos in the event of a return of purchase from your customer. You can select to have a default sales tax rate item for your customer.  Each time you create a new sales form, it will default to last used or you choose the sales tax rate to use for the customer. You can select another rate, if applicable, for your customer if situations have changed (customer moved to a new state).  QBO calculates the Taxable Subtotal by totaling every charge on the form that has its Tax column selected. Then, the Taxable Subtotal is multipled by the Tax % to arrive at the figure in the tax amount field to its right. If you’ve added more than one tax rate in Sales Tax Center, you can select a different tax rate from the Tax drop-down list.Taxes on discounts can also affect sales tax.

If you have to prepare a customer return, make sure you are careful to do it in the current tax period.  Do not void or modify a customer form once sales tax has been paid.  Always be diligent to do any modifications in the current period.  If you do void, do so with a credit memo reversing the original entry (if the void happens out of the current month).

If you converted your desktop to online….

After the conversion

There will be at least two sales tax payable accounts on the Chart of Accounts: One for each old Sales Tax Payable account from QuickBooks Desktop.   One for each Sales Tax Agency Payable account in the new QuickBooks Online (set up automatically for each jurisdiction during the conversion).

You will only use the new Sales Tax Agency Payable account in QBO, and all sales tax will be managed from the Taxes in the left hand navigation tab.Past Sales tax payments will convert as regular checks/cheques.Past Sales tax adjustments will convert as journal entries.

If you have any questions or would like to see a future video on another topic, please reach out to me on Facebook.

You May Also Like…

Law Firm Practice Areas – Personal Injury Law Firms

Are you a personal injury firm and wondering what software to choose? Do you want to know the best setup for a bookkeeper Working with a personal injury lawyer? This article and video will help set you in the right direction.

Law Firm Practice Area Nuances: Immigration Firms

All law firms have their unique workflows. Immigration firms have particular nuances that make working with this type of practice special. This article will spell out the top pain points and how to solve them.

Law Firm Practice Areas: Family Law Accounting Nuances

When working with accounting clients that have the practice area of family law, there are several areas that stand out that can be challenging. In this article, we will step you through some best practices for a successful family law practice.

Law firm KPIs: Break-even Costs

The cost of running your law firm and breaking even is one of the most important metrics to track when you’re starting a new law practice or with an established firm. To get there, your firm must have enough revenue to cover the costs associated with it.

Law firm KPI: Attorney Productivity

Tracking law firm staff production is a critical task for attorneys to track. Many of our clients are in growth mode, and it’s essential to monitor how well your staff is producing. This article discusses a few KPIs or key performance indicators to help you track staff production.

Attorney KPI’s: Marketing for your Law Firm

Tracking your marketing dollars as an attorney running a law firm is critical for firm growth. Learn the tips and tricks we use with our attorney clients to help them grow a profitable law firm.

Law Firm Client Satisfaction Score

My number one KPI for law firms is the client satisfaction score. Running your firm without this important metric can be difficult. Read this article to learn the steps and questions you should ask in setting up your own client satisfaction score.

Attorney Compensation: Growing your Firm the Smart Way

Are you an attorney running a growing firm that is in need of that perfect compensation plan? Are you hiring and trying to gain good staff? This article shares the methods we recommend to our own clients to help them succeed!

The BEST Workflow When Working with Attorneys as an Accountant

We believe our workflow is the best way to make your law firm be more future-ready and cloud-based. Learn why you need to move off from antiquated systems and on to a proven workflow that works!

How to Analyze a Law Firm’s Financial Statements

Interpreting and analyzing data from your law firm books starts with the foundation, which is your chart of accounts. How do you measure your overhead? This post will help you determine best methods for analysis and also trends to look for

Resources for Attorneys

Don't know where to start?

Call us today! We can help you with your accounting and data migration needs. 

QuickBooks Online for Attorneys

Are you an attorney and want to use QuickBooks for your accounting software but don’t know where to start? Download this free e-book today!

Resources for Accountants

We have a course! Fast Track Legal Accounting!

Are you an accountant or bookkeeper that just landed your first attorney-client and needs to know where to start? Do you have a few but want to serve them better? We have a course to get you started!

If you are interested in more information, join our private mastermind group,
The Accountant’s Law Lab: