Microsoft Dynamics GP 2017 YearEnd Closing Abra Lynne

Microsoft Dynamics GP 2017 Year-End Closing Abra Lynne Gilman Senior Consultant Collins Computing, Inc. November 2017

TOPICS Let’s Have A Happy New Year! - Resources - 2017 Changes - Install/Update Notes - Module Details - Closing Questions

Where To Find Resources! Where do I find checklists/docs? ‘Connect’ area of home page Dynamics GP Connect on home page Customersource Dynamics GP Link Microsoft Year-End Blogs Customer. Source Link Ask your partner! https: //mbs. microsoft. com/customersource/northamerica/GP/learning /documentation/system-requirements/dynamicsgpresource

Year-end links from Microsoft! Or block time with your partner’s support staff! https: //community. dynamics. com/gp/b/dynamicsgp/archive/2017/10/10/microsoftdynamics-gp-2017 -year-end-blog-series

Specific Changes for Year-End 2017 1. No W-2 or W-3 Form changes 2. EFW 2 changes (required) 3. Product Quality Fixes around Payroll Year-End. 4. Affordable Care Act Updates - Form and Code changes 5. Fixed Asset Luxury Auto Depreciation changes **No Payables form changes** Who uses Payroll? What about Fixed Assets? How about AA?

Accuwage Testing Electronic file testing - before submitting it to the SSA has changed. It used to be a free download that needed JAVA install – no more! SSA stated installing JAVA & software was risky & enabled hackers to get in more easily, so now it’s all online. It requires a user name/password from your company setup with the SSA. Should have if you file electronically. Here is the link where you go to test your file: https: //www. ssa. gov/bsowelcome. htm On the right, choose Log In & enter your account information. Click Report Wages to Social Security. Choose Accuwage Online tab & click the Accuwage Online link, click W-2 Regulars, choose your file & start testing. If you do not install the year end update and are testing a file, it will error on every employee with this error. Easy to answer, INSTALL THE YEAR END UPDATE!

You May NOT need to install the year-end update if: You Don’t use Payroll Don’t use Fixed Assets (Luxury Auto Dep) OR You DO use payroll but not affected (Consider ACA rpts/electronic files) Don’t use Luxury Autos in FA

Updates/Closing - What’s it all mean? 2017 Payroll Tax Update - Simple Update (minutes) Tax Changes YE Code Updates For 2013/2015/2016 Closing Steps Next Year Changes Upgrades No Last Minute Updates – August 11 th Maine last update) Year-End Update (Please Call Partner to Assist/Schedule) Program Updates: Need to update server/workstations Within same version only – Available Week of Nov 20 th Year-End Closing (Follow steps to close modules) 2018 Payroll Tax Update–Simple Update Hopefully (Tax Tables) 2018 Tax Update (Round 1) – Target Mid December 2018 Round 2 Tax Update will be available mid-January 2018. Update after last Payroll Run of 2017 Upgrade wanted from 10, 2013, 2015, or 2016? Major configuration and structure changes/3 rd parties affected Partners Usually Recommends TEST Upgrade ** No “Tax or Year-End” Updates Available for GP 2010, or prior. GP 2013 ends on 04/03/2018

2017 Payroll (USP) Tax Updates GP Year-End Update 2018 USP Tax Update 2018 Round 1 Tax Update (tax table only) is targeted for mid-December 2017. *Do not install this tax table update until ALL pay runs for 2017 year are complete. The 2018 Round 2 Tax Update will be available mid-January 2018. https: //mbs. microsoft. com/customersource/northamerica/GP/ downloads/tax-regulatory-updates/TUGP 2016

ACA Reporting Changes The Year-End Update helps ‘fix issues’ with picking up employees & has fixes to front of form and follows instructions on the back of the form. • The Plan start month is still optional (like last year). • There were still issues where inactive employees were printing. Specifically if the employee was in Box 16 each month of the year with S 1, then no 1095 would print, but they would be in the year end file. • Other issue, if people changed to dental and visions that were “none”, would still print like they were ‘medical’ plans. So now they look at the health code plan to see if it is set to “NONE” AND “NONE”. • Microsoft Dynamics GP does not support the electronic filing for the 2016 year for ACA. Greenshades and Integrity-Data will allow you to track ACA in Microsoft Dynamics GP, and just do the electronic filing for you at a lower cost option. • Ability to add dependents on the fly in Edit W 2/Dependents. https: //community. dynamics. com/gp/ b/dynamicsgp/archive/2016/11/09/mi crosoft-dynamics-gp-year-endupdate-2016 -affordable-care-act-aca

W-2 Capabilities Blank Paper Printouts! 1 -Wide Forms with Box Form Type was added Print W-2 Forms window to accomplish this With GP 2016 R 2+ print W-2's with lines on blank paper! (Microsoft Dynamics GP >> Routines >> Payroll >> Print W-2’s >> Form Type – 1 Wide Forms with Box >>Print = W-2 Forms

Fixed Asset Changes 2017 https: //www. irs. gov/pub/irs-drop/rp-17 -29. pdf As usual there are changes to the Luxury Auto Maximum Depreciation Deduction Max Depreciation Amounts. Maximum depreciation deduction amounts for luxury vehicles have been updated for assets placed in service in the 2017 calendar year to comply with IRS Guidelines. NO NEW FUNCTIONALITY Reminder: Fixed Asset Year-End Closing report added to year-end close process!! *Single step to close year & print status report of all assets those affected. Report = Per Book & Shows for all assets impacted by year-end Asset ID, Description, Cost Basis, YTD depreciation, Accumulated Depreciation, New Year Book Value, Placed in Service Date, Depreciated to Date, Quantity, YTD Maintenance, & Status

What Release Are You On? GP 2016 R 2 + Year-End Update = TBD (2016=16. 00. 0552, Latest= 16. 00. 0620) GP 2015 R 2 + Year-End Update = TBD (2016=14. 00. 1059, Need to be on 14. 00. 0983 + to update) GP 2013 SP 2 + Year-End Update = TBD (2016=12. 00. 2130, Need to be on 12. 0. 2104+ to update) GP 2010 Final Release 11/18/2014 = 11. 00. 2351

Steps to Closing the Year Start with Subsidiary Modules Sales Order/Purchase Order/MFG/FS/BOM Inventory, Project Accounting Payroll & Human Resources (We’ll cover last) Payables, Receivables, Fixed Assets Analytical Accounting & General Ledger

Blog Series Module Closing Instructions Specific Modules October 24 - General Ledger October 25 - Inventory October 26 - Fixed Assets October 31 - Payables Management Year-End Closing Links November 1 - U. S. Payroll November 2 - W-2 Tips and Tricks November 7 - Electronic W-2 (EFW 2) for a successful filing November 8 - Analytical Accounting November 9 - Receivables Management 2017 November 14 - Affordable Care Act (ACA) November 15 - Canadian Payroll https: //community. dynamics. com/gp/b/dynamicsgp/archive/2017/10/10/microsoftdynamics-gp-2017 -year-end-blog-series

Prepare Modules Finalize Trx Reconcile GL to Subsidiaries Print Reports Backup

Distribution Year-End: Inventory When should the close be done? After you ‘validate’ the modules that post to Inventory. Enter and post all Purchase Order Processing, Invoicing/Sales Order Processing, & Inventory transactions for current year Run POP Received/Not Invoiced report to tie to A/P Liability account. Reports > Purchasing > Analysis > Received/Not Invoiced

“Other” Modules Ready for Inventory Close? Post all transactions for the year for: Purchase Order Processing Project Accounting Sales Order Processing Bill of Materials Field Service Manufacturing Reconcile SOP/POP modules. Utilities > Purchasing > Reconcile Purchasing Transactions Utilities > Sales > Reconcile / Remove Sales Documents

Inventory year end Closing the Year in Inventory will: Ø Transfer summarized current-year quantities, costs, and sales information (Dollars/Quantities) Ø Update Beginning quantity of each item from On Hand quantity at each site. (Turnover Report—uses beginning #) Ø Reset the Quantity Sold field for each item to zero. Options to: Ø Remove purchase receipts for items completely sold. Ø Remove discontinued items from items completely sold. Ø Remove lot attributes for items completely sold. Ø Updates standard cost of item to the current cost if using FIFO or LIFO periodic valuation methods. Ø Remove Cost Change History.

Inventory Card history Quantities and Amounts moved to “Last Year”

Year End Steps for Inventory ü Reconcile Inventory quantities. Utilities > Inventory > Reconcile ü (Optional) Complete a physical inventory count & post adjustments. Reports-Inventory-Activity-Physical Inventory Checklist ü Print inventory reports for records (if applicable): ü Make a backup. ü Close the Inventory Module year Tools > Routines > Inventory > Year-End Close

Serial/Lot Numbers syncing issues Running Inventory Checklinks/Reconcile may create new records in Serial Master table that represent missing serial numbered items. The system will create new serial numbers but these will not match your inventory. Edit the records in the Serial Lot Master table to correct serial numbers. You can also simply add records to the Serial Master table for the missing serial numbers. This can also be done for missing lots.

Physical/Stock Counts Process Stock Calendar Maintenance Dates for next stock count for item-site combo. GP > Tools > Inventory > Setup > Stock Calendar Stock Count Cycle Assignment Assign one stock count frequency to many items. Cards > Inventory > Cycle Count Assignment Stock Count Schedule Qty on hand for each line in stock count schedule captured. Later, actual count qty compared to captured values to create default variance transactions. Transactions > Inventory > Stock Count Schedule Stock Count Forms can be printed during this process. Stock Count Entry Window to enter results of stock counts. When stock count is processed, variance transactions are created. Trx will also post IF Auto-post Stock Count Variances box checked. Transactions >Inventory> Stock Count Entry

Stock Count Screens

Stock Count - Manually Adjust Manual Process: Print a Physical Inventory Checklist. then perform a physical count of your Inventory, verify # on hand accurate for Items. Reports > Inventory > Activity Then Manually create Inventory Transaction of differences for each item. Transactions > Inventory > Transaction Entry NOTE RE: POST TO GL CHECKBOX ON BATCH SCREEN.

Automated Stock Counting: Sales. Pad Data Collection Data. Collection provides an easy to deploy & use mobile bar-code data collection solution. Manage materials within a warehouse or across sites. Easily create Bin Transfers, Site Transfers, and Inventory Adjustments. Allows users to easily enter Stock Counts supporting GP’s standard inventory counting functionality.

Optional Inventory Reports Removing sold purchase receipts during year-end? We recommend printing Purchase Receipts Report. Print any additional reports that you will need for planning or for your permanent records. The suggested reports are as follows:

Tools > Routines > Inventory > Year End Close Summary windows in inventory with specific views of calendar or fiscal year are date-sensitive. ** The inventory year end close process is not date-sensitive. Released in GP 2013: Updating Standard Costs DOES create a GL entry/batch to reflect inventory valuation change. Otherwise, prepare entry manually by referring to pre- and post-close Stock Status reports to determine the valuation change.

Historical IV Trial Balance Don’t see Historical IV Trial Balance under Reports > Inventory > Activity menu? You may need to install it. (and use the HITB Inventory Reset Tool. ) Contact a support desk! Balance the General Ledger to the Inventory Module “As of” a particular date!

Receivables Management Closing Calendar Year-End Fiscal Year-End Close prior to posting transactions in next calendar year. Ø Transfers finance charges to the last year (LY) field on the customer records. (Need to print finance charges on the Dec & Jan customer statements. ) *Finance charges do not automatically print on the customer statements so report needs to be modified to include this information. Close prior to posting any transactions in the next fiscal year. Ø Transfers all other amounts to Last Year “buckets”

Receivables: Customer Summary Screen Fields Updated Cards > Sales > Summary Quantities and Amounts moved to “Last Year”

Receivables Year End Procedures Post trx for year & complete month-end processes (don’t have to post ‘recurring’). Make a backup / Close the year Tools > Routines > Sales > Year End Close Choose Fiscal/Calendar/Both Look at the Closing Date! DO NOT hit process button twice or it will close again! Last Year #s will zero out *Beginning in GP 2013 - Ability to select any printer after selecting “Close Year” (even a pdf if you have adobe writer installed). . Prior to 2013, one you clicked close, you COULD NOT change it.

Closing Company Tax Details After closing BOTH AP AND AR MODULES!! Tools>Routines >Company >Tax Year End Select Close Year check box AND/OR Print Report. Click Process. When prompted to continue with the year-end close, Click Yes. Recommendation: Keep copy of year-end report w/ permanent year-end audit records. Need to Modify $ Amounts in fields? Go to: Tools > Setup >Company > Tax Details

Payables Year-End Closing Calendar Year End When: Close at end of Calendar year, prior to posting transactions in the next Calendar year What - 1099 Amounts YTD cleared, move to LY and LTD Fiscal Year End When – Close at end of Fiscal year prior to posting transactions in the next Fiscal year What - Vendor Yearly Summary Figures are moved to History – updates LY and LTD Closing the year will affect Summary Screens, Smartlists, and Reports showing yearly (this year, last year fields). Scripts available to fix “Amounts Since Last Close” in summary screens.

Payables Vendor Summary Views

Payables Management Year-End Steps Ø Post all transactions for calendar year to close (2017). Ø Put trx for new year (2018) in batches, but not posted. Ø Print Reports>Purchasing>Trial Balance—Aged Trial Bal w/ Options Ø Print the Vendor Period Analysis Report (newer suggestion) Ø Print 1099 Statements using the Print 1099 window Tools > Routines > Purchasing > Print 1099 Ø Do Backup “Post-1099 edits” Ø Close the year Ø Close the fiscal periods Ø Close the tax year Ø Make a Back up named “Post Year End”

1099 Vendor Information When AP invoices w/ 1099 figures are paid, 1099 amount is updated. Verify 1099 Data - Smartlist: Vendors with 1099 yes (& Tax Reg Blank/UDF 2 for W-9 a yes!) Print Edit List of 1099 Vendors Tools > Routines > Purchasing > Print 1099 icon Inquiry Vendor Period Report

Payables Management Year End Important points to remember (Additional functionality in GP 2013) • Separate 1099 Address ID field on vendor card • Additional Box Numbers added for each Tax Type • Additional fields on the 1099 Details window • New functionality to edit 1099 information: • Edit 1099 Transaction Information window (per trx) • Update 1099 Information utility now has options for ‘Not a 1099 vendor’ tax type (per vendor) • Print 1096 Summary Form

Update Vendor 1099 Information Edit 1099 Trx info, see detailed transactions for a 1099 vendor & change the individual trx info to ensure accurate 1099 s. Purchasing Area > Transactions Menu > Edit 1099 Transaction Information

Make vendor 1099 after transactions entered! Purchasing Area > Utilities Menu > Update 1099 Information

Editing 1099 Vendor Information Old Method of Editing 1099 Amounts (Summary Amounts) for prior payments Vendor Maintenance Card > Options Tab Mark Vendor as a 1099 type Cards > Purchasing > 1099 Details Tracks amounts by period/tax type by vendor.

Printing your Company 1099’s Tools > Routines > Purchasing > Print 1099 Only those vendors marked as “ 1099 Vendors” AND with over $600 in 1099 payments will print or show on the list. GP 2013+ you can print 10096 forms too! For an Edit List – hit the printer icon!

Print Period Analysis Report (& email) Reports > Purchasing > Analysis > Period

Closing the Accounts Payable Module Tools > Routines > Purchasing > Year End Close Ø Calendar year Ø Fiscal year Ø Both Close tax year too… GP 2013+ you can select printer AFTER clicking on “Close Year”. Print to PDF! (have Adobe Writer installed).

Company Data Archive Databases Getting large? Inquiry/Reporting slowing down? Start the New Year with improved GP performance and increased productivity with the help of CDA. Just ask for a demo or trial keys.

Project Accounting Year End No Specific Year-End Process for Project Accounting Ø Projects can span multiple fiscal periods. Ø Additionally, projects are independent of the fiscal and calendar year. Optional: Perform the following procedures as part of basic year-end process: Ø Post all cost transactions. Ø Run final billings & revenue recognition on projects for the year. (so GL module is updated before you run year-end routine in GL). After doing this PA & GL will reconcile more quickly/easily. Ø Update the rate tables in PA Position Rate Table Maintenance and PA Employee Rate Table Maintenance windows.

Fixed assets closing results Inquiry > Fixed Assets > Book Asset General Window: • YTD Maintenance amount is removed • Qty is copied to the Begin Qty field Asset Book Window: • YTD Depreciation Amount is removed • Cost Basis is copied to Begin Year Cost • LTD Depr moved to Begin Reserve • Salvage is copied to Begin Salvage Book Setup Window - Current Fiscal Year is updated to new year Do NOT manually change this year to post a new asset into the new year, you will damage data! Just take the time to close the year!

PRIOR to Fixed Asset Year-End Close Ø Enter ALL transactions for the year. (AP, Transfers, etc) Ø Close ALL books before you can process in new year. Ø Fiscal Year End only Ø Run depreciation for the final period of the year. Run depreciation through the last day of the year. Tools>Routines>Fixed Assets>Depreciate Ø Run the General Ledger Interface (Automatic in GP 2013) Date should fall within the current fiscal year that is being closed. (OLD Version - Tools>Routines>Fixed Assets> GL Posting) Last module closed before GL (AFTER A/P!)

PRIOR to Fixed Assets Year-End Close Run reports Build Calendars Verify Quarters Run Backup Ø Run the following reports: Depreciation Ledger Property Ledger Annual Activity Additions Retirements If more than one year also run Book to Book YTD COMPARISONS Ø Ensure that the Fixed Asset Calendar is built correctly Tools>Utilities>Fixed Assets>Build Calendar Ø Verify Quarters setup for all Fiscal Years Tools>Setup>Fixed Assets>Quarters Ø Run a backup!

Year End Steps Fixed assets Ø Run year end routine Tools>Routines>Fixed Assets >Year End Verify Current Fiscal Year on Available Books list is correct. Tools>Setup>Fixe Select each book Insert that book Click continue ** A report WILL BE generated from this process from GP 2015 R 2+

Fixed Assets Year-End Report A Fixed Assets Closing report now prints w/ year-end close process. Prints per Book. Shows: Asset ID, Description, Cost Basis, YTD depreciation, Accumulated Depreciation, NBV, Placed in Service Date, Depreciated to Date, Quantity, YTD maintenance and Status for all assets impacted by year-end close. Single Step – Close Year/Print Report!

Analytical Accounting Notes If AA is being used, be sure it is installed and enabled on workstation where GL is being closed! Don’t underestimate the importance of AA matching GL amounts. **Scripts to verify AA data against GL Management Reporter (Data Mart) reads from AA tables AA Codes automatically close when GL is closed.

Analytical Accounting Year End Scripts • PRIOR to closing GL: Verify records are not duplicated: select distinct(YEAR 1) from AAG 30000 select distinct(YEAR 1) from AAG 40000 • PRIOR to closing GL – see that top 2 & bottom 2 match: select distinct(YEAR 1) from AAG 30000 select distinct(OPENYEAR) from GL 20000 select distinct(YEAR 1)from AAG 40000 order by YEAR 1 select distinct(HSTYEAR) from GL 30000 order by HSTYEAR • Be sure the following returns no results: select count(*) from AAG 40001 where aa. Copy. Status<>8 • Option (setup) to have BBF entries on dimensions AA data closes with GL regardless of whether options on dimensions are marked

Analytical Accounting Close Setup In the Analytical Accounting Options window option should be checked as illustrated below. GP > Tools > Setup > Company > Analytical Accounting > Options Check box to “Include dimension in year-end close”

Analytical Accounting Dimension setup Once AA closing is enabled, define “Consolidate balances during Year End close” option for every transaction dimension in the system. Cards > Financial > Analytical Accounting > Transaction Dimensions Don’t miss marking this for any dimension as it will not close during the year end process.

General Ledger Closing What does GL Closing do? Ø Closes P/L to Retained Earnings Ø Pushes B/S account balances to new year. Only RE B/S accts will have a diff BB than previous year’s ending balance. In GP 2013, choose to Unit Accounts roll forward or clear! Ø Moves open year $ to historical year (GL 20000 to GL 30000) Ø Fiscal Year is marked as historical. Ø AA tables are updated. Moves AA data to history & creates BBF entries on dimensions Ø GP 2013: Option remove inactive accounts – or leave those w/ budgets.

General Ledger Closing Ø General Ledger closing does not have to be done right at year end. **BUT setup new year & periods to process trx for new year. GL Close Key points Ø Have all users exit during the closing process. Ø Enough disk space to double GL 20000 in size. Ø Recommended* - Run GL close at server. Ø Last module to close (Reverse Now available!)

Year End Steps for GL Closing 1. Complete posting/closing for other modules. 2. Post final adjusting entries in GL 3. Print Account List or Smartlist to verify Posting Type 4. Close the last period of the fiscal year (Optional) Setup > Company > Fiscal Periods

Year End Steps for GL Closing (cont. ) ** Retained Earnings Acct WITH option to close to Div. Segments. 5. Make sure Maintain History for Accounts & Transactions is marked. Tools > Setup > Financial > General Ledger ** Also can choose the NEXT Journal Entry to use (Some companies choose “ 16 -000000” to start a new year) 6. Perform File Maintenance on all Financial files – Have users out of system, this may take awhile! File > Maintenance > Checklinks

Year End Steps for GL Closing (cont. ) 7. BACKUP! **Reverse Historical Year available for a re-do! 8. Print final Detail Trial Balance Reports > Financial > Trial Balance > Detail 9. Print final financial statements (FRx, Mgmt Rept, AF) 10. Set up new year in Fiscal Periods Setup. Tools > Setup > Company > Fiscal Periods 11. Close the fiscal year. Tools > Routines > Financial > Year end closing

GL Year End Closing Screen - New Options To ONLY keep inactive accounts that have Budgets, select as shown. The Progress Bar Works! If you don’t select anything, it will NOT remove unused segments and it WILL delete all inactive accounts.

TIPS to dodge a GL Support Call Yes, you can post adjusting entries to the closed year. (But not 2 years back!). Ø Make a copy of your LIVE system into TEST and run a BETA Close in TEST. Make Backups!! Ø Check Account Types (Profit & Loss/Balance Sheet) To fix this: Account not set with correct posting type? TK #864913. Ø Adjusting Entries Needed? § Go to fiscal period setup. Tools>Setup>Financial>GL § Uncheck the particular month § Set allow posting to history § Make the entry AND re-check the month you opened.

AUDITORS REQUEST (Smartlist) External auditors usually ask for a list of all GL entries: • Posted for the year, • Who posted them, and • When they were posted SOP Posting is different. Use USER 2 ENT = User ID entered trx PTDUSRID shows User ID who posted final invoice. These are in SOP 10100. Use Account Transactions Smart. List, filter for Financial Transactions, & add Columns: • User Who Posted (User ID of whoever posted trx) • Originating Posted Date (Sys date) • Reference (GL Description, WHY entry was made) - Starting In GP 2013, now an approval ID/Date for Batches!

Payroll year-end checklist 1. Verify ALWAYS at Calendar Year-End Tools>Routines >Payroll > Year-end Closing your version of GP. 2. Download Payroll Tax updates for 2015. 3. Complete all pay runs for the current year 4. Complete your company’s regular monthly/quarterly payroll procedures for the current year (SUTA/FUTA, WC, Form 941) 5. Make a “Pre Year-End Wage File” backup. 6. Create the Year-End Wage file

Payroll year-end checklist (Cont) Tools > Routines > Payroll > Print W-2 8. Make a backup of new file (named “Post Year-End Wage Table”) 9. Verify W-2 & 1099 -R statement info (Note: If any changes are made to the statement information , make another backup). 10. Print the W-2 statements & W-3 Transmittal form Select Radio Button that you need * Edit W-2 info if necessary Tools>Routines >Payroll>Edit W 2 s

Payroll year-end checklist (Cont) 11. Print the 1099 -R forms and the 1096 Transmittal form (Same Window) Click 1096 Transmittal Form Radio Button, & click Print. ** You can print the 1099 R and/or 1096 Transmittal form as many times as you need. 1099 -R Forms Tools > Routines > Payroll > Print 1099 -Rs Click 1099 -R Forms, and then click Print.

Payroll year-end checklist (cont) Optional: Create a magnetic media file – EFW 2 12. Optional – Electronic Filing Company > 250 employees? - Select Appropriate Companies, - Enter User ID Number, - Click Submitter. The Electronic Filer Submitter Information window opens. - Enter the authorized submission information. - Close Electronic Filer Submitter Info - Change file destination info in the File Name field if it is required. - Click Create File Social Security Administration requires you to create & submit federal W-2 wage reports electronically! Tools > Routines > Payroll > Electronic File

Payroll year end checklist (cont) 14. (Optional: ) Archive inactive employee HR info. Tools > Utilities > Human Resources > Archive Employee 15. Close fiscal periods for payroll series for 2016. (Opt: ) Delete inactive employee info. (To save disk space, but do AFTER creating Year End wage file). Tools > Utilities > Payroll > Remove Inactive do NOT count as ‘active’ employees in license count.

Payroll year end checklist (cont) 17. Set up fiscal periods for 2017 Tools>Setup>Company>Fiscal Periods 18. Install the payroll tax update for 2017 Confirm update – GP > Maintenance > U. S. Pay Update > Check for Payroll Tax updates > Automatic – Next > Enter Authorization # (Login) > Finish. 19. Setup Attendance for new year (Reset with Mass Update) Tools > Setup > Human Resources > Attendance >>Setup Or Tools >>Utilities >>Payroll >>Mass Update 20. Update Local tax and Unemployment Tax rates. 21. Run first 2017 payroll.

If a Company Needs to: Run Paychecks in 2018, prior to closing 2017 1. Verify Version #. 2. Download Payroll Tax updates for 2017. 3. Complete all pay runs for the current year 4. Complete all monthly/quarterly payroll procedures for 2017 5. Make a backup of the original file 6. Install the Year-End Update 7. Create the Year-End file ü Do steps 1 -7 on the left (Previous checklist) ü Set up Fiscal Periods for 2017 Tools>Setup>Company>Fiscal Periods ü Install the payroll tax update for 2017 ü Process 2017 pay run (user date must be 2017) ü THEN Print W-2 / W-3 Transmittal form ü Print 1099 -R /1096 Transmittal form ü Create magnetic media/Inactivate employees

Affordable Care Act Compliance/Reporting ACA View – Smartlist! • WITHIN MICROSOFT DYNAMICS GP – Very Basic. • Check out ACAView. doc (download here). • https: //community. dynamics. com/gp/b/dynamicsgp/archive/2015 /04/01/the-march-hotfix-has-released-what-is-all-the-excitementabout

Affordable Care Act Compliance/Reporting Use Third Parties: INTEGRITY DATA or GREENSHADES ACA Compliance Reporting & BI Tools

www. greenshades. com The E-File Wizard automatically extracts info from GP & creates EFiles suitable for filing to tax and non-tax agencies. Green. Shades can E-File each of the reports below as well as custom reports your company may need: State Filings (SUTA and W 2) State New Hire Reporting Federal 1099 Federal W 2 s Local W 2 s 940 and 941 Reports 401(k) Reports

Questions?