Table reconciliation

Table reconciliation hold the list of cleared receipts/payments with the bank or other institution. One or more cash accounts can be reconciled with the bank statement. The table will contain one record for each period/GL account combination.

Table Type: InnoDB

Field Type Default Description
id int (11) NOT NULL PRIMARY KEY - Auto increment field to hold unique ID
period int(11) 0 Accountig period
gl_account varchar(16) NULL General Ledger account
statement_balance float 0 Balance in the account after the period/gl_account has been reconciled. This amount will usually be zero after reconciliation but may not be zero if reconciliation is in process. This allows for partial reconciliations, saving the intermediate results.
cleared_items text '' Encoded list of items selected to be cleared in a given period/gl_account.