The Anonymous Widower

My Useless John Lewis Credit Card Statement

I recently bought a winter coat in Marks and Spencer. The zip has gone, so I want to find the store, where I bought it, as I use several of the large ones in London regularly. I probably bought it with my John Lewis credit card, so all I need to find is a transaction at over a £100 for Marks and Spencer to get a date and store.

But I can only get the last statement as a spreadsheet, which just gives dates, values and not the store. It’s not even formatted to the sort of level, that a child of six could program.

Quite frankly it’s utter crap!

Unlike with Amex, which gives you everything you need to trace purchases, in an easy-to-read clickable format.

Do John Lewis expect me to keep paper copies of all my purchases?

Paper is so Nineteenth Century!

November 18, 2015 - Posted by | Finance, World | , , ,


  1. Is there nothing you can click – mum banked with NatWest, and I have converted her account to online banking. I can choose see the statement as Excel spreadsheet or as a normal sort of bank statement. Which is great, I can put notes beside the purchases when I download it into Excel. I am impressed with NatWest – when I need to speak to them, which is rarely, I get an English person speaking from England!

    Comment by nosnikrapzil | November 18, 2015 | Reply

  2. You can get it in csv file format which Excel makes a real hash of, Microsoft Money or Quicken. I don’t have the last two pieces of software.

    There is no readable form for a past statement, without external software.

    It’s total crap.

    In the end, Marks ad Spencer just replaced the coat.

    Comment by AnonW | November 18, 2015 | Reply

  3. Glad you got it sorted. Sorry to hear John Lewis are not good with statement data; I would have expected more of them

    Comment by nosnikrapzil | November 19, 2015 | Reply

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.