Home / Fixed Assets / Asset Registration
Asset Registration

Asset Registration · One-Item-One-Code Label Printing

Office computers, meeting-room tables and chairs, shop-floor equipment, company vehicles — recording these assets in Excel alone is useless; they need labels, printed codes and a proper ledger. A single entry generates a unique code plus a QR/barcode label, so everything from acquisition to disposal can be traced by scan.

1
Unique Code per Item
📄
Custom Print Templates
📝
Detail Sub-Table Entry
Capabilities

From Entry to Labeling, Done in One Place

All five stages — adding, bulk import, coding, sub-tables and printing — are turned into tools

📝 Asset Entry

Fully record fields such as asset name / category / specification / purchase date / amount / vendor / warranty period, with customizable extended fields

🔢 Auto Coding

Automatically generate a unique code by the "category + year + serial number" rule (e.g. IT-2026-00012), with customizable coding rules

📋 Detail Sub-Tables

For a batch of assets (e.g. 10 computers bought at once), enter 1 master record + 10 sub-table rows; each sub-row gets its own code + serial number

📸 Label Printing

Supports QR / 1D barcode / text mixed labels; continuous printing, gap reprinting and batch printing all in one click

🎛 Template Designer

WYSIWYG drag-and-drop label template design — size, field position, font and logo are all adjustable; templates are independent per category

📥 Excel Import

Historical assets can be bulk-imported via an Excel template, with automatic validation of required fields and duplicate detection; labels can be batch-printed right after import

asset.shangbangke.com/asset/listAsset Ledger
A
Asset Ledger
Print LabelNew Asset
CodeName / CategoryHolderStatus
IT-2026-00012Lenovo ThinkPad X1 · LaptopM. ZhangIn Use
IT-2026-00013Dell Monitor 27" · Office GearW. LiIn Use
JX-2026-00087Haitian Injection Molder · PlantWorkshop 2Repair
CL-2025-00031Buick GL8 Fleet Car · VehicleAdmin DeptIdle
JJ-2024-00205Meeting Table 3.6m · Furniture3F Meeting RmScrapped

One Item, One Code — Scan to Know Its Whole History

Office computers, shop-floor equipment, meeting tables and chairs — every asset wears a unique code label. An employee scans it to instantly see whose asset it is, when it was purchased, who currently uses it, and when it was last maintained. No more "can't find it, not sure whose it is."

  • Scanning the QR code opens the asset detail page directly — no login required
  • Coding rules combine freely by industry / category / custom logic
  • Both 1D barcodes and QR codes are supported — readable by old and new scanners
  • Label materials include coated paper / waterproof PET / RFID composite
asset.shangbangke.com/asset/importBulk Import
I
Excel Bulk Import
TemplateConfirm
100Rows
97Passed
3To Fix
4m 23sElapsed

Import validation progress

Required
Passed 100
Coding
IT-2026-00210~00309
Dedup
3 serial dups
Labels
Generating 60%

Buy 100 Units at Once, Record Them All in 5 Minutes

An office relocation, year-end bulk procurement, or a new plant coming online often involves hundreds of assets entering the books at once. Excel import + master-detail registration completes in 5 minutes what "used to take two person-days."

  • Download the Excel template, fill it in, and import with line-by-line validation errors
  • 1 master record + N sub-rows — no need to re-enter shared fields
  • Batch-assign asset numbers, with free choice of skipping or continuing numbering
  • Batch-generate label PDFs after import for continuous-form printing
Use Cases

Frequent Scenarios for Asset Registration

New Company Setup

A new company buys 200 office assets at once (computers / desks & chairs / printers), bulk-enters them, prints labels and distributes them to workstations

Factory Equipment Booking

Manufacturers register hundreds of machine tools / fixtures / instruments one by one, including serial numbers / maintenance dates / vendor contacts

Government & Public Institutions

Dedicated registration of state-owned assets, with dual "state-management code + unit code" coding, supporting reporting formats for higher-level authorities

Retail Chains

Each store books its equipment assets separately, HQ aggregates queries centrally, and assets can be quickly transferred to other stores when one closes

Related Features

How to Manage Assets After Booking

Registration is just the start — requisition, transfer, stocktaking, maintenance and disposal must all keep running

Book Your Assets Now

Sign up to experience the full asset registration suite for free and leave the Excel-ledger era behind