We turn your Virgin Money statement PDF into a spreadsheet with the columns the statement prints. Virgin Money leaves most rows without a balance, so we work out each missing balance and check every one we can.
What a Virgin Money statement looks like
- A Virgin Money statement has five columns: Date, Description, Debits, Credits and Balance.
- A description often runs over two or three lines, with the amount on the last line. We put all of those lines in one row, with the amount, so each transaction is one row.
- The date is printed only on the first transaction of each day, written like 02 Sep, without the year.
- Virgin Money usually prints the balance once a day, against the day's last transaction.
What your spreadsheet looks like
Where Virgin Money printed no balance, we work it out from the rows around
it, fill it in, and mark the row filled in the Ledger column.
| Date | Description | Debits | Credits | Balance | Ledger |
|---|---|---|---|---|---|
| 01 Sep 2024 | Opening balance | 250.00 | ok | ||
| 02 Sep | Card Coffee Shop London | 3.10 | 246.90 | filled | |
| Mobile Banking Transfer To Savings 12345678 | 50.00 | 196.90 | ok | ||
| 03 Sep | Card Bakery London | 2.00 | 194.90 | ok |
The rows above are an example, not a real statement.
Where the statement leaves a date blank, your spreadsheet leaves it blank too. Fill in the blanks with three steps in Excel.
How we test it
We test against two Virgin Money statements: 91 transactions in all, and the Ledger column flags none of them. Of the 91, 28 balance against a balance Virgin Money printed. We fill in the other 63, which are mostly the rows Virgin Money prints no balance for.
Convert a Virgin Money statement
- Drop the PDF in the box on this page, and we show you its first page converted.
- Sign up with your email address to download it. You do not need a card. Your free trial converts up to 5 pages of a statement, 15 pages in all.
- To convert every page, choose a plan on the pricing page.
To bring the transactions into your books, download the file for your accounting software from your list of statements, then import it into Xero, QuickBooks or FreeAgent. You get this file on the free trial and on the Standard and Plus plans. Lite gives Excel and CSV.
Once the statement is in your account, we delete the PDF when its conversion finishes. If you drop it in and do not sign in, we delete it too. Our privacy policy says what we keep, and for how long.
Read next
- Bank Statement Codes: What DD, BGC, FPI and the Rest Mean
- Why a Converted Bank Statement Does Not Balance
Other banks
- Convert ANZ Bank Statements to Excel
- Convert Commonwealth Bank (CommBank) Statements to Excel
- Convert ICICI Bank Statements to Excel
- Convert Metro Bank Statements to Excel
- Convert Monzo Bank Statements to Excel
- Convert Nationwide Bank Statements to Excel
- Convert HSBC Bank Statements to Excel
- Convert Lloyds Bank Statements to Excel
- Convert NatWest Bank Statements to Excel
- Convert Santander Bank Statements to Excel
- Convert TSB Bank Statements to Excel
We convert other banks' statements too. See every bank page.