# Inventory Reconciliation From Count to General Ledger

- Author: PreciseBankFlow (https://precisebankflow.com)
- Published: 2026-10-17
- Category: Account reconciliations
- Canonical: https://precisebankflow.com/blog/inventory-reconciliation

> How to do an inventory reconciliation: physical count to the perpetual records to the ledger, cutoff, shrinkage and the adjustments a reviewer expects.
An inventory reconciliation compares three records of the same goods: the physical count on the shelves, the perpetual records in the inventory system, and the inventory balance in the general ledger. Quantities are tied first, then values. Each variance is investigated, the cutoff is checked, and the approved adjustment brings all three into agreement.

## Three layers of an inventory reconciliation: count, perpetual records, ledger

An inventory reconciliation has three layers, and each answers a different question. The count asks what is physically there. The perpetual records ask what the system thinks is there. The ledger asks what the goods are worth in the accounts. Tie them in that order, because a value tie means little if the quantities are wrong.

Perpetual records are the item-level quantities a system updates with every receipt, sale, transfer and adjustment. Not every business keeps them. A business on a periodic system has only the count and the ledger, and the count itself sets the closing figure. The steps below assume a perpetual system, which is where most of the reconciling work lives.

The three layers in short:

| Layer | Source | Question it answers |
| --- | --- | --- |
| Physical count | Count sheets or scanner file | How many units are on hand at count time |
| Perpetual records | Item listing from the inventory system | How many units the system expects, and at what cost |
| General ledger | Inventory account balance | What the books carry as the asset value |

The sections below take each pair in turn: count to perpetual, perpetual to ledger, then the cutoff that affects both.

## Physical inventory count to perpetual records, item by item

Comparing the physical inventory count with the perpetual records means matching counted quantities to system quantities for every item and listing the variances. Small variances on cheap items are expected. Large or repeated variances on valuable items are where the investigation starts.

Freeze movement during the count where you can. If goods must keep moving, record the last receiving document and the last shipping document processed before counting started, so the system snapshot and the count describe the same moment.

Run the system's item listing as of the count time, then enter the count. The worked example below shows five illustrative items from a count at a small distributor.

| Item (example) | System qty | Counted qty | Variance qty | Unit cost | Variance value |
| --- | --- | --- | --- | --- | --- |
| Hand drill, 18V | 140 | 136 | (4) | 62.00 | (248.00) |
| Drill bit set | 410 | 412 | 2 | 9.50 | 19.00 |
| Safety goggles | 900 | 880 | (20) | 3.25 | (65.00) |
| Tool case, large | 75 | 75 | 0 | 41.00 | 0.00 |
| Cordless saw | 32 | 27 | (5) | 189.00 | (945.00) |
| **Net variance** | | | | | **(1,239.00)** |

Before accepting any variance, recount the items over a set value or a set percentage. In the example, the cordless saw stands out. Five missing units at 189.00 each is the largest line, on an item that is easy to carry away.

For each variance that survives the recount, check the obvious explanations first: a receipt entered against the wrong item, a sale shipped but not recorded, goods sitting in a returns area that was not counted, or units of measure mixed up, such as boxes counted as single items. Many variances disappear at this stage. Record which ones did and why.

## Perpetual inventory valuation to the general ledger balance

Once quantities are settled, the perpetual records are valued at cost and the total is compared with the inventory balance in the general ledger. These two should agree, because every inventory transaction in the system posts to the ledger. When they do not, something posted to the ledger without going through the item records.

The usual differences between the valued item listing and the ledger are:

- **Manual journal entries** to the inventory account, such as freight or duty capitalized by journal instead of on the receipt.
- **Received-not-invoiced timing.** Goods received into stock before the vendor bill arrives may be valued at the purchase order price, then adjusted when the bill comes in at a different price.
- **Reserves for obsolete or slow-moving stock,** which many businesses hold in a separate contra account. They reduce the ledger value but not the item listing.
- **Costing method updates,** where standard costs are revised and the revaluation entry lands in the ledger on a different date from the item listing.
- **Capitalized labor and overhead** in manufacturing, recorded through production entries that may lag the item records.

Received-not-invoiced goods link inventory and payables. The same receipt that adds units to stock creates a liability that the vendor's bill later replaces, and the reconciliation of that side is in the [accounts payable reconciliation template and vendor checks](/blog/accounts-payable-reconciliation-template).

If a difference cannot be traced quickly, resist parking it in a general holding account to get the close done. A [suspense account reconciliation that ages and clears old items](/blog/suspense-account-reconciliation) explains why those balances become hard to unwind.

## How does receiving and shipping cutoff distort an inventory count?

Cutoff is the line that decides which period a receipt or shipment belongs to. If goods arrive before the count but the receiving document is processed after, the count shows units the system does not have. If goods ship before the count but the sale posts after, the system shows units that are gone. Both create false variances.

Check cutoff on both sides of the count:

1. **List the last five to ten receiving documents** before the count and the first few after. Confirm the goods on the earlier documents were counted and the goods on the later ones were not.
2. **Do the same for shipping documents.** Goods shipped before the count should not be on the shelves or in the system.
3. **Look at goods in transit.** Purchases shipped by the vendor but not yet received may belong to you already, depending on the shipping terms in the agreement. Sales shipped to a customer may still be yours on similar terms.
4. **Check consigned goods.** Stock held for others should be excluded. Your own stock placed at a customer's site on consignment should be included.

Cutoff errors often explain a variance on one item that is the mirror of another variance on the same item in the next count. If a large positive variance appears where a receipt was posted the day after counting, the variance is timing, not a real gain.

## Inventory shrinkage: when is a count shortage a theft signal?

Inventory shrinkage is the loss of stock between what records say and what is counted, from damage, spoilage, recording errors or theft. Some shrinkage is normal in almost every business. A shortage becomes a theft signal when it concentrates on high-value, portable items, repeats in the same area or appears after records were changed.

Look at shrinkage as a pattern across counts, not as one number:

- **By item.** Are the same few items short at every count?
- **By location.** Does one store, aisle or warehouse account for most of the loss?
- **By time.** Did shortages rise after a staff change or a change in who can adjust records?
- **By adjustment history.** Were positive adjustments posted before the count to cover a known gap?

In the worked example, the cordless saws and hand drills carry nearly all the value of the variance. If the same items were short last quarter, that is a pattern. Recording errors tend to scatter across items; theft tends to cluster.

A shortage that points to a person needs care. Do not confront anyone or delete the count records. The guide on [what to do if you suspect embezzlement at work](/blog/what-to-do-if-you-suspect-embezzlement) describes how to preserve evidence and who to involve. Inventory losses that end in a refund or credit to a customer can also leave a trace in the bank. [PreciseBankFlow](/) lists bank statement lines that have no matching ledger entry, which helps check whether refunds paid out line up with returns received.

## Inventory adjustments a reviewer expects to see

The inventory reconciliation closes with an adjustment that brings the perpetual records and the ledger to the counted figure. A reviewer expects to see the adjustment entry, the list of item variances it is built from, the recount evidence, the approval, and an explanation of every line above a set threshold.

Using the example, the adjusting entry is:

| Account (example) | Debit | Credit |
| --- | --- | --- |
| Inventory shrinkage expense | 1,239.00 | |
| Inventory | | 1,239.00 |

The entry is approved by someone who did not count the stock and cannot change the item records. That separation is what gives the adjustment weight.

Some goods leave inventory without being sold or lost. Items taken for internal use or given away as samples are written out of stock, and depending on where you operate, sales or use tax may be due on them. The [sales tax reconciliation of returns, ledger and sales](/blog/sales-tax-reconciliation) covers how those amounts are checked against the returns filed.

A reviewer will also ask:

- Was the count complete, with every location and every count sheet accounted for?
- Were the recount rules applied as written?
- Do the cutoff tests support the quantities?
- Does the valued listing, after the adjustment, agree with the ledger, less any separate reserve?
- Is the obsolescence reserve still reasonable, given items that did not move?

Keep the file together: count sheets, the variance listing, recount notes, cutoff documents, the entry and its approval. The next count will start from it.