Electronic Bank Reconciliation with Dynamics GP

Dynamics GP includes the ability to process a file from your bank that includes cleared items, and reconcile the checkbooks in Dynamics GP.

This is actually pretty easy to use. The most difficult part is configuring the file format from your bank, to match what will be usable by Dynamics GP. Go to the configurator screen and create a configuration that matches your bank’s download file. You can configure header, detail, and footer records.

Click on the Codes Entry button at the top of the screen to indicate which transactions codes in the source file represent the types of transactions.

You can process a file by going to the Transaction Downloads screen.

To start the process, click on Download.

Then click on Transactions (It’s the same button location)

Once the transactions have processed, click on Reconcile. This will bring you to the normal Bank Reconciliation screen. Proceed as normal.

That’s it.

This is the source file I used for this example: Payroll Transactions

This is the configuration file I used: BankRecConfiguration

If you need to clear out the tables check this out: Clearing Electronic Reconcile Transactions

Here’s a video that shows it in action: http://youtu.be/_gdbhBGh1LY

The post Electronic Bank Reconciliation with Dynamics GP appeared first on myGPcloud.