We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide

Bank Account Transaction Download Formats

I am having a great difficulty finding out what download formats different banks support. I manage my finances using an application called AceMoney running on my Windows laptop. I have accounts with Nationwide, John Lewis, M&S and others and like to manage these in one place. As M&S is closing I am looking at opening a new account. Virgin and Starling are top of the list at the moment. However asking what download formats they support leads to total confusion. OFX and QIF are well known formats and fully acceptable. CSV would be a pain. PDF is just not acceptable. The Reviews on this site do not mention this! 

Comments

  • RG2015
    RG2015 Posts: 6,217 Forumite
    Tenth Anniversary 1,000 Posts Name Dropper Photogenic
    edited 8 March 2021 at 1:24PM
    It looks like the Virgin Money current account only offers CSV downloads although it appears to be set up for more as follows:

    Select format to export your list of transactions
    Basic CSV

    It does open in Excel but that may be the default that I set up on my pc.
  • colsten
    colsten Posts: 17,596 Forumite
    10,000 Posts Seventh Anniversary Photogenic Name Dropper
    Unless you have hundreds of transaction each month, manual reconciliation between your bank account(s) and AceMoney will be miles faster than faffing about with importing . That's my experience, anyway.
  • dunstonh
    dunstonh Posts: 121,292 Forumite
    Part of the Furniture 10,000 Posts Name Dropper Combo Breaker
    Lloyds do QIF and CSV.

    Don't know about Starling as they have banned regulated individuals from opening accounts with them.
    I am an Independent Financial Adviser (IFA). The comments I make are just my opinion and are for discussion purposes only. They are not financial advice and you should not treat them as such. If you feel an area discussed may be relevant to you, then please seek advice from an Independent Financial Adviser local to you.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 354.4K Banking & Borrowing
  • 254.4K Reduce Debt & Boost Income
  • 455.4K Spending & Discounts
  • 247.3K Work, Benefits & Business
  • 604K Mortgages, Homes & Bills
  • 178.4K Life & Family
  • 261.5K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.