7-Step Employee Retention Tax Credit Calculation Worksheet

September 9, 2023 Employee Retention Credit (ERC)

Feeling overwhelmed by the complex calculations involved in the Employee Retention Credit (ERC)? Don’t worry, we’ve got you covered with our 7-step Employee Retention Tax Credit Calculation Worksheet.

In this post, we’ll walk you through our 7-step Employee Retention Tax Credit Calculation Worksheet, providing you with all the details and guidance you need. Whether you’re a small business owner or a large employer, our step-by-step approach will help you understand the eligibility requirements, calculate the maximum credit, and make informed financial decisions.

Get ready to boost your business’s financial health with the secrets of the ERC Calculation Worksheet! Keep reading to learn more.

Need help with calculating ERC? Contact us now to speak with one of our professionals.

Step 1: Determine Eligibility for the Employee Retention Credit

To determine your eligibility for the Employee Retention Credit, assess if your business had a partial or full suspension of operations or experienced a decline in quarterly gross receipts. These eligibility requirements are crucial in calculating the maximum credit you can claim.

Analyzing your business operations and financial data will help you understand if you meet the criteria set by the IRS. A partial or full suspension of operations refers to significant disruptions that affected your ability to conduct business normally. This could include government-mandated closures or restrictions due to the COVID-19 pandemic.

A decline in quarterly gross receipts means a decrease in your business’s revenue compared to the same quarter in the previous year. By carefully evaluating these factors, you can determine if you’re eligible for the Employee Retention Credit and calculate the maximum credit amount you can claim.

Step 2: Gather Necessary Information for Calculation

Gather all the necessary information for the calculation by identifying the qualified wages and health plan expenses paid during the qualifying periods of closure or decline in gross receipts.

To accurately calculate the Employee Retention Credit (ERC), it’s crucial to gather documentation regarding the wages and health plan expenses paid to your employees. This includes information on the periods of closure or decline in gross receipts that qualify for the credit. By collecting these documents, you can ensure that you have the necessary evidence to support your ERC claim.

Also, a consultation with one of our expert CPAs can provide valuable guidance and assistance in navigating the complex calculations involved in claiming the credit. Our expertise can help ensure that you accurately calculate the ERC and maximize your benefits.

Step 3: Identify Qualified Quarters and Wages

Identifying the quarters and wages that qualify for the Employee Retention Credit is essential in determining your eligibility and potential benefits. To help you navigate this process, here are four key points to consider:

1. Review the covered periods: The ERC initially applied from March 13, 2020, to December 31, 2020. However, the American Rescue Plan Act extended it through December 31, 2021. Recovery startup businesses may still be eligible until the end of 2021.

2. Understand eligibility requirements: Qualifying employers must meet criteria such as a partial or full suspension of operations or a decline in quarterly gross receipts.

3. Calculate qualified wages: Determine the maximum credit for both 2020 and 2021 and consult an ERC expert to ensure accuracy.

4. Consider legislative updates: The Consolidated Appropriations Act expanded the types of organizations that qualify for the ERC, increasing eligibility for PPP recipients and allowing more businesses to claim qualified wages.

Step 4: Calculate the Maximum Credit for 2020

By calculating the maximum credit for 2020, you can determine the potential benefits of the Employee Retention Credit (ERC) for that year. Understanding the eligibility requirements for the ERC is crucial in order to make an informed decision.

To calculate the maximum credit for 2020, you need to consider the qualified wages and health plan expenses paid during the qualifying periods of closure or decline in gross receipts. The limit for qualified wages in 2020 is $10,000 per employee per year. This means that the maximum ERC for 2020 is $5,000 per employee per year.

Step 5: Calculate the Maximum Credit for 2021

To determine the potential benefits of the ERC for 2021, you’ll need to calculate the maximum credit by considering the qualified wages and health plan expenses paid during the qualifying periods of closure or decline in gross receipts.

Here are some strategies for maximizing the Employee Retention Credit:

1. Understand the eligibility requirements: Familiarize yourself with the criteria for partial or full suspension of operations or a decline in quarterly gross receipts.

2. Utilize an ERC tax expert: Working with a professional at Northstar can help ensure accurate calculations and proper filing, maximizing your credit. Contact us now to speak with one of our ERC experts.

3. Stay updated on legislation updates: The definition of large employers changed in 2021, expanding eligibility for more businesses. Keeping informed about updates increases your chances of qualifying for the ERC.

4. Take advantage of recovery startup business eligibility: If your business started operations after February 15, 2020, and has less than $1 million in total gross receipts, you may still be eligible for the ERC until December 31, 2021.

Step 6: Determine Eligible Expenses for Large Employers

To determine eligible expenses for large employers, you should include wages and health plan expenses paid when an employee isn’t working due to economic hardship. When calculating the Employee Retention Credit (ERC), it’s important to consider the credit limitations and accurately calculate health plan expenses.

For large employers, the qualified wages limit for 2020 is $10,000 per employee per year, resulting in a maximum ERC of $5,000 per employee per year. In 2021, the qualified wages limit is $10,000 per employee per quarter, resulting in a maximum ERC of $7,000 per employee per quarter or $21,000 per employee per year.

However, if you’re a recovery startup business, you can claim up to $28,000 per employee per year. It’s crucial to accurately determine eligible expenses and consult with ERC tax experts to ensure proper filing and maximize the benefits of the credit.

Step 7: Utilize the Advance Refund Process for Excess Credit

Now that you’ve calculated the Employee Retention Credit (ERC) and determined that your credit amount exceeds your total employment tax deposits for a pay period, it’s time to utilize the advance refund process for the excess credit.

Here’s what you need to know:

1. Understand the process: The advance refund process allows you to claim the excess credit before filing your quarterly payroll tax return. This means that you can receive the funds sooner and improve your cash flow.

2. Complete Form 7200: To claim the advance refund, you’ll need to fill out Form 7200, Advance Payment of Employer Credits Due to COVID-19. This form should be filed with the IRS to request the refund.

3. Provide necessary information: When completing Form 7200, make sure to accurately enter your employer identification number, the tax period for which you’re claiming the advance refund, and the amount of the excess credit you’re requesting.

4. Submit the form: Once you’ve completed Form 7200, submit it to the IRS according to their instructions. The IRS will review your request and process the advance refund if everything is in order.

Employee Retention Tax Credit Calculation FAQ

How do I calculate my ERC credit?

Calculating your Employee Retention Credit (ERC) involves determining eligibility based on factors like revenue decline or government shutdowns. After eligibility, calculate the credit as 70% of qualified wages per employee, with a maximum of $10,000 per quarter in 2021 and 2022. Consult IRS guidelines for precise calculations.

Is there a worksheet for the employee retention credit?

Yes, the IRS provides a worksheet, typically found in Form 941 instructions, to assist in ERC calculations. Ensure you use the latest version to accurately calculate your credit based on current rules.

How to calculate gross receipts for ERC?

Calculate gross receipts for ERC by summing all business revenue sources, excluding tax-exempt income, for specific quarters. Compare these figures to the same quarters in the prior year to assess eligibility for the credit. Refer to IRS guidelines for detailed instructions.

How do you calculate ERC with PPP?

When calculating the Employee Retention Credit (ERC) with a PPP loan, ensure you don’t claim ERC for wages used to qualify for PPP forgiveness. Calculate the ERC as 50% of eligible wages per employee, up to $10,000 per quarter, and subtract it from your PPP forgiveness amount. Accurate reporting and compliance with evolving rules are crucial; consult a tax professional or IRS guidelines for specifics.