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 https://kashflow.ideas.aha.io/ideas/KF-I-4688).

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
  • Already exists
  • Attach files
  • Dan Roberts commented
    September 18, 2019 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
    September 19, 2019 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.

     

    Regards

    Gordon

  • Guest commented
    September 21, 2019 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
    October 01, 2019 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

  • NKB commented
    October 17, 2019 17:19

    We are in the same situation as the OP. We have been a KF customer for 4 years and the automation aspect swayed it for us. Now we are in the dark ages and are left with tiddling about downloading Excel spreadsheet in one format, altering to csv and uploading to KF. We have written a macro, but that is not always without its issues. Looking at the KF website, Santander isn't even on the 'coming soon' list! - Xero has automatic Santander bank feeds so what is holding up KF? Quite frankly KF has fallen behind the times. No real added features or improvements, an app that really is totally useless and lacks any functionality. It's becoming a case of what you see is what you get. Come on KF sort yourself out! Come March 2020 if nothing has changed then we are leaving you for a competitor. 

  • Keith Milner commented
    October 21, 2019 15:44

    I have to agree. And it's ridiculous that Santander, who are one of the top small business banks in the UK, isn't even on the list.

     

    If other enhancements are to go by (e.g. Google Drive integration) then I fully expect to see 2022 roll around and still not have bank feed automation in place.