Payslip Audit Excel Spreadsheet Creation

Open Posted 2 days ago Paid on delivery Ends in 4 days
Open Paid on delivery Ends in 4 days

I'm in need of an Excel expert to create a detailed spreadsheet for auditing my payslips.

The spreadsheet should focus on:

- Comparing hours worked versus money paid under incorrect penalty rates (as per pay award)

- Identifying discrepancies against the amount paid versus the hourly rate with the correct penalty rate applied (As per pay award)

- Tracking standard hours worked and the corresponding rate

- Provide a total for the entire amount underpaid due to the incorrect penalty rates being applied

In terms of functionalities, the spreadsheet should include:

- Automated alerts for any incorrect payments

- Colour coding with key

Ideal skills for this job include advanced proficiency in Excel, experience in payroll auditing, and a strong understanding of penalty rates and standard pay. A keen attention to detail is crucial, as is an ability to create clear, user-friendly spreadsheets.

Excel Data Entry Data Processing Visual Basic Accounting

Project ID: #38950616

About the project

51 proposals Open for bidding Remote project Active 9 hours ago

51 freelancers are bidding on average $140 for this job

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look More

$180 AUD in 3 days
(622 Reviews)
8.6
daniyal3214

As a finance and data analytics professional with years of experience in Excel, Google Sheets, Financial Analysis, and Automation Tools, I firmly believe that I am ideally suited for this project. My proficiency in Exc More

$40 AUD in 1 day
(396 Reviews)
7.7
ShaikhAneesa

Hello, As an Excel expert with experience in payroll auditing, I can create a detailed and user-friendly spreadsheet tailored to your needs. The tool will accurately compare hours worked versus payments received, highl More

$200 AUD in 1 day
(30 Reviews)
6.4
softsolution2000

Hi there I have over 5 years of experience as an Excel expert and have worked extensively in payroll auditing. I am proficient in advanced Excel functions and have a strong understandi More

$163 AUD in 7 days
(11 Reviews)
5.5
professorxwriter

Hello, I understand that you require an Excel expert to create a detailed payslip audit spreadsheet focusing on comparing hours worked versus money paid under incorrect penalty rates, identifying discrepancies, tracki More

$140 AUD in 7 days
(6 Reviews)
4.4
samra53

Hello, Hope you doing good. I have gone through your project details and found interesting to me. I am capable to do your project and ready to start. I can provide you quality assurance with 100 percent accuracy in y More

$30 AUD in 1 day
(18 Reviews)
4.1
ihassan83

Hi there, I can help you create a detailed and user-friendly Excel spreadsheet for auditing your payslips. With advanced Excel proficiency and experience in payroll auditing, I will: Compare hours worked versus pay u More

$30 AUD in 7 days
(8 Reviews)
3.2
mussadiq3

Hi, I have carefully read your project. I'm able to do this. Please open the chat so we start work together . Thanks

$100 AUD in 2 days
(4 Reviews)
3.1
rajat23091969

Hello TemployeeG, With my extensive experience in Excel, data processing, and accounting, I am confident in my ability to create a detailed payslip audit spreadsheet for you. I understand the importance of accuracy wh More

$175 AUD in 3 days
(1 Review)
2.8
CongJP

Hi Happy new year! I’m an Excel and Excel VBA expert with 8 years of experience, boasting a 100% job success rate My specialties include Excel formulas, data conversion, analysis, and crafting user-friendly interfaces More

$140 AUD in 7 days
(6 Reviews)
2.9
abhay686

Hello, I'm Abhay, an Excel expert with significant experience in creating detailed and user-friendly spreadsheets specifically for payroll auditing. My proficiency in Excel includes advanced functionalities such as au More

$140 AUD in 2 days
(4 Reviews)
3.1
goriola

Hi, To create a detailed and user-friendly Excel spreadsheet designed to audit payslips by comparing hours worked and payments received against the correct penalty rates as per the pay award. The spreadsheet will aim t More

$250 AUD in 7 days
(1 Review)
2.8
iqraahmad22

Hello, Hope you doing good. I have gone through your project details and found interesting to me. I am capable to do your project and ready to start. I can provide you quality assurance with 100 percent accuracy in y More

$33 AUD in 1 day
(8 Reviews)
2.5
simplifitax

With my extensive background as a CA and ACA-qualified professional, I've gained a deep understanding of the kind of comprehensive financial scrutiny that your project demands. I have spent the past several years of my More

$140 AUD in 7 days
(2 Reviews)
2.3
farooqwaseem

Hi, As a UK-qualified ACCA accountant with extensive experience in financial analysis and payroll auditing, I can create a robust Excel spreadsheet tailored to auditing your payslips with precision. My expertise in More

$70 AUD in 1 day
(2 Reviews)
2.3
hazemh16

I can create a detailed, user-friendly Excel spreadsheet for auditing your payslips. It will include features such as automated calculations for underpayments (standard vs. penalty rates), alerts for discrepancies, and More

$50 AUD in 1 day
(1 Review)
1.6
FaizanWajid50

As an Excel specialist with over six years of experience, I guarantee that I have the skills required to successfully complete your payslip audit project. With advanced proficiency in data entry and Excel functions, I More

$60 AUD in 2 days
(2 Reviews)
1.2
BParmar95

Australian Payroll Expert - Hi There Because of my 4.5 years of experience in Australian payroll processing, I can understand the Australian award rates which incudes the different penalty rates for overtime, weekend More

$140 AUD in 7 days
(1 Review)
0.6
adilmanzoor555

I am a highly skilled Excel expert with a strong understanding of payroll regulations, including penalty rates and standard pay. I propose to create a comprehensive Excel spreadsheet for auditing your payslips. This sp More

$100 AUD in 3 days
(1 Review)
0.2
rutha50

Hello Dear Client, As a native English speaker with over 4 years of experience as an administrative and customer support agent I am perfect for this job. I have honed skills in Microsoft Office particularly Excel and W More

$140 AUD in 3 days
(0 Reviews)
0.0