📄 Download PDF
📄 Download PDF
IDEN
Civil Construction & Engineering

XERPIUMCONSTRUCTION

ERP Solution for Civil Contractors — Project Management, Budget Control, Work Acceptance, Material Tracking, Progress Billing, Subcontractor, Equipment, Compliance

5Module
179COA Accounts
14Dashboard KPI
73Report Structure

Civil Construction Ecosystem

XERPIUM CONSTRUCTION is an ERP solution for civil contractors & engineering — covering project management with hierarchy, budget vs actual, work acceptance, material tracking from task to stock, automatic procurement, progress billing, and 179 construction-specific COA accounts.

🛠
PROJECT
Hierarchy & Budget
📈
WBS
Work Breakdown Structure
📦
MATERIAL
Task → Stock → PO
✅
WORK ACCEPTANCE
Sign-off Milestone
📈
DASHBOARD
Revenue & Cost KPI

Project Management for Construction

🛠 Project Structure

  • Hierarchy — Parent-child project (WBS-like), sub-project count, parent completion blocking
  • Key — Short unique key [JKT-TOWER], auto-generated from name
  • Version — Version/revision tracking per project
  • Status — Custom status: name, seq, is_closed, fold — configurable
  • Type — Hierarchical project types
  • Sequence — Auto-sequence numbering per project
  • Department — Department per project

💰 Budget & Financial

  • Project Budget — Crossovered budget per project, planned vs practical
  • Budget State — Draft → Confirm → Validate → Done
  • PO Link — Smart button: linked PO count, total, purchase invoices
  • Analytic — Budget per analytic account, cost center tracking
  • Reimbursement — Provisions & reimbursement cost tracking

📦 Material & Procurement

  • Task Material — Record material consumed per task (product_id, qty)
  • Task Stock — Full stock moves from task: source/dest location, picking, scrap
  • Stock State — Pending → Confirmed → Assigned → Done → Cancelled
  • BOQ Integration — Bill of Quantity from WBS activity → procurement list
  • Product Set — Pre-configured kits for material planning
  • Auto-Procure — Task material → stock request → purchase request automatically
  • Analytic Lines — Cost allocation from material consumption

📅 Scheduling & Roles

  • Forecast — Resource/role forecasting, employee capacity, leave handling
  • Role — Hierarchical roles per project, user-project-role assignment
  • Stakeholder — External stakeholders, partner-based, role tracking
  • Milestone Status — Execution % (hours allocated vs done), dedication %
  • Task Features — Parent blocking, parent due auto, stage mgmt, code sequence, notes

Construction-Specific Features

✅ Work Acceptance

  • WA Model — Draft → Accept → Cancel — formal document sign-off
  • PO Line — Link to purchase order line, qty, price
  • Qty Tracking — qty_accepted vs qty_to_accept per line
  • Validation — Invoice qty must match accepted qty
  • Use Case — Govt milestone sign-off, subcontractor work approval, material receipt
  • Configurable — Require WA before goods receipt & before vendor billing

🛠 Project Budget & Procurement

  • Project Budget — Crossovered budget, analytic, budget state
  • Purchase Link — PO count, total, invoice count — smart button per project
  • BOQ-Based Procurement — Material requisition from WBS, qty control, vendor comparison
  • Forecast — Resource planning per role, employee capacity, sales-linked
  • Role Management — Hierarchical roles, user-project-role assignment

📦 Material Procurement

  • Task Material — Material per task, product_id, qty
  • Task Stock — Stock moves from task, location, picking, scrap
  • Product Set — Pre-configured kits for material planning
  • Auto-PR — Task material → stock request → purchase request
  • Analytic — Cost allocation from material consumption

💳 Tracking & Portal

  • Key — Short unique key per project [JKT-TOWER]
  • Version — Revision tracking per project
  • Stakeholder — External partners, role, contact
  • Portal — Client view project progress
  • Update Portal — Project status updates ke client
  • Milestone — Execution %, dedication % per milestone

Construction Chart of Accounts

179 accounts specific to civil construction — from cash to project costs. Balance Sheet, P&L, Trial Balance per Indonesian GAAP (PSAK).

Civil Construction COA

GroupKey Accounts
11 KasProject cash, operating bank, giro bank
12 ReceivablesProject receivables, milestone receivables, retention
13 InventoryProject materials, cement, steel, sand, stone, ready-mix
16 Fixed AssetsExcavator, dump truck, wheel loader, crane, heavy equipment
41 RevenueConstruction services, project milestones, engineering services
51 HPPMaterial, subcontract, equipment cost, project overhead
64 Project ExpensesSite, fuel, loading/unloading, mob demob costs

Financial Reports

  • Balance Sheet — Current assets, fixed assets (heavy equipment), liabilities, equity
  • Profit & Loss — Construction revenue, COGS, project costs, net profit
  • Trial Balance — 32 account groups, 6-digit codes
  • Tax — 11% VAT, final construction income tax, tax retention
  • Turbo Report — Reports in <1 minute, multi-company consolidation

Dashboard & KPI

14 KPI Widgets

  • Total Contract Revenue — SUM amount_total from SOs
  • Total Contracts — COUNT sale orders
  • Active Projects — COUNT of active projects
  • Outstanding AR — Unpaid receivables
  • Total Material Cost — SUM PO material
  • Open Tasks — COUNT of tasks not yet done
  • Total Clients — COUNT of active customers
  • Open POs — COUNT of POs not yet received
  • Revenue Trend — 12-month area chart
  • Material Cost Trend — 12-month line chart
  • Top Clients — Bar chart + list
  • Top Suppliers — Bar chart + list

Cross-Module Integration

  • Accounting — 179-account construction COA, 11% VAT, Turbo Report
  • Inventory — Project materials, cement/steel/sand stock
  • Purchase — Subcontract PO, material, equipment parts
  • Sales — Construction service contracts, milestone billing
  • Project — Hierarchy, budget, task material, forecast, role
  • HR — Project team, engineer, supervisor
  • Dashboard — 14 KPI, revenue, cost, AR trend

Why XERPIUM CONSTRUCTION?

AspectManual System / ExcelXERPIUM CONSTRUCTION
ProjectExcel, email thread✓ Hierarchy, budget, stakeholder, portal
MaterialMaterial book, hard to trace✓ Task → stock → PO, auto procure
Work AcceptancePaper handover report✓ Digital WA, qty validation, govt sign-off
BudgetExcel, not real-time✓ Crossovered budget, analytic, forecast
ProgressWeekly report, manual✓ Task completion, milestone %, portal client
AccountingSeparate bookkeeping✓ 179-account COA, construction B/S & P&L
Dashboard✗ None✓ 14 KPI, revenue, cost, AR trend