The underlying connection was closed: An unexpected error occurred on a send.
Q: The Great Plains Bank Reconciliation is quite simple and allows for range marking of cleared items. What benefit does Easy e-Bank RecTM 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 RecTM 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 RecTM 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 RecTM does, the less you have to do! Back to Top
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.
Great Plains
Bank Download
Matched at Import
System Action Preview Matching
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, 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 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 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 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:
Microsoft Dynamics GP 7.5 and 8.0
Microsoft Dynamics GP 9.0 SP1 or higher
Easy e-Bank Rec will work with GP 7.5, 8.0, 9.0, 10.0, 2010, and 2013 and is compatible with SQL 2000, SQL 2005, and SQL 2008 R2. It will also work with databases that have enabled the binary sort.
Q: Which file formats does Easy e-Bank Rec 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 will import only the bank account that matches the check book ID in Microsoft Dynamics GP. QIF File (Quicken Interface Format)is also supported, preferably with a BAI Code. Version 9.0 of Easy e-Bank Rec 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 http://www.bai.org. The code standards are explained at http://www.bai.org/about-bai/reporting-codes.aspx 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.
Testimonials
RSS Feeds