TCM1000089 - How to use the SEES Tax Credits Entitlement Calculator

Step 1

If you do not have SEES on your Excel toolbar, go to Step 2.

If you do have SEES on your Excel toolbar, go to Step 3.

Step 2

On the ‘HM Revenue & Customs’ home page

• select ‘How do I’ on the toolbar. You will be taken to the ‘How do I’ page
• select ‘Get help with IT basics’ from the ‘Get IT and telephone help’ list
• select ‘Go’. You will be taken to the ‘Basics’ page
• select ‘SEES missing from Excel’ from the ‘General PC help’ list
• select ‘Go’. You will be taken to the ‘Top 10 issues’ page
• select the ‘SEES homepage’ link. You will be taken to the ‘SEES Management and Support Team’ page
• select ‘INSTALL SEES’. The following message ‘Do you want to open or save this file?’ will display
• select ‘Open’. A ‘SEES Installer’ message will display
• select ‘Tax Credits’
• select ‘OK’. SEES should now be available on your Excel toolbar
• go to Step 3.

Step 3

In Excel

• select ‘SEES’ on the toolbar
• select ‘Tax Credits’ from the options available
  Note: ‘Tax Credits’ may not appear and instead you may have the option to select ‘Tax Credits Entitlement Calculator’
• select ‘Tax Credits Entitlement Calculator’ from the options available
• select the ‘Year’ field
• select the tax year to be calculated from the options available
• enter the customer’s name in the ‘Claimant(s) Name(s)’ field
• tab out of the ‘Claimant(s) Name(s)’ field
• select ‘Enter Details of Elements Awarded’
• when the message ‘Is this calculator being used to provide an estimate of entitlement to a customer?’ displays
  • select ‘Yes’ if you are using the Tax Credits Entitlement Calculator to calculate a new award whilst speaking to the customer
    otherwise
  • select ‘No’.

Note: From 6 April 2017, customers will only get the Family Element of Child Tax Credit where they are responsible for a child or children born before that date. A logical decision needs to be made as to whether the Family Element is payable. The default is ‘No’, if there is entitlement ‘Yes’ needs to be selected here. This needs to be repeated for any additional CoCs which are added to the calculation.

Note: The individual child element of Child Tax Credit will no longer be awarded for third and subsequent children or qualifying young persons in a household, born on or after 6 April 2017, unless they meet the exception criteria. You will need to make a logical decision on how many eligible children (including exceptions) need to be included, you will enter this number here as before. This needs to be repeated for any additional CoCs which are added to the calculation. Excluded/Non-exception children are not noted anywhere in the calculator.

If you are completing a notional entitlement calculation, go to Step 5.

If you are completing a four-week run-on exceptions calculation, go to Step 6.

If you are completing an In Year Finalisation calculation, go to Step 7.

If you are completing any other calculation, go to Step 4.

Step 4

In the SEES ‘Tax Credits Entitlement Calculator’

• enter the customer’s details from the start of the relevant award period in the ‘Initial App’ column
  Note: Boxes with red triangles contain ‘Help’ information.

If the customer has had a change of circumstances

• select ‘Add CoCs’. This will open the ‘CoC 1’ column
• enter all the customer’s details - both existing and new – that have happened from the change of circumstances date in the ‘CoC 1’ column
  Note: Select ‘CoC Dates’ to view information regarding the relevant dates to enter.
  Note: Repeat this action for each change of circumstance.
• select ‘Calc’. The system will calculate the customer’s entitlement.

If the customer has not had a change of circumstances, select ‘Calc’. The system will calculate the customer’s entitlement.

Step 5

In the SEES ‘Tax Credits Entitlement Calculator’

• enter the date as the day after the household breakdown in both the ‘Date Claim Submitted’ and ‘Effective Date Of Claim/COCS’ parts of the ‘Initial App’ column
• complete the remainder of the ‘Initial Apps’ column with the customer’s details
• select ‘Add CoCs’. This will open the ‘CoC 1’ column
• in the ‘CoC 1’ column
  • where the effective date of the new claim is within the maximum notional entitlement period enter the date of the new effective date of claim
    Note: This date will include backdating.
  • where the effective date of the new claim is outside of the maximum notional entitlement period enter the date as the day after the household breakdown was notified
• remove all the other information from this column
• select ‘Calc’. The system will calculate the customer’s notional entitlement
  then, where the customer has had a change of circumstances within the notional entitlement period
• select ‘Add CoCs’. This will open the ‘CoC 1’ column
• enter all the customer’s details - both existing and new – that have happened from the change of circumstances date in the ‘CoC 1’ column
  Note: Select ‘CoC Dates’ to view information regarding the relevant dates to enter.
  Note: Repeat this action for each change of circumstance within the notional entitlement period to calculate the correct amount of notional entitlement.
• select ‘Calc’. The system will calculate the customer’s entitlement.
  Note: Where there has been more than one change of circumstances within the notional entitlement period you will need to add together the amounts for each change of circumstance to calculate the full amount of notional entitlement.

Step 6

In the SEES ‘Tax Credits Entitlement Calculator’

• enter the day after the effective date the claim ceased or terminated in the ‘Date Claim Submitted’ and ‘Effective Date Of Claim/ parts of the ‘Initial App’ column
• complete the remainder of the ‘Initial Apps’ column with the customer’s details without the elements that have ended
• select ‘Add CoCs’. This will open the ‘CoC 1’ column
• in the ‘CoC 1’ column
  • enter the day after the four-week run-on period ended in the Effective Date Of Claim field
  • remove any elements of entitlement from ‘CoC 1’
• select ‘Calc’. The system will calculate the customer’s entitlement
• make a note of the figure in the end column of the ‘Payable as (within Entitlement Period) field. This is the amount you will need to pay by User Requested Payment.

Step 7

In the SEES ‘Tax Credits Entitlement Calculator’

• enter the customer’s details from the start of the relevant award period in the ‘Initial App’ column
  Note: Boxes with red triangles contain ‘Help’ information

If the customer has had a change of circumstances

• select ‘Add CoCs’. This will open ‘CoC 1’ column
• enter all the customer’s details – both existing and new – that have happened from the change of circumstances date in the ‘CoC 1’ column
  Note: Select ‘CoC dates’ to view information regarding the relevant dates to enter.
  Note: Repeat this action for each change of circumstance.
• go to Step 8.

Step 8

In the SEES ‘Tax Credit Entitlement Calculator’

• select ‘Add CoC’s’ and enter the Universal Credit start date and remove all entitlement for Child Tax Credit and Working Tax Credit
• select ‘Calc’. The system will calculate the customer’s entitlement.
  Note: This will calculate the customer’s entitlement for their tax credit award period.