Downloads

All-in-one resource for updates and forms.

COATSsql

COATSsql

COATSsql 16.0.1

Please review all information on this page prior to installing and updating your COATS system. Ensure you have all your data backed up. Version 16.0.1 is the latest version of COATSsql available and includes the enhancements listed in the What’s New document.

Yearly Summary What's New

INSTRUCTIONS for installing Version 16.0.1

1. Update your COATSsql software.

  • Ensure version 4.3.8 or greater is installed prior to upgrading to 16.0.1. If your COATSsql version number is less than 4.3.8, you can download and install version 4.3.8 from the linked page.
  • Download “sqlup1601.exe” and store it in your TEMP folder.
  • Locate the TEMP folder on your computer and double-click the sqlup1601.exe file.
  • Extract the file to your COATS folder (i.e. C:\Program Files\COATS\COATS2000) on any computer currently running version 4.3.8 or greater to update.
Icon

SQLup1601.exe

1 file(s) 729.61 MB

2. Update your COATSsql data

  • If you use SQL Server 2014 or higher and are on COATSsql Version 16.0.0 or higher, update your COATSsql data following the instructions in this document:
  • If you use SQL Server 2014 or higher and are on COATSsql Version 4.3.8 through 16.0.0, update your COATSsql data following the instructions in this document:

*** B R E A K I N G   N E W S  ***

Microsoft no longer supports SQL Server 2008 and SQL Server 2012. We are advising our clients that COATSsql is no longer able to support SQL Server 2008 and SQL Server 2012. as a minimum hardware requirement.  Contact COATS Technical Support at 1-800-888-5894 with any questions.

COATSsql REQUIRES .NET Framework 4.5.1.

3. Update your COATSsql tax tables.

See below to access the COATSsql Tax Table Update page.

Whitepapers

Important White Papers are available for your review:

The important White Papers listed below contain valuable information regarding your COATSsql software and should be reviewed thoroughly.

COATSsql 16.0.0
COATSsql 13.0.0
COATSsql 12.0.0
Icon

Adjust_VFP_SQL_2023.pdf

1 file(s) 118.14 KB
COATSsql 10.0.0
Icon
Login is required to access this page
COATSsql 8.3.0
COATSsql 8.0.0
Icon

Adjust_VFP_SQL_2020.pdf

1 file(s) 72.23 KB
Login is required to access this page
COATSsql 7.15.0
Icon

Federal_941_2ndQtr2020_SQL.pdf

1 file(s) 142.79 KB
Login is required to access this page
COATSsql 7.11.4
Icon

SQL_Client_EMPL.pdf

1 file(s) 125.52 KB
Login is required to access this page
Icon

SQL_Employee_W4_Data.pdf

1 file(s) 167.53 KB
Login is required to access this page
COATSsql 7.11.3
Icon

SQL_W4_Federal_Tax_Codes_2020.pdf

1 file(s) 134.16 KB
Login is required to access this page
COATSsql 7.11.2
Icon

Quarterly_Reports_SQL.pdf

1 file(s) 861.53 KB
Login is required to access this page
Icon

Year_End_Processing_sql.pdf

1 file(s) 789.13 KB
Login is required to access this page
COATSsql 7.11.0
Icon

Adjust_VFP_sql_2019.pdf

1 file(s) 117.88 KB
Login is required to access this page
Icon
Login is required to access this page
Icon

HSA_setup_7_11_0.pdf

1 file(s) 0
Login is required to access this page
Icon

SCorp Owner Health Insurance

1 file(s) 9.85 KB
Login is required to access this page
Icon

SQL_W4_Federal_Tax_Codes_2020.pdf

1 file(s) 134.16 KB
Login is required to access this page
Icon

Year_End_Processing_sql.pdf

1 file(s) 789.13 KB
Login is required to access this page
COATSsql 7.8.0
Icon

Handling_Paycards_SQL.pdf

1 file(s) 185.45 KB
Login is required to access this page
COATSsql 7.2.0
Icon

Essential_Staffcare.pdf

1 file(s) 289.46 KB
Login is required to access this page
COATSsql 7.0.9
Icon

ACA 1094c XML Export_709.pdf

1 file(s) 979.75 KB
Login is required to access this page
COATSsql 7.0.0
Icon

Adjust_VFP_sql_2019.pdf

1 file(s) 117.88 KB
Login is required to access this page
Icon

SCorp Owner Health Insurance

1 file(s) 9.85 KB
Login is required to access this page
COATSsql 6.1.3
Icon

ACA Tools w Index SQL.pdf

1 file(s) 768.08 KB
Login is required to access this page
Icon

ACA_Yearend_SQL.pdf

1 file(s) 1.23 MB
Login is required to access this page
Icon

ACA 1094c XML Export.pdf

1 file(s) 957.92 KB
Login is required to access this page
COATSsql 6.1.1
Icon

Year_End_Processing_sql.pdf

1 file(s) 789.13 KB
Login is required to access this page
Icon

SCorp Owner Health Insurance

1 file(s) 9.85 KB
Login is required to access this page
COATSsql 6.1.0
Icon

ACA Tools w Index SQL.pdf

1 file(s) 768.08 KB
Login is required to access this page
Icon

ACA_Yearend_SQL.pdf

1 file(s) 1.23 MB
Login is required to access this page
Icon

1099s through A/P

1 file(s) 0.00 KB
Login is required to access this page
Icon
Login is required to access this page
Icon

SCorp Owner Health Insurance

1 file(s) 9.85 KB
Login is required to access this page
Icon

Sick Pay Stubs

1 file(s) 153.80 KB
Login is required to access this page
Icon

Year_End_Processing_sql.pdf

1 file(s) 789.13 KB
Login is required to access this page
COATSsql 6.0.4
Icon

Quarterly_Reports_SQL.pdf

1 file(s) 861.53 KB
Login is required to access this page
COATSsql 6.0.1
Icon

ACA 1094c XML Export.pdf

1 file(s) 957.92 KB
Login is required to access this page
COATSsql 6.0.0
Icon

ACA Tools w Index SQL.pdf

1 file(s) 768.08 KB
Login is required to access this page
Icon

ACA_Yearend_SQL.pdf

1 file(s) 1.23 MB
Login is required to access this page
Icon

1099s through A/P

1 file(s) 0.00 KB
Login is required to access this page
Icon

SCorp Owner Health Insurance

1 file(s) 9.85 KB
Login is required to access this page
Icon
Login is required to access this page
Icon

Sick Pay Stubs

1 file(s) 153.80 KB
Login is required to access this page
COATSsql 5.0.0
Icon
Login is required to access this page
Icon

ACA_Yearend_SQL.pdf

1 file(s) 1.23 MB
Login is required to access this page
Icon

ACA 1094c XML Export.pdf

1 file(s) 957.92 KB
Login is required to access this page
Icon

ACA Tools w Index SQL.pdf

1 file(s) 768.08 KB
Login is required to access this page
COATSsql 4.8.0
Icon

Resume Parsing 4.8.0

1 file(s) 1.06 MB
Login is required to access this page
Icon

1099s through A/P

1 file(s) 0.00 KB
Login is required to access this page
Icon

ACA_Yearend_SQL.pdf

1 file(s) 1.23 MB
Login is required to access this page
Icon

ACA Tools w Index SQL.pdf

1 file(s) 768.08 KB
Login is required to access this page
Icon

Essential_Staffcare.pdf

1 file(s) 289.46 KB
Login is required to access this page
Icon
Login is required to access this page
Icon

SCorp Owner Health Insurance

1 file(s) 9.85 KB
Login is required to access this page
Icon

Sick Pay Stubs

1 file(s) 153.80 KB
Login is required to access this page
Icon
Login is required to access this page
Icon

Year_End_Processing_sql.pdf

1 file(s) 789.13 KB
Login is required to access this page
COATSsql 4.7.4
Icon

ACA Tools w Index SQL.pdf

1 file(s) 768.08 KB
Login is required to access this page
COATSsql 4.7.0
Icon

Essential_Staffcare.pdf

1 file(s) 289.46 KB
Login is required to access this page
Icon

Quarterly Reports

1 file(s) 691.53 KB
Login is required to access this page
Icon

ACA Tools w Index SQL.pdf

1 file(s) 768.08 KB
Login is required to access this page
Icon

Resume Parsing 4.8.0

1 file(s) 1.06 MB
Login is required to access this page
COATSsql 4.6.8
Icon

ACA Tools w Index.pdf

1 file(s) 504.34 KB
Login is required to access this page
Icon

SCorp Owner Health Insurance

1 file(s) 9.85 KB
Login is required to access this page
COATSsql 4.6.5
Icon

Essential_Staffcare.pdf

1 file(s) 289.46 KB
Login is required to access this page
Icon

1099s through A/P

1 file(s) 0.00 KB
Login is required to access this page
Icon
Login is required to access this page
Icon

SCorp Owner Health Insurance

1 file(s) 9.85 KB
Login is required to access this page
Icon

Sick Pay Stubs

1 file(s) 153.80 KB
Login is required to access this page
Icon

Updating FUTA & SUTA Rates SQL

1 file(s) 0.00 KB
Login is required to access this page
Icon
Login is required to access this page
Icon

Year_End_Processing_sql.pdf

1 file(s) 789.13 KB
Login is required to access this page
COATSsql 4.6.4
Icon
Login is required to access this page
COATSsql 4.5.2
Icon

Client_Assignment_Review.pdf

1 file(s) 185.39 KB
Login is required to access this page
Icon

MarkupPercentageUpdate

1 file(s) 122.66 KB
Login is required to access this page
COATSsql 4.5.0
Icon

Quarterly Reports

1 file(s) 691.53 KB
Login is required to access this page
COATSsql 4.4.7
Icon

Year_End_Processing_sql.pdf

1 file(s) 789.13 KB
Login is required to access this page
COATSsql 4.4.5
Icon

1099s through A/P

1 file(s) 0.00 KB
Login is required to access this page
Icon
Login is required to access this page
Icon

Quarterly Reports

1 file(s) 691.53 KB
Login is required to access this page
Icon

Updating FUTA & SUTA Rates SQL

1 file(s) 0.00 KB
Login is required to access this page
Icon
Login is required to access this page
COATSsql 4.3.19
Icon

ACA Notification

1 file(s) 111 KB
COATSsql 4.3.16
Icon
Login is required to access this page
Icon
Login is required to access this page
Icon

Quarterly Reports

1 file(s) 691.53 KB
Login is required to access this page
COATSsql 4.3.14
COATSsql 4.3.13
Icon
Login is required to access this page
COATSsql 4.3.11
COATSsql 4.3.8
Icon
Login is required to access this page
Icon
Login is required to access this page
Icon
Login is required to access this page
Icon

Quarterly Reports

1 file(s) 691.53 KB
Login is required to access this page
Icon
Login is required to access this page
Icon

Year_End_Processing_sql.pdf

1 file(s) 789.13 KB
Login is required to access this page
Tax Tables

2025 Tax Table Updates for COATSsql

Please note that the website will be updated as states implement changes to their regulations.

1. Download and review the COATSsql tax update document.

Icon

2025_Tax_Update_Sql.pdf

1 file(s) 216.27 KB

2. COATSsql Version 16.0.0 is a required update for 2025. Please CLICK HERE if you do not have version 16.0.0.

3. Download and install the .exe file below to update your 2025 tax tables:

Icon

Taxes_SQL_2025.exe

1 file(s) 168.00 KB

Please be sure you are not running or working in COATSsql while performing this update.

Locate the TEMP folder on your computer and double-click the Taxes_SQL_2025.exe file.

Extract the file to c:\COATS_Taxes_SQL_2025. This is the default folder used.

4.  Click here to view the Special Tax Considerations page.

5. Remember to manually update your FUTA and SUTA rates as necessary.

IRS and STATE rules change FREQUENTLY. Consult your tax adviser for their assistance.

Special Tax Considerations

Some states have special or new considerations regarding their tax tables. Check below to see if your state was affected.

AZ

Arizona has an update to their state withholdings. Please follow the steps below to update employees tax codes for 2023.  No changes in 2024.

CA
CT

In Connecticut, Paid Family Leave Insurance is to be withheld from employees’ paychecks. Update to your local tax table will need to be made accommodate this requirement.

CO

In Colorado, Paid Family Leave Insurance is to be withheld from employees’ paychecks. Update to your local tax table will need to be made accommodate this requirement.

IA

Iowa has altered the taxes and new codes and steps have been created.  This change started in 2024 and altered in 2025.  Both of these years will require an updated W4 needed from Employee.

Icon

IA_Tax_Codes_2025.pdf

1 file(s) 13.14 KB
MD

Maryland has update to their locality withholdings. Please follow the steps below to update employees tax codes for 2025.

Icon

MD_Tax_Codes_2025.pdf

1 file(s) 62.71 KB
MA

In Massachusetts, Paid Family Leave Insurance is to be withheld from employees’ paychecks. Update to your local tax table will need to be made accommodate this requirement.

NJ

In New Jersey, Disability Insurance & Family Leave Insurance are withheld from employees’ paychecks. Changes will need to be made in your local tax table to accommodate this change.

NY

In New York, Paid Family Leave Insurance rate has changed for 2025.

If you withhold Yonkers (NY) taxes from employees, install these codes to your local tax table to accommodate changes for 2022.

Icon

Visual_Updating_NY_LOCAL_2022.pdf

1 file(s) 125.79 KB
Login is required to access this page
OR

In Oregon, Paid Family Leave Insurance is to be withheld from employees’ paychecks. Update to your local tax table will need to be made accommodate this requirement.

WA

In Washington, Paid Family Leave Insurance is to be withheld from employees’ paychecks.  Washington has a new WACares Fund, which is on hold until Mid 2023. Update to your local tax table will need to be made to accommodate for these requirements.

National
Icon
Login is required to access this page

The download links listed below will take you to the files available for download, categorized by product and need. These pages are updated regularly so the information will be current.

COATS Visual

COATSsql

COATS Standard

Tax Table Updates

Special State Tax Considerations

Need a little more help? Contact our tech support team.

Receive Software Update Notifications

Visual Users:

SQL Users: