In your Company Dashboard, click Covid-19. PPP forgiveness calculator - Prior version (5/22/20 - 6/17/20) - Excel. Free Sba Ppp Schedule A Worksheet Excel The Paycheck Protection Program Flexibility Act made some significant changes to PPP loans.. One of the biggest changes was to the eight-week forgiveness period. Complete the PPP Schedule A Worksheet or obtain an equivalent report from the Borrower's payroll system or payroll processor. There was no change to the formula for any non-owner employees that the company may have. PPP Loan Forgiveness Application: Guide to SBA Form 3508 The maximum loan amount is based on a business's average monthly payroll cost (931s and/or line 31 of Schedule C Form 1040). Owner/employee compensation is not be included in PPP Schedule A Worksheet, Table 1 or 2. PPP Loan Forgiveness Application Guide [UPDATED] | Gusto Part 3: The PPP Schedule A Worksheet; and. . We also do not limit if that period is under 8 or 24 weeks, as some clients may want to run this report during their loan period to estimate changes they need to make. 8-week period (or now 24-week period under PPPFA) after the loan is made . PPP loan forgiveness calculator (revised 6/19/20) PDF CARES PPP Loan Forgiveness Report Can calculate part time employees one of two ways: Number of hours divided by 40. Please note if applying for PPP loan PPP Schedule A Worksheet is not required to be submitted to the lender; however, we think it is prudent to use this worksheet to work through both the FTE calculation and Wage Reduction calculation. The workbook was designed to be used by borrowers as a planning tool for maximizing forgiveness for PPP1 when it was originally an 8-week program. Line 2 Average FTE from PPP Schedule A Worksheet, Table 1. The PPP Loan started straightforward but has become increasingly complex. Sample Loan Forgiveness Calculator Ver 1.4 (Sample Data for Observation) Note: Spreadsheet is best used as a desktop app Excel, not used in the Browser. . - Submit PPP Schedule A and Substantiation - Lender has 60 days to review and make a decision; SBA has another 90 days after that. Algebra Worksheets Pdf Grade 7 Keep in mind that there are changes coming in the pipeline, such as instead of an 8-week PPP period that is proposed, to change from 16 to 24 weeks. Average FTE: Ppp schedule a worksheet table 1 excel. Available through Leimberg at https://new.leimbergservices.com/wdev/products.cfm?id=66January, 22 2021 Version 2.0 version here https://youtu.be/rMsO4oGdK30C. PDF Paycheck Protection Program (PPP) Document Worksheet Schedule C borrowers: As of March 3, 2021 the SBA has approved two formulas to calculate the self-employment income for the owners of companies which file a Schedule C; one based on net income (line 31 of the Schedule C) and one based on gross income (line 7 of the Schedule C). Box 1. by. PPP Schedule A Worksheet has Table 1 and Table 2 which asks for employee name, employee identifier, cash compensation, average FTE, and salary . Eligible borrowers able to receive 2.5are x themonthly payroll amount based The PPP (Paycheck Protection Program) Loan Forgiveness Payroll Worksheet is available from the Accounting CS Library. We recommend all borrowers consult with their bank, legal, financial, and business . Line 3. d. UPLOAD Documents. This guide is being provided to assist you in the completion of your PPP forgiveness application. Again we expect the banks to have different interpretations of which expenses qualify but we recommend to start gathering this . If you paid all of your employees at least 75% of . Line 12: Modified total (line 10 X line 11) Line 13: PPP loan amount. Step 4: Record your PPP Loan Amount. Calculate potential forgiveness amounts. Visit our COVID-19 Resource Center for other insights and tools surrounding the CARES Act . Choose the Schedule A tables that match the forgiveness period you have selected, either 8-week or 24-week. Excel Spreadsheet Template for tracking PPP expenses QuickBooks Guidance for tracking PPP expenses. Excel Spreadsheet Template for tracking PPP expenses 2. Complete Schedule A (3508 Only) a. for now, the length of that period is now 24 weeks, thanks to the PPP Flexibility Act. Table Instructions . Step 1 • Begin to gather substantiation needed now. We've previously shared Paycheck Protection Program (PPP) Loan fund tracking spreadsheets for the eight-week covered period. is $15,385, for a 24-week Covered Period, the maximum is $46,154. Documentation supporting the PPP Schedule A Worksheet . The SBA released the PPP loan forgiveness application on May 16, 2020. If this has changed since 2019, select the frequency you were using during the 8-week forgiveness period. self-employed farmers or ranchers (i.e., those who report their net farm profit on IRS Form 1040 Schedule F), use IRS Form 1040 Schedule F in lieu of Schedule C above. Instructions for PPP Schedule A . There is a new question on the main calculator tab asking if the company has been unable to return to prior operating levels due to health restrictions, if yes, then the FTE calculation reverts to 100%. Table Instructions . 4 Or the date you submit the forgiveness request if you submit before the end of the 24-week Covered Period. SBA Form 3508 is made up of several parts including (1) a Loan Forgiveness Calculation Form, (2) a PPP Schedule A, (3) a PPP Schedule A Worksheet, (4) a list of documents and information that must . Please read the instructions in the worksheet which indicate how to use the resources as intended. c. Option (2): If calculations have already been made, numbers can be plugged directly into the corresponding fields without the need for the excel sheet. For payroll costs and/or fte calculation, the wages on the employee wage details, worksheet table 1, 2, and summary tabs will be calculated to match the payroll cost and/or fte on the loan period details tab. This is from PPP Schedule A Worksheet, table 1. 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 goal now is to use PPP funds exclusively on payroll over the 24 weeks. Table 1 Within ten months following the sooner to occur of: (a) the end of the borrower's use of the PPP funds (i.e., the 8 or 24-week period), or (b) December 31, 2020, the borrower must submit the application . It was created based on guidance provided by the SBA in effect at the time of its creation. SBA Guidance continues to come, we update the spreadsheet and notify registered users. Now, we . Option (1) Download the Excel Worksheet b. When calculating the FTE Reduction Exceptions in Table 1 of the PPP Schedule A Worksheet on the Loan Forgiveness Application, do borrowers include employees who made more than $100,000 in 2019 (those listed in Table 2 of the PPP Schedule A Worksheet)? June 15, 2020 PPP Spending Tracker SEK has created an Excel template for your use in tracking expenses related to the PPP loan. June 26, 2020 A business, at its election, has either eight weeks or twenty-four weeks to spend the total PPP loan proceeds on payroll costs, mortgage interest, rent, and utilities and only those costs which are well documented will be eligible for forgiveness. PLEASE NOTE: These spreadsheets are locked to maintain the integrity of the formulas. a. Click PPP Loan Forgiveness Report. Under the PPP Flexibility Act of 2020, the covered period has been extended to 24 weeks. • PPP Schedule A Worksheet is not required to be submitted but must be • Determine if you qualify for EZ form or need to file the Long Form. 5 The selected time period must be the same time period selected for purposes of completing PPP Schedule A, line 11, available on page 3 of the Loan Forgiveness Application Instructions for Borrowers. 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 loan disbursement date. We have updated the PPP tracker spreadsheet, find it HERE.As a reminder, the revised PPP rules allow for a 24-week period versus the original 8-week period. Ppp schedule a worksheet excel 24 weeks. PPP Forgiveness Updated: June 9, 2021 . Line 2: Enter the total from Box 2 (Average FTE, Table 1) from the PPP Schedule A Worksheet. Step 5: Divide your payroll cost by .75. This is the average full-time equivalency (FTE) during the Covered Period or the Alternative Payroll Covered Period Line 3 Total Salary/Hourly Wage Reduction (Box 3) from PPP Schedule A Worksheet, Table 1. 2. FTE loan forgiveness calculation #1. If there is more than one individual included, attach a separate table that lists the names of and payments to . Fill out and Upload Excel Worksheet based using instructions provided on worksheet. Line 3: Enter the total from Box 3 (Salary/Hourly Wage Reduction) from the PPP Schedule A Worksheet. Page . 3) Get the 8-week (or 24-week) $ value of the reduction (Multiply Step 3c2 by 8) This is the estimated pay reduction for this employee, which may result in a reduction to your forgiveness amount. FTE Reduction Quotient (divide line 12 by line 11) or enter 1.0 if FTE Safe Harbor is met. 06/18/2020 7:20:31 PM. Click here to download our Example PPP Loan Forgiveness Spreadsheet, as mentioned in the May . The first way to calculate FTE is to take the average number of hours paid each week, divide by 40, and round to the nearest tenth. 8- or 24-week period that starts with the first day of the pay period after the loan disbursement date Again, if you received your loan before June 5, you can choose between using an 8- or a 24-week period. If there's one thing that CPAs love to do, it's taking a form and developing an exc. PPP forgiveness calculator - Short form 3580EZ - fillable PDF. Alternative Payroll Covered Period: • Businesses that have a biweekly (or more frequent) payroll schedule may choose an Alternative Payroll Covered Period instead of the Covered Period. Part 4: The PPP Borrower Demographic Information Form, an optional survey for PPP borrowers. If the borrower received its ppp loan proceeds on monday, april 20, and the first day of its You'll need this information to calculate how much forgiveness your business can qualify for. The Treasury defines a full-time employee as an employee who works 40 or more hours per week, so FTE is calculated on a scale of 1.0, with 1.0 being the equivalent of 40 hours . Lines 1 through 5: Enter the amounts from PPP Schedule A Worksheet Tables as directed. In . may elect instead to use any consecutive 12-week period between February 15, 2019 and February 15, 2020. Learn more about PPP loan forgiveness → Important note about this report. Covered Period: Calculate the period starting from your disbursement date to 24 weeks (168 days) after. June 4, 2020 www.postschell.com PPP Worksheet Table 1: • This tab will track the employee Name, Identifier, Cash Compensation (from the Employee Worksheet Tab) • This requires the input of the number of hours an employee worked during a specific week. Instructions for PPP Schedule A Worksheet . The bottom line is that, while the PPP forgiveness process still has some details that need to be worked out, we are now gaining more clarity by the day. Enter the amount from line 3 of PPP Schedule A on line 5 of the Loan Forgiveness Application Form. Please contact Cray Kaiser for most recent information. Here's how to fill out the simplified SBA Form 3508EZ.For loan amounts less than $150,000, you can use the new Form 3508S.. On May 18, the SBA released the official form you'll need to fill out in order to apply for forgiveness on your PPP loan, also known as SBA Form 3508. Instructions. If borrowers received the PPP loan before June 5, 2020, the borrower may elect an 8-week covered period as established in the original CARES Act. For clients who use Full 3508: The maximum loan amount is based on a business's average monthly payroll cost (931s and/or line 31 of Schedule C Form 1040). Click here to download our PPP Loan Forgiveness Spreadsheet to help walk you through the application process. An employee working 40 hours or more will be 1.0 FTE. It has been updated on June 15th to reflect recent guideline changes. Enter Salary/Hourly Wage Reduction (Box 3) from PPP Schedule A Worksheet, Table 1: If the average annual salary or hourly wage for each employee listed on the PPP Schedule A Worksheet, Table 1 during the Covered Period was at least 75% of such employee's average annual salary or hourly wage for the most recent full quarter before Total of 5 months. 24 weeks the $46,153.68 will need to be reduced Clients should rerun payroll reports just prior to submitting . Details: Ppp Schedule A Worksheet Excel 24 Weeks - worksheeta - https: 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. Enter Salary/Hourly Wage Reduction (Box 3) from PPP Schedule A Worksheet, Table 1: If the average annual salary or hourly wage for each employee listed on the PPP Schedule A Worksheet, Table 1 during the Covered Period or the Alternative Payroll Enter the date of the first day of the covered period you want forgiven, and the covered period. covers both the 8-week Covered Period and 24-week Covered Period options. This is from PPP Schedule A Worksheet, table 1. Download the Information Checklist to Apply for PPP Loan Forgiveness. Table 1 PPP Schedule A Worksheet, Table 2 Totals PPP Schedule A Worksheet, Table 1 Totals Non-Cash Compensation Payroll Costs During the Covered Period or the Alternative Payroll Covered Period 0 1.0 $50,000.00 5.0 $0.00 $1,500.00 $2,000.00 $1,000.00 $56,500.00 1.0 5.0 1.0 $2,000.00 $0.00 SBA Form 3508 (06/20) • Loans disbursed after 6/5 will default to 24 weeks. PPP Schedule A (unless submitting a 3508EZ Application) Completed PPP Schedule A and PPP Schedule A Worksheet (or an equivalent report from your payroll system or payroll processor) Payroll Costs: FTEs Documents showing the average number of FTE employees on payroll per week employed by the Borrower between February 15, 2019 and June 30, 2019; OR The covered period begins on the date the loan is funded and continues for 24 weeks. Ad the most The easiest way to fill out the Schedule A is to break it up into three sections, which we'll cover. Divide . Alternative Covered Period (8 weeks or 24 weeks). This report runs based on data in OnPay. FREE PPP Loan Forgiveness Ver 1.4 (Blank for your use) 2. Choose the Schedule A tables that match the forgiveness period you have selected, either 8-week or 24-week. Note: although no guidance has been provided, a salaried employee should be listed as working 40 hours a week We then modified it to accommodate the expansion to 24 weeks but with the 24 weeks, the additional eligible costs, etc., the need for planning is not as great as it previously had been. *For . is $15,385, for a 24-week Covered Period, the maximum is $46,154. Of you received your loan prior to June 5th, 2020 you can use . The result is OPTION 3. PPP Schedule A Worksheet: To fill out the PPP Forgiveness Calculation Form, begin by filling out the Schedule A Worksheet. When you run the report, plug in the date range for your coverage period or alternative coverage period. Step 3: Multiply this number by the FTE Reduction Quotient (Schedule A, line 13) The result is OPTION 1. The PPP Schedule A Worksheet; PPP Borrower Demographic Information Form (optional) . Last week, the Treasury issued an FAQ to provide a recovery period to public companies that took PPP loans when they had adequate resources. Format: PDF or Excel only. The loan forgiveness calculators use available guidance from the Small Business Administration (SBA) and Treasury, along with interpretations of . Here are our takeaways for churches, Christian schools, and nonprofits. Simply start with the 8-week version, then Copy and Paste your Input data to the 24-week input worksheets, add the additional data for the extended period and continue. Example -Sam works 25 hours per week When you run the report, plug in the date range for your coverage period or alternative coverage period. . If the average annual salary or hourly wage for each employee listed on the PPP Schedule A Worksheet, Table 1 during the Covered Period or Alternative Payroll Covered Period was at least 75% of such employee's average annual salary or hourly wage between January 1, 2020 and March 31, 2020 select "Yes" from the drop down menu Total of 5 months. 3. and enter the total into . This period will automatically be reflected in the Schedule A worksheet. i. Download Spending Tracker Please note there is a sample tab and a tab for your use. b. Payroll Information • If the loan was disbursed before 6/5, choose which duration you would like to use for your cover period (8 weeks or 24 weeks). Average FTE: 1. Box 2. This is a comprehensive collection of free printable math worksheets for grade 7 and for pre algebra organized by topics such as expressions integers one step equations rational numbers multi step equations inequalities speed time distance graphing slope ratios proportions percent geometry and pi. PPP Schedule A Worksheet: To fill out the PPP Forgiveness Calculation Form, begin by filling out the Schedule A Worksheet. *if the average annual salary or hourly wage for each employee on Schedule A worksheet, Table 1 during the Covered Period was at least 75% of such employee's average annual salary or hourly wage for the most recent full quarter before the Covered Period--- please enter a zero here. • Begin to gather substantiation needed now. 1. of . Note: If you're self-employed, you can save time applying for PPP forgiveness with the new EZ Form. PPP Forgiveness Web Portal Application Guide - Form 3508 . Post & Schell, P.C.'s Paycheck Protection Program Loan Forgiveness Tool. - Submit PPP Schedule A and Substantiation - Lender has 60 days to review and make a decision; SBA has another 90 days after that. Step 6: Your PPP Loan forgiveness amount will be LESSER between Options 1, 2 and 3.