Hello Marlene Wentzel

During the Mid year reconciliation period, it came to our attention that many of our customer’s ETI setups are not correct and that all releases during 2020 was not always installed in the correct processing periods, resulting in incorrect calculations.

At that stage, Sage requested customer to check and reconcile their ETI, and if there were any uncertainties or incorrect calculations, Sage assisted customers to recalculate the correct values, in the correct processing periods, using the compliance rules for the specific periods.

To streamline the mid-year process, tools were developed to do these calculations and make it easier for customers to resolve the discrepancies themselves, without having to ask Sage to do it.

The excel spreadsheet generated by the tool can be saved at any stage and used for calculations, if the customer prefer to do the calculations themself. From left to right, the period set and count is the values as currently in the payroll. The “light green columns” is the values as calculated by the tool.

Same applies to the Incentive values. The green Tax incentive column is the value as calculated , Tax incentive (Before change) is the value as currently in the payroll.  and the Tax Incentive To Import is the value to be imported in the payroll.

If you have any queries with regards to the use of the tool, please review the following information:

How do I use the ETI Validation tool ?

You can also contact your Business Partner for assistance.

Hi Avril

I know for a fact that our updates were loaded as they came out.  Just yesterday I ran the Utility tool again, on the verification process it says remuneration Less than permitted value. (Step 1)   In step 2 it will say again remuneration list exceeds permitted value.  How can it at one calc throw out a value of R750 and with the next calc a value of R1-00.  That is impossible.

I have watched you You Tube Video several times to make sure that I am doing everything correct.  Even after correction is run and you re-validate it, periods still shows in red as incorrect.

Why is it that now where we can just find a normal EXCEL spreadsheet to do some tests yet other much simpler payrolls offer an excel spreadsheet for manual calcs to check.

I am also highly unhappy with the support.  I have uploaded one of my companies last week already to a consultant for support where the company hangs and does not do spreadsheet.  I now have quite a few.  I have had no feedback on this but yet I get email from VIP to say ticket closed.

Quick chat is quick to say the query is to complex.  Via the web form you get little joy.  Phoning you hang on for hours and eventually when the consultant come back to you, they cannot here you although I can here them clearly.  The will not bother to phone back.

I have been advocating on my advertisements for 21 years that I make use of the number 1 Payroll company in South Africa, but I am sorry to say, the support is lately just not what it used to be in the olden days.  We are now bombarded with links and with answers that you can clearly see is a standard answer from VIP which is like just forwarded to us again.

At the moment I am not a happy chappy.

Kind regards

Marlene

Hello Marlene

With regards to the Excel sheet hanging, I would suggest you check the Regional settings on the machine. The following Knowledgebase article provides you with the steps Recommended Regional Settings.

Kindly provide me with the reference ID for your support log and Site Code. I will direct your query to the relevant Team Lead for further assistance.

Hi Marlene. Hope you are well. I have not seen an Excel sheet that allows you to do manual cross checks. I have created one once but it took quite a bit of time to compile as all the various calculations need to built into it. So it is definitely doable. The challenge you will have with that is that you will either need to attempt this yourself, with some guidance, or, you can outsource it to someone to write it for you, which will then have a cost attached to it.

You are more than welcome to reach out to me and I will see how I can assist you with your current ETI challenges.

Hi Shanie, if you don't mind please contact me at [email protected] re assistance.  I thank you kindly.

Marlene

Hi Shanie, if you don't mind please contact me at [email protected] re assistance.  I thank you kindly.

Marlene

Hi Marlene, I have just sent you an email.