Hi Imran,
I would suggest taking this from the banking system itself prior to importing into KashFlow. We only take the information in the form of a screen grab from the accounting software so are not able to actually produce a report prior to the import as no information is received by our system.
Guest
If you are interested find attached an Excel Macro that will sort downloaded bank statements into the correct format. You can then get a download from the bank and get the client to add detail, then upload it to kashflow.
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