Open Forum

Expand all | Collapse all

File Export for Bank Generated Checks

  • 1.  File Export for Bank Generated Checks

    Posted Mar 24, 2020 05:01 PM
    With our new remote working environment, we are investigating the possibility of having our bank generate our Payable checks for our company. We have the ACH process in place to submit NACHA files, but I wanted to know if anyone knows of an automated process within GP to send a formated excel file to a bank to generate your checks for your payables.

    ------------------------------
    Matt Larion
    VC3 Inc.
    Columbia SC
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: File Export for Bank Generated Checks

    Posted Mar 25, 2020 10:37 AM
    Edited by Lise Cummings Mar 25, 2020 10:47 AM
    Hey Matt!  Hope you are doing well!  This is Lise' Cummings, your account manager.  In the setup of the EFT Bank for Payables there is a field at the bottom of that window to select the Communication Type.  You can select either an application or an FTP site. We could also look at Mekorma and see what can be done there if the native functionality is not enough.  Please email me if you need additional help.

    Thanks!
    Lise' Cummings
    InterDyn Artis, an LBMC Technology Solutions Company

    ------------------------------
    Lise Cummings
    Client Strategy Manager
    InterDyn Artis
    (704)846-6750
    Lise.Cummings@interdynartis.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: File Export for Bank Generated Checks

    GOLD CONTRIBUTOR
    Posted Mar 25, 2020 04:35 PM
    I don't know of an existing automated process, but creating an Excel refreshable report for the data is where I'd probably start.  From there an Excel macro may be needed to handle any additional formatting.  If your bank can accept something other than an Excel file then SafePay in GP might be workable.  We use that for positive pay with out bank.  It gives you a good deal of flexibility in the selecting and formatting the data to include, but it's not really designed for the various remittance details you may need.

    ------------------------------
    Jim Harris
    Director of Information Systems
    ExamWorks, Inc.
    Atlanta GA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: File Export for Bank Generated Checks

    GPUG ALL STAR
    Posted Mar 26, 2020 09:39 AM
    Hi @Matt Larion

    I read your message as "You are already setup with your bank to do this but GP is not setup to output the EFT file"

    If that is the case, then Yes, GP is setup to automate the generation of a .txt file that you upload to the bank.

    In case I am reading it correctly, here is a link to how to setup the EFT process in GP:
    ​​
    https://www.gpug.com/viewdocument/setting-up-and-using-eft-in-dynamic?CommunityKey=f5effb5c-1971-4d11-af16-0817422d8c8d&tab=librarydocuments

    ------------------------------

    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: File Export for Bank Generated Checks

    GOLD CONTRIBUTOR
    Posted Mar 26, 2020 01:51 PM
    We are going thru the same process now.  We had our VAR create a file since there is no gp process to generate something like this.  We are in the early stages of this so we haven't had the bank test our file but once we get closer to implementation i can provide you with more information. You can contact me directly.  ​

    ------------------------------
    Theresa Rago
    Manager, Financial Systems
    CV Starr & Co, Inc.
    New York NY
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: File Export for Bank Generated Checks

    GPUG ALL STAR
    Posted Mar 27, 2020 08:51 AM
    @Theresa Rago

    Unless you are on a very, very old version of GP you are incorrect that GP Cannot create the file.  Please see my post above.​

    ------------------------------

    ------------------------------

    Academy - Online Interactive Learning from Experts


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