Calculation of South African Medical Tax Credits


This package will calculate Fringe Benefit, Medical Tax Credit and Additional Medical Tax Credit (Applicable to employees who are 65 or older on the last day of the Tax year) - f84pkg.sql.


Prerequisites to use this package

1. This calculation will be done for Earnings / Deductions {FPRG-6} with Calculation Method "5 - Medical Aid" where

It may also be used by Earnings / Deductions {FPRG-6} with a Local Software calculation (Activated by Calculation Method "U - Medical Aid Local Software") where the Medical Aid Structure {FPRG-8} exists

2. Medical Aid Dependents {PBOP-7} should exist where applicable


Note that the calculation as described below will not function as expected if any of the applicable Earnings or Deductions in the Medical Aid Structure {FPRG-8} are advised with Calculation Method "3 - Advised Amount".


General information    For Tax Certificate Reporting
Calculation Rules
           The Fringe Benefit Amount calculated equals the Employer’s Contribution Amount (Tax Code 4474)             A Medical Tax Credit Amount (Earning) is allowed for the main member (Employee) and for each Medical Aid Dependent as defined on {PBOP-7}.  The Medical Tax Credit amount for each member is a prescribed amount and can be viewed on {FPRC-22}.
   
          A Medical Tax Credit reduces the Employee’s Tax (PAYE) liability and therefore the total Medical Tax Credit Amount may equal but may never exceed the total PAYE deduction, within the reporting period, within the current Tax Year.
 
           With effect from 1st March 2017, an accumulative Medical Tax Credit calculation is done, therefore if the full amount of the Medical Tax Credit could not be calculated in a cycle due to insufficient PAYE, it may be given in another cycle should there be sufficient PAYE in            that cycle.
 

 In order for the Medical Tax Credit to calculate programmatically, the following rules apply:

For each continuous cycle, in the current Tax Year where tax Code ‘4005’ and /or ‘4474’ exists, the allowed Tax Credit Amount is calculated for the cycle.  A calculation is then done for the current cycle using the year-to-date allowed amount, less year-to-date amount already given, limited to the total year-to-date PAYE Amount within the continuous cycle, in the current Tax Year.  The shortfall is then given or alternatively if too much Medical Tax Credit has been calculated in a previous cycle/s (PAYE adjustment may have an effect), the overpayment is recovered

As an accumulative calculation is done, the calculation is no longer Fund dependent.  Therefore the same Medical Tax Credit ED Code may be used across multiple Funds and when defining the ED Code, it is no longer necessary to link the Fund Code to it.
 
Additional Medical Tax Credit for Employee’s >65 (Tax Code 4120)

For Employees who are 65 years or older on the last day of the current Tax Year, an additional Medical Aid Tax Credit is calculated (AMTC>65).
The AMTC>65 reduces the Employee’s Tax (PAYE) liability and therefore the total AMTC>65 amount may equal but may never exceed the total PAYE deduction less Medical Tax Credit, within the reporting period, within the current Tax Year.
               

With effect from 1st March 2017, an accumulative AMTC>65 is done, therefore if the full amount of the AMTC>65 could not be calculated in a cycle due to insufficient net PAYE (i.e. PAYE less Medical Tax Credit), it may be given in another cycle should there be sufficient PAYE in that cycle.

In order for the Medical Tax Credit to calculate programmatically, the following rules apply:

The accumulative calculation is done as follows:

AMTC>65 = (((EE Contribution YTD Amt (Tax Code 4005) + ER Contribution YTD Amt (Tax Code 4474)
        Minus (Medical Tax Credit YTD Amt (Tax Code 4116) multiplied by 3)
                                     Multiplied by 33.333%)
                                             Less AMTC>65 YTD Amt already given in continuous Service Period /Current Tax Year

The shortfall of AMTC is then calculated for the Employee or alternatively if too much AMTC>65 has been calculated for the Employee (Medical Tax Credit adjustment and /or PAYE adjustment may have an effect), the overpayment is recovered.
As an accumulative calculation is done, the calculation is no longer Fund dependent.  Therefore the same ED Code may be used for all Funds and when defining the ED Code, it is no longer necessary to link the Fund Code to the ED Code.
Recommended set up rules

Earning / Deduction Applicable to
Calculation Method Salary Level (E)arning or (D)eduction IRP5 Total Entry in Global Earning/Deduction Types {FPRG-7} Entry in Medical Aid Structure {FPRG-8} Advised Amount, Advised Earning/Deduction
Fringe Benefit
5/U Before Tax.
Of all the Earnings / Deductions in this table, this Earning should have the lowest level
E 3810 Yes Yes Yes
Fringe Benefit Contra
6 After Tax D 9999 Not Required - see note Yes Yes
Employer Contribution
5/U After Tax D 4474 Yes Yes Yes
Employer Contribution Contra
6 After Tax E 9999 Yes Yes Yes
Employee Contribution
5/U After Tax D 4005 Yes Yes Yes
Medical Tax Credit
5/U After Tax E 4116 Yes Yes Yes
Additional Medical Tax Credit Will only calculate for Employees who are 65 years or older on the last day of the Tax year           5/U After Tax              E 4120 Yes                  Yes                        Yes

Note: Where Earnings or deduction are not linked to 'Global Earning Deduction Details' {FPRG-7} (as per table above), information for calculation purposes will be obtained from Earning/Deduction Types {FPRG-6} , for example GLA, Salary Level, Tax Code etc.


History of Changes

Date System Version By Whom Job Description
11-Dec-2006
v01.0.0.0 Frans
T109865 New Document
05-Feb-2013
v02.0.0.0
Sister Legwabe T189018
Medical Tax Credits
08-Apr-2016 v03.0.0.0 Sakhile Ntimane T213274 Updating Calculation Rules
10-Feb-2017 v03.0.0.1 Sakhile Ntimane T206202 Updating Calculation Rules