I have posted a cash batch and would like to reverse the whole batch back to what the account looked like before the cash batch was created. Is there a way to reverse the whole batch?

Hello Karre,

Was the cash batch entered through Receivables or BankRec?

Assuming it was entered in Receivables, enter the whole batch over again, this time using negative amounts and a slightly different check number for each transaction. Then apply the negative amounts against the zero balance invoice(s), bringing the balance back up to the original amount. Post, and you are back at the beginning.

This is also how you record an NSF check.

Steve

yes, this is in receivables, although how do I apply a negative amount to an invoice which no longer shows up in the outstanding receivables because it is now zero.

Hi Karre,

If the invoice has not yet been moved to History, you can get at them from the Cash batch entry by enabling the 'Show All' checkbox. This will show not only the outstanding invoices in the grid but also those that have been fully applied.

If you are using Receivables 9.2A, this process can be sped up by using the Recover Batches feature within Batch Status Inquiry. You don't have to manually enter the entire batch again. Recover the Cash Batch to create all the cash entries, then just change the details to be negative values instead of positive.

If the invoice has been moved to History, then this process is no longer viable as cash entry cannot apply against historical transactions.

Thank you

I also need to reverse Cash batch in Adagio Receivables.
My batch was retrieved in GL as Error Batch because i posted wrong date 1998. Ive left it un-posted.
After I've reverse in receivables Do i still post it all in GL? even the error batch?

Assuming you haven't run Period End or Year End in Receivables since you posted the cash batch, it's pretty straightforward to reverse the Cash batch.

Depending on how many checks are in the batch, you could either recover the posted cash batch (if you are using AR 9.2A) or just re-enter the checks as a new cash batch, using the same wrong date and in the negative, and then applying them to the same invoices you applied the original cash batch - again in the negative. Posting this batch will bring you back to square one, and then you can enter the checks a third time, with the right date.

When you re-enter the checks, use a slightly different check number, for example 12345A instead of 12345.

When you retrieve these into the Ledger, the reversed cash batch with the wrong date will offset the original cash batch with the wrong date, and you can safely delete them.

Make sure to make a backup before doing this; there is a moderate chance that things could get really screwed up if you are not careful.

Steve