Payroll & Billing Hours Automation
Automates the bi-weekly payroll check for a home and community services provider. Staff and billing reports are downloaded from the EHR, billed hours are summarised by service code and rate, and the result is reconciled against the payroll sheet.
- Industry
- Healthcare (Home & Community Services)
- Deliverable
- Payroll Tool.xlsm
- Built with
- Excel VBA, Selenium, Data reconciliation
Before
Billed hours were matched against payroll by hand every two weeks.
After
Staff and billing reports are downloaded, summarised by service code and rate, and reconciled against payroll automatically.
More like this
Related projects
Python Audit Dashboard (Desktop App)
Healthcare (Behavioral Health)
A desktop dashboard written in Python with Tkinter and pandas. It reads exported documentation data, normalises note titles, checks group, one-to-one and daily summary notes for…
View project
Client-Level Audit Tool
Healthcare (Behavioral Health)
An audit workbook that pulls documentation data from the EHR and checks every client against state compliance rules: admission paperwork, daily summaries, group and one-to-one notes,…
View project
Bar Crash Price Timer Display
Hospitality
An animated TV display for a bar's happy-hour game. A countdown timer runs, drink prices crash at random and the display shows crash prices next to…
View project