🔍
Active Workers
0
Total Hours (Month)
0
0 normal · 0 ot · 0 wknd
Total Wages
RM 0
Total Advance
RM 0
Net Payable
RM 0
Monthly Summary —
| # | Name | Position | Hours | Wages (RM) | Advance (RM) | Others (RM) | Net Payable (RM) | Status |
|---|
📤 Batch Worker Upload
Upload Excel (.xlsx) atau CSV (.csv) untuk add ramai workers sekaligus.
Supported: .xlsx, .csv
📋 Format columns
name — Nama penuh worker ⭐ wajibnric — No IC (000000-00-0000) ⭐ wajibposition — Jawatan (Mech Fitter, Welder etc)rate_client — Rate client (RM/jam)rate_mp — Rate manpower (RM/jam)bank — Nama bankaccount — No akaun bankphone — No telefonproject — Nama project semasaproject_start — Tarikh mula project (YYYY-MM-DD)
Add Worker
📥 Bulk Upload Workers
Add many workers at once via Excel template. System uses NRIC to detect duplicates. New projects auto-created.
Workers List
| # | Name | NRIC | Phone | Position | Rate Client | Rate MP | Bank | Project | Period |
|---|
📤 Batch Advance Upload
Upload Excel (.xlsx) atau CSV (.csv) untuk buat advance request ramai-ramai sekaligus.
Supported: .xlsx, .csv
📋 Format columns yang diperlukan
worker_name — Nama worker (kena match dalam system) amount — Jumlah advance (RM) project — Nama project (optional) date — Tarikh (YYYY-MM-DD, optional — default today) note — Nota (optional)
New Advance Request
Pay advance to manpower per project. Select project → tick workers → set amount.
Advance List —
| Date | Project | Workers | Note | Amount (RM) | Status | Actions |
|---|
📥 Bulk Upload Excel
To save time with many workers, fill the Excel template & upload. System will match by NRIC.
Worker that not available in system will di-skip (kena add dulu at tab Workers).
Upload will merge with data existing (tak overwrite kecuali tarikh sama).
Template format: Per Worker (multi-sheet). Setiap sheet = satu worker, sheet name = NRIC.
Key In Manual
Single session (in1/out1 only): system auto-deducts break based on end time:
• Day Shift (in < 6pm): Lunch 1-2pm | Dinner 7-8pm (end > 8pm) | Midnight 12-1am (end > 1am)
• Night Shift (in ≥ 6pm): Supper 12am-1am only (end > 1am)
Two sessions: use exact hours, no auto break deduction. Leave empty if not working.
• Day Shift (in < 6pm): Lunch 1-2pm | Dinner 7-8pm (end > 8pm) | Midnight 12-1am (end > 1am)
• Night Shift (in ≥ 6pm): Supper 12am-1am only (end > 1am)
Two sessions: use exact hours, no auto break deduction. Leave empty if not working.
Claim Client —
Format: Basic (1.0x) | OT 1.5x (sebelum midnight, weekday & Sabtu) | OT 2.0x (lepas midnight, weekday & Sabtu) | Weekend/PH (2.0x) | Past midnight Ahad/PH (3.0x). Rate: Client Rate.
Payslip Manpower —
Format: Normal (1.0x) | OT (1.5x — weekday & Sabtu) | Ahad/PH (2.0x flat — tiada OT). Rate: Manpower Rate. Advance deducted from total. Only Approved payslips can be downloaded.
➕ Others — Deductions / Additions
For items besides advance (eg. broken/lost tools = deduction, bonus/allowance = addition). Will auto-deduct/add from final payslip.
📄 Final Payslip
🏢 Add New Client
Contact Persons
Clients List
📄 Create Invoice
Select client, add line items, generate PDF. Invoice number auto-generated (can override).
Line Items
Add items. QTY × Price = Total. Empty fields auto-clear.
| Item Description | QTY | Price (RM) | Total (RM) | |
|---|---|---|---|---|
| SUB TOTAL | RM 0.00 | |||
| TAX | % | RM 0.00 | ||
| GRAND TOTAL | RM 0.00 | |||
💰 Payments Received (Advance/Deposit)
Record any advance payments the client has made. Will be deducted from invoice total.
| Date | Amount (RM) | Note |
|---|
💡 Save first, then use 👁️ Preview button in Saved Invoices below to check the PDF. Export PDF requires Approval first.
Saved Invoices
📋 Create Quotation
Same format as Invoice. Quotation number auto-generated.
Line Items
| Item Description | QTY | Price (RM) | Total (RM) | |
|---|---|---|---|---|
| SUB TOTAL | RM 0.00 | |||
| TAX | % | RM 0.00 | ||
| GRAND TOTAL | RM 0.00 | |||
💡 Save first, then use 👁️ Preview button in Saved Quotations below. Export PDF requires Approval first.
Saved Quotations
Submit Claim
Submit reimbursement claims with receipt attachments. Goes through approval workflow.
Claim Items
| Item Description | Amount (RM) | |
|---|---|---|
| TOTAL | RM 0.00 |
Receipt Attachments
Upload receipt photos / scans (PNG/JPG, max 1MB each)
No receipts attached
Submitted Claims
⏳ Pending Approvals
Records waiting for approval before download/send.
👥 User Management
Manage who can access this system. New users start as Pending — approve & assign role.
ℹ️
How it works: Share your system URL with staff. They sign in with Google → status = Pending.
Come here to approve as Admin or Staff. They can then access the system.
🇲🇾 Public Holidays — Malaysian Calendar
Select state to auto-load PH. National holidays always auto-included. PH from Malaysian calendar default Client Rate = 2.0x (can toggle individually).
Malaysian Public Holidays — Pick & Add
📝 Custom / Event Holiday
For event holidays (eg. PM declared holiday, ad-hoc state holiday) not in standard calendar.
📅 Active Holidays (Current Year)
Click rate button to toggle 2.0x ↔ 3.0x (client rate). Manpower rate fixed at 2.0x.
🏢 Company Info (Hans Baginda Services)
Your company details — will appear on Invoice/Quotation PDF footer & payment details section.
✍️ Default Signatory (Timesheet Claim)
For timesheet claim PDF (as attachment) — who is "Prepared by".
🖼️ Company Logo
Upload company logo (PNG/JPG, max ~500KB). Will appear on payslip & client claim PDF header. Recommended size: square or wide rectangle, transparent PNG background.
Data Management
All your data is saved in this browser. Backup regularly for safety.