Downloads

All-in-one resource for updates and forms.

COATSsql

COATSsql

COATSsql 15.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 15.0.1 is the latest version of COATSsql available and includes the enhancements listed in the What’s New document.

INSTRUCTIONS for installing Version 15.0.1

1. Update your COATSsql software.

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

SQLup1501.exe

1 file(s) 726.62 MB

2. Update your COATSsql data

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

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

2024 Tax Table Updates for COATSsql

1. Download and review the COATSsql tax update document.

Icon

2024_Tax_Update_SQL.pdf

1 file(s) 213.18 KB

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

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

Icon

Taxes_SQL_2024.exe

1 file(s) 176.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_2024.exe file.

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

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.

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.

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

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

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: