Financial Documents

Virgin Money Bank Statement to Excel: CSV, PDFs and Paper

Virgin Money's business CSV is a transaction list, its app keeps 13 months of statements, and closure history comes printed. How to get each into Excel.

Published
Updated
Reading time
15 min
Topics:Financial DocumentsBank StatementsUKVirgin MoneyPDF conversionNationwideClydesdale BankYorkshire Bankclosed accounts

Virgin Money Business Internet Banking exports transactions as a CSV file, but that file is a transaction list, not a statement. The official monthly statements arrive as links in Secure messages, and the Business Banking app keeps up to 13 months of them. Older statements come from Virgin Money's business team, and when a current account closes, up to five years of its history is sent on paper. So getting a Virgin Money bank statement to Excel depends on the period: for months still inside online banking, export the CSV; for anything earlier, or anything that has to show balances, convert the PDFs and scans.

SourceWhat it holdsHow far backWhere to get itFit for
CSV exportTransactions for the range you chooseNo limit publishedBusiness Internet Banking, statement view, Download transactionOpen months, imports into accounting software
StatementsThe statement, with opening and closing balancesUp to 13 months in the app, depending on when the business registeredSecure messages ("New statement"), or the app's Accounts, then the envelope iconAudit, year-end, VAT, anything a third party checks
Older statementsStatements past the app's 13 monthsBeyond 13 monthsVirgin Money's business team, by phoneLong look-backs, catch-up work
Closure historyUp to five years of payment transactions, printedUp to five yearsSent automatically after an eligible current account closes, or requested in branch or by phoneA closed account's file

The CSV covers a period you can still reach. Everything else in the table is the conversion job: the statements as the record, the paper that follows a closure, and, over a long enough look-back, statements printed under the Clydesdale Bank and Yorkshire Bank names. Virgin Money's business transferred to Nationwide on 2 April 2026, but its customers still use Virgin Money's apps and online banking, so every route above is Virgin Money's own.

The CSV export: a transaction list, not a statement

Virgin Money's guide to downloading business transactions describes the export in two moves. In Business Internet Banking, create a statement view for complete months or for month to date, then choose Download transaction. The transactions export in formats including CSV, for use with accounting software. The guide states no limit on how far back the range can go, so try the period you need before assuming it is out of reach.

What you get is the bank's list of transactions for the dates you picked. What you don't get is a statement. There is no statement page with an opening and closing balance for a reviewer to tick against, and no statement period printed on it to show the file is complete. For a lot of work that doesn't matter:

  • Open months. Bookkeeping for the current quarter, or a month that hasn't closed yet.
  • Imports. Loading a period into Xero, Sage or QuickBooks, where the software only wants dates, descriptions and amounts.
  • Reconciling a period still in online banking. If a figure looks wrong, you can go back to the screen and check it.

It matters as soon as a third party needs to see the balance. An auditor testing year-end cash, the accounts themselves, a lender asking for six months of business statements: each wants the document the bank issued, not a spreadsheet the client exported. The CSV is also no help for a period online banking no longer shows, or for an account that has been closed.

If you do this every month for a client, get your own access rather than waiting for exports to be emailed over. Business Internet Banking allows unlimited users, with access the business sets for each one, so ask the client to set you up as a user and download the CSVs yourself.

Statements in Secure messages and the app, and the 13-month limit

Each official statement arrives as a notification in Secure messages in Business Internet Banking, with a link to the statement. In the Business Banking app, go to Accounts, tap the envelope icon and open the messages titled New statement, or go to More, then Statements. Save each one as a PDF as you go. That PDF, not the app, is what belongs in the client's file.

The app holds "up to 13 months of statements", and fewer if the business registered more recently. Thirteen months is one financial year and a month to spare. Accounts for a March year-end prepared in December already need statements from 20 months back, so the start of the year has left the app. A two-year catch-up for a client who stopped sending anything in 2024, or an enquiry into three years of VAT returns, sits well outside the window.

For anything older, phone Virgin Money's business team, Monday to Friday, 8am to 6pm, and ask for copies. They usually come back as PDFs or paper copies, and either way the transactions are now locked in a document rather than an export.

Business loans work differently again. Their statements are posted once a year to the registered address, so a loan's transactions are on paper from the start.

Personal accounts follow a similar pattern: personal statements arrive in Secure messages as a "Retail Statements" attachment. The closure history below applies to personal current accounts too.

A closed account's five years arrive on paper

When an eligible personal or business current account closes, Virgin Money sends "up to 5 year payment transaction history, free of charge". It comes printed, or in braille or audio on request. Virgin Money's retention policy says it aims to send the history within 10 working days of closure, and sends it automatically unless the customer opts out. After that, the same history can be requested in a branch or by phone, covering up to five years before the date of the request.

The bundle is a legal entitlement. Under the CMA's transaction history rules for closed current accounts, set by the Retail Banking Market Investigation Order 2017 (Article 20.6.2), a bank must send a Transaction History within 40 days of a personal or business current account being closed, and former customers keep the right to request it for five years after closure. The 10-working-day aim sits inside a 40-day legal limit. The CMA's reasoning was that people switching banks worried about losing the banking history lenders ask for when they offer credit, and a business moving its account can face the same request from its new bank or a lender.

The CMA's 2021 letter followed 220 former customers not being sent theirs, a fault Virgin Money has since fixed, so if a client's history hasn't arrived within a few weeks of closing, ask for it.

What arrives is paper, possibly a thick envelope of it. Keep the originals and scan the whole bundle to PDF before doing anything else with it, because from here on it is a scanning-and-conversion job. Virgin Money isn't alone in this: TSB's paper history for closed accounts arrives by post too.

Clydesdale Bank and Yorkshire Bank statements in a multi-year file

Virgin Money's business banking was Clydesdale Bank's. The glossary in Virgin Money's own transfer Q&A says that before the transfer, Clydesdale Bank PLC "traded under the names 'Virgin Money', 'Clydesdale Bank' and 'Yorkshire Bank'". Yorkshire Bank customers moved to the Virgin Money name from late 2019, and Clydesdale Bank customers in 2020 and 2021, though some accounts still carry the Clydesdale name.

So one account's five years can come in three or four layouts: Clydesdale Bank or Yorkshire Bank statements at the start, then Virgin Money's, and since April 2026, Virgin Money's with the Nationwide name at the bottom. The headers, the column order and the way balances are shown can all change from one stretch to the next, while the account behind them is the same one.

That shapes the spreadsheet in two ways. The columns have to be identical across every layout, or the file can't be sorted or totalled as one. And each row should carry the account number and the bank name printed on its statement, plus the statement period, so a reviewer can see which document a row came from. A Clydesdale Bank statement in the pile is not a different account. Key everything on the account number and the history runs on unbroken through the change of name.


Converting Virgin Money PDFs and scanned histories to Excel

The documents a CSV can't stand in for are the ones that end up in an audit or year-end file: statements saved from Secure messages or the app, older copies from the business team, the printed closure history once it is scanned, and any Clydesdale Bank or Yorkshire Bank statements from the account's earlier years. With Invoice Data Extraction you upload them as they are and convert Virgin Money PDF statements and scanned histories to Excel, one row per transaction.

What goes in. PDFs, downloaded or scanned. A scanned five-year bundle can be one long PDF, up to 5,000 pages and 150 MB, or several smaller files; a task takes up to 6,000 files, so a client's whole folder goes in together, and several tasks can run at once. A page photographed on a phone works too, as a JPG or PNG with one page per image.

What you ask for. The empty prompt box offers a ready-made bank statement prompt, one row per transaction. It is written for bank statements in general, not for Virgin Money, so treat it as a starting point and change it to fit the job: the columns you want, the date format, and what each row should carry, such as the account number or the statement period. Plain words are enough. Where the sheet has to match a layout that Xero, Sage or QuickBooks imports, a Structured Prompt lets you name each column header in the order you need it.

What comes back. Excel, CSV or JSON. In Excel, amounts come through as numbers and dates as dates, so totals and pivot tables work without reformatting. Every row carries the file and page it came from, in a Source File column. A value or a row the panel of AI agents cannot agree on is flagged as Review Needed, with what to check, and in the results viewer one click on the file name opens that row beside the page it came from.

The bank's own CSV gives you the bank's columns for the period online banking still shows. The extraction gives you the columns you asked for, across every period, account and brand in the pile.

Worked example: a printed closure history and older Clydesdale PDFs in one sheet

A Glasgow building supplies company moved its main banking away from Virgin Money in June 2026 and closed its business current account there. Two weeks later the printed five-year history arrived, covering June 2021 to June 2026, and the bookkeeper scanned it to PDF. The director had kept the account's earlier statements as PDFs, from July 2020 to July 2021, issued under the Clydesdale Bank name. The company also kept a second Virgin Money business account open for card takings, and the bookkeeper saved its last 13 months of statements from the app, the recent ones with the Nationwide name at the bottom.

Now a buyer is doing due diligence on the company and wants the closed account's six years and the open account's recent statements in one spreadsheet. All three sets go in as one task, with this prompt:

One row per transaction. Date as DD/MM/YYYY, description, amount (money out negative, money in positive), balance. Add to every row the account number, the statement period (for the printed history, the date range of the page), and the bank name printed on the document. Skip cover letters and summary pages.

An invented sample of what comes back:

DateDescriptionAmountBalanceAccountPeriodBank
14/08/2020BACS CLYDE TIMBER LTD-2,184.6011,402.352015441701/08/2020 to 31/08/2020Clydesdale Bank
03/12/2021FPI MCALLISTER BUILD 44718,650.0023,118.922015441726/11/2021 to 09/12/2021Virgin Money
07/02/2023HMRC VAT-6,912.0018,220.142015441727/01/2023 to 10/02/2023Virgin Money
18/05/2026CARD SETTLEMENT 17MAY3,418.759,861.403066803201/05/2026 to 31/05/2026Virgin Money

Before the sheet goes anywhere, check it against the documents. For every statement, and every page of the printed history that shows balances, check that the opening balance plus the sum of that page's amounts equals the closing balance printed, and that each closing balance is the next page's opening balance. Work page by page rather than month by month, because a missed or doubled row then shows up on the page where it happened instead of somewhere in a year's total. The Source File column takes you straight to that page, and the rows flagged Review Needed are the ones to look at first. The same discipline as reconciling a bank statement against the ledger applies, with the bank's own pages as the other side of the check.

One overlap needs a decision. The Clydesdale PDFs run to July 2021 and the printed history starts in June 2021, so a few weeks appear twice. Keep one source for those dates, the statements being the better record, and delete the other's rows, or those weeks are counted twice in every total.

Sort by account, then by date, and each account reads as one continuous history from 2020 to 2026, through the change of name. A pivot of row counts by account and month then shows a missing month as a gap in the list, which is usually a statement or a page that never made it into the pile.

Bank feeds to Xero, Sage and QuickBooks start on the day they connect

Virgin Money's M Account for Business page advertises syncing with Xero, Sage, Shopify and QuickBooks, and Xero free for 6 months, with terms and conditions applying. For a client keeping its books in one of those packages, a feed takes care of the months from now on.

It does nothing for the months before it was connected. A new client taken on in October, a catch-up on a year nobody kept, a prior year that needs restating: those transactions reach the software through an import, from the CSV while online banking still shows the period, or from the converted statements once it doesn't. The guides to importing bank statements into Xero and importing bank statements into Sage set out the column layout each package accepts, which is what a Structured Prompt should match.

Set the import to end the day before the feed's first transaction. If the two overlap, the same payments land in the bank account twice and the software's balance stops matching the bank's.


The move to Nationwide: what has changed, what has not been said, and what to save now

Virgin Money's transfer questions page sets out what has happened so far. Following Court approval on 23 February 2026, Virgin Money's business transferred to Nationwide on 2 April 2026. Accounts keep the Virgin Money and Clydesdale names "for now", and account names will change to "Nationwide", with notice. Sort codes, account numbers, apps and sign-ins are unchanged, and previous statements can still be seen in the app or online banking. Any changes to "Terms, processes or IT systems" will happen gradually. One change is already visible: customers now see the Nationwide name at the bottom of emails, letters and statements. Virgin Money also says it may ask customers to download a new mobile app at some point.

Nationwide's 2026 preliminary results give its plans: customer migration to the Nationwide brand "to commence in 2026", and a Nationwide-branded business banking proposition "in the first half of 2027". Nationwide's own menus and limits, covered in getting Nationwide statements into Excel, are for its personal current accounts, not Virgin Money's.

Neither bank has said what happens to past statements, downloadable transaction history or bank feeds when accounts move onto Nationwide's systems, or when that move happens. That may change nothing at all. It is still a gap in what has been published, and an accountant's file shouldn't depend on it. While the current platform is in front of you:

  • Save every statement in the app's 13-month window as a PDF, for each of the client's accounts.
  • Export CSVs for the periods you will need again: the current and prior financial years, and any VAT quarters not yet filed or still open to query.
  • Store both in the client's file, not in the bank's app.

Extract invoice data to Excel with AI

Upload your invoices, say what you need in plain words, and download the spreadsheet.

  • A panel of AI agents has to agree on every value
  • What the panel cannot agree on is flagged as Review Needed
  • 50 free pages every month, no subscription
  • Any layout, any language, scans and phone photos
  • Numbers come through as numbers and dates as dates
  • Files encrypted and deleted within 48 hours