Wali Haider Jalali.
Admin Dashboard Live

Sheriff Security — Workforce, Payroll & Billing ERP

Automated workforce ERP for 400+ guards: 1-click bulk attendance, automated payroll, location billing, and 14+ financial reports.

ClientMeer Jamal (Sheriff Security)
Year2025 — Completed
DurationDelivered & Live in Production
RoleLead Full-Stack Developer & Systems Architect
Core Capabilities
400+ Active Guards1-Click Bulk AttendanceAuto Payroll & Deductions14+ Financial Reports
Sheriff Security — Workforce, Payroll & Billing ERP preview screenshot 1
Admin DashboardLive Production
1 / 6
Technology Stack
React.jsNode.jsExpress.jsMongoDBJWT AuthTailwind CSSREST APIsPDF/Excel Export

Overview

A mission-critical enterprise workforce and financial ERP built for Sheriff Security Services. The system replaced vulnerable paper registers and spreadsheets, transitioning 400+ active security guards across 45+ locations into an automated, role-based operations hub that manages attendance, monthly payroll of Rs 3.5M+, client billing of Rs 22M+, and executive reporting.

The Challenge

Before this platform, Sheriff Security ran operations on fragmented paper registers and Excel spreadsheets. Tracking 400+ guards across 45+ client locations was chaotic: attendance took hours of manual entry, advance loans and uniform costs were frequently forgotten, month-end salary calculations took over a week to audit, and location billing lacked transparency.

The Engineered Solution

Architected a custom operations ERP. Operations managers can mark bulk attendance for an entire location in one click across 3 shifts, monthly payroll of Rs 3.5M+ is generated automatically with auto-deductions for advances and uniform gear, location-based client invoices are created with pre-calculated taxes, and live P&L is tracked per site. Equipped with tamper-evident audit history and 14+ one-click exportable PDF/Excel reports.

Verified Outcomes

Production Deliverables & Results

400+

Guards Managed in Production

1-Click

Location Bulk Attendance

Rs 3.5M+

Monthly Payroll Automated

14+

Executive Reports (PDF/Excel)

Delivered with clean modular code, documented APIs, and reliable production deployment.

Deep Dive

Key Features & Modules

1-Click Location Bulk Attendance

Mark attendance for an entire client location with a single click across Morning, Day, and Night shifts instead of repeating 400+ entries guard-by-guard. Supports quick filters, absent/leave toggles, and instant daily roll call.

Automated Salary Calculation Engine

Salaries compute automatically from verified monthly attendance logs — calculating daily wages, shift differentials, and overtime without manual math or month-end payroll delay.

Automated Advance & Uniform Deductions

Staff salary advances, emergency loans, and uniform equipment costs are deducted on their own during monthly salary generation, ensuring zero financial leakages.

Location-Based Client Invoicing

Client bills are generated per site with tax automatically pre-calculated. Management can instantly see who has paid, outstanding dues, advance balances, and track over Rs 22M+ in collections.

Live Location-by-Location P&L

Real-time profitability tracking: balances guard salary expenditures against client contract revenues per location, giving leadership immediate visibility into site margins.

Tamper-Evident Audit History

Every attendance mark, modification, or deletion is permanently logged with admin identity and exact timestamp, preventing unverified or quiet record alterations.

14+ Built-in Executive Reports

Comprehensive reporting suite: Monthly Salary Sheets, Daily Attendance, Shift Attendance, Bank Ledger, Client Ledger, Expenses, Deductions, and Party Balances with 1-click PDF and Excel export.

Guard Database & Deployment Tracking

Complete guard directory tracking CNIC, contact numbers, assigned locations, deployment status, and service history across all regional client contracts.

Ready to Build Something Like This?

Need a platform engineered like this?

Whether you need a custom web application, an automated booking portal, or an AI agent for your business — let's discuss your requirements.