Last month, $14,832.17 hit your bank account from Amazon. One number. No context. Just a deposit.
How much was profit? How much went to fees? How many refunds came out? You don’t know. And if you’re honest, you haven’t known for months.
You’re not alone. There are millions of active ecommerce sellers across Amazon, Shopify, eBay, Etsy, and Walmart. Most of them record marketplace deposits as a single line, “Amazon income” or “Shopify sales” and move on. Then tax season arrives. Their accountant asks questions they can’t answer. They overpay by thousands. Or worse, they underpay and get a letter from the IRS.
Here’s the thing: ecommerce accounting is different from every other kind of accounting. Marketplaces don’t send you simple invoices. They bundle hundreds of transactions, sales, fees, refunds, taxes, adjustments, into single lump-sum deposits. If you don’t break those apart, your books are fiction. And fiction doesn’t hold up during an audit.
This guide covers everything you need to set up proper accounting for your ecommerce business. You’ll learn how to choose the right accounting method, build a chart of accounts, record journal entries that actually balance, pick the right tools, and avoid the mistakes that cost sellers thousands every year.
The fundamentals stay the same from $5,000 a month on one channel up to $500,000 across five marketplaces. The stakes just get higher.
No fluff. No theory without action. Just the system that works.
What Is Ecommerce Accounting (and Why It’s Different)
Ecommerce accounting is the process of tracking revenue, expenses, fees, refunds, and taxes from online marketplace sales. It covers everything from recording individual settlement line items to producing financial statements that reflect your true profitability.
Every online seller needs it. Almost none do it right.
The problem isn’t laziness. The problem is structure. Marketplaces don’t work like traditional businesses. And traditional accounting wasn’t built for marketplaces. The gap between how marketplaces pay you and how accounting software expects data creates confusion, errors, and missed deductions.
How Marketplace Payouts Actually Work
When you sell on Amazon, you don’t get paid per order. Amazon collects all your sales over a 14-day period, subtracts every fee they charge you, deducts refunds, adjusts for returns and reimbursements, and deposits what’s left.
Here’s what a typical $12,000 Amazon settlement actually contains:
| Line Item | Amount |
|---|---|
| Product Sales | $14,200 |
| Shipping Credits | $380 |
| Sales Tax Collected | $920 |
| Referral Fees | -$2,130 |
| FBA Fulfillment Fees | -$1,480 |
| Storage Fees | -$210 |
| Refunds Issued | -$560 |
| Advertising Costs | -$320 |
| Other Adjustments | +$200 |
| Bank Deposit | $12,000 |
Your bank sees $12,000. Your books need to see all ten lines. That’s the gap ecommerce accounting fills.
Shopify works similarly. Daily or weekly payouts bundle gross sales minus Shopify Payments fees, transaction fees, and refunds. eBay does the same with managed payments. Etsy, Walmart, same pattern. One deposit. Dozens of hidden components.
If you sell on multiple channels, multiply this problem. You might get three Amazon settlements, seven Shopify payouts, and four eBay deposits in a single month. Each one is a black box until you crack it open.
Why Traditional Accounting Breaks for Online Sellers
Traditional business accounting is linear. You send an invoice. The customer pays. You record the payment. Done.
Ecommerce flips that on its head. You sell 500 units across three marketplaces. Each marketplace takes different fees. Five customers request refunds. Two chargebacks come through. Three different currencies are involved. And all of it collapses into a handful of bank deposits with no clear breakdown.
Add multiple sales channels and it gets worse. The same product sold on Amazon, Shopify, and eBay generates three different fee structures, three different payout schedules, and three different reporting formats.
And then there’s sales tax. You might have nexus in 20+ states. Each marketplace collects differently. Your accounting needs to track what was collected, by whom, and what you still owe.
Traditional double-entry bookkeeping still applies, the principles haven’t changed. But the inputs are a mess. And messy inputs produce wrong outputs.
What Gets Tracked in Ecommerce Accounting
At a high level, ecommerce accounting tracks seven categories:
- Revenue: Gross sales, shipping income, gift wrap fees
- Marketplace fees: Referral fees, fulfillment fees, subscription fees, storage fees
- Refunds and chargebacks: Customer returns, A-to-z claims, disputed charges
- Cost of goods sold (COGS): Product cost, inbound shipping, packaging, duties
- Sales tax: Collected by you or the marketplace, owed to various states
- Operating expenses: Advertising, software subscriptions, warehouse costs
- Shipping costs: Outbound fulfillment, carrier charges
Each of these categories has subcategories. And each marketplace reports them differently. The rest of this guide shows you how to organize all of it.
Choosing Your Accounting Method
Before you record a single transaction, you need to decide how you’ll recognize revenue and expenses. This choice affects your tax bill, your financial statements, and how lenders evaluate your business.
There are three options. Most ecommerce sellers only know about two.
Cash Basis Accounting
Cash basis is the simplest method. You record income when cash hits your bank account. You record expenses when cash leaves. That’s it.
Who it works for: Solo sellers under $1M in revenue. If your business is simple, one channel, a narrow product line, and low inventory complexity, cash basis keeps things easy.
The problem for ecommerce: Timing mismatches. You sell a product on March 28. Amazon holds the cash until their next settlement on April 5. Under cash basis, that sale shows up in April’s books, not March’s. If you’re trying to understand monthly performance, the numbers lie.
Cash basis also hides your real liabilities. You owe sales tax on March’s sales, but if the cash hasn’t arrived yet, your books don’t reflect it. This gets messy at scale.
For seasonal sellers, cash basis creates another problem. Your Q4 sales might show up in Q1 deposits. Your books make it look like January was your best month when really December was. Strategic decisions based on wrong timing data lead to wrong strategies.
Pros:
- Simple to maintain
- Good enough for small operations
- Lower bookkeeping costs
Cons:
- Revenue timing doesn’t match actual sales
- Hard to track true profitability by period
- Won’t satisfy lenders or investors at growth stage
Accrual Accounting
Accrual accounting records revenue when you earn it (when the order ships), not when cash arrives. Expenses are recorded when incurred, not when paid.
Who it works for: Growing sellers above $500K. Any business seeking loans, investors, or a future exit. Any seller who wants to understand actual monthly performance.
Most accountants who specialize in ecommerce recommend accrual. It gives you an accurate picture of what happened each month, regardless of when marketplaces decide to release funds.
The benefit for ecommerce: Your March P&L shows March sales. Period. Amazon’s settlement timing doesn’t distort your numbers. You can compare January to February to March and see real trends.
Pros:
- Accurate picture of each period’s performance
- Required by GAAP (Generally Accepted Accounting Principles)
- Lenders and investors expect it
- Better for inventory-heavy businesses
Cons:
- More complex to maintain
- Requires more accounting knowledge (or a good tool)
- Higher bookkeeping costs
Modified Cash Basis (The Option Nobody Talks About)
Here’s the third option almost no one discusses. Modified cash basis is a hybrid. You use cash basis for day-to-day income and expenses, but switch to accrual for specific items like inventory and large equipment purchases.
Why it works for ecommerce: Most of your transactions (marketplace payouts, operating expenses) flow naturally under cash basis. But inventory, which is often your biggest asset, gets tracked on an accrual basis so your balance sheet reflects reality.
You get the simplicity of cash basis for 90% of your bookkeeping. And you get the accuracy of accrual for the parts that matter most.
Modified cash is particularly useful for mid-stage sellers between $200K and $1M. You’re past the point where pure cash basis works, but you don’t need (or want to pay for) full accrual accounting yet.
Important: Modified cash basis isn’t recognized under GAAP (Generally Accepted Accounting Principles). If you’re seeking venture capital or preparing for acquisition, you’ll need full accrual. But for running your business day to day, modified cash is a practical middle ground that keeps things manageable without sacrificing accuracy where it counts most.
Talk to your accountant about whether modified cash makes sense for you. Many ecommerce-savvy accountants prefer it for mid-stage clients because it reduces bookkeeping overhead while keeping inventory tracking honest.
Which Method Based on Your Revenue Stage
| Annual Revenue | Recommended Method | Why |
|---|---|---|
| Under $100K | Cash basis | Simple, sufficient, low cost to maintain |
| $100K - $500K | Modified cash or accrual | Need better inventory tracking, growing complexity |
| $500K - $2M | Accrual | Lenders expect it, monthly accuracy matters |
| $2M+ | Accrual (required) | Required by most lenders, investors, and acquirers |
This is general guidance, not a rule. Your specific situation matters. A seller doing $80K with 2,000 SKUs across four channels might need accrual sooner than a seller doing $300K with ten products on one channel. Consult your accountant before making this decision, it has real tax implications.
Setting Up Your Books
Your accounting method is decided. Now you need the actual structure. This is where most sellers get lost, not because it’s hard, but because nobody shows them what ecommerce-specific books look like.
Chart of Accounts for Ecommerce
Your chart of accounts (CoA) is the backbone of your books. It’s the master list of categories where every dollar gets sorted. Think of it as a filing system, every transaction needs a folder. Without the right folders, things get lost.
Generic accounting software comes with a default CoA built for service businesses. It has accounts for “Professional Services Income” and “Office Supplies.” It doesn’t have accounts for “Amazon Referral Fees” or “FBA Fulfillment Fees.” You need to customize it for ecommerce.
Here’s a sample chart of accounts organized for an online seller:
Revenue Accounts
| Account Name | Type | Purpose |
|---|---|---|
| Product Sales - Amazon | Income | Gross sales from Amazon |
| Product Sales - Shopify | Income | Gross sales from Shopify |
| Product Sales - eBay | Income | Gross sales from eBay |
| Shipping Income | Income | Shipping fees charged to customers |
| Gift Wrap Income | Income | Gift wrap charges (Amazon) |
Cost of Goods Sold
| Account Name | Type | Purpose |
|---|---|---|
| Product Cost | COGS | Wholesale cost of products sold |
| Inbound Shipping | COGS | Freight to warehouse or FBA |
| Packaging Materials | COGS | Boxes, poly mailers, tape |
| Import Duties | COGS | Customs duties on imported goods |
Expense Accounts
| Account Name | Type | Purpose |
|---|---|---|
| Amazon Referral Fees | Expense | Amazon’s commission per sale |
| Amazon FBA Fees | Expense | Fulfillment fees for FBA orders |
| Amazon Storage Fees | Expense | Monthly and long-term storage |
| Shopify Transaction Fees | Expense | Payment processing fees |
| eBay Final Value Fees | Expense | eBay’s commission per sale |
| Advertising - Amazon PPC | Expense | Sponsored product/brand ads |
| Advertising - Other | Expense | Facebook, Google ads |
| Shipping - Outbound | Expense | Carrier costs for merchant-fulfilled |
| Software Subscriptions | Expense | Accounting tools, inventory tools |
| Returns & Refunds | Expense | Customer refund amounts |
| Chargeback Fees | Expense | Disputed transaction costs |
Liability Accounts
| Account Name | Type | Purpose |
|---|---|---|
| Sales Tax Payable | Liability | Tax collected, owed to states |
| VAT Payable | Liability | VAT collected (UK/EU sellers) |
Tip: Separate your fees by marketplace and by type. “Amazon Fees” as one bucket tells you nothing. “Amazon Referral Fees” and “Amazon FBA Fees” as separate accounts tells you exactly where your money goes. For a detailed breakdown of Amazon’s fee structure, see our Amazon seller fees guide.
Recording Marketplace Transactions: Journal Entry Examples
This is the part no other guide shows you. Actual journal entries with debits and credits that balance. If you understand these examples, you understand ecommerce accounting.
Example 1: Amazon Settlement Journal Entry
Amazon deposits $10,000 into your bank account. Here’s what that settlement actually contains and how to record it:
| Account | Debit | Credit |
|---|---|---|
| Bank Account (Checking) | $10,000 | |
| Amazon Referral Fees | $1,500 | |
| Amazon FBA Fees | $600 | |
| Returns & Refunds | $400 | |
| Product Sales - Amazon | $11,500 | |
| Sales Tax Payable | $800 | |
| Shipping Income | $200 | |
| Totals | $12,500 | $12,500 |
Walk through it line by line: You earned $11,500 in product sales, $800 in sales tax (which you owe to states, it’s not your income), and $200 in shipping income. That’s $12,500 gross. Amazon kept $1,500 in referral fees and $600 in FBA fees. Customers received $400 in refunds. What’s left ($10,000) lands in your bank.
The key insight: your bank deposit ($10,000) is not your revenue ($11,500). And your revenue is not your profit. You still need to subtract COGS and operating expenses from that $11,500 to know what you actually earned.
Debits equal credits. The journal entry total matches your bank deposit. Reconciliation takes one click.
This is how proper Amazon bookkeeping works. Every settlement gets broken down. Every dollar gets categorized. Nothing hides in a lump sum.
Example 2: Shopify Payout Journal Entry
Shopify pays you $5,200. Here’s the breakdown:
| Account | Debit | Credit |
|---|---|---|
| Bank Account (Checking) | $5,200 | |
| Shopify Transaction Fees | $180 | |
| Returns & Refunds | $220 | |
| Product Sales - Shopify | $5,350 | |
| Sales Tax Payable | $250 | |
| Totals | $5,600 | $5,600 |
Key difference from Amazon: Shopify shows you the gross sale amount and deducts fees separately. Amazon shows net amounts in settlement reports. The journal entry structure is the same, but the source data looks different. A good automation tool handles both formats. For Shopify-specific guidance, read our best accounting software for Shopify guide.
Handling Refunds and Chargebacks
Refunds are one of the trickiest parts of ecommerce accounting. Here’s why: the refund almost never appears in the same settlement as the original sale.
Say a customer buys a product on March 3. That sale goes into the March 5 settlement. The customer requests a refund on March 12. That refund appears in the March 19 settlement, a completely different deposit.
If you’re doing manual bookkeeping, this creates a mismatch. March 5 settlement looks great. March 19 settlement looks worse than it should. Over time, it evens out. But for monthly reporting, it can be confusing.
Journal entry for a refund within a settlement:
| Account | Debit | Credit |
|---|---|---|
| Returns & Refunds | $75 | |
| Sales Tax Payable | $6 | |
| Amazon Referral Fees | $11 | |
| Bank Account | $70 | |
| Totals | $81 | $81 |
Notice that Amazon refunds part of their referral fee when a customer returns an item. You don’t eat the full fee. The refund reduces your bank deposit (credited), and the returned referral fee partially offsets it.
Chargebacks work like refunds with an extra sting. When a customer disputes a charge with their credit card company, the marketplace refunds them and charges you an additional chargeback fee (typically $20-$30). Record the chargeback fee as a separate expense line.
Automation tools handle this correctly by reading the settlement data and splitting every line item into its proper account. When you’re processing dozens of refunds per settlement period, manual entry is where errors creep in.
One more thing about refund timing: If you’re using accrual accounting, you should record refund allowances as an estimate each month. You know roughly what percentage of sales get returned. Booking that estimate keeps your monthly P&L closer to reality, even when the actual refund hits a different settlement period.
Inventory and COGS
Revenue gets all the attention. But cost of goods sold determines whether your business actually makes money.
Why COGS Matters More Than Revenue
Revenue is vanity. Profit is sanity. COGS is the bridge between them.
You can’t calculate gross profit without knowing what each product costs you. And “cost” means more than the invoice from your supplier. True COGS includes:
- Product cost: What you paid the manufacturer or wholesaler
- Inbound freight: Shipping from supplier to your warehouse or FBA
- Packaging materials: Boxes, labels, poly bags, inserts
- Import duties and customs: For products sourced internationally
- Prep fees: Amazon FBA prep, labeling, bundling costs
A product that costs $8 wholesale might have a true landed cost of $11.50 when you add freight, packaging, and duties. If you’re using $8 as your COGS, you’re overstating profit by 30%. That phantom profit gets taxed. You lose real money on imaginary gains.
Here’s a real example. You sell 10,000 units per year at $25 each. You think your COGS is $8 per unit ($80,000 total). Your books show $170,000 in gross profit. But your true landed cost is $11.50 per unit ($115,000 total). Real gross profit is $135,000, that’s $35,000 less than you thought. At a 25% tax rate, you paid $8,750 in taxes on profit that didn’t exist.
Track every component. Your margins depend on it. Your tax bill depends on it even more.
COGS Calculation Methods
Three methods exist for calculating COGS. Your choice depends on your product mix and inventory complexity.
| Method | How It Works | Best For |
|---|---|---|
| FIFO (First In, First Out) | Oldest inventory costs are expensed first | Most ecommerce sellers, matches physical flow of goods |
| Weighted Average | Average cost across all units in stock | Sellers with many similar products at similar costs |
| Specific Identification | Track actual cost per individual unit | High-value or unique items (jewelry, vintage, custom) |
FIFO is the most common choice for ecommerce. It assumes you sell your oldest inventory first. This matters when product costs change, if your supplier raises prices, FIFO ensures you’re expensing the lower-cost units first, which means higher reported profit (and higher tax). But it matches how most warehouses actually operate.
Weighted average is simpler. You take the total cost of all units and divide by total quantity. Every unit has the same cost until you buy more inventory. It smooths out price fluctuations and reduces tracking overhead.
Specific identification is rare in ecommerce unless you sell unique items. If every piece is one-of-a-kind, handmade jewelry, vintage collectibles, custom furniture, you need to track each unit’s actual cost. Most standard ecommerce sellers don’t need this level of detail.
Important: Once you pick a method, stick with it. The IRS requires consistency, and switching mid-year creates accounting complications that require professional help to sort out. Consult your accountant before choosing, the right method depends on your product mix, volume, and tax situation.
Tracking Inventory Across Channels
Selling the same product on Amazon, Shopify, and eBay means the same SKU lives in multiple places. FBA warehouses, your own storage, maybe a 3PL facility. Each location has different fulfillment costs. FBA fees are different from self-fulfillment costs. 3PL rates are different from both.
Your COGS per unit might be $11.50 for an FBA order, $9.80 for a self-fulfilled order, and $10.40 for a 3PL-fulfilled order. If you use a blended average, you’ll never know which channel is actually profitable.
The fix: a single inventory management system that feeds into your accounting software. Track inventory quantities and costs in one place. Let that system tell QuickBooks or Xero what your COGS is for each channel.
Without centralized tracking, you’ll end up with inventory discrepancies. Your FBA dashboard says you have 500 units. Your 3PL says 300. Your own warehouse says 200. That’s 1,000 units total, but your accounting software shows 850 because someone forgot to record a shipment. These discrepancies grow over time and make your balance sheet unreliable.
Taxomate’s Inventory plan syncs inventory data directly with QuickBooks Online, including FBA inventory events. Webgility offers similar inventory features but with strict order limits that drive costs up at volume. A2X and Link My Books don’t offer inventory sync to accounting software.
For a deeper look at COGS tracking, read our full cost of goods sold guide.
Tax Obligations for Online Sellers
Taxes are the reason most sellers finally take accounting seriously. Miss a filing deadline or underreport, and the penalties get expensive fast.
This section covers the three tax areas every ecommerce seller needs to understand. It’s not legal advice, always consult a qualified tax professional for your specific situation.
Sales Tax and Economic Nexus
If you sell to customers in the United States, you almost certainly owe sales tax in multiple states. The 2018 Supreme Court ruling in South Dakota v. Wayfair changed everything.
Before Wayfair, you only owed sales tax in states where you had a physical presence. After Wayfair, states can require you to collect sales tax once you hit economic thresholds, typically $100K in sales or 200 transactions in that state.
The good news: Marketplace facilitator laws now require Amazon, Shopify (when using Shopify Payments), eBay, Etsy, and Walmart to collect and remit sales tax on your behalf in most states. The marketplace handles it.
When you still need to act:
- Selling through your own website without a marketplace facilitator
- Selling in states that don’t have marketplace facilitator laws
- Having physical nexus (warehouse, office, employees) in additional states
- Product category exemptions that require specific tax codes
Tools like Avalara, TaxJar, and TaxValet automate sales tax compliance. They calculate rates, file returns, and handle remittance. If you sell in more than a handful of states, they’re worth the investment.
For your books: Sales tax collected needs its own liability account. It’s not income, it’s money you hold temporarily for the government. Recording it as revenue inflates your numbers and creates tax problems.
Income Tax Considerations
Every dollar of profit you earn selling online is taxable income. The good news: almost every dollar your marketplace takes from you is a deductible business expense.
Deductible ecommerce expenses include:
- All marketplace fees (referral, fulfillment, storage, subscription)
- Advertising costs (Amazon PPC, Facebook, Google)
- Shipping and postage
- Packaging materials
- Software subscriptions (accounting tools, inventory tools, listing tools)
- Home office (if applicable)
- Professional services (accountant, bookkeeper)
- Product photography
- Returns processing costs
Quarterly estimated payments: If you expect to owe $1,000+ in federal taxes for the year, the IRS requires quarterly estimated payments. Miss them and you’ll owe penalties plus interest. Mark these dates on your calendar: April 15, June 15, September 15, January 15.
Here’s where proper accounting pays for itself. Sellers with messy books miss deductions. They forget to track FBA storage fees. They don’t categorize advertising expenses. They leave money on the table.
A seller doing $500K in revenue with $75K in deductible marketplace fees who fails to track those fees properly could overpay income tax by $15,000-$20,000. That’s not hypothetical. It happens constantly.
VAT and International Selling
If you sell in the UK or EU, VAT (Value Added Tax) adds another layer. UK sellers must register for VAT once turnover exceeds the threshold (currently 90,000 GBP). EU sellers face different thresholds per country.
Key concepts for international sellers:
- VAT registration: Required above threshold. Some sellers register voluntarily to reclaim input VAT on purchases.
- Flat Rate Scheme (UK): Simplified VAT scheme where you pay a fixed percentage of gross sales. Easier bookkeeping but not always cheaper.
- Import duties: Products entering the UK/EU from outside incur customs duties. These are part of your landed cost (COGS).
- Multi-currency challenges: Selling in GBP, EUR, and USD means tracking exchange rate gains and losses. Your accounting software needs multi-currency support.
Amazon handles VAT collection in many cases through their marketplace facilitator equivalent. But the reporting and filing obligations still fall on you.
For sellers doing cross-border commerce, Xero’s multi-currency features are particularly strong. QuickBooks Online handles multi-currency too, but Xero was built for international businesses from the start.
Bottom line: International selling multiplies your accounting complexity. If you sell across borders, budget for professional help or make absolutely sure your tools handle it correctly.
Essential Financial Statements
Three financial statements tell you everything about your business’s health. If you can’t produce these, you’re flying blind.
Profit and Loss Statement (P&L)
Your P&L (also called an income statement) shows whether you made or lost money over a period. For ecommerce, it follows this structure:
Sample P&L for a $500K/year Amazon Seller
| Line Item | Amount | % of Revenue |
|---|---|---|
| Gross Revenue | $500,000 | 100% |
| Less: Refunds & Returns | -$25,000 | 5% |
| Net Revenue | $475,000 | 95% |
| Less: COGS | -$175,000 | 35% |
| Gross Profit | $300,000 | 60% |
| Amazon Referral Fees | -$75,000 | 15% |
| Amazon FBA Fees | -$55,000 | 11% |
| Amazon Storage Fees | -$8,000 | 1.6% |
| Advertising (PPC) | -$40,000 | 8% |
| Software & Tools | -$3,600 | 0.7% |
| Shipping (non-FBA) | -$5,000 | 1% |
| Insurance | -$2,400 | 0.5% |
| Professional Services | -$6,000 | 1.2% |
| Total Operating Expenses | -$195,000 | 39% |
| Net Profit | $105,000 | 21% |
Three numbers to watch every month:
- Gross margin (Gross Profit / Net Revenue): This seller’s at 63%. Below 50% on Amazon and you’ll struggle to cover operating costs.
- Fee percentage (Total fees / Gross Revenue): Amazon takes about 28% between referral, FBA, and storage. If this creeps above 30%, investigate.
- Net margin (Net Profit / Net Revenue): 21% is solid. Below 10% means you’re working hard for slim returns.
Your P&L is only as accurate as your bookkeeping. Lump-sum deposits with no fee breakdowns produce meaningless P&L statements. Proper ecommerce accounting produces P&Ls that actually help you make decisions.
Balance Sheet Basics
Your balance sheet shows what you own (assets), what you owe (liabilities), and what’s left (equity). It’s a snapshot of a single moment, not a period.
Key balance sheet items for ecommerce sellers:
Assets:
- Cash in bank accounts
- Inventory on hand (your biggest current asset)
- Accounts receivable (pending marketplace payouts)
- Prepaid expenses (annual software subscriptions)
Liabilities:
- Sales tax payable (collected but not yet remitted)
- Credit card balances
- Supplier invoices due
- Loans and credit lines
Why the balance sheet matters: Lenders and buyers look at your balance sheet first. A business with $200K in inventory, $50K in cash, and $30K in debt looks very different from one with $200K in inventory, $5K in cash, and $180K in debt. Same revenue could be running through both.
If you ever want to sell your business, get a loan, or bring on investors, you need a clean balance sheet. Start tracking it now, even if you don’t think you need it yet.
Cash Flow Statement
Here’s a truth about ecommerce: profitable businesses go broke. It happens when you have to buy inventory months before you sell it.
You order $50,000 in inventory in January. It ships from China in February. Arrives at FBA in March. Starts selling in April. Amazon pays you in May. Your cash was gone for four months while your P&L shows growing revenue.
The cash flow statement tracks exactly this. It breaks cash movement into three sections:
- Operating activities: Cash from sales minus cash for expenses. This should be positive.
- Investing activities: Cash spent on equipment, warehouse buildout, etc.
- Financing activities: Loans taken, investor funds received, owner draws.
Cash flow forecasting is critical for seasonal sellers. If Q4 is your peak, you need to buy inventory in Q3. That means your cash balance drops right before your biggest revenue quarter. Without a forecast, you might not have enough cash to fund that inventory purchase.
Map out your cash needs 90 days ahead. Know when inventory orders are due. Know when marketplace payouts arrive. The gap between those two dates is where businesses fail.
How Accounting Works on Each Marketplace
Every marketplace bundles transactions differently. If you sell on multiple channels, you need to understand each one’s structure. Here’s how accounting works on the platforms that matter most. For detailed guidance on Amazon seller accounting, we have a dedicated guide.
Amazon
Amazon is the most complex marketplace for accounting. Settlements happen every 14 days and can contain thousands of individual transactions.
Settlement structure: Amazon settlements are the most detailed (and most confusing) of any marketplace. A single settlement can contain dozens of line item types:
- Product sales (broken out by ASIN)
- Shipping credits
- Gift wrap credits
- Promotional rebates
- Referral fees (8-45% depending on product category)
- FBA fulfillment fees ($3-$10+ per unit depending on size/weight)
- Monthly storage fees ($0.87-$2.40/cubic foot depending on time of year)
- Long-term storage fees (for inventory sitting 181+ days)
- Refund amounts and refunded commissions
- Advertising costs (if using Sponsored Products, Sponsored Brands, etc.)
- Reimbursements (lost/damaged inventory)
- Various adjustments and service fees
FBA vs. Merchant-Fulfilled: These are fundamentally different cost structures. FBA sellers pay fulfillment and storage fees but save on shipping and handling labor. Merchant-fulfilled sellers avoid FBA fees but pay carrier rates and warehouse costs. Your chart of accounts should reflect whichever model you use, and if you use both, you need separate expense accounts for each.
Many sellers also forget about Amazon’s reimbursements. When Amazon loses or damages your inventory, they reimburse you. These reimbursements show up in your settlement but aren’t sales revenue, they’re a different income type. Categorize them separately.
Connecting Amazon to QuickBooks is the most common integration sellers set up. See our Amazon QuickBooks integration guide for the step-by-step process.
For a detailed breakdown of every fee Amazon charges, read our Amazon seller fees guide.
Shopify
Shopify’s accounting structure is cleaner than Amazon’s, but has its own quirks.
Payout structure:
- Shopify pays out daily, weekly, or monthly (your choice)
- Each payout includes: gross sales, refunds, Shopify Payments processing fees, chargebacks, and adjustments
- If you use third-party payment gateways (PayPal, Stripe), those process separately
Key accounting differences from Amazon:
- Shopify shows gross sale amounts, you see the full customer payment
- Processing fees are itemized separately
- No referral fees or fulfillment fees (unless using Shopify Fulfillment Network)
- Third-party payment fees require separate tracking
Important for multi-channel sellers: If a customer pays via PayPal on your Shopify store, that payment doesn’t flow through Shopify Payments. It goes straight to PayPal. Your Shopify payout won’t include it. You need to reconcile PayPal deposits separately.
Another Shopify quirk: refunds processed after a payout has been disbursed appear in a future payout, not the original one. This is normal Shopify behavior. If a customer returns something from last week’s payout, the refund deduction shows up in next week’s payout. Your books need to account for this timing difference.
For Shopify-specific accounting software recommendations, see our best accounting software for Shopify guide and learn how to connect Shopify to QuickBooks.
eBay, Etsy, and Walmart
Each of these marketplaces has its own fee structure and payout schedule.
eBay:
- Managed Payments processes all transactions
- Final value fees: 3-15% depending on category
- Per-order fees: $0.30 per order
- Store subscription fees (optional, reduces per-listing costs)
- Payouts typically daily or weekly
- International fees for cross-border sales
Etsy:
- Transaction fee: 6.5% of sale price
- Listing fee: $0.20 per listing
- Payment processing: 3% + $0.25 per transaction
- Offsite ads fee: 12-15% when Etsy drives the sale
- Payouts typically daily or weekly
Walmart:
- Referral fees: 6-20% by category
- WFS (Walmart Fulfillment Services) fees for eligible sellers
- No monthly subscription fee
- Biweekly payouts
| Feature | Amazon | Shopify | eBay | Etsy | Walmart |
|---|---|---|---|---|---|
| Payout Frequency | Every 14 days | Daily/Weekly/Monthly | Daily/Weekly | Daily/Weekly | Biweekly |
| Fee Model | Referral + FBA + Storage | Processing fees only | Final value + per order | Transaction + listing + processing | Referral only |
| Collects Sales Tax | Yes | Yes (Shopify Payments) | Yes | Yes | Yes |
| Fee Range | 15-40%+ of gross | 2.6-2.9% + $0.30 | 3-15% + $0.30 | 10-25%+ | 6-20% |
The fee range differences are significant for your bottom line. A $25 product sold on Amazon might incur $6-$10 in total fees. That same product sold on your Shopify store might only incur $0.97 in processing fees. Understanding these differences per channel helps you make smarter decisions about where to focus your selling efforts and advertising budget.
Multi-Channel Sellers: Reconciling Across Platforms
Selling on multiple channels multiplies accounting complexity. The same product generates different fee structures, different payout amounts, and different payout timing across each platform.
Without a unified system, you end up with:
- Multiple bank deposits to track per week
- Different fee categories per marketplace
- No single view of total business performance
- Reconciliation nightmares at month-end
The solution is a single accounting system (QuickBooks, Xero, or Wave) fed by automation tools that normalize data from every channel. All your Amazon settlements, Shopify payouts, and eBay payments flow into the same chart of accounts. Your P&L shows performance across all channels in one place.
This is where multi-channel automation tools earn their cost. Taxomate’s Multi plan supports unlimited sales channels at a single price, you’re not paying per marketplace like you would with A2X or Link My Books. If you sell on three or more channels, the savings add up fast.
The goal: one P&L that shows your total business performance. One balance sheet that reflects all your inventory. One reconciliation process that covers every deposit from every marketplace. That’s what proper multi-channel ecommerce accounting looks like.
Automating Your Ecommerce Accounting
Manual bookkeeping works when you’re doing $2,000 a month on one channel. It breaks when you’re doing $20,000 across three channels. And by the time you’re doing $100,000+, it’s costing you more in time, errors, and missed deductions than any tool would cost.
When Manual Bookkeeping Stops Working
Watch for these signs:
- Reconciliation takes hours. You’re cross-referencing settlement reports against bank deposits and losing half a Saturday.
- You’re behind on your books. More than 30 days of unreconciled settlements means you’re guessing at profitability.
- You’re missing deductions. If you can’t name every fee type you paid last month, you’re probably not tracking them all.
- Tax prep is painful. Your accountant asks questions you can’t answer. Or you’re paying them $200/hour to sort through your mess.
- You sell on multiple channels. Three marketplaces with different payout schedules and fee structures = manual chaos.
Rule of thumb: If you’re processing more than $10,000/month in marketplace sales, automation saves you money from day one.
Accounting Software: QuickBooks vs Xero vs Wave
Before you add marketplace automation, you need a base accounting platform. Three options dominate ecommerce:
| Feature | QuickBooks Online | Xero | Wave |
|---|---|---|---|
| Monthly Price | $30-$200 | $15-$78 | Free |
| Best For | US sellers, largest app ecosystem | International/multi-currency sellers | Beginners on a tight budget |
| Marketplace Integrations | Most tools support QBO | Good support, fewer options | Limited (Taxomate supports Wave) |
| Inventory Tracking | Built-in (Plus plan+) | Basic | No |
| Multi-Currency | Yes (Plus plan+) | Strong native support | Limited |
| Payroll | Built-in add-on | Via partners | Built-in (paid) |
| Learning Curve | Moderate | Moderate | Easy |
QuickBooks Online is the default choice for most US-based ecommerce sellers. It has the largest ecosystem of third-party integrations and most accountants know it well. If you’re not sure, start here.
Xero shines for international sellers. Its multi-currency support is stronger than QuickBooks, and it was designed for global businesses. UK, EU, and Australian sellers often prefer Xero.
Wave is free and surprisingly capable for basic needs. The catch: fewer integrations. Taxomate connects to Wave (Amazon, eBay, Etsy, and Walmart), but most other marketplace tools don’t support it. If budget is your primary constraint, Wave works.
Marketplace-to-Accounting Automation Tools
These tools are the bridge between your marketplaces and your accounting software. They pull settlement data, break it down, categorize every line item, and create journal entries that match your bank deposits.
Here’s how the main options compare (for a deeper analysis, see our full Taxomate vs A2X vs Link My Books comparison):
| Feature | Taxomate | A2X | Link My Books | Webgility |
|---|---|---|---|---|
| Setup Time | ~5 minutes | 1-2 hours | ~15 minutes | 1-2 hours |
| Price (1 channel, up to 200 orders) | $14/mo | $29/mo | ~$34/mo | $24/mo |
| Price (1 channel, up to 5K orders) | $44/mo | $79/mo | ~$60/mo | $149/mo + overages |
| Multi-Channel Pricing | Unlimited channels (Multi plan from $27/mo) | Per Merchant ID/channel | Per channel | Per channel + strict order limits |
| Free Historical Data | Unlimited | 3-24 months by plan | 3-24 months by plan | No |
| Inventory Sync to QBO | Yes (Inventory plan) | No | No | Yes |
| Accounting Software | QuickBooks, Xero, Wave | QuickBooks, Xero | QuickBooks, Xero | QuickBooks, Xero |
| Free 1:1 Onboarding | Yes (every plan) | No | Yes | Yes (Pro+) |
| Marketplaces | Amazon, Shopify, eBay, Walmart, Etsy | Amazon, Shopify, eBay, Walmart, Etsy | Amazon, Shopify, eBay, Etsy | Amazon, Shopify, eBay, Walmart, Etsy + more |
Taxomate is the best value for most sellers. Setup takes about 5 minutes, connect your marketplace, connect your accounting software, confirm mappings, done. The Starter plan covers one sales channel starting at $14/month. The Multi plan adds unlimited channels starting at $27/month. Every plan includes free 1:1 onboarding and unlimited historical data imports. Competitors charge more and give you less history. For inventory sync, the Inventory plan starts at $36/month. Check the pricing page for rates by order volume.
A2X has a loyal following among accountants. It’s accurate software with detailed mapping options. But setup takes 1-2 hours and usually requires accounting knowledge. Pricing is per Merchant ID or channel: $29/month (Mini, 200 orders, 3 months history), $79/month (Standard, 5K orders, 24 months history), $159/month (Standard 10K). Multi-channel sellers pay per channel, so costs double or triple quickly. No inventory sync. See our A2X alternative comparison for details.
Link My Books works well for UK and EU sellers who need VAT support. Clean interface, decent setup. Dynamic pricing starting around $34/month per channel. History limited to 3-24 months depending on plan. No inventory sync. Per-channel pricing applies.
Webgility targets enterprise sellers with advanced inventory and shipping needs. Pricing: $24/month (Basic, 100 orders), $79/month (Pro, 300 orders), $149/month (Advanced, 800 orders). The catch: strict order limits with $50 per 100 extra orders in overages. A seller processing 5,000 orders on the Advanced plan would pay $149 base + $2,100 in overages = $2,249/month. Great features if you can afford it.
Bottom line for multi-channel sellers: A seller on Amazon, Shopify, and eBay with 5K total orders would pay about $58/month on Taxomate’s Multi plan. The same setup on A2X would cost $237+/month (3 x $79). On Link My Books, roughly $180/month. On Webgility, well into four figures with overages. The math is clear.
Try Taxomate free for 14 days. No credit card required.
What Automation Actually Does (Step by Step)
If you’ve never used an automation tool, here’s exactly what happens when you connect one:
-
The tool pulls your settlement or payout data from the marketplace API. You don’t export files or copy anything manually.
-
It breaks down every line item. A single Amazon settlement with 800 transactions gets parsed into categories: product sales, referral fees, FBA fees, refunds, storage charges, advertising deductions, tax collected, and more.
-
Each line item maps to an account in your accounting software. Referral fees go to your “Amazon Referral Fees” expense account. Sales go to “Product Sales - Amazon.” Tax collected goes to “Sales Tax Payable.” You configure this once.
-
The tool creates a journal entry that matches your bank deposit. The total of all debits and credits equals the exact amount Amazon (or Shopify, or eBay) deposited in your bank.
-
You reconcile with one click. Open your accounting software, find the matching bank transaction, click to match it against the journal entry. Done.
The entire process runs automatically on new settlements. You check it monthly. Time saved: 5-15 hours per month depending on volume. Deductions captured: all of them. Errors: near zero.
That’s the power of automated ecommerce accounting.
The 7 Costliest Ecommerce Accounting Mistakes
These mistakes aren’t theoretical. They cost real sellers real money every year. Each one is fixable, if you know to look for it.
1. Recording Gross Revenue Instead of Net
This is the most expensive mistake and the most common. You see $200,000 in marketplace sales and record $200,000 as revenue. But Amazon took $40,000 in fees. Your taxable income should be $160,000, not $200,000.
Dollar impact: At a 25% effective tax rate, recording gross instead of net costs you $10,000 in extra taxes on money you never received. You’re paying income tax on Amazon’s fees.
Fix: Always record net settlement amounts with fees broken out as separate expenses. Use automation to ensure every fee gets categorized.
2. Ignoring Marketplace Fees as Deductions
Amazon referral fees. FBA fulfillment fees. Storage fees. Monthly subscription fees. Advertising costs. These are all legitimate business deductions.
Dollar impact: A seller doing $300,000/year on Amazon might pay $45,000-$60,000 in marketplace fees. Missing half of those deductions at a 25% tax rate = $5,625-$7,500 in overpaid taxes.
Fix: Track every fee type in a separate expense account. Your chart of accounts should have dedicated lines for referral fees, FBA fees, storage fees, advertising, and any other recurring charge. See our Amazon seller fees guide for the full list of deductible fees.
3. Not Reconciling Every Settlement
Reconciliation means matching your journal entries to your bank deposits. When sellers skip this step, discrepancies hide. Amazon settlement errors happen. Duplicate charges appear. Refunds go unaccounted for.
Dollar impact: One seller found $2,400 in overcharges buried in three months of unreconciled settlements. Another discovered Amazon had been double-charging storage fees for a discontinued ASIN. They only found it because they reconciled.
Fix: Reconcile every settlement within a week of receiving it. Automation tools do the matching for you, you just verify the numbers.
4. Mixing Personal and Business Accounts
Using your personal bank account for business transactions creates a tangle that gets harder to unwind over time. It also raises red flags during audits.
Dollar impact: If the IRS audits you and finds commingled funds, the burden of proof shifts to you. You have to prove which expenses were business-related. Some sellers lose thousands in denied deductions simply because they couldn’t separate personal from business spending.
Fix: Open a dedicated business bank account and business credit card. Route all marketplace payouts to the business account. Pay business expenses from business accounts only. This is non-negotiable.
5. Wrong Accounting Method for Your Stage
A $2M ecommerce business on cash basis produces a P&L that fluctuates wildly based on payout timing. March looks terrible because Amazon delayed a settlement. April looks amazing because two settlements landed in the same week. Neither month reflects reality.
Dollar impact: Banks and lenders evaluate your business based on financial statements. Wildly fluctuating statements from the wrong accounting method can cost you a loan approval or reduce your terms. That’s thousands in higher interest rates or lost growth opportunities.
Fix: Match your accounting method to your revenue stage (see the decision table earlier in this guide). Transition to accrual before you need to, doing it during a loan application is too late.
6. Not Tracking COGS
Without COGS, you don’t know your gross margin. You think you’re making 40% on each sale because your selling price is $25 and Amazon deposits $15. But after product cost, freight, and packaging, your actual margin is 12%.
Dollar impact: Sellers without COGS data make bad purchasing decisions. They reorder products that lose money. They discount products that already run negative after fees. One seller discovered their “best-selling” product was losing $2 per unit once they finally calculated true COGS.
Fix: Calculate landed cost for every product. Track it in your accounting software. Review COGS monthly. For help setting this up, read our COGS guide.
7. Manual Data Entry Across Multiple Channels
Copying numbers from settlement reports into spreadsheets into accounting software introduces errors at every step. One decimal point in the wrong place turns a $50 fee into $500. One missed row hides a $300 refund.
Dollar impact: Manual entry errors compound over time. A $500 error per month is $6,000 per year. And those errors create cascading problems, your bank reconciliation won’t balance, your P&L is wrong, and your tax return is based on fiction.
Fix: Automate. Connect your marketplaces to your accounting software with a tool that reads settlement data directly from the API. No copy-paste. No spreadsheets. No errors.
Taxomate prevents all seven of these mistakes automatically. Settlements get broken down. Fees get categorized. Journal entries balance. Bank deposits match. Start a free trial and fix your books in 5 minutes.
DIY vs Hiring a Professional
At some point, every seller asks: should I do my own books or hire someone? The answer depends on your revenue, complexity, and how much your time is worth.
Revenue Thresholds for Hiring Help
These are general guidelines, not hard rules. Your situation may differ based on the number of channels, product complexity, and your comfort with numbers.
| Annual Revenue | Recommendation | Estimated Cost |
|---|---|---|
| Under $100K | DIY with automation software | $15-$50/month for tools |
| $100K - $500K | Consider a bookkeeper | $200-$500/month |
| $500K - $2M | Ecommerce-specialized bookkeeper | $500-$1,500/month |
| $2M+ | Ecommerce CPA + bookkeeper | $1,000-$3,000+/month |
Under $100K, a good automation tool and basic accounting software handle everything. You spend 2-3 hours per month reviewing and reconciling. That’s manageable.
Between $100K and $500K, a bookkeeper saves you time and catches errors you’d miss. They handle monthly reconciliation, categorize transactions, and keep your books current. You focus on selling.
Above $500K, you need someone who understands ecommerce specifically. Not a general bookkeeper, one who knows marketplace settlement reports, multi-state sales tax, inventory accounting, and the quirks of Amazon’s payout system.
Above $2M, add a CPA for tax strategy and compliance. The deductions, entity structure, and tax planning opportunities at this level pay for the accountant multiple times over.
For accountants and bookkeepers who serve ecommerce clients, Taxomate offers a partner program with client management features.
Bookkeeper vs Accountant vs CFO
These are different roles. Don’t overpay for what you don’t need, and don’t underpay for what you do.
Bookkeeper: Handles daily/weekly recording. Categorizes transactions, reconciles bank statements, manages accounts payable/receivable. They maintain your books. Most ecommerce sellers need a bookkeeper first.
Accountant/CPA: Handles tax strategy, compliance, and financial statement preparation. They review what the bookkeeper creates and make strategic recommendations. CPAs can represent you before the IRS. You need one for annual tax filing at minimum.
Fractional CFO: Strategic financial planning. Cash flow forecasting, fundraising support, budgeting, pricing strategy, exit planning. You don’t need a CFO until you’re well into seven figures or preparing for a significant financial event.
The ecommerce-specific need: At every stage, make sure your professional understands online selling. A fantastic local CPA who’s never seen an Amazon settlement report will struggle with your books. An average bookkeeper who works with 20 ecommerce sellers will handle your books better.
How to Vet an Ecommerce Accountant
Before hiring, ask these five questions:
-
“How many ecommerce sellers do you currently work with?”: You want at least 5-10. Experience with marketplace accounting matters.
-
“Are you familiar with Amazon settlement reports and Shopify payouts?”: If they look confused, they’ll spend hours learning on your dime.
-
“What accounting software do you recommend, and what automation tools do you use?”: Good answers: QuickBooks or Xero plus a marketplace automation tool. Bad answer: “We’ll just use spreadsheets.”
-
“How do you handle multi-state sales tax?”: They should mention economic nexus thresholds, marketplace facilitator laws, and possibly recommend a tax compliance tool.
-
“What’s your fee structure, flat monthly rate or hourly?”: Flat monthly is almost always better for ecommerce. Hourly rates incentivize your bookkeeper to be slow. Flat rates incentivize them to build efficient systems.
Red flags:
- They’ve never heard of settlement-based accounting
- They suggest recording marketplace deposits as single-line entries
- They don’t mention any automation tools
- They quote hourly rates for ongoing bookkeeping
- They can’t explain the difference between cash and accrual for ecommerce
Finding the right professional is an investment. A good ecommerce accountant saves you more than they cost through better tax strategy, caught errors, and time you reinvest into growing your business.
Monthly Close Checklist
No other guide gives you this. A concrete, step-by-step monthly close process for ecommerce sellers. Do these nine things every month and your books will stay clean, your taxes will be accurate, and you’ll actually know how your business is performing.
1. Reconcile all marketplace settlements and payouts Check that every Amazon settlement, Shopify payout, eBay payment, and Etsy deposit has a matching journal entry in your accounting software. If you use automation, verify that all entries posted correctly.
2. Match settlements to bank deposits Each journal entry total should match a corresponding bank transaction. Flag any mismatches. Common causes: timing differences, currency conversion, partial settlements.
3. Record manual transactions Not everything flows through automation. Supplier payments, refunds processed outside the marketplace, bank fees, owner draws, enter these manually.
4. Review COGS and inventory values Check that your inventory balances match reality. If you’ve received new stock, ensure the cost was recorded. If you ran a promotion, verify COGS reflects the correct units sold.
5. Reconcile sales tax collected vs remitted Compare the sales tax your marketplaces collected with what you’ve remitted to each state. Marketplace facilitator laws handle most of this, but verify nothing slipped through.
6. Review advertising spend categorization Confirm that Amazon PPC, Facebook ads, Google ads, and any other advertising costs are in the right expense accounts. Ad spend is one of the most commonly miscategorized expenses.
7. Run your P&L and compare to prior month Look at revenue, gross margin, fee percentages, and net profit. Compare month over month. Any significant change should have an explanation.
8. Flag anomalies Fee spikes, refund rate increases, margin drops, unexpected charges, investigate anything that moved more than 10% from last month. Problems caught early are cheap to fix. Problems caught in December are expensive.
9. Export reports for your accountant If you work with a bookkeeper or CPA, send them your monthly P&L, balance sheet, and any flagged items. Keep them in the loop so quarterly tax estimates are accurate.
Pro tip: Schedule your monthly close for the same day every month. The 5th or 10th works well, it gives marketplaces time to finalize the prior month’s settlements. Put it on your calendar. Treat it like a meeting you can’t skip. The sellers who do this monthly never panic at tax time. The ones who don’t are the ones scrambling in March.
Total time: 2-4 hours per month with automation. 8-12+ hours without it. That’s the difference between a Saturday morning task and a weekend-killing chore.
Frequently Asked Questions
What is ecommerce accounting?
Ecommerce accounting is the process of tracking revenue, marketplace fees, refunds, taxes, and cost of goods sold from online sales. It’s different from traditional accounting because marketplaces like Amazon and Shopify bundle hundreds or thousands of individual transactions into single settlement payments. Your bank sees one deposit. Proper accounting breaks that deposit into every component, sales, referral fees, fulfillment fees, refunds, tax collected, so your books reflect reality.
What accounting software is best for ecommerce?
QuickBooks Online is the most popular choice for US-based ecommerce sellers. It has the largest ecosystem of third-party integrations, strong inventory features, and most accountants know it well. Xero is the better choice for international sellers who need strong multi-currency support. Wave is a solid free option for beginners, though it has fewer marketplace integrations. All three connect to automation tools like Taxomate that pull in marketplace data automatically.
Do I need an accountant for my online store?
Most sellers under $100K/year can handle their own books using good software and an automation tool. Between $100K and $500K, a bookkeeper ($200-$500/month) saves you time and catches errors. Above $500K, an ecommerce-specialized accountant pays for itself through tax savings and strategic advice. Above $2M, you likely need both a bookkeeper and a CPA. The key is finding someone who understands marketplace settlement reports, not just any accountant.
How do I set up a chart of accounts for ecommerce?
Start with your accounting software’s default chart of accounts, then customize it for ecommerce. Add separate revenue accounts per sales channel (Amazon, Shopify, eBay). Create expense accounts for each fee type, referral fees, FBA fees, storage fees, transaction fees. Add COGS accounts for product cost, inbound shipping, and packaging. Include a sales tax payable liability account. The more granular your chart of accounts, the more visibility you have into where your money goes.
Should I use cash or accrual accounting for ecommerce?
Accrual accounting is recommended for most ecommerce businesses doing over $100K/year in revenue. It records revenue when earned (when the order ships), not when cash arrives, which gives you an accurate monthly picture. Cash basis works fine below $100K or for very simple operations. Modified cash basis is a practical middle ground that uses cash for most transactions but accrual for inventory. Consult your accountant, this decision has real tax implications and is hard to reverse mid-year.
How do I reconcile marketplace settlements?
The most efficient method is using an automation tool like Taxomate. The tool connects to your marketplace account, pulls each settlement’s data, breaks it into components (sales, fees, refunds, taxes), maps each to the correct account in your accounting software, and creates a journal entry. The journal entry total matches your bank deposit exactly. You then match the journal entry against the bank transaction in QuickBooks or Xero, a one-click reconciliation. Without automation, you’d export settlement reports, manually categorize each line item, create journal entries by hand, and hope the totals match.
Get Your Ecommerce Books Right. Starting Today
Ecommerce accounting isn’t optional. It’s the difference between knowing your real profit and guessing. It’s the difference between paying the right amount in taxes and overpaying by thousands. It’s the difference between a business you understand and one that surprises you.
You now have everything you need:
-
Choose your accounting method. Cash for simplicity. Accrual for accuracy. Modified cash for a practical middle ground. Match it to your revenue stage and talk to your accountant.
-
Set up your chart of accounts. Separate accounts for each fee type, each sales channel, each cost category. Granularity now saves pain later.
-
Connect an automation tool. Stop copying numbers from settlement reports into spreadsheets. Let software handle the data. You handle the decisions.
Taxomate connects your marketplaces to your accounting software in about 5 minutes. Amazon, Shopify, eBay, Walmart, Etsy, all to QuickBooks, Xero, or Wave. The Multi plan gives you unlimited sales channels starting at $27/month. Every plan includes free historical data imports and free 1:1 onboarding.
No setup fees. No per-channel charges on the Multi plan. No limits on history.
See pricing | Start free trial | Connect Amazon to QuickBooks | Connect Shopify to QuickBooks