• Resolved thisisnuts

    (@thisisnuts)


    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.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Margaret S. woo-hc

    (@margaretwporg)

    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.

    Thread Starter thisisnuts

    (@thisisnuts)

    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:00
    
    Margaret S. woo-hc

    (@margaretwporg)

    Hi @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

    Thread Starter thisisnuts

    (@thisisnuts)

    Thank you!

    Margaret S. woo-hc

    (@margaretwporg)

    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.

    Margaret S. woo-hc

    (@margaretwporg)

    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.