BankPDFtoXLS turns a Virgin Money statement PDF into a spreadsheet with the columns the statement prints. Virgin Money leaves most rows without a balance, so the converter works out each missing balance and checks every one it 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. The converter puts 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 the spreadsheet looks like
Where Virgin Money printed no balance, the converter works it out from the
rows around it, fills it in, and marks 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.
A date that the statement leaves blank stays blank in the spreadsheet. Fill them in with three steps in Excel.
How we test it
The converter is tested against two Virgin Money statements: 97 transactions in all, and the Ledger column flags none of them. 30 balance against a balance Virgin Money printed. The converter filled in the other 67, which are mostly the rows Virgin Money prints no balance for.
Convert a Virgin Money statement
- Upload the PDF on the home page.
- Check page one in the preview. It is free, with no email and no card.
- Create an account to convert every page. The pricing page lists the plans.
The PDF is deleted when its conversion finishes.
Other banks
- 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
The converter reads other banks' statements too. See every supported bank.