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!
Guest
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
Attachments Open full size
Just added my own suggestion stating the above in different words - sorry!
Have now voted for this suggestion
Attachments Open full size
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
Attachments Open full size
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.
Attachments Open full size