automatic tax rates are undercalculating rates

  • Resolved timbertac

    (@timbertac)


    3 years, 8 months ago

    Okay so my taxes are now working when I made a new page with your default checkout block. However, the tax rates are super low.

    I get $1.03 in tax for Colorado Springs on a $19.99 product (5.15%) and $0.74 (3.7%) for Fort Collings. $0.80 (4%) for Denver. Definitely strange.

    Denver is supposed to be over 8% yet keeps defaulting to 4%.
    What am I doing wrong?

    ***be aware that the link for my page is a test page, the checkout isn’t set to that page as default as I’m deubging. However, this page does work. You’ll have to click the shop and add some items and go back to https://timber-tactics.com/testinggg/ so you can see for yourself.

    Status report:

    
### WordPress Environment ###

WordPress address (URL): https://timber-tactics.com
Site address (URL): https://timber-tactics.com
WC Version: 5.1.0
REST API Version: ? 5.1.0
WC Blocks Version: ? 4.6.0
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 2.0.2
Log Directory Writable: ?
WP Version: 5.7
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.16
PHP Post Max Size: 1 GB
PHP Time Limit: 3000
PHP Max Input Vars: 3000
cURL Version: 7.75.0
OpenSSL/1.1.1j

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

### Database ###

WC Database Version: 5.1.0
WC Database Prefix: wpfl_
Total Database Size: 27.53MB
Database Data Size: 24.75MB
Database Index Size: 2.78MB
wpfl_woocommerce_sessions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wpfl_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpfl_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpfl_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpfl_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpfl_woocommerce_order_itemmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wpfl_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpfl_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpfl_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpfl_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpfl_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpfl_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpfl_actionscheduler_actions: Data: 0.08MB + Index: 0.11MB + Engine InnoDB
wpfl_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpfl_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpfl_actionscheduler_logs: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wpfl_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpfl_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wpfl_layerslider: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_layerslider_revisions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpfl_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_mailerlite_checkouts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_mw_wc_qbo_sync_customer_pairs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_mw_wc_qbo_sync_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_mw_wc_qbo_sync_paymentmethod_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_mw_wc_qbo_sync_payment_id_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_mw_wc_qbo_sync_product_pairs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_mw_wc_qbo_sync_qbo_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_mw_wc_qbo_sync_qbo_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_mw_wc_qbo_sync_real_time_sync_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_mw_wc_qbo_sync_real_time_sync_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_mw_wc_qbo_sync_shipping_product_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_mw_wc_qbo_sync_tax_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_mw_wc_qbo_sync_variation_pairs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpfl_mw_wc_qbo_sync_wq_cf_map: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpfl_options: Data: 7.02MB + Index: 0.14MB + Engine InnoDB
wpfl_postmeta: Data: 1.33MB + Index: 0.50MB + Engine InnoDB
wpfl_posts: Data: 3.36MB + Index: 0.09MB + Engine InnoDB
wpfl_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wpfl_revslider_css_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_revslider_slides: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wpfl_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpfl_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpfl_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpfl_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpfl_usermeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wpfl_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpfl_wcmp_cust_answers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpfl_wcmp_cust_questions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_wcmp_products_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_wcmp_shipping_zone_locations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_wcmp_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_wcmp_vendor_ledger: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_wcmp_vendor_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpfl_wcmp_visitors_stats: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wpfl_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpfl_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpfl_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpfl_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpfl_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpfl_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpfl_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpfl_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wpfl_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpfl_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpfl_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpfl_wfconfig: Data: 1.28MB + Index: 0.00MB + Engine InnoDB
wpfl_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_wffilemods: Data: 6.52MB + Index: 0.00MB + Engine InnoDB
wpfl_wfhits: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpfl_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpfl_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpfl_wfknownfilelist: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wpfl_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpfl_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_wflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpfl_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpfl_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpfl_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpfl_wfstatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
wpfl_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_woo_shippment_provider: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wpfl_wpvivid_scan_result: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_wpvivid_unused_uploads_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpfl_yoast_indexable: Data: 0.14MB + Index: 0.08MB + Engine InnoDB
wpfl_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpfl_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpfl_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpfl_yoast_seo_links: Data: 0.06MB + Index: 0.03MB + Engine InnoDB

### Post Type Counts ###

attachment: 56
custom_css: 1
customize_changeset: 1
elementor_library: 1
mc4wp-form: 1
nav_menu_item: 18
oembed_cache: 1
page: 22
post: 6
product: 37
product_variation: 35
revision: 267
shop_coupon: 2
shop_order: 13
shop_order_refund: 3
testimonials: 2
wpcf7_contact_form: 5

### Security ###

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

### Active Plugins (26) ###

Advanced Flat Rate Shipping For WooCommerce: by theDotstore – 3.9.4
LayerSlider WP: by Kreatura Media – 6.11.6
Bluehost: by Bluehost – 2.5.5
Contact Form 7: by Takayuki Miyoshi – 5.4
Customer Email Verification for WooCommerce: by zorem – 1.3.5
Jetpack by WordPress.com: by Automattic – 9.5
WPBakery Page Builder: by Michael M - WPBakery.com – 6.6.0
Limit Login Attempts Reloaded: by Limit Login Attempts Reloaded – 2.20.3
Mailchimp for WooCommerce: by Mailchimp – 2.5.0
MC4WP: Mailchimp for WordPress: by ibericode – 4.8.3
WooCommerce Sync for QuickBooks Online - by MyWorks Software: by MyWorks Software – 2.2.0
Really Simple SSL: by Really Simple Plugins – 4.0.11
Slider Revolution: by ThemePunch – 6.3.5
Safe SVG: by Daryll Doyle – 1.9.9
The Events Calendar: by The Events Calendar – 5.4.0.2
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.16.49

Advanced Shipment Tracking for WooCommerce: by zorem – 3.2.2
WooCommerce Cost of Shipping: by TheRiteSites – 1.4.0
WooCommerce Blocks: by Automattic – 4.6.0
WooCommerce - MailerLite: by MailerLite – 1.4.10
WooCommerce Stripe Gateway: by WooCommerce – 4.9.0
WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 2.8.2
WooCommerce Shipping & Tax: by Automattic – 1.25.8
WooCommerce: by Automattic – 5.1.0
Wordfence Security: by Wordfence – 7.4.14
Yoast SEO: by Team Yoast – 15.9.2

### Inactive Plugins (2) ###

Kadence WooCommerce Email Designer: by Kadence WP – 1.4.7
Redux: by Redux.io + Dovy Paukstys – 4.1.24

### Must Use Plugins (2) ###

Endurance Page Cache: by Mike Hansen – 2.0.5
SSO: by Garth Mortensen
Mike Hansen – 0.3

### 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)

Connected to WooCommerce.com: –

### WC Pages ###

Shop base: #919 - /shop-template/
Cart: #182 - /cart/
Checkout: #700 - /checkout/
My account: #192 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Creativo Theme
Version: 7.5.4
Author URL: https://rockythemes.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: creativo/woocommerce/archive-product.php
creativo/woocommerce/cart/cart-empty.php
creativo/woocommerce/cart/cart-shipping.php
creativo/woocommerce/cart/cart-totals.php
creativo/woocommerce/cart/cart.php
creativo/woocommerce/checkout/cart-errors.php
creativo/woocommerce/checkout/form-coupon.php
creativo/woocommerce/checkout/form-pay.php
creativo/woocommerce/content-product.php
creativo/woocommerce/global/breadcrumb.php
creativo/woocommerce/myaccount/form-edit-account.php
creativo/woocommerce/myaccount/form-edit-address.php
creativo/woocommerce/myaccount/form-login.php
creativo/woocommerce/myaccount/form-lost-password.php
creativo/woocommerce/myaccount/my-address.php
creativo/woocommerce/myaccount/my-downloads.php
creativo/woocommerce/myaccount/my-orders.php
creativo/woocommerce/notices/error.php
creativo/woocommerce/notices/notice.php
creativo/woocommerce/notices/success.php
creativo/woocommerce/single-product/add-to-cart/grouped.php
creativo/woocommerce/single-product/meta.php
creativo/woocommerce/single-product/product-image.php
creativo/woocommerce/single-product/rating.php
creativo/woocommerce/single-product/related.php
creativo/woocommerce/single-product/review.php
creativo/woocommerce/single-product/sale-flash.php
creativo/woocommerce/single-product/short-description.php
creativo/woocommerce/single-product/tabs/additional-information.php
creativo/woocommerce/single-product/tabs/description.php
creativo/woocommerce/single-product/tabs/tabs.php
creativo/woocommerce/single-product.php

### Action Scheduler ###

Complete: 136
Oldest: 2021-02-11 01:48:34 +0000
Newest: 2021-03-13 01:24:05 +0000

Pending: 1
Oldest: 2021-03-14 00:16:49 +0000
Newest: 2021-03-14 00:16:49 +0000

### Status report information ###

Generated at: 2021-03-13 10:06:55 +00:00

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)

  • Hi, @timbertac!

    I get $1.03 in tax for Colorado Springs on a $19.99 product (5.15%) and $0.74 (3.7%) for Fort Collings. $0.80 (4%) for Denver. Definitely strange.

    I’ve tested your settings on my site, and I get similar results with a Fort Collins, CO 80524 address in my store’s General settings and a USD 19.99 product. The thing I noticed though was that, when I used the same zip code 80524 at checkout, I had a tax rate of USD 1.51 (7.55%). Using 80525, however, gave me USD 0.74 (3.7%).

    It turns out that collecting Sales Tax in Colorado is a little different from other states. In brief, with your tax nexus in Colorado, you only collect the full combined sales tax rate (e.g., CO 2.9% + Larimer 0.8% + Fort Collins 3.85% = 7.55%) for sales in the same district.

    For sales to customers outside your district, you only collect “retailer’s use tax,” which is CO 2.9% + any local district taxes (e.g., 0.8%).

    This matches what I saw in my testing with a CO 80524 store. Sales to 80524 were charged the full 7.55%, but sales to 80525 were only charged 3.7% (C0 2.9% + Larimer 0.8%).

    If you’re interested in reading more about this, I would recommend the following:
    https://www.taxjar.com/states/colorado-sales-tax-online/#how-to-collect-sales-tax-in-colorado

    I hope that helps clear things up!

Viewing 1 replies (of 1 total)
  • The topic ‘automatic tax rates are undercalculating rates’ is closed to new replies.