Tidying the asset register before you count

Two teams can count fixed assets very differently: one finishes in three days, another is still arguing after three weeks. The difference often lies not on the floor but in the register. A register that says "office furniture, one lot" or "equipment, various" gives even a careful counter nothing to match against. A few days spent tidying the register before the count is the highest-return preparation you can do. The aim is not to change the books but to make every line correspond to something you can find on site.

Export first and do not edit the system directly

Export the register from your system (1C, Excel or ERP) and keep it as the "pre-count original". Save a working copy for the tidying. Record every change on the copy, with a column explaining it. Formal corrections to the register are made by finance under company policy, and the counting side only proposes them. Both the before and after versions can then be traced, and nobody has to ask when the register changed.

Five tidying tasks

1. Find duplicates: the same item entered twice, typically around transfers, code changes or late entries. Screen by serial number, and again by name plus location.
2. Add serial numbers: for items with nameplates, add the serial number or model. Where there is none, note the identifying features.
3. Add location and custodian: every line needs a storage location and a user. If unknown, write "to be confirmed" and do not leave it blank.
4. Mark the status: in use, idle, under repair, awaiting scrapping or lent out, so counters need not guess.
5. Standardise names: match "forklift" with "electric forklift" and write both in one form, with a Chinese name column if needed to help head office follow.

Splitting "lot" entries

Entries such as "office furniture, one lot", "tools, various" and "computers, one lot" cause the most trouble. To finance a lot is one amount, while on the floor it is dozens of different things. On the floor you can only count piece by piece, but the register has a single line, so it never matches.

To split one:

• go to the site and count how many pieces the lot really contains and what they are;
• find the original purchase documents to see what was bought, and spread the total cost across the pieces, with the method agreed with finance;
• give each piece its own line and keep the old entry number as the "source";
• for low-value odds and ends, agree with finance which stay managed as a lot and which must be registered individually.

Agreeing the scope with finance

If the scope is unclear, the floor will argue about whether a given item counts. Before the count, confirm with finance in writing:

• what the value threshold for assets is, and whether items below it are managed separately;
• whether leased, deposited and customer-owned equipment is in scope;
• how to treat equipment belonging to other companies or legal entities but kept in this warehouse;
• whether fully depreciated equipment still in use is counted;
• whether equipment already scrapped but not yet disposed of is counted.

Put this on a single page, a scope statement signed by finance, and have everyone follow it.

An invented example

Suppose a plant's exported register has 420 lines. Tidying shows 18 duplicate lines, 65 lines with no storage location, and 22 "lot" lines that on site add up to about 140 pieces.

Removing the 18 duplicates leaves 402 lines. Splitting the 22 lot entries into about 140 lines gives roughly 402 − 22 + 140 = 520 lines. (The figures are invented.) The line count looks larger, but every line can now be found on site, so counting and matching become easier, not harder. If one person does the tidying in 3 days, that is far less effort than arguing on the floor.

When the tidying is done, freeze the register before the count starts. Save a dated version, record any additions or transfers during the count separately and merge them after the count. The basis of the count is then always one version.

In short

The clearer the register, the simpler the floor work. In its fixed asset counts, UzWarehouse registers each item, tags it with a barcode and photographs it, then matches the result to your asset register to help you find missing, idle and unrecorded assets.