Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi there, thartman808.
May I know what specific issue do you have with your sales tax? This is to make sure that we'll be able to address your concern. Anyway, if you have any other questions other than sales tax, please let us know so we'll be able to assist you as soon as possible.
The question that has been asked multiple times has still not been addressed by the QuickBooks team/moderator. Let me try to simplify it...
As has been addressed in multiple QuickBook team responses is how to set up a county surtax. Thank you for the directions.
However, the more complex issue has not been addressed. In Florida, the surtax is only on the FIRST $5,000.00 - there is no surtax for any amount ABOVE $5,000.00. For example, if the Florida county has a 1% surtax, and the invoice is for $6,000.00, the total surtax on the invoices would only be $50.00 ($5,000.00 cap x 1% surtax). If the invoice is for $8,000.00, the total surtax would still only be $50.00. Same goes if the invoice is for $100,000.00, the surtax would still be only $50.00 ($5,000.00 cap x 1% surtax).
If the QuickBooks team cannot address this, has anyone in the community that has dealt with the county surtax in Florida figured out a workaround yet?
Thanks!
This is a real problem and the QuickBooks Team is no help!
I set up new fictitious tax items for a specific sale with calculated percentage for the tax.
The tax percentage is calculated based on the total amount and the tax we have to collect for the sale.
It is not correct and it is time consuming, but it is the best solution I have come up with.
Fortunately, we have only a few customers in Florida, so we can do this.
Thanks for adding a clarification, @hgacctng.
Both QuickBooks Online and QuickBooks Desktop don't have the option to add multiple taxes per line item on invoices.
As a workaround, you can follow the suggestions that were shared by SJ201. Although, I'd highly suggest getting in touch with your accountant before doing these steps. This way, we can ensure that your records are accurate.
I can see how this option would be helpful for you and your business. Therefore, let me take note of this as a suggestion to improve your QuickBooks experience.
Moreover, you can send feedback to developers so they can review your request. This will help them develop our product and might include this on our future updates.
For QuickBooks Desktop, follow these steps:
For QuickBooks Online, click here to submit your suggestions: How do I submit feedback?
You can also track feature requests through the QuickBooks Online Feature Requests website.
In case you need related resources while working with QuickBooks, please feel free to skim through the topics from our help articles.
Fill me in if you have further questions, @hgacctng. I'll be around if you need any help.
Has this issue ben respolved yet fro QuickBooks desktop?
Thank you for joining the thread, kayak.
Currently, the option to add multiple taxes per line item on invoices is unavailable. I understand how this feature can be beneficial for your business. However, since our product engineers handle product changes internally, we are unable to disclose any updates at this time regarding their efforts.
In this, I recommend you send your request directly to our product engineers. They will be informed of the qualities required by business owners in this way.
Here’s how:
Feel free to comment if you have more concerns about the customer payments interface. I’m here to assist you further. Stay safe!
This is crazy that this has never been addressed by QuickBooks. This has to be an issue with all of the QuickBooks users in Florida that occasionally have invoices over $5,000 - I assume that is not a very small number of your QuickBooks users. Yet, you are unable to resolve this for your Florida accounts - is that because you are unable or unwilling to help us? Or, that you realize how big of an issues it is..?
Yes, I see your response about contacting your product engineers for a product suggestion, which I will do. But I'm not putting a lot of faith in this option as this has been an issue with Florida QuickBooks users for YEARS and hasn't been resolved yet. Even this thread was started in 2019, over four years ago... SMH...
Thank you.
QBO applies the surtax at the invoice level, the cap is there. Just map your items to a tax category to tell automated sales tax that is a product (Tangible personal property) and you will see the surtax apply when the invoice amount exceeds $5000. Open the tax draw and go to the bottom, under products and services > expand the carrot thing that looks like this > and you will see the break down of taxes being applied, along with the cap. Note that cap doesn't apply to services, that's why you need to tell QBO you are selling a product.
We have pointed out several times that the problem is with QBDT and QB Enterprise NOT QBOnline.
Even the QB team members have no solution for us at this point.
I am using QBDT, I have short term rentals and not only do I have the same problems with the county taxes, but I also cannot get an invoice to print out properly! For example, lets say the rental is $6000.00 which is 7% (includes Broward County surtax) which should only be up to $5,000. I also have to add an additional 6% tax item for Broward County Tourist Development Tax. I need these printed separately on the invoice. I did the whole subtotal thing (and made sure the bottom tax line item was 0.0%), after the subtotal I added the BCTDT, which calculated correctly. Further down on the invoice I added a security deposit, which is non taxable and have it in my items as non taxable. When printed, it shows the taxable line items, the subtotal, the BCTDT amount, then the security deposit a few lines down and then the FL sales tax after. It makes it appear like I am charging sales tax on the security deposit! It also won't calculate the cap of the $5,000 on the county surtax of 1%. I have been through all the instructions, information I could find and cannot figure out how to change it!
Can you be more specific about this? Where do i actually set up a product that is a tangible personal property item in QBO? I am a certified proadvisor and even I cant find this. Go to products/Services, choose Non-Inventory? Then what?
I SOLVED THIS
I'm using QB Desktop but was just able to solve this and confirmed it is working by viewing the transaction journal.
Go to Lists
Look for tax and search.
Click Item (New) or CTRL+N
Select this item as a Sales Tax Item
Name Surtax Cap
An example of my description "Florida discretionary sales tax surcharge cap for invoices over $5,000"
For rate leave 0%
And set the same state tax agency you pay you (in my case FL DOR)
Do not add this new item to your sales tax group rather use it as an item.
Also make sure you have the state 6% sales tax rate already created.
Create a new invoice
Set sales tax to 6%
Enter your items totaling over $5000
Add your new Surtax Cap item and tab over to the amount column and enter $50
At this point you'll get a warning but just press okay you can ignore that warning.
After saving your invoice you can view the Transaction Journal and confirm that the invoice posted correctly.
For my example I used a $7000 invoice to coincide with the FLDOR surtax example here: https://floridarevenue.com/Forms_library/current/gt800019.pdf
This "solution" appears to work if you happen to have a simple invoice and time to manually calculate and post the discretionary sales tax.
My company does business around the state and through most Florida counties. My staff does not have the time and should not be made to manually calculate the sales tax on each invoice. That is why we pay for software like this.
This "solution" is not a viable work around for me and I presume almost anyone else who reads it.
And based on previous comments, Florida is not the only state that has similar discretionary takes laws. The fact that after 5 years of this thread and continued posts, questions, Reponses, etc. to the same issue that no one with Intuit can provide a solution is just infuriating. Small businesses around this county rely on Intuit QuickBooks to make sure these items are taken care of smoothly and without issue. Clearly Intuit cares very little for it's users and how somethings "as small as this" impacts their businesses in a BIG way.
So, once again, I ask does Intuit QuickBooks have a viable solution for ALL QuickBooks users (desktop and online)????
Hello there, HMCarley.
I can see how this option would be helpful for you and your business. Therefore, let me take note of this as a suggestion to improve your QuickBooks experience. In the meantime, the workaround provided in the thread can help you with discretionary sales tax by county in Florida.
Also, I'd recommend sending feedback directly to our product developer team. Your feedback is valuable in shaping the direction of QuickBooks and adding features that best meet the needs of our users.
To send feedback using QuickBooks Desktop, follow the steps below:
For QuickBooks Online, click here to submit your suggestions: How do I submit feedback? You may open this article to track feature requests through the QuickBooks Online Feature Requests website.
I'll also share these resources that will guide you in managing your sales taxes in QuickBooks Desktop and Online:
I'm always here to back you up if you have further concerns about adding taxes in QuickBooks. Feel free to hit the Reply button.
Quickbooks isn't going to fix this, they haven't for years. I posted the workaround that works and you can customize it for any state discretionary tax issue.
The reason you're using Quickbooks and not a system like NetSuite or a bigger more robust ERP is most likely cost and ease of use, ie QB is thousands of dollars cheaper. You have to understand that this lighter version of software has it's limitations.
Look at what I posted, it works and you can whitebox it and try it for yourself on a few invoices.
It's pretty simple to see how invoices over a certain $ threshold should be treated differently.
I SOLVED THIS
I'm using QB Desktop but was just able to solve this and confirmed it is working by viewing the transaction journal.
Go to Lists
Look for tax and search.
Click Item (New) or CTRL+N
Select this item as a Sales Tax Item
Name Surtax Cap
An example of my description "Florida discretionary sales tax surcharge cap for invoices over $5,000"
For rate leave 0%
And set the same state tax agency you pay you (in my case FL DOR)
Do not add this new item to your sales tax group rather use it as an item.
Also make sure you have the state 6% sales tax rate already created.
Create a new invoice
Set sales tax to 6%
Enter your items totaling over $5000
Add your new Surtax Cap item and tab over to the amount column and enter $50
At this point you'll get a warning but just press okay you can ignore that warning.
After saving your invoice you can view the Transaction Journal and confirm that the invoice posted correctly.
For my example I used a $7000 invoice to coincide with the FLDOR surtax example here: https://floridarevenue.com/Forms_library/current/gt800019.pdf
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here