You’re offline. This is a read only version of the page.
Announcements
690
Has anyone been successful with using the "Electronic Reconcile" segment of electronic banking especially since this segment does not support the BAI format that 90% of the banks use? As a work around, our company has chosen to export our bank statement data into excel and from there put the data into the format that I have mapped in the Electronic reconcile configurator window. I have specified the path to the file in the download maintenance window and when I go to the transactions download window none of the data from the file populates into the scrolling window. I have tried many different ways to map the file in the configurator window all with the same results. Does anyone have any other suggestions that I could try?
*This post is locked for comments
Hi, I am still having issues with the reconciliation, after summit, it seems like a lot of people are on the same boat..
Is there anyway people can share the one file that is working for them?
My bank can provide CSV or BAI2.. but everytime i have a record type match not found.. the codes are there and they are set up.. dont know what else to do..
Hi all,
I need to perform the same setup of a BAI2 file using GP2010's configurator. Were you all able to find a means of configuring the file format to work properly with both checks and deposits? Is it possible to set this up without having to modify the download file data?
Daniela,
I am going through the same issue, getting a report that will have checks and deposits and feeding it to Electronic Reconcile the bank is not being very helpful as the previous file they provided, which never worked had only checks information. From that based a csv was provided but could it be possible that the code configuration be modified, I will work on that, if you go to the bank reconciliation set up screen you will find the transaction codes, the only transaction that matches the code from the banks generally is for the checks as it is "CHK".
Thank you Yolanda
My question was on the bank type codes.
Because it will recognize other stuff, but on the configurator will only let you set up one detail type code.
It seems silly as all businesses have more than just deposits or checks..
Maybe I am missing something, we also have a huge check volume.. but if the system is business intended......
Daniela,
When matching transactions, electronic reconcile matches checks based on the check number and bank cleared date or the dynamics transaction date, this is the reason that the program is able to reconcile your check data. Regarding your deposits, I believe it would work the same way although I have not tested this. You may have to edit the information in your download file to match the deposit number generated by the Great Plains system. Regarding the other transactions (i.e. increase adjustments, decrease adjustments, withdrawasl, etc.), you will have to manually mark of these items as "electronic reconcile' does not recognize these transactions.
During my testing, I manually marked off deposits and the other types of transactions as I am really only concerned with the volume of checks that we have every month that need to marked as cleared. I hope this helps!!!!!
THANK YOU SOOO MUCH!
I can start growing all the hair I pulled with this!!!
Now I have another problem though, on the detail/header/footer, I can only set one detail line there
right now I got it to where it will reconcile the checks (which is already a lot of help!) but it not recognizing deposits or anything else..
Do you have anymore wisdom to share?
Hi Daniela,
After several tests, I finally got the electronic configurator program to work. During my first tests, like you I was using a CSV format I changed it to a tab delimited (i.e. text file) and it is working. When using a CSV file for some reason it puts double quotes around some of the fields. If you open your file in notepad or wordpad you will be able to see the double quotes. I think that electronic reconcile has a problem with the quotes. Try saving your file as a tab-delimted file instead. Also, I setup configurator to use only detail lines no header or footer record types. I hope this helps!
Hi,
I am in the same situation, I am downloading from the bank, I get a CSV, and try to bring it in to GP but it tells me error transaction because it can't read the code..
Instructions in GP are not great on how to set up the codes/types which I think might be the problem I am having...
Help?
Makr,
Currently, the new bank that we are opening our accounts with "only" provide BAI transmission files. They have no other formats. Electronic Reconcile according to the documentation does not support this format. The "only" other option that we were given by our bank is to export our banking activity into excel. As a result, the bank is really not providing us with a format which leaves me to make up our own. I have configured several fixed, tab, and comma delimited formats in the "Electronic Reconcile" configurator window in addition to experimenting with several header and detail options. I am changing the format in excel to match the format that I developed. Even with this manipulation, the data is not importing correctly as nothing appears in my scrolling window after selecting download and then the transactions button. The banking information that we export into excel from the banks is as follows:
Account Number, Date Posted, Amount, Description, Check Number, Reference Number, and Activity Type.
Regarding our Partner, they have set up custom EDI programs for several of their clients however they have not worked extensively with the Electronic Reconcile product. As a company, we would really like to get Electronic Reconcile working as this is one of the reasons our firm purchased the "Electronic Banking" suite of products. We don't want to pay extra for something custom written. Any assistance that you can provide would be greatly appreciated.
#1
André Arnaud de Cal...
294,110
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
