Bank rec problem

[jymm]

a couple of in house accountants ago we were not using the bank rec module at all even though we had bought it. Then a new person started and did a few mass clean ups. THREE YEARS LATER (today) they figure out that she missed a few (10) OLD checks that actually cleared but were not marked as such in bank rec.

Essentially they want to get the transactions off of the list but not change the bottom line (sounded a bit fishy to me since I am the DBA, but it is legit). I can see the transactions in CM20200, but when I try to say that one transaction was RECOND it changes the 'Difference' line when they run the rec (as does changing some of the amounts and dates - hey I am a programmer - I will try anything once as long as I can put it back).

Anyone got a slick way to get 10 or so records off of the bank rec list and not effect the 'bottom line'???

 

[stef315]

I think you could do a "dummy" bank rec. Or, when the next bank rec is done, you'll want to decrease the bank statement balance by the amount of those checks. Then you can clear them and reconcile. The next month, you should be able to enter the correct balance.

Alternatively, you do the the dummy bank rec. So, you did 8/31/04. You do another 8/31/04 (or 9/1/04) and put in the same balance as the first 8/31/04 bank rec minus the total of these transactions. Then you can mark just those transactions and the difference should be zero.

General Ledger should not be affected as you are not posting adjustments. The actual bank balance will not be affected because these checks were already entered and had already hit the checkbook.

 

[jymm]

kinda the same answer I gave them yesterday which was --- effect the start balance by the total amount that you know have already cleared and then clear the checks... should be simple but sometimes the old forest & trees thing comes into play

thanks for your thoughts and confirming what I told them.