{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Macro Error","EOYC","Fields","User Instructions","Employer_Types","Tier_Rates","TEMPSHEET","LA Declaration","LA Welsh Declaration","Non LA Declaration"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":69,"comments":1,"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":"Macro Error","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Warning: Macros are Disabled!"]
[]
[null,"Please ensure that Macros are Enabled before opening this Spreadsheet"]
[]
[null,"On opening you should choose the option \"Enable Macros\" or \"Enable This Content\" when the Security Warning alert is shown."]
[]
[null,"If a Security Warning alert was not shown on opening, please close this spreadsheet. "]
[null,"In Excel 2003 select Tools, Macro, Security from the Menu. Select \"Medium\" and OK and reopen this spreadsheet."]
[]
[null,"In Excel 2007+ when the Security Warning is displayed then click on Options and select Enable This Content then OK "]
[null,"If you wish to Enable All Macros so that no warnings are displayed on opening, follow the instructions below:"]
[null,"Select the File or Office Button > Excel Options > Trust Center > Trust Center Settings button > Macro Settings"]
[null,"then choose Enable All Macros, click OK and then reopen this spreadsheet."]

{"sheet":"EOYC","index":1,"n_rows":61,"n_cols":13,"rows_kept":61,"cut":false,"hidden":true,"merged":[[57,2,57,3],[57,4,57,5],[57,6,57,7],[55,2,55,3],[55,4,55,5],[55,6,55,7],[56,2,56,3],[56,4,56,5],[56,6,56,7],[53,2,53,3],[53,4,53,5],[53,6,53,7],[54,2,54,3],[54,4,54,5],[54,6,54,7],[50,1,50,7],[51,2,51,3],[51,4,51,5],[51,6,51,7],[52,2,52,3],[52,4,52,5],[52,6,52,7],[47,4,47,5],[20,2,21,4],[20,5,21,6],[43,2,43,3],[43,6,43,7],[43,4,43,5],[25,2,25,4],[25,5,25,6],[35,5,35,6],[36,5,36,6],[44,2,44,3],[45,2,45,3],[46,2,46,3],[45,4,45,5],[46,4,46,5],[42,1,42,7],[60,2,60,7],[58,2,58,3],[58,4,58,5],[44,6,44,7],[45,6,45,7],[46,6,46,7],[47,6,47,7],[48,6,48,7],[49,6,49,7],[58,6,58,7],[44,4,44,5],[48,4,48,5],[49,4,49,5],[47,2,47,3],[48,2,48,3],[49,2,49,3],[1,1,2,5],[4,1,4,6],[16,6,16,7],[16,1,16,3],[13,4,13,7],[13,1,13,3],[6,1,7,6],[8,1,9,6]]}
[null,"2020 Version 1.0"]
[null,"Teachers' Pensions Contributions for Financial Year 2019/20"]
[]
[]
[null,"Please familiarise yourself with the instructions, to complete, upload and print your EOYC."]
[]
[null,"To create your Declaration form to be signed, first create your .CSV to upload via the button to the right, then that same button becomes Print File. Click it and ensure you click to print entire workbook."]
[]
[null,"Unaudited EOYC forms should be uploaded to the employers portal no later than 31 May 2020"]
[]
[]
[null,"Employer Information"]
[]
[null,"Local Authority/Establishment Name:"]
[]
[null,null,null,null,"LA Number","Establishment Number"]
[null,"Local Authority/Establishment Number:",null,null,null,null,"(For Local Authorities, please enter the establishment number as '0000')"]
[]
[null,"Employer Type"]
[null,"Please select your Employer Type from the dropdown list below, before completing the remainder of this form."]
[null,null,"Employer Type:"]
[]
[]
[null,"Section 1: Total Actual Contributory Salary"]
[]
[null,null,"Total Contributory Salary:"]
[]
[null,"Section 2: Summary of Contributions"]
[]
[null,null,"i. Career Average Flexibilities\n(Note 3)","ii. Additional Pension Payments (Note 3)","iii. Additional Contributions (Note 3)","iv. Teachers' Contributions","v. Employer's Contributions ","Total Contributions "]
[null,"a. Contributions deducted\n(as per contributory salary at 1\n - see Note 4)"]
[null,null,null,null,"i. Arrears deducted in respect of EFE Elections (Note 5)","ii. Contributions deducted in respect of PRESTON  (Note 6)","iii. TR22 Election amounts deducted (Note 7)","Total Extra Contributions "]
[null,null,null,"b. Extra contributions deducted"]
[null,null,null,null,null,"i. Short Term Pension ","ii. Refunds made  (in respect of previous years only)","Total Refunds made "]
[null,null,null,null,"c. Refunds Made",0]
[null,null,null,null,null,"d. Contributions Paid (Note 8)"]
[null,null,null,null,null,"e. Overall Balance\n\n(2a + 2b) - (2c + 2d)"]
[]
[]
[]
[null,"Section 3: Analysis of Contributions by Tier"]
[]
[null,"Period 1 - 01/04/2019 to 31/08/2019"]
[null,"Tier (Percentage Rate)","Contributory Salary ",null,"Teachers' Contributions ",null,"Employer's Contributions (16.48%)"]
[null,"Tier 1 (7.40%)"]
[null,"Tier 2 (8.60%)"]
[null,"Tier 3 (9.60%)"]
[null,"Tier 4 (10.20%)",null,null,null,null,null,null,null,null,null,null," "]
[null,"Tier 5 (11.30%)"]
[null,"Tier 6 (11.70%"]
[null,"Period 2 - 01/09/2019 to 31/03/2020"]
[null,"Tier (Percentage Rate)","Contributory Salary ",null,"Teachers' Contributions ",null,"Employer's Contributions (23.68%)"]
[null,"Tier 1 (7.40%)"]
[null,"Tier 2 (8.60%)"]
[null,"Tier 3 (9.60%)"]
[null,"Tier 4 (10.20%)",null,null,null,null,null,null,null,null,null,null," "]
[null,"Tier 5 (11.30%)"]
[null,"Tier 6 (11.70%"]
[null,"TOTALS"]
[]
[null,null,"NB: Totals from Section 3 should be identical to the figures in Sections 1 and 2"]

{"sheet":"Fields","index":2,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
["Field Number","Field Name","Cell Name","Field Headings For Output File","Field Type","Field Required","Field Required if field number is completed \n(Enter '0' if not applicable)","Field Default Value","(if 'STRLIST')\nList/Sheet Name","(if 'STRLIST')\nList code description","Fields For  Total Validation"]
[1,"Local Authority/Establishment Name","emp_name",null,"STRING","YES",0,"NO_DEFAULT"]
[2,"Local Authority/Establishment Number - LEA","emp_lano",null,"LA","YES",0,"NO_DEFAULT"]
[3,"Local Authority/Establishment Number - Establishment","emp_estno",null,"ESTAB","YES",0,"NO_DEFAULT"]
[4,"Employer Type","emp_type",null,"STRLIST","YES",0,"NO_DEFAULT","Employer_Types","Employer Type"]
[5,"Total Actual Contributory Salary","act_cont_sal",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[6,"Career Average Flexibilities","ca_flex",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[7,"Additional Pension Payments","add_pen",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[8,"Additional Contributions","add_conts",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[9,"Teachers Contributions","tch_conts",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[10,"Employer Contributions","emp_conts",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[11,"Total Contributions","tot_conts",null,"CURRENCY","YES",0,"NO_DEFAULT",null,null,"+6,+7,+8,+9,+10"]
[12,"Arrears deducted in respect of EFE Elections","efe_arrs",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[13,"Contributions deducted in respect of PRESTON","pres_conts",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[14,"TR22 Election amounts deducted","tr22_ded",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[15,"Total Extra Contributions","tot_extra",null,"CURRENCY","YES",0,"NO_DEFAULT",null,null,"+12,+13,+14"]
[16,"Short Term Pension","st_pen",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[17,"Refunds made (in respect of previous years only)","prev_yrs",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[18,"Total Refunds made","tot_refs",null,"CURRENCY","YES",0,"NO_DEFAULT",null,null,"+16,+17"]
[19,"Contributions Paid","conts_paid",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[20,"Overall Balance","overall_bal",null,"CURRENCY","YES",0,"NO_DEFAULT",null,null,"+11,+15,-18,-19"]
[21,"Contributory Salary – Tier 1","cont_sal_1",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[22,"Teachers’ Contributions – Tier 1","tch_conts_1",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[23,"Employer Contributions (16.48%) – Tier 1","emp_conts_1",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[24,"Contributory Salary – Tier 2","cont_sal_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[25,"Teachers’ Contributions – Tier 2","tch_conts_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[26,"Employer Contributions (16.48%) – Tier 2","emp_conts_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[27,"Contributory Salary – Tier 3","cont_sal_3",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[28,"Teachers’ Contributions – Tier 3","tch_conts_3",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[29,"Employer Contributions (16.48%) – Tier 3","emp_conts_3",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[30,"Contributory Salary – Tier 4","cont_sal_4",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[31,"Teachers’ Contributions – Tier 4","tch_conts_4",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[32,"Employer Contributions (16.48%) – Tier 4","emp_conts_4",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[33,"Contributory Salary – Tier 5","cont_sal_5",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[34,"Teachers’ Contributions – Tier 5","tch_conts_5",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[35,"Employer Contributions (16.48%) – Tier 5","emp_conts_5",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[36,"Contributory Salary – Tier 6","cont_sal_6",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[37,"Teachers’ Contributions – Tier 6","tch_conts_6",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[38,"Employer Contributions (16.48%) – Tier 6","emp_conts_6",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[39,"Contributory Salary – Tier 1","cont_sal_1_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[40,"Teachers’ Contributions – Tier 1","tch_conts_1_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[41,"Employer Contributions (23.68%) – Tier 1","emp_conts_1_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[42,"Contributory Salary – Tier 2","cont_sal_2_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[43,"Teachers’ Contributions – Tier 2","tch_conts_2_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[44,"Employer Contributions (23.68%) – Tier 2","emp_conts_2_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[45,"Contributory Salary – Tier 3","cont_sal_3_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[46,"Teachers’ Contributions – Tier 3","tch_conts_3_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[47,"Employer Contributions (23.68%) – Tier 3","emp_conts_3_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[48,"Contributory Salary – Tier 4","cont_sal_4_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[49,"Teachers’ Contributions – Tier 4","tch_conts_4_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[50,"Employer Contributions (23.68%) – Tier 4","emp_conts_4_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[51,"Contributory Salary – Tier 5","cont_sal_5_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[52,"Teachers’ Contributions – Tier 5","tch_conts_5_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[53,"Employer Contributions (23.68%) – Tier 5","emp_conts_5_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[54,"Contributory Salary – Tier 6","cont_sal_6_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[55,"Teachers’ Contributions – Tier 6","tch_conts_6_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[56,"Employer Contributions (23.68%) – Tier 6","emp_conts_6_2",null,"CURRENCY","YES",0,"NO_DEFAULT"]
[57,"Contributory Salary – Total","cont_sal_tot",null,"CURRENCY","YES",0,"NO_DEFAULT",null,null,"+21,+24,+27,+30,+33,+36,+39,+42,+45,+48,+51,+54"]
[58,"Teachers’ Contributions – Total","tch_conts_tot",null,"CURRENCY","YES",0,"NO_DEFAULT",null,null,"+22,+25,+28,+31,+34,+37,+40,+43,+46,+49,+52,+55"]
[59,"Employer Contributions – Total","emp_conts_tot",null,"CURRENCY","YES",0,"NO_DEFAULT",null,null,"+23,+26,+29,+32,+35,+38,+41,+44,+47,+50,+53,+56"]

{"sheet":"User Instructions","index":3,"n_rows":65,"n_cols":7,"rows_kept":65,"cut":false,"hidden":true,"merged":[[9,0,9,2],[6,0,7,2],[8,0,8,1],[3,0,4,2],[64,6,65,6],[11,0,11,2],[13,0,13,2],[15,0,15,2],[17,0,17,2],[19,0,19,2],[21,0,21,2],[23,0,23,2]]}
[]
[]
[]
["Teachers' Pensions Contributions for Financial Year 2019/20 Instructions"]
[]
[]
["The following instructions are provided to help you complete your End of Year Certificate. For further information, please contact TPAudit@teacherspensions.co.uk or 0345 300 3756 (Option 2)."]
[]
["PLEASE NOTE: YOU ARE EXPECTED TO UPLOAD AN UNAUDITED FORM EVEN IF YOU COMPLETE THE AUDITED FORM BEFORE 31 MAY 2020. IF YOU DO NOT HAVE EMPLOYER PORTAL ACCESS YOU MUST CALL 0345 300 3756 AND SELECT OPTION 3 FOR THE PORTAL TEAM TO SET UP LOG INS"]
["To print your EOYC you must use the button on the front under Instructions. The first time you click it when it says \"Save File as CSV\" this will create your .CSV file to upload to the employer portal. When you click it a second time, it will say \"Print File\". After clicking you must then select \"Print Entire Workbook\" from the options. Your Declaration will be printed based on which drop down is selected on your EOYC template form."]
[]
["1. Section 1 to 3 of this template must be completed in full and returned to Teachers’ Pensions via the Employer Portal on or before 31 May 2020. If you cannot agree the Contributions Paid figure which is contained within the email sent to you, you must contact Teachers’ Pensions to agree the figure before you finalise and submit this return. This form should be submitted to Teachers’ Pensions via the Employer Portal, and a copy passed to your Auditor. This must be returned to Teachers’ Pensions directly by the Auditor, not the Employer by:\n \n• 30 September 2020 for Non LA\n• 30 November 2020 for LA"]
[]
["Total Contributory Salary\n \n2. Total Contributory Salary is the sum of all pensionable pay paid in 2019/20 to employees who are members of the Teachers’ Pension Scheme. This figure should be derived from the payroll records and should not be calculated by grossing up the contribution due figures from Section 2. The figure should include all pensionable pay for all teachers employed (for Local Authorities, this includes those whose pay is administered by an organisation other than the authority). Only pensionable pay should be included, so total pay figures should be adjusted to exclude cases where a teacher:\n \n• Has opted out of the Teachers’ Pension Scheme;\n• Is aged 75 or over;\n• Is in part time non pensionable employment;\n• Is already correctly contributing to the Local Government Pension Scheme;\n• Is in receipt of non-pensionable allowances, i.e. overtime;\n• Is paying contributions on a former high salary;\n• Is paying additional contributions (PRESTON), due in the case of elections for retrospective access to the pension scheme by part-time workers. "]
[]
["Summary of Contributions\n \n3. Career Average Flexibilities (Box 2a [i]) were introduced on 1 April 2015 and relate to additional contributions being made by members to enhance their career average pensions. Additional Pensions Payments [Box 2 (ii)] relate to teachers who have elected to purchase additional pensions (under the new regulations introduced January 2007) via set cash instalments from their salary. Additional  Contributions [Box 2(iii)] relate to teachers who made an election to purchase Family Benefits or Past Added Years prior to 1 January 2007. Additional Contributions will continue to the original cessation date agreed at the time the election was made.\n \n4. Contributions, are those contributions due on the Total Contributory Salary, at Section 1, before any adjustments in respect of previous years, and excluding amounts in respect of TR22 elections [2b (iii) overleaf] and the amounts plus interest in respect of backdated EFE elections (2b (i) ) and contributions in respect of PRESTON payments (due in the case of elections for retrospective access to occupational pension scheme by part-time workers) [2b (ii)]\n \n5. Arrears in respect of elected further employment (EFEs) (2b (i)) are those contributions and interest deducted where agreement was given for the election to be backdated.\n \n6. Contributions deducted in respect of PRESTON [2b (ii)] are those contributions deducted from the employee in the case of elections for retrospective access to occupational pension scheme by part-time workers.\n \n7. TR22 elections [2b (iii)]. Any contributions, deducted in respect of employees who have made an election to pay contributions on a former higher salary. This is the total of the employee’s and employer’s share.\n \n8. Contributions paid are the sums actually remitted, including amounts in respect of TR22 elections, EFE elections and after any adjustments made (e.g. short term pensions, refunds). The total contributions (column 2d) should be completed with the value stated in the email from Teachers’ Pensions. If you cannot agree with the value/records held by Teachers’ Pensions you should contact the audit team to agree the figure.\n \n9. Overall balance (2e). Any sums entered here form the basis of the final adjustment payment or refund between the employer and Teachers’ Pensions. A positive figure indicates an amount due to Teachers’ Pensions; a negative figure indicates an amount due from Teachers’ Pensions."]
[]
["Analysis of Contributions by Tier\n \n10. Using the guidance in notes 2 and 4 above, complete the Contributory Salary and contributions at each Tier. The Total of Contributory salary should agree to the Total Actual Contributory salary disclosed in Section 1. The Total of Employer’s Contributions and Employee’s Contributions should agree with the entries in columns (iv) and (v) of section 2a."]
[]
["End of Year Adjustments\n \n11. After the submission of your EOYC, any resulting underpayment due to the scheme will be notified to you. You should complete an End of Year Underpayment paying-in slip in the Employer Portal and submit your payment.\n \n12. Arrangements will be made to refund any overpayment once the audited form is received and reconciled by Teachers’ Pensions."]
[]
["Statutory Requirements\n \n13. Regulation 219 of the Teachers’ Pensions Regulations 2014 state that employers, within the time set by the scheme manager, make reports and returns to the scheme manager as the scheme manager may require for the purpose of the scheme manager’s functions under these Regulations.\n \n14. Teachers’ Pensions and auditors acting on their behalf have the right to check all returns. If an audited return or independent certificate is not submitted by the due date, Teachers’ Pensions may report the matter of non-compliance of the Scheme Regulations to the Pensions Regulator, as appropriate.\n\n15. The Unaudited EOYC must be issued to your  Auditor alongside a signed declaration form, which will be produced  when printed. "]
[]
["Auditor/Independent Certificate (Non LA Only)\n\n16. The purpose of the auditor or independent certificate, is to provide to the Teachers’ Pensions Accounting Officer, assurance that sums due to the Teachers’ Pension Scheme have been correctly calculated and remitted. \n\n17. The certificate must be stamped with the official stamp of the external auditor. In the case of an independent establishment (an establishment who does not receive any government funding), the certificate should be signed by a suitable person. Examples of a suitable person include: \n\n• An independent qualified accountant or a Governor with a CIMA, ACCA, CIPFA or ICAEW qualification \n• Alternatively a governor who is a retired Bursar or Finance Director \n\nPlease note that the certificate cannot be signed by an employee of the establishment. A governor will be viewed as independent of the establishment as long as they do not receive any remuneration. \n\n18. Auditors should refer to the tests that are in the auditor guidance document which can be obtained from the Teachers’ Pensions Website. The auditor guidance document “TP05” can be found under Employer/Employer Tool Kit/How to Administer the Scheme/End of Year Certificate/Auditor Certification. \n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Return to EOYC"]

{"sheet":"Employer_Types","index":4,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["Employer Types"]
[]
["Description","Code"]
["Local Authority","LADEC"]
["Local Authority (Welsh)","LAWDEC"]
["Non Local Authority","NONLADEC"]

{"sheet":"Tier_Rates","index":5,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["Tier Rates"]
[]
["Number","Rate"]
[1,7.3999999999999996E-2]
[2,8.5999999999999993E-2]
[3,9.6000000000000002E-2]
[4,0.10199999999999999]
[5,0.113]
[6,0.11700000000000001]

{"sheet":"TEMPSHEET","index":6,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Locked?"]
["File date"]
["File time"]

{"sheet":"LA Declaration","index":7,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":true,"merged":[[30,1,30,13],[18,1,18,13],[19,1,19,13],[21,1,21,6],[21,8,21,10],[29,1,29,13],[4,1,4,13],[5,1,5,13],[6,1,6,13],[7,1,7,13],[13,8,14,10],[13,11,13,13]]}
[null,{"$f":"ver","v":"2020 Version 1.0"}]
[null,"Teachers' Pensions Contributions for Financial Year 2019/20"]
[]
[null,"Section 4: Certificate to be given by the Chief Finance Officer of the Local Authority"]
[null,"I hereby certify that, to the best of my knowledge and belief, the entries on this form are correct and that, in accordance with the regulations underpinning the Teachers' Pension Scheme:"]
[null,"- Employee contributions have been correctly calculated, deducted from pensionable salary and remitted to Teachers' Pensions in respect of all employees who are members of the scheme;"]
[null,"- Employer contributions have been correctly calculated and remitted to Teachers' Pensions based on pensionable salaries and applicable contributions rates"]
[null,"- I am satisfied that the authority has adequate systems in place and has obtained supporting evidence which confirms that those entries in respect of teachers in schools maintained by the Local Authority whose salary payments are administered other than directly through the LA payroll, are correctly calculated and paid to Teachers' Pensions. "]
[null,"Name (in capital letters)",null,null,null,null,null,null,"Position"]
[]
[null,"Email Address",null,null,null,null,null,null,"Telephone Number"]
[]
[null,"Signature",null,null,null,null,null,null,"Date"]
[null,null,null,null,null,null,null,null,"DDMMYYYY"]
[]
[]
[]
[null,"Section 5: Certificate of the auditor"]
[null,"I/We have examined the entries in this form (which replaces or amends the original submitted to me/us by the authority dated _____________________________) and the related accounts and records of the authority in accordance with the agreed upon tests in Certification Instruction TP05. "]
[null,"My/our assessment carried out the agreed upon tests in Certification Instruction TP05 and obtained such evidence and explanations as I/we consider necessary. (Except for the matters raised in the attached report dated _____________________________)."]
[null,"Name (in capital letters)",null,null,null,null,null,null,"Date"]
[null,null,null,null,null,null,null,null,"DDMMYYYY"]
[null,"Signature"]
[]
[]
[]
[]
[]
[]
[null,"General Data Protection Regulation (GDPR). The Department for Education (DfE) will use any information you provide in connection with the Teachers’ Pension Scheme to administer and operate the scheme and pay benefits under it. This may include passing details to third parties that are involved in the administration and operation of the scheme. The DfE may also use your data for administrative purposes in line with its data protection notification. In order to fulfil its duty to protect public money, the DfE may use information it holds to prevent and detect fraud. It may also share information with other organisations that handle public funds. If there is any difference between the legislation governing the Teachers’ Pension Scheme and the information in this application form, the legislation will apply. For more information on how we will use your data, go to: "]
[null,{"$f":"HYPERLINK((\"https://www.teacherspensions.co.uk/public/privacy\"))","v":"https://www.teacherspensions.co.uk/public/privacy"}]
[null,"Please return to us at: "]
[null,"Teachers’ Pensions, 11b Lingfield Point, Darlington, DL1 1AX "]
[null,"www.teacherspensions.co.uk . "]

{"sheet":"LA Welsh Declaration","index":8,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":true,"merged":[[39,1,39,13],[38,1,38,13],[18,1,18,13],[19,1,19,13],[25,1,25,6],[25,8,25,10],[35,1,35,2],[35,4,35,5],[4,1,4,13],[5,1,5,13],[6,1,6,13],[7,1,7,13],[13,8,14,10],[13,11,13,13]]}
[null,{"$f":"ver","v":"2020 Version 1.0"}]
[null,"Teachers' Pensions Contributions for Financial Year 2019/20"]
[]
[null,"Section 4: Certificate to be given by the Chief Finance Officer of the Local Authority"]
[null,"I hereby certify that, to the best of my knowledge and belief, the entries on this form are correct and that, in accordance with the regulations underpinning the Teachers' Pension Scheme:"]
[null,"- Employee contributions have been correctly calculated, deducted from pensionable salary and remitted to Teachers' Pensions in respect of all employees who are members of the scheme;"]
[null,"- Employer contributions have been correctly calculated and remitted to Teachers' Pensions based on pensionable salaries and applicable contributions rates"]
[null,"- I am satisfied that the authority has adequate systems in place and has obtained supporting evidence which confirms that those entries in respect of teachers in schools maintained by the Local Authority whose salary payments are administered other than directly through the LA payroll, are correctly calculated and paid to Teachers' Pensions. "]
[null,"Name (in capital letters)",null,null,null,null,null,null,"Position"]
[]
[null,"Email Address",null,null,null,null,null,null,"Telephone Number"]
[]
[null,"Signature",null,null,null,null,null,null,"Date"]
[null,null,null,null,null,null,null,null,"DDMMYYYY"]
[]
[]
[]
[null,"Section 5: Certificate of the auditor"]
[null,"The Statement of Responsibilities of grant-paying and receiving bodies, the Auditor General for Wales and auditors who work under his arrangements for certifying claims and returns sets out the respective responsibilities of these parties. It also sets out the limitations of the responsibilities of the Auditor General for Wales and the auditors working under his arrangements."]
[null,"I/We have examined the entries in this form (which replaces or amends the original submitted to me/us by the authority dated _________________________) and the related accounts and records of the receiving body in accordance with the Auditor General for Wales' Certification Instruction AO1, and have carried out the tests in his Certification Instruction and obtained such evidence and explanations as I/we consider necessary."]
[null,"(Except for the matters raised in the attached report dated _______________________________*)"]
[null,"I/We have concluded that the claim or return :"]
[null," - is fairly stated; and"]
[null," - in accordance with the relevant terms and conditions."]
[null,"Name (in capital letters)",null,null,null,null,null,null,"Date"]
[null,null,null,null,null,null,null,null,"DDMMYYYY"]
[null,"Signature"]
[]
[]
[]
[]
[]
[null,"Audit Conclusion"]
[null,"Please indicate below your audit conclusion by ticking the appropriate box:"]
[]
[null,"Qualification",null,null,"No Qualification"]
[]
[]
[null,"General Data Protection Regulation (GDPR). The Department for Education (DfE) will use any information you provide in connection with the Teachers’ Pension Scheme to administer and operate the scheme and pay benefits under it. This may include passing details to third parties that are involved in the administration and operation of the scheme. The DfE may also use your data for administrative purposes in line with its data protection notification. In order to fulfil its duty to protect public money, the DfE may use information it holds to prevent and detect fraud. It may also share information with other organisations that handle public funds. If there is any difference between the legislation governing the Teachers’ Pension Scheme and the information in this application form, the legislation will apply. For more information on how we will use your data, go to:"]
[null,{"$f":"HYPERLINK((\"https://www.teacherspensions.co.uk/public/privacy\"))","v":"https://www.teacherspensions.co.uk/public/privacy"}]
[null,"Please return to us at: "]
[null,"Teachers’ Pensions, 11b Lingfield Point, Darlington, DL1 1AX "]
[null,"www.teacherspensions.co.uk . "]

{"sheet":"Non LA Declaration","index":9,"n_rows":48,"n_cols":12,"rows_kept":48,"cut":false,"hidden":true,"merged":[[44,1,44,13],[43,1,43,13],[19,1,19,6],[25,8,26,10],[29,1,29,13],[31,1,31,6],[39,1,39,2],[39,4,39,5],[39,8,39,10],[39,11,39,13],[17,1,17,13],[4,1,4,13],[5,1,5,13],[6,1,6,13],[12,8,13,10],[12,11,12,13]]}
[null,{"$f":"ver","v":"2020 Version 1.0"}]
[null,"Teachers' Pensions Contributions for Financial Year 2019/20"]
[]
[null,"Section 4: Certificate to be given by the Officer with financial responsibility for the Employer"]
[null,"I hereby certify that, to the best of my knowledge and belief, the entries on this form are correct and that, in accordance with the regulations underpinning the Teachers' Pension Scheme:"]
[null,"- Employee contributions have been correctly calculated, deducted from pensionable salary and remitted to Teachers' Pensions in respect of all employees who are members of the scheme;"]
[null,"- Employer contributions have been correctly calculated and remitted to Teachers' Pensions based on pensionable salaries and applicable contributions rates"]
[null,"Name (in capital letters)",null,null,null,null,null,null,"Position in Employer"]
[]
[null,"Email Address",null,null,null,null,null,null,"Telephone Number"]
[]
[null,"Signature",null,null,null,null,null,null,"Date"]
[null,null,null,null,null,null,null,null,"DDMMYYYY"]
[]
[]
[]
[null,"Section 5: Independent Certificate"]
[null,"I have examined the entries above for the year ended March 2020 and the establishment's payroll and related records. I have carried out the agreed upon tests that are in Certification Instruction TP05 and have obtained such explanations as I consider necessary. I am of the opinion that the entries are fairly stated."]
[null,"Name (in capital letters)",null,null,null,null,null,null,"Accountancy Qualification"]
[]
[null,"Address",null,null,null,null,null,null,"Signature"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Date"]
[null,null,null,null,null,null,null,null,"DDMMYYYY"]
[null,"Postcode"]
[]
[null,"Section 6: Certification of Auditor"]
[null,"I/we examined the Summary of Contributions for the year ended 31 March 2020 as to whether the contributions shown on the Certificate have been paid in accordance with the rules of the Teachers' Pensions. I/we have carried out the agreed upon tests in Certification Instruction TP05 and obtained such evidence and explanations as I/we consider necessary."]
[null,"Name of firm",null,null,null,null,null,null,"Official Stamp"]
[]
[null,null,null,"`"]
[]
[]
[]
[]
[null,"Section 7: Audit Conclusion"]
[null,"Please indicate below your audit conclusion by ticking the appropriate box:"]
[null,"Assurance given",null,null,"Assurance not given",null,null,null,"We have attached our audit opinion dated:",null,null,"DDMMYYYY"]
[]
[]
[]
[null,"General Data Protection Regulation (GDPR). The Department for Education (DfE) will use any information you provide in connection with the Teachers’ Pension Scheme to administer and operate the scheme and pay benefits under it. This may include passing details to third parties that are involved in the administration and operation of the scheme. The DfE may also use your data for administrative purposes in line with its data protection notification. In order to fulfil its duty to protect public money, the DfE may use information it holds to prevent and detect fraud. It may also share information with other organisations that handle public funds. If there is any difference between the legislation governing the Teachers’ Pension Scheme and the information in this application form, the legislation will apply. For more information on how we will use your data, go to:"]
[null,{"$f":"HYPERLINK((\"https://www.teacherspensions.co.uk/public/privacy\"))","v":"https://www.teacherspensions.co.uk/public/privacy"}]
[null,"Please return to us at: "]
[null,"Teachers’ Pensions, 11b Lingfield Point, Darlington, DL1 1AX "]
[null,"www.teacherspensions.co.uk . "]