Open Forum

Expand all | Collapse all

Bank Transaction Entry Functionality

  • 1.  Bank Transaction Entry Functionality

    Posted Dec 29, 2015 09:16 AM

    Hi GPUG Community,

    We are currently on GP2013 R2, and I have a question when using the Bank Transaction Entry window (Financials -> Transactions -> Bank Transactions).  As part of the improved functionality of GP2013 R2, we are able to copy and paste from Excel into the General Transaction Entry window, however I do not see this functionality present with Bank Transaction entry window.  I would like to understand if this functionality exists and whether I have just not located it or if there is another best practice for the entry of larger Bank Transaction entries?  

    Thank you!

    Michael George
    Senior Accountant
    In Touch Ministries
    Atlanta GA

  • 2.  RE: Bank Transaction Entry Functionality

    Posted Dec 29, 2015 10:14 AM

    Hi Michael,

    You're not missing it, the copy from Excel feature is only available for the General Ledger. One possible workaround for a large Bank Transaction is to enter it as a General Ledger transaction and use a Suspense account instead of cash. Then enter a 2 line Bank Transaction that simply hits Cash and Suspense.

    Victoria Yudin
    Microsoft Dynamics GP MVP 2005-2015
    Flexible Solutions, Inc.

  • 3.  RE: Bank Transaction Entry Functionality

    Posted Dec 30, 2015 08:09 AM

    Hi Victoria,

    Thank you!  I appreciate your confirmation of my question and suggestion for an alternate approach to help us with these transactions.

    Michael George
    Senior Accountant
    In Touch Ministries
    Atlanta GA

  • 4.  RE: Bank Transaction Entry Functionality

    Posted Dec 30, 2015 09:49 AM

    As part of our AIT (Advanced Intercompany Transactions) add-on we added the copy/paste from Excel to the PM Transaction Entry window (in addition to adding functionality to the GL copy/paste).  We had not considered adding it to Bank Transaction Entry, but that is a good idea and we will put it on the list of feature updates for release some time in 2016.

    Bill Marshall

  • 5.  RE: Bank Transaction Entry Functionality

    Posted Dec 31, 2015 09:33 AM

    We use integration manager to upload bank transactions.  Once it's set up it's easy for the user to enter the trxs in excel and then copy/paste them into the template.  

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

  • 6.  RE: Bank Transaction Entry Functionality

    Posted Jun 07, 2016 01:37 PM

    Do you have a template to share for the bank transaction integration? 


    Leihlani Bajacan
    Director of Accounting
    Advanced Dermatology & Cosmetic Services
    Maitland FL

  • 7.  RE: Bank Transaction Entry Functionality

    Posted Jun 08, 2016 09:39 AM

    Within Integration Manager there are sample integrations. Once you find the example for Bank Transactions you will see that it is made up of 2 files > A header and a detail file, with an Index number on each file that will be used to link the data from the 2 files together. I recommend creating a new integration that matches this one (I never change the original, lest I mess it up and then can't get back to how it was before I messed with it). Then, create the 2 files with the exact same column name headers and populate it with your data. NOTE: I always keep an excel version of my file first - as it is easier to work with, but then I save them down to a Text-Tab Delimited version and those are the ones that I have l linked to my integration.

    I have attached samples of the 2 excel files that I use as a base for my integrations.

    Barbara Gavron
    Atlantic Beach / Jacksonville FL


    Bank Trx-Dist.xls   20K 1 version
    Bank Trx-Header.xls   23K 1 version

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