CDFI Program and NMTC Program Annual Report

CDFI Program Awardee and NMTC Allocatee Annual Report

Allocatee TLR Data Point Guidance 2019_1559-0027

CDFI Program and NMTC Program Annual Report

OMB: 1559-0027

⚠️ Notice: This form may be outdated. More recent filings and information on OMB 1559-0027 can be found here:

2023-07-31 - Revision of a currently approved collection

Document [pdf]

Download: pdf | pdf

Community Development Financial Institutions Program
CDFI Program Awardee and NMTC Allocatee Annual Report
OMB Approval Number 1559-0027
PAPERWORK REDUCTION ACT NOTICE
Public reporting burden for this collection of information is estimated to average 60 hours per
response, including the time for reviewing instructions, searching existing data sources,
gathering and maintaining the data needed, and completing and reviewing the collection of
information. An agency may not conduct or sponsor, and a person is not required to respond to, a
collection of information unless it displays a valid OMB control number. The valid OMB control
number for this collection is 1559-0027. Send comments regarding this burden estimate or any
other aspect of this collection of information to the Department of Treasury, CDFI Fund, 1500
Pennsylvania Avenue NW, Washington, DC 20220.

U.S. Department of Treasury
Community Development Financial Institutions Fund

Allocatee (CDE)
Transaction Level Report Data Point
Guidance for
AMIS
August 2019

Table of Contents
Getting Started ....................................................................................................................................................................... 3
Certifying TLRs ...................................................................................................................................................................... 12
Understanding the Data Point Boxes .................................................................................................................................. 14
CDE Transaction Level Report – Data Point Guidance ........................................................................................................ 16
Notes-Investments ............................................................................................................................................................ 16
TLR Projects Tab ................................................................................................................................................................ 40
TLR Address ....................................................................................................................................................................... 77
Loan Source and Disbursements....................................................................................................................................... 84

2 | Page

Getting Started
Transaction Level Reports are now in AMIS. For an overview of the data field changes made review the “CIIS
to AMIS Crosswalk NMTC TLR” guide.
AMIS provides two ways users can create their Transaction Level Report (TLR): 1) Manual entry of your
Transaction Level Report (TLR) through the AMIS User Interface (UI); 2) Upload of multiple TLR records
through either a CSV file template or an XML schema.
Manual Entry
To manually begin your Transaction Level Report (TLR), log into the CDFI Fund’s Awards Management
Information System (AMIS) and click on the TLR Projects tab. Once on the TLR Projects Tab, click the “Create
New TLR Project” button.

Enter the name of your organization in the “Organization” field and click “Next” which will direct you to the
TLR Project detail page where you will fill out the information based on the data points listed in the guide.
Note: you can click the search icon to search the organizations you are associated with if you report for more
than one organization.

3 | Page

Once you have completed and saved your TLR project record, click on the TLR Notes Tab, click the “Create
New TLR Note” button. Fill out the information based on the Data Points listed in the guide.

Once you have finished filling out and saving your TLR Note record, scroll down the page to the Loan Source
related list (located on the TLR Note record). Click the “New Loan Source” button. Fill out the information
based on the Data Points listed in the guide. Further instructions are located on page 82.

Once you have completed and saved your Loan Source record, click on the TLR Projects Tab again, click on the
new record you created and scroll down to the TLR Address related list. Click the “Create New TLR Address”
button. Fill out the information based on the Data Points listed in the guide.

CSV File Upload
To create multiple TLR records at one time, AMIS allows users to upload files to create those TLR records in a CSV file
format. To get started click on the "TLR Import/Export/Certify" tab in the menu bar.
Note: Please use the “General” cell formatting for CSV file uploads.

Use the "Select an Organization" to select the organization that you are creating the TLR records for.

4 | Page

Click the "New_NMTC_TLR_Project.CSV" link to download the template

Open the CSV file
Take a moment to review what each row represents:
Row 1 = Labels (aka fields)
Row 2 = Type of field
Row 3 = Options to choose from when filling out the labels, if applicable
Row 4 = Help Text

Use row 5 and on in the CSV file to fill out your answers for the labels (fields) in row 1.

Use the Help Text on the CSV sheet in row 4 as needed to fill out your data.

After you save the file, back on the AMIS portal, click the "Import New TLR Project" Link.

5 | Page

Click the "Choose File" button and select the CSV file for the TLR Project that you entered data for.
Click the "Upload File" button

Note: It may take several moments for the upload to complete. Once the upload is complete you will be notified via the
"Status" column whether it was 100% successful or if there were validation errors.
If you made any errors while filling out the CSV, you will receive an email with the error records and the errors
themselves. You will also be able to view these files on the AMIS portal itself, click on the links under the "Errors
Column". If you did not make any errors, and the file went through successfully.
Email:

Portal:

6 | Page

If errors were made, open both the error file and error records file. The error file lists the fields that did not pass
validation which caused the file to not be uploaded. The error file will state the “Row”, “Project Number”, “Error”, and
“Fields” to help the user better understand what they need to fix. Below you can see an example:

The error records file will contain the actual records the user tried to upload. This is the file that will need to be edited
for the errors listed in the error file and then re-uploaded. Below you can see an example:

Note: If you receive the following error on the Project Number field “This identifier already exists. To update, please use
a different link” when uploading your TLR file, please contact the AMIS Help Desk at [email protected] for help.

The same process is used for the NMTC TLR Note, NMTC TLR Address, and making updates to the NMTC TLR
Project and NMTC TLR Note. To make updates to the NMTC TLR Project select the “Update NMTC TLR
Project.csv” link, and to make updates to the NMTC TLR Note select the “Update NMTC TLR Note.csv” link. For
updating both Project and Note, the export link will provide a template for the user that contains all existing
TLR Projects or TLR Notes currently in the system for that user’s organization that they are able to make
updates to and will contain the annual update fields they are responsible for updating. Once the user has
made the updates needed, they will re-upload the file. Below are examples of what each update file template
will contain:

NMTC TLR Project:
7 | Page

NMTC TLR Note:

XML File Upload
To create multiple TLR records at one time, AMIS allows users to upload files to create those TLR records in an XML file.
To get started click on the "TLR Import/Export/Certify" tab in the menu bar.

Use the "Select an Organization" to select the organization that you are creating the TLR records for.

Click the "NMTC_TLR_Xml_Schema.xsd" link to download the XML Schema to use when generating an XML file.

8 | Page

Click the “Update_NMTC_TLR_Data.xml” link to download an XML file of current project data already in AMIS to make
updates to. For updating TLR Projects, the export link will provide a template for the user that contains all existing TLR
Projects currently in the system for that user’s organization that they are able to make updates to and will contain the
annual update fields they are responsible for updating.

After you fill out and Save the File, back on the AMIS portal, click the "Import_XML_NMTC_TLR” Link.

Click the "Choose File" button and select the XML file for the TLR Project that you entered data for
Click the "Upload File" button

Note: It may take several moments for the upload to complete. Once the upload is complete you will be notified via the
"Status" column whether it was 100% successful or if there were validation errors.
If you made any errors while filling out the XML, you will receive an email with the error records and the errors
themselves. You will also be able to view these files on the AMIS portal itself, click on the links under the "Errors
Column". If you did not make any errors, and the file went through successfully.

9 | Page

Email:

Portal:

If errors were made, open both the error file and error records file. The error file lists the fields that did not pass
validation which caused the file to not be uploaded. The error file will state the “Type”, “ID Field”, “IDs”, “Error”, and
the “Error Fields” to help the user better understand what needs to be fixed. Below you can see an example:

The error records file will contain the actual records the user tried to upload in the form of an XML file. This is the file
that will need to be edited for the errors listed in the error file and then re-uploaded. Below you can see an example:

10 | Page

Note: If you are having trouble with the XML upload, at the top of the page is a link to “NMTC Import/Export Guidance”
or refer to the “XML Vendor Guide for NMTC & CDFI TLR NACA”.

11 | Page

Certifying TLRs
To ‘Certify’ your TLRs, navigate to the “TLR Import/Export/Certify” tab and select the name of your organization from
the “Select an Organization from the drop-down field and click the “Certify NMTC TLR” button. Adjacent to the “Certify
NMTC TLR” button will be displayed the earliest Fiscal Year available for certification.

Upon clicking the “Certify NMTC TLR” button the user will be directed to the certification statement page and once they
click “Certify NMTC TLR” all TLRs needing certification that pass all validations will be certified.

TLR Certification is due 180 days after the end of an Organization’s Fiscal Year. Once submitted, the TLR records that
have been certified will be locked from any editing, outside of annual updates. The user will still be able to create new
TLR records but will not be able to certify any records until the next fiscal year.
At the beginning of an Organization’s fiscal year, the TLRs that were entered and certified previously will be unlocked, so
the user can update “Annual Update” fields (These are the only fields the user will be able to successfully edit). Once
the user has made the appropriate annual updates to the TLR, they will be able to certify the TLR.
With respect to the job fields for any project, one must enter a response in the job fields (non-real estate, construction
and tenant) either for the projected job fields or the actual fields. Actual jobs can be left blank and filled out at a later
time, however once data is entered, the record is closed. The objective is to provide the best estimate of the actual jobs
once the project is complete and mature (usually in year three or so). However, previously entered actual jobs can be
updated via service request. One can enter "0" for projected jobs. If one doesn’t know the actual jobs yet, best to leave
these fields blank.
Again, once the user certifies the TLR data, all the records will be locked from editing until the next fiscal year.

12 | Page

Object
TLR Project

TLR Note

Loan Source

Annual Update Fields
-Actual Jobs Created (Construction)
-Actual Jobs Created (Financed)
-Actual Jobs Created (Tenant)
-Annual Gross Revenue (Reporting Period)
-Blended Interest Rate
-Comparable Blended Interest Rate
-Amount Charged Off
-Amount Recovered
-Days Delinquent
-Interest Rate
-Loan Status
-Number of 60 Days or More Delinquent
-Number of Times the Loan Restructured
-Original Loan/Investment Amount
-Principle Balance Outstanding
-Term
-QLICI Level
-Active

To check if the users NMTC TLRs are certified or not yet, the user can navigate to the “TLR Projects” tab and select “All”
from the “View:” drop-down field and click “Go!” to see a list of the organizations TLR Projects that displays the “Last
Certified Date” to be able to distinguish which TLR Projects are certified and which have not yet been certified.

Note: Do not certify your TLR until you are ready to submit for the year. If you happen to certify your TLR before you are
ready to, please contact the help desk so that they can assist you in unlocking it.

13 | Page

Understanding the Data Point Boxes
Below is a diagram of how to read and understand the data point boxes listed in the section CDE Transaction
Level Report – Data Point Guidance.
Each data point is color coded according to its related requirements.
Mandatory – A response must be provided or the TLR will not be accepted.
Conditionally Required – This field will become enabled and require an answer based on a response in a
previous field.
Optional – Not required to provide a response although it is recommended.
AMIS System Generated – User response is not allowed.

Example 1:

14 | Page

Example 2:

Who to contact for help
If you are experiencing any difficulties with the data entry portion of your report, including document errors, system
errors, and basic questions, please contact the AMIS Helpdesk. The most effective means of requesting support is
submitting a Service Request. From the AMIS Service Request tab, select the “Create New Service Request” button.
Select “Continue” to accept the default record type of “General Inquiry”. Ensure that “NMTC-AMIS technical problem”
is selected for the Type drop-down field.
Alternatively, the Allocatee may send an email to [email protected]. Please type, “NMTC: TLR Assistance Needed” in
the subject line of the email. A technical support staff person will generally reply within 24 hours on weekdays.
Allocatees may also phone the CDFI Fund IT Help Desk at (202) 653-0422. If a technical support staff person is
unavailable to immediately assist, please leave a message and a staff person will return the call within 36 hours on
weekdays.

15 | Page

CDE Transaction Level Report – Data Point Guidance

Notes-Investments
Note: For the crosswalk guide on the NMTC TLR field level changes from the previous round refer to the “CIIS to AMIS
Crosswalk NMTC TLR”.

Project Number

(Column B)

TLR Project is used to link a Financial Note(s) to a distinct Project and to track Projects across reporting periods. This
field is also used for navigational purposes.
Validations:
x
x

Mandatory Field (Automatically Generated for the user by the system)
This field allows the users to easily navigate back to the associated TLR Project via the “TLR Project”
field hyperlink.
Response must be numeric - up to 8 digits

Originator Transaction ID

(Column C)

Assign a unique identifier to each Financial Note. The Originator Transaction ID is typically a loan number or tracking
number. The Originator Transaction ID is used to track Financial Notes across reporting periods.
Validations:
x
x
x
x

Mandatory Field
Each Originator Transaction ID must be unique to each financial note. Duplicate Originator
Transaction ID’s will cause errors in the file.
Allocatees MUST use the same Originator Transaction ID for each reporting period.
Originator Transaction ID’s can not contain any special characters such as, but not limited to, commas
and exclamation points.
Response must be text - up to 20 characters

Last Certified Date
AMIS will populate this field with the date the TLR object was certified.
Validations:
x

This field will only populate when the user has certified the TLR object
Format of mm/dd/yyyy

16 | Page

Purpose

(Column D)

Choose one of the pre-defined values below and identify the primary purpose of the financial note. If there are
multiple purposes (for example, a loan funding both the purchase of a fixed asset and a facility improvement), select
the purpose with the largest percent of the transaction.
Validations:

Mandatory Field

Please select one of the following:

BUSINESS

Non-Real Estate Business: Financing to for-profit and nonprofit businesses with more
than five employees or in an amount greater than $50,000 for a purpose that is not
connected to the development (including construction of new facilities and
rehabilitation/enhancement of existing facilities), management, or leasing of real
estate.

MICRO

Non- Real Estate Microenterprise: Financing to a for-profit or non-profit enterprise
that has five or fewer employees (including the proprietor) with an amount no more
than $50,000 for a purpose that is not connected to the development (including
construction of new facilities and rehabilitation/enhancement of existing facilities),
management, or leasing of real estate.

RECOCOM

Real Estate – Construction/Permanent/Acquisition w/o Rehab – Commercial:
Financial Note is for predevelopment financing, construction or permanent financing,
or acquisition without rehabilitation of office, retail, manufacturing, or community
facility space. Include mixed-use real estate that combines both commercial and
residential use.

RECOMULTI

Real Estate – Construction–Housing-Multi Family: Financial Notes is for
predevelopment financing, or construction of multifamily housing.

RECOSINGLE

Real Estate – Construction–Housing-Single Family: Financial Note is for
predevelopment financing, or construction of single family housing.

RERHCOM

Real Estate–Rehabilitation–Commercial: Financing is to rehabilitate office, retail,
manufacturing, or community facility space. Financial Note may include acquisition
costs. Include mixed-use real estate that combines both commercial and residential
uses. Exclude acquisitions without rehabilitation.

RERHMULTI

Real Estate – Rehabilitation – Housing – Multi Family: Financing is to rehabilitate or
acquire single family housing.

RERHSINGLE

Real Estate – Rehabilitation – Housing – Single Family: Financing is to rehabilitate or
acquire single family housing.

OTHER

Other: Financial note purpose does not match any of the purposes defined above.

17 | Page

Transaction Type

(Column E)

Report the type of transaction for the financial note by choosing one of the options below.
Validations:
x

Mandatory field

Please select one of the following:
TERM
EQTYINV
LOC
DEBTEQTY
OTHER

Term Loan
Equity Investment
Line of Credit
Debt with Equity
Other

Loan Status

(Column F)

Annual Update Required
Report the status of the loan/investment amount at the reporting period end.
Validations:
x

Mandatory Field

Please select one of the following:
ACTIVE
ACTIVEEND
CLOSED
SOLD
CHARGEDOFF
REFIN
RESTRUCT

Active – the financial note was open, on-the-books, and/or had some sort of activity
during the reporting year.
Active but the financial note has reached the end of its seven-year compliance
reporting period.
Closed in good standing – a loan or line of credit that is paid in full (not refinanced) or
an equity investment that has been exited.
Sold – the financial note is off-the-books but not paid in full.
Charged off - the financial note is off-the-books but not paid in full.
Refinanced - the financial note has been paid in full and the remaining principal
amount has been refinanced by another lender.
Restructured with charge off.

18 | Page

Date Originated

(Column G)

Report the date that a legally binding note has been signed by the borrower/investee in favor of the lender/investor.
Validations:
x
x
x

Mandatory Field
Date Originated must be prior to the current date.
See the Date Formatting section for more information
Response must in the format of mm/dd/yyyy

Date Formatting
Common Question: I have uploaded my file but it says that I have not provided a response for this date column/date
column is in the incorrect format. I see my date entered, how do I fix it?
The most common fix is to make sure the date column is formatted correctly. When entering an answer into a cell that
requires a date, make sure to format the cell as below. This can be done by right clicking on the cell(s). Although it may
not fully appear as if it is in the correct format (March 3, 2014 will appear as 3/3/2014 as opposed to 03/3/2014), rest
assured, this is correct.

19 | Page

Original Loan/Investment Amount

(Column H)

Annual Update Required
Report the amount of the loan/investment.
Validations:
x
x

Mandatory Field
Original Loan/Investment Amount cannot be greater than $50,000 if Purpose = MICRO
Response must be in numeric format

Refinancing

(Column I)

Report whether the loan/investment is a new origination or a refinance of an existing loan/investment with QEI funds.
Validations:
x

Mandatory Field

Please select one of the following:
NEWORIGINATION

New Origination

REFINANCEALLOC

Refinance of Allocatee (or Affiliate) Loan/Investment

REFINANCEUNAFF

Refinance of Un-Affiliated Third-Party Loan/Investment

Construction or Permanent Financing

(Column J)

Report whether the loan/investment is for construction or permanent financing.
Validations:
x

Conditionally Required if Purpose = RECOCOM

Please select one of the following:
CONSTRUCTION
PERMANENT
BOTH

Construction
Permanent
Both construction and permanent

20 | Page

Take-out or Acquisition Financing

(Column K)

Report whether the loan/investment is for take-out or acquisition financing.
Validations:
x

Conditionally Required if Construction or Permanent Financing = PERMANENT or BOTH

Please select one of the following:
TAKEOUT
ACQUISITION

Take-out financing
Acquisition without rehabilitation

Acquisition or Rehabilitation

(Column L)

Report whether the loan/investment includes financing for the acquisition of the property.
Validations:
x

Conditionally Required if Purpose = RERHCO

Please select one of the following:
ACQUISITIONREHAB
REHABILITATION

Acquisition and rehabilitation
Rehabilitation only

Rehabilitation Amount

(Column M)

Report the portion of the Original Loan/Investment Amount that was used for the rehabilitation.
Validations:
x
x
x

Conditionally Required if Acquisition or Rehabilitation = AQUISITIONTREHAB
Response must be in dollars greater than zero
Exclude leveraged dollars.
Response must be in numeric format

21 | Page

Loan Origination Fees

(Column N)

Report the total loan origination fees, including processing, credit report, and other fees.
Validations:
x
x
x

Conditionally Required if Transaction Type = Term Loan, Line of Credit, or Debt with Equity Loan
Origination Fees should not be greater than 15% of the Original Loan/Investment Amount
Loan Origination Fees must be less than Original Loan/Investment Amount
Exclude points
Response must be in numeric format up to 2 decimal places

Interest Rate at Origination

(Column O)

Report the interest rate in effect at origination of the loan.
Validations:
x
x

Conditionally Required if Transaction Type = Term Loan, Line of Credit, or Debt with Equity
Enter the percentage as a whole number (i.e. if the Interest Rate at Origination is 2.0%, enter 2.0
Response must be in numeric format up to 3 decimal places

Interest Rate

(Column P)

Annual Update Required
Report the interest rate in effect at the reporting period end. If the financial note was paid off during the reporting
period, report the interest rate at the time of the pay off.
Validations:
x
x

22 | Page

Interest Type

(Column Q)

Choose one of the pre-defined values below and report the type of interest.
Validations:
x

Conditionally Required if Transaction Type = Term Loan, Line of Credit, or Debt with Equity

Please select one of the following:
FIXED
ADJ

Fixed
Adjustable

Points

(Column R)

Report the points charged to the borrower at origination.
Validations:
x
x
x

Conditionally Required if Transaction Type = Term Loan or Debt with Equity
Report the points as a percentage of the original loan amount
Include points for the particular financial note reported
Response must be in numeric format up to 3 decimal places

Amortization Type

(Column S)

Choose one of the pre-defined values below and report how the financial note is amortized.
Validations:
x

Conditionally Required if Transaction Type = Term Loan, Line of Credit, or Debt with Equity

Please select one of the following:
FULLAMORT

Fully Amortized – Amortization schedule includes both interest and principal
payments throughout the life of the loan.

PARTAMORT

Partially Amortized – Amortization schedule includes some principal payments
throughout the life of the loan, with a larger principal payment at maturity.

NONAMORT

Non-Amortizing – Amortization schedule includes interest only payments with a
single principal payment at maturity.

OTHER

Other

23 | Page

Length of Amortization Period (in months)

(Column T)

Report the length of the amortization period.
Validations:
x
x

Conditionally Required if Amortization Type = FULLAMORT or PARTAMORT
Report the Length of Amortization Period in months
Response must be in numeric format

Period of Interest Only Payments (in months)

(Column U)

Report the number of interest only payments at the time of origination.
Validations:
x
x
x

Conditionally Required if Transaction Type = Term Loan
Report the Period of Interest Only Payments in months
Period of Interest Only Payments must be less than the amount reported as the Term
Response must be in numeric format

Term (in months)

(Column V)

Annual Update Required
For each loan and line of credit, report the full term in months. Report the full term, not the remaining term.
Validations:
x

Conditionally Required if Transaction Type = Term Loan, Line of Credit, or Debt with Equity
Response must be in numeric format

24 | Page

Guarantee

(Column W)

If any portion of the loan is guaranteed, choose one of the pre-defined values below and report the source.
Validations:
x
x

Conditionally Required if Transaction Type = Term Loan, Line of Credit, or Debt with Equity
Exclude performance guarantees

Please select one of the following:
SBA

Small Business Administration (SBA)

USDA

US Department of Agriculture (USDA)

OTHERGOV

Other Federal Government Source

PERSONAL

Personal Guarantee

OTHER

Other

NONE

None

Lien Position

(Column X)

Choose one of the pre-defined values below and report the CDE’s lien position.
Validations:
x

Conditionally Required if Transaction Type = Term Loan, Line of Credit, or Debt with Equity

Please select one of the following:
FIRST
SECOND
UNSECURED
OTHER

First
Second
Unsecured Debt
Other

25 | Page

Collateral Type

(Column Y)

Choose one of the pre-defined values below and report the type of collateral pledged for the loan/investment.
Validations:
x

Conditionally Required if Transaction Type = Term Loan, Line of Credit, or Debt with Equity

Please select one of the following:
RE

Real Estate

REOTHER
VEH

Other Real Estate
Vehicle

EQUIP

Equipment

INVENTORY

Inventory

REC

Receivables

HOMEEQTY

Home Equity

OTHER

Other

NONE

None

Collateral Value at Origination

(Column Z)

Estimate and report the fair value of the collateral at the time of origination.
Validations:
x

Conditionally Required if Transaction Type = Term Loan, Line of Credit, or Debt with Equity
Response must be in numeric format

26 | Page

Equity-Like Features

(Column AA)

Choose one of the pre-defined values below and report the type of equity-like feature.
Validations:
x
x

Conditionally Required if Transaction Type = Debt with Equity
If a loan has more than one equity-like feature, choose the one appearing first in the loan agreement

Please select one of the following:
CONVDEBT
PERFINT

Convertible Debt – Loan agreement specifies an option to convert all or part of the
loan amount to equity
Performance Based Interest Rate – Loan’s interest rate adjusts based on the
borrower’s performance.

ROYALTIES

Royalties – Loan has a royalty participation that gives the investor the right to a
percentage of the borrower’s sales or profits.

WARRANTS

Warrants – Loan agreement gives the investor the right to purchase the portfolio
company’s stock at a later date at a pre-negotiated price.

OTHER

Other – Loan Agreement specifies an equity-like feature not described above.

Equity Injection Amount

(Column AB)

Equity injection is an underwriting mechanism used to help borrowers who lack collateral to qualify for a loan. The
equity injection measures the amount of the borrower's own assets invested in the business. Report the equity
injection amount provided by the investee/borrower (i.e. Down payment for a purchase mortgage or the value of
machinery the borrower purchased for the financed project).
Validations:
x Optional field
x Include both cash and non-cash injections
Response must be in numeric format

Advanced Purchase Commitment

(Column AC)

Report whether the loan/investment is an advance purchase commitment.
Validations:
x

Conditionally Required if QLICI Type = QALICB
Response must be YES or NO

27 | Page

Seller Organization

(Column AD)

Report the seller organization.
Validations:
xConditionally Required if Advance Purchase Commitment = YES
Response must be text

Equity Product

(Column AE)

Compliance Check

Report whether the financial note is an equity product.
Validations:
x
x

Mandatory field
Reject if Equity Product = YES & Transaction Type = Term Loan, Line of Credit, Debt with Equity or
Other
Response must be YES or NO

Equity-Equivalent Terms & Conditions

(Column AF)

Compliance Check

Report whether the financial note has equity-equivalent terms and conditions.
Validations:
x

Mandatory field
Response must be YES or NO

28 | Page

Debt with Equity Features

(Column AG)

Compliance Check

Report whether the financial note has debt with equity features.
Validations:
x
x

Mandatory field
Reject if Debt with Equity Features = YES & Transaction Type = Term Loan, Equity, Line of Credit or
Other
Response must be YES or NO

Subordinated Debt

(Column AH)

Compliance Check

Report whether the financial note is subordinated debt.
Validations:
x
x

Mandatory field
If Lien Position = FIRST then Subordinated Debt must = NO
Response must be YES or NO

Below Market Interest Rate at Origination

(Column AI)

Compliance Check

Report whether the financial note had below market interest rate at origination.
Validations:
x
x

Mandatory field
Reject if Below Market Interest Rate at Origination = YES AND Interest Rate at Origination >=
Comparable Interest Rate at Origination
Response must be YES, NO, or NA

29 | Page

Comparable Interest Rate at Origination

(Column AJ)

Report the comparable market interest rate at origination that the Allocatee used to determine that the financial note
had a below market interest rate.
Validations:
x
x
x

Conditionally required if Below Market Interest Rate at Origination = YES
Comparable Interest Rate at Origination must be greater than Interest Rate at Origination
Enter the percentage as a whole number (i.e. if the Comparable Interest Rate at Origination is 2.0%,
enter 2.0)
Response must be in numeric format up to 3 decimal places

Below Market Interest Rates or Flexible Terms Required under
Allocation Agreement (Financial Note)
Below Market Rates or Flexible Terms
(Column AK)

Compliance Check

Below Market Interest Rates or Flexible Terms required under Allocation Agreement (Financial Note). Report whether
the financial note was required to have a below market interest rate at origination.
Validations:
x

Mandatory field
Response must be YES, NO, or NA

Below Market Interest Rate (Financial Note)

(Column AL)

Below Market Interest Rate
Compliance Check

Below Market Interest Rate (Financial Note). Report whether the financial note had a below market interest rate at
the end of the reporting period.
Validations:
x
x

Mandatory field
If Transaction Type = Term Loan, Line of Credit, or Debt with Equity then Below Market Interest Rate
must = YES or NO
Response must be YES, NO, or NA

30 | Page

What is Interest Rate Comparable?

(Column AM)

Choose one of the pre-defined values below and report the interest rate comparable at the end of the reporting
period.
Validations:
x

Conditionally Required if Below Market Interest Rate (Financial Note) = YES

Please select one of the following:
NONNMTC

CDE’s Non-NMTC Transaction

PARENT

CDE’s Parent/Affiliate

BANKS

Banks

OTHER

Other

Interest Rate Comparable – Other

(Column AN)

Provide further explanation for what the interest rate is comparable to.
Validations:
x Conditionally Required if What is Interest Rate Comparable = OTHER
Response must be text

Lower than Standard Origination Fees (Financial Note) (Column AO)
Lower than Standard Origination Fees
Compliance Check

Report whether the financial note has lower than standard origination fees.
Validations:
x

Mandatory field
Response must be YES or NO

31 | Page

Standard Origination Fees

(Column AP)

Report the comparable market origination fees that the Allocatee used as a benchmark to determine that the financial
note has lower than standard origination fees.
Validations:
x
x
x
x

Conditionally required if Lower than Standard Origination Fees (Financial Note) = YES
Value should be entered in dollars and must not be between 0 and 15
Standard Origination Fees should not be greater than 15% of the Original Loan Amount
Standard Origination Fees must be greater than Loan Origination Fees
Response must be numeric

Longer than Standard Period of Interest Only Payments

(Column AQ)

Compliance Check

Report whether the financial note has longer than standard period of interest only payments.
Validations:
x
x

Mandatory field
If Transaction Type = Term Loan, Line of Credit, or Debt with Equity or Other then Longer than
Standard Period of Interest Only Payments must = YES or NO
Response must be YES, NO, or NA

Standard Period of Interest Only Payments

(Column AR)

Report the comparable market period of interest only payments. Provide the benchmark period, in months, that the
Allocatee used to determine that the financial note has a longer than standard period of interest only payments.
Validations:
x
x
x

Conditionally Required if Longer than Standard Period of Interest Only Payments = YES
Report amount in months
Standard Period of Interest Only Payments must be less than Period of Interest Only Payments
Response must be numeric

32 | Page

Longer than Standard Amortization Period

(Column AS)

Compliance Check

Report whether the financial note has a longer than standard amortization period.
Validations:
x
x

Standard Amortization Period

(Column AT)

Report the comparable market amortization period. Provide the benchmark period, in months, that the Allocatee
used to determine that the financial note has a longer than standard amortization period.
Validations:
x
x
x

Conditionally Required if Longer than Standard Amortization Period = YES
Report amount in months
Standard Amortization Period must be less than Length of Amortization Period
Response must be numeric

What is Standard Amortization Period Comparable?

(Column AU)

Standard Amortization Period Comparable?
Choose one of the pre-defined values below and report the standard amortization period comparable.
Validations:
x

Conditionally Required if Longer than Standard Amortization Period = YES

Please select one of the following:
NONNMTC

CDE’s Non-NMTC Transaction

PARENT

CDE’s Parent/Affiliate

BANKS

Banks

OTHER

Other

33 | Page

Standard Amortization Period Comparable – Other

(Column AV)

Provide further explanation for what the standard amortization period is comparable to.
Validations:
x Conditionally required if What is Standard Amortization Period Comparable? = OTHER
Response must be text

Nontraditional Forms of Collateral

(Column AW)

Compliance Check

Report whether the financial note has a nontraditional form of collateral.
Validations:
x

Mandatory field
Response must be YES or NO

Traditional Form of Collateral

(Column AX)

Choose one of the pre-defined values below and report the comparable market form of collateral that the Allocatee
used as a benchmark to determine that the financial note has a nontraditional form of collateral.
Validations:
x

Conditionally Required if Nontraditional Forms of Collateral = YES

Please select one of the following:
RE
REOTHER
VEH

Real Estate
Other Real Estate
Vehicle

EQUIP

Equipment

INVENTORY

Inventory

REC

Receivables

HOMEEQTY

Home Equity

OTHER

Other

NONE

None

34 | Page

What is Traditional Forms of Collateral Comparable?

(Column AY)

Traditional Collateral Comparable?
Choose one of the pre-defined values below and report the traditional form of collateral comparable.
Validations:
x

Conditionally Required if Nontraditional Forms of Collateral = YES

Please select one of the following:
NONNMTC

CDE’s Non-NMTC Transaction

PARENT

CDE’s Parent/Affiliate

BANKS

Banks

OTHER

Other

Traditional Form of Collateral Comparable – Other

(Column AZ)

Traditional Collateral Comparable Other
Provide further explanation for what traditional form of collateral is comparable.
Validations:
x

Conditionally required if What is Traditional Forms of Collateral Comparable? = OTHER
Response must be text

QLICI Level

(Column BA)

Annual Update Required
Compliance Check

Report whether the financial note was funded with original QEI funds (QEI funds invested for the first time), a
reinvestment of repaid QLICI(s), or both by choosing an option below.
Validations:
x

Mandatory Field

Please select one of the following:
ORIG

Original QEI funds

REINVST

Reinvestment or repaid QLICI’s

ORIGREIN

Both

35 | Page

Principal Balance Outstanding

(Column BB)

Annual Update Required
Report the principal balance outstanding at the end of the reporting period.
Validations:
x

Conditionally required if Transaction Type = Term Loan, Line of Credit, or Debt with Equity
Response must be numeric

Dollar Amount Used to Finance Non-Real Estate Activities
NRE Activities Finance Amount

(Column BC)

Report, in dollars, the portion of proceeds of the financial notes provided by the CDE that financed non-real estate
uses. Non-real estate uses include working capital, inventory, equipment, or any other activity not connected to the
development (including construction of new facilities and rehabilitation/enhancement of existing facilities),
acquisition, management, or leasing of real estate.
Validations:
x

Mandatory field
Response must be numeric up to 2 decimal places

New Originator Transaction ID of Restructured Loan

(Column BD)

New Restructured Loan Transaction ID
Report the new Originator Transaction ID for each financial note that was restructured.
Validations:
x
x

Conditionally required if Loan Status = RESTRUCT
Information provided must match a current or previously submitted Originator Transaction ID
Response must be text

36 | Page

Days Delinquent

(Column BE)

Annual Update Required
Report the number of days that the required loan payment is past due at the reporting period end. If a borrower
made a partial payment on the due date but still owes any part of the payment, report that payment as past due.
Validations:
x

Conditionally required if Transaction Type = Term Loan, Line of Credit, Debt with Equity or OTHER
Response must be numeric

Number of Times 60 Days or More Delinquent

(Column BF)

Number of 60 Days or More Delinquent
Annual Update Required
Report the number of times the loan has been 60 days or more delinquent during the life of the loan.
Validations:
x
x

Conditionally required if Transaction Type = Term Loan, Line of Credit, Debt with Equity or OTHER
Number of Times 60 Days or More Delinquent must be equal to or greater than the value reported
the previous year.
Response must be numeric

Number of Times the Loan was Restructured

(Column BG)

Number of Times the Loan Restructured
Annual Update Required
Report the number of times the loan was restructured during the life of the loan.
Validations:
x
x

Conditionally required if Transaction Type = Term Loan, Line of Credit, Debt with Equity or OTHER
Number of Times the Loan was Restructured must be equal to or greater than the value reported the
previous year.
Response must be numeric

37 | Page

Amount Charged Off

(Column BH)

Annual Update Required
Report the amount charged off during the life of the loan.
Validations:
x
x

Conditionally required if Transaction Type = Term Loan, Line of Credit, Debt with Equity or OTHER
Amount Charged Off + Amount Recovered must be less than or equal to Original Loan/Investment
Amount
Response must be numeric

Amount Recovered

(Column BI)

Annual Update Required
Report the amount recovered as of the reporting period end date.
Validations:
x
x

Conditionally required if Transaction Type = Term Loan, Line of Credit, Debt with Equity or OTHER
and Loan Status = ACTIVEEND, CLOSED, SOLD, CHARGEDOF, REFIN, or RESTRUCT.
Amount Recovered must be equal to or greater than the value reported the previous year.
Response must be numeric

Actual Rate of Return

(Column BJ)

Report the investor’s internal rate of return at the end of the initial reporting period.
Validations:
x

Conditionally required if Transaction Type = Equity Investment
Response must be numeric format up to 3 decimals

38 | Page

Projected Residual Value of QLICI that May be Obtained by the
QALICB
Projected Residual Value of QLICI

(Column BK)

Report the amount of any equity or debt investment which may be acquired by the QALICB as the result of a put/call
option or other arrangement.
Validations:
x
x

Conditionally required if QLICI Type = QALICB and Date Originated is > 12/31/2010
When Loan Status = CLOSED, please place the final value of the QLICI obtained by the QALICB through
a put/call option or other arrangement.
Response must be numeric

39 | Page

TLR Projects Tab
Project Number

(Column B)

Assign a unique identifier to each Project.
Validations:
x
x
x

Mandatory field
Report the TLR Project Number
Note: If you receive the following error on the Project Number field “This identifier already exists.
To update, please use a different link” when uploading your TLR file, please contact the AMIS Help
Desk at [email protected] for help.
Response must be numeric

QLICI Type

(Column C)

Compliance Check

Choose one of the pre-defined values below and report whether the QLICI is an investment in another CDE or a
QALICB.
Validations:
x
x
x

Mandatory field
Non-Profit businesses (except CDE’s) and Advanced Purchases = QALICB
Exclude loan purchases (except Advance Purchases), Financial Counseling, and Other Services (FCOS)

Please select one of the following:
CDE
QALICB

CDE
QALICB

40 | Page

Investee Type

(Column D)

Choose one of the pre-defined values below and report whether the project is an investment in a business or another
CDE.
Validations:
x Mandatory field
x If QLICI Type = CDE then Investee Type must = CDE
x If QLICI Type = QALICB then Investee Type must = BUS
Please select one of the following:
BUS

Business

CDE

Multi-CDE Project ID

(Column E)

Multi-CDE Project Number
Report the Multi-CDE Project Number that was assigned to the Multi-CDE Project. Use the lookup function to identify
and report the Multi-CDE Project ID associated with the project.
Validations:
x
x
x
x

Conditionally Required if TLR Project is part of Multi-CDE Project
Additional guidance can be found in the Multi-CDE section of AMIS
Response must be a valid project number generated by AMIS under the Multi-CDE Project section
Use the lookup icon to view a list of Multi-CDE Projects associated with the organization that the TLR
Project can be linked to.
Response must be text

Organization
Report the Organization name associated with the loans/investments reported in the TLR. Use the lookup function to
identify and report the Organization associated with the project.
Validations:
x
x

Mandatory field
The user must be authorized to submit TLR reporting for the Organization in question.
Response must be text

41 | Page

Fiscal Year
Choose one of the pre-defined values. The system will auto-populate the current and previous Fiscal Year of the TLR
Project available.
Validations:
x

Mandatory Field

Last Certified Date
AMIS will populate this field with the date the TLR object was certified.
Validations:
x

This field will only populate when the user has certified the TLR object
format of mm/dd/yyyy

Total Project Cost

(Column F)

Report the total cost of the project being funded.
Validations:
x
x
x

Mandatory Field
Include all sources of financing as well as the CDE’s portion of the financing
Response cannot be less than:
-

Total Project Cost >=Total Project Cost Public Sources
Total Project Cost >=Total Project Cost Private Investment
Total Project Cost >=Total Project Cost Other CDE’s + Original Loan/Investment Amount
Total Project Cost >=Total Project Cost Public Sources + Total Project Cost Other CDE’s +
Original Loan Investment Amount + Total Project Cost Private Investment
Response must be numeric

42 | Page

Total Project Cost Public Sources

(Column G)

Report the portion of the Total Project Cost provided by public sources.
Validations:
x
x
x
x
x

Conditionally Required if Date Originated > 12/31/2009
Include federal, state, and local government funds
Exclude foundation grants and NMTC funds
Exclude public sources used within the QEI structure (e.g. leverage loan to the investment fund)
Response must be in dollar amount
Response must be numeric

Total Project Cost Other CDE’s

(Column H)

Report the portion of the total QLICI investments made by other CDE’s into the project from QEI proceeds.
Validations:
x
x

Conditionally Required if Date Originated > 12/31/2009
Response must be in dollar amount
Response must be numeric

Total Project Cost Private Investment

(Column I)

Report the portion of the private investment in the project (i.e. CDE’s using non-QEI proceeds, direct bank loans,
direct equity, and other investments).
Validations:
x
x
x

Conditionally Required if Date Originated > 12/31/2009
Exclude all investments utilizing QEI proceeds
Response must be in dollar amount
Response must be numeric

43 | Page

Loan-to-Value Ratio

(Column J)

Report the loan-to-value ratio at origination for the total project.
Validations:
x
x
x
x

Conditionally required if one or more financial notes associated with this project has a Transaction
Type = Term Loan
Enter the percentage as a numeric ratio (i.e. if response is 125%, enter 125)
Exclude unsecured loans from calculations
Response must be >10 AND <500
Response must be numeric up to 3 decimal places OR NA

Projected Debt Service Coverage Ratio

(Column K)

Report the projected debt service coverage ratio at origination for the total project.
Validations:
x
x
x

Conditionally required if one or more financial notes associated with this project has a Transaction
Type = Term Loan
Enter the percentage as a numeric ratio (i.e. if response is 125%, enter 1.25)
The value entered must be greater than 0 and less than 10.
Response must be numeric up to 3 decimal places OR NA

Loan Loss Reserve Requirement

(Column L)

Report the loan loss reserve requirement for the total project.
Validations:
x
x
x

Conditionally required if one or more financial notes associated with this project has a Transaction
Type = Term Loan
Enter the percentage as a whole number (i.e. if response is 25%, enter 25)
The Loan Loss Reserve Requirement must be less than or equal to 100%.
Response must be numeric up to 2 decimal places OR NA

Investee (Borrower) Guidance
• If the QALICB is a real estate developer, the Investee is the developer.
• If the QALICB is an operating business (non-real estate), the Investee is the business.
• If the QALICB is a single-purpose entity (SPE) created by an operating business to lease back property to that
parent business, the Investee is the parent business
44 | Page

Client ID

(Column M)

Report a unique identifier to each client (investee/borrower). The Client ID is used to track the investee/borrower
across Projects. Please do not use any names, social security numbers or any other personal identifying information in
formulating the Client ID.
Validations:
x
x

Mandatory field
Do not use names, social security numbers or any other personal identifying information
Response must be text up to 20 characters

Investee TIN

(Column N)

Report the Tax Identification Number (TIN) of the CDE investee/borrower.
Validations:
x

Conditionally required if QLICI Type = CDE
Response must be numeric

Investee CDE Certification Number

(Column O)

If the Project is an investment in another CDE, report the Certification Number of the CDE investee/borrower.
Validations:
x
x

Conditionally required if QLICI Type = CDE
The Investee CDE Certification Number must be a valid CDE Certification Number.
Response must be numeric

Date Business Established

(Column P)

Report the date formal papers were filed to establish the investee’s/borrower’s business or the date the first sales
occurred.
Validations:
x
x
x

Optional field
Date Business Established must be >= to Date Originated
See the Date Formatting section for more information
Response must in the format of mm/dd/yyyy

45 | Page

Entity Structure

(Column Q)

Choose one of the pre-defined values below and report the investee’s/borrower’s business or government structure.
Validations:
x

Conditionally required if Date Originated is after 12/31/2010

Please select one of the following:
NONPROFIT

Non-Profit or Not-for-Profit – Based on the IRS categorization for tax purposes

FORPROFIT

For-Profit – Based on the IRS categorization for tax purposes

TRIBAL

Tribal or Village Government – Entity is a tribal or village government, whether or not
it has been federally recognized

OTHER

Other – All other structures that do not fit the descriptions above, such as a
government or quasi-government entity (i.e. a water authority)

Minority Owned or Controlled

(Column R)

Report whether the investee/borrower is more than 50% owned or controlled by one or more minorities.
Validations:
x
x
x

Optional field
If the business is a for-profit entity, report whether more than 50% of the owners are minorities
If the business is a nonprofit entity, report whether more than 50% of its Board of Directors are
minorities
Response must be YES or NO

Women Owned or Controlled

(Column S)

Report whether the investee/borrower is more than 50% owned or controlled by one or more women.
Validations:
x
x
x

Optional field
If the business is a for-profit entity, report whether more than 50% of the owners are women
If the business is a nonprofit entity, report whether more than 50% of its Board of Directors are
women
Response must be YES or NO

46 | Page

Low-Income Owned or Controlled

(Column T)

Report whether the investee/borrower is more than 50% owned or controlled by one or more low-income persons.
Validations:
x
x
x

Optional field
If the business is a for-profit entity, report whether more than 50% of the owners are low-income
persons
If the business is a nonprofit entity, report whether more than 50% of its Board of Directors are lowincome persons
Response must be YES or NO

Race

(Column U)

Choose one of the pre-defined values below and report the race of the primary investee(s)/borrower(s)
Validations:
x
x
x
x
x
x

Optional field
If there is more than one investee/borrower, select the race of the primary investee/borrower
If there is more than one primary investee/borrower, select the race of one of them
If the investee/borrower is of mixed race, report one of the races
If the investee/borrower did not provide their race, report NG
If the investee/borrower is a corporation, report NA

Please select one of the following:
AMIND
ALASKAN

American Indian
Alaskan Native

ASIAN

Asian

BLACK

Black or African American

HAWAIIAN

Native Hawaiian

PACIFIC

Other Pacific Islander

WHITE

White

OTHER

Other

Not Given

Not Applicable

47 | Page

Hispanic Origin

(Column V)

Choose one of the pre-defined values below and report whether the primary investee/borrower is Hispanic or Latino.
Validations:
x
x
x
x

Optional field
If there is more than one investee/borrower, respond for the primary investee/borrower
If the investee/borrower did not provide their information, report NG
If the investee/borrower is a corporation, report NA

Please select one of the following:
YES

Yes

Not Given

Not Applicable

Business Description – Primary

(Column W)

Choose one of the pre-defined values below and report the primary description of the business of the QALICB.
Validations:
x Conditionally required if QLICI Type = QALICB
x If QLICI Type = CDE then Business Description – Primary must = OTHER
Please select one of the following:
FOOD
Includes groceries, bakeries, food wholesalers, and farmers’ markets
OFFICE
INDUSTRIAL
HOUSING
HEALTH
COMMUNITY
ARTS

Financial, professional, scientific, management, business, or other office space
Industrial, manufacturing, transportation, logistics, or warehousing space
Housing
Health, human, and social service facilities
Education and community facilities
Facilities or space for the performing arts, cultural, entertainment, or other amenities

RETAIL

Retail

HOTEL

Hotel

MIXED

Includes combinations of office/retail, housing, and community spaces.

OTHER

Other

48 | Page

Business Description – Narrative

(Column X)

Provide an additional description of the type of business that is being financed (e.g. grocery store, Federally Qualified
Health Center, charter school, manufacturing company, etc.) and of the products or services provided by the
operating business (e.g. manufacture of farm equipment, early childhood education, primary healthcare, etc.).
Validations:
x
x

Conditionally required if QLICI Type = QALICB
Description cannot exceed 255 characters
Response must be text

NAICS

(Column Y)

Report the 6-digit North American Industry Classification (NAICS) Code of the QALICB.
Validations:
x

Conditionally required if QLICI Type = QALICB

For investments in leased buildings, the NAICS code for the end user of the leased building should be
reported. Avoid using the NAICS codes for Lessors of Real Estate (i.e. 6-digit NAICS codes beginning
with 531).
To determine the NAICS code for the QALICB financed, go to http://www.census.gov/eos/www/naics/
and use the keyword search for the latest version of NAICS.
Please note that the NAICS code should match the business described in the Business Description
field.

Guidance:

x
x

Response must be numeric

49 | Page

Annual Gross Revenue from Business Operations at Time of
Loan/Investment
Annual Gross Revenue (Loan/Investment)

(Column Z)

Report the investee’s/borrower’s annual gross revenue during the most recent 12-month period prior to project
origination for which the information is available.
Validations:
x
x

Conditionally required if QLICI Type = QALICB
If the QALICB is a single-purpose entity (SPE) created by an operating business to lease back property
to that parent business, report the revenue of the parent business
Response must be numeric

Annual Gross Revenue from Business Operations Reported
During the Reporting Period
(Column AA)
Annual Gross Revenue (Reporting Period)
Annual Update Required
Report the investee’s/borrower’s annual gross business revenue during the most recent 12-month period prior to
project origination for which the information is available.
Validations:
x
x

50 | Page

Guidance for Reporting Jobs Projected/Actual Created or
Maintained
The CDFI Fund will be issuing a request for comment on methods to report jobs created or maintained, both projected
and actual. In the interim, Allocatees may rely on the methods that they have used for reporting previously. Currently
in AMIS, values must be entered for either the three Projected Jobs fields or the three Actual Job fields in the Project Outcomes section. The Actual Job fields can be left blank and filled out in the future if the 3 Projected job fields have
been completed. Once filled out, the Actual Job fields can only be updated via service request.

Type of Jobs Reported

(Column AB)

Choose one of the pre-defined values below and indicate whether the types of jobs being reported are direct or direct
and indirect.
Validations:
x

Conditionally required if Purpose = BUSINESS, MICRO, or any Real Estate option

Please select one of the following:
DIRECT
DIRECT/INDIRECT
NA

Direct jobs
Direct/Indirect jobs
Not Applicable

Full-Time Equivalent Jobs - One FTE is a 35-hour or more work week.
Part-Time employees - When calculating FTE’s, part-time employees should be combined (i.e. 2 part-time employees
that each work 17.5 hours equals one FTE)

Jobs at Time of Loan/Investment

(Column AC)

Report the number of full-time equivalent (FTE) jobs in the business at the time the project was originated.
Validations:
x
x
x

Mandatory Field
Exclude construction jobs
If the QALICB is a single-purpose entity (SPE) created by an operating business to lease back property
to that parent business, report jobs for the parent business.
Response must be numeric

51 | Page

Projected Jobs to Be Created - Construction

(Column AE)

Projected Jobs (Construction)
Report the number of construction jobs projected to be created due to this financing.
Validations:
x
x
x
x
x

Conditionally required if Purpose = any Real Estate option
Exclude induced jobs
Include direct and indirect jobs
The number of jobs should not change after the transaction’s initial year of being reported
Values must be entered for either the three Projected Jobs fields or the three Actual Job fields in the
Project - Outcomes section. User may enter a “0” in this field if it does not apply.
Response must be numeric

Projected Permanent Jobs to Be Created at Businesses Financed
Projected Permanent Jobs (Financed)

(Column AD)

Report the number of permanent full-time equivalent (FTE) jobs projected to be created in the business due to this
financing.
Validations:
x
x
x
x
x

Conditionally required if Purpose = BUSINESS or MICRO
Exclude construction and induced jobs
Include direct and indirect jobs
The number of jobs should not change after the transaction’s initial year of being reported
Values must be entered for either the three Projected Jobs fields or the three Actual Job fields in the
Project - Outcomes section. User may enter a “0” in this field if it does not apply.
Response must be numeric

52 | Page

Projected Permanent Jobs to Be Created at Tenant Businesses
Projected Permanent Jobs (Tenant)

(Column AF)

Report the number of full-time equivalent (FTE) jobs projected to be created in businesses located at the property
financed.
Validations:
x
x
x
x
x
x

Optional field
Purpose must = any Real Estate option
Exclude construction and induced jobs
Include direct and indirect jobs
The number of jobs should not change after the transaction’s initial year of being reported
Values must be entered for either the three Projected Jobs fields or the three Actual Job fields in the
Project - Outcomes section. User may enter a “0” in this field if it does not apply.
Response must be numeric

Actual Jobs Created at Businesses Financed

(Column AG)

Actual Jobs Created (Financed)
Report the cumulative number of full-time equivalent (FTE) jobs created in the business due to this financing.
Validations:
x
x
x
x

Conditionally required if Purpose = BUSINESS or MICRO
Exclude construction and induced jobs
Include direct and indirect jobs
Values must be entered for either the three Projected Jobs fields or the three Actual Job fields in the
Project - Outcomes section. Note that you will not be able to change the Actual Jobs information once
it is entered. This field can be left blank and filled out in the future if all projected job fields are filled
out. Please submit a service request if previously entered values need to be updated.
Response must be numeric

53 | Page

Actual Jobs Created (Construction)

(Column AH)

Report the cumulative number of construction jobs created due to this financing.
Validations:
x
x
x
x

Conditionally required if Purpose = any Real Estate option
Exclude induced jobs
Include direct and indirect jobs
Values must be entered for either the three Projected Jobs fields or the three Actual Job fields in the
Project - Outcomes section. Note that you will not be able to change the Actual Jobs information once
it is entered. This field can be left blank and filled out in the future if all projected job fields are filled
out. Please submit a service request if previously entered values need to be updated.
Response must be numeric

Actual Jobs to Be Created at Tenant Businesses

(Column AI)

Actual Jobs Created (Tenant)
Report the cumulative number of full-time equivalent (FTE) jobs created in businesses located at the property
financed.
Validations:
x
x
x
x
x

Optional field
Purpose must = any Real Estate option
Exclude construction and induced jobs
Include direct and indirect jobs
Values must be entered for either the three Projected Jobs fields or the three Actual Job fields in the
Project - Outcomes section. Note that you will not be able to change the Actual Jobs information once
it is entered. This field can be left blank and filled out in the future if all projected job fields are filled
out. Please submit a service request if previously entered values need to be updated.
Response must be numeric

54 | Page

Source of Job Estimates

(Column AJ)

Choose one of the pre-defined values below and report the source of the job estimates reported.
Validations:
x

Conditionally required if Purpose = BUSINESS, MICRO, or any Real Estate option

Please select one of the following:
NEWFINANCING
WAGEDATA
ECONOMICIMPACT

New hires that the project business expects to be able to make as a result of the new
financing
Estimates based on state or local wage data and projected wage and salary
expenditures attributable to project financing
Estimates based on economic impact modeling systems such as IMPLAN, RIMSII, or
REMI

RULEOFTHUMB

Estimates based on developers “rules of thumb” about jobs created by type of
business and square-footage built.

OTHER

Other – Please provide further explanation in Source of Job Estimates – Other

Not Applicable

Source of Job Estimates – Other

(Column AK)

Provide further explanation for what the source of job estimates is.
Validations:
x

Conditionally required if Source of Job Estimates = OTHER
Response must be text

Square Feet of Real Estate – Manufacturing

(Column AL)

Square Feet of Real Estate – Manufacture
Report the total number of gross square feet of manufacturing space that are expected to be constructed,
rehabilitated, or acquired with funding from the transaction.
Validations:
x

Mandatory Field
Response must be numeric

55 | Page

Square Feet of Real Estate – Office

(Column AM)

Report the total number of gross square feet of office space that are expected to be constructed, rehabilitated, or
acquired with funding from the transaction.
Validations:
x

Mandatory Field
Response must be numeric

Square Feet of Real Estate – Retail

(Column AN)

Report the total number of gross square feet of retail space that are expected to be constructed, rehabilitated, or
acquired with funding from the transaction.
Validations:
x

Mandatory Field
Response must be numeric

Housing Units – Sale

(Column AO)

Compliance Check

Report the number of for-sale housing units to be constructed, rehabilitated, or acquired with funding from the
transaction.
Validations:
x
x

Mandatory Field
Housing Units – Sale must be greater than or equal to Affordable Housing Units - Sale
Response must be numeric

Housing Units – Rental

(Column AP)

Compliance Check

Report the number of rental housing units to be constructed, rehabilitated, or acquired with funding from the
transaction.
Validations:
x
x

Mandatory Field
Housing Units – Rental must be greater than or equal to Affordable Housing Units - Rental
Response must be numeric

56 | Page

Affordable Housing Units – Sale

(Column AQ)

Compliance Check

Of the total Housing Units - Sale to be constructed, rehabilitated, or acquired with funding from the transaction,
report the number that are projected to be affordable housing units
Validations:
x

Mandatory Field
Response must be numeric

Affordable Housing Units – Rental

(Column AR)

Compliance Check

Of the total Housing Units - Rental to be constructed, rehabilitated, or acquired with funding from the transaction,
report the number that are projected to be affordable housing units.
Validations:
x

Mandatory Field
Response must be numeric

Community Facility

(Column AS)

Report whether the project financed is a community facility.
Validations:
x

Mandatory field
Response must be YES, NO, or Don’t Know

57 | Page

Capacity of Educational Community Facility

(Column AT)

Capacity of Educational Community
If the project financed includes an educational facility, report the number of student seats available in the school. If
not, report 0.
Validations:
x

Conditionally required if Community Facility = YES
Response must be numeric

Capacity of Childcare Community Facility

(Column AU)

If the project financed includes a childcare facility, report the number of childcare slots available. If not, report 0.
Validations:
x

Conditionally required if Community Facility = YES
Response must be numeric

Capacity of Healthcare Community Facility

(Column AV)

Capacity of Healthcare Community
If the project financed includes a healthcare facility, report the projected number of visits per year. If not, report 0.
Validations:
x

Conditionally required if Community Facility = YES
Response must be numeric

58 | Page

Capacity of Arts Center Community Facility

(Column AW)

Capacity of Arts Center Community
If the project financed includes an arts center, report the capacity of the arts center (i.e. if the project is a theater,
report the seating capacity). If not, report 0.
Validations:
x

Conditionally required if Community Facility = YES
Response must be numeric

QALICB Type

(Column AX)

Compliance Check

Choose one of the pre-defined values below and report the QALICB type that describes the investee/borrower.
Validations:
x

Conditionally required if QLICI Type = QALICB

Please select one of the following:
RE

Real Estate QALICB

NRE

Non-Real Estate QALICB

SPE

Special Purpose Entity QALICB

59 | Page

NMTC Eligibility Criteria

(Column AY)

Compliance Check

Choose one of the pre-defined values below and report which geographic criteria qualifies this transaction as a NMTC
eligible transaction.
Validations:
x

Mandatory field

Please select one of the following:
TARGETAREA

CDFI Fund approved target area or other area (can only be selected if Date Originated
is prior to 12/31/2012)

TARGETPOP

Targeted population

TRACTS

Tracts with low population

HIGHMIGRATION

High migration rural county
American Community Survey 2006-2010 – May apply to QLICIs closed between

2006-2010ACS
May 1, 2012 and October 31, 2018.
2011-2015ACS

American Community Survey 2011-2015 – May apply to QLICIs closed between and
including October 31, 2017 and October 31, 2018. Exclusively applies to QLICIs closed
on or after November 1, 2018.

60 | Page

Related Entity

(Column AZ)

Compliance Check

Report whether the investee (entity receiving the financing) is a related entity as defined under the applicable
allocation agreement.
Validations:
x

Mandatory field
Response must be YES or NO

Front End Sources of Compensation and Profits Charged to
Investors
Front End Sources (Investors)

(Column BA)

Report the amount of front-end sources of compensation and profits charged to investors in basis points of the QEI
provided by the CDE.
Validations:
x
x
x

Mandatory field
Include any and all revenue charged prior to or during the close of the transaction (i.e. origination fees,
brokerage fees, legal fees, etc.)
Fees should be in basis points of 0 to 10000
Response must be numeric

Front End Sources of Compensation and Profits Charged
Borrowers/Investees
Front End Sources (Borrowers/Investees)

(Column BB)

Report the amount of front-end sources of compensation and profits charged to borrowers/investees in basis points
of the QEI provided by the CDE.
Validations:
x Mandatory field
x Include any and all revenue charged prior to or during the close of the transaction (i.e. origination fees,
brokerage fees, legal fees, etc.)
x Fees should be in basis points of 0 to 10000
Response must be numeric

61 | Page

Front End Sources of Compensation and Profits Charged to Other
Entities
Front End Sources (Other Entities)

(Column BC)

Report the amount of front-end sources of compensation and profits charged to other entities in basis points of the
QEI provided by the CDE.
Validations:
x
x
x

On-going Sources of Compensation and Profits Charged to
Investors
On-going Sources (Investors)

(Column BD)

Report the amount of on-going sources of compensation and profits charged to investors in basis points of the QEI
provided by the CDE.
Validations:
x
x

Mandatory field
Include any and all revenue collected throughout the allocation compliance period (i.e. asset
management fees, compliance fees, interest rate spread, etc.) with the exception of ordinary interest
or dividend payments pass through investors
Fees should be in basis points of 0 to 10000
Response must be numeric

62 | Page

On-going Sources of Compensation and Profits Charged to
Borrowers/Investees
On-going Sources (Borrowers/Investees)
(Column BE)
Report the amount of on-going sources of compensation and profits charged to borrowers/investees in basis points of
the QEI provided by the CDE.
Validations:
x
x

On-going Sources of Compensation and Profits Charged to Other
Entities
On-going Sources (Other Entities)

(Column BF)

Report the amount of on-going sources of compensation and profits charged to other entities in basis points of the
QEI provided by the CDE.
Validations:
x
x

Total QEI Proceeds Retained by the CDE

(Column BG)

Report the total amount of the QEI proceeds retained by the CDE expressed in basis points of the QEI provided by the
CDE.
Validations:
x
x
x

Mandatory field
QEI proceeds retained by the CDE + Amount of the QLICI should equal the total QEI
Fees should be in basis points of 0 to 10000
Response must be numeric

63 | Page

Back-end Sources of Compensation and Profits Charged to
Investors
Back-end Sources (Investors)

(Column BH)

Report the amount of back-end sources of compensation and profits charged to investors in basis points of the QEI
provided by the CDE.
Validations:
x
x
x

Mandatory field
Include any and all revenue collected at time of investment exit or after the investment exit (i.e. success,
residuals, exit fees, carried interest, etc.)
Fees should be in basis points of 0 to 10000
Response must be numeric

Back-end Sources of Compensation and Profits Charged to
Borrowers/Investors
Back-end Sources (Borrowers/Investees)

(Column BI)

Report the amount of back-end sources of compensation and profits charged to borrowers/investees in basis points
of the QEI provided by the CDE.
Validations:
x
x
x

64 | Page

Back-end Sources of Compensation and Profits Charged to Other
Entities
Back-end Sources (Other Entities)

(Column BJ)
Report the amount of back-end sources of compensation and profits charged to other entities in basis points of the
QEI provided by the CDE.
Validations:
x
x
x

Other Sources of Compensation and Profits Charged to Investors
Other Sources (Investors)

(Column BK)

Report the amount of other sources of compensation and profits charged to investors that have not been disclosed as
front-end, on-going, or back-end sources of compensation and profit in basis points of the QEI provided by the CDE.
Validations:
x
x

Mandatory field
Fees should be in basis points of 0 to 10000
Response must be numeric

Other Sources of Compensation and Profits Charged to
Borrowers/Investees
Other Sources (Borrowers/Investees)

(Column BL)

Report the amount of other sources of compensation and profits charged to borrowers/investees that have not been
disclosed as front-end, on-going, or back-end sources of compensation and profit in basis points of the QEI provided
by the CDE.
Validations:
x
x

Mandatory field
Fees should be in basis points of 0 to 10000
Response must be numeric

65 | Page

Other Sources of Compensation and Profits Charged to Other
Entities
Other Sources (Other Entities)

(Column BM)

Report the amount of other sources of compensation and profits charged to other entities that have not been
disclosed as front-end, on-going, or back-end sources of compensation and profit in basis points of the QEI provided
by the CDE.
Validations:
x
x

Mandatory field
Fees should be in basis points of 0 to 10000
Response must be numeric

Below Market Interest Rate

(Column BN)

Compliance Check

Report whether the project had a below market interest rate at the end of the initial reporting period.
Validations:
x

Mandatory field
Response must be YES or NO

Blended Interest Rate

(Column BO)

Annual Update Required
Report the blended interest rate in effect at the reporting period end.
Validations:
x
x
x
x

Conditionally required if Below Market Interest Rate = YES
When calculating the blended interest rate, users may treat equity investments as 0% interest loans
If the project was paid off, report the interest rate at the time of the pay off
Enter the percentage as a whole number (i.e. if the Blended Interest Rate is 2%, enter 2.0)
Response must be numeric up to 3 decimal places

66 | Page

Comparable Blended Interest Rate

(Column BP)

Annual Update Required
Report the comparable market rate at the end of the reporting period that the Allocatee used as a benchmark to
determine that the project has a below market interest rate.
Validations:
x
x
x

Conditionally required if Below Market Interest Rate = YES
Enter the percentage as a whole number (i.e. if the Blended Interest Rate is 2%, enter 2.0)
Comparable Blended Interest Rate must be greater than Blended Interest Rate
Response must be numeric up to 3 decimal places

Lower than Standard Origination Fees

(Column BQ)

Compliance Check

Report whether the project has lower than standard origination fees.
Validations:
x

Mandatory field
Response must be YES or NO

Standard Origination Fees (Project)

(Column BR)

Report the comparable market origination fees that the Allocatee used as benchmark to determine that the project
has lower than standard origination fees.
Validations:
x
x

Conditionally required if Lower than Standard Origination Fees = YES
Value must be entered in dollars and must not be between 0 and 15
Response must be numeric

Higher than Standard Loan to Value Ratio

(Column BS)

Compliance Check

Report whether the project has a higher than standard loan to value ratio.
Validations:
x

Mandatory field
Response must be YES or NO

67 | Page

Standard Loan to Value Ratio

(Column BT)

Report the comparable market loan to value ratio that the Allocatee used as benchmark to determine that the project
has higher than standard loan to value ratio.
Validations:
x
x

Conditionally required if Higher than Standard Loan to Value Ratio = YES
Enter the percentage as a whole number (i.e. if 2%, enter 2.0)
Response must be numeric up to 3 decimal places

More Flexible Borrower Credit Standards

(Column BU)

Compliance Check

Report whether the project has more flexible borrower credit standards.
Validations:
x

Mandatory field
Response must be YES or NO

Lower than Standard Debt Service Coverage Ratio

(Column BV)

Lower than Standard Debt Service Ratio
Compliance Check

Report whether the project has a lower than standard debt service coverage ratio.
Validations:
x Mandatory field
Response must be YES or NO

Standard Debt Service Coverage Ratio

(Column BW)

Report the comparable market debt service coverage ratio that the Allocatee used as benchmark to determine that
the project has a lower than standard debt service coverage ratio.
Validations:
x
x

Conditionally required if Lower than Standard Debt Service Coverage Ratio = YES
Enter the percentage as a whole number (i.e. if 2%, enter 2.0)
Response must be numeric up to 3 decimal places

68 | Page

Lower than Standard Loan Loss Reserve Requirement
Lower than Standard Loan Loss Req

(Column BX)

Compliance Check

Report whether the project has a lower than standard loan loss reserve requirement.
Validations:
x

Mandatory field
Response must be YES or NO

Standard Loan Loss Reserve Requirement

(Column BY)

Report the comparable standard loan loss reserve requirement that the Allocatee used as benchmark to determine
that the project has a lower than standard debt service coverage ratio.
Validations:
x
x

Conditionally required if Lower than Standard Loan Loss Reserve Requirement = YES
Expressed in percentage points, enter percentage as a whole number (e.g. if the LLR requirement is 5%,
enter “5”)
Response must be numeric

Poverty Rates Greater than 25% but less than or equal to 30%
Poverty Rates Greater > 25% and < 30%

(Column BZ)

Compliance Check

Poverty Rates Greater than 25% but less than or equal to 30%.
Validations:
x

Mandatory field
Response must be YES, NO or NA

Poverty Rates Greater than 30%

(Column CA)

Compliance Check

Poverty Rates Greater than 30%
Validations:
x

Mandatory field
Response must be YES, NO or NA

69 | Page

Median Income Less than or Equal to 60% of Area Median
Income
DĞĚŝĂŶ/ŶĐŽŵĞZĂƚĞƐчϲϬйŽĨƌĞĂDĞĚŝĂŶ/ŶĐŽŵĞ

(Column CB)

Compliance Check

If located within a non-metropolitan area, median family income does not exceed 60% of statewide median family
income or if located within a metropolitan area, median family income does not exceed 60% of the statewide median
family income or the metropolitan area median family income.
Validations:
x

Mandatory field
Response must be YES, NO or NA

Median Income Greater than 60% of Area Median Income but
less than 70%
Median Income 60-70% Area Median Income

(Column CC)

Compliance Check

If located within a non-metropolitan area, median family income is greater than 60% but less than 70% of statewide
median family income or if located within a metropolitan area, median family income greater than 60% but less than
or equal to 70% of the statewide median family income or the metropolitan area median family income.
Validations:
x

Mandatory field
Response must be YES, NO or NA

Unemployment rates equal to or greater than 1.25 but less than
1.5 times the national average
Unemployment rates 1.25 – 1.5 Nation AVG

(Column CD)

Compliance Check

Unemployment rates equal to or greater than 1.25 but less than 1.5 times the national average.
Validations:
x

Mandatory field
Response must be YES, NO or NA

70 | Page

Unemployment rates at least 1.5 times the national average
Unemployment rates equal 1.5X national average

(Column CE)

Compliance Check

Unemployment rates at least 1.5 times the national average.
Validations:
x

Mandatory field
Response must be YES, NO or NA

Designated for Redevelopment

(Column CF)

Compliance Check

Designated for redevelopment by a governmental agency.
Validations:
x

Mandatory field
Response must be YES, NO or NA

Designated EZ, EC, or RC

(Column CG)

Compliance Check

Federally designated Empowerment Zone, Enterprise Communities, or Renewal Communities.
Validations:
x

Mandatory field
Response must be YES, NO or NA

SBA Designated HUB Zone

(Column CH)

Compliance Check

U.S. Small Business Administration (SBA) designated HUB Zones, to the extent that the QLICI’s will support businesses
that obtain HUB Zone certification from the SBA.
Validations:
x
x
x

Mandatory field
Round 1 and Round 2 Allocatees – For a project to qualify as an eligible AHD under this criterion, the
project must only be located in an SBA designated HUB Zone
Round 3, Allocatees and all Allocatees thereafter – For a project to qualify as an eligible AHD under this
criteria, the project must be located in an SBA designated HUB Zone and the QLICIs support businesses
that obtain HUB Zone certification from the SBA
Response must be YES, NO or NA

71 | Page

Designated Native American or Alaska Native Area, Hawaiian
Homeland, or Redevelopment Area by Tribe or Other Authority
Designated Native American

(Column CI)

Compliance Check

Federally designated as Native American or Alaskan areas, Hawaiian Homelands, or redevelopment areas by the
appropriate tribal or other authority.
Validations:
x

Mandatory field
Response must be YES, NO or NA

Brownfield Redevelopment Area

(Column CJ)

Compliance Check

Federally designated Brownfields redevelopment areas.
Validations:
x

Mandatory field
Response must be YES, NO or NA

Encompassed by HOPE VI Redevelopment Plan

(Column CK)

Compliance Check

Validations:
x

Mandatory field
Response must be YES, NO or NA

72 | Page

Located in a Hot Zone

(Column CL)

Compliance Check

Located in a Hot Zone. This is defined as geographic areas designated by the Fund as having greater levels of
economic distress.
Validations:
x
x

Mandatory field
Must be NO or NA if Date Originated is after 12/31/12
Response must be YES, NO or NA

Appalachian Regional Commission or Delta Regional Authority
Appalachian Commission/Delta Authority

(Column CM)

Compliance Check

Areas designated as distressed by the Appalachian Regional Commission or Delta Regional Authority.
Validations:
x

Mandatory field
Response must be YES, NO or NA

Colonias

(Column CN)

Compliance Check

Areas as designated by the U.S. Department of Housing and Urban Development.
Validations:
x

Mandatory field
Response must be YES, NO or NA

73 | Page

Medically Underserved Area

(Column CO)

Compliance Check

Federally designated medically underserved areas, to the extent that QLICI activities will support health related
services.
Validations:
x

Mandatory field
Response must be YES, NO or NA

TIF District or Enterprise Zone Program

(Column CP)

Compliance Check

State or local tax-increment financing districts, enterprise zone programs, or other similar state/local programs
targeted towards particularly economically distressed communities.
Validations:
x
x

Mandatory field
d/&ŝƐƚƌŝĐƚŽƌŶƚĞƌƉƌŝƐĞŽŶĞWƌŽŐƌĂŵтDesignated for Redevelopment
Response must be YES, NO or NA

High Migration Rural County

(Column CQ)

Compliance Check

Validations:
x

Mandatory field
Response must be YES, NO or NA

Non-Metropolitan Census Tract

(Column CR)

Compliance Check

Validations:
x

Mandatory field
Response must be YES, NO or NA

74 | Page

FEMA

(Column CS)

Compliance Check

Counties for which the Federal Emergency Management Agency (FEMA) has (a) issues a “major disaster declaration”
since July 15, 2005; and (b) made a determination that such County is eligible for both “individual and public
assistance;” provided that, for areas not located within the GO Zone, the initial project investment was made within
24 months of the disaster declaration.
Validations:
x

Mandatory field
Response must be YES, NO or NA

TAA Program

(Column CT)

Compliance Check

Businesses certified by the Department of Commerce as eligible for assistance under the Trade Adjustment Assistance
for Firms (TAA) Program.
Validations:
x

Mandatory field
Response must be YES, NO or NA

Food Desert

(Column CU)

Compliance Check

A low-income census tract where a substantial number or share of residents has low access to a supermarket or large
grocery store. Census tracts qualify as food deserts if they meet low-income and low-access thresholds established by
the USDA and can be found using the Food Access Research Atlas at http://www.ers.usda.gov/data-products/foodaccess-research-atlas.aspx. Note: This option may only be selected to the extent QLICI activities will increase access
to healthy food.
Validations:
x

Mandatory field
Response must be YES, NO or NA

75 | Page

Targeted Populations

(Column CV)

Compliance Check

As permitted by IRS and related CDFI Fund guidance materials, projects serving Targeted Populations to the extent
that: (a) such projects are 60 percent owned by Low-Income Persons (LIPs); or (b) at least 60 percent of employees are
LIPs; or (c) at least 60 percent of customers are LIPs.
Validations:
x

Mandatory field
Response must be YES, NO or NA

Other Areas of Higher Distress

(Column CW)

Compliance Check

Report any responses applicable to the transaction in the same text as appears in the Allocation Agreement. In
addition to the Standard List outlined above, some Allocations may have additional targeted areas approved in their
Allocation Agreement.
Validations:
x

Mandatory field
Response must be YES, NO or NA

76 | Page

TLR Address
The CDFI Fund requires that Organizations confirm that all addresses are geocodable in CIMS (the Fund’s CDFI
Information and Mapping System) prior to reporting in AMIS. CIMS is available through the “Mapping” link on the
CDFI Fund’s Tools and Resources page: < https://www.cdfifund.gov/pages/tools-resources.aspx>

FIPS Code – refers to the 11-digit Federal Information Processing Standards codes. FIPS Codes must be provided if
AMIS is unable to geocode an address. The FIPS Code is a combination of the State, County, and Tract Code. To find a
FIPS Code visit: < https://www.cdfifund.gov/pages/tools-resources.aspx>

The results of the geocode system display as:
Wen entered into AMIS, FIPS Codes should appear as: 11001010700

As of June 25, 2014, AMIS has updated with the most recent census data. Please use the most current census
information when obtaining and reporting FIPS Codes.

X, Y Coordinates – specify an exact geographic location using longitude and latitude. X, Y Coordinates should not be
rounded, and AMIS requires that both the coordinates be reported to five (5) decimal points. The latitude and longitude
can be found using a variety of tools such as a GPS, an address locator, or a map-based tool.
Example:
X Coordinate (Longitude, typically displayed as negative): -77.04201
Y Coordinate (Latitude, typically displayed as positive): 38.90397

Project Number

(Column B)

Compliance Check

Report the project number for each address that was previously input in Project Number column on the NotesInvestment tab: Column A.
Validations:
x
x

Mandatory Field (System will automatically populate the number of the associated TLR Project)
Project Number must match a Project Number reported on the Notes-Investment tab.
Response must be numeric - up to 8 digits

77 | Page

Multi-CDE Project Number

(Column C)

Report the Multi-CDE Project Number that was assigned to the project. Use the lookup function to identify and report
the Multi-CDE Project ID associated with the project.
Validations:
x
x
x
x

Conditionally Required if the TLR Project that the TLR Address is being entered for is part of a MultiCDE Project
Additional guidance can be found in the Multi-CDE section of AMIS
Response must be a valid project number generated by AMIS under the Multi-CDE Project section
Use the lookup icon to view a list of Multi-CDE Projects associated with the organization that the TLR
Project can be linked to.

Investee Street Address Line 1

(Column D)

Compliance Check

Report the address for the investee/borrower.
Validations:
x
x

Mandatory Field
No Post Office Boxes or Rural Routes
Response must be text

Investee Street Address Line 2

(Column E)

Report the second line of the investee’s street address, if necessary.
Validations:
x
x

Optional Field
No Post Office Boxes or Rural Routes
Response must be text

78 | Page

Investee City

(Column F)

Compliance Check

Report the investee’s city.
Validations:
x

Mandatory Field
Response must be text

Investee State

(Column G)

Compliance Check

Report the two-letter state abbreviation.
Validations:
x

Mandatory Field
Response must be text

Investee Zip Code

(Column H)

Compliance Check

Report the five-digit zip code.
Validations:
x

Mandatory Field
Response must be numeric

Investee Zip Code +4

(Column I)

Compliance Check

Report the four-digit zip code extension
Validations:
x

Optional Field
Response must be numeric

79 | Page

FIPS Code – refers to the 11-digit Federal Information Processing Standards codes. The FIPS Code is a combination of
the State, County, and Tract Code. To find a FIPS Code visit: https://www.cdfifund.gov/Pages/mapping-system.aspx
The results of the geocode system display as:
When entered into AMIS, FIPS Codes should appear as: 11001010700

As of June 25, 2014, AMIS has updated with the most recent census data. Please use the most current census
information when obtaining and reporting FIPS Codes.

Investee FIPS Code

(Column J)

Report the investee’s 11-digit FIPS Code.
Validations:
x

Conditionally required if primary address fields are not entered.
Response must be numeric

Investee Longitude

(Column K)

Report the Investee Longitude.
Validations:
x

Conditionally required if primary address fields are not entered.
Response must be numeric

Investee Latitude

(Column L)

Report the Investee Latitude.
Validations:
x

Conditionally required if primary address fields are not entered.
Response must be numeric

80 | Page

Project Street Address Line 1

(Column M)

Compliance Check

Report the location of the business or other real estate for which the loan or investment is being used.
Validations:
x
x

Mandatory Field
No Post Office Boxes or Rural Routes
Response must be text

Project Street Address Line 2

(Column N)

Report the second line of the project’s street address, if necessary.
Validations:
x
x

Optional Field
No Post Office Boxes or Rural Routes
Response must be text

Project City

(Column O)

Compliance Check

Report the project’s city.
Validations:
x

Mandatory Field
Response must be text

Project State

(Column P)

Compliance Check

Report the two-letter state abbreviation.
Validations:
x

Mandatory Field
Response must be text

81 | Page

Project Zip Code

(Column Q)

Compliance Check

Report the five-digit zip code.
Validations:
x

Mandatory Field
Response must be numeric

Project Zip Code +4

(Column R)

Compliance Check

Report the four-digit zip code extension
Validations:
x

Optional Field
Response must be numeric

Project FIPS Code

(Column S)

Report the project’s 11-digit FIPS Code.
Validations:
x

Conditionally required if primary address fields are not entered.
Response must be numeric

Project Longitude

(Column T)

Report the Project Longitude.
Validations:
x

Conditionally required if primary address fields are not entered.
Response must be numeric

82 | Page

Project Latitude

(Column U)

Report the Project Latitude.
Validations:
x

Conditionally required if primary address fields are not entered.
Response must be numeric

83 | Page

Loan Source and Disbursements
The Loan Source section in AMIS collects data previously reported in the QEI Distribution Report in CIIS. This includes
data related to the source of QLICI funds (i.e. QEIs/RQIs used and amount used from each QEI/RQI) and disbursement
information (i.e. amount of disbursement(s) and date of disbursement(s)).
Loan Source information is required.
For the time being, AMIS does not allow users to report Loan Source information via CSV or XML upload. This data must
be reported via the user interface in AMIS.
Various warnings and validations rules are built in to the Loan Source user interface in AMIS to ensure that loan source
and disbursement data is entered accurately. For example, the fields Disbursement Date and Disbursement Amount are
expected to be identical for all Loan Sources with the same Disbursement ID and same TLR Note. In the case that a Loan
Source is entered with inconsistent values, the user will not be able to save the data.

TLR Note
The system will auto-populate this field with the TLR Note ID of the TLR Note if one was previously selected. If this
field is not prepopulated, the user will be required to look-up the TLR Note.
Validations:
x
x
x

Mandatory Field
Will auto-populate with the TLR Note number. If this field is not prepopulated, the user will be required
to look-up the TLR Note.
Once Loan Source data is saved, this field allows the users to easily navigate back to the associated TLR
Note via the “TLR Note” field hyperlink.
Alphanumeric

Revolving Loan
Report if the Disbursement is made to a revolving loan or loan fund.
Validations:
x
x

Optional field
Checkbox for the user to mark when a loan is revolving.
Checkbox

84 | Page

Disbursement ID
Users are required to group Loan Sources that are tied to the same Disbursement using an identical Disbursement ID.
This value is user entered, but the system will check to ensure that all Loan Sources with the same Disbursement ID
have the same Disbursement Date and the same Disbursement Amount.
Validations:
x
x

Mandatory Field
Loan Source records may have the same disbursement ID, but the fields Disbursement Date and
Disbursement Amount are expected to be identical for all Loan Sources with the same Disbursement ID
and same TLR Note.
Response can be alphanumeric

Disbursement Amount
For each Disbursement ID, report the total disbursement amount. Users do not need to provide a disbursement
amount for disbursements that are “Not Yet Disbursed”.
Validations:
x
x

Mandatory Field
The sum of Disbursement Amounts from each Unique Disbursement ID cannot exceed the Original
Loan/Investment Amount.
Response Must Be Numeric

Disbursement Date
Report the Disbursement date.
Validations:
x

Mandatory Field
Format of mm/dd/yyyy

85 | Page

Record Type of New Record
Choose one of the pre-defined values below and indicate whether the Loan Source record type being reported is a
QEI, RQI, or Other.
Validations:
x

Mandatory Field

Please select one of the following:
1. QEI

QEI

2. RQI

RQI

3. Other

Other
Picklist Selection

QEI
Report the QEI that the Loan Source is associated with.
Validations:
x
x

Conditionally required: If “QEI” was selected as the disbursement type
QEI Identifier should be in the following format: QEI12345678 (“QEI” followed by eight numbers)
Lookup Field to QEIs

Note: Click on the search icon to search for the QEI the Loan Source record is associated with.

86 | Page

RQI
Report the allocation the Loan Source is associated with. Allocatees that have received repayments from prior QLICIs
and have closed reinvestment QLICIs should adhere to the following instructions to report such transactions.
Allocatees can create a Reinvestment Qualified Equity Investment (RQI) ID for each allocation in ATS. The RQI
represents the aggregate amount of repayments received from prior QLICIs as of the reporting period end date.
Validations:
x

Conditionally Required: If “RQI” was selected as the disbursement type
Lookup Field to RQIs

Note: Click on the search icon to search for the Allocation the Loan Source record is associated with.

Source Amount
For each Loan Source, report the QEI that sourced (funded) the disbursement, or if “RQI” is selected, report the
allocation that contains the RQI that sourced (funded) the disbursement. The Source Amount represents the portion
of the QEI used to fund the associated disbursements.

Validations:
x
x
x
x

Mandatory Field
Reported QEIs must be a valid QEI for the Allocatee in the Allocation and QEI Tracking module in AMIS.
Reported Allocations containing the RQI must be a valid Allocation for the Allocatee Allocation and QEI
Tracking module in AMIS.
The sum of Source Amounts for each Unique Disbursement ID cannot exceed the Disbursement Amount
Response Must Be Numeric

87 | Page

File Type	application/pdf
Author	Hart, Chantal
File Modified	2020-04-29
File Created	2020-04-29