KRY-02 · Case Study Production

SIMBADA.

A fixed-asset management system for the City Government of Pontianak — a single source of truth for all regional fixed assets, from planning through write-off, with reporting built to withstand government (BPK) audit.

Client: City Government of Pontianak
Role: Sole developer (V2)
Period: Jan 2026 – present
Core stack: PHP 7 · MySQLi · Bootstrap 3

Overview · City Government

One system, the whole asset lifecycle.

I developed and maintained V2 end-to-end on a custom PHP framework (Qapuas 5.0): six KIB asset classes (A–F), room inventory cards, mutation & depreciation, and an audited-vs-running reconciliation report built for government (BPK) audit — all under role-based access.

6KIB classes (A–F)

29Modules

5Access levels

1220PHP files

PHP 7MySQL / MariaDBMySQLiBootstrap 3jQueryDataTablesQapuas 5.0 frameworkRBAC

Discuss a similar project For institutions — email

Production link withheld at the client's request (internal government system).

SIMBADA asset lifecycle diagram: planning, procurement, KIB/KIR registry, mutation, write-off, then reporting and audit — Asset lifecycle — planning to audit

Asset classification KIB A to F: land, equipment and machinery, buildings and structures, roads and networks, other fixed assets, construction in progress — Asset classes — KIB A–F

Details — Dossier What was built & its impact

What I did

Six asset-card classes (KIB A–F) plus Room Inventory Cards (KIR) for per-room asset tracking.
Full asset-lifecycle modules: planning, procurement, registration, mutation, depreciation, and write-off — with Year / SKPD / SK-status filters.
An “Audited vs Running” reconciliation report that compares audited figures against live data — central to BPK audit readiness.
KIB data validation (B, C, E, F) with hardened error handling & logging — preventing silent failures on empty dates/numbers.
A 3-level module routing system, MySQL/MariaDB compatibility, and query hardening (escaping/int-casting) across modules.
Role-based access control (RBAC, 5 levels: 40–90) with an audit trail for every asset change.

Outcome & impact

Centralized asset control for all work units (SKPD/OPD) in one system of record.
Audit readiness (BPK): validated and reconciled data so fixed-asset reporting holds up.
On-demand reporting (inventory books, KIR, mutation, write-off proposals) replacing slow manual bookkeeping.

Have a similar asset, finance, or licensing system?

I help institutions design, build, and clean up internal systems — from scratch or taking over an existing one — with scope & cost clear up front.

Discuss a similar project ← See other work