FlyerTalk Forums - View Single Post - WoH Credit card! [Launched 2018] (Chase)
View Single Post
Old Oct 13, 2023 | 9:00 pm
  #3585  
Illinwu
5 Years on Site
 
Join Date: Jan 2020
Posts: 278
Originally Posted by kevinjm
From your monthly statement under Account Summary, the number listed for "Purchases" increases your running count.
If on the mobile app, under See All Transactions, filter by transaction type, I've confirmed that anything under "Return" should be subtracted from your running total.

So basically the formula for running count is : New Count = Previous Count + Purchases - Return

Edit: If you want to calculate this from scratch and have access to all your statements, then simply add every value under Purchases without regard to any other value in your statement. Then filter by Return, subtract all those values and you should have your current running count. Use the formula above to continue calculating it or simply keep a column for returns. Previously I mentioned Fee as a filter, but because they never fall under purchases they are already excluded from the running count. Subtracting them again would be an error.

I track my spend via an excel sheet and I can predict my next $5k threshold to within a few dollars.
For the 1st time, I read my recent statement carefully. Depends on timing, returns in the same period goes to “payment”, so I should not assume if purchase = new balance I don’t need to go to the payment/credit section. Thank you for the help.

Last edited by Illinwu; Oct 13, 2023 at 9:54 pm
Illinwu is offline