The following changes are required:

1.  FRCS Regulation 06 Formula enhancement with SRT Ring Fencing calculations. Review attached documents.

   1. PAYE Scenarios 

   2. PAYE Scenario Results

2. New EMS File format. Review attached documents. 

   1. EMS File Format

   2. EMS Sample File

   3. New fields

      1. Directors Remuneration - Scenario : Tax Payer O 

      2. Bonus/Overtime

      3. Redundancy Payment Approval No - Provided by FRCS. Scenario : Tax Payer I

      4. Lump Sum Payment Approval No - Provided by FRCS. Scenario : Tax Payer H

      5. Other One- Off Payment Approval No - Provided by FRCS.

      6. Gross- Up Employee 

         1. Yes - X

         2. No -  Y

      7. Income Tax - PAYE

3. PAYE reports - Sitla to check with Shaneen

4. File Upload - FRCS to confirm on the procedure

New Features

1. Option to enter the approval codes for redundancy, lump sum and other one-off payment.

2. Define if the “Gross” would sum up for an employee

3. Define “Director Fees” components.

Discussions from FRCS:

Test database has been created for the case.

DB: LINKSOFT_FIJI
Server: 10.0.0.14
Version: 10.0.145

Details

Copies from Case No. 10513 created by Aarti

FRCS has announced that their EMS file format has changed. The following are the changes to be incorporated:

1. The EMS will no longer be in text format from 01/08/2019
2. The file’s format has changed to csv (output in excel)

However, prior to date 01/08/2019, the file format will remain the same. So, companies will submit the as it is till 31/07/2019. However, from 01/08/2019 the new file will come into effect.

We will need to maintain both the formats in the system.

Please refer below for definitions of:

1. Normal
2. Directors’ Remuneration
3. Bonus
4. Redundancy
5. Lump Sum Payment
6. Other One-off Payment
   
   

The following changes need to be made:

1. Screen Changes:
   1. On Employee profile screen:
      1. introduce a field for Gross-Up:
         1. The employees can either be marked as “-“ or “x”
   2. On paycode screen:
      1. We need to classify paycode as:
         1. Normal
         2. Directors’ Remuneration
         3. Bonus
         4. Redundancy
         5. Lump Sum Payment
         6. Other One-off Payment
   3. When either Redundancy, Lump Sum Payment or Other One-off Payment is made, FRCS provides an approval number, which needs to be entered on the pay edit screen so that it can be displayed in the csv file
2. Report Changes:
   1. PAYE Reconciliation Report:
      1. Should generate in both the old format and the new format
      2. Old format on and prior to date 31/07/2019
      3. New format on and from date 01/08/2019
   2. Employer Monthly Schedule:
   1. Should generate in both the old format and the new format
   2. Old format on and prior to date 31/07/2019
   3. New format on and from date 01/08/2019

Development work for this case has been completed.

The change will be available in version: 10.146 & 11

1. The following changes were made(Include Database object names, Program classes and any other relevant information):|

1. Added the following values to Pay Classification dropdown:
   1. Normal
   2. Directors’ Remuneration
   3. Bonus
   4. Redundancy
   5. Lump Sum Payment
   6. Other One-off Payment
2. Added data migration to update the pay codes with the values above.
3. Added additional field in employee profile for "Gross-Up". When "Gross-Up" value is set to Yes, the system will print "x" in the Tax EMS file for "Gross-Up" column otherwise it will print "-".
4. Added "Approval Code" column in Pay Edit entries & Manual Pay Edit Entries screen
5. Changed the tax calculation formula to match with the FRCS tax scenarios.
6. Changed the PAYE Electronic file to print CSV file format when the period ending is greater than 31/07/2019. The previous file format is still printed when the period ending date less than 31/07/2019.
7. Changed Tax monthly employer schedule report to print the required columns based on the "period ending date" selected.

2. The issue was caused by:

1. Legislative change

3. Next Step:

1. UAT

4. Notes:

PAYE changes have been developed in version 11 for accreditation. 

The following has been :

1. Tested the PAYE scenarios as per the attached FRCS cases.
2. Verified the EMS file format.
3. Validated that the EMS file can be extracted both in "Text" and "CSV" format.

Test Environment 

• Server - QA4
• Database  - LINKSOFT-FJ-PAYE
  
• Version - 11.719.

Next Step : Present PAYE changes to FRCS for accreditation

Hi Team, 

We have presented the PAYE scenarios and the results to Shaneen and Bhavna in FRCS.

The formulation is correct. FRCS has requested for EMS files for validation.

Next Step:

Rashna and SItla to submit requested file.

Thanks:
Rashna

Hi Alvis, THe PAYE format has not been approved. We need the old format to be placed back in V10.148.

1. We created a demo database 'DEV-LINKSOFT-10148-FijiPAYE'' with the scenarios from FRCS.
2. Created pays and verified the PAYE results. Results as attached.