Request a live WebEx Demo

Download a  TRIAL VERSION of Easy e-Bank RecTM

Frequently Asked Questions

The Microsoft Dynamics^TM GP Bank Reconciliation is quite simple and allows for range marking of cleared items.  What benefit does Easy e-Bank Rec^TM have that significantly outweighs the existing system?

Often the checks in GP start with a 0.  But the bank drops the 0 so how would the matching occur in this instance?

If the checks are off by 1 number (as experience has proved happens periodically), how difficult does the reconciliation become?

Once researched, unreconciled items are easily dealt with in Microsoft Dynamics^TM GP.  The adjustment page of the GP reconciliation process accounts for interest and service charges quite easily.

Do you still need to process deposits to get them into the reconciliation or does Easy e-Bank Rec^TM do it for you?  At our business, because of our daily credit card processing, this is the most time consuming part of the reconciliation process.

I would be more interested in seeing a product that allows import of checks from another system into Microsoft Dynamics^TM GP so that bank reconciliation can be accomplished more easily.

Can Easy e-Bank^TM Rec import bank statements from foreign banks?

Do I need any other software besides Microsoft Dynamics^TM GP to use Easy e-Bank Rec^TM?

Which file formats does Easy e-Bank Rec^TM support for the bank tape import?

What is BAI?

How can I view the detail comments on the bank tape?  What do I do if the bank tape transactions have the same number?

Q:  The Great Plains Bank Reconciliation is quite simple and allows for range marking of cleared items.  What benefit does Easy e-Bank Rec^TM have that significantly outweighs the existing system?   

A:  If you have 50 checks, marking cleared items is not an issue. When you have 300 or 5000, then it starts to become more complicated.  Easy e-Bank Rec^TM has a one-click feature  that performs all of the check marks in the Great Plains bank reconciliation.  You no longer have to match the paper statement one click at a time. 

Moreover, when you import the bank tape, Easy e-Bank Rec^TM automatically matches all items. You can click a button that will display only non-matches (hence, not reconciled) and therefore, only deal with items that require attention.  We visually show you what is matching and not matching.  The more Easy e-Bank Rec^TM does, the less you have to do!

Back to top

Q:  Often the checks in GP start with a 0.  But the bank drops the 0 so how would the matching occur in this instance? 

A:  Easy e-Bank Rec ^TM is built in such a way that the zeros are NOT dropped at the import.  The Preview Checks or Deposits Matching will actually strip leading zeroes and do the matching for you.

Back to top

Q:  If the checks are off by 1 number (as experience has proved happens periodically), how difficult does the reconciliation become? 

A:  Great idea!  In Easy e-Bank Rec^TM, you can modify the user input of the bank number by copying it over from the previous record or just change the last digit. However, to be able to specify a shift of 1 number for a range is a great idea. That one goes in the suggestion box ASAP. Thank you!  How about if we allow you to select the starting and ending check number and adjust all document numbers by 1 or -1!

Back to top

Q:  Once researched, unreconciled items are easily dealt with in Great Plains.  The adjustment page of the Great Plains reconciliation process accounts for interest and service charges quite easily.  

A:  True - for those two instances, but they are not booked in the GL and hence the Bank to GL reconciliation is not complete until the reconcile button is hit. Easy e-Bank Rec^TM automatically books those and other kinds of charges so no manual entry is needed and they are 100% accurate. For example, BAI code 354 is an "Interest Credit" - usually the interest received on the bank statement.  Easy e-Bank Rec will book these transactions automatically.  The same is true for service charges, ZBAs and Sweeps.   

Back to top

Q:  Do you still need to process deposits to get them into the reconciliation or does Easy e-Bank Rec^TM do it for you?  At our business, because of our daily credit card processing, this is the most time consuming part of the reconciliation process.   

A:  I suspect you have credit cards that are settled and the resulting batches are wired to the account by the merchant account processor. The actual wire or deposit already can be booked automatically by Easy e-Bank Rec, as it allows you to identify which entries on the bank tape can create automatic transactions in the bank reconciliation module.

The part that would have to be added is to allow the credit card receipts to be matched to those deposits. We are currently working on that process. Give us a ring and we will be happy to make it work for you! 

Back to top

Q:  I would be more interested in seeing a product that allows import of checks from another system into Great Plains so that bank reconciliation can be accomplished more easily.  

A:  We have SQL statements that do this immediately. If you give us an export file, we can automate this function for you and would include it in your bank reconciliation. The import would allow you to record a bank transaction entry and post to the GL without re-keying.

Back to top

Q:  Can Easy e-Bank Rec^TM import bank statements from non-U.S. banks?

A:  Yes.  We will build one custom bank connection free of charge with the license purchase.  All we need from you is the document number, date, amount and uniform transaction description, preferably a code.

Back to top

Q:  Do I need any other software besides Great Plains to use Easy e-Bank Rec?

A:  Yes.  If you want to export to Excel, you will need Excel.  For your information, our System Requirements are:

Easy e-Bank Rec^TM will work with GP 7.5, 8.0 and 9.0 and is compatible with SQL 2000 and SQL 2005. It will also work with databases that have enabled the binary sort.

Back to top

Q:  Which file formats does Easy e-Bank Rec^TM support for the bank tape import?

A:  The BAI File format is the preferred method.  Depending on your bank's implementation of the BAI standard, it can include all of your bank accounts in a single download.  This makes it easy, as you only have to perform one import from the bank.  By the way, Easy e-Bank Rec^TM will import only the bank account that matches the check book ID in Microsoft Dynamics^TM  GP.

QIF File (Quicken Interface Format)is also supported, preferably with a BAI Code.

Version 9.0 of Easy e-Bank Rec^TM provides the option to set up your own import with CSV, TAB, or an Excel file.

When necessary, we can also build a custom import for a small fee.  We have even imported bank tape data from a web report!

Back to top

Q:  What is BAI?

A:  BAI information can be obtained from www.bai.org.

The code standards are explained at http://www.bai.org/operations/PDF/Cash_Management_2005.pdf.

An FAQ is also available at http://www.bai.org/operations/faq.asp

Back to top

Q:  How can I view the detail comments on the bank tape?  What do I do if the bank tape transactions have the same number?

A:  Easy e-Bank Rec allows you to view the bank tape comments for each transaction.  Just click on the ellipse button by the bank tape transaction on the right side of the screen.  A window pops up that gives you the following information: 

§   Cleared Date

§   Document Number Field – the document number on bank tape

§   User Input Field – you can enter the corresponding GP document#

§   Amount

§   Detailed Description from the bank tape comments

§   Import Date

§   Bank Code 

If there is a number on the button to the right of the transaction instead of an ellipse, it means there are multiple transactions with the same document number on the bank tape.  To view individual transactions, click on the button.  Enter a starting check or deposit number or a zero in the field to the left of the Auto Update Button.  Then click on Auto Update to split the bank tape transaction grouping into its component transactions. 

Back to top