Travel expenses

Travel Expense Management

In production Standalone application

I built one system for the complete travel expense process: calculations based on current rates, manager approval, tax-document validation, and accounting close.

The process relied on a spreadsheet, email, and manual re-entry into the accounting system. Employees calculated the amount from a rate table, approvals circulated outside a single process, and receipts were entered again during final reconciliation.

One process proposes expense categories, calculates amounts using current rates, routes the request to the employee's manager, validates tax files, and reconciles the final balance against the recorded deposit.

The request, approval, expense documentation, and final reconciliation are kept in one record. Each amount follows current rules, and the final balance determines whether the employee must repay funds or the company must reimburse the employee.

I was responsible for the functional and technical design and the complete system build: rate rules, process states, manager approval, tax-document validation, accounting close, deployment, and documentation.

How it works

A request moves between the employee, the employee's manager, and Accounting. The system applies current rates and keeps the balance updated throughout the process.

Scroll horizontally to view the full diagram.

Travel expense request, approval, documentation, and reconciliation A rejected request can return as a new draft. Expense documentation can return to the employee for correction. The final balance produces one of three outcomes. YES NEW DRAFT CORRECT VALID = 0 > 0 < 0 EMPLOYEE Create request Current rate DIRECT MANAGER Approve? Decision with reason ACCOUNTING Record advance Amount and reference EMPLOYEE Submit expenses CFDI + supporting files ACCOUNTING Valid? Reviews documents SYSTEM Calculate balance Advance − approved spend NO DIFFERENCE Close trip Balance settled EMPLOYEE REPAYS Record repayment Amount due to company COMPANY REIMBURSES Record reimbursement Amount due to employee PRIMARY FLOW RETURN / CORRECTION AUTOMATIC RECONCILIATION
Approval and expense validation have separate return paths. Once expenses are approved, the balance leads to a zero-balance close, an employee repayment, or a company reimbursement.

The system in operation

Four stages of the process, from operational visibility through reconciliation and accounting close.

Key functions

Technical details

Reusable foundation
Reusable Application Foundation with authentication, permissions, audit logging, and deployment already configured
Backend
NestJS 11 · TypeORM · PostgreSQL 15
Frontend
React 19 · Vite · TanStack Query · Zod · Tailwind 4
Infrastructure
Elastic Beanstalk · RDS PostgreSQL · S3 · SES · CloudFront · Route 53
Functional scope
Trips with multiple destinations · catalogs for cities, zones, rate levels, and policies with effective dates
Documentation
Functional process guide and deployment guide delivered with the project