Perpetual vs Periodic Inventory UAE: Which One Your SME Actually Needs

If your inventory only becomes “real” on 31 December, you’re running periodic — whatever the ERP brochure says. For any UAE SME above micro-scale, that’s a problem. You don’t know your stock-on-hand until the warehouse team finishes the annual count. Your monthly accounts only tie to physical reality once a year. And in an FTA audit, you’ve got nothing to reconcile against, so the inspector estimates the gap and you pay.

This guide covers what perpetual and periodic actually mean in practice, the system requirements for each, the VAT reconciliation that keeps perpetual defensible, what the year-end audit looks like under both, and the turnover point where switching becomes obvious.

What ‘perpetual’ actually means

A perpetual inventory system updates the stock ledger in real time after every transaction. Receipt of stock from a supplier increments the on-hand quantity and value; issue to a customer decrements them; an inter-warehouse transfer moves units between locations; a write-off zeroes them out. At any moment, the system can produce a stock-on-hand report by SKU, by location, by batch, by serial number — whatever dimensions the ERP is configured to track.

The accounting entries fire automatically:

• On goods receipt: Dr Inventory (specific SKU, specific warehouse) / Cr GRNI clearing account.
• On supplier bill posting: Dr GRNI / Cr Accounts Payable, plus Dr VAT Input / Cr Accounts Payable for the VAT portion.
• On sales invoice: Dr Cost of Sales / Cr Inventory at the costed value, simultaneously with Dr Accounts Receivable / Cr Sales Revenue.
• On inter-warehouse transfer: Dr Inventory (destination) / Cr Inventory (origin).
• On write-off: Dr Inventory Adjustment (P&L) / Cr Inventory.

Every entry is posted by the ERP from the source transaction without a journal voucher. The control accounts on the general ledger always equal the sum of the subledger.

And what ‘periodic’ really looks like in practice

A periodic inventory system updates the stock ledger only at predetermined count dates — typically year-end, sometimes also half-year. Purchases are posted to a Purchases expense account (not Inventory) during the period; sales are posted at revenue but no cost-of-sales entry fires. Cost of sales is derived by formula at the count date:

Opening Stock + Purchases − Closing Stock = Cost of Sales

The accounting entries are simpler — no perpetual costing, no GRNI clearing in many implementations — but the operational consequence is severe:

• Stock-on-hand is unknown between count dates. The warehouse team uses physical pick-faces and shelf signals.
• Cost of sales is unknown between count dates. Monthly management accounts either show no COGS or estimate it from a budget ratio.
• Theft, shrinkage and obsolescence are invisible until the count. The variance at year-end IS the discovery.
• VAT reconciliation is impossible mid-year. Input tax claimed on purchases cannot be tied to a stock movement.

Periodic made sense when ERP was expensive. With Zoho Books at around AED 200 a month, picking periodic now is choosing to operate blind.

“

Side by side

When periodic is genuinely fine

Periodic inventory is genuinely acceptable in a narrow band of UAE SME scenarios:

• Micro-SME retailers — single-location convenience store, small abaya boutique, single neighbourhood pharmacy. Annual turnover under AED 5 million, fewer than 500 SKUs, single owner-operator.
• Service businesses with consumables only — a barber shop, a small cafe, a beauty salon where stock is shampoo, coffee beans and similar consumables held at low value. Treat consumables as expensed-on-receipt for everyday items and inventoried only for higher-value pieces.
• Project businesses where stock is purchased per project — small specialist contractors who buy materials for each job and do not hold standing stock between jobs.

Outside these bands, periodic is a liability. Mid-sized traders, multi-warehouse retailers, manufacturers, gold dealers, e-commerce sellers, construction companies with material stock, and any SME with serial or batch tracking obligations all need perpetual.

Why we call perpetual a daily habit, not a setting

Perpetual is not just an ERP setting; it is a daily discipline. The five non-negotiable operational habits:

1. Every receipt is GRN’d in the ERP at the warehouse door. Not at the end of the week. Not when the bill arrives. The warehouse team raises the GRN against the PO before the truck leaves.
2. Every issue posts a sale or a transfer in the ERP. No stock leaves without a system transaction. Manual deliveries, courier handovers and customer collections all require the ERP entry.
3. The bill posts within 7 days of the GRN. GRNI clears regularly. Long-aged GRNI is the auditor’s red flag.
4. The stock subledger reconciles to GL monthly. Total inventory in the subledger = sum of GL control accounts (raw, WIP, finished, in-transit). Any difference is investigated and posted before the period closes.
5. Cycle counting runs continuously. ABC stratification, A-items monthly, B-items quarterly, C-items semi-annually. Variances above threshold are root-cause-investigated.

Without these habits the ERP runs perpetual on paper while the business runs periodic in reality. We see it constantly, and it’s almost never a software problem. The system is perfectly capable. The discipline just isn’t there, so the inventory means nothing until the year-end count forces the truth out.

The VAT reconciliation the FTA expects to see

UAE VAT is a transactional tax. Input tax is recovered on each invoiced purchase; output tax is charged on each sale. The FTA’s reconciliation question during an audit is straightforward: do the purchase invoices feeding input tax match the stock that hit the warehouse, and do the sales invoices feeding output tax match the stock that left the warehouse?

Under perpetual, this is provable transaction by transaction:

• Purchase invoice → GRN → stock receipt → input tax claimed.
• Sales invoice → stock issue → cost of sales → output tax charged.

The audit trail is continuous. Each VAT return cycle can be reconciled to a stock-movement report for the quarter.

Under periodic, the reconciliation is impossible mid-year. Stock movements only exist at count dates. The auditor or inspector cannot prove that a specific purchase invoice resulted in stock receipt, or that a specific sale corresponded to stock issued — they can only test the aggregate. When the aggregate variance is large (as it usually is), the FTA assesses additional exposure based on inspector estimation.

For UAE SMEs serious about VAT services in Dubai compliance, perpetual is the only defensible position.

Which ERP fits which size of SME

The market for perpetual-capable ERPs in the UAE SME segment is mature. The practical landscape:

The single biggest SME mistake is over-buying. AED 20 million traders running SAP Business One because a consultant talked them into enterprise software. They could have bought Zoho One for a tenth of the cost and got the same operational result. The chart of accounts and the daily discipline matter more than the ERP brand — see our inventory management UAE SME playbook for the design framework.

What your auditor will ask for in March

A statutory auditor in the UAE testing inventory under IAS 2 will look for:

• A documented IAS 2 accounting policy. Cost flow method, basis of cost, NRV testing, provisioning matrix.
• A year-end count attended by the auditor. Count sheets reconciled to perpetual ledger; differences investigated.
• A cycle-count log for the year. Showing rolling accuracy by ABC class.
• GRNI ageing at year-end. Long-aged items explained.
• Slow-moving and obsolete provision computation. Supporting the carrying value.
• Inventory adjustment register. Approval evidence for write-offs.
• Consignment statements. Third-party confirmations for off-balance-sheet stock.
• NRV testing memo. For any inventory class showing impairment signals.
• Reconciliation of stock subledger to GL. For every month of the year.

Under perpetual with disciplined operations, all of this falls out of the monthly close. Under periodic, the auditor has to reconstruct most of it — and the audit fee reflects that. Our accounting and bookkeeping engagements produce the workpapers above as part of the standard monthly close output.

Moving across — a 6-10 week project

For UAE SMEs currently running periodic (or ‘paper perpetual’), the migration is a defined project with a 6-10 week timeline:

1. Week 1 — Diagnostic. Confirm current state, identify chart-of-accounts gaps, ERP configuration audit, staff capability assessment.
2. Week 2 — Design. Inventory chart of accounts redesigned with raw / WIP / finished / in-transit / consignment splits and GRNI clearing. IAS 2 policy drafted. Cycle-count programme designed.
3. Week 3-4 — ERP configuration. Perpetual costing turned on, three-way matching enabled, multi-warehouse set up, GRNI account mapped, batch/serial tracking configured where required.
4. Week 4 — Full count. Physical count of all stock to establish the perpetual opening balance. Reconciled to the existing periodic ledger; any variance posted as opening adjustment.
5. Week 5 — Training. Warehouse team trained on GRN posting; AP team trained on three-way match; finance team trained on monthly reconciliation.
6. Week 6-8 — Parallel run. First month run under perpetual with a manual periodic check at month-end. Variances investigated.
7. Week 9 — Reconciliation. First clean monthly close. Subledger ties to GL.
8. Week 10 — Cycle counting begins. A-class items counted in week 1 of next month.

By month three the SME is fully on perpetual with a sustainable cycle-count programme and audit-ready monthly close. The migration is heavy in the first month, light thereafter.

The cost-flow method choice (FIFO vs WAC) interacts with the perpetual decision — both must be settled before ERP configuration locks. See our companion guide on FIFO vs weighted-average inventory methods for that decision framework.

How this plays out by sector

The perpetual decision plays out slightly differently by sector:

• Construction accounting UAE — Stock is dominated by work-in-progress under IFRS 15 percentage-of-completion, not finished goods. Perpetual covers raw materials only; WIP is a project-cost ledger. Materials at site need warehouse-equivalent control even when there is no formal warehouse.
• Gold jewellery accounting UAE — Perpetual is essential because daily LBMA spot revaluation requires real-time weight tracking by purity grade. Jewellery-specific ERPs (Logic, Goldsoft, GIA) are perpetual-only.
• Real estate accounting UAE — Land bank and units-under-construction are inventory until handover. Each unit is a single SKU; perpetual tracking is automatic.
• E-commerce accounting UAE — Multi-warehouse with FBA, drop-ship and marketplace consignment. Perpetual is non-negotiable because three or more parties (the SME, the marketplace and the 3PL) all need synchronised views.

Why corporate tax sharpens the choice

UAE Corporate Tax follows accounting profit determined under IFRS. The choice between perpetual and periodic does not directly change the IAS 2 method (FIFO or WAC) — both methods can run under either system — but it affects the defensibility of cost of sales in the corporate tax services UAE computation:

• Perpetual: COGS is built up from individual transactions, supported by the stock movement audit trail. The CT computation is defensible to source.
• Periodic: COGS is derived by formula from a single year-end count. The CT computation is only as defensible as the count, and any subsequent challenge to opening or closing stock cascades into COGS.

FTA inspectors increasingly request perpetual stock movement reports during CT audits. Where periodic is in use, expect inspector-estimated adjustments and a longer audit cycle.

How Velmont Crest scopes the migration

We work with UAE SMEs across trading, retail, manufacturing, construction, jewellery and e-commerce on the full perpetual-vs-periodic decision and migration: diagnostic, chart-of-accounts redesign, ERP configuration audit, IAS 2 policy drafting, staff training, parallel-run reconciliation and the first cycle-count programme.

Engagements start with a no-fee 30-minute call to review your current setup. Where a migration is justified, we scope a fixed-fee project under our dedicated inventory accounting service. For SMEs that prefer ongoing support after migration, the monthly close on the new perpetual system folds into a retained accounting and bookkeeping engagement.

We are an advisory and preparation practice, not an ERP implementer or warehouse operator. Where ERP technical implementation is required, we coordinate with your existing or selected ERP partner. Where formal FTA representation is required, we coordinate with a registered tax agent firm.

For UAE SMEs above micro-scale, perpetual isn’t a luxury — it’s what defensible VAT and a clean corporate tax computation rest on, and it’s why the audit closes on time instead of dragging. Book a call when you’re ready to move from paper perpetual to the real thing.