Originally Posted by
generikz
I tried that but it didn't line up either.
If I round down the UNI$ (truncate) to integer, by either blocks of $5 or $10, I get resp. 1,265 and 1,246 when UOB credited me with 1,230.
Just puzzled by the way they calculate things...
Julien
Quoting myself, post #4799:
Excel. Create your own formulas, here is the one which calculates 10x UNI$:
Code:
=TRUNC(TRUNC("posted charge amount")/5,0)*10
"posted charge amount" - is the amount with dollars and cents.As you can see, if you charge anything between $15.01 and $19.99 and these are 10x qualified charges, you will be awarded the same 30 UNI$ - they round it down.
So if you download statement in excel and in your E5 column is the first posted charge, put in F5 column as =TRUNC(TRUNC(E5)/5,0)*10 - this will put there number of awarded 10x UNI$.
Then for each charge which is 10x UNI$, you can copy/paste the formula into corresponding F column. Based on above you can calculate your own list of awarded UNI$ and if there is discrepancy, you need to call.
You have to do your own breakdown if UNI$ awarded per charge, they won't do it for you.