Derived table · Paycheck Protection Program
PPP lender processing fees by lender type, modeled
Fintech lenders earned a modeled $2,272 in SBA processing fees per PPP loan, community banks $4,005 and the 51 largest banks $3,918. The population is the 11,468,206 disbursed loans in SBA's loan-level file of September 30, 2024. The fee schedule paid by loan size, and the fintech type made the smallest loans: 93.5% of its 3,049,574 loans were $50,000 or less, against 67.9% at the big banks and 69.3% at community banks. The six types together earned $38.24 billion, the same total as the per-lender table this page groups.
Download CSV 2 KBData dictionary CSVAt a glancePreviewColumnsHow to useBefore you quote a row
At a glance
Measured on the file on 2026-10-16; the checksum above is the file these numbers describe.
lender_type · uniqueWhat it is
One row for each of six lender types, grouped from the 4,689 originating lenders in the per-lender fee table. The types are community bank (3,512 lenders), big bank (51), fintech (31), CDFI (20), credit union (946) and other (129, including the one row with a blank lender name). Each row sums the type's disbursed loans, current approved dollars and modeled processing fees, and splits the fees by draw and by four loan-size bands. Fee per loan divides fees by loans.
Community banks earned the most, $17.06 billion, 44.6% of the total; the big banks $10.75 billion, 28.1%; the fintech type $6.93 billion, 18.1%; CDFIs $2.27 billion, 5.9%; credit unions $1.03 billion, 2.7%; other lenders $200.79 million, 0.5%. The fee-per-loan order is close to the reverse: community bank $4,005, big bank $3,918, other $2,824, credit union $2,588, CDFI $2,396, fintech $2,272. CDFIs made 98.7% of their loans at $50,000 or less and took 95.7% of their fees from that band. The same two shares for the other types: fintech type 93.5% and 79.6%; big banks 67.9% and 25.3%; community banks 69.3% and 28.5%; credit unions 81.7% and 46.7%; other lenders 82.6% and 51.6%.
The type is a channel label, not a charter. The fintech list holds 14 lenders whose names carry a bank charter word, Cross River Bank, Customers Bank, Celtic Bank Corporation and WebBank among them. They account for 1,139,827 loans and $2.52 billion of the type's $6.93 billion, at $2,211 a loan. The 17 fintech lenders without one account for 1,909,747 loans and $4.41 billion, at $2,308 a loan. The companion file flags the charter word on every lender, so the table can be regrouped by charter.
How it was built
Each lender's loans, dollars and fees come from the per-lender fee table, which prices every disbursed loan in SBA's September 30, 2024 release on its current approved amount under the schedule for its draw and approval date. The 2020 CARES Act schedule paid 5% up to $350,000, 3% above that and below $2 million and 1% at $2 million and above. The 2021 Economic Aid Act schedule paid the lesser of $2,500 or 50% on loans of $50,000 or less, then the same 5% and 3%. The 4,689 rows grouped here match that table to the cent on all 14 shared columns.
The lender type is a keyword rule applied to the lender's name as the SBA file prints it, 104 keywords in all. They break down as 39 naming fintech lenders and the chartered banks the rule groups with them and 36 naming the largest banks. The rest: 19 naming CDFIs and mission lenders, 5 naming Farm Credit lenders as community banks and 5 for credit unions. A name none of them matches is a community bank if it contains bank, banc, trust, savings or national association, and other if not. Re-applying the rule to every name reproduces the type on all 4,689 rows. The companion file's charter flag tests the name for Bank, National Association or SSB.
Preview
| lender_type | category_code | lenders | loans | amount_usd | modeled_fees_usd | fee_per_loan_usd | share_of_fees_pct | share_of_loans_pct | fees_2020_first_draw_usd | fees_2021_first_draw_usd | fees_second_draw_usd | loans_50k_or_less | loans_50k_to_350k | loans_350k_to_2m | loans_2m_and_above | fees_50k_or_less_usd | fees_50k_to_350k_usd | fees_350k_to_2m_usd | fees_2m_and_above_usd | share_loans_50k_or_less_pct | share_fees_50k_or_less_pct | lenders_with_charter_word_in_name |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Community bank | COMMUNITY_BANK | 3512 | 4258532 | 401414240549.07 | 17055395726.33 | 4004.99 | 44.61 | 37.13 | 9567536027.41 | 2086437849.46 | 5401421849.45 | 2952574 | 1078346 | 209202 | 18410 | 4860495914.48 | 6900724522.80 | 4563117666.65 | 731057622.41 | 69.33 | 28.50 | 3380 |
| Big bank | BIG_BANK | 51 | 2744317 | 275216797853.24 | 10753259672.11 | 3918.37 | 28.12 | 23.93 | 6699252339.14 | 640098763.98 | 3413908568.98 | 1862174 | 737542 | 129195 | 15406 | 2720745704.21 | 4525045795.36 | 2876714808.47 | 630753364.07 | 67.86 | 25.30 | 47 |
| Fintech | FINTECH | 31 | 3049574 | 76482901318.76 | 6928802167.72 | 2272.06 | 18.12 | 26.59 | 1256187733.15 | 3445196702.04 | 2227417732.53 | 2851697 | 180261 | 16831 | 785 | 5517922543.44 | 1028246500.80 | 348145353.10 | 34487770.38 | 93.51 | 79.64 | 14 |
| CDFI | CDFI | 20 | 945630 | 16661068616.59 | 2265307612.45 | 2395.55 | 5.92 | 8.25 | 56684397.90 | 1932784318.89 | 275838895.66 | 933732 | 10551 | 1227 | 120 | 2168427070.63 | 62982915.36 | 28739070.38 | 5158556.07 | 98.74 | 95.72 | 0 |
| Credit union | CREDIT_UNION | 946 | 399046 | 19425858703.48 | 1032711014.99 | 2587.95 | 2.70 | 3.48 | 513174952.93 | 179291733.27 | 340244328.79 | 326101 | 65325 | 7066 | 554 | 482657525.64 | 380294035.62 | 147064466.27 | 22694987.46 | 81.72 | 46.74 | 0 |
| Other | OTHER | 129 | 71107 | 3400202002.41 | 200787611.02 | 2823.74 | 0.53 | 0.62 | 74462584.37 | 60614044.33 | 65710982.31 | 58711 | 11123 | 1179 | 94 | 103634921.76 | 68033617.55 | 24929194.48 | 4189877.23 | 82.57 | 51.61 | 0 |
First 6 of 6 rows · cells longer than 60 characters are cut with an ellipsis · shown as text, unformatted.
Files
| File | Rows | Size | SHA-256 | |
|---|---|---|---|---|
ppp-lender-fees-by-lender-type.csvCSV, UTF-8, header row | 6 | 1,691 B | 05e34e7cf01b3bf569f18831ed5e75ec30083c4f0fc2726592f704d87db70056 | Download ↓ |
dictionary.csvdata dictionary, 23 rows | 23 | — | built with this page | Download ↓ |
Columns
| Column | Type, measured | Blank | Distinct | Range / values | Meaning |
|---|---|---|---|---|---|
lender_type | text | 0 | 6 | Community bank (1), Big bank (1), Fintech (1) | Community bank, Big bank, Fintech, CDFI, Credit union or Other. |
category_code | text | 0 | 6 | COMMUNITY_BANK (1), BIG_BANK (1), FINTECH (1) | The same type as the keyword rule names it: COMMUNITY_BANK, BIG_BANK, FINTECH, CDFI, CREDIT_UNION, OTHER. |
lenders | integer | 0 | 6 | 20 – 3.5K · median 90 | Originating lenders of this type; the six rows sum to 4,689. |
loans | integer | 0 | 6 | 71.1K – 4.3M · median 1.8M | Disbursed loans originated by lenders of this type. |
amount_usd | number | 0 | 6 | 3.4B – 401.4B · median 48.0B | Current approved amount of those loans, dollars. |
modeled_fees_usd | number | 0 | 6 | 200.8M – 17.1B · median 4.6B | Modeled processing fees on those loans, dollars (computed from loan amounts, not fees SBA paid). |
fee_per_loan_usd | number | 0 | 6 | 2.3K – 4.0K · median 2.7K | modeled_fees_usd divided by loans. |
share_of_fees_pct | number | 0 | 6 | 0.53 – 44.61 · median 12.02 | modeled_fees_usd as a percentage of the $38,236,263,804.62 total. |
share_of_loans_pct | number | 0 | 6 | 0.62 – 37.13 · median 16.09 | loans as a percentage of 11,468,206. |
fees_2020_first_draw_usd | number | 0 | 6 | 56.7M – 9.6B · median 884.7M | Modeled fees on first-draw loans approved in 2020. |
fees_2021_first_draw_usd | number | 0 | 6 | 60.6M – 3.4B · median 1.3B | Modeled fees on first-draw loans approved in 2021. |
fees_second_draw_usd | number | 0 | 6 | 65.7M – 5.4B · median 1.3B | Modeled fees on second-draw loans (SBA processing method PPS). |
loans_50k_or_less | integer | 0 | 6 | 58.7K – 3M · median 1.4M | Loans of $50,000 or less. |
loans_50k_to_350k | integer | 0 | 6 | 10.6K – 1.1M · median 122.8K | Loans over $50,000 up to $350,000. |
loans_350k_to_2m | integer | 0 | 6 | 1.2K – 209.2K · median 11.9K | Loans over $350,000 and under $2 million. |
loans_2m_and_above | integer | 0 | 6 | 94 – 18.4K · median 669 | Loans of $2 million and above. |
fees_50k_or_less_usd | number | 0 | 6 | 103.6M – 5.5B · median 2.4B | Modeled fees on loans of $50,000 or less. |
fees_50k_to_350k_usd | number | 0 | 6 | 63.0M – 6.9B · median 704.3M | Modeled fees on loans over $50,000 up to $350,000. |
fees_350k_to_2m_usd | number | 0 | 6 | 24.9M – 4.6B · median 247.6M | Modeled fees on loans over $350,000 and under $2 million. |
fees_2m_and_above_usd | number | 0 | 6 | 4.2M – 731.1M · median 28.6M | Modeled fees on loans of $2 million and above. |
share_loans_50k_or_less_pct | number | 0 | 6 | 67.86 – 98.74 · median 82.14 | loans_50k_or_less as a percentage of loans. |
share_fees_50k_or_less_pct | number | 0 | 6 | 25.30 – 95.72 · median 49.17 | fees_50k_or_less_usd as a percentage of modeled_fees_usd. |
lenders_with_charter_word_in_name | integer | 0 | 4 | 0 – 3.4K · median 7 | Lenders of this type whose SBA name contains Bank, National Association or SSB. |
Type, blanks, distinct count, and range are measured on the file. The same table as CSV: dictionary.csv.
How to use it
Specific to this file, measured on it: keys, joins, encodings, units, and the values that will trip a naive count.
- Six rows, sorted by
modeled_fees_usd, largest first. The key is the type label;category_codeis the same type in the form the keyword rule writes. - The splits add up. The four
loans_*band columns sum toloans, and the four band fee columns and the three draw fee columns each sum tomodeled_fees_usdwithin a cent, on every row. - Every lender's type is in the companion file.
ppp-lender-fees-by-lender-type-lenders.csvhas 4,689 rows: lender name, type, charter-word flag, loans, dollars, fees, fee per loan and the $50,000-or-less band. Group it bylender_typeto rebuild this table, or bycharter_word_in_nameto regroup by charter. - Money columns are dollars with two decimals. Divide by 1e9 for billions; round before quoting. LF line endings, UTF-8, 1,691 bytes.
Before you quote a row
- Modeled, not observed. Fees are computed from loan sizes under the published schedules; fees on loans later canceled or found ineligible are not netted out, and the SBA's actual payments are not in the file.
- Names, not charters. The type follows the lender's name against a keyword list. A chartered bank the keyword list names sits in the fintech type, and a lender the list does not name falls to community bank or other by the words in its name. The companion file's charter flag is a name test too.
- Originating lender only. Fees are credited to the lender that originated the loan. Platforms, agents and service providers paid out of those fees do not appear, and a loan sold or serviced elsewhere stays with its originator.
- Population. 11,468,206 disbursed loans, the 11,468,210 rows of the September 30, 2024 release less 4 rows the disbursement filter removes, the same population as the per-lender table and the fee-schedule table.
PPP lender processing fees by lender type, modeled on SBA PPP FOIA loan-level data (2024-09-30 vintage). Pandemic Darlings, https://pandemicdarlings.com/data/ppp-lender-fees-by-lender-type/, SHA-256 05e34e7cf01b3bf569f18831ed5e75ec30083c4f0fc2726592f704d87db70056