Monthly Average Balance Formula and Calculator

The monthly average balance formula is the sum of the account’s balance on each day of a statement period divided by the number of days in that period. Enter daily balances below to calculate the average; the result is a simple arithmetic average, not an interest charge.

Formula

For a period with one balance recorded for every day, add the daily balances and divide by the number of days:

Monthly average balance = (B₁ + B₂ + … + B_d) ÷ d

• B_i is the balance for day i, measured in dollars in this example.
• d is the number of days represented in the list.
• Monthly average balance is the resulting average balance, in dollars.

The calculator uses mean(bal), which is the sum of the values in the list divided by the number of values. The list can contain a different number of entries; enter one daily balance for each day in the period you want to analyze. The output count helps verify that the list has the intended number of days.

Worked Example

The defaults are 30 daily balances, each equal to $100. The calculation is:

1. Sum the daily balances: 30 × $100 = $3,000.
2. Count the daily balances: 30.
3. Divide the sum by the count: $3,000 ÷ 30 = $100.00.

The calculator therefore returns a monthly average balance of $100.00, 30 daily balances, and a sum of $3,000.00.

Assumptions

• Each list entry is the balance for one day, and every day in the period is represented once.
• All entries use the same currency and balance convention; do not mix dollars with cents or different kinds of balances.
• The calculation gives each day equal weight. It does not apply an interest rate, compounding schedule, payment timing, fees, taxes, insurance, PMI, or escrow.
• The result is an arithmetic average, not an account’s ending balance or a lender’s separately defined balance measure.

How the Monthly Average Balance Works

A balance can change during a month because of purchases, deposits, payments, withdrawals, or other transactions. Averaging daily balances captures how long each amount remained in the account. A balance that stays in place for many days contributes more to the average than a balance present for just one day.

For example, suppose a 30-day period starts with a $900 balance. A $300 payment posts after day 10, leaving $600 for the remaining 20 days. If those are the only changes, the daily balances total 10 × $900 + 20 × $600 = $21,000. The monthly average is $21,000 ÷ 30 = $700. The ending balance is $600, so the average and ending balance are different.

In real account records, transaction posting dates and the account’s stated method determine which balance applies to each day. A transaction initiated on one date may not be reflected in the balance until it posts. Use the daily figures from the relevant statement or account records when matching a provider’s calculation.

When to Use This Calculation

This formula is useful when you need a plain average of daily balances over a defined period. It can help summarize how much money was in an account on average, compare periods using the same method, or check a calculation that is explicitly based on daily balances. It does not, on its own, calculate interest, a minimum-balance fee, or a required payment.

Check what “monthly average balance” means in the context where you saw the term. Some statements or products may use a different definition, such as averaging balances at selected dates, using an average daily balance for interest, or applying separate rules to eligible balances. The phrase alone does not establish which method applies.

Common Errors and Limits

• Using only the opening and closing balances: those two figures cannot show how balances changed on the days between them.
• Dividing by the wrong number of days: divide by the number of daily entries actually included, not automatically by 30. Periods can have different lengths.
• Leaving out days or duplicating entries: either mistake changes the average. Confirm the count against the period being analyzed.
• Mixing balance types: do not combine, for example, a statement balance with an available balance unless the intended method calls for it.
• Rounding too early: use the available daily figures at their stated precision, then round the final result to cents. Rounding each daily value first can alter the result.

The calculator averages the values supplied and cannot confirm whether they match a statement’s day-by-day method. It also does not account for transaction timing, different account rules, interest rates, or fees. For an exact product-specific figure, use the definition and records supplied by the account provider.

Related Calculation: Average Daily Balance

“Average daily balance” is commonly used to describe the same basic arithmetic operation: add each day’s balance and divide by the number of days. However, a financial product may define the balances included, the relevant dates, or the treatment of transactions in its own terms. Some interest calculations also apply a periodic rate to an average balance; that extra step is not part of this calculator. Do not treat the average alone as the amount of interest due.

Frequently Asked Questions

How do I calculate a monthly average balance?
Add the balance for every day in the period, then divide by the number of days represented. Use balances measured on a consistent basis.

Is monthly average balance the same as ending balance?
No. The ending balance is the balance at the end of the period; the monthly average incorporates all included daily balances and can be higher or lower.

Do I divide by 30 or by the number of days in the month?
Divide by the number of daily balances included. If the period has 31 days and all 31 daily balances are listed, divide by 31; use 28 or 29 for a complete February period as applicable.

Can I calculate the average from opening and closing balances?
Not reliably if the balance changed during the period. The two figures do not reveal when deposits, payments, or other transactions changed the balance.

Does this formula calculate interest?
No. It returns an average balance only. Interest calculations may use a rate and product-specific rules in addition to an average, so consult the relevant statement or account terms for that calculation.

This result is an estimate based on the daily balances entered; the account provider’s statement or disclosure gives the exact figures for its method.

Related

• Energy Balance: Calculate Intake Minus Expenditure
• How to Balance a T Account: Steps and Examples
• Beginning Balance: How to Calculate It

list bal | Daily balances ($) | 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100
out avg | Monthly average balance | $ | mean(bal) | 2
out days | Number of daily balances | - | count(bal) | 0
out total | Sum of daily balances | $ | sum(bal) | 2