Overdraft and NSF Processing

This dataset provides detailed records of overdraft and non-sufficient funds (NSF) processing for banking accounts, including coverage decisions, courtesy pay limits, overdraft protection transfers, and associated fee assessments. It enables comprehensive analysis of account risk, fee revenue, customer protection utilization, and regulatory compliance for financial institutions.

  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Analyze customer overdraft and NSF patterns for risk assessment

Sample rows

preview · 8 of 800 rows · all 14 columns
transaction_idstringfee_typestringfee_assessedfloatoverdraft_protection_enabledbooleantransaction_typestringaccount_idstringtransaction_datedatetimetransaction_amountfloatdecisionstringcourtesy_pay_limitfloatoverdraft_protection_source_account_idstringoverdraft_protection_transfer_amountfloatfee_posted_datedatetransaction_descriptionstring
TXN100001overdraft_fee35falseoverdraftACC9000012024-03-12T09:22:38134.87approvedblankblankblank2024-03-13Debit card purchase resulted in overdraft
TXN100002nsf_fee32falsensfACC9000022024-03-14T15:45:12980.55returnedblankblankblank2024-03-14Check payment returned for insufficient funds
TXN100003courtesy_pay_fee28truecourtesy_payACC9000032024-03-15T11:02:2655.24paid100blankblank2024-03-15Courtesy pay covered POS purchase
TXN100004transfer_fee10trueoverdraft_protection_transferACC9000042024-03-16T13:29:45250approvedblankACC9000212502024-03-16OD protection transfer from savings
TXN100005overdraft_fee0falseoverdraftACC9000052024-03-17T17:16:0372.19declinedblankblankblank2024-03-17ATM withdrawal rejected, overdraft declined
TXN100006nsf_fee36falsensfACC9000062024-03-18T09:05:141200returnedblankblankblank2024-03-18ACH payment returned for NSF
TXN100007courtesy_pay_fee30truecourtesy_payACC9000072024-03-19T10:11:5980paid200blankblank2024-03-19Courtesy pay covered utility bill
TXN100008transfer_fee8trueoverdraft_protection_transferACC9000082024-03-20T16:49:21115.66approvedblankACC900023115.662024-03-20OD protection transfer from linked checking

What the 800 rows show

from the 800-row sample

Transfer_fee (fee type) stands out: mean fee_assessed is 11.1, against 29.2 for the rest.

  • 39%overdraft_protection_enabled = true
  • 30.0median fee_assessed
  • 4decisions
  • 130.0median transaction_amount
  • 120median courtesy_pay_limit
  • 600.0median overdraft_protection_transfer_amount
Mean fee_assessed by fee_type800 rows
0204028.6overdraf…238 rows31.3nsf_fee211 rows11.1transfer…159 rows27.6courtesy…192 rows
fee_assessed800 rows, in bands of 10
0190380921261763802221001050100fee_assessed →

Median 30.0, from 0.0 to 100.0.

transaction_type800 rows · 4 values
  1. overdraft243
  2. nsf211
  3. courtesy_pay192
  4. overdraft_protection_transfer154
14 columns by typefrom the column list below
  • string 7
  • float 4
  • date 1
  • datetime 1
  • boolean 1

Columns

14 columns in four groups
blueprint · 14 columns
columntypedescriptionexample
Text 7 columns
transaction_idstringUnique identifier for each overdraft or NSF transactionuniqueTXN100001
account_idstringUnique identifier for the customer account involved in the transactionACC900001
transaction_typestringType of transaction (e.g., overdraft, NSF, overdraft protection transfer)4 valuesoverdraft
decisionstringDecision made regarding overdraft coverage (e.g., approved, declined, paid, returned)approved · declined · paid · returnedapproved
overdraft_protection_source_account_idstringIdentifier for the source account used for overdraft protection transfer (if applicable)optionalACC900021
fee_typestringType of fee assessed (e.g., overdraft fee, NSF fee, transfer fee)overdraft_fee · nsf_fee · transfer_fee · courtesy_pay_feeoverdraft_fee
transaction_descriptionstringAdditional details or description for the transactionoptionalNSF returned: e-transfer
Numbers 4 columns
transaction_amountfloatAmount involved in the transaction0 or more134.87
courtesy_pay_limitfloatMaximum courtesy pay limit available for the account at the time of transaction0 or more · optional100
overdraft_protection_transfer_amountfloatAmount transferred from the protection source account to cover the overdraft (if applicable)0 or more · optional250
fee_assessedfloatFee charged to the account as a result of the transaction0 or more35
Dates and times 2 columns
transaction_datedatetimeDate and time when the overdraft or NSF transaction occurred2024-03-12T09:22:38
fee_posted_datedateDate when the fee was posted to the accountoptional2024-03-13
True or false 1 column
overdraft_protection_enabledbooleanIndicates if overdraft protection is enabled for the accountfalse

Use it for

  • overdraft prot…39%310 of 800 rowsmean fee assessed by …28.6over…31.3nsf_…11.1tran…27.6cour…

    A finance dashboard

    The overdraft_protection_enabled rate, fee_assessed by fee_type and a breakdown of transaction_type. Excel, Power BI or Tableau.

  • Why do the 159 transfer_fee rows have a mean fee_assessed of 11.1?

    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 transactions with account_id, transaction_date and transaction_type 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 dataset800 rows14 columns
Yours1,000 rows14 columns

blueprint · overdraft-and-nsf-processing

Behind this dataset

Same schema. As many rows as you need.

These 800 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
  • Opt-in required for ATM/debit overdrafts per Reg E
  • Standard overdraft for checks and ACH
  • Courtesy pay limit: typically $500-$1,000
  • Overdraft fee: $30-$35 per item
  • NSF fee same as overdraft fee
  • Maximum fees per day cap: 3-4
  • Negative balance must be resolved within 30 days
  • Overdraft protection transfer from savings
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
overdraft-and-nsf-processing

What should your data show?

Preview 20 rows free
No signup. No card.