Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Opening balance in bank reconciliation module

(0) ShareShare
ReportReport
Posted on by 1,773

Hi,

I did not use bank reconciliation module in last 10 years in GP. So many transactions are in bank reconciliation statement for reconciliation.  I want to start from next month onwards this module without updating status of old transactions.  Please let me know how I can do this.  Please find attached screen-shot for your reference.

bank.png

*This post is locked for comments

  • Rdmatlo Profile Picture
    Rdmatlo 5 on at
    RE: Opening balance in bank reconciliation module

    Did you ever get an answer for this?  Mine is too.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Opening balance in bank reconciliation module

    I tried your solution and now I have difference between the bank rec and the trial balance

  • Suet Lee Profile Picture
    Suet Lee 1,347 on at
    RE: Opening balance in bank reconciliation module

    Hi P NOUSHAD,

    Did you managed to go about doing this implementation successfully as per suggested by Leslie?

    Hope to hear from you

    Thank You  

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Opening balance in bank reconciliation module

    You'll need to start a Bank Rec. Check all of the boxes EXCEPT your outstanding transactions. Use the Range button to Begin Range, End Range, Mark Range. Go back and uncheck any boxes for outstanding transactions.

    Look at the lower right-hand corner of the Select Bank Transaction entry window and make note of the Difference and which way it's going (too high or too low).

    If you need to increase the balance in the checkbook, make a Deposit Without Receipts. The checkbook balance will increase and no change will be made to the GL.

    If you need to decrease the balance in the checkbook, click the Adjustment button in the Bank Rec window and enter an 'other expense' transaction. Book the adjustment to your cash account so that both sides of the entry go to cash. This way, it won't change your GL balance.

    Kind regards,

    Leslie

  • P NOUSHAD Profile Picture
    P NOUSHAD 1,773 on at
    RE: Opening balance in bank reconciliation module

    Hi,

    Thanks for your support and help.  Let me know how do clear all previous transactions and start from this month by any utility or backend

    Regards,

    Noushad

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Opening balance in bank reconciliation module

    I recommend you clear everything except the truly outstanding items and then make an Adjustment to balance the checkbook. Be sure not to post the adjustment to the general ledger. If you need to increase the balance of the checkbook, enter a Deposit without receipts; deposits do not impact the general ledger.

    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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,289 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans