E-Commerce Accounting Guide for New Online Sellers: Shopify, Etsy, Amazon
Starting an online store on Shopify, Etsy, or Amazon can be exciting. But getting your money straight often feels like a puzzle. Your sales platform (like Shopify), your payment processor (like Stripe or Etsy Payments), and your bank account all tell different stories. Shopify shows your full sales. Stripe deposits a net amount after fees. And your bank just sees what landed. Matching these numbers correctly is key to knowing your true profit. This simple guide will show you how to set up your e-commerce accounting without the headaches.
READY TO TAKE ACTION?
Use the free LaunchAdvisor checklist to track every step in this guide.
Quick Fix: How to Set Up Your Online Store Books
For Shopify-only sellers: Connect Shopify to QuickBooks Online or Xero using an app like A2X or Link My Books. This automatically matches your sales, fees, and refunds to what hits your bank.
For Amazon sellers (FBA or FBM): Use A2X for Amazon to break down those complicated settlement payouts into clear sales and fees.
For Etsy sellers: Etsy has its own payment system. While direct integrations are fewer, tools like Craftybase can help with inventory, and you can still use A2X if you also sell on Shopify/Amazon. Manual entry or simplified reports often work best for early Etsy growth.
For multi-channel sellers (e.g., Shopify + Etsy): You need a single system that can handle all platforms. A good cloud accounting platform with specific integrations is key.
Why Online Store Accounting Is Tricky (and How to Fix It)
Platform payouts are not your total sales. When Shopify, Etsy, or Amazon sends money to your bank, that payment is what's left after they take out fees, handle refunds, and sometimes hold money aside. If you record this deposit as your total sales, you're making your sales look higher than they are and hiding your real costs.
Inventory timing creates issues. If you buy handmade supplies in spring for items sold on Etsy in summer, or send products to Amazon FBA in Q3 that sell in Q4, you need to track when the *cost* of the product actually impacts your profit. This is called Cost of Goods Sold (COGS) and it's vital for knowing your true margins.
Sales tax rules change by state. If your online store sells enough in a state (often $100,000 in sales or 200 orders), you might have 'economic nexus.' This means you need to collect and send sales tax to that state. The rules are different everywhere.
Shopify Store Accounting: Getting the Basics Right
Do not record Shopify payouts directly as your total sales. Instead, record the full sales amount when a customer places an order. Then, separately record Shopify fees, payment processing costs (like Stripe fees), and refunds. Use the bank payout only to make sure everything matches up, not as your income record.
Shopify connects well to accounting software like QuickBooks Online and Xero. Apps like A2X or Link My Books ($19-$59/month for most small sellers) automatically pull your Shopify data, break down fees, and send it to your accounting system in a clean way.
Tax compliance: Shopify Tax helps you calculate and collect sales tax in most states. But you still need to send that collected money to the right states. Tools like TaxJar or Avalara can automate this monthly or quarterly filing process.
Amazon Seller Accounting: Beyond the Settlement Report
Amazon pays you every two weeks through a 'settlement report.' This single payment includes many things: product sales, FBA fees, referral fees, advertising costs, refunds, money Amazon gave you back for lost items, and even money they hold temporarily. Recording this entire settlement as your income is a big accounting mistake for Amazon sellers.
A2X for Amazon is essential here. It reads Amazon's complex settlement report and turns it into a clear list of entries for your accounting software. It maps each item (like a sale, an FBA fee, or an ad cost) to the correct account. This is the best way for Amazon sellers to keep accurate books.
COGS for FBA sellers: When you send products to an Amazon FBA warehouse, the cost of those items isn't an expense yet. It only becomes an expense (Cost of Goods Sold) when a customer buys the product. Most basic accounting software requires you to manually adjust your inventory and COGS for FBA, or use a more advanced inventory tool.
Selling Everywhere? Multi-Channel Accounting Made Simple
If you sell on Shopify, Etsy, Amazon, and even locally at markets, your accounting gets more complex. The main goal is to have one clear system. Think of each sales channel as a separate source of income with its own set of fees. Don't try to force different platform reports into the same messy categories.
For smaller multi-channel sellers, start by using A2X for your main platforms (Shopify, Amazon) and then integrate Etsy as best you can (sometimes manually for basic Etsy reports if sales volume is low). Use a cloud accounting platform like Xero, which is great for handling different money types. As you grow, consider inventory and order management tools like Extensiv (formerly Skubana) or Linnworks, which feed into your accounting system.
Your Go-To Accounting Setup for Online Selling
For Shopify-only (under $5,000-$10,000/month): Shopify + A2X or Link My Books + QuickBooks Online or Xero.
For Etsy-only (growing): Etsy + Craftybase (for inventory and COGS) + QuickBooks Online or Xero. You may need more manual entry for Etsy’s specific reports initially.
For Amazon-only: Amazon Seller Central + A2X + QuickBooks Online or Xero.
For Multi-channel (e.g., Shopify + Etsy + Amazon): Start with A2X for each major channel + QuickBooks Online or Xero. Look into an inventory management tool as you grow.
Add TaxJar or Avalara for sales tax compliance once your sales reach meaningful levels across different states.
Your First Steps to Clean E-Commerce Books
Step 1: Pick your accounting software. QuickBooks Online or Xero are the top choices. Xero is often better if you plan to sell internationally or need strong multi-channel features.
Step 2: Set up your chart of accounts. This means creating separate income accounts for 'Shopify Sales,' 'Etsy Sales,' and 'Amazon Sales.' Also, create separate expense accounts for 'Shopify Fees,' 'Etsy Fees,' 'Amazon Fees,' 'Payment Processing Fees,' and 'Shipping Costs.' This shows you where your money comes from and where it goes.
Step 3: Connect A2X to your Shopify and/or Amazon accounts. If you're on Etsy, look for specific Etsy integrations for your chosen accounting software, or plan to use Etsy's monthly CSV reports.
Step 4: Reconcile your first month manually alongside the automation. This helps you check if the automated setup is correct and builds trust in your new system.
Step 5: If your sales are growing fast (e.g., consistently over $5,000/month or selling to many states), set up TaxJar or Avalara and register for sales tax in any new states where you have nexus.
RECOMMENDED TOOLS
Xero
Cloud accounting built for product businesses
QuickBooks Online
30-day free trial, then from $35/month
Some links above are affiliate links. We may earn a commission if you sign up — at no extra cost to you.
FREQUENTLY ASKED QUESTIONS
Do I need to track inventory in my accounting software?
If you carry physical inventory, yes — GAAP requires it and your gross margin calculation depends on it. QuickBooks Online Plus and Xero both include inventory tracking. For higher volume or multi-warehouse operations, dedicated inventory management software (Extensiv, Cin7) syncs with your accounting platform.
How does sales tax nexus work for online sellers?
Economic nexus was established by the 2018 South Dakota v. Wayfair Supreme Court ruling. Most states now require online sellers to collect and remit sales tax if they exceed $100,000 in sales or 200 transactions in that state annually. You are not required to collect until you hit the threshold, but once you do, you need to register and remit.
Can I use cash-basis accounting for my e-commerce business?
Yes, if your annual gross receipts are under $25M (the IRS threshold requiring accrual for most businesses). Cash-basis is simpler but can distort your understanding of profitability when you carry significant inventory. Most growing e-commerce businesses benefit from switching to accrual by $500K in annual revenue.