Why Indonesian Manufacturers Are Moving From Excel to Digital Asset Management

Every Indonesian manufacturer I talk to is running the same spreadsheet

It has tabs. Usually four or five: one for cranes and hoists, one for pressure vessels, one for forklifts, one for fire equipment, and sometimes one labeled "Other" where everything else accumulates.

There is a column for the last inspection date. There is a column for the next due date. Sometimes there is a column for the SIO (Surat Izin Operasi) permit expiry, maintained by whoever agreed to maintain it at some point in the past. The formulas are mostly correct. The conditional formatting turning expired rows red was someone's idea of progress.

The problem is not that the spreadsheet is poorly built. The problem is what it cannot do, and what the cost of that inability adds up to over time.

The real cost of Excel for asset tracking

Missed inspections: what they cost when an auditor finds them

A Depnaker audit at an auto parts factory in Cikarang found that 14 of 87 regulated assets had lapsed inspection records. Not because inspections had not been performed. The inspections had happened, but the certificates were in a binder in the EHS office, not in the spreadsheet. The two-week corrective action period and the disruption to operations cost the company more than the inspection fees would have across a decade.

The spreadsheet fails here in a specific way: it tracks what someone remembered to enter, not what actually happened. When the inspector delivers the certificate and the EHS coordinator is managing three other tasks, the cell does not get updated. The record falls behind reality.

Expired certificates nobody noticed

PP 50/2012 (Sistem Manajemen Keselamatan dan Kesehatan Kerja) requires documented safety management, and Permenaker 5/2018 requires workplace safety records. The underlying equipment regulations (requiring periodic inspection and permit renewal) create a continuous administrative cycle. A factory with 400 regulated assets has hundreds of expiry dates to track.

Spreadsheets have no active notification mechanism. The cell turns red when a formula calculates an overdue date, but only if someone opens the file and looks at that tab. In practice, the fire equipment tab gets checked thoroughly before a scheduled audit and irregularly the rest of the year.

Lost equipment: a different kind of expensive

A manufacturing group with operations across three facilities in West Java conducted an internal audit and found a 12% discrepancy between its registered forklift count and the forklifts it could physically locate. Some had been transferred between sites without updating the register. Some were at third-party repair shops. A few had been decommissioned informally, removed from service and scrapped without any record.

This is not unusual. Physical assets in industrial environments move, break, get replaced, and get reassigned. A spreadsheet maintained by one EHS team does not update when a maintenance contractor takes a piece of equipment off-site.

Audit scrambles that take days and should take minutes

An audit request arrives: a client's supplier qualification team wants to see the last three years of inspection records for cranes C-01 through C-04. The EHS coordinator has three working days to respond.

She knows the inspections were performed. The inspector is reputable, the certificates exist. The question is where. The 2023 certificates are in the physical binder from before the office move. The 2024 certificates might be PDFs in the shared drive under a folder that may or may not have been organized consistently. The 2025 certificates are on her desktop because she has not had time to file them.

Three days of work to produce what should be a 10-minute export. This is the pattern, not the exception.

What changes with digital asset management

The transition from spreadsheet to purpose-built digital asset management does not require a large project. For a factory with 1,000–5,000 assets, the core migration can be done in under two weeks with internal staff.

What changes immediately:

Every asset has a digital identity linked to a physical tag. A crane hook, a pressure vessel, a forklift: each gets an NFC tag or QR label. When a field inspector scans the tag, they see the asset's current status: last inspection date, next due date, certificate status, open corrective actions. The information follows the physical object, not a row in a file that may or may not be current.

Inspections happen in the system, not on paper. An inspector scans the tag, completes the digital checklist on their phone, adds photos, and submits. The timestamp and GPS location are recorded automatically. The record is immediately visible to the EHS manager, the compliance coordinator, and anyone else with access. No paper to file, no data to transfer, no lag between the field and the record.

Expiry alerts are active, not passive. Set alerts for 90, 60, and 30 days before an SIO or certificate expires. The responsible person receives a notification. The renewal gets scheduled before the expiry, not after an auditor finds it.

Audit preparation becomes an export, not a search. When the client's supplier team requests inspection records, the EHS coordinator selects the relevant assets, sets the date range, and exports a PDF report. Five minutes. The report includes timestamps, inspector names, photographic evidence, and certificate references. It answers the audit request with data that is clearly current and clearly authentic.

A scenario from Cikarang

Consider a Japanese-owned auto parts factory in Cikarang with 1,200 employees and approximately 3,000 assets across three shop floors and a warehouse. The EHS manager, facing a Toyota supplier audit in six weeks, has to demonstrate that the factory's regulated equipment (12 cranes, 34 forklifts, 8 pressure vessels, 140+ items of lifting accessories) is currently compliant.

With a spreadsheet system: two weeks of audit preparation, manual reconciliation of physical assets against the register, tracking down PDF certificates from multiple inspectors, and a stress-filled submission that may still have gaps.

With a digital system: the compliance report for all regulated equipment is generated in KALIRA in under 10 minutes. The EHS manager can see immediately which assets are compliant (green), which are due soon (orange), and which are overdue (red). If there are overdue items, she has six weeks to address them before the audit, not discover them the week before.

The shift in her role is significant. She stops being a document retrieval system and becomes what her title says she is: an EHS manager focused on managing safety, not managing paperwork.

The cost of switching, and the cost of not switching

KALIRA's Professional plan costs Rp 2.249.000/month for 2,000 assets with unlimited users and sites. The Compliance plan at Rp 5.249.000/month adds the compliance modules (Depnaker K3, SOLAS, and ESPR frameworks) that regulated manufacturers need.

For a factory with 3,000 assets, the total cost including NFC tags (Rp 5.000–150.000 per tag depending on environment) and the first year of KALIRA is in the range of Rp 50.000.000–100.000.000. A single missed inspection finding in a Depnaker audit, or a failed Toyota supplier audit, typically costs more than that, in direct penalties, corrective action costs, and the operational impact of scrutiny.

The more accurate comparison is against the EHS coordinator's time currently spent on spreadsheet maintenance and audit preparation. At a conservative estimate of 3–5 working days per month across a team of two, this is roughly 600–1,000 hours per year. That time does not disappear when you move to digital. It redirects toward work that actually improves safety rather than documents that something was documented.

Replace your spreadsheets with KALIRA. Free to start, no credit card

KALIRA's free plan lets you register up to 25 assets and experience the scan-to-record workflow today. The Professional plan, which supports up to 2,000 assets with inspection tracking, certificate management, and multi-site visibility, costs Rp 2.249.000/month.

Replace your spreadsheets with KALIRA. Free to start, no credit card.