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
More like this
Related projects
Production Order Tracker
Custom Products / E-commerce
Moves custom orders through the workshop. Orders flow from the order list to production lines and then to packing as tick boxes are checked, so the…
View project
Team Resource Planner
IT / Project Management
A weekly capacity planner for a team. Members and tasks are added through forms, hours are planned week by week and the planner shows available FTE,…
View project
Staff Performance Benchmark Report
Healthcare (Residential Treatment)
A weekly benchmark report for two residential treatment programs. It compares individual sessions, group sessions, interventions and meeting attendance for every client and staff member against…
View project