Stock figures that cannot be trusted
System stock, physical stock and the ledger disagree, and the difference is written off rather than explained.
Retail & Distribution
Retailers, wholesalers and distributors where margin is thin and stock is the balance sheet.
Who this is written for: Managing directors, operations managers, finance managers and owners of multi-branch or multi-product businesses.
In retail and distribution the stock is the business. Gross margin is usually thin enough that a few percentage points of shrinkage, pricing error or dead stock decides whether the year is profitable. The accounting challenge is not recording sales — the point of sale does that — it is knowing whether the stock figure is true, whether the margin by product and branch is what management believes, and where the leakage is happening.
These are the issues that recur. They are described as sector problems, not as claims about clients we have worked with.
System stock, physical stock and the ledger disagree, and the difference is written off rather than explained.
Total revenue is clear; margin by SKU, category or outlet is not, so decisions are made on revenue rather than profit.
Loss is accepted as a cost of trading rather than investigated, which hides both process failures and theft.
Volume rebates, returns credits and settlement discounts agreed but never reconciled to what is actually received.
Capital tied in stock that will never sell at full price, invisible until the write-down.
Allocated costs applied arbitrarily, so no branch can be compared fairly with another.
Till reconciliation done weekly or monthly rather than daily, so the cause is untraceable by the time it is found.
A structured approach to stock accuracy: cycle counting, count procedures, variance investigation, and correction of the underlying process rather than a periodic write-off.
Gross and contribution margin analysed by SKU, category, customer and outlet, with the cost basis documented so the numbers can be defended.
Landed cost accuracy, supplier price changes, and pricing that reflects real cost including freight, duty and handling.
Reconciling supplier statements, tracking rebates and credits, and recovering what is owed.
Identifying stock at risk, quantifying the exposure and recommending action before it becomes a write-down.
A consistent allocation basis for shared costs so branch comparison is fair, and reporting that supports opening, closing and investment decisions.
Daily reconciliation routines, exception reporting and the controls that make discrepancies traceable.
Configuring the platform for multi-branch stock, valuation method, barcode operations, purchasing approvals and the reporting described above.
Reporting is where sector knowledge shows. A generic management pack tells every business the same thing; a useful one reflects how your sector makes money and where it loses it.
Most businesses do not fail with software because they bought the wrong product. They fail because nobody designed how the business would run inside i…
Service detailBookkeeping is not data entry. Done properly it is the discipline that turns daily transactions into numbers a managing director can rely on. We run t…
Service detailSoftware only automates the process you give it. If the process is unclear, undocumented and dependent on individuals, the system simply records the c…
Service detailAdvisory work is useful when a decision has to be made and the numbers behind it are not clear. We analyse the position, model the options, quantify t…
Service detailStock valuation method must be applied consistently and disclosed appropriately, and duty, levy and VAT treatment on imported goods needs to be handled correctly in landed cost. Getting landed cost wrong understates cost and overstates margin, which then distorts pricing decisions.
We do not publish rates, thresholds or deadlines on this website, because a figure that is out of date is more damaging than no figure at all. Where specific figures matter, they are given in an engagement against the position in force at that date.
The count itself is quick; the process changes behind it take a few cycles to stick. Goods-received discipline, inter-branch transfer recording and price control are usually where the variance comes from, and those take longer than the counting.
This page describes the operating problems and reporting needs we understand in this sector, and the work that follows from them. It is not a claim about named clients. If you want references in your sector, ask us directly and we will tell you honestly what we can provide.
It depends on whether your reporting relies on operational data — stock, jobs, production, projects, grants. If it does, accounting software will leave you assembling that data by hand every month, and an ERP is usually the cheaper option over three years. Use the solution finder for a preliminary view, then let us assess it properly.
Usually, yes. We review the configuration and the processes around it first, because many problems described as software problems are configuration or process problems. Where a rebuild is genuinely needed we will say so.
Some things are quick — a daily reconciliation routine, a proper aged receivables report, an approval framework. Others take a full cycle or two, particularly where data has to be corrected first. We set expectations in the scope rather than promising a timeline we cannot control.
A named person who can make decisions, access to the records and the systems, and time from the people who do the work. Implementation and process work fail on availability more often than on anything else.
Tell us what you are dealing with. We will tell you honestly whether we can help, what it would involve and what it would cost.