{"id":11023,"date":"2025-01-20T09:45:04","date_gmt":"2025-01-20T09:45:04","guid":{"rendered":"https:\/\/www.trustedhosting.in\/blog\/?p=11023"},"modified":"2025-01-20T09:45:04","modified_gmt":"2025-01-20T09:45:04","slug":"how-to-change-tax-rates-in-whmcs","status":"publish","type":"post","link":"https:\/\/www.webystrata.com\/blog\/how-to-change-tax-rates-in-whmcs\/","title":{"rendered":"How to Change Tax Rates in WHMCS"},"content":{"rendered":"
\n
\n

\"How<\/a><\/p>\n

How to Change Tax Rates in WHMCS<\/h1>\n

Sales tax rates generally change over time. WHMCS<\/a> allows you to manage these VAT changes easily.<\/p>\n<\/div>\n<\/div>\n

\n
\n

WHMCS cannot provide tax advice or substitute for a tax expert. We strongly recommend seeking appropriate advice from your local tax and VAT authorities.<\/p><\/blockquote>\n<\/div>\n<\/div>\n

\n

Changing the Tax Rate<\/h2>\n
\n
\n

Make sure to change tax rates at midnight or at the latest time possible before the cron job runs on the day of the change (for the below example, January 3rd).<\/p>\n

Any invoices that the system generates after this change will use the new tax rate, but any existing invoices will keep the old tax rate.<\/p>\n<\/div>\n<\/div>\n

\n
\n

In the examples below, the tax rate is increasing from 17.5% to 20% effective January 4th.<\/p><\/blockquote>\n<\/div>\n<\/div>\n

\n

In the Admin Area<\/h3>\n
\n
\n

To update tax rates in the Admin Area:<\/p>\n

1. Go to\u00a0Configuration > System Settings > Tax Configuration\u00a0<\/strong>(prior to WHMCS 8.0,\u00a0Setup > Payments > Tax Configuration<\/strong>).<\/p>\n

2. Choose the\u00a0Tax Rules<\/strong>\u00a0tab:<\/p>\n

\"\"<\/p>\n

3. Delete the original tax rule by clicking the corresponding red delete icon:<\/p>\n

\"\"<\/p>\n

4. Create a new tax rule with exactly the same name, country, and state.<\/p>\n

5. Enter the new tax rate:<\/p>\n

\"\"<\/p>\n

\n
\n
\n
\n

6. Click\u00a0Add Rule<\/strong>.<\/p>\n<\/div>\n<\/div>\n<\/div>\n

\n

Bulk (SQL) Tax Rate Changes<\/h3>\n
\n
\n

Advanced users can also use SQL to update tax rates. This is useful and can save time if you are updating multiple rules.<\/p>\n

To do this, run an SQL update query on the WHMCS database using a tool like phpMyAdmin:<\/p>\n<\/div>\n<\/div>\n

\n
UPDATE tbltax SET taxrate=20 WHERE taxrate=17.5;<\/code><\/pre>\n
<\/div>\n<\/div>\n<\/div>\n
\n
Updating Existing Invoices<\/h3>\n
\n
\n
If you want to use SQL to update existing but unpaid invoices that are due on or after the change date, you could use this query:<\/p>\n<\/div>\n<\/div>\n
\n
UPDATE tblinvoices SET taxrate=20,tax=subtotal*0.2,total=subtotal+tax-credit WHERE status='Unpaid'\r\nAND taxrate=17.5 AND duedate>='2023-01-01';<\/code><\/pre>\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
Subscriptions and Tax Rate Changes<\/h2>\n
\n
\n
If you have selected\u00a0Exclusive Tax\u00a0<\/strong>or enabled\u00a0Deduct Tax Amount<\/strong>, VAT rate changes may result in a new invoice total compared with the previous invoice. This will have an impact for those clients paying via a fixed amount subscription agreement via gateways like PayPal\u00ae and 2Checkout.<\/p>\n
This will require manual steps to ensure that clients are paying the correct amount. If you anticipate this issue for your clients, cancel the existing subscription and create a new subscription from the next issued invoice to avoid overpayments or interruptions in service.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
How to Change Tax Rates in WHMCS Sales tax rates generally change over time. WHMCS allows you to manage these…<\/p>\n","protected":false},"author":1,"featured_media":11027,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-11023","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-whmcs"],"_links":{"self":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/11023","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/comments?post=11023"}],"version-history":[{"count":1,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/11023\/revisions"}],"predecessor-version":[{"id":11028,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/11023\/revisions\/11028"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media\/11027"}],"wp:attachment":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media?parent=11023"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/categories?post=11023"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/tags?post=11023"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}