Platform Blueprint · Tier-1 Enterprise ERP for Baixis Khmer

Custom Construction &
Site Management System.

A unified platform connecting procurement, multi-warehouse FIFO inventory, employee insurance, face-scan attendance, granular HR & payroll, versioned QS budgeting, and a dedicated Client Portal. Delivered by I.Q Systems.

36Modules
20 WksDevelopment Timeline
DualKhmer & English UI
Construction Crane
01 — BUSINESS WORKFLOW ALIGNMENT

The Foundation Structure

Everything in the system matches how your company operates in the field. Click on a structural layer to see how data and permissions partition.

🏢

Company Level

Global oversight and registries

🏗️

Project Level

Governance and cost center matching

📍

Site Level

Field execution & transaction inputs

Company Level
Handles global registries (employees, suppliers, warehouses), multi-regional tax frameworks, currency conversion matrices (USD, KHR, THB, CNY), consolidated cash flow (see M1), company-wide payroll runs (see M19), and user roles/permissions (see M33).
System Overview Diagram Figure 1
One Connected Platform (Click any card to jump to its modules)
01 Field Layer
👁️

Attendance

Biometric Face Scan

🛒

Procurement

Purchasing

📦

Stock & Inventory

FIFO Costing

↓ Data flow synchronization ↓
02 Platform Core
👥

HR & Payroll

Contracts & Wage Engine

FOUNDATION
Company → Projects → Sites
🛡️

Insurance

Asset & Staff Policies

↓ Real-time accounting audits ↓
03 Governance Layer
📊

QS Budgets

Subcontractors & Retention

🌐

Client Portal

Shielded Progress Window

📈

Reports & Dashboards

Role-Based Analytics

TELEGRAM ENGINE Telegram Notifications — every step, repeated until action is completed
LIVE PROTOTYPE Section 10 Playground — Test requisitions, geofences, and subcontractor claims live
CORE STRATEGY

Key Capabilities We Deliver

These six custom capabilities directly resolve the issues of separate Excel files, paper-based forms, and status gaps. (Click card to view details)

01 — SYSTEM ARCHITECTURE

Real-Time Process Pipeline

From site purchase request to final accounting ledger, linked via automatic Telegram reminders. Click any process to see its modules.

Executive Role-Based Dashboards
cross-project metrics
Recruitment & HR Setup
Sec. 5
Biometric Face Scan Attendance
Sec. 4
QS Detailed Budget & Milestones
Sec. 6
Secure Client Portal
Sec. 7
QS Retention & Subcontractors
Sec. 6
Stock-First Procurement Requests
Sec. 1
FIFO Multi-Warehouse Costing Engine
Sec. 2
Central & Site Warehouses
transfer logs · consumption
Contract Wage Engines
hourly · 26/30 days basis
Asset Registry & Movement
fleet · tools · assignments
Insurance Expiring Tasks
repeating Telegram loops
Automated Period-End Payroll Processing
Sec. 5
Telegram Notification & Approval Engine
Sec. 9
CLICK A STAGE TO VIEW ITS MODULES ↓
Procurement Flowchart (From Request to Payment) Figure 2
YES
NO
Feedback Loop: Quotation Not OK
1. Create Request
Site Engineer creates MR
Stock Transfer
Warehouse site-to-site dispatch
Goods Delivered
Site arrival & FIFO cost update
2. Manager Review
Site manager signs off request
3. Budget check
QS validates cost center limits
4. Stock check
Check warehouse & site levels
5. Collect quotes
Supplier pricing comparison
6. Approve quote
Manager quote selection
7. PO Issued
System sends PO to supplier
8. Invoice Match
Request vs PO vs Invoice match
9. Director Approve
GM final payment sign-off
10. Release Cash
Accountant releases cash on terms
Enough stock?
Himali
Aharon
Anna
Bettany
02 — DETAILED SYSTEM CAPABILITIES

All 36 modules, mapped to proposal sections

Click any module card to inspect the exact proposal features. Filter below to focus on specific domains.

03 — LIVE PROTOTYPE PLAYGROUND

Live TALL Stack ERP Sandbox

Test-drive the core workflows of the Baixis Khmer ERP, modeled directly from the database and controllers of the Laravel application. Switch users at the top-right to adjust access privileges.

BAIXIS ERP — BI Dashboard
👤
Chanda
Managing Director (Admin/PM privileges)
Permissions: Full Approval, Claims Certification, Purchase Orders, Attendance Logs, Stock adjustments
TOTAL BOQ BUDGET
$131,200.00
៛537,920,000 KHR
💰
ACTUAL COST (DISPATCHED)
$24,200.00
៛99,220,000 KHR
🏗️
WASTAGE LEAKAGE
$1,850.00
៛7,585,000 KHR
⚠️
EXCHANGE RATE (OER)
1 USD = 4,100 KHR
Synced daily with NBC
🔄
Project Budget Consumption 18.4% Consumed

WBS Budget vs Actual

Bar Chart
Budget: $45,000 Actual: $18,400 Budget: $35,000 Actual: $5,800 Budget: $51,200 Actual: $0 $60K $40K $20K $0 Block A-1 Block A-2 Block B-G
Budget
Actual

Weekly Spend Trend

Line Chart
$30K $20K $10K $0 Wk 1 Wk 2 Wk 3 Wk 4
Cumulative Spend ($24,200 total)

Cost Allocation Breakdown

Pie Chart
Materials 45%
Labor 35%
Subcon 20%

WBS Cost Center Variance Ledger

Real-Time Cost Allocations
WBS Cost Center Budgeted Cost Actual Cost Remaining Budget Variance %

Material Requisitions & Dispatch Queue

Zone / WBS Material Item Requested By Qty Req / Alloc Status Actions

Raise Material Requisition

Log Site Consumption & Wastage

Mobile Biometric Check-In Emulator

Validates GPS coordinates against project center point before unlocking biometric clock-in.

Site Center Point: 11.5624, 104.8880
Current Distance: 40.2 meters
Geofence Status: Within Range ✅
READY FOR SCAN

Today's Geofenced Biometric Logs

Time Worker Name Type GPS Coordinates Verification

Detailed Project Bill of Quantities (BOQ)

Database Records
WBS Cost Center Material Item Estimated Qty Unit Rate (USD) Total Budget (USD)

Subcontractor Progress Claims Queue

Subcontractor / Trade Claim Ref / WBS Work Description Claimed Gross Certified Net Status Actions

Subcontractor Retention Ledger

Contract ID Subcontractor Reference Claim Transaction Amount (USD)

Submit Progress Claim

CON-880 (Rithy MEP Co.)

Retention rate: 10%
Retention Cap: $15,000
Ret. Held to Date: $8,000
Estimated Retention Hold: $2,000.00
Est. Net Payable: $18,000.00

Warehouse Inventory Levels

Stock status
Material SKU Item Description Quantity On Hand Alert Threshold Status

Procurement Purchase Orders

PO Code Supplier Material Item Ordered Qty Total Cost Status Action

Physical Stock Ledger (Transaction Logs)

FIFO audit logs
Timestamp Material Item Transaction Type Quantity Change Audit Reference / Notes
ACTIVE INSURED POLICIES
2
Forte & AIA providers
INSURED WORKERS
2
Timecard GPS coverage

Active Worker Insurance Assignments

HR Registry
Worker Name Insurance Policy Policy Code Status Action

Assign Insurance Policy to Worker

🏢

Oknha Meng — Secure Client Portal

Interactive project financial audit reports with margin shielding controls.

Margin Shield Protection:
TOTAL DEVELOPMENT VALUE
$93,760.00
Contractual pricing
CERTIFIED MILESTONES
$28,128.00
30% progress claims billed
PROJECT HEALTH
ON BUDGET ✅
Schedule variance within 2%

Certified Invoice & Payment History

Invoice ID Milestone Billed Invoice Date Billed Amount Payment Status
INV-2026-001 Project Deposit (30% on signature) Jan 10, 2026 $28,128.00 Paid
INV-2026-002 M1: Core Systems Config (20% achievement) Pending $18,752.00 Awaiting Milestone

Procured Material Audit Verification

Audit Material Item Total Quantity Actual Contractor Cost Contractual Client Cost Margin Billed %
Portland Cement (SCG) 300 tons $18,400.00 $27,600.00 33.3%
Deformed Steel Rebar (12mm) 25 tons $6,200.00 $8,900.00 30.3%
Ready-Mix Concrete (300 KSC) 250 m³ $4,500.00 $6,000.00 25.0%
04 — FIELD TO LEDGER COST FLOWS

Real-Time Operational Cycles & Tasks

How physical events on-site feed financial ledgers and automate action items through Telegram. (Click flowcharts to jump to modules)

Insurance — Automatic Task Flow Figure 3
Triggers automatically launch tasks that repeat on Telegram until resolved in the system registry.
+ Trigger A

New employee, vehicle or machinery registered

- Trigger B

Employee resigns / quits or vehicle/asset sold

⏱ Trigger C

Policy expiry approaching (30, 14, 7 days limit)

Telegram Task Router

Notification sent immediately to the responsible officer. Alert repeats on a daily schedule until marked DONE in the ERP registry.

Buy Plan

Register new coverage policy in database

Cancel Policy

Terminate agreement with insurer (stop payments)

Renew Policy

Extend policy and log updated expiry date

Master Insurance Register

All policies, limits, premiums, and expiries consolidated in one view. Avoids paying premiums for left personnel/assets.

Attendance & Payroll — Face Scan to Payslip Flow Figure 4
Operational events flow directly from on-site face scans to the payroll engine and ledger allocations.
Step 1: Face Scan

Check-in / check-out terminals or mobile camera scans.

Step 2: Session Tracking

Multiple shifts and split-site logs (morning vs afternoon).

Step 3: Actual Hours Sum

Real worked hours calculated automatically, excluding breaks.

Step 4: Shift Comparison

Matches attendance scans to contract shift rules to detect late arrivals or OT.

Step 5: Manager Approval

Site manager reviews, edits, and signs off attendance logs daily.

Step 6: Payroll Wage Engine

Pulls approved attendance hours. Applies formulas for hourly staff (hours × rate) or monthly staff (salary ÷ 26/30 days × days worked + allowances − deductions).

Step 7: HR Review

HR audits payroll aggregates, allowances, and cash deductions.

Step 8: Director Sign-off

General Manager final payroll release authorization gate.

Step 9: Payslip Release

Individual payslips automatically generated and released in Khmer/English.

Direct Labor Cost Splitting

Worked hours and associated wages flow directly to the project's WBS cost centers and are automatically compiled inside the QS budget actuals matrix.

05 — PHASED DEPLOYMENT STRATEGY

20-Week Delivery Path

Each phase ends with a demonstration and written acceptance. This ensures you start using completed modules immediately. (Click phase card to filter modules)

What Is Included

  • Full system localization in both Khmer and English (every screen, report, and notification).
  • Dual accessibility via computer (web browser) and mobile phones (app).
  • Mobile app includes camera-based face-scan check-in (requires zero extra hardware).
  • 5x Fixed face-scan terminals for main offices/warehouses, fully installed and configured.
  • Direct integration with Telegram for alerts, approvals, and reminders.
  • Initial data setup support (loading employee lists, stock balances, active budgets).
  • User role training conducted in Khmer for site, purchase, HR, accounting, and QS teams.
  • 3-month warranty after final system go-live to resolve any bugs free of charge.
  • Plain-language user manuals.

Key Project Assumptions

  • Baixis Khmer team will make key staff available for requirement sessions (Phase 0) and tests.
  • Internet connectivity is available at permanent sites; the mobile app supports offline cache scans and syncs when connectivity returns.
  • Ongoing cloud hosting, maintenance, and support after the 3-month warranty can be contracted separately as a monthly package.
✈️ TELEGRAM NOTIFICATION
Requisition MR-201 verified against Borey project budget limit.
11:39 AM