E-Commerce Accounting for Amazon & Shopify Sellers

Introduction

E-commerce bookkeeping breaks in a specific, predictable way: the deposit that lands in your bank account from Amazon or Shopify isn't your revenue — it's a net settlement bundling together sales, fees, refunds, ad spend, and reserves. Treating that single number as "revenue" is the most common mistake we see, and it quietly makes every downstream number — margin, profitability by product, actual fee cost — wrong. This guide covers how to actually structure e-commerce accounting correctly.

Table of Contents

1. The Core Problem: The Deposit Is Not Your Revenue
2. Breaking Down an Amazon Settlement Report
3. Shopify-Specific Considerations
4. COGS for E-Commerce: It's Not Just the Wholesale Price
5. Inventory Valuation: FIFO vs. Alternatives
6. Multi-Channel Accounting
7. Sales Tax Across Channels
8. A Practical Setup Checklist
9. FAQ
10. Conclusion

The Core Problem: The Deposit Is Not Your Revenue

This is worth stating plainly because it's the root of nearly every e-commerce bookkeeping problem we see: the amount that hits your bank account is a net number, not gross revenue. A single Amazon settlement, for example, nets together:

• Gross product sales
• Referral fees and FBA fulfillment fees (subtracted)
• Refunds and returns (subtracted)
• Advertising spend, if run through Amazon Ads (subtracted)
• Reserve amounts held back for pending returns or claims (subtracted, held, not lost)

Recording only the net deposit as "revenue" hides all of this — you lose visibility into your actual fee burden as a percentage of sales, refund rates by product, and true advertising ROI, since they're all invisibly netted against each other before you ever see the number.

Breaking Down an Amazon Settlement Report

Proper e-commerce bookkeeping records each component separately, not the net deposit as one line:

Manually decomposing every settlement report is genuinely tedious at real volume — this is exactly the kind of work worth automating through a proper integration (Zoho Books, QuickBooks, or a dedicated e-commerce accounting connector) rather than doing by hand every settlement cycle.

Shopify-Specific Considerations

Shopify's payout structure is simpler than Amazon's in some ways (no FBA fees, no advertising bundled into the same settlement unless you're running Shopify-native ads), but has its own specific traps:

• Payment processing fees (Shopify Payments, or a third-party processor) need to be recorded as a distinct expense, not netted against sales
• Multiple sales channels within Shopify (online store, POS, wholesale) should ideally be tracked separately for margin analysis, even though they roll up to one Shopify account
• App subscription costs (for the various apps most Shopify stores run) are a real, recurring operating expense that's easy to under-track since they're billed separately from the main payout

COGS for E-Commerce: It's Not Just the Wholesale Price

A common under-costing mistake: using only the per-unit wholesale/manufacturing cost as COGS, while ignoring:

• Inbound freight and duties to get the product to your warehouse or fulfillment center
• Packaging materials specific to the product
• Per-unit fulfillment costs, which some businesses track within COGS and others within operating expenses — the important thing is consistency, not which bucket you choose

Getting this right matters directly for pricing — a product that looks like it has a healthy 40% margin based on wholesale cost alone might actually be closer to 20% once true landed cost is included, which changes real decisions about which products to push and which to deprioritize.

Inventory Valuation: FIFO vs. Alternatives

FIFO (First In, First Out) is the standard, generally required method in most jurisdictions and the most common choice for e-commerce, since it typically reflects the actual physical flow of goods reasonably well (older stock generally does sell before newer stock in most retail operations).

The specific method chosen has real tax implications, particularly in inflationary periods where FIFO vs. other valuation approaches can meaningfully shift reported profit. This is a decision to make deliberately with an accountant, and to apply consistently once chosen — switching methods later isn't a simple bookkeeping change, it has real reporting and tax consequences.

Multi-Channel Accounting

Selling across Amazon, Shopify, and possibly wholesale simultaneously means each channel has genuinely different:

• Fee structures (Amazon referral/FBA fees vs. Shopify payment processing vs. wholesale terms)
• Payout timing (Amazon's settlement cycle differs from Shopify's payout schedule)
• Sales tax responsibility (see below)

These need to be tracked at the transaction level with enough detail to roll up into one coherent set of books — blending everything into a single undifferentiated revenue number early makes it effectively impossible to answer "which channel is actually more profitable" later without redoing the work.

Sales Tax Across Channels

This is where marketplace facilitator laws genuinely matter: for sales made through Amazon, marketplace facilitator laws in all 50 states generally require Amazon itself to collect and remit sales tax on your behalf. For sales through your own Shopify store, you are directly responsible for determining where you have economic nexus and collecting tax yourself. A seller doing meaningful volume on both channels needs to track this distinction carefully — it's not simply "sales tax is Amazon's problem now."

A Practical Setup Checklist

1. Connect a proper integration between your sales channels and accounting platform rather than manual settlement entry
2. Break out fees, refunds, and ad spend as separate line items — never record a net deposit as revenue
3. Calculate true landed cost per unit for COGS, not just wholesale price
4. Choose and consistently apply an inventory valuation method (typically FIFO) with your accountant
5. Track channel-level profitability, not just blended totals, if you sell on more than one platform
6. Monitor economic nexus separately for direct sales through your own store, since marketplace facilitator collection doesn't cover everything

Conclusion

Every e-commerce bookkeeping problem we see traces back to the same root cause: treating a net, bundled number as if it were a clean, single fact. Breaking settlements into their real components — sales, fees, refunds, ad spend — isn't extra bookkeeping overhead, it's the only way to actually see whether a product, a channel, or the business as a whole is genuinely profitable once every real cost is accounted for.

If you'd like help setting up e-commerce accounting that actually reflects your real margins, see our Zoho Books setup service for D2C brands or get in touch for a free consultation.