1. Decodes file from GB-18030 to UTF-8

  2. Removes first 4 lines

  3. Remove trailing spaces in all cells

  4. Replaces the following headers:

    交易创建时间date 交易对方payee 商品名称notes 金额(元)amount

  5. Converts amount to number format

  6. If 资金状态 column is not “已收入”, then amount is multiplied by -1

  7. Converts date column to actual date format

  8. Removes last 7 rows without data

  9. Returns the following columns: date, payee, notes, amount