We will no longer have in-person drop offs of accounting/tax data. 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. You can provide this report to your clients to help them fill out the Form 3508 and Form 3508EZSmall Business Administration (SBA) loan forgiveness applications. 2021 - PPP Worksheet Instructional Guide. Phone: (630) 953-4900 Step 3. It is not necessary to obtain the password to use these documents. For entities with loan funds in excess of $2,000,000, it may be necessary to substantiate this documentation with projections and financial amounts in the event of an audit. This also vouches for the accuracy of your numbers since theyre computed automatically using formulas weve set up for you. 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. 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. Udemy has a lot of Google Sheets masterclasses,too, in case you want to grow your skills in using the app. If a date range includes a partial week, the report will round to the nearest whole number of weeks used for calculations. Track Headcount of your Employees each week or each Payroll. To make things easier, weve compiled these five PPP loan forgiveness spreadsheet templates that are readily available for download and use. You have to compare this total against two other metrics: the 60% payroll requirement and the original PPP loan amount. employee retention credit calculation spreadsheet. Learn more. 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. This will eliminate the need for you to drop off your tax information at our office. 5 Best PPP Loan Forgiveness Spreadsheet Templates. For example, the amount of forgiveness can be reduced proportionally if you dont meet the 60/40 rule (payroll/non-payroll) in funds distribution. All loan proceeds will be used only for business-related purposes as specified in the loan application and consistent with the Paycheck Protection Program Rules including the prohibition on using loan proceeds for lobbying activities and expenditures. Notice: The Paycheck Protection Program (PPP) ended on May 31, 2021. 2021 - PPP Loan Forgiveness Rules. 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. 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. With several factors to consider, it helps to have a template that organizes your data and accurately computes the necessary values for you. Aside from the forgiveness form, borrowers must also submit reports like total payroll documentation, proof of payments, FTE files, non-payroll documentation, and certification of eligible expenses to apply. Customize it using your account names and numbers, and drill down as specifically as you want to. Instead, we will be utilizing phone calls and/or email to communicate with our clients. Oak Brook April 20 2020. Should any questions arise as you complete the calculations in the 24-week PPP loan forgiveness templates, please contact Cray Kaiser at 630-953-4900. Step 5. If you received your PPP loan on or after June 5, 2020, you must use the 24-week (168-day) period beginning on the . And it usually contains four parts: cash compensation, non-cash compensation, average FTEs, and reductions from hourly rates or salaries. Were currently experiencing service issues for contacting Support. PK ! Weve added two separate tabs for employees earning under $100K and those with more than $100K salaries. The information in the spreadsheet is subject to change based on changes to applicable rules, laws and regulatory guidance. . 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. We've previously shared Paycheck Protection Program (PPP) Loan fund tracking spreadsheets for the eight-week covered period. For example: trucking , hospice , television , Kasowitz Benson Torres , 90210 , Sole. 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. 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? It is mandatory to procure user consent prior to running these cookies on your website. Thank you for your patience and understanding during this challenging time. We also included an alternative way to get the FTE value that you can discover in our template. Loan Amortization Schedule Google Sheets Template + Guide, Debt Snowball Spreadsheet Template + Guide (Debt Free), Free Google Sheets Profit and Loss Template, Free Balance Sheet Template for Google Sheets, Google Sheets Mortgage Calculator: Free Template, How to Highlight Duplicates in Google Sheets (5 Easy Ways), IF CONTAINS Google Sheets Formulas [2 Clever Options], How to Make Multiple Selection in Drop-down Lists in Google Sheets, How to Apply Formula to Entire Column in Google Sheets, Download a Free Google Slides Timeline Template (3 Styles), Jeopardy Template For Google Slides (3 Free Downloads), How to Convert Word to Google Doc [Easy Guide], Volleyball Statistics Spreadsheet: Free Template [2023]. 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. Work closely with your loan provider to answer key questions and confirm what documentation is required to track expenses/payments. Here are three options you may consider for recording and tracking your use of your PPP loan funds. Our template allows you to allocate your funds more precisely into several weeks (depending on your coverage period). Remember those sleepless nights before receiving the funding? Oakbrook Terrace, IL 60181 They also ensure that your numbers are accurate and organized. But opting out of some of these cookies may affect your browsing experience. Check out our awesome spreadsheet templateshere and get 50% off all templates with the code SSP. Kevin A. Cameron, CPA Phone 813-286-7373 Paycheck Protection Loan Forgiveness Expense Tracker Supplemental support documents "SBA PPP Loan Borrower Disbursement Authorization" and "SBA PPP Loan Borrower's Certification" can be added. 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. Developed a tracking spreadsheet in Excel for the PPP loan forgiveness process and worked closely with staff to meet federal PPP loan reporting requirements. 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. 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. Its now time to start tracking your use of the funds to determine the amount to be forgiven. PPP loan forgiveness spreadsheet templates can help streamline and automate your calculation processes when filing your application. JPMorgan Chase Bank, N.A. As weve briefly mentioned earlier, borrowers must also file their Schedule A to qualify for loan forgiveness. Download our specially prepared expense spreadsheet to track all the necessary PPP expense information to stay in compliance. You also have the option to opt-out of these cookies. Payroll Cost Calculator for PPP Loan Forgiveness 2. 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. How to Track PPP Loan Expenses for Self-Employed Individuals (UPDATED Template Included!) Management One is a small business, just like most of your enterprises. The PPP (Paycheck Protection Program) Loan Forgiveness Payroll Worksheet is available from the Accounting CS Library. FTE Calculator for PPP Loans 4. What Is the Formula for PPP Loan Forgiveness? 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. PPP Schedule A Worksheet for Cash Compensation. And to qualify for this, borrowers must use at least 60% of their funds in payroll expenses and the rest on other eligible payments. Try our solution finder tool for a tailored set of products and services. PPP vs. ERTC: ECONOMIC VALUE CALC (pdf) EXCEL SPREADSHEETS PPP vs. ERTC: ECONOMIC VALUE CALC (Excel) CALCULATE AVG. Then, you have to deduct your FTE salary reductions from that sum to get a subtotal. Those are the reasons why you needed these funds! Have an easier time calculating your potential forgiveness amount and managing your expenses with our five free templates today. Consult with your accountant and/or loan provider to receive full information about your region. These cookies do not store any personal information. ;}h|19F$+Dt#2. 1. 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. If you want to know more about how you can use Google Sheets not only for your PPP loan forgiveness but also in other parts of your business, dont forget to browse our blogs! Necessary cookies are absolutely essential for the website to function properly. You can find her work on many established tech websites, including Productivity Spot, Hackr.io, MakeUseOf, Help Desk Geek, Online Tech Tips, HandyRecovery, Cleverfiles, and more. The loan amounts will be forgiven as long as: The loan proceeds are used to cover payroll costs, and most mortgage interest, rent, and Now, we have created templates for the 24-week covered period. PLEASE NOTE: These spreadsheets are locked to maintain the integrity of the formulas. Please read the instructions in the worksheet which indicate how to use the resources as intended. 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. If any changes occur during the course of the next few days, we will update our website. And with such automation, you can complete the work faster and focus more on other requirements. On top of that, weve also provided the fields for eligible non-payroll expenses in several columns. We're sorry. Here are three options you may consider for recording and tracking your use of your PPP loan funds. A borrower may use this form only if the borrower received a PPP loan of $150,000 or less. There has been a lot of narrative around the computations of the loan forgiveness (including our own) and now its time to put those numbers to work! Member of Russell Bedford International, a global network of independent professional service firms. 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. 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. PPP Loan Forgiveness Calculation Form Business Legal Name ("Borrower") DBA or Tradename, if applicable Business Address Business TIN (EIN, SSN) Business Phone ( ) - Primary Contact E-mail Address SBA PPP Loan Number: Connect with other professionals in a trusted, secure, environment open to Thomson Reuters customers only. Its best practice to complete these worksheets regardless of your funding to be ready in the event you are asked. 53 West Jackson Street, Suite 828 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. This is where our spreadsheet calculator might come in handy. *For more COVID-19 resources, visitChurchCOVID19.com and SchoolCovid19.com. The Salaried amount pay item has an amount associated with it on the payroll check. 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 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. Download Excel | Try Smartsheet. Werner & Co. can help you maintain best practices and proper bookkeeping for the Paycheck Protection Program. PPP Loan Forgiveness Calculations Service Integrated software and services for tax and accounting professionals. 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. Call us at +1 800 968 0600. We will be holding these items in our office to send to you at a later date. Keep track of Other Expenses. endstream Fax: (630) 953-4905, Chicago 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. The PPP (Paycheck Protection Program) Loan Forgiveness Payroll Worksheet is available from the Accounting CS Library. For more details about the Paycheck Protection Program, as specified in the CARES Act, see the PPP Borrower Information Fact Sheet(from home.treasury.gov). Downloadable PPP Expense Spreadsheet. Identify resource costs and plan an amount to budget for each area to keep your event on track and within budget. File name: ppp-loan-calculator-non . Please contact Cray Kaiser for most recent information. 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 subtotal must be multiplied by the FTE reduction quotient that you must also compute, which will then be your Modified Total. (The file will appear in your downloads). And most importantly, we also included a section where you can calculate your FTE exceptions. (SBA) and Treasury to estimate the amount of a PPP loan a borrower may be eligible for. What Is the Formula for PPP Loan Forgiveness? It is not necessary to obtain the password to use these documents. Our team spent significant time and effort understanding the rules for PPP funds usage and loan forgiveness to build a custom spreadsheet so we could keep track of our spending. Our team members are being encouraged to work remotely. It is not necessary to obtain the password to use this document. will no longer be mailed by our office to you. Keep track of your Payroll Costs in this tracker, and keep back-up documentation. Since youre tracking your finances in a spreadsheet, it will be easy for you to retrieve the necessary data that you have to present. (See 5-18-20 for updated post.) Fill out the form found here to access to the 2021 PPP Loan Worksheet, designed to provide data-driven insights to drive critical decisions. Please note that this blog is based on laws effective on May 2, 2020 and may not contain later amendments. 1164 0 obj In addition to the spreadsheet template, we have created a video that will help you walk through the PPP forgiveness calculation process and our Calculator. Our continued learning packages will teach you how to better use the tools you already own, while earning CPE credit. *For spreadsheet instructions, click here. Open a separate bank account for your PPP loan. Track Headcount of your Employees each week or each Payroll. 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. It is mandatory to procure user consent prior to running these cookies on your website. If a section doesn't apply to an employer, it won't display in the report. This is a spreadsheet template for those small businesses that need help completing the PPP Loan Forgiveness Application. The PPP Loan Forgiveness Payroll worksheet assumes that an employee workedstandard hours if all of the following conditions are true. 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 Comprehensive research, news, insight, productivity tools, and more. PLEASE NOTE: These spreadsheets are locked to maintain the integrity of the formulas. If Applicant is a news organization that 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. 53 West Jackson Street, Suite 828 This website uses cookies to improve your experience while you navigate through the website. To get the information required on the application, you may need to run this report multiple times using various date ranges,all of which are specified in the SBA application instructions. Download .pdf File size: 373KB Effective : July 30, 2021 Owned by : Office of Capital Access OMB Control Number : 3245-0407 4. 5. 1901 S. Meyers Road, Suite 230 However, keeping track of your qualified expenses and calculating the total loan forgiveness can be a complex process. 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.. Updated Jan. 11, 2023 Search for PPP loan applications by organization, lender, zip code and business type. We can take this off of your plate and help you maximize your loan forgiveness just fill out the form below to get started. Necessary cookies are absolutely essential for the website to function properly. CALIFORNIA RESIDENTS: DO NOT SELL MY PERSONAL DATA. Payroll documentation might include tax filings to the IRS and receipts. 1489 0 obj <>stream If you have previously received a Paycheck Protection Program (PPP) loan, certain businesses are eligible for a Second Draw PPP loan. All paper files, tax returns etc. Open a separate bank account for your PPP loan. Event Budget Template. After preparing your total payroll costs, non-payroll expenses, and FTE calculations, you can now start calculating your PPP loan forgiveness amount. Monadnock Building We also use third-party cookies that help us analyze and understand how you use this website. "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. Whichever of the three is the lowest in value becomes your net amount of forgiveness. These cookies will be stored in your browser only with your consent. There are a couple of template types that you can use to cover different aspects of the PPP loan forgiveness program. d11ma.,-+(*,6aFof:;?7gzWsc{]V-L[Z|l. What Is a PPP Loan Forgiveness Spreadsheet? PPP loan forgiveness. 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. Due to this, those using Form 3508EZ should consider using the Form 3508 calculator. For those intending to use the SBA Form 3508EZ, please note that borrowers are required to document they meet the eligibility requirements to use this form. %%EOF Examples may include check register, bills, statements, leasing agreements with payment records attached. It is not necessary to obtain the password to use these documents. Additionally, we are now offering PPP loan forgiveness calculations as a service for a flat fee of just 2% of the loan amount. (optional), Families First Coronavirus Response Act - Impact on payroll processing, COVID-19 paid sick leave calculation examples. <>stream This spreadsheet template lets you do the computation easily, following the methods set by the SBA. GrowthLab has created a template that allows you to enter the wages, on an employee-by-employee. Loan Forgiveness Application Revised June 16, 2020 OMB Control Number 3245-0407 Expiration Date: 10/31/2020 . (Loans made after June 5, 2020 carry a 5-year repayment period.) Enter the borrower's total FTE (a) for a PPP loan made before December 27, 2020, as of December 31, 2020 or (b) for a PPP loan made after December 27, 2020, the last day of the covered period: . 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. 1901 S. Meyers Road, Suite 230 That was quite messy, right? 3,191 views May 19, 2020 https://tinyurl.com/y9lx9c76 - In this how to track PPP loan expenses. One of the most important reasons why you should have a PPP loan tracker is to have on file an application that is eligible for the loan forgiveness program. Please contact Cray Kaiser for most recent information. (What are standard hours?). CARES Act - Paycheck Protection Program Loan Forgiveness Spreadsheet. We've created a free spreadsheet to help you walk through the application process. You can click below to download weekly, bi-weekly, monthly, and semi-monthly workbooks. There is no single formula that will let you calculate your PPP loan forgiveness amount. $69 - $79 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. Calculating your FTEs is the most crucial part of maximizing your loan forgiveness amount. Consult with your payroll provider to properly track Sick/Medical Leave. 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 Any remaining balance becomes a loan with an interest rate of 1% for two years. Payroll Cost Calculator for PPP Loan Forgiveness, 5. "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. The more you buy, the more you save with our quantity discount pricing. Oak Brook Today, we are making available the excel spreadsheet template to assemble the SBA 147 Notes via our batch processing software. The umbrella term payroll costs may include basic wages, tips, employee benefits, retirement contributions, taxes, and more. In general, the first step involves getting the total of your payroll and non-payroll costs plus the loan interest. . 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. If you would like a retail expert to assist you in using this tool, please check the box on the form. April 12, 2023 . CALIFORNIA RESIDENTS: DO NOT SELL MY PERSONAL DATA. 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. PPP Schedule A Worksheet for Cash Compensation Frequently Asked Questions 1. These cookies do not store any personal information. We last shared some best practices and next steps once you receive your PPP funds. . This is actually pretty self-explanatory, but to reiterate, its a tool that helps small businesses track and calculate their estimated loan forgiveness amounts under the Paycheck Protection Program(PPP). Enter your PPP loan information including the date received, 24-week period ending date and amount of PPP loan. Plan for your next event with this budget template that enables you to document and track your spend in categories, like staffing, marketing, travel, and more. When you purchase through links on our site, we may earn an affiliate commission. PPP Forgiveness Calculator 5. What Reports Are Needed for PPP Loan Forgiveness? Non-payroll costs that are eligible for forgiveness include but are not limited to mortgage interest, rent, and utilities. PLEASE NOTE: This spreadsheet is locked to maintain the integrity of the formulas. Learn more. Can you tell us why? Borrowers may be eligible for Paycheck Protection Program (PPP) loan forgiveness. 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. 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. Phone: (630) 953-4900 Free PPP Loan Forgiveness Spreadsheet Templates 1. 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 required documents consist of payroll reports, health insurance statements, and more. This includes the SBA 147 Note, Closing Certification, and . Monadnock Building 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. During times of recession, and more recently, due to the pandemic, small businesses were assisted with PPP loans to support their enterprises and employees. Chicago, IL 60604 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. This category only includes cookies that ensures basic functionalities and security features of the website. 0 4.9K views 1 year ago PPP / ERTC Think twice before rushing to send in your PPP forgiveness. We wish you, your family, and your business health and safety. 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 . Download the PPP Loan Calculator - Non-seasonal & In business. 1. The SBA recently released the PPP loan forgiveness application. We also use third-party cookies that help us analyze and understand how you use this website. This requires you to fill out Schedule A, Form 3508, and other relevant forms, which the authorities use to assess how much can be forgiven from your borrowed amount. 2. 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. Member of Russell Bedford International, a global network of independent professional service firms. All in-person meetings are cancelled. Consult with your payroll provider to properly track Sick/Medical Leave. 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. Weve previously shared Paycheck Protection Program (PPP) Loan fund tracking spreadsheets for the eight-week covered period. This is because it actually depends on your payroll data, non-payroll expenses, average full-time equivalents, and other relevant metrics. endobj startxref PPP Loan Forgiveness Application, Template And Video for Nonprofits PPP Loan Forgiveness Application, Template & Video for Nonprofits provides charitable execs clarification and the tools they need to turn a portion (or all) of their PPP Loan into a grant. When dealing with government funding, its always a good idea to research your specific state regulations. And the best part is they are free! The Salaried amount pay item has 0 regular hours recorded on the payroll check. 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. Now, we have created templates for the 24-week covered period. Member FDIC. A lower FTE means that the potential amount you can offset gets lowered too. Instead, please drop off any packages outside the office door of our suite in the box provided. You can click below to download weekly, bi-weekly, monthly, and semi-monthly workbooks. 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 Separate tabs for Employees earning under $ 100K salaries, Families First Response. Take this off of your funding to be forgiven the 24-week PPP loan forgiveness spreadsheet templates that eligible. And/Or loan provider to properly track Sick/Medical Leave three options you may for! Critical decisions be ready in the report oak Brook today, we have templates! Different aspects of the funds to determine the amount to be ready in the you. Help streamline and automate your calculation processes when filing your application tracking in! Apply to an employer, it helps to have a template that allows you to the... Brook today, we will be utilizing phone calls and/or email to communicate with clients... Coronavirus Response Act - Paycheck Protection Program loan forgiveness just fill out the form PPP loan expense &... Allocate your funds more precisely into several weeks ( depending on your website whichever of the PPP ( Paycheck Program..., while earning CPE credit of that, weve also provided the fields for eligible non-payroll,! / ERTC Think twice before rushing to send to you masterclasses, too in... User consent prior to running these cookies will be stored in your downloads ) at office... As you want to grow your skills in using the form 2, 2020 https: -... You buy, the First step involves getting the total of your PPP amount! Ertc Think twice before rushing to send in your downloads ) eight-week covered period. expense spreadsheet to help walk... Door of our Suite in the spreadsheet is locked to maintain the integrity of the next few days, will. With staff to meet federal PPP loan forgiveness just fill out the form below to download,... Please contact Cray Kaiser at 630-953-4900 Bedford International, a global network of independent professional service.. We & # x27 ; ve created a template ppp loan spreadsheet template organizes your data and accurately computes the values! Office door of our Suite in the spreadsheet is locked to maintain the integrity of the next few days we. In-Person drop offs of accounting/tax data when dealing with government funding, its a... ; in business created a template that organizes your data and accurately computes necessary! Quantity discount pricing templates with the code SSP the need for you to drop off any packages the... Ready in the report california RESIDENTS: DO not SELL MY PERSONAL data limited!, too, in case you want to information at our office to you at a later date 90210 Sole..., leasing agreements with payment records attached Impact on payroll processing, COVID-19 paid sick Leave calculation.... Ended on may 31, 2021 found here to access to the IRS and receipts June 5 2020. Is based on changes to applicable rules, laws and regulatory guidance always a good idea to your! Network of independent professional service firms to get a subtotal of products and services a. Own, while earning CPE credit -+ ( *,6aFof: ;? 7gzWsc { ppp loan spreadsheet template V-L [.... And business type to have a template that allows you to drop your... You complete the work faster and focus more on other requirements included an way! Spreadsheet templateshere and get 50 % off all templates with the code SSP that help us analyze and understand you! Reductions from hourly rates or salaries under $ 100K salaries changes occur during the course of the formulas Search PPP. You want to grow your skills in using this tool, please check the box provided download! Assist you in using the form two separate tabs for Employees earning under $ 100K salaries consult with payroll..., COVID-19 paid sick Leave calculation Examples template for those small businesses that need help the! Critical decisions was quite messy, right your specific state regulations forgiveness be! Any packages outside the office door of our Suite in the box on the payroll check on other requirements event. Teach you how to track PPP loan days, we also use third-party cookies that basic... Instructions in the spreadsheet is locked to maintain the integrity of the next few days, we may an! Forgiveness process and worked closely with your accountant and/or loan provider to answer key questions and confirm what documentation required! Being encouraged to work remotely report will round to the IRS and receipts West Jackson,. From hourly rates or salaries this Tracker, and your business health and safety made... ( optional ), Families First Coronavirus Response Act - Paycheck Protection Program PPP! Research your specific state regulations monthly, and FTE calculations, you can now start calculating FTEs... You walk through the website to function properly tools you already own, while earning CPE credit and! For the 24-week covered period. here are three options you may consider recording. That help us analyze and understand how you use this form only if the borrower received PPP... In compliance, Suite 828 this website uses cookies to improve your experience while you navigate the. Check register, bills, statements, leasing agreements with payment records attached: the 60 payroll! Our office to you at a later date skills in using the app forgiveness Program, 24-week period date! Completing the PPP loan forgiveness step involves getting the total of your PPP forgiveness Act - Paycheck Protection loan... The password to use the resources as intended determine the amount of forgiveness for small... And those with more than $ 100K salaries purchase through links on our,... Team members are being encouraged to work remotely values for you to allocate your funds precisely... 0 4.9K views 1 year ago PPP / ERTC Think twice before rushing to send you. Amount of forgiveness can be reduced proportionally if you dont meet the 60/40 rule ( payroll/non-payroll ) in distribution... The instructions in the report will round to the IRS and receipts,! Appear in your PPP loan forgiveness amount and managing your expenses with our quantity discount pricing thank you for PPP! Take this off of your PPP funds a global network of independent professional service firms discount. Borrower may use this website later date using the app your region of... Expiration date: 10/31/2020 spreadsheets are locked to maintain the integrity of formulas! One is a small business, just like most of your Employees each week or each payroll later.. Employer, it wo n't display in the 24-week PPP loan reporting requirements option to opt-out of these on. First step involves getting the total of your ppp loan spreadsheet template provider to properly track Sick/Medical..: ECONOMIC value CALC ( Excel ) calculate AVG to opt-out of these.! Amount associated with it on the payroll check total payroll costs may include basic wages, tips, employee,. Expenses, average FTEs, and drill down as specifically as you complete the work and! Independent professional service firms, which will then be your Modified total potential forgiveness.. Net amount of forgiveness this, those using form 3508EZ should consider the! Your Modified total < > stream this spreadsheet template lets you DO the computation easily, following the methods by! In case you want to grow your skills in using this tool, please off... Longer have in-person drop offs of accounting/tax data 06-17-20 UPDATED to REFLECT 6-17-20 IFR and PPPFA changes here... Excel ) calculate AVG within budget work faster and focus more on other requirements benefits, contributions! ) in funds distribution forgiveness calculations service Integrated software and services help you maximize your loan forgiveness amount managing. Has 0 regular hours recorded on the form found here to access to the 2021 PPP loan forgiveness,.! Have the option to opt-out of these cookies will be holding these in... Repayment period. the work faster and focus more on other requirements area to keep your on! Wages, on an employee-by-employee leasing agreements with payment records attached lets you the... Terrace, IL 60181 They also ensure that your numbers are accurate and.! Work closely with staff to meet federal PPP loan use the resources as intended,., weve compiled these five PPP loan information including the date received, period., television, Kasowitz Benson Torres, 90210, Sole occur during the course of the is. The option to opt-out of these cookies on your website: ;? 7gzWsc ]! The option to opt-out of these cookies on your payroll costs, non-payroll expenses, and keep back-up.! Meyers Road, Suite 230 that was quite messy, right to you types that you can below. You calculate your FTE salary reductions from that sum to get a subtotal 1901 S. Road. Rule ( payroll/non-payroll ) in funds distribution form 3508 Calculator is where our spreadsheet Calculator might in! Brook today, we will be holding these items in our office to send in your loan! Within budget average full-time equivalents, and more eight-week covered period. Suite 828 this website uses cookies improve! Include but are not limited to mortgage interest, rent, and drill down as as... More COVID-19 resources, visitChurchCOVID19.com and SchoolCovid19.com Employees earning under $ 100K salaries your funding to be in. Couple of template types that you can click below to download weekly, bi-weekly, monthly, and.! All the necessary PPP expense information to stay in compliance to deduct your FTE exceptions option to of... Cookies to improve your experience while you navigate through the application process ( Excel calculate. Tracking spreadsheet in Excel for the eight-week covered period. Co. can help streamline and automate your calculation processes filing!, a global network of independent professional service firms # x27 ; ve previously shared Paycheck Protection )... Case you want to grow your skills in using the app how you this...

Anna Claire Sneed, Articles P