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

The Employee Retention Tax Credit (ERC) is a refundable credit that employers can use to offset payroll costs.

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

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 is a refundable tax credit that was created by 2020’s CARES Act and has been extended and changed by subsequent legislations of 2021 and 2023. The ERC aims to encourage employers to keep their workers on the payroll and provide them with health benefits during the crisis.

Main Features and Benefits

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 limit vary depending on the time period for which the credit is claimed. For 2020, the percentage is 50%, and the limit is $5,000 per employee for the entire year. For 2021, there is a 70% percentage and a limit of $7,000 per employee per quarter. For 2023, the percentage is 70% for the first two quarters and 40% for the last two quarters, and the limit is $10,000 per employee per quarter. 2023 Employee Retention Credit Worksheet
The credit will be fully refundable if its amount exceeds that of the employer’s payroll taxes.
Employers who have experienced a significant drop in gross receipts or a complete or partial suspension of their operations as a result of a government order relating to COVID-19 can claim the credit. 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 also request an advance payment of the credit by filing 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 organisation was suspended in whole or in part by a government decree due to the COVID-19, during a quarter calendar of 2020 or 21
Gross receipts of an employer for a quarter calendar in 2020 or in 2021 are less than half (for 2020) and 80% (for 2021) their gross receipts from the same period 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 qualify for ERC despite business suspensions or revenue decreases.

Business Suspension

A government order may suspend a business, or even partially suspend it.

The order limits travel, commerce or group meetings as a result of COVID-19
The order impacts the operations of a business or organization
The order will apply to any calendar month in 2020 or even 2021

Examples of government orders which can lead to a suspension of business include:

Orders to stay at home that prevent non-essential companies from operating
Certain businesses have curfews that limit their hours of operations
Capacity limits that reduce the number of customers or clients that can be served by a business
Bans on travel or restrictions on the ability to transport goods or service by a business

An employer should consider the following factors to determine if an order from a government has suspended a business in its entirety or only partially.

How the nature and scope and the order affect the operation of the business
The duration and frequency of the order and how it coincides with the calendar quarters
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 from any calendar quarter during 2021 are less than 80% compared to the same quarter’s gross receipts from 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
Rents, dividends, and annuities are examples of income streams that include interest, dividends.
Contributions are gifts, donations and grants 2023 Employee Retention Credit Worksheet
Membership fees and dues
Gross income from trades or businesses

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
The same quarters in the calendar year as those used for the federal employment tax returns (Form 941) filed by 2019 and 2020/2021
The same sources reported on your federal income tax form for 2019

Recovery Startup Business

The recovery startup business is one that:

Began carrying on any trade or business after February 15, 2020,
Have average annual gross income of no more than $1 million over the three-year period ending the tax year before the calendar quarter in 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. There are certain limitations and rules that apply to recovery startups businesses.

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

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

The employer’s business has been affected by the pandemic. This could be due to the government ordering the closure or reduction of operations or a significant drop in income from 2019.
How many employees the employer had in 2019 or 2020/2021, and whether they worked or not during the pandemic
What the employer paid each employee for their health insurance and during the pandemic

To claim the ERC, the employer must fill out and submit a form to the IRS. 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 review the forms and pay the money back to the employer. 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. It started in March 2020 and will end in September 2022. The employer must claim ERC before the expiration date or when it becomes unavailable. Employers must also use the money well and not waste it. 2023 Employee Retention Credit Worksheet

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

Time Period

The ERC was implemented, amended, or terminated by various laws in 2020. The credit amount depends on the period for which you claim it. 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 employees affects the definition and calculation of qualified wages and health insurance costs 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 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 that eligible employees receive during periods of suspension or decline in revenue. The list of qualified wages includes tips, bonuses, commissions, and severance payments, as well as sick leave, family leave, severance, and other 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 summarizes the rules and examples for different scenarios: 2023 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

To claim the Employee Retention Credit (ERC), an employer must file a federal employment tax return (Form 941) or an adjusted employment tax return (Form 941-X) with the Internal Revenue Service (IRS). 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 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. The employer can use the Form 941 for:

Reduce the amount of taxes that the employer has to deposit with the IRS by the amount of the ERC
You can ask for advance payment if your ERC exceeds the amount of taxes you have to pay. 2023 Employee Retention Credit Worksheet
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.
Use the IRS worksheets and instructions to calculate and report the ERC
Use Line 11c to declare the wages and costs of health insurance paid to employees who qualify.
Use Line 13d when reporting the credit for each quarter.
Use Line 13f to declare any advance payments received from the IRS.
If you need to receive an advance payment, use Line 24.
You can report excess credit on Line 25 for the following quarters.
Sign and date Form 941 and attach any supporting documents or schedules

Tips and resources on how to complete Form 941 include:

Use online services or electronic filing to submit Form 941 more quickly and securely
The IRS website has updated FAQs on the ERC and Form 941.
You can also contact a tax expert or the IRS for clarifications and assistance if you need it.

Form 941-X

Form 941-X allows you to correct mistakes or make adjustments in Form 941 that has already been filed. The employer can also claim the ERC retroactively by using Form 941X. Form 941-X can be used by the employer to: 2023 Employee Retention Credit Worksheet

Claim a refund or credit for overpaid taxes due to claiming the ERC
Report additional qualified wages paid and health insurance premiums paid to eligible workers that have not been reported on Form 941
Correction of errors or omissions on Form 941 which affect credit amount claimed

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

Use the latest Form 941-X 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 Part 2 to indicate the lines on Form 941 that are being corrected or adapted.
Use Part 3 to explain why Form 941 is being corrected or adjusted
Use Line 24 for any additional qualified wage and health insurance expenses paid to eligible workers
Use Line 25 for any additional credit claimed each quarter.
Use Line 26 for any refunds or credits due to ERC claims.
Sign and date Form 941, and attach any supporting documentation or schedules

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

You must file a separate 941X form for each quarter you are correcting or adjusting. 2023 Employee Retention Credit Worksheet
Fill out Form 941-X immediately after you find an error in Form 941
Visit the IRS website to get the latest updates, FAQs, and guidance regarding Form 941-X, the ERC, and other forms.
If you need clarification or assistance, contact the IRS or an accountant.

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, Form 941 for Q1 of 2021 (January to March) is due April 30, 2020. The employer can still file Form 941 if they have deposited their taxes on time. After the end quarter. For Q1 2021 (January-March), form 941 must be submitted by May 10, 2020, 2023 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 Q1 2020, (January-March), the Form 941 must be filed by April 30th 2020. If the employer has filed Forms 941 and paid tax by April 30th 2020, they have until April 30th 2023 to submit Form 941X. If an employer filed form 941 on April 30 2020 and paid the tax by June 15, 2020, then the deadline to file Form 941-X will be 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 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 cannot be claimed forever. There is a deadline to claim it and a statute that limits its use. To avoid making common mistakes, you should fill out the forms correctly using the information and tips in this article. For clarifications or help, you can always contact an IRS agent or tax professional.

ERC can have a significant impact on your business, organization, and your employees. You can use it to retain employees, keep your cash flowing, and recover after a pandemic. We hope this article has helped you understand more about the ERC and how to claim it. Stay safe and thank you for reading.

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

2023 Employee Retention Credit Worksheet

What is ERC?

Employee Retention Credit – This tax credit is available to employers for keeping their employees employed during the COVID-19 epidemic.

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.

Can everyone apply for ERC?

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

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

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

Among these factors are the time period, employee count, amount of qualifying wages and health insurance cost paid to eligible workers. The article above provides a detailed explanation on how ERC is calculated.

How to claim 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.

Employers are required to report each quarter the total amount claimed as a credit and the wages and insurance premiums paid by eligible employees.

When is the Deadline for Filing the ERC Forms?

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

The last day to submit Form 941 for each quarter is the last calendar month. 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.