Calculating withholding amounts on lump sum payments using Method B(ii)

This article outlines the steps involved in calculating the withholding amount (PAYG and STSL) on a lump sum payment when using Method B(ii).

In accordance with the ATO, the Method B(ii) option should be used when either processing:

• back payments relating to a prior financial year; and/or
• any additional payments (including commissions, bonuses or similar payments) that don’t relate to a single pay period regardless of the financial year the additional payment applies to.

This method calculates withholding by averaging all additional payments made in the current financial year over the number of pay periods in a financial year, and applying that to the average total earnings to date.

To process a lump sum payment for an employee in a pay run using this method, click on Actions > Add Lump Sum Payment. An earnings line will appear as follows: 

Ensure the following actions are completed:

• Select the pay category,
• Ensure the correct location is selected, 
• Enter any notes if applicable (optional),
• Enter the unit(s) if it differs to the default value of "1",
• Enter the lump sum rate/amount,
• Select "Method B(ii)" from the calculation method dropdown.  

Once you save the employee's pay, a tooltip will appear to the right of the "Method B(ii)" label. 

Clicking the tooltip will open a context panel containing details of how the withholding amount has been calculated as per the ATO's guidelines. 

Interpreting the data in the context panel

Each step includes a tooltip that explains how each value was determined as per the below screenshot:

We will provide more detail here on some of the steps used to calculate the withholding amount.

Step 1: Average Earnings

Average earnings are calculated by applying the employee's YTD earnings, including the current pay run, excluding termination payments and lump sum payments processed using Method B (ii) ("normal earnings"). This amount is then divided by the number of pay runs, including the current pay run, in the financial year. When determining the number of pay runs in the financial year, this also includes pay runs that an employee has not been paid, for eg say an employee has a weekly pay schedule and there were 10 pay runs that had been processed since the start of the financial year. The employee had only been paid in 8 of these pay runs (as did not work any hours to be paid in 2 pay runs), the number of pay runs would still be deemed 10.

Where a lump sum payment is being processed for an existing employee in the first pay run of the financial year, the normal earnings will be calculated using the previous financial year's earnings.

Where a lump sum payment is being processed for a new employee in the first pay run of the financial year, the normal earnings will be calculated using the employee's expected earnings for the year. This is determined using the employee's hourly rate of pay x hours per pay period x pay frequency, as detailed in the employee's Pay Run Defaults screen.

Opening balances are also applied when determining normal earnings - to clarify this is only the case where the opening balances financial year setting is the same as the financial year for the pay run being processed.

You can override the normal earnings calculated by the system. To do this, click on the 'Override normal gross earnings' checkbox, enter the desired normal earnings amount and then click on 'Save'.

Ensure you enter the YTD amount in this field as the system will then calculate the average earnings. 

Step 3: Average Additional Earnings

Additional earnings include any YTD lump sum payments, including the current pay run, that were processed using the Method B(ii) option. This will also incorporate any opening balance amount entered in the employee's "Additional Payments (Opening Balance)" field (Opening Balances screen > Earnings tab).

This amount is then divided by the number of pay periods in the financial year, for eg if the employee is on a weekly pay schedule the amount will be divided by 52; if on a monthly pay schedule the amount will be divided by 12.

Step 9: Maximum amount withheld

There is a withholding limit of 47% on tax withheld from any lump sum payments using Method B(ii). As such, you will notice the final amount withheld will never be higher than the amount calculated in this step.

Applying this withholding limit may result in withholding not being sufficient to cover some employees' end of year tax liability. In these situations, an employee can ask their employer to increase their withholding for the remainder of the financial year. To do this, you would need to process a PAYG adjustment in the employee's pay. 

Working Holiday Makers & Lump Sum Payments

Employees defined as working holidaymakers are not subject to this method when calculating the withholding amount on lump-sum payments. Rather, working holidaymakers are taxed in accordance with the Tax table for working holidaymakers. As such, when entering a lump sum amount for a working holidaymaker, you will not be asked to select a calculation method.