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,043 Forumite
    Ninth 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,597 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: 119,237 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
  • 349.9K Banking & Borrowing
  • 252.7K Reduce Debt & Boost Income
  • 453.1K Spending & Discounts
  • 242.9K Work, Benefits & Business
  • 619.8K Mortgages, Homes & Bills
  • 176.4K Life & Family
  • 255.8K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 15.1K Coronavirus Support 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.