Downloads

All-in-one resource for updates and forms.

COATSsql

COATSsql 11.0.0

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

INSTRUCTIONS for installing Version 11.0.0

1. Update your COATSsql software.

  • Ensure version 4.3.8 or greater is installed prior to upgrading to 11.0.0. 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 “sqlup1100.exe” and store it in your TEMP folder.
  • Locate the TEMP folder on your computer and double-click the sqlup1100.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

SQLup1100.exe

1 file(s) 716.89 MB

2. Update your COATSsql data

  • If you use SQL Server 2014 or higher and are on COATSsql Version 10.5.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 10.5.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.

Last updated February 21, 2022

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 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

SUTA_FUTA_Changes_sql

1 file(s) 95.55 KB
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
Icon

SUTA_FUTA_Changes_sql

1 file(s) 95.55 KB
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

2022 Tax Table Updates for COATSsql

1. Download and review the COATSsql tax update document.

Icon

2022_Tax_Update_Sql.pdf

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

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

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

Icon

Taxes_SQL_2022.exe

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

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_2022.exe file.

Extract the file to c:\COATS_Taxes_SQL_2022. 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.

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

CA
Icon

Visual_Updating_CADI_2022.pdf

1 file(s) 115.01 KB
Login is required to access this page
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.

Icon

Visual_Updating_CTPL_2022.pdf

1 file(s) 114.35 KB
Login is required to access this page
MD

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

Icon

MD_Tax_Code_Changes_2022.pdf

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

MD_Tax_Codes_2022.pdf

1 file(s) 118.90 KB
Login is required to access this page
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.

Icon

Visual_Updating_MAPL_2022.pdf

1 file(s) 118.90 KB
Login is required to access this page
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.

Icon

Visual_Updating_NJDI_FL_2021.pdf

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

Visual_Updating_NJ_UI_2022.pdf

1 file(s) 116.49 KB
Login is required to access this page
NY

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

Icon

Visual_Updating_NYPL_2022.pdf

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

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

Icon

Visual_Updating_NY_LOCAL_2022.pdf

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

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

Icon

Visual_Updating_WAPL_2022.pdf

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

Visual_Updating_WACF_2021.pdf

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

SUTA_FUTA_Changes_Visual.pdf

1 file(s) 16.17 KB
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

Vacation / Sick Calculator Update

Multi-Deduction Processor

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

Receive Software Update Notifications

Visual Users:

SQL Users:

Standard Users: