The PACT Act file must be saved and submitted as comma-separated values (CSV) file format.
- Do not include commas in the data. Please remove commas from names and addresses before converting to CSV format.
- Do not include slash or hyphen separators in date fields. (Example: MMDDYYYY)
- If entering a negative number, include a negative symbol before the number. (Example: -125.00)
- In number fields, the character maximum includes the hyphen or decimal point. (Example: ####.## is six characters)
| Column | Field Name | Character Length | Field Format | Upload Requirements | Description of Field Contents |
|---|---|---|---|---|---|
| A | Account Number | 11 | intentionally blank | R = Required | intentionally blank |
| B | Reporting Period | 8 | MMDDYYYY | R = Required | Use last day of reporting period |
| C | Invoice Number | Max 20 | intentionally blank | R = Required | |
| D | Date of Shipment | 8 | MMDDYYYY | R = Required | Must be month of reporting period |
| E | Shipped to Type | 1 | intentionally blank | R = Required | M = Manufacturer W = Wholesale D = Distributor C = Consumer |
| F | Shipped to Name | Max 70 | intentionally blank | R = Required | intentionally blank |
| G | Shipped to Address 1 | Max 40 | intentionally blank | R = Required | intentionally blank |
| H | Shipped to Address 2 | Max 40 | intentionally blank | R = Required | intentionally blank |
| I | Shipped to City | Max 20 | intentionally blank | R = Required | intentionally blank |
| J | Shipped to State | 2 | intentionally blank | R = Required | intentionally blank |
| K | Shipped to ZIP | Min 5, Max 10 | #####-#### | R = Required | intentionally blank |
| L | Shipped to Phone # | Max 13 | ###-###-#### | R = Required | intentionally blank |
| M | Delivery Sale | 1 | 1 or 0 | R = Required | Yes = 1, No = 0 |
| N | Del. Service Co. Name |
Max 70 | intentionally blank | C = Conditional | If Delivery Sale = 1 |
| O | Del. Service Address 1 | Max 40 | intentionally blank | C = Conditional | If Delivery Sale = 1 |
| P | Del. Service Address 2 | Max 40 | intentionally blank | C = Conditional | If Delivery Sale = 1 |
| Q | Del. Service City | Max 20 | intentionally blank | C = Conditional | If Delivery Sale = 1 |
| R | Del. Service State | Max 2 | intentionally blank | C = Conditional | If Delivery Sale = 1 |
| S | Del. Service ZIP | Min 5, Max 10 | ##### | C = Conditional | If Delivery Sale = 1 |
| T | Del. Service Phone # | Max 13 | ###-###-#### | C = Conditional | If Delivery Sale = 1 |
| U | Tobacco Type | 1 | C, R, or S | R = Required | C = Cigarettes R = Roll Your Own S = Smokeless |
| V | Brand Name | Max 40 | intentionally blank | R = Required | Enter Brand Name; -1 = Other Brand Name |
| W | Other Brand Name | Max 30 | intentionally blank | C = Conditional | If Brand Name = -1 |
| X | Cigarettes (Sticks) |
Max 15 | ##### | C = Conditional | intentionally blank |
| Y | RYO (Ounces) | Max 12 | ####.## | C = Conditional | intentionally blank |
| Z | Smokeless (Ounces) | Max 12 | ####.## | C = Conditional | intentionally blank |
| AA | Extended Sale Price | Max 12 | ####.## | C = Conditional | intentionally blank |
| AB | Vermont Tax Paid | 1 | 1 or 0 | R = Required | Vermont stamped or tax paid to Vermont: Yes = 1 No = 0 |