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, but the only thing rows can be auto-filled from if no timesheet is attached) — keeps auto-filled days inside the actual employment period
  • Bank statement line item(s) to look for (optional)
  • Payslip upload (optional) — an alternate source for a month's overtime hours when no daily timesheet is available; per-month choice of timesheet-derived vs payslip-stated once both exist
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
MC / medical leave A medical certificate covering this date was uploaded and reviewed No medical certificate on file covers this date — unpaid unless one is provided
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 (optional if a payslip covers overtime — 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 certificates (optional — PDF or photo)

A timesheet day marked "MC" is only treated as backed by evidence if a matching medical certificate (MC) is on file here — a distinct document from a medical bill/invoice below, since an MC often has no billed amount printed on it at all. Every certificate is scanned for its granted leave period; a timesheet MC day with no matching leave period on file gets flagged in the review below.

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.

Payslip (optional — PDF or photo)

Use this when overtime hours aren't available day-by-day from a timesheet — a payslip states OT hours already worked out by the employer, at whatever breakdown it happens to show (per day, per week, or per month). Each month's Overtime Breakdown below lets you pick whether to use the timesheet-derived figure or this payslip's stated figure once both are available.