Tax Calculation is Wrong

Hi @kyle9296

Thanks for reaching out!

I understand that tax calculation is not being deducted for returned orders on your site, correct?

On my personal site, when I refund orders this is what I’m seeing on my end. The column for the tax rate is also editable wherein you can input the amount you would like to refund.

Can you please share with us the step by step procedure you did when processing refunds on your site?

If a screenshot would be helpful, I’d recommend using https://snipboard.io. You can share the direct link to the image as a response to this topic.

Meanwhile, I will be sharing this support documentation about WooCommerce Refunds for your reference.

Hope this helps!

To be open, the following numbers are fictitious but proportional to the sales and tax number in question. On gross sales of $27,955.70 USD and a tax rate of 6.75%, the net sales are $26,188.00 USD. So Woocommerce should have collected $1,767.70 USD in tax. However, in Woocommerce/Reports/Taxes it says it collected $1,780.20 USD in tax for a difference of $12.50 USD. We had returns totaling $202.72 of which $12.82 is tax. Something is not calculating correctly and the rounding of numbers is playing a factor.

Hi,

I’m sorry to hear about this.

Can you provide a screenshot of your tax settings, i.e. WooCommerce ? settings ? tax? And one screenshot of your Standard rates, please?

For screenshots, you may want to use https://snipboard.io – please follow the instructions on that page, then paste the URL in this thread.

May I ask if you switch temporarily the site theme to Storefront, and then disable all plugins except for WooCommerce, is the report working as expected? If yes, it means that you can switch back the theme to the original, and then reactivate the rest of the plugins, one by one and checking again after each reactivation, until you find the cause of the issue.

[More info].

Let us know how that goes.

https://snipboard.io/Stq3Yp.jpg

Switching to Storefront and disabling all plugins except Woocommerce show the same numbers in Woocommerce/Reports/Orders and Taxes tabs.

Hi,

Sorry to hear that the issue persists after performing a conflict test.

Sorry for asking, can you to provide a copy of your site’s System Status, please? That will help to investigate further. You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”.?

And please share a copy of any fatal error log found under WooCommerce > System Status > Logs (if any).

Thank you.

WordPress Environment

WordPress address (URL): https://phdtackle.com
Site address (URL): https://phdtackle.com
WC Version: 7.5.1
REST API Version: ?</img> 7.5.1
WC Blocks Version: ?</img> 9.6.6
Action Scheduler Version: ?</img> 3.5.4
Log Directory Writable: ?</img>
WP Version: 6.2
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: ?</img>
Language: en_US
External object cache: –

Server Environment

Server Info: Apache
PHP Version: 7.4.33
PHP Post Max Size: 256 MB
PHP Time Limit: 120
PHP Max Input Vars: 3000
cURL Version: 7.85.0
OpenSSL/3.0.8

SUHOSIN Installed: –
MySQL Version: 5.7.39-42-log
Max Upload Size: 256 MB
Default Timezone is UTC: ?</img>
fsockopen/cURL: ?</img>
SoapClient: ?</img>
DOMDocument: ?</img>
GZip: ?</img>
Multibyte String: ?</img>
Remote Post: ?</img>
Remote Get: ?</img>

Database

WC Database Version: 7.5.1
WC Database Prefix: hub_
Total Database Size: 165.14MB
Database Data Size: 115.32MB
Database Index Size: 49.82MB
hub_woocommerce_sessions: Data: 2.02MB + Index: 0.08MB + Engine InnoDB
hub_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
hub_woocommerce_order_items: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
hub_woocommerce_order_itemmeta: Data: 0.27MB + Index: 0.20MB + Engine InnoDB
hub_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
hub_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_actionscheduler_actions: Data: 17.05MB + Index: 12.11MB + Engine InnoDB
hub_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_actionscheduler_logs: Data: 7.02MB + Index: 6.03MB + Engine InnoDB
hub_aioseo_cache: Data: 1.03MB + Index: 0.03MB + Engine InnoDB
hub_aioseo_notifications: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
hub_aioseo_posts: Data: 2.52MB + Index: 0.02MB + Engine InnoDB
hub_aioseo_terms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_barcode_v3_dimension: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_barcode_v3_fields_matching: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_barcode_v3_label_sheets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_barcode_v3_paper_formats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_barcode_v3_profiles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_barcode_v3_templates: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
hub_barcode_v3_template_to_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_barcode_v3_user_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_bwt_failed_submissions: Data: 0.22MB + Index: 0.00MB + Engine InnoDB
hub_bwt_passed_submissions: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
hub_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_comments: Data: 0.14MB + Index: 0.09MB + Engine InnoDB
hub_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
hub_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
hub_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
hub_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
hub_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_gla_budget_recommendations: Data: 0.20MB + Index: 0.11MB + Engine InnoDB
hub_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_gla_shipping_rates: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
hub_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_gpf_feeds: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_mailpoet_log: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
hub_mailpoet_mapping_to_external_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_newsletters: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
hub_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
hub_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
hub_mailpoet_scheduled_tasks: Data: 0.34MB + Index: 0.23MB + Engine InnoDB
hub_mailpoet_scheduled_task_subscribers: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
hub_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
hub_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
hub_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
hub_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_mailpoet_subscribers: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
hub_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_options: Data: 13.05MB + Index: 2.19MB + Engine InnoDB
hub_pimwick_gift_card: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_pimwick_gift_card_activity: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_postmeta: Data: 37.53MB + Index: 20.88MB + Engine InnoDB
hub_posts: Data: 13.39MB + Index: 2.28MB + Engine InnoDB
hub_pos_warehouse: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_sgs_log_events: Data: 2.02MB + Index: 0.00MB + Engine InnoDB
hub_sgs_log_visitors: Data: 0.44MB + Index: 0.00MB + Engine InnoDB
hub_termmeta: Data: 0.30MB + Index: 0.25MB + Engine InnoDB
hub_terms: Data: 0.06MB + Index: 0.09MB + Engine InnoDB
hub_term_relationships: Data: 0.20MB + Index: 0.13MB + Engine InnoDB
hub_term_taxonomy: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
hub_usermeta: Data: 0.19MB + Index: 0.14MB + Engine InnoDB
hub_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
hub_wafp_clicks: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
hub_wafp_commissions: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
hub_wafp_customlinks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
hub_wafp_events: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
hub_wafp_jobs: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
hub_wafp_payments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
hub_wafp_transactions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
hub_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
hub_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
hub_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
hub_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_wc_product_meta_lookup: Data: 1.52MB + Index: 0.84MB + Engine InnoDB
hub_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_wpmailsmtp_attachment_files: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_wpmailsmtp_emails_log: Data: 7.52MB + Index: 0.06MB + Engine InnoDB
hub_wpmailsmtp_email_attachments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_wpmailsmtp_email_tracking_events: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
hub_wpmailsmtp_email_tracking_links: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
hub_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_xoo_wl_list: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_xoo_wl_list_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_yith_wcwl: Data: 0.34MB + Index: 0.13MB + Engine InnoDB
hub_yith_wcwl_lists: Data: 0.45MB + Index: 0.23MB + Engine InnoDB

Post Type Counts

attachment: 2892
cartflows_flow: 2
cartflows_step: 4
custom_css: 1
cwginstocknotifier: 1
elementor_library: 10
elementor_snippet: 9
esaf-creative: 1
jp_img_sitemap: 1
jp_sitemap: 1
jp_sitemap_master: 1
mailpoet_page: 1
nav_menu_item: 159
oembed_cache: 85
page: 30
post: 2
postman_sent_mail: 11
product: 734
product_variation: 3645
product-feed: 13
revision: 37
shop_coupon: 7
shop_order: 121
shop_order_refund: 11
wc_conditional_fee: 11
wp_global_styles: 4
wpcf7_contact_form: 1
wpforms: 1

Security

Secure connection (HTTPS): ?</img>
Hide errors from visitors: ?</img>

Active Plugins (30)

All in One SEO: by All in One SEO Team – 4.3.4.1
Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: by codewoogeek – 3.2
Product Feed Manager for WooCommerce PRO: by RexTheme – 6.3.8
Product Feed Manager for WooCommerce: by RexTheme – 7.2.30
Bing Webmaster Url Submission: by Bing Webmaster – 1.0.13
CartFlows: by CartFlows Inc – 1.11.9
Contact Form 7: by Takayuki Miyoshi – 5.7.5.1
Easy Affiliate Basic: by Caseproof
LLC – 1.2.10

eCommerce Extra Plugin: by Ceylon Themes – 5.3
Elementor Pro: by Elementor.com – 3.12.1
Elementor: by Elementor.com – 3.12.1
Flexible Shipping: by Octolize – 4.20.3
Site Kit by Google: by Google – 1.96.0
Jetpack: by Automattic – 12.0
Kadence WooCommerce Email Designer: by Kadence WP – 1.5.10
Microsoft Advertising Universal Event Tracking (UET): by Microsoft Corporation – 1.0.5
Oliver POS - A WooCommerce Point of Sale (POS): by Oliver POS – 2.4.0.8
PW WooCommerce Gift Cards Pro: by Pimwick
LLC – 1.439

SiteGround Optimizer: by SiteGround – 7.3.1
SiteGround Security: by SiteGround – 1.4.1
WooCommerce Extra Fees Plugin: by theDotstore – 3.9.2
WooCommerce Cart All in One Premium: by VillaTheme – 1.0.10
WooCommerce Payments: by Automattic – 5.7.0
WooCommerce PayPal Payments: by WooCommerce – 2.0.4
WooCommerce Shipping & Tax: by WooCommerce – 2.2.4
WooCommerce - ShipStation Integration: by WooCommerce – 4.3.3
WooCommerce: by Automattic – 7.5.1
WP Mail SMTP Pro: by WPForms – 3.7.0
WP-Sweep: by Lester 'GaMerZ' Chan – 1.1.5
WooCommerce Fortis Gateway: by Fortis – 1.0.8

Inactive Plugins (3)

Import and export users and customers: by codection – 1.22.1
Multi-Carrier ShipStation Shipping for WooCommerce: by OneTeamSoftware – 1.4.8
Temporary Login Without Password: by StoreApps – 1.8.1.1

Dropin Plugins (1)

advanced-cache.php: advanced-cache.php

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)
pw gift card (pw-gift-card)
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: ?</img>
Enforce Approved Product Download Directories: –
Order datastore: WC_Order_Data_Store_CPT

WC Pages

Shop base: #5956 - /shop-all/
Cart: ?</img> Page does not contain the [woocommerce_cart] shortcode or the woocommerce/cart block.
Checkout: ?</img> Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block.
My account: #1590 - /my-account/
Terms and conditions: #1531 - /terms-conditions/

Theme

Name: My Storefront
Version: 1.0.1
Author URL: https://ceylonthemes.com
Child Theme: ?</img>
Parent Theme Name: eCommerce Plus
Parent Theme Version: 1.4.2
Parent Theme Author URL: https://ceylonthemes.com
WooCommerce Support: ?</img>

Templates

Archive Template: Your theme has a woocommerce.php file
you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.

Overrides: ecommerce-plus/woocommerce/content-product.php

Pimwick Plugins

PW WooCommerce Gift Cards Pro: License key: PW-62cb971b3714a
Result: success
Cached: 2023-04-07

WooCommerce PayPal Payments

Onboarded: ?</img>
Shop country code: US
WooCommerce currency supported: ?</img>
Advanced Card Processing available in country: ?</img>
Pay Later messaging available in country: ?</img>
Webhook status: –
Vault enabled: ?</img>
Logging enabled: ?</img>
Reference Transactions: –
Used PayPal Checkout plugin: –
Tracking enabled: –

Admin

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
multichannel-marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: minified-js
new-product-management-experience
product-variation-management
settings

Daily Cron: ?</img> Next scheduled: 2023-04-08 17:34:54 -05:00
Options: ?</img>
Notes: 26
Onboarding: completed

WooCommerce Payments

Version: 5.7.0
Connected to WPCOM: Yes
Blog ID: 202287630
Account ID: acct_1LLSWS2HwbopoWyf

Action Scheduler

Complete: 15,141
Oldest: 2023-03-07 22:33:20 +0000
Newest: 2023-04-07 22:30:26 +0000

Failed: 6
Oldest: 2022-08-30 08:22:52 +0000
Newest: 2023-04-04 03:44:21 +0000

Pending: 11
Oldest: 2023-04-07 22:32:49 +0000
Newest: 2023-04-30 00:13:44 +0000

Status report information

Generated at: 2023-04-07 17:30:35 -05:00
`

2023-03-30T10:43:19+00:00 CRITICAL Uncaught Error: Class ‘Requests_Cookie_Jar’ not found in /home/customer/www/phdtackle.com/public_html/wp-includes/class-requests.php:591

Stack trace:

#0 /home/customer/www/phdtackle.com/public_html/wp-includes/class-requests.php(365): Requests::set_defaults(‘https://phdtack…’, Array, Array, ‘POST’, Array)

#1 /home/customer/www/phdtackle.com/public_html/wp-includes/class-wp-http.php(395): Requests::request(‘https://phdtack…’, Array, Array, ‘POST’, Array)

#2 /home/customer/www/phdtackle.com/public_html/wp-includes/class-wp-http.php(615): WP_Http->request(‘https://phdtack…’, Array)

#3 /home/customer/www/phdtackle.com/public_html/wp-includes/http.php(179): WP_Http->post(‘https://phdtack…’, Array)

#4 /home/customer/www/phdtackle.com/public_html/wp-content/plugins/back-in-stock-notifier-for-woocommerce/includes/library/wp-async-request.php(87): wp_remote_post(‘https://phdtack…’, Array)

#5 /home/customer/www/phdtackle.com/public_html/wp-content/plugins/back-in-stock-notifier-for-woocommerce/includes/librar in /home/customer/www/phdtackle.com/public_html/wp-includes/class-requests.php on line 591

Hi,

Thanks for sending the errors.

To be open, the following numbers are fictitious but proportional to the sales and tax number in question. On gross sales of $27,955.70 USD and a tax rate of 6.75%, the net sales are $26,188.00 USD. So Woocommerce should have collected $1,767.70 USD in tax. However, in Woocommerce/Reports/Taxes it says it collected $1,780.20 USD in tax for a difference of $12.50 USD. We had returns totaling $202.72 of which $12.82 is tax. Something is not calculating correctly and the rounding of numbers is playing a factor.

It is difficult to say without screenshots of the issue, when processing a refund, transaction fees charged by the payment gateway are not refunded, [more info]. Is the discrepancy perhaps related to this?

I was on my testing site that is using WooCommerce 7.5.1 and Storefront theme, I created an order, then refunded it, but I could not see a discrepancy, I checked under WooCommerce > reports > errors > taxes. Also checked under Analytics > taxes, but the issue is not present on my end.

Can you please check if the discrepancy appears when checking the taxes by date or by code? It would be great if you provide a screenshot, so that we can check better.

Thanks.

Hi @kyle9296

We haven’t heard back from you in a while, so I’m going to go ahead and mark this thread as resolved. If you have any other questions please start a new thread.

Thanks!

Hello

I Did Face Same Isuue Like @kyle9296

I explaining My Issue Step By Step

I placed Order Like That

In Order Admin side i Got

After Refunded 1 Qty Refunded Amount Included Product tax. Remainig product should have 4 and Tax Should According to 4 Qty

https://nimb.ws/c4gAi2

But i get this result

Remaining Product Qty is 4 So Tax should According to 4 Qty but its Displaying 0

https://nimb.ws/zDJiV4

So basically i get wrong Output

can you help me with It.

Thanks

Kaushik

• This reply was modified 1 year, 5 months ago by Kaushik Domadiya.