The Stock Balance and the Inventory Asset balance in the Balance Sheet should normally show the same inventory value. If they display different amounts, it usually indicates that there is a discrepancy between your inventory transactions and accounting records.
Possible Causes
This issue may occur for one or more of the following reasons:
- A manual journal entry was posted directly to the Inventory Asset account.
- An inventory transaction was edited, deleted, or recorded incorrectly.
- An incorrect Opening Stock or Stock Adjustment was entered.
- The Inventory Asset account is mapped incorrectly for one or more items or item groups.
- The reports were generated using different reporting dates.
How to Identify the Discrepancy
There are two ways to verify the difference between the Stock Balance and the Balance Sheet.
Option 1: Review the Stock Valuation Report (Recommended)
- Go to Reports > Stock Valuation.
- Select Report Type.
- Choose Stock Value and Balance Sheet Account Variance in Stock.
- Review the report to identify any variance between the stock value and the Inventory Asset balance.
Recommended: This report is the fastest way to determine whether a discrepancy exists.
Option 2: Review the Daily Stock Balance
If a variance is found, review the stock balance by date to identify when the discrepancy first occurred.
- Open the Daily Stock Balance report.
- Compare the stock balance for each day.
- Identify the first date when the Stock Balance differs from the Balance Sheet.
- Review the inventory and accounting transactions recorded on that date to determine the cause.
How to Resolve the Issue
After identifying the cause, correct the related inventory or accounting transactions. Then regenerate both reports using the same reporting date to confirm that the Stock Balance and Balance Sheet show the same amount.
Note: To maintain accurate inventory valuation, avoid posting manual journal entries directly to the Inventory Asset account unless they are required to correct an inventory-related transaction.