Customer Payment History and Credit Scoring

This dataset provides a detailed record of subscriber payment transactions, invoice histories, payment methods, late payment incidents, collections status, deposit requirements, and credit scores for postpaid eligibility. It enables comprehensive analysis of customer financial behavior, risk assessment, and credit management for telecommunications or finance providers.

  • opened 8 times
  • last updated 1 Nov 2025
  • by GoMask
The brief that made it

Credit risk assessment and postpaid eligibility analysis

Sample rows

preview · 8 of 100 rows · all 24 columns
customer_idstringcollection_statusstringinvoice_amountfloatis_late_paymentbooleanaddress_countrystringfull_namestringemailstringphone_numberstringaddress_streetstringaddress_citystringaddress_statestringaddress_postal_codestringinvoice_idstringinvoice_datedateinvoice_due_datedatepayment_idstringpayment_datedatetimepayment_amountfloatpayment_methodstringlate_payment_daysintegerdeposit_requiredbooleandeposit_amountfloatcredit_scoreintegerpostpaid_eligibleboolean
CUST0012Anone109.99falseUSAJessica Chenjessica.chen87@mail.com+14159273012152 Market StSan FranciscoCA94105INV0001A2024-04-042024-04-19PAY0001A2024-04-18T14:23:00109.99credit_card0false0802true
CUST0029Bnone67.5trueUKMohammed Iqbalmiqbal23@webmail.net+44796500839334 King StLondonLondonEC2V 8EHINV0002B2024-03-112024-03-26PAY0002B2024-03-29T11:43:0067.5bank_transfer3false0710true
CUST0036Cnone120falseAustraliaHelen G. Alvarezhelen.alvarez@alvarez.org+6123456789021 Oxford RdSydneyNSW2000INV0003C2024-05-032024-05-18PAY0003C2024-05-18T09:15:00120auto-pay0false0776true
CUST0043Dnone89.95trueUSASamuel Richardsonsam.richardson@gmail.com+1202555014388 BroadwayNew YorkNY10007INV0004D2024-01-152024-01-30PAY0004D2024-02-08T10:33:0089.95credit_card9false0733true
CUST0058Enone74.5trueItalyIsabella Rossiisabella.rossi@libero.it+39069876543Via Roma 45RomeRM00184INV0005E2024-02-222024-03-09PAY0005E2024-03-12T13:22:0074.5debit_card3false0625true
CUST0066Fnone100falseSingaporeKaren Leekaren.lee@outlook.com+658123456710 Orchard RdSingaporeSG238840INV0006F2024-04-212024-05-06PAY0006F2024-05-06T16:05:00100auto-pay0false0799true
CUST0071Gnone79.99trueUSALeonard Fosterlfoster@fosternet.com+1617555123477 Beacon StBostonMA02108INV0007G2024-05-282024-06-12PAY0007G2024-06-13T09:44:0079.99credit_card1false0745true
CUST0089Hnone95.25falseFranceChloe Duboisc.dubois@orange.fr+3312345678927 Rue LafayetteParisIDF75009INV0008H2024-03-202024-04-04PAY0008H2024-04-04T10:00:0095.25bank_transfer0false0768true

What the 100 rows show

from the 100-row sample
  • 40%is_late_payment = true
  • 89.3median invoice_amount
  • 5payment methods
  • 89.3median payment_amount
  • 0median late_payment_days
  • 0median deposit_amount
collection_status100 rows by value
05010097none97%1in_colle…1%1resolved1%1written_…1%
invoice_amount100 rows, in bands of 20
02550226481353101140140240invoice_amount →

Median 89.3, from 54.7 to 220.2.

address_country100 rows · top 10 of 25 values
  1. USA22
  2. UK6
  3. France6
  4. Russia6
  5. UAE5
  6. Spain5
  7. Germany5
  8. Mexico5
  9. Italy4
  10. Sweden4
24 columns by typefrom the column list below
  • string 13
  • integer 2
  • float 3
  • date 2
  • datetime 1
  • boolean 3

Columns

24 columns in four groups
blueprint · 24 columns
columntypedescriptionexample
Text 13 columns
customer_idstringUnique identifier for each subscriber/customeruniqueCUST0012A
full_namestringFull legal name of the customerJessica Chen
emailstringCustomer's email addressuniquejessica.chen87@mail.com
phone_numberstringCustomer's primary contact phone numberoptional+14159273012
address_streetstringCustomer's street addressoptional152 Market St
address_citystringCustomer's cityoptionalSan Francisco
address_statestringCustomer's state or provinceoptionalCA
address_postal_codestringCustomer's postal or ZIP codeoptional94105
address_countrystringCustomer's countryoptionalUSA
invoice_idstringUnique identifier for each invoiceuniqueINV0001A
payment_idstringUnique identifier for each payment transactionuniquePAY0001A
payment_methodstringMethod used for payment (auto-pay, credit card, bank transfer, etc.)6 valuescredit_card
collection_statusstringCurrent status regarding collections (none, in_collection, resolved, written_off)none · in_collection · resolved · written_offnone
Numbers 5 columns
invoice_amountfloatTotal amount billed in the invoice0 or more109.99
payment_amountfloatAmount paid in the transaction0 or more109.99
late_payment_daysintegerNumber of days payment was late (0 if on time)0 or more · optional0
deposit_amountfloatAmount of security deposit required (0 if not required)0 or more · optional0
credit_scoreintegerCustomer's credit score used for postpaid eligibility300 to 850802
Dates and times 3 columns
invoice_datedateDate the invoice was issued2024-04-04
invoice_due_datedateDate the invoice payment is due2024-04-19
payment_datedatetimeDate and time the payment was made2024-04-18T14:23:00
True or false 3 columns
is_late_paymentbooleanIndicates if the payment was latefalse
deposit_requiredbooleanIndicates if a security deposit is required for the accountfalse
postpaid_eligiblebooleanIndicates if the customer is eligible for postpaid services based on credit score and payment historytrue

Use it for

  • is late payment40%40 of 100 rowsmean invoice amount b…93.1none62.4in_c…156.7reso…155.0writ…

    A finance dashboard

    The is_late_payment rate, invoice_amount by collection_status and a breakdown of address_country. Excel, Power BI or Tableau.

  • Why do 40 of 100 rows have is_late_payment = true?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 100 rows.

  • A software demo

    Believable customers with full_name, email and phone_number to fill a screen in front of a buyer.

Not quite right?

Make it yours.

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

Preview 20 rows free

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset100 rows24 columns
Yours10,000 rows24 columnsaddress_street: UK only

blueprint · customer-payment-history-and-credit-scoring

Behind this dataset

Same schema. As many rows as you need.

These 100 rows came out of a blueprint — 24 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
  • Payment transaction ID and invoice number
  • Subscriber MSISDN and billing account
  • Invoice amount, due date, and payment date
  • Payment status: paid on time, late, partial, unpaid
  • Payment method: credit card, bank ACH, mobile wallet, cash, voucher
  • Auto-pay enrollment status for convenience and on-time payment
  • Late payment incidents count and days overdue
  • Collections status: reminder sent, suspended service, collections agency
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
customer-payment-history-and-credit-scoring

What should your data show?

Preview 20 rows free
No signup. No card.