Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Matching Checkbook to GL for Bank Accounts Not in Functional Currency

(0) ShareShare
ReportReport
Posted on by

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?

*This post is locked for comments

  • L Vail Profile Picture
    65,271 on at
    RE: Matching Checkbook to GL for Bank Accounts Not in Functional Currency

    Hi,

    If you hit the currency button in the lower right hand side of the Summary Inquiry window, will that help?

    Kind regards,

    Leslie

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans