Electronic Reporting
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).
| 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. | ||