Leave has been accruing incorrectly!

  • 1
  • Problem
  • Updated 2 years ago
I have only just realised that there is a box to tick to prevent leave (both personal and annual) from accruing on overtime, and so most of my employees now have inflated leave balances.

How can I correct this?
Photo of Georgie

Georgie

  • 372 Points 250 badge 2x thumb
  • frustrated

Posted 3 years ago

  • 1
Photo of Charles van Rotterdam

Charles van Rotterdam

  • 9,886 Points 5k badge 2x thumb

This is the main reason why I have a spreadsheet as a control for leave. It is too easy for any accounting package by inputting the wrong data or ticking the wrong box and then getting your leave balances totally out of whack and very difficult to recreate.

If you like I can email you my leave spreadsheet (includes holiday, sick & TIL) just email me on charley@vanrotterdam.com.au


Photo of John Graetz

John Graetz

  • 25,054 Points 20k badge 2x thumb
I couldn't agree with you more Charles.  I have done the same thing for years.  There are those things in Reckon, where only two decimal points can be used, which by themselves will throw things out of whack.  This is apart from those instances where despite what I might input, Reckon decides to arbitrarily change my input for absolutely no good reason.  There is no way that I will rely on the program's calculations.  I suspect that we might be in the minority though.
John L G
(Edited)
Photo of Georgie

Georgie

  • 372 Points 250 badge 2x thumb
Good advice, but too late for me I'm afraid! I'm currently making a spreadsheet to see how bad the damage is... but I guess there's some way in Reckon of manually overwriting the leave owing once I've worked it out? Then I'll have to write them a letter explaining why all their payslips have been wrong all this time....
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 53,016 Points 50k badge 2x thumb
Yes there is Georgie
Photo of Charles van Rotterdam

Charles van Rotterdam

  • 9,886 Points 5k badge 2x thumb
Georgie; yes you can override the leave by going into the employee settings and just inputting the correct amount into the leave accrued at date box
Photo of Georgie

Georgie

  • 372 Points 250 badge 2x thumb
Now as I go through each pay record, sometimes it tells me it's detecting a change in the leave accrued, and therefore adjusting it, and sometimes it isn't! I don't have much hope now of knowing what the employees' last payslip told them. Aaah Reckon, you are not my friend today!
Photo of Charles van Rotterdam

Charles van Rotterdam

  • 9,886 Points 5k badge 2x thumb
Actually the last payslip may remain the same as accruals will only work going forward. I'd print out all your payslips before you edit
Photo of Sylvia Johnston

Sylvia Johnston

  • 450 Points 250 badge 2x thumb
Hi Everyone. I enter the correct pro rata amount for leave accrual for both personal and holiday leave, then reckon changes what I enter to something completely different! So I enter 0.03846 for personal leave and it changes it to 0.022 or something similar. Same for annual leave. If I leave it like this the leave accrued will short calculate and get me in trouble. Anyone have any ideas how to stop it changing what I enter? Really don't want to use a spreadsheet!
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 53,006 Points 50k badge 2x thumb
Charles its just math. You take normal hours and you have 7.6923% and you have annual leave. Half that for personal leave.
Photo of Charles van Rotterdam

Charles van Rotterdam

  • 9,886 Points 5k badge 2x thumb
Kevin, I know that, how do you think I built the spreadsheet. It just makes it easier for those that don't think of it.
Photo of John Graetz

John Graetz

  • 25,054 Points 20k badge 2x thumb
I am with you Charles on using a spread sheet.  Over the years I have seen enough little things that can throw Reckon accruals out, and this is apart from the fact that there are instances where I input an accrual rate using a decimal figure and it decides to change it to something else for no known reason.  This annoying trait, whilst not making much of a difference, does make a difference.  There is absolutely no way that I will ever rely on the accruals that Reckon calculates.  At least on my spreadsheet I can also record the actual days of leave which again is something that the program cannot do.. My pay slips have a qualification on them which says that "these Accruals are an approximate guide only, due to rounding issues with the Payroll Program".
John L G
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 53,006 Points 50k badge 2x thumb
John if you arent relying on the basic math to calculate the leave what confidence have you that the pay is calculated correctly? Do you check this every week as well?
Photo of John Graetz

John Graetz

  • 25,054 Points 20k badge 2x thumb
Kevin.,  It is not the basic math which is the issue.  The problems are with the accrual factors such as:
1.  In some cases only two decimal points are accepted - should be consistent in having five always.
2.  In other cases I can input a 5 decimal point accrual but Reckon refuses to accept it and instead changes it to something else which I cannot alter.  That is not basic math stuff, but basic flaw stuff in the program.
3.  Every inconsistency such as these, ends up skewing the result.
John L G