Internal Tool · 2025 — Present · Solo Developer
HR & Finance Management Console
Payroll, time-tracking, and finance automation for a small business
Private repository
ReactJavaScriptTailwind CSSVerceluAttend APIPOS Integration
85%
Less Payroll Prep Time
The Problem
Each pay cycle was a multi-day exercise: pulling raw hours from uAttend, classifying regular vs. overtime, applying PTO and leave, layering on commissions and bonuses, then splitting across different payment methods. Onboarding and review reminders were tracked by memory. Daily POS cash flow lagged the books by days, leaving cash visibility blind.
What I Built
- ▸ Payroll engine that pulls hours directly from uAttend and auto-classifies regular and overtime in one pass.
- ▸ Per-employee PTO and leave balance tracking with automatic accrual.
- ▸ Configurable bonus, commission, and multi-payment-method calculations applied per pay run.
- ▸ Employee onboarding workflow with required-document checks and scheduled performance-review reminders.
- ▸ Custom date-range reporting for managers and accounting.
- ▸ Finance module that syncs daily POS inflow/outflow, maintains a unified ledger, and sends scheduled cash-deposit reminders.
Key Decisions
- ▸ Modular console design (Payroll Console / Accounting Console as separate entry points) so each role only sees what they need.
- ▸ Built calculation rules as data-driven configuration rather than hard-coded logic, so pay structures and bonus rules can be adjusted without code changes.
- ▸ Chose React + serverless on Vercel for fast iteration and no infrastructure overhead — appropriate scale for a small business.
Results
- ✓ Cut bi-weekly payroll preparation from ~6 hours to under 1 hour — an 85% reduction.
- ✓ Eliminated recurring overtime miscalculations and PTO balance drift that previously required manual reconciliation each cycle.
- ✓ Real-time daily cash visibility, closing what was previously a 3–5 day reporting lag.
- ✓ Actively used and extended in 2026 as the company's HR and finance backbone.
Private repository
Source code is private — internal company tool containing proprietary business logic and database connections. Happy to walk through the architecture and key implementation details in an interview or on request.