Full Salary Calculation  {FPRN-2}


Use this option to calculate salaries.


General information

Since a salary calculation could last for several hours, the program is executed in background mode. See the section on "Batch" in the Operational Aspects of  the ITS System


User Selection Prompt Text
* an item between square brackets [ ] is the default answer 		Type
&
Length		 Comments
1
 Must a full calc report be printed [Y] (Y)es/(N)o The report lists, per employee, every calculation in the sequence in which it was performed.
2 Must a referring report be printed [N] (Y)es/(N)o This report does not contain fatal errors, but is informative in nature and lists referred transactions, which were not found for specific employees.  (An example would be a person who does not receive a bonus this month, in which case the two global transactions for the employer's contribution to the Stabilization Fund would be listed).  The report is not normally drawn after successful take-on of the Payroll System.
3 Must a cumulative tax calculation be done [Y] (Y)es/(N)o
4 Supply minimum net pay to be flagged on Payment Analysis [0] 0 All employees receiving a net pay less than the answer will be flagged.
 

Example:

 


13-DEC-2011 15:30:06                                  ITS Integrator                                                  Page    1
f8Uccc.pc v01.0.1.2                    Pay Cycle 201104: Validation of PERSONNEL SERVICE RECORDS for THIS TAX YEAR ONLY
                                ================= ======================================= ----------------------


              0 FATAL ERRORS detected;        5 WARNINGS detected

 The WARNINGS will affect  Service Record Reports, and should be attended to

 Please execute Menu Options on {FPRIV} to see detail of the warnings
 ==================================================================

13-DEC-2011 15:30:06                                  ITS Integrator                       
f8Uccc.pc v01.0.1.2             Pay Cycle 201104: Validation of PERSONNEL DATA (Control Report) for THIS TAX YEAR ONLY
                                 ================= ============================================= ----------------------

Validation of FIXED SALARY INFORMATION:            0 FATAL ERRORS detected;        0 WARNINGS detected

Validation of FUND MEMBERSHIP INFORMATION:         0 FATAL ERRORS detected;        0 WARNINGS detected

Validation of SERVICE RECORDS:                     0 FATAL ERRORS detected;        5 WARNINGS detected

Validation of FEMALE MARITAL HISTORY RECORDS:      0 FATAL ERRORS detected;        0 WARNINGS detected

Validation of C RECORDS WITH NO Q RECORDS:         0 FATAL ERRORS detected;        0 WARNINGS detected

TOTAL VALIDATION:                                  0 FATAL ERRORS detected;        5 WARNINGS detected

 Validation took     0.00 min. for 67 people







Date : 13-DEC-2011 15:30                    ITS Integrator                                              Page:    1
Program : f91ccc.pc v01.0.0.4        Non-Balancing Non-Printable Salary Transactions
                                     For Monthly Cycle 201104 ( 01-APR-2011       30-APR-2011       )
                                     Calc/Sequence No  1  1
Personnel                E/D
Number    Month  Year    Code   Date            Print  Type          Amount
--------- -----  ----    ----   ----            -----  ----          ------

Total Earnings    :               0.00
Total Deductions  :               0.00
                    ------------------
Nett Difference   :               0.00
                    ==================

                                              *** Payslips Are In Balance

13-DEC-2011 153006                                       ITS Integrator                                               Page: 1

Program : f82ccc.pc   Salary Transaction Validation For Monthly Payroll Cycle : 201104 And Calc Number : 1

                      ============================================================================



SALARY CALCULATION ASSUMED TO BE THE FIRST RUN OF THIS MONTH and CALC NUMBER WITH SEQUENCE NUMBER 1

SALARY CALCULATION HAS ALREADY BEEN DONE FOR 0 PERSON(S) FOR CALC NUMBER 1 :


 Merge took     0.02 min.


       411 records written to merge file


                                       ITS Integrator                       

Date : 13-DEC-2011   Invalid Transaction Report for Monthly Cycle : 201104, Calc/Seq. No: 1/0                              Page :    1
Time : 15:30:07         ===========================================================
NO TAX DEDUCTED FOR PERSON NO.      9001:  Annual remuneration         12000.00 is below Tax Threshold         46000.00
Message = 58 NULL NOTCH,REF.LVL,WEEKLY OR HOURLY RATE - NO CALC     Person =      9038; E/D Code = 0014; Calc Method = D

 Calc took     0.02 min.


 NO. OF TRANSACTIONS = 130;   NET SALARY =    150421.78
    ACTIVE PERSONNEL = 26;   NON-ACTIVE PERSONNEL = 37;   PERSONNEL WITH BREAK IN SERVICE = 0
NO. OF REJECTED GLA's = 0;   NO. OF INACTIVE GLA's = 1;   NO. OF PRE-TAX BOX 99 TRANSACTIONS = 0
PAYE REMUNERATION = 202753.38             SDL REMUNERATION = 205878.38       
UIF REMUNERATION = 186310.52       

END OF CALCULATION

                                       ITS Integrator                       

Date : 13-DEC-2011      Inactive GLA Report for Monthly Cycle : 201104, Calc Number : 1                                  Page :    1
Time : 15:30:07        =============================================================

                              (Transactions WILL BE POSTED to SUSPENSE GLA MAC1 2012    )


               Person                    Earning/Deduction                     Cost Centre                 Account
--------- ------------------------- ------------------------------------- --------------------------- -------------------------------
       60 Botes, Mrs KA             0014 D UNPAID LEAVE                   6000 FINANCIAL ADMIN        0101     Salaries-Permanent S


NO. OF INACTIVE GLA's = 1

                                        *****  END OF REPORT  *****

13-DEC-2011 15:30:09                                ITS Integrator
f8Cccc.pc                                                Payment Analysis
                               for Monthly Cycle : 201104 (01-APR-2011 / 30-APR-2011), CAlc/Seq. No: 1/ALL

                        By ACB Tape Transfer      45005.72       3 payees
                        By Bank Transfer          24223.85       2 payees
                        By Cheque                 81192.21       8 payees
                        By Cash                       0.00       0 payees
                        Unallocated                   0.00       0 payees
                                              ------------   -----
                        TOTAL PAYMENT            150421.78      13 payees
                                              ============   =====

                           Employees with zero payslips  =      13

                                       Active employees  =      26


                                    ----------
     Total of Negative Payslips           0.00      No. of Negative Payslips = 0
                                    ==========

                                       ITS Integrator                       

Date : 13-DEC-2011      Full Calc. Report for Monthly Cycle : 201104, Calc/Seq. No: 1/1                              Page :    1
Time : 15:30:07         ===========================================================
E/D                              Tax   C Sa S
Code  Earning/Deduction          Box R M L  L          Amount        Level Total       UIF Tot       WCA Tot GLA
----  ------------------------- ---- - - -- -          ------        -----------       -------     -------   --------------
60        Botes, Mrs KA                                TAX C0   MED 0      SR ACCOUNTANT (FINANCIAL SERV)             TAPE TRANSFER
          Birth Date: 19400515       Appointment Type: 1    Resignation Date: 21000101

0001E Salary                   3601 Y 7  0 N           6000.00            6000.00                             6000  9350      P:  CC
0002D Salary Contra            3601 Y 6  1 N           6000.00-              0.00                             6000  9350      P:  CC
0010E Basic Salary             3601 Y 6  3 Y           4800.00            4800.00       4800.00      57600.00 6000  0501      P: GLA
0020E Travel Allowance         3701 Y 6  5 Y            600.00            5400.00       5400.00      64800.00 6000  0501      P: GLA
0014D UNPAID LEAVE             3601   D  5 Y           1363.64-           4036.36       4036.36      63436.36 MAC1  2012    SUSP GLA
0021E Cell Phone Allowance     3601 Y 6  5 Y            600.00            4636.36       4636.36      70636.36 6000  0501      P: GLA
0055E OVERTIME WEEKDAYS        3601 Y E 12 Y           2465.75            7102.11                             6000  0501      P: GLA
0150E ANNUAL BONUS             3605   2 15 Y           7102.11           14204.22                             6000  0501      P: GLA
4000D PAYE                     4103   4 50 N           1416.76-          12787.46                             6000  9316      P:  CC
7011D UIF:  Payment to Fund           B 90 N             46.36-          12741.10                             6000  9340      P:  CC
7050E Skills Levy                     V 96 N             71.02           12812.12                             6000  0501      P: GLA
7051E VAT on Skills Levy              6 97 N              0.10           12812.22                             6000  0501      P: GLA
7052D Skills Levy Contra              K 98 N             71.12-          12741.10                             F001  0677  
-----------------------------------------------------------------------------------------------------------------------------------
65        Malan, Mrs V                                 TAX C0   MED 0      EXTERNAL EXAMINER                          TAPE TRANSFER
          Birth Date: 19280229       Appointment Type: 1    Resignation Date: 20110614

0001E Salary                   3601 Y 7  0 N          37760.17           37760.17                             0310  9350      P:  CC
0002D Salary Contra            3601 Y 6  1 N          37760.17-              0.00                             0310  9350      P:  CC
0010E Basic Salary             3601 Y 6  3 Y          37760.17           37760.17      37760.17     453122.04 0310  0102      P: GLA
4000D PAYE                     4103   4 50 N          19279.40-          18480.77                             0310  9316      P:  CC
7011D UIF:  Payment to Fund           B 90 N             48.49-          18432.28                             0310  9340      P:  CC
7050E Skills Levy                     V 96 N            188.80           18621.08                             0310  0102      P: GLA
7051E VAT on Skills Levy              6 97 N              0.26           18621.34                             0310  0102      P: GLA
7052D Skills Levy Contra              K 98 N            189.06-          18432.28                             F001  0677  
.
.
.

 NO. OF TRANSACTIONS = 130;   NET SALARY =    150421.78
    ACTIVE PERSONNEL = 26;   NON-ACTIVE PERSONNEL = 37;   PERSONNEL WITH BREAK IN SERVICE = 0
NO. OF REJECTED GLA's = 0;   NO. OF INACTIVE GLA's = 1;   NO. OF PRE-TAX BOX 99 TRANSACTIONS = 0
PAYE REMUNERATION = 202753.38             SDL REMUNERATION = 205878.38       
UIF REMUNERATION = 186310.52       

END OF CALCULATION


Date : 13-DEC-2011 15:30                                 ITS Integrator                                                 Page :    1
Program: f60ccc.pc v02.0.0.0                  Annual Bonus (Calc Method 2) Already Calculated in Tax Year
                                              Salary Calc Cycle: 201104
                                              Monthly or Weekly: M
                                              Calc/Seq No: 1/1

CALC METHOD 2(ANNUAL BONUS) HAS BEEN USED MORE THAN ONCE WITHIN THE TAX YEAR FOR EMPLOYEES IN THIS SALARY CALC.
THIS MAY AFFECT THE PAYE DEDUCTION. PLEASE CORRECT BEFORE FINALIZING THIS SALARY CALC.

Employee                                        ED                                      Salary
Number    Surname                        Init   Code                  Amount Year Cycle Level
--------- ------------------------------ ------ ---- ----------------------- ---- ----- ------
1         Magnificus                     JCC    7051                    0.15 2011 3         97


                                                  **** End Of Report ****

 


Processing
Rules		  
 1 Before the calculation starts, the validation of payroll data will automatically be done for all personnel linked to the specific calculation number of the salary calculation as specified in the "C-Salary Calculation" record of the Run Cycle Control File {FPRM-2}. The validation may also be done separately using Validate Payroll Data {FPRIV-1} in which case data for all personnel that is in-service for the specific tax year will be validated. Refer to the on-line documentation of Validate Payroll Data {FPRIV-1} for more detail.
  • In the case of warnings, the validation report will display the number of times a specific condition leading to a warning is encountered. Details of records that caused warnings may be displayed by executing Validate Payroll Data {FPRIV-1}.
  • The occurence of "Fatal Errors" will terminate the process.
2 The actual salary calculation is done. Refer to the  Salary Calculation Procedure {f83ccc.html} for more detail.
  • The Pay Frequency, Pay Cycle and Calculation Number for which the calculation should be done is obtained from the "C - Salary Calculation" record in the Run cycle Control File {FPRM-2}
    •
  • All personnel in service during the pay cycle, with the pay frequency and calculation number as indicated will be included in the calculation provided that their salaries was not already calculated.
  • Should a "C - Salary Calculation" record in the Event Log File {FPRM-3} already exist for this cycle and calc number, the program will give a message indicating the number of persons who have already been calculated for and the sequence they are linked to and indicate the sequence number to be used for the persons now being calculated.
  • As soon as the calculation process starts, an "O" - Calc in Progress record is created in the Event Log File {FPRM-3} for the specific calculation number, sequence number and payroll cycle. 
  • Once the calculation process is finished the "O" - Calc in Progress record will be converted to a "C" - Salary Calculations record to indicate that a salary calculation for the payroll cycle for the specific calculation number and sequence number was done.
    • The "O" - Calc in Progress record can be viewed in Maintenance on Event Type O {FPRM-28}.
      In the event that the calculation process being interrupted  e.g. due to a power failure the "O" record will not be converted to a "C" record and the calculation process may then be to done again with the following steps:
    1. Change the "O" record manually to a "C" record in Maintenance on Event Type O {FPRM-28}
    2. Roll the calculation back with Rollback Full Calculation {FPRN-22}.
    3. Restart the calculation 
    5 After the salary calculation,  the program to Validate Non-Printables {FPRNR1-7} is automatically executed.
    Please note that even if this automatic validation is clean, subsequent single rollbacks and - calculations may still introduce non-balancing transactions. We recommend that  {FPRNR1-7} is always executed again just before payslips are produced.
    6 The Payment Analysis {FPRNR2-3} is also automatically executed to draw attention to personnel with a negative nett pay and personnel with invalid payment methods.
    7 The program to report on Personnel Members where Calculation Method "2 - Annual Bonus" was used more than once {FPRIR1-28} in the same Tax Year is also automatically executed.


    See Also:

    History Of Changes

    Date System Version By Whom Job Description
    12 Dec 2006
    		 v01.0.0.0 Frans t109865 New manual format.
    12 Feb 2007 v01.0.0.0 Frans t126911 Date Effective Notch
    09 May 2007 v01.0.0.0 Allie t141046 Change validation of data per calculation number.
    05-Oct-2009 v01.0.0.1 Charlene van der Schyff t162254 Edit link to find correct target.
    08-Dec-2011 v01.0.0.2 Frans t171865 Calc Method 2 used more than once
    08-Dec-2011 v02.0.0.0 Frans t179271 Integrator 2
    14-Dec-2011 v02.0.0.1 Frans t179323 Add Birthdate, Bonus Month, Resgination Date and App Type to Calc Report