How does the asset inventory report go? Data presentation and concluding statement
RFID Knowledge

How does the asset inventory report go? Data presentation and concluding statement

PublishedShanghai Zejie Smart Technology Co., Ltd.

The report is not a table, it's a decision-making material.

Many people have been given an asset inventory, the first reaction being to pull a name, number, amount, and pay it up. But actually, the person who reads this report -- often the finance manager, the operator or the external audit -- is not "how much you count" but "what can I judge after reading it out." So the asset inventory report has two main lines:Data presentationThe government has been responsible for putting the facts clearly.Concluding remarksThe two pieces are missing and the report is not standing. When we did the asset inventory consultation in Shanghai, we found that most of our clients had their problems coming back.

Data presentation: let numbers speak for themselves

The data show the most easily pedaled pits, and all fields are stacked up in one brain. A table is set in dozens of columns, so thick, people's eyes are emptied, and it doesn't seem to be the point. Good data shows three problems:Let the people who look at it see the sum, the structure, the anomaly.. Organize data around these three points, and the tables will naturally be better read.

First, give me an overview of the "one-span"

The report begins with no direct breakdown, with a summary page. The summary pages usually contain: total number of assets, total book value (i.e., the amount recorded on the books), actual value after inventory, cash surplus (actually more than the assets) deficit (actually less than the balance), and several core indicators such as the true conformity rate (the ratio between the book and physical numbers to the top). These figures determine the basis of the report - the compliance rates of 99 per cent and 85 per cent, with the following very different content.

For example, a medium-sized manufacturing plant with a total book value of 80 million, an actual value of 79.5 million, and a loss of 500,000. In absolute terms, 500,000 represents less than 1 per cent of 80 million, but if the losses are concentrated on a single production line, then focus on it; if they are spread over dozens of sectors, there is no difference. The role of the summary page is to expose this "where is the focus" in advance.

The structure needs to be layered, the particle size appropriate.

The breakdown of the data organization is suggested to be spread on three levels: "Big category - Medium class - Specific Assets". The first level is aggregated by asset type (house building, machine equipment, transport tools, electronics, office furniture, etc.), the second level is split by department of use or location of storage, and the third level is the specific asset number. People who look at this can choose a level of their own — that is, the top management looking at the first level, the sector manager looking at the second level, the external audit or specifically looking at the third floor.

The particle size (i.e. the degree of data detail) is also a choice. It's not as fine as it is, but it matches "what people see to make." For example, for the procurement department, the particle size is medium -- they care about which types of assets are to be filled and which types of assets are left idle; for the maintenance department, the particle size is to be placed on specific equipment, with acquisition time, original value, accumulated depreciation (assets are allocated to the cost component of each year according to the rules).

The anomaly data needs to be highlighted separately.

The abnormal items, which are used differently (released undiscounted, long idle, over-life, etc.), are taken out and added to the list of anomalies in a separate form, and highlighted with different colours or labels. No one looks at normal data by article, but unusual data is really people who care about them.

One common empirical value is that the anomaly accounts for less than 5 per cent of the total number of details, but they often consume 80 per cent of the discussion time. So this section needs to be "heavy" in terms of data presentation -- with a reason statement, with suggested treatments, so that discussions can be based directly on this table and no need to go back to re-refer to the details.

Conclusion: judgement from numbers

The conclusions are a "scramble" of the report, and it is not well written by many.

A workable conclusion should have three levels:Factual findings Questions of attribution Question of non-compliance。

First tier: factual judgement

Direct conclusion: What is the true conformity rate, what is the level of the surplus and deficit, whether the asset structure is reasonable? What is avoided here is a vague expression such as "basically consistent" or "slightly different," which gives a specific number. For example, "the overall reconciliation ratio is 98.7 per cent, with losses concentrated in two categories: electronic equipment and office furniture, with a total shortfall of $320,000."

Second tier: attribution of cause

The attribution of abnormalities is clear, that is to say, the reasons behind them.

The reason is not to pursue blame, but to justify the next improvement proposal. So this level should be as objective as possible and avoid subjective assumptions.

Third floor: proposals for action

The recommendations for action are the real value of some of the conclusions. They are specific, implementable and have priority. For example, not to write "enhanced asset management", but to write "recommended to complete tagging of electronic equipment and office furniture assets within two months, with confirmation by the departmental asset manager's signature; to amend access log forms simultaneously, add a user signer." The more concrete the recommendation is, the easier it is to push down.

Priorities can be distinguished by "short (one month)/medium (one to three months)/long (over six months)". Short-term compliance and accounting adjustments that must be processed immediately, such as write-offs of assets in deficit (formally subtracted from booking), medium-term process and system fixes, long-term mechanisms such as a periodic inventory system, linking the results of annual asset counts to the appraisals, etc.

Report skeleton: lower the reading threshold for the structure itself

The data presentation and conclusions are presented in two pieces, which will be combined by a reasonable skeleton. A standard asset inventory report usually includes the following parts:

  1. Cover and Directory:Indicate reporting cycles, inventory scope, date of reporting, and those responsible.
  2. Executive summary:One to two pages, complete the core numbers and core conclusions for those who do not have time to read the full text.
  3. Inventory overview:Inventory range, time, organization, method of inventory (field count/ tag scan/ system matching), participants.
  4. Data summary:Corporate reconciliation rate, sub-categories, sub-sector data.
  5. The list of anomalies and details:Separated as the excess/loss, status anomaly.
  6. Analysis and conclusions of the causes:Attribution summary, corporate evaluation.
  7. Suggested improvements:Priority is given to the responsible sector and time frame for completion.
  8. Appendix:Complete schedule, inventory background, signature form.

This skeleton is not a dead body, but the core principle is "conclusion before detail, first detail after detail." This sequence corresponds to the attention curve of the report, beginning with a clear judgement, then making it clear whether or not to look into the details.

A few easy-to-penetrate pits.

Finally, we have several practical problems that we have encountered repeatedly in the project for your information.

I want the book numbers aligned first.

The book calibres must be confirmed before the count: the book value is original, net or assessed? Depreciation is averaged by year (the depreciation is divided equally over the useful life) or otherwise. Have the end-of-life assets been charged down? These calibres are inconsistent, the results of the count are not comparable and the accurate count counts are meaningless.

Numbers to keep units and decimal places

The sum is equal to or greater than one dollar, and the amount is consistent; it is uniform to a single unit, station, set, etc.; the percentage is sufficient to keep a decimal number, which is not meaningful and may be unprofessional.

Charts are used at a point, not as text

The distribution of asset classes can be made from a pie-tap, the monthly trend of loss can be from a column-size diagram, and the sector comparison can be drawn from a bar-shaped chart. But the chart is only for structure and trends, not for specific values -- or for tables. One report has three to five charts that are appropriate, but more for reading.

If you're writing this year's inventory, you can put down the chart and try to write the three paragraphs of the executive summary by "fact-cause-prompt," and often find out that the people who read it most want to know are already there.