IMPORTING SECTION 78(2A) INTEREST TRANSACTIONS

According to the new credit act, Section 78(2A) Interest transactions need to be captured on a monthly basis. Many firms have large amounts of investments and LegalSuite has an Import function which can be used to import these transactions into the program. Files can be imported from excel, comma delimited files or xml. It is very important to remember that the files can be imported ONLY IF they are in the correct Format.

FORMAT FOR INTEREST TRANSACTIONS

When importing data using the excel format, the first line is the heading line and must contain the names of each field. The first field must always have the word “BatTran” in it. BatTran Records cannot be updated, they can only be added.

Below is an example of what the Interest Import must look like in

EXCEL

COMMA DELIMITED FILE

FIELDS

BatTran
BookType	I  (For Interest)
Matter1	The Matter to be debited Use FileRef, @OldCode, %AlternateRef or #RecordId
Description1	Description e.g. Interest
Voucher	Voucher Number
Option1	1  ( Must always be 1)
Amount	Insert amount without the Rand sign
InvestmentAccount	Description of the Section 78(2A) as it appears in the business ledger in LegalSuite

LegalSuite cannot separate Interest Transactions for a matter that has separate Investments with the same investment bank.

HOW TO IMPORT THE INVESTMENT TRANSACTIONS

Go to the “File” menu and select “Import/export”.

Select Import Data

The Following Screen will appear:

Filename – Enter the name of the file to wish to import.  Valid files are files ending with the following extensions:

.xml      -           xml files

.xls       -           excel files

.csv      -           comma delimited files

If you have any other Import/Export queries you can click on the  icon on the Import screen.

--END--