Skip to content
Alternative Finance

Underwriting · Underwriters

NSF bank statement analyzer

This NSF bank statement analyzer takes one line per month of NSF count, overdraft fee count and fees paid, and returns the total returned items, the months that breach your policy maximum, the worst month, the first-to-last trend, overdraft events, fees paid and fees as a share of deposits. It is for underwriters screening daily-debit and short-term loan applicants. The output to watch is the trend: a rising count in the most recent months predicts a bounced debit far better than the total.

NSF items across the period
6
Months breaching policy
0 of 4
Worst month
3
Trend (last month minus first)
+3
Overdraft fee events
10
Bank fees paid
$560
Fees as share of deposits
0.23%

A rising NSF count is a stronger decline signal than the total: it shows debits are outrunning deposits now. Returned financing debits in particular suggest a stacked or failing position.

NSF items by month
  • M10
  • M22
  • M31
  • M43

Formula

NSF items across the period = sum of column 1 across all rows. Overdraft fee events = sum of column 2. Bank fees paid = sum of column 3.

Months breaching policy = count of rows where NSF count > Policy maximum NSFs per month. Worst month = the largest NSF count in any row.

Trend = NSF count in the last row − NSF count in the first row; a positive number means returned items are increasing.

Fees as share of deposits = Bank fees paid ÷ (Average monthly deposits × number of months).

Worked examples

Example 1: the default four months, rising but within policy

Inputs: four rows of NSF count, overdraft fee count and fees paid: 0 / 1 / $35; 2 / 3 / $175; 1 / 2 / $105; 3 / 4 / $245. Policy maximum NSFs per month 3; Average monthly deposits $60,000. NSF items across the period = 0 + 2 + 1 + 3 = 6. Months breaching policy: a breach requires a count above 3, and the highest month is exactly 3, so 0 of 4 months breach. Worst month = 3. Trend = 3 − 0 = +3, flagged because it is positive. Overdraft fee events = 1 + 3 + 2 + 4 = 10. Bank fees paid = 35 + 175 + 105 + 245 = $560. Fees as share of deposits = 560 ÷ (60,000 × 4) = 560 ÷ 240,000 = 0.23%. The file passes the policy count test in every month, yet the trend output is the one an underwriter should act on: zero returned items became three in four months while overdraft events rose each month. The fee drag is immaterial at a quarter of a percent of deposits; the direction is not.

Example 2: a bad quarter that is clearly over

Inputs: 4 / 5 / $300; 2 / 2 / $140; 1 / 1 / $70; 0 / 0 / $0. Policy maximum 3; deposits $45,000. Total NSF = 4 + 2 + 1 + 0 = 7, more than the default example. Months breaching: month 1 had 4, above 3, so 1 of 4. Worst month = 4. Trend = 0 − 4 = −4, which the tool shows in green because returned items are falling. Overdraft events = 5 + 2 + 1 + 0 = 8. Fees paid = 300 + 140 + 70 + 0 = $510. Fees share = 510 ÷ (45,000 × 4) = 510 ÷ 180,000 = 0.28%. By total count this file is worse than the default; by trend it is far better, since the most recent month is clean and the deterioration is three months old. A funder applying a rigid rule of no more than six NSFs in four months would decline this file and fund the default one; a funder reading the trend would do the opposite, and would ask what happened in month one and whether the cause, often a single large returned customer cheque, has been resolved.

Example 3: two clean months and a sudden spike

Inputs: 0 / 0 / $0; 0 / 0 / $0; 5 / 6 / $385. Policy maximum 2; deposits $90,000. Total NSF = 5. Months breaching: month 3 with 5 against a limit of 2, so 1 of 3. Worst month = 5. Trend = 5 − 0 = +5. Overdraft events = 6. Fees = $385. Fees share = 385 ÷ (90,000 × 3) = 385 ÷ 270,000 = 0.14%. The fee share is the lowest of the three examples and the total count is modest, but this is the most alarming pattern of the three: a well-run account with sizeable deposits suddenly returned five items in the latest month. That usually means a new fixed obligation began, typically a stacked advance, or a major customer stopped paying. The correct response is not to price the file but to ask for the current month's statement to date and a list of the returned items, because if those five returns include a financing debit, the merchant is already failing someone else's position.

What an NSF count actually measures

A non-sufficient funds item is a debit the bank refused to pay because the balance was too low, or paid into overdraft and charged a fee for. For a lender that will be repaid from the same account, each one is a rehearsal of a missed payment. An NSF bank statement analyzer counts those rehearsals month by month, because the pattern over time carries more information than the sum. A business that bounced four items in one bad month and none since has a story; a business that bounced one, then two, then three is running out of cash in a way the balance line may not yet show.

Overdraft fee events and NSF returns are counted separately because banks treat them differently and so should you. A returned item means a creditor did not get paid, which for a financing debit means a missed payment that the funder will re-present and the merchant's other funders will notice. A paid overdraft means the bank covered the shortfall and charged for it; the creditor was paid, but the business is operating below zero. Both are signs of strain; returns are the more serious because they reach outside the account.

Common decline and refer rules by funder tier
RuleTypical settingWhat it catches
Maximum NSFs per month2 to 5 depending on productAcute cash shortage in any single month
Maximum NSFs across 3 monthsCommonly 3 to 10Chronic shortage
Any NSF in the most recent monthRefer or decline for premium tiersCurrent distress
Any returned financing debitDecline at most fundersFailing an existing position
Rising trendReferDeterioration regardless of totals

Reading the four outputs that matter

The total is the number brokers quote and the least useful one on its own. Months breaching policy tells you whether any single month crossed your line; the tool highlights those months in the chart. The worst month tells you how bad the acute episode was. The trend, last month minus first, tells you the direction. Read them in reverse order: direction first, then severity, then frequency, then total. A positive trend with a breach in the last month is a decline for most daily-debit products; a negative trend with a breach in the first month is a file that may have recovered.

Fees as a share of deposits is a small number in every example because bank fees are small relative to sales, but it serves two purposes. It confirms the fee column was entered correctly, since a figure above one or two percent usually means an extra zero. And it quantifies the drag on a thin-margin business: $560 of fees a quarter is trivial on $60,000 of monthly deposits but material on $8,000. Use the share, not the dollar figure, when comparing files of different sizes.

Why returned financing debits deserve their own look

The tool counts items, but the statements show what each returned item was. A returned cheque to a supplier is a cash-flow problem. A returned ACH debit to another funder is both a cash-flow problem and evidence that the merchant is already failing a position; every funder re-presents returned debits, and a second return typically triggers the default provisions of that other agreement. Funding a merchant in that state means your debit competes with a re-presented one and a potential collections action. The stacking and renewals guide and the MCA stacking calculator cover how to evaluate existing positions; the merchant negative days calculator measures how many days the balance spent below zero, which is the companion metric to the NSF count.

The ACH network has its own view of returns. Under the Nacha operating rules, an originator whose unauthorized return rate exceeds 0.5 percent of debits, whose administrative return rate exceeds 3 percent, or whose overall return rate exceeds 15 percent is subject to review and potential enforcement through its originating bank. A funder's own return rate is largely a product of the accounts it chose to fund, so screening for NSF patterns is also compliance hygiene. Your originating bank will typically monitor these rates and may terminate origination services if they stay elevated.

Setting the policy maximum

The policy maximum NSFs per month is an editable input because funders differ by product and risk appetite. Premium tiers offering factor rates near 1.15 commonly allow zero to two returned items a month and none in the latest month; standard tiers allow three to four; high-risk tiers tolerate more but price accordingly and shorten the term. Whatever the number, it should be written into the credit policy and applied consistently, both for fairness under Regulation B, which the CFPB's regulation text extends to business credit, and because the Section 1071 rule will require covered lenders to report denial reasons for small-business applications.

  • Set a monthly cap and a period total; the monthly cap catches acute problems and the total catches chronic ones.
  • Treat any return in the latest month as a refer regardless of the cap; current distress is worth a phone call.
  • Treat any returned financing debit as a decline unless the broker can document that the position has since been paid off.
  • Weigh the count against account activity: five returns on 400 monthly debits is a different account from five on 40.

Industry matters as well. Cash-heavy and seasonal businesses such as restaurants and construction contractors show more returns in slow months as a matter of course; a rigid cap declines sound businesses in their off-season. A looser cap paired with a trend requirement, no increase across the period, is a common compromise.

Preparing the rows and where the data comes from

Each row is one calendar month in chronological order: the number of returned items, the number of overdraft or NSF fee charges, and the total dollar amount of those fees. The count of returned items comes from the statement's returned-item or NSF lines, which most banks list separately from ordinary debits; count each returned item once even if the same payee re-presented it. Fee counts and amounts come from the fee lines. If the bank combines returned-item fees and overdraft fees under one label, enter the combined count in the second column and note it in the file.

The analysis is only as good as the statements. Applicant-supplied PDFs are the most commonly altered documents in small-business lending, and removing NSF lines is one of the easiest edits to make. Where possible, pull statements through a direct bank connection or request them from the bank. The FTC's small-business guidance covers the basics of handling consumer-report data for owners, and the bankruptcy court search is the natural next step when a file shows a sharp spike in returned items with no explanation. For the broader cash picture, pair this tool with the bank statement cash flow analyzer, which reports net cash flow, trend, volatility and the lowest balance over the same months.

What to do with a borderline file: ask for the most recent month to date, ask for the returned items by payee, and ask what changed. A single large returned customer cheque that cascaded into several of the merchant's own payments is a common and benign explanation. A new daily debit appearing in the same month as the returns is not. If the explanation holds, fund at a reduced amount and shorter term; if it does not, decline and say why, so the broker can bring the file back when the pattern has cleared.

Questions people ask

How many NSFs will a lender allow?

It varies by product and tier. Premium short-term funders commonly allow none to two returned items a month with a clean most recent month; standard tiers allow around three to four; higher-risk tiers accept more and price for it. Most funders also cap the three-month total and decline any file showing a returned payment to another funder. The NSF bank statement analyzer lets you set your own monthly maximum.

What is the difference between an NSF and an overdraft?

An NSF return means the bank refused to pay an item because the balance was insufficient, so the payee did not get paid. An overdraft means the bank paid the item and took the balance below zero, charging a fee. Both show strain; returns are more serious because a creditor went unpaid. The tool counts them in separate columns for that reason.

Why does the trend matter more than the total?

Because the total mixes old and recent behaviour. Seven returns that happened three months ago and have stopped describe a problem that was solved; three returns that began last month describe one that is starting. The trend output subtracts the first month's count from the last, so a positive figure means returned items are increasing, which is the strongest statement-based predictor of a bounced debit.

Should a returned payment to another funder be treated like any other NSF?

No. A returned financing debit means the merchant is already failing an existing obligation, and that funder will re-present the debit and may declare a default. Funding a new position into that situation puts your payment in direct competition with theirs. Most funders decline on a single returned financing debit unless the position has since been paid off and documented.

What does fees as a share of deposits tell me?

It expresses bank fees paid over the period relative to total deposits, which lets you compare the fee drag across businesses of different sizes. For most operating accounts the figure is a fraction of a percent; a figure above one or two percent either means a very small account under real strain or a data-entry error in the fee column.

Sources and further reading

Related tools and guides

More underwriting

Updated October 12, 2026 · By Alternative Finance editorial team

Next step

Turn the estimate into real offers

One request, several funding partners, side-by-side payback. Nothing is binding until you accept an offer.

  • Soft inquiry to request offers; a hard pull only if you proceed with a funder.
  • Decisions in as little as 24 hours for many products; funding often within days.
  • Use our calculators to check the true cost before you accept anything.

See what you may qualify for

Takes about a minute. Requesting offers does not affect your credit score. Free, no obligation.

We are not a lender or broker. Requests are forwarded to funding partners free of charge. How the site is paid.