Electronic Bank Reconciliation with Dynamics GP

Electronic Bank Reconciliation with Dynamics GP

Looking for new software? Check it out, Free Small Business Accounting Software Dynamics GP 2015 Trials »


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

dynamics gp electronic bank reconciliation

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.

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.

To start the process, click on Download.

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

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.

dynamics gp electronic bank reconciliation

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

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

What’s Next? Learn more…

Outgrowing QuickBooks in dynamics gp electronic bank reconciliation

, , , , ,

No comments yet.

Leave a Reply