---
title: "Stock Audit and Stock Reconciliation: How to Match Physical and Book Stock"
slug: "reconcile-book-stock-physical-stock"
published: "2026-08-26"
author: "Ravi Chandel"
---

# Stock Audit and Stock Reconciliation: How to Match Physical and Book Stock

When book stock and physical stock do not match, start a stock audit for that item and location: confirm the same unit, repeat the physical count, trace the movement facts, and make a stock adjustment only when the evidence supports it.

This is a merchant reconciliation process, not a single button. The recorded quantity is a useful starting point; the shelf count is the fact to verify. For an Indian retailer, wholesaler, distributor, FMCG stockist, manufacturer or multi-location merchant, the risk is promising cartons that are not there, buying stock that is already in the godown, or changing the record without knowing what caused the gap.

If the difference began with broken, expired or wasted goods, compare it with the [damaged-stock adjustment guide](/blogs/damaged-stock-wastage-inventory). If the count is tied to goods coming back, use the [sales and purchase returns guide](/blogs/sales-purchase-return-stock) before correcting the balance.

If the difference first appeared immediately after billing, read [why stock goes negative after a sale](/blogs/why-stock-goes-negative-after-sale) for the unit, location and recent-movement checks to do before changing the recorded quantity.

If the shop must keep serving customers while you investigate, follow the [live stock count routine for an open shop](/blogs/how-to-count-stock-without-closing-shop?utm_source=blog&utm_medium=organic&utm_campaign=reconcile-book-stock-physical-stock&utm_content=open-shop-count) for a short count window, a named cut-off and a signed count sheet.

## How to do a stock audit when physical and book stock differ

Book stock is the quantity in your stock record for one item, unit, location and point in time. Physical stock is what the team can actually count in that location at the same point in time. They should be compared like for like: one item, one unit, one godown or shop, and a stated count time.

Do not compare “Parle-G cartons” in the book with loose pieces on a shelf without converting them to one agreed unit. Do not compare the combined quantity of Jaipur Main Godown and Kota Branch with a count taken only at Kota. A difference can be real, or it can be a comparison error.

## Stock reconciliation process: count, trace, decide, correct

### 1. Hold the disputed item, not the whole godown

Note the item and location before the next inward, outward or transfer changes the number. If a retailer order is waiting, tell the salesperson that the quantity is being checked and give a revised time for the answer. You do not need to stop every item in the godown; isolate the disputed item and record the count time.

Write down the item name, pack size, unit, location, date, time, counter and reason for the check. If the same item sits in a shop, branch or second godown, keep those locations separate until you know where the difference belongs.

### 2. Repeat the physical count with a clear boundary

Count unopened cartons and loose units separately, then convert them into the agreed stock unit. Check the reserve rack, picking area, damaged-goods corner, returns shelf and goods kept aside for a retailer order. Ask the counter to mark each counted stack so a second person can repeat the count without guessing where the first count ended.

For a carton item, a useful sheet might say: 60 sealed cartons + 18 loose cartons’ equivalent = 78 cartons. If the pack conversion is uncertain, stop at the conversion question; do not enter a correction merely to make the arithmetic look tidy.

### 3. Check store-wise stock before you correct the number

Open the recorded stock for the same item and store. Check the unit shown, the balance date or period, and whether the user is looking at one store or a combined view. A store-wise balance matters when the physical count happened at one branch but the record was opened for another.

Stock Register’s [store-wise stock view](/features/multi-godown) lets a merchant inspect the recorded quantity for the relevant shop, branch or godown. That confirms the book balance for that location; it does not confirm the shelf count.

### 4. Review stock movement history before an adjustment

Start with the time of the last known matching count and work forward. Gather purchase inward entries, sales outward entries, returns, stock-in or stock-out entries, inter-location transfers, cancelled or edited transactions and any manual notes. For every movement, ask four questions:

- Did the item and unit match?
- Did the movement happen at this location?
- Did the quantity physically move?
- Was the movement recorded once, twice or not at all?

Stock Register’s [stock movement and item history](/features/stock-tracking) shows the entries recorded for an item. Use it to find movements that may explain the gap. It shows the book trail; the godown team still has to confirm what physically happened.

### 5. Name the likely cause before deciding

Do not label every gap as “damage.” Put the difference into the most specific supported explanation you can find:

- **Counting or unit error:** the second count or pack conversion changes the number.
- **Timing difference:** a purchase inward, sale outward or transfer happened around the count but was not included consistently.
- **Wrong location:** the goods are in another shop or godown, or the entry was recorded against the wrong store.
- **Unrecorded movement:** cartons moved, were returned, sampled or dispatched without an entry.
- **Loss or damage:** the physical quantity is genuinely lower and the team has checked the likely locations and movements.

If the cause is still unclear, leave the difference open, protect the next customer promise and keep checking. A neat correction with a vague reason is less useful than a dated note saying what is still unknown.

### 6. Make a stock adjustment only when the facts support it

An adjustment is justified when the count is repeatable, the unit and store are confirmed, relevant movements have been checked, and the difference has a documented business reason. If a transaction was simply entered against the wrong store, correct the underlying entry when your process allows it; do not use a stock adjustment to hide a location error.

Stock Register supports [stock adjustment](/how-to-use/inventory-management/stock-adjustment) for changing a recorded balance, and its current code supports selecting or maintaining adjustment reasons. Use a narrow reason such as “physical count shortfall — 26 Aug” or “count surplus after unit check,” based on what you found. The reason records the decision; it does not explain the physical cause by itself.

Where the account has the relevant report, Stock Register also exposes a stock-adjustment reason-wise report. Review it as a list of adjustments by reason; it does not replace the count sheet or your notes.

## When your register says 84 cartons but the count is 78

If the register shows 84 cartons for one biscuit item at Jaipur Main Godown and the team counts 78, check the reserve rack, dispatch staging area and damaged-goods corner before changing the stock record.

| Fact | Quantity or note |
| --- | --- |
| Book stock at Jaipur Main Godown | 84 cartons |
| Sealed cartons counted | 72 cartons |
| Loose stock converted to carton-equivalent | 6 cartons |
| Physical stock | 78 cartons |
| Difference | 78 - 84 = **6 cartons short** |

The team then finds a 6-carton outward entry created for a retailer dispatch but not reflected in the paper count sheet. If the cartons have left the godown, the book may already be right and the count sheet was taken before the outward movement. No adjustment is justified for that difference.

If the outward entry is not real, the team checks the dispatch area, driver note and retailer communication. If the cartons are still missing and the repeated count remains 78, the owner can record a 6-carton stock-out adjustment with a specific physical-count reason, according to the business’s documentation practice. Replace the item, unit, location and quantities with the records from your own godown.

## Decide what happens to the next order

Until the gap is understood, use the lower confirmed quantity for a cautious dispatch conversation. If the count is 78 and no cartons are reserved, do not promise 84. If the discrepancy is a wrong-store entry and the cartons are in Kota Branch, the next step is to correct the location record or document an internal transfer according to what physically happened. If stock is genuinely short, decide whether to partially serve, transfer usable stock, purchase, or give the retailer a later date as a business decision.

Keep the decision tied to the item and store. A combined total across godowns can be useful for a broad review, but it cannot prove that Jaipur can dispatch cartons sitting in Kota.

## What to record with every investigation

Keep one compact investigation note with:

- item name, pack and agreed unit;
- store or godown name;
- book quantity and the screen or report date;
- physical count, counter and count time;
- movements checked and the period checked;
- suspected cause and evidence found;
- decision: no correction, transaction correction or stock adjustment;
- adjustment reason and reference, if a correction is made;
- person who checked the final result.

This note helps the next person understand why a balance changed. It is your stock-check record, not a claim that Stock Register automatically reconciles stock.

## What Stock Register can and cannot do in a stock audit

Stock Register can help you inspect [recorded stock movement/history](/features/stock-tracking), compare [store-wise recorded quantities](/features/multi-godown), enter a [stock adjustment with a reason](/how-to-use/inventory-management/stock-adjustment) where supported, and work within [staff/store access](/features/staff-roles) assigned to the account. These are product actions.

The physical count, cause check, dispatch decision, evidence collection and decision that a correction is justified belong to your team. Stock Register does not automatically reconcile book stock to a shelf count, investigate the cause or approve a correction for you.

## Common mistakes that create a second mismatch

### Counting while movement continues

If cartons are being picked while the count is running, write down the time and movements or pause the disputed item. Otherwise the two numbers may describe different moments.

### Mixing units

A carton, case, piece and kilogram are not interchangeable until the pack conversion is clear. Put the unit next to every quantity on the count sheet.

### Correcting the wrong store

A short Jaipur balance and surplus Kota balance may be a location-record problem, not a loss. Check store-wise recorded stock and the movement trail before adjusting.

### Using a generic adjustment reason

“Correction” tells the next person very little. Use a dated, specific reason that matches the evidence, and retain the count note outside the entry if your process needs more detail.

### Treating the first count as final

Repeat a meaningful difference after checking hidden, reserved, returned and damaged areas. A second count is often cheaper than a wrong stock correction.

## A daily and weekly reconciliation checklist

### When a difference is reported

- Confirm item, pack, unit, store and count time.
- Count sealed, loose, reserved, damaged and returned stock.
- Compare the physical number with the store-specific book balance.
- Trace inward, outward, returns, transfers and edits since the last known match.
- Decide whether the cause is known, still open or ready for correction.
- Record the next dispatch or purchase decision using the confirmed quantity.

### Weekly review

- Review repeated differences for the same item or location.
- Check adjustment entries and their reasons.
- Compare adjustment reasons with the investigation notes.
- Confirm staff are using the correct store and unit when entering movements.
- Choose a practical count rhythm for fast-moving or high-value items based on your own risk.

## Frequently asked questions

### What is stock reconciliation?

Stock reconciliation is the process of comparing physical stock with book stock for the same item, unit and location, tracing the difference, and deciding whether the recorded balance needs a documented correction.

### Does Stock Register automatically reconcile physical and book stock?

No. Stock Register helps you inspect store-wise recorded stock, movement/history and stock adjustments with reasons where supported; your team must count the goods, investigate the difference and decide whether to correct it.

### When is a stock adjustment justified?

A stock adjustment is justified after a repeatable count, confirmed unit and location, movement checks and a specific business reason support changing the recorded balance. Do not use it to conceal a wrong-store transaction.

### Can I record why a stock adjustment was made during a stock audit?

Yes, Stock Register’s current stock-adjustment flow supports selecting and maintaining adjustment reasons, and a reason-wise adjustment report is available where supported. Use a reason that matches the evidence; it does not prove the physical cause by itself.

### Can staff compare physical counts across every store?

Staff visibility depends on the store access assigned to them. Stock Register supports staff/store access controls in the current product code, but the person doing a physical count still needs access to the relevant location and the business’s count sheet.

### Should I buy more stock when the physical count is lower?

Not automatically. First establish whether the gap is a timing, unit, location or recording issue; then compare the confirmed usable quantity with the next retailer order, supplier lead time and cash decision as general business practice.

## The practical rule

Count the stock, match the unit and store, trace the movement, and correct only the difference you can explain. That keeps a physical-count conversation useful for the next dispatch, purchase or transfer without pretending that a stock record can see inside a carton stack.