We have employees that work in different departments and have to hand calculate. Let's jump into the 90s please.
by: Jennifer D. | over a year ago | Payroll / Job Cost
Votes
17
Please let us pay employees and charge wages to different gl accounts.
by: Jennifer D. | over a year ago | Payroll / Job Cost
Comments
Jennifer, Not sure what you are referring to. Many of my clients have your exact situation and they accomplish what you are trying to do via the department code field on the earnings line. Change the department code to the department they work in and the earnings ARE charged to a different GL account. This has been a feature since at least 1995 when I first started using MAS.
Yes, you can set up different Earnings codes to go to separate departments and hand massage the departments. HOWEVER, it will not separate the Employer Expensed TAXES!!! (DCAA HATES this BTW DCAA does not want G&A mixed up with your Direct Costs!) It will not separate the Employer Contributions with out hand massaging and setting up separate deduction codes or you can fix it by running separate payrolls and making sure everything is divided out that way... but still a HUGE pain. It doesn't help further that the Perpetual History is ran by Employee Number. Sooo you can't use that report to find the cost breakout that way. The Employers Expense Report is only available when Payroll is Running and not recreatable for any specific time period.
I have different earnings code that go to different departments, also. However, when you process payroll, whatever that employees department is in their master file is where the payroll dollars get posted to. It doesn't matter that you entered their times to various departments / activies in time tracker, it's what is in payroll that goes to the GL account. I would LOVE to have a report that I could run that would give me employees actual hours and wages in the different departments.
We have a similar situation and for those employees I need expensed to different GL accounts, I use the labor code feature. This allows me to assign a different GL code to each labor code I create. This will only expense wages and NOT taxes unfortunately. I then use F9 to pull wage data and allocate taxes manually. If you assign a labor code to everyone, even those who never change departments/jobs, just leave the wage expense field blank for those employees and they will expense to the account in their maintenance file. Assigning a labor code to everyone then allows you to run a labor code report that lists everyone being expensed to that code and how much. It might help you.
In Sage 100 you do have the ability to post employees earnings to different G/L accounts.
In Earnings Code maintenance, you must check the box to "Post Exp By Dept".
In Department Maintenance, under the Payroll Expense Accounts section, enter the G/L you want to use for all earnings for that department OR if you want to post each Earnings Code to a different department click on the Earnings tab, select any Earnings code you want to post to a different G/L account.
Now earnings will post to that G/L account depending on what Dept is entered on the earnings lines in Payroll Data Entry.