M2 Reporter Help
Contact Us
  • About M2R
  • Getting Started
    • Before You Begin
    • How To... >
      • Install M2R >
        • New Install of M2R
        • Updating M2R
      • Navigate
      • Import Data into M2R
      • Create and Send Your Metro 2 File
      • Add/Edit/Delete
      • Backup Data
  • What Is ...
    • Company Setup
    • Edit Account - Account
    • Edit Account - Outside Agencies
    • Edit Account - Customer
    • Edit Account - Customer Employment
    • Edit Account - Joint Customer
  • General Reporting Guidelines
    • Banking / Savings & Loan / Credit Union - Installment Loan & Line of Credit
    • Child Support Reporting
    • Credit Cards (non-Retail Cards)
    • Loan Finance Companies
    • Mortgage Lending
    • Residential Rental Reporting >
      • Multiple Tenant Situations
      • Vouchers, Subsidies, Rent Credits, Concessions
      • Lease Renewals
      • Post-lease Outstanding Balances
    • Third Party Collection Agency/Debt Purchaser/Factoring Company Reporting
    • Student Loan Reporters – Federal Loans
    • Student Loan Reporting
    • Utility Company Reporting
    • Consumer Dispute Process
  • FAQ
    • Accounts Included In Bankruptcy
    • Account Status, Payment Rating, Special Comment
    • Consumers Affected by Natural Disaters
    • Consumer Information
    • Cycle Reporting
    • Deleting Accounts/Borrowers
    • Delinquency Reporting
    • Duplicate Tradelines
    • ECOA Requirements
    • FCRA Requirements
    • First Time Reporters
    • What if we don’t currently capture data for a specific field in our system?
    • Reporting Scenarios >
      • FAQ 19 - How should deceased borrowers be reported?
      • FAQ 34 - How should charged off accounts be reported?
      • FAQ 38 - How should accounts that are paid in full for less than the full balance (i.e., settled) be reported?
      • FAQ 39 - How should a paid in full, closed account be reported?
      • FAQ 40 - How should a closed account be reported that has an outstanding balance?
      • FAQ 41 - How long should paid accounts (Account Status Codes 13, 61-65) continue to be reported?
      • FAQ 61 - How should an account be reported when merchandise has been repossessed?
      • FAQ 62 - How should an account be reported when merchandise has been repossessed?
  • Reference
    • Quick Reference Guides to Industry Standards >
      • Banking / Savings & Loan / Credit Union – Installment Loan & Line of Credit
      • Child Support Agencies
      • Credit Cards (non-Retail Cards)
      • Debt Buyers / Collection Agencies
      • Loan Finance Companies
      • Mortgage Lending
      • Point Of Sale
      • Retail Accounts (store exclusive)
      • Sales Finance Companies
      • Student Loan Reporters – Federal Loans
      • Student Loan Reporters – Private Loans
      • Utility Companies
    • Portfolio Type
    • Account Type Codes By Industry
    • Date of Account Information
    • Account Type Codes
    • Terms/Payment Amount Conversion to Monthly
    • Account Status Codes
    • Special Comment Codes by Portfolio
    • Special Comment Codes
    • Date of First Delinquency >
      • Fair Credit Reporting Act Excerpts
    • Consumer Information Indicators (bankruptcy codes)
    • Country Codes
    • General Rules for Address
    • State Codes
    • Compliance Condition Codes
  • Glossary
    • A - M
    • N - Z
  • M2 Reporter Home
  • M2 Reporter Contact
  • M2 Reporter Blog

Import Data into M2R

Importing requirements for M2R

The import feature in M2R can save you time by avoiding double data entry. The import feature can be used by customers who maintain their accounts in another software package/database, spreadsheet document or other .txt, .csv type files

To import your accounts into M2R the data file you are importing must be in a comma-delimited .txt or .csv format. For increased accuracy we highly recommend using a header record in your import file even though it is not required. If you use a header the field names need to match the import field names selected in the import setup. 

We suggest that you import at least the following information, which is required by the credit bureaus for reporting consumer accounts. Any information which is required by the credit bureau you are reporting to that is not imported into M2 Reporter will have to be manually entered. Highlighted fields are required by the M2R program for importing data into M2R. (Note:  actual field data can be imported as blank even for required fields and manually entered later if needed.)



    2. Fields Recommended for reporting Consumer Information
  • Account Number
  • Customer First Name
  • Customer Last Name
  • Customer Address Line (1)
  • Customer City
  • Customer State
  • Customer ZIP
  • Date Opened
  • Current Balance
  • Account Status (1)
  • Date of Account Info
  • Customer SSN
  • Customer DOB
  • ECOA Code (1)
  • Credit Limit
  • Scheduled Monthly Payment
  • Date Closed
  • High/Original Credit (Original loan amt)
  • Last Payment Amt (actual payment)
  • Date Closed
  • Payment Rating
  • Last Payment Date
  • Compliance Condition
  • Original Creditor (2)
  • Creditor Classification  (2)
  • Consumer Information Indicator
  • Terms Duration (3)
  • First Delinquency Date (2)
  • Past Due Amount
  • Original Charge-off Amount
(1)Can be setup as a default or a mapped code 
(2)Required for Collection Agencies
(3)Only for accounts with a portfolio type of Installment or Mortgage
    2. All available import fields
  • Reporting Company ID
  • Account Number
  • Account Type
  • Portfolio Type
  • Date Opened
  • Date of Account info
  • Date Closed
  • Credit Limit
  • High/Original Credit
  • Terms Frequency
  • Terms Duration
  • Scheduled Monthly Payment
  • Actual Payment Amount
  • Date of Last Payment
  • Account Status
  • Payment Rating
  • Current Balance
  • Amount Past Due
  • Special Comment
  • Compliance Condition
  • Original Charge-off Amount
  • Date of First Delinquency
  • Original Creditor Name
  • Creditor Class
  • Purchased Portfolio/Sold to Name
  • Portfolio Indicator
  • Mortgage Agency ID
  • Mortgage Account Number
  • Mortgage ID Number (MIN)
  • Specialized Payment Indicator
  • Deferred Payment Start Date
  • Specialized Payment Due Date
  • Specialized Payment Amount
  • Commercial Customer Name
  • Customer First Name
  • Customer Middle Name
  • Customer Last Name
  • Customer Name Suffix
  • Customer SSN
  • Customer DOB
  • Customer Home Phone
  • Customer Country
  • Customer Address Line 1
  • Customer Address Verified
  • Customer Address Line 2
  • Customer City
  • Customer State
  • Customer ZIP
  • Customer Residence Code
  • Customer Consumer Trans Type
  • Customer Consumer Info Indicator
  • Customer Occupation
  • Customer Employer
  • Customer Employer Address Line 1
  • Customer Employer Address Line 2
  • Customer Employer City
  • Customer Employer State
  • Customer Employer ZIP
  • Customer ECOA
  • Joint First Name
  • Joint Middle Name
  • Joint Last Name
  • Joint Name Suffix
  • Joint SSN
  • Joint DOB
  • Joint Home Phone
  • Joint Customer Same Address
  • Joint Country
  • Joint Address Line 1
  • Joint Address Line 2
  • Joint City
  • Joint State
  • Joint ZIP
  • Joint Residence Code
  • Joint Consumer Trans Type
  • Joint Consumer Info Indicator
  • Joint ECOA
    How do I import my accounts into M2R?

  1. Create your .txt or .csv file for import
  2. Open the M2R program
  3. Go to the Tools Menu
  4. Go to Import Accounts
  5. Select "From a Text File"
  6. In the Import File field type in the path for your import file or browse for it by clicking on the Browse... button
  7. Choose the file format, Delimited or Fixed Length
  8. Select the type of import; Add New Records, Update Existing or both.
  9. Click on the "Ignore First Line of Data" box if you are using a header record
  10. Select the fields you are importing from the Available Fields list on the left hand side. Note: if you are using a header record you don't have to worry about the order. If you are not using a header record the order of your Available Fields must be in the same order fields in your import file.
  11. Setup any Map Codes or Default Codes
  12. Click on Save Settings
  13. Click on Import

Using the "Map Codes" feature  

  • Setting Default Codes - If the value or code for a specific import field is the same for all of your accounts or if you have some accounts that have a blank value for a specific field you can set a default code.
                    1. In the Import Accounts setup click on the Map Codes button at the bottom of the scre
                    2. From the Code Category list choose the field you want to set the default code for
                    3. From the Default Value list choose the value you want the specified field to have
                    4. Click the Ok button at the bottom of the window 
  • Setting up Mapped Codes - If you have a value or code for a specific import field in your import file and it does not match the metro 2 value in M2R you will need to setup a mapping code for each value you are importing.
                    1. In the Import Accounts setup click on the Map Codes button at the bottom of the screen
                    2. From the Code Category list choose the field you want to set the mapped code for
                    3. You will now see a list of Metro 2 Codes and their descriptions in the middle of the window
                    4. To the far right will be a list called Your Code. This list is defaulted with the metro 2 code. For each code that you need to map, change the metro 2 code in the
​                        Your Code list to the code or description that you are using in your import file.
                    5. Click the Ok button at the bottom of the window
Powered by Create your own unique website with customizable templates.