For Australian retailers, wholesalers and distributors

Stock Ledger and Inventory Reconciliation: When the Warehouse and the Ledger Disagree

Ask what your inventory is worth and you will often get two answers. The inventory system reports one figure, the balance sheet reports another, and the difference is explained as a timing issue by people who know it is not. Left alone, that gap widens every month until stocktake produces an adjustment nobody can account for.

This is not a bookkeeping nuisance. Inventory is usually the largest current asset in a retail or wholesale business, and if its value is wrong then reported margin, borrowing capacity and every stocking decision built on cost price are wrong with it. This page is about finding the causes and closing them.

Book a Reconciliation Review (03) 9003 0111

Realistic ROI

Largest asset

Inventory on most retail balance sheets

Which is why a percentage error here outweighs most other reporting problems

Every movement

Should have a matching financial posting

Receipts, sales, transfers, adjustments and write offs alike

Monthly

The longest sensible reconciliation interval

Annual reconciliation means finding an unexplained difference you can no longer trace

Two methods

Cost calculated differently in each system

A very common root cause, and one that never resolves itself

Four Reasons the Two Numbers Drift Apart

The gap is almost never one big error. It is several small mechanisms, each running quietly every day.

The two systems cost stock differently

An inventory system might value stock at a moving average cost while the accounting system carries what was posted at receipt, or one applies landed cost and the other only the supplier price. Both are internally consistent and they will never agree. This is the most common root cause of a persistent gap and it cannot be fixed by adjusting entries, only by aligning the method or by defining exactly how one translates into the other and posting that difference deliberately.

Some movements never generate a posting

Sales usually post cost of goods sold reliably because someone checked that early. The movements that quietly do not are transfers between locations, stock written off for damage, samples and staff purchases, goods receipted before the supplier invoice arrives, and returns put back into stock. Each is small. Together they are the drift, and because each has a different cause they have to be found individually rather than adjusted away as a total.

Cut off is treated loosely

A receipt entered on the first of the month for goods that arrived on the last day of the previous one moves value between periods. So does an invoice posted in one period against a receipt recorded in another. Most businesses have a rule for this and a practice that differs from it. Since reconciliation is done at a point in time, a cut off that is not applied consistently in both systems produces a difference that looks like an error and is actually a date.

Nobody owns the difference

Where the reconciliation is prepared by finance but every cause sits in operations, the report gets produced and filed and nothing changes. Closing the gap needs the variance broken down by cause, each cause assigned to the person who can address it, and the remaining unexplained amount tracked over time so it is visibly shrinking. A single total handed to a bookkeeper is a report, not a control.

How the Reconciliation Is Built

Six components. The first three usually explain most of the gap on their own.

Comparable figures

Establish the two positions

Extract stock on hand quantity and value from the operational system and the inventory balance from the ledger, at the same moment, on the same basis, for the same set of locations. This sounds trivial and rarely is, because the two systems often disagree about which warehouses, consignment stock and goods in transit are included.

Same basis

Align the costing method

Document exactly how each system arrives at a value: average cost, standard cost, last cost, first in first out, and whether freight, duty and handling are included. Where the methods differ, agree with your accountant either to align them or to define and post the translation, so the difference is explained by design rather than discovered every month.

Nothing untracked

Map every movement to a posting

List every way stock can move: receipt, sale, return, transfer, adjustment, write off, sample, staff purchase, assembly, consignment. For each, identify the financial posting that should result and confirm whether it actually happens. The ones with no posting are the leak, and finding them is usually the single highest value step.

Broken down

Explain the current variance

Decompose today’s difference into named causes with amounts: costing method, timing and cut off, missing postings by type, known adjustments not yet booked, and a genuine unexplained residual. A reconciliation that produces a single number nobody can decompose has not really been done.

Monthly, not annual

Automate the periodic check

A scheduled comparison that produces the variance broken down the same way every period, with movement level detail available behind it, delivered to the people who own each cause. Automated so it survives the month when everyone is busy, which is exactly when the gap tends to grow.

Adjustments explained

Close the loop on counts

Cycle counts and stocktakes feeding adjustments that post correctly to both systems, with the reason recorded rather than a bare quantity change. Counting regularly across the year on a rolling basis gives a far better result than one annual count, because a discrepancy found in March can still be investigated.

Common Causes and What They Look Like

Task	Traditional	Reconciled Properly	Notes
Freight and duty in one system only	Explained as rounding	Identified as a costing gap	Typical in importing businesses where landed cost never reaches the accounting system.
Interbranch transfers	Quantity moves, value does not	Matched movement and posting	Harmless within one entity, seriously misleading across separate legal entities.
Damaged stock written off	Removed at the warehouse only	Posted with a reason code	The reason codes are what turn a write off total into something operationally useful.
Goods received, invoice not arrived	In stock, not in the ledger	Accrued and reconciled	Usually needs a goods received not invoiced account that someone actually reviews.
Returns put back on the shelf	Cost never reversed	Reversed at the original cost	Small per transaction, material at volume for high returns categories.
Consignment stock at a customer	Counted twice or not at all	Held as a distinct state	Ownership determines whose balance sheet it belongs on, so define it explicitly.
Stock in transit between sites	Missing from both locations	Visible as in transit	Grows in importance the further apart your locations are.
Annual stocktake adjustment	A large unexplained number	A small residual after named causes	The size of the unexplained residual is the honest measure of whether this worked.

Where Reconciliation Efforts Fail

The difference is journalled away each month

Posting an adjustment to make the balance sheet agree with the inventory system removes the symptom and preserves every cause. The gap reappears next month, slightly larger, and the history of adjustments makes the original mechanism harder to find. Adjust only after the variance has been decomposed and the causes identified, and record what each adjustment relates to, so the pattern remains visible rather than being smoothed out.

Only quantities are reconciled, not values

Quantity reconciliation is worth doing and it is not the same exercise. Two systems can agree perfectly on how many units are on hand and disagree substantially on what they are worth, because the value depends on the costing method, on whether landed cost is included and on which movements have been costed. If your reconciliation stops at units, the balance sheet risk is entirely unaddressed.

Cost changes are applied retrospectively without control

Revaluing stock by changing a cost price is easy in most systems and its financial effect is frequently not posted, or is posted to whatever account was default. Cost price changes should be a controlled action with a clear posting, particularly when landed cost true ups arrive weeks after receipt. Uncontrolled revaluation is a common source of a gap that appears suddenly and cannot be traced to any movement.

Record keeping is not good enough to support the numbers

Inventory valuation and cost of goods sold feed your financial statements and your tax position, and the supporting records need to be retained and retrievable in line with Australian Taxation Office record keeping requirements. A reconciliation that depends on a spreadsheet on one person’s machine, or on system logs that are purged after ninety days, will not stand up when it is needed. Confirm the retention requirements with your accountant and design the evidence trail to meet them.

Stocktake happens once a year

An annual count finds a discrepancy that accumulated over twelve months, by which time the cause is untraceable and the adjustment is simply accepted. Rolling cycle counts, weighted so that high value and fast moving lines are counted more often, find problems while the surrounding records still exist. It is also far less disruptive than closing the warehouse, which is usually the argument that wins the discussion.

Nobody has a target for the unexplained residual

Without a stated tolerance, any difference is treated as normal and the reconciliation becomes a monthly ritual. Agree what an acceptable unexplained residual looks like for your business, in dollars and as a percentage of inventory value, report against it every period, and treat a breach as an incident with an owner. The number will not improve on its own simply because it is being measured.

How Yes AI Approaches Stock Reconciliation

We find the mechanisms before proposing a fix

The first piece of work is decomposing your current difference into named causes with amounts attached. Frequently two or three mechanisms explain most of it, and the remedy is far smaller than the size of the gap suggests. We would rather deliver that analysis than sell a project you may not need.

Costing decisions made with your accountant

Whether to align costing methods or define and post the translation between them is a financial reporting decision, and it belongs with the people responsible for your accounts. We implement what they determine and document it, rather than substituting our own judgement for professional advice.

Built, hosted and monitored by us

The periodic comparison runs on a managed cloud automation layer we operate, producing the same breakdown every period with movement level detail behind it, delivered to the people who own each cause. It keeps running in the months when everyone is too busy to prepare it by hand.

Movements mapped so nothing is untracked

We document every way stock can move in your business and confirm which financial posting each one produces. The movements that produce none are the leak, and listing them is usually the most immediately useful deliverable in the engagement.

From an Unexplained Gap to a Controlled One

Five steps. The first analysis normally takes two to three weeks and often changes what the rest of the project needs to be.

Take both positions properly

Stock on hand and value from the operational system and the inventory balance from the ledger, at the same point in time, for an agreed set of locations and stock states including in transit and consignment.

Document how each system costs stock

The costing method in each, what is included in cost, and how landed cost, revaluations and true ups are handled. Where they differ, the difference is quantified rather than described.

Map movements to postings

Every movement type listed and traced to the financial posting it should create, with a test of whether it actually does. The movements producing no posting are identified and quantified.

Decompose the variance and fix the causes

The current difference broken into named causes with amounts, then the fixes applied at source: postings added, methods aligned or translated, cut off tightened, revaluation controlled.

Automate the check and set a tolerance

A scheduled reconciliation producing the same breakdown every period, an agreed tolerance for the unexplained residual, alerting when it is breached, and cycle counting replacing reliance on an annual stocktake.

FAQ

Why do our inventory system and our accounting system show different stock values?

Usually for several reasons at once. The two systems often calculate cost differently, for example a moving average in one and the amount posted at receipt in the other. Some stock movements produce no financial posting at all, commonly transfers, write offs, samples and returns to stock. Cut off between periods is applied inconsistently. And landed costs such as freight and duty may be included in one system and expensed in the other. Each contributes, which is why the fix is a decomposition rather than a single correction.

Is it normal to have a gap?

A small and explainable difference is normal, particularly around period ends where timing legitimately separates a receipt from an invoice. What is not normal, though it is very common, is a gap that nobody can decompose and that grows month on month. The useful test is not whether the two numbers match exactly but whether you can explain the difference by named cause with amounts, and whether the unexplained residual is small and stable rather than steadily increasing.

Should we just adjust the ledger to match the inventory system?

Not before you understand why they differ. An adjusting journal makes the current period agree while leaving every mechanism running, so the gap returns and the history of adjustments makes the original cause harder to find later. Decompose first, fix the causes at source, then adjust the residual with a note explaining what it relates to. Adjust the balance sheet to match an operational system whose own valuation you have not verified and you may be correcting the wrong number.

How often should we reconcile?

Monthly for most businesses. Quarterly is defensible where inventory is small relative to the business or movements are few. Annually is effectively not reconciling, because a difference that accumulated over twelve months cannot be traced to its causes and simply becomes an adjustment nobody can explain. Monthly is also what makes rolling cycle counts worthwhile, since discrepancies are found while the surrounding records and the people who remember the transactions are still available.

What about stock we hold at a 3PL or on consignment?

Both need to be defined explicitly as their own stock states, because the common failure is stock that is either counted twice or missed by both systems. For a third party warehouse, you are reconciling against someone else’s records as well as your own, so it needs its own regular comparison. For consignment, the question is ownership: stock you own that is sitting at a customer site is still your asset and belongs on your balance sheet, while stock a supplier owns that sits in your warehouse does not, and getting this wrong misstates inventory in either direction.

Do we need to change systems to fix this?

Very rarely. Most gaps are caused by configuration, by missing postings and by process rather than by a system being incapable. The exceptions are genuine, for instance an inventory system that cannot represent landed cost at all or an accounting system with no way to hold a goods received not invoiced position, but they are less common than vendors suggest. We would rather map your movements and show you which specific ones produce no posting than recommend a replacement that leaves the same process problems in place.

How long does this take to sort out?

The diagnostic, meaning taking both positions, documenting the costing methods, mapping movements to postings and decomposing the current variance, is typically two to three weeks. Fixing the causes depends on what is found: adding missing postings is quick, aligning costing methods needs accounting sign off and careful sequencing, and tightening cut off is a process change that takes a period or two to embed. Most businesses have a controlled and explainable position within one to three months.

Know What Your Stock Is Actually Worth

Book a call. We decompose your current difference into named causes with amounts, and give you a priced plan to close them. The analysis is yours either way.