You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
Home > Import/Export > Bulk Import: Delinquent Property Taxes field mapping
Bulk Import: Delinquent Property Taxes field mapping
print icon

When using the Property Tax Template from the Utilities area to do bulk imports of delinquent property taxes, you will notice that there are certain columns that are highlighted in yellow on the template. These columns are the only ones that will map to the Tracking > Property Taxes area. In this article, we will show where each of these highlighted fields is mapped to the Ventures screen.


Column Name Ventures Field
Loan ID

SBA Loan Number/Loan Number

(NOTE: This is the identifier used to match the Excel with the correct project in Ventures)


Contract Number

Tax ID Comments: Parcel Number
DLQ (D or P)


D = Delinqent

P = Current

Delq Amt Amount Due
Year Range Tax Period Year
Search Tax Report Date
Note Code Short Desc Comments: Import Notes
Crit Msg Comments: Critical Message


















NOTE: The three columns for Tax ID, Note Code Short Desc and Crit Msg will all combine into one Comment in Ventures.


0 out of 0 found this helpful

scroll to top icon