web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
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

I have the same question (0)
  • Suggested answer
    sandipdjadhav Profile Picture
    18,319 on at

    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

  • Verified answer
    Community Member Profile Picture
    on at

    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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans