Closing the Bank Reconciliation

To complete a bank reconciliation:

1. Click Save to save the reconciliation. If the reconciliation does not balance Exo Business opens the Check Reconciliation window to alert you that the reconciliation is not finished.

2. You can also click Cancel to return to the search/summary window without saving the reconciliation.

Note: Any Cashbook entries and AP Processing transactions that were created during the reconciliation cannot be undone by clicking Cancel.

Exo Business does updates when you save a bank reconciliation:

• Creates a new BANK_REC_LOG record

• SEQNO New seq no generated

• ACCNO The GL account number of the reconciliation

• SUBACCNO The GL sub-account number of the reconciliation

• RECONCILENO The reconciliation number entered

• TRANSDATE The reconciliation date that was entered in Select unreconciled GL transactions up to and including.

• STMNT_OPENBAL From the window

• STMNT_CLOSEBAL From the window

• GL_BAL The GL balance displayed on window –  sum(amount) all Gltrans where transdate greater than or equal to the reconciliation date (bank_rec_log.transdate) for this account.

• DEPOSITS Unreconciled debit GL Transactions. Su  of debits on LHS

• PAYMENTS Unreconciled credit GL Transactions. Sum of credit on LHS

• GLTRANS_SEQNO Set to  the last GLTrans that makes up the GL balance on the window. This is last seqno of Gltrans where gltrans.transdate greater than or equal to rec date in the window for this GL account

• RECTYPE Manual

• STMNT_DATE New field. Set to the Date of Closing Bank Statement, also displayed in the window.

• LOCKED Per window. Yes/no

• GL_TRANS (updates to reconciled transactions)

• RECONCILE_SEQNO Updated with the seqno of the new bank_rec_log

• RECONCILE_NO From the window

• RECONCILED Set to 1 (meaning it’s reconciled)