hi am looking for a payroll calculator template where i can track every days total labor weekly labor and labor percentage individual pay tubs ,staff list ,should be according to Australian pay there is already some template but they are in usa pay system i should be able to pay staff after tax deductions and other deduction such as medicare etc
basically need a simple spreadsheet for doing staff roaster and daily hours input that calculate everyday total hours and staffs total hours of the week and another spreadsheet calculates the pay and tax. .
the tax rates are based on ATO tables which is changed every year so should be something that i can update yearly and Superannuation is calculated @ 9.25 % and then print a payslip from another worksheet by populating the pay tax and super etc annual leave hours and sick leave hours plus there should be a spreadsheet where i put today sale of 3 different departments and get the labor percentage daily week to date . and even i want another spreadsheet in there for 7 day sales figures it is for a restaurant and then there should be 7 sheets for moday till sunday which records the total sale ,food sales liquor sales and calculates the labor percent for floor and kitchen separately for daily labor percent and week to date labor percent .
and need another template for making rosters for like 15 people weekly which has capability to put splits and calculate hours of the staff daily and weekly and total hours of the day and total hours of the week indiavilay and for the department not the shift links like afternoon shift day shift. should be actual time in there . thanks
Sir,
I am well versed in this kind of jobs and can do your project as per requirement.
Refer my online work portfolio at [login to view URL]
Looking for further discussions in this matter.
with thanks and regards
$38 AUD in 2 days
4.6 (44 reviews)
5.6
5.6
13 freelancers are bidding on average $29 AUD for this job
Hi,
Our team is expert in business plan and Power-point Presentation.
As This is a Chartered Accountant Firm , we can understand your need
Contact us for any query or clarification.
Ca. Kapil Verma
Good Day
I already have something like this in place. I work for a known retail store Pick n Pay and I send the report on a monthly basis,but wont be a problem to do it on a daily or weekly basis.
We have 150+ employees and the only way to keep the labour into concept is by this report.
Ill be glad to assist
Anne-Marie