Blog Layout

What is Payroll Data Aggregation?

Points North • Jun 17, 2019

Employers often have to face complex issues regarding employee withholding taxes. This gets even more challenging when employees on their payroll, earn a mix of regular and non- standard income. 

What is Payroll Data Aggregation?
The non-standard income is known as supplemental wages and there are very strict rules regarding if the employer or the head of payroll can combine both types of withholding into an aggregate amount. This aggregate amount is then used for calculating the final withholding tax owed by the contractor or the employer.

Payroll Data Basics

The Internal Revenue Service (IRS) categorizes employee wages as regular wages and supplemental wages. Regular wages are any amount paid through standard methods like hourly income or monthly salary. Every other kind of payment falls in the category of supplemental wages. It can be in the form of lump-sum, commissions, or advances. 

Special payments covering vacations and illness are also categorized as supplemental wages. For this type of withholding, they can either opt for the aggregate method or a flat rate of 25%. In the aggregate method, the employers can pay taxes on both supplemental and regular wages at the rate specified for the regular wages.

Payroll Data Calculations

For calculating the withholding via the aggregate withholding method, the employer or the head of payroll needs to aggregate the payroll data. Then the tax rate for regular wages is used to calculate the total amount of withholding tax. The rate being used for this calculation is specified by the employee’s W-4

The head of payroll or the employer then subtracts any tax amount which was previously deducted as withholding from the regular wages. And the rest is subtracted from the supplemental wages.

Payroll Data Required Use

Sometimes it becomes necessary that employers use the aggregate method rather than the flat-rate method. This happens if the employer failed to deduct withholding tax from the employee’s regular wages in the last fiscal year. It also becomes necessary if the payroll department of the company doesn’t separate the supplemental and regular payments. 

The utilization of the aggregate method also depends on whether the employee received the regular wages and supplemental wages as separate payments or they received them together.

Common Scenarios

The IRS has specified 9 common scenarios for reducing confusion and helping employers regarding the calculation of their withholding taxes in an easy and accurate way. If the employee receives only semimonthly advances against future commissions, monthly commissions, or irregular commissions exceeding $1000 then the head of payroll must use the aggregate method. And if the supplemental wages were given in the form of severance pay, termination payoff, signing bonuses, lump-sum, sick pay, or vacation pay then the employer and the head of payroll is free to choose between the flat-rate method and the aggregate method.
     
Payroll Data Aggregation can be a very challenging task especially if you have multiple payroll systems and locations. If you are facing problems regarding this and need professional help then you should contact Who’sWhere, a division of Points North. We specialize in providing innovative and smart solutions for ACA compliance, certified payroll compliance, and workforce reporting.
By Points North 26 Jun, 2020
Once employers have familiarized themselves with the ACA obligations, they should also know of the penalties associated with non-compliance. Identifying and paying for full-time employees is fairly easy because of the straightforward details of their job but for variable hour employees’, it is not as simple. Some organizations make use of the ‘limiting’ strategy to manage such schedules but this strategy as its own set of problems. Problems such as workforce scheduling and variable labor requirements are factors that make this strategy impracticable. We’ve combined some of the best ways to ensure ACA compliance in this article and examined how ‘guidance’ can help you limit penalties.
By Points North 14 Jan, 2020
The new year brings new policies and regulations, so it's important to do a comprehensive review and update of your legal and HR compliance to make sure that you're on top of any new laws and regulations. Begin 2020 on the right foot, with the knowledge you'll need to answer any questions from corporate leadership, supervisors, and employees. Here's what you need to know.
By Brad Smith 03 Oct, 2019
Though federal rules from the Department of Labor (DOL) give employers some flexibility in determining when to issue final compensation to workers leaving an organization, final paycheck compliance laws differ from state to state, and those rules also change periodically.
ACA Reporting Is Required and Strictly Enforced by IRS
By Brad Smith 06 Sep, 2019
As the fiscal year closes the employers have many queries regarding the status of the Affordable Care Act (ACA) Reporting. It is questioned every time the tax filing season looms. The answer to all these queries is that Yes! ACA is still the law and employers who tend to ignore their obligations towards ACA reporting can face some heavy penalties.
By Brad Smith 29 Aug, 2019
When your company starts growing it means more success but it also means more responsibility. Once your company grows beyond a certain point, the US government requires you to submit additional information regarding your company being an equal opportunity employer.
Looking for a solution to data aggregation?
By Points North 02 Aug, 2019
It is important to choose a reliable and secure data aggregation solution which provides you with the best data. If you manage to get financial data which is cleaned and enriched then you can make accurate assessments of the financial situation of your customers. Following are some of the things which you should look for while choosing a solution to data aggregation.
Handling compliance with the Affordable Care Act
By Points North 09 Jul, 2019
Handling compliance with the Affordable Care Act - If you're the one in charge for handling compliance with the Affordable Care Act (ACA) reporting and audits then read on; those who aren’t compliant will face penalties from the IRS.
Common IRS Error Codes
By Points North 01 Jul, 2019
Due to the complexity of the process, utilizing a reputable software vendor to file your 1094/1095 data electronically with the IRS is considered to be a best practice. One reason for this is that if it turns out that there’s a problem with some of your ACA data, the IRS doesn’t necessarily make it easy to figure out what went wrong.
Are all employers required to e-File with the IRS?
By Points North 31 May, 2019
We are dedicated to helping our clients navigate the complexity of ACA and employee eligibility reporting. Below you will find information regarding whether or not all employers are required to e-File with the IRS.
ACA Update – More Certainty for the Years Ahead
By Points North 14 May, 2019
The past few years have brought forth a great deal of uncertainty surrounding the Affordable Care Act. The topic of ‘repeal and replace’ was front and center during the 2016 presidential and congressional elections, and 2017 saw several attempts at repeal, none of which were ultimately successfully at scrapping the law in its entirety.
More Posts
Share by: