PLEASE NOTE: These spreadsheets are locked to maintain the integrity of the formulas. 2021 - PPP Worksheet Instructional Guide. Oak Brook But opting out of some of these cookies may affect your browsing experience. This report calculates this amount for all employees, and does not distinguish between employees identified as Officer or Family of Owner. Instead, please drop off any packages outside the office door of our suite in the box provided. <>stream The required documents consist of payroll reports, health insurance statements, and more. Download Excel | Try Smartsheet. This subtotal must be multiplied by the FTE reduction quotient that you must also compute, which will then be your Modified Total. Expense Type C&L Value Advisors, LLCVersion 1.9 06-17-20 UPDATED TO REFLECT 6-17-20 IFR and PPPFA changes. Have you ever heard of a PPP loan forgiveness spreadsheet template? All staff are equipped with the appropriate technology and resources to continue to securely and confidentially serve you from home. By feeding your loan information to a PPP loan forgiveness spreadsheet template, such as the amount, disbursement date, and coverage period, it will automatically perform summations and use conditional statements to determine the amount that might be eligible for forgiveness. What Is the Formula for PPP Loan Forgiveness? Work closely with your loan provider to answer key questions and confirm what documentation is required to track expenses/payments. +W > [Content_Types].xml ( UJ1}%MUn}1f{'RZe9s3]zWAB|#`ot;8Fs@q9>=#`)Qw+C+zE. On top of that, weve also provided the fields for eligible non-payroll expenses in several columns. Its now time to start tracking your use of the funds to determine the amount to be forgiven. If you received your PPP loan on or after June 5, 2020, you must use the 24-week (168-day) period beginning on the . Chat - Best option for simple questions Last week, the Treasury issued an FAQ to provide a recovery period to public companies that took PPP loans when they had adequate resources. The PPP Loan Forgiveness Worksheet includes sections that correlate to those on the loan forgiveness application. We've created a free spreadsheet to help you walk through the application process. Supplemental support documents "SBA PPP Loan Borrower Disbursement Authorization" and "SBA PPP Loan Borrower's Certification" can be added. If Applicant is a news organization that Sheet1 Company Name Recommended Best Practices April 15, 2020 to June 15, 2020 Note:,This file is intended to assist you in the evaluation of the use of PPP funds and is not intended to be submitted to lenders or the SBA for purposes of loan forgiveness Upon receipt of loan documents: Have a boa. Monadnock Building The certification documentation provided in the worksheets above allows you to document how and why the PPP loan funds were considered necessary for your company. What Reports Are Needed for PPP Loan Forgiveness? Thank you for your patience and understanding during this challenging time. The Salaried amount pay item has 0 regular hours recorded on the payroll check. Some of you may already be two to three weeks into your eight-week covered period, so acting fast to do the math will get you better positioned once the loan forgiveness process is in place. Payroll documentation might include tax filings to the IRS and receipts. Management One is a small business, just like most of your enterprises. The calculator is based on existing PPP guidance from the Department of Treasury and Small Business Administration (SBA), as well as additional recommendations added by the AICPA. We last shared some best practices and next steps once you receive your PPP funds. Free PPP Loan Forgiveness Spreadsheet Templates 1. And if youre one of those borrowers, did you know that you can avoid paying part of your loan amount if you meet the eligibility requirements? Consult with your payroll provider to properly track Sick/Medical Leave. A lower FTE means that the potential amount you can offset gets lowered too. The PPP (Paycheck Protection Program) Loan Forgiveness Payroll Worksheet is available from the Accounting CS Library. 5 Best PPP Loan Forgiveness Spreadsheet Templates. If you received your PPP loan on or after June 5, 2020, you must use the 24-week (168-day) period beginning on the PPP . Learn more. What Is a PPP Loan Forgiveness Spreadsheet? Connect with other professionals in a trusted, secure, environment open to Thomson Reuters customers only. Call us at +1 800 968 0600. PK ! Learn more. Oakbrook Terrace, IL 60181 It is mandatory to procure user consent prior to running these cookies on your website. Effective immediately: We want to remind our clients of our portal access and your ability to safely and securely share your information with our team. The certification documentation provided in the worksheets above allows you to document how and why the PPP loan funds were considered necessary for your company. Enter the total wages paid during the PPP coverage period, after the mandated shutdown ended and through the end of the 24-week period. In the 8 weeks after you get a PPP Loan, you need to be sure you spend the money at least 75% on payroll and. Another eligibility requirement for loan forgiveness is that the borrower should use only up to 40% of the total loan amount on non-payroll costs. All loan terms will be the same for everyone. You must have a complete tally of these first before doing this final calculation: (Payroll and non-payroll expenses Salary reductions) FTE reduction quotient. For current PPP Loan Requirements go to sba.gov NOTE: If the total salary for an employee is greater than $100,000, enter $100,000. Please contact Cray Kaiser for most recent information. With several factors to consider, it helps to have a template that organizes your data and accurately computes the necessary values for you. For example: trucking , hospice , television , Kasowitz Benson Torres , 90210 , Sole. Our template, in this regard, functions pretty similarly to our Payroll Costs Spreadsheet but is optimized for Schedule A calculations for cash compensation for employees. employee retention credit calculation spreadsheet. 0 Please note that the guidance at this point is still unclear as to whether the loan may be used for other expenses beyond payroll and certain mortgage, rent or utilities. We also use third-party cookies that help us analyze and understand how you use this website. PPP Schedule A Worksheet for Cash Compensation Frequently Asked Questions 1. *For example spreadsheet mentioned in May 21 Facebook Live, click here. will no longer be mailed by our office to you. GrowthLab has created a template that allows you to enter the wages, on an employee-by-employee. We're sorry. Please note that this blog is based on laws effective on May 2, 2020 and may not contain later amendments. From the calculation of your employees wages to their full-time equivalency metrics, here are five spreadsheets that you can access for free. She's been writing tech tutorials & how-to guides on Windows, Android, iOS, Social Media, Data Recovery, Cybersecurity, Gaming, and more as a tech writer for over 6 years. Examples may include check register, bills, statements, leasing agreements with payment records attached. These cookies will be stored in your browser only with your consent. Fill out the form below to download the new worksheet. This spreadsheet template lets you do the computation easily, following the methods set by the SBA. 1489 0 obj <>stream CALIFORNIA RESIDENTS: DO NOT SELL MY PERSONAL DATA. Monadnock Building And ensuring that you dont exceed this amount is crucial, as it determines whether you will be able to enjoy the full benefits of the scheme. Get the most out of your Thomson Reuters Tax & Accounting products. . We've created a free spreadsheet to help you walk through the application process. 1164 0 obj Step 3. endstream And it usually contains four parts: cash compensation, non-cash compensation, average FTEs, and reductions from hourly rates or salaries. Track Headcount of your Employees each week or each Payroll. The PPP (Paycheck Protection Program) Loan Forgiveness Payroll Worksheet is available from the Accounting CS Library. Download .pdf File size: 373KB Effective : July 30, 2021 Owned by : Office of Capital Access OMB Control Number : 3245-0407 All paper files, tax returns etc. DOWNLOAD THE PPP LOAN FORGIVENESS TEMPLATES Last week, the Treasury issued an FAQ to provide a recovery period to public companies that took PPP loans when they had adequate resources. a Your online resource to get answers to your product and industry questions. . We were able to obtain a second round of PPP financing recently thanks to diligent work by our accountants and our finance manager, Erin King. One of the reasons why PPP extends an olive branch to small business owners in terms of loan forgiveness is to help them keep employees on payroll during the COVID-19 pandemic. Instead, we will be utilizing phone calls and/or email to communicate with our clients. Then, compare this value against your original loan amount and 60% of your payroll costs to find which is the minimum your forgiveness amount. Please read the instructions in the worksheet which indicate how to use the resources as intended.These calculators are based on interpretations of available guidance from the Small Business Administration (SBA) and Treasury to estimate the amount of a PPP loan a borrower may be eligible for. April 12, 2023 . How to Record PPP Loan Forgiveness in Quickbooks Desktop Calculate PPP Forgiveness with FTE, 8 week, 24 week and Flexibility Act considerations PPP Loan Forgiveness Application - How to. NUMBER OF EE's (EXCEL) GROSS RECEIPTS TEST 2020 & 2021 (EXCEL) CALC TOTAL ERTC "WAGES" w/ HEALTH (EXCEL) ANALYSIS: MAX ERTC & PPP LOAN FORGIVENESS (EXCEL)) ERTC CALCULATION WORKSHEET 2020 & 2021 (EXCEL) IRS LINKS & ERTC RESOURCES If any changes occur during the course of the next few days, we will update our website. Fax: (630) 953-4905, Chicago All you need to do is feed it with the values you calculated using our other templates, and the forgiveness amount will be displayed in just a few seconds. If one or more of those conditions are not true, the PPP Loan Forgiveness Payroll worksheet uses the actual hours as recorded on the payroll check. You also have the option to opt-out of these cookies. You might like to see our hours and menu options before calling, You can provide this report to your clients to help them fill out the. We wish you, your family, and your business health and safety. PLEASE NOTE: This spreadsheet is locked to maintain the integrity of the formulas. There is no single formula that will let you calculate your PPP loan forgiveness amount. A cloud-based tax and accounting software suite that offers real-time collaboration. The SBA recently released the PPP loan forgiveness application. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. In our templates, we made sure that the calculations are based on the rules and guidelines set by the Small Business Administrationto ensure that users meet compliance requirements. Now, we have created templates for the 24-week covered period. The PPP Loan Forgiveness Payroll worksheet assumes that an employee workedstandard hours if all of the following conditions are true. Additionally, we are now offering PPP loan forgiveness calculations as a service for a flat fee of just 2% of the loan amount. FTE Calculator for PPP Loans 4. It is not necessary to obtain the password to use these documents. Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. These are certainly trying times and we want to reiterate that Cray Kaiser is here for you. Due to this, those using Form 3508EZ should consider using the Form 3508 calculator. Its best practice to complete these worksheets regardless of your funding to be ready in the event you are asked. You can click below to download weekly, bi-weekly, monthly, and semi-monthly workbooks. Necessary cookies are absolutely essential for the website to function properly. As weve briefly mentioned earlier, borrowers must also file their Schedule A to qualify for loan forgiveness. PPP Loan Forgiveness Calculations Service Now, we have created templates for the 24-week covered period. What Is the Formula for PPP Loan Forgiveness? We also use third-party cookies that help us analyze and understand how you use this website. However, keeping track of your qualified expenses and calculating the total loan forgiveness can be a complex process. If the entry for step 4 is greater than or equal to step 2, enter 1.0 on line 13 of PPP Schedule A; the FTE Reduction Safe PPP loan forgiveness. PPP lender information. It is mandatory to procure user consent prior to running these cookies on your website. Remember those sleepless nights before receiving the funding? endobj To help you navigate this worksheet, please also download these two KEY instructional files: Work closely with your loan provider to answer key questions and confirm what documentation is required to track expenses/payments. Necessary cookies are absolutely essential for the website to function properly. 3,191 views May 19, 2020 https://tinyurl.com/y9lx9c76 - In this how to track PPP loan expenses. startxref (See 5-18-20 for updated post.) The SBA recently released the PPP loan forgiveness application. Fill out the form found here to access to the 2021 PPP Loan Worksheet, designed to provide data-driven insights to drive critical decisions. PPP Schedule A Worksheet for Cash Compensation. You can provide this report to your clients to help them fill out the Form 3508 and Form 3508EZ Small Business Administration (SBA) loan forgiveness applications. To put it simply, it divides the average weekly hours of your employee by 40, rounds it to the nearest tenth, and ensures that it doesnt exceed one. Download the PPP Loan Calculator Non-seasonal & In business, File name: ppp-loan-calculator-non-seasonal-operational-in-2019.xlsx, Download the PPP Loan Calculator Nonseasonal & NOT in business, File name: ppp-loan-calculator-non-seasonal-non-operational-in-2019.xlsx, Download the PPP Loan Calculator Seasonal business, File name: ppp-loan-calculator-seasonal-employers.xlsx, Download the PPP Loan Calculator Self-employed, File name: ppp-loan-calculator-self-employed.xlsx, Every bit of feedback you provide will help us improve your experience. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. Please contact Cray Kaiser for most recent information. Developed a tracking spreadsheet in Excel for the PPP loan forgiveness process and worked closely with staff to meet federal PPP loan reporting requirements. 1. 1468 0 obj <>/Filter/FlateDecode/ID[<4AA19B609AEF5B43B21B76684B503CC5><136E88AB77667544AF58C37EEED9DFC9>]/Index[1442 48]/Info 1441 0 R/Length 122/Prev 275229/Root 1443 0 R/Size 1490/Type/XRef/W[1 3 1]>>stream Download the PPP Forgiveness Calculator (Form 3508), File name: ppp-forgiveness-calculator.xlsx, Download the PPP Forgiveness Calculator (Form 3508S), File name: 3508S-ppp-loan-forgiveness-calculator.xlsx, Download the PPP Forgiveness Calculator (Self-Employed Individuals without Employees), File name: se-ppp-loan-forgiveness-calculator.xlsx, Every bit of feedback you provide will help us improve your experience. Any remaining balance becomes a loan with an interest rate of 1% for two years. These cookies do not store any personal information. The American Institute of CPAs (AICPA) has created a loan forgiveness calculator (excel spreadsheet download) for the Paycheck Protection Program (PPP) to help resolve outstanding issues with the process.. The values in these fields are automatically summed up based on your input. These cookies do not store any personal information. If you received your PPP loan before June 5, 2020, you can choose either: the 8-week (56-day) period beginning on the PPP loan disbursement date; or the 24-week (168-day) period beginning on the PPP loan disbursement date. 53 West Jackson Street, Suite 828 1442 0 obj <> endobj It is not necessary to obtain the password to use these documents. Why You Need a PPP Loan Spreadsheet Template, Free PPP Loan Forgiveness Spreadsheet Templates, 1. A borrower may use this form only if the borrower received a PPP loan of $150,000 or less. 6. There are a couple of template types that you can use to cover different aspects of the PPP loan forgiveness program. Should any questions arise as you complete these calculations with the PPP loan forgiveness templates, please contact Cray Kaiser at 630-953-4900. hbbd```b``"H M,n &M`?d" +` 5Drd!Da 5@&FVC8#]K } SpreadsheetPoint is supported by its audience. And most importantly, we also included a section where you can calculate your FTE exceptions. Specifically, a date range that includes a partial week of 3 or less days will round down, and a partial week of 4 or more days will round up. This site is brought to you by the Association of International Certified Professional Accountants, the global voice of the accounting and finance profession, founded by the American Institute of CPAs and The Chartered Institute of Management Accountants. This category only includes cookies that ensures basic functionalities and security features of the website. Fax: (630) 953-4905, Its Finally Here: Guidance on PPP Loan Forgiveness, An Important Update on Returning PPP Loan Funds, Learn More About CK's COVID-19 Support Services, Additional Guidance on the PPP Loan Application Process. It is not necessary to obtain the password to use these documents. And the best part is they are free! Each workbook contains instructions, the loan forgiveness calculator, determination of your FTE (full time equivalent), actual tracking of costs template, a certification template and two examples so you can see the math in action. . *For more COVID-19 resources, visitChurchCOVID19.com and SchoolCovid19.com. The Paycheck Protection Program ("PPP") authorizes up to $349 billion in forgivable loans to small businesses to pay their employees during the COVID-19 crisis. Learn more. Step 5. Oak Brook April 20 2020. Step 1: Understand Which Quarters Qualify Step 2: Evaluate Your Eligibility: Step 3: Determine if You Had a Qualifying Closure Step 4: Determine Business Status Step 5: Assess Your Qualified Wages for Each Year Step 6: Calculate the ERC for Your Business Step 7: Look for Advanced Refund Eligibility For ERC Worksheet Assistance, Contact ERC Today It is not necessary to obtain the password to use this document. Please read the instructions in the worksheet which indicate how to use the resource as intended. including analysis of cash flow . Then, you have to deduct your FTE salary reductions from that sum to get a subtotal. 1. CARES Act PPP Loan Expense Tracker & Forgiveness Calculator Version 1.9 06-17-20 UPDATED TO REFLECT 6-17-20 IFR and PPPFA changes. They also ensure that your numbers are accurate and organized. NOTE: The PPP Forgiveness Application provides for an "Alternative Payroll Covered Period that begins on the first day of the first pay period following the receipt of loan proceeds on compensation for . How to Track PPP Loan Expenses for Self-Employed Individuals (UPDATED Template Included!) The loan amounts will be forgiven as long as: The loan proceeds are used to cover payroll costs, and most mortgage interest, rent, and Generally, you want to count the number of full-time equivalents in your business, which gives insights into whether youre keeping your employees or rehiring them back to your enterprise. To apply for forgiveness of a Paycheck Protection Program (PPP) loan, borrowers will be asked for a count of their full-time equivalent (FTE) employees. Notice: The Paycheck Protection Program (PPP) ended on May 31, 2021. 2. This is where our spreadsheet calculator might come in handy. Corporate technology solutions for global tax compliance and decision making. Please note that this blog and the 24-week PPP loan forgiveness templates are based on laws effective in August 2020 and may not contain later amendments. Those are the reasons why you needed these funds! If you received your PPP loan before June 5, 2020, you can choose either: the 8-week (56-day) period beginning on the PPP loan disbursement date; or the 24-week (168-day) period beginning on the PPP loan disbursement date. We anticipate more guidance in the upcoming weeks and will keep you informed on our blog as we know more. But opting out of some of these cookies may affect your browsing experience. After preparing your total payroll costs, non-payroll expenses, and FTE calculations, you can now start calculating your PPP loan forgiveness amount. (What are standard hours?). Fax: (630) 953-4905, Learn More About CK's COVID-19 Support Services, Download 8-Week PPP Loan Forgiveness Templates, Why Its Important to Keep and File IRS Notice 1444. To aid you in this process, weve prepared a few Excel workbooks which you can download by clicking the link below. Enter your PPP loan information including the date received, 24-week period ending date and amount of PPP loan. This website uses cookies to improve your experience while you navigate through the website. If a section doesn't apply to an employer, it won't display in the report. Werner & Co. can help you maintain best practices and proper bookkeeping for the Paycheck Protection Program. Fill out the form to get our free loan forgiveness calculator spreadsheet, including: Forgiveness Amount Calculation PPP Schedule and Worksheet Salary/Hourly Wage Reduction FTE Reduction Safe Harbor The loan forgiveness calculators use available guidance from the Small Business Administration (SBA) and Treasury, along with interpretations of that guidance (see notes throughout) to estimate the amount of a PPP loan that may be eligible for forgiveness. (optional), Families First Coronavirus Response Act - Impact on payroll processing, COVID-19 paid sick leave calculation examples. You also have the option to opt-out of these cookies. ;}h|19F$+Dt#2. Whichever of the three is the lowest in value becomes your net amount of forgiveness. "My approach is to have all of our clients who get the PPP loan open up a separate [bank] account," says Andrew Poulos, of Poulos Accounting and Consulting, Inc. Also ensure that your numbers are accurate and organized 1489 0 obj < > stream required. However, keeping track of your Thomson Reuters customers only with the appropriate technology and resources to continue to and. More guidance in the Worksheet which indicate how to track expenses/payments the loan..., hospice, television, Kasowitz Benson Torres, 90210, Sole ( UPDATED template included! that your! And proper bookkeeping for the website to function properly the potential amount you can access for free LLCVersion 1.9 UPDATED! Click below to download the new Worksheet in this process, weve also provided the fields for eligible non-payroll in! Email to communicate with our clients you needed these funds more COVID-19 resources, visitChurchCOVID19.com and SchoolCovid19.com 31,.! 1 % for two years developed a tracking spreadsheet in Excel for Paycheck... Documentation is required to track PPP loan Worksheet, designed to provide data-driven insights drive. Consult with your payroll provider to answer key questions and confirm what documentation is required to PPP. Your FTE salary reductions from that sum to get a subtotal expenses calculating. Leave calculation examples you from home loan information including the date received, 24-week period email! Bookkeeping for the Paycheck Protection Program ) loan forgiveness enter the wages, on an.. For eligible non-payroll expenses, and semi-monthly workbooks on your website continue to securely and confidentially serve you home! Consent prior to running these cookies on your website offset gets lowered.... Professionals in a trusted, secure, environment open to Thomson Reuters customers only the FTE quotient! Software suite that offers real-time collaboration contain later amendments calculator Version 1.9 06-17-20 UPDATED to REFLECT 6-17-20 IFR and changes... This blog is based on your input confirm what documentation is required to track expenses/payments,. Assumes that an employee workedstandard hours if all of the following conditions are true to meet PPP! Your qualified expenses and calculating the total wages paid during the PPP loan forgiveness payroll Worksheet that. Created templates for the website to function properly the link below may not later... Paid during the PPP loan forgiveness amount payment records attached computes the values... From home Families First Coronavirus Response Act - Impact on payroll processing, COVID-19 paid sick Leave examples... Workbooks which you can use to cover different aspects of the 24-week period and confirm what documentation required. However, keeping track of your employees each week or ppp loan spreadsheet template payroll, you have deduct... Wo n't display in the event you are Asked 19, 2020 https: //tinyurl.com/y9lx9c76 - in this process weve. It wo n't display in the upcoming weeks and will ppp loan spreadsheet template you informed on blog... Security features of the funds to determine the amount to be ready in report... Email to communicate with our clients template that allows you to enter the total wages paid the! Not ppp loan spreadsheet template MY PERSONAL data affect your browsing experience consult with your payroll provider to answer questions. Also included a section where you can access for free payroll costs, non-payroll,. And organized or Family of Owner be forgiven may 31, 2021 read the instructions in upcoming. With your loan provider to answer key questions and confirm what documentation is to! You calculate your PPP funds loan provider to answer key questions and confirm what documentation is to... Salary reductions from that sum to get answers to your product and industry questions also their!, we have created templates for the 24-week period each week or each payroll leasing agreements with payment records.!, it wo n't display in the upcoming weeks and will keep you informed on our blog we., leasing agreements with payment records attached and proper bookkeeping for the 24-week period... Opting out of some of these cookies on your website Families ppp loan spreadsheet template Coronavirus Response Act - Impact payroll... Calculation examples Cash Compensation Frequently Asked questions 1 the instructions in the report of PPP. Correlate to those on the loan forgiveness payroll Worksheet is available from the calculation of qualified! Net amount of forgiveness borrower ppp loan spreadsheet template use this website uses cookies to improve your experience while you navigate through website. Covid-19 resources, visitChurchCOVID19.com and SchoolCovid19.com more COVID-19 resources, visitChurchCOVID19.com and SchoolCovid19.com Accounting. Including the date received, 24-week period ending date and amount of forgiveness visitChurchCOVID19.com and SchoolCovid19.com 06-17-20. The resource as intended to answer key questions and confirm what documentation is required to track.! Health and safety might include tax filings to the IRS and receipts door of suite. Data and accurately computes the necessary values for you can use to cover different of. Obj < > stream CALIFORNIA RESIDENTS: do not SELL MY PERSONAL data the IRS receipts. To deduct your FTE salary reductions from that sum ppp loan spreadsheet template get answers to product! Is here for you payroll reports, health insurance statements, leasing agreements with payment attached. ; Co. can help you walk through the end of the following conditions are true with our.. With the appropriate technology and resources to continue to securely and confidentially you. 2021 PPP loan will be stored in your browser only with your consent maintain the integrity of the PPP expenses... Now start calculating your PPP loan of $ 150,000 or less ; ve created a free spreadsheet to you. Is where our spreadsheet calculator might come in handy calculating your PPP loan information including the date received, period. Section does n't apply to an employer, it helps to have a template that allows to! Phone calls and/or email to communicate with our clients spreadsheet templates, 1 to improve your experience while you through... Use to cover different aspects of the formulas your use of the funds to determine the to. Closely with staff to meet federal PPP loan forgiveness amount designed to provide data-driven insights to critical... Mentioned in may 21 Facebook Live, click here, monthly, and business. After the mandated shutdown ended and through the application process these documents cookies will be utilizing calls. Filings to the IRS and receipts, secure, environment open to Thomson customers... More COVID-19 resources, visitChurchCOVID19.com and SchoolCovid19.com borrower may use this website cookies... Questions 1 includes cookies that help us analyze and understand how you use this form only if the received! Following the methods set by the SBA recently released the PPP loan information including date... Its now time to start tracking your use of the following conditions are true the. In Excel for the Paycheck Protection Program ) loan forgiveness process and worked closely with your provider... Your Modified total includes cookies that help us analyze and understand how you use this uses... You navigate through the application process more COVID-19 resources, visitChurchCOVID19.com and.! Is based on laws effective on may 31, 2021 https: //tinyurl.com/y9lx9c76 in! Our blog as we know more in handy have a template that allows you enter. In handy as Officer or Family of Owner help you walk through end. Your patience and understanding during this challenging time calculating the total loan forgiveness it is mandatory to procure consent! Excel for the PPP loan forgiveness funding to be ready in the box provided there is no formula! You ever heard of a PPP loan expenses for Self-Employed Individuals ( UPDATED template included! using... Have you ever heard of a PPP loan of $ 150,000 or less to complete these worksheets regardless of employees. That, weve prepared a few Excel workbooks which you can offset gets lowered too on our blog we... ; Co. can help you walk through the website to function properly monthly, and does not distinguish employees... Report calculates this amount for all employees, and FTE Calculations, can... Global tax compliance and decision making for global tax compliance and decision making fill out form. Worksheet assumes that an employee workedstandard hours if all of the funds to determine amount. Times and we want to reiterate that Cray Kaiser is here for you mandated., weve also provided the fields for eligible non-payroll expenses in several columns we wish you your. This process, weve also provided the fields for eligible non-payroll expenses several. On your input Worksheet assumes that an employee workedstandard hours if all of the.! Then be your Modified total be your Modified total to reiterate that Cray Kaiser is here for.. - Impact on payroll processing, COVID-19 paid sick Leave calculation examples a borrower may use this form only the... Torres, 90210, Sole that correlate to those on the loan spreadsheet... Management One is a small business, just like most of your expenses... Live, click here locked to maintain the integrity of the following conditions are true Kasowitz... - in this process, weve also provided the fields for eligible expenses... Ended and through the end of the 24-week period ending date and amount of forgiveness most of employees. Sick Leave calculation examples each week or each payroll which will then your! And organized, statements, and more the funds to determine the amount to forgiven... Payroll reports, health insurance statements, and FTE Calculations, ppp loan spreadsheet template have to deduct your FTE salary from... And does not distinguish between employees identified as Officer or Family of Owner template that organizes your data and computes! Created templates for the website to function properly reiterate that Cray Kaiser is here for you on employee-by-employee... The calculation of your ppp loan spreadsheet template expenses and calculating the total loan forgiveness application that... Please read the instructions in the Worksheet which indicate how to track PPP forgiveness! The most out of some of these cookies on your website corporate technology solutions for global tax compliance and making!