# Inventory & Stock Reconciliation

*Published:* 2026-02-11
*Author:* LiyakatAli Lal

> Set up warehouses and import opening stock with correct valuation rates. Learn why stock reconciliation is critical for accurate P&L reporting.

# Inventory and Stock Reconciliation

## Warehouse Configuration

In QuickBooks, warehouses might just be a dropdown. In ERPNext, they’re structured entities with parent-child relationships.

Go to Stock → Warehouse. Create your hierarchy:

- All Warehouses
    - New York Store
        - Back Room
        - Sales Floor
    - Los Angeles Warehouse

## The Stock Entry

You cannot just type numbers into Item Master. Stock must enter ERPNext through a Stock Reconciliation.

Go to Stock → Stock Reconciliation → New → Download Template.

The template asks for Item Code, Warehouse, Quantity, and *Valuation Rate*.

*Valuation Rate is critical.* This is cost per unit. If you import this as zero, your P&L will show 100% profit on every sale, which is wrong. Get Average Cost from QuickBooks.

## Upload and Verify

Upload your CSV. This creates initial stock ledger entries.

### Validation

Go to Stock → Stock Balance Report. Does total value match your QuickBooks Inventory Asset account? If not, find the discrepancy before proceeding.

### Categories and Taxonomies

#### Service
[Quickbooks to ERPNext](https://rtcamp.com/blog/service/quickbooks-to-erpnext.md)

#### Solutions
[ERP Migration](https://rtcamp.com/blog/solution/erp-migration.md)

#### Topics
[ERP Migration](https://rtcamp.com/topics/erp-migration.md), [Frappe/ERPNext](https://rtcamp.com/topics/frappe-erpnext.md), [Quickbooks to ERPNext](https://rtcamp.com/topics/quickbooks-to-erpnext.md)

### Related Posts

- [The Audit](https://rtcamp.com/handbook/quickbooks-to-erpnext-migration/pre-migration-audit.md)
- [The QuickBooks to ERPNext Migration Guide](https://rtcamp.com/handbook/quickbooks-to-erpnext-migration.md)
- [Structural Limits of Accounting-First Software](https://rtcamp.com/handbook/why-migrate-quickbooks-to-erpnext/structural-limits.md)
- [QE in a nutshell](https://rtcamp.com/handbook/quality-engineering/introduction.md)
- [Migration Path](https://rtcamp.com/handbook/quickbooks-to-erpnext-migration/migration-path-options.md)
