All sidework
SIDEWORK / Payroll

Payroll management

A clinic payroll tool that turns Excel imports into validated periods and downloadable payslips.

Independent projectDesign & development
Payroll management earnings review with synthetic salary components, deductions, and review checks.
The earnings review interface shown with synthetic payroll data in an isolated component preview.
THE IDEA

From spreadsheet to payslip.

A payroll workspace for handling clinic employee pay, preserving historical salary slips, and making period-based payroll output easier to prepare.

WHAT I BUILT

Make every payroll period traceable.

Built spreadsheet import and validation around a PostgreSQL data model. Finalized payroll periods can be locked, and the export flow produces individual or bundled documents.

  • Excel payroll and account imports with validation and a preview.
  • Doctor, dentist, and staff filters with earnings and deductions review.
  • Finalize and lock payroll periods, preserving historical identity and account snapshots.
  • Export PDF payslips, ZIP bundles, and CSV data.
THE TOOLKIT
Next.jsReactTypeScriptPostgreSQLExcelJSpdf-libJSZip