Worksheet To Calculate Employee Retention Credit

COVID-19 has caused hardships and unprecedented challenges for businesses and organizations all over the world. Lockdowns, social distance, health and security measures and lockdowns have caused many employers to face reduced revenue, increased expenses and disruptions in their operations.

To help employers keep their employees, and to provide them with health insurance during these difficult times, the U.S. federal government has created the Employee Retention credit (ERC), an refundable tax credits that can offset some of payroll costs for employers who qualify.

The ERC, which was originally enacted in 2020 by the CARES Act, was extended and modified later by subsequent legislation in both 2021 & 2023. The ERC will be explained in this article, along with how it works and the different eligibility criteria and time periods for which it can be claimed.

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 Employee Retention Credit? Worksheet To Calculate Employee Retention Credit

Employee Retention Credit (ERC), a refundable tax credits, is available for tax-exempt businesses or organizations with employees that were affected in any way by the COVID-19 Pandemic. The ERC was established by the CARES Act of 2020 and extended and modified in subsequent legislations in 2021 and in 2023. The ERC encourages employers to maintain their workers and to provide health benefits to them during the crisis.

Main Features and Benefits

The credit is a percentage of wages and health insurance premiums paid by eligible employees. There are limits per employee, per quarter.
The credit amount and percentage vary according to the time period in which it 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. For 2023, there will be a 70 percent percentage for the initial two quarters of the year and a 40 percent percentage for the last two. There will also be a limit of $10,000 per employee each quarter. Worksheet To Calculate Employee Retention Credit
The credit is fully refundable, meaning that if the amount of the credit exceeds the employer’s payroll tax liability, the excess will be paid to the employer as a refund.
The credit can be claimed by employers who experienced a significant decline in gross receipts or a full or partial suspension of operations due to a qualifying government order related to COVID-19. Employers who are considered to be recovery startup businesses may also claim this credit, but only for 2023.
The credit may be claimed by filing a modified employment tax return (941-X), or by reducing the employment tax deposits to prepare for the credit. The credit can be requested in advance by employers using Form 7200.

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

Eligibility Criteria

To qualify for the Employee Retention Credit (ERC), an employer must meet one of the following two main criteria:

The employer’s business or organization was fully or partially suspended by a government order due to COVID-19 during a calendar quarter in 2020 or 2021
The employer’s gross revenues for a quarterly calendar period in 2020, 2021 or both were less that 50% (for the 2020 quarter) or 80% (2021 quarter) of its gross revenue for the same year-ago quarter.

In addition, there is a special rule for recovery startup businesses that began operations after February 15, 2020 and have average annual gross receipts of no more than $1 million. These businesses may qualify for ERC regardless of revenue or business suspension.

Business Suspension

An order of the government can suspend a business or an organization in full or part if it:

The order restricts the commerce, travel and group meetings that are prohibited by COVID-19
The order impacts the operations of a business or organization
The order applies to all calendar quarters in 2020 and 2021

These are some examples:

Stay-at-home orders restricting non-essential business operations
Businesses are restricted in their operating hours by curfews
Capacity limits that reduce the number of customers or clients that can be served by a business
Travel bans and restrictions that restrict the ability for a company to transport services or goods

Employers must take into account the following to determine whether a business has been suspended in full or in part by an order of government:

The nature and scope of the order and how it affects the operations of the business
The length and frequency of your order and the way it corresponds to the calendar quarters
The impact of an order on revenue and expenses

Revenue Drop

It is considered a significant decrease in gross revenue if a business has:

The gross receipts for any calendar quarter in 2020 were less than 50% of its gross receipts for the same quarter in 2019
The gross revenue for any quarter of 2021 was less than 80% that for the same period in 2019.

Gross receipts are defined as the total amount received or accrued by a business or organization from all sources during its annual accounting period without any deductions. Gross receipts can include:

Sales of goods and Services
Dividends (rents), royalties and interest
Contributions, gifts and grants Worksheet To Calculate Employee Retention Credit
Membership dues
Gross revenue from businesses or trades

To calculate and compare gross receipts for different quarters, an employer must use:

The same method for accounting (cash-based or accrual-based) that was used to file the federal income Tax return for 2019
The same calendar year quarters that it used to file its federal employment tax returns (Form 941) for 2019 and 2020/2021
The same sources as reported in the federal tax return for 2019

Recovery Startup Business

A recovery startup is a business:

Begun carrying on any business after February 15th, 2020
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

Even if it does not meet the criteria for revenue decline or suspension of business, a recovery startup can still qualify. Recovery startup businesses are subject to certain restrictions and special rules.

Maximum credit per quarter: $50,000
The credit can only be used for wages paid between the third and the fourth quarters of 2020
The credit is subject to an overall cap of $250 million for all recovery startup businesses

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

Credit Amounts and Calculation

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

How much the employer’s business was affected by the pandemic, either by having to close or reduce operations due to government orders or by having a big drop in income compared to 2019
Employer’s number of employees in 2019 or 2021, and whether the employee worked or not.
How much each employee received from their employer and how they were covered by health insurance in the pandemic

Employers must complete and send IRS forms to claim ERC. The form must show the amount the employer paid for their employees’ health insurance, and how they qualified for the ERC. The IRS will verify the forms, and then give the money to your employer. The money can be used by the employer to pay for health insurance, to pay employees, or refunds on payroll taxes.

The ERC will not be available indefinitely. The ERC began in March 2020, and it will end in September 2022. Employers must claim their ERC before they expire or become unavailable. Employers must also use the money well and not waste it. Worksheet To Calculate Employee Retention Credit

Below is more detailed information on the credit amount and calculation of ERC.

Time Period

Different laws introduced, amended and terminated the ERC in 2020, 2021 and 2022. The amount of the credit varies according to the time period that it is applied for. The following table summarizes the key features and differences of the ERC 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 of employees affects the definition and calculation of qualified wages and health insurance costs for eligible employees. The size of an employer depends on its number of FTEs and the time period. The table below summarizes the rules and thresholds for determining employer size in 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 that eligible employees receive during periods of suspension or decline in revenue. Qualified wages include tips, commissions, bonuses, severance pay, sick leave pay, family leave pay, and other forms of compensation. Qualified wages include health insurance costs for eligible employees such as co-pays and deductibles.

The definition and calculation of qualified wages and health insurance costs depend on the employer size and the time period. The following table summarizes the rules and examples for different scenarios: Worksheet To Calculate Employee Retention Credit

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 and Report the Credit

For the Internal Revenue Service to grant the Employee Retention credit (ERC), employers must file either a federal tax return for employment (Form 941), or an amended tax return for employment (Form941-X). The employer has to report each quarter the wages and costs of health insurance paid to employees who are eligible and the credit claimed.

Form 941

Form 941 allows employers to declare their quarterly federal taxes, including income taxes, Medicare and Social Security tax. Form 941 also allows the employer to claim the ERC for current or future quarters. Form 941 allows the employer to do:

ERC reduces the amount that employers must deposit with the IRS in order to pay taxes.
The employer can request an advanced payment of the ERC credit if it exceeds taxes that they have to deposit. Worksheet To Calculate Employee Retention Credit
Carry forward any excess credits to future quarters

Employers should avoid these common mistakes when filling out Form 941 and ensure that they are filled out correctly.

Use the latest Form 941, which reflects all the updates and changes made to the ERC by new laws.
Follow the instructions and worksheets provided by the IRS for calculating and reporting the ERC
Use Line 11c for the amount of qualified wages and health benefits paid to eligible employees
Use Line 13d for the credit claim amount per 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
Line 25 is the place to enter any excess credit which can be carried to a subsequent quarter.
Sign and date Form 941 and attach any supporting documents or schedules

Here are some tips and resources to help you fill out Form 941:

Use online services (e-file or online filing) to submit Form 941, faster and with greater security.
The IRS website has updated FAQs on the ERC and Form 941.
For clarifications or help, you can contact the IRS.

Form 941-X

The Form 941X can be used to make corrections or adjustments on an earlier 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: Worksheet To Calculate Employee Retention Credit

Claim your refund or credit due to overpaid taxes by claiming the ERC
Report additional qualified wages and health insurance costs paid to eligible employees that were not reported on Form 941
Correct any mistakes or omissions made on Form 941 that affect the amount of credit claimed

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

Use the latest version of Form 941-X that reflects the changes and updates made by the laws that affect the ERC
The IRS has provided worksheets to help you calculate the ERC.
Use Part 2 for indicating which lines of the Form 941 need to be corrected or adjusted
Use Part 3 for explaining why form 941 has been corrected or adjusted
Line 24 should be used to record any additional health insurance and wages paid to employees who qualify.
Line 25 is the place to enter any additional credit claims for each quarter.
Use Line 26 when reporting any refund or credit that you have requested as a result of claiming your ERC
Sign the form 941-X, date it and include any documents or schedules that you wish to attach.

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

Fill out a separate form 941-X per quarter being corrected or recalculated Worksheet To Calculate Employee Retention Credit
After making a correction or finding an error, you should file Form 941X.
Visit the IRS website to get the latest updates, FAQs, and guidance regarding Form 941-X, the ERC, and other forms.
You can also contact a tax expert or the IRS for clarification or additional assistance.

Deadline and Statute of Limitations

The deadline for submitting Form 941 generally falls on the last calendar day of the following month. For example, Form 941 for Q1 of 2021 (January to March) is due April 30, 2020. In the event that an employer has deposited the taxes due on time for a particular quarter, Form 941 can be filed by the 10th date of the following month. After the end of the quarterly period. Form 941 for the first quarter of 2021 (January – March) is due on May 10, 2021. Worksheet To Calculate Employee Retention Credit

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, Q1 2019 (January to March), Form 941 had to be submitted by April 30, 2019. 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 employer files Form 941 in April 2020 and pays the tax on June 15 2020, they have until June 15 2022 to file Form 941.

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

Conclusion

The Employee Retention Credit (ERC) is a valuable tax benefit that can help employers who were affected by the COVID-19 pandemic keep their employees on the payroll and reduce the impact of the pandemic on their businesses or organizations.

The ERC is a refundable tax credit that varies depending on the time period, the number of employees, and the amount of qualified wages and health insurance costs paid to eligible employees. The ERC may be claimed through IRS Forms 941 and 941X, which require the employer to report the qualified wages paid and the health insurance expenses incurred by each employee.

Do not miss out on this opportunity if you’re an employer that meets the ERC eligibility criteria. The ERC does not last forever. It has a deadline, and there is a statute of limitations for claiming the ERC. You should file your forms as soon as possible and use the tips and resources provided in this article to fill them out correctly and avoid common errors. You can contact the IRS for help or clarification, or you could consult a tax expert.

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

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

Worksheet To Calculate Employee Retention Credit

What is the ERC?

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

The CARES Act, passed by Congress in March of this year, was amended in December of that year by the CAA Act. In March 2021, the ARPA Act (American Rescue Plan Act of 2021), was extended.

Who is eligible for the ERC?

Not everyone is eligible for the ERC. Only employers who paid wages and retained employees between March 13, 2019, and December 31, 2020, are eligible.

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

A government order imposed a suspension (full or partial) on the business or organization due to COVID-19.
The gross receipts of a calendar quarter for 2020 or 2021 were less than a percent of the gross receipts from a similar quarter in 2019.
They are a recovery startup business that began operations after February 15, 2020, and has average annual gross receipts of no more than $1 million.

How much is the ERC?

The amount ERC received by a business or organization will depend upon several factors.

Some of these factors include the time period, the number of employees, the number of qualified wages, and health insurance costs paid to eligible employees. If you want a more detailed explanation, read the above article.

How do I claim my ERC?

To claim the ERC, an employer must file a federal employment tax reform or an adjusted employment tax return (Form 941-X) with the IRS.

Employers must submit quarterly reports detailing the amounts of the tax credit, the wages paid and the health insurance premiums that they have claimed to be reimbursed.

When is the deadline to submit the ERC form?

The deadlines for filing Forms 941 and 941-X are different.

The deadline for Form 941 is usually the last day in the month after the end of every quarter. Meanwhile, the deadline for Form 941-X is generally three years from the date that the original Form 941 was filled. It can be as late as two years after you paid the tax, but the later date is the preferred date.