Employee Retention Credit Calculation Spreadsheet Aicpa

COVID-19, the pandemic that has swept across the globe in recent years, has brought unprecedented challenges and hardships to businesses and organisations around. Many employers have experienced reduced revenues, higher expenses, and disruptions to their operations because of lockdowns, distancing from social media, and health-and-safety measures.

Employee Retention Credit is a refundable income tax credit available to eligible employers that helps them retain their employees while providing health benefits.

The ERC, which was originally enacted in 2020 by the CARES Act, was extended and modified later by subsequent legislation in both 2021 & 2023. This article will provide an overview of the ERC and its workings, as well as how to apply for it in different time periods.

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 Calculation Spreadsheet Aicpa

Employee Retention Tax Credit (ERC), is a refundable tax credit for organizations and businesses with employees who have been affected by COVID-19. The ERC was created by the CARES Act in 2020 and was extended and modified by subsequent legislation in 2021 and 2023. The ERC’s goal is to encourage employers during a crisis to continue to employ their workers, and to offer them health coverage.

Main Features and Benefits

The credit is equal to a percentage of qualified wages and health insurance costs paid to eligible employees, up to a certain limit per employee per quarter.
The percentage and the limit vary depending on the time period for which the credit is claimed. In 2020, the 50% percentage and $5,000 limit per employee is applicable for the entire calendar year. For 2021, there is a 70% percentage and a limit of $7,000 per employee per quarter. 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. Employee Retention Credit Calculation Spreadsheet Aicpa
The credit is fully refundable, which means that if it exceeds the employer’s payroll tax liability the excess amount will be returned to the employer.
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. For 2023 only, employers that are classified as recovery startup business can claim the credit.
Credits can be claimed either by amending your employment tax return (Form 941)-X or by reducing your employment tax deposit in anticipation of receiving 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

Employers who wish to qualify for Employee Retention Credit (ERC) must meet 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.
The employer’s gross receipts for a calendar quarter in 2020 or 2021 were less than 50% (for 2020) or 80% (for 2021) of its gross receipts for the same quarter in 2019

A special rule is in place for businesses that have started operating after February 15, 2020, and whose average gross receipts per year are no more than one million dollars. These businesses are eligible for the ERC, regardless of whether their business has been suspended or if revenue has declined.

Business Suspension

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

The order restricts commerce, travel or group meetings because of COVID-19
The order has a direct impact on the operations of an organization or business
This order is applicable to any calendar quarter of 2020 or 2021

Some examples of orders from the government that could cause a business to be suspended are:

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

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 scope and nature of the order as well as how it impacts the business.
The duration, frequency of the orders and their alignment with the four quarters calendar.
The extent and severity of the impact of the order on the revenues and expenses of the business

Revenue Decline

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

The gross revenue for any calendar-quarter in 2020 was less than 50 percent of the gross revenues for the same period in 2019.
The gross receipts from any calendar quarter during 2021 are less than 80% compared to the same quarter’s gross receipts from 2019.

Gross receipts refer to the total of all money received or accrued during a company’s annual accounting period. Gross receipts include:

Sales of Goods and Services
Rents, dividends, and annuities are examples of income streams that include interest, dividends.
Gifts, donations, and contributions Employee Retention Credit Calculation Spreadsheet Aicpa
Dues and fees for membership
Gross income from trades or businesses

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

Use the same method (cash or accrual accounting) as it used when filing its federal income taxes 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 reported on your federal income tax form for 2019

Recovery Startup Business

A recovery startup business is a business that:

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 startups are not exempt from certain rules and restrictions.

The maximum credit amount per quarter is $50,000
The credit is only available for wages paid in the third and fourth quarters of 2021
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 Amount and Calculation

ERC amounts and rules vary for different time periods and employers. The main factors that affect the ERC are:

How much an employer’s company was affected by the pandemic.
How many employees the employer had in 2019 or 2020/2021, and whether they worked or not during the pandemic
How much did the employer pay each employee in health insurance?

The employer has to fill out some forms and send them to the IRS to claim the 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 review the forms and pay the money back to the employer. The employer can then use the money for paying their employees, their health insurance and/or to receive refunds or credits on their payroll tax.

The ERC won’t be around forever. It started in March 2020 and will end in September 2022. The employer has to claim the ERC before it expires or becomes unavailable. Employers must also use the money well and not waste it. Employee Retention Credit Calculation Spreadsheet Aicpa

You can find more information below on ERC calculation and credit amount.

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 summarises the main features and differences between the ERCs of 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 eligible employees will affect the calculation and definition of health insurance and qualified wages. 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 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 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 salaries also include the costs of providing health coverage to eligible workers, including premiums, copays, deductibles, and coinsurance.

The size of an employer’s business and the period in which they operate will determine the definition and calculation for qualified wages and health care costs. Table 1 summarizes and gives examples of rules in various scenarios. Employee Retention Credit Calculation Spreadsheet Aicpa

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

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 report the qualified wages and health insurance costs paid to eligible employees and the amount of credit claimed for each quarter.

Form 941

Form 941 is used by employers to report their quarterly federal tax liabilities, which includes income tax, Medicare tax, and social security tax. Form 941 is used by the employer to claim ERC for the current quarter or future. Form 941 is used by employers to:

ERC reduces taxes that employers have to deposit at the IRS.
You can ask for advance payment if your ERC exceeds the amount of taxes you have to pay. Employee Retention Credit Calculation Spreadsheet Aicpa
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 Form 941, which reflects all the updates and changes made to the ERC by new laws.
Follow the IRS instructions and worksheets for calculating the ERC and reporting it.
Use line 11c to report qualified wages paid and health insurance premiums paid to eligible employees
Use Line 13d for the credit claim amount per quarter
Line 13f should be used to report any advance payments made by the IRS.
Use Line 24 to request an advance payment of the credit if needed
Use Line 25 to report any excess credit that can be carried forward to subsequent quarters
Sign and date Form 941 and attach any supporting documents or schedules

Some tips and resources for filling out Form 941 are:

Form 941 can be submitted faster and more securely by using electronic filing (efile) or online services
Updates, FAQs, and guidance about Form 941, the ERC, and other IRS forms can be found on the IRS website.
For clarifications or help, you can contact the IRS.

Form 941-X

Form 941-X is used to correct errors or make adjustments on a previously filed Form 941. Form 941-X allows employers to claim ERC retroactively. Employers can use Form 941/X for Employee Retention Credit Calculation Spreadsheet Aicpa

Claim your refund or credit due to overpaid taxes by claiming the ERC
Report any additional wages or health insurance costs that are paid to employees who are eligible but not reported on Form 951.
Correction of errors or omissions on Form 941 which affect credit amount claimed

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

Use the latest Form 941-X 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 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 is used to report additional wages and health insurance premiums paid to eligible employees.
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.

Some tips and resources for filling out Form 941-X are:

You must file a separate 941X form for each quarter you are correcting or adjusting. Employee Retention Credit Calculation Spreadsheet Aicpa
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.
For clarifications or help, you can contact the IRS.

Deadline and Statute of Limitations

The deadline for filing Form 941 is generally the last day of the month following the end of each quarter. For example, Q1 2020 (January-March) Form 941 will be due on April 30, 2021. 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. Following the end of the quarter. For example, Q1 2020 (January to March) requires that Form 941 be returned by May 10, 2021. Employee Retention Credit Calculation Spreadsheet Aicpa

The deadline for submitting Form 941X is usually three years following the original date of Form 941 or two after the date on which the tax was paid. For Q1 2020 (January – March), for example, Form 941 is due on April 30, 2020. If an employer submitted Forms 941 on 30 April 2020 and the tax was paid on 30 April 2020, it is now April 2023 before they can file Forms 941-X. If an employer filed Form 941 on April 30, 2020, and paid the tax on June 15, 2020, the deadline for filing Form 941-X is June 15, 2022.

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

Conclusion

Employee Retention (ERC) Credit is an important tax benefit which can help employers that were affected by COVID-19 to retain their employees, and lessen the impact the pandemic had on their organizations or businesses.

The ERC, a refundable credit, varies according to the time period and number of employees as well as the amount of qualified wage and health insurance expenses paid to employees who are eligible. 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.

If you are an employer who meets the eligibility criteria for the ERC, you should not miss this opportunity to take advantage of this tax benefit. The ERC has a time limit and deadline for claiming. The forms should be filed as soon as you can. You can use the resources and advice provided in this post to avoid common mistakes and fill them out correctly. 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. You can use it to retain employees, keep your cash flowing, and recover after a pandemic. We hope that this article helped you to understand more about ERC and the claim process. Thanks for reading and please stay safe.

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

Employee Retention Credit Calculation Spreadsheet Aicpa

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 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. Only employers who paid wages and retained employees between March 13, 2019, and December 31, 2020, are eligible.

More details are available above. But here are some of the highlights.

The business or organization was suspended (fully or partially) by government order due to the COVID-19 pandemic.
Their gross receipts for a calendar quarter in 2020 or 2021 were less than a percentage of their gross receipts for the same quarter in 2019.
It is a recovery-startup business that has been operating since after February 15, 2020. Their average annual gross receipts are no more than one million dollars.

How much is the ERC?

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

One of the factors is the length of time the company has been in business, the number and type of employees it has, the amount that qualifies as wages, or the health insurance premiums paid to employees who are eligible. You can read the article above for a more detailed explanation of how ERC is calculated.

How do I claim my ERC?

To receive the ERC, employers must file with the IRS a Form 941-X (revised employment tax returns) or a Federal Employment Tax Reform.

Employers must declare the wages and costs of health insurance paid to employees who qualify and the credit claimed each quarter.

When is the deadline to submit the ERC form?

The deadlines of Form 941, Form 941X and ERC 941 are different.

The last day for Form 941 in most cases is the last month following the end each quarter. For Form 941X, the deadline is three years following the date on which the original form 941 was filed. This can also be up to two years, based on the date when the tax is paid.