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.