All projects
Beauty & Wellness — Iconnails
Automated payroll, zero spreadsheets
A nail salon business was running payroll through tangled Excel sheets every cycle — manual, slow, and error-prone. They needed an automated payroll system that could handle commissions, deductions, and reporting without the spreadsheet headaches.
Web DevelopmentInternal Tools
01
Problem
The problem.
- 01Payroll computed manually across multiple Excel sheets every pay period
- 02Commission and deduction formulas frequently broke or produced inconsistent results
- 03Hours spent reconciling staff hours, tips, and service-based commissions
- 04No audit trail for past payroll runs — corrections meant rebuilding spreadsheets from scratch
02
Solution
The solution.
Built an automated payroll system that computes staff pay, commissions, and deductions from logged services and hours — replacing the Excel workflow with a reliable, auditable dashboard. Extended with budgeting, expense, and customer modules to support the wider business.
03
Result
The result.
- Eliminated manual Excel-based payroll computation
- Automated commissions and deductions tied to logged services
- Auditable history of every payroll run
- Unified payroll, budgeting, expense, and customer management