Regulatory Reporting Upload Templates
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
When you access the report in the ALCMS Customer Portal, you will have the option to enter invoices/shipments manually or upload a file containing all shipments. While a file upload is not required, you may wish to do so as an alternative to entering each invoice manually.
The report upload should be in the form of an Excel file. The following are the templates and file format requirements for both Monthly Reports and Wine Direct Shipper Annual Reports.
Use the following for Monthly Excise Reports:
| Field Name | Description |
|---|---|
| LCNR | whl/sol/manf you are shipping to or receiving from |
| SHPD | Ship Date |
| VLME | places |
| INVC | Invoice Number |
| TYPE | Liquor/ Wine/ Malt (Domestic)/Malt (Foreign) *Please Note* Malt categories need to be specifically formatted as the following in order to correctly load into the system: Malt (Domestic) and Malt (Foreign) |
Use the following for Annual Wine Direct Shipper Reports:
| Field Name | Description |
|---|---|
| LCNR | Alcohol Carrier License Number Please refer to the Active License Report to find the license number of the Alcohol Carrier that you use. |
| TRKD | Tracking Number |
| SHPD | Ship Date |
| FNSP | First Name - Ship To |
| LNSP | Last Name - Ship To |
| A1SP, A2SP, CYSP, STSP, ZPSP | Address, City, State, Zip Code - Ship To |
| VLME | gallons including two decimal places |
| INVC | Invoice Number |
| FNSD | First Name - Sold To |
| LNSD | Last Name - Sold To |
| A1SD, A2SD, CYSD, STSD, ZPSD | Address, City, State, Zip Code - Sold To |