Forensic Accountant for Underpayment Spreadsheet

Posted last week

Worldwide

Summary

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
  • Expert
    Experience Level
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
Microsoft Excel
Accounting
Nice-to-have skills
Financial Accounting
Data Entry
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
Member since Jun 30, 2026
  • Australia
    11:00 PM

Explore similar jobs on Upwork

Short Film Budget EstimationFixed-price‐ Posted 2 months ago
Video Production
Budget
Film Budget
Film & Video
Google Ads Account OptimizationHourly‐ Posted 4 weeks ago
Google AdSense
Google Ads
Pay Per Click Advertising
Google Analytics
Google Tag Manager
PPC Campaign Setup & Management

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers 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

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo