Prepare Simple Payroll in Excel

This project received 82 bids from talented freelancers with an average bid price of $76 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
Project Description

I want someone to help me prepare monthly Payroll for about 60 staff using spreadsheet. No complex calculations. It takes me about 5 hrs to do the whole lot & I dont use any Excel smarts. This can be an ongoing project for years to come. Confidentiality is important. The salary adjustments are for non attendance, commissions and expense reimbursements.

Once this is completed they should also need to log in online to the funds transfer portal and set the payments up.

For estimation purposes assume 8 HRS of work. Ideal for a mature/responsible person working from home.

Sample payrun is attached. Names and amounts have been changed.

I will give you the Previous month file.

Current month attendence sheet
Bonus and commission sheet

You have to insert the new attendence and also commission amounts.
Also adjust the no of days in a month days to workout the rate for absentees.
Once calculated log in to the Banking portal and individually set up for payment.
Reconcile all numbers
Generate Payment Slips (which is already there in the first page) for all and save as a PDF file
Email the lot to me.


Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online