Help us improve

Open Banking and CSV import of bank accounts

Well Open Banking has come into effect and has been known about for some time (see

Unfortunately, Yodlee are taking an age to integrate this, whereas some competing accounts platforms (such as QuickFile) have already launched their open banking integration.

Unfortunately, my account is with Santander - despite them having published their API etc, Yodlee expect to integrate with this in January 2020

Looks as though Kashflow customers will be left well behind the times (again).

Unfortunately, Yodlee have never been my preferred feed integrator - for example, their paypal solution never worked for me (it was even worse than Kashflow's poorly implemented paypal app).

I know that we can use a CSV import in the meantime, but I tried this with Santander - created an export, then reformatted it (deleting columns and re-ordering the columns and changing column names to fit in with Kashflow's own CSV) but import just reports an unknown error

Not sure I can put up with this for the next 4+ months.....

  • Rich Mellor
  • Sep 18 2019
  • New
  • Attach files
  • Dan Roberts commented
    18 Sep 09:31

    Sorry KashFlow but this whole situation has been really badly handled by you guys. There should have been communications sent out in advance so that we could avoid issues with duplicate transactions etc. Not good enough and your woolly answers via the support channel are pretty crap too. 

  • G B commented
    19 Sep 12:28

    Hi,  if you are interested find attached an Excel Macro that will sort downloaded bank statements into the correct format.


    It removes common problems (2 digit years, commas, full stops, blank lines, etc..) and has been used by a few of our clients.

    You set it up once (see the full guide) and save the settings.  From then on, you simply point the downloaded CSV file and it will create a file in the correct format.


    I'm aware using a macro from an unknown source is not always advisable, so the macro code is not protected.  if you wish to inspect first, do not enable the macro & activate the 'Developer' tab in Excel.  From there you can click on 'View Code' and you can see it is simply formatting commands with a bit of extra logic.


    It will work in all versions of Excel except Office 365 online as it does not run Excel VBA macros (Office 365 desktop works).  If you do not have Excel, a free office package like 'Open Office' is supposed to run Excel macros.




  • Guest commented
    21 Sep 17:38

    "You get what you pay for" isn't that what they always say?


    Well it doesn't seem to be the case here!  I pay for an automated bookkeeping solution but I'm having to do it all manually.


    Agree with the OP that this should have been prepared in advance of the deadline.  Seamless transition is the sign of customer care not fix it when its broke.


    Thanks to GB for the macro, I will see if this solves my issue for now, while I wait on a response to my complaint.  I certainly wont be waiting until the new year for a fix.  If the response is not suitable I'll be taking my business elsewhere.  Running a small business is hard enough without having additional admin and not being able to see your accounts!

  • Guest commented
    01 Oct 10:40

    We have used KashFlow for the past few years, since it was acquired by IRIS, and encouraged clients to use it.   Whilst there have been a few problems, it has been reasonably comparable with similar packages.     This latest farce re Bank Feeds is something, however, that should never have happened and in speaking with senior employees at KashFlow, they concede that errors have been made.   

    There were problems a couple of years ago with activating Santander  Bank Feeds and KashFlow were fully aware that there was a problem then.    Other software suppliers such as Xero and FreeAgent sorted out these problems a long time.

    One of the reasons why people use Cloud Accounting is the usefulness of Bank Feeds and to find it has been taken away not just for a few days ,(which we originally and incorrectly assumed), but for over 2 months is disastrous.     Note:    We were advised last week that it will be sorted by 30 November!!!?       KashFlow - this is not good enough  !!!


    KashFlow is clearly and sadly not in touch with the modern world and the need to provide an effective and efficient service.   Without Bank Feeds and problems already encountered with downloading csv files, it is clear that we will not be recommending KashFlow to any new clients.      We shouldn't have to even contemplate using csv files as this system was used because it had Bank Feeds!!!


    A very unhappy customer