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.
| Source | What it holds | How far back | Where to get it | Fit for |
|---|---|---|---|---|
| CSV export | Transactions for the range you choose | No limit published | Business Internet Banking, statement view, Download transaction | Open months, imports into accounting software |
| Statements | The statement, with opening and closing balances | Up to 13 months in the app, depending on when the business registered | Secure messages ("New statement"), or the app's Accounts, then the envelope icon | Audit, year-end, VAT, anything a third party checks |
| Older statements | Statements past the app's 13 months | Beyond 13 months | Virgin Money's business team, by phone | Long look-backs, catch-up work |
| Closure history | Up to five years of payment transactions, printed | Up to five years | Sent automatically after an eligible current account closes, or requested in branch or by phone | A 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:
| Date | Description | Amount | Balance | Account | Period | Bank |
|---|---|---|---|---|---|---|
| 14/08/2020 | BACS CLYDE TIMBER LTD | -2,184.60 | 11,402.35 | 20154417 | 01/08/2020 to 31/08/2020 | Clydesdale Bank |
| 03/12/2021 | FPI MCALLISTER BUILD 4471 | 8,650.00 | 23,118.92 | 20154417 | 26/11/2021 to 09/12/2021 | Virgin Money |
| 07/02/2023 | HMRC VAT | -6,912.00 | 18,220.14 | 20154417 | 27/01/2023 to 10/02/2023 | Virgin Money |
| 18/05/2026 | CARD SETTLEMENT 17MAY | 3,418.75 | 9,861.40 | 30668032 | 01/05/2026 to 31/05/2026 | Virgin 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.