How to Create a Reconciliation Report

In this guide, we will walk you through the process of generating a reconciliation report to help ensure that your inventory records in the system align with the actual stock on hand. This report allows you to easily identify missing or unscanned items based on your system's quantity records.

You may refer to this video for a step-by-step guide on how to Create a Reconciliation Report: 

https://www.youtube.com/watch?v=P8uW5KEOfjY

Why Generate a Reconciliation Report?

A reconciliation report is essential for keeping track of discrepancies between the system's recorded quantities and the actual number of items in your warehouse. This helps you catch potential issues like missing products or items that haven't been scanned properly, allowing for more accurate inventory management.

Step 1: Accessing the Vendors Module

To begin generating a reconciliation report, you will first need to access the Vendors module. Follow these steps:

1. Open the Left Navigation Menu by clicking the three-line icon at the top left of your screen.

2. Click the Vendor menu option.
   
    

3. Select All Vendors to analyze all of your products on hand.
   
    
   
   
   

Step 2: Navigating to the Inventory Check Tab

Once in the Vendors module:

1. Click on the Inventory Check tab.
   
   

2. Press the three-dotted button located to the right of the Inventory Check button.
   
   

3. In the context menu that opens, click the Generate Reconciliation Report option.
   
    

Step 3: Adding Checklists for Inventory

In the dialog that appears, you will need to add the necessary checklists to complete your inventory reconciliation. These checklists help you capture an accurate representation of your stock. You can include:

• A mix of House Accounts or individual vendor inventory checklists.

• Allocated Sales Order items that have been scanned but not yet left your warehouse. Note that the system might have already moved them elsewhere as soon as they were allocated.
  
   
   

Step 4: Generating the Report

After selecting all of the inventory checks that cover your full inventory:

1. Press the Generate Report button.
   
   

2. Depending on the size of your inventory, the report may take a few minutes to generate.

3. Once complete, the system will generate an Excel file for download.
   
    

Step 5: Reviewing the Report

In the Excel file: 

• Each item found in the system will have its own row.

• The System Quantity column shows the number of items according to the system's records.

• The Found Item Quantity column shows the actual quantity found in your warehouse.

Troubleshooting

If you encounter any issues while trying to generate a Reconciliation Report, please reach out to  Flawless POS customer support for technical assistance.