Standard 15 Day Import Format

The first line of the CSV file will be ignored. It is reserved for a column heading. Any errors on data upload should result in all data being rejected and the user receiving an error that helps them correct and fix the data problem in their CSV file. Click here to download sample file

Column 1 - Account Number

  • A unique identifier that is no more than 100 characters long which uniquely identifies the debtor in the creditor's system.
  • 100 characters or less
  • Must be present

Column 2 - Company Name

  • The name of the company, should be consistent across uploads
  • 100 characters or less
  • Must be present

Column 3 - MC Number

  • A unique identifier for trucking companies.
  • 6 digits
  • Optional

Column 4 - Phone Number

  • The contact phone number if you wanted to call this company
  • 10 characters exactly
  • Optional

Column 5 - Fax Number

  • The contact fax number if you wanted to fax this company
  • 10 characters exactly
  • Optional

Column 6 - Address Line 1

  • The first line of the physical address of the company
  • 100 characters or less
  • Optional

Column 7 - Address Line 2

  • The second line of the physical address of the company
  • 100 characters or less
  • Optional

Column 8 - City

  • The city of the company's physical address.
  • 100 characters or less
  • Optional

Column 9 - State

  • The state of the company's physical address.
  • 2 characters exactly
  • Optional

Column 10 - Postal Code

  • The 12 character postal code for the company's physical address.
  • 12 characters or less
  • Optional

Column 11 - Country

  • The country of the company's physical address.
  • 2 characters exactly
  • Optional
  • This is the ISO-3166 country code as listed here: http://www.iso.org/iso/english_country_names_and_code_elements

Column 12 - Attention

  • The department or person within the company who mail should be addressed to.
  • 100 characters or less
  • Optional

Column 13 - Mailing Address Line 1

  • The first line of the address if something were to be mailed to this company
  • 100 characters or less
  • Optional

Column 14 - Mailing Address Line 2

  • The second line of the address if something were to be mailed to this company
  • 100 characters or less
  • Optional

Column 15 - Mailing City

  • The city that would show up in the address if something were to be mailed to this company
  • 100 characters or less
  • Optional

Column 16 - Mailing State

  • The state that would show up in the address if something were to be mailed to this company
  • 2 characters exactly
  • Optional

Column 17 - Mailing Postal Code

  • The 12 character postal code that would show up in the address if something were to be mailed to this company
  • 12 characters or less
  • Optional

Column 18 - Mailing Country

  • The country associated with the address if something were to be mailed to this company
  • 2 characters exactly
  • Optional
  • This is the ISO-3166 country code as listed here: http://www.iso.org/iso/english_country_names_and_code_elements

Column 19 - Accounts Receivable days 1-15 owed as of the first of the month

  • The dollar amount that is owed during this period as of the first few days of the month when the data is uploaded
  • Must be present

Column 20 - Accounts Receivable days 16-30 owed as of the first of the month

  • The dollar amount that is owed during this period as of the first few days of the month when the data is uploaded
  • Must be present

Column 21 - Accounts Receivable days 31-45 owed as of the first of the month

  • The dollar amount that is owed during this period as of the first few days of the month when the data is uploaded
  • Must be present

Column 22 - Accounts Receivable days 46-60 owed as of the first of the month

  • The dollar amount that is owed during this period as of the first few days of the month when the data is uploaded
  • Must be present

Column 23 - Accounts Receivable days 61-75 owed as of the first of the month

  • The dollar amount that is owed during this period as of the first few days of the month when the data is uploaded
  • Must be present

Column 24 - Accounts Receivable days 76-90 owed as of the first of the month

  • The dollar amount that is owed during this period as of the first few days of the month when the data is uploaded
  • Must be present

Column 25 - Accounts Receivable owed past 91 days as of the first of the month

  • The dollar amount that is owed during this period as of the first few days of the month when the data is uploaded
  • Must be present