Spreadsheet: 774255d1648334752-create-a-reference-formula-impact_statement
Sheet: placeholders

report_date | 21/03/2022
employee | [NAME]
ato_loan_flag | no
annual_salary | 200000.00
allowances | 0.00
employee_no
mobile | 0
home_email | [EMAIL]
reference | 100218
employer | Department of Housing
employer_fbt_type | full-fbt-payable
pay_cycle | Fortnightly
driver_id | 100218
package_name_1 | Childcare
description_1 | Childcare
benefit_type_1 | exempt
start_date_1 | 22/03/2022
cycles_1 | 1
compress_flag_1 | no
total_deduction_1 | 10000.00
employee_contribution_1 | 0.00
[NAME] | 384.61
annual_deductions_1 | 384.61
status_flag_1 | active
addback_1 | sp
disbursement_type_1 | recurring
account_name_1
bsb_1 | 063-594
account_number_1 | 111111
gst_flag_1 | no
package_name_2 | Home Office Expenses
description_2 | Home Office Expenses
benefit_type_2 | exempt
start_date_2 | 22/03/2022
cycles_2 | 1
compress_flag_2 | no
total_deduction_2 | 600.00
employee_contribution_2 | 0.00
deduction_per_pay_2 | 23.07
annual_deductions_2 | 23.07
status_flag_2 | active
addback_2 | sp
disbursement_type_2 | recurring
account_name_2
bsb_2 | 063-594
account_number_2 | 111111
gst_flag_2 | yes
package_name_3 | Portable Electronic Devices
description_3 | Portable Electronic Devices
benefit_type_3 | exempt
start_date_3 | 22/03/2022
cycles_3 | 1
compress_flag_3 | no
total_deduction_3 | 2500.00
employee_contribution_3 | 0.00
deduction_per_pay_3 | 96.15
annual_deductions_3 | 96.15
status_flag_3 | active
addback_3 | sp
disbursement_type_3 | recurring
account_name_3
bsb_3 | 063-594
account_number_3 | 111111
gst_flag_3 | yes
package_name_4 | Superannuation
description_4 | Superannuation
benefit_type_4 | exempt
start_date_4 | 22/03/2022
cycles_4 | 1
compress_flag_4 | no
total_deduction_4 | 6000.00
employee_contribution_4 | 0.00
deduction_per_pay_4 | 230.76
annual_deductions_4 | 230.76
status_flag_4 | active
addback_4 | sp
disbursement_type_4 | recurring
account_name_4
bsb_4 | 063-594
account_number_4 | 111111
gst_flag_4 | no
package_name_5 | Novated Lease - Salary Packaged
description_5 | Novated Lease - Salary Packaged
benefit_type_5 | type-1
start_date_5 | 22/03/2022
cycles_5 | 1
compress_flag_5 | no
total_deduction_5 | 12000.00
employee_contribution_5 | 0.00
deduction_per_pay_5 | 461.53
annual_deductions_5 | 461.53
status_flag_5 | active
addback_5 | sp
disbursement_type_5 | periodic
account_name_5
bsb_5
account_number_5
gst_flag_5 | yes
package_name_6 | Administration Fee
description_6 | Administration Fee
benefit_type_6 | exempt
start_date_6 | 22/03/2022
cycles_6 | 1
compress_flag_6 | no
total_deduction_6 | 636.00
employee_contribution_6 | 0.00
deduction_per_pay_6 | 24.46
annual_deductions_6 | 24.46
[NAME] | active
addback_6 | sp
disbursement_type_6 | recurring
account_name_6
bsb_6
[NAME]
[NAME] | yes
package_name_7
description_7
benefit_type_7
start_date_7
cycles_7
compress_flag_7
total_deduction_7
employee_contribution_7
deduction_per_pay_7
annual_deductions_7
status_flag_7
addback_7
disbursement_type_7
account_name_7
bsb_7
[NAME]
gst_flag_7
package_name_8
description_8
benefit_type_8
start_date_8
cycles_8
compress_flag_8
total_deduction_8
employee_contribution_8
deduction_per_pay_8
annual_deductions_8
[NAME]
addback_8
disbursement_type_8
account_name_8
bsb_8
account_number_8
gst_flag_8
employee_location
employer_super | 0.00
employee_super | 0.00