Employee Retention Credit Worksheet

COVID-19’s pandemic caused unimaginable hardships to many organizations and businesses around the globe. Many employers have faced reduced revenues, increased expenses, and disrupted operations due to lockdowns, social distancing, and health and safety measures.

To help employers retain their employees and provide them with health benefits during this difficult time, the U.S. government has introduced the Employee Retention Credit (ERC), a refundable tax credit that can offset some of the payroll costs for eligible employers.

The ERC is a program that was introduced by the CARES Act of 2020. Subsequent legislation was passed in 2021 and in 2023 to extend and modify it. This article will explain what the ERC is, how it works, and how to claim it for different time periods and eligibility criteria.

For a brief reading of what the Employee Retention Credit or ERC is, take a look at this video from the YouTube channel “ERC Specialists”. You can also continue below to read an in-depth explanation of ERC.

What is the Employee Retention Credit? Employee Retention Credit Worksheet

The Employee Retention Credit (ERC) is a refundable tax credit for businesses and tax-exempt organizations that had employees and were affected by the COVID-19 pandemic. The ERC was created by the CARES Act in 2020 and was extended and modified by subsequent legislation in 2021 and 2023. The ERC encourages employers to maintain their workers and to provide health benefits to them during the crisis.

Main Features & Benefits

The credit is a percentage of wages and health insurance premiums paid by eligible employees. There are limits per employee, per quarter.
The percentage and limit will vary depending on when the credit is claimed. In 2020, 50% of the employees will be eligible for the credit, with a maximum limit of $5,000 per employee. For 2021, it is 70%. The limit is $7,000 per quarter per employee. In 2023, 70% of the employees will be eligible for the first two quarterly limits and 40% in the final two. The limit for each employee is $10,000. Employee Retention Credit Worksheet
The credit is fully refundable. If the amount of credit exceeds an employer’s liability for payroll tax, the excess will then be paid back to the employer.
Employers can claim this credit if they experienced a significant decrease in gross receipts due to an order from the government relating to COVID-19. Employers who are considered to be recovery startup businesses may also claim this credit, but only for 2023.
The credit can be claimed by filing an amended employment tax return (Form 941-X) or by reducing employment tax deposits in anticipation of the credit. Employers can request an advance payment by submitting Form 7200.

> > Click Here to Find Out if You are Eligible for ERC < <

Eligibility Criteria

To qualify for Employee Retention credit (ERC), employers must meet either of two main criteria.

A government order has suspended or halted the business or organization of an employer due to COVID-19 in a calendar year 2020 or 2021.
Employer’s gross receipts in a calendar quarter of 2020 or 2021 was less than 50% or 80% of the gross receipts in the same quarter in 2019.

The recovery startup rule also applies to businesses that began operating after February 14, 2020 and had average annual gross receipts not exceeding $1 million. These businesses may qualify for ERC regardless of revenue or business suspension.

Business Suspension

A government order can either suspend or fully suspend a company or organization if the following conditions are met:

The order limits commerce, travel, or group meetings due to COVID-19
The order has a direct impact on the operations of an organization or business
Order applies to any calendar year in 2020 or 21

Some examples of government orders that can cause a business suspension are:

Stay-athome orders restrict non-essential enterprises from operating
Businesses are restricted in their operating hours by curfews
Limits in capacity that restrict the number or clients that a business can serve
Travel restrictions or bans that impact the ability of an organization to transport goods and services

To determine whether an employer’s business was suspended fully or partially by a government directive, the employer must:

The order’s nature, scope, and impact on the business
The length, frequency, and timing of the order in relation to the quarters of the year.
The impact of an order on revenue and expenses

Revenue Decline

A business or organization is considered to have experienced a significant decline in gross receipts if:

The gross receipts from any quarter in 2020 is less than 50% its gross receipts from the same calendar quarter in 2019.
The gross receipts for any calendar quarter in 2021 were less than 80% of its gross receipts for the same quarter in 2019

Gross receipts are the total amount that a business or organization has received or accrued from all sources, during its annual accounting period. Gross receipts are:

Sales of goods and services
Interest, dividends rents royalties and annuities
Donations, contributions, grants and gifts Employee Retention Credit Worksheet
Membership fees and dues
Gross profits from trades and businesses

Employers must use the following formulas to calculate gross receipts and compare them between quarters.

The same method for accounting (cash-based or accrual-based) that was used to file the federal income Tax return for 2019
Use the same calendar quarters as it did for its federal employment tax return (Form 941 ) for 2019 and 2021/2022
The same sources reported on your federal income tax form for 2019

Recovery Startup Business

A startup that is in recovery can be defined as

Start any new business or occupation after February 15, 2019,
Has average annual gross receipts of no more than $1 million for the three-tax-year period ending with the tax year that precedes the calendar quarter for which the credit is determined

If a business is in recovery, it can still qualify for ERC even if the business has been suspended or its revenue has declined. Recovery Startup Businesses are still subject to some restrictions and special rules.

Maximum credit per quarter: $50,000
The credit is only available for wages paid in the third and fourth quarters of 2021
The credit has a cap of 250 million dollars for all startup businesses that are eligible.

> > Click Here to Find Out if You are Eligible for ERC < <

Credit Amount Calculation

ERC amounts and rules vary for different time periods and employers. The ERC’s main influences are:

How much an employer’s company was affected by the pandemic.
What number of employees did the employer have in 2019 and 2020/2021?
What the employer paid each employee for their health insurance and during the pandemic

The employer has to fill out some forms and send them to the IRS to claim the ERC. The forms must include the total amount paid by the employer to employees, their health insurance coverage and the reasons why they are eligible for the ERC. The IRS will then check the forms before giving the money to employers. The employer could use this money to pay health insurance for employees or to get refunds and credits for payroll taxes.

The ERC will not be available indefinitely. The ERC started in March 2020 and ends in September 2022. The employer is required to claim ERCs before they expire, or are no longer available. The employer also has to use the money wisely and not waste it. Employee Retention Credit Worksheet

The following information provides more details on the ERC credit and how it is calculated.

Time Period

The ERC was implemented, amended, or terminated by various laws in 2020. The amount of the credit varies according to the time period that it is applied for. The table below summarizes key differences and features of the ERCs for each time period:

Time Period	Law	Eligible Employers	Credit Rate	Qualified Wages
2020	CARES Act	Employers with business suspension or revenue decline of more than 50%	50% of qualified wages up to $10,000 per employee per year	Wages paid from March 13 to December 31, 2020
Q1-Q3 2021	CAA and ARPA	Employers with business suspension or revenue decline of more than 20%	70% of qualified wages up to $10,000 per employee per quarter	Wages paid from January 1 to September 30, 2021
Q3-Q4 2021 (Recovery Startup Business)	ARPA	Recovery startup businesses with average annual gross receipts of no more than $1 million,	70% of qualified wages up to $10,000 per employee per quarter (subject to a $50,000 cap per quarter),	Wages paid from July 1 to December 31, 2021,
Q4 2021 – Q3 2022 (Severely Financially Distressed Employer)	ARPA and IIJA	Employers with a revenue decline of more than 90%	70% of qualified wages up to $10,000 per employee per quarter	Wages paid from October 1, 2021, to September 30, 2022

Number of Employees

The number employed affects how wages are calculated and defined, as well as the health insurance premiums for eligible employees. A small employer or a large employer is determined by the number of employees who worked full-time (FTEs) in 2019 and the time period. The following table summarizes the thresholds and rules for determining the employer size for each time period:

Time Period	Small Employer Threshold	Large Employer Threshold
2020	Less than or equal to 100 FTEs in 2019	More than 100 FTEs in 2019
Q1-Q2 2021	Less than or equal to 500 FTEs in 2019	More than 500 FTEs in 2019
Q3-Q4 2021	Less than or equal to 500 FTEs in any calendar quarter in either calendar year beginning after December 31, 2019, and ending before July 1, 2021. If an employer did not have in either calendar year beginning after December 31, 2019, and ending before July 1, 2021, the employer is treated as a small eligible employer if it had less than or equal to 500 FTEs in any calendar quarter beginning after June 30, 2021. For recovery startup businesses, the employer size is irrelevant. For severely financially distressed employers, the employer size is irrelevant if the employer had a revenue decline of more than 90%. Otherwise, the same rules as Q1-Q2 2021 apply.	More than 500 FTEs in any calendar quarter in either calendar year beginning after December 31, 2019, and ending before July 1, 2021. If an employer did not exist in either calendar year beginning after December 31, 2019, and ending before July 1, 2021, the employer is treated as a large eligible employer if it had more than 500 FTEs in any calendar quarter beginning after June 30, 2021.

To count FTEs for a given year or quarter, an employer must use the following steps:

Count the number of employees who worked at least 30 hours per week (or at least 130 hours per month) for each month in the year or quarter
Add up the total hours worked by all other employees (who are not counted as FTEs) for each month in the year or quarter
Divide the total hours by120and round down to the nearest whole number
Add the number of FTEs from Step One and Step Three for each month in the year or quarter
Calculate the average number of FTEs by adding up the monthly totals and dividing by 12 (for a year) or 3 (for a quarter)

Qualified Wages and Health Insurance Costs

Qualified wages are wages paid to eligible employees during a period of business suspension or revenue decline. Qualified wage includes tips and bonuses, as well as severance, pays, sick leave payments, family leave payments and other types of compensation. Qualified wage also includes the cost of health insurance for eligible employees. This may include premiums, deductibles, co-pays, or co-insurance.

The employer size, the time period and the calculation of the qualified wage and health insurance cost will affect the calculation. The following table provides a summary of the rules for different scenarios. Employee Retention Credit Worksheet

Employer Size	Time Period	Qualified Wages and Health Insurance Costs	Example
Small	2020	All wages and health insurance costs paid to any employee, regardless of whether the employee worked or not	An employer with 80 FTEs in 2019 paid $8,000 in wages and $2,000 in health insurance costs to an employee in 2020. The employer had a revenue decline of more than 50% in Q2 2020. The qualified wages and health insurance costs for Q2 2020 are $10,000.
Small	Q1-Q3 2021	All wages and health insurance costs paid to any employee, regardless of whether the employee worked or not	An employer with 400 FTEs in 2019 paid $12,000 in wages and $3,000 in health insurance costs to an employee in Q1 2021. The employer had a revenue decline of more than 20% in Q1 2021. The qualified wages and health insurance costs for Q1 2021 are $15,000.
Small	Q3-Q4 2021 (Recovery Startup Business)	All wages and health insurance costs paid to any employee, regardless of whether the employee worked or not (subject to a $50,000 cap per quarter)	A recovery startup business that began operations in March 2020 paid $9,000 in wages and $1,000 in health insurance costs to an employee in Q3 2021. The business had average annual gross receipts of $800,000. The qualified wages and health insurance costs for Q3 2021 are $10,000.
Small	Q4 2021 – Q3 2022 (Severely Financially Distressed Employer)	All wages and health insurance costs paid to any employee, regardless of whether the employee worked or not	An employer with 600 FTEs in Q2 2019 paid $11,000 in wages and $4,000 in health insurance costs to an employee in Q4 2021. The employer had a revenue decline of more than 90% in Q4 2021. The qualified wages and health insurance costs for Q4 2021 are $15,000.
Large	2020	Wages and health insurance costs paid to an employee for the time that the employee did not work (up to the amount that the employee would have been paid for working an equivalent duration during the 30 days immediately preceding the period of economic hardship)	An employer with 120 FTEs in 2019 paid $10,000 in wages and $2,000 in health insurance costs to an employee who worked full-time (40 hours per week) in 2020. The employer had a business suspension due to a government order in April 2020. The employee did not work for two weeks in April 2020. The qualified wages and health insurance costs for April 2020 are $2,308 ($10,000 x2/52+$2,000 x2/52).
Large	Q1-Q3 2021	Wages and health insurance costs paid to an employee for the time that the employee did not work (up to the amount that the employee would have been paid for working an equivalent duration during the 90 days immediately preceding the period of economic hardship)	An employer with 550 FTEs in 2019 paid $15,000 in wages and $5,000 in health insurance costs to an employee who worked full-time (40 hours per week) in Q1 2021. The employer had a revenue decline of more than 20% in Q1 2021. The employee did not work for three weeks in Q1 2021. The qualified wages and health insurance costs for Q1 2021 are $5,769 ($15,000 x3/13+$5,000 x3/13).
Large	Q3-Q4 2021 (Severely Financially Distressed Employer)	All wages and health insurance costs paid to any employee, regardless of whether the employee worked or not (only if the employer had a revenue decline of more than 90%. Otherwise, the same rules as Q1-Q32021 apply.)	An employer with 700 FTEs in Q4 2019 paid $12,000 in wages and $6,000 in health insurance costs to an employee who worked full-time (40 hours per week) in Q4 2021. The employer had a revenue decline of more than 90% in Q4 2021. The qualified wages and health insurance costs

> > Click Here to Find Out if You are Eligible for ERC < <

Claim the Credit and Report It

The Internal Revenue Service (IRS) requires that employers claim the Employee-Retention Credit by filing a federal income tax return, Form 941, or a modified employment tax form (Form941X), with them. The employer must declare the wages and health insurance premiums paid to eligible employees, as well as the credit amount claimed each quarter.

Form 941

Form 941 is used to report the employer’s quarterly federal tax liability, including income tax, social security tax, and Medicare tax. The employer can also claim the ERC in Form 941 for future or current quarters. The employer can use Form 941 to:

Reduce the amount of taxes that the employer has to deposit with the IRS by the amount of the ERC
The employer can request an advanced payment of the ERC credit if it exceeds taxes that they have to deposit. Employee Retention Credit Worksheet
Any excess credit can be carried forward to the next quarter

To ensure the correct completion of Form 941, and to avoid common errors:

Use the latest version of Form 941 that reflects the changes and updates made by the laws that affect the ERC
Follow the IRS instructions and worksheets for calculating the ERC and reporting it.
Use Line 11c to report the qualified wages and health insurance costs paid to eligible employees
Use Line 13d to declare the credit amount claimed for each quarter
Use Line 13f to declare any advance payments received from the IRS.
Use Line 24 to request an advance payment of the credit if needed
You can report excess credit on Line 25 for the following quarters.
Sign and date Form 941, attaching any supporting documents, schedules, or schedules.

You can find some helpful tips on how to fill out Form 941 here:

Use electronic filing (e-file) or online services to submit Form 941 faster and more securely
You can find updates, FAQs, and more information on the IRS site about Form 941, the ERC.
Contact the IRS or a tax professional for assistance or clarification if needed

Form 941-X

Form 941-X is used to correct errors or make adjustments on a previously filed Form 941. Form 941-X also allows the employer to claim the ERC retroactively for past quarters. The employer can use the Form 941 X to: Employee Retention Credit Worksheet

Claim a refund or credit for overpaid taxes due to claiming the ERC
Report additional qualified wages and health insurance costs paid to eligible employees that were not reported on Form 941
The amount of credit claimed will be affected by any mistakes or omissions in Form 941.

To fill out Form 941-X correctly and avoid common errors, the employer should:

Use the latest version 941-X to reflect the updated laws and regulations that impact the ERC.
The IRS has provided worksheets to help you calculate the ERC.
Use Part 2 to indicate which lines of Form 941 are being corrected or adjusted
Use Part 3 to explain why Form 941 is being corrected or adjusted
Line 24 should be used to record any additional health insurance and wages paid to employees who qualify.
Use Line 25 to claim any additional credit for each quarter.
Use Line 26 for any refunds or credits due to ERC claims.
Sign the form 941-X, date it and include any documents or schedules that you wish to attach.

The following are some resources and tips for filling in Form 941X.

Fill out a separate form 941-X per quarter being corrected or recalculated Employee Retention Credit Worksheet
File Form 941-X as soon as possible after discovering an error or making an 0adjustment on Form 941
You can find updates, FAQs, and more information on the IRS site about the ERC and Form 941X.
Need clarification? Contact an IRS agent or tax professional.

Deadline and Statute of Limitations

Form 941 must be filed by the last date of the month that follows the end each quarter. For example, for Q1 2021 (January-March), Form 941 is due by April 30, 2021. Nevertheless, if the employer deposited all taxes due in a given quarter on time, they may file Form 941 before the 10th day. The end of the quarter. For Q1 2021 (January-March), form 941 must be submitted by May 10, 2020, Employee Retention Credit Worksheet

The deadline for filing Form 941-X is generally three years from the date that the original Form 941 was filed or two years from the date that the tax was paid, whichever is later. For example, for Q1 2020 (January-March), Form 941 was due by April 30, 2020. If an employer files Form 941 by April 30, 2020 and pays the tax on April 30 2020, then the deadline to file Form 941-X will be April 30, 2023. If an employers filed Forms 941 and paid taxes on June 15, 2019, the deadline is June 15, 2022.

> > Click Here to Find Out if You are Eligible for ERC < <

Conclusion

Employee Retention credit (ERC), a valuable benefit under tax law, can help employers who have been affected by COVID-19 keep their staff on payroll and minimize the impact of pandemic.

The ERC (Eligible Employees Credit) is a tax credit that can vary depending on the time frame, the number and type of employees employed, and the amount paid in wages and insurance to employees eligible for the credit. The ERC credit can be claimed with IRS Forms 941 or 941X by reporting to them the qualified health insurance and wages costs as well as the amount claimed each quarter.

Do not miss out on this opportunity if you’re an employer that meets the ERC eligibility criteria. The ERC is not available forever and has a deadline and a statute of limitations for claiming it. Use the resources and tips provided in this article to ensure that you fill out your forms correctly and avoid common mistakes. If you need clarification or assistance, you can contact the IRS.

The ERC can make a big difference for your business or organization and your employees. It can help you retain your workers, maintain your cash flow, and recover from the pandemic. This article should have helped you learn more about ERCs and how to apply for them. We thank you for reading. Please stay safe.

> > Click Here to Find Out if You are Eligible for ERC < <

Employee Retention Credit Worksheet

What is ERC?

Employee Retention Credit is an employer tax credit available to employers who kept their employees on payroll during COVID-19.

The CARES Act created the American Rescue Plan Act of 2021 in March 2021. Later, the CAA (Consolidated Appropriations Act), in December 2020, was amended and expanded by ARPA (American Rescue Plan Act of 2021), in March 2021.

Can everyone apply for ERC?

ERCs are not available to all. Employers who retained their employees and paid them wages between March 13, 2020, and December 31, 2021, are eligible.

There are also criteria for eligibility; more details can be read above, but here are the highlights:

A government order has suspended the business or organization (wholly or partially) due to COVID-19.
The gross receipts they had for a calendar-quarter in 2020, 2021 or both were less than 10% of their gross receipts during the same quarter last year.
The business is a startup that started operations after February 15, 2020, and has an average gross revenue of less than $1 million.

How much is the ERC?

The amount of ERC a company or organization receives will depend on several factors.

Some of these include the time period and number of employees. Others are the amount paid in qualified wages or health insurance to eligible employees. For a detailed explanation of ERC, you can read the article mentioned above.

How to claim the ERC?

To claim the ERC an employer must submit a federal employment reform (Form 941)-X or a revised employment tax return to the IRS.

The employer must provide a quarterly report detailing the wages, health insurance and other costs that are eligible for credit as well as the amount claimed.

When is the deadline to submit the ERC form?

There are two different deadlines to file the ERC Forms: Form 941 (Form 941-X) and Form 941 (941).

The last day for Form 941 in most cases is the last month following the end each quarter. In contrast, the deadline to submit Form 941 X is generally set at three years since the date of the original 941. It can also be from two years from the date that the tax was paid, with the later date being the more preferred one.