How do I ensure my ecommerce bookkeeping with marketplace accounting is compliant with sales tax nexus rules?

To keep ecommerce bookkeeping and marketplace accounting compliant with sales tax nexus rules, you need a process that ties together where you have nexus, who is responsible for collecting tax, and how the tax is recorded in your books.

Here’s a practical framework:

1) Know where you have nexus

Sales tax nexus can be created by:

• Physical presence: office, warehouse, employees, inventory, contractors in a state
• Economic nexus: exceeding a state’s sales/revenue threshold
• Marketplace nexus / marketplace facilitator rules: the marketplace may collect and remit tax for your sales, depending on the state
• Affiliate/other nexus rules: varies by state

Action: Maintain a state-by-state nexus matrix that tracks:

• States where you’re registered
• Why nexus exists
• Date nexus started
• Registration number
• Filing frequency
• Thresholds and current trailing 12-month sales

2) Determine whether the marketplace is collecting tax

For platforms like Amazon, Walmart, Etsy, eBay, etc.:

• In many states, the marketplace facilitator collects/remits sales tax on eligible marketplace sales
• In some cases, you may still need to collect tax on:
  • Non-marketplace sales (your own website)
  • Excluded items
  • States where marketplace rules are different
  • Direct fulfillment orders or special situations

Action: For each channel, document:

• Whether tax is collected by the marketplace
• Which states are covered
• Whether sales are taxable, exempt, or partially taxable
• What reports the marketplace provides

3) Separate “tax collected by marketplace” from “tax you owe”

In bookkeeping, the key is not to double count or understate tax.

Typical treatment:

• Marketplace-collected tax is usually not your revenue
• It should generally be recorded separately from sales revenue and matched to marketplace settlement reports
• If the marketplace remits tax directly, you may not show that tax as a liability on your books unless your accounting method requires a clearing account for reconciliation

Best practice: Use a sales tax clearing account or separate liability accounts so you can reconcile:

• Gross sales
• Discounts/refunds
• Shipping
• Marketplace fees
• Tax collected by channel/state
• Tax remitted by you

4) Configure bookkeeping by state and channel

Your chart of accounts and reporting should let you track:

• Sales by state
• Taxable vs. non-taxable sales
• Marketplace vs. direct-to-consumer sales
• Collected tax vs. remitted tax
• Refunds/returns and tax adjustments

Action: Use class/location/state tags or separate accounts to support nexus reporting and audit trails.

5) Reconcile marketplace settlements monthly

Marketplace settlement reports often bundle:

• Product sales
• Shipping
• Returns
• Fees
• Promotions
• Tax collected
• Tax remitted/withheld

Action: Reconcile each settlement to your books monthly:

• Match gross sales to settlement data
• Confirm tax collected aligns with state rules
• Verify returns reduce taxable sales correctly
• Ensure fees don’t get mixed into revenue
• Investigate discrepancies immediately

6) Register and file where required

If you have nexus in a state:

• Register for a sales tax permit before or as soon as required
• File returns on the correct schedule
• File even if marketplace sales are tax-collected by the facilitator, if the state still requires reporting or you have other taxable sales

Important: Marketplace collection doesn’t always eliminate your filing obligations.

7) Handle exempt sales correctly

If you sell exempt products or to exempt buyers:

• Keep exemption certificates when required
• Validate customer exemptions
• Track exempt marketplace orders separately if the platform allows it

8) Watch for inventory and fulfillment impacts

Using FBA/3PL warehouses can create nexus in states where inventory is stored.

Action: Track:

• Where inventory is held
• When inventory is moved
• Warehouse/3PL locations
• Employee/contractor locations

9) Automate tax determination and bookkeeping where possible

Consider using:

• Sales tax automation software
• Ecommerce accounting integrations
• Inventory/fulfillment syncing
• Nexus monitoring tools

These can help you:

• Identify new nexus states
• Correctly map tax rates
• Reduce manual errors
• Improve audit readiness

10) Keep documentation for audits

Retain:

• Marketplace settlement reports
• Sales tax returns
• Exemption certificates
• Nexus threshold calculations
• Registration certificates
• Tax configuration screenshots/rules
• Inventory location records

Common mistakes to avoid

• Assuming marketplace sales never create filing obligations
• Recording marketplace-collected tax as revenue
• Not reconciling settlements to books
• Forgetting nexus from inventory storage
• Missing economic nexus thresholds
• Not tracking exempt sales separately
• Failing to update for state law changes

A simple compliance workflow

1. Track nexus by state monthly
2. Identify tax responsibility by channel/state
3. Configure accounting to separate tax from revenue
4. Reconcile marketplace settlements every month
5. File returns in all required states
6. Maintain records for audit support

If you want, I can also give you:

• a sample nexus tracking spreadsheet
• a bookkeeping chart of accounts setup for ecommerce
• or a month-end reconciliation checklist for Amazon/Etsy/Walmart sales tax