The rules we check
Every check comes from a CDFI Fund guide and names the page it comes from. The rules were last checked against the guides on 2026-11-19. Items marked “Check with Henry” are ones Fundingo’s CDFI specialist is still confirming.
- CDFI/NACA/CDFI ERP Transaction Level Report (TLR) Data Point Collection Guide, May 2026
- Abbreviated Transaction Level Report (TLR) Data Point Collection Guide, December 2023
Abbreviated TLR
41 data points, 108 checks.
Loan (13)
Originator Transaction ID
RequiredYour unique id for the loan. Starts with a letter, up to 20 characters, no names or Social Security numbers.
- Originator Transaction ID is a mandatory field.Abbreviated TLR guide, December 2023, p. 6 (Originator Transaction ID)
- Originator Transaction ID must start with a letter, for example a1234.Abbreviated TLR guide, December 2023, p. 6 (Originator Transaction ID)
- Originator Transaction ID should have letters and numbers only, with no special characters such as commas or exclamation points.Abbreviated TLR guide, December 2023, p. 6 (Originator Transaction ID)(a check to review, not an error)
- Originator Transaction ID can be at most 20 characters long.Abbreviated TLR guide, December 2023, p. 6 (Originator Transaction ID)
- Each Originator Transaction ID must be unique: give every loan its own.Abbreviated TLR guide, December 2023, p. 6 (Originator Transaction ID)
TLR Submission Year
RequiredThe year of the report, the same for every loan.
- TLR Submission Year is a mandatory field.Abbreviated TLR guide, December 2023, p. 6 (TLR Submission Year)
- TLR Submission Year must be the year of this report for every loan.Abbreviated TLR guide, December 2023, p. 6 (TLR Submission Year)
Date Originated
RequiredThe date the borrower signed the note.
- Date Originated is a mandatory field.Abbreviated TLR guide, December 2023, p. 6 (Date Originated)
- Date Originated must be a date (mm/dd/yyyy).Abbreviated TLR guide, December 2023, p. 6 (Date Originated)
- Only loans originated during the reporting period belong in this TLR. Check the date, or leave the loan out.Abbreviated TLR guide, December 2023, p. 4, 6 (General Reporting Guidelines; Date Originated)
- Date Originated cannot be after today.Abbreviated TLR guide, December 2023, p. 6 (Date Originated)
Original Loan/Investment Amount
RequiredThe original amount, a positive whole number. For lines of credit, the credit limit.
- Original Loan/Investment Amount is a mandatory field.Abbreviated TLR guide, December 2023, p. 7 (Original Loan/Investment Amount)
- Original Loan/Investment Amount must be a number.Abbreviated TLR guide, December 2023, p. 7 (Original Loan/Investment Amount)
- Original Loan/Investment Amount must be greater than 0.Abbreviated TLR guide, December 2023, p. 7 (Original Loan/Investment Amount)
- Original Loan/Investment Amount must be a whole number.Abbreviated TLR guide, December 2023, p. 7 (Original Loan/Investment Amount)(a check to review, not an error)
- Original Loan/Investment Amount cannot be greater than 50,000 when Purpose is MICRO.Abbreviated TLR guide, December 2023, p. 7 (Original Loan/Investment Amount)
Purpose
RequiredThe primary purpose: the one with the largest share of the loan.
Values: CONSUMER, BUSINESS, MICRO, CLIMATE, HOMEPURCH, HOMEIMP, RECOCOM, RECOMULTI, RECOSINGLE, RERHCOM, RERHMULTI, RERHSINGLE, OTHER
- Purpose is a mandatory field.Abbreviated TLR guide, December 2023, pp. 7-8 (Purpose)
- Use a value from the CDFI Fund list (see the guide for the full list).Abbreviated TLR guide, December 2023, pp. 7-8 (Purpose)
- Purpose cannot be BUSINESS, RECOCOM, RECOMULTI, RECOSINGLE, RERHCOM, RERHMULTI or RERHSINGLE when Investee/Borrower Type is IND.Abbreviated TLR guide, December 2023, p. 13 (Investee/Borrower Type)
- Purpose must be OTHER when Investee/Borrower Type is CDFI.Abbreviated TLR guide, December 2023, p. 13 (Investee/Borrower Type)
- Purpose cannot be CONSUMER, HOMEPURCH or HOMEIMP when Investee/Borrower Type is BUS.Abbreviated TLR guide, December 2023, p. 13 (Investee/Borrower Type)
Climate-Centered Purpose
Required in some cases: when Purpose is CONSUMER, BUSINESS, MICRO, HOMEPURCH, HOMEIMP, RECOCOM, RECOMULTI, RECOSINGLE, RERHCOM, RERHMULTI, RERHSINGLE or OTHERWhether the loan has a secondary purpose centered on climate.
Values: Yes, No, Do Not Know
- Climate-Centered Purpose is required when Purpose is CONSUMER, BUSINESS, MICRO, HOMEPURCH, HOMEIMP, RECOCOM, RECOMULTI, RECOSINGLE, RERHCOM, RERHMULTI, RERHSINGLE or OTHER.Abbreviated TLR guide, December 2023, pp. 8-9 (Climate-Centered Purpose)
- Use a value from the CDFI Fund list: Yes, No or Do Not Know.Abbreviated TLR guide, December 2023, pp. 8-9 (Climate-Centered Purpose)
Transaction Type
RequiredThe kind of transaction: term loan, line of credit, equity investment and so on.
Values: TERM, EQTYINV, CREDITCARD, LOC, DEBTEQTY, LNGUARANTEE, LNLSRESERVE, CAPRESERVE, OTHER
- Transaction Type is a mandatory field.Abbreviated TLR guide, December 2023, pp. 9-10 (Transaction Type)
- Use a value from the CDFI Fund list: TERM, EQTYINV, CREDITCARD, LOC, DEBTEQTY, LNGUARANTEE, LNLSRESERVE, CAPRESERVE or OTHER.Abbreviated TLR guide, December 2023, pp. 9-10 (Transaction Type)
Loan Status
RequiredThe status at the end of the reporting period.
Values: ACTIVE, CLOSED, SOLD, CHARGEDOFF, REFIN, RESTRUCT
- Loan Status is a mandatory field.Abbreviated TLR guide, December 2023, p. 10 (Loan Status)
- Use a value from the CDFI Fund list: ACTIVE, CLOSED, SOLD, CHARGEDOFF, REFIN or RESTRUCT.Abbreviated TLR guide, December 2023, p. 10 (Loan Status)
Interest Rate
Required in some cases: when Transaction Type is TERM, LOC, CREDITCARD or DEBTEQTYThe rate at origination as a percentage: 2.5 for 2.5%. 99 if unknown or not applicable.
- Interest Rate is required when Transaction Type is TERM, LOC, CREDITCARD or DEBTEQTY.Abbreviated TLR guide, December 2023, p. 10 (Interest Rate)
- Interest Rate must be a number.Abbreviated TLR guide, December 2023, p. 10 (Interest Rate)
- Interest Rate must be equal to or greater than 0 when Transaction Type is TERM, LOC, CREDITCARD or DEBTEQTY.Abbreviated TLR guide, December 2023, p. 10 (Interest Rate)
- Interest Rate can have at most 3 decimal places.Abbreviated TLR guide, December 2023, p. 10 (Interest Rate)
- Enter Interest Rate as a percentage, for example 2.5 for 2.5%, not 0.025.Abbreviated TLR guide, December 2023, p. 10 (Interest Rate)(a check to review, not an error)
Points
Required in some cases: when Transaction Type is TERM or DEBTEQTYPoints at origination as a percentage of the loan, not the fees. 99 if unknown or not applicable.
- Points is required when Transaction Type is TERM or DEBTEQTY.Abbreviated TLR guide, December 2023, p. 11 (Points)
- Points must be a number.Abbreviated TLR guide, December 2023, p. 11 (Points)
- Points must be equal to or greater than 0.Abbreviated TLR guide, December 2023, p. 11 (Points)
- Points cannot be greater than 100.Abbreviated TLR guide, December 2023, p. 11 (Points)
- Points can have at most 3 decimal places.Abbreviated TLR guide, December 2023, p. 11 (Points)
Origination Fees
Required in some cases: when Transaction Type is TERM, LOC or DEBTEQTYTotal fees paid at origination, not the points. 0 if none.
- Origination Fees is required when Transaction Type is TERM, LOC or DEBTEQTY.Abbreviated TLR guide, December 2023, p. 11 (Origination Fees)
- Origination Fees must be a number.Abbreviated TLR guide, December 2023, p. 11 (Origination Fees)
- Origination Fees must be equal to or greater than 0 when Transaction Type is TERM, LOC or DEBTEQTY.Abbreviated TLR guide, December 2023, p. 11 (Origination Fees)
- Origination Fees must be less than Original Loan/Investment Amount when Transaction Type is TERM, LOC or DEBTEQTY.Abbreviated TLR guide, December 2023, p. 11 (Origination Fees)
- Origination Fees can have at most 2 decimal places.Abbreviated TLR guide, December 2023, p. 11 (Origination Fees)
Equity-Like Features
Required in some cases: when Transaction Type is DEBTEQTYFor debt with equity: the equity-like feature that appears first in the loan agreement.
Values: CONVDEBT, PERFINT, ROYALTIES, WARRANTS, OTHER
- Equity-Like Features is required when Transaction Type is DEBTEQTY.Abbreviated TLR guide, December 2023, pp. 11-12 (Equity-Like Features)
- Use a value from the CDFI Fund list: CONVDEBT, PERFINT, ROYALTIES, WARRANTS or OTHER.Abbreviated TLR guide, December 2023, pp. 11-12 (Equity-Like Features)
Forgivable Loan
Required in some cases: when Transaction Type is TERM, EQTYINV, LOC or DEBTEQTYWhether some or all of the loan may be converted to a grant.
Values: Yes, YesTM, No, Do Not Know
- Forgivable Loan is required when Transaction Type is TERM, EQTYINV, LOC or DEBTEQTY.Abbreviated TLR guide, December 2023, p. 12 (Forgivable Loan)
- Use a value from the CDFI Fund list: Yes, YesTM, No or Do Not Know.Abbreviated TLR guide, December 2023, p. 12 (Forgivable Loan)
Borrower (9)
Client ID
RequiredYour id for the borrower or project. Starts with a letter, up to 20 characters, no names or Social Security numbers.
- Client ID is a mandatory field.Abbreviated TLR guide, December 2023, p. 12 (Client ID)
- Client ID must start with a letter, for example a1234.Abbreviated TLR guide, December 2023, p. 12 (Client ID)(a check to review, not an error)
- Client ID should have letters and numbers only, with no special characters such as commas or exclamation points.Abbreviated TLR guide, December 2023, p. 12 (Client ID)(a check to review, not an error)
- Client ID can be at most 20 characters long.Abbreviated TLR guide, December 2023, p. 12 (Client ID)
Investee/Borrower Type
RequiredWhether the borrower is an individual, a business or a certified CDFI. Nonprofits are businesses.
Values: IND, BUS, CDFI
- Investee/Borrower Type is a mandatory field.Abbreviated TLR guide, December 2023, pp. 12-13 (Investee/Borrower Type)
- Use a value from the CDFI Fund list: IND, BUS or CDFI.Abbreviated TLR guide, December 2023, pp. 12-13 (Investee/Borrower Type)
Entity Structure
Required in some cases: when Investee/Borrower Type is BUSFor businesses: nonprofit, for-profit, tribal government or other.
Values: NONPROFIT, FORPROFIT, TRIBAL, OTHER
- Entity Structure is required when Investee/Borrower Type is BUS.Abbreviated TLR guide, December 2023, p. 13 (Entity Structure)
- Use a value from the CDFI Fund list: NONPROFIT, FORPROFIT, TRIBAL or OTHER.Abbreviated TLR guide, December 2023, p. 13 (Entity Structure)
Minority Owned or Controlled
Required in some cases: when Investee/Borrower Type is BUSFor businesses: more than 50% owned or controlled by minorities.
Values: Yes, No, Do Not Know
- Minority Owned or Controlled is required when Investee/Borrower Type is BUS.Abbreviated TLR guide, December 2023, pp. 13-14 (Minority Owned or Controlled)
- Use a value from the CDFI Fund list: Yes, No or Do Not Know.Abbreviated TLR guide, December 2023, pp. 13-14 (Minority Owned or Controlled)
Women Owned or Controlled
Required in some cases: when Investee/Borrower Type is BUSFor businesses: more than 50% owned or controlled by women.
Values: Yes, No, Do Not Know
- Women Owned or Controlled is required when Investee/Borrower Type is BUS.Abbreviated TLR guide, December 2023, p. 14 (Women Owned or Controlled)
- Use a value from the CDFI Fund list: Yes, No or Do Not Know.Abbreviated TLR guide, December 2023, p. 14 (Women Owned or Controlled)
Low-Income Owned or Controlled
Required in some cases: when Investee/Borrower Type is BUSFor businesses: more than 50% owned or controlled by low-income persons.
Values: Yes, No, Do Not Know
- Low-Income Owned or Controlled is required when Investee/Borrower Type is BUS.Abbreviated TLR guide, December 2023, p. 14 (Low-Income Owned or Controlled)
- Use a value from the CDFI Fund list: Yes, No or Do Not Know.Abbreviated TLR guide, December 2023, p. 14 (Low-Income Owned or Controlled)
Race
Required in some cases: when Investee/Borrower Type is INDFor individuals: the borrower’s race. OTHER for mixed race.
Values: AMIND, ALASKAN, ASIAN, BLACK, HAWAIIAN, PACIFIC, WHITE, OTHER, Do Not Know
- Race is required when Investee/Borrower Type is IND.Abbreviated TLR guide, December 2023, pp. 14-15 (Race)
- Use a value from the CDFI Fund list: AMIND, ALASKAN, ASIAN, BLACK, HAWAIIAN, PACIFIC, WHITE, OTHER or Do Not Know.Abbreviated TLR guide, December 2023, pp. 14-15 (Race)
Hispanic Origin
Required in some cases: when Investee/Borrower Type is INDFor individuals: whether the borrower is Hispanic.
Values: Yes, No, Do Not Know
- Hispanic Origin is required when Investee/Borrower Type is IND.Abbreviated TLR guide, December 2023, p. 15 (Hispanic Origin)
- Use a value from the CDFI Fund list: Yes, No or Do Not Know.Abbreviated TLR guide, December 2023, p. 15 (Hispanic Origin)
Low-Income Status
Required in some cases: when Investee/Borrower Type is INDFor individuals: whether family income is at or below 80% of the Area Median Family Income.
Values: Low-Income, Not Low-Income, Do Not Know
- Low-Income Status is required when Investee/Borrower Type is IND.Abbreviated TLR guide, December 2023, pp. 15-16 (Low-Income Status)
- Use a value from the CDFI Fund list: Low-Income, Not Low-Income or Do Not Know.Abbreviated TLR guide, December 2023, pp. 15-16 (Low-Income Status)
Target market (7)
Other Targeted Populations
RequiredThe Other Targeted Population the loan serves, or NA.
Values: Native American, Native Alaskan, African American, Native Hawaiian, Other Pacific Islander, Persons with Disabilities, Hispanic, Certified CDFIs, Filipino, Vietnamese, Other Approved OTP, NA
- Other Targeted Populations is a mandatory field.Abbreviated TLR guide, December 2023, p. 16 (Other Targeted Populations)
- Use a value from the CDFI Fund list: Native American, Native Alaskan, African American, Native Hawaiian, Other Pacific Islander, Persons with Disabilities, Hispanic, Certified CDFIs, Filipino, Vietnamese, Other Approved OTP or NA.Abbreviated TLR guide, December 2023, p. 16 (Other Targeted Populations)
Description of Other Approved OTP
Required in some cases: when Other Targeted Populations is Other Approved OTPWhen Other Targeted Populations is Other Approved OTP: which population.
- Description of Other Approved OTP is required when Other Targeted Populations is Other Approved OTP.Abbreviated TLR guide, December 2023, p. 17 (Description of Other Approved OTP)
LITP End Users
RequiredWhether the loan mainly serves low-income end users (third parties, such as a business’s employees or a building’s tenants).
Values: YES, NO, NA
- LITP End Users is a mandatory field.Abbreviated TLR guide, December 2023, p. 17 (LITP End Users)
- Use a value from the CDFI Fund list: YES, NO or NA.Abbreviated TLR guide, December 2023, p. 17 (LITP End Users)
OTP End Users
RequiredThe Other Targeted Population of the end users, or NA.
Values: Native American, Native Alaskan, African American, Native Hawaiian, Other Pacific Islander, Persons with Disabilities, Hispanic, Filipino, Vietnamese, Other Approved OTP, NA
- OTP End Users is a mandatory field.Abbreviated TLR guide, December 2023, p. 18 (OTP End Users)
- Use a value from the CDFI Fund list: Native American, Native Alaskan, African American, Native Hawaiian, Other Pacific Islander, Persons with Disabilities, Hispanic, Filipino, Vietnamese, Other Approved OTP or NA.Abbreviated TLR guide, December 2023, p. 18 (OTP End Users)
Description of Other Approved OTP-End Users
Required in some cases: when OTP End Users is Other Approved OTPWhen OTP End Users is Other Approved OTP: which population.
- Description of Other Approved OTP-End Users is required when OTP End Users is Other Approved OTP.Abbreviated TLR guide, December 2023, p. 18 (Description of Other Approved OTP-End Users)
IA End Users
RequiredWhether the loan serves end users in Investment Areas.
Values: YES, NO, NA
- IA End Users is a mandatory field.Abbreviated TLR guide, December 2023, p. 19 (IA End Users)
- Use a value from the CDFI Fund list: YES, NO or NA.Abbreviated TLR guide, December 2023, p. 19 (IA End Users)
Designated Target Market Type
RequiredThe one Target Market type used for this loan in the threshold calculation.
Values: IA – Pre-qualified, IA – Customized, IA – Non-Metro Customized, IA – Non-Metro counties/Parishes, LITP, OTP - Native American, OTP - Native Alaskan, OTP - African American, OTP - Native Hawaiian, OTP - Other Pacific Islander, OTP - Persons with Disabilities, OTP - Hispanic, OTP - Filipino, OTP - Vietnamese, OTP - Other Approved OTP, Non-Target Market
- Designated Target Market Type is a mandatory field.Abbreviated TLR guide, December 2023, pp. 19-20 (Designated Target Market Type)
- Use a value from the CDFI Fund list (see the guide for the full list).Abbreviated TLR guide, December 2023, pp. 19-20 (Designated Target Market Type)
- Designated Target Market Type must be Non-Target Market when International Address is Yes.Full-length TLR guide, May 2026, pp. 53-54 (International Address)
- Designated Target Market Type cannot be IA – Pre-qualified, IA – Customized, IA – Non-Metro Customized or IA – Non-Metro counties/Parishes when Unknown Domestic Address is Yes.Full-length TLR guide, May 2026, p. 54 (Unknown Domestic Address)
Location (12)
Project Street Address Line
Required in some cases: one of Project Street Address Line, Project Longitude (X-Coordinate) is needed when Investee/Borrower Type is BUS or CDFICheck with HenryThe street number and name of the business or project, for example 357 Bluff Rd. No P.O. boxes.
- Fill in Project Street Address Line or Project Longitude (X-Coordinate) when Investee/Borrower Type is BUS or CDFI.Full-length TLR guide, May 2026, pp. 50-53 (Project Street Address Line; Project Latitude (X-Coordinate))
- Leave Project Street Address Line empty when Project State is PR, AS, GU, MP or VI.Full-length TLR guide, May 2026, p. 50 (Project Street Address Line)
Check with Henry: the abbreviated guide (December 2023, p. 3, item 5) says to use the CDFI TLR Address report but does not list its fields. This check uses the full-length guide of May 2026.
Project Street Address Line 2
OptionalCheck with HenryUnit or suite number, if any. Optional.
Check with Henry: the abbreviated guide (December 2023, p. 3, item 5) says to use the CDFI TLR Address report but does not list its fields. This check uses the full-length guide of May 2026.
Project City
Required in some cases: when Investee/Borrower Type is BUS or CDFI, and Project Longitude (X-Coordinate) is empty, and Project Latitude (Y-Coordinate) is empty, and not (Project State is PR, AS, GU, MP or VI)Check with HenryThe project’s city.
- Project City is required when Investee/Borrower Type is BUS or CDFI, and Project Longitude (X-Coordinate) is empty, and Project Latitude (Y-Coordinate) is empty, and not (Project State is PR, AS, GU, MP or VI).Full-length TLR guide, May 2026, p. 51 (Project City)
- Leave Project City empty when Project State is PR, AS, GU, MP or VI.Full-length TLR guide, May 2026, p. 51 (Project City)
Check with Henry: the abbreviated guide (December 2023, p. 3, item 5) says to use the CDFI TLR Address report but does not list its fields. This check uses the full-length guide of May 2026.
Project State
Required in some cases: when Investee/Borrower Type is BUS or CDFI, and Project Longitude (X-Coordinate) is empty, and Project Latitude (Y-Coordinate) is emptyCheck with HenryThe two-letter state code, or the code of a US territory (PR, AS, GU, MP or VI).
Values: AL, AK, AZ, AR, CA, CO, CT, DE, DC, FL, GA, HI, ID, IL, IN, IA, KS, KY, LA, ME, MD, MA, MI, MN, MS, MO, MT, NE, NV, NH, NJ, NM, NY, NC, ND, OH, OK, OR, PA, RI, SC, SD, TN, TX, UT, VT, VA, WA, WV, WI, WY, PR, AS, GU, MP, VI
- Project State is required when Investee/Borrower Type is BUS or CDFI, and Project Longitude (X-Coordinate) is empty, and Project Latitude (Y-Coordinate) is empty.Full-length TLR guide, May 2026, p. 51 (Project State)
- Use a value from the CDFI Fund list (see the guide for the full list).Full-length TLR guide, May 2026, p. 51 (Project State)
Check with Henry: the abbreviated guide (December 2023, p. 3, item 5) says to use the CDFI TLR Address report but does not list its fields. This check uses the full-length guide of May 2026.
Project Zip Code 5
Required in some cases: when Investee/Borrower Type is BUS or CDFI, and Project Longitude (X-Coordinate) is empty, and Project Latitude (Y-Coordinate) is empty, and not (Project State is PR, AS, GU, MP or VI)Check with HenryThe five-digit zip code.
- Project Zip Code 5 is required when Investee/Borrower Type is BUS or CDFI, and Project Longitude (X-Coordinate) is empty, and Project Latitude (Y-Coordinate) is empty, and not (Project State is PR, AS, GU, MP or VI).Full-length TLR guide, May 2026, pp. 51-52 (Project Zip Code 5)
- Project Zip Code 5 must be a five-digit code, for example 22191 or 04106 (keep the leading 0; put the +4 in its own column).Full-length TLR guide, May 2026, pp. 51-52 (Project Zip Code 5)
- Leave Project Zip Code 5 empty when Project State is PR, AS, GU, MP or VI.Full-length TLR guide, May 2026, pp. 51-52 (Project Zip Code 5)
Check with Henry: the abbreviated guide (December 2023, p. 3, item 5) says to use the CDFI TLR Address report but does not list its fields. This check uses the full-length guide of May 2026.
Project Zip Code +4
OptionalCheck with HenryThe four-digit zip code extension. Optional.
- Project Zip Code +4 must be a four-digit code.Full-length TLR guide, May 2026, p. 52 (Project Zip Code +4)
Check with Henry: the abbreviated guide (December 2023, p. 3, item 5) says to use the CDFI TLR Address report but does not list its fields. This check uses the full-length guide of May 2026.
Project FIPS Code
Required in some cases: one of Project FIPS Code, Project Street Address Line, Project Longitude (X-Coordinate) is needed when Investee/Borrower Type is INDCheck with HenryThe 11-digit 2020 census tract FIPS code. For loans to individuals, the FIPS code can replace the address.
- Fill in Project FIPS Code, Project Street Address Line or Project Longitude (X-Coordinate) when Investee/Borrower Type is IND.Full-length TLR guide, May 2026, pp. 50-53 (CDFI Address TLR Object)
- Project FIPS Code must be an 11-digit code; a 10-digit code needs a leading 0 (Excel drops it, so format the column as text).Full-length TLR guide, May 2026, p. 52 (Project FIPS Code)
Check with Henry: the abbreviated guide (December 2023, p. 3, item 5) says to use the CDFI TLR Address report but does not list its fields. This check uses the full-length guide of May 2026.
Project Longitude (X-Coordinate)
Required in some cases: one of Project Street Address Line, Project Longitude (X-Coordinate) is needed when Investee/Borrower Type is BUS or CDFICheck with HenryThe project’s longitude. The guide labels this field "Project Latitude (X-Coordinate)" but asks for the longitude.
- Project Longitude (X-Coordinate) is required when Project State is PR, AS, GU, MP or VI.Full-length TLR guide, May 2026, p. 50 (CDFI Address TLR Object)
- Project Longitude (X-Coordinate) is required when Project Latitude (Y-Coordinate) is filled in.Full-length TLR guide, May 2026, pp. 52-53 (Project Latitude (X-Coordinate))
- Project Longitude (X-Coordinate) must be a number.Full-length TLR guide, May 2026, pp. 52-53 (Project Latitude (X-Coordinate))
- Project Longitude (X-Coordinate) must be equal to or greater than -180.Full-length TLR guide, May 2026, pp. 52-53 (Project Latitude (X-Coordinate))
- Project Longitude (X-Coordinate) cannot be greater than 180.Full-length TLR guide, May 2026, pp. 52-53 (Project Latitude (X-Coordinate))
Check with Henry: the abbreviated guide (December 2023, p. 3, item 5) says to use the CDFI TLR Address report but does not list its fields. This check uses the full-length guide of May 2026.
Project Latitude (Y-Coordinate)
Required in some cases: when Project Longitude (X-Coordinate) is filled inCheck with HenryThe project’s latitude.
- Project Latitude (Y-Coordinate) is required when Project Longitude (X-Coordinate) is filled in.Full-length TLR guide, May 2026, p. 53 (Project Latitude (Y-Coordinate))
- Project Latitude (Y-Coordinate) must be a number.Full-length TLR guide, May 2026, p. 53 (Project Latitude (Y-Coordinate))
- Project Latitude (Y-Coordinate) must be equal to or greater than -90.Full-length TLR guide, May 2026, p. 53 (Project Latitude (Y-Coordinate))
- Project Latitude (Y-Coordinate) cannot be greater than 90.Full-length TLR guide, May 2026, p. 53 (Project Latitude (Y-Coordinate))
Check with Henry: the abbreviated guide (December 2023, p. 3, item 5) says to use the CDFI TLR Address report but does not list its fields. This check uses the full-length guide of May 2026.
Census Vintage Year
RequiredCheck with HenryThe census year for the tracts. All CDFIs should select 2020.
Values: 2020, 2010
- Census Vintage Year is a mandatory field.Full-length TLR guide, May 2026, p. 53 (Census Vintage Year)
- Use a value from the CDFI Fund list: 2020 or 2010.Full-length TLR guide, May 2026, p. 53 (Census Vintage Year)
- All CDFIs should select 2020 as the Census Vintage Year.Full-length TLR guide, May 2026, p. 53 (Census Vintage Year)(a check to review, not an error)
Check with Henry: the abbreviated guide (December 2023, p. 3, item 5) says to use the CDFI TLR Address report but does not list its fields. This check uses the full-length guide of May 2026.
International Address
RequiredCheck with HenryYes if the borrower or business is outside the United States and its territories. The default is No.
Values: Yes, No
- International Address is a mandatory field.Full-length TLR guide, May 2026, pp. 53-54 (International Address)
- Use a value from the CDFI Fund list: Yes or No.Full-length TLR guide, May 2026, pp. 53-54 (International Address)
Check with Henry: the abbreviated guide (December 2023, p. 3, item 5) says to use the CDFI TLR Address report but does not list its fields. This check uses the full-length guide of May 2026.
Unknown Domestic Address
RequiredCheck with HenryYes if the place is in the United States but could not be geocoded. The default is No.
Values: Yes, No
- Unknown Domestic Address is a mandatory field.Full-length TLR guide, May 2026, p. 54 (Unknown Domestic Address)
- Use a value from the CDFI Fund list: Yes or No.Full-length TLR guide, May 2026, p. 54 (Unknown Domestic Address)
Check with Henry: the abbreviated guide (December 2023, p. 3, item 5) says to use the CDFI TLR Address report but does not list its fields. This check uses the full-length guide of May 2026.
Full-length TLR
103 data points, 245 checks.
Loan (17)
TLR Submission Year
RequiredThe CDFI’s fiscal year the loan was originated in, the same for every loan in the report.
- TLR Submission Year is a mandatory field.Full-length TLR guide, May 2026, p. 6 (TLR Submission Year)
- TLR Submission Year must be the year of this report for every loan.Full-length TLR guide, May 2026, p. 6 (TLR Submission Year)
Date Originated
RequiredThe date the borrower signed the note.
- Date Originated is a mandatory field.Full-length TLR guide, May 2026, p. 7 (Date Originated)
- Date Originated must be a date (mm/dd/yyyy).Full-length TLR guide, May 2026, p. 7 (Date Originated)
- Only loans originated during the reporting period belong in this TLR. Check the date, or leave the loan out.Full-length TLR guide, May 2026, p. 5, 7 (General Reporting Guidelines; Date Originated)
- Date Originated cannot be after today.Full-length TLR guide, May 2026, p. 7 (Date Originated)
Original Loan/Investment Amount
RequiredThe original amount, a positive whole number. For lines of credit, the credit limit.
- Original Loan/Investment Amount is a mandatory field.Full-length TLR guide, May 2026, p. 7 (Original Loan/Investment Amount)
- Original Loan/Investment Amount must be a number.Full-length TLR guide, May 2026, p. 7 (Original Loan/Investment Amount)
- Original Loan/Investment Amount must be greater than 0.Full-length TLR guide, May 2026, p. 7 (Original Loan/Investment Amount)
- Original Loan/Investment Amount must be a whole number.Full-length TLR guide, May 2026, p. 7 (Original Loan/Investment Amount)(a check to review, not an error)
- Original Loan/Investment Amount cannot be greater than 50,000 when Purpose is MICRO.Full-length TLR guide, May 2026, p. 7 (Original Loan/Investment Amount)
Purpose
RequiredCheck with HenryThe primary purpose: the one with the largest share of the loan.
Values: CONSUMER, BUSINESS, MICRO, HOMEPURCH, HOMEIMP, RECOCOM, RECOMULTI, RECOSINGLE, RERHCOM, RERHMULTI, RERHSINGLE, OTHER
- Purpose is a mandatory field.Full-length TLR guide, May 2026, pp. 7-9 (Purpose)
- Use a value from the CDFI Fund list: CONSUMER, BUSINESS, MICRO, HOMEPURCH, HOMEIMP, RECOCOM, RECOMULTI, RECOSINGLE, RERHCOM, RERHMULTI, RERHSINGLE or OTHER.Full-length TLR guide, May 2026, pp. 7-9 (Purpose)
- Purpose cannot be BUSINESS, RECOCOM, RECOMULTI, RECOSINGLE, RERHCOM, RERHMULTI or RERHSINGLE when Investee/Borrower Type is IND.Full-length TLR guide, May 2026, p. 16 (Investee/Borrower Type)
- Purpose must be OTHER when Investee/Borrower Type is CDFI.Full-length TLR guide, May 2026, p. 16 (Investee/Borrower Type)
- Purpose cannot be CONSUMER, HOMEPURCH or HOMEIMP when Investee/Borrower Type is BUS.Full-length TLR guide, May 2026, p. 16 (Investee/Borrower Type)
Check with Henry: the May 2026 guide lists CLIMATE among the purposes for individuals (p. 8) but not in the Purpose code table. The tool follows the table, so CLIMATE is reported as not on the list.
Transaction Type
RequiredThe kind of transaction: term loan, line of credit, equity investment and so on.
Values: TERM, EQTYINV, CREDITCARD, LOC, DEBTEQTY, LNGUARANTEE, LNLSRESERVE, CAPRESERVE, OTHER
- Transaction Type is a mandatory field.Full-length TLR guide, May 2026, p. 9 (Transaction Type)
- Use a value from the CDFI Fund list: TERM, EQTYINV, CREDITCARD, LOC, DEBTEQTY, LNGUARANTEE, LNLSRESERVE, CAPRESERVE or OTHER.Full-length TLR guide, May 2026, p. 9 (Transaction Type)
Loan Status
RequiredThe status at the end of the reporting period.
Values: ACTIVE, CLOSED, SOLD, CHARGEDOFF, REFIN, RESTRUCT
- Loan Status is a mandatory field.Full-length TLR guide, May 2026, p. 10 (Loan Status)
- Use a value from the CDFI Fund list: ACTIVE, CLOSED, SOLD, CHARGEDOFF, REFIN or RESTRUCT.Full-length TLR guide, May 2026, p. 10 (Loan Status)
Originator Transaction ID
RequiredYour unique id for the loan. Starts with a letter, up to 20 characters, no names or Social Security numbers.
- Originator Transaction ID is a mandatory field.Full-length TLR guide, May 2026, p. 10 (Originator Transaction ID)
- Originator Transaction ID must start with a letter, for example a1234.Full-length TLR guide, May 2026, p. 10 (Originator Transaction ID)
- Originator Transaction ID should have letters and numbers only, with no special characters such as commas or exclamation points.Full-length TLR guide, May 2026, p. 10 (Originator Transaction ID)(a check to review, not an error)
- Originator Transaction ID can be at most 20 characters long.Full-length TLR guide, May 2026, p. 10 (Originator Transaction ID)
- Each Originator Transaction ID must be unique: give every loan its own.Full-length TLR guide, May 2026, p. 10 (Originator Transaction ID)
Interest Rate
Required in some cases: when Transaction Type is TERM, LOC or DEBTEQTYThe rate at origination as a percentage: 2.5 for 2.5%. 99 if unknown or not applicable.
- Interest Rate is required when Transaction Type is TERM, LOC or DEBTEQTY.Full-length TLR guide, May 2026, p. 11 (Interest Rate)
- Interest Rate must be a number.Full-length TLR guide, May 2026, p. 11 (Interest Rate)
- Interest Rate must be equal to or greater than 0 when Transaction Type is TERM, LOC or DEBTEQTY.Full-length TLR guide, May 2026, p. 11 (Interest Rate)
- Interest Rate can have at most 3 decimal places.Full-length TLR guide, May 2026, p. 11 (Interest Rate)
- Enter Interest Rate as a percentage, for example 2.5 for 2.5%, not 0.025.Full-length TLR guide, May 2026, p. 11 (Interest Rate)(a check to review, not an error)
Interest Type
Required in some cases: when Transaction Type is TERM, LOC or DEBTEQTYWhether the rate at origination is fixed or adjustable.
Values: FIXED, ADJ
- Interest Type is required when Transaction Type is TERM, LOC or DEBTEQTY.Full-length TLR guide, May 2026, p. 11 (Interest Type)
- Use a value from the CDFI Fund list: FIXED or ADJ.Full-length TLR guide, May 2026, p. 11 (Interest Type)
Points
Required in some cases: when Transaction Type is TERM or DEBTEQTYPoints at origination as a percentage of the loan, not the fees. 99 if unknown or not applicable.
- Points is required when Transaction Type is TERM or DEBTEQTY.Full-length TLR guide, May 2026, p. 11 (Points)
- Points must be a number.Full-length TLR guide, May 2026, p. 11 (Points)
- Points must be equal to or greater than 0.Full-length TLR guide, May 2026, p. 11 (Points)
- Points cannot be greater than 100.Full-length TLR guide, May 2026, p. 11 (Points)
- Points can have at most 3 decimal places.Full-length TLR guide, May 2026, p. 11 (Points)
Origination Fees
Required in some cases: when Transaction Type is TERM, LOC or DEBTEQTYTotal fees paid at origination, not the points. 0 if none.
- Origination Fees is required when Transaction Type is TERM, LOC or DEBTEQTY.Full-length TLR guide, May 2026, p. 12 (Origination Fees)
- Origination Fees must be a number.Full-length TLR guide, May 2026, p. 12 (Origination Fees)
- Origination Fees must be equal to or greater than 0 when Transaction Type is TERM, LOC or DEBTEQTY.Full-length TLR guide, May 2026, p. 12 (Origination Fees)
- Origination Fees must be less than Original Loan/Investment Amount when Transaction Type is TERM, LOC or DEBTEQTY.Full-length TLR guide, May 2026, p. 12 (Origination Fees)
- Origination Fees can have at most 2 decimal places.Full-length TLR guide, May 2026, p. 12 (Origination Fees)
Amortization Type
Required in some cases: when Transaction Type is TERM, LOC or DEBTEQTYHow the loan is amortized at origination.
Values: FULLAMORT, PARTAMORT, NONAMORT, OTHER
- Amortization Type is required when Transaction Type is TERM, LOC or DEBTEQTY.Full-length TLR guide, May 2026, p. 12 (Amortization Type)
- Use a value from the CDFI Fund list: FULLAMORT, PARTAMORT, NONAMORT or OTHER.Full-length TLR guide, May 2026, p. 12 (Amortization Type)
Equity-Like Features
Required in some cases: when Transaction Type is DEBTEQTYFor debt with equity: the equity-like feature that appears first in the loan agreement.
Values: CONVDEBT, PERFINT, ROYALTIES, WARRANTS, OTHER
- Equity-Like Features is required when Transaction Type is DEBTEQTY.Full-length TLR guide, May 2026, pp. 12-13 (Equity-Like Features)
- Use a value from the CDFI Fund list: CONVDEBT, PERFINT, ROYALTIES, WARRANTS or OTHER.Full-length TLR guide, May 2026, pp. 12-13 (Equity-Like Features)
Term (in months)
Required in some cases: when Transaction Type is TERMThe full term at origination in months; 15 days is 0.5. 999 if unknown or not applicable.
- Term (in months) is required when Transaction Type is TERM.Full-length TLR guide, May 2026, p. 13 (Term (in months))
- Term (in months) must be a number.Full-length TLR guide, May 2026, p. 13 (Term (in months))
- Term (in months) must be greater than 0 when Transaction Type is TERM.Full-length TLR guide, May 2026, p. 13 (Term (in months))
- Term (in months) is most likely between 1 and 360. Check it is in months, not days; 999 means unknown.Full-length TLR guide, May 2026, p. 13 (Term (in months))(a check to review, not an error)
Guarantee by Third Party
Required in some cases: when Transaction Type is TERM, LOC or DEBTEQTYWho guarantees part of the loan, if anyone. Not performance guarantees.
Values: SBA, USDA, OTHERGOV, PERSONAL, NONE, OTHER
- Guarantee by Third Party is required when Transaction Type is TERM, LOC or DEBTEQTY.Full-length TLR guide, May 2026, pp. 13-14 (Guarantee by Third Party)
- Use a value from the CDFI Fund list: SBA, USDA, OTHERGOV, PERSONAL, NONE or OTHER.Full-length TLR guide, May 2026, pp. 13-14 (Guarantee by Third Party)
Forgivable Loan
Required in some cases: when Transaction Type is TERM, EQTYINV, LOC or DEBTEQTYWhether some or all of the loan may be converted to a grant.
Values: Yes, YesTM1, YesTM2, No, Do Not Know
- Forgivable Loan is required when Transaction Type is TERM, EQTYINV, LOC or DEBTEQTY.Full-length TLR guide, May 2026, pp. 14-15 (Forgivable Loan)
- Use a value from the CDFI Fund list: Yes, YesTM1, YesTM2, No or Do Not Know.Full-length TLR guide, May 2026, pp. 14-15 (Forgivable Loan)
FA Program Type
RequiredWhich award’s performance goal the loan is used for, or NA. Only one per loan.
Values: PPC-FA, HFFI-FA, DF-FA, RRP-FA, ERP, FA, CMF, NMTC, NA
- FA Program Type is a mandatory field.Full-length TLR guide, May 2026, pp. 15-16 (FA Program Type)
- Use a value from the CDFI Fund list: PPC-FA, HFFI-FA, DF-FA, RRP-FA, ERP, FA, CMF, NMTC or NA.Full-length TLR guide, May 2026, pp. 15-16 (FA Program Type)
- RRP-FA is kept only for late submissions after December 31, 2025. Check your award agreement.Full-length TLR guide, May 2026, pp. 15-16 (FA Program Type)(a check to review, not an error)
Borrower (17)
Client ID
RequiredYour id for the borrower or project. Starts with a letter, up to 20 characters, no names or Social Security numbers.
- Client ID is a mandatory field.Full-length TLR guide, May 2026, p. 16 (Client ID)
- Client ID must start with a letter, for example a1234.Full-length TLR guide, May 2026, p. 16 (Client ID)(a check to review, not an error)
- Client ID should have letters and numbers only, with no special characters such as commas or exclamation points.Full-length TLR guide, May 2026, p. 16 (Client ID)(a check to review, not an error)
- Client ID can be at most 20 characters long.Full-length TLR guide, May 2026, p. 16 (Client ID)
Investee/Borrower Type
RequiredWhether the borrower is an individual, a business or a certified CDFI. Nonprofits are businesses.
Values: IND, BUS, CDFI
- Investee/Borrower Type is a mandatory field.Full-length TLR guide, May 2026, pp. 16-17 (Investee/Borrower Type)
- Use a value from the CDFI Fund list: IND, BUS or CDFI.Full-length TLR guide, May 2026, pp. 16-17 (Investee/Borrower Type)
NAICS
Required in some cases: when Investee/Borrower Type is BUSFor businesses: the six-digit 2022 NAICS code. 999999 if unknown or not applicable.
- NAICS is required when Investee/Borrower Type is BUS.Full-length TLR guide, May 2026, p. 17 (NAICS)
- NAICS must be a six-digit code (999999 if unknown).Full-length TLR guide, May 2026, p. 17 (NAICS)
Date Business Established
Required in some cases: when Investee/Borrower Type is BUSFor businesses: the date the business was formed or first made sales. If unknown, the Date Originated.
- Date Business Established is required when Investee/Borrower Type is BUS.Full-length TLR guide, May 2026, p. 17 (Date Business Established)
- Date Business Established must be a date (mm/dd/yyyy).Full-length TLR guide, May 2026, p. 17 (Date Business Established)
- Date Business Established cannot be after Date Originated.Full-length TLR guide, May 2026, p. 17 (Date Business Established)
- Date Business Established must be before today.Full-length TLR guide, May 2026, p. 17 (Date Business Established)
Entity Structure
Required in some cases: when Investee/Borrower Type is BUSFor businesses: nonprofit, for-profit, tribal government or other.
Values: NONPROFIT, FORPROFIT, TRIBAL, OTHER
- Entity Structure is required when Investee/Borrower Type is BUS.Full-length TLR guide, May 2026, p. 18 (Entity Structure)
- Use a value from the CDFI Fund list: NONPROFIT, FORPROFIT, TRIBAL or OTHER.Full-length TLR guide, May 2026, p. 18 (Entity Structure)
Minority Owned or Controlled
Required in some cases: when Investee/Borrower Type is BUSFor businesses: more than 50% owned or controlled by minorities.
Values: Yes, No, Do Not Know
- Minority Owned or Controlled is required when Investee/Borrower Type is BUS.Full-length TLR guide, May 2026, p. 18 (Minority Owned or Controlled)
- Use a value from the CDFI Fund list: Yes, No or Do Not Know.Full-length TLR guide, May 2026, p. 18 (Minority Owned or Controlled)
Women Owned or Controlled
Required in some cases: when Investee/Borrower Type is BUSFor businesses: more than 50% owned or controlled by women.
Values: Yes, No, Do Not Know
- Women Owned or Controlled is required when Investee/Borrower Type is BUS.Full-length TLR guide, May 2026, pp. 18-19 (Women Owned or Controlled)
- Use a value from the CDFI Fund list: Yes, No or Do Not Know.Full-length TLR guide, May 2026, pp. 18-19 (Women Owned or Controlled)
Low-Income Owned or Controlled
Required in some cases: when Investee/Borrower Type is BUSFor businesses: more than 50% owned or controlled by low-income persons.
Values: Yes, No, Do Not Know
- Low-Income Owned or Controlled is required when Investee/Borrower Type is BUS.Full-length TLR guide, May 2026, p. 19 (Low-Income Owned or Controlled)
- Use a value from the CDFI Fund list: Yes, No or Do Not Know.Full-length TLR guide, May 2026, p. 19 (Low-Income Owned or Controlled)
Credit Score Category
Required in some cases: when Investee/Borrower Type is INDFor individuals: the band of the most recent credit score.
Values: Excellent Credit, Very Good Credit, Good Credit, Fair Credit, Poor Credit, No or Thin Credit, Do Not Know
- Credit Score Category is required when Investee/Borrower Type is IND.Full-length TLR guide, May 2026, pp. 19-20 (Credit Score Category)
- Use a value from the CDFI Fund list: Excellent Credit, Very Good Credit, Good Credit, Fair Credit, Poor Credit, No or Thin Credit or Do Not Know.Full-length TLR guide, May 2026, pp. 19-20 (Credit Score Category)
Sex
Required in some cases: when Investee/Borrower Type is INDFor individuals: the borrower’s sex, or Declined to Answer.
Values: MALE, FEMALE, Declined to Answer
- Sex is required when Investee/Borrower Type is IND.Full-length TLR guide, May 2026, p. 20 (Sex)
- Use a value from the CDFI Fund list: MALE, FEMALE or Declined to Answer.Full-length TLR guide, May 2026, p. 20 (Sex)
Race
Required in some cases: when Investee/Borrower Type is INDFor individuals: the borrower’s race. OTHER for mixed race.
Values: AMIND, ALASKAN, ASIAN, BLACK, HAWAIIAN, PACIFIC, WHITE, OTHER, Do Not Know
- Race is required when Investee/Borrower Type is IND.Full-length TLR guide, May 2026, p. 20 (Race)
- Use a value from the CDFI Fund list: AMIND, ALASKAN, ASIAN, BLACK, HAWAIIAN, PACIFIC, WHITE, OTHER or Do Not Know.Full-length TLR guide, May 2026, p. 20 (Race)
Hispanic Origin
Required in some cases: when Investee/Borrower Type is INDFor individuals: whether the borrower is Hispanic or Latino.
Values: Yes, No, Do Not Know
- Hispanic Origin is required when Investee/Borrower Type is IND.Full-length TLR guide, May 2026, p. 21 (Hispanic Origin)
- Use a value from the CDFI Fund list: Yes, No or Do Not Know.Full-length TLR guide, May 2026, p. 21 (Hispanic Origin)
Female-Headed Household
Required in some cases: when Investee/Borrower Type is INDFor individuals: whether the borrower is a single woman who is the main support of a household with a dependent.
Values: Yes, No, Do Not Know
- Female-Headed Household is required when Investee/Borrower Type is IND.Full-length TLR guide, May 2026, p. 21 (Female-Headed Household)
- Use a value from the CDFI Fund list: Yes, No or Do Not Know.Full-length TLR guide, May 2026, p. 21 (Female-Headed Household)
First-Time Home Buyer
Required in some cases: when Purpose is HOMEPURCHFor home purchase loans: whether the buyer has not owned a home in the past three years.
Values: Yes, No, Do Not Know
- First-Time Home Buyer is required when Purpose is HOMEPURCH.Full-length TLR guide, May 2026, pp. 21-22 (First-Time Home Buyer)
- Use a value from the CDFI Fund list: Yes, No or Do Not Know.Full-length TLR guide, May 2026, pp. 21-22 (First-Time Home Buyer)
Banked at Time of Intake
Required in some cases: when Investee/Borrower Type is INDFor individuals: banking status at intake.
Values: Banked, Underbanked, Unbanked, Do Not Know
- Banked at Time of Intake is required when Investee/Borrower Type is IND.Full-length TLR guide, May 2026, p. 22 (Banked at Time of Intake)
- Use a value from the CDFI Fund list: Banked, Underbanked, Unbanked or Do Not Know.Full-length TLR guide, May 2026, p. 22 (Banked at Time of Intake)
Annual Gross Revenue from Business Operations at Time of Loan/Investment Origination
Required in some cases: when Investee/Borrower Type is BUSFor businesses: gross revenue in the most recent 12 months before origination. 0 if none.
- Annual Gross Revenue from Business Operations at Time of Loan/Investment Origination is required when Investee/Borrower Type is BUS.Full-length TLR guide, May 2026, p. 22 (Annual Gross Revenue from Business Operations at Time of Loan/Investment Origination)
- Annual Gross Revenue from Business Operations at Time of Loan/Investment Origination must be a number.Full-length TLR guide, May 2026, p. 22 (Annual Gross Revenue from Business Operations at Time of Loan/Investment Origination)
- Annual Gross Revenue from Business Operations at Time of Loan/Investment Origination must be equal to or greater than 0 when Investee/Borrower Type is BUS.Full-length TLR guide, May 2026, p. 22 (Annual Gross Revenue from Business Operations at Time of Loan/Investment Origination)
Low-Income Status
Required in some cases: when Investee/Borrower Type is INDFor individuals: the income band against the area median family income.
Values: Extremely Low-Income, Very Low-Income, Low-Income, Middle-Income, Upper-Income, Do Not Know
- Low-Income Status is required when Investee/Borrower Type is IND.Full-length TLR guide, May 2026, p. 23 (Low-Income Status)
- Use a value from the CDFI Fund list: Extremely Low-Income, Very Low-Income, Low-Income, Middle-Income, Upper-Income or Do Not Know.Full-length TLR guide, May 2026, p. 23 (Low-Income Status)
Target market (7)
Other Targeted Populations
RequiredThe Other Targeted Population the loan serves, or NA.
Values: Native American, Native Alaskan, African American, Native Hawaiian, Other Pacific Islander, Filipino, Vietnamese, Persons with Disabilities, Hispanic, Certified CDFIs, Other Approved OTP, NA
- Other Targeted Populations is a mandatory field.Full-length TLR guide, May 2026, pp. 23-24 (Other Targeted Populations)
- Use a value from the CDFI Fund list: Native American, Native Alaskan, African American, Native Hawaiian, Other Pacific Islander, Filipino, Vietnamese, Persons with Disabilities, Hispanic, Certified CDFIs, Other Approved OTP or NA.Full-length TLR guide, May 2026, pp. 23-24 (Other Targeted Populations)
Description of Other Approved OTP
Required in some cases: when Other Targeted Populations is Other Approved OTPWhen Other Targeted Populations is Other Approved OTP: which population.
- Description of Other Approved OTP is required when Other Targeted Populations is Other Approved OTP.Full-length TLR guide, May 2026, p. 24 (Description of Other Approved OTP)
LITP End Users
RequiredWhether the loan mainly serves low-income end users (third parties, such as a business’s employees or a building’s tenants).
Values: YES, NO, NA
- LITP End Users is a mandatory field.Full-length TLR guide, May 2026, p. 25 (LITP End Users)
- Use a value from the CDFI Fund list: YES, NO or NA.Full-length TLR guide, May 2026, p. 25 (LITP End Users)
OTP End Users
RequiredCheck with HenryThe Other Targeted Population of the end users, or NA.
Values: Native American, Native Alaskan, African American/Black, Native Hawaiian, Native Pacific Islander, Persons with Disabilities, Hispanic, Filipino, Vietnamese, Other Approved OTP, NA
- OTP End Users is a mandatory field.Full-length TLR guide, May 2026, pp. 25-26 (OTP End Users)
- Use a value from the CDFI Fund list: Native American, Native Alaskan, African American/Black, Native Hawaiian, Native Pacific Islander, Persons with Disabilities, Hispanic, Filipino, Vietnamese, Other Approved OTP or NA.Full-length TLR guide, May 2026, pp. 25-26 (OTP End Users)
Check with Henry: the May 2026 guide spells two OTP End Users values differently from the Other Targeted Populations list ("African American/Black", "Native Pacific Islander"). The tool uses the spelling of this list and suggests it for "African American" and "Other Pacific Islander".
Description of Other Approved OTP-End Users
Required in some cases: when OTP End Users is Other Approved OTPWhen OTP End Users is Other Approved OTP: which population.
- Description of Other Approved OTP-End Users is required when OTP End Users is Other Approved OTP.Full-length TLR guide, May 2026, p. 26 (Description of Other Approved OTP-End Users)
IA End Users
RequiredWhether the loan serves end users in Investment Areas (2016-2020 ACS dataset).
Values: YES, NO, NA
- IA End Users is a mandatory field.Full-length TLR guide, May 2026, pp. 26-27 (IA End Users)
- Use a value from the CDFI Fund list: YES, NO or NA.Full-length TLR guide, May 2026, pp. 26-27 (IA End Users)
Designated Target Market Type
RequiredThe one Target Market type used for this loan in the threshold calculation.
Values: IA–Pre-qualified, IA–Customized, IA–Non-Metro Customized, IA–Non-Metro Counties/Parishes, LITP, OTP–Native American, OTP–Native Alaskan, OTP–African American, OTP–Native Hawaiian, OTP–Other Pacific Islander, OTP–Persons with Disabilities, OTP–Hispanic, OTP–Filipino, OTP–Vietnamese, OTP–Certified CDFIs, OTP–Other Approved OTP, Non-Target Market
- Designated Target Market Type is a mandatory field.Full-length TLR guide, May 2026, pp. 27-28 (Designated Target Market Type)
- Use a value from the CDFI Fund list (see the guide for the full list).Full-length TLR guide, May 2026, pp. 27-28 (Designated Target Market Type)
- Designated Target Market Type must be Non-Target Market when International Address is Yes.Full-length TLR guide, May 2026, pp. 53-54 (International Address)
- Designated Target Market Type cannot be IA–Pre-qualified, IA–Customized, IA–Non-Metro Customized or IA–Non-Metro Counties/Parishes when Unknown Domestic Address is Yes.Full-length TLR guide, May 2026, p. 54 (Unknown Domestic Address)
Impact (25)
Total Project Cost
Required in some cases: when Investee/Borrower Type is BUSThe total cost of the project the loan funds. If unknown, the Original Loan/Investment Amount.
- Total Project Cost is required when Investee/Borrower Type is BUS.Full-length TLR guide, May 2026, p. 28 (Total Project Cost)
- Total Project Cost must be a number.Full-length TLR guide, May 2026, p. 28 (Total Project Cost)
- Total Project Cost must be equal to or greater than Original Loan/Investment Amount when Investee/Borrower Type is BUS.Full-length TLR guide, May 2026, p. 28 (Total Project Cost)
Type of Jobs Reported
Required in some cases: when Purpose is BUSINESS, MICRO, RECOCOM, RECOMULTI, RECOSINGLE, RERHCOM, RERHMULTI or RERHSINGLEWhether the job numbers are direct jobs, or direct and indirect jobs.
Values: DIRECT, DWINDIRECT, Do Not Know
- Type of Jobs Reported is required when Purpose is BUSINESS, MICRO, RECOCOM, RECOMULTI, RECOSINGLE, RERHCOM, RERHMULTI or RERHSINGLE.Full-length TLR guide, May 2026, p. 30 (Type of Jobs Reported)
- Use a value from the CDFI Fund list: DIRECT, DWINDIRECT or Do Not Know.Full-length TLR guide, May 2026, p. 30 (Type of Jobs Reported)
Projected Permanent Jobs to Be Created at Business Financed
Required in some cases: when Purpose is BUSINESS or MICROFor business and micro loans: projected permanent full-time equivalent jobs created and retained. 0 if none.
- Projected Permanent Jobs to Be Created at Business Financed is required when Purpose is BUSINESS or MICRO.Full-length TLR guide, May 2026, p. 30 (Projected Permanent Jobs to Be Created at Business Financed)
- Projected Permanent Jobs to Be Created at Business Financed must be a number.Full-length TLR guide, May 2026, p. 30 (Projected Permanent Jobs to Be Created at Business Financed)
- Projected Permanent Jobs to Be Created at Business Financed must be equal to or greater than 0 when Purpose is BUSINESS or MICRO.Full-length TLR guide, May 2026, p. 30 (Projected Permanent Jobs to Be Created at Business Financed)
Projected Jobs to Be Created-Construction
Required in some cases: when Purpose is RECOCOM, RECOMULTI, RECOSINGLE, RERHCOM, RERHMULTI or RERHSINGLEFor real estate loans: projected full-time equivalent construction jobs. 0 if none.
- Projected Jobs to Be Created-Construction is required when Purpose is RECOCOM, RECOMULTI, RECOSINGLE, RERHCOM, RERHMULTI or RERHSINGLE.Full-length TLR guide, May 2026, pp. 30-31 (Projected Jobs to Be Created-Construction)
- Projected Jobs to Be Created-Construction must be a number.Full-length TLR guide, May 2026, pp. 30-31 (Projected Jobs to Be Created-Construction)
- Projected Jobs to Be Created-Construction must be equal to or greater than 0 when Purpose is RECOCOM, RECOMULTI, RECOSINGLE, RERHCOM, RERHMULTI or RERHSINGLE.Full-length TLR guide, May 2026, pp. 30-31 (Projected Jobs to Be Created-Construction)
Projected Permanent Jobs to Be Created at Tenant Businesses
Required in some cases: when Purpose is RECOCOM, RECOMULTI, RECOSINGLE, RERHCOM, RERHMULTI or RERHSINGLEFor real estate loans: projected permanent jobs at businesses at the property. 0 if none.
- Projected Permanent Jobs to Be Created at Tenant Businesses is required when Purpose is RECOCOM, RECOMULTI, RECOSINGLE, RERHCOM, RERHMULTI or RERHSINGLE.Full-length TLR guide, May 2026, p. 31 (Projected Permanent Jobs to Be Created at Tenant Businesses)
- Projected Permanent Jobs to Be Created at Tenant Businesses must be a number.Full-length TLR guide, May 2026, p. 31 (Projected Permanent Jobs to Be Created at Tenant Businesses)
- Projected Permanent Jobs to Be Created at Tenant Businesses must be equal to or greater than 0 when Purpose is RECOCOM, RECOMULTI, RECOSINGLE, RERHCOM, RERHMULTI or RERHSINGLE.Full-length TLR guide, May 2026, p. 31 (Projected Permanent Jobs to Be Created at Tenant Businesses)
Source of Job Estimates
Required in some cases: when Purpose is BUSINESS, MICRO, RECOCOM, RECOMULTI, RECOSINGLE, RERHCOM, RERHMULTI or RERHSINGLEWhere the job numbers come from.
Values: NEWFINANCING, WAGEDATA, ECONOMICIMPACT, RULEOFTHUMB, OTHER
- Source of Job Estimates is required when Purpose is BUSINESS, MICRO, RECOCOM, RECOMULTI, RECOSINGLE, RERHCOM, RERHMULTI or RERHSINGLE.Full-length TLR guide, May 2026, pp. 31-32 (Source of Job Estimates)
- Use a value from the CDFI Fund list: NEWFINANCING, WAGEDATA, ECONOMICIMPACT, RULEOFTHUMB or OTHER.Full-length TLR guide, May 2026, pp. 31-32 (Source of Job Estimates)
Source of Job Estimates – Other
Required in some cases: when Source of Job Estimates is OTHERWhen the source is OTHER: what it is.
- Source of Job Estimates – Other is required when Source of Job Estimates is OTHER.Full-length TLR guide, May 2026, p. 32 (Source of Job Estimates – Other)
Community Facility
RequiredWhether the project financed is a community facility.
Values: Yes, No, Do Not Know
- Community Facility is a mandatory field.Full-length TLR guide, May 2026, p. 32 (Community Facility)
- Use a value from the CDFI Fund list: Yes, No or Do Not Know.Full-length TLR guide, May 2026, p. 32 (Community Facility)
Capacity of Educational Community Facility
Required in some cases: when Community Facility is YesStudents served per year. 0 if unknown or not applicable.
- Capacity of Educational Community Facility is required when Community Facility is Yes.Full-length TLR guide, May 2026, pp. 32-33 (Capacity of Educational Community Facility)
- Capacity of Educational Community Facility must be a number.Full-length TLR guide, May 2026, pp. 32-33 (Capacity of Educational Community Facility)
- Capacity of Educational Community Facility must be equal to or greater than 0 when Community Facility is Yes.Full-length TLR guide, May 2026, pp. 32-33 (Capacity of Educational Community Facility)
Capacity of Child Care Community Facility
Required in some cases: when Community Facility is YesChildren served per year. 0 if unknown or not applicable.
- Capacity of Child Care Community Facility is required when Community Facility is Yes.Full-length TLR guide, May 2026, p. 33 (Capacity of Child Care Community Facility)
- Capacity of Child Care Community Facility must be a number.Full-length TLR guide, May 2026, p. 33 (Capacity of Child Care Community Facility)
- Capacity of Child Care Community Facility must be equal to or greater than 0 when Community Facility is Yes.Full-length TLR guide, May 2026, p. 33 (Capacity of Child Care Community Facility)
Capacity of Healthcare Community Facility
Required in some cases: when Community Facility is YesPatients or visits per year. 0 if unknown or not applicable.
- Capacity of Healthcare Community Facility is required when Community Facility is Yes.Full-length TLR guide, May 2026, p. 33 (Capacity of Healthcare Community Facility)
- Capacity of Healthcare Community Facility must be a number.Full-length TLR guide, May 2026, p. 33 (Capacity of Healthcare Community Facility)
- Capacity of Healthcare Community Facility must be equal to or greater than 0 when Community Facility is Yes.Full-length TLR guide, May 2026, p. 33 (Capacity of Healthcare Community Facility)
Capacity of Arts Center Community Facility
Required in some cases: when Community Facility is YesPeople served or visits per year. 0 if unknown or not applicable.
- Capacity of Arts Center Community Facility is required when Community Facility is Yes.Full-length TLR guide, May 2026, pp. 33-34 (Capacity of Arts Center Community Facility)
- Capacity of Arts Center Community Facility must be a number.Full-length TLR guide, May 2026, pp. 33-34 (Capacity of Arts Center Community Facility)
- Capacity of Arts Center Community Facility must be equal to or greater than 0 when Community Facility is Yes.Full-length TLR guide, May 2026, pp. 33-34 (Capacity of Arts Center Community Facility)
Capacity of Other Community Facility
Required in some cases: when Community Facility is YesPeople served or visits per year. 0 if unknown or not applicable.
- Capacity of Other Community Facility is required when Community Facility is Yes.Full-length TLR guide, May 2026, p. 34 (Capacity of Other Community Facility)
- Capacity of Other Community Facility must be a number.Full-length TLR guide, May 2026, p. 34 (Capacity of Other Community Facility)
- Capacity of Other Community Facility must be equal to or greater than 0 when Community Facility is Yes.Full-length TLR guide, May 2026, p. 34 (Capacity of Other Community Facility)
Square Feet of Real Estate – Total
Required in some cases: when Purpose is RECOCOM or RERHCOMGross square feet built, rehabilitated or acquired. 0 if none.
- Square Feet of Real Estate – Total is required when Purpose is RECOCOM or RERHCOM.Full-length TLR guide, May 2026, p. 34 (Square Feet of Real Estate – Total)
- Square Feet of Real Estate – Total must be a number.Full-length TLR guide, May 2026, p. 34 (Square Feet of Real Estate – Total)
- Square Feet of Real Estate – Total must be equal to or greater than the sum of Square Feet of Real Estate – Manufacturing, Square Feet of Real Estate – Office and Square Feet of Real Estate – Retail when Purpose is RECOCOM or RERHCOM.Full-length TLR guide, May 2026, p. 34 (Square Feet of Real Estate – Total)
Square Feet of Real Estate – Manufacturing
Required in some cases: when Purpose is RECOCOM or RERHCOMGross square feet of manufacturing space. 0 if none.
- Square Feet of Real Estate – Manufacturing is required when Purpose is RECOCOM or RERHCOM.Full-length TLR guide, May 2026, p. 35 (Square Feet of Real Estate – Manufacturing)
- Square Feet of Real Estate – Manufacturing must be a number.Full-length TLR guide, May 2026, p. 35 (Square Feet of Real Estate – Manufacturing)
- Square Feet of Real Estate – Manufacturing must be equal to or greater than 0 when Purpose is RECOCOM or RERHCOM.Full-length TLR guide, May 2026, p. 35 (Square Feet of Real Estate – Manufacturing)
Square Feet of Real Estate – Office
Required in some cases: when Purpose is RECOCOM or RERHCOMGross square feet of office space. 0 if none.
- Square Feet of Real Estate – Office is required when Purpose is RECOCOM or RERHCOM.Full-length TLR guide, May 2026, p. 35 (Square Feet of Real Estate – Office)
- Square Feet of Real Estate – Office must be a number.Full-length TLR guide, May 2026, p. 35 (Square Feet of Real Estate – Office)
- Square Feet of Real Estate – Office must be equal to or greater than 0 when Purpose is RECOCOM or RERHCOM.Full-length TLR guide, May 2026, p. 35 (Square Feet of Real Estate – Office)
Square Feet of Real Estate – Retail
Required in some cases: when Purpose is RECOCOM or RERHCOMGross square feet of retail space. 0 if none.
- Square Feet of Real Estate – Retail is required when Purpose is RECOCOM or RERHCOM.Full-length TLR guide, May 2026, p. 35 (Square Feet of Real Estate – Retail)
- Square Feet of Real Estate – Retail must be a number.Full-length TLR guide, May 2026, p. 35 (Square Feet of Real Estate – Retail)
- Square Feet of Real Estate – Retail must be equal to or greater than 0 when Purpose is RECOCOM or RERHCOM.Full-length TLR guide, May 2026, p. 35 (Square Feet of Real Estate – Retail)
Housing Units – Sale
Required in some cases: when Purpose is RECOMULTI, RECOSINGLE, RERHMULTI or RERHSINGLEFor-sale housing units built, rehabilitated or acquired. 0 if none.
- Housing Units – Sale is required when Purpose is RECOMULTI, RECOSINGLE, RERHMULTI or RERHSINGLE.Full-length TLR guide, May 2026, p. 36 (Housing Units – Sale)
- Housing Units – Sale must be a number.Full-length TLR guide, May 2026, p. 36 (Housing Units – Sale)
- Housing Units – Sale must be equal to or greater than 0 when Purpose is RECOMULTI, RECOSINGLE, RERHMULTI or RERHSINGLE.Full-length TLR guide, May 2026, p. 36 (Housing Units – Sale)
Housing Units – Rental
Required in some cases: when Purpose is RECOMULTI, RECOSINGLE, RERHMULTI or RERHSINGLERental housing units built, rehabilitated or acquired. 0 if none.
- Housing Units – Rental is required when Purpose is RECOMULTI, RECOSINGLE, RERHMULTI or RERHSINGLE.Full-length TLR guide, May 2026, p. 36 (Housing Units – Rental)
- Housing Units – Rental must be a number.Full-length TLR guide, May 2026, p. 36 (Housing Units – Rental)
- Housing Units – Rental must be equal to or greater than 0 when Purpose is RECOMULTI, RECOSINGLE, RERHMULTI or RERHSINGLE.Full-length TLR guide, May 2026, p. 36 (Housing Units – Rental)
Affordable Housing Units – Sale
Required in some cases: when Purpose is RECOMULTI, RECOSINGLE, RERHMULTI or RERHSINGLEOf the for-sale units, how many are affordable. 0 if none.
- Affordable Housing Units – Sale is required when Purpose is RECOMULTI, RECOSINGLE, RERHMULTI or RERHSINGLE.Full-length TLR guide, May 2026, p. 36 (Affordable Housing Units – Sale)
- Affordable Housing Units – Sale must be a number.Full-length TLR guide, May 2026, p. 36 (Affordable Housing Units – Sale)
- Affordable Housing Units – Sale must be equal to or greater than 0 when Purpose is RECOMULTI, RECOSINGLE, RERHMULTI or RERHSINGLE.Full-length TLR guide, May 2026, p. 36 (Affordable Housing Units – Sale)
- Affordable Housing Units – Sale must be equal to or less than Housing Units – Sale when Purpose is RECOMULTI, RECOSINGLE, RERHMULTI or RERHSINGLE.Full-length TLR guide, May 2026, p. 36 (Affordable Housing Units – Sale)
Affordable Housing Units – Rental
Required in some cases: when Purpose is RECOMULTI, RECOSINGLE, RERHMULTI or RERHSINGLEOf the rental units, how many are affordable. 0 if none.
- Affordable Housing Units – Rental is required when Purpose is RECOMULTI, RECOSINGLE, RERHMULTI or RERHSINGLE.Full-length TLR guide, May 2026, p. 37 (Affordable Housing Units – Rental)
- Affordable Housing Units – Rental must be a number.Full-length TLR guide, May 2026, p. 37 (Affordable Housing Units – Rental)
- Affordable Housing Units – Rental must be equal to or greater than 0 when Purpose is RECOMULTI, RECOSINGLE, RERHMULTI or RERHSINGLE.Full-length TLR guide, May 2026, p. 37 (Affordable Housing Units – Rental)
- Affordable Housing Units – Rental must be equal to or less than Housing Units – Rental when Purpose is RECOMULTI, RECOSINGLE, RERHMULTI or RERHSINGLE.Full-length TLR guide, May 2026, p. 37 (Affordable Housing Units – Rental)
Other Impact (1)-Explain
OptionalAnother measured, quantitative impact, up to 150 characters.
- Other Impact (1)-Explain can be at most 150 characters long.Full-length TLR guide, May 2026, p. 37 (Other Impact (1)-Explain)
Other Impact (1)-Number of Units
Required in some cases: when Other Impact (1)-Explain is filled inThe number of units of that impact in the reporting period.
- Other Impact (1)-Number of Units is required when Other Impact (1)-Explain is filled in.Full-length TLR guide, May 2026, p. 37 (Other Impact (1)-Number of Units)
- Other Impact (1)-Number of Units must be a number.Full-length TLR guide, May 2026, p. 37 (Other Impact (1)-Number of Units)
- Other Impact (1)-Number of Units must be equal to or greater than 0 when Other Impact (1)-Explain is filled in.Full-length TLR guide, May 2026, p. 37 (Other Impact (1)-Number of Units)
Other Impact (2)-Explain
OptionalA second measured, quantitative impact, up to 150 characters.
- Other Impact (2)-Explain can be at most 150 characters long.Full-length TLR guide, May 2026, pp. 37-38 (Other Impact (2)-Explain)
Other Impact (2)-Number of Units
Required in some cases: when Other Impact (2)-Explain is filled inThe number of units of that impact in the reporting period.
- Other Impact (2)-Number of Units is required when Other Impact (2)-Explain is filled in.Full-length TLR guide, May 2026, p. 38 (Other Impact (2)-Number of Units)
- Other Impact (2)-Number of Units must be a number.Full-length TLR guide, May 2026, p. 38 (Other Impact (2)-Number of Units)
- Other Impact (2)-Number of Units must be equal to or greater than 0 when Other Impact (2)-Explain is filled in.Full-length TLR guide, May 2026, p. 38 (Other Impact (2)-Number of Units)
Healthy Food Financing Initiative (12)
Year of HFFI Award
Required in some cases: when FA Program Type is HFFI-FAFor HFFI-FA loans: the fiscal year of the HFFI-FA award used.
- Year of HFFI Award is required when FA Program Type is HFFI-FA.Full-length TLR guide, May 2026, p. 39 (Year of HFFI Award)
- Year of HFFI Award must be a four-digit year.Full-length TLR guide, May 2026, p. 39 (Year of HFFI Award)
HFFI-FA Activity
Required in some cases: when FA Program Type is HFFI-FAFor HFFI-FA loans: retail or non-retail.
Values: RETAIL, NONRETAIL
- HFFI-FA Activity is required when FA Program Type is HFFI-FA.Full-length TLR guide, May 2026, p. 40 (HFFI-FA Activity)
- Use a value from the CDFI Fund list: RETAIL or NONRETAIL.Full-length TLR guide, May 2026, p. 40 (HFFI-FA Activity)
Healthy Food Outlet Activity
Required in some cases: when FA Program Type is HFFI-FAFor HFFI-FA loans: the type of healthy food activity.
Values: GROCERYSTORE, MOBILEFOODMKT, FARMERSMKT, COOPERATIVE, CORNERSTORE, BODEGA, PRODUCTION, DISTRIBUTION, SALE, CONSUMPTION, OTHER, NA
- Healthy Food Outlet Activity is required when FA Program Type is HFFI-FA.Full-length TLR guide, May 2026, pp. 40-41 (Healthy Food Outlet Activity)
- Use a value from the CDFI Fund list: GROCERYSTORE, MOBILEFOODMKT, FARMERSMKT, COOPERATIVE, CORNERSTORE, BODEGA, PRODUCTION, DISTRIBUTION, SALE, CONSUMPTION, OTHER or NA.Full-length TLR guide, May 2026, pp. 40-41 (Healthy Food Outlet Activity)
- Healthy Food Outlet Activity cannot be PRODUCTION, DISTRIBUTION, SALE or CONSUMPTION when HFFI-FA Activity is RETAIL.Full-length TLR guide, May 2026, pp. 40-41 (Healthy Food Outlet Activity)
- Healthy Food Outlet Activity cannot be GROCERYSTORE, MOBILEFOODMKT, FARMERSMKT, COOPERATIVE, CORNERSTORE, BODEGA or OTHER when HFFI-FA Activity is NONRETAIL.Full-length TLR guide, May 2026, pp. 40-41 (Healthy Food Outlet Activity)
Healthy Food Outlet Activity – Other
Required in some cases: when Healthy Food Outlet Activity is OTHERWhen the outlet activity is OTHER: what it is.
- Healthy Food Outlet Activity – Other is required when Healthy Food Outlet Activity is OTHER.Full-length TLR guide, May 2026, p. 41 (Healthy Food Outlet Activity – Other)
Food Desert Identifier Source
Required in some cases: when FA Program Type is HFFI-FAFor HFFI-FA loans: the method used to identify the food desert.
Values: ERS, TRF, OTHER
- Food Desert Identifier Source is required when FA Program Type is HFFI-FA.Full-length TLR guide, May 2026, p. 41 (Food Desert Identifier Source)
- Use a value from the CDFI Fund list: ERS, TRF or OTHER.Full-length TLR guide, May 2026, p. 41 (Food Desert Identifier Source)
Food Desert Identifier Source – Other
Required in some cases: when Food Desert Identifier Source is OTHERWhen the source is OTHER: what it is.
- Food Desert Identifier Source – Other is required when Food Desert Identifier Source is OTHER.Full-length TLR guide, May 2026, p. 42 (Food Desert Identifier Source – Other)
Healthy Foods Project Description
Required in some cases: when FA Program Type is HFFI-FAFor HFFI-FA loans: a description of the HFFI activity.
- Healthy Foods Project Description is required when FA Program Type is HFFI-FA.Full-length TLR guide, May 2026, p. 42 (Healthy Foods Project Description)
Total Number of New Retail Healthy Food Outlets
Required in some cases: when FA Program Type is HFFI-FA, and HFFI-FA Activity is RETAILFor HFFI-FA retail loans: distinct new retail outlets.
- Total Number of New Retail Healthy Food Outlets is required when FA Program Type is HFFI-FA, and HFFI-FA Activity is RETAIL.Full-length TLR guide, May 2026, p. 42 (Total Number of New Retail Healthy Food Outlets)
- Total Number of New Retail Healthy Food Outlets must be a number.Full-length TLR guide, May 2026, p. 42 (Total Number of New Retail Healthy Food Outlets)
Total Number of New Non-Retail Healthy Food Lending Activities
Required in some cases: when FA Program Type is HFFI-FA, and HFFI-FA Activity is NONRETAILFor HFFI-FA non-retail loans: distinct new non-retail activities.
- Total Number of New Non-Retail Healthy Food Lending Activities is required when FA Program Type is HFFI-FA, and HFFI-FA Activity is NONRETAIL.Full-length TLR guide, May 2026, p. 43 (Total Number of New Non-Retail Healthy Food Lending Activities)
- Total Number of New Non-Retail Healthy Food Lending Activities must be a number.Full-length TLR guide, May 2026, p. 43 (Total Number of New Non-Retail Healthy Food Lending Activities)
Square Footage of New Retail Healthy Food Outlets
Required in some cases: when FA Program Type is HFFI-FA, and HFFI-FA Activity is RETAILFor HFFI-FA retail loans: square footage of new retail outlets.
- Square Footage of New Retail Healthy Food Outlets is required when FA Program Type is HFFI-FA, and HFFI-FA Activity is RETAIL.Full-length TLR guide, May 2026, p. 43 (Square Footage of New Retail Healthy Food Outlets)
- Square Footage of New Retail Healthy Food Outlets must be a number.Full-length TLR guide, May 2026, p. 43 (Square Footage of New Retail Healthy Food Outlets)
Square Footage of New Non-Retail Healthy Food Outlets
Required in some cases: when FA Program Type is HFFI-FA, and HFFI-FA Activity is NONRETAILFor HFFI-FA non-retail loans: square footage of new non-retail outlets.
- Square Footage of New Non-Retail Healthy Food Outlets is required when FA Program Type is HFFI-FA, and HFFI-FA Activity is NONRETAIL.Full-length TLR guide, May 2026, p. 43 (Square Footage of New Non-Retail Healthy Food Outlets)
- Square Footage of New Non-Retail Healthy Food Outlets must be a number.Full-length TLR guide, May 2026, p. 43 (Square Footage of New Non-Retail Healthy Food Outlets)
Target Market
Required in some cases: when FA Program Type is HFFI-FAFor HFFI-FA loans: how the location was found to be in the Target Market.
Values: INVESTMENT AREAS, TARGETED POP, NA
- Target Market is required when FA Program Type is HFFI-FA.Full-length TLR guide, May 2026, pp. 43-44 (Target Market)
- Use a value from the CDFI Fund list: INVESTMENT AREAS, TARGETED POP or NA.Full-length TLR guide, May 2026, pp. 43-44 (Target Market)
Equitable Recovery Program (13)
ERP Small Business
Required in some cases: when FA Program Type is ERP, and Purpose is BUSINESS or MICROFor ERP business and micro loans: whether it finances a small business or small farm by ERP’s definitions.
Values: YesSB100K, YesSB, YesSF, No
- ERP Small Business is required when FA Program Type is ERP, and Purpose is BUSINESS or MICRO.Full-length TLR guide, May 2026, p. 45 (ERP Small Business)
- Use a value from the CDFI Fund list: YesSB100K, YesSB, YesSF or No.Full-length TLR guide, May 2026, p. 45 (ERP Small Business)
ERP Impact (Employment)
OptionalCheck with HenryFor ERP loans: YES if the loan helps respond to the economic impact of COVID-19 on job loss; otherwise blank.
Values: YES
- Enter YES, or leave ERP Impact (Employment) blank.Full-length TLR guide, May 2026, p. 45 (ERP Impact (Employment))
Check with Henry: the guide marks each ERP impact "Mandatory Field if FA Program Type = ERP" but also says "If not, leave blank" and "Response must be YES or null". The tool checks that each is YES or blank, and that ERP Impact (N/A) is YES when no other impact is.
ERP Impact (Healthcare)
OptionalCheck with HenryFor ERP loans: YES if the loan helps respond to the economic impact of COVID-19 on disruptions in health and mental healthcare; otherwise blank.
Values: YES
- Enter YES, or leave ERP Impact (Healthcare) blank.Full-length TLR guide, May 2026, p. 46 (ERP Impact (Healthcare))
Check with Henry: the guide marks each ERP impact "Mandatory Field if FA Program Type = ERP" but also says "If not, leave blank" and "Response must be YES or null". The tool checks that each is YES or blank, and that ERP Impact (N/A) is YES when no other impact is.
ERP Impact (Childcare)
OptionalCheck with HenryFor ERP loans: YES if the loan helps respond to the economic impact of COVID-19 on disruptions in childcare; otherwise blank.
Values: YES
- Enter YES, or leave ERP Impact (Childcare) blank.Full-length TLR guide, May 2026, p. 46 (ERP Impact (Childcare))
Check with Henry: the guide marks each ERP impact "Mandatory Field if FA Program Type = ERP" but also says "If not, leave blank" and "Response must be YES or null". The tool checks that each is YES or blank, and that ERP Impact (N/A) is YES when no other impact is.
ERP Impact (Housing Stability)
OptionalCheck with HenryFor ERP loans: YES if the loan helps respond to the economic impact of COVID-19 on increased housing instability; otherwise blank.
Values: YES
- Enter YES, or leave ERP Impact (Housing Stability) blank.Full-length TLR guide, May 2026, p. 46 (ERP Impact (Housing Stability))
Check with Henry: the guide marks each ERP impact "Mandatory Field if FA Program Type = ERP" but also says "If not, leave blank" and "Response must be YES or null". The tool checks that each is YES or blank, and that ERP Impact (N/A) is YES when no other impact is.
ERP Impact (Affordable Housing)
OptionalCheck with HenryFor ERP loans: YES if the loan helps respond to the economic impact of COVID-19 on the availability and cost of financing for affordable housing; otherwise blank.
Values: YES
- Enter YES, or leave ERP Impact (Affordable Housing) blank.Full-length TLR guide, May 2026, pp. 46-47 (ERP Impact (Affordable Housing))
Check with Henry: the guide marks each ERP impact "Mandatory Field if FA Program Type = ERP" but also says "If not, leave blank" and "Response must be YES or null". The tool checks that each is YES or blank, and that ERP Impact (N/A) is YES when no other impact is.
ERP Impact (Affordable Ownership)
OptionalCheck with HenryFor ERP loans: YES if the loan helps respond to the economic impact of COVID-19 on the availability and cost of financing for home ownership; otherwise blank.
Values: YES
- Enter YES, or leave ERP Impact (Affordable Ownership) blank.Full-length TLR guide, May 2026, p. 47 (ERP Impact (Affordable Ownership))
Check with Henry: the guide marks each ERP impact "Mandatory Field if FA Program Type = ERP" but also says "If not, leave blank" and "Response must be YES or null". The tool checks that each is YES or blank, and that ERP Impact (N/A) is YES when no other impact is.
ERP Impact (Broadband)
OptionalCheck with HenryFor ERP loans: YES if the loan helps respond to the economic impact of COVID-19 on access to broadband internet; otherwise blank.
Values: YES
- Enter YES, or leave ERP Impact (Broadband) blank.Full-length TLR guide, May 2026, p. 47 (ERP Impact (Broadband))
Check with Henry: the guide marks each ERP impact "Mandatory Field if FA Program Type = ERP" but also says "If not, leave blank" and "Response must be YES or null". The tool checks that each is YES or blank, and that ERP Impact (N/A) is YES when no other impact is.
ERP Impact (Food Insufficiency)
OptionalCheck with HenryFor ERP loans: YES if the loan helps respond to the economic impact of COVID-19 on food insufficiency; otherwise blank.
Values: YES
- Enter YES, or leave ERP Impact (Food Insufficiency) blank.Full-length TLR guide, May 2026, pp. 47-48 (ERP Impact (Food Insufficiency))
Check with Henry: the guide marks each ERP impact "Mandatory Field if FA Program Type = ERP" but also says "If not, leave blank" and "Response must be YES or null". The tool checks that each is YES or blank, and that ERP Impact (N/A) is YES when no other impact is.
ERP Impact (Business Disruption)
OptionalCheck with HenryFor ERP loans: YES if the loan helps respond to the economic impact of COVID-19 on disruptions in operations for small businesses, small farms and nonprofits; otherwise blank.
Values: YES
- Enter YES, or leave ERP Impact (Business Disruption) blank.Full-length TLR guide, May 2026, p. 48 (ERP Impact (Business Disruption))
Check with Henry: the guide marks each ERP impact "Mandatory Field if FA Program Type = ERP" but also says "If not, leave blank" and "Response must be YES or null". The tool checks that each is YES or blank, and that ERP Impact (N/A) is YES when no other impact is.
ERP Impact (Other)
OptionalCheck with HenryFor ERP loans: YES if the loan helps respond to the economic impact of COVID-19 on an issue area not named in the TLR; otherwise blank.
Values: YES
- Enter YES, or leave ERP Impact (Other) blank.Full-length TLR guide, May 2026, p. 48 (ERP Impact (Other))
Check with Henry: the guide marks each ERP impact "Mandatory Field if FA Program Type = ERP" but also says "If not, leave blank" and "Response must be YES or null". The tool checks that each is YES or blank, and that ERP Impact (N/A) is YES when no other impact is.
ERP Impact (N/A)
Required in some cases: when FA Program Type is ERP, and ERP Impact (Employment) is empty, and ERP Impact (Healthcare) is empty, and ERP Impact (Childcare) is empty, and ERP Impact (Housing Stability) is empty, and ERP Impact (Affordable Housing) is empty, and ERP Impact (Affordable Ownership) is empty, and ERP Impact (Broadband) is empty, and ERP Impact (Food Insufficiency) is empty, and ERP Impact (Business Disruption) is empty, and ERP Impact (Other) is emptyCheck with HenryFor ERP loans: YES if none of the other ERP impacts apply; otherwise blank.
Values: YES
- Enter YES, or leave ERP Impact (N/A) blank.Full-length TLR guide, May 2026, p. 49 (ERP Impact (N/A))
- Enter YES in ERP Impact (N/A) when no other ERP impact is YES.Full-length TLR guide, May 2026, p. 49 (ERP Impact (N/A))
Check with Henry: the guide marks each ERP impact "Mandatory Field if FA Program Type = ERP" but also says "If not, leave blank" and "Response must be YES or null". The tool checks that each is YES or blank, and that ERP Impact (N/A) is YES when no other impact is.
ERP 2010 Census Tract
Required in some cases: when FA Program Type is ERPFor ERP transactions, the project’s 11-digit 2010 census tract FIPS code.
- ERP 2010 Census Tract is required when FA Program Type is ERP.Full-length TLR guide, May 2026, p. 54 (ERP 2010 Census Tract)
- ERP 2010 Census Tract must be an 11-digit code; a 10-digit code needs a leading 0 (Excel drops it, so format the column as text).Full-length TLR guide, May 2026, p. 54 (ERP 2010 Census Tract)
Location (12)
Project Street Address Line
Required in some cases: one of Project Street Address Line, Project Longitude (X-Coordinate) is needed when Investee/Borrower Type is BUS or CDFIThe street number and name of the business or project, for example 357 Bluff Rd. No P.O. boxes.
- Fill in Project Street Address Line or Project Longitude (X-Coordinate) when Investee/Borrower Type is BUS or CDFI.Full-length TLR guide, May 2026, pp. 50-53 (Project Street Address Line; Project Latitude (X-Coordinate))
- Leave Project Street Address Line empty when Project State is PR, AS, GU, MP or VI.Full-length TLR guide, May 2026, p. 50 (Project Street Address Line)
Project Street Address Line 2
OptionalUnit or suite number, if any. Optional.
Project City
Required in some cases: when Investee/Borrower Type is BUS or CDFI, and Project Longitude (X-Coordinate) is empty, and Project Latitude (Y-Coordinate) is empty, and not (Project State is PR, AS, GU, MP or VI)The project’s city.
- Project City is required when Investee/Borrower Type is BUS or CDFI, and Project Longitude (X-Coordinate) is empty, and Project Latitude (Y-Coordinate) is empty, and not (Project State is PR, AS, GU, MP or VI).Full-length TLR guide, May 2026, p. 51 (Project City)
- Leave Project City empty when Project State is PR, AS, GU, MP or VI.Full-length TLR guide, May 2026, p. 51 (Project City)
Project State
Required in some cases: when Investee/Borrower Type is BUS or CDFI, and Project Longitude (X-Coordinate) is empty, and Project Latitude (Y-Coordinate) is emptyThe two-letter state code, or the code of a US territory (PR, AS, GU, MP or VI).
Values: AL, AK, AZ, AR, CA, CO, CT, DE, DC, FL, GA, HI, ID, IL, IN, IA, KS, KY, LA, ME, MD, MA, MI, MN, MS, MO, MT, NE, NV, NH, NJ, NM, NY, NC, ND, OH, OK, OR, PA, RI, SC, SD, TN, TX, UT, VT, VA, WA, WV, WI, WY, PR, AS, GU, MP, VI
- Project State is required when Investee/Borrower Type is BUS or CDFI, and Project Longitude (X-Coordinate) is empty, and Project Latitude (Y-Coordinate) is empty.Full-length TLR guide, May 2026, p. 51 (Project State)
- Use a value from the CDFI Fund list (see the guide for the full list).Full-length TLR guide, May 2026, p. 51 (Project State)
Project Zip Code 5
Required in some cases: when Investee/Borrower Type is BUS or CDFI, and Project Longitude (X-Coordinate) is empty, and Project Latitude (Y-Coordinate) is empty, and not (Project State is PR, AS, GU, MP or VI)The five-digit zip code.
- Project Zip Code 5 is required when Investee/Borrower Type is BUS or CDFI, and Project Longitude (X-Coordinate) is empty, and Project Latitude (Y-Coordinate) is empty, and not (Project State is PR, AS, GU, MP or VI).Full-length TLR guide, May 2026, pp. 51-52 (Project Zip Code 5)
- Project Zip Code 5 must be a five-digit code, for example 22191 or 04106 (keep the leading 0; put the +4 in its own column).Full-length TLR guide, May 2026, pp. 51-52 (Project Zip Code 5)
- Leave Project Zip Code 5 empty when Project State is PR, AS, GU, MP or VI.Full-length TLR guide, May 2026, pp. 51-52 (Project Zip Code 5)
Project Zip Code +4
OptionalThe four-digit zip code extension. Optional.
- Project Zip Code +4 must be a four-digit code.Full-length TLR guide, May 2026, p. 52 (Project Zip Code +4)
Project FIPS Code
Required in some cases: one of Project FIPS Code, Project Street Address Line, Project Longitude (X-Coordinate) is needed when Investee/Borrower Type is INDThe 11-digit 2020 census tract FIPS code. For loans to individuals, the FIPS code can replace the address.
- Fill in Project FIPS Code, Project Street Address Line or Project Longitude (X-Coordinate) when Investee/Borrower Type is IND.Full-length TLR guide, May 2026, pp. 50-53 (CDFI Address TLR Object)
- Project FIPS Code must be an 11-digit code; a 10-digit code needs a leading 0 (Excel drops it, so format the column as text).Full-length TLR guide, May 2026, p. 52 (Project FIPS Code)
Project Longitude (X-Coordinate)
Required in some cases: one of Project Street Address Line, Project Longitude (X-Coordinate) is needed when Investee/Borrower Type is BUS or CDFIThe project’s longitude. The guide labels this field "Project Latitude (X-Coordinate)" but asks for the longitude.
- Project Longitude (X-Coordinate) is required when Project State is PR, AS, GU, MP or VI.Full-length TLR guide, May 2026, p. 50 (CDFI Address TLR Object)
- Project Longitude (X-Coordinate) is required when Project Latitude (Y-Coordinate) is filled in.Full-length TLR guide, May 2026, pp. 52-53 (Project Latitude (X-Coordinate))
- Project Longitude (X-Coordinate) must be a number.Full-length TLR guide, May 2026, pp. 52-53 (Project Latitude (X-Coordinate))
- Project Longitude (X-Coordinate) must be equal to or greater than -180.Full-length TLR guide, May 2026, pp. 52-53 (Project Latitude (X-Coordinate))
- Project Longitude (X-Coordinate) cannot be greater than 180.Full-length TLR guide, May 2026, pp. 52-53 (Project Latitude (X-Coordinate))
Project Latitude (Y-Coordinate)
Required in some cases: when Project Longitude (X-Coordinate) is filled inThe project’s latitude.
- Project Latitude (Y-Coordinate) is required when Project Longitude (X-Coordinate) is filled in.Full-length TLR guide, May 2026, p. 53 (Project Latitude (Y-Coordinate))
- Project Latitude (Y-Coordinate) must be a number.Full-length TLR guide, May 2026, p. 53 (Project Latitude (Y-Coordinate))
- Project Latitude (Y-Coordinate) must be equal to or greater than -90.Full-length TLR guide, May 2026, p. 53 (Project Latitude (Y-Coordinate))
- Project Latitude (Y-Coordinate) cannot be greater than 90.Full-length TLR guide, May 2026, p. 53 (Project Latitude (Y-Coordinate))
Census Vintage Year
RequiredThe census year for the tracts. All CDFIs should select 2020.
Values: 2020, 2010
- Census Vintage Year is a mandatory field.Full-length TLR guide, May 2026, p. 53 (Census Vintage Year)
- Use a value from the CDFI Fund list: 2020 or 2010.Full-length TLR guide, May 2026, p. 53 (Census Vintage Year)
- All CDFIs should select 2020 as the Census Vintage Year.Full-length TLR guide, May 2026, p. 53 (Census Vintage Year)(a check to review, not an error)
International Address
RequiredYes if the borrower or business is outside the United States and its territories. The default is No.
Values: Yes, No
- International Address is a mandatory field.Full-length TLR guide, May 2026, pp. 53-54 (International Address)
- Use a value from the CDFI Fund list: Yes or No.Full-length TLR guide, May 2026, pp. 53-54 (International Address)
Unknown Domestic Address
RequiredYes if the place is in the United States but could not be geocoded. The default is No.
Values: Yes, No
- Unknown Domestic Address is a mandatory field.Full-length TLR guide, May 2026, p. 54 (Unknown Domestic Address)
- Use a value from the CDFI Fund list: Yes or No.Full-length TLR guide, May 2026, p. 54 (Unknown Domestic Address)
Fundingo CDFI Reporting Workspace checks your loan data against the CDFI Fund’s published TLR rules. It gives no legal, compliance, tax or credit advice: it never says whether your CDFI is compliant, meets its Target Market tests or keeps its certification. You submit your TLR in AMIS yourself.