PayStream
Enterprise payroll ETL
| Vendor | Amount | Date |
|---|---|---|
| acme CORP | $1,250.00 | 03/04/25 |
| globex llc | 890.5 usd | 2025-4-3 |
| Initech | USD 2,000 | 4/3/2025 |
Synthetic rows. Real client data is never exposed.
Synthetic data only. Real client data is never exposed.
Built as AI Solutions Lead at BDO, serving multinational FMCG/pharma payroll teams. Source and real client datasets are private. Reach out for a walkthrough.
Request accessPayStream automates enterprise payroll processing. It ingests vendor payroll exports and runs deterministic pandas/openpyxl pipelines to produce bank payment files, GL/finance reports, total and individual variance reports, and accruals, with currency conversion and a centralized naming-conventions module exposed over REST. The React + TypeScript frontend drives a FastAPI + SQLAlchemy backend with JWT/bcrypt auth, RBAC, rate limiting, audit logging, and multi-database support, shipped with Docker Compose. Built under client engagement; everything shown here runs on synthetic rows. Real client data is never exposed.
- React
- TypeScript
- Vite
- FastAPI
- Python
- pandas
- openpyxl
- SQLAlchemy
- JWT
- Docker
Architecture · vendor exports → bank files + finance reports
Ingest vendor exports
Vendor payroll export files enter the FastAPI backend.
Deterministic ETL
pandas / openpyxl pipelines clean, map, and currency-convert against a centralized naming-conventions module.
Generate outputs
Produces bank payment files, GL/finance reports, total + individual variance reports, and accruals.
Secure delivery
Served through a React config UI over JWT/bcrypt auth, RBAC, rate limiting, and audit logging.
- Outputs
- bank files · GL/variance · accruals
- Platform
- multi-currency · multi-DB
- Security
- JWT/bcrypt · RBAC · audit log