Import General ledger accounts

Parent Previous Next

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 the Setup → Export menu.

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, if not already displayed.

3.Select one of the following file types in which the data to import, is saved on your system:

a)TurboCASH Exchange File (*.TXF)

b)XML Database File (*.XML)

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

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) 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) 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 "Data file import completed!" will be displayed. Click on the OK button.  

10.Go to the Reports ribbon and select Reports → Ledger  → Listing menu to check that the ledger accounts are correct.

11.If you need to edit the ledger accounts, go to the Action ribbon and select Accounts.

The values of the data in the Import Check 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).

Created with the Personal Edition of HelpNDoc: Easy to use tool to create HTML Help files and Help web sites