A multi-marketplace home and kitchen brand doing $7M in annual revenue across Amazon, Shopify, Walmart, eBay, and TikTok Shop spent two years using a part-time bookkeeper and an increasingly complex Google Sheet. In April 2026, they migrated to ConnectBooks. Here's what they found, and what changed.
The business: 14-product home and kitchen brand, founded 2021, based in Atlanta. Five active sales channels by late 2025. Annual revenue around $7M, with Amazon at 58%, Shopify DTC at 22%, Walmart at 10%, eBay at 6%, and TikTok Shop at 4% and growing.
The accounting setup before migration: QuickBooks Online Plus as the general ledger. A part-time bookkeeper (8 hours/week) handling reconciliation and month-end close. A Google Sheet maintained by the founder for SKU-level cost tracking, updated monthly. Amazon settlements reconciled via A2X. The other four channels handled manually via the bookkeeper's QuickBooks bank feeds and journal entries.
Three problems showed up consistently in the 18 months before the migration:
Total migration time from kick-off to full cutover: 30 days. Week-by-week:
Week 1: Account setup, marketplace connections, historical data pull from each marketplace going back 90 days. Mapped 14 SKUs across 5 marketplace-specific SKU codes per channel.
Week 2: Imported inventory ledger with current per-unit landed costs. Found three SKUs where the spreadsheet hadn't been updated with the Vietnam tariff adjustment from October 2025. Real variable COGS was 8-12% higher than what the sheet showed.
Week 3: Ran ConnectBooks and A2X in parallel for two weeks across Amazon settlements. Found two small categorization differences (around $400 total). ConnectBooks was more granular on FBA storage fees.
Week 4: Cut over fully. The bookkeeper's weekly time dropped from 8 hours to 3.
| Metric | Before | After (90 days post-cutover) |
|---|---|---|
| Bookkeeper hours/week | 8 | 3 |
| Effective bookkeeping cost/month | $1,200 | $450 + ~$300 software |
| SKU-level profit visibility | Quarterly, in spreadsheet | Real-time, in app |
| Amazon reimbursements claimed | $1,800/yr estimated | $4,800 in first 90 days |
| Walmart fee misclassification rate | ~3% of fees | 0% (automated) |
| Time to monthly close | 9 business days | 3 business days |
Three weeks after cutover, the SKU-level P&L view showed that one of the company's top-10-by-revenue SKUs was actually losing money on Walmart at the current price point. The Walmart referral fee, FBA storage allocation, and current landed cost had crossed contribution-margin-negative without anyone noticing. The founder's response: raise the Walmart price by $4.50 (Amazon stayed the same), which moved the SKU from -2% contribution margin to +18%. Monthly revenue on Walmart for that SKU dropped about 8%, but contribution dollars increased.
This is the kind of decision the Google Sheet wasn't showing because the Sheet didn't allocate Walmart-specific fees per SKU. The aggregate company P&L looked healthy; the SKU-level P&L revealed where the leak was.
We could see the company was making money. We had no idea which products were making it. After the migration, the answer was less obvious than we expected. Two of our top sellers were dragging down the others, and one of our smaller SKUs was carrying disproportionate margin. We've restructured our marketing budget around what we learned in the first 60 days.
See if ConnectBooks fits your operation. 30-day free trial. We'll help with the migration setup, including a parallel comparison period if you're moving from A2X or another tool.
Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.
Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo
