{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","Input","Sheet2","Sheet3","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7"],"not_rendered":{"charts":0,"images":8,"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":"Instructions","index":0,"n_rows":75,"n_cols":3,"rows_kept":75,"cut":false,"hidden":false,"merged":[[7,2,8,8],[74,2,75,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"Input","index":1,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[4,1,4,8],[15,1,15,8],[26,1,26,8],[2,2,2,3],[31,2,32,8]]}
[]
[null,"Gifts made as part of normal expenditure out of income"]
[null,"Name of settlor/donor:","Enter name"]
[null,"Tax year in which gifts made ",2023,{"$f":"C4+1","v":2024},{"$f":"D4+1","v":2025},2026,2027,2028,2029]
[null,"Income (per annum)"]
[null,"Salary"]
[null,"Pensions"]
[null,"Interest (including ISAs)"]
[null,"Investments (dividends)"]
[null,"Rents"]
[null,"Annuities (income element)"]
[null,"Other"]
[null,"Minus Income Tax paid"]
[null,"Net Income",{"$f":"SUM(C6:C12)-C13","v":0},0,0,0,0,0,0]
[]
[null,"Expenditure (per annum)"]
[null,"Mortgages"]
[null,"Insurance"]
[null,"Household bills"]
[null,"Council Tax"]
[null,"Travelling Costs"]
[null,"Entertainment"]
[null,"Holidays"]
[null,"Nursing home fees"]
[null,"Other"]
[null,"Total expenditure",{"$f":"SUM(C17:C25)","v":0},{"$f":"SUM(D17:D25)","v":0},0,0,0,0,0]
[]
[null,"Surplus income for year",{"$f":"C14-C26","v":0},{"$f":"D14-D26","v":0},0,0,0,0,0]
[null,"Gifts made to Excess income trust - Old Mutual Wealth",0,0,0,0,0,0,0]
[]
[]
[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":"Sheet2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet3","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Year 1","index":4,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[35,1,35,2],[32,1,32,2],[1,1,2,2],[6,1,6,2],[17,1,17,2],[28,1,28,2],[3,1,3,2]]}
[]
[null,{"$f":"\"Gifts made as part of normal expenditure out of income - record of gifts for:\"&\" \"& Input!C3","v":"Gifts made as part of normal expenditure out of income - record of gifts for: Enter name"}]
[]
[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 to the Quilter normal expenditure trust. 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,"Tax year in which gifts made ",{"$f":"Input!$C$4","v":2023}]
[null,"Income"]
[null,{"$f":"Input!B6","v":"Salary"}]
[null,{"$f":"Input!B7","v":"Pensions"}]
[null,{"$f":"Input!B8","v":"Interest (including ISAs)"}]
[null,{"$f":"Input!B9","v":"Investments (dividends)"}]
[null,{"$f":"Input!B10","v":"Rents"}]
[null,{"$f":"Input!B11","v":"Annuities (income element)"}]
[null,{"$f":"Input!B12","v":"Other"}]
[null,{"$f":"Input!B13","v":"Minus Income Tax paid"}]
[null,"Net Income",{"$f":"SUM(C8:C14)-C15","v":0}]
[]
[null,"Expenditure"]
[null,{"$f":"Input!B17","v":"Mortgages"}]
[null,{"$f":"Input!B18","v":"Insurance"}]
[null,{"$f":"Input!B19","v":"Household bills"}]
[null,{"$f":"Input!B20","v":"Council Tax"}]
[null,"Travelling Costs"]
[null,{"$f":"Input!B22","v":"Entertainment"}]
[null,{"$f":"Input!B23","v":"Holidays"}]
[null,{"$f":"Input!B24","v":"Nursing home fees"}]
[null,{"$f":"Input!B25","v":"Other"}]
[null,"Total expenditure",{"$f":"SUM(C19:C27)","v":0}]
[]
[null,"Surplus income for year",{"$f":"C16-C28","v":0}]
[null,"Gifts made to Excess income trust - Old Mutual Wealth",0]
[]
[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 May 2021. 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":5,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,1,32,2],[1,1,2,2],[3,1,3,2],[6,1,6,2],[17,1,17,2],[28,1,28,2]]}
[]
[null,{"$f":"\"Gifts made as part of normal expenditure out of income - record of gifts for:\"&\" \"& Input!C3","v":"Gifts made as part of normal expenditure out of income - record of gifts for: Enter name"}]
[]
[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 to the Quilter normal expenditure trust. 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,"Tax year in which gifts made ",{"$f":"Input!$D$4","v":2024}]
[null,"Income"]
[null,{"$f":"Input!B6","v":"Salary"}]
[null,{"$f":"Input!B7","v":"Pensions"}]
[null,{"$f":"Input!B8","v":"Interest (including ISAs)"}]
[null,{"$f":"Input!B9","v":"Investments (dividends)"}]
[null,{"$f":"Input!B10","v":"Rents"}]
[null,{"$f":"Input!B11","v":"Annuities (income element)"}]
[null,{"$f":"Input!B12","v":"Other"}]
[null,{"$f":"Input!B13","v":"Minus Income Tax paid"}]
[null,"Net Income",{"$f":"SUM(C8:C14)-C15","v":0}]
[]
[null,"Expenditure"]
[null,{"$f":"Input!B17","v":"Mortgages"}]
[null,{"$f":"Input!B18","v":"Insurance"}]
[null,{"$f":"Input!B19","v":"Household bills"}]
[null,{"$f":"Input!B20","v":"Council Tax"}]
[null,"Travelling Costs"]
[null,{"$f":"Input!B22","v":"Entertainment"}]
[null,{"$f":"Input!B23","v":"Holidays"}]
[null,{"$f":"Input!B24","v":"Nursing home fees"}]
[null,{"$f":"Input!B25","v":"Other"}]
[null,"Total expenditure",{"$f":"SUM(C19:C27)","v":0}]
[]
[null,"Surplus income for year",{"$f":"C16-C28","v":0}]
[null,"Gifts made to Excess income trust - Old Mutual Wealth",0]
[]
[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 May 2021. 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":6,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,2,2],[32,1,32,2],[3,1,3,2],[6,1,6,2],[17,1,17,2],[28,1,28,2]]}
[]
[null,{"$f":"\"Gifts made as part of normal expenditure out of income - record of gifts for:\"&\" \"& Input!C3","v":"Gifts made as part of normal expenditure out of income - record of gifts for: Enter name"}]
[]
[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 to the Quilter normal expenditure trust. 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,"Tax year in which gifts made ",{"$f":"Input!$E$4","v":2025}]
[null,"Income"]
[null,{"$f":"Input!B6","v":"Salary"}]
[null,{"$f":"Input!B7","v":"Pensions"}]
[null,{"$f":"Input!B8","v":"Interest (including ISAs)"}]
[null,{"$f":"Input!B9","v":"Investments (dividends)"}]
[null,{"$f":"Input!B10","v":"Rents"}]
[null,{"$f":"Input!B11","v":"Annuities (income element)"}]
[null,{"$f":"Input!B12","v":"Other"}]
[null,{"$f":"Input!B13","v":"Minus Income Tax paid"}]
[null,"Net Income",{"$f":"SUM(C8:C14)-C15","v":0}]
[]
[null,"Expenditure"]
[null,{"$f":"Input!B17","v":"Mortgages"}]
[null,{"$f":"Input!B18","v":"Insurance"}]
[null,{"$f":"Input!B19","v":"Household bills"}]
[null,{"$f":"Input!B20","v":"Council Tax"}]
[null,"Travelling Costs"]
[null,{"$f":"Input!B22","v":"Entertainment"}]
[null,{"$f":"Input!B23","v":"Holidays"}]
[null,{"$f":"Input!B24","v":"Nursing home fees"}]
[null,{"$f":"Input!B25","v":"Other"}]
[null,"Total expenditure",{"$f":"SUM(C19:C27)","v":0}]
[]
[null,"Surplus income for year",{"$f":"C16-C28","v":0}]
[null,"Gifts made to Excess income trust - Old Mutual Wealth",0]
[]
[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 May 2021. 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":7,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,2,2],[32,1,32,2],[3,1,3,2],[6,1,6,2],[17,1,17,2],[28,1,28,2]]}
[]
[null,{"$f":"\"Gifts made as part of normal expenditure out of income - record of gifts for:\"&\" \"& Input!C3","v":"Gifts made as part of normal expenditure out of income - record of gifts for: Enter name"}]
[]
[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 to the Quilter normal expenditure trust. 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,"Tax year in which gifts made ",{"$f":"Input!$F$4","v":2026}]
[null,"Income"]
[null,{"$f":"Input!B6","v":"Salary"}]
[null,{"$f":"Input!B7","v":"Pensions"}]
[null,{"$f":"Input!B8","v":"Interest (including ISAs)"}]
[null,{"$f":"Input!B9","v":"Investments (dividends)"}]
[null,{"$f":"Input!B10","v":"Rents"}]
[null,{"$f":"Input!B11","v":"Annuities (income element)"}]
[null,{"$f":"Input!B12","v":"Other"}]
[null,{"$f":"Input!B13","v":"Minus Income Tax paid"}]
[null,"Net Income",{"$f":"SUM(C8:C14)-C15","v":0}]
[]
[null,"Expenditure"]
[null,{"$f":"Input!B17","v":"Mortgages"}]
[null,{"$f":"Input!B18","v":"Insurance"}]
[null,{"$f":"Input!B19","v":"Household bills"}]
[null,{"$f":"Input!B20","v":"Council Tax"}]
[null,"Travelling Costs"]
[null,{"$f":"Input!B22","v":"Entertainment"}]
[null,{"$f":"Input!B23","v":"Holidays"}]
[null,{"$f":"Input!B24","v":"Nursing home fees"}]
[null,{"$f":"Input!B25","v":"Other"}]
[null,"Total expenditure",{"$f":"SUM(C19:C27)","v":0}]
[]
[null,"Surplus income for year",{"$f":"C16-C28","v":0}]
[null,"Gifts made to Excess income trust - Old Mutual Wealth",0]
[]
[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 May 2021. 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":8,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,2,2],[32,1,32,2],[3,1,3,2],[6,1,6,2],[17,1,17,2],[28,1,28,2]]}
[]
[null,{"$f":"\"Gifts made as part of normal expenditure out of income - record of gifts for:\"&\" \"& Input!C3","v":"Gifts made as part of normal expenditure out of income - record of gifts for: Enter name"}]
[]
[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 to the Quilter normal expenditure trust. 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,"Tax year in which gifts made ",{"$f":"Input!$G$4","v":2027}]
[null,"Income"]
[null,{"$f":"Input!B6","v":"Salary"}]
[null,{"$f":"Input!B7","v":"Pensions"}]
[null,{"$f":"Input!B8","v":"Interest (including ISAs)"}]
[null,{"$f":"Input!B9","v":"Investments (dividends)"}]
[null,{"$f":"Input!B10","v":"Rents"}]
[null,{"$f":"Input!B11","v":"Annuities (income element)"}]
[null,{"$f":"Input!B12","v":"Other"}]
[null,{"$f":"Input!B13","v":"Minus Income Tax paid"}]
[null,"Net Income",{"$f":"SUM(C8:C14)-C15","v":0}]
[]
[null,"Expenditure"]
[null,{"$f":"Input!B17","v":"Mortgages"}]
[null,{"$f":"Input!B18","v":"Insurance"}]
[null,{"$f":"Input!B19","v":"Household bills"}]
[null,{"$f":"Input!B20","v":"Council Tax"}]
[null,"Travelling Costs"]
[null,{"$f":"Input!B22","v":"Entertainment"}]
[null,{"$f":"Input!B23","v":"Holidays"}]
[null,{"$f":"Input!B24","v":"Nursing home fees"}]
[null,{"$f":"Input!B25","v":"Other"}]
[null,"Total expenditure",{"$f":"SUM(C19:C27)","v":0}]
[]
[null,"Surplus income for year",{"$f":"C16-C28","v":0}]
[null,"Gifts made to Excess income trust - Old Mutual Wealth",0]
[]
[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 May 2021. 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":9,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,2,2],[32,1,32,2],[3,1,3,2],[6,1,6,2],[17,1,17,2],[28,1,28,2]]}
[]
[null,{"$f":"\"Gifts made as part of normal expenditure out of income - record of gifts for:\"&\" \"& Input!C3","v":"Gifts made as part of normal expenditure out of income - record of gifts for: Enter name"}]
[]
[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 to the Quilter normal expenditure trust. 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,"Tax year in which gifts made ",{"$f":"Input!$H$4","v":2028}]
[null,"Income"]
[null,{"$f":"Input!B6","v":"Salary"}]
[null,{"$f":"Input!B7","v":"Pensions"}]
[null,{"$f":"Input!B8","v":"Interest (including ISAs)"}]
[null,{"$f":"Input!B9","v":"Investments (dividends)"}]
[null,{"$f":"Input!B10","v":"Rents"}]
[null,{"$f":"Input!B11","v":"Annuities (income element)"}]
[null,{"$f":"Input!B12","v":"Other"}]
[null,{"$f":"Input!B13","v":"Minus Income Tax paid"}]
[null,"Net Income",{"$f":"SUM(C8:C14)-C15","v":0}]
[]
[null,"Expenditure"]
[null,{"$f":"Input!B17","v":"Mortgages"}]
[null,{"$f":"Input!B18","v":"Insurance"}]
[null,{"$f":"Input!B19","v":"Household bills"}]
[null,{"$f":"Input!B20","v":"Council Tax"}]
[null,"Travelling Costs"]
[null,{"$f":"Input!B22","v":"Entertainment"}]
[null,{"$f":"Input!B23","v":"Holidays"}]
[null,{"$f":"Input!B24","v":"Nursing home fees"}]
[null,{"$f":"Input!B25","v":"Other"}]
[null,"Total expenditure",{"$f":"SUM(C19:C27)","v":0}]
[]
[null,"Surplus income for year",{"$f":"C16-C28","v":0}]
[null,"Gifts made to Excess income trust - Old Mutual Wealth",0]
[]
[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 May 2021. 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":10,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,2,2],[32,1,32,2],[3,1,3,2],[6,1,6,2],[17,1,17,2],[28,1,28,2]]}
[]
[null,{"$f":"\"Gifts made as part of normal expenditure out of income - record of gifts for:\"&\" \"& Input!C3","v":"Gifts made as part of normal expenditure out of income - record of gifts for: Enter name"}]
[]
[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 to the Quilter normal expenditure trust. 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,"Tax year in which gifts made ",{"$f":"Input!$I$4","v":2029}]
[null,"Income"]
[null,{"$f":"Input!B6","v":"Salary"}]
[null,{"$f":"Input!B7","v":"Pensions"}]
[null,{"$f":"Input!B8","v":"Interest (including ISAs)"}]
[null,{"$f":"Input!B9","v":"Investments (dividends)"}]
[null,{"$f":"Input!B10","v":"Rents"}]
[null,{"$f":"Input!B11","v":"Annuities (income element)"}]
[null,{"$f":"Input!B12","v":"Other"}]
[null,{"$f":"Input!B13","v":"Minus Income Tax paid"}]
[null,"Net Income",{"$f":"SUM(C8:C14)-C15","v":0}]
[]
[null,"Expenditure"]
[null,{"$f":"Input!B17","v":"Mortgages"}]
[null,{"$f":"Input!B18","v":"Insurance"}]
[null,{"$f":"Input!B19","v":"Household bills"}]
[null,{"$f":"Input!B20","v":"Council Tax"}]
[null,"Travelling Costs"]
[null,{"$f":"Input!B22","v":"Entertainment"}]
[null,{"$f":"Input!B23","v":"Holidays"}]
[null,{"$f":"Input!B24","v":"Nursing home fees"}]
[null,{"$f":"Input!B25","v":"Other"}]
[null,"Total expenditure",{"$f":"SUM(C19:C27)","v":0}]
[]
[null,"Surplus income for year",{"$f":"C16-C28","v":0}]
[null,"Gifts made to Excess income trust - Old Mutual Wealth",0]
[]
[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 May 2021. We believe this interpretation is correct, but cannot guarantee it. Tax relief and the tax treatment of investment funds may change.\n "]