Connecticut Fuel Tax Calculator

Instructions for using the Excel Spreadsheet to fill out your IFTA-100 IFTA Quarterly Fuel Tax Return 1. Complete Demographic Information – Your IFTA Taxpayer ID Number, Name and Address on the IFTA-100-MN tab. 2. Check any of the boxes that apply to this return (Address change, No Operation in any jurisdiction, etc.) 3. Choose the tab that corresponds to the Fuel Type of the schedule that you will file (Diesel, Gasoline). 4. Complete the MPG calculation. Enter your Total IFTA Miles, Total Non-IFTA Miles (If Applicable) and Total Gallons for the Quarter. 5. Complete the schedules for the individual Jurisdictions. Enter the jurisdiction by clicking the drop down box on the left side of the form and choose the abbreviation for the jurisdiction that you are filing. Enter the IFTA Miles and any TAX PAID GALLONS for that jurisdiction. 6. Once all Jurisdictions have been entered, click on the error tab and see if the return contains any errors (Noted by a “1” in any of the fields). 7. Once the return is complete and no error codes exist. Print the return and mail it to: State of Connecticut PO Box 22075 Albany, NY 12201-2075 ERROR Report Total Errors IFTA-100-MN IFTA Identification Number (Must be 11 digits long, not including CT or check digit number.) 1 1 = ERROR Motor Fuel 1 0 = OK Total IFTA Miles do not match total IFTA miles in Col. H. Tax Paid Gallons cannot be greater than Total gallons. 0 Line 9 Must be entered as a positive. Line 11 Must be entered as a positive. Refund amount on line 11 cannot be greater than line 10. Diesel Total IFTA Miles do not match total IFTA miles in Col. H. Tax Paid Gallons cannot be greater than Total gallons. 0 0 0 0 Click here for IFTA Inc.'s Web site. http://www.iftach.org 0 0 tp://www.iftach.org 2Q/2009 STATE OF CONNECTICUT DEPARTMENT OF REVENUE SERVICES 25 SIGOURNEY ST. HARTFORD, CT. 06106 IFTA-100-MN Use this form to report operations for the quarter ending 06/30/09 This report must be filed by the last day of the month following the end of the quarter. Licensee IFTA Identification number CT Name Street address City State Zip Code Address change No operation in any jurisdiction Cancel license Amended report IFTA Quarterly Fuel Use Tax Report File this report even if there is no tax due. Use this form for filing your Quarterly Fuel Use Tax Report as required under the International Fuel Tax agreement (IFTA). Read instructions carefully. Make a copy for your records. Attach check or money order payable to: COMMISSIONER OF REVENUE SERVICES See Mailing Instructions. $ Enter the amount of your payment here Enter the Total Due from column Q of Form IFTA-101-MN, IFTA Quarterly Fuel Use Tax Schedule, for each fuel types listed in lines 1 thru 4. For all other fuel types enter the Total Amount from column S of the worksheet on the back of Form IFTA-101-I-MN. Enter any credit amounts in brackets. Attach a Form IFTA-101-MN for each type reported below. 1 Diesel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 . . . . . . . . . . . . 2 Motor fuel gasoline. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 3 Ethanol. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 4 Propane (LPG). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4. . . . . . . . . . . . 5 All other fuel types not listed in lines 1 thru 4 (from worksheet on back of IFTA-101-I) . . 5 . 6 Subtotal of amount due or (credit) (add lines 1 through 5). . . . . . . . . . . . . . . . . . . . .6 . . . . . . . . . . . . . . . 7 Penalty (see instructions). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .7. . . . . . . . . . . . . . 9 Credits to be applied. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 . . . . . . . . . . . . ") . . 10 Balance due/(credit) (subtract line 9 from line 8). . . . . . . . . . . . . . . . . . . . . . . . . . . .10. . . . . . . . . . . . . . 11 Refund amount requested. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 I certify that this business is duly licensed and that this report, including any schedules, is to the best of my knowledge and belief true, correct and complete. For Office Use Only 50.00 . 8 Total balance due or (credit) (add lines 6 and 7). . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 . . . . . . . . . . . . . . . . . 50.00 50.00 Authorized signature Official title Date Taxpayer's phone number Paid preparer's EIN Paid preparer's phone # Sig Corr Name/ID Paid preparer's name or firm (if other than taxpayer) Paid preparer's address CT Paid preparer's signature Please make a copy of this report for your records. IFTA-100-MN (3/01) See Mailing Instructions. Date Date Received CONNECTICUT DEPARTMENT OF REVENUE SERVICES 2Q/2009 IFTA Quarterly Fuel Use Tax Schedule Tax on Fuel Type: D (Diesel) Attach this schedule to Form IFTA-100, IFTA Quarterly Fuel Use Tax Report. Prepare a separate schedule for each fuel type. Use additional sheets if necessary. Make a copy for your records. Use this form to report operations for the quarter ending Date due Date Processed IFTA-101 06/30/09 07/31/09 08/17/09 Licensee IFTA Identification number Name CT Round to the nearest whole gallon or mile. Read instructions (IFTA-101-I) carefully. Total Total (A) IFTA Miles + (B) Non-IFTA Miles = (C) Total Miles / (D) Total Gallons (all IFTA and Non-IFTA jurisdictions) = = (E) (E) N Tax Rate Average Fleet MPG (2 decimal places) (A) (B) H = (C) I Taxable Miles / J (D) K Taxable Gallons (col. I / J) L Tax Paid Gallons Enter credits in brackets([ ]). F G Rate Code M Net Taxable Gallons (col. K - L) O Tax (Credit) Due (col. M x N (Tax)) (col. K x N (Surch)) P Interest Due Q Jurisdiction IFTA Miles MPG from E above Total Due (col. O + P) Subtotal Subtotal from continuation Total - - - - IFTA Quarterly Fuel Use Tax Schedule DIESEL - Continuation-2 Licensee IFTA Identification number CT Total IFTA Miles Total (B) Non-IFTA Miles = (C) (B) H = (C) I Taxable Miles Name Use this form to report operations for the quarter ending Date due Date Processed 06/30/09 07/31/09 08/17/09 (A) (A) + + Total Miles / / J (D) Total Gallons (all IFTA and Non-IFTA jurisdictions) = = (E) (E) N Tax Rate Average Fleet MPG (2 decimal places) (D) K Taxable Gallons (col. I / J) L Tax Paid Gallons Enter credits in brackets([ ]). F G Rate Code M Net Taxable Gallons (col. K - L) O Tax (Credit) Due (col. M x N (Tax)) (col. K x N (Surch)) P Interest Due Q Jurisdiction IFTA Miles MPG from E above Total Due (col. O + P) Total - - - - Totals IFTA Quarterly Fuel Use Tax Schedule DIESEL - Continuation-3 Licensee IFTA Identification number CT Total IFTA Miles Total (B) Non-IFTA Miles = (C) (B) H = (C) I Taxable Miles Name Use this form to report operations for the quarter ending Date due Date Processed 06/30/09 07/31/09 08/17/09 (A) (A) + + Total Miles / / J (D) Total Gallons (all IFTA and Non-IFTA jurisdictions) = = (E) (E) N Tax Rate Average Fleet MPG (2 decimal places) (D) K Taxable Gallons (col. I / J) L Tax Paid Gallons Enter credits in brackets([ ]). F G Rate Code M Net Taxable Gallons (col. K - L) O Tax (Credit) Due (col. M x N (Tax)) (col. K x N (Surch)) P Interest Due Q Jurisdiction IFTA Miles MPG from E above Total Due (col. O + P) Total - - - - Totals CONNECTICUT DEPARTMENT OF REVENUE SERVICES 2Q/2009 IFTA Quarterly Fuel Use Tax Schedule Tax on Fuel Type: G (Gasoline) Attach this schedule to Form IFTA-100, IFTA Quarterly Fuel Use Tax Report. Prepare a separate schedule for each fuel type. Use additional sheets if necessary. Make a copy for your records. Use this form to report operations for the quarter ending Date due Date Processed IFTA-101 06/30/09 07/31/09 08/17/09 Licensee IFTA Identification number Name CT Round to the nearest whole gallon or mile. Read instructions (IFTA-101-I) carefully. Total Total (A) IFTA Miles + (B) Non-IFTA Miles = (C) Total Miles / (D) Total Gallons (all IFTA and Non-IFTA jurisdictions) = = (E) (E) N Tax Rate Average Fleet MPG (2 decimal places) (A) + (B) H = (C) I Taxable Miles / J (D) K Taxable Gallons (col. I / J) L Tax Paid Gallons Enter credits in brackets([ ]). F G Rate Code M Net Taxable Gallons (col. K - L) O Tax (Credit) Due (col. M x N (Tax)) (col. K x N (Surch)) P Interest Due Q Jurisdiction IFTA Miles MPG from E above Total Due (col. O + P) Sub total Subtotal from continuation Total - - - - IFTA Quarterly Fuel Use Tax Schedule GASOLINE - Continuation-2 Licensee IFTA Identification number CT (A) (A) Total IFTA Miles + + Total (B) Non-IFTA Miles = (C) (B) H = (C) I Taxable Miles Name Use this form to report operations for the quarter ending Date due Date Processed 06/30/09 07/31/09 08/17/09 Total Miles / / J (D) Total Gallons (all IFTA and Non-IFTA jurisdictions) = = (E) (E) N Tax Rate Average Fleet MPG (2 decimal places) (D) K Taxable Gallons (col. I / J) L Tax Paid Gallons Enter credits in brackets([ ]). F G Rate Code M Net Taxable Gallons (col. K - L) O Tax (Credit) Due (col. M x N (Tax)) (col. K x N (Surch)) P Interest Due Q Jurisdiction IFTA Miles MPG from E above Total Due (col. O + P) Total - - - - Totals JD AB AL AR AZ BC CA CO CT DE FL GA IA ID IL IN IN KS KY KY LA MA MB MD ME MI MN MO MS MT NB NC ND NE NH NJ NL NM NS NV NY OH OK ON OR PA PE QC RI SC SD SK Jurisdiction Alberta Alabama Arkansas Arizona British Columbia California Colorado Connecticut Delaware Florida Georgia Iowa Idaho Illinois Indiana Indiana Kansas Kentucky Kentucky Louisiana Massachusetts Manitoba Maryland Maine Michigan Minnesota Missouri Mississippi Montana New Brunswick North Carolina North Dakota Nebraska New Hampshire New Jersey Newfoundland New Mexico Nova Scotia Neveda New York Ohio Oklahoma Ontario Oregon Pennsylvania Prince Edward Island Quebec Rhode Island South Carolina South Dakota Saskatchewan FUEL_TYPE DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL Tax CodeUS Tax Rate Expiration Date Surcharge <- - - Enter (Y) for SURCHA 0056 0.2678 30-Jun-09 N 0054 0.19 30-Jun-09 N 0056 0.225 30-Jun-09 N 0065 0.26 30-Jun-09 N BE SURE TO CHANGE QU 0055 0.5263 30-Jun-09 N END DATE ON IFTA-100 M 0054 0.437 30-Jun-09 N 0056 0.205 30-Jun-09 N 0055 0.434 30-Jun-09 N 0052 0.22 30-Jun-09 N 0056 0.3187 30-Jun-09 N 0055 0.132 30-Jun-09 N 0056 0.225 30-Jun-09 N 0056 0.25 30-Jun-09 N 0056 0.434 30-Jun-09 N 0111 0.16 30-Jun-09 N 0112 0.11 30-Jun-09 Y 0056 0.26 30-Jun-09 N 0103 0.181 30-Jun-09 N 0104 0.084 30-Jun-09 Y 0056 0.2 30-Jun-09 N 0054 0.21 30-Jun-09 N 0057 0.3421 30-Jun-09 N 0054 0.2425 30-Jun-09 N 0051 0.296 30-Jun-09 N 0078 0.262 30-Jun-09 N 0057 0.255 30-Jun-09 N 0056 0.17 30-Jun-09 N 0056 0.18 30-Jun-09 N 0056 0.2775 30-Jun-09 N 0054 0.5028 30-Jun-09 N 0056 0.299 30-Jun-09 N 0056 0.23 30-Jun-09 N 0056 0.264 30-Jun-09 N 0050 0.18 30-Jun-09 N 0052 0.175 30-Jun-09 N 0054 0.4908 30-Jun-09 N 0056 0.21 30-Jun-09 N 0054 0.4581 30-Jun-09 N 0056 0.27 30-Jun-09 N 0054 0.3875 30-Jun-09 N 0096 0.28 30-Jun-09 N 0056 0.13 30-Jun-09 N 0050 0.4254 30-Jun-09 N 0054 0 30-Jun-09 N 0061 0.381 30-Jun-09 N 0055 0.5682 30-Jun-09 N 0056 0.482 30-Jun-09 N 0052 0.3 30-Jun-09 N 0054 0.16 30-Jun-09 N 0056 0.22 30-Jun-09 N 0056 0.4463 30-Jun-09 N TN TX UT VA VA VT WA WI WV WY Tennessee Texas Utah Virginia Virginia Vermont Washington Wisconsin West Virginia Wyoming DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL DIESEL 0056 0056 0056 0107 0108 0064 0056 0056 0054 0056 0.17 0.2 0.245 0.175 0.035 0.26 0.375 0.329 0.322 0.14 30-Jun-09 30-Jun-09 30-Jun-09 30-Jun-09 30-Jun-09 30-Jun-09 30-Jun-09 30-Jun-09 30-Jun-09 30-Jun-09 N N N N Y N N N N N <- - - Enter (Y) for SURCHARGE or (R) for RATE CHANGE BE SURE TO CHANGE QUARTER END DATE ON IFTA-100 MN JD AB AL AR AZ BC CA CO CT DE FL GA IA ID IL IN IN KS KY KY LA MA MB MD ME MI MN MO MS MT NB NC ND NE NH NJ NL NM NS NV NY OH OK ON OR PA PE QC RI SC SD Jurisdiction Alberta Alabama Arkansas Arizona British Columbia California Colorado Connecticut Delaware Florida Georgia Iowa Idaho Illinois Indiana Indiana Kansas Kentucky Kentucky Louisiana Massachusetts Manitoba Maryland Maine Michigan Minnesota Missouri Mississippi Montana New Brunswick North Carolina North Dakota Nebraska New Hampshire New Jersey Newfoundland New Mexico Nova Scotia Neveda New York Ohio Oklahoma Ontario Oregon Pennsylvania Prince Edward Island Quebec Rhode Island South Carolina South Dakota FUEL_TYPE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE Tax Code US Tax Rate Expiration DateSurcharge <- - - Enter (Y) for SURCHAR 0056 0.2678 30-Jun-09 N 0054 0.16 30-Jun-09 N 0056 0.215 30-Jun-09 N 0056 0 30-Jun-09 N BE SURE TO CHANGE QUAR 0055 0.501 30-Jun-09 N END DATE ON IFTA-100 MN 0054 0 30-Jun-09 N 0056 0.22 30-Jun-09 N 0054 0.25 30-Jun-09 N 0052 0.23 30-Jun-09 N 0056 0.2117 30-Jun-09 N 0059 0.125 30-Jun-09 N 0056 0.21 30-Jun-09 N 0054 0 30-Jun-09 N 0056 0.373 30-Jun-09 N 0112 0.11 30-Jun-09 Y 0111 0.18 30-Jun-09 N 0056 0.24 30-Jun-09 N 0104 0.036 30-Jun-09 Y 0103 0.211 30-Jun-09 N 0056 0.2 30-Jun-09 N 0054 0.21 30-Jun-09 N 0056 0.3421 30-Jun-09 N 0054 0.235 30-Jun-09 N 0050 0 30-Jun-09 N 0055 0 30-Jun-09 N 0057 0.255 30-Jun-09 N 0055 0.17 30-Jun-09 N 0056 0.18 30-Jun-09 N 0056 0 30-Jun-09 N 0054 0.3183 30-Jun-09 N 0056 0.299 30-Jun-09 N 0056 0.23 30-Jun-09 N 0056 0.264 30-Jun-09 N 0050 0 30-Jun-09 N 0052 0.145 30-Jun-09 N 0054 0.4908 30-Jun-09 N 0054 0 30-Jun-09 N 0055 0.4611 30-Jun-09 N 0054 0.23 30-Jun-09 N 0054 0.379 30-Jun-09 N 0096 0.28 30-Jun-09 N 0056 0.16 30-Jun-09 N 0050 0.4373 30-Jun-09 N 0054 0 30-Jun-09 N 0061 0.312 30-Jun-09 N 0055 0054 0052 0054 0054 0.4522 0.4522 0.3 0.16 0 30-Jun-09 30-Jun-09 30-Jun-09 30-Jun-09 30-Jun-09 N N N N N SK TN TX UT VA VA VT WA WI WV WY Saskatchewan Tennessee Texas Utah Virginia Virginia Vermont Washington Wisconsin West Virginia Wyoming GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE GASOLINE 0056 0056 0056 0056 0107 0108 0051 0056 0056 0054 0056 0.4463 0.2 0.2 0.245 0.175 0.035 0 0.375 0.329 0.322 0.14 30-Jun-09 30-Jun-09 30-Jun-09 30-Jun-09 30-Jun-09 30-Jun-09 30-Jun-09 30-Jun-09 30-Jun-09 30-Jun-09 30-Jun-09 N N N N N Y N N N N N <- - - Enter (Y) for SURCHARGE or (R) for RATE CHANGE BE SURE TO CHANGE QUARTER END DATE ON IFTA-100 MN Abbreviation AB AK AL AR AZ BC CA CO CT DC DE FL GA IA ID IL IN KS KY LA MA MB MD ME MI MN MO MS MT MX NB NC ND NE NL NH NJ NM NS NT NV NY OH OK ON OR PA PE QC RI SC SD SK TN TX UT VA VT WA WI WV WY YT Jurisdiction Alberta Alaska Alabama Arkansas Arizona British Columbia California Colorado Connecticut Dist. of Columbia Delaware Florida Georgia Iowa Idaho Illinois Indiana Kansas Kentucky Louisiana Massachusetts Manitoba Maryland Maine Michigan Minnesota Missouri Mississippi Montana Mexico New Brunswick North Carolina North Dakota Nebraska Newfoundland New Hampshire New Jersey New Mexico Nova Scotia Nrthwst Territory Neveda New York Ohio Oklahoma Ontario Oregon Pennsylvania Prince Edward Isl. Quebec Rhode Island South Carolina South Dakota Saskatchewan Tennessee Texas Utah Virginia Vermont Washington Wisconsin West Virginia Wyoming Yukon Territory Surcharge/Rate Change (Y) = Surcharge (R) = Rate Change (C) = Surcharge state with a rate change MUST USE CAPITAL LETTERS See example below. DIESEL Y Y Y IN KY VA MOTOR FUEL/GASOLINE Y IN Y KY Y VA Surcharge state with a rate change must be entered twice. One with a Y and one with a C. Rate change only must be entered with an R. Y IN Y KY C KY Y MI Y OH Y VT Y VA R ME 63