Although this will work for viewing the historical transactions, you can also see the past reconciliations from the Bank Account Card by viewing the Bank Statements, you can't reverse a transaction that has already been closed. If you view the detail of the record in the Bank Account Ledger Entries, look for the field "Closed by Statement No.". This will tell you which Bank Statement it's on.
If BC/NAV were to allow you to reverse reconciled (Closed) transactions you would have a Bank Statement that now doesn't reconcile to the transactions it's applied against.
If there is a transaction that is reconciled but shouldn't be, usually because the incorrect transaction for the same amount was matched, you'll have to just do a journal and reconcile those transactions against each other so there is zero effect on the Bank Statement but the transactions are now all marked as closed.
E.g.
two transactions for $40 are recorded in the Bank Account with Posting Date 04/10/2019. One was an cheque and the other was a bank charge.
When the Bank Reconciliation was performed on 31/10/2019 the cheque transaction on the Bank Account Entries was matched to the Bank Statement Entry for the cheque that was issue. This reconciliation was subsequently posted. Now on 2 November you discover the cheque is damaged and needs to be replaced. This means that the cheque needs to be reversed but can't be because the Bank Account Ledger Entry is closed.
Complete the following.
- Post a normal entry to reverse the original Cheque entry, (Dr Bank and Cr the relevant Vendor or G/L)
- Post a new entry for the re-issued cheque
- On the next Bank Reconciliation capture a Bank Statement Entry with a Statement Amount of zero
- Match the Bank Charge entry to this line to get it closed
- Match the Reversal entry posted above to the same Bank Statement Line.
- This has the effect of leaving an Applied Amount of Zero on the Bank Statement Line. This is a valid option
- I have been known to suggest to the users that they generate a Bank Reconciliation just for this purpose, using the Ending Date of the Statement that had the incorrect allocation, just to ensure that the dates of outstanding transactions is correct.
- Post the Bank Reconciliation and you will have the one cheque entry remaining as an outstanding item and the necessary transactions closed off.
