Open Forum

Expand all | Collapse all

File Export for Bank Generated Checks

  • 1.  File Export for Bank Generated Checks

    Posted 16 days ago
    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
    ------------------------------


  • 2.  RE: File Export for Bank Generated Checks

    Posted 15 days ago
    Edited by Lise Cummings 15 days ago
    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
    ------------------------------



  • 3.  RE: File Export for Bank Generated Checks

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



  • 4.  RE: File Export for Bank Generated Checks

    GPUG ALL STAR
    Posted 14 days ago
    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

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

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



  • 5.  RE: File Export for Bank Generated Checks

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



  • 6.  RE: File Export for Bank Generated Checks

    GPUG ALL STAR
    Posted 14 days ago
    @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.​

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

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



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