Some implementation guidelines:
1) Use Accounting->Setup, Global tab to enable Bank Reconciliation Import and define Debit and Credit Adjustment Types
2) Use System->Setup->Import/Export to setup the import utility
3) Start a new Bank Reconciliation period and click on the Import button and select the import file
4) The importBankrecCleared will attempt to clear bank transactions. For deposits, will use bankrecimport_reference to match with cashrcpt_docnumber and clear the amount bankrecitem_debit_amount. For payments, will use bankrecimport_reference to match with checkhead_number and clear the amount bankrecitem_credit_amount. For both of the clearing transactions, bankrecimport_effdate is the date of the transaction. Columns bankrecimport_descrip and bankrecimport_comment are not used. Column bankrecimport is not used, but could be used to import currency exchange rates. If a matching deposit/payment document is not found then a bank reconciliation adjustment is created based on configuration.