{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Welcome","Inputs","Numerical Updates","Notes","Error Page","Comments"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"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":"Welcome","index":0,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
["Tapered Annual Allowance Calculator - Welcome"]
[]
[]
[]
["Excel requirements"]
["To use this tool you will need to click any “Enable Editing” or “Enable Content” pop up message. \nIf you receive an error message stating “Cannot run the macro… “  then press F1 to search how to enable macros."]
[]
["Calculator outcome"]
["The accuracy of the results will depend on the accuracy of the information provided. We have assumed that your client is a relevant UK individual."]
["This calculator cannot account for every scenario so if further assistance is needed please phone our pensions technical team on 02380 726 010 option 1. Calls are recorded for training purposes and to avoid misunderstandings."]
[]
["Guidance"]
["We recommend you read HMRC's guidance on the tapered annual allowance at -"]
[]
[]
["For our summary on the tapered annual allowance, please read"]
[]
[]
["Legal"]

{"sheet":"Inputs","index":1,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,2,9,4],[9,1,10,1],[9,0,10,0],[5,8,5,10],[4,0,4,5],[5,0,5,5],[4,8,4,10],[9,5,10,5],[9,6,10,6],[9,8,10,8],[9,9,10,9],[9,10,10,10]]}
[]
[null,null,null,null,null,null,null,null,null,null,"Tapered Annual Allowance Calculator - Inputs"]
[]
[]
[{"$f":"commentsHeading","v":"1) Net income"}]
[{"$f":"IF(comments=\"\",\"\",comments)","v":"In general, this will be a person’s total taxable income. It will be made up of things like salary, benefits in kind, dividends, rental income. It will not include things like salary sacrifice, net pay arrangements or the first £30,000 of a redundancy payment as these are not taxable.\n\nIf your client has complicated finances, you may need to refer them to their accountant to work out the net income. The definition in legislation is ‘net income for the tax year is calculated under steps 1 and 2 of section 23 of the Income Tax Act 2007’.\n"}]
[]
["As you select each field, the box above on the left will change to give information about what to key in that field."]
[]
["1) Net income","2) Salary sacrifice or flexible remuneration","Money purchase schemes",null,null,"6) Defined benefit or cash balance pension input","7) Taxable lump sum death benefit",null,"Threshold income","Adjusted income","Applicable annual allowance"]
[null,null,"3) Relief at source contributions","4) Net pay arrangement or other reliefs","5) Employer contributions"]
[null,null,null,null,null,null,null,null,{"$f":"MAX(A12+B12-C12-G12,0)","v":0},{"$f":"A12+D12+E12+F12-G12","v":0},{"$f":"AA-IF(I12>Threshold,MIN(MAX(INT((J12-Adjusted)/2),0),TaperReduc))","v":40000}]

{"sheet":"Numerical Updates","index":2,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,null,"Cell name"]
["Annual Allowance",40000,"AA"]
["Threshold income",200000,"Threshold"]
["Adjusted income",240000,"Adjusted"]
["Taper minimum",4000,"TaperMin"]
["Max reduction in taper",{"$f":"B2-B5","v":36000},"TaperReduc"]

{"sheet":"Notes","index":3,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["Tapered Annual Allowance Calculator - Notes"]

{"sheet":"Error Page","index":4,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[64,1,64,7],[9,2,9,3],[10,2,10,4],[16,2,16,6]]}
[]
[null,null,null,null,null,null,null,"Maximum Contribution Calculator - Error"]
[]
[]
[null,null,"We are sorry but an error has occurred with this tool."]
[null,null,"Error code: ",1004]
[null,null,"Things you should try:"]
[null,null,"Please reopen this tool from our website."]
[null,null,"When using this tool please ensure that:"]
[null,null,"1. Macros are enabled"]
[null,null,"2. Protected view is disabled"]
[null,null,"Please view the Excel Help files (press F1) or  for further information about how to do this"]
[]
[null,null,"Please note that this tool has been tested on Windows 10, Microsoft 365 for enterprise."]
[null,null,"Compatibility with other operating systems or versions of Excel or is not guaranteed."]
[]
[null,null,"If you are still experiencing problems using this tool, please contact technicalsolutionspensions@quilter.com"]

{"sheet":"Comments","index":5,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Inputs!A10","v":"1) Net income"},{"$f":"Inputs!B10","v":"2) Salary sacrifice or flexible remuneration"},{"$f":"Inputs!C11","v":"3) Relief at source contributions"},{"$f":"Inputs!D11","v":"4) Net pay arrangement or other reliefs"},{"$f":"Inputs!E11","v":"5) Employer contributions"},{"$f":"Inputs!F10","v":"6) Defined benefit or cash balance pension input"},{"$f":"Inputs!G10","v":"7) Taxable lump sum death benefit"}]
["In general, this will be a person’s total taxable income. It will be made up of things like salary, benefits in kind, dividends, rental income. It will not include things like salary sacrifice, net pay arrangements or the first £30,000 of a redundancy payment as these are not taxable.\n\nIf your client has complicated finances, you may need to refer them to their accountant to work out the net income. The definition in legislation is ‘net income for the tax year is calculated under steps 1 and 2 of section 23 of the Income Tax Act 2007’.\n","If your client has made a pension contribution via a new salary sacrifice or flexible remuneration arrangement that started on or after 9 July 2015, you need to add the value of the sacrifice/flexible remuneration here.\n\nThis may include agreements that have to be agreed each year or any increases made to a long standing agreement after 8th July 2015.\n\nDon’t forget that as this value will now be paid by the employer as a pension contribution instead of being paid to your client, it needs to be included in the employer contribution box too.\n","This is where the pension scheme adds 20% tax relief to any personal contributions that are made on behalf of a member. \n\nEnter the total gross contributions made via relief at source to a UK or overseas pension scheme.","A net pay arrangement is where a pension contribution is deducted from a person’s gross salary. This means they get tax relief by way of not paying income tax in the first place. This is common for defined benefit schemes and auto enrolment schemes. A net pay arrangement is different to a salary sacrifice because the employer and employee still have to pay national insurance on the amount deducted.\n\nIt is possible for your client to make a separate claim for tax relief from HMRC if a scheme cannot offer any or enough tax relief.  Details can be found on the www.gov.uk website, search for ptm044240.\n\nEnter the gross:\n• contribution that relates to a net pay arrangement. \n• amount of a claim for excess relief for a net pay arrangement.\n• contribution where a claim is made for tax relief because the pension scheme does not offer any or enough tax relief.\n","Enter the gross employer contributions made to a UK pension scheme.\n\nEnter the gross employer contributions made to an overseas pension scheme where contributions for a member started before 6 April 2006 which corresponds with a UK registered pension scheme.\n\nDon’t forget that if your client has a salary sacrifice or flexible remuneration arrangement, this needs to be included here.","Enter the pension input for any defined benefit or cash balance scheme.\nThe input amount for a defined benefit or cash balance is not the total contributions into the scheme, instead it relates to the increase in benefits within the scheme.\n\nFor information on how to work out the pension input please see the below sites.\n\nDefined benefit: Go to www.gov.uk website, search for ptm053301\n\nCash balance: Go to www.gov.uk website, search for ptm053400\n\n\n","Enter the value of any lump sum death benefit paid from a pension scheme that was taxable.\n\nFor details of which lump sum death benefits are taxable please go to www.gov.uk website, search for ptm073010\n"]
[]
["1) Net income"]
["In general, this will be a person’s total taxable income. It will be made up of things like salary, benefits in kind, dividends, rental income. It will not include things like salary sacrifice, net pay arrangements or the first £30,000 of a redundancy payment as these are not taxable.\n\nIf your client has complicated finances, you may need to refer them to their accountant to work out the net income. The definition in legislation is ‘net income for the tax year is calculated under steps 1 and 2 of section 23 of the Income Tax Act 2007’.\n"]