3833 Not equal to 4584

Kindly Do Not use the below steps if you are doing your Year End Submission.  The below steps where only applicable to the Bi-Annual submission for 2019!

This exception occurs on Council Companies and is usually received on terminated employees for the MIBFA, MIBCO and ELECTRICAL Councils.  This exception might appear on all employees in the ROAD FREIGHT Councils.

In order to fix this, our Dev team has created a Utility and published it in our update 2020 Update 2a (That is specifically only for council clients).

This update is specifically designed to fix this exception in September or later.

To clear your exception you will need to do the following:

  1. Update to 2020 Update 2a from the Download Manager
  2. Run a Legislative release
  3. Run the Council Benefit Utility
  4. Run a Rebuilt Totals
  5. ROAD FREIGHT clients will need to do their Payroll Run and Pay period update before running the Exception report to receive a clear report.

Please remember that the relevant Fringe Benefit code for your council (M203, I300, I301, R700 or E214) is processed in your current period.  If the code is not processed in the current period you will have to add it to the payslip and do a pay period update in order for the exception to be fixed - even if it is not for Road Freight

Step 1: Update

In Pastel Payroll, click on Utility, Weblinks, Download latest software version to access our Download manager. Click on Download for the full install for 2020 Update 2a.  Please download and install this update

Step 2: Leg Release

View our Legislative release guide here

Step 3: Utility

Click on Utility, Council Benefit Utility.  Click on Ok - it will show you a list of all employees that where changed



Step 4: Rebuilt Totals

View our Rebuilt Totals guide here

Step 5: Payroll Run and Pay Period update

If you are a Road Freight client that has processed September values, you need to roll over into the next period before re-running the exception report.

  • Hi I did the above 

    But it still gives me the error

    I am in period 8 (October) can this be the problem?

    Do I need to be in August (Period 6) for this fixe te work?

  • in reply to HeinSpook

    Good Morning Hein,

    No, you should not be in August when running the utility.  The Utility is designed to enter a transaction into August (if the council codes where not there), and in the case of Road Freight to calculate the Year To date values of the Company Contributions to accommodate the months afterward (hence the Pay Period update that needs to be done into the next period).

    The only times that I have seen this not work is in cases where the Fringe benefit code is currently not on the payslip (in this case you will have to add it and then do a pay period update).

    So please ensure that you:

    1. Ran a Rebuilt totals
    2. The relevant Fringe Benefit code is on the Payslip currently and that it is not overwritten
    3. Also if you needed to add the code to the current period or if you are on Road Freight ensure that you do a pay period update.

    If all of this is done and you are still getting the exception, please send an email to [email protected] so we can send you upload procedures so we can investigate the dataset.  Please use Sage City and your Site code in the subject line.

  • Used the Utility after updating to 2a and rebuilt totals.  Still get the same error message.

    On each employee Masterfile now shows different totals for 3833 and 4584 and these should both be nil.  Three data bases affected.

  • in reply to admac

    Hi Admac,

    Remember to please run a leg release as soon as you have updated to 2a.  Please ensure that your relevant Fringe benefit code is on the Payslip in the current period.  If you are only adding the codes on now please do a pay period update and check if the exception has been cleared.

    If all of this is done and you are still getting the exception, please send an email to [email protected] so we can send you upload procedures so we can investigate the dataset.  Please use Sage City and your Site code in the subject line.

  • in reply to ThandiweK

    We've downloaded 2a, completed Legislative Update and still get an error report on IRP5 Exception Reports that Code 3833 is not equal to 4584.  Note that MIBFA have specifically stated that we are not to deduct, nor are we liable, for Bargaining levy deductions or contributions

    Copies of the relevant data have bee submitted to Jamie van Wyk, so far without any success in resolving our problem.

  • in reply to admac

    Hi Admac,

    Thank you for the feedback.  I received the 3 datasets from Jamie.  

    You are getting the exception due to the fact that you currently don't have the code M203 (Fringe Benefit code for the MIBFA council) processed.  I see that you have ran the Utiltiy - that has affectively added the code M203 in the August period with the year to date up to and including August (As it was designed to do)

    To clear your exception, you will have to add the code M203 to the payslips and then do a Pay Period update in order to correct the exception.

    The code M203 is the Fringe Benefit code that goes along with M103 (Sick Pay Fund).  So if you have the code M103 processed, then you need to have the code M203 processed.  As you are only adding the codes to the payslip now, you have to do a pay period update before the Exception report will clear.

    Please note that the code M203 and the exception that you are getting have nothing to do with the Bargaining Levy.  

  • in reply to ThandiweK

    Hi,  

    Can you please assist?  I am in period 8 October and update 2a with MIBCO council.  I have done the following.

    1. Update to 2020 Update 2a from the Download Manager
    2. Run a Legislative release
    3. Run the Council Benefit Utility
    4. Run a Rebuilt Totals

    But still gets the same error.  I see that there needs to be a Fringe Benefit.  Can you please assist in the code for MIBCO that I need to load on the payslip?

    The relevant Fringe Benefit code is on the Payslip currently and that it is not overwritten

    I also can not update the payslip as I am still in October and need to do the run at the end of the month.

  • in reply to Tienie Nel

    Good day Tienie,

    The codes required on the Default tab of the Payslips are I300 - Sick & Accident Fringe Benefit and I301 - Add. Holiday Fringe Benefit.

    Kindly note, you will need to perform the Pay Period update in order for the Exception on the Exception report to be cleared.

  • in reply to ThandiweK

    Hi! I have followed the steps and managed to fix the 3833/3883 must equal 4584 error for all except 2 employees who have been terminated on the payroll. How do I fix the error for them if they no longer have payslips to add the M203 code to? Thanks!

  • in reply to Yolandi Taljaard

    Hi Yolandi,

    Where these 2 employees terminated in the September/October period?

  • in reply to ThandiweK

    Hi, yes that's right.

    I restored my backup and went through the steps again this morning, unfortunately I still get this error with these 2 employees.

  • in reply to Yolandi Taljaard

    The Council Utility will only add the August values -  the client should have processed the codes when they became available in July.  The only way to fix it is to select one of the below:

    1. Restore back to September and add the codes, and recapture the Month of October and redo the utility and pay period updates
    2. Have a chargeable datafix done (charged at 890excl. vat)
    3. Exclude these employees and do manual certificates for them in E@syfile, however we will not be able to assist with this.

    Please let us know if you need assistance with option 1 or 2.

  • in reply to ThandiweK

    Thank you! As I'm pressed for time, I'll manually add their certificates in e@syfile. 

  • in reply to ThandiweK

    hi,Im doing the same as Yolandie.I have 17 certificates to do manually.The rest of the certificates are fine and are showing no errors on the exception report.However when exporting those into easyfile,it gives the following errors and fails validation:

    Source code 4149 value 8226.33 not equal to total 4101 + 4102 + 4115 + 4141 + 4142 = 12962.46

    please assist.

  • in reply to FatimaA

    Hi FatimaA,

    Please advise if you have any custom codes processed on these employees?  And also please advise how many of these custom codes are linked to custom templates

  • in reply to ThandiweK

    i have 1 custom code linked

  • in reply to FatimaA

    What Tax Totals is linked to that Custom code?  You can check this on Setup, Transaction Templates

  • in reply to FatimaA

    sorry its on 3699

  • in reply to FatimaA

    Please scroll down to the bottom and advise what other tax totals have been ticked?

  • in reply to ThandiweK

    3699 and 3601

    thats it

  • in reply to FatimaA

    Please send an email to [email protected] with the subject line Sage City and your site code so we can send you a guide on how to send your data to us. 

    Please note that there is a 48 hour turnaround time on all data investigations

  • in reply to ThandiweK

    i have done this yesterday already.

  • in reply to FatimaA

    Did you email them yesterday regarding the 3833 or regarding the import exception you are currently getting?

  • in reply to ThandiweK

    hi

    i have managed to sort that error - thank you

    im capturing the certificates manually now - where will i get the amounts to capture them