Skip to main content
Excel workbook
The use of this workbook tool has declined considerably since it was implemented. On June 30, 2024, the Excel Workbook will be discontinued. The workbook will not be updated after Quarter 4, 2023. Additional sales and use tax tools are available online.
A downloadable tax calculator workbook using Microsoft Excel that displays tax rates and location codes, calculates totals, and summarizes sales by city or county without an online connection. This Excel Workbook may be used to upload local sales tax data to e-file, or the local sales tax data may be printed and attached to your paper tax return.
Note: The workbook does not include location codes and rates for sales or leases of motor vehicles and sales of lodging.
2023
- Quarter 4 (Oct 1 - Dec 31)
- Quarter 3 (July 1 - Sept 30)
- Quarter 2 (April 1 - Jun 30)
- Quarter 1 (Jan 1 - Mar 31)
2022
- Quarter 4 (Oct 1 - Dec 31)
- Quarter 3 (July 1 - Sept 30)
- Quarter 2 (Apr 1 - Jun 30)
- Quarter 1 (Jan 1 - Mar 31)
2021
- Quarter 4 (Oct 1 - Dec 31)
- Quarter 3 (July 1 - Sept 30)
- Quarter 2 (Apr 1 - Jun 30)
- Quarter 1 (Jan 1 - Mar 31)
2020
- Quarter 4 (Oct 1 - Dec 31)
- Quarter 3 (July 1 - Sept 30)
- Quarter 2 (Apr 1 - Jun 30)
- Quarter 1 (Jan 1 - Mar 31)
2019
- Quarter 4 (Oct 1 - Dec 31)
- Quarter 3 (July 1 - Sept 30)
- Quarter 2 (Apr 1 - Jun 30)
- Quarter 1 (Jan 1 - Mar 31)
2018
- Quarter 4 (Oct 1 - Dec 31)
- Quarter 3 (July 1 - Sept 30)
- Quarter 2 (Apr 1 - Jun 30)
- Quarter 1 (Jan 1 - Mar 31)
