E-commerce Bookkeeping Made Simple

If you run an e-commerce business, you already know the bookkeeping is nothing like a traditional brick-and-mortar shop. You’re juggling sales from three or four platforms, tracking inventory across warehouses, calculating fees that eat into every transaction, and trying to figure out which states you owe sales tax to this quarter.

The average e-commerce seller spends 8-12 hours per month on bookkeeping — and most of them still aren’t confident their books are right. That’s because e-commerce bookkeeping has unique challenges that generic accounting tools weren’t designed to handle.

BookkeepingFlow was built for exactly this. Here’s how we take the complexity out of ecommerce bookkeeping so you can focus on growing your store.

The Unique Challenges of E-commerce Bookkeeping

Multi-Channel Sales Create Multi-Channel Chaos

Most e-commerce businesses sell on more than one platform. Maybe you started on Etsy, expanded to Shopify, and now you’re also on Amazon. Each platform has its own dashboard, its own transaction format, and its own payout schedule.

Here’s what that looks like in practice: You sell a $45 product on Amazon on Tuesday. Amazon takes a $6.75 referral fee, a $5.40 FBA fee, and charges $0.30 for the shipping label. They batch that transaction with 47 others and deposit a lump sum in your bank account on Friday. Meanwhile, a customer on Shopify buys the same product, pays via Shop Pay, and you see that deposit show up the next business day — minus Shopify’s 2.9% + $0.30 processing fee.

Now multiply that by hundreds of transactions per month, and you can see why reconciliation becomes a nightmare. BookkeepingFlow solves this by syncing directly with every major platform and pulling in transaction-level data — not just the batched deposit amounts. Every sale, fee, and payout is matched automatically.

Inventory and COGS: The Numbers That Actually Matter

Revenue is vanity. Cost of goods sold (COGS) is sanity. If you don’t know your true COGS, you don’t know your true profit — and you’re probably making pricing decisions based on bad data.

COGS for e-commerce includes:

• Product cost — what you paid your supplier per unit
• Inbound shipping — freight, duties, and customs fees to get inventory to your warehouse
• Warehousing — storage fees (especially Amazon FBA storage fees, which change seasonally)
• Packaging — boxes, mailer bags, branded inserts, tape
• Shrinkage — damaged, lost, or expired inventory

BookkeepingFlow tracks COGS at the SKU level using your chosen accounting method. When you receive a shipment from your supplier, log the landed cost and we’ll automatically calculate COGS every time that product sells — across every channel. If you’re learning the basics of tracking business finances, our guide on how to do bookkeeping for a small business covers the fundamentals.

Example: You sell phone cases. You buy them from your supplier at $4.50 each, pay $0.80 per unit for shipping from China, and spend $0.40 on branded packaging. Your true COGS per unit is $5.70 — not $4.50. On a $24.99 selling price, that’s the difference between thinking you have a 82% margin and knowing you have a 77% margin. At 500 units per month, that “small” difference is $375 in phantom profit.

Sales Tax Nexus: The Hidden Compliance Burden

Sales tax nexus is one of the most confusing parts of running an e-commerce business. Since the 2018 South Dakota v. Wayfair Supreme Court decision, states can require you to collect and remit sales tax even if you have no physical presence there — as long as you exceed their economic nexus threshold.

Here’s the simplified version: If you sell enough into a state, you owe that state sales tax.

Most states set thresholds at either $100,000 in sales or 200 transactions per year, but it varies. Texas uses $500,000. California uses $500,000. New York uses $500,000 and 100 transactions. Some states count marketplace sales (where the marketplace collects tax for you), and others don’t.

BookkeepingFlow monitors your sales by state in real time. When you’re approaching a nexus threshold, we alert you. When you cross it, we help you register and start calculating the correct rates — down to the city and county level, because yes, sales tax rates vary within states too. No more spreadsheets tracking state-by-state totals. No more surprise tax bills.

Marketplace Fees Are Eating Your Margins

Amazon alone has more than a dozen fee types: referral fees, FBA fulfillment fees, monthly storage fees, long-term storage fees, removal fees, advertising fees, return processing fees, and more. Each one needs to hit the right line item on your books.

When you categorize all marketplace fees into a single “Amazon fees” bucket, you’re hiding critical data. BookkeepingFlow breaks every fee into its proper expense category — advertising, fulfillment, storage, payment processing — so you can see exactly where your money goes and make smarter decisions. Many of these fees qualify as small business tax deductions, but only if they’re categorized correctly.

Returns and Refunds Distort Your Revenue

E-commerce return rates typically run between 15% and 30%, depending on your product category. Apparel is closer to 30%. Electronics hover around 15%. That means for every $100,000 in gross sales, you might process $15,000 to $30,000 in returns.

Each return triggers a cascade of bookkeeping entries: revenue reversal, COGS adjustment, possible restocking fee, return shipping cost, and potentially a damaged/unsellable inventory write-off. If you’re not matching returns to original orders, your monthly revenue and COGS numbers are wrong.

BookkeepingFlow automatically matches every refund to its original transaction, reverses the revenue, adjusts COGS (if the item is returned to sellable inventory), and logs any associated fees. Your P&L always reflects reality.

Payment Processor Reconciliation

Stripe batches payouts. PayPal holds funds. Amazon settles every two weeks (or daily, depending on your account). Shop Pay deposits on its own schedule. Every processor groups transactions differently, making it almost impossible to match your bank statement to individual orders.

BookkeepingFlow reconciles at the transaction level, not the deposit level. We break every batched bank deposit back into its component orders, fees, and adjustments — so your books balance down to the penny.

How BookkeepingFlow Solves E-commerce Bookkeeping

Shopify Integration

BookkeepingFlow connects directly to your Shopify store via API. We pull in:

• Every order (including line items, discounts, and taxes collected)
• Shopify Payments payout reports (matched to individual orders)
• Refunds and exchanges (linked to original orders)
• Transaction fees and Shopify subscription charges
• Third-party payment gateway data (PayPal, Stripe, etc.)

Setup takes about 3 minutes. Once connected, your Shopify data flows in automatically — no CSV exports, no manual imports.

Amazon Seller Integration

Amazon’s settlement reports are notoriously hard to read. BookkeepingFlow parses them automatically:

• Product sales broken out by SKU and marketplace
• FBA fees separated into fulfillment, storage, and removal categories
• Advertising spend (Sponsored Products, Brands, Display) pulled from your ad console
• Reimbursements for lost or damaged FBA inventory
• Returns and refund adjustments

We also reconcile Amazon’s bi-weekly (or daily) deposits against the itemized settlement data so nothing falls through the cracks.

WooCommerce Integration

For self-hosted WooCommerce stores, BookkeepingFlow integrates via the WooCommerce REST API:

• Order data including product, shipping, and tax line items
• Payment gateway transaction records (Stripe, PayPal, Square)
• Refund and cancellation records
• Subscription renewal data (if you use WooCommerce Subscriptions)

Because WooCommerce gives you more raw data access than hosted platforms, our integration is especially granular — you get full visibility into every aspect of every transaction. If you’ve been using QuickBooks to manage your WooCommerce store’s finances, you might find that a purpose-built alternative handles the data flow much more smoothly.

Sample Monthly P&L for an E-commerce Business

Here’s what a typical monthly profit and loss statement looks like for a mid-size e-commerce seller doing about $50,000/month in revenue across Shopify and Amazon. BookkeepingFlow generates this automatically.

Revenue

Line Item	Amount
Shopify gross sales	$28,500
Amazon gross sales	$24,200
Less: returns & refunds	($5,270)
Net Revenue	$47,430

Cost of Goods Sold

Line Item	Amount
Product cost (landed)	$14,800
Packaging & shipping materials	$1,420
Inbound freight	$980
Inventory shrinkage/write-offs	$340
Total COGS	$17,540

Gross Profit: $29,890 (63.0% margin)

Operating Expenses

Line Item	Amount
Amazon referral fees	$3,630
Amazon FBA fulfillment fees	$2,900
Amazon storage fees	$480
Shopify subscription + apps	$380
Payment processing (Stripe/PayPal)	$1,190
Shipping (Shopify orders)	$2,850
Advertising (Amazon PPC + Meta)	$4,200
Software & tools	$320
Returns processing & restocking	$410
Virtual assistant / contractor labor	$1,500
Total Operating Expenses	$17,860

Net Profit: $12,030 (25.4% net margin)

This seller’s books show that Amazon’s higher fees (referral + FBA = $6,530) significantly cut into margins compared to Shopify’s direct-to-consumer channel. Without this level of detail, they might not realize that their Amazon channel is 12 percentage points less profitable than Shopify — which could change how they allocate ad spend.

BookkeepingFlow generates this breakdown every month, automatically, with no manual data entry.

COGS Tracking Methodology

Getting COGS right is the single most impactful thing you can do for your e-commerce books. Here’s how BookkeepingFlow handles it:

Step 1: Log Your Landed Cost

When you receive inventory, you enter (or we import from your supplier invoice) the per-unit cost including the product price, shipping, duties, and any other costs to get the product to your warehouse. This is your landed cost — the true cost of each unit.

Step 2: Choose Your Cost Method

• FIFO (First In, First Out): The oldest inventory is “sold” first. Best for most e-commerce businesses, especially if your costs change over time.
• LIFO (Last In, First Out): The newest inventory is sold first. Less common for e-commerce but useful in some scenarios.
• Weighted Average: Averages the cost of all units in stock. Simple and effective if your costs are relatively stable.

Step 3: Automatic COGS Calculation

Every time a sale occurs — on any channel — BookkeepingFlow calculates COGS based on your chosen method and the current inventory cost data. This happens in real time, not at month-end.

Step 4: Return Adjustments

When a customer returns an item, BookkeepingFlow checks whether it’s going back into sellable inventory. If yes, COGS is reversed. If the item is damaged and written off, COGS stays recognized and we log the write-off separately.

Getting Started Takes 10 Minutes

Here’s the quick-start path for e-commerce sellers:

1. Connect your sales channels — Shopify, Amazon, WooCommerce, Etsy, or eBay. Each connection takes 2-3 minutes.
2. Link your bank accounts and payment processors — Stripe, PayPal, and your business bank account.
3. Import your product catalog and costs — Upload a CSV or connect to your inventory management system.
4. Let AI categorize your historical transactions — BookkeepingFlow reviews your last 12 months of data and categorizes everything with 95%+ accuracy.
5. Review and approve — Spot-check the AI’s work, make any corrections, and you’re running.

From that point forward, every transaction is automatically imported, categorized, and reconciled. Monthly reports, COGS calculations, and sales tax tracking happen in the background.

Ready to see what stress-free ecommerce bookkeeping looks like? Check out our pricing plans to find the right fit for your store size and sales volume.