Back to Blog
E-commerce

Inventory Management for E-commerce: WAC, FIFO & Best Practices

Master e-commerce inventory management with proven methods like Weighted Average Cost and FIFO. Learn stock tracking, reorder points, and how cloud software automates it all.

Ala-Hasba TeamMarch 4, 202613 min read

Inventory is the engine of every e-commerce business. It sits between what you spend and what you earn, and how you account for it determines your reported profit, your tax liability, and whether your financial statements tell the truth. Yet inventory management is one of the most neglected areas for small and mid-sized online sellers in the GCC - until something goes wrong.

Running out of a best-selling product costs you sales. Overstocking ties up cash you could deploy elsewhere. Misvaluing your stock distorts your profit margins and misleads every financial decision that follows. This guide walks through the fundamentals of e-commerce inventory management: how to value your stock correctly, how to track it reliably, and how to avoid the mistakes that quietly erode profitability.

Why Inventory Management Matters for E-commerce

For a service business, the balance sheet is relatively simple. For an e-commerce business, inventory is often the largest asset on the books - and unlike cash or receivables, it requires active management to remain accurate.

Your Profit Depends on It

Cost of goods sold (COGS) is the direct cost of the products you sell. It flows directly through your income statement and reduces your gross profit. If COGS is wrong - because you guessed at your stock value or never tracked it at all - your gross margin is wrong, your net profit is wrong, and every business decision built on those numbers is built on sand.

Cash Flow Depends on It

Inventory represents cash you have already spent. When you buy 200 units of a product at 4 KD each, you have committed 800 KD of working capital. Understanding how that investment converts back into cash - and how quickly - is essential to managing liquidity. Businesses that do not track inventory often discover they are "profitable on paper" but cash-strapped in practice.

Compliance Depends on It

In Kuwait and across the GCC, businesses are expected to follow IFRS (International Financial Reporting Standards) or local equivalents derived from them. IFRS requires that inventory be measured at the lower of cost and net realisable value, and that the cost method used - whether Weighted Average Cost, FIFO, or another permissible method - be applied consistently. LIFO (Last In, First Out) is explicitly prohibited under IAS 2. This is not a technical footnote; it affects what cost method you are legally permitted to use and how you present your financials.

Inventory Valuation Methods: WAC, FIFO, and LIFO

When you sell a unit of product, you need to know what it cost you. This sounds simple until you have bought the same product at different prices over time. Three methods exist for resolving this problem.

Weighted Average Cost (WAC)

WAC calculates a blended average cost across all units in stock. Every time you receive a new delivery, the system recalculates the average by dividing the total value of inventory on hand by the total number of units.

Example:

You start by purchasing 100 units at 5.000 KD each. Your inventory value is 500.000 KD and your average cost is 5.000 KD per unit.

Later, you receive 50 more units at 6.000 KD each, adding 300.000 KD of value to your stock.

Your new WAC is calculated as:

(500.000 + 300.000) / (100 + 50) = 800.000 / 150 = 5.333 KD per unit

When you sell a unit, COGS is recorded at 5.333 KD - regardless of which physical batch that unit came from.

WAC is the standard method under IFRS (IAS 2) and is the most commonly used approach in the GCC. It smooths out price fluctuations, is straightforward to apply consistently, and is accepted by tax authorities across the region.

FIFO (First In, First Out)

FIFO assumes that the oldest inventory you purchased is the first to be sold. If you bought 100 units at 5 KD and then 50 units at 6 KD, and you sell 80 units, FIFO says those 80 units came from the first batch and cost 5 KD each.

FIFO is also permitted under IFRS and is widely used, particularly for perishable goods or products with expiry dates where the assumption mirrors physical reality. In a rising price environment, FIFO produces lower COGS and higher reported profit compared to WAC - which means higher taxable income. In a falling price environment, the effect reverses.

For most GCC e-commerce businesses dealing in durable goods - electronics, apparel, household items - the practical difference between WAC and FIFO is small, but WAC is generally simpler to administer.

LIFO (Last In, First Out)

LIFO assumes the most recently purchased inventory is sold first. It is popular in the United States under US GAAP because it tends to produce higher COGS in inflationary environments, reducing taxable profit.

LIFO is prohibited under IAS 2 (IFRS). If you are operating in Kuwait, Saudi Arabia, the UAE, Bahrain, or Qatar and your financials are prepared under IFRS or an IFRS-derived standard, you cannot use LIFO. Any accounting software that offers LIFO as an option for GCC businesses should be treated with caution.

Which Method Should You Use?

For e-commerce businesses in the GCC: Weighted Average Cost. It is IFRS-compliant, consistently applied, practical to automate, and accepted by local regulatory frameworks. Unless you have a specific reason to use FIFO - such as products with strict batch traceability requirements - WAC is the right default.

Stock Tracking Fundamentals

Valuation method aside, the foundation of inventory management is accurate, real-time tracking. This means knowing what you have, where it is, and what it cost you - at any given moment.

SKUs and Product Identification

Every product in your catalogue needs a unique identifier. Stock Keeping Units (SKUs) are the internal codes you assign to products. A well-structured SKU system makes it immediately obvious what a product is without having to look it up - for example, ELEC-PHONE-CASE-BLK-M is more useful than ITEM00437.

If you sell across multiple channels - your own website, a marketplace, a physical outlet - each channel may assign its own external ID to the same product. Your inventory system needs to track both your internal SKU and any external identifiers to avoid mismatches.

Real-Time Stock Levels

Knowing your stock level at the end of last month is not enough. E-commerce moves quickly, and a stock level that was accurate this morning may be wrong by this afternoon. Every sale should decrement stock immediately. Every incoming delivery should increment it. Every return or adjustment should be recorded as it happens.

The alternative - periodic physical counts with manual reconciliation - is prone to error, creates gaps in accuracy between counts, and cannot support fast-moving operations.

Low Stock Alerts and Thresholds

Each product should have a low stock threshold - a level at which you want to be notified that a reorder is needed. This threshold is not the same for every product. A high-velocity item selling 50 units per week needs a much higher safety buffer than a slow mover selling 5 units per month.

Configuring per-product thresholds and receiving alerts when levels drop below them prevents the most common and costly inventory failure: discovering a popular product is out of stock only after a customer tries to order it.

Reorder Points and Safety Stock

A reorder point is the stock level at which you should place a new purchase order, timed so that the new delivery arrives before you run out. Calculating it correctly requires two inputs: your average daily sales rate and your supplier lead time.

Calculating Your Reorder Point

Basic formula:

Reorder Point = Average Daily Sales x Supplier Lead Time (days)

If you sell an average of 8 units per day and your supplier takes 10 days to deliver, your reorder point is 80 units. When stock drops to 80, you order.

Safety Stock

The basic formula assumes everything goes to plan - that your sales rate stays constant and your supplier delivers on time. Neither is guaranteed. Safety stock is a buffer you hold above the calculated reorder point to absorb variability.

Simple safety stock formula:

Safety Stock = (Maximum Daily Sales - Average Daily Sales) x Lead Time

If your maximum daily sales spike to 15 units (for example, during a promotion) and your average is 8, with a 10-day lead time:

Safety Stock = (15 - 8) x 10 = 70 units

Your adjusted reorder point becomes 80 + 70 = 150 units. Holding less than 150 units means you are at risk of a stockout if demand spikes or your supplier is delayed.

These numbers need to be revisited regularly. Sales patterns change with seasons, promotions, and market conditions. A reorder point that was appropriate six months ago may be wrong today.

Avoiding Overstock

Safety stock and high reorder points protect against stockouts, but they carry their own cost. Excess inventory consumes working capital, occupies storage space, and - for fashion or technology products - risks obsolescence. The goal is not to hold as much stock as possible, but to hold the right amount: enough to meet demand without tying up cash unnecessarily.

Common Inventory Mistakes That Hurt E-commerce Businesses

Most inventory problems in small and mid-sized e-commerce operations trace back to a handful of predictable errors.

Not Tracking COGS at All

Some business owners track revenue carefully but treat all stock purchases as an immediate expense. This approach - sometimes called cash-basis accounting - is simple but deeply misleading for product businesses. It causes profit to swing wildly based on when you happen to buy stock, not when you actually sell it. Under IFRS (the accrual basis), COGS should be recognised when the sale occurs, not when the purchase is made.

Using the Wrong Cost for COGS

If you buy stock at different prices over time and always use the most recent price, or always use the original purchase price, you are not applying a consistent method. This produces inaccurate COGS, incorrect gross margins, and financial statements that do not reflect reality. Choosing WAC or FIFO and applying it systematically - ideally through software that does it automatically - is the correct approach.

Mixing Business and Personal Stock

A surprisingly common issue for early-stage e-commerce sellers: products purchased for personal use that end up being sold through the business (or vice versa). This contaminates your inventory records, understates or overstates COGS, and makes it impossible to produce accurate financials. Business inventory must be tracked separately from anything not acquired for resale.

Not Reconciling Physical Stock with System Records

Your accounting system may show 120 units on hand. A physical count may reveal 107. The difference could be due to theft, breakage, data entry errors, or returns not properly recorded. If reconciliation is never done, these discrepancies compound. A once-per-quarter physical count, cross-referenced against system records, is the minimum standard for any serious e-commerce operation.

Ignoring Returns and Adjustments

Returned products need to go back into inventory (if they are resalable) or be written off (if they are not). Failing to record returns accurately means your stock levels are wrong and your COGS is overstated - which understates your profit. Every return should trigger a defined process: inspect the product, update the record, and adjust the journal accordingly.

How Ala-Hasba Handles Inventory Management

Ala-Hasba is built specifically for e-commerce and retail businesses in the GCC, with inventory management designed around IFRS compliance and the practical realities of regional operations.

WAC Method Built-In and Automatic

Ala-Hasba uses Weighted Average Cost as its default and only inventory valuation method - the IFRS-compliant standard for the GCC. There is no option to select LIFO, which keeps the system aligned with regional regulatory requirements.

Every time a stock delivery is recorded, Ala-Hasba automatically recalculates the weighted average cost for that product based on the updated total value and total units. You do not need to compute anything manually. If you receive 100 units at 5.000 KD and later 50 units at 6.000 KD, the system calculates 5.333 KD as the new cost price without any intervention on your part. This recalculation happens at the product level, in real time, on every delivery.

Products Page: Stock Levels, Cost Price, and Margins

The Products page gives a full view of your catalogue with current stock levels, average cost price, sale price, and calculated margin for each product. You can see at a glance which products are profitable, which have thin margins, and which are at risk of a stockout.

Each product record includes a low stock threshold that you set. When stock drops to or below that threshold, the product is flagged in the products list. There is no need to check manually - the system surfaces what needs attention.

Stock Deliveries: Recording Incoming Inventory

When a delivery arrives, you record it through the Stock Deliveries page. Each delivery entry captures the product, the quantity received, and the unit cost paid. Ala-Hasba immediately updates the product's stock level and recalculates its weighted average cost price.

This is where the WAC recalculation happens. If costs have increased since your last delivery, the average cost adjusts upward. If you negotiated a better price, it adjusts downward. The change flows automatically into future COGS calculations without any manual journal entry required.

Automatic COGS Journal Entries on Every Sale

This is one of the most important accounting features for e-commerce businesses. Every time a sale is recorded in Ala-Hasba, the system automatically creates a double-entry journal for COGS:

  • Debit: Cost of Goods Sold (account 5000 series)
  • Credit: Inventory (account 1200)

The amount is based on the current weighted average cost at the time of sale. This means your COGS is always calculated correctly and your inventory balance on the balance sheet stays accurate without any manual bookkeeping. The journal entries are visible in the full journal ledger for review and audit.

Margin Analysis Page

The Margin Analysis page aggregates sales and cost data to show real-time profitability by product. You can see which products generate the most gross profit, which have the highest margin percentage, and which are underperforming relative to their cost. This view updates as new sales and deliveries are recorded, giving you a live picture of product-level economics.

For e-commerce businesses with large catalogues, this page is where strategic decisions - what to promote, what to discount, what to discontinue - are grounded in actual data rather than intuition.

Works for Both E-commerce and Retail

Ala-Hasba's inventory system serves both e-commerce and retail business types. The same product catalogue, the same WAC calculation, and the same COGS journal logic apply whether you are selling through an online channel, a physical location, or both. Businesses that operate across channels see a unified inventory picture without needing to maintain separate systems.

For retail operations, the Quick Sale feature integrates directly with the same inventory records: selling an item through Quick Sale decrements stock and records COGS the same way an e-commerce order would. There is no double counting, no manual reconciliation between systems.

Summary

Inventory management for e-commerce is not a back-office technicality - it is the mechanism by which your sales translate into accurate profit figures, and your purchasing decisions translate into reliable financial statements. Getting it right requires three things: a consistent, IFRS-compliant valuation method (WAC for GCC businesses), real-time stock tracking with low stock alerts and defined reorder points, and automatic COGS recognition on every sale.

The businesses that manage inventory well are the ones that know their margins with confidence, can forecast cash needs accurately, and can produce financial statements that reflect reality. The businesses that do not manage it well often discover the gap between their intuition and their actual position only when it is too late to act.

Whether you are just building out your inventory processes or looking to replace a manual or disconnected system, the principles in this guide provide the foundation - and the right software can make all of it automatic.

Related Articles

GCC Compliance

Annual Financial Reporting for GCC Businesses: A Complete Checklist

12 min read

Financial Reports

Balance Sheet Explained: Assets, Liabilities, and Equity for Small Business Owners

12 min read

Accounting Fundamentals

Bank Reconciliation Step by Step (With Software)

14 min read

Ready to simplify your accounting?

Try Ala-Hasba free and put what you learned into practice.

Start Your Free Trial