To achieve accurate tax calculations, Stripe Tax needs to know what you are selling, not just where you are selling it. Different products (like digital software vs. physical hardware) are taxed differently across various jurisdictions.
By mapping Stripe Product Tax Codes (PTC) to your NetSuite Item records, you ensure that PayPack applies the correct taxability rules to every line item on your invoices.
What is a Product Tax Code (PTC)?
A Product Tax Code is a unique identifier used by Stripe to categorize products for tax purposes. Examples include:
txcd_10000000: General - Electronically Supplied Services
txcd_20030000: General - Services
txcd_00000000: Non-taxable / Exempt
See Stripe Docs: Product tax codes to learn more.
Import PTCs into NetSuite
Use the PayPack Map/Reduce script to bring Stripe PTCs into NetSuite.
In NetSuite, navigate to Lists > Scripting > Scripts.
Locate the script titled:
PayPack Stripe Product Tax Code Sync MR.Click View next to the script, then navigate to the Deployments subtab.
Click the link for the Script Deployment (usually labeled
PayPack Stripe Product Tax Code Sync MR Deploy).On the Deployment record, click Edit, then select Save and Execute when status is testing from the blue save button dropdown.
Status Check: You will be redirected to the Map/Reduce Status page. Wait until the "Status" column shows Complete.
What this script does: It queries your Stripe account and creates a custom Product tax code record for you to validate and assign to NetSuite items.
Deploy Scheduled Script
Schedule the script to run automatically by setting the script deployment status to scheduled.
Watch this video tutorial to see the NetSuite Map/Reduce script in action.
Configure the Item Record in NetSuite
PayPack adds a custom field to your NetSuite Item records to house the Stripe PTC.
In NetSuite, navigate to Lists > Accounting > Items.
Click Edit next to an Item (e.g., a Non-Inventory Part or Service Item).
Locate the PayPack Data subtab.
Find the custom field labeled Stripe Product Tax Code.
Enter the corresponding PTC (e.g.,
txcd_99999999).Save the record.
Watch the video tutorial below for a step-by-step guide on how to assign a Stripe Product Tax Code (PTC) to your NetSuite item records.
Leaving the Stripe Product Tax Code field blank will result in a calculation error, as Stripe requires a product category to determine accurate taxability. To avoid processing disruptions, it is best practice to explicitly map every item used in your transactions to a valid Stripe PTC.
Bulk Update via CSV
If you have hundreds of items, updating them manually is inefficient. Use NetSuite’s CSV Import to update your items in bulk.
Prepare a CSV file with two columns: Internal ID (NetSuite Item ID) and Stripe Product Tax Code.
Navigate to Setup > Import/Export > Import CSV Records.
Select Items as the Record Type.
Map your CSV "Stripe Product Tax Code" column to the NetSuite field:
Stripe Product Tax Code (Custom).Run the import.