TurboCASH Accounting Software TurboCASH United Kingdom
Select your Country
OPEN SOURCE ACCOUNTING SOFTWARE
HomeFeatures & ScreenshotsShop onlineCompareFAQForumRegisterContact
Community
Free Downloads
Shop
Other Titles

Using TurboCASH

 







ONLINE BANKING
OPEN A BANK STATEMENT LOTUS SPREADSHEET FILE
  
When the Bank Statement Transaction records or data of a valid imported bank statement or downloaded bank statement file is saved in the Lotus 123 file format, you may access the file by locating it in the specific location and file name where you have saved this file on your system. You may use this Lotus 123 file to analyse and sort this data for your specific requirements.

To access the Lotus 123 file:
Locate the file on your system. You may use the Windows Explorer .
Double-click on the icon with the name you have saved the specific data for the saved bank statement file. The selected file will be displayed.

Title bar - program name. Title bar - name of the saved file. Restore button - click to restore the program to the size in which the progam was displayed. Close button - click to close or exit the program. Minimise button - click to minimise the program. Menu bar - click to access the menu options in the program. Minimise button - click to minimise the active spreadsheet. Restore button - click to restore the spreadsheet to the size in which the progam was displayed. Close button - click to close or exit the active spreadsheet. Program name and icon. New - click to open a new spreadsheet. Open - click to open an existing spreadsheet. Save - click to save the data or your changes in this speadsheet. Print - click to print this spreadsheet or the selected cells. Cut - removes the contents of the selected cells and places it on the Clipboard. Copy - places the contents of the selected cells on the Clipboard. Paste - places the contents from the Clipboard into the selected cells of the active spreadsheet. Undo - click to undo a last or previous action. Change sheet properties. Select range or graphic object. Copy a range's styles to other ranges. Size columns to fit. Sum values above or to the left. Select several objects Create a chart. Create a map. Create a query table. Create a new version of the selected range. Create a script button. Create a text block. Draw an ellipse or circle. Draw a forward-pointing arrow. Name Box - diplays the column and row of cells Formula bar - displays the contents or a formula for seelcted cells. Columns coords=0,119,781,136 Row 1 - Headings for the exported data fields. Rows 2 to the end - the data for each transaction. Universal SmartIcons set Change range properties. Range SmartIcons set. Print Preview Sheet number or name. Previous spreadsheet or next spreadsheet. Create a new spreadsheet. Transaction ID - a unique number for each transaction. Line Type ID - Source ID Bank ID Transaction Date Posted Date Transaction amount. Memo - Bank Memo Rows Transaction Type ID Bank Account Number Reference False is not reconciled and true means the transaction is selected as reconsiled. Description of the item on the bank statement. Scroll bar.

 

The data of the bank statement saved in the Lotus spreadsheet file format is saved in 13 columns (columns A to M)

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 Bank Statement.

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).