Average Daily Balance: Definition, Formula, and How to Calculate It

Whether you're reviewing credit card interest charges, reconciling a savings account, or auditing a client's books, the average daily balance (ADB) appears constantly in finance. Yet many accountants and business owners have never worked through the calculation themselves. This guide covers the definition, formula, a step-by-step worked example, and how to calculate ADB in Excel using a bank statement transaction log.

What Is Average Daily Balance?

The average daily balance is the mean balance held in an account over a specific period, typically a monthly billing or statement cycle. Banks and credit card issuers use it as the baseline for calculating interest charges, overdraft fees, and minimum balance requirements.

Rather than snapshot a balance on a single day — which could be manipulated — ADB smooths every transaction across the full period, giving a fairer picture of how much money actually sat in (or was owed on) the account.

Average Daily Balance Definition

The average daily balance definition used by virtually all U.S. banks, credit card companies, and financial institutions is straightforward:

ADB = (Sum of Daily Ending Balances) ÷ (Number of Days in the Period)

You take each day's closing balance — whether a transaction occurred or not — add them all up, and divide by the number of days in the billing or statement cycle.

ADB Formula: Worked Example

Here is a 7-day transaction log to illustrate the calculation:

Sum of daily balances: $2,000 + $2,000 + $1,600 + $1,600 + $2,600 + $2,600 + $2,400 = $14,800

ADB = $14,800 ÷ 7 = $2,114.29

This is the figure a lender would use when calculating interest for that week. Days with no activity still count — the previous day's balance carries forward.

Why Average Daily Balance Matters

Credit Card Interest

Most credit card companies apply the daily periodic rate (annual APR ÷ 365) to the ADB for each billing cycle. A lower ADB means lower interest charges — which is why making mid-cycle payments reduces your bill more than waiting until the due date.

Savings Account Interest

Many banks credit interest on savings accounts based on the ADB over the month. If your balance dips for even a few days, your earned interest drops proportionally, even if you restore the funds before the statement closes.

Overdraft Protection and Fees

Some banks waive monthly maintenance fees only if your ADB stays above a threshold — often $1,500 to $5,000 for checking accounts. Tracking your running balance daily is the only reliable way to stay above that line.

Business Lending and Analysis

For bookkeepers and accountants, ADB appears in working capital analysis, cash flow forecasting, and credit facility reviews. Lenders frequently request average daily balance figures when evaluating a business line of credit or revolving facility.

How to Find ADB on Your Bank Statement

Most banks do not print the ADB directly on a standard bank statement — they calculate it internally. Credit card statements are the exception: they often include it in the interest charge section, labeled "Average Daily Balance" or "Balance Subject to Interest Rate."

For deposit accounts, you need to calculate ADB manually from your statement of an account — a full, transaction-by-transaction record of every debit and credit in the period.

Statement of Account vs. Bank Statement

These terms are often used interchangeably, but there is a meaningful distinction:

• Bank statement: A summary document issued by the bank, typically monthly, showing opening balance, individual transactions, and closing balance.
• Statement of account: A broader term covering any detailed transaction record — it may span multiple months, cover multiple accounts, or be issued by a vendor, lender, or financial institution.

For ADB calculations you need the granular transaction-level detail that a full statement of account provides, not just a monthly summary.

How to Calculate ADB in Excel: Transaction Log Approach

Converting your bank statement into an Excel account transaction log makes ADB calculation fast and auditable:

1. Convert your bank statement into a spreadsheet with columns: Date, Description, Debit, Credit, Running Balance.
2. Fill every calendar day in the period — for days with no transactions, carry forward the prior day's closing balance so every day has a row.
3. Sum the Running Balance column: =SUM(E2:E32) for a 31-day month.
4. Divide by the number of days: =SUM(E2:E32)/31.

The result is your average daily balance for the period. For credit card statements, use the same approach on the transaction export from your card issuer.

If your bank statement is a PDF, you need to extract the data before you can work with it in Excel — which is where most of the manual effort goes.

Calculate ADB Faster with LedgerLift

Manually retyping transactions from a PDF bank statement is slow and error-prone. LedgerLift converts any PDF bank statement into a clean Excel or CSV transaction log in seconds — no templates, no bank-specific setup required, works with any bank worldwide.

Upload your statement, get a structured spreadsheet back, and drop it straight into your ADB formula. You can also push transactions directly to QuickBooks Online, sync finished files to Google Drive or Dropbox, and edit transactions inline before exporting.

Start free — 120 pages, no credit card required.

---

Frequently Asked Questions

What is the average daily balance method?

The average daily balance method is the most common way credit card companies calculate interest. It totals the ending balance on each day of the billing cycle and divides by the number of days in that cycle. The resulting ADB is then multiplied by the daily periodic rate (APR ÷ 365) to determine the interest charge for the period.

How do I calculate average daily balance in Excel?

Create a transaction log with one row per calendar day and a running balance column. Carry forward the prior day's balance on any day with no transactions. Then use =SUM(BalanceRange)/NumberOfDays to get the ADB. If your source data is a PDF bank statement, use LedgerLift to convert it to Excel first — it takes seconds and handles any bank format.

What is a statement of an account?

A statement of an account is a detailed record of all transactions in an account over a given period, issued by a bank, lender, or vendor. Unlike a summary bank statement, it provides the transaction-level detail — date, amount, running balance — you need to calculate daily ending balances and derive the ADB accurately.

Does average daily balance include pending transactions?

Generally no. Banks and credit card issuers use posted (cleared) transactions to calculate each day's ending balance. Pending transactions that have not yet settled are typically excluded from the ADB calculation, though policies vary by institution.

What is a good average daily balance to maintain?

It depends on your bank's requirements. Many banks waive monthly maintenance fees if your ADB stays above $1,500 (checking) or $300–$500 (savings). For credit cards, a lower ADB reduces interest charges — paying down your balance mid-cycle rather than waiting until month-end lowers your ADB and the interest you owe.

How does average daily balance affect savings account interest?

Savings accounts that pay interest based on ADB reward consistently high balances throughout the month. A single large withdrawal mid-cycle lowers your ADB for the entire period, reducing the interest you earn — even if you replenish the funds before the statement date. Timing transfers carefully can meaningfully improve your monthly interest income.