Skip to main content
B
bspeed
January 14, 2019
Question

Sales tax group rounding

  • January 14, 2019
  • 3 replies
  • 0 views

So our sales tax =9.2% if I plug in the city tax 2.9% and county of 6.3% =9.2% for the sales tax group

some invoice amounts the sales tax will round up or down a penny.

But if I make a sales tax item of the 9.2% it is perfect.

Is there any way to fix this?

Will it mess up my TPT when filing each month because we collect a few more pennies than we should?

Thanks!

    3 replies

    A
    Anonymous
    January 14, 2019

    Good day @bspeed.

     

    Let me help share some information about the sales tax calculation in QuickBooks.

     

    There are times that a sales tax amount will automatically round up or down when calculated based on the amount of the invoice or sales receipt. If there are a few more pennies collected, you can process a sales tax adjustment to make sure you keep an accurate record of these taxes. 

     

    For the detailed steps on how, please refer to this helpful article: Process sales tax adjustment.

     

    This article will lead you on the right track. If you need assistance with the steps, feel free to contact our Desktop Care Support. They can access your account in a secure environment and help you navigate easily using their screen share tool.

     

    1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
    2. Choose your QuickBooks Product.
    3. Select your QuickBooks Version.
    4. On the Contact Us page, click a topic.
    5. Click on the Get Phone Number button to see the support number.

    I'll be on the lookout for your reply if you have other questions about sales tax. :)

     

    Rustler
    Rustler
    January 14, 2019
    @bspeed wrote:

    So our sales tax =9.2% if I plug in the city tax 2.9% and county of 6.3% =9.2% for the sales tax group

    some invoice amounts the sales tax will round up or down a penny.

    But if I make a sales tax item of the 9.2% it is perfect.

    Is there any way to fix this?

    Will it mess up my TPT when filing each month because we collect a few more pennies than we should?

    Thanks!

    This BUG has been in QB since 2006 when I started

     

    intuit knows about it, I posted with a developer how to fix it in 2008, helped him do the code

    intuit just does not care IMO since the fix was never implemented.

     

    intuits solution is adjust sales tax payable, and as far as the present sale is concerned, they are not concerned.

    Their "fix" is to use a non inventory item set to non taxable to adjust the invoice total up or down.

     

     

      A
      Anonymous
      January 8, 2020

      So they expect us to figure up sales tax on every invoice to make sure it's right, then keep track of it with a separate item? I've been dealing with this for years and just send the excess collections to the state. It's bull because why does it round up when you have whole numbers. Not to mentions I collection different amounts of sales tax in NC where counties have different rates. I don't have time to do THEIR job. I pay for accounting software to work. Otherwise, I mind as well just keep a ledger. 

       

      This is a pain because I'm using two different systems and they don't balance which makes me have to create another line item to offset the difference. What a bunch of crap! Typical Quickbooks BS.

      C
      Charies_M
      January 9, 2020

      Thanks for joining this thread, Matt K.

       

      I appreciate you for sharing your thoughts about the rounding off behavior of sales tax to some invoice amounts. In the meantime, you can process sales tax adjustment to correct the tax amounts. 

       

      While our engineers continue to develop a concrete resolution, I encourage you to visit this link: https://www.firmofthefuture.com/product-industry-news/product-updates/. I want you to be updated with the most recent happenings and future developments of QuickBooks Desktop.

       

      You can always get back to me for any questions. I'm always delighted to help. Wishing you well.

      J
      JTK148
      September 7, 2021

      Hi everyone, very new to QuickBooks and use SOS Inventory for our stock control etc. 

       

      I have noticed this issue too where the total on some invoice on SOS Inventory is out by a penny compared to Quickbooks, however, as we aren't a brand new business and have been running for a long time, we need to make sure that the totals on invoices, purchase orders, etc are all correct. 

       

      Currently we have to as a business go onto QB Online and make sure that the amounts are the same for each and every invoice etc, which can't be the best way in going about this at all. 

       

      Has there been a fix for this since, or is this still something that is apparent? 

       

       

      Kristine Mae
      Kristine Mae
      September 7, 2021

      Hi there, JTK148. Thanks for choosing QuickBooks as your accounting partner. I will add a few details.

       

      For now, we're still unable to turn off the auto-rounding feature. I know it's important to some businesses. I suggest sending feedback directly to our software engineers. They love to hear our customer's ideas and take note of it. Here's how:

      1. Click the Gear icon.
      2. Select Feedback.

      The more request it has, the more likely it'll be added to the next update.

       

      In the meantime, you can continue creating a sales tax adjustment as a workaround.

       

      Feel free to let us know if you have other sales tax concerns. We're available 24/7 to assist you. Keep safe!

        Terms & ConditionsAccessibility statement