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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Help! Trying to clear bank items that were paid/reversed in different months

(0) ShareShare
ReportReport
Posted on by 5

Good morning all, 

I hope someone here can help. We've tried everything we can think of but haven't had any luck yet. 

We had an error with our bank and they returned some checks they shouldn't have. 

The trouble is they paid them on 8/31 according to our bank statement - and then reversed them on 9/1. 

The checks were voided before we started the reconciliation so weren't available to check off in order to balance to zero. 

We thought the solution would be to re-enter them as manual payments and then reverse those for September. 

We were able to check off the manual payments and reconcile August but now we can't figure out how to reverse them for September. When someone tried to void them the message came back that we can't void them because they're reconciled. 

I was asked to "un-reconcile" them so we can get them voided.

Will that work - and how do I do that? The transactions no longer appear in the reconciliation.

Thank you! 

Categories:
I have the same question (0)
  • Suggested answer
    Cheryl Waswick Profile Picture
    Microsoft Employee on at

    Just so I understand,

    the bank cleared the checks on the 8/31 bank statement and then credited them back on 9/1.

    In GP, you issued the checks in August and also voided them in August so they did not show up on the bank recon.

    Then you rekeyed them in August and cleared them with the 8/31 bank statement and reconciled.

    Now on the Sept bank recon, there is not void to offset the credits on the Sept bank statement?

    --------------------

    The first set of checks were entered and voided before they were reconciled, so they drop off the recon.

    The 2nd set of checks were reconciled in August.   But now you need something on the sept reconciliation to offset the reversals on the sept bank statement.

    You should now be able to VOID the 2nd set of checks with a 9/1 void date.  The system will alert you that the check has already been reconciled, but you should be able to continue on past this message and void it anyway.   The system will create a 'negative check' for this amount in Bank Rec with the same check number to alert you of the issue (because you can't both CASH a check and VOID a check), so you can use that negative check to offset your Sept bank statement.  

    --If these were Payables checks, then the negative checks should show up on your bank reconciliation automatically.  

    --If these were cash receipts from Receivables, then you may need to go to Transactions | Financial | Deposit entry and select the negative cash receipt and post it as a negative deposit.  Then the 'negative deposit' will now show up on the Bank Reconciliation and you can use this as your offset for the credits on the bank statement.  

    If you need more help, please open a support case for further assistance.  (per your support plan)

    Hope that helps,

    Cheryl Waswick

    Microsoft Dynamics GP Support

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 461 Super User 2026 Season 1

#2
Subra Profile Picture

Subra 445

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 440 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans