How do I handle multi-channel sales bookkeeping for Amazon and Shopify?
The challenge with multi-channel sales is that what lands in your bank account looks nothing like what you actually sold. Amazon deposits every two weeks after deducting FBA fees, referral fees, refunds, and other charges. Shopify deposits more frequently but also nets out payment processing fees. If you record just the deposits as revenue, your books understate actual sales and hide the true cost of selling on each platform.
The right approach tracks gross sales, fees, refunds, and net deposits separately for each channel. This means setting up your chart of accounts to capture Amazon sales, Shopify sales, Amazon fees, Shopify fees, and so on. When a $1,000 Amazon payout hits your bank, you need to know it actually represents $1,200 in sales minus $150 in FBA fees, $30 in referral fees, and $20 in refunds. E-commerce businesses that skip this step end up with financials that technically balance but tell them nothing useful about profitability.
Integration tools make this manageable. A2X and Link My Books connect directly to Amazon Seller Central and Shopify, pulling settlement data and creating accurate journal entries in QuickBooks or Xero. They break down exactly what’s in each payout so your revenue and fee accounts match reality. Without these tools, you’re manually pulling reports and trying to reconcile numbers that never quite tie out.
Inventory adds another layer of complexity. When the same products sell on both platforms, you need a system that tracks total inventory across channels. Otherwise your cost of goods sold calculations won’t be accurate and you won’t have a clear picture of stock levels. Some businesses use inventory management software that syncs with both Amazon and Shopify, while others track it manually through periodic counts.
The goal is knowing channel-by-channel profitability. Amazon might generate more volume but also higher fees. Shopify might have better margins but require more marketing spend to drive traffic. Without proper small business bookkeeping that separates each channel, you can’t see which one actually makes money and which one just looks busy.
Common mistakes include recording net deposits as gross revenue, which hides your true sales volume and fee burden. Another is mixing all e-commerce sales into one revenue account, making it impossible to compare channel performance. Monthly reconciliation catches these issues early. Compare your sales reports from Amazon Seller Central and Shopify admin to what’s recorded in your books. The numbers should tie within a few dollars. If they don’t, something isn’t posting correctly and the longer you wait, the harder cleanup becomes.
Full-Service Bookkeeping for Greater Phoenix
The Next Step:
A Quick Conversation
Tell us about your situation. We'll listen, ask a few questions, and give you a clear price to handle the work.
More Questions
How do I account for gift cards and store credit?
Gift cards and store credit are liabilities until redeemed, not revenue when sold. Record the sale as a liability, then recognize revenue when the customer uses the card or credit toward a purchase.
Read answerWhat's the best way to track Amazon seller fees in QuickBooks?
The key is breaking apart Amazon's net deposits into gross sales and individual fee categories. You can do this manually using settlement reports or automate it with integration tools like A2X.
Read answerWhy don't my Amazon deposits match my sales reports?
Amazon deposits are net amounts after fees, refunds, advertising costs, and reserves are deducted. The number hitting your bank is what remains after Amazon takes its cut, not your gross sales.
Read answerHow do I account for Amazon advertising costs in my books?
Record Amazon advertising costs as a marketing expense, separate from your cost of goods and Amazon seller fees. The tricky part is extracting clean data since Amazon deducts ad spend from your settlements before depositing to your bank.
Read answerWhat bookkeeping mistakes do Amazon sellers make most often?
The biggest mistakes are recording Amazon's disbursement as total revenue, not tracking inventory costs properly, and ignoring the detailed fee breakdown. These errors make it impossible to understand your actual profit margins.
Read answerHow much does bookkeeping cost for a small business?
Small business bookkeeping typically costs $200 to $600 monthly for basic services. The actual price depends on transaction volume, industry complexity, and whether you need just the basics or more comprehensive financial management.
Read answer