{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Input","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Version control"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"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":"Input","index":0,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,2,34,9],[6,2,6,9],[17,2,17,9],[28,2,28,9],[4,3,4,4]]}
[]
[]
[null,null,"Gifts made as part of normal expenditure out of income"]
[]
[null,null,"Name of settlor/donor:"]
[null,null,"Tax year (end) in which gifts made ",2025,{"$f":"D6+1","v":2026},{"$f":"E6+1","v":2027},2028,2029,2030,2031]
[null,null,"Income (per annum)"]
[null,null,"Salary"]
[null,null,"Pensions"]
[null,null,"Interest (including ISAs)"]
[null,null,"Investments (dividends)"]
[null,null,"Rents"]
[null,null,"Annuities (income element)"]
[null,null,"Other"]
[null,null,"Minus Income Tax paid"]
[null,null,"Net Income",{"$f":"SUM(D8:D14)-D15","v":0},0,0,0,0,0,0]
[]
[null,null,"Expenditure (per annum)"]
[null,null,"Mortgages"]
[null,null,"Insurance"]
[null,null,"Household bills"]
[null,null,"Council Tax"]
[null,null,"Travelling Costs"]
[null,null,"Entertainment"]
[null,null,"Holidays"]
[null,null,"Nursing home fees"]
[null,null,"Other"]
[null,null,"Total expenditure",{"$f":"SUM(D19:D27)","v":0},{"$f":"SUM(E19:E27)","v":0},0,0,0,0,0]
[]
[null,null,"Surplus income for year",{"$f":"D16-D28","v":0},{"$f":"E16-E28","v":0},0,0,0,0,0]
[null,null,"Gifts made "]
[]
[]
[null,null,"IMPORTANT - No data entered into this tool is stored by Quilter. If a record of this is required please save a copy of this spreadsheet on your computer. "]

{"sheet":"Year 1","index":1,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,2,3,2],[33,2,33,3],[7,2,7,3],[18,2,18,3],[29,2,29,3],[4,2,4,3]]}
[]
[]
[null,null,{"$f":"\"Record of gifts for:\"&\" \"& Input!D5","v":"Record of gifts for: "}]
[]
[null,null,"This page can be printed to provide an audit trail of your income and expenditure for the year noted along with the gift made. This gift should be part of a 'regular' gifting pattern and must not result in a reduction in your standard of living. Your executors will require this information to enable them to claim the exemption using IHT403 form."]
[]
[null,null,"Tax year in which gifts made ",{"$f":"Input!$D$6","v":2025}]
[null,null,"Income"]
[null,null,{"$f":"Input!C8","v":"Salary"},{"$f":"IF(Input!D8=\"\",\"\",Input!D8)","v":""}]
[null,null,{"$f":"Input!C9","v":"Pensions"},{"$f":"IF(Input!D9=\"\",\"\",Input!D9)","v":""}]
[null,null,{"$f":"Input!C10","v":"Interest (including ISAs)"},{"$f":"IF(Input!D10=\"\",\"\",Input!D10)","v":""}]
[null,null,{"$f":"Input!C11","v":"Investments (dividends)"},{"$f":"IF(Input!D11=\"\",\"\",Input!D11)","v":""}]
[null,null,{"$f":"Input!C12","v":"Rents"},{"$f":"IF(Input!D12=\"\",\"\",Input!D12)","v":""}]
[null,null,{"$f":"Input!C13","v":"Annuities (income element)"},{"$f":"IF(Input!D13=\"\",\"\",Input!D13)","v":""}]
[null,null,{"$f":"Input!C14","v":"Other"},{"$f":"IF(Input!D14=\"\",\"\",Input!D14)","v":""}]
[null,null,{"$f":"Input!C15","v":"Minus Income Tax paid"},{"$f":"IF(Input!D15=\"\",\"\",Input!D15)","v":""}]
[null,null,"Net Income",{"$f":"IFERROR(SUM(D9:D15)-D16,0)","v":0}]
[]
[null,null,"Expenditure"]
[null,null,{"$f":"Input!C19","v":"Mortgages"},{"$f":"IF(Input!D19=\"\",\"\",Input!D19)","v":""}]
[null,null,{"$f":"Input!C20","v":"Insurance"},{"$f":"IF(Input!D20=\"\",\"\",Input!D20)","v":""}]
[null,null,{"$f":"Input!C21","v":"Household bills"},{"$f":"IF(Input!D21=\"\",\"\",Input!D21)","v":""}]
[null,null,{"$f":"Input!C22","v":"Council Tax"},{"$f":"IF(Input!D22=\"\",\"\",Input!D22)","v":""}]
[null,null,"Travelling Costs",{"$f":"IF(Input!D23=\"\",\"\",Input!D23)","v":""}]
[null,null,{"$f":"Input!C24","v":"Entertainment"},{"$f":"IF(Input!D24=\"\",\"\",Input!D24)","v":""}]
[null,null,{"$f":"Input!C25","v":"Holidays"},{"$f":"IF(Input!D25=\"\",\"\",Input!D25)","v":""}]
[null,null,{"$f":"Input!C26","v":"Nursing home fees"},{"$f":"IF(Input!D26=\"\",\"\",Input!D26)","v":""}]
[null,null,{"$f":"Input!C27","v":"Other"},{"$f":"IF(Input!D27=\"\",\"\",Input!D27)","v":""}]
[null,null,"Total expenditure",{"$f":"IFERROR(SUM(D20:D28),0)","v":0}]
[]
[null,null,"Surplus income for year",{"$f":"D17-D29","v":0}]
[null,null,"Gifts made ",{"$f":"Input!D31","v":0}]
[]
[null,null,"Although keeping an audit of income and expenditure increases the chance of these gifts being considered exempt, gifts within 7 years of death must be declared by your executors using IHT403 and are subject to acceptance of HM Revenue and Customs. This document is based on Quilter's interpretation of the law and HM Revenue and Customs practice as at November 2024. We believe this interpretation is correct, but cannot guarantee it. Tax relief and the tax treatment of investment funds may change.\n "]

{"sheet":"Year 2","index":2,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,2,33,3],[2,2,3,2],[4,2,4,3],[7,2,7,3],[18,2,18,3],[29,2,29,3]]}
[]
[]
[null,null,{"$f":"\"Record of gifts for:\"&\" \"& Input!D5","v":"Record of gifts for: "}]
[]
[null,null,"This page can be printed to provide an audit trail of your income and expenditure for the year noted along with the gift made. This gift should be part of a 'regular' gifting pattern and must not result in a reduction in your standard of living. Your executors will require this information to enable them to claim the exemption using IHT403 form."]
[]
[null,null,"Tax year in which gifts made ",{"$f":"Input!$E$6","v":2026}]
[null,null,"Income"]
[null,null,{"$f":"Input!C8","v":"Salary"},{"$f":"IF(Input!E8=\"\",\"\",Input!E8)","v":""}]
[null,null,{"$f":"Input!C9","v":"Pensions"},{"$f":"IF(Input!E9=\"\",\"\",Input!E9)","v":""}]
[null,null,{"$f":"Input!C10","v":"Interest (including ISAs)"},{"$f":"IF(Input!E10=\"\",\"\",Input!E10)","v":""}]
[null,null,{"$f":"Input!C11","v":"Investments (dividends)"},{"$f":"IF(Input!E11=\"\",\"\",Input!E11)","v":""}]
[null,null,{"$f":"Input!C12","v":"Rents"},{"$f":"IF(Input!E12=\"\",\"\",Input!E12)","v":""}]
[null,null,{"$f":"Input!C13","v":"Annuities (income element)"},{"$f":"IF(Input!E13=\"\",\"\",Input!E13)","v":""}]
[null,null,{"$f":"Input!C14","v":"Other"},{"$f":"IF(Input!E14=\"\",\"\",Input!E14)","v":""}]
[null,null,{"$f":"Input!C15","v":"Minus Income Tax paid"},{"$f":"IF(Input!E15=\"\",\"\",Input!E15)","v":""}]
[null,null,"Net Income",{"$f":"IFERROR(SUM(D9:D15)-D16,0)","v":0}]
[]
[null,null,"Expenditure"]
[null,null,{"$f":"Input!C19","v":"Mortgages"},{"$f":"IF(Input!E19=\"\",\"\",Input!E19)","v":""}]
[null,null,{"$f":"Input!C20","v":"Insurance"},{"$f":"IF(Input!E20=\"\",\"\",Input!E20)","v":""}]
[null,null,{"$f":"Input!C21","v":"Household bills"},{"$f":"IF(Input!E21=\"\",\"\",Input!E21)","v":""}]
[null,null,{"$f":"Input!C22","v":"Council Tax"},{"$f":"IF(Input!E22=\"\",\"\",Input!E22)","v":""}]
[null,null,"Travelling Costs",{"$f":"IF(Input!E23=\"\",\"\",Input!E23)","v":""}]
[null,null,{"$f":"Input!C24","v":"Entertainment"},{"$f":"IF(Input!E24=\"\",\"\",Input!E24)","v":""}]
[null,null,{"$f":"Input!C25","v":"Holidays"},{"$f":"IF(Input!E25=\"\",\"\",Input!E25)","v":""}]
[null,null,{"$f":"Input!C26","v":"Nursing home fees"},{"$f":"IF(Input!E26=\"\",\"\",Input!E26)","v":""}]
[null,null,{"$f":"Input!C27","v":"Other"},{"$f":"IF(Input!E27=\"\",\"\",Input!E27)","v":""}]
[null,null,"Total expenditure",{"$f":"IFERROR(SUM(D20:D28),0)","v":0}]
[]
[null,null,"Surplus income for year",{"$f":"D17-D29","v":0}]
[null,null,"Gifts made ",{"$f":"Input!E31","v":0}]
[]
[null,null,"Although keeping an audit of income and expenditure increases the chance of these gifts being considered exempt, gifts within 7 years of death must be declared by your executors using IHT403 and are subject to acceptance of HM Revenue and Customs. This document is based on Quilter's interpretation of the law and HM Revenue and Customs practice as at November 2024. We believe this interpretation is correct, but cannot guarantee it. Tax relief and the tax treatment of investment funds may change.\n "]

{"sheet":"Year 3","index":3,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,2,33,3],[2,2,3,2],[4,2,4,3],[7,2,7,3],[18,2,18,3],[29,2,29,3]]}
[]
[]
[null,null,{"$f":"\"Record of gifts for:\"&\" \"& Input!D5","v":"Record of gifts for: "}]
[]
[null,null,"This page can be printed to provide an audit trail of your income and expenditure for the year noted along with the gift made. This gift should be part of a 'regular' gifting pattern and must not result in a reduction in your standard of living. Your executors will require this information to enable them to claim the exemption using IHT403 form."]
[]
[null,null,"Tax year in which gifts made ",{"$f":"Input!$F$6","v":2027}]
[null,null,"Income"]
[null,null,{"$f":"Input!C8","v":"Salary"},{"$f":"IF(Input!F8=\"\",\"\",Input!F8)","v":""}]
[null,null,{"$f":"Input!C9","v":"Pensions"},{"$f":"IF(Input!F9=\"\",\"\",Input!F9)","v":""}]
[null,null,{"$f":"Input!C10","v":"Interest (including ISAs)"},{"$f":"IF(Input!F10=\"\",\"\",Input!F10)","v":""}]
[null,null,{"$f":"Input!C11","v":"Investments (dividends)"},{"$f":"IF(Input!F11=\"\",\"\",Input!F11)","v":""}]
[null,null,{"$f":"Input!C12","v":"Rents"},{"$f":"IF(Input!F12=\"\",\"\",Input!F12)","v":""}]
[null,null,{"$f":"Input!C13","v":"Annuities (income element)"},{"$f":"IF(Input!F13=\"\",\"\",Input!F13)","v":""}]
[null,null,{"$f":"Input!C14","v":"Other"},{"$f":"IF(Input!F14=\"\",\"\",Input!F14)","v":""}]
[null,null,{"$f":"Input!C15","v":"Minus Income Tax paid"},{"$f":"IF(Input!F15=\"\",\"\",Input!F15)","v":""}]
[null,null,"Net Income",{"$f":"IFERROR(SUM(D9:D15)-D16,0)","v":0}]
[]
[null,null,"Expenditure"]
[null,null,{"$f":"Input!C19","v":"Mortgages"},{"$f":"IF(Input!F19=\"\",\"\",Input!F19)","v":""}]
[null,null,{"$f":"Input!C20","v":"Insurance"},{"$f":"IF(Input!F20=\"\",\"\",Input!F20)","v":""}]
[null,null,{"$f":"Input!C21","v":"Household bills"},{"$f":"IF(Input!F21=\"\",\"\",Input!F21)","v":""}]
[null,null,{"$f":"Input!C22","v":"Council Tax"},{"$f":"IF(Input!F22=\"\",\"\",Input!F22)","v":""}]
[null,null,"Travelling Costs",{"$f":"IF(Input!F23=\"\",\"\",Input!F23)","v":""}]
[null,null,{"$f":"Input!C24","v":"Entertainment"},{"$f":"IF(Input!F24=\"\",\"\",Input!F24)","v":""}]
[null,null,{"$f":"Input!C25","v":"Holidays"},{"$f":"IF(Input!F25=\"\",\"\",Input!F25)","v":""}]
[null,null,{"$f":"Input!C26","v":"Nursing home fees"},{"$f":"IF(Input!F26=\"\",\"\",Input!F26)","v":""}]
[null,null,{"$f":"Input!C27","v":"Other"},{"$f":"IF(Input!F27=\"\",\"\",Input!F27)","v":""}]
[null,null,"Total expenditure",{"$f":"IFERROR(SUM(D20:D28),0)","v":0}]
[]
[null,null,"Surplus income for year",{"$f":"D17-D29","v":0}]
[null,null,"Gifts made ",{"$f":"Input!F31","v":0}]
[]
[null,null,"Although keeping an audit of income and expenditure increases the chance of these gifts being considered exempt, gifts within 7 years of death must be declared by your executors using IHT403 and are subject to acceptance of HM Revenue and Customs. This document is based on Quilter's interpretation of the law and HM Revenue and Customs practice as at November 2024. We believe this interpretation is correct, but cannot guarantee it. Tax relief and the tax treatment of investment funds may change.\n "]

{"sheet":"Year 4","index":4,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,2,33,3],[2,2,3,2],[4,2,4,3],[7,2,7,3],[18,2,18,3],[29,2,29,3]]}
[]
[]
[null,null,{"$f":"\"Record of gifts for:\"&\" \"& Input!D5","v":"Record of gifts for: "}]
[]
[null,null,"This page can be printed to provide an audit trail of your income and expenditure for the year noted along with the gift made. This gift should be part of a 'regular' gifting pattern and must not result in a reduction in your standard of living. Your executors will require this information to enable them to claim the exemption using IHT403 form."]
[]
[null,null,"Tax year in which gifts made ",{"$f":"Input!$G$6","v":2028}]
[null,null,"Income"]
[null,null,{"$f":"Input!C8","v":"Salary"},{"$f":"IF(Input!G8=\"\",\"\",Input!G8)","v":""}]
[null,null,{"$f":"Input!C9","v":"Pensions"},{"$f":"IF(Input!G9=\"\",\"\",Input!G9)","v":""}]
[null,null,{"$f":"Input!C10","v":"Interest (including ISAs)"},{"$f":"IF(Input!G10=\"\",\"\",Input!G10)","v":""}]
[null,null,{"$f":"Input!C11","v":"Investments (dividends)"},{"$f":"IF(Input!G11=\"\",\"\",Input!G11)","v":""}]
[null,null,{"$f":"Input!C12","v":"Rents"},{"$f":"IF(Input!G12=\"\",\"\",Input!G12)","v":""}]
[null,null,{"$f":"Input!C13","v":"Annuities (income element)"},{"$f":"IF(Input!G13=\"\",\"\",Input!G13)","v":""}]
[null,null,{"$f":"Input!C14","v":"Other"},{"$f":"IF(Input!G14=\"\",\"\",Input!G14)","v":""}]
[null,null,{"$f":"Input!C15","v":"Minus Income Tax paid"},{"$f":"IF(Input!G15=\"\",\"\",Input!G15)","v":""}]
[null,null,"Net Income",{"$f":"IFERROR(SUM(D9:D15)-D16,0)","v":0}]
[]
[null,null,"Expenditure"]
[null,null,{"$f":"Input!C19","v":"Mortgages"},{"$f":"IF(Input!G19=\"\",\"\",Input!G19)","v":""}]
[null,null,{"$f":"Input!C20","v":"Insurance"},{"$f":"IF(Input!G20=\"\",\"\",Input!G20)","v":""}]
[null,null,{"$f":"Input!C21","v":"Household bills"},{"$f":"IF(Input!G21=\"\",\"\",Input!G21)","v":""}]
[null,null,{"$f":"Input!C22","v":"Council Tax"},{"$f":"IF(Input!G22=\"\",\"\",Input!G22)","v":""}]
[null,null,"Travelling Costs",{"$f":"IF(Input!G23=\"\",\"\",Input!G23)","v":""}]
[null,null,{"$f":"Input!C24","v":"Entertainment"},{"$f":"IF(Input!G24=\"\",\"\",Input!G24)","v":""}]
[null,null,{"$f":"Input!C25","v":"Holidays"},{"$f":"IF(Input!G25=\"\",\"\",Input!G25)","v":""}]
[null,null,{"$f":"Input!C26","v":"Nursing home fees"},{"$f":"IF(Input!G26=\"\",\"\",Input!G26)","v":""}]
[null,null,{"$f":"Input!C27","v":"Other"},{"$f":"IF(Input!G27=\"\",\"\",Input!G27)","v":""}]
[null,null,"Total expenditure",{"$f":"IFERROR(SUM(D20:D28),0)","v":0}]
[]
[null,null,"Surplus income for year",{"$f":"D17-D29","v":0}]
[null,null,"Gifts made ",{"$f":"Input!G31","v":0}]
[]
[null,null,"Although keeping an audit of income and expenditure increases the chance of these gifts being considered exempt, gifts within 7 years of death must be declared by your executors using IHT403 and are subject to acceptance of HM Revenue and Customs. This document is based on Quilter's interpretation of the law and HM Revenue and Customs practice as at November 2024. We believe this interpretation is correct, but cannot guarantee it. Tax relief and the tax treatment of investment funds may change.\n "]

{"sheet":"Year 5","index":5,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,2,33,3],[2,2,3,2],[4,2,4,3],[7,2,7,3],[18,2,18,3],[29,2,29,3]]}
[]
[]
[null,null,{"$f":"\"Record of gifts for:\"&\" \"& Input!D5","v":"Record of gifts for: "}]
[]
[null,null,"This page can be printed to provide an audit trail of your income and expenditure for the year noted along with the gift made. This gift should be part of a 'regular' gifting pattern and must not result in a reduction in your standard of living. Your executors will require this information to enable them to claim the exemption using IHT403 form."]
[]
[null,null,"Tax year in which gifts made ",{"$f":"Input!$H$6","v":2029}]
[null,null,"Income"]
[null,null,{"$f":"Input!C8","v":"Salary"},{"$f":"IF(Input!H8=\"\",\"\",Input!H8)","v":""}]
[null,null,{"$f":"Input!C9","v":"Pensions"},{"$f":"IF(Input!H9=\"\",\"\",Input!H9)","v":""}]
[null,null,{"$f":"Input!C10","v":"Interest (including ISAs)"},{"$f":"IF(Input!H10=\"\",\"\",Input!H10)","v":""}]
[null,null,{"$f":"Input!C11","v":"Investments (dividends)"},{"$f":"IF(Input!H11=\"\",\"\",Input!H11)","v":""}]
[null,null,{"$f":"Input!C12","v":"Rents"},{"$f":"IF(Input!H12=\"\",\"\",Input!H12)","v":""}]
[null,null,{"$f":"Input!C13","v":"Annuities (income element)"},{"$f":"IF(Input!H13=\"\",\"\",Input!H13)","v":""}]
[null,null,{"$f":"Input!C14","v":"Other"},{"$f":"IF(Input!H14=\"\",\"\",Input!H14)","v":""}]
[null,null,{"$f":"Input!C15","v":"Minus Income Tax paid"},{"$f":"IF(Input!H15=\"\",\"\",Input!H15)","v":""}]
[null,null,"Net Income",{"$f":"IFERROR(SUM(D9:D15)-D16,0)","v":0}]
[]
[null,null,"Expenditure"]
[null,null,{"$f":"Input!C19","v":"Mortgages"},{"$f":"IF(Input!H19=\"\",\"\",Input!H19)","v":""}]
[null,null,{"$f":"Input!C20","v":"Insurance"},{"$f":"IF(Input!H20=\"\",\"\",Input!H20)","v":""}]
[null,null,{"$f":"Input!C21","v":"Household bills"},{"$f":"IF(Input!H21=\"\",\"\",Input!H21)","v":""}]
[null,null,{"$f":"Input!C22","v":"Council Tax"},{"$f":"IF(Input!H22=\"\",\"\",Input!H22)","v":""}]
[null,null,"Travelling Costs",{"$f":"IF(Input!H23=\"\",\"\",Input!H23)","v":""}]
[null,null,{"$f":"Input!C24","v":"Entertainment"},{"$f":"IF(Input!H24=\"\",\"\",Input!H24)","v":""}]
[null,null,{"$f":"Input!C25","v":"Holidays"},{"$f":"IF(Input!H25=\"\",\"\",Input!H25)","v":""}]
[null,null,{"$f":"Input!C26","v":"Nursing home fees"},{"$f":"IF(Input!H26=\"\",\"\",Input!H26)","v":""}]
[null,null,{"$f":"Input!C27","v":"Other"},{"$f":"IF(Input!H27=\"\",\"\",Input!H27)","v":""}]
[null,null,"Total expenditure",{"$f":"IFERROR(SUM(D20:D28),0)","v":0}]
[]
[null,null,"Surplus income for year",{"$f":"D17-D29","v":0}]
[null,null,"Gifts made ",{"$f":"Input!H31","v":0}]
[]
[null,null,"Although keeping an audit of income and expenditure increases the chance of these gifts being considered exempt, gifts within 7 years of death must be declared by your executors using IHT403 and are subject to acceptance of HM Revenue and Customs. This document is based on Quilter's interpretation of the law and HM Revenue and Customs practice as at November 2024. We believe this interpretation is correct, but cannot guarantee it. Tax relief and the tax treatment of investment funds may change.\n "]

{"sheet":"Year 6","index":6,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,2,33,3],[2,2,3,2],[4,2,4,3],[7,2,7,3],[18,2,18,3],[29,2,29,3]]}
[]
[]
[null,null,{"$f":"\"Record of gifts for:\"&\" \"& Input!D5","v":"Record of gifts for: "}]
[]
[null,null,"This page can be printed to provide an audit trail of your income and expenditure for the year noted along with the gift made. This gift should be part of a 'regular' gifting pattern and must not result in a reduction in your standard of living. Your executors will require this information to enable them to claim the exemption using IHT403 form."]
[]
[null,null,"Tax year in which gifts made ",{"$f":"Input!$I$6","v":2030}]
[null,null,"Income"]
[null,null,{"$f":"Input!C8","v":"Salary"},{"$f":"IF(Input!I8=\"\",\"\",Input!I8)","v":""}]
[null,null,{"$f":"Input!C9","v":"Pensions"},{"$f":"IF(Input!I9=\"\",\"\",Input!I9)","v":""}]
[null,null,{"$f":"Input!C10","v":"Interest (including ISAs)"},{"$f":"IF(Input!I10=\"\",\"\",Input!I10)","v":""}]
[null,null,{"$f":"Input!C11","v":"Investments (dividends)"},{"$f":"IF(Input!I11=\"\",\"\",Input!I11)","v":""}]
[null,null,{"$f":"Input!C12","v":"Rents"},{"$f":"IF(Input!I12=\"\",\"\",Input!I12)","v":""}]
[null,null,{"$f":"Input!C13","v":"Annuities (income element)"},{"$f":"IF(Input!I13=\"\",\"\",Input!I13)","v":""}]
[null,null,{"$f":"Input!C14","v":"Other"},{"$f":"IF(Input!I14=\"\",\"\",Input!I14)","v":""}]
[null,null,{"$f":"Input!C15","v":"Minus Income Tax paid"},{"$f":"IF(Input!I15=\"\",\"\",Input!I15)","v":""}]
[null,null,"Net Income",{"$f":"IFERROR(SUM(D9:D15)-D16,0)","v":0}]
[]
[null,null,"Expenditure"]
[null,null,{"$f":"Input!C19","v":"Mortgages"},{"$f":"IF(Input!I19=\"\",\"\",Input!I19)","v":""}]
[null,null,{"$f":"Input!C20","v":"Insurance"},{"$f":"IF(Input!I20=\"\",\"\",Input!I20)","v":""}]
[null,null,{"$f":"Input!C21","v":"Household bills"},{"$f":"IF(Input!I21=\"\",\"\",Input!I21)","v":""}]
[null,null,{"$f":"Input!C22","v":"Council Tax"},{"$f":"IF(Input!I22=\"\",\"\",Input!I22)","v":""}]
[null,null,"Travelling Costs",{"$f":"IF(Input!I23=\"\",\"\",Input!I23)","v":""}]
[null,null,{"$f":"Input!C24","v":"Entertainment"},{"$f":"IF(Input!I24=\"\",\"\",Input!I24)","v":""}]
[null,null,{"$f":"Input!C25","v":"Holidays"},{"$f":"IF(Input!I25=\"\",\"\",Input!I25)","v":""}]
[null,null,{"$f":"Input!C26","v":"Nursing home fees"},{"$f":"IF(Input!I26=\"\",\"\",Input!I26)","v":""}]
[null,null,{"$f":"Input!C27","v":"Other"},{"$f":"IF(Input!I27=\"\",\"\",Input!I27)","v":""}]
[null,null,"Total expenditure",{"$f":"IFERROR(SUM(D20:D28),0)","v":0}]
[]
[null,null,"Surplus income for year",{"$f":"D17-D29","v":0}]
[null,null,"Gifts made ",{"$f":"Input!I31","v":0}]
[]
[null,null,"Although keeping an audit of income and expenditure increases the chance of these gifts being considered exempt, gifts within 7 years of death must be declared by your executors using IHT403 and are subject to acceptance of HM Revenue and Customs. This document is based on Quilter's interpretation of the law and HM Revenue and Customs practice as at November 2024. We believe this interpretation is correct, but cannot guarantee it. Tax relief and the tax treatment of investment funds may change.\n "]

{"sheet":"Year 7","index":7,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,2,33,3],[2,2,3,2],[4,2,4,3],[7,2,7,3],[18,2,18,3],[29,2,29,3]]}
[]
[]
[null,null,{"$f":"\"Record of gifts for:\"&\" \"& Input!D5","v":"Record of gifts for: "}]
[]
[null,null,"This page can be printed to provide an audit trail of your income and expenditure for the year noted along with the gift made. This gift should be part of a 'regular' gifting pattern and must not result in a reduction in your standard of living. Your executors will require this information to enable them to claim the exemption using IHT403 form."]
[]
[null,null,"Tax year in which gifts made ",{"$f":"Input!$J$6","v":2031}]
[null,null,"Income"]
[null,null,{"$f":"Input!C8","v":"Salary"},{"$f":"IF(Input!J8=\"\",\"\",Input!J8)","v":""}]
[null,null,{"$f":"Input!C9","v":"Pensions"},{"$f":"IF(Input!J9=\"\",\"\",Input!J9)","v":""}]
[null,null,{"$f":"Input!C10","v":"Interest (including ISAs)"},{"$f":"IF(Input!J10=\"\",\"\",Input!J10)","v":""}]
[null,null,{"$f":"Input!C11","v":"Investments (dividends)"},{"$f":"IF(Input!J11=\"\",\"\",Input!J11)","v":""}]
[null,null,{"$f":"Input!C12","v":"Rents"},{"$f":"IF(Input!J12=\"\",\"\",Input!J12)","v":""}]
[null,null,{"$f":"Input!C13","v":"Annuities (income element)"},{"$f":"IF(Input!J13=\"\",\"\",Input!J13)","v":""}]
[null,null,{"$f":"Input!C14","v":"Other"},{"$f":"IF(Input!J14=\"\",\"\",Input!J14)","v":""}]
[null,null,{"$f":"Input!C15","v":"Minus Income Tax paid"},{"$f":"IF(Input!J15=\"\",\"\",Input!J15)","v":""}]
[null,null,"Net Income",{"$f":"IFERROR(SUM(D9:D15)-D16,0)","v":0}]
[]
[null,null,"Expenditure"]
[null,null,{"$f":"Input!C19","v":"Mortgages"},{"$f":"IF(Input!J19=\"\",\"\",Input!J19)","v":""}]
[null,null,{"$f":"Input!C20","v":"Insurance"},{"$f":"IF(Input!J20=\"\",\"\",Input!J20)","v":""}]
[null,null,{"$f":"Input!C21","v":"Household bills"},{"$f":"IF(Input!J21=\"\",\"\",Input!J21)","v":""}]
[null,null,{"$f":"Input!C22","v":"Council Tax"},{"$f":"IF(Input!J22=\"\",\"\",Input!J22)","v":""}]
[null,null,"Travelling Costs",{"$f":"IF(Input!J23=\"\",\"\",Input!J23)","v":""}]
[null,null,{"$f":"Input!C24","v":"Entertainment"},{"$f":"IF(Input!J24=\"\",\"\",Input!J24)","v":""}]
[null,null,{"$f":"Input!C25","v":"Holidays"},{"$f":"IF(Input!J25=\"\",\"\",Input!J25)","v":""}]
[null,null,{"$f":"Input!C26","v":"Nursing home fees"},{"$f":"IF(Input!J26=\"\",\"\",Input!J26)","v":""}]
[null,null,{"$f":"Input!C27","v":"Other"},{"$f":"IF(Input!J27=\"\",\"\",Input!J27)","v":""}]
[null,null,"Total expenditure",{"$f":"IFERROR(SUM(D20:D28),0)","v":0}]
[]
[null,null,"Surplus income for year",{"$f":"D17-D29","v":0}]
[null,null,"Gifts made ",{"$f":"Input!J31","v":0}]
[]
[null,null,"Although keeping an audit of income and expenditure increases the chance of these gifts being considered exempt, gifts within 7 years of death must be declared by your executors using IHT403 and are subject to acceptance of HM Revenue and Customs. This document is based on Quilter's interpretation of the law and HM Revenue and Customs practice as at November 2024. We believe this interpretation is correct, but cannot guarantee it. Tax relief and the tax treatment of investment funds may change.\n "]

{"sheet":"Version control","index":8,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Version ","Date","Notes"]
["V2","2024-11-01","Updated look and feel"]