To calculate the average balance of a bank account, add the ending balance for every day of the statement period and divide that total by the number of days in the period. Federal Regulation DD defines the method exactly this way: the full amount of principal in the account for each day, summed, then divided by the days in the cycle.1eCFR. 12 CFR Part 1030 – Truth in Savings (Regulation DD) The arithmetic is simple once the daily balances are in front of you.
What You Need Before You Start
The only raw material is your ending balance for every day in the statement period. Most banks show daily balances on the monthly statement or let you download a transaction history from online banking. If your account receives electronic transfers, the bank is required to send a periodic statement at least monthly during cycles when transfers occur, or quarterly otherwise.2eCFR. 12 CFR 1005.9 – Receipts at Electronic Terminals; Periodic Statements
Check the exact start and end dates of the cycle. Banks don’t always align statements with calendar months. A cycle might run from the 15th of one month through the 14th of the next, and it may span anywhere from 28 to 31 days. That day count is your divisor, so getting it wrong throws off the whole result.
You need a balance for every calendar day, including weekends and holidays. If no transactions post on a Saturday, Friday’s balance carries forward. The account didn’t close; the balance simply persists through any non-business day until new transactions settle.
Cut-Off Times and Posted vs. Pending
A deposit made at 4:00 p.m. may not count toward that day’s ending balance. Banks set a daily cut-off, and under federal rules that cut-off can be no earlier than 2:00 p.m. for in-person branch transactions and no earlier than noon for ATM deposits.3Consumer Financial Protection Bureau. How Long Can a Bank or Credit Union Hold Funds I Deposited Anything arriving after the cut-off is treated as if it arrived the next business day. A large deposit landing one day later shifts your daily balance for that date and can nudge the average up or down.
The ending balance that counts here is the ledger balance: the total after all fully processed credits and debits have posted. Pending items showing in your app but not yet settled won’t appear in the day’s final figure. To match the bank’s number, work from posted transactions, not the real-time available balance.
The Calculation Step by Step
Two moves: add, then divide. Take the ending balance for every day of the statement period, sum them, and divide by the total number of days.1eCFR. 12 CFR Part 1030 – Truth in Savings (Regulation DD)
A Worked Example
Say your statement period is 30 days. You start the month with $2,000. On day 11 you deposit $1,500, bringing the balance to $3,500. On day 21 you withdraw $500, dropping it to $3,000. No other transactions occur. The breakdown looks like this:
- Days 1 through 10, ten days at $2,000: 10 × $2,000 = $20,000
- Days 11 through 20, ten days at $3,500: 10 × $3,500 = $35,000
- Days 21 through 30, ten days at $3,000: 10 × $3,000 = $30,000
The cumulative total is $85,000. Divide by 30 days and the average daily balance is $2,833.33. Even though the account held $3,500 for a third of the month, the lower starting balance pulls the average well below that peak. A big deposit halfway through the month doesn’t help the average as much as people often expect.
Using a Spreadsheet for Longer Cycles
Summing thirty-plus daily balances by hand gets tedious. A simple spreadsheet handles it quickly: put dates in column A and ending balances in column B, use a SUM function on column B, and divide by the day count. Most bank portals let you export transaction history as a CSV, which you can sort into this format in a few minutes. It also makes gaps obvious. If your row count doesn’t match the number of days in the cycle, you’re missing a day.
Average Balance vs. Minimum Daily Balance
Banks use two different balance tests, and confusing them is one of the most common ways people get hit with unexpected fees. An average balance requirement means the bank calculates the average across the entire statement period using the method above. A minimum daily balance requirement means the balance cannot dip below a set threshold on any single day.
The difference matters most on bad days. If an account requires a $1,500 average balance and you briefly dip to $800 after paying rent, you can recover by depositing funds later in the month. The low day drags the average but doesn’t automatically trigger a fee. Under a minimum daily balance rule, that single $800 day is enough to incur the penalty, no matter what you deposit afterward.
Before running either calculation, check your account’s fee schedule to see which test applies. The language usually sits in the account disclosure or terms-and-conditions document you received when opening the account. If you can’t find it, the bank is required to provide these terms on request under Regulation DD.1eCFR. 12 CFR Part 1030 – Truth in Savings (Regulation DD)
When Your Number Doesn’t Match the Bank’s
If you run the formula and land on a different average than what your statement shows, the most likely culprit is a timing mismatch. Deposits made near the cut-off may have posted a day later than you expected, shifting balances by a day. Holds on deposited checks can also create discrepancies: the bank’s ledger may not reflect a check deposit until the funds actually clear, even though your available balance shows the money sooner.
Another common error is using the wrong date range. If your statement cycle runs from October 18 through November 17, that’s 31 days, not the 30 you might assume for a “monthly” statement. Dividing by the wrong day count will always produce a different result than the bank’s.
If you’ve double-checked the dates, verified every daily balance against the posted transaction history, and still can’t reconcile, contact the bank. Federal regulators enforce Truth in Savings Act requirements through administrative oversight, and banks are obligated to accurately disclose the figures they use to charge fees or calculate interest.4Office of the Law Revision Counsel. 12 USC 4309 – Administrative Enforcement If you believe the bank made an error and isn’t correcting it, you can file a complaint with the Consumer Financial Protection Bureau.