The data of the bank statement saved in
the Lotus spreadsheet file format is saved in 13 columns (columns A to
Column A - Transaction ID
Column B - Line Type ID
Column C - Source ID
Column D - Bank ID
Column E - Transaction Type ID
Column F - Account Code - This is the account number of the
selected or downloaded bank account.
Column G - Transaction Date
Column H - Posted Date
Column I - Amount - This is the transaction amount from the
Column J - Memo - This is the memo or description of the
transaction as displayed on the bank statement.
Column K - Reference
Column L - Reconciled - This column indicates whether a
transaction is reconciled or not. False indicates that the transaction is not
reconciled and True indicates a Reconciled transaction.
Column M - Description
If the correct dates are not displayed for the bank statement
transactions, you need to select the correct dates when you save the bank statement transactions as a file. It is important to select the correct dates to include
transactions (the dates must correspond with those dates for which you need to
do the bank reconciliation).