Hi Jonathan,
Can you provide a bit more detail on this please? Currently, within KashFlow you can choose exactly which bank account you wish to import.
Hi, if you are interested find attached an Excel Macro that will sort downloaded bank statements into the correct format.
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.
Practically, when importing, you have to add another column to the current CSV as a bank account ID, so the import tool knows which Bank account it needs to import to. If you don't do this, it will import to the default Bank Account. This is written in your knowledge-base.
This is frustrating. I have tested many other competitors of Kashflow and all give you a drop-down of which bank account you wish to import to before choosing the import file.
Anonymous
Hi, if you are interested find attached an Excel Macro that will sort downloaded bank statements into the correct format.
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
Hi,
Practically, when importing, you have to add another column to the current CSV as a bank account ID, so the import tool knows which Bank account it needs to import to. If you don't do this, it will import to the default Bank Account. This is written in your knowledge-base.
This is frustrating. I have tested many other competitors of Kashflow and all give you a drop-down of which bank account you wish to import to before choosing the import file.
Thanks
Attachments Open full size
Any updates on this please?
Attachments Open full size