Inventory Software for Nigerian Distributors

Distribution businesses do not usually fail because of a bad month. They fail because stock value on paper and stock value in the warehouse drift apart for two years until a count forces a write-off large enough to matter.

Stock is a distributor's working capital. Software that keeps the two figures together does more for the business than almost any other system. This article sets out exactly what that software must do in Nigerian conditions, how to evaluate options, what it costs, and how to implement it without losing a month of data.

What inventory software must do for a distributor

A retail shop needs to know what is on its shelves. A distributor needs considerably more, because stock is constantly moving between places the business does not physically watch.

The six core jobs:

1. Hold an accurate quantity and value per item per location, updated by transactions rather than by adjustment.
2. Move stock reliably between locations, including issuing to vans and receiving returns, with both sides confirmed.
3. Track batch and expiry where products have shelf life or regulatory traceability requirements.
4. Support counting, full and partial, with variance recorded, explained and approved rather than silently overwritten.
5. Trigger replenishment based on real demand and real supply lead times.
6. Value stock consistently, including the effect of exchange-rate movement where goods are imported.

Anything that cannot do all six is a stock list, not an inventory system.

Feature checklist to demand from any vendor

Use this in a demonstration and ask to see each item performed, not described.

• Unlimited locations, with vehicles configurable as locations
• Goods received against a purchase order, with variance recorded
• Transfers requiring confirmation at the receiving end
• Batch or lot numbers with expiry dates and first-expiry-first-out picking
• Serial number tracking where relevant, for example electronics
• Unit of measure conversion, for example carton, pack and piece
• Barcode scanning on receiving, picking and counting
• Full and cycle counts with a blind count option and variance approval
• Reason codes for every adjustment, damage and write-off
• Returns from customers handled as a distinct transaction, with condition recorded
• Reorder points and suggested purchase orders based on lead time and demand
• Stock valuation method stated clearly, with landed cost supported for imported goods
• Offline capability for warehouse and van devices
• Role-based permissions and a complete audit trail of who changed what
• Integration with your accounting package and your sales or field sales system
• Exportable data in a documented format, at any time, without fees

A vendor who cannot demonstrate confirmed transfers, blind counts and expiry-driven picking is selling software written for a different kind of business.

Multi-location stock: depots, vans and sub-distributors

This is where distribution differs most from other inventory situations.

Vans are locations. When stock is loaded onto a vehicle it has not left the business, so it must not leave the books. Treat each vehicle as a location with its own balance. At the end of every trip, reconcile: stock loaded, stock sold, stock returned, cash and payments collected. Differences investigated the same day are recoverable; differences found at month end are not.

Transfers need two confirmations. A transfer that decrements the source immediately and credits the destination on trust creates stock in transit that nobody owns. Require receipt confirmation, and report on transfers outstanding beyond a set period.

Sub-distributor and consignment stock. If you place stock with a sub-distributor or an agent before it is sold, you still own it. Track it as a location with restricted permissions, and reconcile periodically. Distributors who skip this frequently discover the exposure only when a relationship ends.

Depots need local accountability. Each location should have a named person responsible for its balance, and permissions that prevent someone in one depot adjusting another's stock.

Movement in Nigerian conditions adds time. Inter-city transfers take longer than planned, and goods can sit at a transporter's depot. Build a stock-in-transit view and treat anything outstanding for more than a few days as an exception requiring follow-up.

Batch, expiry, returns and damage

For distributors of food, beverages, pharmaceuticals, agrochemicals, cosmetics and personal care, batch and expiry handling is the difference between a controlled business and a slow write-off.

Requirements:

• Batch or lot number captured at goods receipt, with manufacture and expiry dates
• Picking that defaults to earliest expiry first, with an override that is logged
• An expiry exposure report showing stock value by remaining shelf life band
• Automatic blocking of expired stock from picking
• Quarantine status for stock under investigation
• Recall capability: given a batch number, list every customer who received it

That last point matters commercially and for compliance. Distributors handling regulated products should confirm their specific obligations with NAFDAC and, for pharmaceuticals, the relevant pharmacy regulatory authority, since requirements change and vary by product class.

Returns and damage need their own transaction types, not adjustments. Record the reason, the condition, whether the item returns to sellable stock, quarantine or write-off, and which customer and representative it came from. Returns data analysed by product and by route often reveals a handling or storage problem that is cheaper to fix than to absorb.

Counts, variance and shrinkage control

Counting is where inventory systems earn trust, or lose it.

Cycle counting beats annual counting. Counting a slice of the warehouse continuously, with fast-moving and high-value items counted most often, finds errors while they are still traceable. An annual count finds a number you can only write off.

Count blind. Counters should not see the expected quantity. A count that displays the system figure becomes a confirmation exercise.

Variance must be explained, then approved. Each variance should carry a reason code, a recount where material, and approval by someone other than the person responsible for the stock.

Track variance as a metric. Variance value as a percentage of stock value, by location and by period, is one of the most useful management figures a distributor can have. A location whose variance is consistently worse than others has a process or a personnel problem.

Separate the causes. Shrinkage has several sources: theft, receiving errors, picking errors, unrecorded damage, unit of measure confusion, and transfers never confirmed. Reason codes let you tell them apart, and each has a different remedy.

Reorder points, lead times and working capital

Ordering too late costs sales. Ordering too early traps cash a Nigerian distributor usually cannot spare.

A workable reorder calculation needs three inputs: average demand over a period, the variability of that demand, and the actual lead time from order to available stock, including clearing time for imported goods and inter-city transport.

Practical guidance:

1. Calculate lead time from your own records, not from a supplier's promise. Capture order date, dispatch date and availability date every time.
2. Use the spread of lead times, not only the average. If clearing occasionally takes three extra weeks, your safety stock must reflect that.
3. Set service levels by product class. High-margin, fast-moving lines justify more cover than slow tail items.
4. Review reorder points quarterly, and after any change in supplier or route.
5. Report stock cover in days, not just quantity. Days of cover is the figure that connects inventory to working capital.
6. Flag slow movers and dead stock monthly, and act on them while they still have shelf life and market value.

Buy a packaged product or build a custom system?

A five-question decision framework:

1. Does a packaged product handle vans as stock locations with trip reconciliation? If not, it will not fit a van sales business.
2. Does it support batch and expiry with first-expiry-first-out picking? Essential for food, pharmaceutical and personal care distribution.
3. Can it work offline in the warehouse and on the road?
4. Will subscription costs in foreign currency remain acceptable as your user count grows?
5. Can you export all your data, in a documented format, without paying for the privilege?

Two clear failures on these questions point toward a custom or hybrid build.

What inventory software costs a Nigerian distributor

Indicative 2026 ranges. Actual quotations vary with scope, vendor, number of locations and users, and the exchange rate at the time of contracting. Compare two or three written quotations on identical scope.

Costs outside the software quotation: barcode scanners and label printers; rugged or entry-level Android devices for warehouse and van staff; network and power provision in the warehouse; hosting from roughly ₦150,000 to ₦800,000 per year for a modest cloud deployment; maintenance and support at 15% to 25% of build cost per year; and the internal effort of a full count and data clean-up before go-live.

Example (hypothetical): a pharmaceutical distributor in Ibadan

This scenario is a hypothetical illustration, not a Linestech client result.

A pharmaceutical and consumer health distributor in Ibadan operates one main warehouse, a second depot, four delivery vehicles and a small sub-distributor arrangement in two nearby towns. Its stock includes items with meaningful shelf life constraints.

Symptoms: expiry write-offs each year that nobody forecasts; stock counts taking three days and producing variances that get approved in bulk; sub-distributor stock that is never formally reconciled; and reorder decisions made from memory, which produces both stockouts on fast lines and overstock on slow ones.

A phased build that fits:

Phase one, roughly ₦4,000,000 to ₦8,000,000, about three months. Multi-location stock with vehicles and sub-distributor locations included, goods receipt against purchase orders with batch and expiry capture, confirmed transfers, barcode scanning, and blind cycle counting with variance reason codes and approval.

Phase two, roughly ₦2,000,000 to ₦5,000,000. First-expiry-first-out picking, expiry exposure reporting by shelf-life band, quarantine and recall reporting, and returns handling with condition codes.

Phase three, roughly ₦2,000,000 to ₦6,000,000. Reorder points calculated from actual lead times, stock cover in days, slow-mover reporting, and integration with the accounting package.

The targets agreed before phase one: reduce expiry write-off value in the next twelve months, cut count duration, and produce a reconciled sub-distributor position monthly. Those figures decide whether the investment worked.

Implementation steps

1. Rationalise the item master. One code per sellable unit, agreed pack sizes and conversions, obsolete codes archived rather than deleted.
2. Define locations. Warehouses, depots, each vehicle, quarantine, damaged goods, and sub-distributor or consignment locations.
3. Agree the valuation method with your accountant, including how landed cost is applied to imported goods.
4. Run a full physical count immediately before go-live and reconcile it. Do not migrate a stock figure you do not believe.
5. Load opening balances, not years of history. Keep old records accessible for reference.
6. Configure reason codes and approval rules before users start, so bad habits never form.
7. Train by role: receiving, picking, van staff, counters, supervisors and finance each need different sessions on the devices they will use.
8. Pilot in one location for two to four weeks with the old process running in parallel, reconciled weekly.
9. Extend location by location, adding vehicles once depot discipline is stable.
10. Review after one quarter: variance percentage, expiry exposure, stock cover in days, and count duration.

Mistakes to avoid

Adjusting stock instead of recording transactions. Every adjustment without a reason code is a lost opportunity to find a process problem.

Leaving vans off the system. Stock on a vehicle is still your stock and your exposure.

Counting with the expected figure visible. It converts a count into a confirmation and hides the very errors you are counting to find.

One person with unrestricted rights. Receiving, adjusting, approving variances and issuing credit notes should not all sit with the same individual.

Ignoring unit of measure conversions. Carton, pack and piece confusion is one of the most common causes of unexplained variance in Nigerian distribution.

Buying software that cannot handle expiry, then selling short-dated stock. For food, pharmaceutical and personal care distributors this is a direct financial and compliance risk.

Migrating a stock figure you know is wrong. The system inherits the error and you never trust its reports afterwards.

Treating go-live as the finish. Discipline is a habit. Review variance and expiry exposure monthly for at least the first year.

Conclusion

Inventory software for a Nigerian distributor should be chosen on four capabilities above all others: vehicles and sub-distributors treated as real stock locations with confirmed transfers, batch and expiry control with first-expiry-first-out picking, blind cycle counting with reason codes and approvals, and reorder points built on your own measured lead times.

Get the item master and a believable opening count right before anything else. The businesses that get real value from stock software are the ones where every movement is a transaction with a reason, and where variance is a weekly question rather than an annual write-off.

Looking at multi-location stock control, van reconciliation or batch and expiry tracking? Linestech builds inventory and distribution software for Nigerian businesses, including offline warehouse and van applications and integration with existing accounting packages. Tell us how your stock moves today and we will help you scope a practical first phase.

Frequently asked questions

What is the difference between inventory software for a shop and for a distributor?

A shop needs shelf-level accuracy in one place. A distributor needs stock tracked across depots, vehicles and sometimes sub-distributors, with confirmed transfers, batch and expiry control, returns handling and reorder logic based on variable supply lead times. Retail-oriented software usually lacks the movement and reconciliation features distribution depends on.

Can we manage stock on vans without expensive devices?

Yes. Entry-level Android phones with a barcode scanning camera or an inexpensive Bluetooth scanner are sufficient for most van operations. The requirement that matters is offline capability, so a trip can be recorded and settled without a network connection.

How often should we count stock?

Move to cycle counting: count fast-moving and high-value items weekly or fortnightly, mid-range items monthly, and slow movers quarterly, so the whole catalogue is covered over a cycle. Keep an annual full count if your auditors require it, but do not rely on it to manage the business.

What stock valuation method should a Nigerian distributor use?

Weighted average cost is the most common and practical choice, particularly where purchase prices change frequently. For imported goods, valuation should use landed cost at the exchange rate actually obtained. Agree the method with your accountant and apply it consistently, because switching methods distorts comparisons.

How do we handle stock we have placed with sub-distributors?

Treat each sub-distributor as a stock location with restricted permissions, record placements as transfers requiring confirmation, and reconcile on a fixed schedule. Agree in writing who bears the risk of loss and expiry, and make the outstanding position a monthly management report.

Will inventory software stop theft?

It will not prevent theft, but it makes theft visible and attributable, which usually reduces it. Reason codes, blind counts, confirmed transfers, segregated permissions and an audit trail turn an unexplained gap into a specific question about a specific location, date and person.

Should inventory be part of our accounting system or separate?

Either can work, provided there is one source of truth for quantities and a reliable link to financial postings. Many Nigerian distributors keep their accounting package and run a dedicated stock and field sales layer alongside it, posting confirmed transactions across. What fails is maintaining two independent stock records.

How long before the software pays for itself?

Where write-offs, expiry and unexplained variance are currently significant, the effect often appears within two or three quarters as counts tighten and expiry exposure becomes visible early enough to act on. Record your baseline before go-live, otherwise the question cannot be answered credibly.

Sources and further reading

Figures, platform rules and regulations change. These are the primary references behind this article and the places to check before you act on it.

• NAFDAC
• Core Web Vitals — web.dev
• PostgreSQL documentation