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

To Import Accounts Data into TurboCASH:

1.Click on the Tools → Import menu. 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:

8.If you click on the OK button, the Import Check screen, listing the debtor (customer) accounts, is displayed:

9.If you click on the OK button, the Import Check screen, listing the creditor (supplier) accounts, is displayed:

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-sccounts, 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