Skip to main content

Average Daily Balance Calculator

Compute the average daily balance of an account over a statement period.

BalanceDays held
$
d
$
d
$
d

Average daily balance

$2,220.00

Periods3
Total days30

Each balance is weighted by the number of days it was held, then divided by the total days in the statement period.

Run these numbers on real data

These results are only as good as the figures you put in. Convert your PDF bank statements to Excel or CSV, review the extracted rows, then total your real deposits, expenses, and balances.

Convert a statement free

The average daily balance is the day-weighted mean of an account's balance over a statement period. It is found by multiplying each balance by the number of days it was held, summing those products, and dividing by the total days. Banks use it to calculate interest and to assess minimum-balance fees.

How the average daily balance method works

For each segment of the statement period, multiply the balance by the number of days it stayed at that level. Add the products together, then divide by the total number of days in the period. The result is the average daily balance.

Where to find your daily balances

Daily balances come from the running balance column of your bank statement. Convert the PDF statement to a spreadsheet, review the extracted balances, then group consecutive days that held the same balance before using the calculator.

Average daily balance formula in Excel

Put each balance in column A and the number of days it remained in effect in column B. For rows 2 through 4, use this formula:

=SUMPRODUCT(A2:A4,B2:B4)/SUM(B2:B4)
Worked average daily balance example
BalanceDays heldBalance x days
$2,50010$25,000
$1,20012$14,400
$3,4008$27,200
Average30 days$2,220.00

Use the monthly statement as the source record. If the balances are locked in a PDF, first use the PDF bank statement to Excel converter, then verify the extracted rows before calculating the average.

Download the Excel-ready CSV template

Frequently asked questions

Related calculators

Embed this calculator

Add this free average daily balance calculator to your own site. Copy and paste the snippet below.

<iframe src="https://bankscanpro.com/calculators/embed/average-daily-balance" width="100%" height="760" style="border:1px solid #e5e7eb;border-radius:12px;max-width:760px" title="Average Daily Balance Calculator by BankScanPro" loading="lazy"></iframe>