For all those who are struggling with YES Marquee reward points miscalculation, I'd suggest you use
@Aadi55 tool TRACKCARD which helps you ease the process. I just found a discrepancy in my Jun 2025 statement where they have credited 236 points less that I'm supposed to get and I've escalated the case with the excel-like template from the mentioned tool. Thanks
@Aadi55 for the free tool
🙂
Have got all these cards set up, need to onboard my remaining cards as well.
View attachment 101670
will add both excel and pdf report generation features using the tool soon.
Also
@rafzy , once you are sure about your manual rewards calculation logic, per transaction basic, i'd like to discuss in dm in details. I should be able to implement the same calculation in the tool also without user (you) calculating manually and enter the rewards points for ease of calculation.
I have Airtel Axis and Swiggy HDFC cards, which i am using extensively. And both of these 2 cards do not have per transaction basis rewards calculation, instead cumulative total rewards per statement cycle is mentioned in the statement pdf. These 2 cards are already post-mortemed thoroughly and i have implemented the logic to calculate per transaction basis rewards which is working perfectly for me as of now.
Unlike ICICI cards and few other cards like Flipkart Axis, none other cards show this transparency of per transaction level rewards calculation in the statement. TrackCards moto is the exact same thing. To be able to capture and generate per transaction basis transparency for each cards. Which is a little ambitious idea, but I believe it can be implemented if folks like you step up and help me hand in hand.
Tata Neu Infinity card is one of them. No clarity on per transaction basis rewards calculation also quite complicated calculation. In this following post
@raghumahajan has explained clearly the calculations.
I am monitoring Tata Neu very closely using an Excel sheet.
The statement credit formula I derived after months of data entry is =ROUND(IF(Amount< 33, 0, 0.5% * Amount),0)
It is rounding up to the zero decimal point transaction if the amount > 33.
For Neu coints in app, =IF(Mode= "neu app", ROUND(IF(Amt < 100, 0,1% * Amt),0),0)
I have already implemented this logic explained by him, but didn't make it live as i don't personally hold this particular card and couldn't verify using a few statements pdf that the calculations are correct and in place.
I believe, in quality over quantity. So do not intend to make this calculation live without being 100% sure that my calculations are perfect.
let me know
@rafzy once you are sure on the rewards calculation for Yes Marquee, lets discuss and i'll implement the logic in TrackCards.
Those who don't know where to start if interested in TrackCards, start reading the post in my signature.
Thanks.
