Free Utah Municipal Telecommunications License Tax (TC-34Q) Supplemental Information, TC-34Qi - Utah

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

TC-34Qi
Rev. 9/05

Municipal Telecommunications License Tax (TC-34Q) Supplemental Information

The monthly detail information (TC-34Q) required in conjunction with the TC-34 coupon return for Municipal Telecommunications License Tax is to be submitted electronically. The current format in a comma delimited, variable length file (.csv) is as follows:

Description
Header Record Federal ID #, Tax Type, Gross Receipts Total, MTLT Total Detail Record For MTFT Period From Date, Period to date, FIPS State Code, FIPS County Code, FIPS MA Code, Filler, Utah County Code, Utah City Code, Gross Receipts, Rate, Tax Amount, Jurisdiction Description

Instruction
Single Record Exclude the dash Data should always be "29" Actual gross receipts total in dollars and cents Actual MTLT total in dollars and cents One Record for each jurisdiction being reported Format "YYYYMM" Format "YYYYMM" The state FIPS code for Utah is 49 The county code can be found in the FIPS table The MA code can be found in the FIPS table Reserved for future use -- no space, just a comma Two-digit Utah county identifier Three-digit Utah city identifier Amount of services subject to tax in dollars and cents Tax rate for jurisdiction, i.e. 3.33% = .0333 Amount of tax on gross receipts in dollars and cents Name of jurisdiction from the FIPS table

Type
Numeric Numeric Numeric Numeric Numeric Numeric Character Character Character Character Character Character Numeric Numeric Numeric Character

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 the password is your e-mail address. An alternative is to enter ftp://ftp.tax.utah.gov/prv/(Tax Commission issued subdirectory) that will take you directly into your subdirectory where you can copy and paste your file. Each account is currently assigned a specific subdirectory in /prv/(Tax Commission issued subdirectory). You will post your supplemental TC-34Q information using the filename "xxx9999mt.csv" (with xxx representing the three-digit month abbreviation in lowercase, as in dec, jan, jun, etc, and 9999 representing the year, as in 2004) in your specific subdirectory. The file name must be lowercase, so the file name for the July, 2004 filing would be "jul2004mt.csv." The "mt" identifies this as the Municipal Telecommunications License Tax file as opposed to the Emergency Services (911) file also being posted to the same subdirectory. To summarize: Location: ftp.tax.utah.gov (FTP Client) or ftp://ftp.tax.utah.gov/prv/(Tax Commission issued subdirectory) User Id : anonymous Password: email address Path: /prv/(Tax Commission issued subdirectory) Filename : xxx9999mt.csv (lowercase) Format: comma delimited, variable length, text file (.csv)

The supplemental information file (TC-34Q) has the same due date as the coupon return (TC-34) and is subject to the same late filing penalties.

Amended Returns
To amend locations for previous periods, take the net difference between the amount of the original filing and the new amount. Include the net difference for the amended location in the current information report. The net difference should also be reflected in the gross receipts total and the MTLT total (total tax). See example below.

Examples
1. The comma delimited, variable length, text file for a filer with two jurisdictions would look like the following: 91234567,29,10625.00,425.00 200407,200407,49,001,04060, ,01,002,8125.00,.04,325.00,Beaver City 200407,200407,49,001,50040, ,01,008,2500.00,.04,100.00,Milford 2. AMENDED: A filer that reported the amount of gross receipts filed for Milford in July, 2004, as $2,500.00 with a tax amount of $100.00 has found a difference. The gross receipts should have been $l,875.00 with a tax amount of $75.00. The difference for gross receipts is $(625.00) with a difference in the tax amount of $(25.00). The amended record would be as follows: 200407,200407,49,001,50040, , 01,008,-625.00,.04,-25.00,Milford The table with the County/City and FIPS codes can be found on the following pages of this document.

Jurisdiction Identifier
Beaver City Milford Minersville Bear River Brigham Corinne Deweyville Elwood Fielding Garland Honeyville Howell Mantua Perry Plymouth Portage Snowville Tremonton Willard Amalga Cache Valley Transit Clarkston Cornish Hyde Park Hyrum Lewiston Logan Mendon Millville Newton Nibley North Logan Paradise Providence Richmond River Heights Smithfield Trenton Wellsville East Carbon Helper Price Scofield Sunnyside Wellington Manila Bountiful Centerville Clearfield Clinton Farmington Fruit Heights Kaysville Layton North Salt Lake South Weber Sunset Syracuse West Bountiful West Point Woods Cross Altamont Duchesne City Myton Roosevelt Tabiona Castle Dale Clawson Cleveland

Utah County Code
01 01 01 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 04 04 04 04 04 04 05 06 06 06 06 06 06 06 06 06 06 06 06 06 06 06 07 07 07 07 07 08 08 08

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

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

FIPS County Code
001 001 001 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 007 007 007 007 007 007 009 011 011 011 011 011 011 011 011 011 011 011 011 011 011 011 013 013 013 013 013 015 015 015

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

Elmo Emery City Ferron Green River Huntington Orangeville Antimony Boulder Cannonville Escalante Hatch Henrieville Panguitch Tropic Castle Valley Moab Brian Head Cedar City Enoch Kanarraville Paragonah Parowan Eureka Levan Mona Nephi Rocky Ridge Town Alton Big Water Glendale Kanab Orderville Delta Fillmore Hinckley Holden Kanosh Leamington Lynndyl Meadow Oak City Scipio Morgan City Circleville Junction Kingston Marysvale Garden City Laketown Randolph Woodruff Alta Bluffdale Cottonwood heights Draper Herriman Holladay Midvale Murray Riverton Salt Lake City Sandy South Jordan South Salt Lake Taylorsville West Jordan West Valley City Blanding Monticello Centerfield Ephraim

08 08 08 08 08 08 09 09 09 09 09 09 09 09 10 10 11 11 11 11 11 11 12 12 12 12 12 13 13 13 13 13 14 14 14 14 14 14 14 14 14 14 15 16 16 16 16 17 17 17 17 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 19 19 20 20

007 008 009 011 012 016 001 002 004 005 006 008 011 015 005 011 028 003 005 012 018 019 009 019 024 026 030 001 010 002 004 007 010 014 023 024 026 028 030 034 037 040 007 003 005 006 007 001 002 005 010 003 019 020 039 060 065 093 096 118 122 131 138 139 142 155 167 002 009 004 008

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

015 015 015 015 015 015 017 017 017 017 017 017 017 017 019 019 021 021 021 021 021 021 023 023 023 023 023 025 025 025 025 025 027 027 027 027 027 027 027 027 027 027 029 031 031 031 031 033 033 033 033 035 035 035 035 035 035 035 035 035 035 035 035 035 035 035 035 037 037 039 039

22540 22870 25180 31670 36950 56860 01860 07470 10330 23750 33760 34750 57740 77560 11000 50700 08020 11320 23200 40030 57960 58510 24080 44650 51140 54220 64590 00870 05534 29360 39920 57080 18910 25510 35740 35960 40250 43880 46740 48830 55430 67880 51910 12970 39590 41350 48610 27930 42560 63020 85260 00650 06810 16270 20120 34970 36070 49710 53230 64340 67000 67440 70850 71070 75360 82950 83470 06370 51580 11870 23530

Fairview Fayette Fountain Green Gunnison Manti Mayfield Moroni Mt. Pleasant 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 Erda Grantsville Lakepoint Lincoln Ophir Rush Valley Stansbury Park Stockton Tooele City Vernon Wendover Ballard Naples Vernal Alpine American Fork Cedar Fort Cedar Hills 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 Vineyard Woodland Hills Charleston Heber

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 23 23 23 23 23 23 23 23 23 23 23 24 24 24 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

009 010 011 014 020 021 023 024 031 032 033 001 002 007 014 018 025 029 031 033 034 035 000 038 006 013 017 022 029 030 017 023 030 065 037 056 066 046 048 050 052 028 014 024 001 002 019 123 030 124 035 038 043 099 066 070 073 083 085 088 090 093 096 097 098 103 106 117 125 003 008

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

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 045 045 045 045 045 045 045 045 045 045 045 047 047 047 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

24630 25070 26720 32660 47730 48720 52130 53010 71730 72940 80860 01750 02740 12260 22650 29580 39370 41680 51360 63240 63570 65880 00000 68650 14840 26940 34640 39810 55650 58070 23640 31120 00000 00000 56750 65240 72720 73050 76680 80200 82730 03345 53560 80090 00540 01310 11430 11440 20810 22370 24410 28810 30130 35190 44320 45090 47950 57300 58730 60930 62470 00000 65770 67770 67825 71290 72280 80420 85050 12420 34200

Midway Park City East Wallsburg Apple Valley Enterprise Hildale Hurricane Ivins La Verkin Leeds New Harmony Rockville Santa Clara Springdale St George Toquerville Virgin Washington City Bicknell Hanksville Loa Lyman Torrey Farr West Harrisville Hooper Huntsville Marriott-Slaterville North Ogden Ogden Plain City Pleasant View Riverdale Roy South Ogden Uintah Washington Terrace West Haven

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

011 013 014 002 005 035 008 010 011 012 015 019 021 023 020 024 026 027 001 005 007 008 010 012 016 018 019 022 026 027 030 031 036 037 040 043 049 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

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

49820 58070 80970 01905 23420 35300 37170 38710 43440 44100 54440 64560 67660 71840 65330 76900 80530 81960 05490 00000 45530 46410 77010 24850 33540 36400 37060 48300 55100 55980 60710 61150 64010 65110 70960 77890 82070 82930