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.
..here's some ideas for different sheets you may want to setup in a spreadsheet(s):
I know some people like using YNAB or something like that, but I'm a big "personal spreadsheet" guy on this stuff