# Spreadsheet Compare Tool Pages

Instructions for comparing inventory against a spreadsheet including importing, auditing, and updating inventory in partner system.

# Spreadsheet Compare Tool

## ****The Spreadsheet Compare Tool is coming soon****

<p class="callout info">If no integration is available, use the Spreadsheet Compare Tool to quickly compare RFID scans against a partner inventory to identify discrepancies, print stickers, and generate an inventory correction sheet to upload back into the partner system.</p>

##### ****Export Inventory from Partner****

Download the on hand inventory counts from your partner software. The sheet must contain the following two columns:

- Unique Identifier (SKU or Barcode)
- Quantity of Items

****Save the file****<span style="white-space: pre-wrap;"> to your computer.</span>

##### ****Spreadsheet Compare Tool****

Open the spreadsheet compare tool and login. You will use the same username and password that you use to login to the web portal.

##### ****Setup****

<span style="white-space: pre-wrap;">From the </span>****setup tab****<span style="white-space: pre-wrap;"> select the Vendor and Location you are auditing. If you only have one vendor account in Simple RFID the option will be preselected.</span>

<span style="white-space: pre-wrap;">Choose </span>****Full**** <span style="white-space: pre-wrap;">or </span>****Partial**** to audit (this option will be removed and only the Full Audit option will be available)

<span style="white-space: pre-wrap;">Then click </span>****Continue****

[![image.png](https://kb.simplerfid.com/uploads/images/gallery/2026-02/scaled-1680-/BlWimage.png)](https://kb.simplerfid.com/uploads/images/gallery/2026-02/BlWimage.png)

****Upload****

Click the browse window to locate the saved inventory file from the partner system.

Locate the file and double click it to load

[![image.png](https://kb.simplerfid.com/uploads/images/gallery/2026-02/scaled-1680-/NKWimage.png)](https://kb.simplerfid.com/uploads/images/gallery/2026-02/NKWimage.png)

##### ****Mapping****

Choose the column mappings that correspond the the related fields. The (SKU) and (Qty) should map to SKU and Items.

Then click the "****Run Comparison****" button

[![image.png](https://kb.simplerfid.com/uploads/images/gallery/2026-02/scaled-1680-/BkEimage.png)](https://kb.simplerfid.com/uploads/images/gallery/2026-02/BkEimage.png)

##### ****Results****

The page will then load with the Verified RFID counts vs. the uploaded partner on hand counts

[![image.png](https://kb.simplerfid.com/uploads/images/gallery/2026-02/scaled-1680-/DpDimage.png)](https://kb.simplerfid.com/uploads/images/gallery/2026-02/DpDimage.png)

From the Results tab identify all items which appear as Unmatched.

****Print Labels****

Check each product to identify if all items are tagged. If items require tags to be printed:

- Click the checkbox on the far right
- Click Print to add them to a print job
- Choose the Printer &amp; Label layout
- Confirm the details and click Print

Confirm that the RFID scans match the quantity in the SIMPLERFID column

****Export Correction****

One the RFID counts are confirmed to be accurate, click the items which require an inventory correction in the partner software

<span style="white-space: pre-wrap;">Click the </span>****Sync**** button to generate an updated sheet containing corrected quantities

****Upload Corrections Into Partner Software****

Use this sheet to upload back into your partner software

# Auditing against Spreadsheets

<p class="callout info">Auditing is the process of counting items fresh from 0. Since items may have been removed or new items added, auditing ensures that the RFID count represents what is physically on hand. There are two ways to audit against a spreadsheet.</p>

#### ****Partial Auditing****

<span style="white-space: pre-wrap;">Use the Partial Audit option to adjust </span><u>Simple RFID counts</u><span style="white-space: pre-wrap;"> for a </span>****single item****<span style="white-space: pre-wrap;">, or a </span>****small group of items****<span style="white-space: pre-wrap;">, </span>

##### ****Inventory Tab****

- Open the web portal (portal.simplerfid.com).
- <span style="white-space: pre-wrap;">Click on the Inventory option from the left menu, </span>
- Ensure that you have selected the location you are auditing.

##### ****Verified inventory tab****

- <span style="white-space: pre-wrap;">Confirm that you are viewing the </span>****Verified****<span style="white-space: pre-wrap;"> tab. The Verified inventory tab represents your inventory.</span>
- ****Use the Search window to locate the item(s)****<span style="white-space: pre-wrap;"> for which you wish to generate fresh counts</span>
- Click on the "****Trash can****<span style="white-space: pre-wrap;">" icon located to the far right. </span><u><span style="white-space: pre-wrap;">Clicking the trash can for these items removes them from the </span></u><u>****Verified****</u><u><span style="white-space: pre-wrap;"> list, moving them to the </span></u><u>****Absent**** </u><u>tab.</u>

##### ****Mobile App****

- Open the mobile App, and ensure that you are at the same location.
- <span style="white-space: pre-wrap;">Click on the </span>****Scan****<span style="white-space: pre-wrap;"> icon</span>
- Scan the items which are being audited. They will appear as "****New****" items in the scan status
- ****Upload results****

##### ****Spreadsheet Compare Tool****

Return to the Compare Tool and refresh the "Simple RFID Results" so that the newly audited counts appear.

---

#### ****Complete Audit****

<span style="white-space: pre-wrap;">Reset the </span>****Entire Inventory****<span style="white-space: pre-wrap;"> to establish fresh counts for all items. </span><u>This can be done from the Mobile App or the Web Portal.</u>

##### ****Reset from Mobile App****

- <span style="white-space: pre-wrap;">Click the Scan option. </span>
- Click the Audit button
- <span style="white-space: pre-wrap;">Accept the prompt </span>

OR

##### ****Reset from Web Portal****

- Click the Inventory option in the left menu
- Confirm that you are on the Verified tab
- Click the Audit Inventory button

##### ****Perform Inventory Scan****

- Open the Mobile App
- Click the Scan option
- Click "Start a new scan session"
- Scan all inventory
- Upload results

##### ****Spreadsheet Compare Tool****

Return to the Compare Tool and refresh the "Simple RFID Results" so that the newly audited counts appear.