Help us improve

Receipt Bank: Pull through bank reference in to description field in Kashflow

All purchases published from RB are lacking details and just a fill stop if populated in the description field.   RB confirmed at Accountex that they provide this info, but KashFlow isn't displaying it. Pls pull through bank reference in to description field in Kashflow.  QBO does this and its quite informative.  

  • TB
  • May 4 2019
  • Acknowledged
  • Attach files
  • G B commented
    19 Sep 19:37

    Agreed, the only solution is to merge 2 cells from a downloaded CSV file instead (using Formula -> Text -> Concentrate or manually entering a formula into cell like = A1 & " " & B1 to merge the reference (A1 in this case and detail columns (B1 in this example).

     

    I wrote an Excel Macro that will sort downloaded bank statements into the correct format, which I can then add detail or merge columns into before uploading.

     

    It also 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