Tax calculation
-
Hello,
I am looking at 2021 taxes, the taxes under revenue tab shows as $3740 and under Taxes tab shows as $4373. Why would the 2 number not match?
Also under the revenue tax i can see a message that states “full refunds are not deducted from tax or net sales totals” what does this mean? this is a hoover over message under revenue and then taxes
This is on latest version of woocomerce and latest version of wordpress
-
This topic was modified 4 years ago by
thisisnuts.
-
This topic was modified 4 years ago by
Viewing 6 replies - 1 through 6 (of 6 total)
-
Hi @thisisnuts
I understand that a different figure is showing for the taxes in the Revenue tab that the one on the Taxes tab.
As a first step please go to: WooCommerce ➔ Status ➔ Tools ➔ Clear analytics cache.
Once cleared, you can re-import the data from the bottom of the page at Analytics ➔ Settings, and check again.If that doesn’t help either then can you please let us know if you are using a plugin for tax calculation such as the WooCommerce Shipping and Tax?
In order for us to get a better idea of your setup, please share a copy of your site’s System Status. You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.
I have done as you mentioned above and the numbers did not change.
to give you additional information. I have exported the data manually via data export plugin and then calcualted the taxes manually what I have seen is the following:total tax collected in USD 1210.9
total tax collected in CAD 3183.66
which totals $4,393 (this number is very close to the number from the reports TAX section $4373)However, this does not make any sense becuase tax should not mix the two currencies it should show in USD or CAD ( I would assume it should show in the default currency of the shop whcih in our case is USD)
### WordPress Environment ### WC Version: 6.5.1 REST API Version: ✔ 6.5.1 WC Blocks Version: ✔ 7.4.3 Action Scheduler Version: ✔ 3.4.0 Log Directory Writable: ✔ WP Version: 5.9.3 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: ✔ Language: en_US External object cache: – ### Server Environment ### Server Info: Apache/2.4.41 (Ubuntu) PHP Version: 7.4.3 PHP Post Max Size: 8 MB PHP Time Limit: 30 PHP Max Input Vars: 1000 cURL Version: 7.68.0 OpenSSL/1.1.1f SUHOSIN Installed: – MySQL Version: 8.0.22-0ubuntu0.20.04.2 Max Upload Size: 2 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ❌ Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected. DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 6.5.1 WC Database Prefix: wp_ Total Database Size: 236.10MB Database Data Size: 199.29MB Database Index Size: 36.81MB wp_woocommerce_sessions: Data: 123.73MB + Index: 4.98MB + Engine MyISAM wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_order_items: Data: 1.75MB + Index: 0.77MB + Engine MyISAM wp_woocommerce_order_itemmeta: Data: 14.84MB + Index: 8.34MB + Engine MyISAM wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_payment_tokens: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wp_woocommerce_payment_tokenmeta: Data: 0.03MB + Index: 0.03MB + Engine MyISAM wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_actionscheduler_actions: Data: 0.54MB + Index: 0.29MB + Engine MyISAM wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_actionscheduler_logs: Data: 0.44MB + Index: 0.28MB + Engine MyISAM wp_aepc_custom_audiences: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aepc_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cartflows_ca_cart_abandonment: Data: 8.55MB + Index: 0.14MB + Engine InnoDB wp_cartflows_ca_email_history: Data: 0.34MB + Index: 0.44MB + Engine InnoDB wp_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_commentmeta: Data: 0.24MB + Index: 0.21MB + Engine MyISAM wp_comments: Data: 5.51MB + Index: 1.92MB + Engine MyISAM wp_failed_jobs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB wp_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_glsr_assigned_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_glsr_assigned_terms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_glsr_assigned_users: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_glsr_ratings: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailchimp_carts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_omnisend_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_options: Data: 3.51MB + Index: 0.21MB + Engine MyISAM wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_postmeta: Data: 24.63MB + Index: 11.40MB + Engine MyISAM wp_posts: Data: 3.67MB + Index: 1.00MB + Engine MyISAM wp_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_realmedialibrary: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_realmedialibrary_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_realmedialibrary_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_realmedialibrary_tmp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_sbi_feed_caches: Data: 0.05MB + Index: 0.02MB + Engine InnoDB wp_sbi_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_sbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_sbi_instagram_posts: Data: 0.11MB + Index: 0.00MB + Engine InnoDB wp_sbi_sources: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_sib_model_contact: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_sib_model_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_sib_model_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_social_users: Data: 0.01MB + Index: 0.02MB + Engine MyISAM wp_term_relationships: Data: 0.12MB + Index: 0.25MB + Engine MyISAM wp_term_taxonomy: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wp_termmeta: Data: 0.03MB + Index: 0.03MB + Engine MyISAM wp_terms: Data: 0.00MB + Index: 0.02MB + Engine MyISAM wp_tm_taskmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_usermeta: Data: 4.07MB + Index: 1.67MB + Engine MyISAM wp_users: Data: 0.19MB + Index: 0.16MB + Engine MyISAM wp_wc_admin_note_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_admin_notes: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_customer_lookup: Data: 0.32MB + Index: 0.28MB + Engine MyISAM wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.04MB + Engine MyISAM wp_wc_order_product_lookup: Data: 1.92MB + Index: 1.55MB + Engine MyISAM wp_wc_order_stats: Data: 0.28MB + Index: 0.19MB + Engine MyISAM wp_wc_order_tax_lookup: Data: 0.04MB + Index: 0.05MB + Engine MyISAM wp_wc_product_attributes_lookup: Data: 0.14MB + Index: 0.13MB + Engine InnoDB wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 0.10MB + Index: 0.12MB + Engine MyISAM wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_reserved_stock: Data: 0.02MB + Index: 0.02MB + Engine MyISAM wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wdr_order_discounts: Data: 0.20MB + Index: 0.00MB + Engine InnoDB wp_wdr_order_item_discounts: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wt_iew_action_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wt_iew_cron: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wt_iew_ftp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_yith_wcwl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_yith_wcwl_lists: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_yoast_indexable: Data: 2.52MB + Index: 1.28MB + Engine InnoDB wp_yoast_indexable_hierarchy: Data: 0.13MB + Index: 0.16MB + Engine InnoDB wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_yoast_primary_term: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_yoast_seo_links: Data: 0.09MB + Index: 0.03MB + Engine InnoDB ### Post Type Counts ### acf-field: 7 acf-field-group: 2 attachment: 3522 blocks: 16 featured_item: 8 nav_menu_item: 112 oembed_cache: 10 page: 25 post: 15 product: 1078 product_variation: 150 revision: 725 shop_coupon: 19 shop_order: 3804 shop_order_refund: 117 sidebar: 1 site-review: 73 wp_global_styles: 1 wpcf7_contact_form: 3 yith-wcbm-badge: 1 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (28) ### Automizely Popup - Email Pop Up, Sales Pop Up, Exit Intent Pop Up, Upsell Pop Up, Cart Abandonment Pop Up: by Automizely Marketing – 1.0.15 Cloudflare: by Cloudflare Inc. – 4.9.1 Contact Form 7: by Takayuki Miyoshi – 5.5.6 Customer Reviews for WooCommerce: by CusRev – 4.38 Duplicate Page: by mndpsingh287 – 4.4.8 Facebook for WooCommerce: by Facebook – 2.6.13 Google Listings and Ads: by WooCommerce – 1.12.8 Smash Balloon Instagram Feed: by Smash Balloon – 6.0.5 HubSpot All-In-One Marketing - Forms, Popups, Live Chat: by HubSpot – 8.11.94 Newsletter, SMTP, Email marketing and Subscribe forms by Sendinblue: by Sendinblue – 3.1.41 Flying Images by WP Speed Matters: by Gijo Varghese – 2.4.13 Nextend Social Login: by Nextendweb – 3.1.4 PixelYourSite PRO: by PixelYourSite – 9.0.0 Redirection: by John Godley – 5.2.3 Site Reviews: by Paul Ryley – 5.23.6 Woocommerce autocomplete checkout address: by Acespritech Solutions Pvt. Ltd. – 1.1.0 WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.2.15 Woo Discount Rules PRO 2.0: by Flycart – 2.4.0 Woo Discount Rules: by Flycart – 2.4.0 WOOCS - WooCommerce Currency Switcher: by realmag777 – 1.3.7.5 WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.3 WooCommerce Stripe Gateway: by WooCommerce – 6.3.0 WooCommerce Shipping & Tax: by WooCommerce – 1.25.28 WooCommerce - ShipStation Integration: by WooCommerce – 4.1.42 (update to version 4.1.48 is available) WooCommerce: by Automattic – 6.5.1 WooSidebars: by WooCommerce – 1.4.6 Yoast SEO: by Team Yoast – 18.8 Asset CleanUp: Page Speed Booster: by Gabe Livan – 1.3.8.5 ### Inactive Plugins (13) ### Advanced Custom Fields PRO: by Elliot Condon – 5.6.10 Async JavaScript: by Frank Goossens (futtta) – 2.21.08.31 Classic Editor: by WordPress Contributors – 1.6.2 PHP Console Log: by Marcus Viar – 1.0.1 PixelYourSite Pinterest: by PixelYourSite – 3.2.3 Product Import Export for WooCommerce: by WebToffee – 2.2.0 PW WooCommerce Bulk Edit: by Pimwick LLC – 2.97 W3 Total Cache: by BoldGrid – 2.2.1 WooCommerce Admin: by WooCommerce – 3.3.2 WooCommerce PayPal Payments: by WooCommerce – 1.8.0 WordPress Users & WooCommerce Customers Import Export(BASIC): by WebToffee – 2.2.9 WP-Optimize - Clean, Compress, Cache: by David Anderson Ruhani Rabin Team Updraft – 3.2.3 YITH WooCommerce Wishlist: by YITH – 3.8.0 ### 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: – Enforce Approved Product Download Directories: – ### WC Pages ### Shop base: #62 - /shop Cart: #61 - /cart Checkout: #60 - /checkout My account: #59 - /my-account Terms and conditions: ❌ Page not set ### Theme ### Name: Flatsome Child Version: 5.30 Author URL: Child Theme: ✔ Parent Theme Name: Flatsome Parent Theme Version: 3.15.3 Parent Theme Author URL: http://www.uxthemes.com/ WooCommerce Support: ✔ ### Templates ### Overrides: flatsome/woocommerce/archive-product.php flatsome/woocommerce/cart/cart-empty.php flatsome/woocommerce/cart/cart-shipping.php flatsome-child/woocommerce/cart/cart.php version 3.5.0 is out of date. The core version is 3.8.0 flatsome-child/woocommerce/cart/mini-cart.php version 3.5.0 is out of date. The core version is 5.2.0 flatsome-child/woocommerce/checkout/form-checkout.php flatsome/woocommerce/checkout/form-coupon.php flatsome-child/woocommerce/checkout/review-order.php version 3.8.0 is out of date. The core version is 5.2.0 flatsome/woocommerce/checkout/terms.php flatsome/woocommerce/checkout/thankyou.php flatsome/woocommerce/content-product-cat.php flatsome-child/woocommerce/content-product.php flatsome/woocommerce/content-single-product.php flatsome/woocommerce/content-widget-product.php flatsome/woocommerce/global/breadcrumb.php flatsome/woocommerce/global/quantity-input.php flatsome/woocommerce/global/wrapper-end.php flatsome/woocommerce/global/wrapper-start.php flatsome/woocommerce/loop/loop-end.php flatsome/woocommerce/loop/loop-start.php flatsome/woocommerce/loop/pagination.php flatsome/woocommerce/loop/result-count.php flatsome/woocommerce/loop/sale-flash.php flatsome/woocommerce/myaccount/form-login.php flatsome/woocommerce/myaccount/navigation.php flatsome/woocommerce/notices/error.php flatsome/woocommerce/notices/notice.php flatsome/woocommerce/notices/success.php flatsome/woocommerce/product-searchform.php flatsome/woocommerce/single-product/photoswipe.php flatsome/woocommerce/single-product/price.php flatsome/woocommerce/single-product/product-image.php flatsome/woocommerce/single-product/product-thumbnails.php flatsome/woocommerce/single-product/rating.php flatsome/woocommerce/single-product/related.php flatsome/woocommerce/single-product/review.php flatsome/woocommerce/single-product/sale-flash.php flatsome/woocommerce/single-product/share.php flatsome-child/woocommerce/single-product/short-description.php flatsome/woocommerce/single-product/tabs/tabs.php flatsome/woocommerce/single-product/title.php flatsome/woocommerce/single-product/up-sells.php flatsome/woocommerce/single-product-reviews.php flatsome/woocommerce/single-product.php flatsome/woocommerce/content-product_cat.php Outdated Templates: ❌ Learn how to update ### Action Scheduler ### Complete: 1,309 Oldest: 2022-05-09 10:15:25 -0400 Newest: 2022-05-16 10:12:40 -0400 Failed: 16 Oldest: 2022-01-31 12:14:27 -0500 Newest: 2022-03-21 10:40:42 -0400 Pending: 2 Oldest: 2022-05-16 14:56:22 -0400 Newest: 2022-05-16 23:00:00 -0400 ### Status report information ### Generated at: 2022-05-16 10:14:02 -04:00Hi @thisisnuts
Thanks for providing the additional information.
I see that you have the WooCommerce Shipping & Tax: by WooCommerce – 1.25.28 extension. Please reach us on the WooCommerce Shipping & Tax forum at https://ww.wp.xz.cn/support/plugin/woocommerce-services/ where our plugin’s team can assist you.
Feel free to include a link to this forum topic, so we can use this topic as a reference.
Thanks
Thank you!
You’re welcome!
Hoping for a quick resolution. Do let us know if we can be of further assistance here.
* This particular forum is for questions that are related to the WooCommerce core features.
As further assistance is to be provided by the plugin’s team, I’ll go ahead and mark this thread as resolved.
Feel free to create a new topic if you have other questions related to core WooCommerce.
Viewing 6 replies - 1 through 6 (of 6 total)
The topic ‘Tax calculation’ is closed to new replies.
