Skip to content
Alternative Finance

Broker tools · Brokers and underwriters

Merchant bank statement analyzer for MCA bank statement analysis

This tool performs the first pass of MCA bank statement analysis the way an underwriter does it: you paste the daily ending balances and the deposit amounts from a statement, enter the NSF count and any existing financing debits, and it returns average daily balance, total and average deposits, negative and low-balance days, balance volatility, the existing debits' share of deposits and an illustrative A to D grade with a rough funding estimate. It is for brokers pre-screening files and underwriters checking them. Nothing you paste leaves your browser. Watch the lowest balance and the negative days, not the average.

Statement grade (illustrative)
B
Average daily balance
$6,538
Total deposits
$38,800
Deposit count
12
Average deposit
$3,233
Negative balance days
1
Days under $1,000
1
NSF items
1
Balance volatility (std dev ÷ mean)
0.39
Existing debits as share of deposits
18.9%
Lowest balance
-$150

Grade thresholds mirror what underwriters commonly screen (negative days, NSFs, average balance, volatility) and are illustrative. Nothing you paste leaves your browser.

Daily ending balance
$8,200D1$7,650D2$9,100D3$4,200D4-$150D5$3,900D6$6,100D7$7,800D8$8,900D9$5,200D10$2,100D11$6,400D12$7,700D13$9,900D14$8,100D15$6,600D16$4,300D17$5,900D18$7,200D19$8,800D20$9,400D21

Your funding estimate

$31,040

Estimated amount from your inputs. An example calculation, not an offer from any lender.

Compare funding options

Formula

Average daily balance = sum of Daily ending balances ÷ number of balances pasted; Lowest balance = the minimum of the list

Negative balance days = count of balances below $0; Days under $1,000 = count of balances below $1,000

Total deposits = sum of Deposit amounts; Deposit count = number of amounts; Average deposit = Total deposits ÷ Deposit count

Balance volatility = sample standard deviation of the balances ÷ absolute value of the average daily balance; Existing debits as share of deposits = Existing financing debits per day × 21 ÷ Total deposits

Illustrative grade: A when no negative days, no NSFs, average balance above $5,000 and volatility below 0.5; B when at most one negative day, at most one NSF and average balance above $2,500; C when at most three negative days and three NSFs; otherwise D. Funding estimate = Total deposits × 1.0 (A), 0.8 (B), 0.5 (C) or 0 (D).

Worked examples

Example 1: the default statement, 21 balances and 12 deposits with one NSF

The default balances are 8,200; 7,650; 9,100; 4,200; −150; 3,900; 6,100; 7,800; 8,900; 5,200; 2,100; 6,400; 7,700; 9,900; 8,100; 6,600; 4,300; 5,900; 7,200; 8,800; 9,400. They sum to $137,300 over 21 days, so the average daily balance = $137,300 ÷ 21 = $6,538.10, shown as $6,538. One balance is negative (−$150, day 5) and it is also the only day under $1,000, so negative days = 1 and days under $1,000 = 1; the lowest balance is −$150. The deposits are 3,200; 2,900; 4,100; 1,800; 2,600; 3,900; 4,400; 2,200; 3,100; 2,700; 3,800; 4,100, totalling $38,800 across 12 credits, an average deposit of $3,233. The sample standard deviation of the balances is about $2,558, so volatility = $2,558 ÷ $6,538 = 0.39. Existing debits of $350 a day × 21 = $7,350, which is 18.9 percent of $38,800. Grade: the single negative day rules out A; with one negative day, one NSF and an average above $2,500 the statement grades B, and the estimate is $38,800 × 0.8 = $31,040.

Example 2: a clean but small account

Balances 4,000; 3,500; 5,200; 6,100; 2,900; 3,300; 4,800; 5,500; 4,100; 3,600 sum to $43,000 over 10 days, so the average daily balance = $4,300. No day is negative or under $1,000; the lowest balance is $2,900. Deposits 2,500; 3,000; 1,800; 2,200; 4,000; 2,500 total $16,000 across 6 credits, averaging $2,667. Deviations from the $4,300 mean are −300, −800, 900, 1,800, −1,400, −1,000, 500, 1,200, −200, −700; their squares sum to 9,960,000; dividing by 9 gives 1,106,667 and the square root is $1,052, so volatility = $1,052 ÷ $4,300 = 0.24. NSFs are 0. Existing debits of $200 a day × 21 = $4,200, which is 26.3 percent of deposits. Grade: no negatives and no NSFs, but the average balance of $4,300 is below the $5,000 required for A, so the statement grades B and the estimate is $16,000 × 0.8 = $12,800. The account is clean; it is simply small, and the existing debits already take more than a quarter of deposits.

Example 3: a statement that fails on negative days

Balances 900; −200; −450; 300; −120; 1,500; 800; −60; 200; 2,100 sum to $4,970 over 10 days, so the average daily balance = $497. Four days are negative and eight of the ten are under $1,000; the lowest balance is −$450. Deposits 1,200; 900; 1,500; 2,000; 1,100 total $6,700 across 5 credits, averaging $1,340. The standard deviation of the balances is about $819, so volatility = $819 ÷ $497 = 1.65, meaning the typical swing is larger than the average balance. Four NSFs are entered. Existing debits of $100 a day × 21 = $2,100, which is 31.3 percent of deposits. Grade: four negative days exceeds the three allowed for C, so the statement grades D and the funding estimate is $0. A broker who submits this file is spending a funder's underwriting time on a decline; the merchant needs to clear the overdrafts and show a month without NSFs before any funder will look.

What underwriters read first on a bank statement

A merchant cash advance is repaid by daily debits from the operating account, so the statement is the underwriting. Funders look at four things before anything else: whether the account goes negative, how often items are returned for insufficient funds, how much cash sits in the account on an average day, and how much comes in. The average daily balance tells them whether a debit will clear on an ordinary day; the negative days and NSFs tell them what happens on a bad one. This tool reproduces that first pass so you can grade a file before you submit it. MCA bank statement analysis done at the broker's desk saves the funder's time and your reputation, because the files you send fund more often.

The grade thresholds here are illustrative and mirror what underwriters commonly screen; every funder has its own cut-offs and its own weighting. What is consistent across funders is the order of importance: negative days and NSFs are near-automatic declines above a small count, average daily balance sets the funding ceiling, and deposit count and volatility shape the term. The merchant negative days calculator and the NSF transaction analyzer go deeper on the two decline triggers.

Statement-based underwriting is also what state regulators and the CFPB expect sales-based financing providers to be doing. The CFPB's Section 1071 rule treats merchant cash advances as covered credit for data collection, and the application data a funder collects starts from what the statement shows. A broker who understands the statement can explain a decline to a merchant in terms the merchant can fix.

How to extract the numbers from a statement

  1. 1

    Use complete statements, all pages

    The daily balance table is usually on the last pages. A statement missing pages is a statement missing the negative days. Funders bounce incomplete statements; so should you.

  2. 2

    Paste the daily ending balances in order

    One balance per line, negatives with a minus sign. Days without activity are often omitted from the daily balance table; the balance carries forward, so repeat it for those days if you want the average to be a true calendar average. The average daily balance calculator has a segment mode for balance-and-days entry.

  3. 3

    Paste every credit as a deposit

    Card settlements, ACH credits, checks, cash. Exclude transfers from the merchant's own accounts, loan or advance proceeds, and reversals; funders exclude them too, and a file whose deposits include a $30,000 funding wire looks better than the business is.

  4. 4

    Count NSFs and returned items from the fee lines

    Overdraft fees, NSF fees, returned item fees and reversed debits. Count each occurrence, not each fee type.

  5. 5

    Enter existing financing debits per business day

    Sum the daily debits to other funders across the month and divide by the number of business days. Weekly debits divide by five.

Most funders want three to four months of statements; run each month separately and compare. A merchant whose average balance is falling month over month while deposits hold steady is spending faster than they earn, usually on existing debits. A merchant whose deposit count is falling is losing customers. The grade on the most recent month matters most; the trend across months decides the term.

Reading the eleven outputs

What each output means to a funder
OutputReads well whenWhat a bad reading signals
Average daily balanceHigh relative to the proposed daily debitA debit larger than a few percent of the average will bounce on slow days
Total deposits and deposit countMany moderate creditsFew large credits mean concentration; one lost customer empties the account
Average depositConsistent with the business typeA restaurant with $20,000 average deposits is depositing something other than sales
Negative balance daysZeroEach negative day is a day a debit would have been returned
Days under $1,000Zero or oneNear-zero days predict future negative days once a new debit starts
NSF itemsZeroReturned items are the strongest single predictor of a defaulted advance
Balance volatilityBelow 0.5Swings larger than half the average mean the account is managed day to day
Existing debits as share of depositsWell under 15%Little room for another debit; see the stacking calculator
Lowest balanceComfortably positiveThe floor the new debit would have to clear

Volatility is the sample standard deviation of the balances divided by the mean, a ratio statisticians call the coefficient of variation. It is unit-free, so a $5,000 account and a $50,000 account can be compared. A volatility of 0.39, as in the default example, means the typical day's balance sits within about 40 percent of the average, which is ordinary for a retail business; a volatility above 1 means the balance swings by more than its own average, which happens when large deposits arrive on a few days and are spent down between them. Funders price volatile accounts with shorter terms and weekly rather than daily debits.

The funding estimate and how funders size an advance

The estimate multiplies total deposits by a grade factor: one times monthly deposits for an A, 0.8 for a B, 0.5 for a C and nothing for a D. That is a rough stand-in for the way funders size advances as a share of monthly revenue, with better paper commanding a larger share and a longer term. It is deliberately conservative on the deposit side, because it uses the single month pasted rather than an average of three. The MCA funding capacity estimator sizes an advance from the daily payment the deposits can carry, which is the funder's second check after the grade.

The existing debits' share of deposits connects the two checks. In the default example, $350 a day of existing debits already takes 18.9 percent of deposits, which is above the share at which defaults concentrate. A new position on this merchant would be a stack, and the right next step is the MCA stacking calculator with the merchant's operating costs, not a submission. The debt burden calculator expresses the same idea as a monthly ratio for funders who underwrite that way.

Fraud, altered statements and verification

Pasted numbers are only as good as the statement they came from. Altered PDF statements are a persistent problem in sales-based financing, and funders now verify accounts directly through bank-data connections or by requiring the merchant to log in during underwriting. Signs that a statement has been edited include daily balances that do not reconcile with the listed transactions, fonts or alignment that change mid-page, round-number deposits with no payer description, and a month with no fees of any kind on an account that has NSFs in other months. Run the reconciliation: opening balance plus deposits minus debits must equal the closing balance.

A broker who submits an altered statement, even unknowingly, is exposed under the ISO agreement's representations and under Section 5 of the FTC Act, and a merchant who supplies one has committed fraud against the funder. The FTC's data security guidance under the Gramm-Leach-Bliley Act also matters here: the Safeguards Rule reaches finders who bring borrowers and funders together, and statements are the non-public personal information it protects. Store them encrypted, share them only through the funder's portal and delete them when the file closes. This tool runs entirely in the browser for that reason.

The FDIC's consumer resources explain how banks post transactions and assess overdraft and NSF fees, which is useful when a merchant disputes the count: a bank that pays an item into overdraft and charges a fee produces a negative day; a bank that returns the item produces an NSF without necessarily producing a negative day. Both appear on the statement, and funders count both.

What to tell a merchant whose statement grades C or D

  • Stop the overdrafts first. A month with zero negative days and zero NSFs moves most files from D to C and some to B. Most funders look hardest at the most recent month.
  • Separate business from personal banking. Owner draws and personal spending from the operating account depress the average balance and inflate volatility.
  • Move card settlements to the account being submitted. Deposits in an account the funder does not see do not count.
  • Pay down or pay off existing positions before applying for more. A share of deposits above 15 percent is a decline at most funders regardless of grade.
  • Consider a product that does not debit daily. A merchant with receivables may fit invoice factoring; one with a strong but seasonal business may fit a line of credit drawn in the slow months.

The guide on documents needed for business funding tells merchants what to gather and why statements matter most. Sending it before the first call cuts the back-and-forth on missing pages, which is the most common reason a submission stalls.

Questions people ask

How many months of bank statements do MCA funders want?

Commonly three to four complete months, all pages, for the business operating account; larger requests and seasonal businesses may need six to twelve. Funders also verify the account directly during underwriting, so the statements must match the live account. Run each month through this tool separately and compare the grades.

What is a good average daily balance for a merchant cash advance?

High enough that the proposed daily debit is a small fraction of it on every day, not just on average. The illustrative grade here requires an average above $5,000 for an A and above $2,500 for a B, but funders care more about the lowest balance and the count of days under $1,000, because those are the days a debit would be returned.

How many negative days or NSFs will get an MCA declined?

Many funders decline above three to five negative days in a month and above two or three NSFs; some decline on any NSF in the most recent month. Streaks of consecutive negative days are read more harshly than scattered ones because they show the account cannot recover between debits. The negative days calculator counts streaks.

What does balance volatility mean on a bank statement?

The standard deviation of the daily balances divided by the average, a measure of how much the balance swings relative to its typical level. Below 0.5 is steady; above 1 means swings larger than the average itself. Volatile accounts get shorter terms and sometimes weekly rather than daily debits.

Is it safe to paste bank statement data into this tool?

The calculation runs in your browser and nothing you paste is transmitted or stored. Even so, paste only the numbers, not account numbers or names, and handle the underlying statements under the Gramm-Leach-Bliley Safeguards Rule, which covers finders who connect borrowers with funders.

Can I use this for MCA bank statement analysis on a personal account?

You can paste the numbers, but funders generally require a business operating account in the entity's name, and personal spending will depress the average balance and inflate volatility. If the merchant runs the business through a personal account, the first advice is to open a business account and build two or three months of history in it.

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.