Job codes in payroll entries not being included in general ledger posting

Question

We are using MYOB Accountright Live 2020.1

Job codes that are included in payroll payments have not been consistently transferring into the general ledger. Within a single payroll run, some payment lines will post to the job and some will not.

The glitch started to occur from a payroll period in January 2020.

Has anyone seen this before or knows how to resolve it?

komal_s · Accepted Answer

Hi&nbsp;SMQR&nbsp;
Can you please confirm if you use timesheets as well? If yes, please ensure that the job codes are entered on both timesheets and standard pay on the card file of the employee. In case timesheets are not used, are there any specific jobs that are not getting posted to general journal?
&nbsp;
If possible, please attach screenshots of any payroll transaction having job codes and the general journal not having those specific amounts.&nbsp;

smqr · Answer

Thank you Komal_S ... you hit the nail on the head. I had 4 hours with MYOB Support last Friday and then 2 hours on Monday, and on Monday we were able to confirm that it came from imported timesheets not having a job allocation. Even though there are job settings in the standard pay area, and the payroll entry appears to be allocating to a job, the timesheet blank job code over-rides the other information when it came to posting to the general ledger.

I am impressed with your response getting to the problem, thank you.

smqr · Answer

HI Angela, the problem began when we started using timesheets to bring in the hours worked to the payroll. We found that the job info recorded in the timesheet will override what is in standard pays, so we had to ensure that all the job codes were entered in at the timesheet stage. I hope this helps you find a solution.&nbsp;

smqr · Answer

Hi Angela, I don't know how large your payroll is - if there are not too many employees then manually entering might be OK. The client I was working with had about 150 or so employees. We ended up exporting the data from the timesheet provider as a CSV file. We ran a report from MYOB that had the employee name and the job codes. (We use the custom lists function to record the job code for employees - that matches the job list options). Then we used a vlookup to get the job info from the MYOB report into the csv file. Then imported the timesheet data into MYOB including the job reference. This might save you some time if you are dealing with a lot of data.&nbsp;&nbsp;&nbsp;

angela1234 · Answer

How did you fix this problem?&nbsp; We have just started using Job codes and I am having the exact same problem.&nbsp;

smqr · Answer

&nbsp;&nbsp;&nbsp;

Forum Discussion

Job codes in payroll entries not being included in general ledger posting

7 Replies

Related content

Payroll Entries

LIne items on payroll entries

Reversing a payroll entry

Payroll including timesheets from outside of date range

Account not included in subtotal

incorrect pay entry

Payroll - Journal entry

Including surcharge for payments