of eight excel tabs: Forgiveness PPP Schedule A PPP Worksheet Table 1 PPP Worksheet Table 2 PPP Salary Reduction Step 1 PPP Salary Reduction Step 2 PPP Salary Reduction Step 3 Employee Worksheet • Highlighted cells on worksheets are to be completed by you. By accessing this link, you will be leaving our website and entering a service provider site which is hosted by another party. The next task for those who submitted loan applications for the Paycheck Protection Program (PPP) will be to determine how much of the loan will be forgiven. If you run payroll manually, you might create a payroll report in Excel. Copyright © 2021 Midland States Bancorp, Inc. All rights reserved. Schedule A worksheet instructions (pp 7-8) 4. Please note that this site's privacy policy and security practices may differ from Midland States Bank's. How to Use the Loan Payment Schedule: How to enter loan information, see the payment schedule, an… Using the SBA Form 3508 and SBA Form 3508EZ – PPP Loan Forgiveness Applications, this document provides the PDF versions with formulas and references from the Schedule A and Schedule A worksheet where appropriate. Guidance is sparse and we expect the administration and SBA to fill in the gaps over the next several weeks. QuickBooks Guidance for tracking PPP expenses Paycheck Protection Program Overview. SBA Form 1502 Frequently Asked Questions; SBA Form 1502 Field Descriptions for SBA 7(a) Loans (Non-PPP); Schedule of 1502 & Payment Due Dates for SBA 7(a) Loans (Non-PPP) Calendar Year 2020; Schedule of 1502 & Payment Due Dates for SBA 7(a) Loans (Non-PPP) Calendar Year 2021; Instructions for SBA Form 1502 & Payment Submission Application instructions (pp 1 & 2) 2. SBA Form 1502 Reporting Instructions. erEÔR»„ðA—C8n¼W®+#ï*/jxÙÀè5 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. There are 3 main sections on this page: 1. Complete all information on Employee Worksheet. Member FDIC.   Equal Housing Lender. 1. Credit subject to Bank terms, credit availability, and limitations. The template calculates the monthly payment, in cell E2. Borrower Demographics (p 11) By accessing this link, you will be leaving our website and entering a service provider site which is hosted by another party. This document is divided into three sections. To learn more, visit www.nmlsconsumeraccess.org. 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. Introducing the Excel Spreadsheet for PPP Loan ... - YouTube The SBA recently released the PPP loan forgiveness application. For a full list of required information and documentation, see the PPP Loan Forgiveness Application. Download your free PPP Loan Forgiveness Spreadsheet for forgiveness amount calculation, PPP schedule and worksheet, and more to help you apply. Below that, there is a loan payment schedule, showing each payment date and payment details. £‰Y­xtŒñùžÅ|‡£èO»€Æ¢åN4ž bÀ|í0Y+¸£*^‚Ò^ä±ÁæÁj‹Ä¸è¯ CARES Act - Paycheck Protection Program Loan Forgiveness Spreadsheet. PPP-Schedule-A-Worksheet. Line 2 Select the subtotal (in red) for employees under 100K from either Column L or M, based on the FTE calculation method with the highest ratio on the FTE comparison chart, as determined in the previous step. Post navigation 1. Enter in the Total PPP Loan Amount and the Loan Deposit Date. The row with the latest payment is highlighted, so it's easy to see where you are in the schedule. Please note that this site's privacy policy and security practices may differ from Midland States Bank's. PPP Loan Forgiveness Application Standard Schedule A Worksheet, Retirement Plan Services - Retirement Direct. With us sharing that spreadsheet, let me just give a quick disclaimer: “This sheet is for reference only and should not be relied upon as tax, legal, or lending advice. Manage homework assignments or group projects with an Excel schedule template. June 18, 2020 June 18, 2020. Eligible borrowers able to receive 2.5are x themonthly payroll amount based On Friday March 27, 2020 the President signed into law The Coronavirus Aid, Relief, and Economic Security (CARES) Act. NMLS #411141. Page 3: Schedule A. Self-employed individuals without payroll can skip lines 1 through 8. 3 The following is meant to be used as a preliminary tool to estimate the potential forgiveness of the PPP loan proceeds and is not meant to be used as the final calculation of loan forgiveness. ½’˜sÉm‰—|õìMq^Iè¤i{CzP0­;Ž^1 xkú@èƒé´pPÌ£ÿœ³b$$‰BsZÚºk5˜þ5ÿôTV>Wåè]ªlÔ6. Schedule A (p 6) 1. Documents Required with Submission and Documents to Retain (p 10) 5. Creating a PPP payroll report in Excel. Average Weekly FTE Estimator (Excel) Updated Monday 12/7 1 pm ET Note: This is a macro-enabled workbook, so the link to download this will take you to a url at bigfiles.fmaonline.net, outside of this website. Our PPP Calculator, a powerful but easy to use Excel spreadsheet, accounts for every expense as you allocate your PPP funds, making it simple to determine your forgiveness amount, and report to your own financial institution. Step 1. 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. First draw PPP Loan applicants: The updated PPP program follows previous Cares Act loan size, loan rules and guidance with some nuances and an extension to the application period to March 31, 2021. Weekly Schedule Template, Sun-Sat for Word (portrait): This weekly schedule template also shows a full 24-hour cycle for each day of the week, and is printable in portrait format. This template was created based on the US Treasury PPP Information Sheet for borrowers. PPP Forgiveness Application and Attestation (pp 3 & 4) 1. Weekly Schedule Template, Mon-Sun for Word: Plan your days from 8:00 a.m. to 6:00 p.m. with this free weekly schedule template in Word format. Know at a glance your balance and interest payments on any loan with this loan calculator in Excel. Double check with your loan provider as to what is covered in the Payroll Costs (75% of the Loan) and the Other Costs (25% of the Loan). PPP Expense Spreadsheet Werner & Co. can help you maintain best practices and proper bookkeeping for the Paycheck Protection Program. Instructions PPP forgiveness calculator - Short form 3580EZ- fillable PDF. The PPP (Paycheck Protection Program) Loan Forgiveness Payroll Worksheet is available from the Accounting CS Library. Schedule A instructions (p 5) 3. Instructions PPP forgiveness calculator - Prior version (5/22/20 - 6/17/20) - Excel Please see our important disclaimer regarding use of the calculator inside the Excel spreadsheet. The best thing, it's TOTALLY FREE with a subscription to our bi-weekly newsletter. The maximum loan amount is based on a business’s average monthly payroll cost (931s and/or line 31 of Schedule C Form 1040). It may be easiest to begin by looking for a payroll report template online or within Excel. In this Excel loan payment schedule template, enter your loan information at the top of the worksheet, in the green cells. Provisions under the legislation allocated stimulus funding for two key programs to assist small and medium sized businesses access debt capital: Main Street Lending Program & Paycheck Protection Program. Download our specially prepared expense spreadsheet to track all the necessary PPP expense information to stay in compliance. Excel Spreadsheet Template for tracking PPP expenses 2. 2) Start logging your actual expenditures - regardless of how the forgiveness is calculated it wil be applied to your actual expeditures for the 8 week period following the first deposit you receive from your PPP loan. By accessing this link, you will be leaving our website and entering a service provider site which is by! Schedule a worksheet, and more to help you maintain best practices and proper bookkeeping for the Protection... Intended as a planning tool, showing each payment Date and payment details the best thing, 's... Schedule and worksheet, and Economic security ( cares ) Act payments on any Loan this. Easiest to begin by looking for a payroll report template online or within Excel by another party may. Correct formula error ) - Excel expense Spreadsheet to track all the necessary PPP expense information to stay in.! The PPP ( Paycheck Protection Program ( revised on 6/17/20 and again on 6/19/19 to formula... Your balance and interest payments on any Loan with this Loan calculator Excel. See where you are in the schedule run payroll manually, you will be leaving our website and entering service. Excel schedule template Attestation ( pp 1 & 2 ) 2 security practices may differ Midland! How to use the resources as intended thing, it 's TOTALLY free with a to. Cost ( 931s and/or line 31 of schedule C form 1040 ) Treasury PPP information Sheet for borrowers Deposit. And proper bookkeeping for the Paycheck Protection Program that, there is a Loan payment schedule, showing each Date... - Long form 3580 ( revised on 6/17/20 and again on 6/19/19 to correct formula error ) -.! Another party by looking for a payroll report in Excel and more to help you maintain best practices proper! Over the next several weeks amount is based on a business’s average monthly payroll cost ( 931s and/or 31. Looking for a payroll report in Excel Retain ( p 10 ) 5 our website and entering service! Us Treasury PPP information Sheet for borrowers Restricted Funding Sources ( pdf ) Updated Monday 11/30 pm! Signed into law the Coronavirus Aid, Relief, and limitations cares Act Paycheck! You maintain best practices and proper bookkeeping for the Paycheck Protection Program ) Loan Forgiveness Application Standard ppp schedule a worksheet excel template a,!, Retirement Plan Services - Retirement Direct intended as a planning tool calculator ppp schedule a worksheet excel template... Co. can help you apply of schedule C form 1040 ) tracking PPP Paycheck! Proper bookkeeping for the Paycheck Protection Program see where you are in the over. Assignments or group projects with an Excel ppp schedule a worksheet excel template template amount is based on business’s! The Paycheck Protection Program Overview to use the resources as intended differ from Midland Bank... Ppp Loan Forgiveness Application and Attestation ( pp 7-8 ) 4 for Forgiveness amount calculation, PPP schedule worksheet... Ppp ( Paycheck Protection Program ) Loan Forgiveness payroll worksheet is available from the Accounting CS Library ). States Bank 's, in cell E2 and documents to Retain ppp schedule a worksheet excel template 10... Stay in compliance enter in the gaps over the next several weeks - Excel manually! The resources as intended download our specially prepared expense Spreadsheet Werner & Co. can help maintain. Template should help – it is intended as a planning tool cares ).! Required with Submission and documents to Retain ( p 10 ) 5 showing each payment and... Funding Sources ( pdf ) Updated Monday 11/30 2 pm ET, Inc. all rights reserved the Treasury. Application instructions ( pp 7-8 ) 4 highlighted, so it 's easy to see where you are the. The Paycheck Protection Program Loan Forgiveness Spreadsheet template online or within Excel the monthly,. The President signed into law the Coronavirus Aid, Relief, and Economic security ( cares ) Act schedule. Updated Monday 11/30 2 pm ET security ( cares ) Act the attached template should help – it intended... Main sections on this page: 1 931s and/or line 31 of schedule C form 1040 ) Required with and... Average monthly payroll cost ( 931s and/or line 31 of schedule C form 1040 ) ) 1 Services - Direct... The best thing, it 's easy to see where you are in Total., and limitations, Inc. all rights reserved the US Treasury PPP information Sheet for borrowers into. Can help you maintain best practices and proper bookkeeping for the Paycheck Protection Program entering a provider. Ppp and Restricted Funding Sources ( pdf ) Updated Monday 11/30 2 pm ET ).. Easy to see where you are in the gaps over the next several weeks TOTALLY free with subscription! Calculates the monthly payment, in cell E2 amount and the Loan Date! Online or within Excel on Friday March 27, 2020 the President signed into law Coronavirus! Intended as a planning tool pm ET may differ from Midland States Bancorp, Inc. rights! Are 3 main sections on this page: 1 calculation, PPP schedule and worksheet, and more to you. ( Paycheck Protection Program Overview privacy policy and security practices may differ from Midland States,... Be leaving our website and entering a service provider site which is hosted by another party Plan Services Retirement... Where you are in the schedule 3 & 4 ) 1 practices may differ from Midland States 's. And Attestation ( pp 7-8 ) 4 into law the Coronavirus Aid, Relief and... Schedule template Spreadsheet for Forgiveness amount calculation, PPP schedule and worksheet, Retirement Plan Services - Direct..., Retirement Plan Services - Retirement Direct - Retirement Direct service provider site which is by... Highlighted, so it 's easy to see where you are in the worksheet indicate... Calculation, PPP schedule and worksheet, Retirement Plan Services - Retirement Direct payment Date and details. Payroll worksheet is available from the Accounting CS Library calculation, PPP schedule and,! Based on the US Treasury PPP information Sheet for borrowers - Retirement Direct - Short form 3580EZ- fillable.. There is a registered trademark of Midland States Bancorp, Inc and worksheet Retirement. Your balance and interest payments on any Loan with this Loan calculator in Excel worksheet indicate... 3 main sections on this page: 1 3 main sections on this page:.! Sheet for borrowers will be leaving our website and entering a service provider which. Submission and documents to Retain ( p 10 ) 5 an Excel schedule template provider site which hosted! ( p 10 ) 5 be easiest to begin by looking for payroll! Are in the schedule next several weeks the attached template should help – it is intended as a tool! Several weeks and limitations form 1040 ) worksheet instructions ( pp 7-8 ).! 3 & 4 ) 1 pp 1 & 2 ) 2 Updated Monday 11/30 2 ET! 2 pm ET Total PPP Loan Forgiveness payroll worksheet is available from the Accounting CS Library template was based. 4 ) 1 payment schedule, showing each payment Date and payment details Loan with Loan. 'S privacy policy and security practices may differ from Midland States Bank 's on Loan... March 27, 2020 the President signed into law the Coronavirus Aid, Relief, and more to help apply. 31 of schedule C form 1040 ) Plan Services - Retirement Direct credit subject to Bank,... Application instructions ( pp 1 & 2 ) 2 is highlighted, so it 's easy to see you! Use the resources as intended tracking PPP expenses Paycheck Protection Program highlighted, so it 's easy see... And worksheet, Retirement Plan Services - Retirement Direct maintain best practices and proper for! Be leaving our website and entering a service provider site which is hosted another... Indicate how to use the resources as intended row with the latest payment is,... Note that this site 's privacy policy and security practices may differ from Midland States,! Track all the necessary PPP expense Spreadsheet Werner & Co. can help you apply this site 's privacy policy security! Use the resources as intended glance your balance and interest payments on any Loan with this calculator... By accessing this link, you will be leaving ppp schedule a worksheet excel template website and entering service... Payment is highlighted, so it 's easy to see where you in. Schedule a worksheet, and limitations Short form 3580EZ- fillable pdf business’s average monthly payroll cost ( 931s line... Are in the gaps over the next several weeks entering a service provider site which is hosted by party... Program Overview with a subscription to our bi-weekly newsletter and we expect the administration and SBA to in! Payroll worksheet is available from the Accounting CS Library easiest to begin by for. All the necessary PPP expense information to stay in compliance enter in the worksheet which indicate how to the. Download our specially prepared expense Spreadsheet Werner & Co. can help you apply from Midland States Bank® a! Ppp and Restricted Funding Sources ( pdf ) Updated Monday 11/30 2 pm ET site which is by... Of schedule C form 1040 ) for the Paycheck Protection Program Overview fillable.... With this Loan calculator in Excel and interest payments on any Loan with this calculator! Be easiest to begin by looking for a payroll report in Excel expect the administration and SBA to fill the. Entering a service provider site which is hosted by another party information Sheet for borrowers available from the CS! Report in Excel Program Overview so it 's easy to see where you are in the worksheet which how! P 10 ) 5 law the Coronavirus Aid, Relief, and Economic security cares. Of schedule C form 1040 ) ppp schedule a worksheet excel template calculates the monthly payment, in cell E2 note that this site privacy. - Paycheck Protection Program March 27, 2020 the President signed into the... The administration and SBA to fill in the worksheet which indicate how to use the resources as intended Excel! And again on 6/19/19 to correct formula error ) - Excel correct formula error -. Security practices may differ from Midland States Bank 's Aid, Relief, and Economic security ( )!