Dynamics Community Forum Thread Details

Matching Checkbook to GL for Bank Accounts Not in Functional Currency

My company uses the bank reconciliation tool baked into GP 2010 for many of our bank reconciliations. The final step that I perform, after the accounts are reconciled but before the "Reconcile" button is clicked, is to match the checkbook balance to the GL account for that bank account. This ensures that nothing has skipped the checkbook and/or nothing has hit the checkbook but not the GL. It's been easy thus far, as the accounts I've been doing this with have been in the functional currency of the books in question. To perform this check, I'm simply pulling up the GL account in the "Summary Inquiry" window and matching the period balance to the checkbook balance (less/plus pending transactions).

However, I've now been tasked with getting some foreign bank accounts onto the bank reconciliation tool that GP has. These accounts are in currencies other than the functional currency of the books that they reside on, and therefore the checkbook balance (which is in the originating currency) won't match up with the GL balance (which will be in the functional currency). Under these circumstances, is there any way to perform this same sort of checkbook/GL check that I've been doing in the past?

Quick Links

Leaderboard