Open Forum

Expand all | Collapse all

2020 1099 Changes on GP 2013

  • 1.  2020 1099 Changes on GP 2013

    GOLD CONTRIBUTOR
    Posted 19 days ago
    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 19 days ago
    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 19 days ago
    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 18 days ago
    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 18 days ago
    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


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