Ecommerce Bookkeeping: A Complete Guide

Most ecommerce store owners did not start their business because they love bookkeeping. But if your books are a mess, you will not know if you are making money until tax season, and by then it is too late to fix anything.

Ecommerce bookkeeping is different from traditional bookkeeping because the money moves through more systems: your ecommerce platform, payment processors, ad platforms, shipping providers, and sometimes marketplaces. Each one takes a cut, and each one reports numbers slightly differently.

This guide covers what you need to track, the most common mistakes, and how to keep your books accurate without spending hours in spreadsheets.

Why Ecommerce Bookkeeping Is Different

A traditional retail business has one register and one bank account. An ecommerce business might have:

• Shopify processing payments and holding funds
• Stripe or PayPal as additional payment processors
• Meta, Google, and TikTok charging ad spend from different cards
• ShipStation or a 3PL billing for shipping
• Recharge collecting subscription payments
• Amazon paying out on a 14-day cycle
• Sales tax collected in multiple states

Each of these systems generates transactions, takes fees, and sends money to your bank account on different schedules. If you just look at your bank account, you have no idea what actually happened.

What You Need to Track

Revenue (Gross and Net)

Gross revenue is the total amount customers paid before any deductions. Net revenue is what you keep after refunds, returns, and discounts.

The gap between gross and net matters. A store with $100,000 in gross revenue and a 12 percent return rate has $88,000 in net revenue. That $12,000 difference changes every profitability calculation.

Cost of Goods Sold (COGS)

This is what each product costs you to buy or make. Include:

• Purchase price from your supplier or raw material costs
• Inbound freight (shipping from supplier to your warehouse)
• Packaging materials
• Any customs or duties on imported goods

Many store owners undercount COGS by only including the purchase price. If you pay $8 for a product and $2 to ship it to your warehouse plus $0.50 for packaging, your true COGS is $10.50, not $8.

Payment Processing Fees

Every transaction costs money. Shopify Payments charges 2.4 to 2.9 percent plus $0.30 per transaction. Stripe charges similar rates. PayPal often charges more. These fees add up to thousands of dollars per month for active stores.

Ad Spend

Track ad spend by platform (Meta, Google, TikTok) and by month. This is usually your largest operating expense after COGS. You need to know your total ad spend relative to revenue to calculate your marketing efficiency.

Shipping Costs

Track both inbound shipping (supplier to you) and outbound shipping (you to customer). If you offer free shipping, the cost still exists. It just comes out of your margin instead of the customer's pocket.

Operating Expenses

Everything else: software subscriptions, warehouse rent, team payroll, contractor payments, insurance, office supplies, professional services (accountant, lawyer).

Sales Tax

If you collect sales tax, track it separately. Sales tax is not revenue. It is money you collect on behalf of the government and pass through. Mixing sales tax into your revenue numbers makes your business look bigger and more profitable than it is.

The 5 Most Common Bookkeeping Mistakes

1. Recording Shopify Payouts as Revenue

Shopify sends you a lump sum every few days. That payout is NOT your revenue. It is revenue minus fees, minus refunds, minus reserves. If you record the payout amount as revenue, your books will be wrong by the amount of all those deductions.

Fix: Record each order as individual revenue. Record fees, refunds, and reserves as separate line items.

2. Ignoring the Timing Difference

A customer orders on March 28, you get paid on April 2. Which month does that revenue belong to? Under accrual accounting (which most growing businesses should use), it belongs to March. Under cash accounting, it belongs to April.

3. Not Tracking COGS Per Product

If you have 50 products and use one average COGS number for all of them, your margin calculations are wrong. A $10 product with $3 COGS and a $10 product with $8 COGS have very different profitability. You might be promoting the wrong products.

4. Mixing Personal and Business Expenses

If your ad account is on your personal credit card, or you buy office supplies with your personal Amazon account, those transactions need to be separated and recorded in your business books. Mixing them creates tax problems and makes your P&L unreliable.

5. Reconciling Once a Year

If you only look at your books at tax time, you are 12 months behind. Problems that could have been caught in January compound through December. Reconcile monthly at minimum.

How to Set Up Your Books

Step 1: Choose Your Accounting Software

Step 2: Set Up Your Chart of Accounts

Create accounts that match how your business works:

• Revenue: Product Sales, Shipping Revenue, Subscription Revenue
• COGS: Product Costs, Packaging, Inbound Freight, Customs
• Operating Expenses: Ad Spend (by platform), Payment Processing Fees, Shipping (outbound), Software, Payroll, Rent, Professional Services
• Other: Sales Tax Payable, Refunds

Step 3: Connect Your Platforms

The fewer manual entries you make, the fewer errors you have. Connect your ecommerce platform, payment processors, and bank accounts to your accounting software. Many integration tools (like A2X for Shopify-to-QuickBooks) automate the transaction mapping.

Step 4: Reconcile Monthly

At the end of each month, make sure every bank transaction matches a record in your books. If you have unexplained differences, investigate them before moving on.

Bookkeeping vs Financial Intelligence

Good bookkeeping tells you what happened. Financial intelligence tells you what to do about it. Bookkeeping records that you spent $5,000 on Meta Ads. Financial intelligence tells you that $5,000 generated $18,000 in revenue with a 22 percent net margin, and suggests reallocating budget from your underperforming Google campaigns.

Nummbas sits on top of your bookkeeping (through QuickBooks or Xero) and your ecommerce data to give you that intelligence layer: dashboards that show real profitability, expense trends, cash flow projections, and AI-powered recommendations on where to focus.