使用excel管理多張信用卡心得分享 - 信用卡
By Ingrid
at 2016-03-21T00:02
at 2016-03-21T00:02
Table of Contents
繼上回分享2.2版之後,
linpudding大在推文中提到年費的起始月份等功能,
因此利用空閒時間新增了年費提醒的欄位並新增了電子發票歸戶記錄在本次的~
信用卡管理2.3版
https://goo.gl/fA6KMu
給有興趣的板友可以下載使用
歡迎板友們繼續提供使用心得,讓這個檔案改善的更好使用。
本次2.3板更新的內容如下:
1.增加「電子發票」欄位,
可依消費習慣選擇信用卡或電子票證的電子發票開立方式記錄及管理。
我個人習慣是會把有在使用的電子票證信用卡拿去7-11的ibon做電子發票歸戶,
沒使用過的板友可以先上財政部電子發票平台申請自然人憑證條碼或手機條碼,
我自己是申請手機條碼,申請好之後就可以去7-11進行歸戶。
使用電子發票的好處是可以減少紙本發票量,一方面比較環保,一方面便於管理。
再搭配雲端發票APP,隨時可以在手機查詢消費紀錄,也可以利用APP管控消費。
另外可以在該平台先設定個人的銀行帳號,
已經歸戶的電子發票就會自動對獎並把中獎的匯入該戶頭。
個人還滿推薦大家多多使用電子發票。
至於信用卡的電子發票部分才剛開始階段,我自己還沒歸戶過,
如果有這方面經驗的板友也懇請分享一下使用心得。
2.增加「年費月份」欄位,可供提醒自己年費什麼時候到期方便管理。
3.在免年費欄位後新增「尚須刷」(次)欄位,
提供使用者記錄提醒自己還須刷幾次才達到免年費。
我把這上述兩個欄位放在一起,可以輸入信用卡的年費月份資訊後,
在依照自己的消費次數在尚須刷幾次才免年費以提醒自己年費出帳前要達到目標,
不過這前題當然是善意的達到信用卡要求的免年費條件,
除非是特定一定要收年費的信用卡,一般產生年費後打客服電話多半還是可以減免。
4.「分類」新增保險,停車,繳費,教育,繳稅,公益,分期等選項;刪除慈善選項。
--
以上內容,如有任何建議麻煩請不吝指教,感謝!
--
Tags:
信用卡
All Comments
By Barb Cronin
at 2016-03-21T03:18
at 2016-03-21T03:18
By Caitlin
at 2016-03-21T07:49
at 2016-03-21T07:49
By John
at 2016-03-21T09:24
at 2016-03-21T09:24
By Eartha
at 2016-03-22T03:18
at 2016-03-22T03:18
By Andrew
at 2016-03-23T05:15
at 2016-03-23T05:15
By Erin
at 2016-03-25T03:10
at 2016-03-25T03:10
By Valerie
at 2016-03-28T23:45
at 2016-03-28T23:45
By Damian
at 2016-04-01T18:51
at 2016-04-01T18:51
By Yuri
at 2016-04-02T22:57
at 2016-04-02T22:57
By Brianna
at 2016-04-07T18:57
at 2016-04-07T18:57
By Dinah
at 2016-04-11T11:47
at 2016-04-11T11:47
By Kama
at 2016-04-14T15:57
at 2016-04-14T15:57
By Andy
at 2016-04-16T17:35
at 2016-04-16T17:35
By Dora
at 2016-04-19T01:30
at 2016-04-19T01:30
By Skylar Davis
at 2016-04-22T18:07
at 2016-04-22T18:07
By Zenobia
at 2016-04-24T04:17
at 2016-04-24T04:17
By Ula
at 2016-04-28T08:59
at 2016-04-28T08:59
By Enid
at 2016-05-03T06:35
at 2016-05-03T06:35
By Regina
at 2016-05-07T01:18
at 2016-05-07T01:18
By Donna
at 2016-05-07T16:23
at 2016-05-07T16:23
By Vanessa
at 2016-05-08T00:13
at 2016-05-08T00:13
By Ula
at 2016-05-10T23:52
at 2016-05-10T23:52
By Hedda
at 2016-05-15T23:12
at 2016-05-15T23:12
By Zanna
at 2016-05-19T16:51
at 2016-05-19T16:51
By Dora
at 2016-05-20T19:03
at 2016-05-20T19:03
By Odelette
at 2016-05-21T17:45
at 2016-05-21T17:45
By Elma
at 2016-05-24T15:02
at 2016-05-24T15:02
By Kyle
at 2016-05-25T04:52
at 2016-05-25T04:52
By Isabella
at 2016-05-25T13:32
at 2016-05-25T13:32
By Todd Johnson
at 2016-05-27T10:36
at 2016-05-27T10:36
By Puput
at 2016-06-01T10:17
at 2016-06-01T10:17
By Ursula
at 2016-06-04T01:44
at 2016-06-04T01:44
By Oliver
at 2016-06-04T04:18
at 2016-06-04T04:18
Related Posts
凱基現金回饋卡
By Harry
at 2016-03-20T23:23
at 2016-03-20T23:23
出現在未出帳的款項是店家已經請款了嗎?
By Queena
at 2016-03-20T22:36
at 2016-03-20T22:36
華南紅卡 海外被盜刷
By Jack
at 2016-03-20T19:38
at 2016-03-20T19:38
國外刷退 VISA 4月1日取消手續費
By Rachel
at 2016-03-20T19:06
at 2016-03-20T19:06
威秀線上訂位機制改版
By Candice
at 2016-03-20T19:03
at 2016-03-20T19:03