Skip to content

Converts banks' pseudo-CSV output into a proper CSV file

License

Notifications You must be signed in to change notification settings

adib/BankConverter2

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

27 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Bank Converter 2

These scripts takes the "CSV export" files generated by some internet banking websites into a well-formed CSV file format ready to import into popular personal finance software applications.

The problem is that the files that these banks generates are not standard comma-separated values (CSV) files. Some spreadsheet applications are able to open them but otherwise these files are not compatible with personal-finance software.

That’s where these scripts come in. Each script convert a particular bank’s dump and then creates a well-formed CSV file with a standard date format, ready for import.

Supported Formats

Currently these banks and account types are supported:

Prerequisites

These scripts should work with a standard Python 2.7 installation. They were tested to run on on plain-vanilla macOS and its pre-installed Python distribution.

Installation

These installation steps should work on Unix or Unix-like systems (e.g. macOS, Linux, or BSD).

  1. Download the repository

  2. Mark the scripts as executable:

     $ chmod a+x csv-bca.py csv-ocbc.py csv-dbs.py csv-transferwise.py
    
  3. Create a symbolic link from /usr/local/bin to the script's installation directory:

     $ cd /usr/local/bin  
     $ ln -s {path-to-download}/csv-dbs.py csv-dbs  
     $ ln -s {path-to-download}/csv-ocbc.py csv-ocbc
     $ ln -s {path-to-download}/csv-bca.py csv-bca
     $ ln -s {path-to-download}/csv-transferwise.py csv-transferwise
    

If you are a Windows user, please adapt those steps to your system as necessary.

Usage

  1. Open your bank's Internet Banking website and download your transaction history into a CSV file.
  2. Run the conversion script against it, either csv-dbs, csv-ocbc, csv-bca or csv-transferwise
    • The first argument is your bank's CSV file as input.
    • The second argument is where to write the processed CSV output.
  3. Import the resulting CSV output into your favorite personal finance software.

License

These scripts are provided under the BSD 2-clause open source license. Please refer to file LICENSE.md for details.

Endnote

I have been having this CSV conversion problem for a long time and have been solving it manually so far – that is, clean up the data manually using a text editor and a spreadsheet. I even wrote a blog post on the topic and see whether it would be worth to write an app around the issue. Apparently there was not much interest, hence I wrote these scripts just to solve my own problem. Please let us know if I was wrong and it's worth your time and money to have an easy-to-use app or service to do this.

Sasmito Adibowo
http://cutecoder.org