Payroll 2.0

How Does Sage 100 Payroll Count Active Employees?

May 16, 2020 by Wayne Schulz

The Sage 100 payroll subscription is priced annually based upon the number of active employees. Since August 1, 2017, there have been two tier schedules depending upon whether you are a new or existing ( purchased before April 2016 ) user of payroll.

The on-going price paid for a payroll subscription is based upon the number of active employees paid by your company.

Here is Sage’s definition of an active employee via their knowledgebase.

Tier Count Calculation

The tax calculation process is what populates the SY_Metering.m4t table.

It does not matter if you have printed or updated checks.

If they were in payroll when the tax calculation was run they count. If payroll data entry was cleared after-tax calculation was run, they were already counted.

The count is cleared on the first of every month and starts over.

Each employee is counted once based on their encrypted EmployeeKey$. No matter how many times you pay that employee in a month they are only counted once. The tier limit counts all Company Codes in the installation for that account. Usually, test companies are a copy of live data so it does not increase unless new employees are added to that company code.

The messages you receive depend on the timing and status below.

You are given a grace period of 45 days after you first exceed your tier count limit.
In the 45 days grace period, you are allowed to exceed the 100 until the expire date.
After the expiration date, you are able to continue to perform tax calculation for your tier limit.

Once the unique employee ID’s reach the tier count, tax calculation will be unable to perform tax calculation.

There are 2 solutions:

Remove extra employees in Payroll Data Entry.
Contact the sales team to purchase a higher tier.

FAQ: Emergency Paid Sick Leave and Emergency Family Medical Leave associated with the HR_6201 – Families First Coronavirus Response Act (FFCRA) in Sage 100

April 9, 2020 by Wayne Schulz

Sage has released a four-page document answering the most frequently asked questions about the Emergency Paid Sick Leave and Emergency Family Medical Leave rules associated with HR 6201.

This short guide provides additional information on how to set up Sage 100 Payroll 2.20.x to function properly with the next earnings codes.

For a full copy of the FAQ visit the Sage Knowledgebase here and scroll to the bottom and select FAQ FFCRA for Sage 100.pdf.

Sage 100 Payroll 2.20 Download Links ( Including Hot-Fixes )

December 24, 2019 by Wayne Schulz

Sage just released Sage 100 Payroll 2.20 which includes important updates required for your first payroll of 2020.

Note: You’ll be able to see these new filing statuses in Employee maintenance after installing the payroll tax update that will be released in mid-December, 2019.

However, the withholding tax will not calculate correctly until you have upgraded to Sage 100 Payroll 2.20.

HH1 — Head of Household 2020 or Later
HH2 — Head of Household 2020 Ckbx (checkbox) 2c
MJ1 — Married FJ (filing jointly) 2020 or Later
MJ2 — Married FJ 2020 Ckbx 2c
NR1 — NR (nonresident) Alien 2020 or Later
NR2 — NR Alien 2020 Ckbx 2c
S1 — Single 2020 or Later
S2 — Single 2020 Ckbx 2c

Sage 100 Payroll 2.20 Upgrade Links

Documentation:
Sage 100 Payroll 2.20 Tax Tables 12/24/2019 – Read What’s New

Sage 100 Product Documentation – Visit Website

Downloads:

Sage 100 Payroll 2.20 – Download Link

You do NOT need to upgrade your core Sage 100 2018 or 2019 modules. The payroll update installs independently of core modules.

Tax Table Updates:

These are all delivered over the web. To install a tax table update follow these instructions:

To verify whether you have the latest tax update installed:

Select Payroll > Utilities > Payroll Tax Update.
Click Proceed to download and install the latest tax update.
To access this task, the Allow Payroll Tax Update security event check box must be selected for your role in Role Maintenance. Select Payroll > Utilities > Payroll Tax Update.

Download and apply these hotfixes:

Payroll 2.20.0 Program Fix PR6016T – Download
Tax Calculation—A New Property is Required (-10424) For New Jersey Employee Disability Capped Wages to calculate correctly. Note: Install Payroll Tax Table dated 12/24/2019 as well in order to calculate properly.

Payroll 2.20.0 Program Fix PR 6017T – Download
This addresses an issue where Social Security wages and taxes are not calculating for new tax profiles after installing Sage 100 Payroll 2.20 and the Tax Update deployed 12/12/2019.

Payroll 2.20.0 Program Fix PR6018T– Download
When renumbering employees from one department to another and using an alpha character in the department code (i.e., A1, A2, 3C, 4F, etc) a message will pop-up: 3C is not numeric.

Payroll 2.20.0 Program Fix PR6019T– Download
NJ Family Leave Insurance tax do not pull into boxes 18 and 19 on W2 form.

Sage 100 Payroll 2.20.0 Program Fix PR6020T – Download

Employee Medicare rate is missing on the Quarterly Tax Report which causes the employee Calculated Medicare Taxes to calculate incorrectly
Error: ” No tax drill down records are found.” occurs when drilling down into Employee Other Taxes in some scenarios
Ohio local taxes and wages are not appearing on W-2 boxes 18 and 19 or combined with other local taxes

Resolves the following issues:

Open Reported Issues:

Renumbering Employees ( RESOLVED WITH PR6018T – link above )
Payroll 2.20 may prevent renumbering an employee from one department to another with the error ” the employee number already exists in department xx”

Payroll 2.20 Quarterly Tax Report Missing Employee Medicare Tax Rate ( INFORMATIONAL ONLY ) – Engineering is currently reviewing. This does not affect the calculation; it is calculating correctly at the 1.45%. It is just showing 0.00% under Tax Rates – Link

Sage 100cloud Payroll 2.1x Over Withholding for Checks Dated 12/31/2019

December 17, 2019 by Wayne Schulz

We have seen multiple reports from Sage 100 Payroll users where a payroll check dated on 12/31/2019 via Sage 100cloud Payroll 2.1x has too much federal tax withholding.

UPDATE: Sage has published a hot-fix for Payroll versions 2.19.4 and 2.20

In some cases, reports have mentioned federal income tax withholding that is $100 or more than the prior payroll check.

Sage has an issue report on this which they documented as:

Tax Calculation – New W4 Dependent Amt, Other Income & Deductions Values not pulled into Calculation when check date is 12/31/2019 or 01/01/2020

Federal tax withheld changes on checks dated 12/31/2019 or 01/01/2020

Federal tax calculation amount is wrong on checks dated 12/31/2019 or 01/01/2020

W-4 exemptions are ignored when generating payroll check dated 12/31/2019 or 01/01/2020

According to this knowledgebase entry, expect a hot-fix to be issued around the same time as Sage releases Payroll 2.20 which is expected on or about December 19, 2019.

These Are The Supported Versions of Sage 100cloud As of October 1, 2019

September 30, 2019 by Wayne Schulz

As of October 1, 2019 the following Sage 100cloud versions are eligible for support directly from Sage.

Depending upon the Sage 100cloud version ( these dates also apply to the Sage 100 perpetual license) the level of support varies.

There Are Four Primary Types of Sage 100cloud Support:

Product Updates – Self-instlling bundle of fixes as well as some feature enhancements. These are typically issued on a regular basis throughought the year.

IRD – Interim Release Download – a special annual update which readies the verison of Sage 100cloud for year-end tax processing ( Accounts Payable and Payroll ) – expected release date mid-December 2019

Hot-Fixes – typically quick fixes which are issued urgently to fix a problem when the fix can’t wait until the next product update or when the version may not be eligible for product updates but is eligible for hot-fix.

Phone Support – the longest running support benefit is phone support which allows those with a Sage Business Care plan to call Sage directly.

The official Sage chart outlining the Sage 100cloud product versions which they suppport is available here.

Sage 100cloud Supported Versions – 10/1/2019

Product Updates, IRD, Hot-Fixes & Phone Support

Sage 100 2019

IRD, Hot-Fixes & Phone Support

Sage 100 2018

IRD & Phone Support

Sage 100 2017

If you are using Payroll with Sage 100cloud, this is the last year that Sage 100 2017 will be eligible for payroll updates coming into the 2019 year-end.

Users of the updated Payroll 2.x will want to update to version 2.2 ( expected mid-December 2019 release date ) which will be required for processing payroll taxes for 2019.

Schulz Consulting offers Sage 100cloud Support for one low fixed price. If requested, we can also price in an annual upgrade ( typically every other year ). Contact us here for more information.