Layouts for Racing Bets Levy Return upload data files
There are four layouts, one for each operator type (Bookmakers, Betting Exchanges, On Course Totalisators and Off Course Totalisators).
Types of rows
The file must be made up of three kinds of rows, (H)eader, (D)etail and (F)ooter. See the layout below for details of each kind.
Order
The (H)eader row must be the first row, followed by the (D)etail rows and then the (F)ooter as the last row. The detail rows must be ordered according to Race Club, Race Date and then Race No.
Date and code
The file must be in date order and in the following code order: Thoroughbreds (T), Greyhounds (G) and Harness (H). Files that are not in this order will not upload.
Separation of columns
Columns (fields) must be comma separated (CSV). Note that creating the files in a spreadsheet program and saving as CSV is fine. It may create extra commas and lines at the end of the header and footer that need to be removed prior to uploading the file.
File name
Please ensure that the file to be uploaded is named as follows: Racing Bets Levy Return <month>.csv (where <month> is the applicable month the return applies to YYYYMM format)
Sample: Racing Bets Levy Return 201812.csv
Tips for creating these files
If you are creating them in a spreadsheet program, you can set up formulas to calculate the correct numbers. When you save the files as .csv, the formulas are removed and the value remains.
If you enter Nov09 or 11/2009 or Nov/09 in Microsoft Excel, it will convert that to Nov-09 which is a valid format for submission.If you enter Nov/09 or Nov-09 in Google Docs, it will format it incorrectly. Use Nov09 or 11/2009.