QUOTE(tbheng @ Nov 20 2013, 07:43 AM)
I use copy-paste method from the internet banking screen to my laptop Excel template.
The only one that prevent copy-paste was the AEON internet banking screen. So I do a print-to-pdf and then copy-paste from the pdf content into Excel.
Excel is great, I use various formula/condition to auto calc, things like if it is weekend, if it is 5%/1%; 2xTP or 5xTP; TP (and in RM value)cumulated/redeemed; round up/down; CB by category; effective return; projection of how much balance (no of swipes and amount) I am away from the max CB; cumulative CB from each card; no of EPP installments reamianing; annual spent by category, recon between statement and physical slips; link cc payment entries to my IBG/SA account entries; etc.
I still feel I can do more, hence am adding progressively as I go along.
Wah, do you mind sharing your excel?The only one that prevent copy-paste was the AEON internet banking screen. So I do a print-to-pdf and then copy-paste from the pdf content into Excel.
Excel is great, I use various formula/condition to auto calc, things like if it is weekend, if it is 5%/1%; 2xTP or 5xTP; TP (and in RM value)cumulated/redeemed; round up/down; CB by category; effective return; projection of how much balance (no of swipes and amount) I am away from the max CB; cumulative CB from each card; no of EPP installments reamianing; annual spent by category, recon between statement and physical slips; link cc payment entries to my IBG/SA account entries; etc.
Nov 20 2013, 10:55 AM

Quote
0.0419sec
1.43
7 queries
GZIP Disabled