Leave amount is incorrect in the Payslips. Although it is correct in the employee’s record.

Legacy KB ID: 5623

Question

Why are the accrued leave hours (including Annual leave or personal leave) are printed wrong in the payslips? I have tried correcting the hours on the employee’s leave card, however, it is not reflecting correctly in the payslips. How can I fix it?

Why do payslips from the latest version of Reckon Accounts Business show an incorrect amount of Accrued leave, while other reports show the correct amount?

Answer

Whom does this apply to?

This issue is effecting random Reckon Accounts Business (Plus, Premier and Enterprise/Hosted) users using 2015 and later releases.

Analysis:

We have identified the issue where the payslips of some employees do not display the correct accrued leave hours.

We understand although the payslips do not show the correct hours, the leave liability report and the leave hours in employee actual record shows the correct hours.

We have found that this issue usually occurs after you've updated an employee's leave hours from their profile and/or by updating a previous financial year's pay run after a pay run created after 1 July.

In other cases, the main cause has been data corruption within the data file.

Workaround 1

Note: While we have known this workaround to fix most of the issues we have tested, we can not warrant that it will fix the issue in every case.

The workaround to the issue is to reset the hours for leave for the employee and entering it manually after rebuilding the files 3 times.

Please follow the below steps to fix the issue which is categorised into two parts:

Part 1: Preparations
  1. Backup the file. Make a fresh new backup of your Reckon file and keep it separate in a safe location so you can easily access it if required.
  2. Print the Current ‘Leave liability’ report and ensure you know the current leave accruals for each employee prior to making any changes.
Part 2: Execution
  1. Go to the employee menu and select the employee which has an issue with leave.
  2. Edit the employee.
  3. Go to ‘Payroll & Compensation’ Info Tab
  4. Click on the Leave Details Tab
  5. Note down the existing Year Begins on “xxxxx”, Day “xx” and Begin accruing time on “xx/xx/xx” field for the employee (or take a screen shot of the existing details. As you will need to enter them back once the fix is done.)

  1. Complete step 5 (above step) for both Personal and Holiday
  2. Tick the 'Reset hours each new year' option for the employee
  3. Enter the Year begins on, Day and Begin accruing time on field as a date after the last pay entered but prior to the next pay date (i.e. if the last pay was on 08/11 and the next pay is on 15/11 enter any date between 09/11 & 14/11 as the reset date)
  4. Do this for both Personal and Holiday
  5. Rebuild the data file 3 times (File > Utilities > Rebuild)
  6. Process the next pay (eg 15/11), the leave will reset.
  7. Go into the Employee record and enter the correct Amount of Personal and Holiday Leave (and untick the Reset option)
  8. Enter the correct ‘Year begins on’, ‘Day’ and ‘Begin accruing on’ field as well as noted in step 5 above.
  9. Next week when you process the next pay (i.e. 22/11), the leave accruals will be correct in Payslip & Employee Record and the Transaction.

Workaround 2:

If Workaround 1 does not resolve the issue, you can consider trying the following:

  1. Create a new employee profile with the same employee information
  2. Deactivate the old employee record and exclude it from payment summaries and single touch payroll. 
  3. Enter the same employee number in the new record (you may change the employee number in the old record to something else)
Note: Do not skip this step. It is essential that you report all single touch payroll using the same employee number. Using a new employee number for STP during the year will result in two or more payment summaries getting generated at the ATO's end.
  1. Enter payroll year to date values and current leave accrued.
  2. Test the new profile and begin to use it.
  3. Refer to the old inactive employee record for all historical data. 

If this is happening on all of the employees, you may do the following workaround:

7. Export Employee list together with Pay items list using IIF. (File>Utilities>Export>Lists of IIF files.)

8. Modify existing employee records by changing their existing Employee Numbers and adding a prefix "OLD - " to the Employee First name or a suffix "-OLD" to the Last name.

9. Import back the IIF file. This should create a new employee profile. You can then add the Leave balances. (File>Utilities>Import>IIF files.)

10. Create a test pay run. Leave should now accrue as expected.

Need more help?

Ask the Reckon Community at:https://community.reckon.com/reckon

How did we do?

Details do not save for an Employee created in Reckon Accounts Business 2016

Liability Cheque for PAYE tax assigned to Australian Taxation Office

Related Articles

Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)