How do you read a separate-tax marketplace export?

Last updated: 2026-08-09

Written and reviewed by Seller Profit Guard Editorial Team.

Separate-Tax Marketplace Export Example flow from buyer totals and tax roles to retained revenue, payout, decision, and restoration — Use the separate-tax worksheet to separate marketplace and seller tax roles.

Open Shopify fixture

An invented export shows USD 10,000 merchandise and shipping plus USD 1,000 seller-collected tax. After USD 400 merchandise refunds and USD 40 seller-tax refunds, retained revenue is USD 9,600 and USD 960 remains liability cash. After USD 900 of non-tax fees, expected payout is USD 9,660. Use a materially different separate-tax Shopify export rather than renaming the tax-inclusive fixture. Checkpoint 1 in the separate-tax worksheet records channel, market, cohort, export layout, tax roles, source version, owner, reviewer, and accepted formula before interpretation.

For open shopify fixture, preserve the separate merchandise and seller-tax columns, liability cash, refund layers, non-tax fees, payout cutoff, qualified-review boundary, and restoration rather than borrowing a marketplace-remitted-tax presentation.

Use invented or approved aggregates only. Exclude private emails, buyer identities, addresses, order rows, taxpayer IDs, account details, payment and bank records, credentials, private invoices, and raw exports from the public separate-tax worksheet.

Verify separate columns

An invented export shows USD 10,000 merchandise and shipping plus USD 1,000 seller-collected tax. After USD 400 merchandise refunds and USD 40 seller-tax refunds, retained revenue is USD 9,600 and USD 960 remains liability cash. After USD 900 of non-tax fees, expected payout is USD 9,660. Use a materially different separate-tax Shopify export rather than renaming the tax-inclusive fixture. Checkpoint 2 in the separate-tax worksheet records channel, market, cohort, export layout, tax roles, source version, owner, reviewer, and accepted formula before interpretation.

For verify separate columns, preserve the separate merchandise and seller-tax columns, liability cash, refund layers, non-tax fees, payout cutoff, qualified-review boundary, and restoration rather than borrowing a marketplace-remitted-tax presentation.

Carry USD 10,000 revenue

An invented export shows USD 10,000 merchandise and shipping plus USD 1,000 seller-collected tax. After USD 400 merchandise refunds and USD 40 seller-tax refunds, retained revenue is USD 9,600 and USD 960 remains liability cash. After USD 900 of non-tax fees, expected payout is USD 9,660. Use a materially different separate-tax Shopify export rather than renaming the tax-inclusive fixture. Checkpoint 3 in the separate-tax worksheet records channel, market, cohort, export layout, tax roles, source version, owner, reviewer, and accepted formula before interpretation.

For carry usd 10,000 revenue, preserve the separate merchandise and seller-tax columns, liability cash, refund layers, non-tax fees, payout cutoff, qualified-review boundary, and restoration rather than borrowing a marketplace-remitted-tax presentation.

Carry USD 1,000 seller tax

An invented export shows USD 10,000 merchandise and shipping plus USD 1,000 seller-collected tax. After USD 400 merchandise refunds and USD 40 seller-tax refunds, retained revenue is USD 9,600 and USD 960 remains liability cash. After USD 900 of non-tax fees, expected payout is USD 9,660. Use a materially different separate-tax Shopify export rather than renaming the tax-inclusive fixture. Checkpoint 4 in the separate-tax worksheet records channel, market, cohort, export layout, tax roles, source version, owner, reviewer, and accepted formula before interpretation.

For carry usd 1,000 seller tax, preserve the separate merchandise and seller-tax columns, liability cash, refund layers, non-tax fees, payout cutoff, qualified-review boundary, and restoration rather than borrowing a marketplace-remitted-tax presentation.

Carry refund layers

An invented export shows USD 10,000 merchandise and shipping plus USD 1,000 seller-collected tax. After USD 400 merchandise refunds and USD 40 seller-tax refunds, retained revenue is USD 9,600 and USD 960 remains liability cash. After USD 900 of non-tax fees, expected payout is USD 9,660. Use a materially different separate-tax Shopify export rather than renaming the tax-inclusive fixture. Checkpoint 5 in the separate-tax worksheet records channel, market, cohort, export layout, tax roles, source version, owner, reviewer, and accepted formula before interpretation.

For carry refund layers, preserve the separate merchandise and seller-tax columns, liability cash, refund layers, non-tax fees, payout cutoff, qualified-review boundary, and restoration rather than borrowing a marketplace-remitted-tax presentation.

separate-tax worksheet: carry refund layers — Original explanatory diagram for carry refund layers using invented aggregate values and no private seller data.

Calculate USD 9,600 revenue

An invented export shows USD 10,000 merchandise and shipping plus USD 1,000 seller-collected tax. After USD 400 merchandise refunds and USD 40 seller-tax refunds, retained revenue is USD 9,600 and USD 960 remains liability cash. After USD 900 of non-tax fees, expected payout is USD 9,660. Use a materially different separate-tax Shopify export rather than renaming the tax-inclusive fixture. Checkpoint 6 in the separate-tax worksheet records channel, market, cohort, export layout, tax roles, source version, owner, reviewer, and accepted formula before interpretation.

For calculate usd 9,600 revenue, preserve the separate merchandise and seller-tax columns, liability cash, refund layers, non-tax fees, payout cutoff, qualified-review boundary, and restoration rather than borrowing a marketplace-remitted-tax presentation.

Calculate USD 960 liability

An invented export shows USD 10,000 merchandise and shipping plus USD 1,000 seller-collected tax. After USD 400 merchandise refunds and USD 40 seller-tax refunds, retained revenue is USD 9,600 and USD 960 remains liability cash. After USD 900 of non-tax fees, expected payout is USD 9,660. Use a materially different separate-tax Shopify export rather than renaming the tax-inclusive fixture. Checkpoint 7 in the separate-tax worksheet records channel, market, cohort, export layout, tax roles, source version, owner, reviewer, and accepted formula before interpretation.

For calculate usd 960 liability, preserve the separate merchandise and seller-tax columns, liability cash, refund layers, non-tax fees, payout cutoff, qualified-review boundary, and restoration rather than borrowing a marketplace-remitted-tax presentation.

Carry USD 900 fees

An invented export shows USD 10,000 merchandise and shipping plus USD 1,000 seller-collected tax. After USD 400 merchandise refunds and USD 40 seller-tax refunds, retained revenue is USD 9,600 and USD 960 remains liability cash. After USD 900 of non-tax fees, expected payout is USD 9,660. Use a materially different separate-tax Shopify export rather than renaming the tax-inclusive fixture. Checkpoint 8 in the separate-tax worksheet records channel, market, cohort, export layout, tax roles, source version, owner, reviewer, and accepted formula before interpretation.

For carry usd 900 fees, preserve the separate merchandise and seller-tax columns, liability cash, refund layers, non-tax fees, payout cutoff, qualified-review boundary, and restoration rather than borrowing a marketplace-remitted-tax presentation.

Bridge USD 9,660 payout

An invented export shows USD 10,000 merchandise and shipping plus USD 1,000 seller-collected tax. After USD 400 merchandise refunds and USD 40 seller-tax refunds, retained revenue is USD 9,600 and USD 960 remains liability cash. After USD 900 of non-tax fees, expected payout is USD 9,660. Use a materially different separate-tax Shopify export rather than renaming the tax-inclusive fixture. Checkpoint 9 in the separate-tax worksheet records channel, market, cohort, export layout, tax roles, source version, owner, reviewer, and accepted formula before interpretation.

For bridge usd 9,660 payout, preserve the separate merchandise and seller-tax columns, liability cash, refund layers, non-tax fees, payout cutoff, qualified-review boundary, and restoration rather than borrowing a marketplace-remitted-tax presentation.

Close scenario

An invented export shows USD 10,000 merchandise and shipping plus USD 1,000 seller-collected tax. After USD 400 merchandise refunds and USD 40 seller-tax refunds, retained revenue is USD 9,600 and USD 960 remains liability cash. After USD 900 of non-tax fees, expected payout is USD 9,660. Use a materially different separate-tax Shopify export rather than renaming the tax-inclusive fixture. Checkpoint 10 in the separate-tax worksheet records channel, market, cohort, export layout, tax roles, source version, owner, reviewer, and accepted formula before interpretation.

For close scenario, preserve the separate merchandise and seller-tax columns, liability cash, refund layers, non-tax fees, payout cutoff, qualified-review boundary, and restoration rather than borrowing a marketplace-remitted-tax presentation.

Open Shopify fixture: verification test 1

Create one synthetic counterexample for open shopify fixture. Change one buyer-total, revenue, tax-role, refund, fee, adjustment, payout, flag, or threshold field; retain the prior packet; and show the order-total bridge, retained revenue, tax balances, expected payout, gap, and Block, Review, or Ready effect.

Reconcile the counterexample against first-party order, tax, refund, settlement, payout, remittance-marker, official-definition, source-version, owner, reviewer, protected-baseline, qualified-review, stop-trigger, and restored-result evidence.

Explain why the test does not determine taxability, nexus, registration, collection, remittance, filing, exemption, withholding, taxable income, accounting treatment, legal compliance, demand, conversion, or channel superiority.

Separate-tax verification 1 must keep seller-collected liability cash outside retained revenue while still explaining why it can appear inside the payout bridge before payment or remittance.

Verify separate columns: verification test 2

Create one synthetic counterexample for verify separate columns. Change one buyer-total, revenue, tax-role, refund, fee, adjustment, payout, flag, or threshold field; retain the prior packet; and show the order-total bridge, retained revenue, tax balances, expected payout, gap, and Block, Review, or Ready effect.

Separate-tax verification 2 must keep seller-collected liability cash outside retained revenue while still explaining why it can appear inside the payout bridge before payment or remittance.

Carry USD 10,000 revenue: verification test 3

Create one synthetic counterexample for carry usd 10,000 revenue. Change one buyer-total, revenue, tax-role, refund, fee, adjustment, payout, flag, or threshold field; retain the prior packet; and show the order-total bridge, retained revenue, tax balances, expected payout, gap, and Block, Review, or Ready effect.

Separate-tax verification 3 must keep seller-collected liability cash outside retained revenue while still explaining why it can appear inside the payout bridge before payment or remittance.

Carry USD 1,000 seller tax: verification test 4

Create one synthetic counterexample for carry usd 1,000 seller tax. Change one buyer-total, revenue, tax-role, refund, fee, adjustment, payout, flag, or threshold field; retain the prior packet; and show the order-total bridge, retained revenue, tax balances, expected payout, gap, and Block, Review, or Ready effect.

Separate-tax verification 4 must keep seller-collected liability cash outside retained revenue while still explaining why it can appear inside the payout bridge before payment or remittance.

Carry refund layers: verification test 5

Create one synthetic counterexample for carry refund layers. Change one buyer-total, revenue, tax-role, refund, fee, adjustment, payout, flag, or threshold field; retain the prior packet; and show the order-total bridge, retained revenue, tax balances, expected payout, gap, and Block, Review, or Ready effect.

Separate-tax verification 5 must keep seller-collected liability cash outside retained revenue while still explaining why it can appear inside the payout bridge before payment or remittance.

separate-tax worksheet: carry refund layers: verification test 5 — Original explanatory diagram for carry refund layers: verification test 5 using invented aggregate values and no private seller data.

Calculate USD 9,600 revenue: verification test 6

Create one synthetic counterexample for calculate usd 9,600 revenue. Change one buyer-total, revenue, tax-role, refund, fee, adjustment, payout, flag, or threshold field; retain the prior packet; and show the order-total bridge, retained revenue, tax balances, expected payout, gap, and Block, Review, or Ready effect.

Separate-tax verification 6 must keep seller-collected liability cash outside retained revenue while still explaining why it can appear inside the payout bridge before payment or remittance.

Calculate USD 960 liability: verification test 7

Create one synthetic counterexample for calculate usd 960 liability. Change one buyer-total, revenue, tax-role, refund, fee, adjustment, payout, flag, or threshold field; retain the prior packet; and show the order-total bridge, retained revenue, tax balances, expected payout, gap, and Block, Review, or Ready effect.

Separate-tax verification 7 must keep seller-collected liability cash outside retained revenue while still explaining why it can appear inside the payout bridge before payment or remittance.

Carry USD 900 fees: verification test 8

Create one synthetic counterexample for carry usd 900 fees. Change one buyer-total, revenue, tax-role, refund, fee, adjustment, payout, flag, or threshold field; retain the prior packet; and show the order-total bridge, retained revenue, tax balances, expected payout, gap, and Block, Review, or Ready effect.

Separate-tax verification 8 must keep seller-collected liability cash outside retained revenue while still explaining why it can appear inside the payout bridge before payment or remittance.

Bridge USD 9,660 payout: verification test 9

Create one synthetic counterexample for bridge usd 9,660 payout. Change one buyer-total, revenue, tax-role, refund, fee, adjustment, payout, flag, or threshold field; retain the prior packet; and show the order-total bridge, retained revenue, tax balances, expected payout, gap, and Block, Review, or Ready effect.

Separate-tax verification 9 must keep seller-collected liability cash outside retained revenue while still explaining why it can appear inside the payout bridge before payment or remittance.

Close scenario: verification test 10

Create one synthetic counterexample for close scenario. Change one buyer-total, revenue, tax-role, refund, fee, adjustment, payout, flag, or threshold field; retain the prior packet; and show the order-total bridge, retained revenue, tax balances, expected payout, gap, and Block, Review, or Ready effect.

Separate-tax verification 10 must keep seller-collected liability cash outside retained revenue while still explaining why it can appear inside the payout bridge before payment or remittance.

Separate-Tax Marketplace Export Example: evidence exercise 1

Reperform open shopify fixture with invented tax-inclusive and separate-tax exports. Hold channel scope, currency, cohort dates, merchandise and shipping definition, refund maturity, fee classes, payout cutoff, rounding, and evidence controls constant where comparison requires them.

Archive the accepted packet before varying the field. Explain buyer-total reconciliation, retained revenue, net marketplace tax, net seller-tax liability, expected payout, actual payout, gap, decision, monitoring trigger, professional-review boundary, and restoration path.

The exercise remains educational and source-linked. It does not recommend tax settings, determine legal or accounting treatment, file or remit tax, access private records, or replace jurisdiction-, product-, channel-, entity-, registration-, contract-, tax-authority-, or qualified-professional review.

The separate-tax exercise at step 1 isolates export presentation and collection role rather than assuming that a visible tax column belongs to seller revenue or that a missing column means tax was not collected.

Separate-Tax Marketplace Export Example: evidence exercise 2

Reperform verify separate columns with invented tax-inclusive and separate-tax exports. Hold channel scope, currency, cohort dates, merchandise and shipping definition, refund maturity, fee classes, payout cutoff, rounding, and evidence controls constant where comparison requires them.

The separate-tax exercise at step 2 isolates export presentation and collection role rather than assuming that a visible tax column belongs to seller revenue or that a missing column means tax was not collected.

Separate-Tax Marketplace Export Example: evidence exercise 3

Reperform carry usd 10,000 revenue with invented tax-inclusive and separate-tax exports. Hold channel scope, currency, cohort dates, merchandise and shipping definition, refund maturity, fee classes, payout cutoff, rounding, and evidence controls constant where comparison requires them.

The separate-tax exercise at step 3 isolates export presentation and collection role rather than assuming that a visible tax column belongs to seller revenue or that a missing column means tax was not collected.

Separate-Tax Marketplace Export Example: evidence exercise 4

Reperform carry usd 1,000 seller tax with invented tax-inclusive and separate-tax exports. Hold channel scope, currency, cohort dates, merchandise and shipping definition, refund maturity, fee classes, payout cutoff, rounding, and evidence controls constant where comparison requires them.

The separate-tax exercise at step 4 isolates export presentation and collection role rather than assuming that a visible tax column belongs to seller revenue or that a missing column means tax was not collected.

Separate-Tax Marketplace Export Example: evidence exercise 5

Reperform carry refund layers with invented tax-inclusive and separate-tax exports. Hold channel scope, currency, cohort dates, merchandise and shipping definition, refund maturity, fee classes, payout cutoff, rounding, and evidence controls constant where comparison requires them.

The separate-tax exercise at step 5 isolates export presentation and collection role rather than assuming that a visible tax column belongs to seller revenue or that a missing column means tax was not collected.

separate-tax worksheet: separate-tax marketplace export example: evidence exercise 5 — Original explanatory diagram for separate-tax marketplace export example: evidence exercise 5 using invented aggregate values and no private seller data.

Separate-Tax Marketplace Export Example: evidence exercise 6

Reperform calculate usd 9,600 revenue with invented tax-inclusive and separate-tax exports. Hold channel scope, currency, cohort dates, merchandise and shipping definition, refund maturity, fee classes, payout cutoff, rounding, and evidence controls constant where comparison requires them.

The separate-tax exercise at step 6 isolates export presentation and collection role rather than assuming that a visible tax column belongs to seller revenue or that a missing column means tax was not collected.

Separate-Tax Marketplace Export Example: evidence exercise 7

Reperform calculate usd 960 liability with invented tax-inclusive and separate-tax exports. Hold channel scope, currency, cohort dates, merchandise and shipping definition, refund maturity, fee classes, payout cutoff, rounding, and evidence controls constant where comparison requires them.

The separate-tax exercise at step 7 isolates export presentation and collection role rather than assuming that a visible tax column belongs to seller revenue or that a missing column means tax was not collected.

Separate-Tax Marketplace Export Example: evidence exercise 8

Reperform carry usd 900 fees with invented tax-inclusive and separate-tax exports. Hold channel scope, currency, cohort dates, merchandise and shipping definition, refund maturity, fee classes, payout cutoff, rounding, and evidence controls constant where comparison requires them.

The separate-tax exercise at step 8 isolates export presentation and collection role rather than assuming that a visible tax column belongs to seller revenue or that a missing column means tax was not collected.

Separate-Tax Marketplace Export Example: evidence exercise 9

Reperform bridge usd 9,660 payout with invented tax-inclusive and separate-tax exports. Hold channel scope, currency, cohort dates, merchandise and shipping definition, refund maturity, fee classes, payout cutoff, rounding, and evidence controls constant where comparison requires them.

The separate-tax exercise at step 9 isolates export presentation and collection role rather than assuming that a visible tax column belongs to seller revenue or that a missing column means tax was not collected.

Separate-Tax Marketplace Export Example: evidence exercise 10

Reperform close scenario with invented tax-inclusive and separate-tax exports. Hold channel scope, currency, cohort dates, merchandise and shipping definition, refund maturity, fee classes, payout cutoff, rounding, and evidence controls constant where comparison requires them.

The separate-tax exercise at step 10 isolates export presentation and collection role rather than assuming that a visible tax column belongs to seller revenue or that a missing column means tax was not collected.

Sources and further reading

Etsy Help: US State Sales Tax: Official marketplace-facilitator collection, remittance, Payment account, and buyer-tax reporting context.
Etsy Help: Tax Laws Around the World: Official buyer tax, seller withholding, seller-fee tax, and government-reporting distinctions.
Shopify Help: Sales tax in Shop: Official marketplace-tax payout, refund, finance-report, filing, and professional-review context.
Shopify Help: Marketplace Connect imports: Official Withhold tax versus Send tax reporting behavior.
TikTok Ads: Gross Revenue: Official customer-payment, sales-tax, platform-discount, and Gross Revenue bridge.
Seller Profit Guard methodology: Evidence, privacy, calculation, review, correction, release, and restoration controls.

Related Seller Profit Guard tools

Marketplace-Collected Tax Separator: Separate buyer-tax roles from retained revenue and payout.
Payment Account Reconciliation: Rebuild a complete aggregate settlement bridge.
Marketplace Fee Comparison Calculator: Keep non-tax fees separate from buyer tax.
Sales Channel Contribution Calculator: Compare contribution after revenue normalization.
Methodology: Review evidence, privacy, calculation, correction, release, and restoration.
Data Privacy: Protect seller, buyer, email, order, payment, tax, bank, and raw-export data.
Marketplace-Collected Tax Separation Formula and Inputs: Define buyer total, merchandise and shipping revenue, marketplace and seller tax roles, refunds, fees, adjustments, payout, evidence, and formulas.
Tax-Inclusive Marketplace Export Example: Reperform an invented Etsy export with tax inside buyer total, then separate refunds, retained revenue, remitted tax, fees, adjustments, and payout.
Marketplace-Collected Tax Separation Mistakes: Diagnose buyer-total, tax-role, refund, fee, withholding, payout, report, timing, accounting, and interpretation errors.
Reliable Marketplace Tax Reconciliation Sources: Map order totals, tax roles, remittance flags, refunds, fees, adjustments, payouts, ownership, review, and restoration to first-party evidence.
Marketplace Tax Separation Decision Thresholds: Separate structural Block, payout Review, retained-revenue Review, narrow Ready, overrides, stop rules, monitoring, and restoration.
Compare Tax-Inclusive and Separate-Tax Exports: Align cohort, currency, revenue, tax roles, refunds, fees, adjustments, payout cutoff, and report definitions before comparing retained revenue.
Monthly Marketplace Tax Reconciliation Routine: Turn tax separation into a repeatable report, refund, settlement, payout, mapping, review, exception, monitoring, and restoration cadence.
Interpret Marketplace Tax and Retained Revenue: Read buyer total, retained revenue, marketplace tax, seller liability, expected payout, and gap without false accounting or tax claims.
Marketplace-Collected Tax Audit Template: Preserve cohort, export layout, buyer total, revenue, tax roles, refunds, flags, fees, adjustments, payout, formulas, sources, review, stop, and restoration.

Next step: Open Seller Profit Guard.

This is operational planning help, not tax, accounting, legal, financial, or platform-policy advice. Review the Terms and disclaimer, and verify current platform rules and fee assumptions before changing prices.