Free TC-29Qi, Utah 911 Emergency Srvcs Schedule Supplemental Information - Utah

Utah State Tax Commission 210 North 1950 West · Salt Lake City, UT 84134 · www.tax.utah.gov

TC-29Qi
Rev. 6/07

911 Emergency Services Schedule (TC-29Q) Supplemental Information

The detail information (TC-29Q) required in conjunction with the TC-29 coupon return for Emergency Services Telephone Fee is to be submitted electronically. The supplemental information file (TC-29Q) has the same due date as the coupon return (TC-29) and is subject to the same late filing penalties. The required format for the comma delimited, variable length file is as follows:

Description
Header Record Federal ID #, Tax Type, E911 Total,* Poison Control,** Total*** Detail Record For E911 Period From Date, Period To Date, FIPS State Code, FIPS County Code, FIPS MA Code, Filler, Utah County Code, Utah City Code, Land Lines, Cellular Lines, Rate, Tax Amount, Jurisdiction Description Detail Record For Poison Control Period From Date, Period To Date, FIPS State Code, Filler, Filler, Filler, Poison Control Code, Poison Control Code, Land Lines, Cellular Lines, Rate, Tax Amount, Jurisdiction Description Detail Record For Statewide 911 Fee Period From Date, Period To Date, FIPS State Code, Filler, Filler, Filler, Statewide Code, Statewide Code, Land Lines, Cellular Lines, Rate, Tax Amount, Jurisdiction Description

Instruction
Single Record Exclude the dash (9 digits) Data should always be "26" E911 total (enter decimal and cents if applicable) Poison Control total (enter decimal and cents if applicable) Total amount remitted (enter decimal and cents if applicable) One Record for each jurisdiction being reported Format "YYYYMM" Format "YYYYMM" Utah's FIPS code is 49 Three-digit county code found in the FIPS table Five-digit MA code found in the FIPS table Leave blank, but enter comma Two-digit Utah county identifier Three-digit Utah city identifier Number of taxed land lines (whole numbers only) Number of taxed cellular lines (whole numbers only) Tax rate for jurisdiction (currently 0.65) Tax amount for this jurisdiction (enter decimal and cents if applicable)
Name of jurisdiction from the FIPS table

Type
Character Character Numeric Numeric
Numeric

Numeric Numeric Character Character Character Character Character Character Numeric Numeric Numeric Numeric
Character

One record for each filing period reported Format "YYYYMM" Format "YYYYMM" Utah's FIPS code is 49 "0" "0" Leave blank, but enter comma Two-digit identifier (use 00) Three-digit identifier (use 000)) Number of taxed land lines (whole numbers only) Number of taxed cellular lines (whole numbers only) Tax rate for Poison Control (currently 0.07) Tax amount for Poison Control (enter decimal and cents if applicable)
Always "Poison Control" for this detail line

Numeric Numeric Character Character Character Character Character Character Numeric Numeric Numeric Numeric
Character

One record for each filing period reported Format "YYYYMM" Format "YYYYMM" Utah's FIPS code is 49 "0" "0" Leave blank, but enter comma Two-digit statewide identifier (use 33) Three-digit statewide identifier (use 000) Number of taxed land lines (whole numbers only) Number of taxed cellular lines (whole numbers only) Tax rate for Statewide 911 Fee (currently 0.13) Tax amount for Statewide 911 (enter decimal and cents if applicable)
Always "Statewide 911" for this detail line

Numeric Numeric Character Character Character Character Character Character Numeric Numeric Numeric Numeric
Character

Detail Record For Seller Discount Period From Date, Period To Date, FIPS State Code, Filler, Filler, Filler, Seller Discount Code, Seller Discount Code, Land Lines, Cellular Lines, Rate, Seller Discount, Jurisdiction Description
Notes:

One record for each filing period reported Format "YYYYMM" Format "YYYYMM" Utah's FIPS code is 49 "0" "0" Leave blank, but enter comma Two-digit seller discount identifier (use 99) Three-digit seller discount identifier (use 999) "0" or gross amount of 911 subject to discount "0" or gross amount of 911 subject to discount Seller discount rate is 0.015 Amount of seller discount (enter minus sign before dollars & cents)
Always "Seller Discount" for this detail line

Numeric Numeric Character Character Character Character Character Character Numeric Numeric Numeric Numeric
Character

* E911 Total equals the tax for each jurisdiction line, plus the statewide amount, less the seller discount, if applicable. Only monthly filers are eligible for seller discount. Return must be filed and paid timely to be eligible for seller discount. ** Poison Control is the detail record amount, which is the number of lines multiplied by .07 *** Total is the E911 Total plus the Poison Control Total

How to File
The file records will be in a variable length, text format with each field separated by a comma. The supplemental information can be submitted using FTP Client to ftp.tax.utah.gov that will prompt you to log in with the user id "anonymous" and your e-mail address as the password. An alternative is to enter ftp://ftp.tax.utah.gov/prv/(Tax Commission issued subdirectoy) that will take you directly into your subdirectoy where you can copy and paste your file. Each account is currently assigned a specific subdirectoy in /prv/(Tax Commission issued subdirectoy). You will post your supplemental TC-29Q information using the filename "xxx9999.csv" (with xxx representing the three-digit month abbreviation in lowercase as in dec, jan, jun, etc, and 9999 representing the year as in 2005) in your specific subdirectoy. The file name must be lowercase, so the file name for the July 2005 filing would be "jul2005.csv." To summarize: Location: ftp.tax.utah.gov (FTP Client) or ftp://ftp.tax.utah.gov/prv/ (Tax Commission issued subdirectoy) User Id: anonymous Password: e-mail address Path: /prv/(Tax Commission issued subdirectoy) Filename: xxx9999.csv (lowercase) Format: comma delimited, variable length, text file (.csv)

Example
The following is an example of the comma-delimited file for an account with 3 jurisdictions for the Sept. 2005 filing period: 123456789,26,226.65,20.65,247.30 200509,200509,49,011,07690,,06,004,10,0,0.65,6.5,Bountiful 200509,200509,49,043,58070,,22,030,250,0,0.65,162.5, Park City 200509,200509,49,035,70850,,18,138, 35,0,0.65,22.75,South Jordan 200509,200509,49,0,0,,00,000,295,0,0.07,20.65,Poison Control 200509,200509,49,0,0,,33,000,295,0,0.13,38.35,Statewide 911 200509,200509,49,0,0,,99,999,0,230.10,0.015,-3.45,Seller Discount

Amended Returns
To amend an amount on a previously filed period, enter the net difference between the amount of the original filing and the corrected amount as a separate detail line on the current filing. It is not necessary to file the whole previous return along with the corrected line(s). The following is an example of how an amended amount should be added to a current filing. Using the example above, we will add a correction for the 200508-200508 period for county/city code 18-138. The August return reported 40 lines, where it should have been 50 lines. The net difference is 10 lines for an increase of $6.50. The line added to the 200509-200509 file is: 200508,200508,49,035,70850,,18,138,10,0,0.65,6.50,South Jordan Below, we have incorporated the changed line from period 200508-200508 into the example file for period 200509-200509. 123456789,26,234.33,21.35,255.68 200509,200509,49,011,07690,,06,004,10,0,0.65,6.5,Bountiful 200509,200509,49,043,58070,,22,030,250,0,0.65,162.5, Park City 200509,200509,49,035,70850,,18,138,35,0,0.65,22.75,South Jordan 200508,200508,49,035,70850,,18,138,10,0,0.65,6.5,South Jordan 200509,200509,49,0,0,,00,000,305,0,0.07,21.35,Poison Control 200509,200509,49,0,0,,33,000,305,0,0.13,39.65,Statewide 911 200509,200509,49,0,0,,99,999,0,237.90,0.015,-3.57,Seller Discount Note: In this example, the fields that were affected by the correction from period 200508-200508 are highlighted. Because we added more lines, the Poison Control and Statewide 911 counts increased, which in turn changed the dollar amounts. You do not need to highlight any changes in your text files. Important: The total number of jurisdiction lines must equal the number of lines used for both Poison Control and Statewide 911. The FIPS table is printed on the following pages.

Jurisdiction Identifier
Poison Control Seller Discount Statewide Beaver City Beaver County Milford Minersville Bear River Box Elder County Brigham Corinne Deweyville Elwood Fielding Garland Honeyville Howell Mantua Perry Plymouth Portage Snowville Tremonton Willard Amalga Cache County Cache Valley Transit Clarkston Cornish Hyde Park Hyrum Lewiston Logan Mendon Millville Newton Nibley North Logan Paradise Providence Richmond River Heights Smithfield Trenton Wellsville Carbon County East Carbon Helper Price Scofield Sunnyside Wellington Daggett County Manila Bountiful Centerville Clearfield Clinton Davis County Farmington Fruit Heights Kaysville Layton North Salt Lake South Weber Sunset Syracuse West Bountiful West Point Woods Cross

Utah County Code
00 99 33 01 01 01 01 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 03 03 03 03 03 03 03 03 03 03 03 03 03 03 03 03 03 03 03 03 03 04 04 04 04 04 04 04 05 05 06 06 06 06 06 06 06 06 06 06 06 06 06 06 06 06

Utah City Code
000 999 000 002 000 008 009 004 000 017 025 032 035 041 044 054 057 069 086 090 092 100 113 120 001 000 900 014 017 032 033 036 038 041 044 047 098 049 053 056 059 060 062 081 076 000 058 016 035 040 046 053 000 006 004 006 008 059 000 017 010 026 030 035 045 048 049 061 056 057

FIPS State Code
49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49

FIPS County Code
000 000 000 001 001 001 001 003 003 003 003 003 003 003 003 003 003 003 003 003 003 003 003 003 005 005 005 005 005 005 005 005 005 005 005 005 005 005 005 005 005 005 005 005 005 007 007 007 007 007 007 007 009 009 011 011 011 011 011 011 011 011 011 011 011 011 011 011 011 011

FIPS MA Code
00000 00000 00000 04060 00000 50040 50590 03950 00000 08460 15830 19680 22760 25290 28150 36290 36620 47840 59390 61260 61590 69970 77120 84710 01090 00000 00000 13190 15940 37390 37500 44760 45860 49160 50370 54550 54660 54990 57850 62360 63680 64120 69640 77230 82620 00000 20890 34530 62030 67990 74370 82510 00000 47620 07690 11980 13850 14290 00000 24740 27490 40360 43660 55210 71180 74480 74810 82840 83390 85370

Altamont Duchesne City Duchesne County Myton Roosevelt Tabiona Castle Dale Clawson Cleveland Elmo Emery City Emery County Ferron Green River Huntington Orangeville Antimony Boulder Cannonville Escalante Garfield County Hatch Henrieville Panguitch Tropic Grand County Castle Valley Moab Brian Head Cedar City Enoch Iron County Kanarraville Paragonah Parowan Eureka Juab County Levan Mona Nephi Rocky Ridge Town Alton Big Water Glendale Kanab Kane County Orderville Big Water Delta Fillmore Hinckley Holden Kanosh Leamington Lynndyl Meadow Millard County Oak City Scipio Morgan City Morgan County Circleville Junction Kingston Marysvale Piute County Garden City Laketown Randolph Rich County Woodruff Alta

07 07 07 07 07 07 08 08 08 08 08 08 08 08 08 08 09 09 09 09 09 09 09 09 09 10 10 10 11 11 11 11 11 11 11 12 12 12 12 12 12 13 13 13 13 13 13 13 14 14 14 14 14 14 14 14 14 14 14 15 15 16 16 16 16 16 17 17 17 17 17 18

001 008 000 017 019 020 001 003 004 007 008 000 009 011 012 016 001 002 004 005 000 006 008 011 015 000 005 011 028 003 005 000 012 018 019 009 000 019 024 026 030 001 010 002 004 000 007 010 010 014 023 024 026 028 030 034 000 037 040 007 000 003 005 006 007 000 001 002 005 000 010 003

49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49

013 013 013 013 013 013 015 015 015 015 015 015 015 015 015 015 017 017 017 017 017 017 017 017 017 019 019 019 021 021 021 021 021 021 021 023 023 023 023 023 023 025 025 025 025 025 025 025 027 027 027 027 027 027 027 027 027 027 027 029 029 031 031 031 031 031 033 033 033 033 033 035

00760 20340 00000 53340 64670 74920 10660 13300 14070 22540 22870 00000 25180 31670 36950 56860 01860 07470 10330 23750 00000 33760 34750 57740 77560 00000 11000 50700 08020 11320 23200 00000 40030 57960 58510 24080 00000 44650 51140 54220 64590 00870 05534 29360 39920 00000 57080 05534 18910 25510 35740 35960 40250 43880 46740 48830 00000 55430 67880 51910 00000 12970 39590 41350 48610 00000 27930 42560 63020 00000 85260 00650

Bluffdale Cottonwood Heights Draper Herriman Holladay Midvale Murray Riverton Salt Lake City Salt Lake County Sandy South Jordan South Salt Lake Taylorsville West Jordan West Valley City Blanding Monticello San Juan County Centerfield Ephraim Fairview Fayette Fountain Green Gunnison Manti Mayfield Moroni Mt. Pleasant Sanpete County Spring City Sterling Wales Annabella Aurora Central Valley Elsinore Glenwood Joseph Koosharem Monroe Redmond Richfield Salina Sevier County Sigurd Coalville Francis Henefer Kamas Oakley Park City Snyderville Basin Transit Dist. Summit County Erda Grantsville Lakepoint Lincoln Ophir Rush Valley Stansbury Park Stockton Tooele City Tooele County Vernon Wendover Ballard Naples Uintah County Vernal Alpine American Fork

18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 19 19 19 20 20 20 20 20 20 20 20 20 20 20 20 20 20 21 21 21 21 21 21 21 21 21 21 21 21 21 22 22 22 22 22 22 22 22 23 23 23 23 23 23 23 23 23 23 23 23 24 24 24 24 25 25

019 020 039 060 065 093 096 118 122 000 131 138 139 142 155 167 002 009 000 004 008 009 010 011 014 020 021 023 024 000 031 032 033 001 002 007 014 018 025 029 031 033 034 035 000 038 006 013 017 022 029 030 900 000 017 023 030 065 037 056 066 046 048 000 050 052 028 014 000 024 001 002

49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49

035 035 035 035 035 035 035 035 035 035 035 035 035 035 035 035 037 037 037 039 039 039 039 039 039 039 039 039 039 039 039 039 039 041 041 041 041 041 041 041 041 041 041 041 041 041 043 043 043 043 043 043 043 043 045 045 045 045 045 045 045 045 045 045 045 045 047 047 047 047 049 049

06810 16270 20120 34970 36070 49710 53230 64340 67000 00000 67440 70850 71070 75360 82950 83470 06370 51580 00000 11870 23530 24630 25070 26720 32660 47730 48720 52130 53010 00000 71730 72940 80860 01750 02740 12260 22650 29580 39370 41680 51360 63240 63570 65880 00000 68650 14840 26940 34640 39810 55650 58070 70190 99043 23640 31120 00000 00000 56750 65240 72720 73050 76680 00000 80200 82730 03345 53560 00000 80090 00540 01310

Cedar Fort Cedar Hills Draper City South Eagle Mountain Elk Ridge Fairfield Genola Goshen Highland Lehi Lindon Mapleton Orem Payson Pleasant Grove Provo Provo Canyon Salem Santaquin Saratoga Springs Spanish Fork Springville Utah County Vineyard Woodland Hills Charleston Heber Midway Park City East Wallsburg Wasatch County Apple Valley Enterprise Hildale Hurricane Ivins La Verkin Leeds New Harmony Rockville Santa Clara Springdale St George Toquerville Virgin Washington City Washington County Bicknell Hanksville Loa Lyman Torrey Wayne County Farr West Harrisville Hooper Huntsville Marriott-Slaterville North Ogden Ogden Plain City Pleasant View Riverdale Roy South Ogden Uintah Washington Terrace Weber County West Haven

25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 26 26 26 26 26 26 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 28 28 28 28 28 28 29 29 29 29 29 29 29 29 29 29 29 29 29 29 29 29

019 123 029 030 124 035 038 043 099 066 070 073 083 085 088 090 093 096 097 098 103 106 000 117 125 003 008 011 013 014 000 002 005 035 008 010 011 012 015 019 021 023 020 024 026 027 000 001 005 007 008 010 000 012 016 018 019 022 026 027 030 031 036 037 040 043 049 000 051

49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49

049 049 049 049 049 049 049 049 049 049 049 049 049 049 049 049 049 049 049 049 049 049 049 049 049 051 051 051 051 051 051 053 053 053 053 053 053 053 053 053 053 053 053 053 053 053 053 055 055 055 055 055 055 057 057 057 057 057 057 057 057 057 057 057 057 057 057 057 057

11430 11440 20120 20810 22370 24410 28810 30130 35190 44320 45090 47950 57300 58730 60930 62470 00000 65770 67770 67825 71290 72280 00000 80420 85050 12420 34200 49820 58070 80970 00000 01905 23420 35300 37170 38710 43440 44100 54440 64560 67660 71840 65330 76900 80530 81960 00000 05490 00000 45530 46410 77010 00000 24850 33540 36400 37060 48300 55100 55980 60710 61150 64010 65110 70960 77890 82070 00000 82930