Looking for an ATO work-from-home Excel template?

Important disclaimer

The information in this article is general in nature and should not be considered financial or taxation advice. Everyone’s circumstances are different, and tax laws can be complex. We strongly recommend consulting with a qualified accountant or registered tax agent who can provide advice tailored to your situation. WFH Logbook Australia is a record-keeping tool and does not provide tax or financial advice.

The short answer

If you’re searching for an ATO work-from-home Excel template, there is something important to know before you download one: the spreadsheet itself is not what makes a record acceptable.

An Excel spreadsheet can be used to record your work-from-home hours. The problem is how most templates are used. A blank workbook downloaded at tax time and filled with your usual weekly schedule is not a contemporaneous record of the hours you actually worked from home.

For the fixed-rate method, the ATO expects you to keep a record of your actual work-from-home hours across the entire income year. The record can take different forms, but it needs to be maintained as you go rather than reconstructed months later.

That is where an Excel template often falls short in practice. It gives you rows and formulas, but it does not help you remember to make each entry or show clearly when you recorded and corrected it.

What the ATO expects

For the 2023–24 and later income years, the ATO’s fixed-rate method guidance says you must keep a record for the entire income year of the number of hours you worked from home.

It also makes two important points:

• An estimate for the whole year is not accepted.
• A short representative period cannot be applied to the rest of the year.

The record can be a timesheet, roster, log of time spent accessing an employer system, time-tracking app, diary, or similar document. What matters is that it records the actual hours and is kept contemporaneously.

In everyday language, contemporaneous record keeping means making the record at the time you work from home or close enough to that time for it to be a reliable account of what happened.

The ATO also requires evidence that you incurred the running expenses covered by the fixed rate. Your hours log does not replace bills or other supporting documents you may need to retain.

Why a spreadsheet is not automatically compliant

Excel and Google Sheets are flexible tools. That flexibility is useful, but it can also make a work-from-home hours spreadsheet a weak record if you do not maintain it carefully.

A template can be filled in after the event

A work-from-home diary template normally contains a date column, an hours column, and a formula to calculate a total. Nothing prevents all those rows from being completed at the end of the financial year.

The finished spreadsheet might look detailed, but the detail does not demonstrate that the record was made when the work occurred. Typing daily entries into Excel in June does not turn an annual estimate into a contemporaneous log.

Your normal schedule is not your actual hours

Suppose you usually work from home on Monday, Wednesday, and Friday. Multiplying three days by your normal hours and the number of working weeks may produce a neat total, but it overlooks real-life changes such as:

• Annual leave and personal leave
• Public holidays
• Extra office days
• Appointments and late starts
• Split days between home and another workplace
• Overtime or shorter workdays

The fixed-rate method is based on the actual number of hours you worked from home, not the schedule you expected to follow.

A blank file cannot remind you to use it

The hardest part of keeping a log is rarely the formula. It is remembering to open the spreadsheet regularly and enter the hours while they are still fresh.

You can add calendar reminders or create your own routine, but those systems sit outside the Excel template. Once you miss a few weeks, it becomes much easier to rely on memory and estimates.

Corrections can overwrite the original entry

Everyone makes mistakes. You might enter the wrong hours, forget a half-day in the office, or need to correct a past entry.

In an ordinary spreadsheet, a correction simply replaces the value in the cell. Unless you have deliberately set up version history and preserve it, the final file may not explain when the original entry was made or why it changed. That does not mean an edit is prohibited. It means the surrounding history can provide useful context if you later need to explain your records.

Multiple copies create confusion

Spreadsheets are easily copied, attached to emails, saved under new names, and moved between devices. By tax time, you might have WFH-hours-final.xlsx, WFH-hours-final-2.xlsx, and another version stored in the cloud.

If the totals differ, you first need to work out which file is the complete record. A single purpose-built log avoids that version problem.

What a reliable Excel WFH log would involve

If you prefer to use an Excel work-from-home logbook, it needs an ongoing routine behind it. At a minimum, you should:

• Record the date and actual number of hours worked from home.
• Update it throughout the income year, close to when the work occurs.
• Adjust entries for leave, office attendance, breaks, and unusual workdays.
• Avoid populating the year from a standard weekly schedule.
• Keep the file secure and backed up.
• Use a consistent method for recording and explaining corrections.
• Retain the bills and other evidence required for your chosen deduction method.

An accountant or registered tax agent can advise whether your particular records support your claim.

Excel template compared with a WFH tracking app

Both options can hold a list of hours. The difference is how much work you need to do to maintain a reliable record.

Automatic timestamps and edit history do not guarantee that the ATO will accept a deduction. They provide helpful context that can demonstrate how and when you maintained your records.

A common spreadsheet mistake

Consider Sam, who normally works from home on Monday, Wednesday, and Friday for eight hours each day.

During one month, Sam takes two days of leave, attends the office on a Wednesday, works a half-day from home before an appointment, and works an extra Friday evening. A spreadsheet populated from the usual schedule records 96 hours for the month. Sam’s actual work-from-home hours are different.

If Sam logs each day as it happens, those exceptions are captured naturally. If Sam reconstructs the month from a calendar much later, it becomes harder to remember the half-day, additional office visit, and extra hours accurately.

This is why the routine matters more than the template.

If you already track your hours in Excel

Do not discard records you have already kept. A spreadsheet that you updated regularly may be useful evidence of your actual work-from-home hours.

If there are gaps, avoid filling them with your normal schedule and presenting the result as a contemporaneous record. Look for other genuine records, such as employer timesheets, rosters, calendar entries, or system-access logs, and ask your accountant or tax agent how they affect your situation.

You can start using a daily WFH hours tracker now without rewriting the past. Keep your existing spreadsheet and begin maintaining the new record from the date you switch.

Skip the spreadsheet maintenance

WFH Logbook Australia is designed specifically for maintaining work-from-home hour records throughout the year. You can log a workday in one tap, use optional reminders, keep timestamped entries and a transparent edit history, and export a clear PDF report when you need it.

The app is free, with no limit on reports. Download it from the Apple App Store or Google Play.

Common questions

Does the ATO accept an Excel work-from-home logbook?

The ATO says the record can be in any form, provided it records your actual hours and is kept contemporaneously. An Excel spreadsheet may meet that description if you maintain it properly throughout the year. Downloading or completing a template at tax time does not, by itself, satisfy those expectations.

Can I create my WFH spreadsheet at tax time?

You can create a spreadsheet that totals other genuine records, but a spreadsheet reconstructed from memory or your usual schedule is not the same as a contemporaneously maintained log. Ask a registered tax agent about the evidence available for your particular claim.

Can I use my usual weekly work-from-home schedule?

Your schedule can help you remember when you expected to work from home, but the fixed-rate calculation must use the actual hours you worked from home. You need to account for leave, public holidays, office days, split days, and other changes.

Is a four-week WFH diary enough?

Not for recording hours under the fixed-rate method for the 2023–24 and later income years. The ATO requires a record of hours for the entire income year and does not accept a representative period extrapolated across the year.

What does contemporaneous mean?

It means keeping the record at the time the work happens or close to it, rather than recreating the record well after the event.

Do timestamps guarantee that my claim will be accepted?

No. Timestamps can help demonstrate when records were maintained, but they do not guarantee a deduction. You still need to satisfy the relevant eligibility and record-keeping requirements.

Do I need to keep bills as well as an hours log?

For the fixed-rate method, the ATO says you must also keep at least one document for each type of running expense covered by the rate that you incurred. The exact records you need depend on your circumstances and the method you use.