Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Void Bank Reconciliation Transaction in different Period

(0) ShareShare
ReportReport
Posted on by

Hi Everyone,

In June, one of my coworkers accidentally entered a bank deposit transaction which did not existed at all if you match the bank statement.

She entered Dr $51 from bank (Cash in) and Cr $51 for Un-explainable revenue account on June 5 via increase adjustment under Transactions - Financials - Bank Transaction. After bank reconciliation done, this $51 deposit become pending deposit.

When I take her job, I spot this mistake. When I try to void this transaction, I went to Transactions - Financials - Bank Transaction then void this transaction but I choose transaction date on July 1, 2017.

When I was voiding it, June period has not been closed in GP. But June is the last month of our financial period. Again, last year has not been closed neither due to ongoing auditing.

As a result, GP made below entries:

June 5, Dr bank $51 and Cr bank $51

July 1, Cr bank $51 and Dr bank $51

I cannot see this pending deposit from Bank Reconciliation because I voided it. But, if you add trail balance for bank in June, it is still have $51 on debit side. 

Can anyone is able to explain to me what GP entries mean and do I need to do something further?

Thanks.

PZ

*This post is locked for comments

  • Verified answer
    RE: Void Bank Reconciliation Transaction in different Period

    Hi Sandip,

    Thanks for the reply. It is troubled me for days. I called our GP service provide and finally understand what happened and why GP did that.

    Because my company does not purchase Encore module for bank reconciliation, so we have to use Transactions - Financial - Bank Reconciliation instead. JE cr and dr same amount in both June and July actually is balance GL in bank reconciliation module only. This is why when I did bank reconciliation, it all balanced. But GL for bank (when you go to Reports - Financial - Trial Balance) is unbalance because it is another module. This is why when I add all dr and cr, there is an extra amount outstanding.

    Long story short, I do need an extra JE to write-off unbalance amount.

    Thanks again for your help.

    PZ

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,267 on at
    RE: Void Bank Reconciliation Transaction in different Period

    Hellp PZ,

    I don't think you need to do any further things.  This kind of situation will come again and again whereas you have closed period and then later you voided closed period transaction in next period.

    Just for accounting purpose your June Balance is with $51 and July it is zero out.

    Let's see other bloggers view if any but I am sure you should good to go.

    Thanks much

    Sandip

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,436 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans