Client project
TaxPilot PH BIR-Compliant DAT File Generator
TaxPilot PH converts Excel and CSV files into BIR-compliant SLSP, QAP, SAWT, and MAP .DAT files in seconds. A multi-tenant SaaS built for Philippine accountants, bookkeepers, and SMEs.
Philippine tax filing requires specific .DAT file formats that are painful to produce by hand from spreadsheets. TaxPilot automates it.
The problem
BIR submission formats are exact. A .DAT file is not a flexible export, it is a fixed specification, and a file that is almost right is rejected. Accounting staff were building them by hand from Excel, which is slow, and worse, silently error-prone. There is no room to improvise when the receiving system is a government one.
What I built
Upload to .DAT in one step. Users upload Excel or CSV and the app outputs correctly formatted SLSP, QAP, SAWT and MAP files ready for BIR submission.
Format compliance as the core requirement. The whole value is matching a published government spec exactly, field by field. This is the opposite of a feature you can iterate towards.
Multi-tenancy. Built as SaaS so an accounting firm handles multiple client companies with isolated data rather than separate installs.
Google OAuth sign-in. Removes password management for a professional user base that already lives in Google Workspace.
The stack
Custom PHP MVC architecture with MySQL and a Tailwind interface. Custom MVC rather than Laravel because the application is narrow and well defined, and a smaller readable codebase is easier for the client to have maintained later.
Why it matters as a reference
Most integration work is against APIs that tolerate small mistakes. Compliance output does not. If your project involves matching an external specification exactly, whether that is a government format, an EDI feed or a partner import, this is the closest example.
Related services
Need something similar? Tell me which format or system you need to match exactly.
Highlights
- Excel & CSV upload → BIR-compliant .DAT files (SLSP, QAP, SAWT, MAP, 1604-C/E/F)
- Reverse-parse uploaded .DAT files back into editable Excel
- Quarterly Excel summary reports matching BIR RELIEF output format
- Multi-tenant client management, unlimited clients per account
- Fully customizable UI (theme, colors, fonts, labels) zero hardcoding
- BIR Excel templates with pre-mapped columns zero column mapping
- Preview-then-paywall free users see full preview, pay to export
- OWASP Top 10 compliant, encrypted sensitive data at rest
- Tenant isolation at the database level
- Passes BIR's Alphalist/RELIEF Validation Module on the first try