web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Using Integration Manager to import payroll benefits

(0) ShareShare
ReportReport
Posted on by 80

Can anyone give me the mappings for this?  I don't get any errors but nothing gets populated either.  I have turned off all of human resoursces and we are using GP2010 sp3.

 

Thanks

*This post is locked for comments

I have the same question (0)
  • Colleen Firman Profile Picture
    40 on at
    Re: Using Integration Manager to import payroll benefits

    Hi Susan, I do NOT have any answers for you ;-) (sorry!) but I would like to clarify as I believe I have some questions on this topic as well.  

    I assume you are referring to the IRS Requirement new this year whereby we are required to report the amounts of health benefits/premiums provided to employees - is that correct?

    I am looking for anyone else that is currently working on this issue as I am debating whether or not it would be easier to integrate the data or simply "edit" the W-2's as this is an information number only.  Am I in the correct conversation? ;-)

    Thanks!

  • Douglas Karel Profile Picture
    2,140 on at
    Re: Using Integration Manager to import payroll benefits

    @ Colleen –

    For 2012 W2’s (printed in 2013) it might be easier to edit the W2’s if you do not have a lot of employee.  However, since the requirement is for companies that have 250 employees, I would guess you have at least that many.    Which depending on the staff level, could still be burdensome.

    However, for the future, and what we had done when this first came out in 2010, was create benefit codes for each type of coverage (Single, Family, Single + Child, Single + Spouse) and put in the applicable premium rate for each of the policies and assign them to the employees.   I would then include this on the paychecks each pay period.    This has a twofold effect.   It shows the employee how much the company pays on their behalf and second it eliminates the need to do anything at year end.   The rates can also be changed at the setup level and rolled down to the employees.

    One note to remember.   What needs to be reported on W2’s is the gross amount of insurance that is paid.  It is not reduced by the amount the employee contributes for their share of insurance.  

    Not sure if this might help, but regarding your import, is your benefit codes set up to be ‘Transaction required’.   Not sure if you were importing as a payroll transaction or not.

  • Colleen Firman Profile Picture
    40 on at
    Re: Using Integration Manager to import payroll benefits

    Thank you so much for responding Doug!  

    We began utilizing Advanced Payroll to track our Benefits at the beginning of the year.  However, due to multiple issues, I am not confident that the amount we could pull from the system via Benefit Codes would be correct - or even "near" correct ;-) [I know this is simply an informational figure and therefore has some leeway for "close enough is good enough" but I don't believe pulling from the system would provide me with "close enough"]

    We have 3 medical carriers, 2 of which have provided us with the amounts that we do need to report, and one we need to pull from the individual invoices.  However, what I am mainly struggling with is how I integrate those amounts into GP?...Or.... would it be easier to manually enter each amount onto each W-2 via the edit option.  My preference would be of course to integrate via an Excel Spreadsheet, but I do not know if that is possible and/or how to do that, so I was curious if anyone else was in the same boat?

    Thank you!!

    Colleen

  • Colleen Firman Profile Picture
    40 on at
    Re: Using Integration Manager to import payroll benefits

    FYI - Just an update, we had SOCIUS assist us in completing the integration :-) ya...easy way out ;-)  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans