What does a mining site swing roster spreadsheet help you track?

It helps you track employee details, swing dates, shift type, hours, labour cost, travel, accommodation, allowances, overtime and super in one workbook. For a remote site, that is the difference between guessing the labour bill and seeing it row by row.

Can I use this template for a 2/1 swing pattern?

Yes. The roster sheet is set up for swing start and end dates, so a 2/1 pattern, 3/1 pattern or any other repeating cycle can be entered as long as you update the dates and shift counts correctly.

Does the spreadsheet calculate superannuation?

Yes. The template includes a Super % column and a super cost column, so you can show the employer cost separately from wages. At 11.5%, a $4,000 swing adds $460 of super.

Is this roster suitable for payroll records?

It can support payroll records, but it is not a payroll system. You still need to make sure payslips, PAYG withholding and STP reporting are handled properly in your payroll software or process.

What should I check before approving a swing roster?

Check dates, shift counts, overtime, travel, camp bookings and fatigue risk before you sign it off. A one-day date error can change hours, penalties and accommodation costs all at once.

When should I move from Excel to software?

Move on when the roster is too big to check manually, or when you are running multiple sites and the same worker keeps appearing in different drafts. If the admin time is taking longer than the actual planning, software is usually the next step.

Payroll & HR

Mining Site Swing Roster Excel - Free Template

Roster mining crews, shifts, swing dates, labour costs, travel, accommodation, allowances, super and fatigue checks in Excel.

2026-07-08

265 Downloads

4.8/5 Average rating

Download template

Screenshot 1: Roster tab - Excel template mining site swing roster excel spreadsheet australia

This Excel swing roster template tracks mining site shifts, swing dates, labour costs and compliance checks in one workbook. It includes a Roster sheet, a Summary Dashboard and an Instructions sheet.

Use it to plan 2/1 swings, record hours, add travel and accommodation costs, and total up superannuation and overtime for each worker. It is set up for Australian sites and costs in AUD.

The template is handy for a roster coordinator, site admin or small mining contractor who needs a clear view of who is on site, what each swing costs, and whether fatigue or compliance issues are starting to build.

The key benefits of this Excel template

Tracks each worker’s swing dates, shift type and total hours in one place.
Shows base labour, overtime, travel, accommodation and allowances separately for cleaner costing.
Calculates super on top of wages so you can see the true labour cost per employee.
Flags fatigue risk and compliance issues before the roster gets messy.
Makes it easier to compare one 14-day swing against another and spot cost blowouts.
Provides a summary view for quick site-level checking without digging through rows.
Keeps roster data in Australian dollars, which helps when you are comparing labour quotes or site budgets.

Step-by-step guide

Enter each employee’s ID, name, role, home city and site on the Roster sheet. Keep the list current before you build the next swing.
Fill in the swing pattern, start and end dates, shift type, hours per shift and number of shifts. The sheet then totals hours and labour cost fields for you.
Add hourly rate, travel cost, accommodation, allowances and overtime hours. This gives you the full swing cost rather than just wages.
Check the super percentage and cost columns. If your pay rate changes, update the rate first so the totals stay right.
Review fatigue risk and compliance check notes before publishing the roster. That is where you catch back-to-back shifts or too many hours in a short block.
Open the Summary Dashboard to review totals, compare workers and spot expensive patterns across the site.
Use the Instructions sheet as your setup guide whenever a new admin person takes over the roster.

Screenshot 2: Summary Dashboard tab - Excel template mining site swing roster excel spreadsheet australia — Figure 2: Worksheet "Summary Dashboard"

What is included

Roster table with 25 columns covering employee details, swing dates, shifts and pay inputs.

Base labour cost, overtime cost and total cost fields for each worker.

Separate columns for travel, accommodation and allowances so site costs are not hidden inside wages.

Super % and super cost fields to show the full employer outlay.

Fatigue risk and compliance check fields to support safer scheduling.

Summary Dashboard sheet for a high-level cost and roster view.

Instructions sheet to help you set up and use the template properly.

How mining crews use this Excel roster across a swing cycle

A mining site roster is usually handled by the site admin, roster coordinator or operations manager at the point where swings, flights and camp beds all have to line up. The pressure comes hard at the start of a 2/1 or 3/1 cycle, when a single change can affect travel bookings, room allocations and labour cost for the whole fortnight.

Who uses it day to day

A chippie with 4 employees on a remote site might have two on days and two on nights, with each worker costing $850 a day before you add allowances and super. A small contractor can quickly be looking at more than $47,600 for a 14-day swing if accommodation is $180 a night and travel is $300 per worker.

Why the swing pattern matters

This workbook is built around the swing pattern, start date, end date and shift type, which is exactly how mining rosters are managed in practice. If you are rostered for 12-hour shifts across 14 days, the difference between 14 shifts and 13 shifts is not small — that is 12 hours of labour, plus overtime and super, that can shift your site cost by well over $1,000.

Where the dashboard helps

The Summary Dashboard is useful when you are comparing crews across a month, especially if one crew is running heavier overtime than the others. For example, if Site A has 18 workers on swing and Site B has 11, you can see quickly whether travel, camp costs or overtime are pushing the budget off target.

Screenshot 3: Instructions tab - Excel template mining site swing roster excel spreadsheet australia — Figure 3: Worksheet "Instructions"

What the ATO and Fair Work expect when you roster mining employees

Once your roster turns into payroll, the numbers have to line up with Fair Work, PAYG withholding and STP reporting. If the employee is paid for ordinary hours, overtime or allowances, those amounts need to be recorded properly so the payslip matches the roster and the payroll file.

Pay and super basics

The superannuation guarantee rate is 11.5% in 2026, and it is paid to a complying fund quarterly. If a fitter earns $3,200 for a swing, the employer super amount is $368, which is not optional and should sit alongside wages in your labour cost view.

Records you need to keep

The ATO expects business records to be kept for 5 years, which includes rosters, time records and payroll support. If you are using this spreadsheet to back up a pay run, keep the source roster, the approved changes and the final export together so the trail is easy to follow.

Using the roster to support compliance

Mining work often involves long days and fatigue-sensitive scheduling, so the roster should show enough detail to explain why a person worked a particular swing. If someone is on 12-hour shifts for 14 days straight, that is 168 hours on site, and you want the file to show the hours, overtime and any loadings clearly before the pay run goes through.

Where mining rosters go wrong and what it costs

The biggest problems in mining rosters usually come from cost items being left out, dates being entered wrong, or a swing being pushed one day too far. A missed accommodation line at $180 a night for 10 people is a straight $1,800 understatement, and that is before you touch flights or meals.

Hidden overtime and loadings

If overtime is not recorded separately, a roster that looked like $22,000 for the week can easily become $26,000 once the extra hours are counted at penalty rates. That kind of miss causes bad decisions — you approve another crew change, but the site is already over budget.

Fatigue and back-to-back swings

Another common failure is stacking swings too tightly, especially when a relief worker gets added at the last minute. If one worker finishes on Friday and is booked for another 14-day swing starting Monday, you may save a flight, but you can also create a fatigue and compliance problem that is much more expensive to fix later.

Bad data means bad payroll

One wrong start date can send the wrong hours into payroll, and that can trigger an underpayment or an overpayment that takes hours to unwind. If 8 employees are paid from a bad roster and each correction takes 20 minutes, you have already burned more than 2.5 hours of admin time on one mistake.

That same payroll cleanup is where a superannuation contributions tracker becomes useful, because correcting one roster mistake often means checking whether the right contributions were calculated on the corrected pay.

How to make the swing roster part of your weekly routine

The easiest way to keep this spreadsheet alive is to tie it to an existing job, such as the weekly pay run or the Monday site planning meeting. If the roster is updated at the same time every week, it is far less likely to get lost in a desktop folder after two swings.

Practical habits that keep it tidy

Copy the previous swing and change only the dates, names and costs that have moved.
Use the same naming pattern for sites and roles so your reconciliation checks stay clean.
Review the dashboard before you approve flights, camp bookings or labour hire invoices.
Mark errors in one colour and approved changes in another so the roster history is easy to follow.

When spreadsheet tracking is enough

For a small contractor with 10 to 25 workers, this workbook is usually enough if one person owns the roster and payroll is handled separately. Once you are juggling multiple sites, live leave balances, complex award rules and more than a few hundred shifts a month, that is when Xero, MYOB or a dedicated workforce system starts to make more sense.

Once you are juggling multiple sites, live leave balances, complex award rules and more than a few hundred shifts a month, the next step is a FIFO roster tracker that keeps every shift and approval in one place.

Frequently asked questions about this template

It helps you track employee details, swing dates, shift type, hours, labour cost, travel, accommodation, allowances, overtime and super in one workbook. For a remote site, that is the difference between guessing the labour bill and seeing it row by row.
Yes. The roster sheet is set up for swing start and end dates, so a 2/1 pattern, 3/1 pattern or any other repeating cycle can be entered as long as you update the dates and shift counts correctly.
Yes. The template includes a Super % column and a super cost column, so you can show the employer cost separately from wages. At 11.5%, a $4,000 swing adds $460 of super.
It can support payroll records, but it is not a payroll system. You still need to make sure payslips, PAYG withholding and STP reporting are handled properly in your payroll software or process.
Check dates, shift counts, overtime, travel, camp bookings and fatigue risk before you sign it off. A one-day date error can change hours, penalties and accommodation costs all at once.
Move on when the roster is too big to check manually, or when you are running multiple sites and the same worker keeps appearing in different drafts. If the admin time is taking longer than the actual planning, software is usually the next step.