Automated Tax Calculations Incorrect

Hey @ageekonabike!

Thanks for passing along that info.

We are aware of this bug and a fix for this is currently in the works. It should be included in the next Services update, which we hope to be releasing soon. We apologize for the inconvenience.

In the meantime, you can use manual rates to ensure you collect the correct amount in taxes.

Cheers,

Still seeing some discrepancies with Colorado (CO) tax rates, has a fix for this issue be released?

Still a problem in Colorado – calculating tax at 4% for area with 7.9%. How do we set taxes manually? If an order has been placed, the customer has already been charged and paid for an incorrect tax. We cannot go back and ask them to pay more because our system has an error.

Thanks!

I don’t see a taxes option in Woocommerce services. I set up taxes in Settings to do automatic calculations with buyer’s billing address.

The product is Hemp Oil Plus, 5 oz, $50, shipping to Arvada, CO 80003. The tax calculated was $2, or 4%. There was no shipping fee with this order.

This is a problem, since it’s costing us revenue. Thanks for the help!

### WordPress Environment ###

Home URL: https://www.vbfarms.com
Site URL: https://www.vbfarms.com
WC Version: 3.5.3
Log Directory Writable: ?
WP Version: ? 4.9.9 - There is a newer version of WordPress available (5.0.2)
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.0.33 - We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
PHP Post Max Size: 64 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.62.0
OpenSSL/1.0.2q

SUHOSIN Installed: –
MySQL Version: 5.6.41-84.1
Max Upload Size: 64 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.5.3
WC Database Prefix: wpg8_
MaxMind GeoIP Database: ?
Total Database Size: 10.02MB
Database Data Size: 9.19MB
Database Index Size: 0.83MB
wpg8_woocommerce_sessions: Data: 5.48MB + Index: 0.30MB
wpg8_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB
wpg8_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB
wpg8_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB
wpg8_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB
wpg8_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.01MB
wpg8_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB
wpg8_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB
wpg8_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB
wpg8_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB
wpg8_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB
wpg8_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB
wpg8_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB
wpg8_woocommerce_log: Data: 0.00MB + Index: 0.00MB
wpg8_commentmeta: Data: 0.00MB + Index: 0.00MB
wpg8_comments: Data: 0.00MB + Index: 0.01MB
wpg8_failed_jobs: Data: 0.00MB + Index: 0.00MB
wpg8_image_hover_ultimate_list: Data: 0.00MB + Index: 0.00MB
wpg8_image_hover_ultimate_style: Data: 0.00MB + Index: 0.00MB
wpg8_links: Data: 0.00MB + Index: 0.00MB
wpg8_loginizer_logs: Data: 0.00MB + Index: 0.01MB
wpg8_mailchimp_carts: Data: 0.00MB + Index: 0.00MB
wpg8_my_calendar: Data: 0.01MB + Index: 0.01MB
wpg8_my_calendar_categories: Data: 0.00MB + Index: 0.00MB
wpg8_my_calendar_category_relationships: Data: 0.00MB + Index: 0.00MB
wpg8_my_calendar_events: Data: 0.00MB + Index: 0.00MB
wpg8_my_calendar_locations: Data: 0.00MB + Index: 0.00MB
wpg8_nf3_actions: Data: 0.00MB + Index: 0.00MB
wpg8_nf3_action_meta: Data: 0.01MB + Index: 0.00MB
wpg8_nf3_chunks: Data: 0.00MB + Index: 0.00MB
wpg8_nf3_fields: Data: 0.00MB + Index: 0.00MB
wpg8_nf3_field_meta: Data: 0.15MB + Index: 0.01MB
wpg8_nf3_forms: Data: 0.00MB + Index: 0.00MB
wpg8_nf3_form_meta: Data: 0.01MB + Index: 0.00MB
wpg8_nf3_objects: Data: 0.00MB + Index: 0.00MB
wpg8_nf3_object_meta: Data: 0.00MB + Index: 0.00MB
wpg8_nf3_relationships: Data: 0.00MB + Index: 0.00MB
wpg8_nf3_upgrades: Data: 0.17MB + Index: 0.00MB
wpg8_ngg_album: Data: 0.00MB + Index: 0.00MB
wpg8_ngg_gallery: Data: 0.00MB + Index: 0.00MB
wpg8_ngg_pictures: Data: 0.00MB + Index: 0.00MB
wpg8_options: Data: 1.03MB + Index: 0.10MB
wpg8_postmeta: Data: 0.54MB + Index: 0.21MB
wpg8_posts: Data: 1.57MB + Index: 0.09MB
wpg8_queue: Data: 0.00MB + Index: 0.00MB
wpg8_termmeta: Data: 0.00MB + Index: 0.01MB
wpg8_terms: Data: 0.00MB + Index: 0.01MB
wpg8_term_relationships: Data: 0.00MB + Index: 0.01MB
wpg8_term_taxonomy: Data: 0.00MB + Index: 0.00MB
wpg8_usermeta: Data: 0.19MB + Index: 0.02MB
wpg8_users: Data: 0.00MB + Index: 0.01MB
wpg8_wc_download_log: Data: 0.00MB + Index: 0.00MB
wpg8_wc_webhooks: Data: 0.00MB + Index: 0.00MB
wpg8_yoast_seo_links: Data: 0.01MB + Index: 0.01MB
wpg8_yoast_seo_meta: Data: 0.00MB + Index: 0.00MB

### Post Type Counts ###

attachment: 100
custom_css: 1
customize_changeset: 7
ec_store: 1
ecwd_calendar: 1
ecwd_event: 1
jetpack_migration: 2
jp_img_sitemap: 3
jp_sitemap: 3
jp_sitemap_master: 3
mc-events: 75
mc4wp-form: 1
nav_menu_item: 30
nf_sub: 10
page: 43
post: 2
product: 13
product_variation: 37
revision: 434
shop_coupon: 8
shop_order: 11
shop_order_refund: 1
tablepress_table: 2
tribe_events: 4
tribe_organizer: 1
tribe_venue: 3

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (28) ###

Akismet Anti-Spam: by Automattic – 4.1
Jetpack by WordPress.com: by Automattic – 6.8.1
Mailchimp for WooCommerce: by Mailchimp – 2.1.11 – Not tested with the active version of WooCommerce
My Calendar: by Joseph C Dolson – 3.1.2
Ninja Forms: by The WP Ninjas – 3.3.20
Really Simple SSL: by Rogier Lankhorst
Mark Wolters – 3.1.3

Remove Query Strings From Static Resources: by Speed Up My Website – 1.4
Storefront Blog Customiser: by WooCommerce – 1.2.5
Storefront Footer Bar: by WooThemes – 1.0.4
Storefront Hamburger Menu: by WooCommerce – 1.2.2
Storefront Homepage Contact Section: by WooThemes – 1.0.5
Storefront Mega Menus: by WooCommerce – 1.6.2 – Not tested with the active version of WooCommerce
Storefront Parallax Hero: by WooCommerce – 1.5.7
Storefront Powerpack: by WooCommerce – 1.4.13
Storefront Pricing Tables: by WooCommerce – 1.1.0
Storefront Product Hero: by WooThemes – 1.2.13
Storefront Product Pagination: by WooThemes – 1.2.4 – Not tested with the active version of WooCommerce
Storefront Product Sharing: by WooCommerce – 1.0.6
Storefront Reviews: by WooCommerce – 1.0.4 – Not tested with the active version of WooCommerce
Storefront Sticky Add to Cart: by WooThemes – 1.1.9
Title Remover: by WPGurus – 1.2
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.16.0

WooCommerce PayPal Checkout Gateway: by WooCommerce – 1.6.5
WooCommerce Services: by Automattic – 1.18.0
WooCommerce Square: by WooCommerce – 1.0.34
WooCommerce: by Automattic – 3.5.3
Yoast SEO: by Team Yoast – 9.3
SEOPress: by Benjamin Denis – 3.2.6

### Settings ###

API Enabled: –
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

### WC Pages ###

Shop base: #939 - /shop/
Cart: #940 - /cart/
Checkout: #941 - /checkout/
My account: #942 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Storefront
Version: 2.4.2
Author URL: https://woocommerce.com/
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ?

### Templates ###

Overrides: –

I have replied to all your emails requesting information and trying different approaches, but none of them have solved the problem.

This seems to be a bug in WooCommerce resulting in incorrect sales tax calculations in Colorado. This is costing us money on every transaction, so could you please help us resolve this?

Thanks you!

@shaunkuschel

Can you please let us know when the Colorado tax issue will be resolved? I’m trying to launch my store, but given that most of our transactions will be in Colorado, I want to ensure the tax is correct.

My test sales are showing a 4.0% tax for Denver through Woocommerce automated tax. The 2019 combined sales tax rate for Denver, CO is 8.31%. That’s a big discrepancy.

Please help and thanks.

• This reply was modified 5 years, 10 months ago by beckyrisch.

Hey everyone (@beckyrisch, @patvanb6, @hluoma, @ageekonabike)! Sorry for the delay getting back to you all with an update about this issue.

There was a fix released for the discrepancies, but it looks like there may still be an issue with a few locations.

Using Denver as an example, it looks like the correct State and District taxes are being added, but the City tax isn’t.

There is some great info about what taxes need to be collected in CO the link below, as well as a link to a very handy tax rate collection calculator, which I definitely recommend checking out.

https://www.taxjar.com/states/colorado-sales-tax-online/#how-to-register-for-a-sales-tax-permit-in-colorado

Denver’s City tax rate of 4.310% wasn’t being added in the automated rates for the Denver address I was testing but the the 2.9% State tax and 1.1% District tax were correctly added.

While we work on a fix for this, I would suggest manually adding the City tax rate to the tables you use (WooCommerce > Settings > Tax > Standard rates) and change the priority of that rate to something different than what the State tax priority is (the default priority of the State tax is “1”, so you can set the City tax rate priority to “2”, for example), that way those rates will combine to equal the correct 8.310%.

Also, be sure to test this workaround using a real address, to make sure the automated rates are returned correctly.

Give this a try and let me know if you see any other issues.

Thanks!

CC: @beckyrisch (since the tag above doesn’t seem to have worked)

This has been marked as resolved but based on Shaun Kuschel’s response, and my own testing, it is an ongoing issue. May I ask when is this going to be truly resolved and fixed?

Hey @npuana!

This thread was marked as resolved a while back (perhaps when part of the issue was resolved?), but it does look like there are still some issues going on, so we’re still working on this. Normally, we would have asked for a new thread to be created since the ‘Resolved’ status makes this pretty confusing (and it’s an old thread), but the developers are aware and working on a resolution currently.

I’ll be sure to watch this thread, keep you all updated, and let you know when this is actually resolved.

Uggh, I have many clients using these automated tax rates and we have just realized they are incorrect. Only state and county rates are being added, no city rates. I am going to have to revert to manual rates. Colorado users BEWARE

Hey @czeller,

The cause of the issue with Colorado has been identified and a fix is being worked on, but in the meantime, you can either switch to manual rates (disabling automated taxes) or just add the city tax rate you need to the appropriate tax table(s) with a different priority than the State tax. For example, this is what I did on my test site for Denver while awaiting the update:

https://cld.wthms.co/y8XC7B

The State tax row was added automatically by Services and has a priority of 1, so I manually added Denver’s city tax of 4.31% (which I believe is the correct City rate for Denver, but recommend that everyone confirm the rates that they should legally be charging) with a priority of 2, to ensure they are combined when customers match both the Denver and Colorado rows.

• This reply was modified 5 years, 9 months ago by Shaun Kuschel a11n.

Hi Sean,

Do I only need to collect sales tax for my online store in Colorado, which is where we have a tiny physical store?

Or do I need to also collect sales tax from any town in the country that orders from us (and products shipped there)?

I ask, because I don’t want to turn off Automated Taxes, especially if I need to collect tax from other states. But at the same time, I need to get the local taxes in working order, using your suggestion for hand coding Standard rates.

Also, though that suggestion works in a pinch, it’s a lot to ask us to do a line item tax rate for more than 100 towns in Colorado.

Thanks!

• This reply was modified 5 years, 8 months ago by beckyrisch.

Hello Shaun,
Has there been any progress here? This has been very difficult to comply with Colorado sales tax laws.

Thank you

To everyone on this thread…

I created this csv file with 62 Colorado cities and their tax rate in the proper woocommerce format that you can use on your store. There’s an easy way to upload it and it works. Be sure to turn off Automated though.

https://drive.google.com/file/d/1bwcskLgxmwv0EeMAJeoaRvRrUzLyo8-L/view?usp=sharing

It would need to be manually updated if there are any tax changes, and it doesn’t cover every town. But if anyone wants to add more, then it can be a working document.

It doesn’t mean Woo shouldn’t really, truly fix the Colorado tax situation, but it is a workaround in the meantime.

I don’t really understand what the hold up is, @shaunkuschel (this thread started 7 months ago!). Can you enlighten us?