Dynamics GP E-Reconcile
Posted Tuesday, March 30th, 2010
Electronic Reconcile is part of the Electronic Banking series in Dynamics GP. If you are not using it yet consider the time saving possiblities. Instead of having to manually check off each cleared transaction in Bank Reconciliation you upload a file from your bank. Easy. With the exception of a BAI (Banking Administration Institute) type file Electronic Reconcile works with fixed field, comma delimited and tab delimited type files. Here’s a senerio of how the functionality works…
Your bank sends a file of cleared transactions. You save the file in a folder as a specific name you have previously determined which is mapped to the transaction upload window. See Below.
Microsoft Dynamics >> Tools >> Routines >> Financial >> Electronic Reconcile >> Transactions Download
- Select the Bank Account to upload transactions
- Click Download
- You will receive 2 messages. One asking you to proceed to the upload file, click OK, then a confirmation window. Enter in a code for the upload and click ok.
- On the window you will see the “Download” button change to “Transactions.” Click the Transactions button and you will see the transactions from the file in the window as seen below.
- Click the “Reconcile” button to take you directly to the bank reconciliation window.
- Click the “Transactions” button and the transactions from the bank file you received will be match to the transactions in the Bank Reconciliation module.
It really is that easy. There is a little setup and mapping required that your Dynamics GP consultant can provide for you. Then all you have to do is print the reconciliation reports to check the totals, check for any transactions or adjustments where the transaction maybe different and click the “Reconcile” button. Then you’re done.
Tags: Dynamics GP, Dynamics GP E Reconcile, Electronic Reconcile
Posted in Banking, Dynamics GP
Amy Walsh
Amy Walsh is a consultant with I.B.I.S., Inc. and Microsoft Certified Business Management Solutions Professional. She is a graduate of Mercer University. She brings over 15 years experience working with domestic and international enterprises ranging from start-up to established global B2B companies.
With her background in accounting / finance alongside working with Microsoft Dynamics GP as both an end user and consultant allows her articulate connectivity into the world of Microsoft Dynamics GP. Her goal is to help businesses succeed in their endeavors through process streamlining, education and finding the right ERP solution.
Need Expert Help With Dynamics GP?
Get the support you need to effectively manage your business.
Learn more about our Dynamics GP support options
[...] Amy Walsh has coverage of the electronic reconcile functionality in Dynamics GP in her new post Dynamics GP E-Reconcile up at DynamicsCare. Published: Wednesday, March 31, 2010, 12:00 [...]
I have tried several mapping configurations for Electronic Reconcile with no success of getting it to work. Can you send me a screen shot of the mapping you used in the “Electronic Reconcile Format Configurator” window? Additionally, can you send me the screen shot of the download maintenance window for this example?
Electronic Reconcile configuration is bank specific. Wachovia, Bank of America, etc…are all different. The data you receive in the bank file depending on the “type” of file delimited, fixed etc…have specific positions that the configurator reads and is also based off of the information in your checkbook (card>>financial>>checkbook). Unfortunately, I do not have the screen shots.
or
Helpdesk can assist | Main: (770) 368-4000
helpdesk@ibis.com
Enter Support Requests On-line at: http://www.ibis.com/dynamicscare.html
I downloaded reconciliation records from the bank for checks not processed by GP. They keep showing as not matched. I would like to delete these records but can not find the table in which they are kept. I must be missing something!