Bank statements for a visa application: what the caseworker is checking

The checklist says six months of bank statements showing a minimum balance, and you have six statement documents downloaded from online banking sitting in a folder. The question underneath the requirement is not really about a number. A caseworker has to be satisfied on two points: that the money is yours and you can actually reach it, and that it was already there rather than assembled to pass the check.

Every part of the presentation follows from that. Requirements themselves differ enormously by country, by route and by category, so work from the exact wording in your own guidance and treat anything below as the concern behind the rule rather than the rule.

Maintained funds, not a snapshot

Read the sentence in your guidance literally. "Held for 28 consecutive days" and "an average balance of" and "a balance of at least, at the date of application" are three different tests, and statements that satisfy one can fail another. Where the wording leaves room for interpretation, present the run so that it satisfies the strictest reading available.

Continuous holding is the strictest of the three, and it is a common way for a financial requirement to be written. Where that is the wording, the test is the lowest point in the window rather than the closing figure, so an account that dips below the threshold for a week in month three does not satisfy it however comfortable the final balance is. Under an average-balance test or a balance-on-a-date test, the same dip may not matter at all. The wording decides that, not the shape of the account.

One account can therefore return three different answers. Take month-end balances of 2,100.00, 1,950.00, 2,300.00, 1,880.00, 2,240.00 and 11,300.00. The six figures total 21,770.00, so the mean of the month-end balances is 3,628.33. The last is 11,300.00, up 9,060.00 on the month before it. Against a closing-figure test the account looks strong. Against an average it is middling, with a caveat below that is worth more than it looks.

Against continuous holding, those six figures cannot answer the question at all. They are the balance at six particular instants, one a month, and a balance sampled monthly can only understate how low the account went in between, never overstate it. The lowest of the six, 1,880.00, is therefore an upper bound on the real low point and never a lower one. Treating it as the answer is how an application fails a threshold the applicant believed was comfortably met.

The rows settle it. Read the transactions for the same window and the true minimum turns up inside month two. The month opens on 2,100.00, rent of 900.00 takes it to 1,200.00, salary of 1,050.00 brings it back to 2,250.00, and a card payment of 300.00 leaves the printed month-end figure of 1,950.00. The number a continuous-holding test measures is 1,200.00, not 1,880.00. A threshold of 1,500.00 looks met on every month-end row and fails on a day in month two that no month-end figure shows. Nothing about the account changed between those readings, only how often it was sampled.

An average test carries its own trap. Where guidance says average balance, find out which average it means before you compute anything, because a published average balance requirement is commonly an average daily balance, which sums the closing balance on every day of the period and divides by the number of days. That is not the mean of six month-end figures, and the two can be far apart on the same account: a balance that spends most of each month low and is topped up before the statement date averages well by month end and badly by day. The 3,628.33 above is the mean of six month-end balances and nothing more.

Sourcing the deposits

The 9,060.00 that lifted the balance in the final month of that example is not a problem in itself. What makes it worth pre-empting is its shape: a large credit landing shortly before an application, taking an account from below a threshold to well above it, is the pattern a maintained-funds test exists to detect. A reviewer who cannot tell where it came from has a reason to ask, and a request for further evidence costs weeks that a completed application would not have.

If you have a credit that materially changes the picture, put the explanation in the application rather than waiting to be asked. Sale completion statements, gift letters, inheritance paperwork, a redundancy settlement or a maturing deposit each turn an unattributed line into an accounted-for one. Documenting a large deposit is a common expectation across financial assessment generally, and the same instinct shows up in how mortgage underwriters read statements. It is not a guarantee: some routes limit which sources count, or how recently the money may have arrived, and only your own guidance answers that.

What the run has to look like

Two document-level defects are worth ruling out before anything is submitted, and both are visible in a folder listing.

• Gaps between periods. Six files with six month names in them can still be missing a period, because the file name was written by whoever downloaded them. Sort by period start and confirm two things separately. Each closing balance should equal the next opening balance, which shows the files you hold join up. The printed statement periods should also run back to back with no gap between one period's end and the next period's start, which is the only one of the two that catches a missing month, because a quiet month that closes on the balance it opened with chains cleanly onto a file that is not really its neighbour. Neither check tells you the run covers the window your guidance asks for, so compare the first and last dates against the wording as a separate step. The same method that assembles a full year of statements into one spreadsheet applies to a six-month window.
• Documents that do not identify themselves. A page that does not carry the bank's name, your name as the account holder, the account number and the statement period gives a reviewer nothing to tie it to an account or a period. Screenshots of an online banking balance and printed transaction lists frequently carry none of those. Where guidance specifies the bank's issued statement, a screenshot does not meet the requirement; where the wording is looser, it still leaves the reviewer with nothing checkable.

The spreadsheet is for you, not for them

Convert the six statements for your own checking, not as a substitute for the documents. The bank-issued statement is the evidence; a converted file is a derivative of it, and what a bank statement can prove runs through the original document, not through your copy of the numbers.

What the spreadsheet earns you is the ability to answer, in seconds, the three questions you cannot answer by flicking through statement documents: what was the lowest balance across the whole period, on what date, and which credits above a threshold need an explanation attached. Sorting the combined rows by balance ascending gives the first two. Filtering credits above your own cutoff gives the third.

1. 1

   List the periods you need

   Write out the six periods your guidance requires, by date, before downloading anything, so a missing month is obvious at the folder stage.
2. 2

   Convert every statement

   Convert all six statement documents, keeping one converted file per source document so each row can be traced to the page it came from.
3. 3

   Chain the balances

   Confirm each file's closing balance equals the next file's opening balance and the dates run back to back, with no gap and no overlap.
4. 4

   Find the lowest point

   Sort every transaction row by balance and read the minimum, not the lowest of the six month-end figures, which can never be lower than the true minimum and is usually above it. Compare it against the test your guidance actually sets.
5. 5

   Attach a source to every large credit

   List credits that materially change the balance and pair each with the document that explains where the money came from.

Why the conversion has to be right

If the spreadsheet you are checking against contains a misread figure, you can talk yourself into confidence that is not there. A low point of 1,200.00 that is really 200.00 is the difference between an application and a refusal, and nothing on the sorted sheet announces it.

Which check you run against that decides whether you find out. Totalling a month, opening balance plus credits minus debits against the printed closing figure, is defeated by any two errors that cancel. A row lost at a page break and another row of the same value read twice leave the month's total exactly where it should be. Rebuilding the balance column catches the same pair: start from the opening balance, apply one row at a time, and compare each rebuilt figure against the balance printed beside that row. The rebuilt column goes out at the row that vanished and stays out until the duplicate cancels it, so every row in between disagrees with the document. That is also the only version of the check that finds the low point, because the low point is a row, not a total.

What it never covers is anything that is not an amount. Dates, descriptions and payer names rebuild perfectly whatever they say, as does a row recorded with an amount of zero, and so does a balance misread in a way that agrees with the amount misread beside it. Where a statement prints no running balance column there is nothing to rebuild against at all, which is worth knowing before you rely on a converted low point. Treat a clean rebuild as settled evidence about the amount column and nothing wider. For a financial requirement, the amount column is the column the decision turns on.

The alternative is reading six statement documents on screen and hoping to spot the smallest number among six hundred rows. Sorting a combined sheet takes a second and gives the same answer every time you run it.