Skip to main content

Break Open Tickets Distributor's Instructions

Distributor's Reporting Instructions

Reporting site

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 Number, Customer Name, Street Address, City, State, Zip Code, Customer Phone, Date Sold, Denomination, Box Count, Payout Percentage, Game Name, Form Id, Service Club, Invoice Amount, Distributor ID

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

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

"4N52747, Jacks Games, 123 test street, rutland, vt, 05000, 222-222-2222, 2015-01-05, 123.00, 100, 100.00, Blackhills, T957, yes, 123.00, 123"

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.

Distributor'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.

The customer must be a non-profit. The current list of Non-Profits registered is available on the reporting site.

List of Distributors

id    name
1    Best Bingo Supplies, Inc
2    Game Tab Ltd