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: users upload Excel or CSV, and the app outputs correctly formatted SLSP, QAP, SAWT, and MAP .DAT files ready for BIR submission. Built as a multi-tenant SaaS on a custom PHP MVC architecture with MySQL and a Tailwind UI, with Google OAuth sign-in.
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