Running the Inventory Reconciliation report

Running the Inventory Reconciliation Report

The Inventory Reconciliation report helps you compare your physical stock count against the quantities recorded in Usystems. Use it after conducting a physical inventory count to identify discrepancies and adjust system records.

Before you start

• You have permission to view inventory reports
• You have completed a physical count of your inventory or selected warehouse sections
• Know which warehouse(s) or product categories you want to reconcile

Steps

1. Go to Reports menu and select Inventory Reconciliation Open in Usystems

2. The report page loads with default filters applied. Review the current filters (warehouse, date range, product type) to ensure they match your reconciliation scope.

3. If you need to narrow or adjust the report, use the Filter options:

   • Select a specific Warehouse to reconcile only that location
   • Choose a Date to reconcile as of a specific date
   • Filter by Product Category if reconciling only certain items

4. Click Run Report or Generate (the system displays the report immediately with your selected filters).

5. The report shows each product's system quantity, physical count (if entered), and variance. Review the variance column—negative numbers mean physical count is less than system records; positive means more.

6. If your organization requires approval before making adjustments, note the discrepancies and forward them to the appropriate manager.

Accounting impact

Inventory adjustments from reconciliation do not post to the general ledger until you create an Inventory Adjustment document. The reconciliation report itself is read-only and does not change account balances.

Tips & common mistakes

• Do the physical count first. The report is only useful if your warehouse team has already counted items and entered the counts into a staging area or form.
• Run the report before and after adjustments. Save or print the initial report, then run it again after adjustments to confirm variances are resolved.
• Check for data entry errors. Large variances often indicate typos in the count form—verify the physical count was entered correctly before assuming inventory loss.
• Use warehouse filters. If you have multiple warehouses, run separate reports per location to avoid mixing different count dates.