How To Perform A POS / eBound Reconciliation

Step

Prepare the POS File

1

Navigate to the Reports area of the POS (Office>Reporting>Reports)

2

Click “Items with Serial Numbers that Have Not Sold”

3

Note the number of serial numbers.

4

Label the tab POS

5

Highlight the serial number column and convert to “text” (text to columns works best)

6

Click on column D and insert column

7

Label column “In BB?”

8

Add a new tab and label it “eBound”

9

Save file as “Reconciliation”

Step

Prepare the Bound Book File

1

Navigate to the main screen and click “On Hand Firearms”

2

Export to CSV

3

Click go to reports

4

Once the report finishes preparing, click download

5

Copy and paste the entire sheet into the “eBound” tab of the “Reconciliation” file

6

Note the number of serial numbers.

7

Highlight the serial number column and convert to “text” (text to columns works best)

8

Click on column D and insert column

9

Label column “In POS?”

Step

Compare the files

1

In the POS tab, create a vlookup to the ebound file

2

In the eBound tab, create a vlookup to the POS file

3

Note the mismatches.

4

Click save

Step

Results Summary

Result

1

Total number of Unique serial numbers in eBound file

2

The number of serial numbers without a match in POS

3

Total number of Unique serial numbers in POS file

4

The number of serial numbers without a match in eBund

SN

Reason

Status