Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[jeremiah hough]

Does anyone know of a good solution for posting payroll to the correct month when the payroll week is split between two months?  Example:  our payroll runs Monday-Sunday.  if we have a pay week that consists of 7/27/17 – 8/2/17 we want they payroll to be split between the months based on the days worked during the month.  Is there anyway to do this.  I believe GP posts the payroll to the g/l based on check date.  Any suggestions?

——————————
jeremiah hough
Independent Stave Company
lebanon MO
——————————

[Teri Carpenter]

?Hi Jeremiah,
in the Advanced Payroll module there is a Payroll Accrual feature you can use to accrue the expense to the prior month.  You will need to set up which accounts to accrue, then at the end of the month, pick the batches and indicate how many days or what percent to accrue for the prior month.

——————————
Teri Carpenter
President
TD Carpenter & Associates, Inc.
Toledo OH
——————————
——————————————-

[jeremiah hough]

I’ve read about the accruals but we want something more precise than basing it on days worked or percentages.  I was hoping you could post off of the pay period from and to instead of check date.  i thought we could create a batch for each period and combine them for payroll but it post to the g/l by pay period.

——————————
jeremiah hough
Independent Stave Company
lebanon MO
——————————
——————————————-

[Phil Camp]

?I’m sure we do it the hard way, but we calculate the payroll for the period covered in the month prior to the check date and create a recurring journal entry that reverses on the first day of the month the check is going to be dated.  Probably not the best solution, but it works well for us.

——————————
Phil Camp
Director of Information/Controller
Hopkinsville Milling Co.
Hopkinsville, KY 42240
——————————
——————————————-

[Charlie Waage]

Hi Jeremiah,

                What we do is:

                                Post the entire actual payroll to August fiscal period using TRx Date 8/2/17.

 

                                Download that journal entry to excel.

Multiply each line item by 71.42857% (which is 5 days in July divided by 7 total days in the payroll week).

Review and make changes as needed (for example: change credit from Cash to Accrued Payroll liability, etc)

This is now your journal entry for July’s Accrued Payroll.

Copy or use Integration Manager to upload to GP and post into July fiscal period using TRx Date 7/31/17 AND REVERSING ON 8/1/2017.

 

                You’re left with 5 days payroll expense booked in July and a net of 2 days payroll expense booked in August.

Charlie

 

Charlie Waage

Director of Accounting and IT Coordination

CEC

Breaking The Cycle of Recidivism® 

35 Fairfield Place

West Caldwell, NJ 07006-6206

(973) 226-2900 ext 299  l (973) 575-3978 Direct line | (973) 740-1793 Fax

charlie.waage@cecint.com l http://www.cecintl.com

 

——Original Message——

Does anyone know of a good solution for posting payroll to the correct month when the payroll week is split between two months?  Example:  our payroll runs Monday-Sunday.  if we have a pay week that consists of 7/27/17 – 8/2/17 we want they payroll to be split between the months based on the days worked during the month.  Is there anyway to do this.  I believe GP posts the payroll to the g/l based on check date.  Any suggestions?

——————————
jeremiah hough
Independent Stave Company
lebanon MO
——————————

[Joni Finnell]

?Jeremiah:

We use the Payroll Accrual feature as Teri has mentioned. You can choose by pay period as long as that pay period has been processed. Something to keep in mind. The process will try to post the entire accrual in one account. We like to have ours split between wages and payroll taxes. So, we export the JE before it is posted and sort the transactions to get a total for each then we edit the JE before it is posted. That is the only manual part of the process.

Phil & Charlie – you might want to look at the accrual process it could save you a lot of time. 

Thanks

——————————
Joni Finnell
Project Accountant/GP Troubleshooter
Consumer Support Services, Inc.
Newark OH
——————————
——————————————-

[Kathy Youngquist]

?We understand your concern and have the same one.  We post our own payroll accruals using a portion of the actual payroll that spreads across two months, so we get much closer to the applicable cost that should be assigned.  It seems as though the GP system assumes that payrolls are all homogeneous, but ours are not.  We are in the health care business, so we staff 24/7 and staffing fluctuates according to how many patients/residents we have daily.  Also, holidays are paid at either 1.5x or 2.0x, which makes a big difference.  Before GP we ran on a Unix system that understood dates and automatically calculated the percentages to assign to each month when a payroll included days from two months.  We wish this could be done in GP also.

——————————
Kathy Youngquist
CFO
Elim Care, Inc.
Eden Prairie MN
——————————
——————————————-

[jeremiah hough]

Glad to hear we aren’t the only one with this problem.  I was beginning to think we were crazy for wanting to be more precise.  We make it work now but it’s pretty manual.  We have to split time out between several departments so we dump our time system into excel by dates then add a 1 to the end of the departments for the dates that need to be accrued.  we then have to run gp reports and make journal entries to reverse the accruals.  i’d love to find a better way but haven’t had much luck.

——————————
jeremiah hough
Independent Stave Company
lebanon MO
——————————
——————————————-