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
- The Medical Aid Structure {FPRG-8} exists
- The Lookup Table Detail {FPRG-5}
exists
- The relevant Earnings / Deductions has been set-up (Refer to the Recommended set-up rules below)
- The Tax Code of the Medical Tax Credit Earnings is "4116 -
Medical Scheme Fees Tax Credit" and the Calculation Method of the
Medical Tax Credit Earnings is "5 - Medical Aid" or "U - Medical Aid
Local Software".
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
- Tax Credits and Additional Tax Credits reduce the Tax
Liability of the employee and are show as separate transactions on the
payslip (Earning).
- The accumulated Tax Credit amount and Additional Tax Credit Amount for the service period within
the tax year may not exceed the accumulated value of the PAYE (Pay as
You Earn) deducted for the same period.
For Tax Certificate Reporting
- The PAYE Deduction (Tax Code 4102) is reduced by the Tax Credit
Amount (Tax Code 4116) and the Additional Tax Credit Amount (Tax Code
4120) i.e the amount reported under Tax Code 4102 is the sum of
Tax Codes 4102, 4116 and 4120.
- In addition to the above, the Tax Credit Amount is also reported
under Tax Code 4116 and the Additional Tax Credit Amount under Tax Code
4120.
- The Employee`s contribution (Tax Code 4005) is increased by the
Fringe Benefit Amount (Tax Code 3810) i.e the amount reported under Tax
Code 4005 is the Sum of Tax Code 4005 and 3810.
- In addition to the above Fringe Benefit is also reported under Tax Code 3810.
Calculation Rules
- Fringe Benefit (Tax Code 3810)
The
Fringe Benefit Amount calculated equals the Employer’s
Contribution Amount (Tax Code 4474)
- Medical
Tax Credit (Tax Code 4116)
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:
- The ED Code must be linked to the Appointment Type of the Employee {FPRG-7}
- The Tax Code linked to the ED Code must be ‘4116’
- The Calc Method defined for the ED Code must be either ‘U’ or ‘5’
- Either Tax Code ‘4005’ and /or Tax Code ‘4474’ must exist for the
Employee within the current Tax Year /Continuous Service Period
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 ED Code must be linked to the Appointment Type of the Employee {FPRG-7}
- The Tax Code linked to the ED Code must be ‘4120’
- The Calc Method defined for the ED Code must be either ‘U’ or ‘5’
- Medical Tax Credit (Tax Code 4116) must exist within the continuous Service Period in the current Tax Year.
- Either Tax Code ‘4005’ and /or Tax Code
‘4474’ must exist for the Employee within the current Tax
Year /Continuous Service Period
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 |