featured article

From 11 Days to 3: How a $5M Amazon and Shopify Brand Automated COGS

Nachman Lieser

July 30, 2026

This is a composite, not a single named customer. It is built from the pattern we see repeatedly across multi-channel sellers in the $3M to $8M range, assembled into one representative brand so the before-and-after is concrete.

A note on what this is

The brand below is illustrative. It is a representative composite drawn from common patterns across Amazon-and-Shopify sellers in the mid-seven-figure range, not a specific real customer. The numbers are typical of what sellers at this scale report, assembled into one story so the mechanics are clear rather than abstract. Treat the figures as a representative example.

The starting point: a $5M brand drowning in its own close

Picture a consumer-products brand doing about $5M a year, roughly 60% on Amazon FBA and 40% on its own Shopify store, with around 180 active SKUs. The owner had a part-time bookkeeper and a tax CPA. On paper, a healthy business. In practice, the books were a month behind and the owner could not answer a basic question: which products actually made money.

The close took 11 business days. That is not a typo. Every month, the bookkeeper pulled Amazon settlement reports and Shopify payout reports, hand-keyed summary numbers into QuickBooks, estimated cost of goods sold as a single blended percentage, and tried to reconcile deposits that never matched the sales figures because of fees, refunds, and reserves. By the time the books closed, the data was six weeks stale and too coarse to act on.

The three problems underneath

The 11-day close was a symptom. Three specific failures caused it.

  • COGS was a guess. With 180 SKUs bought at different costs across different purchase orders, a single blended COGS percentage was fiction. High-margin and low-margin products were averaged into one meaningless number.
  • Settlement deposits never reconciled cleanly. The Amazon deposit was net of fees, ads, refunds, and reserves. Reconciling it by hand to gross sales meant hours of detective work every month, and reserves were either ignored or mis-booked.
  • Inventory lived in a spreadsheet. Units sat across FBA, a 3PL, and a home warehouse, tracked in a tab that was usually wrong, so the inventory asset on the balance sheet never tied to reality.

The combined effect: the owner priced products, chose what to reorder, and judged channel performance from numbers that were both late and inaccurate.

What changed

The brand kept its QuickBooks ledger and its CPA. It added ConnectBooks as the layer between the channels and the ledger. The setup work was establishing an accurate per-location opening inventory value and mapping the chart of accounts. From there:

  • Amazon and Shopify settlement data synced automatically, with fees, refunds, and reserves broken out.
  • COGS was applied per unit on FIFO, so each sale carried its actual cost.
  • Inventory was tracked across FBA, 3PL, and the warehouse in one place.
  • The Amazon clearing balance reconciled to the live Seller Central balance, reserves included.

The bookkeeper stopped hand-keying and started reviewing.

The before and after

METRICBEFOREAFTER
Month-end close11 business days3 business days
COGS methodSingle blended estimatePer-unit FIFO, per SKU
Books current as of\~6 weeks staleWithin days
Deposit reconciliationManual, hours per channelAutomated
Inventory accuracySpreadsheet, often wrongTracked across 3 locations
SKU-level marginUnknownVisible per product and channel

The close dropping from 11 days to 3 is the headline, but the more valuable change was the second row. Once COGS was per unit, the owner could finally see that a handful of SKUs treated as winners were near break-even after true landed cost and fees, while several quiet products carried the real margin. The reorder and pricing decisions changed within the first month.

Why the COGS accuracy mattered most

A blended COGS percentage does not just blur the numbers; it actively misleads. At this brand, the blended figure suggested every product cleared a comfortable margin. Per-unit FIFO COGS told the truth: cost varied widely by SKU and purchase batch, and once Amazon fees and ad spend were attributed correctly, the margin spread across products was enormous. Decisions made on the blended number had been quietly subsidizing losing SKUs with the profit from winning ones, with no visibility into either.

This is the pattern across mid-market multi-channel sellers. The close time is the pain they feel; the COGS inaccuracy is the problem that actually costs them money.

The visibility payoff

Three days to close is operational relief. The strategic payoff is decisions made on current, accurate, SKU-level data. The owner could see channel-level P&L, know real margin before reordering, and walk into the CPA meeting with reconciled books instead of a reconstruction project. ConnectBooks syncs Amazon, Shopify, Walmart, eBay, and TikTok Shop into QuickBooks Online, QuickBooks Desktop, or Xero, applies FIFO COGS per unit, and produces per-channel P&L. Plans start at $149/mo. See /integrations/amazon-accounting.

Crunch, the AI CFO feature, is in active beta with a waitlist for the full release, designed to turn that clean, current data into forward-looking cash and profit guidance. See /crunch.

NEXT STEPCut your close from weeks to days and finally see real per-SKU margin. ConnectBooks automates COGS and settlement sync, starting at $149/mo. See /pricing.

Is this case study a real, named customer?

No. It is a composite, a representative example assembled from common patterns we see across multi-channel Amazon and Shopify sellers in the roughly $3M to $8M range. The figures are typical of what sellers at this scale report, combined into one illustrative brand so the before-and-after mechanics are concrete rather than abstract.

Why does a blended COGS percentage cause problems?

Because it averages products with very different costs into one number, hiding which SKUs actually make money. A brand with many SKUs bought at different prices across different purchase orders cannot judge margin, pricing, or reorder decisions from a blended figure. Per-unit FIFO COGS attributes each sale its actual cost, which often reveals that supposed winners are near break-even and quiet products carry the real margin.

How does automating COGS shorten the month-end close?

The close is slow mostly because someone is hand-keying settlement summaries, estimating COGS, and manually reconciling deposits that never match sales. Automating the settlement sync and applying COGS per unit removes that manual work, so the bookkeeper reviews reconciled data instead of rebuilding it. That is what takes a close from around 11 days to about 3.

What was the most valuable change, the faster close or the COGS accuracy?

The COGS accuracy. The faster close is operational relief, but the per-unit COGS is what changed business decisions, because it exposed the true margin spread across products that a blended estimate had hidden. The brand adjusted pricing and reordering in the first month on the strength of numbers it could finally trust.

Could a Shopify-and-Amazon seller keep QuickBooks during this?

Yes. In this composite the brand kept its existing QuickBooks ledger and CPA and added ConnectBooks as the layer between its channels and the ledger. The setup was establishing an accurate opening inventory value per location and mapping the chart of accounts, after which settlements synced automatically with per-unit COGS applied. ConnectBooks supports QuickBooks Online, QuickBooks Desktop, and Xero.

Clean, accurate books make this manageable. Start a free trial of ConnectBooks to get settlement-level accuracy and real margin visibility for your ecommerce business. No credit card required.

Take Control of Your E-Commerce Business with ConnectBooks

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