Originally Posted in 2011 – This is a reposting as my blog URL has changed since it was originally posted.
Need to balance the cash as of the last day of last month? Use the Microsoft Dynamics GP Checkbook Balance Inquiry window.
Enter the date range BEFORE entering the Checkbook ID. Data begins populating as soon as the Checkbook is entered, and if there is a lot of transactions, you might end up waiting before having the opportunity to enter the date range.
In the top right hand corner is the Current Checkbook Balance, which is what Bank Reconciliation has as of now, and below that is the Current Cash Account Balance, which is what the General Ledger has in it now. At the bottom the Bank Balance for the ending date range you enter will be displayed. Use the print icon in the top right corner to print the detail to support your Balance Sheet.