Proof of Funds Bank Statement: What to Provide
What a proof of funds bank statement needs to show, how reviewers read balances and large deposits, and how to check your statements in Excel first.
SheetStatement Team11 min read
On this page
- What "proof of funds" usually means
- Who asks for proof of funds, and what they tend to look for
- How reviewers commonly read a statement
- Never edit a statement
- Step 1: gather the right statements
- Step 2: convert and check each statement
- Step 3: find deposits that need explaining
- Step 4: total funds across accounts
- A worked example
- Building a combined daily balance
- Bank letter or statements?
- Privacy
- Common mistakes
- A short checklist
- Check your statements before you submit
- FAQ
TL;DR A proof of funds bank statement is an official statement (or a letter from your bank) showing that you have enough money available for a specific purpose, such as a home purchase, a visa, studying abroad or a large transaction. Reviewers generally look for your name, the bank's details, a recent date, a balance at or above the required amount, and, often, a history showing the money has been there for a while rather than arriving just before you applied. Provide the exact documents and date range the requester asks for, never edit a statement, and be ready to explain any large recent deposits. Before you submit, convert your statements to a spreadsheet so you can check the minimum and average balances, spot deposits that need explaining, and add up funds across accounts.
Sooner or later, many people are asked to prove they have money. A seller wants evidence that a cash buyer can actually pay. A consulate wants to know a visitor can support themselves. A university needs evidence that an international student can cover tuition and living costs. A landlord, a business partner or a lender might ask too.
The request is usually phrased simply, "proof of funds" or "evidence of funds", but the details matter. Submitting the wrong date range, a screenshot instead of a statement, or a balance that only just appeared can delay or derail an application. This guide explains what proof of funds usually involves, how reviewers tend to read statements, how to check your own statements beforehand, and how to handle common complications.
This is general information, not legal, immigration or financial advice. Requirements depend on who is asking and why, and they change. Always follow the specific instructions you've been given, and ask the requesting organisation or a qualified adviser if anything is unclear.
What "proof of funds" usually means
Proof of funds is documentary evidence that money is available to you. The most common forms are:
- Official bank statements covering a specified period, usually in PDF or on paper, showing your name, account details, transactions and balances.
- A bank letter on the bank's letterhead confirming the account holder, the balance on a given date, and sometimes how long the account has been open.
- Investment or savings account statements, where the requester accepts funds held outside a current account.
What's acceptable depends entirely on the requester. Some accept a recent statement; some want several months; some want a letter dated within a few days of the application; some want both.
Who asks for proof of funds, and what they tend to look for
Home purchases. Sellers and their agents often want to see that a buyer can complete, especially for cash offers. Mortgage lenders separately verify the down payment and closing costs, and they commonly look at where the money came from as well as the balance. Our guide to bank statements for a mortgage application covers lender review in more depth.
Visas and immigration. Many visa routes require evidence that you can support yourself, and some set specific rules on the amount, the currency, how long the funds must have been held, and the age of the statements. These rules are detailed and strict. Our guide to bank statements for a visa application covers general preparation, but the official guidance for your route is what counts.
Study abroad. Universities and student visa processes often require evidence of funds for tuition and living costs, sometimes in a sponsor's name with a supporting letter.
Business transactions. Buying a business, investing, or entering a large contract may involve proof of funds, often through a bank letter or an adviser.
Rentals. Some landlords ask for statements as evidence that you can pay rent, particularly if you don't have a long employment history. See our guide to bank statements for a rental application.
How reviewers commonly read a statement
Whoever reviews your statement is usually checking a few things.
Identity. Does the name on the statement match the applicant (or the named sponsor)? Is the bank identifiable?
Recency. Is the statement recent enough? Many requesters set a maximum age.
Amount. Is the balance at or above the required amount? Some requesters look at the closing balance, some at the balance on a specific date, some at the lowest balance over a period.
History. Has the money been there for a while? A large deposit just before the application is a common reason for follow-up questions, because the reviewer wants to know where it came from. The idea of money being "seasoned", held for a period, is widely used in mortgage lending, and some visa routes have explicit holding-period rules.
Consistency. Do the transactions look normal for the person? Are there unexplained transfers in from other people? Does the statement look authentic and unaltered?
You can't control the rules, but you can check your statements against these points before anyone else does.
Never edit a statement
It's worth saying plainly: don't alter, recreate or "tidy up" an official statement. Submitting a modified bank statement can be treated as fraud and can have serious consequences, including refusal of the application and legal action. If something on your statement needs explaining, explain it with a separate letter and supporting documents.
The spreadsheet work in this guide is for your own review. You send the original documents.
Step 1: gather the right statements
Read the request carefully and note:
- Which accounts are acceptable (current, savings, investments, joint accounts, accounts in a sponsor's name).
- The date range or number of months.
- How recent the latest statement must be.
- The format: PDF download, stamped paper statement, or bank letter.
- The currency, and whether conversion to another currency is required.
Then download the statements for each account. If you need older statements, our guide to how to get old bank statements explains the usual routes.
Step 2: convert and check each statement
Convert each statement to a spreadsheet so you can analyse it. SheetStatement reads the PDF into rows and checks that the opening balance plus transactions equals the closing balance, which confirms nothing is missing. The free plan covers 3 pages a month; paid plans start at $9 a month.
Your table should have Date, Description, Amount and Balance columns, plus an Account column if you have several accounts. With balances in column E, three numbers matter:
Closing balance: =INDEX(E:E, COUNTA(E:E))
Lowest balance: =MIN(E2:E500)
Highest balance: =MAX(E2:E500)
The lowest balance is often the most revealing. If the requirement is $20,000 and your closing balance is $24,000 but your balance dipped to $9,000 in the middle of the period, a requester looking at the whole period may not consider the requirement met.
Some requesters look at an average balance. Our guide to calculating the average daily balance from a bank statement shows how to do it properly, weighting each balance by the number of days it was held.
Step 3: find deposits that need explaining
Filter for large deposits, for example anything over a set amount or a percentage of your usual monthly income:
=FILTER(Tx, (Tx[Amount] > 2000), "None")
For each one, ask: would a stranger know where this came from? Common examples:
- Salary or business income: usually self-explanatory if it's regular.
- A transfer from your own savings: show the matching withdrawal on the other account's statement.
- A gift from family: often needs a gift letter and sometimes the donor's statement showing the money leaving their account. Mortgage lenders in particular commonly have specific gift requirements.
- Proceeds from selling a car, property or investments: keep the sale documents.
- A loan: some requesters won't accept borrowed money as proof of funds, so check.
Prepare an explanation and the supporting documents for each. Our guide to Excel FILTER for bank transactions shows more ways to pull out transactions of interest.
Step 4: total funds across accounts
If you're combining accounts, build a small summary:
| Account | Holder | Currency | Closing balance | Lowest balance in period |
|---|
Be careful with transfers between your own accounts. If you moved $5,000 from savings to checking during the period, it appears as a deposit in one and a withdrawal in the other. It doesn't change your total, but it can look like new money in the receiving account. Tag those transfers so you can explain them easily.
If the requirement is in another currency, note which exchange rate the requester uses, if specified. Some visa routes specify the rate source and date. Don't assume.
A worked example
Someone applying to study abroad must show funds of at least $18,000, held for the last two months, with statements no older than a month at the time of application. (These figures are illustrative; real requirements differ.)
They have two accounts:
| Account | Closing balance | Lowest balance in the last two months |
|---|---|---|
| Savings | $15,200.00 | $15,000.00 |
| Checking | $4,350.00 | $1,120.00 |
| Total | $19,550.00 | — |
At first glance, the closing balances total $19,550, above the $18,000 requirement. But the checking account dropped to $1,120 at one point, and if that low fell on a day when savings was also at its lowest, the combined balance would have been $16,120, below the requirement. If the requester measures the lowest combined balance over the period, this application could fall short.
A combined daily balance column shows the true position. With both accounts' transactions stacked and sorted by date, a running total of all amounts plus the two opening balances gives the combined balance each day. The minimum of that column is the figure to compare. Our guide to combining multiple bank statements in Excel explains how to stack accounts.
The spreadsheet also flags a $6,000 deposit into savings seven weeks ago, labelled as a transfer from a family member. That's inside the two-month window and needs explaining, likely with a sponsor or gift letter and evidence of the source, according to the specific rules.
With this review done before applying, the student can decide whether to wait until the funds have been held long enough, add a sponsor's funds if allowed, or prepare the required explanation. Finding out from a refusal is far more expensive.
Building a combined daily balance
Checking each account's lowest balance separately is a useful first look, but it can mislead in both directions: two accounts may hit their lows on different days, or a transfer between them may make one look low while the total is unchanged. A combined daily balance answers the real question.
Here's a straightforward way to build it:
- Stack the transactions from every account into one table with Date, Account and Amount columns.
- Add one row per account at the start of the period for its opening balance, dated the first day, with the opening balance as the amount.
- Sort the whole table by date.
- Add a running total column. With amounts in column C starting at row 2, put
=C2in D2 and=D2+C3in D3, then fill down.
The running total is your combined balance after each transaction. Because several transactions can happen on the same day, the balance that matters for each day is the last one for that date. To find the lowest end-of-day combined balance, add a helper column that flags the last row for each date:
=IF(A2<>A3, D2, "")
Fill it down and take =MIN() of that helper column. Transfers between your own accounts cancel out in this view, because the withdrawal from one account and the deposit into the other both sit in the same running total. That's exactly the behaviour you want.
If the result is comfortably above the requirement, you have useful reassurance. If it's close or below, you know before the reviewer does, and you can plan accordingly.
Bank letter or statements?
Some requesters accept a bank letter confirming the balance on a date. Letters are short and simple but show no history, so they may not satisfy a holding-period requirement. Statements show history but contain more personal information.
If you can choose, consider what the requester is trying to establish. If they care about the money being there over time, statements are usually needed. If they only want a snapshot, a letter may do. When in doubt, ask.
Privacy
Statements show every transaction, including who you pay and where you shop. Some people want to redact unrelated details. Whether that's acceptable depends on the requester; some reject redacted statements outright. Ask before redacting anything, and never change balances or amounts.
Common mistakes
Sending screenshots. App screenshots are rarely accepted as proof of funds. Use official statements or letters.
Wrong date range. Check exactly which months are required and whether the latest statement is recent enough on the date you submit.
A last-minute large deposit with no explanation. Prepare the evidence before you're asked.
Ignoring the lowest balance. Your closing balance may meet the requirement while your balance during the period did not.
Counting money that isn't yours. Funds in a business account, an account held for someone else, or a joint account may not count as yours. Check the rules.
Counting borrowed money. Some requesters won't accept loans or credit lines as available funds.
A short checklist
- The statements cover exactly the period requested and are recent enough.
- Your name (or your sponsor's) and the bank's details are visible.
- The balance meets the requirement on every relevant day, not only the last.
- Large deposits have explanations and supporting documents.
- Transfers between your own accounts are identified.
- Currency conversion uses the rate the requester specifies, if any.
- Original, unaltered documents are what you submit.
Check your statements before you submit
Upload your statements to SheetStatement, confirm the balances, and export to Excel to check minimum balances, large deposits and combined totals before you apply. The free plan covers 3 pages a month; paid plans are $9, $19 and $39 a month.
FAQ
What is a proof of funds bank statement?
It's an official bank statement, or sometimes a letter from your bank, showing you have enough money available for a particular purpose, such as a home purchase, visa or study.
How many months of statements do I need?
It depends entirely on the requester. Some want one recent statement, others two, three or six months. Follow the instructions you've been given.
Can I combine several bank accounts?
Often yes, but rules vary. Make sure each account is in an acceptable name and type, and watch for transfers between accounts that could look like new deposits.
Why would a large deposit be a problem?
Reviewers often want to know where money came from. A large recent deposit may need a letter and supporting documents, such as a gift letter or sale paperwork.
Can I use a spreadsheet instead of statements?
No. Submit official documents. Use the spreadsheet only to check your own figures before you apply.
Is a bank letter better than statements?
A letter is a snapshot of the balance on one date. If the requester wants to see funds held over time, statements are usually needed.
How much does SheetStatement cost?
The free plan includes 3 pages a month. Paid plans are Starter at $9 a month, Pro at $19 and Business at $39.