Skip to main content

Average Daily Balance Calculator

Calculate a day-weighted account balance free, then copy the schedule or Excel formula.

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

Use this free average daily balance calculator to find the day-weighted mean of an account balance over a statement period. Multiply each balance by the number of days it was held, add those products, then divide by the total days. Banks use this method for interest and minimum-balance calculations.

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.

Daily balance calculator vs average daily balance calculator

A daily balance calculator records or updates the balance for an individual day. An average daily balance calculator combines every daily balance in the statement period into one day-weighted average. Use the day-weighted result when a bank asks for an average balance or applies the average daily balance method.

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>