Average Daily Balance: How to Calculate It for Lenders

Average daily balance (ADB) is the sum of an account's end-of-day balances across a statement cycle, divided by the number of days in that cycle. Lenders and merchant cash advance funders use it as a liquidity test: it shows whether a business keeps a real cash cushion or whether money lands and leaves the same day. As a rough rule, most funders want to see an average daily balance worth at least 5% to 15% of monthly deposits before they advance.

What is average daily balance?

Average daily balance is the mean of an account's closing balance over every day in the statement period. You take the end-of-day balance for each day, including weekends and holidays, add them together, and divide by the number of days. Unlike a single closing balance, it reflects how much cash the account actually held day to day, not just where it happened to land on the last day of the cycle.

That distinction is the whole point for an underwriter. A merchant can move money out the day a statement closes and post a tiny ending balance, or leave a large deposit sitting on the last day and look flush. The average smooths both tricks, so it is much harder to dress up than a closing snapshot.

How do you calculate average daily balance?

Add each day's ending balance for the full statement period, then divide by the number of days in that period. A day with no transactions carries the previous day's balance forward, so every calendar day counts, not just the days with activity. Here is a short worked example over a seven-day stretch.

The daily balances add up to $77,000. Divide by 7 days and the average daily balance is $11,000. Notice that the closing balance on day 7 was only $9,000, so the snapshot understates the real cushion by $2,000. On a different account the snapshot would overstate it. That gap is exactly why lenders work from the average instead of the ending number.

What is the average daily balance formula?

The formula is simple: average daily balance equals the sum of every day's ending balance divided by the number of days in the period. In plain terms, ADB = (total of daily closing balances) / (days in the cycle). It is the same averaging method credit card issuers use to charge interest, but lenders apply it to borrower statements to gauge liquidity rather than to compute a finance charge.

Why do lenders care about average daily balance?

Lenders care because average daily balance measures liquidity, not just revenue. A business can deposit $50,000 a month and still run an ADB of $800 if the money leaves as fast as it arrives, which means there is no cushion to absorb a slow week or a new loan payment. Revenue tells you the business has sales. ADB tells you whether it can actually carry a payment.

This is why ADB sits next to deposit volume on almost every funder's scorecard. A healthy average daily balance signals that the borrower can ride out timing gaps between receivables and bills, and that a daily or weekly remittance will not immediately tip the account negative. Read it together with negative days and NSF activity for the full liquidity picture: a strong deposit base with a thin balance and frequent NSF and overdraft fees is a classic stretched-cash-flow profile. For the wider read on judging repayment ability from the statement, see our guide to cash flow underwriting.

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

Most MCA funders want an average daily balance worth at least 5% to 15% of monthly deposits, with the exact threshold set by paper grade and risk appetite. On $50,000 of monthly deposits, that is roughly $2,500 to $7,500. A higher ADB supports a larger advance and a more aggressive remittance schedule; a thin ADB caps the offer or kills the file outright. The table below shows common benchmarks.

These are common policy ranges, not a fixed rule. Each funder sets its own credit box, and an A-paper deal will clear a lower ADB ratio than a high-risk file. Confirm the threshold against your own guidelines, and read ADB alongside the advance the merchant may already be carrying, since stacked positions drain the balance fast. Our guide to detecting loan stacking from bank statements covers how to spot those existing remittances.

Average daily balance vs minimum balance vs ending balance

The minimum balance is the lowest point the account touched during the cycle; the ending balance is where it closed on the last day; the average daily balance is the mean across every day. ADB is the most reliable of the three for underwriting. One large deposit on the last day can flatter an ending balance, and a single rough day sets the minimum, while the average absorbs both and shows the typical level of cash the business kept on hand.

How many negative days are too many?

A few negative days a month can be tolerable for an otherwise strong file, but ten or more negative days in a single month is a serious red flag. It tells the underwriter the account regularly runs out of money, and adding a daily or weekly MCA remittance would push it further into overdraft. Negative days and a low average daily balance usually travel together, and the combination is one of the most common reasons a cash-flow file gets declined.

How to calculate average daily balance automatically

Calculating ADB by hand means reading the daily ending balance off every page of every statement, carrying weekends forward, and repeating it across 6 to 12 months. One missed weekend balance throws the average off, and the work scales badly when you are reviewing dozens of files a week. Software does it from the source.

LenderAnalyzer reads the daily balances from every uploaded statement and reports the average daily balance per month alongside deposits, NSF counts and negative days, so you read the number instead of building it. Upload a borrower's statements to the cash flow analysis software and the full liquidity picture comes back in one pass, including the verified merchant cash advance underwriting metrics funders score on. The same extraction also powers bank statement analysis and bank statement verification, so the balances you average are the balances you have already confirmed are genuine.

If you would rather pull the daily ending-balance column into your own model, you can convert the bank statement to an Excel or CSV spreadsheet first and build the series there. And once an advance is approved, send the funding agreement out for signature with an online document e-signing tool to close the file without printing or scanning.