To track cost of goods sold accurately, Amazon and Shopify sellers desperately need a reliable system that consistently connects their landed inventory costs directly to their recognized sales revenue.

Without highly accurate cost of goods sold (COGS) tracking, it becomes almost mathematically impossible to understand your true net profitability, analyze individual product performance, or forecast your cash flow. The absolute most successful ecommerce businesses combine accurate double-entry bookkeeping, perpetual inventory management, and perfectly clean sales data to create highly reliable financial reporting.

Many ecommerce businesses know exactly how much gross revenue they generate on a weekly basis. Far fewer actually know how much profit they get to keep. The critical, missing piece of the financial puzzle is almost always cost of goods sold.

‍

How to Track Cost of Goods Sold for Amazon and Shopify Sellers

To track cost of goods sold accurately, Amazon and Shopify sellers desperately need a reliable system that consistently connects their landed inventory costs directly to their recognized sales revenue.

Without highly accurate cost of goods sold (COGS) tracking, it becomes almost mathematically impossible to understand your true net profitability, analyze individual product performance, or forecast your cash flow. The absolute most successful ecommerce businesses combine accurate double-entry bookkeeping, perpetual inventory management, and perfectly clean sales data to create highly reliable financial reporting.

Many ecommerce businesses know exactly how much gross revenue they generate on a weekly basis. Far fewer actually know how much profit they get to keep. The critical, missing piece of the financial puzzle is almost always cost of goods sold.

What Is Cost of Goods Sold (COGS)?

Cost of goods sold, commonly referred to as COGS, represents the total direct costs associated with producing or purchasing the exact products your business actually sold during a specific accounting period.

For multi-channel Amazon and Shopify sellers, calculating your landed cost typically includes:

• Wholesale Purchase Costs: The exact price paid to your supplier or manufacturer for the raw product.
• Freight and Inbound Shipping: Air, sea, or ground freight costs to get the inventory into your warehouse or an Amazon FBA fulfillment center.
• Import Duties and Tariffs: Customs fees required to bring the product into your country.
• Direct Packaging Costs: Specialized boxes, polybags, inserts, or labeling that are directly part of the final physical product.
• Direct Manufacturing Labor: If you assemble the products yourself, the direct wages tied strictly to production.

What is Excluded from COGS?

It is equally important to understand what does not belong in this calculation. COGS does not normally include indirect costs or operating expenses, such as:

• Amazon PPC or Facebook advertising spend.
• Monthly software subscriptions (like your Shopify plan or repricing tools).
• Employee salaries not tied directly to physical manufacturing.
• Amazon referral fees and FBA fulfillment fees.
• Shopify Payments or Stripe transaction processing fees.
• Monthly 3PL warehouse storage rent.

Those are operating expenses, not inventory costs. Understanding this rigid accounting distinction is absolutely essential because treating a marketplace fee as an inventory cost will fundamentally distort your profit reporting and cause severe tax compliance issues.

The Core COGS Accounting Formula

To accurately track your margins, you must understand the standard accounting formula used by certified public accountants and major software platforms.

The Retail COGS Formula:

Beginning Inventory + Purchases During Period − Ending Inventory = Cost of Goods Sold

• Beginning Inventory: The total financial value of all unsold stock sitting in your warehouse at the start of the month.
• Purchases: The total landed cost of any new inventory you bought or received during that exact month.
• Ending Inventory: The total value of the unsold stock remaining at the very end of the month.

Example: If you start November with £15,000 in inventory, purchase an additional £5,000 in stock, and end November with £8,000 in unsold stock, your COGS for November is exactly £12,000.

Why Cost of Goods Sold Matters for Ecommerce Sellers

Many passionate ecommerce founders focus far too heavily on top-line revenue growth. However, gross revenue alone tells an incredibly incomplete, and often dangerous, story.

Consider two highly popular Amazon products:

• Product A generates exactly £100,000 in annual sales.
• Product B also generates exactly £100,000 in annual sales.

At first glance, their performance appears identical. However, when we look deeper at the supply chain:

• Product A costs £30,000 to source, ship, and prep (Landed Cost).
• Product B costs £80,000 to source, ship, and prep (Landed Cost).

The true profitability is dramatically different. Product A yields a massive £70,000 gross profit, while Product B yields a dangerously thin £20,000 gross profit before advertising is even deducted.

Without aggressively accurate COGS tracking, business owners often make poor, highly destructive decisions regarding:

• Setting retail pricing strategies.
• Executing inventory purchase orders.
• Allocating aggressive PPC marketing budgets.
• Funding new product line expansion.

The businesses that intimately understand their direct materials and landed costs generally make vastly better, highly profitable decisions.

Why Amazon and Shopify Sellers Struggle With COGS

Tracking cost of goods sold becomes exponentially more difficult as ecommerce businesses successfully grow and scale. Several complex operational factors contribute to this exact friction.

1. The Timing of Accrual Accounting

Under the highly preferred accrual accounting method, inventory purchases should never be recorded as an immediate expense. Products are purchased months before they are actually sold, meaning that cash leaves the bank long before revenue is recognized. This creates a severe timing challenge between cash flow and profitability that confuses many founders. You must record the expense only when the specific unit actually sells.

2. Fragmented Multiple Sales Channels

Many ambitious businesses sell simultaneously through:

• Amazon (Seller Central)
• Shopify
• eBay
• Wholesale B2B channels

Revenue quickly becomes massively fragmented across completely disconnected platforms, while your inventory costs remain centralized in your warehouse.

3. Extreme Marketplace Complexity

Marketplaces introduce massive layers of deductions that complicate the math.

• Amazon introduces: Hidden FBA pick-and-pack fees, rolling storage fees, unpredictable customer refunds, and international inventory movements.
• Shopify introduces: Diverse payment processing fees, multiple third-party fulfillment models, and point-of-sale integrations.

Without properly structured, automated accounting systems, separating your true COGS from these chaotic marketplace fees becomes a mathematical nightmare.

The Difference Between Revenue And Profit

One of the most dangerously common mistakes ecommerce founders make is blindly confusing revenue growth with profit growth.

A business generating £500,000 in revenue with £400,000 in COGS is fundamentally, financially different from a business generating £500,000 in revenue with only £200,000 in COGS.

The second business successfully creates significantly more working capital despite possessing identical top-line revenue. Tracking cost of goods sold consistently allows growing businesses to accurately calculate:

• Gross Profit: Your total revenue minus your cost of goods sold.
• Gross Profit Margin: Your gross profit mathematically expressed as a percentage of your total revenue.
• Product-Level Profitability: Deeply understanding exactly which SKUs create the strongest financial returns and which ones are secretly draining your capital.

Without pinpoint-accurate COGS data feeding into your general ledger, all of these vital metrics become highly unreliable.

How To Track Cost of Goods Sold Correctly

To prevent massive discrepancies at tax time, you must follow a rigid, step-by-step financial workflow.

Step 1: Maintain Highly Accurate Inventory Records

Your internal inventory records must flawlessly reflect:

• Supplier product purchase orders.
• Physical inventory received at the 3PL or FBA warehouse.
• Total units sold across all channels.
• Ending inventory remaining on the shelves.
• Inventory shrinkage (damaged, lost, or obsolete units).

This strict perpetual inventory tracking provides the absolute foundation for accurate cost accounting.

Step 2: Strictly Separate Inventory From Expenses

When you wire £10,000 to a manufacturer in China, that is not a business expense. Inventory purchases should not automatically be recorded as expenses on your Profit and Loss (P&L) statement. Instead, they must be recorded as an Inventory Asset on your Balance Sheet until the specific products are successfully sold to a customer. This accrual method ensures costs are recognized perfectly in the correct accounting period.

Step 3: Connect Sales Data To Accounting Data

This is exactly where many massive ecommerce businesses encounter severe difficulties. Sales occur across multiple digital platforms. Your inventory accounting data often exists elsewhere. Without flawlessly accurate sales and fee data entering the cloud accounting system, your profitability reporting becomes immediately unreliable.

Step 4: Review Gross Profit Margins Regularly

COGS tracking is absolutely not a once-a-year exercise reserved for tax season. The most successful ecommerce businesses review their true profitability consistently every single month. This allows founders to instantly identify:

• Dangerous margin erosion due to rising freight costs.
• Sudden spikes in raw supplier product costs.
• Underperforming or obsolete SKUs.
• Immediate pricing optimization opportunities.

The Competitive Landscape: Organizing Your Financial Data

If you want to track COGS accurately, you must ensure that your top-line revenue and marketplace fees are recorded perfectly inside your accounting software (like Xero or QuickBooks). To do this, sellers rely heavily on third-party ecommerce accounting software connectors.

Here is how the leading platforms approach the marketplace data that feeds into your COGS calculation.

• Taxomate: Offers a highly flexible, budget-conscious approach to automating your accounting data. While users can heavily customize their data flow, achieving perfect reconciliation often requires deep manual setup. For COGS to be accurate, the user must ensure the sales data Taxomate pushes is flawlessly mapped.
• Webgility: A massive, enterprise-leaning software that attempts to handle both your general ledger sync and your actual inventory management simultaneously. It pushes order-level details into your accounting software. While powerful, pushing thousands of individual Amazon orders into QuickBooks can cause severe general ledger bloat, slowing down your ability to pull fast profitability reports.
• A2X: A highly established pioneer in the summary accounting space. A2X pulls data from Amazon and Shopify and creates clean summary journal entries. By accurately separating gross sales from fees and VAT, it ensures that when your inventory software pushes the COGS value, the resulting gross margin calculation on your P&L is perfectly accurate.

Where Link My Books Fits Into The COGS Process

While Link My Books is not a standalone warehouse inventory management platform, it plays an incredibly vital, foundational role in creating flawlessly accurate ecommerce financial records.

Many profitability issues do not start with bad inventory math; they begin with poor, chaotic sales data. If your recognized revenue, FBA fees, VAT liabilities, and settlement information are inaccurate, your final profitability calculations become entirely unreliable, no matter how perfectly you track your landed costs. Link My Books solves that exact problem.

Cleaner Revenue Data

Amazon and Shopify generate massive, chaotic amounts of transactional information. Link My Books intelligently organizes that chaotic information into perfectly structured, double-entry accounting summaries. This ensures your top-line revenue is isolated perfectly from your fees.

Better Financial Visibility

To calculate true gross profitability accurately using your COGS data, businesses first need absolute confidence in their recognized revenue figures. Link My Books helps guarantee that gross sales, platform fees, customer refunds, and bank settlements are correctly and automatically represented within the accounting system.

Easier Multi-Channel Reporting

As businesses aggressively expand across multiple platforms, consolidating reporting becomes increasingly difficult. Link My Books deeply centralizes your Amazon seller accounting alongside Shopify, eBay, and Etsy, creating a rock-solid, reliable financial foundation for your gross margin analysis.

Improved Decision Making

Accurate COGS analysis depends entirely on accurate revenue reporting. When your automated sales data is clean and your bank feed reconciliation is one-click reliable, business owners can finally make aggressive, confident decisions regarding inventory purchasing, product pricing, and marketing investment.

Common Cost of Goods Sold Mistakes to Avoid

Recording Inventory Purchases As Immediate Expenses

Dumping a £20,000 supplier invoice directly into an expense account immediately distorts your profitability reporting for that month and artificially inflates your profit in subsequent months when the items actually sell.

Ignoring Inbound Freight And Import Duties

Many businesses dangerously underestimate their true product costs by only tracking the wholesale unit price. Freight, customs duties, and prep-center costs must be baked into your landed COGS value.

Focusing Solely On Top-Line Revenue

Celebrating a massive £100,000 sales month without immediate cost visibility can create incredibly misleading, dangerous conclusions about your company's actual runway.

Using Incomplete or Messy Sales Data

If your gross sales figures inside Xero are inaccurate because you didn't properly separate Amazon's hidden referral fees from the payout, your resulting COGS profitability calculations become mathematically useless.

Reviewing Profitability Too Infrequently

Growing businesses should aggressively monitor their gross margins consistently every single month rather than waiting until year-end accounts are prepared by their CPA.

FAQ

What exactly is included in the cost of goods sold?

Cost of goods sold strictly includes direct inventory purchase costs, raw manufacturing materials, specialized product packaging, and inbound freight or customs duties directly associated with getting the products ready to be sold.

Why is COGS so critically important for Amazon sellers?

Tracking COGS allows Amazon sellers to understand their actual, real-world net profitability per SKU, rather than focusing solely on dangerous, inflated gross revenue figures inside Seller Central.

Is the cost of goods sold the exact same thing as operating expenses?

No. Operating expenses include indirect items such as Facebook advertising, software subscriptions, office rent, and payroll. COGS relates exclusively to the direct cost of the physical inventory sold.

Does Link My Books calculate my cost of goods sold for me?

Link My Books focuses strictly on organizing your chaotic ecommerce sales, fees, and settlement data into perfect summaries within your accounting system. This highly accurate sales data creates the mandatory, perfect foundation required for your inventory software to calculate your true profitability.

How often should an ecommerce business review its COGS and margins?

The most successful, highly profitable ecommerce businesses monitor their product profitability and overall gross margins on a strict monthly basis to catch supply chain price increases early, rather than waiting until the end of the fiscal year.

Key Takeaways

Tracking your cost of goods sold accurately is undeniably one of the most important, critical financial disciplines for growing Amazon and Shopify sellers.

Gross revenue alone absolutely does not reveal your true business performance. Profitability does.

Businesses that successfully combine strong, perpetual inventory management with pristinely clean ecommerce accounting data gain significantly better, faster visibility into their margins, product performance, and long-term growth opportunities.

Link My Books heavily supports that scaling process by ensuring your gross revenue, hidden fees, customer refunds, and settlement data are accurately and flawlessly represented within your cloud accounting system, creating the ultimate, strong financial foundation for your profitability analysis.

Ready to clean up your sales data so you can track true profitability?

Start a free trial today and seamlessly connect your sales channels in minutes.

‍