Universal Payroll
- Type
- Self-hosted payroll automation platform
- Status
- Controlled pre-pilot test
Context
Payroll in Azerbaijan's private sector has to follow local requirements. Done by hand, it takes a lot of time, invites calculation errors, is hard to audit, and keeping up with the regulations is difficult.
Approach
I designed and built a self-hosted platform on PostgreSQL and n8n: data intake and validation, automated calculation, anomaly detection with four rules, and Human-in-the-Loop approval through Telegram. Audit reports cover the checks, and a RAG-based assistant answers regulatory questions.
Outcome
In a controlled pre-pilot test, 2,520 field-level comparisons showed a variance of 0.0000 AZN. This is a pre-pilot result, not yet production use.
Capabilities
- Automated payroll calculation
- Data intake and validation
- Anomaly detection using four rules
- Human-in-the-Loop approval
- Telegram approval workflows
- Reporting for audits
- RAG-based assistant for regulatory questions
- Self-hosted administration interface
Built with
- PostgreSQL
- n8n
- Docker
- React
- Vite
- Telegram API
- RAG
- AI Agents