Timesheet Calculator Australia

Convert seven days of start, finish and unpaid-break records into paid hours. Then apply user-entered weekly ordinary and overtime bands, rates, allowance and super scenario without pretending one generic rule replaces the applicable award or agreement.

How the Australian timesheet calculator counts hours

For each day, finish time minus start time gives elapsed shift minutes. When finish is earlier than start, the calculator treats the shift as crossing midnight and adds 24 hours. The entered unpaid break is then subtracted. A day with both times blank records zero hours, while supplying only one time produces an error so a partial record is not silently ignored.

Daily results are added to the weekly total. This is time arithmetic, not a decision about which hours are ordinary, overtime or a penalty period. The pay section allocates aggregate weekly hours to the user-entered ordinary cap, then the first overtime band and finally the later overtime band. Actual industrial instruments can allocate hours by day, time, roster cycle or circumstance instead.

Keep the underlying start, finish and break evidence

Fair Work says employers must keep time and wages records for seven years and that records must be legible, in English, accessible and not false or misleading. Required hour records vary with employment and payment arrangements, while overtime records can need the number of hours and when overtime started and finished. A calculated weekly total does not replace the source time entries.

Record changes as corrections with an audit trail rather than overwriting history without explanation. Employees should also keep their own hours, particularly when work occurs away from the usual site or outside rostered times. Compare the submitted timesheet, approved timesheet and pay slip so missing shifts or altered breaks are identified early.

Unpaid breaks must reflect the applicable rule and reality

The page subtracts the break minutes entered; it does not decide whether a break was required, taken, paid or interrupted. Awards, agreements, contracts and work health and safety obligations can set different break rules. Work performed during an unpaid break may need to be recorded and paid, and some instruments impose additional payments when a meal break is delayed or missed.

Do not automatically subtract a scheduled break when the employee worked through it. Record actual start and finish of breaks when required. Paid rest breaks stay inside paid time and should not be entered as unpaid. If a shift crosses midnight, preserve the actual dates because one clock pair alone cannot show which calendar day or penalty period applies.

Aggregate overtime allocation is only a scenario

The example allocates the first 38 hours as ordinary, the next two hours at 1.5 times and later hours at two times. That pattern must not be assumed for every Australian employee. Overtime can arise after daily ordinary hours, outside a span, beyond a roster cycle, on recall, after insufficient rest or under a specific averaging arrangement. Casual overtime rates can incorporate loading differently.

Weekend, public-holiday, shift and overtime rates may overlap without being cumulative, depending on the instrument. The calculator does not classify a Saturday row automatically because some Saturday work can be ordinary at a penalty rate while other work is overtime. Use the Fair Work Pay and Conditions Tool, current award, enterprise agreement or contract to determine the correct categories, then adapt the entered bands only when that simplification matches.

Base rate and allowances need the right definition

Enter the hourly rate that the chosen multipliers act on. Some all-purpose allowances form part of the ordinary hourly rate before penalties or overtime are applied, while reimbursement and expense allowances may be separate. The single allowance field here is added after band pay and is not multiplied. If the instrument requires another treatment, calculate the components separately.

Minimum rates change and depend on award coverage, classification, age, apprenticeship, employment type and effective pay period. The page deliberately has no preloaded national rate. Verify the current rate for the exact classification and first full pay period, then retain the source beside the time record.

Super is an editable payroll scenario

The super result multiplies gross pay by the entered OTE share and super rate. This does not decide ordinary time earnings. Overtime is generally excluded from OTE when paid for work outside ordinary hours, while some commissions, allowances or loadings can be included depending on their nature. An 80% OTE share is only an example allocation.

The super guarantee rate is 12% from 1 July 2025 under current ATO information, but employer obligations can involve maximum contribution bases, salary and wages definitions, choice, fund timing and industrial terms. Use payroll records and ATO guidance. Gross plus super is not employee take-home pay and excludes payroll tax, workers compensation and other employer costs.

Pay withholding and deductions are outside the result

Gross pay is not net pay. PAYG withholding depends on declarations, tax tables, pay frequency and other factors. Lawful deductions have separate requirements and should not be inserted by reducing the base rate or hours. The pay slip must show required information, including gross and net amounts and separately identifiable loadings, allowances or penalties where applicable.

Reconcile this gross scenario to payroll, then check withholding, deductions, reimbursements and prior adjustments separately. If a discrepancy appears, preserve both records and investigate the classification, rate, hours, break or rounding rather than editing the timesheet to match the paid total.

Timesheet review checklist

Use records to resolve differences

Start with one pay period and compare every day, then trace ordinary and overtime classifications. Check whether a public holiday, leave, time off instead of overtime, minimum engagement or averaging agreement applies. Small rounding differences should be separated from missing hours or an incorrect legal rate.

Raise concerns promptly and keep written notes. Fair Work provides guidance for fixing workplace problems, while unions, employer associations and legal advisers can assist with interpretation. This page cannot determine an underpayment because it only applies the rates and allocation entered by the user.

Record overnight and split shifts explicitly

Each daily row accepts one continuous start-to-finish period. An overnight entry is useful for elapsed-time arithmetic, but the supporting record should still state both calendar dates. That detail matters when a shift crosses midnight, a public holiday begins, a penalty window changes, or payroll assigns hours to different pay periods. Check the calculated hours against the original clock or roster record before approval.

For a split shift, do not stretch one row across the unpaid gap and describe the entire gap as a meal break unless that matches the actual record. Keep each work period separately in the source timesheet, calculate its paid duration, and enter the combined daily paid hours into the payroll process that applies. The single-row interface cannot test split-shift allowances, minimum engagements or rest-between-shifts rules. Preserve corrections, approver notes and the reason for any manual allocation so another reviewer can reproduce the result.

Frequently asked questions