What bookkeeping records should ecommerce sellers keep for sales tax filings?
Sales tax filings come down to documentation. If your records can’t show what you sold, where, and how much tax was collected, you can’t defend the numbers on your returns. Ecommerce sellers need cleaner records than most businesses because sales happen across multiple states, platforms, and tax rules at once.
Start with sales by state. Every state where you have nexus needs its own breakdown showing gross sales, taxable sales, exempt sales, and tax collected. Economic nexus thresholds vary, so you also need totals for states where you’re close to triggering a filing requirement. Without state-level detail, you can’t file accurately and you can’t tell when a new state needs to be added.
Separate marketplace sales from direct sales. Marketplaces like Amazon, Etsy, and Walmart collect and remit sales tax on your behalf in most states under marketplace facilitator laws. Those sales still need to be reported on your returns in many states, just as non-taxable or already-collected sales. Direct sales through Shopify, WooCommerce, or your own site are your responsibility to collect and remit. Mixing them together creates filings that overpay or underpay.
Keep tax collected amounts tied to each transaction. The tax you collect is not revenue. It’s a liability you hold until you remit it. Your books should show tax collected as a separate liability account, not buried in sales income.
Save exempt and resale certificates for every customer claiming exemption. If you sell wholesale or to nonprofits, you need a valid certificate on file before you skip collecting tax. States can come back years later asking for proof. No certificate means you owe the tax yourself.
Track refunds and returns carefully because they reduce taxable sales and the tax you owe. If you refunded a customer in a later filing period, you need to adjust the right state’s return.
Shipping charges are taxable in some states and not in others. Your records should separate shipping revenue from product revenue so the right portion gets taxed in each jurisdiction.
Pull TaxJar reports monthly and reconcile them against platform payout reports from Shopify, Amazon, Stripe, and any other channel you use. The payout reports show what actually hit your bank. TaxJar shows what should have been collected. Differences point to setup issues or missed transactions.
Most ecommerce sellers benefit from sales tax management that handles the monthly reconciliation between platforms and filing software. The work of compiling state-by-state numbers, matching payouts to sales, and tracking exemption certificates is where mistakes happen. A firm offering bookkeeping, tax, and consulting services built for ecommerce keeps these records organized throughout the year so filings are routine instead of a scramble each month.
Trusted Accounting for Small Businesses
First Step:
Start With a Call
Tell us about your business and what you need help with. We'll ask a few questions, evaluate your current situation, and let you know how GMJ can support your books, taxes, and day-to-day operations.
More Questions
What financial information should a nonprofit treasurer organize before handing off duties?
A clean treasurer handoff includes bank and software access, current reconciliations, the chart of accounts, grant files, donor restriction records, payroll and vendor documentation, board minutes, and the most recent Form 990.
Read answerWhen does a South Carolina ecommerce seller need to collect sales tax?
South Carolina requires remote sellers to collect sales tax once they exceed $100,000 in gross revenue from sales into the state during the current or previous calendar year. Physical presence in the state triggers the requirement immediately.
Read answerWhat tax strategy questions should a small business ask before year-end?
Year-end is when tax decisions actually move the needle. After December 31, most options are gone. The right questions cover entity structure, estimated payments, retirement contributions, depreciation, inventory, payroll, owner compensation, and whether you have cash to pay the bill.
Read answerHow can tax planning change when an owner is choosing LLC, S corp or partnership treatment?
Entity choice changes how income flows to your personal return, how much self-employment tax you pay, and what compensation rules apply. Each structure has trade-offs around payroll, distributions, basis tracking, and state filings that shape your planning every year.
Read answerHow should tips be recorded for restaurant bookkeeping and payroll?
Tips need to be tracked by type: credit card tips, cash tips, service charges, and tip pool distributions. Pull POS tip reports daily, reconcile them against cash deposits and payroll, and keep service charges separate since they're revenue, not tips.
Read answerWhat bookkeeping issues show up when a medical practice opens a second location?
Opening a second location forces you to track everything by location, allocate shared payroll and overhead correctly, match insurance deposits to the right office, and forecast cash flow for a site that will likely run at a loss for months before turning profitable.
Read answer