Break Open Tickets Non-Profit's Instructions

Non-Profit’s Reporting Instructions

Reporting site https://secure.vermont.gov/DLC/botix/

You may use the reporting site to submit entries one at a time, or you may enter a bulk upload.

The upload file must be a valid comma-separated values (CSV) text file. The data fields must be ordered exactly like this:

Serial, Date Game Ended, Denomination, Count, Payout Percentage, Distributor ID, Name of Game Manager, Manager Street Address, Manager Town, Manager State, Manager Zip, Manager Phone, Manager Email, DLC Licensee, Amount Sold, Amount Received, Form Number, Other Name, Other Street, Other City, Other State, Other Zipcode, Other Phone, Other Email

If you select "Other" as a distributor, you must provide the name, address and contact details. Otherwise, please write "NONE" in those fields.

There should be 24 columns altogether. NOTE: PLEASE DO NOT INCLUDE COLUMN NAMES.

The comma-separated values file should look something like this, with one transaction per line.

"33333333, 09/28/2017, 100.00, 100, 100, 13, John Doe, 147 State Street, Montpelier, VT, 05601, 000-000-0000, DLC@VT.GOV, no, 100, 10000, 13446, John Doe Distributing, 111 Test Street, Montpelier, VT, 05601, 111-111-1111, jddistributing@test.com"

Files that do not conform to this format will be rejected. Most spreadsheet applications, such as Excel, as well as accounting/inventory management systems are capable of saving files in comma-separated values (CSV) format. For help, contact your vendor.

Non-Profit's Format Template

If you use the template, you MUST remove the top line of column headers and save the file in a .csv format.

List of Distributors

id    name
1    Best Bingo Supplies, Inc
2    Bingo Supply of Vermont, Inc
3    Burke Enterprise Partnership
4    Game Tab Ltd

Tags: 

How to Reach Us

Patrick T. Delaney, Commissioner
Wendy Knight, Deputy Commissioner
13 Green Mountain Drive
Montpelier VT 05602
802-828-2345

Complete Contact List

Public Information Requests

Wendy Knight, Deputy Commissioner, Liquor Control

Click Here - For Statewide Public Records Database

 

Vermont Board of Liquor and Lottery