You sell on Amazon, Shopify, and Etsy. Amazon pays you every two weeks. Shopify pays daily. Etsy pays weekly. Each platform calculates fees differently, reports revenue differently, handles refunds differently, and deposits money into your bank account on a different schedule. Your bank statement shows 38 deposits last month from three different sources. Your QuickBooks shows $214,000 in revenue. Your combined platform dashboards show $287,000 in gross sales. And there is a $4,200 discrepancy between what the platforms say they paid you and what your bank actually received.
Welcome to multi-channel seller reconciliation — the single most time-consuming and error-prone task in e-commerce bookkeeping. It is also the most important, because without it, your financial statements are fiction.
This guide covers the step-by-step reconciliation process for multi-channel sellers: platform-specific settlement handling, the three-way matching methodology, unified chart of accounts design, inventory tracking across channels, automation tools, and the monthly close process that keeps everything clean. For the broader e-commerce bookkeeping framework, see our complete e-commerce seller bookkeeping guide.
Multi-channel selling creates financial complexity that scales exponentially. A single-channel Amazon seller has one settlement to reconcile per payment period. Add Shopify and Etsy, and you have three different data sources — each with its own format, fee structure, payout schedule, and quirks.
Here is what makes multi-channel reconciliation different from single-channel:
| Platform | Payout Frequency | Typical Delay | Deposits Per Month |
|---|---|---|---|
| Amazon | Biweekly | 3-5 business days after settlement | 2 |
| Shopify Payments | Daily or rolling | 2-3 business days | 20-22 |
| Etsy | Weekly (or daily for eligible shops) | 3-5 business days | 4-5 (weekly) or 20+ (daily) |
| PayPal | Immediate or daily batch | 0-1 business days | 20-30 |
| Walmart | Biweekly | 3-5 business days | 2 |
A three-channel seller (Amazon + Shopify + Etsy on weekly deposits) receives approximately 28-30 deposits per month into potentially multiple bank accounts. Each deposit must be traced back to a settlement or payout report, verified against the platform data, and posted to the accounting system with proper categorization.
Each platform takes a different cut, calculated differently:
| Fee Type | Amazon | Shopify | Etsy |
|---|---|---|---|
| Commission / Referral | 8-15% of sale price | None (with Shopify Payments) | 6.5% transaction fee |
| Payment Processing | Included in referral fee | 2.5-2.9% + $0.30 | 3% + $0.25 |
| Fulfillment (if applicable) | $3.22 – $10.48+ (FBA) | N/A (self-fulfilled) | N/A (self-fulfilled) |
| Listing Fees | $0.99/item or $39.99/mo Pro | Included in subscription | $0.20 per listing |
| Advertising | PPC (variable) | N/A (external ads) | 12-15% Offsite Ads (if eligible) |
| Subscription | $39.99/mo (Pro) | $39-$399/mo | $15/mo (Plus, optional) |
The total fee burden on a $30 product: Amazon might take $9.70 (32%), Shopify Payments takes $1.17 (3.9%), and Etsy takes $3.65 (12.2%). If your books do not separate fees by platform, you cannot determine which channel is actually the most profitable after all-in costs.
Amazon gives you a settlement report every two weeks as a flat file. Shopify provides a payout detail page in the admin dashboard. Etsy offers a payment CSV download. None of them use the same column names, transaction categories, or accounting terminology. Your bookkeeper (or your automation tool) must translate three different reporting formats into a unified chart of accounts.
Multi-channel seller reconciliation requires matching three data sources for every platform, every month:
Source 1: Platform settlement/payout report — What the platform says happened (gross sales, fees deducted, refunds processed, net payout amount).
Source 2: Bank deposits — What actually arrived in your bank account.
Source 3: Accounting records — What your books say happened (QuickBooks or Xero journal entries for that platform). This three-way reconciliation aligns with AICPA internal control guidelines for verifying transaction completeness and accuracy.
All three must agree. When they do not, the discrepancy falls into one of these categories:
The most common reconciliation discrepancy. A sale occurs on March 31, the settlement covers it in the April 1-14 period, and the deposit arrives on April 18. This sale belongs in March revenue (under accrual accounting), the settlement in the first half of April, and the bank deposit in mid-April. Three different dates, one transaction.
Resolution: Use the order/shipment date for revenue recognition, not the deposit date. A2X and Link My Books handle this automatically.
Amazon occasionally charges incorrect fees — wrong referral fee category, incorrect FBA size tier measurement, or duplicate charges. These appear as differences between expected fees (based on your product dimensions and categories) and actual fees on the settlement report.
Resolution: Compare actual fees to expected fees monthly. File fee correction cases with Amazon Seller Support for overcharges. Record fee corrections as a reduction to marketplace fees when reimbursed.
Orders that appear in one source but not another. A customer places an order on Shopify, but the payment fails and the order is not fulfilled — yet it still shows in Shopify’s order report. Or a return is processed on Amazon that reduces a future settlement, but the corresponding order was from a previous period.
Resolution: Run order-level reports from each platform and match to accounting entries. Investigate orders present in the platform but missing from the books (or vice versa).
Amazon and Shopify Payments both hold reserves under certain conditions (new seller accounts, high chargeback rates, seasonal reserves). These reduce your payout but are not expenses — they are your money being held temporarily.
Bookkeeping treatment: Record reserves as a transfer from Cash to a “Marketplace Reserves” asset account. When the reserve is released, reverse the entry. Do not record reserves as an expense — this understates your revenue and creates a reconciliation problem when the funds are eventually released.
Pro Tip: Create a reconciliation log — a simple spreadsheet that tracks discrepancies, their cause, their resolution, and the date resolved. A discrepancy that persists for more than one month is a sign that something structural is broken in your bookkeeping setup. Do not carry unresolved discrepancies forward.
The foundation of multi-channel reconciliation is a chart of accounts that captures revenue and fees by platform while still producing consolidated financial statements. The structure from our e-commerce bookkeeping guide is designed for this purpose.
The key principle: Revenue accounts are split by channel. COGS accounts are not.
Your products have the same landed cost regardless of which channel sells them. Splitting revenue by channel (Amazon, Shopify, Etsy) while keeping COGS consolidated allows you to calculate:
The most valuable output of multi-channel reconciliation is a channel-level P&L that looks like this:
| Line Item | Amazon | Shopify | Etsy | Total |
|---|---|---|---|---|
| Gross Revenue | $120,000 | $85,000 | $22,000 | $227,000 |
| Returns & Refunds | ($14,400) | ($5,100) | ($1,760) | ($21,260) |
| Net Revenue | $105,600 | $79,900 | $20,240 | $205,740 |
| COGS (allocated by units sold) | ($42,000) | ($29,750) | ($7,700) | ($79,450) |
| Gross Profit | $63,600 | $50,150 | $12,540 | $126,290 |
| Marketplace Fees | ($37,800) | ($2,340) | ($2,860) | ($43,000) |
| Advertising | ($14,400) | ($6,800) | ($2,200) | ($23,400) |
| Contribution Margin | $11,400 | $41,010 | $7,480 | $59,890 |
| Contribution % | 10.8% | 51.3% | 37.0% | 29.1% |
This report reveals what most multi-channel sellers suspect but cannot prove: Amazon generates the most revenue but the worst margins. Shopify (direct-to-consumer) has the highest contribution margin by far. Etsy sits in the middle. Without channel-level reconciliation, you would see $227,000 in revenue and $59,890 in contribution and have no idea where to focus growth efforts.
Multi-channel inventory management adds a reconciliation layer that single-channel sellers do not face: the same products exist in multiple locations and are sold through multiple platforms simultaneously.
A typical multi-channel seller holds inventory in:
Without real-time inventory sync, you risk selling a product on Shopify that was just sold (but not yet updated) on Amazon. Overselling leads to cancelled orders, negative reviews, and refund costs.
Inventory management solutions:
Per IRS recordkeeping requirements, you must maintain records that support every income and expense item on your tax return — including inventory valuations across all locations. For accounting purposes, all inventory — regardless of location — appears on one line of the balance sheet: Inventory (asset). But your bookkeeper needs to reconcile the total against platform-level inventory reports:
Monthly inventory reconciliation:
Discrepancies above 2% of total units indicate a systemic tracking problem — usually caused by returns not being properly received back into inventory, transfers between locations not being recorded, or manual adjustments made on one platform but not reflected in the accounting system.
Manual reconciliation across three or more channels is agonizing above 500 total orders per month. Here are the tools that make it manageable:
A2X is the gold standard for multi-channel reconciliation with QuickBooks or Xero. It connects to Amazon, Shopify, Etsy, eBay, and Walmart independently, reads each platform’s settlement/payout data, and posts categorized journal entries to your accounting software.
Key advantages:
Pricing: Each platform connection is priced separately. For Amazon + Shopify + Etsy, expect $60-$200/month depending on order volume.
Similar to A2X but focused on Amazon and Shopify (Etsy support is newer). Slightly lower price point and simpler interface. Good for two-channel sellers who do not need eBay or Walmart integration.
Goes beyond integration — Finaloop attempts to handle the entire bookkeeping function for e-commerce sellers. It pulls data from all platforms, categorizes transactions, and produces financial statements. Best for sellers who want a turnkey solution rather than managing the tool-to-QuickBooks pipeline themselves.
Important: Automation tools are only as good as their configuration. A2X with default account mappings will produce clean journal entries that tie to your bank — but they will use generic account names. Take the time to customize the account mapping to match your chart of accounts structure. The upfront setup takes 2-3 hours per platform; it saves hundreds of hours per year in reconciliation.
A structured monthly close process prevents reconciliation backlogs from compounding. Here is the process we use with our multi-channel e-commerce clients:
Amazon:
Shopify:
Etsy:
Every month-end close for multi-channel sellers involves these standard adjustments:
These are the warning signs that your reconciliation process needs professional help:
Each of these signals a structural problem that gets worse with time. Unreconciled months compound — a 2% discrepancy in January becomes a 12% discrepancy by June because errors in prior months mask errors in current months.
Ready for clean multi-channel financials? We specialize in e-commerce bookkeeping for sellers on 2+ platforms. Get an instant quote based on your channel mix and order volume, or visit our marketplace seller bookkeeping page to see how we work.
Get a free quote and see how Steph's Books can save you 40-60% vs hiring in-house.
