Employee Retention Credit 2023 Worksheet Excel

Many businesses and organizations have faced unprecedented hardships and challenges as a result of the COVID-19 pandemic. 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 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 has been in place since 2020 when the CARES Act was passed. Later, in 2021 and again in 2023, it was modified and extended by new legislation. This article will describe what the ERC does, how it operates, and explain how to claim it.

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 2023 Worksheet Excel

Employee Retention Credit is a tax credit that can be refunded to businesses and tax-exempt organizations who had employees 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 was created to encourage employers in crisis to keep workers on their payrolls and provide them health insurance.

Main Features and Advantages

Credits are equal to a percent of the qualified wages and costs for health insurance paid to eligible employees up to a limit per employee each quarter.
The percentage and the maximum credit vary depending on how long the credit can be claimed. For 2020, the percent is 50%, and the limit is $5,000 for each employee per year. 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. Employee Retention Credit 2023 Worksheet Excel
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.
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. In addition, employers who qualify as recovery-startup businesses for 2023 can also claim the credits.
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. By submitting Form 7020, employers can request an early payment of their credit.

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

Criteria for Eligibility

Employers who wish to qualify for Employee Retention Credit (ERC) must meet two main criteria.

The employer’s company or organization has been suspended, either fully or partly, by an order of the government due to COVID-19 at a particular calendar quarter in 2020/2021
The gross receipts of the employer for a calendar-quarter in 2020 or 2020 were less than 50 percent (for 2020), or 80 percent (for 2021), of their gross receipts during the same calendar 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 can qualify for the ERC regardless of business suspension or revenue decline.

Business Suspension

A business or organization is considered fully or partially suspended by a government order if:

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
The order will apply to any calendar month in 2020 or even 2021

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

Stay-at-home orders that restrict non-essential businesses from operating
Businesses are restricted in their operating hours by curfews
Limits on the capacity of a business that limit how many customers or clients it can serve
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 extent of the order, and its impact on the operation of your business
The duration, frequency of the orders and their alignment with the four quarters calendar.
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 of any calendar quarter in 2020 are less than half the gross receipts of the same quarter in 2019.
The gross revenues for any calendar-quarter in 2021 will be less than 80 percent of the gross revenue in 2019 for that same quarter.

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 are:

Sales of Goods & Services
Rents, dividends, and annuities are examples of income streams that include interest, dividends.
Gifts, donations, and contributions Employee Retention Credit 2023 Worksheet Excel
Membership fees and dues
Gross revenue from businesses or trades

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

Use the same method (cash or accrual accounting) as it used when filing its federal income taxes for 2019
It will use the same calendar year quarters for 2019/2021 as it did to file its federal Employment Tax Returns (Form 941).
The same sources of revenue that they reported on their federal income tax return in 2019

Recovery Startup Business

Recovery startup businesses are those that:

Began carrying on any trade or business after February 15, 2020,
If you have average annual gross revenues of less than $1 million in any three tax-year period that ends with the tax-year preceding the calendar quarter for credit determination.

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.

The maximum credit available per quarter is $50,000
The credit is only available for wages paid in the third and fourth quarters of 2021
Credits for recovery startups are subject to a maximum of $250 million.

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

Credit Amounts and Calculation

ERC amounts and rules vary for different time periods and 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
How many employees the employer had in 2019 or 2020/2021, and whether they worked or not during the pandemic
How much each employee received from their employer and how they were covered by health insurance in the pandemic

In order to receive the ERC from the IRS, the employer will need to complete some forms. The employer has to fill out the forms and show how much he paid his employees, as well their health insurance, to qualify for ERC. The IRS will verify the forms, and then give the money to your employer. The employer could use this money to pay health insurance for employees or to get refunds and credits for payroll taxes.

ERCs are not available forever. 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 must also spend the money properly and not waste any of it. Employee Retention Credit 2023 Worksheet Excel

Below you will find detailed information on ERC, including the amount of credit and the calculation.

Time Period

The ERC was introduced, amended, and terminated by different laws in 2020, 2021, and 2022. Credit amounts vary depending on when they are claimed. The following table summarizes and compares the ERC’s main features for each 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. According to the time frame and number of full-time equivalents (FTEs), an employer can be classified as a small employer or large employer. The table below summarizes all the rules and thresholds that determine an employer’s size.

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, Health Insurance Costs

Qualified wages refer to wages paid during a period when the business is suspended or revenues are declining. Qualified wages can include severance payment, bonuses, severance tips, sick pay, family pay and other forms compensation. Qualified wages also include the cost of providing health insurance to eligible employees, such as premiums, deductibles, co-pays, and co-insurance.

The calculation and definition of health insurance and qualified wages are dependent on the size of the employer and the time period. This table summarises the rules and provides examples for various scenarios. Employee Retention Credit 2023 Worksheet Excel

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 < <

Claiming and Reporting 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 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 reports the quarterly federal tax liability of an employer, including income tax and Medicare taxes. Form 941 is used by the employer to claim ERC for the current quarter or future. Form 941 can be used by the employer to:

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. Employee Retention Credit 2023 Worksheet Excel
Carry forward any excess credits to future quarters

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

Use the latest version 941 which reflects updates and changes in the ERC.
Use the IRS worksheets and instructions to calculate and report the ERC
Use line 11c to report qualified wages paid and health insurance premiums paid to eligible employees
Use Line 13d to declare the credit amount claimed for each quarter
Use Line 13f to report any advance payments of the credit received from the IRS
If you need to receive an advance payment, use Line 24.
Report any credit balance that may be carried forward into the next quarter using Line 25
Sign Form 941, date it and attach any documents or schedules that you wish to include.

Some tips and resources for filling out Form 941 are:

Use electronic filing services (efile) and online services to submit the Form 941 faster, more securely
Visit the IRS website to get the latest updates, FAQs, and guidance regarding Form 941 and ERC.
Contact the IRS or a tax professional for assistance or clarification if needed

Form 941-X

The Form 941 X is used for corrections and adjustments to a Form 941. The employer can also claim the ERC retroactively by using Form 941X. The employer can use Form 941-X to: Employee Retention Credit 2023 Worksheet Excel

Claim refunds or credits for taxes overpaid due to the ERC
Report additional qualified wage and health insurance expenses paid to eligible employees which were not reported in Form 941
The amount of credit claimed will be affected by any mistakes or omissions in Form 941.

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

Use the most recent version of Form 941X, which reflects any changes or updates to the ERC 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
Use Line 24 to report any additional qualified wages and health insurance costs paid to eligible employees
Line 25 should be used to declare any additional amount claimed as a credit each quarter
You can use Line 26 to request a refund or credit due to claiming 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:

File a separate Form 941-X for each quarter that is being corrected or adjusted Employee Retention Credit 2023 Worksheet Excel
Fill out Form 941-X immediately after you find an error in Form 941
Check the IRS website for updates, FAQs, and guidance on Form 941-X and the ERC
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, 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. For example, Q1 2020 (January to March) requires that Form 941 be returned by May 10, 2021. Employee Retention Credit 2023 Worksheet Excel

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 Credit is a valuable tax credit that can assist employers affected by the COVID-19 Pandemic to keep their employees and reduce the impact on their business or organization.

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 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.

You should not miss the opportunity to benefit from this tax incentive if you are an eligible employer. 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 also contact the IRS or a tax professional for assistance or clarification if needed.

ERCs can be a huge help to your organization or business and its employees. It will help you to keep your employees, maintain a healthy cash flow, as well as recover from pandemic. This article aims to provide you with more information about the ERC. Thanks for reading and please stay safe.

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

Employee Retention Credit 2023 Worksheet Excel

What is an ERC?

Employee Retention Credit: This is a credit that employers can claim if they retained employees during the COVID-19 pandemic.

It was created by the CARES Act in March 2020 and was later amended and extended by the CAA (Consolidated Appropriations Act) in December 2020, and the ARPA (American Rescue Plan Act of 2021) in March 2021

Does everyone qualify for the ERC program?

ERCs are not available to all. It is only available to employers who have retained employees and paid their wages to them between March 13, 2020, and December 31, 2021.

The criteria for eligibility is also listed above. For the highlights, please see:

A government order imposed a suspension (full or partial) on the business or organization due to COVID-19.
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.
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.

What is the ERC rate?

The amount of ERC a company or organization receives will depend on 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. To learn more about how ERCs are calculated, please read the article.

How to claim 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 ERC’s deadline?

The deadline for filing the ERC forms is different for Form 941 and Form 941-X.

Form 941 deadline is typically the last of the month following 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 is also possible to choose a date of two years following the date on which the tax was paid.