How to do Inventory Reconciliation

Company Letterhead

{{company_name}}

{{company_address}}

Phone: {{phone}}

Email: {{email}}

Website: {{website}}

Document Title

Inventory Reconciliation Procedure

1. Purpose

The purpose of this procedure is to establish a standardized process for reconciling physical inventory counts with inventory records within {{company_name}}. This ensures accuracy of stock data, identifies discrepancies, and facilitates corrective actions to maintain efficient inventory management.

2. Scope

This procedure applies to all inventory held by {{company_name}} at {{location(s)}} and covers all types of inventory, including raw materials, work-in-progress, and finished goods.

3. Responsibilities

**Inventory Manager:** Overall responsibility for the execution and accuracy of inventory reconciliation.

**Warehouse Staff:** Responsible for conducting physical counts and reporting discrepancies.

**Finance Department:** Responsible for reviewing financial implications of discrepancies and approving write-offs/adjustments.

4. Frequency of Reconciliation

Inventory reconciliation shall be conducted {{frequency_of_reconciliation}} (e.g., weekly, monthly, quarterly, annually) or as required in response to significant discrepancies or operational changes.

5. Procedure

**5.1 Preparation:**

a. Freeze all inventory movements (receipts, issues, transfers) during the reconciliation period.

b. Print detailed inventory reports from the inventory management system (IMS) as of {{date_of_report_generation}}.

c. Prepare physical count sheets for each inventory storage location.

**5.2 Physical Count:**

a. Two independent individuals (where possible) will conduct a physical count of all inventory items.

b. Record actual quantities on the count sheets, noting any damaged or obsolete items.

c. Ensure all items are identified by {{item_identifier}} (e.g., SKU, part number).

**5.3 Data Entry:**

a. Enter the physical count data into the designated reconciliation module of the IMS.

**5.4 Reconciliation and Discrepancy Identification:**

a. Compare the physical count data with the IMS records.

b. Identify and document all discrepancies (overages and shortages) for each item.

c. Investigate significant discrepancies (e.g., above {{threshold_percentage}}% or {{threshold_value}} units) to determine the root cause.

**5.5 Resolution of Discrepancies:**

a. For discrepancies identified, attempt to locate missing items or verify erroneous entries.

b. Obtain necessary approvals for inventory adjustments (write-offs or write-ups) from {{approving_authority}}.

c. Process approved adjustments in the IMS on {{date_of_adjustment}}.

**5.6 Documentation:**

a. Maintain all count sheets, discrepancy reports, investigation findings, and adjustment approvals for auditing purposes for a period of {{retention_period}}.

6. Reporting

A summary report of the inventory reconciliation, including total adjustments and reasons for significant discrepancies, shall be submitted to {{management_receiver}} by {{reporting_deadline}}.

7. Corrective Actions

Based on the reconciliation findings, implement corrective actions to address identified root causes of discrepancies and prevent recurrence. This may include improvements in receiving, issuing, storage, or data entry processes.

Signature Block

___________________________

{{authorized_signature_name}}

{{title}}

Date: {{date}}