web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

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

I have the same question (0)
  • L Vail Profile Picture
    65,271 on at

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans