Ledger Reconciliations

Our asset management specialists provide data reconciliation where the physical inventory data is reconciled against the client’s current asset inventory listing. Data reconciliation is performed using two-tier methodology.

Tier I Reconciliation

Tier I reconciliation is an automated process in which items are matched by a unique identifier. Items are first matched by an existing asset tag number, and then the asset serial number as the second matching criteria.

Tier II Reconciliation

Tier II reconciliation is performed if an additional reconciliation of assets is necessary after the completion of the Tier I reconciliation. A Tier II reconciliation involves a line-by-line comparison of the current asset lists to the physical inventory results in an attempt to identify assets as unique items.

The reconciliation professionals first review the existing asset ledger. From there, the ledger line items are categorized into the following areas:

Infrastructure (land, buildings & improvements)
Assets unable to be tagged (software & component hardware)
Questionable ledger entries (“Equipment for John”)
Non-inventoried assets (items costing less than the capitalization threshold

The reconciliation team provides the ledger analysis reports and reconciliation reports in Excel or comma delimited format for further analysis or to import into the client’s existing asset management system.