Running an e-commerce store is exciting, but the back end can get messy very fast. Orders come in from multiple marketplaces, fees are deducted before you see the money, stock lives in different warehouses or with Amazon FBA, and every state seems to have its own tax rules.
Behind all this, three bookkeeping pillars decide whether your store is truly profitable:
- How do you track inventory
- How accurately you calculate the Cost of Goods Sold (COGS)
- How do you manage sales tax in different jurisdictions
Get these wrong and your margins, cash flow, and compliance can all suffer. Get them right and you have reliable numbers for pricing, scaling, and tax planning.
Why E-commerce Bookkeeping Is Different
E-commerce bookkeeping differs from bookkeeping for a local shop. A typical online store deals with:
- Multiple sales channels such as Shopify, Amazon, eBay, Etsy, WooCommerce
- Several payment processors such as PayPal, Stripe, Shop Pay, Amazon Pay
- Platform and payment gateway fees, refunds, chargebacks, and discounts
- Inventory stored in your own warehouse, a 3PL, or FBA locations
- Sales tax or VAT obligations in multiple states or countries
Manual spreadsheets or basic bookkeeping tools usually can’t keep up with the complexity of e-commerce. It’s much more reliable to use a cloud accounting system, such as QuickBooks Online or Xero, connected to your e-commerce platforms through dedicated apps that feed sales, fees, taxes, and inventory into your books in a structured manner.
Understanding COGS for E-commerce
COGS is the total direct cost of the products you actually sell in a period. It is what you spend to get items ready for sale, not your overheads. Getting COGS right is critical because:
- Gross profit = Sales revenue minus COGS
- Pricing decisions depend on accurate gross margins
- Misstated COGS can make a healthy business look unprofitable
The standard formula is:
COGS = Beginning Inventory + Purchases − Ending Inventory
For e-commerce, COGS usually includes:
- Product purchase cost from your supplier or manufacturer
- Inbound shipping and freight
- Customs duties and import fees
- Packaging that ships with the product
- Certain fulfillment costs that are directly tied to each unit
Many sellers forget to include shipping and handling in COGS, which inflates profit on paper. Good bookkeeping ensures all these costs are tracked and allocated correctly so your product level margins are real, not optimistic.
Inventory Tracking and Valuation
Inventory is often the largest asset on an e-commerce balance sheet. Poor tracking leads to:
- Stockouts and lost sales
- Overstocking and cash locked in slow movers
- Wrong COGS because the system does not know what was sold at what cost
Most accounting platforms support common valuation methods such as FIFO, LIFO, weighted average, and specific identification. Choosing the right method and applying it consistently is important for accurate reporting and, in some jurisdictions, for tax purposes.
Best practices for e-commerce inventory bookkeeping include:
- Using item-level tracking for every SKU rather than generic categories
- Recording landed cost that includes product, freight, and related charges
- Using inventory or order management tools once you cross a certain volume or revenue threshold
- Regular stock counts and adjustments to match physical and book inventory
When you connect inventory systems and marketplaces properly, the accounting system can automatically move costs from Inventory Asset to COGS each time a sale is recorded, which keeps both your balance sheet and income statement in sync.
Using Software Integrations To Tie It All Together
Modern e-commerce bookkeeping is built around integrated software. Instead of recording every order by hand, you connect:
- Shopify, Amazon, eBay, Etsy and other channels
- Payment processors
- Inventory or order management tools
- Your accounting system, such as QuickBooks or Xero
Apps like Webgility, A2X, Link My Books and similar connectors summarise sales, fees, refunds, taxes, and payouts and post them into the accounting system in a clean format. This reduces manual data entry, improves accuracy, and makes reconciliation faster.
Put simply, e-commerce bookkeeping works best when your sales channels, inventory tools, and accounting software are in constant sync, not talking to each other once a month through CSV files.
A Practical Framework For E-Commerce Bookkeeping
Here is where we bring the key elements together in plain language, based on what successful online sellers do in practice.
E-commerce bookkeeping needs very precise tracking of inventory-related costs. That includes the purchase price of each product, the shipping and handling you pay to bring stock in, and platform or fulfillment fees that should be treated as part of your selling costs. At the same time, you are dealing with complex sales tax rules across different states or regions, especially once you cross economic nexus thresholds.
For most brands, this is best handled with integrated accounting software such as QuickBooks, paired with e-commerce plugins and connectors that:
- Pull orders and payouts from every sales channel in real time
- Sync inventory quantities and cost data
- Capture fees, discounts, and taxes in the right accounts
- Produce accurate financial reports that show true profitability and compliance
A clean workflow usually includes these steps:
- Design a clear chart of accounts
- Separate income accounts for each sales channel
- Dedicated COGS accounts for product cost, inbound freight, and fulfillment
- Separate accounts for platform fees, payment fees, and advertising
- Integrate every sales channel
- Connect Shopify, Amazon, eBay, Etsy and others to your accounting system through a connector
- Use daily or payout-based summaries instead of pushing every single order line
- Automate data flow wherever possible
- Avoid manual imports or one-off spreadsheets
- Let apps post sales, COGS, fees, and taxes automatically
- Reconcile on a fixed schedule
- Match bank feeds and merchant payouts to accounting entries
- Reconcile sales per marketplace, payment gateway balances, and inventory quantities
- Review where you have tax nexus and confirm that sales tax is being collected and remitted correctly
When you follow this kind of structured approach, you get reliable numbers for each channel and can see which products, markets, or platforms are truly profitable.
Sales Tax Management For E-Commerce Stores
Sales tax has become one of the most complicated parts of e-commerce bookkeeping. Since the South Dakota v. Wayfair decision, many states in the United States have applied economic nexus rules. This means you can be required to collect and remit sales tax in a state even if you have no physical presence there, once your sales cross a revenue or transaction threshold.
Key concepts for e-commerce retailers include:
- Sales tax nexus
Nexus is the level of connection with a state that creates a sales tax obligation. It can result from physical presence, such as warehouses or staff, or from economic activity, such as a certain level of online sales. - Thousands of tax jurisdictions
In the United States alone, there are more than 12,000 state, county, and local tax jurisdictions, each with potential rate and rule differences. Trying to apply the correct tax rate manually for each location quickly becomes unmanageable once you scale. - Marketplace and direct sales
Marketplaces like Amazon may collect and remit sales tax on marketplace-facilitated sales, but you can still be responsible for tax on direct sales from your own site and for correct reporting.
Best practices for e-commerce sales tax bookkeeping include:
- Determine the states or regions where you have nexus.
- Register for sales tax permits before collecting tax.
- Configure tax settings correctly in each sales channel.
- Use a sales tax automation tool or integrated solution to calculate, track, and file returns.
- Reconcile the collected tax in your accounting system to what is paid to tax authorities.
When your bookkeeping is set up correctly, sales tax collected in each state sits in a liability account, separate from your revenue, until you file and pay it. This keeps your cash position honest and avoids surprises.
Multi-Channel Inventory, COGS, and Fees
Many e-commerce businesses sell on more than one platform. This adds extra complexity for bookkeeping because:
- Each channel has its own fee structure and payout schedule
- Returns and chargebacks may appear in different periods from the original sales
- Some channels ship from your own stock, while others ship from their own warehouses
To handle this, your bookkeeping should:
- Track revenue, COGS, and fees by channel so you can compare margins
- Use integration tools that break payouts into sales, refunds, fees, and taxes instead of booking the net deposit only
- Standardise SKU codes across platforms so inventory and COGS stay aligned
- Reconcile marketplace statements, payment processor reports, and bank deposits every month
This is where a dedicated ecommerce bookkeeping process really pays off, because it turns confusing payout reports into clear financial statements you can act on.
When To Outsource Bookkeeping For Your E-commerce Store
Many founders start by doing the books themselves or asking a local accountant to help. That can work for a small, single-channel store. It becomes risky once you have:
- Multiple marketplaces and your own website
- High monthly transaction volumes
- Stock spread across warehouses, 3PLs, and FBA centers
- Sales tax obligations in several states or countries
- Investors, lenders, or tax authorities asking for clean financials
At that stage, it is often more effective to Outsource Bookkeeping Services to a specialist team that understands e-commerce tools, integrations, and tax rules.
A partner like Outsourcing Business Solutions can:
- Set up or clean up your accounting system and chart of accounts for e-commerce
- Configure integrations between your sales channels and QuickBooks or other software
- Track inventory and COGS correctly so you know product and channel-level margins
- Monitor sales tax exposure and keep your filings on schedule
- Work alongside your CPA or tax preparer so year-end is smoother and less stressful
You get the benefit of an experienced e-commerce bookkeeping team without the cost of building one in-house, while you stay focused on marketing, product, and customer experience.
Conclusion
Bookkeeping for e-commerce stores is not just about recording sales. It is about:
- Tracking inventory and COGS accurately so your margins are real
- Managing multi-channel payouts and fees so your cash flow is clear
- Staying on top of sales tax nexus and filings so your growth is compliant
With the right systems and workflows, you can see exactly which products, campaigns, and markets are working and scale your store with confidence.
If you feel your numbers are not matching your bank balance, or you are unsure how tax in different states affects you, it may be time to streamline your backend. Instead of trying to do everything yourself, consider whether it is the right moment to Outsource Bookkeeping Services and let a specialist ecommerce team keep your books accurate, timely, and ready for growth.
