*Make sure to download first the LodgeiT Smart Excel Utility Tool, learn more here
TABLE OF CONTENTS
- Create Form and Download Template
- FBT Excel Worksheet and Calculation
- Uploading the worksheet via Form
Create Form and Download 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"
Via 3 dots > Import.
Download the "Template" to generate your calculation and worksheet.
*Make sure to download first the LodgeiT Smart Excel Utility Tool, learn more here
FBT Excel Worksheet and Calculation
Inside the excel, select "LodgeiT" plug-in > LodgeiT standard, and press "FBT Return Preparer"
To get start, you need to create "Add Employee"
Then, once you have an "Employee", create "Add Benefit"
Inside the "Benefits", make sure that you are working with the correct "Employee/s", if you need to change, press the 3 dots
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.
It also auto fill the excel tab "FBT Form"
Uploading the worksheet via Form
Via 3 dots > Import.
Select the file and Import
Note: A fringe benefits tax (FBT) rate of 47% applies across the 31 March 2022 to 31 March 2026 FBT years.
The $12,666.50 is the total tax rate (47%) from $26,950.
Related Guides:
ATO: Fringe benefits tax – a guide for employers
ATO: Fringe benefits tax – rates and thresholds
ATO: Fringe benefits tax – historical rates and thresholds
FBT lodgments will adopt the pricing structure of Income Tax Returns, for further details about the pricing, check here
Related Guide: Preparation of Fringe Benefit Tax Return (FBT)