field_block:node:page:title

Certificate of Rent Paid (CRP) File Formats

field_block:node:page:body

You can import Certificate of Rent Paid (CRP) information into e-Services from a spreadsheet. Use the information and documents on this page to help you create the spreadsheet.

CRP Import File Blank Template (XLS)
CRP Example Import File (XLS)

field_block:node:page:field_paragraph

Formatting and Field Details [+]

Use this table to learn how to format the data in each column. Required fields are marked with an asterisk below.

You can also view or download this information in a spreadsheet: CRP Schema (XLS)

Field Name [Column]	Notes
Owner (True/False) [A] *	Enter "TRUE" if you are the property owner, otherwise "FALSE"
Owner First and Last Name [B] *
Owner Address [C]*
Owner City [D]*
Owner State [E]*	Capitalized two letter state abbreviation
Owner Zip [F]*	5 digits
Owner Phone [G]*	10 digit phone number including area code
Adult Foster Care (True/False) [H]*	Enter "TRUE" if the property is part of an Adult Foster Care facility, otherwise "FALSE"
Assisted Living (True/False) [I]*	Enter "TRUE" if the property is part of an Assisted Living facility, otherwise "FALSE"
Intermediate Care (True/False) [J]*	Enter "TRUE" if the property is part of an Intermediate Care facility, otherwise "FALSE"
Nursing Home (True/False) [K]*	Enter "TRUE" if the property is part of a Nursing Home facility, otherwise "FALSE"
Mobile Home (True/False) [L]*	Enter "TRUE" if the property is a Mobile Home, otherwise "FALSE"
Mobile Home Lot (True/False) [M]*	Enter "TRUE" if the property is a Mobile Home Lot, otherwise "FALSE"
Property ID [N]*
Number of Units on This Property [O]*
Renter Last Name [P]*
Renter First Name [Q]*
Renter Middle Initial [R]	One letter
Rental Address [S]*
Rental Unit [T]
Rental City [U]*
Rental State [V]*	Capitalized two letter state abbreviation
Rental Zip [W]*	5 digits
Rental County [X]*	Must be a valid Minnesota county
Rented From [Y]*
Rented To [Z]*
Total Months Rented [AA]*	##.## (Can be decimal, for example 11.25 or integer, for example, 6)
Number of Adults [AB]*
Medical Assistance (True/False) [AC]*	If the renter received Medical Assistance, enter "TRUE", otherwise "FALSE"
Medical Assistance Amount [AD]	Amount of Medical Assistance received.
Housing Support (True/False) [AE]*	If the renter received Housing Support, enter "TRUE", otherwise "FALSE"
Housing Support Amount [AF]	Leave blank for 2024 CRPs. For 2023 and earlier, enter amount of Housing Support received.
Renter's Share of Rent Paid [AG]	If blank, this will be entered as $0.
Caretaker Reduction [AH]	If blank, this will be entered as $0.
Total Rent Paid [AI]	If blank, this will be entered as $0. Should equal "Renters share of rent paid" + "Caretaker Reduction."
Managing Agent First and Last Name [AJ]	If you are a managing agent, enter your name. Otherwise, this can be left blank.
Managing Agent Phone Number [AK]	If you are a managing agent, enter your 10 digit phone number including area code. Otherwise, this can be left blank.

Contact Info

Email

Contact form

Phone

Hours [+]

Address [+]

field_block:node:page:field_last_updated

Last Updated

November 18, 2024

Certificate of Rent Paid (CRP) File Formats

Contact Info

Related Content