Tennessee Tiered Tax Rates

gregaricangregarican Member Posts: 744 

So we will be adding a new shop in Nashville, TN soon. Tennessee has a challenging sales tax structure. Described here --> https://help.avalara.com/Frequently_Asked_Questions/Product_and_Service_Taxability_FAQ/How_is_the_Tennessee_Tiered_Tax_applied%3F.

Based on what I see in terms of configuring tax rates and tax classes in Lightspeed Retail, I don't see where this TN Tiered Tax is doable. A portion of an individual line item can be taxed at a certain rate, depending on its dollar amount. I was just in an online chat with a Lightspeed Retail support rep (Jan L.), who pointed me toward creating tax classes for these three tax tiers. And having the sales staff manually apply them as needed. But even then, these taxes would apply to the entire amount, not just a tiered portion.

Anyone out there using Lightspeed Retail in the state of Tennessee? If so, how do you workaround this?


  • gregaricangregarican Member Posts: 744 

    From the support chat ...

    Chat started on 03 Jan 2020, 01:52 PM (GMT+0)


    *** Greg Kujawa joined the chat ***


    Greg Kujawa: We will be adding a new shop in Nashville, TN within a month. Wanted to confirm that Lightspeed Retail correctly calculates Tennessee Tiered Tax rates.


    Greg Kujawa: Here's an article detailing how this tax is structured --> https://help.avalara.com/Frequently_Asked_Questions/Product_and_Service_Taxability_FAQ/How_is_the_Tennessee_Tiered_Tax_applied%3F


    Customer Service: All of our agents are currently busy assisting other customers. Your question is important to us and we will be with you shortly!


    *** Jan L. joined the chat ***


    Jan L. : Hi, my name is Jan and I will be assisting you today.


    Greg Kujawa: Sounds good.


    Jan L. : let me double-check on that for you.


    Jan L. : one moment please


    Greg Kujawa: Thank you.


    Jan L. : can I have your account ID please


    Greg Kujawa: xxxxxx


    Jan L. : Thanks, One moment please.


    Greg Kujawa: Okay.


    Jan L. : Thanks for waiting, as per checking, yes lightspeed will still be able to calculate your tax correctly as long as it's also set up correctly in the system.


    Greg Kujawa: What do you mean "set up correctly in the system?" This is a manual configuration I'm assuming?


    Jan L. : Yes, you will have to manually set tax rates on your account settings.


    Greg Kujawa: If you can please forward me a link that explains this I'd appreciate it. That way we can refer to it when setting up the new shop. Thanks!


    Jan L. : okay no problem.


    Jan L. : https://retail-support.lightspeedhq.com/hc/en-us/articles/229131108-Setting-sales-taxes


    Greg Kujawa: Actually while I was waiting I just looked in these settings. I don't see where I can set dollar thresholds for the tiers. For example, $1,601 to $3,200 for a single line item in the sale.


    Greg Kujawa: If you click the link that I sent in the beginning of this thread, the tiers are explained. I don't see where this is doable in the Settings.


    Jan L. : one moment. let me go back to that


    Greg Kujawa: - State tax rate of 7% is applicable to all amounts. - Local tax rate between 2.25% and 2.75% is applicable between 0- $1,600 for all items. - State single article tax rate of 2.75% is applicable for all single items between $1,600-$3,200.


    Greg Kujawa: It's tricky, so that's why I asked :)


    Jan L. : Okay, so this is doable by using tax classes


    Jan L. : https://retail-support.lightspeedhq.com/hc/en-us/articles/360033992054-Setting-tax-classes


    Greg Kujawa: Hmmm, I don't see where this is defined by dollar thresholds. So I'm assuming that the salesperson would have to manually select the classes that might apply? And keeping in mind this tax applies to individual line items, as the Avalara link explains with concrete examples.


    Jan L. : Indeed the system won't be able to automatically recognize the by dollar threshold, you will have to create the tax classes and tax rates then assign the tax class to the items individually depending on the item price.


    Greg Kujawa: Gotcha. Thanks for your help!


    Greg Kujawa: That's all I needed. Have a good weekend!


    Jan L. : no problem


    Jan L. : Perfect. Thanks for your time and have a great day.


    *** Jan L. left the chat ***


    *** Greg Kujawa left the chat ***

  • gregaricangregarican Member Posts: 744 

    I have learned that Avalara offers an integrated solution that supposedly works with Lightspeed Retail POS. Will find out more details on Monday.

  • gregaricangregarican Member Posts: 744 
    edited January 2020

    So here is what I see...

    1) Avalara can integrate with Lightspeed Retail POS for handling TN Tiered Tax. They calculate things based on the line item particulars, then adding a new dummy line item that sums up the tax owed. The tax collected footer actually reflects zero tax collected, as the dummy line item provides the reporting detail. Here's a demo --> https://www.youtube.com/watch?v=8kCCt95RuYQ.

    2) Avalara can perform sales tax reporting directly to the state of TN. Which is nice.

    3) Avalara reportedly will be recognized as a formal Lightspeed partner toward the end of next month. We have been told that this means they will have expanded access to override the sales tax in Lightspeed Retail POS. Meaning no more dummy line item workaround explained in Point #1 above.

    Can anyone at Lightspeed speak to Point #3? I was under the impression that Lightspeed partners and customers alike share the same API endpoints. And currently there isn't a way to override sales tax via the API. Is Lightspeed planning to release a major update next month that will expose a new POS tax override endpoint or something?

    @Adrian Samuel or @Michael Carey can either of you please let me know about this? Our contract is up this summer, and with a new Nashville, TN shop opening up around the same time we have some decisions to make. Thanks so much!

  • gregaricangregarican Member Posts: 744 
  • gregaricangregarican Member Posts: 744 
    edited February 2020

    So our Nashville, TN store is opening this coming Monday. How can we use Lightspeed Retail to tender sales transactions, in light to the tiered sales tax structure? @Adrian Samuel or @Michael Carey  I first posted this question over a month ago and didn't hear anything back as to a confirmed timetable. Any confirmation back about the Avalara partnered solution for this?

    Post edited by gregarican on
  • Adrian SamuelAdrian Samuel Moderator, Lightspeed Staff Posts: 654 moderator
    edited February 2020

    Hey @gregarican,

    Sorry for the late response, this one slipped through the cracks!

    • So there is no major releases from the API and it is possible that there was some miscommunication between Avalara and yourself about what " expanded access to override the sales tax " access is.

    Changing the tax on a SaleLine has been available for a while and can be seen here:

    Request: https://api.lightspeedhq.com/API/Account/Sale/{saleID}/SaleLine/{SaleLineID}.json

    Payload: { "taxClassID":"3" }

    So you can use custom menus to speak to your custom web application and have it override the current tax menus on the sale.

    More info about custom menus can be seen here:



    I hope this helps!

    Post edited by Adrian Samuel on

    Adrian Samuel

    Software Developer

    Lightspeed HQ

  • gregaricangregarican Member Posts: 744 
    edited February 2020

    Thanks for the feedback. So what was the nature of the Avalara partnership then, in terms of benefits for Lightspeed Retail clients?

    Appreciate the reference links and whatnot, but this only modifies SaleLine taxes against a single pre-defined taxClassID. Which (if I'm not mistaken) is static and cannot dynamically break out tiered taxes against:

    1) the entire line item amount.

    2) the line item amount between $0 and $1,600.

    3) the line item amount between $1,601 and $3,200.

    That's the crux of my question. How do your existing Lightspeed Retail clients properly collect and remit sales tax if they have nexus in the state of Tennessee? I still have yet to see a solution that would work. 🤔

  • gregaricangregarican Member Posts: 744 

    So this is still obviously an open question. If anyone out there is a Tennessee Lightspeed Retail client, how do you properly handle sales taxes? One of our head office staff visited the new store we're opening. He saw some retailers like Abercrombie & Fitch just took a flat 10% sales tax, and then refund the customer's credit card the difference that's calculated after the fact. He looked at his receipt and then checked his online statement a few days later and saw the credit. Pretty clunky and manual if you ask me, plus leaves potential legal exposure for over-collecting in the first place!

  • gregaricangregarican Member Posts: 744 

    Missed the boat on this one. We have decided to go with Shopify POS to cleanly handle what should be a simple solution --- properly collecting sales taxes. Shopify POS truly integrates with Avalara, so it will be a turn-key solution in this regard.

    Ironically enough, Shopify POS can't handle Canadian penny rounding either. But for us at least that's not an issue since we're US-based. 😁

  • gregaricangregarican Member Posts: 744 
    edited June 2021

    So about a year and a half later, the question persists. Does Lightspeed Retail properly handle sales tax for POS transactions rung in Tennessee? It seems a silly question to ask, since it's pretty much state law that sales taxes have to be properly collected and reported.

    Can anyone from Lightspeed's side please confirm or deny? @VanessaD a little over 9 months ago you had mentioned that it's in the development queue --> https://community.lightspeedhq.com/en/discussion/comment/17765. Wondering when this matter will finally be laid to rest...

  • VD_LSVD_LS Administrator, Moderator, Lightspeed Staff Posts: 788 moderator

    Hey @gregarican

    The product team had evaluated the effort of this (along with other tax schemes we don't currently support) about a year and a half ago, like you said, and it was decided that prioritizing other projects would need to happen first.

    Thank you so much for understanding. We'll notify you if something like this moves forward and goes into beta testing or general availability.


    If you have any further questions Please do not hesitate to contact LightSpeed support or check out our Support Page.

    All the best!


    Lightspeed Retail Support

    866-932-1801 ext. 2 (Toll-Free)

    514-907-1801 ext. 2 (Montreal)

  • gregaricangregarican Member Posts: 744 

    Hmm...not sure where properly ringing and collecting sales tax wouldn't be a priority. But here is a link I found where a third party integrator appears to have come up with something --> https://www.youtube.com/watch?v=8kCCt95RuYQ. Reaching out to them to see their methodology for achieving this. While it's a dummy SKU, at least that a single reportable entity for the one-off sales tax.

  • gregaricangregarican Member Posts: 744 
    edited June 2021

    Actually am almost done developing the workaround. Similar to the YouTube clip I referenced above. Adding a custom POS register button for an external website call, I see the call includes the current sale's variables as URI parameters. My web service takes the saleID, iterates its sale lines via the Lightspeed Retail API, calculates the tiered tax amounts, and then via the API adds those as sale lines that appear back in the POS register. The tiered tax amounts are associated with dummy non-inventoried SKU's.

    If I flag this shop as not having any default sales tax then the button works. We just have to report off the dummy SKU's associated with this mechanism for this one particular shop. The remainder of the shops in other states correctly calculate sales tax, thank God.

    Not the most elegant workaround, but it works 😀

    Post edited by gregarican on
  • VD_LSVD_LS Administrator, Moderator, Lightspeed Staff Posts: 788 moderator


    Thank you for the workaround! Your dedication to this is greatly appreciated and always welcomed.


    If you have any further questions Please do not hesitate to contact LightSpeed support or check out our Support Page.

    All the best!


    Lightspeed Retail Support

    866-932-1801 ext. 2 (Toll-Free)

    514-907-1801 ext. 2 (Montreal)

Sign In or Register to comment.