Skip to content
Alternative Finance

Broker tools · Brokers and underwriters

Merchant average daily balance calculator

This average daily balance calculator computes the figure underwriters pull from a merchant's bank statement: the sum of each day's ending balance divided by the number of days. Paste one balance per day, or enter balance-and-days segments when the statement only lists days with activity, and it returns the average, the days counted, the lowest and highest balances, the number of days below half the average and the ending balance. It is for brokers and underwriters screening a file. Read the average together with the minimum; an acceptable average with repeated near-zero days is the signature of a business living debit to debit.

Average daily balance
$5,757.14
Days counted
21
Lowest balance
$2,200
Highest balance
$9,600
Days below half the average
2
Ending balance
$5,100

Average daily balance = sum of each day's ending balance ÷ number of days. Underwriters read it with the minimum: a healthy average with repeated near-zero days signals a business living debit to debit.

Formula

List mode: Average daily balance = (Balance on day 1 + Balance on day 2 + … + Balance on day N) ÷ N, where N is the number of balances pasted

Segment mode: each line is a balance and the number of days it was held; the balance is repeated that many times before averaging, so Average daily balance = Σ (balance × days) ÷ Σ days

Lowest balance and Highest balance = the minimum and maximum of the expanded daily list; Ending balance = the last balance in the list

Days below half the average = count of days whose balance is less than 0.5 × Average daily balance

Worked examples

Example 1: the default 21-day list

The default balances are 5,200; 5,200; 6,100; 3,900; 3,900; 3,900; 7,400; 8,100; 2,200; 2,200; 5,600; 6,900; 7,100; 7,100; 4,800; 4,800; 9,200; 9,600; 6,300; 6,300; 5,100. Adding them in groups: 5,200 + 5,200 + 6,100 = 16,500; 3,900 × 3 = 11,700; 7,400 + 8,100 = 15,500; 2,200 × 2 = 4,400; 5,600 + 6,900 = 12,500; 7,100 × 2 = 14,200; 4,800 × 2 = 9,600; 9,200 + 9,600 = 18,800; 6,300 × 2 = 12,600; and 5,100. The total is 16,500 + 11,700 + 15,500 + 4,400 + 12,500 + 14,200 + 9,600 + 18,800 + 12,600 + 5,100 = $120,900 over 21 days. Average daily balance = $120,900 ÷ 21 = $5,757.14. Lowest balance $2,200, highest $9,600, ending balance $5,100. Half the average is $2,878.57, and only the two $2,200 days fall below it, so days below half the average = 2. Repeated balances on consecutive days are normal: they are days with no posted activity on which the statement carries the balance forward.

Example 2: segment mode from a statement that lists only activity days

Many statements print a balance only on days with transactions. If the statement shows $12,000 held for 5 days, then $3,500 for 9 days, then $800 for 4 days, then $6,200 for 12 days, enter four lines in segment mode: 12000, 5 and 3500, 9 and 800, 4 and 6200, 12. The calculator expands them to 30 daily balances. Sum = 12,000 × 5 + 3,500 × 9 + 800 × 4 + 6,200 × 12 = 60,000 + 31,500 + 3,200 + 74,400 = $169,100. Average daily balance = $169,100 ÷ 30 = $5,636.67. Lowest $800, highest $12,000, ending $6,200. Half the average is $2,818.33, and the four days at $800 fall below it, so days below half the average = 4. Notice that the average is pulled up by the 12 days at $6,200 and the 5 days at $12,000; the 4 days at $800 would have returned a daily debit of $900, which the average alone would never reveal.

Example 3: a ten-day list with a low floor

Balances 3,000; 3,000; 1,500; 400; 400; 6,500; 6,500; 2,800; 2,800; 2,100. Sum = 3,000 + 3,000 + 1,500 + 400 + 400 + 6,500 + 6,500 + 2,800 + 2,800 + 2,100 = $29,000. Average daily balance = $29,000 ÷ 10 = $2,900.00. Lowest $400, highest $6,500, ending $2,100. Half the average is $1,450, and the two $400 days fall below it, so days below half the average = 2. An underwriter reading this file sees an average that clears most funders' minimum for a small advance, but a floor of $400 on two consecutive days, which means a daily debit of $450 would have overdrawn the account twice in ten days. The advance this merchant can carry is set by the floor, not by the $2,900 average.

Why the average daily balance matters in MCA underwriting

A merchant cash advance is collected by a fixed daily debit against the operating account, so the question a funder asks is whether the account will have the money every business day for the length of the term. The average daily balance is the first approximation: an account that holds $5,757 on a typical day can absorb a $300 debit without strain and a $1,500 debit only on good days. Funders compare the proposed daily payment with the average and decline or shorten the term when the ratio is uncomfortable. The same figure drives the size of the advance; a larger average supports a larger payment and so a larger funding amount. This average daily balance calculator reproduces the number the way a statement does so the broker's screen matches the underwriter's.

The average is also where banks and funders agree on method. Bank statements report the average ledger or collected balance across the statement cycle using exactly this arithmetic, which is why the figure on the statement summary page should match what you compute from the daily balance table. If it does not, either days are missing from your paste or the statement has been altered. The FDIC explains how banks post transactions and compute balances, including the difference between ledger balance and available balance; funders underwrite to the ledger balance that appears on the statement.

Underwriters never read the average alone. They read it with the minimum, the count of low days and the trend across months. The merchant bank statement analyzer combines those with deposits and NSFs into a single grade; this tool isolates the average so you can see exactly how it was built and what is dragging it down.

List mode versus segment mode

Statements come in two layouts. Some print a daily balance table that lists every calendar day with its ending balance; paste those in list mode, one per line. Others print a balance only on days with activity, with the balance carrying forward on silent days. For those, segment mode lets you enter each balance with the number of days it was held, and the calculator repeats the balance for the correct count before averaging. The two methods give identical results when the inputs describe the same days; the segment method is simply faster to type from an activity-only statement.

Choosing the input mode
Statement layoutModeHow to enterCommon error
Daily balance table, every day listedListOne balance per line in date orderSkipping weekends when the bank lists them; include every row the bank prints
Balances only on activity daysSegmentsBalance, days held, one segment per lineEntering days between activity as one day; count the calendar days until the next change
Running balance in the transaction listListTake the last balance of each dayTaking every transaction's running balance, which overweights busy days
Statement summary onlyNeitherUse the bank's average as a check and request the full statementAccepting a summary figure that cannot be reconciled

Whichever mode you use, the days counted output should equal the number of days in the statement period. A 30-day statement that produces 22 days counted is missing eight days, and the missing days are usually the ones with the lowest balances, because activity-only statements tend to omit the quiet stretches after a large debit. Funders compute the average over the full cycle, so a paste that omits days overstates the average.

Reading the result with the floor and the ending balance

The lowest balance is the floor: the largest daily debit the account could have survived on its worst day without going negative. In the default example the floor is $2,200 against an average of $5,757, a comfortable relationship; in example 3 the floor is $400 against an average of $2,900, which is not. The days below half the average output counts how often the account dips to that region. Two or three such days in a month on an otherwise healthy account are ordinary; a third of the month below half the average means the average is being held up by a few large deposits and the business is spending the rest of the time near empty.

The ending balance tells you where the merchant is right now, which matters because the first debit on a new advance lands within days of funding. An average of $5,757 with an ending balance of $900 means the first debits hit an account that has been drawn down, often by the payoff of another position or by the merchant's own spending in anticipation of funding. Funders that see a falling ending balance across three statements shorten the term or decline.

How funders use the number

  • Minimum thresholds. Many funders set a floor for the average daily balance below which they will not fund at all, with higher floors for larger advances. The thresholds are not published, but a broker learns each funder's cut-off quickly from declines.
  • Payment-to-balance ratio. The proposed daily debit divided by the average daily balance; funders want it low enough that an ordinary bad day does not return the debit. The MCA daily payment calculator gives the debit for a proposed advance, factor and term.
  • Sizing. The average, together with monthly deposits, sets the maximum advance. The maximum funding amount calculator shows the underwriter's version of that calculation.
  • Trend. Three months of averages that fall while deposits hold steady mean the merchant is spending faster than they earn, usually on existing debits. The average monthly deposit calculator gives the deposit side of the trend.
  • Stacking detection. A sudden drop in the average that coincides with a new daily debit to another funder is a second position. Funders cross-check the balance trend against the debit lines; so should you, with the MCA stacking calculator.

Business owners who want to understand what the number says about their own cash position can read the working capital and cash runway pages; the Federal Reserve's small business credit research documents how often small firms report cash flow gaps as their reason for seeking financing, which is the condition a low average daily balance reflects.

Regulatory context for statement-based underwriting

Sales-based financing providers are increasingly expected to document their underwriting. The commercial financing disclosure laws in California, administered by the DFPI, and New York, administered by the DFS, require an estimated APR on sales-based financing that is computed from projected payments, and the projection starts from the statement data: deposits and balances are what the provider uses to estimate how long the payback will take. The CFPB's Section 1071 rule requires covered providers to collect application data including the amount applied for and the action taken, so a decline on balance grounds becomes a recorded data point.

For brokers, the statement is non-public personal information. The FTC's Safeguards Rule under the Gramm-Leach-Bliley Act reaches finders who bring borrowers and funders together; keep statements encrypted, share them only through the funder's portal and retain them no longer than the funder's agreement requires. This calculator processes the numbers in your browser and stores nothing.

Common input mistakes

  1. Pasting running balances after every transaction instead of the ending balance for each day. A day with twelve transactions then counts twelve times and the average is distorted toward busy days.
  2. Omitting weekend and holiday rows that the bank prints. If the bank lists them, they are days in the cycle and belong in the average.
  3. Entering segments with the wrong day count. The days held is the number of calendar days until the balance next changes, not the number of transactions.
  4. Mixing two accounts. Compute each account separately; funders underwrite the account the debits will come from.
  5. Including the funding wire from a prior advance. A $40,000 credit inflates the average for the rest of the month; note it and, for underwriting purposes, read the average of the days before it separately.
  6. Treating the average as the available balance. Holds on card settlements and pending debits mean the usable balance is often lower than the ledger figure on the statement.

If a merchant's average is too low for the advance they want, the alternatives are a smaller advance sized to the floor, a weekly-debit structure that gives the account time to recover between pulls, or a product that does not depend on the daily balance at all, such as invoice factoring for receivables-heavy businesses or equipment financing for asset purchases. The merchant negative days calculator is the next check when the floor is close to zero.

Questions people ask

How do you calculate average daily balance from a bank statement?

Add the ending balance for every day in the statement period and divide by the number of days. If the statement lists balances only on days with activity, carry each balance forward through the silent days before averaging; segment mode in this calculator does that from balance-and-days pairs. The result should match the bank's own average on the statement summary.

What average daily balance do MCA funders look for?

Thresholds vary by funder and by advance size and are not published. In practice funders compare the proposed daily debit with the average and with the lowest balance, and they look for an average that is stable or rising across three months. A low floor or a falling trend matters more than the level of the average itself.

Is average daily balance the same as average collected balance?

Not quite. The ledger balance counts deposits when posted; the collected balance excludes deposits that have not yet cleared. Most statements show the ledger balance in the daily balance table, and funders underwrite to that. For a merchant with large check deposits, the collected balance can be noticeably lower on the days after a deposit.

Why does the calculator count days below half the average?

Because the average can be held up by a few large deposits while the account spends most of the month near empty. Counting the days below half the average shows how often the balance falls into the region where a daily debit is at risk of being returned, which is what the funder actually cares about.

Can I use the average daily balance calculator for a personal account?

The arithmetic is the same, but merchant cash advance funders require a business operating account in the entity's name and will underwrite only that account. If the business runs through a personal account, opening a business account and building two or three months of history in it is the first step toward funding.

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.