Data Imput Options

Data Input Options

One of the first steps in getting set up for online batch processing is to determine the data input method. Many options are available. One option is to input your data into an Excel spreadsheet and save as a space-delimited fixed-format file to send to TransUnion. Alternatively, customers can program for, and send in, fixed format inquiry (FFI) strings via the standard TransUnion inquiry input method (TU4.0/TU4.1).

For online batch processing, it is critical that the data be sent in a standard, consistent format for every submission. Use these tools to help create your file.

Some of these documents may require Adobe® Acrobat® Reader®. You can download the free Adobe Acrobat Reader software from the Adobe website.

Suggested Input Templates

Insert your data into the Excel 97-2003 or Excel 2007 spreadsheet template below. Except for the headers, the columns in these blank Excel files are the exact length required for a successful online batch transmission. After you create the spreadsheet, save it as a space-delimited, fixed-format file and submit it to TransUnion.
Last Updated: 01/30/2012
Suggested OLB data input rules and specifications for the OLB input template.
Last Updated: 12/30/2009
Excel 97-2003 version of standard spreadsheet template.
Last Updated: 02/14/2012
Excel 2007 and higher version of standard spreadsheet template.
Last Updated: 01/30/2012
OLB custom layout data input rules and specifications for the OLB input template.
Last Updated: 01/30/2012
OLB Portfolio Valuation 2.0 layout data input rules and specifications for the OLB input template.
Last Updated: 01/30/2012

Excel 97-2003 version of the OLB Portfolio Valuation Suggested Input Template.

Last Updated: 02/14/2012

Excel 2007 and higher version of the OLB Portfolio Valuation Suggested Input Template.

Last Updated: 02/14/2012
If you are anticipating to receive the Trans Recovery 3.0 score, then you will need to confirm if you need to use one of the input layout templates below. The special input format only applies to the Plus and No Hit versions of the score. The general score versions do not require this special format and therefore either this layout or the suggested standard input layout can be used.
Last Updated: 02/14/2012
Excel 97-2003 version of the Trans Recovery 3.0 All Industry Suggested Input Template.
Last Updated: 02/14/2012
Excel 2007 and higher version of the Trans Recovery 3.0 All Industry Suggested Input Template.
Last Updated: 02/14/2012
If you are anticipating to receive the Trans Recovery 3.0 score, then you will need to confirm if you need to use one of the input layout templates below. The special input format only applies to the Plus and No Hit versions of the score. The general score versions do not require this special format and therefore either this layout or the suggested standard input layout can be used.
Last Updated: 02/14/2012
Excel 97-2003 version of the Trans Recovery 3.0 Bankcard Suggested Input Template.
Last Updated: 02/14/2012
Excel 2007 and higher version of the Trans Recovery 3.0 Bankcard Suggested Input Template.
NEXT STEPS:
Print Text
Click to print page
Page Tools Divider
Font Text
Click to reduce font size
Click to increase font size
Content only available to subscribers
CONTACT US
Business
Phone
800-985-4208
Hours: 9am - 6pm EST

Billing Inquiries
Phone
866-810-2636
Hours: 8am - 5pm EST
Personal
Phone
800-916-8800
Hours: 8am – 8 pm EST