Bookkeeping for Online Stores: Shopify, Amazon & WooCommerce

Why E-commerce Bookkeeping Is Different

Online retail creates bookkeeping challenges that brick-and-mortar stores do not face:

• Multiple sales channels - Shopify, Amazon, eBay, Etsy, and your own website all need to be tracked
• Marketplace fees - Amazon charges referral fees, FBA fees, storage fees, and advertising fees
• Payment processor fees - Stripe, PayPal, and Afterpay all take a cut
• Refunds and chargebacks - Online returns are higher than in-store
• Multi-currency - Selling internationally means dealing with exchange rates
• Inventory across locations - Stock in your warehouse, Amazon FBA, and potentially third-party logistics
• Sales tax complexity - Different rules in different states and countries

Getting these wrong does not just mean messy books - it means you do not know your true profit margins.

Setting Up Your Accounts

Revenue Structure

Track revenue by channel so you can measure profitability:

• Shopify Direct Sales
• Amazon Sales
• eBay Sales
• Wholesale Orders

Cost of Goods Sold

• Product Cost (landed cost including shipping to your warehouse)
• Packaging Materials
• Shipping to Customers
• Amazon FBA Fees
• Marketplace Referral Fees

Operating Expenses

• Platform Subscriptions (Shopify, Amazon seller account)
• Payment Processing Fees
• Advertising (Google Ads, Facebook, Amazon PPC)
• Photography and Content
• Returns Processing
• Warehouse/Storage
• Software Tools

Multi-Channel Sales Reconciliation

The Core Problem

You sell a $50 item on Amazon. Amazon charges a 15% referral fee ($7.50) and an FBA fee ($4.00). They settle the net amount ($38.50) to your bank account two weeks later as part of a lump sum with hundreds of other transactions.

Your bookkeeping needs to record:

• $50 in revenue
• $7.50 in marketplace fees
• $4.00 in fulfilment fees
• $38.50 in cash received

Multiply this by hundreds of orders across multiple platforms, and you understand why e-commerce bookkeeping is complex.

Integration Solutions

Connect each platform to Xero through dedicated integrations:

Shopify - Use the Shopify-Xero integration or a tool like A2X to sync daily sales summaries. These create invoices in Xero matching your Shopify orders, with fees broken out separately.

Amazon - A2X or Link My Books sync Amazon settlement reports to Xero. These tools decode Amazon's complex fee structure and create accurate journal entries.

eBay - Similar integrations exist for eBay, though fewer businesses rely solely on eBay today.

Daily vs Summary Recording

You have two options:

1. Individual transactions - Every order becomes a separate invoice in Xero. This is precise but creates enormous volume.
2. Daily or settlement summaries - Aggregate sales, fees, and refunds into daily or settlement-period summaries. This is more practical for most businesses.

Most accountants recommend summary recording for businesses with more than 50 orders per day. The key is that the summary accurately reflects total revenue, total fees, total refunds, and net cash received.

Inventory Accounting

Cost of Goods Sold (COGS)

COGS is one of the most important numbers in e-commerce. It tells you the direct cost of producing or acquiring the products you sold.

COGS = Opening Inventory + Purchases - Closing Inventory

Landed Cost

Your true product cost is not just what you paid the supplier. Include:

• Product purchase price
• International shipping and freight
• Customs duties and import taxes
• Inspection and quality control
• Domestic freight to your warehouse

Inventory Valuation Methods

• First In, First Out (FIFO) - Oldest stock is sold first. Most common and most conservative.
• Weighted Average - Average cost across all units. Simpler but less precise.
• Specific Identification - Track cost per unit. Only practical for high-value items.

Choose FIFO unless your accountant recommends otherwise.

Handling Refunds and Returns

Recording Refunds

When you refund a customer, record:

• A credit note or negative invoice reducing revenue
• A reversal of COGS if the item is returned to inventory
• Any restocking fees charged
• Return shipping costs if you cover them

Chargeback Accounting

Chargebacks are refunds initiated by the customer's bank. They include additional fees ($15-25 per chargeback). Record the refund as reduced revenue and the chargeback fee as a separate expense.

Return Rate Tracking

Monitor your return rate by channel. If Amazon returns are 12% and Shopify direct returns are 4%, that drastically changes the profitability comparison between channels.

Sales Tax and GST

Australia

If you sell to Australian customers and your turnover exceeds $75,000, you charge 10% GST. Exports are GST-free.

Multiple US States

If you have "nexus" (physical or economic presence) in US states, you must collect and remit state sales tax. Services like TaxJar or Avalara automate this.

International Sales

Selling internationally requires understanding each country's import duties and GST/VAT obligations. Many countries require you to register for and charge local taxes once you exceed certain thresholds.

The Automated E-commerce Setup

1. Xero as your central accounting system
2. A2X or Link My Books for Amazon and Shopify integration
3. SortBooks for automated categorisation of bank transactions
4. Inventory management tool (Cin7, TradeGecko, or DEAR) connected to Xero
5. Payment reconciliation automated through bank feeds

This setup means your multi-channel sales, marketplace fees, and bank deposits are all reconciled automatically. Your monthly review focuses on margins and trends rather than data entry.

The difference between profitable and unprofitable e-commerce businesses often comes down to knowing the true cost per unit, per channel. Automated bookkeeping gives you that visibility.