TCM1000490 - How to establish the customers entitlement using SEES and populate the Calculation sheet - Manual Payments Team

Step 1

On the ‘Function Menu�

  • select ‘Applicationâ€� on the toolbar
  • select ‘Viewâ€� from the options available. You will be taken to the ‘Key Entry Data - Applicantâ€� screen
  • enter the customer’s NINO
  • select the ‘Latestâ€� checkbox
  • select ‘OKâ€�.

If you are taken to the ‘Select Application� screen

  • select the relevant claim
  • select ‘OKâ€�. You will be taken to the ‘Application Summaryâ€� screen
  • go to Step 2.

If you are taken to the ‘Select Application Version� screen

  • select the latest claim version
  • select ‘OKâ€�. You will be taken to the ‘Application Summaryâ€� screen
  • go to Step 2.

If you are taken straight to the ‘Application Summary� screen, go to Step 2.

Step 2

Return to your desktop

  • open the ‘Râ€� spreadsheet on your desktop. »Ê¹ÚÌåÓýapp spreadsheet will open at the letter page with a message displayed
  • select ‘Don’t updateâ€�. »Ê¹ÚÌåÓýapp letter page of the spreadsheet will display
  • return to the ‘Application Summaryâ€� screen to enter the name and address details onto the TC857p letter.

If customer 1 is the nominated recipient

  • select ‘Continueâ€�. You will be taken to the ‘Additional Informationâ€� screen for customer 1
  • select the customer 1 details on the screen
  • select ‘Printâ€�
  • go to Step 3.

If customer 2 is the nominated recipient

  • select ‘Continueâ€� twice. You will be taken to the ‘Additional Informationâ€� screen for customer 2
  • select the customer 2 details on the screen
  • select ‘Printâ€�
  • go to Step 3.

Top of page

Step 3

Return to the open letter page of the spreadsheet

  • select ‘Collect detailsâ€�. »Ê¹ÚÌåÓýapp details will be automatically transferred to the letter

Note: Enter customer 2 NINO if required on the right hand side of the letter.

  • select the ‘Addresseeâ€� box, either ‘App 1â€� or ‘App2 â€� on the letter
  • select ‘Calculation sheetâ€� from the bottom of the spreadsheet
  • go to Step 4.

Top of page

Step 4

On the ‘Calculation� sheet, check and complete both of the following sections

  • section 1 - all fields will be populated

    • check that customer 1 and customer 2 name and NINO details are correct
    • confirm the ‘Nominated recipientâ€� fields and ‘Nominated creditâ€� fields are populated correctly as noted on the stencil
    • use the drop down menus to amend any details, if required
  • section 2 - the award start date and end dates will be populated with the start date and end date of the current tax year

    • amend the end date if the award has already ended
  • go to Step 5.

Top of page

Step 5

Open the ‘SEES Tax Credits Entitlement Calculator� (Tcalc1) in Microsoft (MS) Excel. To do this

  • select ‘SEESâ€� on the toolbar
  • select ‘Tax Credits Entitlement Calculatorâ€� from the options available

Note: If ‘SEES� is not on your toolbar, SEES can be installed from the Intranet. Go to the ‘Benefits & Credits� homepage, select ‘S� from the ‘B&C A-Z index�, select ‘SEES homepage� and then select ‘Install SEES�.

  • use ‘Windowâ€� to move between the ‘SEES Tax Credits Entitlement Calculatorâ€� and the spreadsheet
  • go to Step 6.

Top of page

Step 6

Select the appropriate tax year

  • select ‘Enter details of elements awardedâ€�. You will be asked ‘Is this calculator being used to provide an estimate of entitlement to a customerâ€�, select ‘Noâ€�

Note: If CY is ‘S� (system estimated), check if we have ‘E� (estimated) or ‘A� (actual) income for PY. We do not need CY income to do a calculation. Estimated or actual income for PY is sufficient.

  • complete ‘SEESâ€� calculation. For how to do this, use TCM1000089.

If the result of the calculation is that there is no entitlement

  • update Household Notes with the message PC04 from TCM0168020. For how to do this, use TCM1000001Ìý
  • return to the guidance you were previously following.

If the result of the calculation is that there is entitlement

  • complete section 2 of the ‘Calculationâ€� sheet using the data from the ‘SEES Tax Credits Entitlement Calculatorâ€� print out as follows

Note: Use ‘Windowâ€� to go back to the ‘Calculationâ€� sheet and select ‘Collectâ€� in section 2. »Ê¹ÚÌåÓýapp figures from the ‘SEES Tax Credits Entitlement Calculatorâ€� will populate section 2.

Top of page

Step 7

On section 3 of the ‘Calculation� sheet

Note: »Ê¹ÚÌåÓýapp ‘Household Pay Dayâ€� is populated with today’s date. »Ê¹ÚÌåÓýapp ‘Date of Next HH pay dayâ€� is populated with a date two weeks from today’s date. If a different date is needed this date can be moved forwards or backwards. »Ê¹ÚÌåÓýapp correct pay date can be entered up to one day before payment is due.

If the award period has not already ended for recalculation cases

  • check if the ‘Recalculation referralâ€� template states a pay date to be used to tie in with the previous pay dates
  • check the last pay date in function ‘View Household Notesâ€� to confirm the day and date for the next payment according to the pay frequency
  • change the ‘Today dateâ€� field on the right hand side of the sheet to the required date
  • go to Step 8.

If the award period has not already ended and you are dealing with

  • new referral cases, use today’s date as the pay day
  • ‘Business As Usualâ€� (BAU) cases. use two weeks from today’s date as the next pay date
  • ‘User Requested Paymentâ€� (URP) ‘PXRMâ€� cases, use the date one week from today’s date as the next pay date
  • select ‘Save after checkingâ€�
  • go to Step 8.

If the award period has already ended

  • treat the end date of the award period as the next household pay day
  • record this date in the ‘Date of Next HH pay dayâ€� box in the ‘Entitlement to Next HH pay dayâ€� table at section 3 of the ‘Calculationâ€� sheet
  • complete the ‘WTCâ€� and ‘CTCâ€� boxes in the ‘Entitlement to next HH pay dayâ€� table at section 3 of the ‘Calculationâ€� sheet using the data from the Tax Credits Entitlement Calculator print out

Note: This will be the same as the details entered at section 2 of the ‘Calculation� sheet.

Top of page

Step 8

To determine entitlement up to the next household pay day, use ‘Window� to return to the ‘SEES Tax Credits Entitlement Calculator�

  • on the ‘SEES Tax Credits Entitlement Calculatorâ€�
  • remove any change of circumstances where the effective date is after the date of the next household pay day, recorded in the ‘Entitlement to next HH pay dayâ€� table at section 3 of the ‘Calculationâ€� sheet
  • use a change of circumstances with the next household pay day as the effective date of the claim or change of circumstance and remove all elements
  • select ‘Calcâ€�. »Ê¹ÚÌåÓýapp ‘Calcâ€� screen will display
  • select ‘Printâ€� to print out the ‘SEESâ€� calculation

Note: Only select the ‘View Calculation� sheet for printing.

  • use ‘Windowâ€� to return to the spreadsheet
  • select ‘Collectâ€� in section 3. »Ê¹ÚÌåÓýapp ‘’WTCâ€�, ‘CTCâ€� and ‘Totalâ€� amounts due up to the date of the next household pay date will populate
  • go to Step 9.

Top of page

Step 9

Enter the percentage of the adjustment required, as noted earlier on the ‘Calculation� sheet

If you are dealing with a ‘Minimum award� case the percentage required is 100%

  • select â€�100%â€� from the ‘Category of Awardâ€� field in the ‘Entitlement to next HH pay dayâ€� table at section 3

Note: »Ê¹ÚÌåÓýapp ‘Adjusted remaining WTC / CTC entitlementâ€� field will be populated automatically with zeros.

If you are dealing with a case where ‘Qualifying benefits� are in payment the percentage required is 10%

  • select â€�10%â€� from the ‘Category of Awardâ€� field in the ‘Entitlement to next HH pay dayâ€� table at section 3

Note: »Ê¹ÚÌåÓýapp ‘Adjusted remaining WTC / CTC entitlementâ€� field will be populated automatically.

If neither of the above applies the percentage required is 25%

  • select â€�25%â€� from the ‘Category of Awardâ€� field in the ‘Entitlement to next HH pay dayâ€� table at section 3

Note: »Ê¹ÚÌåÓýapp ‘Adjusted remaining WTC / CTC entitlementâ€� field will be populated automatically.

Top of page

Step 10

From the payment details noted, complete the following at section 3 of the ‘Calculation� sheet

  • system payments up to today’s date
  • payments still to be paid from today’s date up to the date of the next household pay day
  • any manual payments made so far, as listed on the ‘Calculationâ€� sheet and whether these payments are posted or not posted

Note: Payments marked as posted ‘Yes� will not be deducted as they will already be included in the ‘System payments Up To�.

  • any system payments still to be paid after the date of the next household pay day
  • select the ‘Enterâ€� key on your keyboard to prompt the calculation
  • go to Step 11.

Top of page

Step 11

Schedule the manual payments. To do this, on the ‘Calculation� sheet

  • select the ‘Schedule of paymentsâ€� page

Note: If the adjusted WTC or CTC figure applies, ‘In year restriction applied� will display.

  • the customer 1 and customer 2, if appropriate details will have been copied from the ‘Calculationâ€� sheet
  • select the reason for issue from the drop down menu
  • select ‘Allocateâ€�. »Ê¹ÚÌåÓýapp pay dates for the remainder of the tax year and the amounts payable will automatically populate
  • arrears and roundings are displayed in the first payment field
  • the remaining entitlement is divided equally between the number of scheduled payments shown in the payment fields for the remaining pay dates
  • the totals are shown at the bottom of the screen

Note: »Ê¹ÚÌåÓýapp totals shown and any payments that have already been made should equal the entitlement for the year, unless a restricted adjustment has been applied.

If no arrears are payable

  • the remaining payments shown may be adjusted at your manager’s discretion
  • to divide the remaining entitlement over all the remaining pay dates, ask your manager for advice
  • go to Step 12.

If arrears are payable, go to Step 12.

Top of page

Step 12

On the ‘Calculation� sheet, select ‘Letters� tab

  • select ‘Printâ€� to print out the ‘Letterâ€�
  • select the ‘Calc sheetâ€� and print this page
  • select ‘Scheduleâ€� and print this page
  • you should now hold hard copies of the

    • letter
    • ‘Calculationâ€� sheets with arrears (two pages) and schedule (one page)

    and

    • ‘SEESâ€� ‘Calculationâ€� sheets you printed out earlier
  • go to Step 13.

Top of page

Step 13

Save and close documents

  • select ‘Fileâ€� ‘Save Asâ€� a signal box will appear
  • select ‘Okâ€�
  • save in locally held ‘CAFâ€�
  • select ‘noâ€� when the signal box appears to close the ‘Calculationâ€� sheet

then

  • save ‘SEESâ€�

    • select ‘Fileâ€� ‘Save Asâ€� a signal box will appear
    • select ‘Okâ€�
    • save in locally held ‘CAFâ€�
    • select ‘noâ€� when the signal box appears to close ‘SEESâ€�
  • return to the guidance you were previously following.