How to Add the State Tax Reports Dashboard Role

1. Using Universal Search, navigate to the Dashboard table

2. Filter the Dashboard name you want to modify then click Go

3. Click Subtable the click Dashboard Roles

4. Click the expand button then click Add Dashboard Roles

5. Select the roles of the people who will need to see and use the dashboard then click Save Changes

Missouri Division of Alcohol and Tobacco Control

The Division of Alcohol and Tobacco Control has implemented an electronic

excise tax reporting system that allows Manufacturers, Solicitors, and

Wholesalers to submit their monthly reports electronically. ATC encourages

licensees to submit reports electronically. Please see "how to get started"

for additional details on electronic reporting.

How to get started

The electronic report should be in the form of a text file. The following

is a file layout or breakdown of the electronic report or file(s).

File Description for Alcohol Invoice

Field Name Type Description

WHL/SOL NAME40A

ADDR1 40A (dba doing business as)

ADDR2 40A (building number / street )

ADDR3 70A (city / state / zip)

*SHIP DATE 10A (date shipped (mmddyyyy) )

*INVOICE NUM 10A (invoice number)

ORDER NUM 8A (order number)

QUANTITY 29A (case quantity / btls size)

DESCR 30A (product description)

*GROUPTYPE 30A (compliance group (liquor, malt, wine) see list below)

ALCOHOL PERC 3 (alcohol percentage no decimals (5% would be 050))

FILLER118A

*GALLONS 7 (gallons including two decimal places WItdOUT decimal point

(150.75 gals would be 15075) NOTE: SOLICITORS SHOULD 7 ITEMIZE

EACH LINE/PRODUCT WItd TOTAL GALLONS. WHOLESALERS NEED ONLY

TO PROVIDE TOTAL GALLONS PER INVOICE)

FILLER231A

LITERS8A

*LICENSE NUM 8 (license number of tde whol/sol you are reporting)

FILLER34A

*TASXSTAT 1A (1 taxed, 2 untaxed)

*ZIPCODE 10A (zip code + 4 of tde whl/sol you are reporting)