About the PPP Expense Tracker and Forgiveness Calculator

---

The PPP Loan Expense Tracker and Forgiveness Calculator allows you to input expenses and payroll costs data and automatically populates your forgiveness calculations. The PPP Loan Expense Tracker and Forgiveness Calculator references and tracks the line numbers of the PPP Forgiveness Application and operates in accordance with the SBA guidance and can be used alongside the PPP Forgiveness Application for quick and efficient organization of financial data, documentation, calculation, and summarization of each major aspect of the PPP loan. The PPP Loan Expense Tracker and Forgiveness Calculator may even be included as an Exhibit to your forgiveness application!

The PPP Loan Expense Tracker and Forgiveness Calculator was custom-designed and tested by Kevin Cameron, CPA in association with the CPA firm of C and L Value Advisors with the assistance of Alan Gassman and Brandon Ketron. This easy-to-use tool lets you maximize your billable time while assuring proper explanation and calculations to help staff members and sophisticated clients run numbers and provide illustrations.
The PPP Loan Expense Tracker and Forgiveness Calculator provide the following functionality:

1. Ability to input dates expenses were incurred and dates expenses are paid with automatic proration if applicable.
2. Convenient and simple spreadsheet to track and allocate expenses between payroll and non-payroll costs.
3. Ability to track whether supporting documents required to be submitted with the application have been provided.
4. Inputs for wages paid and hours worked for each employee designed to match data and information needed to complete PPP Schedule A worksheets.
5. Automatic calculations for the reduction in loan forgiveness based on the number of Full-Time Equivalent Employees and certain salary reductions, including inputs to account for safe harbors and other de minimis exceptions to the above limitations.
6. Automatic calculations to apply the limitation that non-payroll costs cannot exceed 25% of the Forgiveness Amount.

Available only for financial professionals and we will provide updates if the Calculator changes.