Summary
Description
The ETI Validation Utility validates the ETI periods, sets as well as selected setup related issues of the current tax year. The tool will allow you to export the data, do corrections where required, and import the corrected information into the payroll to be ready for the year-end submission.
Cause
During the mid-year reconciliation period, it came to our attention that some customer’s Employment Tax Incentive (ETI) company setups are incorrect resulting in incorrect amounts utilised. A new in-system utility is available for Sage Business Cloud Payroll Professional customers to validate the ETI setup.
Resolution
- From the Main Menu
- Click on Utilities
- Select ETI
- Select ETI Validation
NOTE: It is advisable to BACKUP before continuing with this option
Click here for the steps on how to make a backup
CAUTION: If you have not made a BACKUP, please do so now before continuing with these options
Click on Step 1 - Validate ETI Setup and Data
- Please be patient, an Excel Workbook will generate displaying the validation errors.
- Your download will begin shortly. If your download does not automatically start, you can manually start the download.
- Click Finish to return to the ETI Validation Screen
The Company ETI Setup and Employee ETI data will be validated.
Any errors and omissions will be identified and recorded on the Excel Workbook, per employee, per month.
- The reason for the validation errors for the current tax year, as well as the solutions, will be recorded on the Solutions Sheet of this Excel Workbook.
- Click on the Solutions tab and follow the guidelines to amend any ETI Setup errors and employee ETI data for the current period. This will ensure that ETI is correct in future Pay Periods.
- Employee ETI History data if required must be amended in Step 2.
- The Excel Workbook can be saved or closed after the validations have been verified.
- The following ETI guides are available:
- ETI Calc Info - This explains how the calculation is applied in the payroll
- Setup Guidelines - How to setup ETI in your payroll company
- Import Guidelines - Guideline document on the requirements for the ETI csv file layout. The tool will automatically create the ETI csv file in this layout to import into the system.
Click on Step 2 - Extract Data and Amend
All the Employee ETI History data will be extracted for the current Tax Year. Detailed notes accompany this step.
You may amend history data on the Excel Sheet, as per the Validation Report in Step 1. This is optional.
NOTE: We strongly advise you to book a consultation with your Business Partner if you are unsure about any of these details. Click here to book a consultation
You may select to recalculate ETI Sets, Periods and Incentive values. Please consult the <Notes> for details pertaining to the functionality of this Excel Workbook
ETI Export Selections
The ETI data will be extracted from the beginning of the Tax Year up until the current Processing Period.
The following selections can be made:
- Select the Range of Employees (All employees, Range of Employees,Department, Paypoint,Category, Paterson,Manager, RSC Code)
- Export Employees (Active Employees, Terminated Employees, All Employees, Current New and/or Term). We recommend you to select All Employees, as there can be ETI on terminated employees
- Sort Sequence (Sort Name, Employee Code, Department, Paypoint, Category, R.S.C Code, Paterson, Job Title, Manager)
- Click on Export
- File successfully created Employee records exported: XX, Select OK
- Your download will begin shortly. If your download does not automatically start, you can manually start the download.
- Click Finish to return to the ETI Validation Screen
- Open the Excel Workbook with the ETI Validation Process
ETI Validation Process - Step 2
CAUTION: If you have not made a Backup, please do so now before continuing with these options.
Notes - The user can select the Notes bar to read for further assistance
Use this option to review and amend any ETI History information that will influence the calculation of the Tax Incentive.
- This is the Employee ETI History data for the current Tax Year
- You may amend the history data on this Excel Sheet, as per the Validation Report in Step 1
- This data is used to recalculate the ETI Sets, Periods and Incentive values in Option 2
- For a detailed explanation of each field on this sheet, please consult the <Import Guidelines> found under: Main Menu > Utilities > ETI > ETI Validation
NOTE: We strongly advise you to book a consultation with your Business Partner if you are unsure about any of these details.
- You can Save this Excel Workbook at any time.
- You can Run Recalculation of Option 2 multiple times.
- When you are done, click on Back to Menu and select the next step.
- If you have made all the applicable amendments on this sheet, go Back to the Menu and proceed with Option 2. Run Recalculation of ETI Sets, Periods and Tax Incentives.
- Before you run the recalculation ensure that all Manual History Adjustments have been made.
- The History Adjustments will influence the calculation of ETI Sets, Periods and Tax Incentive values.
- When you run the recalculation a few extra columns will be added to the sheet.
- If the company wants to claim the higher value, adjust the value in the "Tax Incentive To Import" column with the value that must be imported.
NOTE: If values that are imported differ from the values already declared on the EMP201 reports, they will need to be restated and may result in penalties.
- Would you like to proceed with the Recalculation ?
- Select OK or Cancel
- An Excel Workbook will generate displaying the recalculated information
When you select this option you have 3 options:
- Import all data except Incentives - this option will create an import file with all data, including changes made to fields, recalculated ETI Sets and Period. Newly calculated Incentive values will not be included. The original Incentive values will be kept.
- Import All Data- this option will create an import file with all the data, including changes made to fields, recalculated ETI Sets and Periods as well as the Incentive values as per the "Tax Incentive To Import" column.
- Cancel - this will cancel the action and take you back to the Menu.
- The Import options will prompt you to select a destination path to save the import file to. Make a note of the location as you will need it when importing the file into the payroll.
- The default file name will be IMP-ETI.csv.
- Please DO NOT open the saved csv file in Excel. It will change the formatting of the fields and you will not be able to import the file successfully.
- You may now close the Excel Workbook
- Access the Payroll
- If you have not made a backup, please make a backup before importing the File into Payroll
- From the Main Menu, Click on Utilities, Select ETI, Select ETI Validation
- Follow the on screen prompts to import the file created and saved during Option 3
- Import the file which you saved at the end of the previous step, in the destination folder of your choice.
- After successfully importing th file, you could go back to Step 1 to validate the ETI Setup and Employee data again to ensure that everything is correct now.
NOTE: It is advisable to BACKUP before continuing with this option. Click here for the steps on how to make a backup
- Click on Browse to indicate where the Import file is located
- Please Enter the name of the Import file
- Click on Import
- Once you have imported the file we recommend that you run Step 1 again to ensure that your validation errors/warnings are resolved
Watch a short video on how to run the ETI Validation Utility