Merchant Place Books Logo

Resources

How a specialist ecommerce bookkeeper handles inventory and COGS

By Martin Elsworth, CPA, co-founder, Merchant Place Books

Much like the gap between your sales and your platform payouts, accounting for inventory and cost of goods sold is where bookkeeping often trips up. It isn't unique to ecommerce, as payout handling is, but the result is the same: books you can't rely on for tax prep, financing or business decisions.

Here is how a specialist ecommerce bookkeeper handles it: the principle, the choices, the tools and the monthly routine.

Why the platform can't do it for you

An Amazon settlement or a Shopify payout shows what you sold and what the platform charged you. Nothing in it says what the product cost you, what freight and duties added, or how much stock is still on your shelf. So the cost side has to come from somewhere else.

The principle: inventory is an asset until it sells

Buying inventory is not an expense on the day you pay. It sits on the balance sheet as an asset until you sell it, and the cost of the units you sell moves onto the Profit & Loss, into cost of goods sold (COGS), in the month of the sale.

An illustrative example. In March you buy 1,000 units at $8, so $8,000. You sell 300 units at $30 in March and 400 in April.

Here, March looks like a bad month and April looks like a fantastic one. Neither is an accurate reflection of how the business performed.

Now, what goes into the cost of inventory?

The cost of a unit is its landed cost: the supplier price plus freight in, duties and tariffs, customs and brokerage, insurance, and any prep, labeling or inspection needed to make it sellable.

Storage fees, ad spend and freight out (what you pay to ship orders to customers) are not part of landed cost; they are selling and operating costs.

Some businesses show outbound shipping and marketplace fulfillment fees inside cost of sales instead.

What matters is choosing one treatment, applying it consistently, knowing which you chose and why.

Choosing a costing method

When your cost per unit changes (a price rise, a new supplier, a tariff), the costing method decides which cost lands in which month. FIFO assumes the oldest units sell first; weighted average blends them. FIFO tracks reality more closely when costs move; weighted average is simpler to keep up. Pick one and stay with it.

The tools, from simple to heavy

  1. A basic cost sheet and journal entries. A spreadsheet list of SKUs and their landed costs, multiplied by units sold each month, gives COGS. The bookkeeper posts it as a journal entry and adjusts the remaining inventory asset. It works in any version of QuickBooks, but it doesn't track stock quantities in real time.
  2. A2X. It summarizes each marketplace settlement into clean entries for QuickBooks, and it can pull in the SKUs and units sold so the COGS entry follows each month's sales.
  3. QuickBooks Online's own inventory tracking. It records quantity and cost per item and relieves stock as sales are recorded. It sits in the higher QuickBooks tiers and needs careful setup when sales arrive as summarized settlements.
  4. An inventory management system (IMS). Once there are many SKUs, several warehouses or purchase orders in flight, a dedicated IMS tracks quantities and cost layers, and the bookkeeper reconciles it to the books. Examples include Cin7, Finale and Fishbowl.

The right level depends on volume, SKU count and how fast the stock turns.

The monthly routine

  1. Confirm units sold by SKU from each channel.
  2. Add the month's purchases and spread freight, duties and prep across the units they relate to.
  3. Post COGS and update the inventory asset.
  4. Reconcile the inventory balance to the stock report or the IMS.
  5. Chase the variances: negative stock, SKUs with no cost (they show an absurd 100% margin), goods in transit, lost or damaged units, and Amazon reimbursements.
  6. Review margin by product for anything that looks too good or too thin.

Three questions to ask any bookkeeper

  1. Is my inventory on the balance sheet as an asset, not expensed when I buy it?*
  2. Is the cost of goods matched to the month the sale happened?
  3. Are freight and duties included in my product cost?

*How inventory is treated for tax is a question for your CPA or tax preparer.

More from Resources