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.
    http://www.GPReportsViewer.com
    http://victoriayudin.com



  • 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
    President
    mc²



  • 5.  RE: Bank Transaction Entry Functionality

    GOLD CONTRIBUTOR
    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? 

    Thanks!

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



  • 7.  RE: Bank Transaction Entry Functionality

    TOP CONTRIBUTOR
    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
    904-536-0129

    Attachment(s)

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


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