Premium Pro Help

The Import function allows you to import your assessments from a file directly into the Input schedules.  By using this feature, you eliminate the need to make numerous manual entries.   

Only a properly configured ASCII file may be imported into the GTS module of Enterprise.  For more information on the ASCII file layout, please see Appendix A.

1. Open the GTS module for the company you wish to import information into.
2. Go to the File menu and select Import.
3. Select ASCII.
4. Click Browse, and locate the import file you wish to import from. Click Open.
5. Select the jurisdictions you wish to import.
6. Click Import.

The ASCII file layout is as follows:

The ASCII File Format specification described below will allow you to import your GFA assessment and credit information into the GFA Tracking System. Each line of the ASCII file represents one assessment. Each amount in the ASCII is separated by a tab. Each field can be any length. Fields with no amounts should contain zero (0). Negative numbers should have a minus sign (-) immediately preceding the number (-10000). The format for each line is as follows:

Col. 1:                     Line of Business (PC/LIFE/AH/ANN)

Col. 2:                     State Abbreviation

Col. 3:                     Assessment Date

Col. 4:                     Date Paid

Col. 5:                     Description

Col 6:                      Check Box for Class A Assessments (-1 = include, 0 = exclude)

Col 7:                      Class A Assessment Amount

Col 8:                      Check Box for Class B Assessments (-1 = include, 0 = exclude)

Col 9:                      Class B Assessment Amount

Col 10:                    Check Box for Class C Assessments (-1 = include, 0 = exclude)

Col 11:                    Class C Assessment Amount 

 

A Sample line looks like the following:

AH        CT         01/01/2001           01/15/2001           0            1000      -1           2000      -1           3000

The above line will enter the assessment in the AH tab of the GTS and will transfer $1000 into Class A, $2000 into Class B, $3000 into Class C. The columns for Class B and C will be checked to indicate that you may receive credit for the assessment amount.