{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Fund Data","Dropdowns"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Fund Data","index":0,"n_rows":115,"n_cols":10,"rows_kept":115,"cut":false,"hidden":false,"merged":[[114,4,114,5],[108,4,108,5],[109,4,109,5],[110,4,110,5],[100,4,100,5],[112,4,112,5],[113,4,113,5],[111,4,111,5],[8,0,8,7],[13,4,13,7],[12,4,12,7],[100,6,100,7],[100,8,100,9],[9,0,9,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Data requirements for an Actuarial Certificate for  "]
["Account Based Pensions and TRISS Pensions"]
[null,"A."]
[null,null,"A1.","FUND DETAILS"]
[null,null,null,"Fund Name"]
[null,null,null,"Trustee(s)"]
[null,null,null,"Financial Year ended:"]
[]
[]
[null,null,"A2.","Number of unsegregated periods in the year"]
[]
[]
[]
[null,null,"A3.","Are any of the pension accounts pre-retirement TRIS?"]
[]
[]
[null,null,"A4.","Are any of the pension accounts post-retirement TRIS?"]
[]
[]
[null,null,"A5.","Number of pension members"]
[]
[]
[null,null,null,"First Name"]
[null,null,null,"Last Name"]
[null,null,null,"Date of birth"]
[]
[null,"B.",null,"ACCOUNT BALANCES"]
[null,null,"B1.","Account based pensions "]
[]
[]
[null,null,null,"* Total Fund balances includes all pension accounts, all pension account types, and all non-pension accounts"]
[]
[null,null,"B2.","TRIS pre-retirement accounts",null,null,null,"-- Not Applicable --"]
[]
[]
[]
[null,null,"B3.","TRIS post-retirement accounts",null,null,null,"-- Not Applicable --"]
[]
[]
[]
[null,"C.",null,"PENSIONS PAID IN THE UNSEGREGATED PERIODS"]
[null,null,"C1.","Account based pensions (including pension commutations paid from the Fund)"]
[]
[]
[]
[]
[null,null,"C2.","TRIS pre-retirement pensions (including pension commutations paid from the Fund)",null,null,null,"-- Not Applicable --"]
[]
[]
[]
[]
[null,null,"C3.","TRIS post-retirement pensions (including pension commutations paid from the Fund)",null,null,null,"-- Not Applicable --"]
[]
[]
[]
[]
[null,"D.",null,"PENSIONS ROLLED BACK TO AN ACCUMULATION ACCOUNT IN THE UNSEGREGATED PERIODS"]
[null,null,"D1.","Account based pensions "]
[]
[]
[]
[]
[null,null,"D2.","TRIS pre-retirement pensions",null,null,null,"-- Not Applicable --"]
[]
[]
[]
[]
[null,null,"D3.","TRIS post-retirement pensions",null,null,null,"-- Not Applicable --"]
[]
[]
[]
[]
[null,"E.",null,"PENSION ACCOUNTS COMMENCED IN THE UNSEGREGATED PERIODS"]
[null,null,"E1.","Account based pensions "]
[]
[]
[]
[]
[null,null,"E2.","TRIS pre-retirement pensions",null,null,null,"-- Not Applicable --"]
[]
[]
[]
[]
[null,null,"E3.","TRIS post-retirement pensions",null,null,null,"-- Not Applicable --"]
[]
[]
[]
[]
[]
[]
[null,"F.",null,"NON-PENSION (i.e. ACCUMULATION) ACCOUNT TRANSACTIONS IN THE UNSEGREGATED PERIODS"]
[null,null,null,null,{"$f":"\"* If there were many contributions spread evenly over the year, enter only the total amount and show the date as 1 January \" & YEAR(E15)","v":"* If there were many contributions spread evenly over the year, enter only the total amount and show the date as 1 January 1900"}]
[null,null,null,null,"NCCs & Transfers into the Fund *",null,"Concessional Contributions (before tax) *",null,"Accumulation Account Withdrawals"]
[null,null,null,null,"Date","Amount","Date","Amount","Date","Amount"]
[]
[]
[null,"G.",null,"Total net income of the Fund for the financial year"]
[]
[]
[null,"H.",null,"CONTACT DETAILS"]
[null,null,null,"Contact Person"]
[null,null,null,"Company Name"]
[null,null,null,"Street / PO Box Address"]
[null,null,null,"Town/Suburb"]
[null,null,null,"Postcode"]
[null,null,null,"State"]
[null,null,null,"Email Address"]

{"sheet":"Dropdowns","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["A1","A2","A3, A4","A5","G"]
["Financial\nYear ended","Number of \nunsegregated\nperiods \nin the year","Pre/Post\nRetirement\nTRIS","Number of\npension\nmembers","State"]
["2015-06-30",1,"Yes",1,"VIC"]
["2016-06-30",2,"No",2,"NSW"]
["2017-06-30",3,null,3,"TAS"]
["2018-06-30",4,null,4,"QLD"]
["2019-06-30",5,null,5,"ACT"]
["2020-06-30",6,null,6,"SA"]
["2021-06-30",7,null,null,"WA"]
["2022-06-30",8,null,null,"NT"]
["2023-06-30",9]
["2024-06-30",10]
["2025-06-30"]