Coronavirus Disease 2019 (COVID-19) in Colorado: State & National Resources

Sales Tax - Spreadsheet Filing

The Department allows retailers with two or more sites (locations) to file electronically using an approved Microsoft Excel spreadsheet if you do not already use an Approved Sales Tax Software Vendor. This spreadsheet service is available as part of Revenue Online. After approval, Excel spreadsheets must be uploaded through Revenue Online. A sample spreadsheet must be reviewed and approved by the Department before a business can file using Excel.

Changes for 2020

The spreadsheet has changed for 2020 due to Colorado sales tax law and the subsequent tax form changes. The 2020 template has different columns than the older version. As a result, the older version cannot be used for 2020 returns.  However, if a return needs to be filed for a period before 2020, please use the older version.  On the 2020 template, there is an additional worksheet for the state service fee, which now has a cap of $1,000.00 for each filing period.  The service worksheet will provide your payment amount.
 
You can use the document “How to Add Location Account Numbers to a Sales Return Spreadsheet” on this page to prepare your new spreadsheet. It provides step-by-step directions for how to prepare the new version of the sales tax spreadsheet. If you have questions or concerns, please email dor_locationfilers@state.co.us.

Spreadsheet Templates

Handbook & Instructions

How to Become an Approved Spreadsheet Filer

For instructions on how to become an approved filer, review the Spreadsheet Filing Handbook (updated January 24, 2020).

How to Add Location Account Numbers to a Sales Tax Return

How to Add Location Account Numbers to a Sales Return Spreadsheet Instructions (Printable PDF)

Can't see this video? Click here.