How to track and analyse your actual Cost of Goods Sold (COGS)

To keep your business profitable, you must track your actual Cost of Goods Sold (COGS) by calculating the real-world cost of materials, direct labour, and consumables for every unit you produce. By comparing these "actuals" against your initial budget, you can identify if rising supplier prices or production inefficiencies are eating into your margins, allowing you to adjust your pricing or processes before your profit disappears.

What exactly is COGS?

Cost of Goods Sold (COGS) refers only to the direct costs involved in producing your products. It does not include "overheads" like your rent, website hosting, or marketing. In the UK, keeping a sharp eye on COGS is essential for accurate bookkeeping and ensuring your "Gross Profit" is high enough to cover those other bills.

Step 1: Gather your actual expenditure

While your initial estimates were a great starting point, real life is often messier. To track actual COGS, you need to look at what you actually spent over a specific period (e.g., a month or a quarter). Gather the following:

• Invoices from suppliers: Include the cost of the raw materials plus any shipping or import duties paid.
• Packaging costs: Every box, sticker, and piece of tissue paper used for the final product.
• Direct labour: If you pay staff (or yourself) a specific rate to assemble the product, record the exact hours spent on production.
• Waste and spoilage: Account for materials that were damaged or discarded during the process.

Step 2: Use the COGS formula

The most common way to calculate COGS for a set period is:

(Starting Inventory + New Purchases) – Ending Inventory = COGS

This tells you the value of the stock that actually left your business as a finished sale. If you prefer to track it per unit, simply divide your total production costs for a batch by the number of sellable units produced.

Step 3: Compare "Budget" vs "Actual"

This is where the "analysis" happens. Create a simple table to see where the discrepancies lie. For example:

Item	Budgeted Cost	Actual Cost	Variance
Raw Material A	£2.50	£2.85	+£0.35
Packaging	£0.50	£0.45	-£0.05
Labour	£5.00	£6.50	+£1.50

Step 4: Take action

If your actual COGS is higher than your budget, your profit margin is shrinking. You have three main levers to pull:

1. Sourcing: Can you find a cheaper supplier or buy in larger quantities to get a discount?
2. Efficiency: If labour costs are high, is there a way to speed up the making process without losing quality?
3. Pricing: If material costs have risen across the whole market, it may be time to increase your retail price to maintain your margin.

Top Tip: Don't wait until the end of the year to do this. Review your COGS monthly. In a fluctuating economy, material prices can change quickly, and the sooner you spot a trend, the easier it is to fix.