How is the inventory and fixed asset inventory drawn up?
Many people think that inventory and fixed assets are to be counted in two sets. In practice, both types of asset can be captured on the same floor table for on-site information but are managed separately through asset class fields, discrepancy rules and a follow-up reconciliation process. The form is to record “what is on the books” and “where is on-site, what is actually on-site”.
Rationale for the consolidation of the inventory: common field, classification check
Inventory is usually by name, specification, batch and volume management, fixed assets are more focused on asset numbering, use department, location and service status. Both require reconciliation of bookkeeping with physical items, so they can share a table of inventory; but they cannot be simplified into one set of fields and judgement criteria.
When designed, it is proposed to divide fields into three groups:Common FieldsRecord asset class, name, location, responsible department, book number, physical quantity and differences;Inventory field(a) Record the specifications, batches, units of measure, storage and mass status;Fixed assets fieldRecord the number of the asset, date of acquisition, user, depreciation status and state of equipment.
How the table is designed: first to determine fields, then to sequence the count
A functional consolidated inventory table can be arranged in the following order: Serial number, asset class, book code, asset name, specification model, unit of measure, number of accounts, number of actual balances, quantity of discrepancies, location of storage, responsible department or user, status of assets, description of differences, person who reviewed, date of count. Enables an exclusive field by category, such as batch and vault slots for inventory, fixed assets to number and use.
The number of discrepancies is calculated as "the number of actual pallets -- the number of book entries". The same quantity is also maintained; items found to be surplus, deficit, location inconsistent or unidentifiable should be accounted for in the statement of differences and marked for pending verification.
Before inventory counts are checked, the list is extracted from the inventory and fixed assets tables and consolidated into a common base table. It is recommended that the inventory be arranged by warehouse, floor or line of responsibility to avoid the inventory personnel being searched for back and forth; the number and status of the disks are confirmed on site and the differences reviewed by the reviewer. When Shanghai-based Selecting Tech designs such an inventory process, it will use the “booklist” and “physical objects on site” as two check lines to avoid only filling in the form, without retrospecting where the difference is.
Why not just one table: differences are treated by asset class
The consolidation is an information-gathering entry, not an accounting treatment. When there are discrepancies in the quantity of inventory, further verifications are usually made for incoming and outgoing records, batches, units of measurement and quality; where there is a discrepancy between the fixed asset account, the asset number, transfer record, user and place of storage should be reconciled. The physical value is cancelled, the loaning or moving is subject to cross-checking with the corresponding formalities and accounting records.
For example, if a physical count finds two more units of an item than the warehouse records show, first check for unposted receipts or unit conversion errors. If an item of equipment is missing from an office, use its asset ID to check whether it has been transferred, sent out for repair, or disposed of. Once discrepancies are verified, resolve them through the company's internal approval process and record the reason for the adjustment and the completion date.
Landing inspection: ensure that records are reviewable and retroactive
Before formal use, check whether asset classes are filled in, whether inventory and fixed asset exclusive fields are clear, whether the number units are uniform or whether the difference can be traced to a specific location and responsible person. Checks are followed by a check of unrecorded items, duplicate records, blank differences statements and incomplete approvals. The form should keep the date of the version and the calibration, and the next count can be linked to this record.
When designing the consolidated inventory, the core is to collect it in a uniform manner, sort it out and treat it separately. First, we have to set the bottom table with a common field, then we need to add fields by stock and fixed asset management, and we need to include review and approval records in the process so that a table can be easily counted on site and support subsequent reconciliations.

Ms. Lei
Mr. Pang