Differences

This shows you the differences between two versions of the page.

spay:procguide:monthlytask_monthly_mra_special_allowance [2018/02/07 22:44]
mclement created 		spay:procguide:monthlytask_monthly_mra_special_allowance [2023/01/18 15:13] (current)
mclement
Line 1: Line 1:
-====== Monthly MRA Special Allowance ======+====== Monthly MRA Special Allowance Statement======
-As per the MNS announcements published in January 2018, additional changes (Employment Type) should be provided. the changes are applicable as from period December 2017 (201712) again through a new csv file.+Before exporting the MRA Special Allowance Statement for the fisrt time, it is compulsory to insert the appropriate bank code of each bank in Sicorax Payroll through References | Bank . To do so use the steps below:
-To export the Monthly MNS PAYE Return, use the steps below.+====== MRA Bank Codes ====== 
 + 
 +The following is the official list of bank codes provided by the MRA for the purpose of the MRA Special Allowance Statement. The list is available on the website of the MRA through the following link www.mra.mu/download/excelTemplateSpecialAllowance.xlsx 
 + 
 +  *  **The Mauritius Commercial Bank Ltd: MCB-01** 
 +  *  **ABC Banking Corporation Ltd: ABC-01** 
 +  *  **The Hongkong and Shanghai Banking Corporation Limited: HSBC-01** 
 +  *  **Standard Chartered Bank (Mauritius) Limited: SCB-01** 
 +  *  **Banque des Mascareignes Ltee: BMAS-01** 
 +  *  **Barclays Bank PLC: BARC-01** 
 +  *  **State Bank of Mauritius: SBM-01** 
 +  *  **SBI (Mauritius) Ltd :  SBI-01** 
 +  *  **MauBank Ltd: MPCB-01** 
 +  *  **Investec Bank (Mauritius) Limited: INVB-01** 
 +  *  **Bank of Baroda: BOB-01** 
 +  *  **Habib Bank Limited: HABB-01** 
 +  *  **Bank of India International Ltd: INIL-01** 
 +  *  **Standard Bank (Mauritius) Limited: SBL-01** 
 +  *  **Bank One Limited: BOL-01** 
 +  *  **Afrasia Bank Limited: AFRB-01** 
 + 
 + 
 +** How to insert MRA Bank Codes through Refernces | Bank ** 
 + 
 +{{:spay:procguide:references_bank_mraspcallw2018.png|}} 
 + 
 +Step 1: Go to References 
 + 
 +Step 2: Click Bank icon  
 + 
 +{{:spay:procguide:bank_external_code_mraspcallw2018.png|}} 
 + 
 +Step 3: Insert External Code as per above illustration 
 + 
 +Step 4: Click Save 
 + 
 +To export the MRA Special Allowance Statement, use the steps below.
{{:spay:procguide:xmlexport2017.png|}} {{:spay:procguide:xmlexport2017.png|}}
Line 11: Line 47:
Step 2: Click XML Exports icon Step 2: Click XML Exports icon
-{{:spay:procguide:mnspaye2018_criteria_export.png|}}+{{:spay:procguide:spay_mra_spc_allw_export_2020.png|}}
-Step 3: Double-click Monthly MNS PAYE Return (Jan 2018) as per below illustration+Step 3: Double-click MRA Special Allowance Statement (Jan 2018) as per below illustration
Step 4: Insert the following criteria: Step 4: Insert the following criteria:
Line 22: Line 58:
  * **Company**: Choose company from the list   * **Company**: Choose company from the list
- 
-  * **P/D to exclude from return**: Select End of Year Bonus (13th month bonus) code(s) from the lookup icon (refer to the following illustrations for further explanation) 
  * **Telephone number**: Insert number, it should be equal to 7 numeric characters   * **Telephone number**: Insert number, it should be equal to 7 numeric characters
Line 30: Line 64:
  * **Company Email address**: Insert the contact email address of the company   * **Company Email address**: Insert the contact email address of the company
- 
-  * **Name of Declarant**: Insert the name, it should bear UPPER CASE letters and/or numeric characters (max 50 characters) 
- 
-  * **File name**: Insert file name, it should be less than 21 characters long 
  * **Directory**: Click lookup icon to browse and select the folder to which you want to export the file   * **Directory**: Click lookup icon to browse and select the folder to which you want to export the file
Line 39: Line 69:
Step 5: Click Export button from the toolbar Step 5: Click Export button from the toolbar
-{{:spay:procguide:mnspaye2018_criteria_eyb.png|}} +**NB:(1) For employees whose National ID is missing in the system a message will be shown in the log indicating invalid NID and the export file will be incomplete. You will need to update the NID in the Employee master file and export the file again (2) The log window indicates anomalies on the export file, e.g Value is required for P/D to exclude from return, invalid NID, wrongly inserted Name of Declarant, Telephone number, etc.  **
- +
- +
-**Above illustration: How to exclude End of Year Bonus from the Monthly MNS PAYE Return (Jan 2018)** +
- +
-Step 1: Click lookup icon +
- +
-Step 2: Select End of Year Bonus payment code(s) +
- +
-Step 2: Click Apply button +
- +
- +
-**NB:(1) The file contains tax payers and non-tax payers and for those whose National ID is missing in the system a message will be shown in the log indicating invalid NID and the export file will be incomplete. You will need to update the NID in the Employee master file and export the file again (2) The log window indicates anomalies on the export file, e.g Value is required for P/D to exclude from return, invalid NID, wrongly inserted Name of Declarant, Telephone number, etc.  **+
A sample of the csv file is shown below: A sample of the csv file is shown below:
-{{:spay:procguide:mnspaye2018_csv.png|}} +{{:spay:procguide:spay_mra_spc_allw_csv_2020.png|}}
- +
-====== Employment Type - Employee Masterfile ====== +
- +
-To update your Employee Masterfile with the appropriate Employment Type value, follow the steps below. +
- +
-{{:spay:procguide:employmenttype.png|}} +
- +
-Step 1: Go to Employee +
- +
-Step 2: Click Employee icon  +
- +
-Step 3: Fill in employee details+

Views
Personal Tools