FBT Worksheet and Calculation

Modified on: Mon, 13 Oct, 2025 at 2:45 PM

FBT Worksheet and Calculation

This guide outlines the steps for preparing and filing Fringe Benefits Tax (FBT) returns using the LodgeiT Smart Excel Utility (LSU) and the associated worksheet and calculation tools.

Prerequisites:

Download the LodgeiT Smart Excel Utility Tool (LSU) - Before starting, ensure the LSU tool is downloaded and installed. This is essential for generating and managing the FBT worksheets.

TABLE OF CONTENTS

Create The Form and Download The Template
FBT Excel Worksheet and Calculation
Uploading the worksheet via Form

Create The Form and Download The Template

Once you have downloaded the LodgeiT Smart Excel Utility (LSU). You may now proceed with the worksheet and form:

Select the "Year", and press "Create & Prefill"

Access the form’s menu via the 3 dots icon and select Import.

Download the FBT Template Excel file, which will be filled with relevant data for the FBT reporting period.

*Make sure to download first the LodgeiT Smart Excel Utility Tool, learn more here

FBT Excel Worksheet and Calculation

Within the downloaded Excel template, select "LodgeiT" plug-in > LodgeiT standard, and then click "FBT Return Preparer" to start working on your data.

Use the Add Employee function to input staff details required for the FBT calculations.

For each employee, create Add Benefit entries for each fringe benefit that applies.

Confirm the correct employee is selected in the Benefits section; use the 3 dots menu to switch employees if needed.

Illustration of the Worksheet with Benefits and Employees:

Once the employees and benefits are done, you may then proceed with the import.

Press "Add All Benefits to Excel"

Result:

Illustration: The "Expense Payment" is divided to 2 employees Lizza and Lulu. The calculation in excel will auto split the amount for both employees.

The spreadsheet automatically allocates expense payments proportionally between employees if benefits are shared. It also auto-populates the FBT Form tab based on your inputs.

Uploading the worksheet via Form

Once your Excel worksheet is complete, return to the LodgeiT FBT return form. Click the 3 dots icon and select Import.

Select the file and Import

Important Information

The current Fringe Benefits Tax rate is 47%, applicable for FBT years ending between 31 March 2022 and 31 March 2026.

For example, a taxable value of $26,950 would attract a total FBT of $12,666.50 at the 47% rate.

Additional Resources and References

ATO: Fringe benefits tax – a guide for employers

ATO: Fringe benefits tax – rates and thresholds

ATO: Fringe benefits tax – historical rates and thresholds

LodgeiT pricing details for FBT lodgements align with Income Tax Return pricing — further details available on the LodgeiT pricing page. here

Did you find it helpful? Yes No