QuickBooks

Major Update for QuickBooks Online Sales Tax

What Is Powering QuickBooks Online Sales Tax?

Last month Intuit announced that they were acquiring Exactor, a “cloud-based SaaS technology provider of sales and use tax calculation and filing.”

It is my understanding that Exactor is providing the underlying technology that is running this new sales tax feature in QuickBooks Online. This is good, Intuit did not go out and try to build this complicated technology on their own. Instead, they have acquired an existing, mature technology. This gives me much more confidence in this new feature than I would have had if Intuit was building it from scratch. On their own, it would have taken years to develop something that was the equivalent.

I’m not familiar with Exactor in detail, so I can’t really say too much about them. The company was founded in 2006, so it isn’t a newcomer. Their sales and use tax products integrate with a very impressive list of products and companies, such as QuickBooks Online, QuickBooks desktop, NetSuite, several flavors of Microsoft Dynamics, multiple Sage Intacct accounting products, and multiple payments/ecommerce providers. See this list of current integrations.

Converting from the Old Sales Tax Method

Everything I’ve shown you so far has been for a new QuickBooks Online subscription, or for an existing one where you have never enabled sales tax before this time. If you have ever turned on sales tax prior to this update, you will not be able to use the new system at this time. Here’s what you might see if you select Taxes. This is the old format for the sales tax center. If you see this, you have been using the older sales tax method, and you can’t change to the new system (yet).

QuickBooks Online Sales Tax Update

If you have enabled sales tax before this new feature was released, the question will be, How can I change to the new system? Unfortunately, it is going to be tricky to convert from the old system to the new system. In the old system, when you set up a sales tax agency, you could enter any name that you wanted. I could, for example, create an agency named “CA BOE.” In the new system, the agency names are set up for you, so they are standardized across all users. For California it would be “California State Board of Equalization.” How can QuickBooks Online know that “CA BOE” is that agency? It’s complicated. And I suspect that there are also some internal differences in how tax data is stored.

Intuit’s plan is to start off by providing the new sales tax feature to companies that have not yet implemented sales tax. No migration necessary there. Early in 2018 they should be able to start migrating customers from the old system to the new system. It will take time. I suspect they’ll start with the easier cases first. This won’t be something that can be done just by clicking a switch in your file.

So What Do I Think?

I’ve only been playing with this for a few days, so it is hard for me to comment on accuracy and reliability. I have to say that it looks very good — I’ve not been able to catch any errors. There might be a few minor user interface glitches that will be resolved soon, but nothing that causes any problems.

This feature has been field tested by a large number of users for many months now, which should give new users a lot of confidence.

As I mentioned above, I’m very happy that Intuit has acquired this technology, rather than trying to develop it from scratch. It is a very complex technology.

The new QuickBooks Online Sales Tax feature is a major improvement, and it will save a huge amount of work for any small business that has to collect sales tax.


Save pagePDF pageEmail pagePrint page

About the author

Charlie Russell

Charlie Russell has been involved with the small business software industry since the mid 70's, and remembers releasing his first commercial accounting software product when you had an 8-bit microcomputer with one 8 inch floppy disk drive. He has a special interest in inventory and manufacturing software for small businesses. Charlie is a Certified Advanced QuickBooks ProAdvisor with additional certifications for QuickBooks Online and QuickBooks Enterprise, as well as being a Xero Certified Partner. Charlie started blogging about QuickBooks in 2008 (Practical QuickBooks) and has been the managing editor and primary writer for the Accountex Report (formerly the Sleeter Report) since 2011. Charlie can be reached at [email protected]

Visit his CCRSoftware web site for information about his QuickBooks add-on products. He is also the author of the California Wildflower Hikes blog.

11 Comments

    • Anything is possible, and Enterprise is the desktop product where they are focusing development of NEW features. However, I haven’t heard anything about that, and I would be surprised if they did. Intuit really wants people to move to QBO.

      As I point out in the article, Exactor’s website says that they have an integration of their product with QuickBooks desktop. I have not used it, so the technology should be there. That doesn’t mean that they will roll that into Enterprise, however.

  • Hi Charlie,

    Thanks for sharing your knowledge about QuickBooks online Sales tax updates.
    Sales Tax Dashboard really help me to track the things in proper way.

    Looking forward to new things about QuickBooks.

  • Thanks for the article. One thing I missed is any way to indicate where the item was sold. I have to pay one rate if it is purchased at my address and another rate if I ship it to the customer’s address.

    • The product sees YOUR address as well as the ship-to address for the invoice, and should make the proper determination of sales tax based on both of those information points. As well as the classification of the item you are selling.

  • Hello, I have the desktop version and wanted to transition to the online version. After my QuickBooks advisor Lori came by Monday to set it up, we found that in order for taxes to be calculated automatically, I would have to subscribe to the $24.95 version not the basic one I currently have.
    Do you know if QuickBooks update will effect the tax calculation of the basic version? If so, when?

    • There are multiple versions of the product (three, officially, but there also are some special versions based on it), I don’t see them bringing it to all versions at this point. Although if there is enough user pressure for that, they will listen.

  • Wow, this is very promising news! Thanks for another great write-up. The integration with Avalara both on QBO (and in a somewhat lesser degreed QBD) has been very frustrating. A major reason why this is the case is supposedly Avalara’s difficultly in parsing the address in the format that QBO and QBD present it.

    Hoping a tight integration will prevent those issues. This has been and currently is a huge pain point for me and my clients.

    I can understand the complexities in converting existing files, but I hope that is something that will be available very soon as migrating data from one QBO file to another to get this new functionality would be come at a high cost. Any ideas on that time frame?

    What version levels of QBO subscription will this be included in?

    The QBO Sample Company still shows the old sales tax system. Do you know when that will be updated?

    Would like to give the new system a test drive, how should I do that?

    Thanks, Jeff

    • I’m clarifying with Intuit about which editions of QBO support this system. I had assumed all, but I’m checking.

      It won’t be in the “test company” QBO option, or the sample company. Because, I believe, that was set up using the old sales tax system, so it can’t convert. But I’m making an assumption as to WHY it isn’t. I know that they told me that it wasn’t in those versions yet. Simplest way to test this is to do what I always do – start up a new 30 day trial version.

      I don’t have a timeframe from them for being able to convert files that already used sales tax. I know that this is very high on their list of things to do (I was just talking to the product manager for the feature this morning, at QB Connect, and that came up). In any case, if they told me, I wouldn’t be able to publish that, as things like that are usually covered by an NDA. But, in this case, they haven’t told me.

  • That’s a great news and this will surely help small businesses in enhancing their accuracy of sales tax report. Thanks for the detailed information on this update.

  • Discussing this with Intuit product managers, the updated sales tax feature is offered in the US versions of QuickBooks Online Simple Start, Essentials and Plus. Again, if you have ever enabled sales tax prior to this release, the new version won’t be available to you (at this time). This won’t be in QuickBooks Self Employed, and it isn’t currently available in the cut-down version of QBO that you get for free with the Gmail Invoicing feature I’ve discussed recently.

Leave a Comment