Glossary

What is average daily balance on a business bank statement?

Average daily balance is the sum of a business account's end-of-day balances divided by the number of days, weekends included. Lenders use it to see how much cash the business normally keeps, which the ending balance on a statement can hide or flatter.

LendPipe team

Why not just use the ending balance

The ending balance is one day out of thirty. A deposit on the last day of the month, or a payment that clears the next morning, moves it without saying anything about the month. The average daily balance uses every day, so a balance that sits near zero for three weeks shows up even if the statement closes high.

Some banks print it. When they don't, rebuild each day's close from the opening balance and that day's credits and debits, then take the mean. Days a weekend or holiday carries over count at the last close.

Worked example: June's two balances

Copper Lane Bakery ending and average daily balance by month
MonthEnding balanceAverage daily balance
April$29,194.95$21,286.82
June$38,333.94$19,726.78
July$24,725.61$31,116.26
August$28,773.48$32,189.32

June ends on the highest balance in the file, because Kestrel Ridge's $30,000 advance landed on June 15. Its average daily balance is the lowest, pulled down by two days below zero, the deepest at −$8,719.13. The average across the file is $26,171.15.

Set the average against what the account has to pay out. Copper Lane's existing debt works out to $606.76 a business day, so a balance that averages $26,171.15 covers it many times over, except on the two June days it didn't.

Open the Copper Lane Bakery analysisThe sample file every example here comes from: Fernhill Bank statements for April to August, with May missing.

How Underly does it

Negative days and NSFsAverage daily balance, lowest balance, negative days and NSF returns, with a day-by-day balance calendar.

FAQ

Common questions

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

There's no single number. Compare it with the merchant's own debt payments and with its true revenue: an average that covers several days of existing payments reads very differently from one that covers less than one.

Do weekends count in the average?

Yes. Each calendar day counts, and a day with no activity closes at the previous day's balance.

Try Underly free for 7 days

10 credits in the trial. Cancel anytime. Unlimited users on every plan.