All articles

Accounting

Sales Tax — Rates, Sur-Tax, Liability vs Collected

How JewelTrak computes sales tax (TaxRate + SurTaxRate over a threshold), why some invoices have $0 tax (out-of-state, wholesale, taxable=0), and the difference between Tax Liability and Tax Collected on reports.

JewelTrak computes sales tax per invoice based on three rate fields stored on the order: TaxRate, SurTaxRate, and SurTaxThreshold. Understanding how they combine is important for jurisdictions like Florida that have a base state rate and a discretionary county “sur-tax” capped at a threshold per item.

How tax is calculated

The base tax applies to the entire invoice subtotal. The surtax cap is applied per item, not per line and not per invoice:

base tax  = subtotal × TaxRate

per line: surtax = min(|lineExt|, qty × SurTaxThreshold) × SurTaxRate
          (algebraically equivalent to giving each item its own SurTaxThreshold cap)

total tax = base tax + Σ (surtax for each line)
  • TaxRate — the base rate that applies to the entire subtotal (e.g. 6% state).
  • SurTaxRate — an additional rate (e.g. 1% county discretionary).
  • SurTaxThreshold — the dollar cap per item above which the SurTaxRate stops applying. Common in Florida ($5,000 cap).

Why per-item matters

A line of qty 3 at $3,000 each is three separate items for surtax purposes — each $3K item is under the $5K cap, so the full $9,000 line gets surtaxed:

3 × $3,000 watches in Florida (6% + 1%, $5,000 cap):
  base   = 9,000 × 0.06                 = $540
  surtax = min(9,000, 3 × 5,000) × 0.01 = $90    (full line under per-item cap)
  total                                 = $630

Contrast a single $8,000 item — only $5,000 of it gets surtaxed:

1 × $8,000 watch in Florida (6% + 1%, $5,000 cap):
  base   = 8,000 × 0.06                 = $480
  surtax = min(8,000, 1 × 5,000) × 0.01 = $50    (capped at one item × threshold)
  total                                 = $530

Service lines (StockType = ‘S’) are treated as a single item — the cap applies once to the line’s full amount.

Why this changed. Earlier versions capped surtax against the invoice subtotal as a whole, which under-collected on multi-quantity lines above the threshold. The math now matches the Florida DOR guidance (and equivalent rules in other surtax states): each item carries its own cap.

Trade-ins

A trade-in lowers the price being taxed. It doesn’t earn tax back. Florida taxes “the sales price of the new article, less the credit for the used article taken in trade” (§212.09). So JewelTrak:

  1. taxes the items being sold as above, each with its own surtax cap;
  2. takes the trades off the taxable amount, all the trades on the invoice together;
  3. charges surtax on whichever is smaller: the items’ capped surtax amount, or what’s left after the trades.

Tax never goes below $0 because of a trade. If the trade is worth more than the purchase, the extra is the shop buying the piece, not a tax refund. A real return of a sold item still refunds its own tax.

$20,000 ring, $15,000 trade (6% + 0.5%, $5,000 cap):
  taxable = 20,000 − 15,000               = $5,000
  base    = 5,000 × 0.06                  = $300
  surtax  = min(5,000, 5,000) × 0.005     = $25

$60,030 band, $60,030 of trades:
  taxable = $0, so tax = $0

Invoices paid in full before September 23, 2026 keep the tax they were paid under.

Invoices imported from your old system keep its tax math, with one change: a trade can no longer take the tax below $0. If the trade is worth more than everything else on the invoice, the tax is $0 rather than a refund. Imported invoices already paid in full keep the tax they were paid under.

Rates are stored as decimals (0.06 = 6%) — the display layer converts to percentages.

Where the rates come from

Rates are per invoice, written at order creation time, copied from:

  1. The store’s default rates (Settings → Stores → [store] → Tax setup), OR
  2. The customer’s override (some out-of-state customers have their own tax setup).

Moving an open invoice to another store gives it that store’s rates, and the totals show them as soon as you change the Store / Account box. The rates stay as they are if an administrator set them by hand, or if the invoice is already in QuickBooks.

Changing one invoice’s rates

To see the rates an invoice was locked in with, click the pencil next to Taxable under Options. The window shows the tax rate and surtax, and who changed them and why if they were ever set by hand. It also says, in plain words, how the tax on that invoice was worked out: whether the surtax cap applies per item or to the whole invoice (invoices brought over from your previous system keep its whole-invoice cap), and, when there is a trade-in, which trade-in rule the invoice was taxed under. Anyone can look.

An administrator can also change them there, for example for an invoice that has to be billed at the rate in force before your rates changed. Click Change rates, enter the tax rate, surtax rate and the amount the surtax applies to (blank for no limit), and give a reason. Only that invoice changes; the store keeps its rates.

This works on a new invoice before its first save, too, in the same window: set the rates and the reason, click Use these rates, then Save, and the invoice is created with them. “Own rates” shows next to Taxable until you save; Use the store’s rates in the window puts it back.

Rates can have up to three decimal places (8.875%). Once set, saving the invoice or its work order later never changes them; only Edit rates does.

  • It works only on an open invoice that has not been sent to QuickBooks. A finalized invoice is what the customer was charged.
  • The invoice then reads Set manually, with who did it, when and the reason, so the rate never looks like a mistake later. The change is also in the audit log.
  • If the invoice bills a single work order, the work order gets the same rates, so saving the work order later does not put the old ones back.

Don’t change the store’s rates to do this: every sale rung up at that store in the meantime would take the temporary rate.

When tax is $0

A $0 tax line on an invoice means one of:

  • Taxable = 0 on the order header — the customer is tax-exempt or the sale qualifies (out-of-state ship-to, resale certificate on file, etc.).
  • Wholesale invoice — the invoice’s type is Wholesale; sales to wholesale don’t generally collect tax.
  • TaxRate = 0 — the store has no rate configured (rare; usually a setup oversight).

The Sales Tax Liability report breaks invoices into three sections: Retail Taxable, Retail Non-Taxable, and Wholesale, so you can see which bucket a tax-free sale fell into. The section comes from the type saved on the invoice: a Wholesale invoice goes to Wholesale, and a Retail or Retail Tax Exempt invoice goes to Retail Taxable or Retail Non-Taxable by whether tax was charged. The customer’s record doesn’t decide it, so a retail sale to someone you also buy from stays under Retail, and editing a customer later never moves past sales.

Tax Liability vs Tax Collected

On the report, both columns usually show the same number — but they can diverge:

  • Tax Liability = what the formula says you owe based on the invoice subtotals (the calculated amount).
  • Tax Collected = what you actually charged the customer.

In the current model, these are equal — every invoice’s tax is the calculated value. The two columns exist for jurisdictions where you might collect a different amount (e.g. invoice-level tax overrides). If you don’t override, expect them to match.

Splitting out the surtax (Florida DR-15)

The Florida DR-15 return asks for the surtax separately: line 15(a), the amount of items over $5,000 (the part that pays state tax but no surtax), and line 15(d), the total surtax. The Sales Tax report shows them by default: its Surtax dropdown starts on Split out surtax. Choose Tax combined for the report without the surtax columns.

With the split on, three columns follow Tax Collected:

  • State Tax: the tax at the store’s main rate.
  • Surtax: the county surtax on that invoice.
  • Over $5,000: the part of any item above the $5,000 surtax limit.

State Tax plus Surtax always equals the invoice’s tax. The figures come from the same calculation that charged the customer, so they tie to what was collected.

Under the grand total, a DR-15 line shows the State Tax, the 15(a) amount and the 15(d) surtax, ready to copy onto the return. Excel and CSV downloads include the same columns and lines.

Invoices marked Combined rate were charged one combined rate (for example 6.5%) with no surtax rate recorded, in a store that charges surtax. Their tax can’t be split, so it shows entirely as State Tax, and the DR-15 line says how many there are. To avoid this, enter the state rate and the surtax rate separately in the store’s settings (for example 6% and 0.5%), not one combined rate.

Zero-tax filter

The Sales Tax Liability report has a Zero-tax filter:

  • Include zero-tax: every invoice in the date range shows. This is the default for most shops.
  • Exclude zero-tax: leaves out
    • non-taxable Retail invoices, meaning a Retail sale with tax turned off. Invoices with the order type Retail Tax Exempt, and Wholesale invoices, still show.
    • invoices that come to $0, where the subtotal, tax and shipping add up to nothing because a trade or an adjustment offset the sale. Card fees aren’t counted in that test.

This is the same rule as legacy’s “Hide adjusted retail” store setting, and a shop that had that setting on starts with Exclude zero-tax already chosen. Either way you can switch it for any run, and Print, Excel, CSV and Email always match what’s chosen on screen. The filter doesn’t apply to the cash-basis version of the report.

Cash outlet invoices

Invoices whose Sales Outlet is Cash never show on the sales tax report, whatever the filters, the same as in legacy.

Cash-basis report (shops that report tax when paid)

Some shops report sales tax when an invoice is paid rather than when it’s sold. For them the report lists each taxable invoice in the period it became paid in full, with all of its tax, and the dates you pick are payment dates.

A return that you refunded shows in the period of the refund, with its tax as a negative amount, so it reduces the tax for that period.

Voided invoices

Voiding an invoice never changes a period you may already have filed. Instead:

  • A sale shows in the period of its invoice date, even if it was voided later. Rerunning that period gives the same tax you reported.
  • In the period it was voided, the invoice shows again as a Void row: the same figures, negative, dated the day it was voided, with “sold” and the original date under it. That negative tax is what you can take back on your next return.
  • An invoice dated and voided in the same period doesn’t appear at all, because the sale and its void cancel out.

On the cash-basis version, the same applies to the period the invoice was paid in full: it’s reversed in the period it was voided only if it had been paid off in an earlier one.

Excel and CSV mark these rows VOID, with the original sale date next to the customer’s name.

Returns work separately: a return invoice already carries negative tax in the month it’s written.

Which invoice document you can print

Email, Share, Print and Download PDF each offer up to three versions of the invoice, and which ones appear depends on the order itself — because these are tax records, not layouts:

The orderDocuments offered
Taxable (any type)Standard only
Not taxableStandard and Resale
Type is Retail Tax ExemptTax Exempt only

So a sale that charged tax can’t produce a resale certificate, and an exempt sale can’t be papered over with an ordinary invoice. When only one version applies — the common case for a taxable retail sale — the button just prints it, with no menu to choose from.

If you tick Taxable on a Retail Tax Exempt order the buttons switch off, because that combination contradicts itself. Clear Taxable, or change the Type, and they come back.

Tips

  • File the Sales Tax Liability report monthly with your state’s sales tax return.
  • The Tax Collected total should match what you remit to the state (down to the rounding rules — JewelTrak rounds per-line at 2 decimals).
  • For a customer who claims tax-exempt status, mark Taxable = 0 on the invoice and record their resale-certificate number on the contact record so the verification + audit trail lives in JewelTrak. See Resale Certificates for the capture + verify workflow.
  • If you ship to multiple states, set up a per-customer rate override or use the customer’s default address to drive the rate.