📨 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!

Barclaycard Transaction Information

MickSCZ
MickSCZ Posts: 4
Sixth Anniversary Photogenic Name Dropper Combo Breaker
Newbie
edited 13 November at 12:08PM in Credit cards

For years I have downloaded the details of my Barclaycard transactions in QIF format to import the information into my home accounts software package.

Since the Barclaycard website was removed this option is no longer available, they only offer PDF, CSV and HTML formats on the Barclays website.

When I telephoned to ask them about it, the people that I spoke to appeared to be totally unaware what I was talking about. Has anyone else experienced this issue?

Comments

  • flaneurs_lobster
    flaneurs_lobster Posts: 13,228
    10,000 Posts Seventh Anniversary Photogenic Name Dropper
    Forumite

    Will your software package not take a CSV feed? Which package is it?

    In any case, a recent thread suggests that the feed is less than optimal

  • MickSCZ
    MickSCZ Posts: 4
    Sixth Anniversary Photogenic Name Dropper Combo Breaker
    Newbie

    Thank you for your response. Yes my package does accept csv input, but like the thread that you shared, I find the the data comes through in a manner that needs to be manipulated every time that you import it. I haven't experienced the truncated values issue though. I may just have to put up with it, but it's far from expected.

  • pochisoldi
    pochisoldi Posts: 414
    Part of the Furniture 100 Posts Name Dropper
    Forumite

    The current situation with Barclaycard CSV downloads from the Barclays website is this:

    You can't easily do a "all transactions since the last statement - you have to select "custom" and enter the dates. This may cause issues where transactions took place before the last statement, but were posted after the statement was issued. It also needs for you to know the required start date.

    The dates in the file are now the transaction dates.

    There is sufficient information to create QIF files (transaction date, transaction amount, payee) but you'll probably have to reformat individual fields.

    At some point I will get around to coding a CSV to OFX converter, which will sidestep the "can't download transactions since last statement" issue - I have an algorithm to generate unique ID's for each transaction.

    For the time being, the Lloyds Ultra card has getting all my "trade", except for some purchases which attracted Cashback Rewards (7% cashback at Asda a couple of months ago), so that one's on the back burner. (No AI coding here - all done in Perl).

★ ★ ★ 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
  • 356K Banking & Borrowing
  • 255K Reduce Debt & Boost Income
  • 456.3K Spending & Discounts
  • 248.5K Work, Benefits & Business
  • 606.2K Mortgages, Homes & Bills
  • 179.1K Life & Family
  • 264K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.2K Discuss & Feedback
  • 37.7K Read-Only Boards
Quick Search

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.