Payslip Audit Excel Spreadsheet Creation

Encerrado Postado há 2 semanas Pago na entrega
Encerrado Pago na entrega

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 Processamento de Dados Processamento de dados Visual Basic Contabilidade

ID do Projeto: #38950616

Sobre o projeto

52 propostas Projeto remoto Ativo em há 2 semanas

52 freelancers estão ofertando em média $143 nesse trabalho

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 Mais

$180 AUD in 3 dias
(622 Comentários)
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 Mais

$40 AUD em 1 dia
(397 Comentários)
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 Mais

$200 AUD em 1 dia
(30 Comentários)
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 Mais

$163 AUD in 7 dias
(11 Comentários)
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 Mais

$140 AUD in 7 dias
(6 Comentários)
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 Mais

$30 AUD em 1 dia
(18 Comentários)
4.1
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 dias
(5 Comentários)
3.4
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 Mais

$30 AUD in 7 dias
(8 Comentários)
3.2
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 Mais

$140 AUD in 7 dias
(4 Comentários)
3.2
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 Mais

$140 AUD in 7 dias
(6 Comentários)
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 Mais

$140 AUD in 2 dias
(4 Comentários)
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 Mais

$175 AUD in 3 dias
(1 Comentário)
2.8
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 Mais

$250 AUD in 7 dias
(1 Comentário)
2.8
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 Mais

$70 AUD em 1 dia
(3 Comentários)
2.8
nehaaggarwal

As an Excel-savvy Chartered Accountant with a strong understanding of payroll, tax and financial regulations, I possess the necessary skills to create a comprehensive and efficient spreadsheet tailored for your payslip Mais

$220 AUD in 7 dias
(7 Comentários)
3.2
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 Mais

$33 AUD em 1 dia
(10 Comentários)
2.7
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 Mais

$50 AUD em 1 dia
(1 Comentário)
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 Mais

$60 AUD in 2 dias
(2 Comentários)
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 Mais

$140 AUD in 7 dias
(2 Comentários)
1.1
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 Mais

$140 AUD in 3 dias
(1 Comentário)
0.2