We are a healthcare company. We run payroll for our employees twice a month. Our employees have a set rate for visits they perform seeing patients. When we run payroll we want to pay our employees the visit rate + documentation bonus + mileage reimbursement per visit. This amount per visit per employee comes from another software and can be export as a CSV. For Each employee we sum up the total and add to our payroll sheet.
The amounts from the CSV are summed up manually per employee and added by hand into the payroll sheet. We then update a few other columns per employee on the payroll sheet. The payroll sheet has formulas which help us determine total gross pay and reimbursement. We then take this information and update our payments into our payroll provider.
We use google sheets + google drive to do this process by hand.
Google API (Sheets, Drive, etc)
Google Apps Script
13 freelancers are bidding on average $477 for this job
Hello! I'm a Boston, MA-based IT consultant and I've done a few Google Sheets automation projects for factories. Are there any HIPAA considerations with your sheet? Thanks, Robert