Lowyat.NET -> Finance, Business and Investment House -> Credit Cards, Debit Cards, Prepaid Cards and Loyalty CardsCredit Cards Report your Cash Back from Credit Cards, Monthly or Promotional Cash Backs
|
|
 May 2 2014, 02:49 PM
|
||||||||||
 
Senior Member
534 posts Joined: Oct 2006 From: Penang  
|
|
||||||||||
|
|
|
|
|
May 2 2014, 04:14 PM
|
Junior Member
377 posts Joined: Apr 2008 
|
Name of Credit Card : Maybank2card AMEX
Cash-Back Received : RM50 Cash-Back Type : Monthly Transaction Date : 30 April 2014 Posting Date : 1 May 2014 |
|
|
May 2 2014, 04:28 PM
|
||||||||||
Senior Member
932 posts Joined: Jan 2014 From: N02 E102
|
 This post has been edited by Wongchoy: May 2 2014, 04:29 PM |
||||||||||
|
|
May 2 2014, 08:01 PM
|
||||||||||
Junior Member
353 posts Joined: Jan 2003 From: kuala lumpur
|
|
||||||||||
|
|
May 3 2014, 01:11 AM
|
||||||||||
Senior Member
7,496 posts Joined: Feb 2007
|
|
||||||||||
|
|
May 3 2014, 08:45 AM
|
Senior Member
6,483 posts Joined: Apr 2012
|
Name of Credit Card : Maybank2card AMEX
Cash-Back Received : RM50 Cash-Back Type : Monthly Transaction Date : 30 April 2014 Posting Date : 1 May 2014 |
|
|
|
|
|
May 3 2014, 09:02 AM
|
||||||||
All Stars
65,273 posts Joined: Jan 2003
|
QUOTE(tbheng @ May 2 2014, 01:31 PM) |Name Of Credit Card|Maybankard 2 AMEX|
 Was suppose to be on the dot...   m2u is very slow...everyone is checking out their Amex CB...  it's rounding down mechanism, so some retail purchases are the culprit (especially the govt tax 6% on top of actual purchase value + rounding to nearest 5 cents)general guideline: each transaction is on even-tenth cents, e.g. RM10.20, RM10.40, RM10.60, RM10.80, RM11.00. This way, no "loss" to mbb's 5% cb round down calculation. if the transaction odd-tenth cents, e.g. RM10.10, RM10.30, you'll lose a little after 5% cb round down. for me, my April amex weekend spending was RM1,000.10 (watson's bill was RM63.65, Starbucks bill was RM14.85). Both the RM0.05 extra not getting any cb  |
||||||||
|
|
May 3 2014, 09:28 AM
|
|
Senior Member
1,188 posts Joined: Sep 2008
|
QUOTE(cybpsych @ May 3 2014, 09:02 AM) it's rounding down mechanism, so some retail purchases are the culprit (especially the govt tax 6% on top of actual purchase value + rounding to nearest 5 cents)general guideline: each transaction is on even-tenth cents, e.g. RM10.20, RM10.40, RM10.60, RM10.80, RM11.00. This way, no "loss" to mbb's 5% cb round down calculation. if the transaction odd-tenth cents, e.g. RM10.10, RM10.30, you'll lose a little after 5% cb round down. for me, my April amex weekend spending was RM1,000.10 (watson's bill was RM63.65, Starbucks bill was RM14.85). Both the RM0.05 extra not getting any cb Thanks for the hints, will implement that in my spreadsheet.  Din notice this in the pass when I have > 1k spending on weekend. |
|
|
May 3 2014, 02:23 PM
|
||||||||||
Senior Member
819 posts Joined: Jun 2007 From: Moon's Dark Side
|
|
||||||||||
|
|
May 3 2014, 03:22 PM
|
||||||||||
Senior Member
1,311 posts Joined: Apr 2010
|
|
||||||||||
|
|
May 3 2014, 05:01 PM
|
|
All Stars
65,273 posts Joined: Jan 2003
|
QUOTE(tbheng @ May 3 2014, 09:28 AM) Ooh, okay. Due to 5% that's why the even-tenth and odd-tenth cents scenario. Here's my Excel formula to properly calculate Maybank's cashback if... Thanks for the hints, will implement that in my spreadsheet. Din notice this in the pass when I have > 1k spending on weekend. 1) The transaction date = weekend (dont calculate if weekdays) 2) The Debit column has value inside (payment from M2U/cashback are under Credit, Debit will be empty, so dont bother to calculate it) 3) Actual cashback formula is =ROUNDDOWN(D1*5%,2) =IF(ISBLANK(D1),"",IF(WEEKDAY(B1,2)>5,ROUNDDOWN(D1*5%,2),"")) Replace B1 to the cell containing the transaction date Replace D1 to the cell containing the transaction amount (debit)  p/s: I've officially maxed out my May's RM50 cashback due to Etiqa Motortakaful (Insurance) @ RM1.4K. Spending diet-month again  This post has been edited by cybpsych: May 3 2014, 05:03 PM |
|
|
May 4 2014, 12:16 AM
|
|
Senior Member
1,188 posts Joined: Sep 2008
|
QUOTE(cybpsych @ May 3 2014, 05:01 PM) Here's my Excel formula to properly calculate Maybank's cashback if... I used similar formula like yours except I was using ROUND() instead of ROUNDDOWN().1) The transaction date = weekend (dont calculate if weekdays) 2) The Debit column has value inside (payment from M2U/cashback are under Credit, Debit will be empty, so dont bother to calculate it) 3) Actual cashback formula is =ROUNDDOWN(D1*5%,2) =IF(ISBLANK(D1),"",IF(WEEKDAY(B1,2)>5,ROUNDDOWN(D1*5%,2),"")) Replace B1 to the cell containing the transaction date Replace D1 to the cell containing the transaction amount (debit) p/s: I've officially maxed out my May's RM50 cashback due to Etiqa Motortakaful (Insurance) @ RM1.4K. Spending diet-month again I found the culprit transaction after using ROUNDDOWN(). Will use the new function from now on. Thanks for sharing... |
|
|
May 4 2014, 03:55 PM
|
Senior Member
8,259 posts Joined: Sep 2009
|
Name Of Credit Card Maybankard 2 AMEX
Cash-Back Received RM50 Cash-Back Type Monthly 5% Weekend Cashback Transaction Date 30-Apr-2014 Posting Date 01-May-2014 |
|
|
|
|
|
May 4 2014, 03:56 PM
|
|
Senior Member
8,259 posts Joined: Sep 2009
|
Hmm.. how do you guys able to reply in the nice box table?
|
|
|
May 4 2014, 03:58 PM
|
|
All Stars
65,273 posts Joined: Jan 2003
|
QUOTE(Kaka23 @ May 4 2014, 03:56 PM) Hmm.. how do you guys able to reply in the nice box table? try to reply a post with the box table (but dont send), then you can see/copy the codes out |
|
|
May 4 2014, 04:00 PM
|
||||||||||
|
Senior Member
8,259 posts Joined: Sep 2009
|
|
||||||||||
|
|
May 4 2014, 04:01 PM
|
|
Senior Member
8,259 posts Joined: Sep 2009
|
QUOTE(cybpsych @ May 4 2014, 04:58 PM) try to reply a post with the box table (but dont send), then you can see/copy the codes out Ah.. got it, thanks! Appreciate it! |
|
|
May 4 2014, 11:21 PM
|
All Stars
21,308 posts Joined: Jan 2003 From: Kuala Lumpur 
|
QUOTE(Kaka23 @ May 4 2014, 03:56 PM) Hmm.. how do you guys able to reply in the nice box table? Refer to Post #1 under "code" box |
|
|
May 5 2014, 02:49 PM
|
Junior Member
185 posts Joined: Apr 2009 From: Bolehland
|
Name of Credit Card : Maybankard 2 AMEX
Cash-Back Received : RM50.00 Cash-Back Type : Monthly (5% Weekend Rebate) Transaction Date : 30 April 2014 Posting Date : 1 May 2014 |
|
|
May 5 2014, 02:53 PM
|
|
Junior Member
185 posts Joined: Apr 2009 From: Bolehland
|
Name of Credit Card : UOB ONE Card
Cash-Back Received : RM0.45 Cash-Back Type : Monthly Transaction Date : 4 May 2014 Posting Date : 4 May 2014 |
| Change to: |  0.0229sec
 0.78
 6 queries
 GZIP Disabled
Time is now: 2nd December 2025 - 01:22 PM |
Quote