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.
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.
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