Stock Reconciliation

Stock Reconciliation is the process of aligning your physical inventory count with what's recorded in YousrERP. It adjusts stock quantities and values to match actual physical stock.

When to Perform Reconciliation

• After a physical stock count
• When you discover stock discrepancies
• During periodic (monthly/quarterly/annual) inventory audits
• After suspected theft or damage
• When changing valuation rates

Creating a Stock Reconciliation

1. Go to Stock > Stock Reconciliation and click New.
2. Select the Company and Warehouse (or leave blank for all warehouses).
3. Set the Posting Date.
4. The system shows all items currently in stock with:

- Current Qty (in system)

- Valuation Rate (current cost per unit)

1. Enter the Physical Qty (actual count) for each item.
2. The Difference Qty is calculated:

- Positive difference = stock gain (adds to inventory)

- Negative difference = stock loss (deducts from inventory)

1. Click Save and Submit.

Accounting Impact

• Stock Gain (physical > system): Debit Stock, Credit Stock Adjustment Account
• Stock Loss (physical < system): Credit Stock, Debit Stock Adjustment Account

The Stock Adjustment Account is configured in Company Setup.

Tips for Physical Stock Count

1. Plan ahead: Schedule during low activity periods.
2. Freeze movements: Don't move stock during counting.
3. Print count sheets: Generate count sheets from YousrERP.
4. Count in teams: Two-person teams for accuracy.
5. Count everything: Include all warehouses, zones, and products.
6. Investigate differences: Understand why discrepancies exist before reconciling.
7. Get approval: Have management approve significant adjustments.

Batch and Serial Items

For batch-tracked items, reconcile at the batch level. For serial-tracked items, reconcile individual serial numbers.

Related Topics

• Stock Entry
• Warehouse
• Company Setup