Skip to main content
All CollectionsIndigo Payroll & LeaveEnd of Year Process
How do I allocate C.O.L.A. to all employees at once?
How do I allocate C.O.L.A. to all employees at once?

Using the Global Basic Pay Adjustments Utility for COLA

Jake Ellis avatar
Written by Jake Ellis
Updated over 2 weeks ago

Are you in a video-watching mood? πŸ€“

The Global Basic Pay Adjustments Utility allows you to change the basic pays of employees in bulk. This can be found in the Payroll and Leave module under the Utilities section.

The utility will allow you to select particular (or all) employees and affect basic pay adjustments for them.

  • After accessing the Global Basic Pay Adjustments page, select employees using the checkboxes to the left of the grid. Note that you can still activate the System Filter sidebar as usual.

  • On the right side of the page, you can set up the needed adjustments by filling the fields below.

    • Effective Date section
      ​

      • Effective Date field: The date on which the basic pay adjustments take effect (usually the first of January for C.O.L.A).
        ​

    • Fixed Pay section
      ​

      • Type: two options are available (Amount and Percentage), but for this scenario you can leave Amount.

      • Frequency: it's set as Week by default.

      • Amount: the figure to add up or deduct (negative value) to the basic pay.

      • Minimum Wage: this is the amount you may want to update to align with the value set by authorities.

        • If Amount (e.g. 5) is set, and a Minimum Wage (e.g. 250) is entered, the system will check if any employees are earning below the minimum wage. If so, their pay will be adjusted to meet the new minimum wage which will include the C.O.L.A increase.

          • John's current minimum wage is 240 (below the official minimum wage of 250).

          • Amount = 5 (cola); Minimum Wage = 250.

          • John's wage will be updated to 250.

        • If Minimum Wage is set to 0.00, the system will ignore the minimum wage and only perform the Global Basic Adjustment (C.O.L.A).

          • Amount = 5 (cola); Minimum Wage = 0.00.

          • John's wage will be updated to 245 (as John's starting minimum wage was 240).

        • If you realised you made a mistake and want to correct it, add exactly the same value you added in your last adjustment. Then set the previous value in the Amount field as negative and click on Generate.

          • John's current minimum wage is 250 (by previous mistake).

          • Amount = -5 ; Minimum Wage = 250.

          • John's wage will be 245 (the minimum wage field was ignored).
            ​

    • Hourly Pay section should be filled along with the Fixed Pay, so both Fixed and Hourly employees are updated.
      ​

      • Type: set it as Amount.

      • Frequency: it's set as Hour by default.

      • Amount: it can be either a flat rate or percentage, depending on your selection. It works the same way as the Amount field for the Fixed Pay section.

      • Minimum Wage: this is the hourly amount you may want to update to align with the value set by authorities. It works the same way as the Minimum Wage field for the Fixed Pay section but with hour-related figures.
        ​

    • Update all basic pays for employee after effective date: it instructs Indigo to update future basic pays too with this new increase automatically after the effective date.
      ​

  • Click Generate to perform the adjustments selected.
    ​

Click on Audit to consult the list of the bulk amendments you ran along with its details in a grid.
​

  • Audit No: internal code to identify the Audit created at the global adjustment generation.

  • Effective Date: the adjustment will occur when this date hits.

  • Type: it shows if you chose Amount or Percentage.

  • Frequency: it shows if the adjustment applies to the weekly wage or hourly wage.

  • Amount: the value you inserted to add or subtract from the current wage.

  • Weekly Minimum Wage: the weekly value you input when generating the adjustment.

  • Hourly Minimum Wage: the hourly value you input when generating the adjustment.

  • Update all basic pays for employee after effective date: it shows if the checkbox was ticked or not.

Select the Lines tab on the top right corner, if you want to look at the history for a specific employee you amended.

  • Audit No: internal code to identify the Audit created at the global adjustment generation.

  • Reference: internal code for the specific line inside an Audit record.

  • Employee Code: code assigned to the employee in the Employee profile.

  • Original Basic Pay: the Basic Pay value before the adjustment.

  • New Basic Pay: the Basic Pay value after the adjustment.

  • Basic effective date: the date the adjustment will be effective.

  • Remarks: here you will see 'Increased to Minimum Wage', if the weekly or hourly wage were lower than the minimum wage and the global adjustment amended this.


Did this answer your question?