E-Commerce Bookkeeping in 2025: What Shopify, Etsy, and Amazon Sellers Must Know — And How Otterz Can Help

U.S. e-commerce sales hit $310.3 billion in Q3 2025 alone, according to the U.S. Census Bureau — a 5.1% increase from the same quarter the previous year. E-commerce now accounts for 16.4% of all U.S. retail sales, and that number climbs every quarter (U.S. Census Bureau, Quarterly Retail E-Commerce Sales Report).

Behind every one of those billions is a seller trying to figure out why the deposit in their bank account doesn’t match the sales on their dashboard.

That’s the reconciliation problem. And if you sell on Shopify, Amazon, or both, it’s the single most common reason your books are wrong, your profit margins are fictional, and your tax filings are a gamble.

This guide walks through exactly how e-commerce reconciliation works on each platform, where most sellers get it wrong, and how to build a system that keeps your books accurate without consuming your weekends.

If you’re already behind on your books and need to get current fast, Otterz’s Bookkeeping Services specialize in

e-commerce and retail businesses — including multi-platform reconciliation, fee tracking, and sales tax compliance.

Why E-Commerce Reconciliation Is Different From Every Other Business

Traditional retail is straightforward: a customer pays you, money hits your bank account, you record the sale. The number on the receipt matches the number in your account.

E-commerce doesn’t work that way. Not even close.

When you sell a $50 product on Amazon, the customer pays $50. But what lands in your bank account two weeks later might be $37.42 — after Amazon takes its referral fee, FBA fulfillment fee, storage fee, and advertising cost-per-click charges. If the customer returned the item, Amazon may also deduct a return processing fee while crediting back only a portion of the original referral fee.

Shopify is different but equally complex. If a customer pays $50 through Shop Pay, Shopify deducts its payment processing fee before depositing the remainder. But if the same customer paid through PayPal, that fee is processed separately, through a different system, with a different deposit timeline.

Now multiply that by hundreds or thousands of transactions per month, across two or more platforms, with returns, chargebacks, advertising spend, and multiple payment gateways — and you start to understand why most e-commerce sellers’ books are wrong.

The gap between “what you sold” and “what hit your bank account” is where profit disappears and tax problems begin.

How Shopify Payouts Actually Work

Understanding Shopify’s payout structure is the first step to reconciling it correctly.

• The customer pays $50. Shopify Payments (or your third-party gateway) processes the transaction and deducts a payment processing fee — typically 2.6% + 30¢ for the basic plan in the U.S.
• Shopify batches your payouts. Rather than depositing each individual sale, Shopify groups transactions into periodic payouts — usually every one to three business days.
• Each payout is a net amount. The deposit that hits your bank is the sum of gross sales minus payment processing fees, refunds, chargebacks, and any Shopify app charges billed against your balance. It is not a clean, round number.
• This is where most sellers go wrong. They see a $4,237.18 deposit from Shopify and record it as “$4,237.18 in revenue.” But that deposit includes revenue, minus fees, minus refunds. Recording the net deposit as revenue understates your gross sales and produces financial statements that are essentially fiction.

The Right Way to Reconcile Shopify

• Gross sales go into your revenue account — the full amount customers paid, before any deductions.
• Payment processing fees go into an expense account. On $500,000 in annual sales, Shopify Payments fees alone can exceed $13,000. If you don’t track them, you’re overestimating your margins by that much.
• Refunds reduce revenue. When a customer returns an item, the refund should reverse the original revenue entry — not show up as a mysterious expense.
• Chargebacks need their own tracking. A chargeback isn’t a refund — it’s a dispute, and it often comes with an additional fee from the payment processor.
• Third-party payment gateways complicate everything. If you accept payments through PayPal, Stripe, Shop Pay, and Apple Pay simultaneously, each gateway deposits money on its own schedule, with its own fee structure.

This is exactly the kind of multi-source reconciliation that an AI-powered bookkeeping system handles automatically — matching each deposit to its component transactions across gateways.

How Amazon Settlements Actually Work

Amazon doesn’t pay you per order. It pays you per settlement period — typically every 14 days. Each settlement is a single deposit that represents the net result of everything that happened in your Amazon business during that period.

The Amazon Settlement Report is the key document. Here’s what’s inside:

• Product sales. The gross amount customers paid for your products. This is your top-line revenue.
• Referral fees. Amazon charges 8–15% of each sale depending on category. On a $50 item, that’s $4–$7.50 per unit.
• FBA fulfillment fees. Per-unit charges for pick, pack, and ship — roughly $3.22 for a standard small item, more for larger products.
• FBA storage fees. Monthly charges based on inventory volume. These increase significantly during Q4 and spike further after 181 days (long-term storage fees).
• Advertising charges. Amazon PPC costs are deducted directly from your settlement. They need to be recorded as marketing expenses, not a reduction in revenue.
• Returns and refunds. Amazon refunds the customer and deducts from your settlement — but doesn’t always return the full referral fee.
• Reimbursements. If Amazon loses or damages your inventory, reimbursements appear as line items buried in the settlement. Easy to miss. Essentially free money left on the table.

The Reconciliation Gap Most Sellers Don’t See

Your Amazon dashboard shows $25,000 in sales. You expect a deposit close to that. Instead, $17,800 lands in your bank account. The $7,200 difference is spread across referral fees ($3,250), FBA fees ($2,100), PPC advertising ($1,400), returns ($350), and storage fees ($100).

If you record $17,800 as revenue, you’ve underreported your sales by $7,200. Your COGS and profit margins will be wrong. Your tax filings will be wrong. And if the IRS compares your reported revenue to the 1099-K that Amazon files on your behalf, you’ve got a problem.

The correct approach: record $25,000 in gross revenue and separately record each fee category as an expense. The deposit reconciles when gross revenue minus all fees equals the bank deposit.

This is the exact reconciliation workflow that Otterz’s Bookkeeping Agent automates — ingesting settlement data, categorizing every fee line, and reconciling to your bank deposit.

Multi-Channel Reconciliation: Selling on Both Platforms

If you sell on both Shopify and Amazon, the reconciliation complexity multiplies. You now have two different payout schedules, two different fee structures, two different return policies, and potentially overlapping inventory.

• Double-counting revenue. If a sale starts on Shopify but fulfillment happens through Amazon MCF, you might accidentally record revenue on both platforms.
• COGS misallocation. When the same inventory serves both channels, you need a consistent method — either FIFO or weighted average cost — applied uniformly.
• Separate advertising costs that blur together. If you don’t attribute ad spend to the correct channel, you can’t determine which channel is actually profitable.
• Cash timing mismatches. Shopify deposits within days. Amazon deposits biweekly. If you’re matching deposits to dates, the timing differences create chaos.

Maintaining clear, channel-specific financial data is one of the core reasons e-commerce sellers benefit from controller-level oversight that goes beyond basic bookkeeping.

Sales Tax Compliance: The Hidden Accounting Burden

E-commerce sales tax became vastly more complex after the 2018 Supreme Court decision in South Dakota v. Wayfair, Inc., which allowed states to require out-of-state sellers to collect sales tax based on economic activity — not just physical presence.

In 2026, the standard economic nexus threshold in most states is $100,000 in gross sales. Illinois eliminated its 200-transaction threshold as of January 1, 2026, moving to a revenue-only model.

• If you sell $100,000+ into any state, you likely have economic nexus and are required to register, collect, and remit sales tax.
• If you use Amazon FBA, you may have physical nexus in 20+ states where Amazon stores your inventory — regardless of your sales volume.
• Amazon collects sales tax on marketplace sales, but if you also sell through Shopify, sales tax on those direct sales is entirely your responsibility.

This is exactly why Otterz’s Tax & Compliance Services include sales tax management as part of the e-commerce accounting package.

The Chart of Accounts That Works for E-Commerce

Most e-commerce sellers use a generic chart of accounts from QuickBooks or Xero. That’s fine for a coffee shop. It’s a disaster for an e-commerce business. Here’s the structure that gives you actual visibility:

Revenue Accounts (separate by channel)

• Shopify Product Sales
• Amazon Product Sales
• Shopify Shipping Revenue
• Amazon Shipping Credits

Cost of Goods Sold

• Product Cost (COGS)
• Inbound Freight / Shipping to Warehouse
• Packaging Materials

Platform Fees (separate by type)

• Shopify Payment Processing Fees
• Amazon Referral Fees
• Amazon FBA Fulfillment Fees
• Amazon FBA Storage Fees
• PayPal / Stripe Processing Fees

Marketing Expenses (by channel)

• Amazon PPC / Sponsored Products
• Facebook / Meta Advertising
• Google Shopping Ads

Returns & Refunds (by channel)

• Shopify Refunds
• Amazon Returns
• Chargeback Losses

Setting up this kind of tailored chart of accounts is one of the first things a dedicated e-commerce bookkeeping team does — because everything downstream depends on getting the structure right.

Inventory Accounting: The COGS Problem Most Sellers Ignore

The IRS requires businesses with inventory to use an accounting method that clearly reflects income. For most e-commerce sellers, that means either FIFO (First In, First Out) or weighted average cost.

• FIFO assumes the oldest inventory is sold first. If product costs fluctuate, FIFO can result in lower COGS during rising-cost periods — which means higher taxable income.
• Weighted average cost divides total inventory cost by total units. It smooths out price fluctuations and is simpler to maintain.
• The mistake most sellers make: They record COGS based on the most recent batch, or don’t track COGS at all. Neither approach will survive an IRS audit, and neither gives you accurate margin data.

For sellers with multiple SKUs and international sourcing, CFO-level financial strategy makes the difference between flying blind and making informed decisions.

Monthly Reconciliation Checklist for E-Commerce Sellers

Week 1:

Reconcile all bank deposits to platform payouts. Every Shopify payout and Amazon settlement should tie to a specific bank deposit.

Week 1:

Break each payout into gross revenue, fees, refunds, and other components. Record each in the correct account.

Week 2:

Reconcile payment gateways. If you use PayPal, Stripe, or other gateways, reconcile each independently.

Week 2:

Review Amazon reimbursements. Check for inventory lost, damaged, or destroyed. File claims for missing reimbursements.

Week 3:

Update inventory records and COGS. Match units sold to units purchased using your chosen valuation method.

Week 3:

Review advertising spend by channel. Confirm Amazon PPC charges match campaign manager data.

Week 4:

Reconcile sales tax collected versus remitted across all platforms and states.

Week 4:

Generate and review financial statements. P&L should reflect accurate gross margins by channel.

This reconciliation cadence is what Otterz’s bookkeeping and controller teams execute for e-commerce clients every month.

FAQs:

1. How do I reconcile Shopify payouts with my bank account?

Each Shopify payout is a net deposit combining gross sales minus payment processing fees, refunds, and chargebacks. Break every payout into components using Shopify’s Payout Report: record gross sales as revenue, processing fees as an expense, and refunds as a revenue reversal. The components should sum to the exact bank deposit. If you use multiple payment gateways, reconcile each separately.

2. What is an Amazon Settlement Report and how do I use it?

An Amazon Settlement Report is a detailed breakdown of every financial transaction within a settlement period — typically 14 days. It shows gross product sales, shipping credits, referral fees, FBA fees, storage fees, advertising deductions, refunds, and reimbursements. The net total equals your bank deposit. Record each line item in the correct account rather than booking the net deposit as revenue.

3. Why doesn’t my Amazon deposit match my sales?

Amazon deducts referral fees (8–15%), FBA fulfillment fees, storage fees, advertising charges, and refunds before depositing the remainder. On $25,000 in gross sales, the actual deposit might be $17,000–$19,000 after all deductions. Record these differences as expenses. If numbers still don’t balance, check for withheld reserves, pending reimbursements, or chargebacks.

5. Do I need to collect sales tax if I sell on Amazon?

Amazon collects and remits sales tax on marketplace sales under marketplace facilitator laws. However, if you also sell through Shopify, you’re responsible for direct-sale tax collection. You may have economic nexus in states where you exceed $100,000 in sales, or physical nexus where Amazon stores your FBA inventory. Both require registration and compliance.

The Bottom Line

E-commerce accounting isn’t harder because the transactions are more complex. It’s harder because the data is fragmented, the fees are hidden inside net deposits, and the timing of cash doesn’t match the timing of sales.

The sellers who get reconciliation right are the ones who know their real margins, make better decisions, and don’t get surprised at tax time.

The sellers who don’t think they’re profitable because their bank balance is growing — until they realize that 15–25% of gross revenue has been quietly consumed by platform fees, advertising costs, and missed reimbursements they never tracked.

Otterz combines AI-powered bookkeeping with expert tax compliance and CFO-level financial strategy — purpose-built for e-commerce and retail businesses.

We handle multi-platform reconciliation, fee tracking, inventory accounting, and sales tax compliance so you can focus on selling.