• TurboCASH UK Website • Download TurboCASH FREE • Buy TurboCASH
taken from the Accounting Made Easy e-book








ONLINE BANKING
SAVE BANK STATEMENT FILE AS
  
This option allows you to save any imported or downloaded bank statement in any directory or folder on your system in the XML Data packet or a Lotus Spreadsheet file format.

To Save a Bank Statement As a File:
Open the Set of Books in which your bank account is created for which you wish to save a valid imported bank statement or downloaded bank statement.
Click on the Tools - Plug-ins - Bank Online menu option or press the <Alt> and <T> and <B> keys on your keyboard. The Online Banking utility will be launched.
Click on the File tab and select the Save As option. The Save Transaction to File As screen will be displayed.

Title bar. Close button - Click to close or exit this screen. The full route (drive, folder, etc.) and name of the file as specified on the Save Bank transaction Data File screen. Enter or select the date from which you need to include transactions. Enter or select the date until which you need to include transactions. Enter a memo description to filter the information to be included. Select to show the deposit (receipts into the bank account) transactions. Select to show the withdrawal (payments out of the bank account) transactions. Select to use the memo description to filter the information to be included in this report. Click to save the Bank Statement. Click to cancel to close or exit this screen.
Click on the down arrow to select a valid directory or folder on your system to save the file in and to specify the file name. The Save Bank transaction Data File screen will be displayed.

Title bar. Click to display Windows help on this screen. Close button - click to exit this screen. The name of the selected folder. Click on the down arrow to select another folder on your system. One level up - click to select another file in a folder. Create new folder. Back - click to go to the previous folder. View menu - click to select the options in which the folders and files in the selected directory should be displayed. All the folders and/or files on your system or selected directory will be displayed in this area. Enter a file name. Click to transfer the file to the Save To field. Click to close or exit this screen. Select the file type if the correct type is not displayed. Click to go directly to the location on your system.
Select a valid directory or folder on your system to save the file in and enter the file name. Select the Type of File as XML Data packet (*.XML) or a Lotus 123 (*.Wk1).
Click on the button. The Save Transaction to File As screen will be displayed.
Select the Filtering options as to specify what to include in the export or saved file. You may enter or select the dates from and to and specify whether to show deposits, withdrawals (payments / cheques) or to use the bank memo descriptions in the statement.
Click on the button. The bank statement will be exported to the selected file format.

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

GNU Free Documentation License 1.2 SourceForge
Content released by Digidan under the GNU Free Documentation License 1.2.