IT Asset Register and Serial Reconciliation Sheet

The IT Asset Register and Serial Reconciliation Sheet is an Excel workbook that checks a certificate of destruction against your own asset register, serial number by serial number.

It is written for IT, procurement, compliance and audit teams who need to prove that every device that left their control is accounted for.

List your assets on the register sheet with their serial numbers. When the certificate or serial schedule arrives, copy its serials onto the second sheet. The workbook then shows, for every asset, whether it appears on the certificate, and for every certified serial, whether it is in your register. A summary sheet counts the matches and the exceptions and shows a single result: reconciled, or exceptions to resolve. Exceptions are the point. A drive that is in your register and not on the certificate, or on the certificate and not in your register, is a question for your supplier before the job is closed.

Serials are matched exactly, ignoring spaces and capitals, so check for typing errors before you raise a query.

It works with any supplier's paperwork. Our Sample Certificate of Destruction shows what a certificate with a serial schedule should look like, and our on-site hard drive destruction service issues one the same day.