Community Investment Impact System (CIIS) CIIS 8.1 CDFI TLR Manual/Online Data Entry

1. US Department of the Treasury Community Development Financial Institutions Fund Community Investment Impact System (CIIS) CIIS 8.1 CDFI TLR Manual/Online Data Entry February 2011

2. Introduction • You should continue with this session if you are a CDFI with questions about: • The Transaction Level Report (TLR) functionality • Completing the TLR Online • Certifying and submitting the TLR

3. Agenda • Who Should Use Online/Manual Data Entry? • TLR Introduction • Prepare TLR • Enter TLR Data • Validate Pending Transactions • Pre-Certify Transactions • Certify TLR • FY 2010 Report

4. Who Should Use Online/Manual Data Entry? • Organizations with a small number of transactions • Less than 10 transactions. • Organizations with a lot of data. • Organizations with more than 10 transactions should consider using the Excel Template. • Organizations with a large amount of data & technical support should consider using XML.

5. TLR Introduction Organization’s Data Submit Transactions to CIIS Pending Transactions Pre-Certify / Return to Pending Users may copy Certified TLR from previous Reporting Period to Current Pending. Pre-Certified Transactions Certify Certified Transactions Users may generate a copy of Certified TLR to current Excel Template for reference and/or future reporting.

6. Prepare TLR Report Period Include all loans and investments that were outstanding at any time during the reporting period. The reporting period for the FY 2010 TLR is the Organization's fiscal year ending in 2010. “As of Date” All data must be reported as of the reporting period end date unless otherwise noted.

7. Prepare TLR • TLR Data Point Instructions (Example 1) Excel Column Double Box indicates “Mandatory Data Field” General Validation requirements Describes data format for Excel Template.

8. Prepare TLR • TLR Data Point Instructions (Example 2) Excel Column Thick Box indicates “Conditionally Required” Data field may be used to measure compliance with the Organization’s Assistance Agreement General Validation requirements Describes data format for Excel Template.

9. Originator Transaction ID Investee Type Date Originated Original Loan/Investment Amount Purpose Transaction Type Loan Status Address or Census Tract fields Prepare TLR • FY 2010 Mandatory CDFI Data Points

10. Prepare TLR • FY 2010 Conditionally Required CDFI Data Points • Interest Rate • Interest Type • Points • Origination Fees • Amortization Type • Equity Like Features • Days Delinquent • Fair Value at Origination / End of Reporting Period • Projected Impacts (except for Other Impacts) • Projected Jobs to be Created (Business / Construction) • Jobs at Time of Loan/Investment / Jobs at Reporting Period End • First-Time Homebuyer • Community Facility / Capacity of Community Facilities • Square Feet of Real Estate – Retail / Office / Manufacturing • Affordable Housing / Housing – Sale / Rental • Term • Guarantee • Lien Position • Collateral Type • Collateral Value at Origination • Principal Balance Outstanding

11. Enter TLR Data Organization’s Data Submit Transactions to CIIS Pending Transactions HINT: If you Certified a TLR in a previous Report Period, you should begin by downloading the previous report.

12. Enter TLR Data • To enter TLR data using with the online interface: • Go to CIIS Home Page • Select “Data Entry” from TLR menu.

13. Enter TLR Data • Initiate a new transaction: On TLR Data Entry screen, select “Online Entry” from “Submit transactions” menu.

14. Enter TLR Data • User must complete 5 Key data points in order to navigate to other data points or save the transaction: • Originator Transaction ID • Investee Type • Purpose • Transaction Type • Loan Status

15. Enter TLR Data • Navigating - Use CIIS navigation buttons, NOT browser navigation buttons. • Saving: • “Save” button. • “Previous,” “Next, ” and “Exit” buttons also save. • New data entries will not be saved if: • CIIS “times out;” • User closes CIIS window; • User selects a Table of Contents link; or • User selects “Home” button.

16. Enter TLR Data Table of Contents Navigation Buttons

17. Enter TLR Data • Updating Transactions Pending Transactions: • On TLR Data Entry screen, select “Pending Transactions” from TLR Functions. • Select the transaction checkbox. • Select “Update Transaction” button. • CIIS will bring user to Page 1 of the Transaction.

18. Enter TLR Data

19. Validate Pending Transactions • General Validations • CIIS will run General Validations, as noted in the TLR Instructions. • User must complete General Validations one transaction at a time. • CIIS provides a report of any General Validation errors. • Users must correct errors by Updating Transaction.

20. Validate Pending Transactions • Sample Error Report

21. Validate Pending Transactions 2. Address Verification (ESRI Validation) • Address Verification tests for “geocodable” (ability to map) Investee & Project Addresses. • To complete Address Verification: • All General Validations must be passed. • Use “Validate Transaction” button on “Pending” page. • CIIS will validate all pending transactions. • CIIS provides a report of entered addresses that are not “geocodable.” • 75% of addresses must be “geocodable” to Pre-Certify. • Users must correct errors by Updating Transaction.

22. Validate Pending Transactions • Transaction Status • Entry - Transaction is not validated. • Error – Errors exist in General Validations • Passed – Passed General Validations, Address Verification not complete. • Error: Address Verification Failed - Address could not be geocoded. Ready to Pre-Certify if less then 25% fail. • Address Verification Passed - Passed General Validations & Address Verification. Ready to Pre-Certify.

23. Pre-Certify Transactions • Pre-Certify all Pending Transactions to be Certified. • Users may Pre-Certify transactions when Transactions status = “Address Verification Passed” Organization’s Data Submit Transactions to CIIS Pending Transactions Pre-Certify / Return to Pending Pre-Certified Transactions

24. Pre-Certify Transactions • Users may view Pre-Certified transactions’ Key data points online. • Users may Pre-Certify multiple times. • Users may send Pre-Certified transactions back to Pending in batch.

25. Certify TLR Organization’s Data Submit Transactions to CIIS Pending Transactions Pre-Certify / Return to Pending Users may copy Certified TLR from previous Reporting Period to Current Pending. Pre-Certified Transactions Certify Certified Transactions Users may generate a copy of Certified TLR to current Excel Template for reference and/or future reporting.

26. Certify TLR • CIIS has a single Certification for ILR and TLR. • Organizations may only Certify one time per Report Period. • Users may Certify TLR when: • ILR is complete. • TLR – There are one or more Pre-Certified Transactions. • TLR – There are no Transactions in the Pending List. • How to Certify: Select “Certify” from CIIS home page

27. Useful information • Additional CIIS information is available at www.cdfifund.gov/what_we_do/ciis.asp • Contact the CIIS Help Desk at ciishelp@kearneyco.com or (703) 373 -1516