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 requires 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 NAME 40A whl/sol you are shipping to or receiving from
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)
FILLER1 18A  -
*GALLONS 7 gallons including two decimal places WITHOUT decimal point (150.75 gals would be 15075) NOTE: SOLICITORS SHOULD ITEMIZE EACH LINE/PRODUCT WITH TOTAL GALLONS. WHOLESALERS NEED ONLY TO PROVIDE TOTAL GALLONS PER INVOICE
FILLER2  31A -
LITERS 8A -
*LICENSE NUM 8 license number of the whl/sol you are reporting
FILLER3 4A -
*TAXSTAT 1A 1 (taxed), 2 (untaxed)
*ZIPCODE 10A zip code +4 of the whl/sol you are reporting
Note: *Denotes required fields for Missouri. Other states may use these fields to capture additional data. Therefore, all field(s) must remain within the file for standardization purposes.