Navigation:  Accounting > Bank/Check Reconciliation > Reconciliation Details

This page will describe some programming details that will help with understanding the reconciliation system.

 

NOTE: When starting reconciliation a check is made for any cleared transactions that are not dated. If any are found a warning is raised. Undated transactions will not appear in totals as totals are calculated throught the Statement Closing Date and undated transactions are undefined.

 

Bank Statement Beg. Bal = Bank Setup Beg. Balance (TWBanks.BankBegBalance)  +  All Deposits that have cleared the bank (register status = 'C')  - All Checks that have cleared the bank, through and including the Statement Closing Date

 

Bank Statement End Bal = Amount entered by user in field.

 

Out Of Balance = Bank Statement End Balance - Bank Statement Beg. Bal

 

Escrowed Total = Total of Escrows through Statement Closing Date.

 

 

 

Cleared Bank Deposits = Deposits for the current reconciliation that have been flagged as cleared through Statement Closing Date. (TranType='D', Status <> 'C' ,Cleared = True)

 

Cleared Bank Checks = Checks for the current reconciliation that have been flagged as cleared through Statement Closing Date. (TranType='C', Status <> 'C' Cleared = True)

 

Cleared Bank Balance = Cleared Bank Deposits - Cleared Bank Checks

 

 

 

Outstanding Deposits = Verified Deposits that have not cleared (TranType = 'D', Status ='P', Cleared = False)

 

Outstanding Checks = Verified Checks that have not cleared (TranType = 'C', Status ='P', Cleared = False)

 

Outstanding Balance =  Outstanding Deposits - Outstanding Checks