FBT import template

Modified on Thu, 24 Apr at 8:30 AM

Overview

The FBT import template is an Excel file, used to import an entity's benefits, vehicles, drivers, and employee data into TaxLab. It outlines the required structure and formatting to ensure the data is correctly imported.

Important note

  • This template is a reference guide and should not be used for direct FBT data entry into TaxLab.
  • Only specific columns are required for importing:
    employee_id
    description
    asset_id
    days_available_for_private_use
  • Make sure to complete and import only the columns necessary for the calculation.

How to download the FBT import template

  1. Navigate to the Workpapers tab within the entity's FBT calculation and select Benefits.
  2. On the Benefits page, select the Import button.
  3. In the Import Benefits pop up window, select Download Import Template.

Keep in mind, the template can be downloaded from any Import window within the FBT software.

Template guidelines

The template provided ensures your data is formatted correctly for import. It includes the following:

  • Accepted column headings for the import.
  • Examples showing the correct data format.
  • Indicators showing whether a field is required or optional. Some fields are essential for calculations, while others can be included for reference or reporting.
  • Descriptions of each data item.

To prepare your data for import, follow these steps:

  • Open your source data alongside the TaxLab template.
  • Copy the Required column headings from the TaxLab template and paste them into the corresponding columns in your source data, replacing any existing headings.

Regarding the employee_id column heading:

  • Use 'Shareholder Pool' or 'POOL1' for non-attributed benefits provided to major shareholder-employees.
  • Use 'Employee Pool' or 'POOL2' for non-attributed benefits provided to employees.

Troubleshooting

Your data isn't in a format we recognise

  • Check headers match the TaxLab FBT import template
  • Check data in each field matches the relating header
    e.g. if the Header is Make > Data in that cell needs to be Ford
  • Character limits have not been exceeded in any cells
    50 character limit for
    employee_id, membership_number, asset_id, make, cost_centre

Next steps

Once your data is prepared, begin uploading your benefits to TaxLab. 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article