Client-Level Audit Tool
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, and signatures. Daily, monthly and weekly-meeting audits are produced from the same data.
- Industry
- Healthcare (Behavioral Health)
- Deliverable
- Audit Tool.xlsb
- Built with
- Excel VBA, Selenium, Python
More like this
Related projects
Counselor Service Hours Report
Healthcare (Behavioral Health)
A counselor selector report that shows, for any week, how many minutes of individual, group, treatment coordination and peer support each assigned client received, with alerts…
View project
Payroll & Billing Hours Automation
Healthcare (Home & Community Services)
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…
View project
Account Reporting Tracker
Food & Beverage Brokerage
A shared tracker for account managers. Each update entered on the form is sent to the internal database, a master log file and a separate file…
View project