Previous page

Next page

PGPRTAXA084B - FRCS PayDay Filing Report January 2020 (Fiji)

Reports | Report Groups | PGPRTAXA | PGPRTAXA084B - FRCS Payday Filing Report January 2020

Summary

Report type: Hard-coded

For Fijian employers to fulfil their "PayDay Filing" reporting obligations from January 2020 onwards. You must use the the PGPRTAXA084B (prior to this you used PGPRTAXA084A).

PGPRTAXA084B creates a readable report file and an export file.

The export file is the one you upload to the FRCS Taxpayer Online Portal.

If you want to create a readable report file and an export file, you need to:

  1. Edit report settings to set Export to FRCA to "Yes", and enter the Export File Path and Export Sequence No values.
  2. Edit report destination to select the File options tab | Save to file checkbox, and enter Format and Filename for the readable report file.
  3. Run the report and check the readable report file.
  4. Run Send and Receive to send the export file to the Export File Path location and the readable report file to the Filename location.

Setup requirements

This report requires the following configuration work to be completed before running the report

  • Tax reporting category

    To ensure the correct monetary amounts are reported in the correct category, each applicable allowance must be mapped to the appropriate Tax reporting category.

  • Employer IRD number or Tax ID number

    Company Settings must contain a Payroll | Tax | Tax Details tab | Employer IRD number so it can be added to the export file and used in the export file name. If the report is filtered by internal company, it will use the Details tab | Tax ID number.

  • Approval Numbers

    Approval Numbers are required for Redundancy, Lump Sum, and Other One-Off payments. These Approval numbers should be recorded on the transactions that make the payments, in the Text field. The Approval number MUST be entered within square brackets for the report to pick up the values. If the number entered is less than 12 characters, the report will pad the value with leading zeros.

Contents

The report includes the following information:

  • Employee TIN
  • Date of Birth
  • Tax code
  • Residency Status
  • Employee's start and finish dates (within reported period)
  • Normal Income (Current period and YTD)
  • Directors' Remuneration (Current period and YTD)
  • Bonus/Overtime (Current period and YTD)
  • Redundancy (Current period and YTD)
  • Lump Sum (Current period and YTD)
  • Other one-off amount (Current period and YTD)
  • FNPF Deducted
  • Gross-up Employee
  • Income Tax
  • Social Responsibility Tax (SRT)
  • Environment Climate Adaptation Levy (ECAL)

The following table explains the fields on the FRCS PayDay Filing Report Setup form.

Field

Details

Period Type

You will only be able to select "Q. Pay Sequence selection"

Period Date Range

To run the report you must select one standard pay. The reported dates on the report will be based on the selected pay. You will be able to select multiple Manual pays, the values for these pays will be rolled into reporting dates of the associated Standard Pay.

Note: The Period Date Range is used for the Employment Start Date and Employment Finish Date values.

Employer Branch Number

Enter your three-digit number.

Export to FRCA

Yes/No field that determines whether an export file is created.

  • No - Only readable report is created.
  • Yes - Enables Export... fields below. Readable report and export file are created.

Important: The report will create an export file, only if the Report Destination | File options tab | Save to file checkbox is selected.

Export File Path

Enabled when Export to FRCA = "Yes".

Enter the location that you want to send the EMS export file to.

You do not need to enter a file name because the report will automatically use the file name format specified by FRCA (see below).

Export Sequence No

Enabled when Export to FRCA = "Yes".

Enter the sequence number for the export file in this reporting period. If this report is the first file created for this period, enter "1". If it is the second file, enter "2".

Important: If you are running multiple copies of the report for the same period, every time you run the report, you must update the Export Sequence No value. If you do not update this value, and you write files to the same Export File Path, each new file will overwrite the previous file because they will have the same name.

Employee

Leave this field blank to run the report for all employees. If you want to run the report for one employee, select that employee's record.

The following table explains the fields on the FRCA PAYE EMS File Report Destination form.

Field

Details

Destination options tab

Send to my inbox

Click this checkbox if you want to save copies of the readable report file and the export file to your inbox.

File options tab

Save to file

You must click this checkbox if you want to create an export file that you can email to FRCA.

Format

Select a format for the readable report file.

Filename

Enter the location that you want to send the readable report file to.

If this field is blank, Exolvo sends the the readable report file to the user's Temp folder.

Export File Name

The export file uses the following naming convention:

<TIN>-<Branch Number>-<Summary Year>-<Summary Month>-<Sequence Number>.csv

For example:

  • Employer TIN number = 123456789
  • Branch= 099
  • Summary Year = 2013
  • Summary Month = 03
  • Export Sequence No = 1

    Note: If Export Sequence No is blank in report settings, this part of the name defaults to 1.

These values will generate the following file name:

123456789-099-2013-03-1.csv