Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Transaction Entry Postings May Appear On Trial Balance And Not In Bank Rec Vice Versa

(0) ShareShare
ReportReport
Posted on by 140

I am reconciling the bank accounts and various transactions that have been posted do not appear in the bank reconciliation screen, however they affect the trial balance (GL). Vice-versa, some transactions do not reflect on the trial balance, but show in the bank reconciliation window to be reconciled.  These are all posted transaction entries whether they are deposits or withdrawals (in other words they have not been entered as journal entries).  Is there a posting setting that needs to be updated in Dynamics GP 2010, or will all these transactions need to be voided and entered in a different manner?  Thank you in advance!

*This post is locked for comments

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Transaction Entry Postings May Appear On Trial Balance And Not In Bank Rec Vice Versa

    Transactions posted on the Bank Reconciliation Module are supposed to throw to GL according to your posting setup. 

    Go to Microsoft Dynamics GP > Tools > Setup > Posting > Posting

    You need to check three origins (Bank Transaction, Bank Transfer and Bank deposit). The option highlighted on the left regarding either post to or post through general ledger determines how the journal entries will be populated when one of these transaction is posted on the Bank Reconciliation module.

    As for the correction, you need to consider initially the Reconcile to General Ledger (Microsoft Dynamics > Tools > Routines  > Financial > Reconcile to GL) in case you are on GP2013. Otherwise, in case you have already determined all the incorrect transaction, you could use the following criteria:

    • Individual correction, through which you need to go through the incorrect transaction one by one, void and enter the correct one. In case the original transaction is not posted to General Ledger, ensure to uncheck the post through and post to options above in order not to post a reversing journal entry (this will corrupt your cash account)
    • Mass correction, through which you can correct the monthly difference with one transaction, either on the general ledger or bank reconciliation in order to have these two modules tie together.
    One more not to consider, transactions posted on the module will go through general ledger according to your setup. Otherwise, the other scenario doesn't happen, which means journal entries affecting your cash account on the GL level doesn't flow up to the Bank Reconciliation Module.
    Further illustration can be found below: Bank Reconciliation
  • sueconrod Profile Picture
    sueconrod 335 on at
    RE: Transaction Entry Postings May Appear On Trial Balance And Not In Bank Rec Vice Versa

    1.  Did you create all your deposits.  Even though you have entered the receipts into Great Plains, you must go into TRX>>Financial>>Bank Deposits.

    2.  Check your posting setup and make sure that all Bank Transactions are marked to post to and post thru to General Ledger.  Bank Deposit Entry, Bank Transaction Entry, Bank Transfer Entry.  This whay they will appear.  (Banking acts as a subledger to General Ledger and therefore need to post thru).

    3.  Go to your Transactions>>Financial>>Series Post and make sure that there are not any postings out there that are single entry that need to be posted to your General Ledger.

    4.  Check that there are not any batches stuck in Batch Recovery.  Tools>>Routines>>Batch Recovery

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,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans