How do I correct my annual leave days due?

If you haven't been using Pastel Payroll since the exception of your company, you might find yourself in instances where your employees leave days due differs from the amount that you have in your manual records.

Pastel Payroll also doesn't allow you to make actual changes to the days due tab on the masterfile.  Don't dispair, even though the Days Due field is not available, doesn't mean that you can't get the system to show you the correct number of Days Due.  

Payroll Automatically calculates the below fields:

  • Days Accrued (By taking the cycle leave entitlement and dividing it by the periods work for the Annual Accrual Method)
  • Days Taken (By consolidating the days that you have captured on the leave tab)
  • Days Due (By Taking the amount in the Opening Balance column, adding the amount in the days Accrued column, deducting the amount in the days taken column)

The only field that is is available for you to edit is the Opening Balance field, but as mention above, the amount in this field is used in the calculation that determines the opening balance.  That formula again:

Opening Balance + Days Accrued - Days Taken = Days Due

Lets say for example Employee X's Days Due should be 12.75 days, but he was added onto the payroll after the company's inception and his leave tab on the masterfile shows the Below:

To have the system show the correct amount of days due, you will have to add and amount to the opening balance:

Opening Balance + Days Accrued - Days Taken = Days Due

(x+3.75) + 3.34 - 0 = 12.75

= x = 12.75 - 3.34 - 3.75

= x = 5.66

So your Opening balance needs to change to 9.41.  I know that is a lot of math!  The easier way to do it is just to see what is the Days Due that you want MINUS what is the days due that you have and just add that value to the opening balance:

I have Days Due of 7.09, I want days due of 12.75 (12.75-7.09 = 5.66) so I will ADD 5.66 to whatever my Opening Balance is.


Remember that your opening balance, as well as your Days Due can be Negative as well!  So you can change Employee Y's opening balance to show days due of 1.25 if his masterfile is currently showing these amounts:

I want days due of 1.25, I have days Due of 5.8. Deduct what you have from the amount that you want (1.25 - 5.8 = -4.55) and add that to your opening balance (3.30 - 4.55 = -1.25): 

If your Opening Balance is not available for editing, then your employee has already been processed and you will have to do a Clear Run Flags