← BACKPROJECT · 02
Payroll Export & Mapping Tool
Rust · Tauri · TypeScript
- The problem: payroll staff were manually reformatting export files in Excel before every ERP import cycle. 30,000+ rows, error-prone column mapping, and debit/credit imbalances that caused the import to silently reject batches.
- Built as a Tauri desktop app (Rust backend, React + TypeScript frontend) so it runs natively on Windows without a web server, a Node.js runtime, or any IT infrastructure change. The install is a single executable.
- Ingests raw payroll exports, validates field presence and type constraints, then maps columns to the target ERP schema via a configurable field-mapping layer. Mismatches surface as inline errors before any output file is written; the user fixes the source, not the output.
- Automated debit/credit balancing pass detects and corrects sign errors that would cause the ERP import to reject the batch. This eliminated 100% of the manual reconciliation step that previously blocked every import cycle.
- Configurable SFTP routing pushes finalized files to multiple directories in a single click, replacing a separate manual step that was repeated for each payroll file type.
- Reduced end-to-end payroll prep time by 70–85% per cycle. Under NDA; source not public.
Tech Stack
RUST
TAURI
REACT
TYPESCRIPT
SQL SERVER
