How-to

Upload arrears

Last updated November 30, 2022 · Tushar Agarwal

Arrears (sometimes also known as an arrearage) is a legal term for the part of a debt that is overdue after one or more required payments have been missed. In short, arrears are money that is owed and should already have been paid. In HRStop, the admin can add arrears in the system for any employee.

HRStop lets you, as an admin, upload arrears in bulk. You can also manually add the arrear for a particular employee.


Follow these steps to upload arrears in bulk:

  1. Navigate to Control Panel → Payroll → Arrears.

  2. On the Arrears page, click the Import Arrears button in the action bar. A new page opens, showing the fields to upload the arrears.

  3. Read the tips section on the page for help. The file has the following column heads, where you can update the relevant information:

    • Arrear Name: The name of the arrear

    • Arrear Type: Earning/ Deduction

    • Arrear Value: The amount to be paid, e.g., 400, 5000, etc. Or, if you want the system to auto-calculate the amount for a certain number of days, enter the number of days here and set “Calculation Mode” to Days (see the next point)

    • Transaction Date: The transaction date for the month in which the arrear is to be considered while processing the payroll.

    Calculation Mode: Enter Amount / Days, depending on the calculation you want to process.

    If you enter Amount in this field in column J, column H (Arrear Value) holds the amount you want to add/deduct for the employee.

    If you enter Days in this field in column J, column H (Arrear Value) holds the number of days you want to add/deduct for the employee.

    Category: Taxable/ Non-Taxable (as per the category of arrear)

    Arrear Status: Unprocessed. (When the payroll is processed and the transaction date falls within the payroll period, the arrear status automatically changes to Processed.)

    Consider In Deduction: Update: True (if considered), False (if not considered)

    Is Consider In PF: Update: True (if considered), False (if not considered)

    Is Consider In ESIC: Update: True (if considered), False (if not considered)

  4. Click Download Sample CSV file. A .CSV file is downloaded.

  5. Edit it and upload it in the Upload File field.

  6. Select the Date Format used in the uploaded file.

  7. Click Review and Upload/ Upload (to upload directly), or click Reset to clear the details.

  8. An option to map the system fields against the uploaded fields is available (you can manually change the mapping if there is a mismatch).

  9. Click the Preview button to preview the uploaded data.

  10. Click the Upload button to upload it.

All changes take effect instantly.