Marty Zigman

Conversations with Marty Zigman

Certified Administrator • ERP • SuiteCloud

Solving VAT-Inclusive Pricing in NetSuite Without Activating SuiteTax

Accounting NetSuite Reporting



This article is relevant if you need to support foreign VAT obligations in NetSuite OneWorld while preserving an existing US Edition configuration, avoiding SuiteTax risk, and still presenting customer-facing prices the way buyers expect to see them.

TL;DR Summary

A recent client needed to launch a United Kingdom third-party logistics (3PL) warehouse operation while keeping US-based sales staff, transacting in GBP for Great Britain and EUR for Ireland, and managing VAT obligations without creating a separate UK legal entity. Their NetSuite account was already running effectively on Legacy Tax, and they wanted to avoid SuiteTax due to concerns about instability, existing reporting dependencies, and the risk of disrupting EDI integrations. The challenge was that their US Edition OneWorld account enforced tax-exclusive pricing behavior, even though UK and Ireland customers expect VAT-inclusive pricing. Our solution was to keep Legacy Tax in place, intentionally let the native tax engine calculate based on the wrong assumption, and then use SuiteScript to back out the correct net product amount so that tax, gross totals, and presentation all align with regional expectations.

Background

A recent client asked us to visit their operations and help plan a United Kingdom third-party logistics (3PL) warehouse rollout. The business model was straightforward on paper but nuanced in NetSuite. Sales personnel would remain in the United States. Transactions would occur in GBP for Great Britain and EUR for Ireland. The company had already worked closely with tax and legal advisors and confirmed that they did not need to establish a UK legal entity. However, they still carried VAT reporting obligations for the affected jurisdictions.

This combination is where implementation teams need to slow down and think carefully. Just because a company does not need a legal entity in a country does not mean NetSuite can be left in a default state. Tax nexus, transaction presentation, pricing logic, and downstream reporting still have to line up with operational reality.  Activating SuiteTax is irreversible and should be considered carefully.

In this case, the client was already running NetSuite Legacy Tax successfully. They planned to use an outside firm to produce VAT obligation reports, so they did not need NetSuite’s international reporting structures or extra compliance overhead. They simply needed the transaction records to support the correct tax calculations and the correct financial impact.  Fortunately, VAT taxation elements are relatively simple and easy to maintain.

Consideration for Specific Account Configuration

The issue became more interesting because the account was a OneWorld environment provisioned as a US Edition. That matters. In this configuration, taxation is fundamentally built around amounts exclusive of tax. Taxes are added on top of the amount. Although Oracle NetSuite documentation may suggest the presence of configuration switches for tax-inclusive pricing, those options were not available in this provisioned account. In our experience, some of these behaviors are rooted in the original account provisioning and are not always retrofittable in a practical way.

This requirement also ties directly to a long-standing principle I described in an earlier article: customers should see prices the way they naturally think about them in their market. For background, see my 2017 article, “Solve NetSuite VAT / GST Exclusive Pricing Challenges”.

NetSuite Legacy Tax and VAT-Inclusive Pricing Reality

Common sense says a UK or Irish buyer often thinks in tax-inclusive terms. The displayed unit price should feel familiar. The invoice should look right. The gross amount should match the customer’s expectation. Yet a US Edition Legacy Tax configuration in NetSuite wants to start from a tax-exclusive amount and then add tax afterward.

That mismatch creates both a user-experience problem and an accounting-modeling problem.

The user experience problem is easy to see. If the commercial team promises a VAT-inclusive price, but NetSuite treats the same number as tax-exclusive, the tax is overstated and the gross amount is inflated.

The accounting problem is more subtle. If the wrong amount is used as the taxable base, VAT liability is incorrect, line economics are incorrect, and invoice presentation becomes misleading. Even if an outside compliance partner prepares the formal VAT filings, the source transactional data must remain coherent.

We therefore needed a solution that honored four constraints:

  1. Preserve Legacy Tax because it was stable and already fit the client’s environment.
  2. Avoid SuiteTax activation because of implementation risk, reporting disruption, and integration concerns.
  3. Support VAT-inclusive pricing behavior for UK and Ireland transactions.
  4. Produce correct GL impact without introducing a third-party tax engine.

A Practical Solution: Tax-Inclusive Approach for Legacy Tax

The solution was to accept that NetSuite Legacy Tax would calculate from the wrong assumption, then use SuiteScript to correct the taxable base.

The key design decision was this: for UK and Ireland transactions, we anchored the Rate column as the price the customer expects to see; that is, the tax-inclusive amount.

From there, we let NetSuite do what it normally does, then intervene with controlled logic to back into the correct net amount.

The approach works as follows:

  1. Treat Rate as the trusted tax-inclusive selling price: For applicable UK and Ireland sales transactions, the Rate field is considered authoritative. It comes from pricing tables and reflects the commercial number that the customer should recognize.
  2. Calculate a new gross line amount: We determine the total intended line amount as Quantity × Rate, even though NetSuite does this on our behalf.  We can do this because we trust that Quantity and Rate are always anchored.
  3. Back into the net product amount: Because the displayed rate includes VAT, the correct net amount must be derived by dividing the gross amount by (1 + tax rate).
  4. Override NetSuite’s Line Amount field: NetSuite allows the line Amount to be overridden. We update the Amount field with the calculated net product value.  Now we have the right product price.
  5. Let Legacy Tax recalculate naturally: Once the Amount field reflects the true pre-tax amount, the native tax engine calculates tax as: Amount × Tax Rate

This gives us the result we want:

  • The Rate remains the customer-facing tax-inclusive price.
  • The Amount becomes the net product value, exclusive of tax.
  • The Tax Amount becomes the correct VAT.
  • The Gross Amount aligns with Quantity × Rate.

That is the key. We are not fighting the entire tax engine. We are carefully feeding it the correct taxable base after preserving the market-facing price.

The NetSuite Legacy Tax Setup for VAT Inclusive Taxation

  1. Use Legacy Tax only:  The client was already operating successfully on Legacy Tax, so there was no reason to introduce SuiteTax risk for this requirement.
  2. Leverage Advanced Taxes in OneWorld: Advanced Taxes is already enabled in NetSuite OneWorld accounts, which provides the foundation for nexus and tax code setup.
  3. Establish nexus for the applicable foreign jurisdictions: Even though a new UK subsidiary was not required, we indicated that the US subsidiary had nexus in the UK and Ireland because the company was selling and shipping into those foreign jurisdictions.
  4. Connect tax authority vendor records: Tax authority vendor records were linked to support liability tracking and administrative clarity.
  5. Avoid unnecessary Add-in International Tax Report structures: Because an outside service would prepare VAT reporting, we chose not to install international tax reports. This prevented unnecessary technical bloat and reduced maintenance overhead.
  6. Create tax records for UK and Ireland VAT rates: Nexus and tax schedules were configured with the appropriate VAT rates for each jurisdiction.

Key Considerations to Activate the Solution

  1. Prioritize invoices and cash sales: The client wanted the setup to appear on sales orders, which is useful, but the most important transaction point is the invoice or cash sale because that is where the financial impact is recorded.
  2. Refine customer-facing invoice presentation: Regional expectations matter. Invoice templates and customer communications should present tax and line pricing in the way UK and Ireland recipients expect to read them.  NetSuite’s tools readily allow for these refinements.
  3. Validate general ledger impact: Do not stop at the form view. Always confirm that revenue, tax liability, receivables, and gross transaction totals post as expected.

Click images to better understand the solution.

Delivering Reliable NetSuite Outcomes Across Borders

What matters most in projects like this is disciplined modeling. The wrong answer is often to assume that a newer feature automatically represents progress. In this case, activating SuiteTax introduced unnecessary risk compared to the client’s stated needs. They already had a functioning Legacy Tax environment, stable reporting, and existing EDI integrations that could be jeopardized by a transition to a different tax engine.

Instead, we used careful problem framing. We recognized that the account provisioning constrained tax-inclusive options. We respected the client’s operating model and legal guidance. We designed around the limitation with light scripted logic rather than a heavy platform change. And we kept the solution aligned with how customers in those markets think about pricing.

This is the kind of work we value most: listening carefully, modeling accurately, and executing with precision. We routinely share our intellectual property, algorithms, and implementation patterns without license charges because the real value is not in holding back ideas. The real value is in understanding the business requirement, translating it into clean system behavior, and delivering a result that stands up in operations and finance.

If you found this article relevant, feel free to sign up for notifications to new articles as I post them. If you are ready to model UK and Ireland VAT-inclusive pricing in NetSuite without taking unnecessary SuiteTax risk, let’s have a conversation.

 

 

Marty Zigman LinkedIn

Marty Zigman

Holding three official certifications, Marty is widely recognized as a top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. A former Deloitte & Touche CPA and technology executive with CTO roles, he brings over 35 years of leadership in ERP, CRM, and eCommerce business systems. Contact Marty to engage directly.

BiographyYouTubeLinkedInX (Twitter)

Leave a Reply

Your email address will not be published. Required fields are marked *