2019 Integrity Data Presents Payroll Year End For Dynamics GP Slide Deck PDF Free Download

1y ago

20 Views

1 Downloads

5.10 MB

49 Pages

Report/dmca

Download PDF

Transcription

Agenda Welcome and introduction Year-end schedule overview Review year-end payroll changes Review standard order of payroll tasks Troubleshoot year-end discrepancies New W-4 Examples Q&A / Links to helpful information Integrity Data 2019. All rights reserved

Integrity Data overviewMICROSOFTDYNAMICS GPPARTNER20 YEARS!Providing solutions toGP customers since 2000 Reliable Software Expert Services Top-Notch SupportOriginal authors of Core Payroll Extensions Advanced Payroll Advanced Human Resources PTO Manager Benefit Self Service Integrity Data 2019. All rights reserved

Important upcoming datesNovember 18th: GP 2015, 2016 & Oct. 2019 Releaseyear-end updateThe GP 2018 update will include the Oct. 2019 Release!Late December: 2020 Round 1 tax table updateMid-January: 2020 Round 2 tax update (details not yetavailable)January 31, 2020:W-2s, EFW21099s1095-Cs to employeesMarch 31, 2020: ACA E-filing deadline to IRS Integrity Data 2019. All rights reserved

GP 2018 New HRP Features RTM Turn off garnishment reports in posting setupRoll down payroll setup options from setup to inactive recordsChange department code in all payroll files, including historyRestrict inactive Deduction and Benefit codes in lookupsReprint Distribution Detail and Summary reports.Advanced Human Resource Wellness and Health Insurance Integration R2 Start/End Dates for Pay Codes Deduction/Benefit Group Maximum FICA totals on the Check csgp/ Integrity Data 2019. All rights reserved

Oct 2019 New HRP Features Deduction & Benefit Mass Assignment PIP Voucher Edit List Report PIP - Remit to Address in Payroll Vendor Setup Ability to Exclude Additional Withholding in Payroll Year-End Release includes new W-4 support Changes to the Employee Tax Maintenance window New withholding statuses Changes to the federal tax calculation Upgrade Blog Series Dynamics GP and Year-End Update Upgrade Planning - Let's Get Started Integrity Data 2019. All rights reserved

From Terry Heley This is the product team blog site that talks about all the features andhad some feature of the dayhttps://community.dynamics.com/gp/b/gpteamblog This is the landing area for the release with lots of log-series-schedule Integrity Data 2019. All rights reserved

Year-end update changesDynamics GP 2018: Oct. 2019 release is included inthe year-end releaseDynamics GP 2015, 2016, 2018 No W-2 or W-3 Form changes No ACA changes– Reminder: Microsoft WILL NOT support ACA e-filing for 2019 reporting Print W-2 on blank paper: GP 2016 R2 & Later Only Integrity Data 2019. All rights reserved

Tax table updatesTax table updates (subject to change)(Target release date Mid-December 2019) FICA Social Security limit 137,700 States changes: TBDDon’t apply this update until afteryour last payroll of 2019! Integrity Data 2019. All rights reserved

Year-end checklist Get the latest 2019 tax tables (Do this now!) Install the year-end update Create the year-end file as a test Verify W-2 and 1099-R information Remove year-end file Complete all pay runs for 2019 Make a backup Create the year-end file Make a backupNote: You can start processing 2020 payrolls once you have created the Year-end file (Backup! & get new tax tables first!) Integrity Data 2019. All rights reserved

Year-end checklist Verify W-2 and 1099-R information Print / e-mail* the W-2/W-3 Create electronic W-2* Print the 1099-R/1096 Archive inactive employees (HR)** Setup 2020 fiscal periods Close 2019 fiscal periods** Update 2020 payroll tax tables Start processing 2020 payrollsEmail W-2s to your employees!If you’ve licensed Employee E-mailSuite from Integrity Data*W-2 Only /**Optional Integrity Data 2019. All rights reserved

Benefit Self Service checklistBenefit Self Service year-end process Create future effective benefits Open enrollment period Review enrollments Complete final pay of 2019 Activate future effective benefits Post enrollments Review benefits Begin processing 2020 payrolls Integrity Data 2019. All rights reserved

Integrity Data products checklistOther items (perform prior to first 2020 pay run)Employee Accounts & Splits / FTE Manager Copy employee positionsEnhanced Retirement Plans Change retirement catch-up contribution limit 2019 401(k), incl. Roth 401(k): 6,500 on amounts over 19,500 2019 SIMPLE IRA Catch-Up: 6,500 on amounts over 13,500 2019 Roth IRA: 1,000 on amounts over 6,500 2019 403(b): 6,500 on amounts over 57,000 (or 100% of includable compensation) Review shared maximumsLife Insurance Tax Calculator Verify IRS rates (no changes) Integrity Data 2019. All rights reserved

Integrity Data products checklistOther items (perform prior to first 2020 pay run)Employee E-Mail Suite *IF YOU ARE NOT ON AT LEAST OUR MID-YEAR RELESEInstall the year-end update prior to sending out your W-2s to ensure your employeesget the correct formComprehensive Leave Manager / PTO Manager Apply carry over limits Create lump sum posting dates (year-end wage work file) If upgrading to Oct. 2019, ensure you upgrade your Integrity Data products to Oct.2019! Integrity Data 2019. All rights reserved

ACA Year-end checklist Determine ALE Status for 2020 Measure Part Time Employees for Eligibility Offer coverage to 2020 eligible employees Generate 1095-C for 2019 eligible employees Get Started Early – Do this in December! Distribute to employees by 1/31/2020 Generate 1094-C for each EIN File by mail with IRS by 2/28/2020 E-File with IRS by 3/31/2020 Integrity Data 2019. All rights reserved

Troubleshooting year-end issuesReconciling the 941 W-2s Payroll Summary Problem areas– Manual checks / adjustments– TSA changes on deductions– Business expense pay codes (report as wages)– Failed / interrupted payroll postings Table information– Payroll Check History (UPR30100)– Payroll Transaction History (UPR30300)– Employee Summary (UPR00900/UPR00901)– Payroll Tax Liabilities (UPR30200) Perform quarterly with 941 filing Integrity Data 2019. All rights reserved

Payroll User GroupIn our Payroll User Group, we hold quarterly meetings to help you stay upto date and connected with other Payroll users in the Microsoft DynamicsGP community on topics related to: Payroll Dynamics GP Payroll Integrity Data NewsGo to www.integrity-data.com/pug to join!28 Integrity Data 2019. All rights reserved

Helpful informationInformation from Microsoft Download links– Microsoft Dynamics GP 2018 Customersource– Microsoft Dynamics GP 2016 Customersource– Microsoft Dynamics GP 2015 Customersource Microsoft Dynamics GP Directory– This page offers easy access to Microsoft Dynamics GP resources. This pageis intended to provide a consolidated view of relevant documentation,videos, solutions to known issues, links to related resources, as well ascommunity sites for implementing Microsoft Dynamics GP. Integrity Data 2019. All rights reserved

Helpful information Microsoft Dynamics GP echnical/b/dynamicsgp/default.aspx Microsoft Dynamics community:https://community.dynamics.com/ Microsoft Dynamics .aspx Integrity Data blog:Prepare for Payroll Year End Integrity Data 2019. All rights reserved

Helpful informationMicrosoft KB articles Year-end closing procedures for Microsoft Dynamics GP Payroll Incorrect calculations on the Payroll 941 Quarterly Summary Report in MicrosoftDynamics GP Correcting differences between federal wages in Form 941 and in the PayrollSummary report in Microsoft Dynamics GPContact your Microsoft partnerGPUG community boards Integrity Data 2019. All rights reserved

Helpful informationKey points to remember:Year-end wage file Held in UPR10100-UPR10107 tables Year-end wage report Edit and print W-2s Create W-2 electronic file (W200005, W200006)Prior to processing pay runs in New Year Install Payroll Tax Update Round 1– Microsoft Dynamics GP Maintenance U.S. Payroll Updates Check for Payroll Tax Updates– Downloads & Updates Tax Updates (manual) Integrity Data 2019. All rights reserved

Helpful informationHelpful documents, numbers, sites and articles: Downloads and updates Tax updatesU.S. Year End Update.pdfW-2 Wage and Tax Statement Data Source.pdfTax forms: 800-432-1281 www.microsoftbusinesschecks.comIRS forms and publications: http://www.irs.gov/formspubs/index.htmlAccuwage for electronic file ndex.html KB Article 850663 Year-end closing procedures for MicrosoftDynamics GP Payroll http://support.microsoft.com/kb/850663 Integrity Data 2019. All rights reserved

New W-4 for 2020Why the change? Tax Cuts & Jobs Act of 2017– Eliminated personal “exemptions”– Doubled the standard deduction– Increased child tax credits– Eliminated &/or restricted several itemizeddeductions– SALT (State & Local Tax)– Mortgage Interest– Charitable Contributions– Other Deductions (e.g. Unreimbursedemployee expenses & Tax prep fees) Integrity Data 2019. All rights reserved

W-4 for 2020 – Common Questions What’s Pub. 15-T? No more “Circular E” Section 17? Are employees required to complete new form? No Can employers require employees to complete a new form? Yes Will Federal W/H change if the employee does not complete a new W-4 for 2020? Yes, but no more so than in years past due to tax table changes Are these changes final? Almost – some minor tweaks due end of November for W-4 / December for 15-T What’s the Withholding estimator? Used by taxpayers with more “complicated” tax situations (webinar coming from IRS) Integrity Data 2019. All rights reserved

New W-4 for 2020 No more exemptions(aka “allowances”) “Multiple Jobs” Higher tax tables Line 3: “Dependents” credit Line 4a: “Other Income” Line 4b: “Deductions” How do I file “Exempt” oror “NRA” (Nonresident Alien)? Integrity Data 2019. All rights reserved

11/20/201940 IntegrityDataAll2019.All reserved.rights reserved IntegrityData 2019.rights

Window before the year-endupdate is applied11/20/2019Window after the year-endupdate is applied41 IntegrityDataAll2019.All reserved.rights reserved IntegrityData 2019.rights

11/20/201942 IntegrityDataAll2019.All reserved.rights reserved IntegrityData 2019.rights

11/20/201943 IntegrityDataAll2019.All reserved.rights reserved IntegrityData 2019.rights

11/20/201944 IntegrityDataAll2019.All reserved.rights reserved IntegrityData 2019.rights

Have the employee use thewithholding estimator and providea form with “extra withholding.”11/20/201945 IntegrityDataAll2019.All reserved.rights reserved IntegrityData 2019.rights

11/20/201946 IntegrityDataAll2019.All reserved.rights reserved IntegrityData 2019.rights

Year-end closing procedures for Microsoft Dynamics GP Payroll Incorrect calculations on the Payroll 941 Quarterly Summary Report in Microsoft Dynamics GP Correcting differences between federal wages in Form 941 and in the Payroll Summary report in Microsoft Dynamics GP . Contact your Microsoft partner. GPUG community boards