Skip to content
Alternative Finance

Broker tools · Brokers and underwriters

Bank statement negative days calculator

This bank statement negative days calculator counts the days a merchant's operating account closed below zero, the longest run of consecutive negative days, the deepest negative balance, the days that closed above zero but below a low-balance line you set, and the share of days negative, then compares the count with the funder's maximum negative days per month. It is for brokers screening files and underwriters checking them. Watch the streak more than the count: five scattered negative days are a merchant who overdraws occasionally; five in a row are a merchant whose account cannot recover between debits.

Negative days
5 of 21
Against funder limit
Exceeds limit by 2
Longest overdraft streak
2 days
Deepest negative balance
-$310
Days under $500
2
Share of days negative
24%

Many funders decline above three to five negative days a month and look hardest at streaks, which show the business cannot recover between debits.

Daily ending balance
$1,200D1$400D2-$220D3-$80D4$900D5$2,100D6$1,500D7-$40D8$600D9$1,800D10$2,500D11$2,200D12$300D13-$150D14-$310D15$700D16$1,900D17$2,400D18$2,000D19$1,100D20$900D21

Formula

Negative days = count of Daily ending balances below $0; Share of days negative = Negative days ÷ total days pasted

Against funder limit: within limit when Negative days ≤ Funder's maximum negative days per month; otherwise the excess is shown

Longest overdraft streak = the greatest number of consecutive negative days in the pasted order; the streak resets on any day at or above $0

Deepest negative balance = the minimum of the list; Days under the low-balance line = count of balances that are at or above $0 and below the Low-balance line

Worked examples

Example 1: the default 21-day statement against a limit of 3

The default balances are 1,200; 400; −220; −80; 900; 2,100; 1,500; −40; 600; 1,800; 2,500; 2,200; 300; −150; −310; 700; 1,900; 2,400; 2,000; 1,100; 900, with a funder limit of 3 negative days and a low-balance line of $500. Walking the list: days 3 and 4 are negative (−220, −80), day 8 is negative (−40), and days 14 and 15 are negative (−150, −310). Negative days = 5 of 21. Against the limit of 3, the file exceeds the limit by 2. The streaks are 2 days (days 3 to 4), 1 day (day 8) and 2 days (days 14 to 15), so the longest overdraft streak is 2 days. The deepest negative balance is −$310 on day 15. Days at or above zero but under $500 are day 2 ($400) and day 13 ($300), so days under $500 = 2. Share of days negative = 5 ÷ 21 = 23.8 percent, shown as 24 percent. This file is declined at a funder with a limit of 3 and would be declined at most funders with a limit of 5 as well, because the pattern repeats every week or so.

Example 2: a single negative day, within limit

Balances 2,400; 1,900; 350; −90; 1,200; 2,800; 3,100; 2,600; 450; 1,700 over ten days, limit 3, low-balance line $500. Only day 4 (−90) is negative, so negative days = 1 of 10, within the limit by 2. The longest streak is 1 day. The deepest negative balance is −$90. Days at or above zero but under $500 are day 3 ($350) and day 9 ($450), so days under $500 = 2. Share of days negative = 1 ÷ 10 = 10 percent. The negative day is shallow, isolated and immediately followed by recovery to $1,200; most funders read this as a timing issue, a debit that landed a day before a deposit, and fund it, possibly with a request for the next month's statement to confirm. The two sub-$500 days are the detail an underwriter notes: the account runs close to the line about once a week.

Example 3: within the limit on count, failed on streak

Balances 800; −100; −250; −400; −600; −150; 300; 900; 1,500; 2,000; 2,200; 1,800 over twelve days, limit 5, low-balance line $1,000. Days 2 through 6 are negative, so negative days = 5 of 12, which is exactly the limit and reads within limit. But all five are consecutive: the longest overdraft streak is 5 days, and the balance deepened each day from −$100 to −$600 before beginning to recover. The deepest negative balance is −$600. Days at or above zero but under $1,000 are day 1 ($800), day 7 ($300) and day 8 ($900), so days under $1,000 = 3. Share of days negative = 5 ÷ 12 = 41.7 percent, shown as 42 percent. A funder reading this statement sees a merchant who ran a week in overdraft, probably paying overdraft fees each day, and recovered only when a large deposit arrived. The count passes the limit; the streak and the 42 percent share fail the file.

Why negative days are a decline trigger

A merchant cash advance is repaid by a fixed debit every business day. On a day the account closes negative, that debit either bounced or was paid into overdraft by the bank at a fee; either way the funder learned something the application did not say. Negative days on the statements before funding are the best available predictor of returned debits after funding, which is why most funders set a hard limit, commonly three to five per month, and decline above it without further review. The bank statement negative days calculator applies that limit to the pasted balances and shows the excess, so you know before submitting whether the file will clear the first screen.

The returned debits that negative days predict are also a problem for the funder's own banking. ACH originators are measured on return rates under the Nacha operating rules, which set an unauthorized return threshold of 0.5 percent, an administrative return threshold of 3 percent and an overall return threshold of 15 percent; an originator above those lines faces inquiry from its bank and can lose the ability to originate. The Federal Reserve's FedACH overview describes the network. A funder that funds merchants with frequent negative days is adding to its own return rate, which is why the limit is enforced even on files that otherwise look profitable.

The count is a screen, not a verdict. Two files with five negative days can be very different merchants: one overdraws by $40 on the day before payroll deposits arrive and recovers the next morning; the other sinks for a week. The streak, the depth and the share of days negative separate them, which is why this tool reports all four.

Reading the six outputs

Output by output
OutputWhat it measuresHow an underwriter reads it
Negative daysCount of days closing below zeroThe screen; compared directly with the funder's monthly limit
Against funder limitCount minus limitExceeding by one is a conversation; exceeding by three is a decline
Longest overdraft streakConsecutive negative daysTwo or more means the account did not recover between debits; four or more is read as a structural shortfall
Deepest negative balanceThe minimum balanceRelative to the proposed daily debit; a −$600 floor against a $450 debit means two debits would have bounced
Days under the low-balance linePositive days below your lineNear-misses that become negative days once a new debit starts
Share of days negativeNegative days ÷ days pastedNormalizes across statement lengths; above about 15 percent the account is in overdraft more than one day a week

Set the low-balance line at or just above the daily debit you intend to propose. Every day that closed below it is a day the new debit would have taken the account negative, so the count of low days plus the count of negative days is the forecast of returned debits per month after funding. In the default example, a proposed debit of $500 would have produced 7 negative days rather than 5. The MCA daily payment calculator gives the debit for the advance under consideration.

What the pattern says about the business

Negative days cluster for reasons an underwriter can usually identify from the transaction detail. Scattered single days just before regular deposits are timing: payroll, rent or a vendor autopay lands a day before card settlements post. Streaks that begin on the same date each month are a fixed obligation the business cannot cover from that week's deposits; often it is an existing advance's debits running against a slow week. Streaks that deepen day by day, as in example 3, are a business spending more than it takes in and relying on the bank's overdraft tolerance. A deepest balance that grows more negative month over month is the same business approaching the point where the bank closes the account.

Banks describe how they handle overdrafts in the account agreement and on the statement, and the FDIC publishes consumer guidance on overdraft programs and fees that applies in substance to small business accounts as well. The fees matter to the underwriter because each overdraft day costs the merchant a fee that further reduces the balance; a merchant with twenty overdraft fees a month is paying a material amount for the privilege of being overdrawn, and that money would otherwise have covered the debit.

For the merchant, the practical point is that negative days are fixable in a month. Moving autopays to the day after settlements post, keeping a cushion equal to the largest regular debit, and not taking a new position until the existing one is paid down will usually produce a clean statement. A broker who explains that and resubmits in thirty days funds a file that a broker who submits today gets declined on.

Funder limits and what exceeding them costs

  • Hard limits. Many funders decline above three to five negative days in the most recent month regardless of other strengths; the limit is often lower for second and third positions.
  • Streak rules. Some funders decline any streak of three or more consecutive negative days even when the total count is within the limit, because a streak is evidence the account cannot recover between debits.
  • Pricing. Files that pass the limit with one or two negative days are commonly placed in a lower paper grade, which means a higher buy rate and a shorter term. The MCA buy rate sell rate calculator shows what that does to the merchant's daily payment and APR.
  • Weekly debits. Funders sometimes offer a weekly rather than daily debit to a merchant with timing-related negative days, giving the account a week to recover between pulls. The total cost is unchanged; the return risk falls.
  • Conditions. A funder may approve subject to the next month's statement showing zero negative days, or subject to the merchant's bank confirming no overdraft fees in the last thirty days.

Exceeding the limit on a file you submit anyway costs more than the decline. Funders track broker submission quality, and ISOs whose files are repeatedly declined on first-screen criteria lose their place in the queue and sometimes their agreement. Screening with this tool and the merchant bank statement analyzer before submitting keeps your approval rate up, which is what gets your files looked at first.

Disclosure, fair dealing and the merchant's side

A merchant who is funded despite a statement full of negative days is a merchant likely to default, and a default on a merchant cash advance can end in collection, judgment against the personal guarantor and, in some states, enforcement of a confession of judgment. New York restricted confessions of judgment against out-of-state merchants, and the New York Department of Financial Services administers the state's commercial finance disclosure rules that require an APR and total cost before signing. Connecticut's Department of Banking registers providers and brokers of commercial financing. None of this prevents a funder from funding a weak file, but it makes the cost visible to a merchant who may be better off not taking the money.

The FTC's small business guidance and its enforcement under Section 5 of the FTC Act address representations made to businesses seeking financing. Telling a merchant with a week-long overdraft streak that a new daily debit is affordable is the kind of representation that the merchant's later default will test. The guide on confessions of judgment and personal guarantees explains the downside the merchant has signed up for; a merchant whose account ends in bankruptcy is a loss for every funder in the stack and a clawback for the broker.

Input checks before you trust the count

  1. Paste ending balances in date order. The streak calculation depends on the sequence; a sorted or shuffled list produces a wrong streak.
  2. Include every day the bank lists, including weekends and holidays if they appear. Omitting days shrinks the denominator and understates the share negative.
  3. Use the minus sign for negatives. Balances shown in parentheses or with a DR marker on the statement must be entered as negative numbers.
  4. Check the count against the statement summary. Many statements print the number of overdraft or NSF fees; the negative-day count should be consistent with it.
  5. Run each month separately. A three-month paste averages a clean month with a bad one; funders weight the most recent month most heavily.
  6. Set the low-balance line to the proposed daily debit. The days under the line are the forecast of new negative days after funding.

If the file fails, the merchant's options are to clean up the account for a month and reapply, to reduce the request to a size whose debit fits under the floor, or to look at a product that does not debit daily. The MCA funding capacity estimator sizes a smaller advance from deposits, and the average daily balance calculator shows where the floor sits once the overdrafts stop. Merchants who can wait and whose statements improve may fit a short-term business loan with weekly or monthly payments.

Questions people ask

How many negative days will get a merchant cash advance declined?

Many funders decline above three to five negative days in the most recent month, with lower limits for second and third positions. Some decline any streak of three or more consecutive negative days regardless of the count. Funders also count NSF items separately, so a statement with few negative days but several returned items is still a decline at most desks.

What counts as a negative day on a bank statement?

A day whose ending balance is below zero, whether the bank paid items into overdraft or the merchant's deposits simply did not cover the debits that posted. Days where an item was returned for insufficient funds but the balance stayed at or above zero are NSF days, not negative days; funders count both.

Why does the calculator track overdraft streaks?

Because consecutive negative days show the account did not recover between debits. A single negative day followed by recovery is usually a timing issue; a streak means the business is spending more than it deposits and relying on the bank's overdraft tolerance. Underwriters treat a streak of three or more as a stronger negative than the same number of scattered days.

What is the low-balance line for?

To count the days that closed above zero but would have gone negative with a new daily debit. Set it to the debit you intend to propose; the days under the line plus the existing negative days forecast how many returned debits the funder would see each month after funding.

Can a merchant fix negative days quickly?

Usually within a month. Moving automatic payments to the day after card settlements post, keeping a cushion equal to the largest regular debit, stopping personal spending from the business account and not stacking a new position before the current one is paid down will produce a clean statement at most businesses that are actually profitable.

Sources and further reading

Related tools and guides

More broker tools

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.

Check merchant cash advance offers

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.