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.