Help us improve

Change the description of a bank transaction via the feeds

I think it would be great if you can modify the description of an imported bank transaction via the bank feed to reflect more usefull info. Some entries on the bank statement does not really make sense if you review them during an audit a couple of months later. If you coud add the ability to change it so it makes more sense later, or an optional field for extra related info it would be awesome
  • Fanie
  • Jan 10 2017
  • Acknowledged
  • Nov 26, 2018

    Admin Response

    Hi all, Many thanks for your feedback. We will look into this request and see what we can do to implement. Over the coming year we will be looking at our bank feeds functionality and looking to improve certain areas, having released the functionality a year ago its time for a bit of a spring clean!
  • Attach files
  • Simon commented
    January 10, 2017 09:21

    When using imported bank entries can we change the narrative from that imported. Even when assigning the system assumes the narrative of the bank statement rather than the detail previously entered in the manual entry.

  • Arthur Sampson commented
    January 10, 2017 09:21

    I just posted my own request for this before seeing this one! I also notice that there is at least one other similar request. What is needed is for the "comments" field one the import screen to be made read/write (it currently picks up narrative from the bank statement but is read0only so you can't edit or add to it

  • Arthur Sampson commented
    January 10, 2017 09:21

    Just added my own suggestion stating the above in different words - sorry!
    Have now voted for this suggestion

  • G B commented
    19 Sep 19:29

    Agreed, your nominal ledger ends up with just cheque numbers with no details as clients do not change the detail after the import is done (the only option to add detail).  The alternative is to use a CSV and adjust it in Excel before import.

     

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

     

    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