Beta This part of GOV.UK is being rebuilt – find out what this means

HMRC internal manual

Tax Credits Manual

From
HM Revenue & Customs
Updated
, see all updates

How to use the SEES Tax Credits Entitlement Calculator

Step 1

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

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

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

In Excel

  • select ‘SEES’ on the toolbar
  • select ‘Tax Credits’ from the options available
  • 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

Note: ‘Tax Credits’ may not appear and instead you may have the option to select ‘Tax Credits Entitlement Calculator’

  • select ‘Yes’ if you are using the Tax Credits Entitlement Calculator to calculate a new award whilst speaking to the customer

    otherwise

  • select ‘No’.

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

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

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

If you are completing any other calculation, go to .

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

In the SEES ‘Tax Credit Entitlement Calculator’

  • select ‘Add CoC’s’ and enter the date 1 day before 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.