ETI Excel Template Program for Microsoft Windows

Do you need to calculate South African Employment Tax Incentives (Youth Employment) or just want a way to easily check your ETI payroll calculations?

If you have Windows Excel  and require a tool to just calculate ETI then seriously consider this program, (or look at LabourTools desktop app)

ETI Version 4 now includes the proposed 2021 Aug to Nov calculations

Features:

  • Save employee details so that it is easier to capture future claims.
  • Capture the earnings and hours and click on Calculate to see the value of the claim.
  • If the input values do not comply with the SARS employee requirements then a message will appear and a value will not be calculated.
  • Save the calculation by clicking on the Save button if you want to keep history.
  • If calculations are saved, the number of claims can be looked up for future claims. The lookup is done automatically by a press of a button.
  •  The number of claims  is important because the number of claims determine what calculation to use. There are three calculation groups:

                  * Cycle 1 for 1 to 12 months

                  * Cycle 2 for 13 to 24 months

                  * Cycle 0 for Covid Relief 2020  and **** NEW August to November 2021 extended calculations

  •  CoVid Relief calculations are automatically applied - you don't have to do anything other than to calculate for staff over 29 years of age and earned/"deemed to have earned" less than R6500 per month.
  • Import or capture Employees directly in the Employee tab if you don't want to use the Form each time.
  • Import or capture ETI History directly in the ETI History tab if you don't want to use the Form each time.
  • Use the ETI History Tab for SARS Easyfile submission records. The fields are setup according to the BRS Spec that is why month is 01, 02, 03 etc REMEMBER to save only valid calculations so that your count of calculations is correct - and not counting zero calculated claims.
  • One program/spreadsheet for all your ETI calculations.
  • If your payroll software calculates ETI you can use this calculator to check the calculations. You don't need to first save employees or history -just type in the fields, click Calculate and see the results.
  • The program checks that the age, income is allowable and works out the 160 hours equivalent earnings if the hours worked amount is less than 160 hours. It even checks the number of claims and allows for the extra 8 claims for CoVid relief in 2020 and August - November 2021 extended rules. NB. Only save valid claims to history so that the count of existing claims is accurate. Do not save zero calculations.
  • Use the Checklist Tab to make sure you have complied to the Employer requirements.
  • Our Consultants use this tool to check our systems and to audit the outsourcing payroll calculations.


Installation:

Installation is easy. Place your order here, pay and then go to the downloads section after you login again and download the ZIP file.

Uncompress the file first before running it.

The SHA 256 Checksum for the Zip file is:

1FFA8D3658F24C6B9969283CE2710A8B1CFEB4313B26C8EB4A242E41F87CA6BC


The SHA 256 Checksum for the EXE file is:

97DC0D9B3C3CC23D8402EB7012F0D95005A6CDDB4AC540C04F0B50451A4B3B3C


The software will need an unlock key that is provided by sending the code generated to codes@payslip.co.za as instructed in the installation screens.

The extension of the file will always be .exe and not .xlsm or .xls because it is a compiled program that uses Excel.

The first time you save an employee or claim, the relevant sheets and headings will automatically be created.


Software Requirements:

Windows operating system and Microsoft Excel 64 bit Windows systems)

The purchase of this software is limited to one computer only (not network). The unlock key will only allow access on a specific computer or  one virtual drive.


HELP AND SUPPORT

If you need assistance or would like help with calculating ETI historically or reconciling Emp201's, please contact help@payslip.co.za so that we can setup a consultation booking at a suitable time.

We look forward to your feedback and if you have any recommendations for the next version, please let us know.

Payslip has products and services to help employers of all sizes and industries with their payroll and HR requirements. Contact us if you would like to discuss the options available.


E&OE Excepted


Write a review

Note: HTML is not translated!
    Bad           Good

Captcha

Our software understands South Africa's complex changes in tax, labour law, UIF and other legislation

Our software understands South Africa's complex changes in tax, labour law, UIF and other legislation

  • Product Code: ETI-Calculator
  • Availability: In Stock
  • R747.50
  • R573.85
  • Ex Tax: R499.00

Tags: ETI Calculator, excel template

For Micro Companies or startups with few staff where a simple payslip is required and no history is ..
R747.50
text_tax R650.00

This is a collection of software tools for:Individual payslips and historyEmployment Tax Incentive c..
R977.50
text_tax R850.00

Do you need to calculate South African Employment Tax Incentives (Youth Employment) or just want a w..
R747.50 R573.85
text_tax R499.00

We offer a consulting service on all your payroll queries, questions and projects.Let us help you to..
R782.00
text_tax R680.00

For Micro Companies or startups with few staff where a simple payslip is required and no history is ..
R575.00
text_tax R500.00

PayLite is perfect for  payroll functioning,  reporting and UIF extracts and more.PayLite ..
R4,370.00
text_tax R3,800.00

We process Salaries, Executive Pay, Weekly, fortnightly and Monthly wages.Prices reduce according to..
R74.75
text_tax R65.00