FormerMember

Reverse a Bank Account Reconciliation

Posted By FormerMember

is there a way to reverse a posted bank reconciliation?  I am new to Sage 500 and have made an error that covers 2 months of bank reconciliations. I failed to key in the Bank Ending Balance for these 2 months and have just caught the error. 

  • This can only be done via SQL -

    1. Set the BankStmtKey and DateCleared to NULL, Status=1 for all records in tcmCashTran that's associated with the bank statement (recon) to delete

    2. Delete the tcmBankStatement record for the recon to delete

    Any adjustments posted as part of the recon can't be deleted.   They will have to reversed in the normal manner.

    Hope this helps.