Dynamics Community Forum Thread Details

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

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:

Microsoft Dynamics GP

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

Quick Links

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