Closed

Payroll Google Sheet Automation

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.

We are looking for a Javascript developer to help us automate a part of this process. The process is well defined and requires someone who has good working knowledge to help us bring some automation to the process. You must have the following skills and demonstrable experience.

Javascript

Google API (Sheets, Drive, etc)

Google Apps Script

Skills: JavaScript, Google APIs

About the Employer:
( 0 reviews ) Union City, United States

Project ID: #28427777

13 freelancers are bidding on average $477 for this job

kanwalrafique

Hi, I'm an experienced JavaScript developer. I have extensive experience in Google Apps Script programming specifically for Google Sheets. I have done several Google Apps Script projects for various clients here on Fre More

$300 USD in 5 days
(31 Reviews)
5.9
AndrwProjects

Hi. I can help you do it using PHP and Google spreadsheets. Integration with sheets will be done via google Api. I completed few projects this way already. This way also allow introduce some backend(for uploads or sepa More

$400 USD in 8 days
(34 Reviews)
5.3
PetarNik

Hi, This is Petar from Serbia, a top-rated javascript developer. I have extensive experience in Google API and Google Sheet. Reading your post, I feel strongly confident. I am very interested in your project. I can mak More

$500 USD in 3 days
(5 Reviews)
5.2
(19 Reviews)
5.0
rchowe

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

$1000 USD in 7 days
(1 Review)
3.7
gorandeveloper20

Hi, there. Hope you are doing well. I have read your job description very carefully and I see you need to someone's help to automate a part of this project. I have a lot of experiences about the javascript and google a More

$750 USD in 7 days
(2 Reviews)
3.3
AbrarHGalib

Hi there, I am an expert in Google App Script with more than two years of experience. Your process is well defined and as you have clearly identified, not too difficult to automate. Here's the approach I am proposing: More

$325 USD in 5 days
(7 Reviews)
3.4
yashgangani

Hello, I read your requirements.. You want to automate your payroll system. I have work a lot in google app script and google sheet automation. If you want to check then you can see my profile reviews for that. I can d More

$400 USD in 7 days
(6 Reviews)
2.9
aruls1962

I have developed a system for my company, by which each traveling person makes a "punch" in his mobile while starting and ending his journey. the GPS, distance travelled and address of both the punches are automaticall More

$444 USD in 5 days
(2 Reviews)
1.7
tushchak0716

Hi greetings from Tushar!! I am interested in taking up your project related to automating the payroll calculation of your employees on Google Sheets. I have hands on experience of working with google app script, goog More

$330 USD in 4 days
(1 Review)
1.0
metlickijv

Good day. I am a top talent javascript developer with extensive experience. I have complete many similar projects using javascript libraries. As an expert, I can provide high-quality results within the deadline. You ca More

$500 USD in 3 days
(0 Reviews)
0.0
mjavierpedraza

I'm an experienced developer and have created several projects using the google apps script to retrieve data from another google files, youtube or external apps like JIRA or BitBucket and consolidate them into a sheet More

$250 USD in 7 days
(0 Reviews)
0.0
khairulbasar1

This can be done with only few clicks. Google apps script will do your csv import, and then google sheet would do the remaining work as defined in apps script to carry out the rest of automation and calculation, Your I More

$500 USD in 7 days
(0 Reviews)
0.0