£÷×−+789C45=AccountingCompare
bookkeeping

Stock and Inventory Accounting: How to Value and Track Your Stock

A comprehensive guide to UK stock and inventory accounting, covering valuation methods, tracking processes, and software solutions.

10 min read Updated April 2026🇬🇧 UK-specific
Sarah Mitchell
Sarah Mitchell·
Editorial guidelines

TL;DR: Key Takeaways

  • Stock valuation directly impacts profit and tax liabilities for UK businesses, making accurate accounting crucial.
  • FIFO and Weighted Average Cost are permissible under UK GAAP (FRS 102), while LIFO is generally not allowed.
  • Inventory must be valued at the lower of cost and Net Realisable Value (NRV), ensuring assets are not overstated.
  • Regular stock counts and proper accounting for obsolete stock and Work in Progress (WIP) are essential for financial accuracy and compliance.

Introduction

For any business that buys and sells goods, managing stock - or inventory - is a fundamental aspect of financial health. Accurate stock and inventory accounting not only provides a true picture of your business's assets and profitability but also ensures compliance with UK accounting standards and tax regulations. This comprehensive guide will delve into the core principles of stock and inventory accounting in the UK, covering valuation methods, tracking processes, and how modern accounting software can streamline these critical tasks.

Why Stock Valuation Matters: Impact on Profit and Tax

The value assigned to your stock directly influences two key financial metrics: your Cost of Goods Sold (COGS) and the value of your inventory on the balance sheet. These, in turn, affect your reported profit and, consequently, your Corporation Tax liability [1].

When stock is undervalued, COGS will be higher, leading to lower reported profits and potentially lower tax. Conversely, overvalued stock results in lower COGS, higher reported profits, and a higher tax bill. HMRC scrutinises stock valuation to ensure businesses are not manipulating figures for tax advantages [2].

Inventory Valuation Methods Under UK GAAP

Under UK Generally Accepted Accounting Principles (GAAP), specifically FRS 102 Section 13, businesses must measure inventories at the lower of cost and net realisable value (NRV) [3]. This principle ensures that assets are not overstated on the balance sheet. Several methods are used to determine the 'cost' of inventory.

1. First-In, First-Out (FIFO)

Principle: FIFO assumes that the first goods purchased or produced are the first ones sold. This method aligns with the physical flow of goods for many businesses, especially those dealing with perishable items or products with expiry dates [4].

How it works: When a sale occurs, the cost assigned to that sale is based on the cost of the oldest inventory units. The remaining inventory is therefore valued at the cost of the most recently purchased units.

Pros:

  • Reflects the actual physical flow of goods for many businesses.
  • Results in a higher reported profit and higher inventory value during periods of rising costs, which can be favourable to investors.
  • Widely accepted under UK GAAP and International Financial Reporting Standards (IFRS).

Cons:

  • Can lead to higher tax liabilities during inflationary periods due to higher reported profits.
  • May not accurately reflect the true cost of replacing inventory if prices are fluctuating rapidly.

2. Last-In, First-Out (LIFO)

Principle: LIFO assumes that the last goods purchased or produced are the first ones sold. This method is rarely used in practice and is not permitted under FRS 102 in the UK [4].

Important Note:

LIFO is generally not permitted under UK GAAP (FRS 102) or IFRS. Businesses operating in the UK should not use this method for statutory accounts.

How it works: When a sale occurs, the cost assigned is based on the cost of the most recent inventory units. The remaining inventory is valued at the cost of the oldest units.

Pros (where permitted):

  • Matches the most recent costs against current revenues, which can provide a better measure of current income during periods of inflation.
  • Can result in lower reported profits and lower tax liabilities during inflationary periods.

Cons:

  • Not permitted under UK GAAP (FRS 102) or IFRS.
  • Does not reflect the actual physical flow of goods for most businesses.
  • Can result in an undervaluation of inventory on the balance sheet, as it's valued at older, potentially lower costs.

3. Weighted Average Cost (WAC)

Principle: The Weighted Average Cost method calculates an average cost for all inventory items available for sale. This method is particularly useful when inventory items are identical and purchased at varying prices, smoothing out price fluctuations [4].

How it works: The total cost of all inventory available for sale is divided by the total number of units available for sale to arrive at an average cost per unit. This average cost is then used to value both COGS and ending inventory.

Pros:

  • Smooths out price fluctuations, providing a more stable cost figure.
  • Simple to apply, especially with modern accounting software.
  • Widely accepted under UK GAAP and IFRS.
  • Often reflects the reality for businesses where specific identification of stock is impractical.

Cons:

  • Does not reflect the actual physical flow of goods.
  • The average cost may not be representative if there are significant price differences between purchases.

The Lower of Cost and Net Realisable Value (NRV) Principle

Regardless of the cost flow assumption (FIFO or WAC), UK GAAP (FRS 102) mandates that inventory must be valued at the lower of its cost and its Net Realisable Value (NRV) [3].

Cost includes all costs of purchase, costs of conversion (for manufactured goods), and other costs incurred in bringing the inventories to their present location and condition [3].

Net Realisable Value (NRV) is the estimated selling price in the ordinary course of business less the estimated costs of completion and the estimated costs necessary to make the sale [3].

Example:

If a product cost £10 to purchase but can now only be sold for £8 (after deducting selling costs), its value in the accounts must be written down to £8. This prevents overstating the value of assets that have lost market value due to damage, obsolescence, or changes in demand [2].

Stock Count Process: Ensuring Accuracy

Regular stock counts are vital for verifying the accuracy of inventory records and identifying discrepancies caused by damage, theft (shrinkage), or administrative errors. A meticulous stocktake ensures accurate financial reporting and efficient stock control [5].

Key Steps in a Stock Count Process:

  1. Preparation:
    • Schedule: Choose a date and time that minimises disruption, ideally outside regular trading hours. Auditors may observe significant stocktakes [5].
    • Organise: Tidy and arrange stock, grouping similar items and ensuring easy access [5].
    • Update Records: Ensure inventory records, including locations and product codes, are up-to-date and ready for comparison [5].
    • Brief Team: Assign reliable team members with product knowledge and fully brief them on the process [5].
    • Plan for Discrepancies: Establish a clear procedure for handling and investigating discrepancies [5].
    • Exclude Stock: Temporarily exclude items sold but not dispatched, or new arrivals not yet added to inventory [5].
  2. Counting:
    • Consistency: Use a consistent counting system (e.g., tick sheets, electronic scanners) [5].
    • Accuracy: Emphasise precision; avoid estimates, and double-check high-value or large quantity items [5].
    • Mark Counted Stock: Implement a system to mark items that have been counted to prevent double-counting [5].
  3. Post-Count Activities:
    • Record: Input physical counts into the inventory management system [5].
    • Reconcile: Investigate discrepancies between physical counts and records. Identify causes (damage, shrinkage, system errors) [5].
    • Adjust: Make necessary adjustments to records, documenting reasons for all changes [5].
    • Review: Develop an action plan based on findings (e.g., adjust control procedures, reorder stock) [5].
    • Retain Records: Keep all stocktake records for future reference and audit purposes [5].

Accounting for Obsolete, Damaged, or Slow-Moving Stock

Stock that is obsolete, damaged, or slow-moving needs special attention. Under the lower of cost and NRV principle, such stock must be written down to its NRV if that is lower than its cost. This write-down reduces the value of inventory on the balance sheet and increases COGS, thereby reducing reported profit [2].

Example:

A clothing retailer has winter coats remaining at the end of the season. The original cost was £50 per coat. To clear them, they are now expected to sell for £20, with selling costs of £2. The NRV is £18 (£20 - £2). The coats must be written down from £50 to £18, resulting in a £32 loss per coat recognised in the profit and loss account.

Work in Progress (WIP) Accounting

Work in Progress (WIP) refers to goods that are in the process of being manufactured but are not yet complete. WIP is also considered inventory and must be valued under FRS 102 Section 13 [3].

The cost of WIP includes: [3]

  • Raw materials used.
  • Direct labour costs incurred in production.
  • Allocated production overheads (e.g., factory rent, utilities, depreciation of machinery).

Example:

A furniture manufacturer is building a custom table. The cost of timber, glue, and screws (raw materials), the wages of the carpenter (direct labour), and a portion of the workshop's electricity bill (allocated overhead) would all be included in the WIP valuation for that table until it is completed and ready for sale.

How Accounting Software Handles Inventory

Modern accounting software can significantly simplify inventory management, automating many of the complex calculations and tracking processes. However, the level of functionality varies between platforms.

QuickBooks UK

QuickBooks Online (QBO) offers built-in inventory management features that are suitable for many small to medium-sized businesses. These features include: [6]

  • Real-time tracking: Monitor stock levels as items are bought and sold.
  • Low-stock alerts: Receive notifications when it's time to reorder.
  • Inventory insights: Gain an understanding of what products are selling well.
  • Costing methods: QBO typically uses the FIFO method for inventory valuation.

Pros:

  • Integrated directly with accounting, simplifying reconciliation.
  • User-friendly interface.
  • Good for businesses with straightforward inventory needs.

Cons:

  • May lack advanced features required by businesses with complex inventory, such as batch tracking, multiple warehouse locations, or sophisticated reporting.
  • Limited customisation for specific industry needs.

Xero UK (and Add-ons)

Xero's core platform has basic inventory tracking capabilities, primarily for tracking quantities and simple average cost. For businesses with more complex inventory requirements, Xero integrates seamlessly with a wide range of third-party inventory management add-ons [7].

Popular Xero Inventory Add-ons:

  • Unleashed Software: Offers comprehensive inventory management, including batch tracking, multiple warehouses, production, and B2B e-commerce. It integrates with Xero to sync sales, purchases, and stock movements [8].
  • DEAR Inventory (now Cin7 Core): Provides advanced features like manufacturing, warehouse management, and multi-channel sales. It offers robust inventory control for growing businesses [9].

Pros:

  • Xero's flexibility allows businesses to choose an add-on that perfectly matches their specific inventory needs.
  • Add-ons often provide highly specialised features not found in general accounting software.
  • Scalable solutions for businesses as they grow and their inventory needs become more complex.

Cons:

  • Requires an additional subscription cost for the add-on.
  • Can involve a learning curve to set up and manage the integration.
  • Basic Xero inventory may be insufficient for even moderately complex stock.

Data Table: Comparison of Inventory Valuation Methods

FeatureFIFO (First-In, First-Out)Weighted Average Cost (WAC)LIFO (Last-In, First-Out)
PrincipleOldest stock sold firstAverage cost of all stockNewest stock sold first
UK GAAP (FRS 102)PermittedPermittedNot Permitted
Impact on COGS (Rising Prices)Lower COGSModerate COGSHigher COGS
Impact on Profit (Rising Prices)Higher ProfitModerate ProfitLower Profit
Impact on Inventory Value (Rising Prices)Higher (reflects recent costs)ModerateLower (reflects older costs)
Physical Flow MatchOften matches (e.g., perishables)Rarely matchesRarely matches
ComplexityModerateSimpleModerate (if permitted)

Data Table: Typical Inventory-Related Costs (UK 2026/27)

Cost CategoryDescriptionExample (Annual Estimate)
Purchase CostsCost of acquiring goods, including import duties and transport.£50,000 - £500,000+
Storage CostsWarehouse rent, utilities, insurance, security.£5,000 - £50,000
Handling CostsLabour for receiving, moving, picking, packing.£3,000 - £30,000
Obsolescence/SpoilageWrite-downs due to damage, expiry, or market changes.1% - 5% of inventory value
Inventory SoftwareSubscription fees for dedicated inventory management systems.£300 - £2,000+
Stocktaking LabourWages for staff performing physical counts.£500 - £5,000

*Note: These figures are illustrative and can vary significantly based on business size, industry, and inventory volume.

Conclusion

Effective stock and inventory accounting is more than just a compliance exercise; it's a strategic imperative for any UK business dealing with physical goods. By understanding and correctly applying valuation methods like FIFO and Weighted Average Cost, adhering to the lower of cost and NRV principle, and implementing robust stock count processes, businesses can ensure accurate financial reporting, optimise profitability, and make informed decisions. Leveraging the right accounting software, whether it's QuickBooks' built-in features or Xero with a powerful add-on like Unleashed or DEAR, can further streamline these operations, providing real-time insights and control over your most tangible assets.

Compare Accounting Software

Ready to find the best accounting software for your inventory management needs? Compare leading UK accounting software solutions to find the perfect fit for your business.

Compare All Software →

References

Recommended Software for This Topic

QU

QuickBooks

XE

Xero

SA

Sage 50cloud