---
title: "NJ Sales Tax Splitter for Online Sellers (Python) | MCC"
description: "Split Shopify, Etsy, Amazon, eBay and Square orders into marketplace, NJ taxable, exempt and out-of-state sales. Quarterly ST-50 totals and nexus warnings."
url: "https://mcc-solutionsnj.com/bookkeeping/nj-sales-tax-splitter-python-script"
---

Paid script

# New Jersey Sales Tax Splitter for Online Sellers

Drop in your order exports and see which sales the marketplace already taxed, which NJ sales you owe 6.625% on, and what to put on each quarterly ST-50.

[![Intuit ProAdvisor Gold tier badge](/img/credentials/intuit-proadvisor-gold.png)](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)Gold tier in Intuit's ProAdvisor program. [See my Intuit listing](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)

Paid script

## NJ Sales Tax Splitter

Buy this script on its own for $39, one time. No membership needed. It runs on your own computer and nothing you enter leaves it. Read how it works and the questions below first.

The [Automation Suite](/bookkeeping/automation-suite) includes this and 10 more tools for $99. Members get this included. [See the membership](/membership) or [sign in](/membership/login). Already bought it? Email me my access link.

How it works

## How it works

Export orders from **Shopify, Etsy, Amazon, eBay or Square** (or any CSV with date, amount, tax and state). The script detects each platform from its headers and puts every line in one bucket: **marketplace facilitator** (the platform collected and remitted NJ tax), **your own NJ taxable sales**, **NJ exempt** items such as most clothing (from an editable keyword list), or **out-of-state**. It totals each quarter for the ST-50 with tax due at 6.625% next to the tax you actually collected and the due date, flags the $30,000 monthly-payment threshold, and lists sales by destination state with warnings when a state nears an economic-nexus threshold you can edit. Everything runs on your computer.

FAQ

## About this calculator

**What do I need to run it?**

Python 3.9 or newer (free from python.org) and your order export files. No other installs, no account, and no internet connection is needed.

**Which exports does it read?**

Shopify order exports, Etsy sold orders or sold order items, Amazon order reports (tab or comma separated), eBay order reports, Square item details, and a generic CSV with date, amount, tax, state and channel columns.

**How does it know what is exempt?**

It uses an editable keyword list. By default clothing and footwear are exempt and accessories like jewelry, handbags and watches are taxable, following the NJ Division of Taxation clothing guidance. Review the matched rule shown for each line.

**Is this tax advice?**

No. It sorts and totals your data using published NJ rates and rules so you can prepare or check a return. Confirm the figures on nj.gov or with a tax professional before filing.

See [all free tools](/free-tools). More free tools: [Early payment discount calculator](/bookkeeping/early-payment-discount-calculator), [Debt-to-equity ratio calculator](/bookkeeping/debt-to-equity-ratio-calculator), [Receivables turnover calculator](/bookkeeping/accounts-receivable-turnover-calculator), or [see all free tools](/free-tools).

Free

### Month-End Close Checklist (PDF)

The five-day close, one page to print. Enter your email and we send a link to confirm it is yours, then the download. We may email you about new toolkits, and every email has an unsubscribe link.

General information, not tax or legal advice. [How we write and check our tools](/editorial-standards).

## Want your books and numbers handled?

[Free health check](/bookkeeping/health-check)[Call (908) 444-6373](tel:+19084446373)