How do we organize a full-scale inventory of fixed assets?
The core of the full-scale inventory is not "point" but "organization" -- a device that goes from book to site, requires four steps to check, mark, enter and check, and one step is needed to widen the difference. The most common thing we have seen is that the roller is: the scene is closed, the account is still intact, the reconciliation is not matched, the count is white. Put the organization in front of the action, and the count is not just going through.
Point 1: draw the border of the inventory first, then do it.
The border is unclear and the majority of the inventory returns.
- Scope: Is it just for the equipment, or is it idle, open for disposal, rented? Does construction in progress count? In a sentence, anything on the books is done, but only if it is defined in writing.
- Time Window: What date is the base date for the inventory count? This date determines the cut-off point for the book balance, which is the basis for all differences.
- Department and duty bearer: Financial, asset management, use department, on-site inventory team, with clear lines of reference to each of the Quartet's respective boundaries.
- caliber: original, net, quantity, location of storage, user - which fields to output at this count are to be set first.
We usually work with clients first to produce an inventory of the four items in a table, and then sign them and start them. The program itself is two pages of paper, but without it, all the actions that follow can be reset.
Point 2: "Close" and "take it all out."
Many teams pull a bill and go to the scene, and they find a bunch of things that are not recorded on the account, and the inventory forms are becoming more messy. The correct sequence is to clean up the account first:
- Export from ERP or asset systemBase date asset desk account, which includes asset number, name, specification, place of deposit, user, original value, net value.
- ProcessReconstruction of construction in progress— Equipment that has been acquired with experience but is not converted to fixed assets is first posted on the books.
- ProcessEnd-of-life undiscounted— Assets that have gone through the approval process but have not been written off in a written-off account are removed from the desk accounts.
- TagsUnaccounted assets— Items found on the scene that are not on the books, and a separate ready-to-see sheet is created so as not to be forced into the main table.
This usually takes three to five working days, depending on how clean the system data is. If the books contain thousands of errors or omissions, use a script or tool for bulk cleanup and then spot-check manually.
Point 3: On-site inventory should be "grouped + standardized"
The scene is the most prone to disruption. Three details determine efficiency:
- Grouping principle: Grouping by physical location (soft floor, second floor, warehouse, office area) is more efficient than by sector because the equipment does not run across the position.
- Standardize the inventory table: Each count sheet should include at least the asset number, name, model and specifications, physical quantity, location, user, condition (in service, idle, pending repair, or pending disposal), and notes. Apply standardized QR tags to equipment and scan to populate the form. This cuts the count time per item from five minutes to under one.
- Photo and forensics.(b) Assets with a surplus or deficit, which are not accounted for in the accounts, are photographed and archived on site, and are labelled with asset numbers and time stamped, and are subject to ex post facto liability.
For manufacturing inventory counts, Shanghai Zejie usually recommends teams of two or three. One group scans equipment into the system, and another verifies the tags on site, with two people cross-checking. A 5,000-asset project can finish the on-site count in five to seven days.
Point 4: The reconciliation is for "causes of difference" and not just "numbers of discrepancies".
Once the inventory is completed, there are three types of differences between book and physical: the surplus (outside the books), the deficit (on the books but not found), and the information difference (both accounted for but not matched by the number, location, user).
The three types of difference are treated differently:
- Disk Ying: If the acquisition is first confirmed by a prior-period omission or by a new purchase not recorded, the re-entry process will be completed before the entry is made.
- LossesIf you have a loss, the user will register and then check the end-of-life approval.
- Information discrepancies(b) Often due to changes in location, personnel changes and delays in the updating of desk accounts, which typically account for over 60 per cent of manufacturing enterprises, by updating master data in the system without the need for a reconciliation.
The field recommendations of the table of variances include: asset number; type of discrepancy; amount of discrepancy; cause; responsible department; disposal method; processor; time of completion. This table is developed to give the management value of the entire sub-count.
Point 5: Dispose, not just report.
The inventory report is the end of most businesses’ stock-taking. But the disposal action that followed is the real point of value:
- Recording of gains• Relocation costs or valuations of the same type of asset are recorded and the desk accounts are adjusted.
- DiscountDisaggregation follows the process of obsolescence, loss and damage, liability and compensation, and write-off is synchronized with tax filing.
- System revisionThe inventory revealed problems — such as the rate of de-labelling, the rate of unupdated location changes — to be pushed back into the asset management system and to identify those responsible.
- Next count optimization: Inventory cycle, inventory approach, clustering rule adjusted to this experience.
In the projects we have done, disposal action is in place and the second count of discrepancies can be reduced by more than 50 per cent on average; only those that report no disposal are reported, and the difference tends to be similar to the first.
Point 6: The computer tool is used on the blade.
The more tools the better, the better.
- Excel: Small and medium-sized enterprises suitable for an annual one-time inventory of less than 500 assets, with low standardised operating costs.
- Barcode and QR code stocktaking• The size of the 1,000-10,000 assets is most appropriate, and the time taken for an inventory of a single device can be reduced from 5 minutes to less than 1 minute.
- RFID: Fits to an asset-intensive and high-value scenario, such as electrical equipment, machine servers, but the cost of a single label is budgeted.
- Asset management system: When the inventory is a regularized (quarterly or monthly) exercise, Excel alone is no longer viable and requires system support for billings, processes, reports.
Shanghai-based technology usually recommends to clients that they run systems and processes, then go on; the system is not a tool for alternative management, but for solidizing them. First, use Excel to run the inventory over two rounds, and then get the problem out of hand, and then introduce it into the system, and landing will do much better than going straight on.
Summary
Full-scale inventory is a typical "one hour savings, one week later." Six things are done in order: drawing the boundary -- scope, time, responsibility, four things with calibre; clearing the books -- construction in progress, end of life, disposal of off-the-book assets first; standardized counts — grouping, two-dimensional code, taking photographs to take evidence; finding reasons — three types of differences are dealt with separately; handling — recording, scrap, system revision; selecting tools — scale matching, not blind on the system.
If you start a full-volume inventory this year, you suggest that we start with the first two points, and then you can move the rest in a rhythm. The asset count is a few times in the firm where "the book and the physical must be" mandatory alignment, once solid, and then management will be much easier.

Ms. Lei
Mr. Pang