Adjusting Inventory Value in the Ledger: What a Bookkeeper Needs to Know

Inventory is one of the few balance sheet figures that software often refuses to let you edit directly. When the counted value and the ledger value disagree, the correction is still your job. Here is how we approach it so the adjustment survives review.

Why the software will not simply let you retype the number

Perpetual inventory systems that run on FIFO, including QuickBooks Online, derive the inventory balance from every purchase and every sale recorded against each item. The balance on the balance sheet is an output, not an input. There is no field you can overwrite.

That is deliberate. If the value could be edited directly, the item-level cost layers underneath would stop agreeing with the general ledger, and future sales would post to a cost of goods sold figure nobody can trace. The constraint protects the ledger from you, in the best sense.

Where the correction actually goes

The fix is a journal entry, and the judgement is in the accounts you choose. Suppose a physical count shows stock worth 4,200 less than the ledger. The usual entry debits an inventory adjustment or shrinkage expense account and credits inventory for 4,200. A write-up reverses the direction.

Two judgement calls deserve care. First, use a dedicated adjustment expense account rather than cost of goods sold, so shrinkage stays visible in reporting instead of hiding inside margin. Second, if the shortfall points to a specific cause, damage or theft or a supplier short-ship, book it to the account your client's policy or your jurisdiction's tax rules expect, because deductibility often depends on it. We do not pick that silently; we flag it.

What the entry does not fix

A journal entry moves the general ledger only. It does not update the item-level quantity or cost layers underneath. If quantities are wrong, an inventory adjustment at the item level is the right tool, and it will create its own balancing entry. Doing both, a JE for value and an item adjustment for quantity, is how double-counting happens.

Decide first which layer is wrong. If the count quantity is right but the value is not, use a JE. If the quantity itself is off, adjust the item and let the software post the value.

Evidence to keep with the close

An inventory valuation adjustment is a classic audit question, so the working paper should stand alone. Attach or reference the count sheets, the valuation basis, and a short note on why the value moved. Date the entry in the period being corrected. An adjustment dated after the close that moves a prior period's balance is a red flag at review, and rightly so.

When to stop and escalate

A small, explained variance is bookkeeping. Repeated large unexplained swings, item costs that disagree with the ledger after a clean adjustment, or inventory balances that went wrong after a migration or a file repair are a different problem. At that point the data underneath is suspect, and no journal entry will cure it. Preserve a backup or copy before anyone touches the file, and hand it to a specialist in QuickBooks data repair rather than adjusting around the damage.

If the repair itself is what you need, our QuickBooks error code repair service covers it, and the ledger work can resume once the file is sound.