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
For assistance on the ETI Validation tool, please select from the following:
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.
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
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
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.
NOTE: Once you have completed Step 1 to 3 of the ETI Validation Utility, you can run Step 1 of ETI Validation to validate if the mentioned errors have been corrected. Some errors on the report can be valid, thus can be ignored if your ETI setup is correct.
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
NOTE: It is advisable to BACKUP before continuing with this option
CAUTION: If you have not made a BACKUP, please do so now before continuing with these options