Skip to content
Guide 14 min read

Inventory management software in the UAE: how to choose a stock, warehouse and stock-count system

By Manager & CEO, SmartTech Studio

Ask the owner of a trading or distribution company in the UAE how much stock they have, and the honest answer is often “it depends which file you open”. The warehouse keeper has one sheet, the accountant has another, the salesman has a WhatsApp photo of a shelf, and the figure in the accounting software was last right at the year-end count. That gap costs money every day: sales lost because the system said an item was out when it was on a pallet in the corner, cash tied up in slow stock nobody noticed, expired goods written off, and a year-end count that takes the whole team two weekends.

This guide is for owners and managers of small and mid-sized businesses that hold physical stock: general trading companies, distributors, spare-parts dealers, FMCG and food suppliers, building-materials traders and retailers with a back-store or a central warehouse. It explains when Excel has stopped working, the functions a real inventory management system must have, how batches and expiry dates should be handled, how to set reorder points, how stock counts should run, how to value inventory under IFRS, how VAT, customs duty and designated zones affect the records, which systems it must connect to, and how a packaged product compares with a custom build.

It is deliberately not about AI warehouse automation for large logistics operators, which we cover in a separate guide, or about connecting a POS to an ERP or an online store, which have their own articles. It is about getting the stock records right in the first place. SmartTech Studio builds ERP, CRM, POS and inventory systems for businesses in the UAE and the region, and this is the checklist we use in the first workshop with a new client. It is general information, not tax or accounting advice, so confirm the treatment for your business with your accountant or the Federal Tax Authority.

Signs Excel can no longer run your stock

Spreadsheets are a reasonable start. A new trading company with fifty items and one storeroom can manage on a well-kept sheet for a while. The trouble is that a spreadsheet records what someone typed, not what happened, and it cannot stop two people from changing the same number. As the business grows, the symptoms are predictable.

The quantity in the file and the quantity on the shelf disagree, and nobody can say when they stopped agreeing. Salespeople phone the warehouse before every quotation because they no longer trust the figure. The same product appears under two or three names or codes, so stock seems to be both short and in surplus. Goods are moved from the main warehouse to a branch or a van and the movement is recorded on paper, if at all. Expired or damaged items are discovered during the annual count rather than before they expire. Purchasing orders by habit and by gut feel, so the business runs out of fast movers while slow lines gather dust. And the accountant cannot tell you the cost of goods sold for last month without a long reconciliation.

The test is simple: if you cannot answer “how many of item X do we have, where exactly, and what did it cost us” in under a minute, from one screen you trust, the spreadsheet has done its job and it is time for a system. The same moment often coincides with a wider decision about accounting and operations, which our guide to ERP systems for SMEs in the UAE covers. Inventory is usually the module that forces that decision, because it is where errors cost money fastest.

What does inventory and warehouse software actually need to do?

Every serious inventory system rests on an item master: one record per product, with a unique code, a barcode, a description in English and Arabic, a unit of measure and any conversions (a carton of 12, a pallet of 40 cartons), a category, the default supplier, the purchase and selling units, the tax treatment and the tracking rules that apply to it. If the item master is messy, nothing built on top of it will be reliable. Most failed implementations we are asked to rescue failed here, on duplicate items and missing barcodes, not on software.

Barcodes are what turn records into facts. Where suppliers already print a GS1 barcode, use it. Where they do not, the system should generate internal barcodes and print labels for items, cartons and shelf locations. Every movement, receiving, picking, transfer and count, should then be confirmed by a scan rather than typed. That single rule removes most of the errors a spreadsheet invites.

Locations come next. A business with a main warehouse, a showroom, a branch in another emirate and a few delivery vans has at least four stock locations, and each must show its own quantity. Inside a warehouse, the system should track stock by zone, aisle, rack and bin, so a picker is told where to go instead of searching. Transfers between locations should be documents in their own right, with stock “in transit” between dispatch and receipt, so it is never counted twice or lost.

Around those foundations sit the everyday transactions: goods received against a purchase order, with partial deliveries and supplier returns; sales orders reserved, picked, packed and delivered; adjustments for damage or loss that require a reason and an approval; and a full audit trail showing who changed what and when. A good system also lets staff do all of this on a handheld scanner or an ordinary Android phone, in Arabic or English, because the people in the warehouse are rarely sitting at a desk.

Batches, serial numbers and expiry dates: how should FEFO work?

Not every item needs the same level of tracking, and forcing it on all of them slows the warehouse down. A good system lets you set the rule per item: no tracking for screws sold by the box, batch or lot tracking for food, cosmetics, chemicals and pharmaceuticals, and serial-number tracking for electronics, machines, high-value spare parts and anything sold with a warranty.

Batch tracking records the lot number and, where relevant, the production and expiry dates of each delivery. It lets you answer two questions that matter enormously in food and healthcare: which customers received a given batch, and which batches are about to expire. If a supplier issues a recall, a system with proper batch tracking produces the list of affected customers in minutes. Without it, you are reading delivery notes.

For perishable or dated goods, the picking rule should be FEFO, first expired, first out, not just FIFO. The system should propose the batch with the nearest expiry date when a picker scans an order, warn or block when someone tries to issue a later batch first, and refuse to sell expired stock at all. It should also respect customer requirements on remaining shelf life, since many supermarkets and distributors will reject goods that arrive with too little life left. A daily report of stock expiring in the next 30, 60 and 90 days lets sales push those items while they can still be sold.

Serial tracking works at the level of the single unit. It links each serial number to its purchase, its sale, the customer and the warranty start date, so a service desk can check a returned unit instantly. For spare-parts dealers and equipment suppliers this is often the feature that justifies the whole system.

Reorder points and min/max levels: when should you buy?

Most of the cash in a trading business sits on its shelves, so purchasing discipline matters as much as sales. An inventory system should tell purchasing what to buy, rather than leaving it to memory.

The classic tool is the reorder point: the stock level at which a new order must be placed so that it arrives before you run out. It is roughly the average daily usage multiplied by the supplier’s lead time in days, plus a safety stock to cover variation in demand and delivery. An item that sells 20 units a day from a supplier who takes 15 days to deliver needs reordering at around 300 units plus safety stock. For goods shipped from Asia or Europe, lead times are long and variable, which is exactly why the calculation should live in the system and be reviewed, not fixed once in a spreadsheet.

Min/max levels are the simpler version many SMEs prefer: when stock falls below the minimum, the system suggests an order that brings it back up to the maximum. Either way, the system should generate a daily reorder suggestion per warehouse and per supplier, which a buyer reviews and turns into purchase orders with one click.

It also helps to classify items. An ABC analysis ranks items by their share of sales value or consumption, so the few lines that drive most of the business get tight reorder settings and frequent counts, while the long tail of cheap items gets looser rules. Add a regular report of slow-moving and dead stock, items with no sale in 90 or 180 days, and you have the two levers that free up cash: buy less of what does not sell, and clear what is already sitting there.

Stock counts and cycle counting without closing the warehouse

Many UAE businesses still close for a weekend at year-end to count everything. It works, but it is expensive, error-prone when tired people count thousands of items, and it tells you the truth only once a year. A good inventory system supports two better approaches.

The first is a well-run full count when you need one. The system freezes the expected quantities for the locations being counted, prints or pushes count sheets by bin, and lets counters scan items on their phones without seeing the expected figure, so they count rather than confirm. Differences above a tolerance trigger a recount by someone else before anything is posted. Only then are adjustments approved and posted, with the cost impact visible to finance.

The second is cycle counting: counting a small part of the warehouse every day or week, so that every item is counted several times a year without stopping operations. A common pattern combines it with ABC classification, counting A items monthly, B items quarterly and C items once or twice a year, plus any bin where a picker reported a shortage. Over time, cycle counts show you where the errors come from, a particular location, item or shift, and the record becomes accurate enough that the annual count becomes a formality your auditors can rely on.

Whichever method you use, the rules are the same: count by scanning, count blind, recount differences, require a reason for every adjustment and keep the history. That is what “stock count software” should mean, not just a screen to type quantities into.

Landed cost and inventory valuation under IAS 2

The quantity is only half of the inventory record. The other half is the cost, and this is where many systems built for retail fall short for importers and distributors.

Under IFRS, which UAE companies generally report under, IAS 2 says inventory is measured at the lower of cost and net realisable value. Cost includes the purchase price, import duties and other taxes that are not recoverable, transport, handling and other costs directly attributable to bringing the goods to their present location and condition, less trade discounts and rebates. In practice that means the “landed cost” of an imported item is the supplier price plus freight, insurance, customs duty, clearing and port charges and inland transport, while VAT you can recover is not part of the cost.

The system therefore needs a landed-cost function. When the clearing agent’s and the shipping line’s invoices arrive, often weeks after the goods, finance should be able to attach them to the shipment and allocate them across the items in it, by value, weight, volume or quantity. The item costs update, and so do the margins on anything already sold from that shipment, according to the method chosen. Without this, importers either undercost their stock and overstate profit, or keep a parallel costing sheet that never quite matches the books.

On cost formulas, IAS 2 allows FIFO (first in, first out) or weighted average cost for interchangeable items, and specific identification for items that are not interchangeable, such as serialised machines or made-to-order goods. LIFO is not permitted under IFRS. The same formula must be used for all inventories of a similar nature and use. Most SME traders in the UAE choose weighted average for simplicity, while businesses with dated or volatile-cost goods sometimes prefer FIFO; agree the choice with your accountant before go-live, because changing it later is painful.

Finally, the system should support the net realisable value test: reports of items whose expected selling price, less the costs to sell, has fallen below cost, because they are damaged, obsolete, close to expiry or simply no longer selling. Writing those down at each reporting date is a requirement, not a choice, and a system that flags them makes it routine.

VAT, customs duty and designated zones: what the stock records must capture

The UAE charges VAT at a standard rate of 5%. For inventory, the important points are that each item carries the right tax treatment, that purchase VAT is recorded separately so it can be recovered rather than buried in stock cost, and that every sale produces a valid tax invoice. That sounds like accounting, but it starts in the item master and the warehouse documents.

Imports add customs duty. The UAE applies the GCC common customs tariff, under which most goods pay duty of 5% of their customs value, which is normally the CIF value, cost plus insurance and freight. Some goods carry other rates or are exempt, so the rate depends on the item’s HS code; your clearing agent or the customs authority is the right source for a specific product. VAT on imported goods is calculated on the customs value plus the duty, and VAT-registered businesses generally account for it through the reverse charge in their return. Your system should store the HS code on each item, record the duty paid per shipment as part of landed cost, and keep the customs declaration number with the receipt so the import VAT can be traced.

Free zones complicate the picture for businesses that hold stock in them. For VAT purposes, some free zones are listed by the Cabinet as designated zones, and certain movements of goods within and between designated zones are treated as outside the UAE, provided strict conditions are met, such as the goods not being used or altered and the transfer following customs suspension rules. Moving goods from the mainland into a designated zone, by contrast, is treated as a local supply. Not every free zone is a designated zone, and the list can change, so check the Federal Tax Authority’s current list for each warehouse.

For the inventory system, that means every warehouse must know whether it is on the mainland, in an ordinary free zone or in a designated zone, and transfers between them must carry the correct tax treatment automatically, instead of relying on whoever creates the transfer. Businesses with a free-zone entity and a mainland entity usually also need separate books per company, which is where inventory meets the multi-entity questions in our ERP guides.

Which systems should inventory connect to?

Inventory is never an island. Stock goes down when something is sold and up when something is bought, and the money side of both lands in the accounts. The question is not whether to connect, but which system owns which data.

Point of sale. If you sell from shops or showrooms, every POS sale and return must reduce or restore the stock of that branch immediately, and branch transfers must flow through the same system. How to design that link, and which side should own prices and products, is covered in our article on integrating POS with ERP in the UAE.

Online store. A website or marketplace that sells from the same warehouse needs live stock figures, or you will sell items you do not have. The details of syncing an online store with branch stock are in our guide to connecting an online store to a POS.

Accounting. Every receipt, sale, transfer between companies, adjustment and landed-cost allocation has a value, and those values must post to the general ledger without retyping. If the inventory system is a module of an ERP, this happens natively. If it is a separate product, the integration and the mapping of accounts deserve as much care as the stock features.

E-invoicing. Under the UAE Electronic Invoicing System, businesses with revenue of AED 50 million or more go live on 1 January 2027, and those below that threshold must appoint an Accredited Service Provider by 31 March 2027 and go live on 1 July 2027. The invoice is issued from your sales or accounting system, not the warehouse, but its lines come from the same item master, so codes, descriptions, units and tax treatments must be clean. Our UAE e-invoicing guide explains the model, and the free e-invoicing calculator shows your own deadline.

Larger operations with high order volumes, several shifts and automation in mind may need a full warehouse management system on top of inventory, with wave picking, slotting and, increasingly, AI forecasting. That is a different scale of project, which we describe in our guide to AI warehouse and logistics software in the UAE. Most SMEs should get the basics in this article working first.

Off-the-shelf or custom inventory software?

There is no universal answer. Packaged inventory and ERP products are mature, and for a business whose processes are standard they are often the right choice. A custom system makes sense when the way you work is part of your advantage, or when the packaged options force you into workarounds. The broader trade-off is set out in our article on custom software versus off-the-shelf; for inventory specifically, the differences look like this:

Off-the-shelf vs custom inventory system
FactorOff-the-shelf productCustom system
Time to startDays to weeks for standard setupsWeeks to a few months, depending on scope
Upfront costLow; mostly setup and data clean-upHigher; a build project, quoted on scope
Running costPer-user or per-location subscription that grows with youHosting and support; no per-user licence
Fit to your processYou adapt to the product’s workflowThe workflow follows how your warehouse works
Arabic interface and documentsVaries; check screens, labels and reports, not just invoicesArabic and English designed in from the start
IntegrationsGood with partners it already supports; limited elsewhereBuilt for your POS, store, accounts and suppliers
OwnershipVendor owns the product and the roadmapYou own the system and decide what changes
Best forStandard trading and retail with common workflowsUnusual processes, several entities, heavy integration

A practical middle path is common: run a packaged accounting system and build a custom inventory and operations layer on top of it, or extend an ERP with custom modules for the parts of the business it handles badly. Either way, ask any vendor to show your own items, with your batches, units and warehouses, during the demo, not their sample data.

How to implement an inventory system, and what it costs

Implementations succeed or fail on preparation more than on software. The order we follow with clients is roughly this.

First, map the business: every stock location, every type of movement, who does what, and which items need batch, serial or expiry tracking. Second, clean the item master: one code and one barcode per item, units and conversions agreed, duplicates merged. Third, agree with your accountant the valuation method, the landed-cost rules and the opening balances. Fourth, label the warehouse: bin locations, item labels where suppliers do not provide barcodes, and scanners or phones for the team. Fifth, do an opening stock count by scanning and load it on a single cut-off date in every system. Sixth, connect the POS, online store, accounting and e-invoicing in the order that matters most to your cash flow. Seventh, run the old and new processes side by side for a short period, compare the figures daily and fix every difference. Finally, train the people who will actually use it, in their language, and name one owner in operations who checks the exceptions every day.

On cost, packaged products are usually priced as a subscription per user or per location, plus setup, so the long-term cost depends on how many people and branches you add. A custom inventory or ERP system built by SmartTech Studio starts from AED 25,000 excluding VAT. What moves the price is the number of locations and companies, the tracking rules (batch, serial, expiry), the number of integrations, mobile scanning apps, and how much historical data must be migrated. You can see what is included on our ERP, CRM and POS systems service page, and we give a fixed quote once the scope is clear.

We work with trading and distribution businesses across the emirates, from Abu Dhabi and Dubai to the east coast, where Fujairah’s port, shipping and industrial companies deal with exactly the import, transfer and spare-parts questions in this guide. If you would like a second opinion on your current stock process, or a quote for a system, get in touch with our team and send us a sample of your item list; it tells us more than any brief.

FAQ

What is the best inventory management software for a small business in the UAE?

The best one is the one that fits how your stock moves. Check that it supports barcodes, several warehouses and bins, batch or serial tracking where you need it, reorder suggestions, blind stock counts, landed cost, an Arabic interface and a clean link to your accounts. Test it with your own items before you sign.

Can I keep using Excel for inventory?

For a few dozen items in one location, yes, for a while. Once you have several locations, staff changing quantities, batches or expiry dates, or you cannot say what you have and where in under a minute, a spreadsheet costs more in errors and lost sales than a system would.

Which inventory valuation method is allowed in the UAE?

Companies reporting under IFRS follow IAS 2, which allows FIFO or weighted average cost for interchangeable items and specific identification for unique items. LIFO is not permitted. Inventory is carried at the lower of cost and net realisable value. Agree the method with your accountant before go-live.

Should customs duty be included in the cost of my stock?

Yes, non-recoverable import duties are part of inventory cost under IAS 2, together with freight, insurance, clearing and handling. Most goods pay 5% of their customs value under the GCC common tariff, but check the rate for your HS code. VAT you can recover is not part of the cost.

Do I need barcode scanners, or can staff use phones?

Many SMEs start with ordinary Android phones running a scanning app, which is enough for receiving, transfers and counts at moderate volumes. Busy warehouses usually move to rugged handheld scanners, which read faster, survive drops and last a full shift. A good system works with both.

How much does an inventory management system cost in the UAE?

Packaged products are usually a subscription per user or per location plus setup. A custom inventory or ERP system from SmartTech Studio starts from AED 25,000 excluding VAT, with the final price set by the number of locations and companies, tracking rules, integrations and data migration.

العربية