Help us improve

Bank Feeds > Import: there needs to be an email option or CSV download option for accountants to get explanation for transactions from clien

Bank Feeds > Import: there needs to be an email option or CSV download option for accountants to get explanation for transactions from client.
  • Guest
  • Jan 10 2017
  • Already exists
  • Jan 10, 2017

    Admin response

    Hi Imran, I would suggest taking this from the banking system itself prior to importing into KashFlow. We only take the information in the form of a screen grab from the accounting software so are not able to actually produce a report prior to the import as no information is received by our system.
  • Attach files
  • G B commented
    19 Sep, 2019 07:45pm

    If you are interested find attached an Excel Macro that will sort downloaded bank statements into the correct format.  You can then get a download from the bank and get the client to add detail, then upload it to kashflow.

     

    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