field_block:node:page:title
File Lawful Gambling Tax Electronically
field_block:node:page:body
There are two ways you can file your return in e-Services:
If you import a return, you must follow the rules below.
The Gambling Monthly Tax Return (G1 and B2) File Layout Rules contains the requirements for each field in the file. The second tab of this document explains the available options for the type of operation, type of game, and game status.
Net Receipts Loss Tax Credit: If you are reporting and claiming a tax credit for the net losses for bingo, raffle, and paddlewheel activity, you must complete the Net Receipts Loss (Schedule NRL) and attach it as a PDF file in e-Services.
Amend Returns: You cannot submit an amended return in e-Services. Complete a paper Gambling Monthly Tax Return (Form G1), check the "Amended return" box, and mail it to the department.
field_block:node:page:field_paragraph
Open the spreadsheet named Gambling Monthly Tax Return Import File Template (see Lawful Gambling Tax File Formats).
- In row 2, enter the required G1 and Worksheet E information. Use the column descriptions to determine what information you must enter. Note: If you report exempt raffles, e-Services will calculate net receipts and ER credit.
- In row 4 and below, enter each barcoded game on a separate line. You can include all game types and site locations in the same spreadsheet.
- Do not use commas.
- Round to nearest dollar.
- Record Type: Enter G1-B2 for each game.
- Type of Operation: Enter BOOTH = Booth; BAROP = Bar-op, or PTDISP = Pull-tab dispenser
- Type of Game: Enter P = Paper Pull-tabs; PW = Paddlewheels; T = Tipboards; PT = Progressive tipboards; PP = Progressive pull-tabs; RB = Raffle Boards, or SB = Sports-themed tipboards.
- Game Status: Enter 1 = Played; 2 = Missing; 3 = Defective; 4 = Destroyed with Revenue Approval; 5 = Fund Loss Games Destroyed by Revenue; 6 = Reported as Fund Loss
- Manufacturer ID: Must be two alpha characters.
Before you import the file into to e-Services you must save it as a Text (.txt) file format. First, you must save it as a Comma Delimited (.csv) file and then convert it into a .txt file.
- Delete rows 1 and 3 which contain the header detail. The only information in your file should be the data you entered.
- Save the file as a .csv file. Select File>Save As. In the Save as type: drop down, select CVS (Comma delimited) and select Save.
- Close the Excel file.
- Open the .csv file in Notepad. Find the file, right click on the file name and select the Open with>Notepad.
- Select File>Save, to save it as a .txt file.
Remember to keep a copy of the spreadsheet in case you need to file an amended return in the future.
To import your file, log in to e-Services and select Returns and Periods for your Lawful Gambling Tax account. Select the File Return link for the appropriate filing period and select Import Your Data.
Remember to keep a copy of the spreadsheet in case you need to file an amended return.
