Prepare Simple Payroll in Excel

  • Status Closed
  • Budget $30 - $250 USD
  • Total Bids 82

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.



Get free quotes for a project like this
Skills Required

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