I accidently imported the wrong period of deposits into bank rec and now I'm wondering what is the easiest way to clear these deposits. I imported it a couple of days ago so resetting from a back-up is not an option.

"Imported" or "Retrieved"? From the bank or from Adagio? It's not clear where the problem is.

How can deposits be for the wrong period? BankRec doesn't worry about periods. Only Ledger is period based.

Sorry, we'll need a little more information as to what the problem is you are facing before we can help.

I exported the wrong period from Ledger and only noticed it when I had already imported into Bank Rec and posted it.

Now I'm really confused!

Normally, transactions flow from BankRec to Ledger, so I'm not sure what process you are following. When BankRec is installed, normally it takes over all entries to the Bank accounts, and you should not be doing any entries directly in Ledger to those accounts (like the AR and AP control accounts should not be touched in Ledger).

Since it doesn't sound like you have BankRec integrated with the general ledger in the regular way, I'm not sure what assistance we'll be able to provide through the Forum.

I exported transactions from Ledger, and select the correct template that was set up for us. After clicking export, I am able to choose the correct account and fiscal period for which I want to export. This is where I chose the wrong one.

Once it has been exported, it's then opened in an excel file where a few changes are made such as numbering each line. After that is saved, I go to bank rec, go to file, import, then deposits and click detail only. After the correct template and excel file are chosen, I import it. Here it goes into a batch and that batch I post so that it then shows up in my bank rec.

I have May deposits in bank rec but I don't need them. I was just wondering if there was an easy way to clear the deposits because if I just right-click and hit clear it messes with my numbers. I was just wondering if there was an off-setting entry that I could make to clear it up.

Hope this is clearer. This is what I was taught to do and how to do it.

This is a unique setup because of the requirements and the imports from their POS system which is working well. His question is whether there is a way to reverse a posted batch in BankRec. We can clear it with an offsetting entry in BankRec and then delete the batch before it is posted in Ledger. Obviously this is not a pretty way of dealing with a huge batch of transactions.

"Clearing" a transaction in BankRec generates no GL activity, so I'm not clear how it would mess your numbers.

If you posted a batch in error in BankRec, then enter and post a batch that reverses the transactions that were posted.

Since you exported transactions from Ledger and they are presumably sitting in Excel or a CSV file, a quick way of creating the reversing batch would be to edit that file and flip the sign of all the amounts.