SBA PPP Loan Expenditure Tracking Worksheet
The Paycheck Protection Program (PPP) was created by the U.S. Small Business Administration (SBA) to provide emergency financial assistance to small businesses affected by the COVID19 pandemic. While the initial loan forgiveness process was straightforward, the Treasury Department later required borrowers to track and report detailed expenditures using a dedicated SBA PPP Loan Expenditure Tracking Worksheet. This page explains why the worksheet matters, what it includes, how to fill it out, and best practices for staying compliant.
Why the Tracking Worksheet Is Required
- Verification of Covered Expenses: The SBA allows loan forgiveness only for payroll and other qualified costs. The worksheet helps the SBA confirm that funds were used correctly.
- Audit Trail: A clear record of each expense creates an audit trail that can be reviewed by lenders, the SBA, or an external auditor.
- Consistency Across Borrowers: A standardized format ensures that every borrower reports the same categories in a comparable way.
- Future Program Integrity: Accurate tracking builds trust and reduces the risk of fraud or misuse of PPP funds.
Key Sections of the Worksheet
| Section | Description | Typical Documentation |
|---|---|---|
| Borrower Information | Legal name, EIN, loan number, lender name, and loan amount. | Loan agreement, SBA approval letter. |
| Payroll Expenses | All qualified payroll costs for each employee during the covered period (typically 8week or 24week window). | Pay stubs, payroll registers, 941 forms, employee W2s. |
| HealthCare Benefits | Employer contributions to health insurance, dental, vision, and related benefits. | Invoice statements from insurers, benefit plan summaries. |
| Mortgage/ rent | Payments for realestate rent or mortgage interest that qualify under the program. | Lease agreements, mortgage statements, cancelled checks. |
| Utilities | Utility costs (electric, water, gas, internet, phone) that were necessary to keep the business operational. | Utility bills, payment receipts. |
| Other Eligible Expenses | Applicable costs such as property damage insurance, software subscriptions, and other operational expenses. | Invoices, contracts, receipts. |
| Totals & Forgiveness Calculation | Aggregates all qualified amounts, applies the forgiveness percentage (generally 100% if 60% of the loan is used for payroll), and shows the final forgiveness amount. | Worksheet formulas, lenderprovided forgiveness calculator. |
StepbyStep Guide to Completing the Worksheet
1. Gather All Source Documents
Before you open the worksheet, collect payroll reports, benefit statements, lease contracts, utility bills, and any other receipt that evidences the use of PPP funds. Create a digital folder with subfolders for each expense type to keep everything organized.
2. Verify the Covered Period
The SBA defines a covered period of either 8 weeks or 24 weeks from the loan disbursement date. Every expense you record must fall within this window. Use the loan disbursement date from your SBA notice to set the start and end dates.
3. Enter Borrower Information
Fill in the top section exactly as it appears on the loan agreement. Any typo can delay forgiveness.
4. Record Payroll Expenses
- List each employee separately (or use a summary if you have a large staff).
- Enter gross wages, salaries, tips, commissions, and employee benefits that qualify.
- Deduct any amounts that are not eligible, such as overtime paid for work performed after the covered period.
- Make sure the total payroll amount does not exceed the loan amount (or the 60% payroll threshold if using the 8week period).
5. Add HealthCare Benefits
Enter the employers portion of healthcare premiums for the covered period. Do not include employee contributions.
6. Capture Rent or Mortgage Interest
Enter the portion of your rent or mortgage that was paid with PPP funds. For mortgage interest, use the interest portion (not principal).
7. List Utilities
Only utilities directly tied to business operations qualify. Enter the amount paid during the covered period.
8. Include Other Eligible Expenses
If you used PPP funds for other allowable costs, such as software subscriptions that enable remote work, list them here with supporting invoices.
9. Calculate Totals and Forgiveness
Most worksheets have builtin formulas. Verify that:
- Total qualified expenses loan amount.
- At least 60% of the loan was used for payroll (required for 100% forgiveness).
Best Practices for Compliance
- Maintain Original Documents: Keep electronic copies of all source documents for at least three years after forgiveness is finalized.
- Use Consistent Naming Conventions: For example, 202304PayrollReport.pdf makes it easy to locate files during an audit.
- Separate PPP Funds in Accounting Software: Tag all PPPrelated transactions with a unique account code.
- Reconcile Monthly: Run a monthly reconciliation between the worksheet totals and your accounting ledger.
- Consult a CPA: A professional can review your worksheet before submission and help you avoid common pitfalls.
Common Mistakes to Avoid
| Issue | Impact | How to Prevent |
|---|---|---|
| Doublecounting expenses | Inflated totals may trigger an audit or reduction in forgiveness. | Crosscheck each expense against source documents; use a single worksheet version. |
| Including ineligible costs | Funds may be disallowed, reducing forgiveness amount. | Reference SBAs eligibility list before entering any expense. |
| Missing payroll threshold | Forfeits 100% forgiveness; you may only receive 50% forgiveness. | Calculate payroll share early and adjust spending if necessary. |
| Incorrect covered period dates | Expenses outside the window are disqualified. | Set a calendar reminder for the start/end dates when beginning data entry. |
Submitting the Worksheet
Once completed, the worksheet is typically submitted to the lender, who then forwards it to the SBA. Follow your lenders specific instructionssome accept PDFs, others use an online portal. After submission, keep a copy for your records and be prepared to provide additional documentation if requested.
Resources
This page provides general guidance and does not replace professional legal or tax advice. Always consult a qualified accountant or attorney for your specific situation.
SBA PPP Loan Expenditure Tracking Worksheet and Reference File Download Link
Bank Of England Loan Level Data Reporting Template For Auto Loan Portfolios and Reference...