Originally Posted by
Illinwu
I have been using a spreadsheet to tack monthly spending since day 1; the EQN numbers (calculated from the running total) recently does not match what was posted by Hyatt. Wondering whether others encountered the same issue. I called Chase to inquire the running total but was told they cannot release this number to me.
edit - I use each month’s statement’s “new balance” #.
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.