Ecommerce Bookkeeping: The Complete Guide for Online Sellers

What Is Ecommerce Bookkeeping — and Why Is It Different?

Ecommerce bookkeeping is the process of recording, categorizing, and reconciling all financial transactions that flow through your online store or marketplace accounts. On the surface it sounds like regular bookkeeping, but the mechanics are fundamentally different from a brick-and-mortar business.

When a customer buys from your physical store, you receive cash or a card payment, and you record revenue. Simple. When a customer buys from your Amazon listing, you don't receive money immediately — Amazon collects the payment, deducts referral fees, FBA fulfillment fees, storage fees, promotional discounts, and reimbursements, then sends you a net payout every two weeks. That payout might be for transactions that occurred 14–21 days earlier. It's not revenue — it's a settlement.

This mismatch between gross sales and net payouts is the core challenge of ecommerce bookkeeping. Most bookkeepers (and many sellers) record only the payout deposit, which means their profit and loss statement shows far less revenue and expense than actually occurred. The result: inaccurate financials, incorrect tax filings, and a P&L that doesn't reflect the real health of the business.

This guide covers everything you need to do ecommerce bookkeeping correctly — from setting up your chart of accounts to reconciling monthly settlements and choosing the right tools.

The Core Challenge: Settlement Reports

Every major marketplace produces a settlement report (or payout report) at the end of each payment period. These reports contain dozens of line items:

• Gross sales — the full price customers paid
• Returns and refunds — amounts credited back to customers
• Marketplace fees — referral fees, fulfillment fees, listing fees, subscription fees
• Promotions and discounts — coupon redemptions, lightning deals
• Reimbursements — Amazon reimbursing you for lost or damaged inventory
• Tax collected — sales tax that the marketplace collected and remitted on your behalf
• Net payout — what you actually receive in your bank account

All of these items must be recorded separately in your books. The net payout goes to your bank account, but you must also recognize the gross sales as revenue, and each fee category as the appropriate expense.

Here's a simplified example for an Amazon settlement:

Account	Debit	Credit
Checking Account	$8,247.15
Amazon Referral Fees	$1,102.40
Amazon FBA Fees	$834.70
Refunds Issued	$312.50
Sales Tax Payable		$247.80
Sales Revenue		$10,249.75

Total debits: $10,497.55. Total credits: $10,497.55. Balanced.

If you only recorded the $8,247.15 payout, your revenue would be understated by $2,002.60 and your expenses would be missing entirely.

Setting Up Your Ecommerce Chart of Accounts

The foundation of ecommerce bookkeeping is a chart of accounts designed for the way marketplace settlements actually work. The default chart of accounts in QuickBooks or Xero isn't set up for this — you'll need to add accounts specific to ecommerce.

Income Accounts

• Marketplace Sales Revenue — gross product sales (one account per marketplace, or a single consolidated account)
• Shipping Revenue — shipping charged to buyers (keep separate from product sales)
• Reimbursement Income — marketplace reimbursements for lost/damaged inventory

Cost of Goods Sold

• COGS — Product Cost — your cost to purchase or manufacture inventory sold

Expense Accounts

• Amazon Referral Fees (or "Platform Referral Fees")
• FBA Fulfillment Fees
• FBA Storage Fees
• Marketplace Advertising — Amazon Sponsored Products, Etsy Ads
• Shopify Subscription Fee
• Shopify Transaction Fees
• PayPal / Payment Gateway Fees
• Listing Fees — Etsy listing fees, eBay insertion fees
• Promotions and Discounts — contra-revenue or expense, depending on your preference

Liability Accounts

• Sales Tax Payable — tax collected by the marketplace and remitted on your behalf (this is zero-sum: collected and remitted, no tax liability remains, but you need to track it)

Asset Accounts

• Marketplace Clearing Account — a holding account for the period between when a sale occurs and when the settlement closes. Some accountants prefer to accrue revenue when the sale happens rather than when the settlement pays. The clearing account handles the timing difference.

The exact structure depends on your specific marketplaces and whether you use cash or accrual accounting. See our E-Commerce Chart of Accounts Template for a complete, ready-to-import template.

Ecommerce Bookkeeping by Platform

Amazon FBA

Amazon issues settlements every two weeks. The full settlement file is a tab-separated text file (the "Date Range Transaction Report" downloaded from Seller Central). Key characteristics:

• Settlement periods don't align to calendar months, so you'll have 2–3 settlements per month
• Fee codes like FBAPerUnitFulfillmentFee, Commission, and StorageReferralFeePerUnit must be mapped to expense accounts
• Reimbursements for lost inventory appear as positive amounts in the Miscellaneous category
• FBA storage fees appear in a separate monthly Storage Fee event, not in the regular settlement

How to record it: Sum all amounts by fee category. Build a journal entry with gross sales as credits and all fees, refunds, and the bank deposit as debits. Verify that it balances to the cent.

Shopify

Shopify Payments issues payouts every 1–3 business days (depending on your plan and location). The payout report CSV, downloaded from the Payments > Payouts section in Shopify Admin, contains:

• Individual order totals
• Refunds processed during the period
• Transaction fees (the Shopify Payments processing fee, typically 2.4–2.9% + 30¢)
• Shopify subscription fees (if billed against the payout balance)
• Third-party payment gateway fees (if not using Shopify Payments)

How to record it: Group by category (sales, refunds, fees), sum each group, and build a journal entry. The payout deposit goes to your checking account. See our full guide: How to Import Shopify Payouts into QuickBooks.

Etsy

Etsy's Payment Account CSV shows all credits (sales), debits (fees), and your net deposits. Key line items:

• Sale — gross order amount
• Listing fee — $0.20 per active listing
• Transaction fee — 6.5% of the sale price including shipping
• Payment processing fee — 3% + $0.25 per transaction
• Offsite Ads fee — 12–15% when Etsy Ads drives a sale

How to record it: The Etsy Payment Account CSV is the source of truth. Map each line type to the corresponding account, sum by category, and build your journal entry.

Walmart Marketplace

Walmart pays weekly. The settlement report shows gross sales, returns, WFS fulfillment fees, referral fees, and subscription fees. Map each to the appropriate expense account and build a balanced journal entry.

eBay Managed Payments

eBay's Transaction Report shows each order, final value fee, and shipping label charges. Final value fees (7–15% depending on category) and payment processing fees (2.7% + $0.30) are the primary deductions.

Cash vs. Accrual Accounting for Ecommerce

Most small ecommerce sellers use cash basis accounting: record revenue when you receive the payout and expenses when you pay them. The problem is that Amazon's two-week cycle means December sales might not hit your books until January.

Accrual basis recognizes revenue when the sale occurs and expenses when incurred. This is more accurate but requires tracking timing differences with a Marketplace Clearing Account.

For most sellers under $1M revenue, cash basis is acceptable. As you scale, consider switching to accrual with your accountant's guidance.

Common Ecommerce Bookkeeping Mistakes

1. Recording Only the Net Payout

The most common mistake. When Amazon deposits $8,247 in your bank account, that is not your revenue. Your gross sales were $10,249 — the difference was fees and refunds. Always record the full settlement, not just the deposit.

2. Ignoring Fee Categories

Lumping all marketplace fees into a single "Amazon Fees" expense makes your P&L useless for business analysis. You can't see whether referral fees are eating margin, or whether FBA storage fees are growing unsustainably. Break fees into meaningful categories.

3. Missing End-of-Period Settlements

Amazon and Shopify don't close settlements at month-end. A settlement that started March 28 might close April 11. Close your books March 31 and you miss that settlement. Either accrue the unbilled settlement or use a cutoff journal entry.

4. Double-Counting Sales Tax

When Amazon collects and remits marketplace facilitator tax on your behalf, it's not your revenue and not your liability. Record it to wash out: Sales Tax Payable is credited when collected and debited when remitted by Amazon. Don't include it in your sales revenue.

5. Skipping Reconciliation

Every settlement must reconcile against the actual bank deposit. The net payout in the settlement file must equal what hit your checking account. Investigate any discrepancy before closing the period.

Choosing the Right Bookkeeping Tool

Manual (spreadsheets): Works for very low volume. Error-prone and doesn't scale.

API-connected apps (A2X, Link My Books): Zero-touch automation. Requires OAuth access to your marketplace and accounting accounts. Supports QBO and Xero only.

File-upload converter (SettleBooks): Download settlement file, upload it, export journal entry. Works for any marketplace, any accounting software, without API access. Ideal for bookkeepers managing client data under NDAs.

See: Best A2X Alternatives in 2026

Monthly Ecommerce Bookkeeping Checklist

1. Download all settlement reports for the month from each marketplace
2. Reconcile each settlement against the bank deposit
3. Record all journal entries — one per settlement, broken down by fee category
4. Reconcile your bank account in QuickBooks/Xero against the bank statement
5. Review settlements that straddle month-end and accrue if needed
6. Verify P&L: revenue, fee expenses, and refunds all broken out separately
7. Check that marketplace-facilitated sales tax is correctly recorded

How SettleBooks Automates This

SettleBooks reads your settlement file, maps every fee category, sums the amounts, and builds a balanced journal entry automatically. Upload your file at the free Settlement Summary Viewer — no login required — and see how your settlement breaks down in under 60 seconds.

Explore the rest of this series:

• How to Reconcile Your Amazon Settlement Report
• How to Import Shopify Payouts into QuickBooks
• Amazon Settlement Report: What Every Line Item Means
• E-Commerce Chart of Accounts Template