Ecommerce COGS Reconciliation: How to Tie Inventory to Cost of Goods Sold

Key Takeaways

• Ecommerce COGS reconciliation matches every unit sold to a verified cost — beginning inventory plus purchases minus ending inventory equals COGS.
• Even a 1–2% shift in COGS can affect profit more than a large jump in revenue, according to Seller Candy.
• Marketplace settlements must be broken into components — gross sales, platform fees, refunds, and ad charges — before any figure hits your books.
• Inventory adjustments exceeding 10% of total inventory value over a year are a red flag for process problems, per A2X Accounting.
• COGS drifts from inventory movement when landed costs are missing, settlements are recorded gross, or shrinkage is never written off.

Ecommerce COGS reconciliation is the process of comparing your inventory movement records — units received, units sold, units adjusted — against the cost of goods sold figure on your income statement, so every sale has a verified, complete cost behind it. Done monthly, it keeps gross margin trustworthy. Skipped, it lets small errors compound into a P&L that looks fine while the underlying numbers are wrong.

The COGS formula is straightforward: Beginning Inventory + Purchases and Direct Costs − Ending Inventory = COGS (Iris Finance). The reconciliation work is making sure each of those inputs is accurate before you close the month.

How Do You Reconcile Inventory to COGS for an Ecommerce Business?

Inventory-to-COGS reconciliation runs in five steps. Each step closes a specific gap between what your system says and what actually happened.

Step 1: Confirm your beginning inventory balance

Your beginning inventory for the current month must equal the ending inventory from the prior month — after any adjustments were posted. If those two numbers don't match, investigate before moving forward. A mismatch here cascades through every downstream calculation.

Step 2: Record all inventory receipts at landed cost

Every purchase order received during the month needs to be recorded at its full landed cost: supplier invoice price plus inbound freight, import duty, and any prep or inspection fees. Seller Candy identifies tracking landed cost at the SKU level as a foundational step — not an optional refinement. If you receive 500 units at a hypothetical (illustrative) $12 landed cost each, your inventory asset increases by $6,000, not just the $10 supplier price per unit.

Syncing purchase orders with your bookkeeping system as they are received — rather than at month-end — prevents a backlog of unrecorded receipts from distorting your ending inventory count.

Step 3: Pull units sold from every channel

For each sales channel — Shopify, Amazon, Walmart, or wholesale — pull the units sold during the period. This is the figure that drives COGS recognition: when a product ships, its cost moves from inventory (an asset) to COGS (an expense). If you sell across multiple channels, the unit counts must roll up into one place. Fragmented systems create gaps, and gaps produce a COGS figure that doesn't reflect actual sales activity.

Cross-check your bookkeeping system against channel-level inventory reports — for example, the Amazon Seller Central inventory report — every month, as Growthy recommends.

Step 4: Perform a physical or 3PL count and post adjustments

Calculate your expected ending inventory: Beginning Inventory + Units Received − Units Sold = Expected Ending Inventory. Then compare that to your actual count — whether that's a physical warehouse count, a 3PL report, or an FBA inventory snapshot.

Discrepancies between expected and actual ending inventory represent shrinkage, damage, mislabeled units, or fulfillment errors. Seller Candy notes that shrinkage, damaged items, and mislabeled units all impact COGS and must be recorded. Post an inventory adjustment to write down the book value to match the physical count, and expense the difference.

A2X Accounting offers a useful benchmark: inventory adjustments of 10% or less over the course of a year are generally acceptable. Adjustments exceeding 10% are a red flag that poor processes are leading to significant losses and that procedures need review.

Step 5: Verify COGS on the income statement

Once ending inventory is confirmed, recalculate COGS using the formula and compare it to what your accounting system posted. If the system-generated COGS matches your manual calculation, the reconciliation is clean. If it doesn't, the gap points to one of the drift causes covered below.

For a structured monthly close schedule that incorporates these steps, see the month-end close calendar template.

How Are Marketplace Settlements Recorded?

Marketplace settlements — the periodic deposits Amazon, Shopify Payments, or other platforms send — are not the same as revenue. Recording a settlement deposit as gross revenue is one of the most common ecommerce bookkeeping errors, and it distorts both the top line and COGS.

A settlement typically bundles several distinct items:

• Gross product sales — the price customers paid
• Platform fees — Amazon referral fees, Shopify transaction fees, fulfillment fees
• Refunds and returns — amounts credited back to customers
• Advertising charges — PPC spend deducted from the settlement
• Other adjustments — storage fees, chargeback debits, reimbursements

Each of these belongs in a different line on your P&L. Platform fees are operating expenses, not COGS. Seller Candy lists Amazon marketplace fees and Shopify transaction fees explicitly as items that do not belong in COGS — they belong in operating expenses. Recording the net deposit as a single revenue line hides all of this detail and makes gross margin meaningless.

How to record a settlement correctly

The correct approach is to record the gross sales amount as revenue, then record each fee, refund, and charge as its own line item in the appropriate expense category. The net deposit to your bank account is the result — not the starting point.

In practice, this means using a clearing account or a tool that parses settlement files (such as A2X or a similar integration) to split the deposit before it hits your books. Without that split, channel settlement reconciliation becomes a manual exercise at month-end that is easy to get wrong.

Note on fulfillment fees: whether FBA or 3PL fulfillment costs sit in COGS or operating expenses depends on your business model. A2X Accounting notes that outbound shipping is generally an operating expense — unless it is included in the product price (free shipping) or you are drop shipping and your supplier charges it directly. Apply the test consistently across all channels.

For a broader look at how reconciliation fits into your monthly close, the balance sheet reconciliation checklist covers the full account-by-account scope.

What Causes COGS to Drift from Inventory Movement?

COGS drift — where the cost of goods sold on your P&L no longer reflects actual inventory consumption — has a small number of root causes. Identifying which one applies is faster than trying to reconcile a large unexplained variance at year-end.

Landed costs excluded from unit cost

If you record inventory at the supplier invoice price but leave out inbound freight, import duty, and prep costs, your unit cost is understated from the moment the goods arrive. Every sale then recognizes less COGS than the product actually cost. Over time, this understates COGS and overstates gross margin — until a physical count or year-end true-up forces a correction.

Seller Candy identifies tracking landed cost at the SKU level and updating cost changes as they happen as two of the core practices for accurate COGS. Both address this drift cause directly.

Settlements recorded as net deposits

When a marketplace settlement is booked as a single deposit — net of fees, refunds, and ad charges — gross revenue is understated and operating expenses are invisible. COGS may appear correct in isolation, but gross margin is wrong because revenue is wrong. This is a channel settlement reconciliation failure, not strictly a COGS failure, but it produces the same result: a P&L that cannot be trusted.

Shrinkage and damaged inventory not written off

If your book inventory count stays higher than your physical count because shrinkage is never posted, your ending inventory is overstated. An overstated ending inventory reduces COGS in the formula (Beginning Inventory + Purchases − Ending Inventory = COGS), making gross margin look better than it is. The correction arrives eventually — usually at year-end — as a large, unexplained COGS adjustment.

Ledger Gurus recommends periodic self-audits comparing calculated inventory to actual inventory on hand. Significant discrepancies warrant a deeper investigation into the records.

Cost changes not updated in the system

Supplier prices change. Freight rates change. If your system still carries last quarter's unit cost while you are receiving inventory at a higher price, COGS will be understated for every unit sold at the old cost. Seller Candy flags updating cost changes as they happen as a distinct step — not something to catch up on quarterly.

Timing mismatches between inventory receipt and sale recognition

COGS should be recognized when a product ships to the customer, not when the purchase order is placed or when the settlement arrives. If your system records COGS at a different point in the fulfillment cycle, the monthly figures will be off even if the annual total is correct. The aACE documentation describes this precisely: the COGS reconciliation process allocates inventory usage records to inventory lot records to calculate actual cost, and posts the journal entry that removes units from inventory and expenses them to cost of sales at the point of shipment.

What Belongs in Ecommerce COGS — and What Doesn't?

Getting the COGS boundary right is a prerequisite for reconciliation. If you are including costs that don't belong, or excluding costs that do, the reconciliation will always produce a variance — even when your process is otherwise clean.

Typically included in COGS:

• Supplier or manufacturer invoice cost
• Inbound freight and import duty (landed cost)
• Packaging materials directly tied to the product
• Direct labor tied to production or assembly
• Prep and inspection costs (where directly tied to making the product sellable)

Typically excluded from COGS (operating expenses instead):

• Outbound shipping to customers (unless free shipping is included in the product price, or drop-ship supplier charges it directly — per A2X Accounting)
• Amazon referral fees, Shopify transaction fees
• PPC advertising and coupons
• 3PL storage and warehouse rent
• Salaries not tied to production
• Software, office expenses, utilities

A useful test from A2X Accounting: ask whether you would have incurred the cost if you hadn't bought the item. If the answer is no, it likely belongs in COGS. If the cost exists regardless of whether you stocked that product, it belongs in operating expenses.

Applying this boundary consistently across all SKUs and channels is what makes the reconciliation meaningful. Inconsistent categorization produces a COGS figure that is neither comparable period-to-period nor useful for pricing decisions.

How Often Should You Reconcile Inventory and COGS?

Monthly reconciliation is the standard for ecommerce businesses that want decision-ready financials. Waiting until year-end means small errors accumulate into large corrections that are difficult to trace and expensive to fix.

Ledger Gurus recommends periodically performing self-audits and comparing calculated inventory to actual inventory on hand. For most ecommerce businesses, "periodically" should mean monthly — aligned with the monthly close cycle.

The practical cadence looks like this:

1. During the month: Record POs at landed cost as goods are received. Parse settlement files as they arrive rather than batching at month-end.
2. Close week: Pull channel inventory reports. Reconcile units sold to bookkeeping. Request 3PL count or pull FBA snapshot.
3. By day 10 of the following month: Post inventory adjustments, verify COGS formula, confirm ending inventory ties to the balance sheet.

For ecommerce businesses managing inventory across multiple warehouses or fulfillment partners, the services/month-end-close process needs to account for each location separately before rolling up to a consolidated figure.

A2X Accounting notes that inventory accounting isn't a journey of perfection — it's about continuously improving processes over time. The 10% annual adjustment benchmark is a useful guardrail: if you are consistently within that range, your process is working. If you are consistently above it, the process needs structural change, not just more frequent true-ups.

For ecommerce businesses evaluating whether their current accounting setup can support this kind of monthly discipline, the /industries/retail-ecommerce page covers what a purpose-built ecommerce accounting engagement looks like.

Disclaimer: Laya provides this content for informational purposes only. This material does not constitute tax, legal, or accounting advice. Please consult your own tax, legal, and accounting advisors before engaging in any transaction.

If your COGS and inventory reconciliation aren't closing cleanly each month, book an intro to see how Laya structures the monthly close for ecommerce businesses.