A visa officer or a loan underwriter almost never asks for a spreadsheet. They want the bank's own PDF, downloaded from online banking or stamped at a branch, because that document is the proof. It carries the bank's formatting, the account holder's name, the statement period, and the running balance. Nobody trusts a spreadsheet you typed yourself, and they are right not to.
So the PDF is what you submit. Full stop. The catch is that the PDF is a terrible tool for the work you actually have to do before you submit it. You need to total your deposits, find the average closing balance, and know which large credits are going to raise a question. Doing that math by squinting at a six-page PDF is slow and error-prone. This is where a working copy in a spreadsheet earns its place, as long as you never confuse it with the record you hand over.
What the application really wants to see
Most reviewers are looking at three things, whether they say so or not.
The first is the closing balance, and more specifically whether it holds up over time. A single healthy month means little. A Schengen visa often wants three to six months of statements precisely so nobody games the number by parking cash for a week. A mortgage lender looks at two or three months to confirm your down payment and reserves are seasoned, not borrowed the day before.
The second is stability. They want to see money coming in on a rhythm that matches what you told them, salary on a predictable date, and they do not want to see the balance sawtoothing to near zero and back.
The third is the unexplained large deposit. A credit that dwarfs your normal activity is a flag. For a mortgage, undocumented large deposits can stall an approval until you produce a paper trail. For a visa, a sudden lump sum right before you apply reads as borrowed funds meant to inflate the picture. You want to find these yourself, before the reviewer does, so you can attach an explanation instead of getting a request for one.
None of that is hard math. It is just tedious to do inside a PDF, and easy to get wrong when you are copying numbers by hand.
Keep the PDF as the record, work on a copy
Here is the whole method in one line: submit the untouched PDF, and do your calculations on a spreadsheet version you made from it.
Download the statement from online banking rather than scanning a paper copy. A native PDF from your bank is cleaner, it has selectable text, and it is the version reviewers expect. Save it somewhere safe and do not edit it. That file is your evidence.
Then make a working copy. You want the same rows the bank shows, but in columns you can sum and sort. Copying and pasting out of a PDF does not give you that. The columns collapse, dates fuse with descriptions, and you end up rebuilding the table by hand. A converter that reads the PDF layout does the job in seconds instead. ConvertFin turns a statement into an Excel or CSV file with four columns: Date, Description, Amount, and Balance. Card statements that do not print a running balance will leave that last column blank, which is normal.
The privacy point matters more here than in almost any other conversion task, because loan and visa statements are as sensitive as financial documents get. ConvertFin parses the PDF locally in your browser using pdf.js, and the file is never uploaded to a server. Your statement stays on your own machine. If you want the detail on how that works, it is on the security page.
One honest limit before you start. This only works on PDFs with real, selectable text. If your statement is a scanned image, the kind where you cannot highlight a number with your cursor, there is no text to read and the conversion will come back empty. ConvertFin does not do OCR. The fix is to download a fresh PDF straight from online banking, which is text-based, rather than scanning a printout.
Do the math on the working copy
Once you have the Excel or CSV file, the three questions answer themselves quickly.
For the average closing balance, some banks print an end-of-day balance on every row, so you can average the Balance column directly with AVERAGE. If yours only shows the closing figure per statement, put the closing balance from each month in its own cell and average those. Reviewers who ask for an "average balance" usually mean the monthly closing figures, so match whatever the application asks for rather than inventing your own definition.
For total deposits, sort or filter the Amount column so credits sit together, then sum them. In a single-column format, deposits are the positive numbers and withdrawals are negative, so a SUMIF for values greater than zero gives you inflows and the negative side gives you outflows. This is also the fastest way to sanity-check that your income matches what you claimed.
For large deposits, sort the Amount column high to low. Anything well above your normal activity jumps to the top. Look at each one and ask whether a reviewer would understand it at a glance. A recurring salary is fine. A one-off transfer of several thousand is the kind of thing to document now, with a gift letter, a sale receipt, or a note explaining the source, so it travels with your application instead of triggering a follow-up.
If you are converting several months at once, do each month and stack them, so you can build a multi-month view in one sheet and average across the whole period. Files go through one at a time — there is no batch upload.
Then submit the original
When the math is done, close the spreadsheet and go back to the PDF. That is what gets uploaded to the visa portal or sent to the loan officer. The spreadsheet was scaffolding. It helped you total the deposits, average the balance, and catch the one transfer that needed a paragraph of explanation, and now its job is over.
A couple of things worth doing before you send. Check that every page of the PDF is included, since applications often require the full statement including pages that are mostly blank or hold only the summary. Confirm your name and the account number are visible, because a statement that could belong to anyone is worth nothing as proof. And never alter the PDF to make a number look better. Editing the document you are submitting as evidence is fraud, and the working-copy method exists so you never have any reason to touch it.
If you are deciding what format to export your working copy in, Excel is easiest for formulas while CSV is more portable, and the PDF vs CSV vs Excel comparison walks through the tradeoffs. ConvertFin handles the usual banks people apply with, including Chase, Bank of America, Wells Fargo, Capital One, Citi, Amex, US Bank, and PNC, with the full list on the supported banks page.
Ready to build your working copy? Convert your statement to Excel in your browser, run the numbers, and submit the original PDF with confidence.