Skip to main content

Electronic Bank Reconciliation with Dynamics GP

Did you know? Dynamics GP includes the ability to process a file from your bank that includes cleared items and reconcile cheque books.

Setting up Electronic Bank Reconcile in Microsoft Dynamics GP is incredibly useful and easy to use. If you don’t see the menu on your screen, it could be that the program isn’t turned on and you will need to speak to your system administrator to resolve this.

The most difficult part is configuring the file format from your bank to match what will be usable by Dynamics GP. Once you obtain the required layout information from your bank, 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 bottom of the screen to indicate which transactions codes in the source file represent the types of transactions.

Use Download Maintenance to define the accounts using that file layout and the location of the download file.

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

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

If you would like to learn more about Electronic Bank Reconciliation with Dynamics GP reach out to the GP support team or give us a call at 204-982-9890.

Over 25 Years Experience

At Prophet we understand that software is just a starting point and we’re focused on delivering solutions that drive accountability, efficiency and growth. Whether you’re outsourcing or looking for someone to work with your team, it’s important to have a partner you have confidence in.

Contact Us Today!