Import General ledger accounts
This option will allow you to import data for Account records from a valid file format into an existing Set of Books. To be able to import the data for Account records, you need to have created a valid XML Database file, TXF TurboCASH Data Exchange file, Lotus Spreadsheet file on your system in Export on the Setup ribbon.
To Import Accounts into TurboCASH:
1.On the Setup ribbon, select Import. The "Import Data into TurboCASH" screen is displayed:
2.Select Accounts as the "Data type to import" option.
3.Select one of the following file types in which the data to import, is saved on your system:
a)Tab delimited (*.txt) (used in this example)
b)TurboCASH Exchange File (*.TXF)
c)XML Database File (*.XML)
d)Lotus Spreadsheet File (*.WK1)
4.Click on the button to locate the data file. The following screen is displayed:
5.Click on the button to locate the data file.
You may click on the View file button to open the file in the default program on your System which is associated with the selected file type. In this example the text file is opened in "Notepad":
6.Click on the button. The following screen is displayed:
7.Click on the Import button. The "Import Check" screen is displayed:
If you have clicked on the All button, the Import Check screens for debtor (customer / client) and creditor (supplier / vendor) accounts may be listed. You may edit these and Import the data for the accounts. If you click on the Cancel button of these "ImportCheck" screens, no data will be imported.
ImportCheck for debtor (customer / client) accounts:
ImportCheck for creditor (supplier / vendor) accounts:
8.You may use the record buttons to add, delete or change the accounts on the "ImportCheck" screen. You may then click on the All or OK buttons to import the accounts.
9.Once the import process is finished an information message will be displayed.
"Data file import completed!"
10.Click on the OK button.
The values of the data in the "ImportCheck" screen, listing the general ledger accounts, is as follows:
•AccountTypeID - Account type - 0=General ledger, 3=Bank accounts and 4=Tax accounts
•SDescription - Account description (Name)
•SAccountCode - Account number (Code)
•BIncomeExpense - 1=Income / Expenses, 2=General ledger (Tax and Bank accounts is by default a Balance sheet Account)
•BSubAccounts - 1=Sub-accounts, 0=No Sub-accounts
•SGroup1 - Account group 1 Description
•SGroup2 - Account group 2 Description
•DStartDate - Start Date - (only applicable to Account type 4 only (i.e. Tax accounts))
•DEndDate - End Date - (only applicable to Account type 4 only (i.e. Tax accounts))
•FRate - Tax Rate (Percentage) - (only applicable to Account type 4 only (i.e. Tax accounts))
•SReceipt - Receipts journal - (only applicable to Account type 3 only (i.e. Bank accounts))
•SPayment - Payments journal - (only applicable to Account type 3 only (i.e. Bank accounts))
•SCurrency - Currency (Not used).