How to Calculate Average Monthly Balance (and Average Daily Balance) From Bank Statements

Last updated July 2026.

Quick answer: Average daily balance equals the sum of your end-of-day balances over a period divided by the number of days in that period. Average monthly balance is the average of your monthly figures, usually the average of each month's daily balance or of the month-end balances. Because your balance only changes on days you have a transaction, the fast way to compute it from a statement is to weight each balance by the number of days it stayed the same, add those up, and divide by the day count. Lenders use these numbers to judge your cash cushion and your ability to service new debt.

The reason this comes up is almost always a loan. A single snapshot balance can be gamed by timing one deposit, so lenders look at the average across a period instead, and so should you when you size your own reserves. Here is how to compute it from the statement you already have.

How do you calculate average daily balance?

Take the closing balance for every day in the period, add them all together, and divide by the number of days. Written out: average daily balance = (sum of end-of-day balances) divided by (number of days in the period). This captures the ups and downs across the whole period rather than a single moment, which is why it is a truer picture of how much cash you actually kept on hand. The one trick is that you do not need a balance typed for all 30 or 31 days. Your balance holds steady between transactions, so you weight each balance by how many days it lasted.

What is average daily balance on a bank statement?

On a statement, the average daily balance is what your account held on a typical day across the statement period, read from the running-balance column. Each row shows the balance after that day's activity, and that balance carries forward until the next transaction changes it. To turn that column into an average, you multiply each balance by the number of days it stayed in effect, sum those products, and divide by the total days. That weighting is the whole game, and it is why the running balance matters: lose it, and you cannot reconstruct the daily figures the calculation needs.

How is average monthly balance calculated?

Average monthly balance is calculated by averaging your balance across the months in question. There is no single universal formula, so define which one you mean: the most defensible versions are the average of each month's average daily balance, or the average of the month-end balances across the period. For a lender reviewing several months, the average of the monthly daily balances is the stronger measure because it reflects the whole month, not just the day the statement closed. Whichever you use, state it, because a month-end average and a daily average can differ a lot for an account that swings during the month.

A worked example from a running-balance column

Suppose a 31-day month where the account held $1,000 for the first 15 days and $1,500 for the remaining 16 days. Weight each balance by its days:

Divide the total by the days: $39,000 divided by 31 equals $1,290.32. That is the average daily balance for the month. In a spreadsheet you would put each daily balance in a column, or list balance and days-held pairs, and let a formula do the weighting. When your statement is a clean set of rows with the running balance intact, this is a two-column calculation instead of an hour of manual math.

Why do lenders want bank statements?

Lenders read bank statements to see three things the balance snapshot hides: your cash cushion, how often you run into non-sufficient-funds or overdraft trouble, and whether your deposits are steady enough to service a new payment. Average daily and average monthly balance are the headline numbers because a healthy average signals reserves, while a thin average with frequent overdrafts signals cash-flow stress. Different lenders weigh it differently. Business lenders reviewing a line of credit look hard at the average daily balance and NSF frequency, self-employed mortgage borrowers get their income built from averaged deposits, and revenue-based funders score average balance, negative-balance days, and deposit consistency together.

How many months of bank statements do I need for a loan?

It depends on the loan. Business loans and lines of credit commonly ask for 3 to 6 months of statements. SBA 7(a) lenders analyze the operating account and typically want the statements for the 3 months preceding the request. Bank-statement mortgages for self-employed borrowers usually want 12 to 24 months, with 12 sometimes enough for strong credit and a large down payment. Merchant cash advance and revenue-based funders review 3 to 6 months. The safe planning range is 3 to 24 months depending on the product, so pull more than you think you need and convert them all to one workbook. Some benchmarks you will hear, like a minimum average daily balance or an NSF cap, are lender rules of thumb rather than fixed standards, so treat them as directional.

Where the converter fits

To average your balances, you first need the daily balances in a spreadsheet, and that is what BankXLSX does: it converts each PDF statement into dated rows with the running balance preserved, so the weighted average is a formula rather than manual keying. It does not compute your loan eligibility or make a lending decision; it prepares the data your lender, your accountant, or you then analyze. If you are assembling a loan package, convert every month, then see how to prepare bank statements for a loan and our guide for the lenders and underwriters who will review them. Underwriters usually verify income from your other paperwork too, so it helps to have pay stubs and tax returns ready to pull the numbers out of those documents the same way.