Excise Tax e-File: File Naming Convention

Submission ID - The submission ID is a unique number used to track a return. It is made up of several components, as follows: WTN (the 10 digit Wisconsin Tax Number, remove the 3 digit prefix and the 2 digit suffix from the 15 digit WTN) + ccyy + jjj + Char(3), where ccyy is the 4 digit year, jjj is the 3 digit Julian date (January 31 is 031) plus 3 alpha numeric characters that must be unique for the day (for a total of 20).

Example: WTN = 1234567890
Date = April 26, 2010 = 116 Julian (Ordinal) Date
Unique for day 3 Characters = a05

SubmissionID = 12345678902010116a05

The submission ID is used in two places in naming files for submission.

The xml return is named using the three char prefix from the chart plus the submission ID with an .xml extension

Example: Form CT105 using the Submission ID in the above example would be named C0512345678902010116a05.xml

This return is in a folder named xml.

Attachments: Production submissions may contain attachments, but may be filed without them. If you have attachments, the return must be zipped with the folder containing 1 XML return file and any attachment files. There should be no subdirectories within the ZIP file.

The xml folder containing the xml return and if present the attachments are zipped into a zip archive folder named C0512345678902010116a05.zip

This zip file is what is transferred to the sFTP server.

WARNING: Improperly named or constructed files will be ignored/quarantined by our system.

Excise Tax e-File File Naming Convention

#FormFile Name PrefixName/Description
1Form AB-154A54Common Carrier Alcohol Beverage Tax Return
2Form AB-605A05Refund Claim for Beverage Tax
3Form BT-100B00Wisconsin Brewery Fermented Malt Beverage Tax Return
4Form BT-104B04Wisconsin Fermented Malt Beverage Tax Return
5Form BT-612B12Refund Claim for Fermented Malt Beverages Sold to the Armed Forces of the United States
6Form CT-001C01Native American Tribes Claim for Wisconsin Cigarette Tax Refund
7Form CT-100C00Wisconsin Distributor's Cigarette Tax Return
8Form CT-105C05Wisconsin Distributor's Cigarette Tax Return Out-Of-State Permittees
9Form CT-111C11Cigarette Warehouse Report
10Form CT-114C14Quarterly Report of Wisconsin Tax-Paid Cigarettes Purchased
11Form CT-121SC21Wisconsin Combined Cigarette Use Tax and Sales Tax Return
12Form TT-100T00Wisconsin Distributor's Tobacco Products Tax Return
13Form TT-114T14Quarterly Report of Wisconsin Tax-Paid Tobacco Products Purchased
14Form TT-104ST04Wisconsin Tobacco Products Use Tax and Sales and Use Tax Return
15Form TT-001T01Native American Tribe's Claim for Wisconsin Tobacco Products Tax Refund

November 17, 2011