For international students holding a Subclass 500 Student Visa in Australia, maintaining strict compliance with Visa Condition 8105 is vital. Under current Department of Home Affairs rules, you are legally restricted to working a maximum of 48 hours per fortnight while your course is in session.

The dangerous trap of this rule is the word fortnight. The ATO and the Department of Home Affairs define a fortnight as a strict, rolling 14-day period starting on a Monday. They do not look at your employer’s custom pay cycles, and they do not just look at isolated calendar weeks. If any rolling 14-day combination of weeks crosses the 48-hour threshold, you are automatically flagged for a visa breach.

To protect your permanent residency or graduate visa pathway, you need to build an airtight tracking system.

1. Understanding the “Rolling Fortnight” Math Trap

Before setting up your digital tracking sheet, you must understand how immigration compliance officers run their calculations. They use a rolling overlap model.

Imagine this real-world working month scenario:

• Week 1: 15 hours worked
• Week 2: 30 hours worked
• Week 3: 10 hours worked
• Week 4: 35 hours worked

The Math Analysis:

• Fortnight A (Weeks 1 + 2): 15 + 30 = 45 hours. (Completely Legal ✅)
• Fortnight B (Weeks 3 + 4): 10 + 35 = 45 hours. (Completely Legal ✅)
• The Overlap Trap (Weeks 2 + 3): 30 + 10 = 40 hours. (Completely Legal ✅)

But look what happens if you work a schedule where a heavy week sits next to another moderately active week, such as a rolling block of Week 2 (30 hours) and a sudden shift pick-up in Week 3 of 20 hours. 30 + 20 = 50 hours, resulting in an immediate visa breach. You must ensure that every possible back-to-back week combo adds up to 48 or less.

2. Step-by-Step: Building an Excel/Google Sheets Tracker

Building an automated cloud spreadsheet is the best way to monitor your hours across multiple part-time or casual jobs. Follow this setup guide:

Step 1: Create Your Structural Columns

Open a new sheet and create the following header rows across columns A to E:

• Column A: Start Date (Must always be a Monday)
• Column B: Week Number (e.g., Week 1, Week 2, Week 3)
• Column C: Total Hours Worked This Week (Manually input from your timesheets)
• Column D: Rolling Fortnight Total (Calculated automatically via formula)
• Column E: Visa Compliance Status (Automated warning flag)

Step 2: Apply the Automation Formulas

Leave row 1 for headers. In row 2, input your first week of hours in cell C2.

In row 3, input your second week of hours in cell C3.

Now, setup the automated calculation cell in D3 to add the first rolling block:

Plaintext

=SUM(C2:C3)

Drag this formula down the rest of Column D. It will continuously sum the current week and the immediate week prior.

Next, setup an automated visual warning system in cell E3 to alert you if you hit a danger zone:

Plaintext

=IF(D3>48, “⚠️ VISA BREACH!”, “CONFIRMED COMPLIANT ✅”)

Step 3: Apply Conditional Formatting (Visual Shield)

1. Highlight all cells in Column D.
2. Select Conditional Formatting -> Highlight Cell Rules -> Greater Than.
3. Type 48 and select Light Red Fill. Now, the sheet will instantly flash red the second you accidentally accept an extra casual shift that threatens your visa.

The Rolling Compliance Tracker Model Layout

3. The Set-and-Forget Alternative: The Fair Work Mobile App

If you don’t want to manage a manual spreadsheet, you can utilize official federal government software tools.

Download the free Record My Hours app developed directly by the Fair Work Ombudsman (FWO).

How to Configure it for Condition 8105:

1. Turn On Wi-Fi and Location Services: The app features advanced automatic geofencing. The second you physically walk into your retail shop, restaurant, or office, it automatically drop-pins your start time.
2. Toggle the Multiple Workplaces Option: If you are balancing a bar job on weekends and a retail job on weekdays, you can register both businesses under separate profiles within the app.
3. Export the Evidence Pack Monthly: The app keeps an immutable record of your time logs. At the end of every month, hit Export Timesheet. This generates an accountant-ready CSV file and a secure backup stream to your personal cloud drive. If Home Affairs ever runs a Single Touch Payroll (STP Phase 2) data audit on your income spikes, this export acts as your definitive primary proof to confirm compliance.