Welcome to the Utah Association of Counties TRECS's secure web portal for debt offset.
This portal enables Utah local governments to upload their debt data files to the UTRECS clearinghouse for potential offsets against the debtor’s personal state income tax refund through the Utah Utah Division of Finance. Other features allow local governments to download refund payment files and other reports and to update local agency contact information for debtor inquiry.
Participating local governments must have executed the UTRECS Memorandum of Understanding and submitted the registration form before uploading debt files. For more information, please visit the UTRECS website and contact UTRECS Program Administrator Zeke Lee.
Debt File Requirements:
County debt data files must conform to the UTRECS debt offset file layout standards. All column names must be included in the file in the correct order, even if no corresponding data exist. Columns designated R (Required) must include the corresponding data. The file layout provides the data definition and its required format.
Debt Refresh Requirements:
Counties should refresh their files at least weekly to reflect new debts or changes in debts by resubmitting the initial debt file in its entirety. Debt amounts should be reduced to reflect any debtor payments. Full repayments should reset the debt amount to $0—do not delete the debtor row. All rows remain in place until the end of the calendar year.
Debt Expiration Requirements:
If a county no longer wants to pursue a specific debt through offset, the county should enter a debt expiration date into the appropriate field. Do not delete the debtor row or reduce the debt to $0.
Debt File Requirements:
County debt data files must conform to the TRECS file layout standards. All column names must be included in the file in the correct order, even if no corresponding data exist. Columns designated R (Required) must include the corresponding data. The file layout provides the data definition and its required format.
Debt Refresh Requirements:
Counties should refresh their files at least weekly to reflect new debts or changes in debts by resubmitting the initial debt file in its entirety. Debt amounts should be reduced to reflect any debtor payments. Full repayments should reset the debt amount to $0—do not delete the debtor row. All rows remain in place until the end of the calendar year.
Debt Expiration Requirements:
If a county no longer wants to pursue a specific debt through offset, the county should enter a debt expiration date into the appropriate field. Do not delete the debtor row or reduce the debt to $0.
Welcome to the Utah Association of Counties TRECS's secure debt offset file upload site.
This page enables Utah local governments to upload their debt data files to the UTRECS clearinghouse for potential offsets against the debtor’s personal state income tax refund and/or state lottery winnings through the Utah Utah Division of Finance.
Please identify the location of the debt data file you would like to upload and ensure that it is in the appropriate format for uploading. Please visit the UTRECS website for format instructions. Please note that your file must be in this exact format, e.g. column names, order, data structure, or your file will fail to process.
Debt File Requirements:
County debt data files must conform to the UTRECS debt offset file layout standards. All column names must be included in the file in the correct order, even if no corresponding data exist. Columns designated R (Required) must include the corresponding data. The file layout provides the data definition and its required format.
Debt Refresh Requirements:
Counties should refresh their files at least weekly to reflect new debts or changes in debts by resubmitting the initial debt file in its entirety. Debt amounts should be reduced to reflect any debtor payments. Full repayments should reset the debt amount to $0—do not delete the debtor row. All rows remain in place until the end of the calendar year.
Debt Expiration Requirements:
If a county no longer wants to pursue a specific debt through offset, the county should enter a debt expiration date into the appropriate field. Do not delete the debtor row or reduce the debt to $0.
Click on the "Browse..." button to select the data file for upload. Please note that this file will be on your local government’s network or locally on your PC.
Once the file is selected, click on the “Upload” button to upload. Successful uploads will generate an automatic email confirmation to the email with which you are logged in. Failed uploads will also generate an automatic email. Please expect the confirmation within 15 minutes.
Please note that we are experiencing JavaScript incompatibility issues with Microsoft Internet Explorer and ask that files be uploaded via another browser.
If you are experiencing trouble uploading your file or are having technical issues, please call (877) 265-4770.
Welcome to the Utah Association of Counties TRECS's secure debt file download site.
This page enables Utah local governments to download their debt payment and other data files generated by the UTRECS clearinghouse.
Files are labeled by type and run date, with the latest files listed first.
Please note that an individual file will be available at this download site for up to 30 days after its run date.
To download to your local PC, please select the data file for download and follow your browser’s instructions.
If you are experiencing trouble downloading your file or are having technical issues, please call (877) 265-4770.
Files available for download: