No fixed-asset register? How to build one from scratch

In many companies the equipment list is incomplete or out of date: desks moved to another office, computers were replaced, a machine went for repair and never came back, old furniture was never written off. Rather than patching such a list, it is often quicker and more reliable to rebuild it from scratch by walking the site. The steps are simple: first you build the physical list, then you match it against the accounting records. Work in the opposite order and you will keep getting lost on every line: "it used to be here, now it is gone".

Decide the register fields in advance

Before the walk-round decide which columns the register has. Otherwise you will have to walk the site a second time just to add one. Usually you need:

• a new asset number (identical to the number on the tag);
• the name and type of equipment, model, serial number (if any);
• location: building, floor, room;
• the responsible employee or department;
• condition: good, needs repair, unusable;
• year of purchase (if known), photo number and a note.

Do not fill in the book value and accounting category columns during the walk. They appear at the stage of matching against the accounting data.

Walking the site room by room

Take the building plan, give every room a code and mark the route in advance. On entering a room, move clockwise: from the door along the wall and, at the end, to the items in the middle. Stick an asset tag on every item, note the serial number and photograph the item together with its tag. The key rule: do not look for equipment by its accounting name. Write down what you see; matching with the books comes later. Otherwise your eye gets tuned to find what is on the list and stops noticing what is not. Do not separate large from small items yet either: a desk, a printer and an office chair all go into the register alike.

Think through the special cases in advance:

• locked rooms and safes are opened together with the key holder;
• equipment that staff take home or carry in a car is listed separately and confirmed later;
• rented or third-party equipment is entered separately with a "leased" mark;
• open yards and outbuildings must be included in the route.

Matching against the accounting data

When the walk is over, put the result next to the accounting list. Every line falls into one of three groups: matched; on the books but not found on site; found on site but not on the books. A fourth group is lines with differing details: another model, location or custodian. The easiest way to match is by serial or asset number; without them you have to rely on a combination of features: name, room and employee. The causes of differences are usually the same: the item was moved, never put on the books when bought, issued without a document, or kept its old number after a replacement.

An illustrative example

Suppose the books show 320 items, and the walk finds 355. The result: 298 matched; 22 are on the books but not found (320 − 298 = 22); 57 were found but are not on the books (355 − 298 = 57). Now each group is handled separately. For the 22 missing items you ask: were they sent to another branch, are they under repair, was the write-off never processed? For the 57 extra items, you and the accountant or lawyer decide which are fixed assets to be put on the balance sheet and which are low-value items. In the other 298 lines the location and custodian details are updated. Such decisions belong not to the counting team but to the company's management.

Keeping the register alive

A register built from scratch will be out of date again within a year if nobody updates it. The rules are simple: every new item arrives with a tag, a move is recorded on a transfer sheet, and retired equipment is written off by a document. The register should have a single owner, and once a year you should run a sample check.

Conclusion

Building a register from scratch means a walk-round, a physical list, a match against the books and a decision on the differences. The Inventory team carries out fixed-asset counts, tags the equipment, applies barcode or QR labels, builds the register and hands over an analysis of the differences with the report.