Municipal for Premium ASCII

Premium Pro provides you with the capability of importing municipal premiums, taxes, and/or fees depending on the requirements of the state’s municipal return. For Life companies, the states you can import are Georgia and Louisiana. The Georgia import will source in the number of business locations for each municipality instead of a premium amount. For P&C companies, you can import Florida, Louisiana, and South Carolina.

From the File menu, select Import, and then choose Municipal.  The Municipal Import dialog window will appear.  Select the appropriate municipal import you wish to perform.  Click on the Browse button to select the file to import.  Click Open after selecting the file.  Choose the applicable Import option (By Municipal Code or By Municipal Name).  Click the Import button to start the import process.  

The ASCII File Import Method

(By Municipal Code or By Municipal Name)

Two different layouts can be followed when creating an ASCII file. The first layout is By Municipal Name. Each line of the ASCII file lists the municipality name, followed by other data to be imported. To import a file created with the municipal name layout, select the correct import type from the import dialog box. If you select By Municipal Code while importing a file in a By Municipal Name format, you will receive an error message. No information will be imported.

The second layout is By Municipal Code. Each line of the ASCII file lists the municipal code of each city, followed by other data to be imported. If you select By Municipal Name from the dropdown list while importing a file in a By Municipal Code format, you will receive an error message. No information will be imported.

Importing an .txt file

(From Municipal)

The state returns for Louisiana (Form 1076) and Georgia (GID-17A) both have pages listing municipalities and taxes or fees. If you have already completed these forms in the Municipal module, you may export this data to an ASCII file. While in the Municipal module, you can select File > Export > Export Municipal data for [state name]. The Municipal software will create a .txt file using the By Municipal Code layout. After you have exported the data from the Municipal module, import the .txt file into the corresponding Life or PC module. Select the import type of By Municipal Code from the import dialog box.

Importing an .imp file

(From Allocator)

The Premium Pro Allocator software program allocates insurance policies to the correct municipality. After allocation, Allocator creates an ASCII file with an extension of .imp. Like the ASCII files created by the Municipal module, the .imp file is already in a file format that can be imported into Premium Tax. Allocator allows you to create an ASCII file in either the By Municipal Code or the By Municipal Name layout.  

Importing Directly from the Municipal Tax Module

(From Municipal Tax Module)

If you have already completed form 1076 for Louisiana or GID 17A for Georgia, you may go to File > Import > Import [State return] to import the data from the Municipal module directly into the Premium Tax module.

Municipal ASCII File Layout for Premium Pro Life and PC

The Municipal Import uses the municipal code or name assigned to each municipality as it appears on the current year’s annual premium tax return.  The name must be in all uppercase letters and must be spelled exactly as it appears on the return.

Each line contains all the information of one municipality and must end with a carriage return line feed. Negative numbers are designated by placing a minus sign immediately preceding the number.  No null characters are allowed. All items in a list must be assigned a value.  If premiums have not been written in a municipality, a zero must be assigned to the item.

It is important to note the specific layout for each state. The format of the ASCII file for each import type is as follows:

Florida

You must create separate ASCII files for the two types of import: Florida Firefighters’ Pension Trust Fund, and Florida Police Officers’ Retirement Trust Fund. You must select the import file for Florida Fire or Florida Police. The ASCII file layout is the same for both types of Florida imports.  

By Municipal Code

Starting Col

Description

Length

Data Type

Valid Values

1

State Abbreviation ("FL")

2

Alpha

"FL" or "fl"

3

Municipal Code

5

Numeric

Valid Muni Code

8

Taxable Premiums

W. Space Delimited

Numeric

Valid Number

By Municipal Name

Starting Col

Description

Length

Data Type

Valid Values

1

State Abbreviation ("FL")

2

Alpha

"FL" or "fl"

3

Municipal Name 

30

Alpha

Valid Muni Name

35

Taxable Premiums

W. Space Delimited

Numeric

Valid Number

Georgia

By Municipal Code

Starting Col

Description

Length

Data Type

Valid Values

1

State Abbreviation ("GA")

2

Alpha

"GA" or "ga"

3

Municipal Code

5

Numeric

Valid Muni Code

8

Business Locations 

W. Space Delimited

Numeric

Valid Number

By Municipal Name

Starting Col

Description

Length

Data Type

Valid Values

1

State Abbreviation ("GA")

2

Alpha

"GA" or "ga"

3

Municipal Name

30

Alpha

Valid Muni Name

35

Business Locations 

W. Space Delimited

Numeric

Valid Number

Louisiana

By Municipal Code

Starting Col

Description

Length

Data Type

Valid Values

1

State Abbreviation ("LA")

2

Alpha

"LA" or "la"

3

Muni Code

5

Numeric

Valid Muni Code

8

Direct Premiums

W. Space Delimited

Numeric

Valid Number

By Municipal Name

Starting Col

Description

Length

Data Type

Valid Values

1

State Abbreviation ("LA")

2

Alpha

"LA" or "la"

3

Municipal Name

30

Alpha

Valid Muni Name

35

Direct Premiums

W. Space Delimited

Numeric

Valid Number

South Carolina

By Municipal Code

Starting Col

Description

Length

Data Type

Valid Values

1

State Abbreviation ("SC")

2

Alpha

"SC" or "sc"

3

Muni Code

5

Numeric

Valid Muni Code

8

Taxable Premiums

W.Space Delimited

Numeric

Valid Number

By Municipal Name

Starting Col

Description

Length

Data Type

Valid Values

1

State Abbreviation ("SC")

2

Alpha

"SC" or "sc"

4

Muni Name

30

Alpha

Valid Muni Name

35

Taxable Premiums

W. Space Delimited

Numeric

Valid Number


The ASCII File Import Method

(By Municipal Code or By Municipal Name)

Two different layouts can be followed when creating an ASCII file. The first layout is By Municipal Name. Each line of the ASCII file lists the municipality name, followed by other data to be imported. To import a file created with the municipal name layout, select the correct import type from the import dialog box. If you select By Municipal Code while importing a file in a By Municipal Name format, you will receive an error message. No information will be imported.

The second layout is By Municipal Code. Each line of the ASCII file lists the municipal code of each city, followed by other data to be imported. If you select By Municipal Name from the dropdown list while importing a file in a By Municipal Code format, you will receive an error message. No information will be imported.

Importing an .txt file

(From Municipal)

The state returns for Louisiana (Form 1076) and Georgia (GID-17A) both have pages listing municipalities and taxes or fees. If you have already completed these forms in the Municipal module, you may export this data to an ASCII file. While in the Municipal module, you can select File > Export > Export Municipal data for [state name]. The Municipal software will create a .txt file using the By Municipal Code layout. After you have exported the data from the Municipal module, import the .txt file into the corresponding Life or PC module. Select the import type of By Municipal Code from the import dialog box.

Importing an .imp file

(From Allocator)

The Premium Pro Allocator software program allocates insurance policies to the correct municipality. After allocation, Allocator creates an ASCII file with an extension of .imp. Like the ASCII files created by the Municipal module, the .imp file is already in a file format that can be imported into Premium Tax. Allocator allows you to create an ASCII file in either the By Municipal Code or the By Municipal Name layout.  

Importing Directly from the Municipal Tax Module

(From Municipal Tax Module)

If you have already completed form 1076 for Louisiana or GID 17A for Georgia, you may go to File > Import > Import [State return] to import the data from the Municipal module directly into the Premium Tax module.

Municipal ASCII File Layout for Premium Pro Life and PC

The Municipal Import uses the municipal code or name assigned to each municipality as it appears on the current year’s annual premium tax return.  The name must be in all uppercase letters and must be spelled exactly as it appears on the return.

Each line contains all the information of one municipality and must end with a carriage return line feed. Negative numbers are designated by placing a minus sign immediately preceding the number.  No null characters are allowed. All items in a list must be assigned a value.  If premiums have not been written in a municipality, a zero must be assigned to the item.

It is important to note the specific layout for each state. The format of the ASCII file for each import type is as follows:

Florida

You must create separate ASCII files for the two types of import: Florida Firefighters’ Pension Trust Fund, and Florida Police Officers’ Retirement Trust Fund. You must select the import file for Florida Fire or Florida Police. The ASCII file layout is the same for both types of Florida imports.  

By Municipal Code

Starting Col

Description

Length

Data Type

Valid Values

1

State Abbreviation ("FL")

2

Alpha

"FL" or "fl"

3

Municipal Code

5

Numeric

Valid Muni Code

8

Taxable Premiums

W. Space Delimited

Numeric

Valid Number

By Municipal Name

Starting Col

Description

Length

Data Type

Valid Values

1

State Abbreviation ("FL")

2

Alpha

"FL" or "fl"

3

Municipal Name 

30

Alpha

Valid Muni Name

35

Taxable Premiums

W. Space Delimited

Numeric

Valid Number

Georgia

By Municipal Code

Starting Col

Description

Length

Data Type

Valid Values

1

State Abbreviation ("GA")

2

Alpha

"GA" or "ga"

3

Municipal Code

5

Numeric

Valid Muni Code

8

Business Locations 

W. Space Delimited

Numeric

Valid Number

By Municipal Name

Starting Col

Description

Length

Data Type

Valid Values

1

State Abbreviation ("GA")

2

Alpha

"GA" or "ga"

3

Municipal Name

30

Alpha

Valid Muni Name

35

Business Locations 

W. Space Delimited

Numeric

Valid Number

Louisiana

By Municipal Code

Starting Col

Description

Length

Data Type

Valid Values

1

State Abbreviation ("LA")

2

Alpha

"LA" or "la"

3

Muni Code

5

Numeric

Valid Muni Code

8

Direct Premiums

W. Space Delimited

Numeric

Valid Number

By Municipal Name

Starting Col

Description

Length

Data Type

Valid Values

1

State Abbreviation ("LA")

2

Alpha

"LA" or "la"

3

Municipal Name

30

Alpha

Valid Muni Name

35

Direct Premiums

W. Space Delimited

Numeric

Valid Number

South Carolina

By Municipal Code

Starting Col

Description

Length

Data Type

Valid Values

1

State Abbreviation ("SC")

2

Alpha

"SC" or "sc"

3

Muni Code

5

Numeric

Valid Muni Code

8

Taxable Premiums

W.Space Delimited

Numeric

Valid Number

By Municipal Name

Starting Col

Description

Length

Data Type

Valid Values

1

State Abbreviation ("SC")

2

Alpha

"SC" or "sc"

4

Muni Name

30

Alpha

Valid Muni Name

35

Taxable Premiums

W. Space Delimited

Numeric

Valid Number


 

©1995-2015 TriTech Software Development Corp. ©2006-2015 TriTech Services Inc. All rights reserved. Premium Pro® is a registered trademark.