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
| Month | Ending balance | Average 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.Related terms
More guides
- The MCA underwriting checklist for bank statementsEvery check in order, from a complete file to a priced offer.
- How to spot MCA stacking on bank statementsFinding every position, reading its cadence and working out the monthly burden.
- How to calculate true revenue from bank statementsEvery exclusion, with a worked month from gross deposits to true revenue.
- How to spot a fake or altered bank statementRed flags in the numbers, the document, the account details and the file, and how to confirm a statement with the bank.
- How to size an MCA offer with debt-to-revenue and holdbackA worked example from existing positions to the room left for a new advance.