Inventory reconciliation: matching stock value to the ledger

Inventory reconciliation ensures that the value of stock recorded in your accounting ledger matches the value of the physical stock in your warehouse. Mismatches can signal theft, waste, pricing errors, or data entry mistakes. This process is critical for accurate financial statements and tax compliance.

Before you start

• You have completed at least one stock count (see "Performing a stock count and adjustment")
• All recent purchase receipts and sales transactions are complete
• You have access to the Inventory and General Ledger sections of Usystems
• Your admin has configured the inventory valuation method (FIFO, average cost, or standard cost)

Steps

1. Go to Reports → Inventory Reconciliation Report. Open in Usystems

2. Choose the date or period you want to reconcile (usually month-end or quarter-end).

3. The report shows:

   • System balance: the total value of inventory in your ledger
   • Counted balance: the value of inventory from your most recent physical count
   • Variance: the difference between the two

4. If the variance is zero or negligible (rounding), your reconciliation is complete. Document the date and click Mark as Reconciled.

5. If there is a significant variance:

   • Review the list of items with discrepancies (the report itemizes each one)
   • Check for recent purchases or sales that may not have been recorded yet
   • Verify that count adjustments from step 1 were posted (check the journal)
   • If the variance is due to damage, theft, or waste, create an adjustment memo with your manager

6. Once you've identified the cause, ask your admin to post a correcting journal entry if needed, or plan a recount.

7. When you and your admin agree the ledger is correct, click Confirm Reconciliation to close the period.

Accounting impact

Reconciliation itself doesn't create a journal entry — it is a verification step. However, if you find errors during reconciliation (such as a count adjustment that didn't post), the admin will create a journal entry to credit/debit your inventory account and offset to an expense or variance account. This ensures your balance sheet and profit & loss reflect the true stock on hand.

Tips & common mistakes

• Reconcile at month-end. This gives you a clear cutoff point and helps tax and audit trails.
• Check the valuation method. If your company uses average cost, price changes between transactions can make small variances normal.
• Watch for outstanding shipments. If you sold stock but haven't shipped it yet, it may still be in the warehouse but already removed from inventory records.
• Don't ignore small variances repeatedly. A few units lost each month can hide a bigger problem — investigate the pattern.

---