SheetStatement

PPP Loan Records: Organizing Bank Statements for Review

By SheetStatement Team · · Updated · 11 min read

TL;DR: The Paycheck Protection Program closed to new loans years ago, but borrowers can still be asked to support their loan and forgiveness figures, and the program's rules required documentation to be kept for a number of years. Bank statements are central: they show the loan deposit and the payroll, rent, utility and other payments you counted. Gather statements for the covered period, convert them to a spreadsheet, tag each payment to the forgiveness category it supported, and keep everything together with payroll reports and invoices. This is general information, not legal or tax advice; check current SBA guidance and talk to your accountant or lender.

Important: PPP rules changed several times while the program ran, and they differed by loan size, loan round and forgiveness form. We don't give legal or tax advice. For any review, rely on current SBA guidance, your lender and your professional advisers.

The Paycheck Protection Program (PPP) was a US government loan program for businesses during the pandemic, run through the Small Business Administration (SBA) and private lenders. Many loans were forgiven, in whole or in part, based on how the money was spent. Forgiveness wasn't necessarily the end of the story: the SBA had the right to review loans, and borrowers were required to keep supporting documents for a period after forgiveness or repayment.

Those reviews still come up, as do related questions from lenders, accountants and buyers of businesses doing due diligence. This guide is about organizing the bank side of your PPP records so you can answer them.

What bank statements show in a PPP context

Bank statements are useful evidence for several points:

  1. The loan deposit: when it arrived and how much.
  2. Payroll costs: net pay to employees, payroll tax payments, and payments to payroll providers.
  3. Non-payroll costs that could count toward forgiveness, depending on the rules that applied to your loan: for example, mortgage interest, rent, utilities, and in later rounds some additional categories.
  4. Timing: that payments fell within your covered period.
  5. Business operations: for some reviews, statements help show the business was operating as described in the application.

Statements alone aren't enough for most of these. Payroll reports, tax filings, leases and utility bills provide the detail. Statements prove the money moved. Together they let a reviewer follow each forgiven dollar from your claim, to the document that justified it, to the bank line that shows it was paid.

Step 1: Find your loan documents

Before touching the statements, collect:

  • The loan application and note.
  • The forgiveness application (the specific form you used) and any supporting schedules.
  • Your lender's forgiveness decision and the SBA's decision, if separate.
  • Any correspondence about the loan or forgiveness.

The forgiveness application tells you the covered period you chose and the amounts you claimed in each category. Everything else is evidence for those numbers.

Step 2: Gather statements for the right periods

You'll typically want statements for:

  • The covered period used for forgiveness.
  • The reference periods used to calculate the loan amount or to compare payroll and headcount, if relevant to your loan.
  • The month the loan was deposited.
  • Any account the loan proceeds moved through, if you transferred them.

If the statements are old, you may need to request copies from the bank. Our guide to getting old bank statements covers how. Check that the statements chain: each closing balance equals the next opening balance.

Step 3: Convert and combine

Convert copies of the statements to Excel. SheetStatement extracts the transactions and checks each statement against its balances, which matters when the point is to prove amounts. Combine all accounts into one table with date, account, description and amount.

Step 4: Tag each payment to a category

Add a PPP category column and tag the payments that supported your forgiveness figures:

Date Description Amount PPP category Support
2020-05-08 PAYROLL PROVIDER NET PAY -18,240.11 Payroll: net pay Payroll register
2020-05-08 PAYROLL PROVIDER TAX -4,912.30 Payroll: employer taxes Payroll tax report
2020-05-01 RENT LANDLORD LLC -6,500.00 Rent Lease, landlord invoice
2020-05-14 CITY ELECTRIC -612.45 Utilities Utility bill
2020-05-20 HEALTH INSURER -2,140.00 Payroll: benefits Insurer invoice

Use the categories from the forgiveness form you filed, so the totals line up with what you claimed. Our article on Excel formulas to categorize transactions shows how to automate the tagging with a lookup table.

Step 5: Reconcile to your forgiveness application

Build a PivotTable that totals each PPP category within the covered period. Then compare with the forgiveness application:

Category Bank statements Forgiveness application Difference
Payroll costs 132,410.50 132,410.50 0.00
Rent 26,000.00 26,000.00 0.00
Utilities 2,412.80 2,390.00 22.80

Differences aren't necessarily errors. Payroll costs on the form may have been calculated from payroll reports using rules about when costs are incurred versus paid, and some costs may have been paid in ways that don't map one-to-one to bank lines. But you should be able to explain each difference. Write the explanation next to it.

For every tagged payment, note where the support lives: payroll register for the pay date, lease and invoice for rent, the bill for utilities. If your files are digital, a document name or path in the Support column makes it easy to pull anything a reviewer asks for.

Step 7: Trace the loan proceeds

Some reviews ask how the loan money itself was used. If the proceeds went into your main operating account, that's simple: the deposit is on the statement and the payments follow. If you moved proceeds to a separate account, include that account's statements, and link the transfers. Our forensic accounting guide explains a simple method for tracing transfers between accounts.

Payroll through a provider: reading the statement lines

Most small businesses ran PPP payroll through a payroll provider, which means the bank statement shows a few large debits per pay run rather than a line per employee. Typically you'll see something like:

  • A debit for net pay, which the provider then distributes to employees.
  • A debit for payroll taxes, which the provider remits on your behalf.
  • Separate debits for benefits, such as health insurance premiums or retirement contributions, if they're paid outside the provider.
  • A fee for the provider's service, which generally isn't a payroll cost.

Match each pay run's debits to the provider's payroll register for the same date. The register breaks the debit down by employee and by type of cost, which is what a reviewer needs to see. If the provider's reports and the bank debits don't agree for a pay run, find out why: a manual check, a correction, or a refund from the provider are common reasons.

If you paid employees directly, by checks or transfers, the statement shows each payment. Tag them individually and match to your payroll records.

Owner compensation

Owner compensation was treated specially under PPP, and the rules depended on the type of business and the loan round. If your forgiveness included compensation for yourself as an owner, your statements may show it as a draw, a payroll payment, or not at all (for some sole proprietors, the calculation was based on prior-year income rather than payments). Keep whatever documentation supported the figure you used, and ask your accountant how it was calculated if you don't remember. This is one of the areas reviewers ask about.

Mixed accounts and personal spending

If the business account also carried personal spending, or the loan was deposited into an account used for both, separating the two clearly is especially important. Tag personal items as such and exclude them from your PPP totals. A reviewer seeing personal spending in the covered period isn't automatically a problem, but your figures should obviously exclude it, and the records should show how. Going forward, a dedicated business account makes all of this easier.

Common gaps in PPP records

From what we've seen, the gaps that cause the most trouble are:

  • A missing month of statements in the covered period.
  • No payroll register for a pay run that appears on the statement.
  • Rent or utilities paid personally and reimbursed, without clear records of the reimbursement.
  • Proceeds moved to another account whose statements weren't kept.
  • No copy of the forgiveness application as filed.

Each of these can usually be fixed: statements and payroll reports can be re-requested, landlords and utilities can supply statements, and lenders hold copies of what you submitted. It's just much faster to do it before someone asks.

How long this takes

For a small business with a single operating account and a payroll provider, organizing PPP records as described typically takes an afternoon once the statements are in hand: an hour to convert and tag, an hour to reconcile to the forgiveness application, and the rest to gather supporting documents. Businesses with several accounts or direct payroll take longer. Most of the time goes on finding documents, which is why linking each line to its support is worth doing once and keeping.

A worked example

A restaurant owner receives a letter from her lender asking for documentation supporting her forgiven PPP loan.

  1. She finds her forgiveness application, which shows an eight-week covered period and amounts for payroll, rent and utilities.
  2. She downloads statements for the covered period plus the month of the loan deposit. One month is no longer available online, so she requests it from the bank.
  3. She converts and combines them, then tags payroll provider debits, rent, and utility payments.
  4. The payroll total on the statements matches her payroll provider's reports for the period. Rent matches exactly.
  5. Utilities on the statements are slightly higher than on the form. Her accountant's notes explain that one bill included a non-qualifying charge that was excluded.
  6. She sends the lender the forgiveness application, payroll reports, lease, utility bills, the bank statements, and her summary table with the explanation.

The summary table was the most useful document in the pack, because it connected everything else.

Building the summary pack

Reviewers, lenders and buyers all respond well to the same structure. Put these in one folder, numbered in this order:

  1. Summary table comparing bank totals with the forgiveness application, with explanations.
  2. Forgiveness application as filed, and the forgiveness decision.
  3. Loan documents: application and note.
  4. Bank statements for the covered period and loan deposit month, all pages.
  5. Payroll reports for each pay date in the covered period, and payroll tax filings for the relevant quarters.
  6. Non-payroll support: lease or mortgage statements, utility bills, and anything else claimed.
  7. Tagged transaction spreadsheet linking statement lines to documents.

Keep a short index at the front listing each document. If anyone asks for something specific, you can send it in minutes, and you'll send the same version every time.

Record retention

The PPP rules required borrowers to keep documentation supporting their loan and forgiveness for a set number of years after forgiveness or repayment, with different periods for different types of documents. Check current SBA guidance and ask your accountant for the period that applies to your loan. When in doubt, keep everything, including bank statements, until you've confirmed the retention period has passed. Digital copies stored securely are fine for most purposes.

Selling a business with a PPP loan in its history

If you're selling a business that received a PPP loan, a buyer's advisers may want to see the forgiveness documentation and supporting records. A tidy pack, prepared as above, can save weeks in due diligence. Your lender may also have requirements related to changes in ownership; check with them and your lawyer.

Other pandemic-era programs

Similar principles apply to other relief programs, such as other SBA disaster loans, grants and tax credits: keep statements showing receipt and use of funds, link payments to the categories you claimed, and keep supporting documents for the required retention period. Each program has its own rules.

Troubleshooting common reconciliation gaps

When your bank-statement totals don't line up with the forgiveness application, the explanation usually falls into one of these buckets.

Payroll paid versus payroll incurred. Depending on the rules that applied to your loan, payroll costs could sometimes be counted when paid or when incurred within the covered period. A pay run for work done in the last days of the covered period, but paid after it, may appear in your forgiveness figure but not in that period's bank statements. Note the pay date and the period it covered.

Payroll taxes paid quarterly. If employer payroll taxes were paid after the covered period, they won't appear in the period's statements. Your payroll tax filings support them instead.

Benefits paid annually or in advance. An insurance premium paid before the covered period, or a retirement contribution paid after it, can create a timing difference. Keep the invoices and the payment confirmations together.

Costs paid by another account or card. A utility paid by business credit card shows up on the card statement, not the bank statement. Include the card statement and link the card payment from the bank.

Partial forgiveness. If not all of the loan was forgiven, the remaining balance became a loan with repayments. Those repayments appear on later statements; keep them with the loan records, separate from the forgiveness analysis.

A mini checklist before responding to a request

  1. Forgiveness application as filed, and the decision.
  2. Statements for the covered period and loan deposit month, every page.
  3. Payroll reports for every pay date claimed.
  4. Supporting documents for each non-payroll category.
  5. Summary table with every difference explained.
  6. A short cover note answering the specific questions asked, and nothing more.
  7. Your accountant's review, before anything is sent.

Edge case: the business has since closed

If the business has closed, the records are still needed for the retention period. Keep statements, payroll reports and the forgiveness file together in one place, and make sure someone (usually the former owner) knows where they are. If the bank account was closed, download or request its final statements before access disappears.

FAQ

Do I still need my PPP loan records?

The program required borrowers to keep supporting documents for a number of years after forgiveness or repayment. Check current SBA guidance and ask your accountant whether that period has passed for your loan.

What bank statements are needed for PPP documentation?

Typically statements covering the forgiveness covered period, the month of the loan deposit, and any periods used to calculate the loan, for every account involved.

How do I show how PPP funds were spent?

Tag each payment on your statements to the forgiveness category it supported, total them for the covered period, compare with your forgiveness application, and link each payment to its supporting document.

Why don't my statement totals match my forgiveness application exactly?

Payroll costs may have been calculated under specific timing rules, and some amounts may have been excluded or included differently. Document the reason for each difference, ideally with your accountant.

What if I can't get old bank statements?

Request copies from the bank, which keeps records for years. Your payroll provider and accountant may also have copies of relevant documents.

No. It's general information on organizing records. For any review, rely on current SBA guidance and your lender, accountant or lawyer.

Skip the retyping

Upload a PDF or scanned statement and download a balance-checked Excel, CSV, QuickBooks or Xero file. Try the converter free.

Related articles

Convert your first statement free

3 pages a month on the free plan. No credit card.