Skip to main content
Post a question

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Last Reconciled Balance in the Checkbook Maintenance Window

Posted on 5 Dec 2012 23:06:40 by Microsoft Employee

Could you confirm the correct procedure for entering opening balances into a new checkbook?  I have always understood that the proper procedure is to do the following:

Enter the Last Reconciled Balance and date in the Checkbook winow and Save.  This will update the Current Checkbook Balance with the beginning balance.  Then enter any outstanding checks into the Bank Trx Entry window and post to Bank Rec only - not to GL.  Then enter any outstanding receipts/deposits.

The controversy is whether the Last Reconciled Balance should be the amount on the Bank Statement Less the total of the outstanding cks OR is it the amount that appears on the statement without subtracting out the OS checks. 

If you enter the balance that is on the statement and then begin entering OS checks, this decreases the current checkbook balance which seems to me to be what should happen.

Then another theory I heard was not to enter anything in the Last Reconciled Balance field and continue with Reconciling.  Don't you eventually have to plug that figure in order to get the checkbook to balance?

The customer wanted to enter the opening balances into the checkbook by doing an increase adjustment.  It does update the checkbook balance with the increased amount but again what do you do with the Last Reconciled Balance field?

Thank you,

Nancy

 

*This post is locked for comments

  • callen Profile Picture
    callen 4,595 on 06 Dec 2012 at 20:39:04
    Re: Last Reconciled Balance in the Checkbook Maintenance Window

    The Last Reconciled Balance is the amount from the bank statement.  So, you would enter the bank statement balance and any outstanding transactions from that statement.

    Here's information from the Bank Reconciliation Training Guide:

    Follow these steps to transfer existing checkbooks:

    1.   Reconcile existing checkbooks using your previous system.

    2.   Set up each reconciled checkbook. This makes sure that the last reconciliation balance is the

    bank statement ending balance from step 1.

    3.   Enter transactions for outstanding checks and deposits that have not cleared as of the

    reconciliation in step 1.

    4.   Post. Make sure that outstanding checks and deposits do not re-post to General Ledger, if

    previously posted from another module.

    Reconcile the existing checkbook manually or in your other system before you set up a checkbook in

    Microsoft Dynamics GP. Reconcile the checkbook when the monthly bank statement is received.

    Otherwise, there may be several outstanding checks and deposits that must be entered manually.

    Use the Checkbook Maintenance window to set up each of the reconciled checkbooks. Enter the last

    reconciled balance for each checkbook. The last reconciled balance is the ending balance on the

    last bank statement. Change the last reconciled balance until the checkbook is reconciled for the

    first time in

    Bank Reconciliation.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans