How to Calculate Average Balance on a Bank Statement
Embassies and lenders often ask for average monthly balance or average daily balance. Here's how to calculate it correctly.
Average daily balance
- Record closing balance for each day in the period
- Sum all daily closing balances
- Divide by number of days
Formula: Average daily balance = Σ daily closing balances ÷ days in period
Average monthly balance
For each month in your statement period:
- Calculate average daily balance for that month
- Or: (Opening balance + Closing balance) ÷ 2 — simplified method some embassies accept
For visa applications, true average daily is more accurate and defensible.
Worked example
| Day | Closing balance |
|---|---|
| 1–30 | $5,000 average |
If balance was $4,000 for 15 days and $6,000 for 15 days:
(15×4000 + 15×6000) ÷ 30 = $5,000 average daily balance
Why embassies care
Average balance shows sustained financial health — not just a last-minute deposit before application. Schengen and UK visas scrutinize sudden spikes.
Automate with StatementsCraft
Our visa format tool computes opening, closing, and average monthly balance on the cover page automatically from your uploaded statement.
FAQ
Average balance vs current balance?
Current balance is one day; average reflects entire period — embassies want average.
Which months to include?
Typically last 3–6 months per visa type.
Excel formula?
Use AVERAGE() on daily balance column if you build a sheet — or use our tool.
Conclusion
Calculate average balance accurately for credible visa and loan applications. Visa format with auto calculation.