Hi Jenna,
Thanks for your feedback. The way that the bank feeds are constructed is to pull a confined set of data into KashFlow that is made up mostly of numeric data. Bringing in comments may be possible, but certainly the ability to then edit them within the bank area would be a large amount of development work in line with the banks if this was to then be reflected again within your online banking system.
If the feature does get a number of votes we can certainly investigate, thank you for getting in touch!
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