The MicrOpay General Ledger (GL) can include Leave Liability for users wishing to automate the process of updating their GL with the leave accruals each month.
Whenever an update of leave entitlements occurs, the _iptblEmployeeLeaveAccrual table is updated with the value of the employee’s leave accrual at the next End of Pay process. Where relevant, an update occurs for Annual Leave, Sick Leave, Long Service Leave, Public Holiday Leave, and Extra Leave.
There may be instances where a user does not wish for the table to be updated. For example, Bob Jones has been transferred to the ABC Company from the XYZ Company. Bob's Annual Leave, Sick Leave, and Long Service Leave balances as at 30/04/2019 will be transferred across. Payroll does not wish to have this balance show when the GL is run for leave liability, as this has been added to the accounting software manually.
The Payroll user ticks the Initial Balance checkbox
If the checkbox is not ticked, the adjusted balance will flow through to the GL at the next End of Pay process.
The checkbox is also available in Payroll, Transactions, General, Update Leave Entitlements popup window.
General Ledger Integration, Maintenance, Accounts
Set up an Account for each relevant type of leave.
Click the Add button.
Enter the Account number from the General Ledger.
Enter a description of the Account.
Select an Account Type.
Set up a balance Account for each relevant type of leave with an Account Type of Not Posted.
General Ledger Integration, Maintenance, Batches
It is advised to set up a separate GL batch for the leave accruals.
Click Add and enter a unique Code.
Enter a unique Description.
In Filename, enter the Path and File Name you would like to save the General Ledger Batch to.
Enter an account in the Default Post Contra To field; however, this is not essential where the balance Accounts will be used in the Batch setup.
Click on the Details tab.
Click Add.
In the Type field, click on the dropdown and select Leave Liability.
In the Leave Type field, click on the dropdown and select the type of leave.
In the Post As field, select Credit.
The Rate field defaults to Normal Rate. Click on the dropdown to select Award Rate, Other Rate, or a User Defined Leave Rate if desired.
In the Post Contra To field, select the relevant balance Account. For Long Service Leave, tick the Apply Contingency checkbox if no liability until the Contingency period has passed. This is defined in the Pro Rata Entitlement section of the Long Service Leave class.
In the Post By area, tick any or all options for posting by Cost Account, Component, and Employee.
Click Add.
Under Cost Account, click the dropdown and select a Cost Account or enter the % symbol as a wildcard for all Cost Accounts. Users may also add a combination of Cost Account and wildcards. E.g., ABC Company wishes to credit their GL based on Position 1 of their Cost Accounts. The user enters all the characters of each Position 1, followed by the % symbol.
Click on the dropdown under Ledger Account to select the relevant Account.
Click OK to save.
Once setup is complete, click OK again in the Editing Batch Details window to save the new Batch.
This setup is designed to be used in conjunction with a separate General Ledger batch setup for Payroll.