Distributor Spreadsheet Templates

The COFTS provides Microsoft® Excel spreadsheet templates free of charge that can be used to electronically file monthly DR 7050 distributor reports along with DR 7055 and DR 7056 schedules.

The templates differ only in the number of individual fuel product receipts and disbursements that they can hold (e.g., the 100 by 100 template holds up to 100 receipts and 100 disbursements).

Download the smallest template that fits your number of fuel product receipts and disbursements.

The spreadsheet template can be saved to a location such as the Desktop (recommended) where double-clicking it creates a new spreadsheet.

Although there are several ways to file a spreadsheet created from any of these templates, filing by web upload is the easiest. Web upload is available in your restricted area of the web site. Use XLS Check beforehand to reduce the likelihood that your filing will be rejected.

Important!

The COFTS accepts DR 7050 distributor report spreadsheets based on these COFTS-provided spreadsheet templates only. It is the licensed distributor's responsibility to own or acquire a copy of either Microsoft® Excel 97 (SR-2) or newer. To file electronically with the COFTS, a licensed distributor must have a signed trading partner agreement on file.

01/01/2014: Per State statute, Propane (LPG), Compressed Natural Gas (CNG), and Liquified Natural Gas (LNG) are to be reported separately beginning with usage in 2014. Please select the appropriate tax period below:

TAX PERIODS SEPTEMBER 2020+

Version dtr0002w (09/01/2020) -- Required for September 2020 and subsequent tax periods

This update supports the change in the ERS fee rate from 0.0125 to 0.015625 that goes into effect starting with the September 2020 tax period.

download to create   download to create
100 by 100 USDtr1x1w.xlt  
200 by 200 USDtr2x2w.xlt   200 by 100 USDtr2x1w.xlt
300 by 300 USDtr3x3w.xlt   300 by 100 USDtr3x1w.xlt
400 by 400 USDtr4x4w.xlt   400 by 100 USDtr4x1w.xlt
500 by 500 USDtr5x5w.xlt   500 by 100 USDtr5x1w.xlt
600 by 600 USDtr6x6w.xlt   600 by 100 USDtr6x1w.xlt
800 by 800 USDtr8x8w.xlt   800 by 100 USDtr8x1w.xlt
800 by 1200 USDtr8x12w.xlt  
1200 by 1200 USDtr12x12w.xlt   1200 by 100 USDtr12x1w.xlt
1600 by 1600 USDtr16x16w.xlt   1600 by 100 USDtr16x1w.xlt
2000 by 2000 USDtr20x20w.xlt   2000 by 100 USDtr20x1w.xlt
2500 by 500 USDtr25x5w.xlt  
2500 by 2500 USDtr25x25w.xlt   2500 by 100 USDtr25x1w.xlt
4000 by 4000 USDtr40x40w.xlt  
TAX PERIODS JANUARY 2020-AUGUST 2020

Version dtr0002v (01/01/2020) -- Required for January 2020 and subsequent tax periods

This update supports the change in the ERS fee rate from 0.009375 to 0.0125 that goes into effect starting with the January 2020 tax period.

download to create   download to create
100 by 100 USDtr1x1v.xlt  
200 by 200 USDtr2x2v.xlt   200 by 100 USDtr2x1v.xlt
300 by 300 USDtr3x3v.xlt   300 by 100 USDtr3x1v.xlt
400 by 400 USDtr4x4v.xlt   400 by 100 USDtr4x1v.xlt
500 by 500 USDtr5x5v.xlt   500 by 100 USDtr5x1v.xlt
600 by 600 USDtr6x6v.xlt   600 by 100 USDtr6x1v.xlt
800 by 800 USDtr8x8v.xlt   800 by 100 USDtr8x1v.xlt
800 by 1200 USDtr8x12v.xlt  
1200 by 1200 USDtr12x12v.xlt   1200 by 100 USDtr12x1v.xlt
1600 by 1600 USDtr16x16v.xlt   1600 by 100 USDtr16x1v.xlt
2000 by 2000 USDtr20x20v.xlt   2000 by 100 USDtr20x1v.xlt
2500 by 500 USDtr25x5v.xlt  
2500 by 2500 USDtr25x25v.xlt   2500 by 100 USDtr25x1v.xlt
4000 by 4000 USDtr40x40v.xlt  
TAX PERIODS NOVEMBER 2018-DECEMBER 2019

Version dtr0002u (11/01/2018) -- Required for November 2018 and subsequent tax periods

This update supports the change in the ERS fee rate from 0.0125 to 0.009375 that goes into effect starting with the November 2018 tax period.

download to create   download to create
100 by 100 USDtr1x1u.xlt  
200 by 200 USDtr2x2u.xlt   200 by 100 USDtr2x1u.xlt
300 by 300 USDtr3x3u.xlt   300 by 100 USDtr3x1u.xlt
400 by 400 USDtr4x4u.xlt   400 by 100 USDtr4x1u.xlt
500 by 500 USDtr5x5u.xlt   500 by 100 USDtr5x1u.xlt
600 by 600 USDtr6x6u.xlt   600 by 100 USDtr6x1u.xlt
800 by 800 USDtr8x8u.xlt   800 by 100 USDtr8x1u.xlt
800 by 1200 USDtr8x12u.xlt  
1200 by 1200 USDtr12x12u.xlt   1200 by 100 USDtr12x1u.xlt
1600 by 1600 USDtr16x16u.xlt   1600 by 100 USDtr16x1u.xlt
2000 by 2000 USDtr20x20u.xlt   2000 by 100 USDtr20x1u.xlt
2500 by 500 USDtr25x5u.xlt  
2500 by 2500 USDtr25x25u.xlt   2500 by 100 USDtr25x1u.xlt
4000 by 4000 USDtr40x40u.xlt  
TAX PERIODS OCTOBER 2017-OCTOBER 2018

Version dtr0002t (10/01/2017) -- Required for October 2017 through October 2018 tax periods

This update supports the change in the ERS fee rate from 0.009375 to 0.0125 that goes into effect starting with the October 2017 tax period.

download to create   download to create
100 by 100 USDtr1x1t.xlt  
200 by 200 USDtr2x2t.xlt   200 by 100 USDtr2x1t.xlt
300 by 300 USDtr3x3t.xlt   300 by 100 USDtr3x1t.xlt
400 by 400 USDtr4x4t.xlt   400 by 100 USDtr4x1t.xlt
500 by 500 USDtr5x5t.xlt   500 by 100 USDtr5x1t.xlt
600 by 600 USDtr6x6t.xlt   600 by 100 USDtr6x1t.xlt
800 by 800 USDtr8x8t.xlt   800 by 100 USDtr8x1t.xlt
800 by 1200 USDtr8x12t.xlt  
1200 by 1200 USDtr12x12t.xlt   1200 by 100 USDtr12x1t.xlt
1600 by 1600 USDtr16x16t.xlt   1600 by 100 USDtr16x1t.xlt
2000 by 2000 USDtr20x20t.xlt   2000 by 100 USDtr20x1t.xlt
2500 by 500 USDtr25x5t.xlt  
2500 by 2500 USDtr25x25t.xlt   2500 by 100 USDtr25x1t.xlt
4000 by 4000 USDtr40x40t.xlt  
TAX PERIODS APRIL 2017-SEPTEMBER 2017

Version dtr0002s (04/01/2017) -- Required for April 2017 through September 2017 tax periods

This update supports the change in the ERS fee rate from 0.0125 to 0.009375 that goes into effect starting with the April 2017 tax period.

download to create   download to create
100 by 100 USDtr1x1s.xlt  
200 by 200 USDtr2x2s.xlt   200 by 100 USDtr2x1s.xlt
300 by 300 USDtr3x3s.xlt   300 by 100 USDtr3x1s.xlt
400 by 400 USDtr4x4s.xlt   400 by 100 USDtr4x1s.xlt
500 by 500 USDtr5x5s.xlt   500 by 100 USDtr5x1s.xlt
600 by 600 USDtr6x6s.xlt   600 by 100 USDtr6x1s.xlt
800 by 800 USDtr8x8s.xlt   800 by 100 USDtr8x1s.xlt
800 by 1200 USDtr8x12s.xlt  
1200 by 1200 USDtr12x12s.xlt   1200 by 100 USDtr12x1s.xlt
1600 by 1600 USDtr16x16s.xlt   1600 by 100 USDtr16x1s.xlt
2000 by 2000 USDtr20x20s.xlt   2000 by 100 USDtr20x1s.xlt
2500 by 500 USDtr25x5s.xlt  
2500 by 2500 USDtr25x25s.xlt   2500 by 100 USDtr25x1s.xlt
4000 by 4000 USDtr40x40s.xlt  
TAX PERIODS 2016-MARCH 2017

Version dtr0002r (01/01/2016) -- Required for January 2016 through March 2017 tax periods

This update changes the tax calculations on Propane.

download to create   download to create
100 by 100 USDtr1x1r.xlt  
200 by 200 USDtr2x2r.xlt   200 by 100 USDtr2x1r.xlt
300 by 300 USDtr3x3r.xlt   300 by 100 USDtr3x1r.xlt
400 by 400 USDtr4x4r.xlt   400 by 100 USDtr4x1r.xlt
500 by 500 USDtr5x5r.xlt   500 by 100 USDtr5x1r.xlt
600 by 600 USDtr6x6r.xlt   600 by 100 USDtr6x1r.xlt
800 by 800 USDtr8x8r.xlt   800 by 100 USDtr8x1r.xlt
800 by 1200 USDtr8x12r.xlt  
1200 by 1200 USDtr12x12r.xlt   1200 by 100 USDtr12x1r.xlt
1600 by 1600 USDtr16x16r.xlt   1600 by 100 USDtr16x1r.xlt
2000 by 2000 USDtr20x20r.xlt   2000 by 100 USDtr20x1r.xlt
2500 by 500 USDtr25x5r.xlt  
2500 by 2500 USDtr25x25r.xlt   2500 by 100 USDtr25x1r.xlt
4000 by 4000 USDtr40x40r.xlt  
TAX PERIODS 2014-2015

Version dtr0002q (01/01/2014) -- Required for January 2014 and subsequent tax periods

This update supports the separation of Propane, Liquified Natural Gas, and Compressed Natural Gas from Special Fuels, elimination of the DR0129 fee, and the addition of the LPG/NG fee, all per State statute, which goes into effect starting with the January 2014 tax period. This is a "must have" update that can only be used for tax periods in 2014 and later; for tax periods prior to 2014 please use the previous version (below).

download to create   download to create
100 by 100 USDtr1x1q.xlt  
200 by 200 USDtr2x2q.xlt   200 by 100 USDtr2x1q.xlt
300 by 300 USDtr3x3q.xlt   300 by 100 USDtr3x1q.xlt
400 by 400 USDtr4x4q.xlt   400 by 100 USDtr4x1q.xlt
500 by 500 USDtr5x5q.xlt   500 by 100 USDtr5x1q.xlt
600 by 600 USDtr6x6q.xlt   600 by 100 USDtr6x1q.xlt
800 by 800 USDtr8x8q.xlt   800 by 100 USDtr8x1q.xlt
800 by 1200 USDtr8x12q.xlt  
1200 by 1200 USDtr12x12q.xlt   1200 by 100 USDtr12x1q.xlt
1600 by 1600 USDtr16x16q.xlt   1600 by 100 USDtr16x1q.xlt
2000 by 2000 USDtr20x20q.xlt   2000 by 100 USDtr20x1q.xlt
2500 by 500 USDtr25x5q.xlt  
2500 by 2500 USDtr25x25q.xlt   2500 by 100 USDtr25x1q.xlt
4000 by 4000 USDtr40x40q.xlt  
TAX PERIODS 1999-2013

Version dtr0002p (08/15/2013) -- Required for tax periods prior to January 2014

This update supports the increase in the ERS fee rate from 0.00625 to 0.0125 that goes into effect starting with the August 2013 tax period. This version can also be used for tax periods prior to 2014.

download to create   download to create
100 by 100 USDtr1x1p.xlt  
200 by 200 USDtr2x2p.xlt   200 by 100 USDtr2x1p.xlt
300 by 300 USDtr3x3p.xlt   300 by 100 USDtr3x1p.xlt
400 by 400 USDtr4x4p.xlt   400 by 100 USDtr4x1p.xlt
500 by 500 USDtr5x5p.xlt   500 by 100 USDtr5x1p.xlt
600 by 600 USDtr6x6p.xlt   600 by 100 USDtr6x1p.xlt
800 by 800 USDtr8x8p.xlt   800 by 100 USDtr8x1p.xlt
800 by 1200 USDtr8x12p.xlt  
1200 by 1200 USDtr12x12p.xlt   1200 by 100 USDtr12x1p.xlt
1600 by 1600 USDtr16x16p.xlt   1600 by 100 USDtr16x1p.xlt
2000 by 2000 USDtr20x20p.xlt   2000 by 100 USDtr20x1p.xlt
2500 by 500 USDtr25x5p.xlt  
2500 by 2500 USDtr25x25p.xlt   2500 by 100 USDtr25x1p.xlt
4000 by 4000 USDtr40x40p.xlt  
PAST VERSION INFORMATION

Version dtr0002o (01/31/2013)

This update supports the decrease in the ERS fee rate from 0.0125 to 0.00625 that goes into effect starting with the January 2013 tax period. This version can also be used for tax periods prior to January 2013.

Version dtr0002n (07/26/2012)

This update supports the increase in the ERS fee rate from 0.00625 to 0.009375 that goes into effect starting with the July 2012 tax period. This update also supports the future ERS fee increase from the July 2012 rate of 0.009375 to the new August 2012 rate of 0.0125 . The 0.0125 rate will start with the August 2012 return, due September 2012. This version can also be used for tax periods prior to July 2012.

Version dtr0002m (01/12/2012)

This update supports the decrease in the ERS fee rate from 0.0125 to 0.00625 that goes into effect starting with the January 2012 tax period. This version can also be used for tax periods prior to January 2012.

Version dtr0002l (01/27/2010)

This update supports the increase in the ERS fee rate from 0.009375 to 0.0125 that goes into effect starting with the March 2010 tax period. This version can also be used for tax periods prior to March 2010.

Version dtr0002k (12/14/2009)

This update supports the increase in the ERS fee rate from 0.00625 to 0.009375 that goes into effect starting with the December 2009 tax period.

Version dtr0002j (08/01/2009)

Mode Dyed Adjustments(DA) has been added. XLS and EDI checks have been updated accordingly. Distributors need to download the newest version to use, for checking their returns before uploading to the fuel tracking system.Downloading is required.


______________________________
Copyright © 1999-2021
Colorado Department of Revenue and
Explore Information Services, LLC
All rights reserved.