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