Calculators and Sample Spreadsheets

CALCULATORS
The interest calculators are intended to be used to estimate the amount of interest and/or total tax plus interest owed based on the tax type selected and dollar value(s) entered. The tax type can be changed using the dropdown menu and the values should be entered as positive numbers. When opening these calculators, please click “Enable Content” for the fields to pre-populate.
Note: These calculators are strictly for use on a PC. They are not Mac compatible.

microsoft-excel-icon-25 Annual Interest Calculator

microsoft-excel-icon-25 Monthly Interest Calculator

microsoft-excel-icon-25 Quarterly Interest Calculator

 

 

SAMPLE SPREADSHEETS

Applicants approved for a tax type that is due on a monthly or quarterly basis should submit spreadsheets in lieu of actual returns for periods filed under the amnesty program. These sample spreadsheet formats include all the information typically found on the return, and are provided as guidance only in order to assist in preparing your own spreadsheets. Some fields, such as the tax rate, should be changed to correspond with the appropriate tax type. State administered local sales and use tax rates may be found here.

microsoft-excel-icon-25 Withholding Sample Spreadsheet

microsoft-excel-icon-25 County Sample SLU Spreadsheet

microsoft-excel-icon-25 State Sample Sellers Use Spreadsheet

microsoft-excel-icon-25 City Sample SLU Spreadsheet