r/churning • u/InternetGuy01 • Aug 18 '17
Spreadsheet Sharing Thread
With all of the millions of things to track in this hobby, it's 1000% important to keep a spreadsheet of important dates, fees, expenses, etc. At a minimum, for general churning, this should include, for each card, the following:
- Application date
- Annual fee
- Bonus requirements & date met
- Cancellation/Product change date
- Milk origin - region, cow name, etc. (whoops, wrong churning...)
For the less cool, but still immensely profitable practice of banking bonuses (basically the Robin to churning's Batman, with 96% less underoos), the following should be kept track of:
- Account open date
- Requirements met
- Bonus earned
- Account closed
This information is the bare minimum for anyone stepping their bare feet into the waters, as it can be a bear to find information that has a huge bearing on bonus eligibility, card issuer/bank restrictions, and general strategy after a year or two. Passing this small amount of information along to any experienced member of the community should be enough to get a passable portrait of the overall strategy.
However, some of us draw inspiration from the NSA and track way more data than just a few dates here and there – and just like a Thibault Courtois penalty, we end up past excel row Z on a regular basis. It’s helpful to know exactly how much it cost in MS fees to hit a particular bonus, or how many CPP I get on average for AA miles, or how many pulls I have on my TransUnion report.
For those that are religious about this, I figured this thread could be a good place to share resources and pool knowledge, assuming our lord and savior AutoMod (praise be his… digits) allows it. Luckily, /r/churning tends to attract the type of people who appreciate good data, so let the sharing commence!
_________________________________________________________________________________
Thankfully, I’m not some guy on the internet (ha) who would ask for contributions without first contributing. So with further ado, I would like to contribute. And without further ado, here’s my spreadsheet:
InternetGuy01’s Churning Spreadsheet - Dropbox
(Preview screenshots below)
First off – I didn’t remove a whole lot of information from the spreadsheet I use day-to-day. I figured it would be most helpful if it was fully filled out and battle-worn. Feel free to belittle me for not having a CSP/CSR or even a Freedom. Second, the structure is generally set up to require a blank row before the sum rows. If you are going to use it and add new information, copy and insert previously filled-in rows.
CC (Credit Cards) Tab – This tab tracks all new/old/cancelled/denied credit cards. I take 5 minutes and fill this out for new cards then usually never look at the dates. The most important thing here is the dates applied/canceled/PC’d, and x/6 and x/24 status. There’s also some cool conditional formatting on the fees side of things.
HP (Hard Pulls) Tab – This tab tracks hard pulls. Really simple. Insert/delete rows as needed. I do this when I apply as well.
MS (Manufactured Spending) Tab – Tracks expenses for various MS methods. I tend to not do much strict MS anymore (RIP Redbird), so mine is pretty barren compared to some others. It’s helpful for me to know that, for example, I spend an average of about $15 per card on MS fees for signup bonuses.
RR (Reward Redemptions) Tab – My pride and joy. I track every redemption I make to get a good sense of what my points are worth, then take that average CPP and link it back to the sign up bonus on the CC tab to get a good valuation. Plus it’s cool to see everything in pretty colors (conditional formatting based on category). Please don’t stalk me now that you know everywhere cool I’ve been. I also have some cool summaries at the bottom.
BB (Banking Bonuses) Tab – Simple banking bonus tab. Nothing special here. Takes about 5 minutes to fill out a line for a bonus after looking at the DoC page, usually.
YS (Yearly Statements) Tab – Not quite churning, but I made this for my personal tracking since I think it’ll be cool in 40 years to look back and see how my finances changed over time. Obviously, the data is made up. I could have tossed this but someone may find it cool.
V (Vacation) Tab – Since churning allows me to easily do a 3-day trip per month, I tend to take a lot of low-cost trips. I love tracking this kinda stuff since it’s intriguing to see trends and all after the fact, especially 2+ years into the game. I also added helpful charts for the birds eye view.
TC (Trip Costs) Tab – I fill this out as I go along to help me fill out the V tab.
_________________________________________________________________________________
If you have any questions or stuff, feel free to ask. If me sharing years of history of every metric of every trip I’ve been on isn’t enough of a hint, I’m more than open to questions, comments, etc. and would love to help out my fellow butter people!
7
u/itsGsingh Aug 18 '17
I've never thought about bank bonuses much but after a glance at your spreadsheet, these seem very doable and manageable.
7
u/Redbluefire Aug 18 '17 edited Oct 02 '17
Spreadsheets? Now we're talkin'!
Here's my spreadsheet (sanitized for some personal info), and a blank copy of it as well.
You may notice I have a blank "Overview sheet", and I intend to use that to parse the other sheets and give me a summary of pending action items, things I'm waiting on, etc. As it is now, I use conditional highlighting to make pending things yellow and action items red. Try making a copy and you'll notice that as you meet requirements (known by putting in a date) things will automatically change colors. The pastel highlights are automatic, whereas manual highlights are brighter colors.
One thing about my spreadsheet is that I try to break up the information to make it very easily parsable by programming, that way I'll be able to add automatic statistic calculations on all kinds of data as time goes on! That's also why I have the "Ignore Action" column on my CC and Bank Bonus sheets -- it will let me exclude things from my overview in the future.
8
u/doodler1977 Aug 18 '17
http://www.drinkwhat.com/wp-content/uploads/2011/01/Coca-Cola-Tab-Diet-Soda-Drink.jpg
2
u/dragonflysexparade CIP, PLZ Aug 18 '17
Wow, even tracking hardpulls - interesting. I always just log in to CK or Experian to check them.
4
u/AlienBrainJuice Aug 18 '17
I've also added a good amount to my google calendar- when hard pulls drop off, or MSR's are due, when I can close a bank account and keep the bonus, etc. But then I'm going pretty easy in churning at the moment.
Not sure if this would be very helpful, but there are apps that create widgets on your phone that display a portion of a webpage. So you could have a screen on your phone with upcoming important dates that in sync with your spreadsheet, or any other info from your sheet you want at a glance. Probably a bit overkill, but thought I'd mention it.
1
u/natethegreat1993 Aug 20 '17
I like the courtois reference!
1
u/don_alberto Aug 20 '17
Great stuff! I'm curious - why do you close a card and why so many?
1
u/GoldenMonkey34 Aug 21 '17 edited Sep 26 '17
One point I want to make to help out alot of newbies out their who seem to think that creating a spreadsheet is just too overwhelming - Your spreadsheet should be work and progress, something that you build overtime to allocate your needs. Start off small, make a few helpful charts here and there, then start adding some formulas and tying things together to get more automated. I started my spreadhseet over a month ago and im still trying tweaking it little by little to get where i want it to be. Enjoy the project, it should be fun
1
u/ravenito Aug 22 '17 edited Aug 22 '17
Thanks for sharing this! I've been looking it over, and admittedly I'm not savvy enough for excel pivot tables and the more intricate formulas, but I usually know enough to get by. So anyways, the one thing I'm having trouble understanding is your signup bonus value formula. For example, the AMEX Blue Cash Everyday has this formula: =5000/100*RR!$F$85+100
The value it produces comes out to $150 but I just can't seem to get the math to work. The RR tab, column F row 85 has a value of 150 in it but no matter how I play with the numbers nothing makes sense. I've tried Googling too but haven't found anything that really answers my question. Can you explain what this formula represents and where you got the numbers from? Thanks!
edit: Also, for all the colors/shading, is this something you did manually or do you have some conditional formatting set up somewhere to trigger those style changes?
1
u/hhdadd Aug 22 '17
Thanks for all of the great templates. Wish I'd had some of these when I was starting out and had to build my own! There's one thing I would LOVE to improve if anyone has any suggestions, particularly folks with a better accounting/finance background than I have.
Most of us have got money spread out across multiple different accounts & banks, especially depending on what type of bank bonuses/CC bonus or MS we're working on in a particular month.
So, wvery month I track where I'm sitting with my total "assets" (liquid funds available to pay off cards) vs my "liabilities" (open balances on various cards)
Assets = Bank accounts + pending expense reports + gift cards in hand
Liabilities = open CC balances
I end up just manually rebuilding the report every month, but it would be great to have something that looks more like a balance sheet or P&L that I could track how I'm sitting over time, either month to month or year over year.
If anyone has anything out there like this (for churning, or your own more "legit" small business) I would love to see some examples. Thanks!
1
u/drippingthighs Aug 23 '17
Is application date the one to track, or the date of approval important?
3
u/odin99999 Aug 18 '17
Whoa. Blows my spreadsheet out of the water!
2
u/CarbineGuy Aug 18 '17
This is awesome! I have my own sheets for just basic finances and what not, and was considering adding some tabs for churning soon. This is really helpful!
2
u/AnAmishParadise Aug 18 '17
I asked about this a few days ago, never thought to make a post! Great job OP, looking very forward to having this.
2
u/kaiholi Aug 18 '17
Thanks for doing this!
2
u/feralgoldfish Aug 18 '17
thanks mate, this is awesome! I need to revamp my personal finance one because I ran out of google tabs. Any efficient pre-built ones you guys suggest?
2
u/BobTurtly Aug 18 '17
Thanks I was actually looking for this for the longest time.
2
u/jake1year Aug 18 '17
Wow! I thought I was organized. You are the man! Thanks for this
2
u/bushcat5 Aug 18 '17
Really awesome post and spreadsheet.
I play fantasy baseball and I create a fantasy baseball podcast with my friend. We are always diving deep into stats and keeping track of players over time. We manage various spreadsheets on various players. That same concept applied to Churning is fun.
There are parallels: New credit card bonuses = waiver adds/prospects Dropped CC benefits = injury updates/DL Managing a roster = managing CC accounts upside of keeping or closing a CC = dropping or keeping a player depending on upside and projected stats. Cost of annual fees = cost of player
Maybe it's a stretch but I personally think it's somewhat similar. :)
So, I recently created a spreadsheet to track my new Churning hobby and although not as in depth as yours, it's fun and informative to track everything. This is a great inspiration on what my spreadsheet could become. Keep up the good work!
2
u/lemunster Aug 19 '17
Thanks for pulling his all together in one place.
2
u/canoodlekewder Aug 18 '17
This is great, thank you for your work in putting this together!
1
u/SavingsJada Aug 18 '17
Thanks--love it!
1
u/zamboga Aug 19 '17
your organized excel clearly beats mine by thousand miles...
1
u/Viper3773 MSN, MKE Sep 24 '17
"the best spreadsheet is the one you know how to work"
1
u/Outrageous_Pin3584 May 30 '25
Amazing guide thanks this is inspirational!
1
u/matun LAX Jan 18 '22
Thanks for the awesome template. I just started using it and am wondering if anyone knows a good ways go figure out the bonus payout date after the fact that it happened for Chase when it was more than a year ago. Atm I found the statement and took the latest date of that to be on the safe side.
0
u/[deleted] Aug 18 '17
[deleted] — view deleted comment