Minimum Version Required: 24.01
Pre-Conditions
The State Tax Reports Dashboard Role is required to view the State Tax Reports dashboard
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
Steps
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 | 40A | whl/sol you are shipping to or receiving from |
ADDR1 | 40A | 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 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 |
FILLER2 | 31A | - |
LITERS | 8A | - |
*LICENSE NUM | 8 | (license number of the whol/sol you are reporting) |
FILLER3 | 4A | - |
*TASXSTAT | 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.