Tax Credit Transmit Florida

This Tax Credit Export Type is for the state of Florida. Florida does not receive a transmission file and instead receives an Excel spreadsheet in a required format which is attached to an email.  This Tax Credit Export Type will create a CSV file which can be pasted into the Tenant Data tab of this Excel spreadsheet.

A separate Excel Spreadsheet that with macros is provided in Property Manager as part of the Build LIHTC File task that will take this CSV file and copy it into the necessary format to be sent to the State of Florida.

In January 2015, the Florida Annual Reporting Spreadsheet has been updated to maintain compliance. To use the updated Spreadsheet, follow these steps:

1. 1. Save the Florida_TIC_report.xls and Florida_TIC_report_macro.xls files to your document library, using the Property Manager > System Administration > Maintain Documents path.

   2. Right click and then select Insert Document.

   3. Enter a document name, and then click the Search Document icon and select your file.

   4. Change the file type to Excel, and then click OK.

   5. To verify that the document has been saved, right click the document name and then select View Images.

   6. Set up or update the export, using the Property Manager > System Administration > Export Setup path.

1. 7. If an export already exists for your community, delete the export.

   8. Create a new export using the Create New Export task.

   9. Select the community and funding program.

   10. Select Tax Credit Transmit FL in the Export Type field.

   11. In the Export Database Name field, enter Florida_TIC_report_macro.

   12. In the Export Server field, enter Florida_TIC_report.

   13. Select the Active check box.

   14. Click Finished.

   15. Build the LIHTC file using the Build LIHTC File task.

If you receive any errors when running the Build LIHTC File task, verify that the locations for the data file and Excel file are correct. If you continue to receive an error after this has been verified, try saving the files to a different location (such as your desktop), update the export, and try again.

When creating a Tax Credit Transmit Florida Export CSV File, the following columns should be completed:

• Funding Program - you can have a separate Tax Credit Transmit Export Type for each funding program of a community.

• Short Description - this column populates the Destination Column on the Occupancy and Compliance Detail > LIHTC tab

• Excluded Certtypes - NS, GR, SL, GP, VC, LC, RA, TM, XF, NR, NU

• • Certtypes to be excluded from the CSV file to be created.

Two other setup details that need to be taken care of before you can transmit a successful file:

• The formatting of the BIN entered at the Community Detail > Contract tab needs to exclude dashes.  This populates the BIN Number (Column 1).

• • For example if the BIN is NY-00-99999, it needs to be entered as NY0099999.

• The formatting of the Unit Nbr entered at the Unit Detail > General tab in the Tax Credit Unit Nbr column needs to exclude dashes.  This populates the Unit Number (Column 2).

• • If this column is left blank (null), then the CSV file will pull the Unit Nbr as the Building Number and Apt Number (for example, P-1234).