Salary Claim Calculator

Inputs you provide
  • Weekly rest day
  • Work week (5.5/6-day) and half-day, for 5.5-day weeks
  • Standard break
  • Default shift timing — used to fill in days with no timesheet entry
  • Claim period start/end dates (optional) — keeps auto-filled days inside the actual employment period
  • Bank statement line item(s) to look for (optional)
Computed automatically (needs IPA basic salary)
  • Hourly / daily basic rate, daily gross rate
  • Basic Salary / Overtime / Rest / Public Holiday Breakdown — each pay category shown separately, per month
  • Owed vs Paid delta (also needs a bank statement scan)
Guardrails — flagged live on each row
Check Passes (no flag) Flags
Break Break matches what you set above Break is different from what you set — check the row
12-hour/day cap Worked 12 hours or less that day Worked more than 12 hours in one day
Monthly overtime cap Under 72 overtime hours that month Over 72 overtime hours in one month
Rest day worked Worker didn't work on their rest day Worker worked on their rest day — extra pay applies
Public holiday worked Worker didn't work on a public holiday Worker worked on a public holiday — extra pay applies
Missing work day Every expected work day is accounted for A work day had no entry — app filled it in for you
Bank statement transaction All 3 independent scan passes caught this transaction Fewer than 3 passes caught it — flagged, worth double-checking against the source page
Flags only — nothing here is auto-corrected or written to the spreadsheet; every row still needs your review.

Worker's schedule

Worker's weekly rest day

Work week

Standard break

Used to double-check each row's break against what was actually extracted — a mismatch is flagged for review, not auto-corrected.

Claim period (optional)

Start
End
Stops the app from inventing work days before the worker started or after they left — e.g. if they started on a Wednesday, Monday/Tuesday that same week won't be auto-filled even if the rest of the month otherwise falls short.

Claim salary-in-lieu of termination notice (optional)

Claim salary-in-lieu of paid annual leave (optional)

Claim sick leave pay (optional)

Documents

⚠ Make sure every page — IPA letter and timesheets alike — is upright before uploading. A sideways page (common in scanned/photographed PDFs) can cause the scan to silently misread dates and times.

IPA letter (PDF or photo)

Employer/salary/OT-rate terms are read off it alongside the timesheets, in the same submit.

Timesheet files (PDF or photo)

Bank statement (optional — PDF or photo)

A worker sometimes says they were paid "some" but not all of what's owed — this is a separate check against their own bank statement, not tied to the claim scan above and not written to the spreadsheet. Every incoming (credit) transaction on the statement is extracted — nothing is filtered by keyword — so delete whatever's irrelevant in the review below before comparing against the claim total.

Medical bills (optional — PDF or photo)

An employer of a Work Permit holder is generally required to bear the worker's medical costs — this checks whether that actually happened. Every medical bill/invoice is scanned for its billed date and amount. Review the extracted amounts below, mark whether each one was reimbursed by the employer, and the app totals the unreimbursed amount for you.