Tender Ledger Management System
Enterprise ERP for contractor management, ledger accounting, billing, and payment distribution across government tender workflows.
- Role
- Software Architect & Full-Stack Developer
- Timeframe
- 2024 — Present
- Tech Stack
- LaravelPHPMySQLDockerNginxCoolifyGitHub Actions
Overview
A full enterprise resource planning platform built for organizations that manage large volumes of government and private tenders. It brings contractor records, tender assignments, ledger accounting, billing, and payment distribution into a single system of record, replacing a patchwork of spreadsheets and manual bookkeeping.
The Business Problem
The client's tender operations spanned multiple departments — contractor qualification, tender assignment, billing, and payment — each tracked in disconnected spreadsheets. Reconciling a single contractor's ledger against active tenders required manually cross-referencing several files, which was slow, error-prone, and impossible to audit reliably at scale.
The Solution
I designed and built a module-based ERP with contractor records, department-mapped tender (Bluebook) classification, and a double-entry-style ledger engine at its core. Contractor billing and payment distribution are driven directly from tender assignment data, so every payment traces back to a specific tender and contractor without manual cross-referencing. A dedicated automation layer, secured with separate encrypted automation credentials, feeds contractor and tender data into downstream reporting systems via authenticated export APIs.
Architecture
Laravel MVC backend with a service-layer architecture separating contractor, tender, ledger, and billing domains, backed by a normalized MySQL schema and API-key-authenticated export endpoints for external reporting integrations.
- Service-layer separation between contractor management, tender assignment, ledger accounting, and billing modules
- Department-mapped tender classification (Bluebook) for accurate categorization across departments
- Encrypted, separately scoped automation credentials for scheduled data sync jobs
- API-key-authenticated export endpoints for contractor and tender reporting integrations
- Containerized deployment (Docker + Coolify) with GitHub Actions CI/CD
Key Features
Contractor Ledger
Full accounting ledger per contractor, tracking billing, payments, and outstanding balances tied directly to tender records.
Tender Assignment & Tracking
Assigns and tracks tenders per contractor with department-mapped classification for accurate reporting.
Billing & Payment Distribution
Generates and distributes contractor payments derived directly from tender and ledger data, keeping every transaction auditable.
Contractor Document Management
Centralized storage and verification for contractor qualification documents required for tender eligibility.
Automated Reporting Exports
API-key-secured export endpoints that feed contractor and tender data into external reporting and intelligence systems.
Role-Based Access Control
Department- and role-scoped access so staff only see the contractors and tenders relevant to their function.
Challenges & Resolutions
Challenge
Contractor billing needed to stay perfectly consistent with tender assignment data, even as both were edited independently by different departments.
Resolution
Built the billing and ledger modules to derive directly from the tender-assignment source of truth rather than duplicating data, eliminating a whole class of reconciliation bugs.
Challenge
Automated data-sync jobs needed system-level credentials that couldn't be tied to a specific human user's login.
Resolution
Introduced a separate, encrypted automation-credential field decoupled from user authentication, with its own guarded encryption path to prevent it from breaking regular contractor updates in production.
Challenge
External reporting systems needed contractor and tender data without direct database access.
Resolution
Built dedicated, API-key-authenticated export endpoints that expose exactly the enriched contractor/tender data needed — nothing more — keeping the integration surface minimal and auditable.
Results
1 system
Single Source of Truth
Replaced disconnected spreadsheets with one auditable ledger and tender system
100%
Traceable Payments
Every contractor payment traces directly back to a specific tender assignment
API-based
Reporting Integration
Automated, authenticated exports replace manual data hand-offs to reporting systems
Have a similar project in mind?
Let's talk through your requirements and see if this is a fit.
Start a Conversation