WVMomof3
DIS Veteran
- Joined
- Feb 21, 2005
- Messages
- 3,277
Another reminder
A fresh year is a great time to start tracking many things...here's some ideas for different sheets you may want to setup in a spreadsheet(s):
- A loyalty account balance tracker - Fields may include: Program Name, Person (i.e. me, wife, children), Points balance, Last Activity, Expiration Date (if applicable), As of Date (last time I verified the balance), Approx. Value (based on my personal valuation), Notes & Membership ID. Having this setup and updated on occasion will help you verify you're getting all the points you expected AND no fraud has occurred
- Credit Card Bonus tracker - Fields may include: Card Name, Last 4 of Acct#, Person (i.e. me, wife), Date Applied, Date Cancelled (if applicable), Annual Fee (if applicable), Annual Bonus (i.e. travel credit, free night), Signup Bonus, Min. Spend, Date Bonus Received, Bonus Value, % Return on MSR, Notes
- Bank Account Bonus tracker - Similar to CC tracker: Bank Name, Last 4 of Acct#, Date Approved, Date Cancelled (if applicable), Monthly Fee (if applicable), Fee Waiver Requirements, Date Bonus Received, Bonus Value, Notes (including when I can cancel the acct without penalty)
- Referral tracker - Card Name, Last 4 of Acct#, Person (i.e. me, wife), YTD referral total (in pts/$/etc.), Max pts/$ Available, Notes (including who used my referral if known so I might repay them in the future)
- Redemption tracker - I set mine up as follows (there are a lot of ways you could do this):
- GROSS COSTS (each as its own field):
Flight,
Hotel, Dining, Tickets, Other (SUBTOTAL)- LESS SAVINGS (each as its own field): Flight Points, Hotel Points, Other CC Savings, Misc Discounts, Other Savings (SUBTOTAL)
- GRAND TOTAL EXPENSED (typically $0 for us as I offset all travel expenses with some sort of savings)
- And not necessarily churning related but of course you could begin tracking all of your expenses if you aren't already doing so. I may or may not have 2+ other sheets showing various expense tracking, personal balance sheet, annual ledgers, projected retirement savings, etc...I also may be crazy
I know some people like using YNAB or something like that, but I'm a big "personal spreadsheet" guy on this stuff
I just spent the last couple days categorizing every CC transaction from all of 2018, all 1401 of them. Hoping to really stay on this weekly this year so I really see where we are spending this year. I am interested in your tracking of expenses and how you do it. I am trying to figure out the best way to go about exactly what I want to do. I am not going as deep as you and categorizing each thing, so not quite where you are. For example, Giant Eagle all goes to groceries whether I have bought dog food, detergent or other things also. Maybe I will be ready for that next year. lol But if you have any tips for me, let me know.