Help us improve

Automatic Bank Feed

If importing bank transactions can be automated or semi-automated (like PayPal at the moment) that would be fantastic!
  • KashFlow Product Manager
  • Jan 10 2017
  • Released
  • Jan 10, 2017

    Admin Response

    Hi there, We're happy to annouce that the second phase of bank feeds is now live and allows you to create invoices, purchases and bank transactions using the information fed in by your bank, and also to assign payments directly to invoices, purchases and existing transactions. We've got a knowledge base article available at http://www.kashflow.com/akademy/kb/bank-feeds with a video of the new functionality and set up instructions. We're really excited about these developments and have a lot of new functionality in the pipeline coming very soon. The next phase of bank feeds will be 'auto matching' - this will intelligently create/assign and allow you to create custom rules - we'll have more information on that available shortly. - Steven
  • Attach files
  • G B commented
    19 Sep 19:51

    With the bank direct feed disabled,  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