PPP Loan Worksheet

Track your expenses to maximize forgiveness on the 2nd draw of your PPP loan during the COVID-19 pandemic in 2021.

 We developed this tool to help you get laser-focused on your cash flow as it relates to your second draw PPP loan funds.

Management One is a small business, just like most of your enterprises. 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. 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.

As a service to our customers and community members, we are sharing our work with you.

 
PPP-Loan-Worksheet_2021-02_thumb.jpg
 

Use this as a guide to track your fund allocations and maximize forgiveness on the loan.

Customize it using your account names and numbers, and drill down as specifically as you want to.

How to use this sheet

 

Step 1.

Fill out the form below to download the new worksheet.

Step 2.

To help you navigate this worksheet, please also download these two KEY instructional files:

Step 3.

Work closely with your loan provider to answer key questions and confirm what documentation is required to track expenses/payments. 

  • Consult with your payroll provider to properly track Sick/Medical Leave

  • Track Headcount of your Employees each week or each Payroll.

  • Keep track of your Payroll Costs in this tracker, and keep back-up documentation. The required documents consist of payroll reports, health insurance statements, and more.

  • Keep track of Other Expenses. Examples may include check register, bills, statements, leasing agreements with payment records attached.

Regulations by U.S. State

When dealing with government funding, it’s always a good idea to research your specific state regulations.

Consult with your accountant and/or loan provider to receive full information about your region.

Access your FREE download

Fill out the form found here to access to the 2021 PPP Loan Worksheet, designed to provide data-driven insights to drive critical decisions. If you would like a retail expert to assist you in using this tool, please check the box on the form.

If you have questions about using this sheet, please reach out to your Management One Retail Expert, or contact us directly.