---
title: Asset Device Reconciliation Report
description: Run the Asset Device Reconciliation report to compare linked asset and device serials, review missing or mismatched values, and verify the records.
---

[Skip to content](https://help.perspio.io/help/asset-device-reconciliation-report#main-content)

English

Show submenu for translations

![Screenshot\_3-4-2025\_17232\_](https://help.perspio.io/hs-fs/hubfs/Screenshot_3-4-2025_17232_.jpeg?width=200&height=53&name=Screenshot_3-4-2025_17232_.jpeg)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Contact us](mailto:servicedesk@perspio.io)

[Contact us](mailto:servicedesk@perspio.io)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Perspio Help Centre](https://help.perspio.io/help?hsLang=en)
2. [Reports](https://help.perspio.io/help/reports?hsLang=en)
3. [Available Reports](https://help.perspio.io/help/reports?hsLang=en#available-reports)

# Asset Device Reconciliation Report

## Compare linked asset and device records to find missing values or values that don’t agree.

### Overview

The **Asset Device Reconciliation** report lists linked asset and device records where the selected values differ or a value is missing. Each row identifies the asset and device, shows the two values, and explains why the pair was flagged.

Use this report to check records where both fields are expected to hold the same identifier. A machine serial number and a separate tracker’s hardware serial can legitimately differ.

---

### Report Structure

The generated report includes the following columns:

| Column Name | Description |
| --- | --- |
| **Asset Id** | The identifier for the asset in Perspio. |
| **Asset Name** | The asset name as it appears in Perspio. |
| **Device Id** | The identifier for the linked device being compared. Use it to find the right device when an asset has more than one. |
| **Asset Value** | The value in the asset field selected for comparison. With the default selection, this is Serial Number. |
| **Device Value** | The value in the device field selected for comparison. With the default selection, this is Serial. |
| **Mismatch Reason** | Why the row appears, such as Device value missing or Value mismatch. |

The PDF footer shows when the report was generated and the time zone applied.

---

### How to Generate the Report

1. Navigate to **Reports → Asset Device Reconciliation**. In **List** view, click the **Report ID** on that row.
2. In **Snapshot**, use **Search assets** to select one or more assets, or choose *Groups* or *Conditions* to define the scope.
3. Select **Serial Number** under **Asset Master Property**.
4. Select **Serial** under **Device Master Property**.
5. Click **Run**.

Results appear in a tabular preview. Use the download controls beside the result to save it in **PDF**, **PDF/A**, **XLSX** or **CSV** format. If you use **Run in Background** for a larger selection, retrieve the completed file from **Downloads** within the report.

---

### Applicability and Use Cases

#### 1. Asset and Device Record Checks

Check a group of linked assets and devices after onboarding or a replacement. Use the report to identify records that need a closer look.

#### 2. Inventory Reconciliation

Before a stocktake or audit, narrow the report to the group you are reviewing. Use the asset and device identifiers to check exceptions against the correct source records.

#### 3. Missing Data Investigation

Find rows where a comparison value is blank. Start with the reason shown, then check whether the value should be recorded directly or supplied by another system.

---

### Interpreting the Data

- **Device value missing:** The selected value is blank on the linked device record. Use **Device Id** to identify the device and check the source of that field.
- **Value mismatch:** Both sides have a recorded value and the values differ. Confirm the fields are intended to represent the same identifier and check the original records before making a correction.
- **No rows returned:** Check the selected assets, device links and comparison fields. The report lists exceptions for linked pairs, so an empty result does not confirm that every asset has a linked device.

---

### Summary

Use **Asset Device Reconciliation** to identify which linked records need review. Start with **Mismatch Reason**, verify the asset and device, then confirm the expected value before correcting the record.

 

 

- [Introduction](https://help.perspio.io/help/introduction?hsLang=en#main-content)

    - [How to's](https://help.perspio.io/help/introduction?hsLang=en#how-tos)
- [Assets](https://help.perspio.io/help/assets?hsLang=en#main-content)

    - [Asset Inspector](https://help.perspio.io/help/assets?hsLang=en#asset-inspector)
    - [Utilisation Module](https://help.perspio.io/help/assets?hsLang=en#utilisation-module)
    - [Configuration](https://help.perspio.io/help/assets?hsLang=en#configuration)
    - [Events](https://help.perspio.io/help/assets?hsLang=en#events)
    - [Servicing](https://help.perspio.io/help/assets?hsLang=en#servicing)
    - [Asset Configuration](https://help.perspio.io/help/assets?hsLang=en#asset-configuration)
    - [Device Configuration](https://help.perspio.io/help/assets?hsLang=en#device-configuration)
- [Explorer](https://help.perspio.io/help/explorer?hsLang=en)
- [Dashboards](https://help.perspio.io/help/dashboards?hsLang=en#main-content)

    - [Configuration](https://help.perspio.io/help/dashboards?hsLang=en#configuration)
- [Reports](https://help.perspio.io/help/reports?hsLang=en#main-content)

    - [Available Reports](https://help.perspio.io/help/reports?hsLang=en#available-reports)
- [Groups](https://help.perspio.io/help/groups?hsLang=en#main-content)

    - [Security Groups](https://help.perspio.io/help/groups?hsLang=en#security-groups)
    - [Asset Groups](https://help.perspio.io/help/groups?hsLang=en#asset-groups)
- [Geofences](https://help.perspio.io/help/geofences?hsLang=en)
- [Workflows](https://help.perspio.io/help/workflows?hsLang=en)
- [Administration](https://help.perspio.io/help/administration?hsLang=en#main-content)

    - [Settings Module](https://help.perspio.io/help/administration?hsLang=en#settings-module)
    - [Admin Panel](https://help.perspio.io/help/administration?hsLang=en#admin-panel)
- [Devices](https://help.perspio.io/help/devices?hsLang=en#main-content)

    - [Troubleshooting](https://help.perspio.io/help/devices?hsLang=en#troubleshooting)
    - [Installation Guides](https://help.perspio.io/help/devices?hsLang=en#installation-guides)

[![](https://help.perspio.io/hs-fs/hubfs/Perspio%20Logo%20%E2%80%93%20Colour%20White%20%E2%80%93%20large%20%20RGB.png?width=786&height=177&name=Perspio%20Logo%20%E2%80%93%20Colour%20White%20%E2%80%93%20large%20%20RGB.png)](https://perspio.io)

2/50 Yeo St, Neutral Bay NSW 2089

[mailto:servicedesk@perspio.io](mailto:servicedesk@perspio.io) <https://www.facebook.com/InauroAus/> <https://www.inauro.io/>

Copyright © 2026 Inauro