Skip to content
Alternative Finance

Underwriting · Underwriters

Bank statement cash flow analysis tool

Paste one line per month of deposits, withdrawals and ending balance and this tool performs the core bank statement cash flow analysis an underwriter needs: average net cash flow, deposit trend from first to last month, volatility, how many months spent more than they took in, the lowest month-end balance, and how much additional daily debit the account can carry under a policy cap. It is built for funders and lenders sizing daily or weekly repayment products. Watch the trend and volatility lines: a healthy average can hide a deposit line that is falling every month.

Average monthly net cash flow
$1,250
Average deposits
$86,000
Average withdrawals
$84,750
Deposit trend (first to last month)
2%
Deposit volatility
8%
Months with withdrawals above deposits
2 of 6
Lowest month-end balance
$4,600
Room for additional daily debit
$214.29

Sustainable debit = deposits × policy share ÷ business days, less existing debits. A declining or volatile deposit line reduces what the average suggests.

Deposits by month
$82,000M1$91,000M2$76,000M3$88,000M4$95,000M5$84,000M6

Your funding estimate

$26,374

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

Compare funding options

Formula

Average deposits = mean of the first column; Average withdrawals = mean of the second; Average monthly net cash flow = Average deposits − Average withdrawals.

Deposit trend = (last month deposits − first month deposits) ÷ first month deposits. Deposit volatility = sample standard deviation of deposits ÷ Average deposits.

Months with withdrawals above deposits = count of rows where column 2 exceeds column 1. Lowest month-end balance = minimum of the third column.

Room for additional daily debit = (Average deposits × Maximum total debits as share of deposits) ÷ 21 business days − Existing daily financing debits.

Worked examples

Example 1: the six default months

Inputs: six rows of deposits, withdrawals and ending balance: 82,000 / 79,500 / 6,100; 91,000 / 88,000 / 9,100; 76,000 / 80,500 / 4,600; 88,000 / 84,000 / 8,600; 95,000 / 90,000 / 13,600; 84,000 / 86,500 / 11,100. Existing daily financing debits $400; Maximum total debits as share of deposits 15%. Deposits sum to 516,000, so Average deposits = 516,000 ÷ 6 = $86,000. Withdrawals sum to 508,500, Average withdrawals = $84,750. Net cash flow = 86,000 − 84,750 = $1,250 a month. Trend = (84,000 − 82,000) ÷ 82,000 = 2.4%, shown as 2%. Volatility: the sample standard deviation of the six deposit figures is $6,782; 6,782 ÷ 86,000 = 7.9%, shown as 8%. Months where withdrawals exceeded deposits: month 3 (80,500 vs 76,000) and month 6 (86,500 vs 84,000), so 2 of 6. Lowest month-end balance = $4,600. Debit room: 86,000 × 0.15 = $12,900 a month ÷ 21 = $614.29 a day, less the existing $400 = $214.29. A new advance debiting $214 a day for 160 business days at a 1.3 factor would be about $26,000, which is the estimate the tool shows.

Example 2: a declining account with no room

Inputs: four rows: 60,000 / 58,000 / 5,000; 52,000 / 55,000 / 2,000; 45,000 / 47,000 / 1,500; 40,000 / 44,000 / 900. Existing daily debits $600; cap 12%. Average deposits = 197,000 ÷ 4 = $49,250. Average withdrawals = 204,000 ÷ 4 = $51,000. Net cash flow = −$1,750 a month. Trend = (40,000 − 60,000) ÷ 60,000 = −33%. Volatility: standard deviation $8,694 ÷ 49,250 = 17.7%, shown as 18%. Three of four months spent more than they took in. Lowest balance $900. Debit room = 49,250 × 0.12 = 5,910 ÷ 21 = $281.43 − 600 = −$318.57. The negative room says the existing $600 daily debit already exceeds what a 12 percent cap allows on this deposit base by more than $300 a day. Note that the average alone, $49,250, would have supported a modest advance; the trend and the balance line show the business is burning its cushion at a rate that makes any new position a likely default within the term.

Example 3: a steady account under a conservative cap

Inputs: three rows: 120,000 / 110,000 / 30,000; 118,000 / 112,000 / 36,000; 125,000 / 115,000 / 46,000. Existing daily debits $0; cap 10%. Average deposits = 363,000 ÷ 3 = $121,000. Average withdrawals = 337,000 ÷ 3 = $112,333. Net cash flow = $8,667 a month, and the balance rose from 30,000 to 46,000, which is consistent with that net. Trend = (125,000 − 120,000) ÷ 120,000 = 4.2%, shown as 4%. Volatility: standard deviation $3,606 ÷ 121,000 = 3%. Zero months negative. Lowest balance $30,000. Debit room = 121,000 × 0.10 = 12,100 ÷ 21 = $576.19 a day with nothing existing. At 160 business days and a 1.3 factor that supports roughly $70,900 of new funding under the 10 percent cap. Only three months of data is a limitation: this could be the peak of a seasonal cycle, so an underwriter would ask for six to twelve months or the prior year's same quarter before funding at the full figure.

What bank statement cash flow analysis measures

A business bank statement is the only financial document most small businesses produce every month without an accountant, and it is the document a daily-debit funder is actually repaid from. Bank statement cash flow analysis reduces three to twelve statements to a handful of numbers: how much comes in, how much goes out, whether the inflow is rising or falling, how much it swings, how often the business overspends, and how low the balance gets. Together they answer the underwriting question for a cash-flow product: can this account absorb another fixed daily withdrawal for the proposed term without going negative?

Net cash flow is the headline but the weakest of the six because it is an average. A business with net cash flow of $1,250 a month, as in the default example, is close to break-even; two of its six months were negative. A funder that debits a further $214 a day, about $4,500 a month, is asking that business to cut spending or grow by that amount. That is not necessarily wrong, since the use of proceeds may produce the growth, but it should be a conscious decision rather than a by-product of looking only at the average.

What each output tells an underwriter
OutputWarning level in the toolWhat it usually means
Net cash flowBelow zeroWithdrawals exceed deposits on average; balance is being drawn down or funded by borrowing
Deposit trendBelow −15%Revenue is falling across the statement period
Deposit volatilityAbove 25%Lumpy inflows; a fixed daily debit will overshoot in slow months
Negative monthsAnyMonths where the account was a net source of cash to the business
Lowest month-end balanceJudgementThin cushion relative to the proposed debit
Room for daily debitBelow zeroExisting debits already exceed the policy cap

Reading trend and volatility together

The trend measure compares only the first and last months, which makes it simple to explain but sensitive to those two months. If the last month contains a one-off receipt, the trend looks better than it is; if the first month was unusually strong, the trend looks worse. The bars chart shows all months so you can see whether the end points are representative. A declining trend with low volatility is the most dangerous combination: deposits are falling steadily, not swinging. A flat trend with high volatility is a seasonal or project-based business, and the right response is to size the debit on the weak months rather than the average.

Volatility is expressed as the coefficient of variation, the standard deviation of monthly deposits divided by their mean. Below 10 percent is a very stable account; 10 to 25 percent is typical for retail and services; above 25 percent indicates lumpy inflows that a fixed daily debit will overshoot in slow months. A common underwriting adjustment is to reduce the deposit base used for sizing by one standard deviation when volatility exceeds 25 percent, which in the tool you can approximate by lowering the policy share. Seasonal industries such as construction and landscaping routinely show volatility above 30 percent and are usually funded on a trailing twelve-month view rather than the last quarter.

Setting the debit cap and reading the room figure

The maximum total debits as a share of deposits is the key policy input. It expresses how much of the business's gross inflow all financing debits combined may take. Caps of 10 to 20 percent are commonly used; the right figure depends on gross margin, because a 15 percent debit is light for a 60 percent margin consultancy and crushing for a 12 percent margin distributor. The tool divides the monthly allowance by 21 business days, a conventional approximation of the business days in a month, and subtracts the daily debits the business already sends to other funders. What remains is the room for a new daily payment.

Existing daily financing debits must include every recurring pull from another funder, converted to a daily figure: a weekly debit of $1,500 is about $300 a day. The debt burden calculator performs that conversion and also measures the burden against gross profit. If the room is negative, the business is already over the cap and a new position would be a stack; the stacking and renewals guide explains why that is usually declined and when a consolidation is the better structure. If the room is positive, the estimate card converts it into an advance amount by multiplying the daily room by 160 business days and dividing by a 1.3 factor; use the maximum funding amount calculator to apply your own term, factor and coverage limits.

  • Lower the cap for low-margin trades such as fuel, grocery and distribution, where the debit comes out of a thin gross profit.
  • Lower it when volatility is above 25 percent so the debit still clears in slow months.
  • Raise it modestly only for high-margin, low-volatility accounts with substantial balances relative to the debit.
  • Never size on the room figure without confirming that deposits are net of transfers and loan proceeds.

Preparing the rows

Each line is one calendar month: total credits, total debits and the ending ledger balance, in that order, separated by commas. Dollar signs and spaces are ignored, so you can paste from a spreadsheet. Months should be consecutive and in chronological order, oldest first, because the trend compares the first and last rows and the chart highlights the last month. Use total credits as the bank reports them for the deposit column, but be aware that this includes transfers and loan proceeds; for a true deposit base, run the average monthly deposits calculator first and paste the net figures.

Where the business has more than one operating account, either combine the months across accounts before pasting or analyze each account separately and compare. Inter-account transfers inflate both deposits and withdrawals in a combined view and must be removed. Statements should come through a bank-data connection or directly from the bank where possible; PDF statements supplied by the applicant are routinely altered, and the tool cannot detect that. Returned items and overdraft fees are better analyzed with the NSF transaction analyzer, which counts them by month and compares them with policy.

Where this fits in the credit decision

For a bank or SBA lender, statement analysis is a supplement to financial-statement underwriting: it confirms that the revenue in the tax return is real and that the business is not already carrying undisclosed daily debt. For an advance or short-term funder it is the primary analysis, often the whole analysis. In either case the output should be read alongside the owner's credit, the industry and the use of proceeds. The Federal Reserve's annual Small Business Credit Survey documents how often small firms report cash-flow shortfalls as their main financial challenge, which is the condition this analysis is designed to detect before funding rather than after.

Two regulatory notes. First, funders that debit accounts by ACH operate under Nacha's operating rules, which set return-rate thresholds: unauthorized returns above 0.5 percent, administrative returns above 3 percent and total returns above 15 percent of debits trigger review and potential penalties against the originator. A portfolio funded on accounts with negative months and thin balances produces returned debits that count toward those thresholds. Second, a growing number of states, including California, New York, Utah, Virginia, Georgia, Florida and Connecticut, require commercial financing providers to disclose cost and payment terms before closing; the New York DFS and California DFPI sites publish their rules. Sizing on an accurate cash-flow analysis keeps those disclosures honest and reduces the chance that the disclosed payment is one the account cannot make.

If the analysis says no, the alternatives depend on why. A declining trend with a sound business behind it may suit a smaller advance with a longer term, or invoice factoring that advances on specific receivables rather than deposits. High volatility with strong peaks suggests a line of credit drawn in slow months and repaid in strong ones. Negative net cash flow with no explanation is a decline, and a conversation about expenses rather than financing.

Questions people ask

How many months of bank statements should I analyze?

Three months is the common minimum for a short-term advance and six is better; a full twelve lets you see seasonality and compare the same months year over year. The tool accepts any number of rows. With fewer than four months, treat the trend and volatility figures as indicative only, because two end points and a tiny sample can mislead in either direction.

What is a good deposit trend?

Flat to modestly rising is what most funders want to see; the tool flags a decline worse than 15 percent from first to last month. Strong growth is welcome but check that the latest month does not contain loan proceeds or a one-off receipt, which would make the trend an illusion. A declining line in a business with low volatility is the strongest early warning the statements give.

Why does bank statement cash flow analysis use 21 business days a month?

Daily-debit products pull on business days, and 252 business days a year divided by 12 is 21 a month. Dividing the monthly debit allowance by 21 converts it to the daily figure the funder will actually withdraw. Some funders use 20 or 22; the difference is small, but be consistent when comparing the result with the daily debits already on the account.

What does a negative room for additional daily debit mean?

That the existing financing debits already take more than the policy share of deposits. Adding another position would stack the merchant beyond your own cap. The usual responses are to decline, to consolidate the existing positions into one longer obligation with a lower combined daily payment, or to wait until the existing balances pay down and re-run the analysis.

Should withdrawals include the existing financing debits?

Yes. The withdrawals column is total debits as the bank reports them, which includes payments to other funders. That is correct for net cash flow, because those payments are real outflows. Enter the daily equivalent of those financing debits separately in the existing daily debits field so the room calculation can subtract them from the policy allowance.

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.