{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Personal Details TAB","2023-2024 Pay Details","Authorised Leave","Declaration"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Personal Details TAB","index":0,"n_rows":56,"n_cols":11,"rows_kept":56,"cut":false,"hidden":false,"merged":[[24,4,24,6],[44,4,45,4],[44,0,46,2],[53,0,54,8],[23,4,23,6],[26,0,27,2],[26,4,27,6],[44,5,45,7],[48,6,49,6],[39,3,39,5],[40,3,40,5],[41,3,41,5],[30,0,32,6],[35,0,35,2],[34,0,34,2],[36,0,36,2],[18,2,18,6],[20,4,20,6],[20,0,21,2],[0,0,5,8],[8,0,8,6],[10,2,10,6],[12,0,12,1],[12,2,16,6],[38,0,38,2],[39,0,39,2],[40,0,40,2],[41,0,41,2],[34,3,34,5],[35,3,35,5],[36,3,36,5],[37,3,37,5],[38,3,38,5],[37,0,37,2]]}
[null,null,null,null,null,null,null,null,null,null,"Salaried"]
[null,null,null,null,null,null,null,null,null,null,"Solo"]
[]
[]
[]
[]
["Type 2 medical practitioner  annual Self-Assessment form"]
[]
["To be fully completed by all Type 2 medical practitioner members"]
[]
["Full name",null,null,null,null,null,null,null,"A"]
[]
["Current address",null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
["Email address",null,null,null,null,null,null,null," "]
[]
["NHS Pension Scheme membership number",null,null,null,null,null,null,null,"B"]
[]
[]
["National Insurance number",null,null,null,null,null,null,null,"C"]
["GMC number"]
[]
["PCSE team (England) and/or LHB (Wales)",null,null,null,null,null,null,null,"D"]
[null,null,null,null,null,null,null,null," "]
[]
[]
["List the names and addresses and ODS codes of all GP practices, OOHPs, CCGs, ICB's and LHBs who you  worked for in England and Wales during 2023/24",null,null,null,null,null,null,null,"E"]
[]
[]
[]
["Name",null,null,"Address",null,null,"ODS Code","Income Type"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Were you a salaried GP on maternity / paternity / adoption / sick leave during 2023/24?",null,null,null,null,{"$f":"IF(E45=\"Yes\",\"Please ensure authorised leave tab is also completed\",\"\")","v":""},null,null,"F"]
[]
[]
[]
["Did you have an added years contract during 2023/24",null,null,null,null,null,null,null,"G"]
[]
[]
["If so please state the relevant % ",null,null,null,null,null,null,null,"H"]
[]
["The self-assessment form must be sent to PCSE (England) or the LHB (Wales) before 28 February 2025"]
[]
["Always retain a copy"]

{"sheet":"2023-2024 Pay Details","index":1,"n_rows":66,"n_cols":12,"rows_kept":66,"cut":false,"hidden":false,"merged":[[56,5,58,5],[2,0,3,2],[6,5,8,7],[46,1,49,3],[51,1,53,3],[19,1,22,3],[19,5,22,5],[24,1,26,3],[24,5,26,5],[28,1,30,3],[28,5,30,5],[51,5,54,5],[32,1,35,3],[32,5,35,5],[65,11,67,11],[65,5,67,5],[65,7,67,7],[65,9,67,9],[60,5,62,5],[37,1,39,3],[37,5,39,5],[41,5,44,5],[41,1,44,3],[65,1,67,3],[51,7,54,7],[51,9,54,9],[60,1,62,3],[56,1,58,3],[32,9,35,9],[37,7,39,7],[37,9,39,9],[41,7,44,7],[41,9,44,9],[2,5,3,5],[37,11,39,11],[28,11,30,11],[56,11,58,11],[24,7,26,7],[24,11,26,11],[32,11,35,11],[56,7,58,7],[46,9,49,9],[56,9,58,9],[24,9,26,9],[28,9,30,9],[46,5,49,5],[46,7,49,7],[32,7,35,7],[28,7,30,7]]}
[null,"NHS Pension Scheme year  2023/24: Type 2 medical practitioner annual self assessment form : 2023/24 Pensionable Pay"]
[]
["Please select correct contribution rate from drop down (Annualised rate where appropriate)"]
[]
[]
["Tier","From","To"]
[5.0999999999999997E-2,0,13246,null,null,"Please use annualisation calculator to determine the correct tiered contribution rate"]
[5.7000000000000002E-2,13247,17673]
[6.0999999999999999E-2,17674,24022]
[6.8000000000000005E-2,24023,25146]
[7.6999999999999999E-2,25147,29635]
[8.7999999999999995E-2,29636,30638]
[9.8000000000000004E-2,30639,45996]
[0.1,45997,51708]
[0.11600000000000001,51709,58972]
[0.125,58973,75632]
[0.13500000000000001,75633,"and over"]
[]
[null,null,null,null,null,"Total pensionable pay",null,"Conts already paid by the salaried GP",null,"Amount under / over paid by the salaried GP",null,"Conts already collected by PCSE/LHB"]
[null,"In box 1 state NHS pensionable income earned as a Type 1 medical practitioner/GP provider (GP partner/shareholder or single-hander) during 1 April 2023 to 31 March 2024. In box 1a state the employee contributions paid.",null,null,1]
[]
[]
[]
[]
[null,"In box 2 state your Type 2 medical practitioner (salaried GP)  NHS pensionable pay from your first practice named in box E (personal details tab). In box 2a state the employee contributions paid via deduction from salary by your employer. In box 2c state the employee contributions collected from your employer directly by PCSE/LHB",null,null,2,null,"2a",null,"2b",{"$f":"(F25*$F$3)-H25","v":0},"2c"]
[]
[]
[]
[null,"In box 2(i) state your Type 2 medical practitioner (salaried GP) NHS pensionable pay from your second practice named in box E. In box 2(i)a state the employee contributions paid via deduction from salary by your employer. In box 2(i)c state the employee contributions collected from your employer directly by PCSE/LHB",null,null,"2(i)",null,"2(i)a",null,"2(i)b",{"$f":"(F29*$F$3)-H29","v":0},"2(i)c"]
[]
[]
[]
[null,"In box 2(ii) state your Type 2 medical practitioner (salaried GP) NHS pensionable pay from your third practice named in box E. In box 2(ii)a state the employee contributions already paid via deduction from salary by your employer. In box 2(ii)c state the employee contributions collected from your employer directly by PCSE/LHB",null,null,"2(ii)",null,"2(ii)a",null,"2(ii)b",{"$f":"(F33*$F$3)-H33","v":0},"2(ii)c"]
[]
[]
[]
[]
[null,"In box 2(iii) state your Type 2 NHS pensionable pay from   any other practices named in box E (personal details tab) and in box 2(iii)a state the employee contributions already paid via deduction from salary by your employer. In box 2(iii)c state the employee contributions collected from your employer directly by PCSE/LHB",null,null,"2(iii)",null,"2(iii)a",null,"2(iii)b",{"$f":"(F38*$F$3)-H38","v":0},"2(iii)c"]
[]
[]
[]
[null,"In box 3 state your total pensionable income from your main Solo post (this includes OOHs, GPwSI, ICB, Appraisals, recorded on form Solo). In box 3a state the employee contributions paid. ",null,null,3,null,"3a",null,"3b",{"$f":"(F42*$F$3)-H42","v":0}]
[]
[]
[]
[]
[null,"In box 4 state your total pensionable income from any other Solo posts (for exampleOOHs, GPwSI, ICB, Appraisals). In  box 4a state the employee contributions paid.",null,null,4,null,"4a",null,"4b",{"$f":"(F47*$F$3)-H47","v":0}]
[]
[]
[]
[]
[null,"In box 5 state your total pensionable income from your freelance GP locum posts in 1 April 2023 to 31 March 2024.",null,null,5,null,"5a",null,"5b",{"$f":"(F52*$F$3)-H52","v":0}]
[]
[]
[]
[]
[null,"Box 6 is your total GP pensionable income for 1 April 2023 to 31 March 2024. Box 6a states your total employee contributions already paid during 2023/24. Box 6c states the toal employee contributions collected by PCSE/LHB from your employers ",null,null,6,{"$f":"SUM(F20:F55)","v":0},"6a",{"$f":"SUM(H20:H56)","v":0},"6b",{"$f":"SUM(J20:J56)","v":0},"6c",{"$f":"SUM(L25:L40)","v":0}]
[]
[]
[]
[null,"Total amount of NHS Additional Pension contributions due to be paid during 1 April 2023 to 31 March 2024 (does not include money purchase, free standing AVCs or Added Years contracts)",null,null,7]
[]
[]
[]
[]
[null,"Total amount of Added Years pension contributions due to be paid during 1 April 2023 to 31st March 2024 in box 8, amounts collected at source by your employers at box 8a, amounts paid to PCSE/LHB by your employers at box 8c",null,null,8,null,"8a",null,"8b",{"$f":"(F66*'Personal Details TAB'!$G$52)-H66","v":0},"8c"]

{"sheet":"Authorised Leave","index":2,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[5,7,7,7],[11,0,14,2],[11,5,13,5],[11,7,13,7],[2,0,3,9],[5,0,8,2],[5,5,7,5],[28,0,30,2],[28,5,30,5],[28,7,30,7],[17,0,20,2],[17,5,19,5],[17,7,19,7],[22,0,25,2],[22,5,24,5],[22,7,24,7]]}
["NHS Pension Scheme year 2023/24 authorised leave: Type 2 medical practitioner  annual self assessment form"]
[]
["This must only be completed where you have been on an authorised leave of absence (for example, maternity, paternity, adoption, or sick leave during 2023/24)"]
[]
[null,null,null,null,null,"Actual pensionable pay",null,"Employer pay (actual plus deemed pay)"]
["In box 1 state your actual Type 2 NHS pensionable pay received from your first practice named in box E (personal details tab) and what your employer (actual plus deemed pay) pay was during 2023/24 in box 1a",null,null,null,1,null,"1a"]
[]
[]
[]
[]
[]
["In box 2 state your actual Type 2 NHS pensionable pay from your second practice named in box E (personal details tab) and what your employer (actual plus deemed pay) pay was during 2023/24 in box 2a",null,null,null,2,null,"2a"]
[]
[]
[]
[]
[]
["In box 2(i) state your actual Type 2 NHS pensionable pay from your third practice named in box E (personal details tab) and what your employer (actual plus deemed pay) pay was during 2023/24 in box 2(i)a",null,null,null,"2(i)",null,"2(i)a"]
[]
[]
[]
[]
["In box 2(ii) state your actual Type 2 NHS pensionable pay from any other practices named in box E (personal details tab) and what your employer (actual plus deemed pay) pay was during 2023/24 in box 2(ii)a",null,null,null,"2(ii)",null,"2(ii)a"]
[]
[]
[]
[]
[]
["Box 3 is your total actual income for 2023/24 and box 3a states your total employer pay (including any deemed) during 2023/24",null,null,null,3,{"$f":"SUM(F6:F27)","v":0},"3a",{"$f":"SUM(H6:H27)","v":0}]

{"sheet":"Declaration","index":3,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Declaration"]
[]
["Note: Providing incorrect or false information may lead to investigation, prosecution, or referral to a regulatory body. \t"]
["I confirm that:"]
["• The total GP NHS pensionable income declared excludes private income.\n\n• The total GP NHS pensionable income declared  excludes officer income; that is, a salaried hospital doctor post.\n\t\t\n• If I have underpaid NHS Pension Scheme employee contributions I shall pay all the arrears over to NHSE/PCSE or the LHB via the relevant NHS body; for example, practice or OOHP.\n\n• If I have overpaid employee contributions I confirm that I have made arrangements to recover the overpaid contributions from each NHS body.\n\n• The information provided is correct and will be consistent (though may not be identical) with my HMRC tax return.\n\n• I have paid added years contributions (if relevant) on all my NHS pensionable income using the relevant forms; for example, Solo, Locum forms A and B.\n\n• I have paid my additional pension contributions (if relevant) through one nominated pensionable post.\n\n• By completing this form I am aware that if I have not settled any underpayment of contributions, my pensionable earnings for the year 2023/24 may be set to ‘zero’ (in accordance with the NHS Pension Scheme Regulations) even though I have already paid over contributions on account.\n\n• All the NHS pensionable income I have declared I have done so as an individual, not as a limited company or similar; that is, I have not incorporated."]
["Signature: "]
["Date: "]
["Name in capitals: "]
[]
["How we use your information\n \nThe NHS Business Services Authority – NHS Pensions will use the information provided for administering your NHS Pension Scheme membership and processing payment of your NHS pension benefits. We may share your information to administer and pay your NHS pension, enable us to prevent and detect fraud and mistakes, for debt collection purposes, or as required by law.  For more information about who we share your information with and how long we keep your personal data and your rights, please visit our website at www.nhsbsa.nhs.uk/yourinformation"]