This is a case for Extracting from Indonesian Bank (BCA). From the default Bank Mutation / Statement export on the “Before” section, becomes the “After” section which is clean and ready to use for processing. This case, the process will do 3 steps:

1. To remove the first 6 rows
2. To remove the last 4 rows
3. To add a new “Tipe” column between “Jumlah” and “Saldo”. Then, from the values, split the DB and CR from that cell into the new “Tipe” column.

This case can be done in one click with Gruntable.

Before

After

This is a case where the user needs to convert the Bank Statement into Accounting Software (Kledo from Indonesia). The columns format are completely different, we need to extract the values, then map it to the corresponding columns that will be imported to Accounting Software. In this case, the process will do:

1. Extract the Name from “Keterangan” column and put it into “Nama Kontak”
2. Extract the Transaction Number from “Keterangan” column and put it into “Nomor Transaksi”
3. Map the date from “Tanggal Transaksi” column to “Tanggal Transaksi”
4. Input the “Jumlah” column to “Jumlah Kirim/Terima Dana” which we’ll give negative sign for outgoing transaction
5. Input the column “Kode Akun Bank” as 1-1001 and for column “Termasuk Pajak” we input Tidak.

All these being done in one click with Gruntable.

Before

After