Bookkeeping, accounting, and fractional CFO services for small businesses across Central Florida.

Call or Text: (407) 476-6348

How do I track inventory and sales across Amazon, Shopify, and eBay in one set of books?

The biggest mistake multichannel sellers make is recording Amazon, Shopify, and eBay deposits as single income transactions from their bank feed. That deposit from Amazon isn’t your revenue. It’s a net payout after Amazon has already deducted marketplace fees, refunds, advertising costs, and FBA charges. If you record the deposit as income, your books understate actual revenue and completely hide what it costs to sell on each platform.

The right approach is using a multichannel integration tool like A2X, Bookkeep, or Klayena. These tools connect to each sales platform and to QuickBooks Online, then summarize each platform’s daily or settlement-period activity into detailed journal entries. Instead of one mystery deposit, you get a clean breakdown of gross sales, marketplace fees, shipping costs, refunds, and the net payout. That level of detail is what makes your financial reports actually useful.

Your chart of accounts setup matters just as much as the tool itself. Each sales channel should have its own income account or class in QuickBooks Online. You want to pull a profit and loss report filtered by Amazon, Shopify, or eBay individually. Without that separation, you might see that your total business is profitable while having no idea that one platform is actually losing money after fees and returns. Channel-level profitability is the whole reason for doing this correctly.

For inventory, the challenge is that your stock is often shared across platforms but sold through different channels at different price points with different fee structures. Your integration tool handles the sales and fees side, but you still need accurate cost of goods sold. That means maintaining proper inventory records with consistent unit costs. If you’re using FBA for Amazon but self-fulfilling Shopify orders, your fulfillment costs differ by channel and your books should reflect that difference.

Reconciliation ties everything together. Each platform settles on its own schedule. Amazon might pay every two weeks, Shopify daily, and eBay weekly. The integration tool creates journal entries when sales happen, and then you match the actual bank deposit to the expected payout. When the numbers don’t match, you catch discrepancies quickly instead of discovering a $3,000 problem six months later.

Sales tax adds another layer. Amazon handles collection and remittance in most states through Marketplace Facilitator rules, but Shopify may require you to manage it depending on your configuration. Your books need to track what was collected and by whom so you don’t double-report or miss a filing in Florida or any other state where you have nexus.

If you’re already selling on multiple platforms but your books are a mess of lump-sum deposits with no detail, that’s fixable. Our bilingual bookkeeping services include getting your integration tools connected and your QuickBooks Online chart of accounts structured properly. The upfront setup takes some effort, but it saves hours every month and gives you numbers you can actually trust.

The sellers who scale successfully on multiple platforms are the ones who know their real margins by channel. Guessing which platform performs best based on gross sales alone leads to bad decisions. With the right tools and proper accounting structure, your books tell you exactly where to invest more and where to cut back. That kind of clarity is what turns an e-commerce business from a side hustle into something that grows intentionally.

Central Florida's Trusted Bookkeeping Firm

Start Here:
A 30-Minute Consultation

Tell us about your business and what's going on with your books. We'll figure out exactly what you need, and give you a straightforward quote.

More Questions

How does sales tax nexus work for a Florida-based e-commerce seller shipping to other states?

Your Florida location creates automatic nexus in the state, but you likely owe sales tax in other states too. Since the 2018 Wayfair ruling, any state where you exceed economic nexus thresholds can require you to collect and remit sales tax.

Read answer

How should a dropshipping business track cost of goods sold when inventory is never on hand?

Track COGS per order by recording the supplier cost plus shipping to the customer for every sale. Set up products as non-inventory items in QuickBooks Online so each transaction captures both revenue and cost automatically.

Read answer

How do I track startup costs and the initial franchise fee when opening a new location?

Pre-opening costs like training, travel, build-out, and initial inventory are capitalized as startup costs and amortized over 15 years under Section 195. The franchise fee is a separate intangible asset that gets amortized over the term of your franchise agreement.

Read answer

What's the difference between FIFO, LIFO, and weighted average for inventory valuation?

FIFO records the oldest inventory costs as cost of goods sold first, LIFO records the newest costs first, and weighted average blends all costs together. The method you pick directly affects your reported profit and tax liability.

Read answer

What's the best way for a retail store to catch and track inventory shrinkage?

Regular physical inventory counts compared against your book inventory reveal shrinkage. The key is doing counts frequently enough to catch problems early and categorizing losses so you can identify patterns and root causes.

Read answer

How do I record franchise territory rights as an asset and amortize them over time?

Record the initial franchise fee as an intangible asset called Franchise Rights. Then amortize it using straight-line amortization over the life of your franchise agreement, which is typically 10 to 20 years.

Read answer

Orlando bookkeeping firm serving small businesses across Central Florida. Full-service bookkeeping, accounting, and advisory services backed by 10+ years of accounting experience. QuickBooks ProAdvisor certified and bilingual in English and Spanish.

Service Area

Serving Orlando, Lake Nona, Avalon Park, Winter Park, Kissimmee and surrounding areas

Client Reviews

5-Star Rated Firm

Social

  • QuickBooks ProAdvisor badge
  • QuickBooks Online Certification Level 1 badge
  • QuickBooks Online Certification Level 2 badge
  • GDA Certificate badge

© 2026 Zacosta Bookkeeping Services