Metro 2® Furnisher Upload Guide

    Complete interactive guide for Metro 2® file format specifications

    Template File Available

    Download our Metro 2® template file to get started with data preparation. This template includes all required fields and serves as a foundation for populating your data.

    Download Template

    1. File-level Rules

    RuleRequirement
    EncodingUTF-8 (no BOM)
    DelimiterComma or tab – stay consistent
    Header rowMust match the column names & order in §§ 2-3
    Date formatYYYYMMDD (8 digits) – no slashes or dashes
    Money / limitsWhole dollars only; negatives with a leading "-"
    BlanksIf a field is "not applicable," leave it empty (never "N/A", "null", etc.)
    Submission cadenceTransmit one file per month after the billing cycle closes; include every open tradeline each month

    2. Fields That Can Be Inferred or Auto-Calculated

    Our system can automatically calculate or infer many fields based on the data you provide, reducing the burden of manually populating every field. The table in section 3 indicates which fields have inference capabilities with notes marked as "(see §2)".

    Payment-Related Fields

    • Scheduled Payment Amount: Calculated from loan amount, duration, and frequency
    • Actual Payment Amount: Defaults to scheduled amount for current accounts

    Status Fields

    • Account Status: Inferred from days past due when blank
    • Payment Rating: Auto-set when required by status
    • Payment History: Generated from account age and delinquency timing

    Data Parsing & Formatting

    • Name Fields: Parsed from full name when individual fields missing
    • Address Components: Intelligently parsed from full address
    • Phone Numbers: Auto-formatted and cleaned
    • ZIP Codes: Formatted and padded as needed

    Credit & Delinquency

    • Credit Limit/Highest Credit: Synchronized when one is zero
    • Amount Past Due: Auto-corrected for current/paid accounts
    • Date of First Delinquency: Calculated from days past due

    Note: This inference system ensures data completeness while maintaining Metro 2® compliance, reducing the burden on clients to provide every field when the data can be logically derived from other fields.

    3. Core / Base Segment Layout (Fields 5 – 46)

    Type key: N = numeric, A = alpha, AN = alphanumeric, ANS = alphanumeric + space

    Required* = required except where CRRG expressly allows blank

    Field Requirements:

    RequiredMust be provided in all cases
    ConditionalRequired under specific circumstances
    OptionalMay be omitted if not applicable
    #Column NameLen/TypeRequirementAccepted Values & Meaning
    5IdentificationNumber≤20 ANRequired
    Unique furnisher/branch ID; must remain constant
    6CycleIdentifier2 ANConditional
    Report only if you break reporting into multiple cycles (e.g. "01", "17")
    7ConsumerAccountNumber≤30 ANRequired
    Exact account # as on the statement (tokenised OK)
    8PortfolioType1 ARequired
    C I M O R – Line of Credit, Installment, Mortgage, Open, Revolving
    9AccountType2 ANRequired
    Full list of >100 codes
    10DateOpened8 NRequired
    Original open date – never future
    11CreditLimit9 NR*
    Whole-dollar limit for C/M/R/O; else 0 (Can be auto-synchronized with Highest Credit - see §2)
    12HighestCreditOrOrigLoanAmt9 NRequired
    Highest balance ever (LOC/REV) or original principal (Install/Mtg) (Can be auto-synchronized with Credit Limit - see §2)
    13TermsDuration3 ANRequired
    Months (001-999) or constants LOC, REV, 001 (Open)
    14TermsFrequency1 ARequired
    D P W B E M L Q T S Y
    15ScheduledPaymentAmt9 NConditional
    Contractual payment this period; 0 for Open portfolios (Can be auto-calculated - see §2)
    16ActualPaymentAmt9 NOptional
    Whole-dollar payment received this period (Can be auto-inferred for current accounts - see §2)
    17AccountStatus3 ANRequired
    Full CRRG list (Can be auto-inferred from Days Past Due - see §2)
    18PaymentRating1 AConditional
    Required only with final or derogatory statuses; 0-6,G,L as defined (Auto-set when required - see §2)
    19PaymentHistoryProfile24 ANOptional
    24-month string (0-6,B,D,E,G,H,J,K,L) – newest at left (Can be auto-generated - see §2)
    20SpecialComment2 ANOptional
    Two-char codes
    21ComplianceConditionCode2 AOptional
    XA-XR
    22CurrentBalance9 NRequired
    Outstanding balance as-of field 24
    23AmountPastDue9 NConditional
    >0 when Status is late/derog; must be 0 if Status 11 or 13 (Auto-corrected - see §2)
    24OriginalChargeoffAmt9 NConditional
    Required only if Status 97
    25DateOfAccountInfo8 NRequired
    Cycle closing date ("as of")
    26FCRA_DOFI8 NConditional
    Date of first delinquency leading to CO/Collection (Can be auto-calculated - see §2)
    27DateClosed8 NConditional
    Required if Status 13 or any final 60-day+ status
    28DateLastPayment8 NOptional
    Most recent payment date (Defaults to Date Opened - see §2)
    29InterestType1 AOptional
    F Fixed, V Variable
    30Surname25 ANSRequired
    Primary consumer last name (Can be parsed from full name - see §2)
    31FirstName15 ANSRequired
    (Can be parsed from full name - see §2)
    32MiddleName15 ANSOptional
    (Can be parsed from full name - see §2)
    33GenerationCode1 AOptional
    J S 1-9 (Jr, Sr, III…)
    34SSN9 NR*
    Zero-fill if unknown
    35DateOfBirth8 NConditional
    00000000 if unknown; required for ECOA 3 (Becomes required when SSN invalid - see §2)
    36PhoneNumber10 NOptional
    Digits only (Auto-formatted - see §2)
    37ECOACode1 ARequired
    1 2 3 5 7 T X W Z
    38ConsumerInfoIndicator2 ANOptional
    A-H,1A,Q,R,V,2A,S,T,U
    39CountryCode2 AR*
    US or any CRRG code
    40Address130 ANSRequired
    (Can be parsed from full address - see §2)
    41Address230 ANSOptional
    (Can be parsed from full address - see §2)
    42City20 ANSRequired
    (Can be parsed from full address - see §2)
    43State2 ARequired
    USPS plus territories (Can be parsed from full address - see §2)
    44PostalCode11 ANRequired
    ZIP + 4 allowed (no dash) (Auto-formatted - see §2)
    45AddressIndicator1 ARequired
    C M U (Complete, Military, Foreign)
    46ResidenceCode1 NOptional
    0 Undesignated, 1 Own, 2 Rent

    5. Appendices – Full Code Lists

    Comprehensive Bankruptcy Reporting Guide

    1. Key Fields for Bankruptcy Reporting

    Consumer Information Indicator (CII) - Field 38

    Petition Filed:

    • A = Chapter 7 petition filed
    • B = Chapter 11 petition filed
    • C = Chapter 12 petition filed
    • D = Chapter 13 petition filed

    Discharged/Completed:

    • E = Chapter 7 discharged
    • F = Chapter 11 discharged
    • G = Chapter 12 discharged/completed
    • H = Chapter 13 discharged/completed

    Other BK Events:

    • Q = Removal (removes petition indicator)
    • R = Chapter 7 reaffirmation of debt
    • V = Chapter 7 reaffirmation rescinded
    • 2A = Lease assumption

    ECOA Code - Field 10

    • T = Terminate non-filer protected by stay (do not report during stay/plan)
    • Z = Delete authorized users on accounts in petition
    • Resume with real ECOA (1, 2, etc.) when protection ends, not T

    Account Status - Field 17A

    • Keep reporting; use petition-time status or as-of DOI depending on scenario
    • Ch 7/11: Report status as of Date of Account Information (FAQ 27c/d)
    • Ch 12/13: Report petition-time status until plan confirmed (FAQ 28)

    Payment History Profile - Field 21

    • Report "D" in first (leftmost) position for each month the stay is in effect
    • Never remove historic "D" markers (even if BK converts or is dismissed)
    • Continue incrementing "D" monthly during stay/plan period

    Date of First Delinquency (DOFD) - Field 25

    • If current when included in Ch 7: DOFD = Bankruptcy Petition Date
    • If already delinquent before BK: Keep original DOFD
    • Ch 12/13 converting to Ch 7 with Status 11: Keep original Ch 12/13 petition date

    2. Reporting Scenarios

    A) Chapter 7 or 11 - All Borrowers are Filers (FAQ 27c)

    Month BK Filed:

    • CII: A (Ch 7) or B (Ch 11)
    • Account Status: As of DOI (not necessarily petition-time)
    • Payment History: First character based on prior month's status
    • Current Balance/Scheduled Payment/Amount Past Due: As of DOI
    • Authorized Users: Delete (ECOA = Z)

    Between Petition and Resolution:

    • CII: A/B or blank (retain prior value)
    • All other fields: As of DOI each month

    Discharged:

    • CII: E (Ch 7) or F (Ch 11)
    • All fields: As of DOI
    • After reporting E/F, stop reporting filer(s)

    Reaffirmation:

    • CII: R (Ch 7 reaffirmation) or 2A (lease assumption)
    • If BK later discharged but reaffirmation remains: Do NOT report discharge
    • Keep reporting as reaffirmed

    Dismissed/Withdrawn:

    • CII: Q (removal)
    • Keep reporting other fields as of DOI
    • Do NOT remove prior "D" markers from Payment History

    B) Chapter 7 or 11 - One Filer + One Non-Filer (FAQ 27d)

    General Rules:

    • Non-Filer protected by stay → ECOA = T (terminate)
    • Do NOT report Non-Filer while stay applies
    • Authorized users must be deleted (ECOA = Z)

    Month BK Filed:

    • CII: A/B for Filer, blank for Non-Filer
    • Account Status/Balance/Scheduled/Past Due: As of DOI

    Discharged:

    • CII: E/F for Filer, blank for Non-Filer
    • After E/F, stop reporting Filer

    C) Chapter 12 or 13 - Plan Bankruptcy (FAQ 28)

    C1) All Filers (FAQ 28b):

    Month BK Filed:

    • CII: C (Ch 12) or D (Ch 13)
    • Account Status: Status at time of petition
    • Payment History: First character based on previous month
    • Current Balance/Scheduled/Past Due: Petition-time values

    Plan Confirmed:

    • Switch to plan terms for filer(s)
    • Current Balance: Plan balance (declines as paid)
    • Amount Past Due: 0
    • Terms Duration/Frequency: Update to plan
    • Scheduled Monthly Payment: Plan payment
    • DOI: Current month

    Plan Completed - No Further Obligation:

    • CII: G/H (Ch 12/13 completed)
    • Current Balance/Scheduled/Past Due: 0
    • After G/H, stop reporting filer(s)

    Plan Completed - Consumer Keeps Paying:

    • CII: Q (removal)
    • Payment History: First month "D", then normal increments
    • Continue reporting tradeline

    Conversion to Ch 7:

    • CII: A (petition) or E (discharged)
    • If Status 11: Keep original Ch 12/13 petition date in DOFD
    • Continue under FAQ 27 rules

    C2) Mixed: One Filer + One Non-Filer (FAQ 28d):

    Special Rules:

    • Filer: Report with CII codes as above
    • Non-Filer: Do NOT report during protected period (ECOA = T)
    • When protection ends: Resume with real ECOA (not T)
    • First month back: Set Payment History first position to "D"

    3. Quick Implementation Checklist

    If BK petition filed (Ch 7/11):

    → CII A/B; Status & monetary fields as of DOI; Payment History "D" during stay; Delete AU (ECOA Z)

    If BK petition filed (Ch 12/13):

    → CII C/D; Status = petition-time; Balance/Past-Due/Scheduled at petition values; Increment "D" monthly

    If Non-Filer protected:

    → ECOA = T, do not report during protection; Resume with real ECOA when protection ends

    If Discharge (Ch 7/11):

    → CII E/F, then stop reporting filer

    If Plan Completed (Ch 12/13) - No obligation:

    → CII G/H, Balance/Scheduled/Past-Due = 0, stop reporting filer

    If Plan Completed (Ch 12/13) - Payments continue:

    → CII Q, first month "D", then normal status increments

    If Reaffirmation (Ch 7):

    → CII R (or 2A for lease); Do NOT send E/F if BK discharges

    If BK dismissed/withdrawn:

    → CII Q; Keep other fields as of DOI; Do NOT remove prior "D" months

    If Ch 12/13 converts to Ch 7:

    → CII A/E; Keep DOFD if Status 11; Continue under Ch 7 rules

    ⚠️ Critical Implementation Notes

    • • Never remove historic "D" markers from Payment History Profile
    • • Always delete Authorized Users (ECOA = Z) when account enters bankruptcy
    • • Non-Filers protected by stay must use ECOA = T (not reported)
    • • Reaffirmed debts continue reporting even if bankruptcy is discharged
    • • Plan values replace original terms in Ch 12/13 after confirmation
    • • FAQ references: 27(c) and 27(d) for Ch 7/11; 28(b) and 28(d) for Ch 12/13

    Using the File

    1. Validate header, required fields and value sets (Appendices) before ingest.
    2. Apply cross-field edits (e.g., Portfolio ↔ AccountType, Status ↔ AmountPastDue) per CRRG Exhibit 15.
    3. Transform each row into a 426-byte Base segment and add J/K/L/N segments when their lead fields are non-blank.
    4. Pad & wrap the batch with Metro 2 Header/Trailer prior to CRA submission.

    Note: This single guide contains every Metro 2 field your customers could send (Base + all optional segments), with clear Required/Conditional/Optional tags and exhaustive value lists referenced in the appendices.