Year-End Stock Count & Inventory Reconciliation UAE
Plan a year-end stock count, set a clean cut-off, investigate differences and reconcile inventory to the ledger. A practical guide for UAE trading companies.
For a trading company, inventory is often the largest asset on the balance sheet. If the quantities in the system do not match the goods on the shelves, gross profit, VAT workings and the corporate tax computation can all be affected. A well-planned year-end stock count is the simplest way to confirm the figure and to find the process problems behind any differences.
1. Plan the count early
Agree the count date, the locations included and the people responsible at least two weeks in advance. Decide whether you will run a full count at year end or a series of cycle counts during the year with a smaller year-end check. Share written instructions so every counter follows the same method.
Assign counting teams in pairs: one person counts, the other records.
Separate the people who count from the people who maintain the stock records where possible.
Prepare count sheets or mobile count lists by location and bin.
Inform your auditor if they plan to attend.
2. Establish a clean cut-off
Cut-off errors are the most common cause of year-end differences. Stop or clearly separate goods received and goods dispatched during the count. Record the last delivery note, goods receipt and invoice numbers before the count begins, so that every movement can be placed on the right side of the year end.
In RQM Books, delivery notes, purchase orders and supplier bills update inventory from the source document, which makes the cut-off easier to review.
3. Count blind, then compare
Counters should not see the system quantity while counting. A blind count avoids the temptation to confirm the expected figure. Once the count is complete, compare counted quantities with the system and flag every line that differs beyond an agreed tolerance.
4. Recount and investigate differences
Recount significant differences with a different team before making any adjustment. Then investigate the cause. Typical reasons include:
Goods received but the supplier bill or receipt not yet posted.
Goods delivered to customers without a delivery note.
Wrong unit of measure, for example cartons recorded as pieces.
Items transferred between warehouses without a transfer record.
Damaged, expired or obsolete stock not written off.
Theft or loss.
5. Approve and post adjustments
Stock adjustments should be approved by someone independent of the warehouse and posted with a clear reason code. Keep the count sheets, recount results and approvals with the adjustment. Large or unusual adjustments should be reviewed by management before the books are closed.
6. Reconcile inventory to the general ledger
After adjustments, the inventory valuation report should agree with the inventory balance in the general ledger. If it does not, look for manual journals posted to the inventory account, bills posted to expense instead of stock, or costing differences. Review the inventory and financial reports together so operations and finance are working from the same figure.
7. Review valuation and slow-moving stock
Inventory is generally measured at the lower of cost and net realisable value under the company's accounting framework. Use the count to identify slow-moving, damaged and near-expiry items and discuss any write-down with your accountant. Document the basis for the decision.
8. Fix the process, not only the number
Every difference points to a process weakness. If goods are regularly received without a system record, tighten the receiving step. If transfers are missed, require a transfer document before goods move. Moving to regular cycle counts for high-value or fast-moving items reduces the size of the year-end task.
Bring warehouse and accounts together
A stock count is much easier when every movement comes from an operational document that also updates the accounts. RQM Books connects inventory management, sales, purchasing and accounting for UAE trading companies and auto parts businesses. Book a demonstration to walk through a count and reconciliation using your own items.
This guide is general operational information. Inventory valuation and write-downs should be agreed with your accountant or auditor under the accounting framework your company applies.