Decodes file from GB-18030
to UTF-8
Removes first 4 lines
Remove trailing spaces in all cells
Replaces the following headers:
交易创建时间
→ date
交易对方
→ payee
商品名称
→ notes
金额(元)
→ amount
Converts amount
to number format
If 资金状态
column is not “已收入”, then amount
is multiplied by -1
Converts date
column to actual date format
Removes last 7 rows without data
Returns the following columns: date
, payee
, notes
, amount