Importing Bank Transactions into TurboCASH
Spreadsheet
The bankimport spreadsheet is a set of transforms of CSV files to make them compatible with TurboCASH Imports
Open Office
bankimport spreadsheet is tested with Open Office .
bank import into TurboCASH
bank import (1:30)ondemand_video
Video to show how to use the bank import spreadsheet to transform your data.
bank import in detail (9:10)ondemand_video
Video in detail to show how to use the bank import spreadsheet to transform your bank data. This assumes you are an absolute beginner to spreadsheets, TurboCASH and CSV files
TurboCASH Bank Import
filter_1 Download your bank Statement from your bank and save it to your PC.
filter_2 Open the Bankimport Spreadsheet in Open Office and choose your bank.
filter_3 Open your download in a second spreadsheet, use Text delimiter ''
Copy the transactions from your download into the correct import sheet.
Dates must be in the precise format as shown
You can preallocate the accounts (Column D of the import) but they must be in exactly the format shown
filter_4 Extend the transformation in the second spreadsheet import tab by copying the formula over the required number of rows
filter_5 Save your import tab using the csv option {Tab}. Use the option to Edit filter and make sure your export is {Tab} delimited
