Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

reconciliation bank

Posted on by 260

Hello, everybody.

 

Yesterday I have started the reconciliation 2010, well I am new person in this company and the last bookkeeper never entered nothing into the system. However I finished to enter everything, and now I have to reconcile, since I was working yesterday (je,je,je...overtime), I did not have any problem with the deposit everything matched, but I could not find the check, I know they are there because, I have printed everything, but the windows did not show these.

On the other hand, the last bookkeeper did not enter anything for 2009 either, the balance for 2010 Bank statement begins with 18,567 and something, now and if somebody print a 2009 BS it shows almost 2,000,000.00. However, I am very new in GP and my question here is when I finish with January 2010 do I have to do any adjusment.

Thank you for all the  help!!!!

 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: reconciliation bank

    Hi,

    i have the same problem but now its different when we run it it show every thing except only for deposit there is no descriptions. please i will very appreciate for your help too. We wish to print narration when doing bank reconciliation in GP – bank module.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: reconciliation bank

    Do you know if this checkbook was ever reconcile? If you go to Cards->Financial->Checkbook and pull up this checkbook  can you enter values for Last Reconciled Balance and Last Reconciled Date. If you can, this checkbook has never been reconciled. It that case you can follow these steps, ignore the steps about marking the CB as inactive, the point is to pick a stop where you have manually reconciled you CB:

    1. Post all transactions in Payables Management, Receivables Management, Sales Order Processing, Invoicing and Payroll.

    2. Click Cards, click Financial, and then click Checkbook.

    3. Select an existing Checkbook and then click to select the Inactive check box. Repeat this step to mark each existing Checkbook as inactive.

    4. Manually reconcile your last bank statement and determine your outstanding checks and deposits.

    5. Click Setup, click System, click Registration, enter your Registration Keys, and then click OK.

    6. Click Cards, click Financial, click Checkbook, set up your checkbook with the appropriate settings, and enter your Last Reconciled Balance and Last Reconciled Date from the last bank statement reconciled manually.

    7. Click Setup, click Posting, click Posting, select Financial as the Series, select Bank Transaction Entry as the Origin, click to de-select the Post to General Ledger check box, and then click Save. Repeat this step to de-select the Post to General Ledger check box for the Bank Deposit Entry window and then click OK to exit the window. This turns off posting to General Ledger.

    8. Click Transactions, click Financial, click Bank Transactions, enter your outstanding checks, and then click Post. Repeat this step to enter and post all outstanding checks, click X to close the window, and then click OK to print the Bank Reconciliation Posting Journal.

    9. Click Transactions, click Financial, click Bank Deposits, enter your outstanding deposits, and then click Post. Repeat this step to enter and post all outstanding deposits, click X to close the window, and then click OK to print the Bank Reconciliation Posting Journal.

    10. Click Cards, click Financial, click Checkbook, and then compare the Checkbook Balance to the Cash Account Balance. The two balances must equal.

    11. Click Setup, click Posting, click Posting, select Financial as the Series, select Bank Transaction Entry as the Origin, click to select the Post to General Ledger check box, and then click Save. Repeat this step to select the Post to General Ledger check box for the Bank Deposit Entry window and then click OK to exit the window. This turns on posting to General Ledger.

    12. Verify that all Customers, Vendors and Employees are set up to Use Cash Account from Checkbook.

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