...Menu...
Menu Group: File Maintenance - Optional
Split codes allow you to allocate the salaried employees pay across any number of G/L codes proportionally provided that the total percentage is 100. The split code will be entered on the employee profile. For salaried employees the gross pay will be split across the G/L codes specified in the code on the employee profile. For hourly employees the rules are:
When you are posting time the system will check for a non-blank split code on the employees profile. If the test is true then you will be able to post time for that transaction with a blank G/L code. The system will then apply the transaction across the G/L codes defined in the split. If you override the G/L code (in time posting) then the G/L cod entered will be used and the split will be ignored.
Split codes may also be masked. In this case the following example will illustrate how the G/L codes are generated:
The algorithm would be:1. If the G/L code is not masked use it.
2. If the G/L code is masked then retrieve the g/l code from the EBD or the employee:a) If the Use EBD switch = yes the use the g/l code from the EBD and replace the x’s with the digits in the EBD G/L code.
b) If the Use Employee G/L = yes use the employee G/L code instead.
By way of example:
We have set up this split code:
G/L code |
Split percentage |
1720xxxx |
20% |
3650xxxx |
20% |
5605xxxx |
20% |
5705xxxx |
20% |
7605xxxx |
20% |
For our example we will illustrate 2 possibilities, one where the Use EBD G/L = yes and the other where the Use Employee G/L = yes. In both examples we will use the same transaction:
John Smith is paid $1,000.00 of regular time (EBD 101) and $100.00 of overtime (EBD 102).
1. We have these EBD’s where Use EBD G/L = yes:
EBD |
Debit G/L |
Use EBD G/L |
101 |
34501010 |
Yes |
102 |
34501060 |
Yes |
This will be the G/L entry (debit side) resulting from the transaction:
For the regular time:
G/L code |
Amount |
17201010 |
200.00 |
36501010 |
200.00 |
56051010 |
200.00 |
57051010 |
200.00 |
76051010 |
200.00 |
For the overtime:
G/L code |
Amount |
17201060 |
20.00 |
36501060 |
20.00 |
56051060 |
20.00 |
57051060 |
20.00 |
76051060 |
20.00 |
Note that the G/L codes were created by superimposing the split code G/L onto the G/L code from the EBD file. That is:
1720xxxx + 34501010 = 17201010 etc.
We have replaced the x’s in the split code G/L with the digits from the EBD G/L..
2. We have these EBD’s where Use Employee G/L = yes:
The Employee G/L code is 34501090
EBD |
Debit G/L |
Use Employee G/L |
101 |
34501010 |
Yes |
102 |
34501060 |
Yes |
For the regular time:
G/L code |
Amount |
17201090 |
200.00 |
36501090 |
200.00 |
56051090 |
200.00 |
57051090 |
200.00 |
76051090 |
200.00 |
For the overtime:
G/L code |
Amount |
17201090 |
20.00 |
36501090 |
20.00 |
56051090 |
20.00 |
57051090 |
20.00 |
76051090 |
20.00 |
Note that the G/L codes were created by superimposing the split code G/L onto the G/L code from the Employee master file. That is:
1720xxxx + 34501090 = 17201090 etc.
We have replaced the x’s in the split code G/L with the digits from the Employee G/L.
Last Updated October 20, 2006