Forensic Accountant for Underpayment Spreadsheet
Worldwide
I need an expert Australian forensic accountant to build a 100% accurate underpayment spreadsheet for a federal court claim. Case Details: Period: 07/11/2022 to 19/12/2025 (approx. 8,555 hours total).Worksite: Main 24-hour construction gate for the Gamuda Sydney Metro infrastructure project.Shifts: Fixed 12-hour night shifts only (6:00 PM to 6:00 AM).Roster: Alternating weeks of 48 hours one week and 48 to 72 hours the next week. Records: I have complete personal timesheets and a detailed hour note log covering the entire 3+ year period. This includes exact dates, days, hours, and unpaid vacation weeks taken. These personal logs must form the primary basis of your calculation. Pay Received: Flat rate for the whole period (mostly cash-in-hand, with a short period of bank transfers at those same flat rates). Rates started at $25/hr, went to $26/hr, and ended at $27/hr. I can provide approximate dates for when these flat rates changed to help with your calculations.Missed Entitlements to Calculate:I received NO superannuation, annual leave, overtime, overnight rates, weekend rates, or public holiday rates. You must calculate the missing difference across four historic financial year brackets including: Compounding 30% permanent night shift loading on ordinary hours.Compounding 150% and 200% daily and weekly overtime triggers.Weekend and public holiday penalty rates.Accrued annual leave entitlements.Missing superannuation guarantee percentages across the historic financial year changes. Dual-Scenario Output Required: Scenario 1: Security Services Industry Award 2020 [MA000016] calculated strictly at Security Officer Level 3 (due to ongoing on-site training duties for new guards), including the mandatory weekly Supervision Allowance. Scenario 2: Building and Construction General On-site Award 2020 [MA000020] due to specialized construction tickets utilized at the infrastructure gate (Traffic Control, Personnel Hoist, Work Safely at Heights, and Tunnel Induction). Please quote a single fixed price for the completed project. All raw data and documentation provided must remain strictly confidential under Upwork's terms.
$350.00
Fixed-price- ExpertExperience Level
- Remote Job
- One-time projectProject Type
Skills and Expertise
Activity on this job
- Proposals:5 to 10
- Last viewed by client:4 days ago
- Interviewing:3
- Invites sent:0
- Unanswered invites:0
About the client
- Australia11:00 PM
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by