CorporateWalla logoCorporateWalla
CW · ACCOUNTING & BOOKKEEPING

Inventory & Stock Reconciliation Services

  • Every difference traced to one of six causes, so a variance is not called a loss until the other five are eliminated
  • Negative stock listed, dated and cleared — it is a physical impossibility, so the records are definitively wrong
  • Marketplace and 3PL reconciliation where you do not hold the stock and a count is not available
  • A correction schedule designed to be posted, not interpreted
  • Process findings, so the same differences do not reappear next quarter

When You Need Reconciliation Rather Than a Count

Your stock ledger says one thing. Your warehouse says another. Somewhere between them sit a few hundred differences nobody has had the time to work through — and until they are worked through, every report built on that ledger is unreliable.

A physical count tells you what is there. Reconciliation tells you why the records disagree with it. Those are different problems and they need different engagements.

You need reconciliation when
  • Your last count produced a variance you never closed out
  • The ledger carries negative stock — a physical impossibility, so the records are definitively wrong
  • Your ERP and your warehouse system disagree, or your ERP and your marketplace dashboard disagree
  • You migrated systems and the opening balances were never proved
  • The same items show a shortage in one code and an excess in another
  • Your statutory auditor has raised an inventory query you cannot answer from the ledger as it stands
  • A GST notice has been issued on a stock discrepancy and you need a documented reconciliation to respond with
You need a count instead when

Often the honest answer is both: count first, then reconcile. We will tell you which you need at the scoping call rather than sell you the larger engagement by default.

The Six Causes, in the Order We Eliminate Them

  1. Timing differencesGoods received but not booked; dispatched but not invoiced; internal transfers in transit at the cut-off. Usually the largest bucket and the least alarming.
  2. Unit-of-measure errorsMetres booked as kilograms. Boxes counted as pieces. A carton of 24 entered as 1. These produce spectacular variances that are not losses at all, and they recur until the item master is fixed.
  3. Item-coding errorsThe same physical item living under two codes, so one shows a shortage and the other an equal excess. Visible immediately once you sort the variance register by value.
  4. Unrecorded movementsIssues to production, samples, replacements, warranty returns and internal consumption that never reached the ledger.
  5. Condition, not quantityThe item is physically present but damaged, expired or unsellable. That is a valuation and provisioning question, not a count question, and treating it as shrinkage misstates both.
  6. Genuine lossOnly after the first five have been eliminated. Quantified, located, and reported with the period over which it arose where the records allow it.

Negative Stock, Marketplaces and ERP Migrations

Negative stock. A negative balance means an issue was booked before the corresponding receipt. It cannot be a real position. We list every negative balance in the ledger with its item, location and date, because each one is both a correction to make and a control finding to act on — and because auditors ask about them.

Marketplace and 3PL reconciliation. For e-commerce sellers and D2C brands the stock cannot be counted, because you do not hold it. Reconciliation here means matching your books against the platform's or the 3PL's own inventory report, and accounting for the lag created by returns, RTOs, unsellable inventory and reimbursements. It is a documentary exercise, and it is frequently the only verification available. See e-commerce accounting.

ERP migration cleanup. Opening balances in a new system are only as reliable as the reconciliation behind them. We prove the closing position in the old system, identify what should and should not carry over, standardise the item master and units of measure, and hand over a migration-ready stock file with the workings.

Our Process

  1. Scoping callWhat is wrong, what systems are involved, what the deadline is.
  2. Data extractionStock ledger, item master, movement registers, and the physical count or platform report you are reconciling against.
  3. Data quality reviewDuplicate codes, inconsistent units, blank locations, negative balances.
  4. Line-by-line comparisonBook against physical, or book against the counterparty record.
  5. Cause analysisEach variance run through the six causes above.
  6. Correction scheduleThe entries to post, with supporting reasoning for each.
  7. Process findingsWhere in your workflow the differences originate.
  8. ReportVariance register, correction schedule and process recommendations.

What You Receive

  • Variance register — item, location, book quantity, physical quantity, variance quantity and value, classification, and the evidence behind each classification
  • Correction schedule — the adjustments to pass, grouped by type, ready for your accounts team
  • Negative stock schedule — every negative balance with its origin
  • Item master issues list — duplicates, unit inconsistencies, unusable descriptions
  • Process findings — where the differences are being created, so this is the last time you pay for this
  • Reconciliation statement — book to physical, with every reconciling item explained

Data We Need

  • Stock ledger or closing stock statement at the reconciliation date, item-wise and location-wise
  • Item master with units of measure
  • Goods receipt, issue, dispatch and return registers for the period
  • Physical count sheets, if a count has been done
  • Marketplace or 3PL inventory reports, if applicable
  • Purchase and sales registers
  • Details of any adjustments already passed
  • List of locations with custodians

Why CorporateWalla

We classify before we conclude. A variance is not a loss until the other five causes have been eliminated. Firms that report gross variance as shrinkage produce numbers that alarm boards and mean nothing.

We fix the cause, not just the number. The process-findings section is the part that stops you buying this engagement again in six months.

We hand over entries, not homework. The correction schedule is designed to be posted, not interpreted.

One team. DSG Corporate Financial Advisors LLP — in-house Chartered Accountants, Company Secretaries, Cost Accountants and lawyers, so a reconciliation that turns into a GST exposure or an audit qualification stays with the same people.

Inventory Reconciliation FAQs

What is inventory reconciliation?

The process of comparing recorded stock against physical or counterparty-reported stock and explaining every difference between them — by cause, not just by amount.

What is the difference between a stock audit and inventory reconciliation?

A stock audit includes a physical count, a documented cut-off, a sampling basis and an independent report. Reconciliation is the records-side exercise of explaining differences. Reconciliation is a step within a stock audit; it is also a standalone engagement when the count already exists and the differences were never closed out.

Why does book stock differ from physical stock?

Six recurring reasons: timing differences around the cut-off, unit-of-measure errors, duplicate or wrong item codes, unrecorded movements, condition issues mistaken for quantity issues, and genuine loss. In most engagements genuine loss is the smallest of the six.

What does negative stock mean?

That an issue was recorded before the corresponding receipt. It is physically impossible, so it always indicates a records error. It also invites audit and departmental questions, which is why every negative balance is listed and cleared.

Can you reconcile stock held at a 3PL or on a marketplace?

Yes. Where you do not hold the stock, reconciliation is against the custodian's or the platform's own inventory report, with returns, RTOs and unsellable inventory accounted for separately. For many e-commerce sellers this is the only verification available.

Do I need a physical count first?

Not always. If a recent count exists and the variances were never closed, reconciliation alone is enough. If nothing has been counted this year, or you need independent evidence of existence, count first — see stock audit. We will tell you which at the scoping call.

Will this help with a GST notice on stock differences?

A documented reconciliation, with each difference traced to a cause and supported by records, is the basis on which a reply is built. GST law requires stock records under section 35 of the CGST Act and rules 56(2) and 56(12); it does not require physical verification. Where a discrepancy has been alleged, what matters is whether you can explain it from your records.

How long does a reconciliation take?

It depends on SKU count, number of locations and the state of the data. Most of the time is spent on data quality, not on comparison. We give a timeline with the scope after the scoping call.

Request a Scoping Call

Send us a stock ledger extract and tell us what you are trying to close. We will tell you whether this is a reconciliation, a count, or both.

Useful to know up front: which ERP or accounting system you run — Tally, SAP, Oracle, Zoho, Busy, something custom, or spreadsheets — roughly how many SKUs and how many locations, and what is driving this. Persistent variances, negative stock, an ERP migration, a marketplace or 3PL mismatch, a statutory audit query, a GST notice and a first-time cleanup are six different engagements.

CorporateWalla, operating under DSG Corporate Financial Advisors LLP, 129A Bangur Avenue, Block A, Kolkata 700055.

CW · ACCOUNTING & BOOKKEEPING

Send a ledger extract and we will scope it

We will tell you whether the fix is a reconciliation, a count, or both — and price only what the job needs. Call 72783 76654. Mon–Sat, 10:00 AM – 7:00 PM IST.