Uploading Files in PrecisionTrack™

Option 2

I am tracking every piece of my mailing (ROUND-TRIP) and would prefer to download a range of numbers to create my own IM™BC.

TrackItBack Pro™(TIB Pro) utilizes the Intelligent Mail® barcode to provide round trip tracking. A unique tracking ID is used to define inbound and outbound tracking on the same job.Files being uploaded for TIB Pro should appear in the format specified below. Field sizes shown are the maximum field size accepted. The columns must be either tab or comma delimited (.txt or csv). Fixed length files will not be accepted.

Fields 1- 3and24-25are required for round trip tracking.

The additional fields such as name, address, etc., are optional but if uploaded will be available for viewing in our Single Piece report in addition to other reports such as the Turn Around Payment Analysis and Revenue Anticipation reports.

Please note that optional fields (through Field 25) must be represented, even if they are not populated. You may use headers in your uploaded file. If the file uploaded includes a header record, the header labels used must include at least one of the following values for validation: (CustomerUniqueIdentifier, POSTNET™, Onecode, IMB, City, State or ZIP).

Column / Type / Max Size / Required/Optional
Customer Unique Identifier / Alpha/Num / 20 / Required
Outbound POSTNET™ / Numeric / 11 / Recommended*
IM™BC (left 20 chars, excludes POSTNET™) / Numeric / 20 / Required
Greeting / Alpha/Num / 10 / Optional
First Name / Alpha / 50 / Optional
Middle Initial / Alpha / 2 / Optional
Last Name / Alpha / 50 / Optional
Suffix / Alpha / 10 / Optional
Full Name / Alpha / 100 / Optional
Company / Alpha / 50 / Optional
Title / Alpha / 50 / Optional
Address 1 / Alpha/Num / 128 / Optional
Address 2 / Alpha/Num / 128 / Optional
City / Alpha / 50 / Optional
State / Alpha / 2 / Optional
ZIP Code™ / Numeric / 10 / Optional
User Defined 1 / Alpha/Num / 100 / Optional
User Defined 2 / Alpha/Num / 100 / Optional
User Defined 3 / Alpha/Num / 100 / Optional
PT-JobId / Numeric / 8 / Optional * required for separate FTP uploads only
Revenue Amount / Numeric / 12 / Optional – $0.00
UserDefinedNumeric / Alpha/Num / 12 / Optional Future Use
UserDefinedDate (Billing Due Date) / Numeric / 12 / Optional - MM/DD/YYYY
TIB IM™BC / Numeric / 31 / Required
Inbound POSTNET™ / Numeric / 9 or 11 / Required - Reply address/Return address POSTNET™

* Records that are uploaded without a value in the POSTNET™ field will not be included in any reports driven by ZIP Code (i.e. State, ZIP3, ZIP5, etc). This will result in the reports appearing to be out of balance.

TrackItBack Pro™ Upload File field descriptions

Revenue Amount – The total amount of revenue in dollars the inbound mail piece represents. This field is required if you will be using the Revenue Anticipation Report.

UserDefined Numeric – Leave blank for future use.

UserDefinedDate (Billing Due Date)– The due date of the bill or invoice for the inbound mail piece.

TIB IM™BC– All 31 characters of the inbound Intelligent Mail® barcode.

Inbound POSTNET™ – If multiple inbound POSTNET™’s are used then each record should have a POSTNET™ entered for each inbound piece.Note: The POSTNET™ uploaded must match the reply address POSTNET™(s) that were entered when the job was ordered. An inbound POSTNET™ must be 9, or 11 digits. Do not include check digits.

Click here to see a sample files:
Uploaded data (simple format). (TIBPro Roundtrip Simple format no encode.xls)
Uploaded data extended format with mailing detail data. (TIBPro Roundtrip Extended format no encode.xls) (Insert a sample file for the simple and extended formats)

Note: If the example file is used as a template, please save the upload file as a text tab-delimited file prior to uploading

Uploading the File

  1. Create a tab-delimited or Comma delimited file as specified
  2. Save your file locally as a .txt or .csv file
  3. Click on the "Uploads" tab in your account
  4. Select the option “Replace existing data with the new data in this file” or “Append to existing information with the data in this file”. Use the “Replace” option if this is the first file you are uploading.
  5. Check the box “File includes TrackItBack Data”
  6. Check the box “Do Not Create Encode File”
  7. Select the job name from the drop down list of jobs
  8. Browse for your file and select it
  9. Enter the email address where all email notifications for file uploads and the encoded file downloads will be sent
  10. Click the Upload File button at the bottom of the screen
  11. Your upload is complete

IMPORTANT- You may revise this data at any time by uploading a modified file and selecting the replace option. This will replace the existing information.

You will receive an email from fter you upload your file. This will indicate a successful upload, or notify you of any problem.

If you need assistance, please contact Customer Service at (888) 444-9972 Option 1

© 2010, Pitney Bowes Inc.1 - 3