Construction ERP

An ERP for a firm running many construction projects at once. It connects site attendance, daily and monthly wages, materials, drawings and documents, and client billing, with a separate portal view for each type of participant.

Each project kept its own spreadsheets for attendance, wages and bills. Leadership had no consolidated view of project financials or workforce cost, and preparing a client bill meant collecting figures from several people.

We identified the seven kinds of people involved in a project — administrators, site engineers, supervisors, contractors, consultants, workers and clients — and designed what each needs to see and do. Attendance and payroll were built first, because every other figure depends on them.

• Next.js (App Router) front end with role-based portals
• Python FastAPI back end
• PostgreSQL for projects, attendance, payroll and billing
• MinIO object storage with presigned URLs for drawings and documents
• Redis for caching; Docker for deployment
• Google Sheets API for automated client ledgers

Site teams record attendance daily. The payroll engine calculates daily and monthly wages. Documents and drawings are stored per project with controlled access, and client ledgers are generated automatically for billing.

• Role-based portals for seven participant types
• Daily attendance and wage calculation
• Project documents and drawing storage
• Automated client ledger generation
• Materials and stock tracking
• Project-level financial overview

• Attendance entry is designed for supervisors on a phone at the site gate.
• Every participant sees only their projects and their own actions.

• Next.js
• FastAPI
• PostgreSQL
• MinIO
• Redis
• Docker
• Google Sheets API

Containerised deployment with object storage for documents and scheduled jobs for payroll and ledger generation.