Open Forum

Expand all | Collapse all

2020 1099 Changes on GP 2013

  • 1.  2020 1099 Changes on GP 2013

    GOLD CONTRIBUTOR
    Posted Jun 17, 2020 09:45 AM
    Hi, all. We have GP 2013 R2 and just found out there are changes coming in the 1099s for 2020. I know we won't get those updates because of the version of GP we're running (at least I'm pretty sure) but was wondering if anyone knew of any 3rd party products that would allow us to complete the 1099s for this year... Either something that ties into GP directly or something where we could export the data via a Smartlist and import it to the product?

    Any help or other suggestions are greatly appreciated. Thanks

    ------------------------------
    Jon Godwin
    Database Administrator
    Boulder CO
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: 2020 1099 Changes on GP 2013

    GPUG ALL STAR
    Posted Jun 17, 2020 09:57 AM
    There are a number of online services that allow you to upload an Excel file with 1099 information by simply filling out a template. You could potentially create a SmartList to export the data as required by one of these services. Take a look at:

    https://www.tax1099.com/integrations/1099-excel-template
    https://www.esmartpayroll.com/excel_form_1099misc.asp?

    Disclaimer: I am not by any means endorsing any of these companies or have any affiliations with them. I am simply using these as a reference for companies that do provide the type of service you are needing to support your requirements above. The responsibility of validating whether a particular service fits your needs relies solely with you and your company :-)

    ------------------------------
    Mariano Gomez Bent, MVP, Dynamics Credentialed Professional
    Director of Technology
    Mekorma
    ROSWELL GA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: 2020 1099 Changes on GP 2013

    GOLD CONTRIBUTOR
    Posted Jun 17, 2020 11:03 AM
    Thanks, Mariano. I appreciate the leads.

    ------------------------------
    Jon Godwin
    Database Administrator
    Boulder CO
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: 2020 1099 Changes on GP 2013

    Posted Jun 18, 2020 11:03 AM
    I have used a couple of different 1099 products to print 1099 forms.
    - 1099 Express
    - TFP (comes bundled with the Office Depot brand 1099 forms)

    My experience with these software products is that they are a little clunky - meaning they're not the most intuitive. However, both allow for importing of a file of vendor information and payments. I think they both offer some sort of electronic filing capability (generating a file to upload to the IRS).

    I was able to modify one of Victoria Yudin's SQL queries to get the vendor payment data: https://victoriayudin.com/2010/07/15/sql-view-to-show-yearly-totals-for-dynamics-gp-vendors/.​ You should be able to get this data from SmartList as well.

    Hope this helps.

    ------------------------------
    Landon Russell
    Accounting Manager
    Capitol Services Inc
    Austin TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: 2020 1099 Changes on GP 2013

    TOP CONTRIBUTOR
    Posted Jun 18, 2020 01:10 PM
    Jon,
    As others have pointed out on here -- there are various 1099 solutions available to you once you get the data exported from GP.
    In case you're looking for a program to pull the data directly from GP, I can confirm that the Greenshades 1099 solution (including recipient copies and IRS compliant e-file) will support the new 1099-NEC for tax year 2020. So even though your values are stored as 1099-MISC currently (in GP 2013 R2), the data can still be extracted, massaged, and then reported as 1099-NEC to recipients and IRS. https://www.greenshades.com/year-end-solution/

    Let me know if you have any questions that I can help answer for you regarding this.

    ------------------------------
    Chris Hadden, CPP
    Product Management
    Greenshades Software
    jacksonville FL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: 2020 1099 Changes on GP 2013

    Posted 10 days ago
    Thanks Chris!  Will you be able to pull from GP 2010 as well?  For printing the 1099 MISC and 1099 NEC as well as electronic filing?


    ------------------------------
    Mary Lenehan
    Client Account Manager
    Crestwood Associates L.L.C.
    Mount Prospect IL
    mary@crestwood.com
    www.crestwood.com8472328282
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 7.  RE: 2020 1099 Changes on GP 2013

    TOP CONTRIBUTOR
    Posted 7 days ago

    Hi Mary,

     

    Yes, we will continue to support GP 2010. The Greenshades program will grab the 1099 type values from GP and allow the user to report these values as stored in GP. In the event a value is stored in GP as a 1099-MISC type and should in fact be reported as a 1099-NEC type, the Greenshades user does have options. The user has the ability to massage the data (export, and then re-import to Year-End Forms module as a 1099-NEC type) as a workaround to convert the data from a 1099-MISC type to a 1099-NEC type. In addition, any 1099-MISC appearing to report NEC values in Box 7, will be flagged within the program so the user can address accordingly.

     

    Please let me know if you have any questions on this.  



    ------------------------------
    Chris Hadden, CPP
    Product Management
    Greenshades Software
    jacksonville FL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 8.  RE: 2020 1099 Changes on GP 2013

    TOP CONTRIBUTOR
    Posted 6 days ago
    Hi Jon.
    We use 1099Pro.com.  The data mapping from Dynamics GP is easy to configure.  The application prints 1099 forms to plain paper and generates our e-file package for the state.  Printing duplicates or one-off forms is quick and easy.  There is also an option to upload our data to the cloud for printing, mailing and e-filing.  There are several editions of the software with various feature levels and the cost is very reasonable.

    ------------------------------
    Lou Spevack
    American Council on Education
    Washington DC
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role