Consumer Finance Late Payment Events

This dataset provides detailed records of overdue consumer finance payments, including payment amounts, overdue durations, categorized reasons for lateness, and collections process status. It enables comprehensive risk modeling, collections workflow optimization, and regulatory compliance analysis for financial institutions managing consumer credit portfolios.

  • last updated 21 Jul 2025
  • by GoMask
The brief that made it

Credit risk modeling and customer segmentation

Sample rows

preview · 8 of 200 rows · all 14 columns
event_idstringcollection_stagestringamount_duefloatcontacted_customerbooleanlate_payment_reasonstringcustomer_idstringaccount_idstringevent_datedatedue_datedatedays_overdueintegeramount_paidfloatpayment_statusstringcustomer_risk_scorefloatnotesstring
EVT00001none115.75falseforgot_to_payCUST001ACCT0012024-03-152024-03-123115.75paid15.2Customer forgot to pay, resolved quickly with no reminder.
EVT00002reminder_sent824.9trueinsufficient_fundsCUST002ACCT0022023-07-052023-06-22130unpaid56.8Customer contacted regarding insufficient funds, payment plan discussed.
EVT00003resolved49falsetechnical_issueCUST003ACCT0032022-09-192022-09-17249paid7.5Payment delayed due to app technical issue; resolved automatically.
EVT00004reminder_sent1250truemedical_emergencyCUST004ACCT0042021-12-112021-11-1130300partially_paid62.4Partial payment after medical emergency; customer expects to pay balance soon.
EVT00005in_collections3800truelost_jobCUST002ACCT0062022-02-222021-12-10740in_collections95.7Escalated to collections due to unemployment; no payments made.
EVT00006none120.06falseforgot_to_payCUST005ACCT0052023-04-172023-04-125120.06paid10.9Customer forgot to pay; paid in full after email reminder.
EVT00007reminder_sent650.5truemedical_emergencyCUST006ACCT0062021-05-042021-04-04300unpaid51Medical emergency reported; awaiting customer response.
EVT00008reminder_sent210trueinsufficient_fundsCUST007ACCT0072023-06-202023-06-101084partially_paid46.4Partial payment made due to insufficient funds; follow-up scheduled.

What the 200 rows show

from the 200-row sample

Legal_action (collection stage) stands out: mean amount_due is 10,850, against 792.0 for the rest.

  • 57%contacted_customer = true
  • 323.0median amount_due
  • 5payment statuses
  • 13.5median days_overdue
  • 45.0median amount_paid
  • 48.0median customer_risk_score
Mean amount_due by collection_stage200 rows
010k20k131.2none54 rows652.8remind…70 rows3,848in_col…21 rows10,850legal_…16 rows311.5resolv…39 rows
amount_due200 rows, in bands of 2,500
0851701691283301031012.5k25kamount_due →

Median 323.0, from 0.0 to 22,650.

late_payment_reason200 rows · 7 values
  1. forgot_to_pay49
  2. insufficient_funds33
  3. lost_job30
  4. dispute30
  5. technical_issue26
  6. medical_emergency21
  7. other11
14 columns by typefrom the column list below
  • string 7
  • integer 1
  • float 3
  • date 2
  • boolean 1

Columns

14 columns in four groups
blueprint · 14 columns
columntypedescriptionexample
Text 7 columns
event_idstringUnique identifier for each late payment eventuniqueEVT00001
customer_idstringUnique identifier for the customer associated with the late payment eventCUST001
account_idstringUnique identifier for the financial account related to the late paymentACCT001
payment_statusstringCurrent status of the overdue payment5 valuespaid
late_payment_reasonstringCategorized reason for the late payment7 valuesforgot_to_pay
collection_stagestringStage of the collections process for the overdue payment5 values · optionalnone
notesstringAdditional notes or comments regarding the late payment eventoptionalCustomer forgot to pay, r…
Numbers 4 columns
days_overdueintegerNumber of days the payment is overdue as of the event date1 or more3
amount_duefloatTotal amount that was due on the payment date0 or more115.75
amount_paidfloatAmount paid by the customer as of the event date (may be zero)0 or more115.75
customer_risk_scorefloatRisk score assigned to the customer at the time of the event (e.g., 0-1 or 0-100 scale)0 to 100 · optional15.2
Dates and times 2 columns
event_datedateDate when the late payment event was recorded2024-03-15
due_datedateOriginal due date for the payment2024-03-12
True or false 1 column
contacted_customerbooleanIndicates whether the customer has been contacted regarding the overdue paymentfalse

Use it for

  • contacted cust…57%114 of 200 rowsmean amount due by co…131.2none652.8remi…3.8kin_c…10.8klega…

    A finance dashboard

    The contacted_customer rate, amount_due by collection_stage and a breakdown of late_payment_reason. Excel, Power BI or Tableau.

  • Why do the 16 legal_action rows have a mean amount_due of 10,850?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable events with customer_id, account_id and event_date to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 14 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows14 columns
Yours1,000 rows14 columns

blueprint · consumer-finance-late-payment-events

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 14 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Account ID and payment date.
  • Days late and late fee.
  • Reason for delay coded.
  • Resolution status recorded.
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
consumer-finance-late-payment-events

What should your data show?

Preview 20 rows free
No signup. No card.