Category Cards bonus Spreadsheet

A work in progress. This is bonus only, no EDP.
Category Rewards Spreadsheet

Please post any changes/updates

Interesting.. I have something similar for my credit cards
https://docs.google.com/spreadsheet/pub?key=0AmM6lFxEl6RMdERHVFF...

I like the spreadsheets. I was just pondering creating something similar when I stumbled upon this post.

I've also been thinking about creating something that I can put in my wallet, so I remember which card to use at any given time. Maybe a small label from a brother label-maker (for example) that I can stick to each credit card on a quarterly basis, or perhaps just a credit card sized cheat-sheet to keep in my wallet. With 6 cards, that change quarterly, it's hard to remember sometimes which one to use when I'm out shopping.

Anyone devise a similar system that they'd care to share?

BingBlangBlaow said:   Nice list OP. I believe Citi Fwd is also 5p on movies.

Added, Thanks!

With the 5% Grocery on Chase Freedom you should be able to hit the gas stations attached to those stores.

E.g. meijer and Kroger gas didn't count in Jan-Mar, so they should count now. Or, buy gift cards for your preferred gas station at the grocery store.

imbatman said:   talljay said:   I have an Android App in progress that is almost ready.

And yes, it'll be free.

That will be nice for my wife. Not on iphone though?

No iPhone for following reasons:
A) I don't have an iPhone
B) no simple and cheap path to develop apps for iPhone

Great spreadsheet(s) maybe add a column for annual fee?

Isn't the Chase card usually 3 categories per quarter? Did they nerf it or something?

soccerref said:   Great spreadsheet(s) maybe add a column for annual fee?
Just implemented your request + added more info to the spreadsheet.

thok said:   Isn't the Chase card usually 3 categories per quarter? Did they nerf it or something?

Chase Freedom has two categories for three out of four quarters in 2012. Take a look here: https://creditcards.chase.com/freedom/Activate.aspx

I appreciate the input. I'll make the changes when I get home later tonight.

Nice. Now if OP and jazzboyrules will commit to update their spreadsheets every month/quarter - THAT would be awesome!

BTW, another thread posted something along similar lines, but involved a bit of coding:
http://www.fatwallet.com/forums/finance/1113199/

wam1 said:   I like the spreadsheets. I was just pondering creating something similar when I stumbled upon this post.

I've also been thinking about creating something that I can put in my wallet, so I remember which card to use at any given time. Maybe a small label from a brother label-maker (for example) that I can stick to each credit card on a quarterly basis, or perhaps just a credit card sized cheat-sheet to keep in my wallet. With 6 cards, that change quarterly, it's hard to remember sometimes which one to use when I'm out shopping.

Anyone devise a similar system that they'd care to share?

When I have the time (which is not always) I'd abbreviate the categories and SMS it to my phone. When I do that, I post it on FWF, as well...but I usually focus on the Citi Dividend & Chase Freedom whereas a ton of members here play a bigger game -

Perhaps we should just sticky the spreadsheets that the two members shared here, and the OPs can allow a few other members to also enter data in the spreadsheets to keep them current and relevant to a wider swath of members.

MoneyOCD said:   I think you got Citi Dividend wrong for Q2

Earn 5% Cash Back when you use your Citi Dividend Card from
April 1, 2012 through June 30, 2012 at:
The Home Depot® and on Home Furnishing and
Home & Garden purchases once you enroll.

I think you're right. I lumped them all into Home Improvements. I'll add Home Depot and leave
Home and Garden in Home improvements? I need to look at MCC codes for Home furnishings. Do
they really break it down to just furniture stores? Would that include BedBugs and Beyond?

FW10001 said:   Nice. Now if OP and jazzboyrules will commit to update their spreadsheets every month/quarter - THAT would be awesome!

BTW, another thread posted something along similar lines, but involved a bit of coding:
http://www.fatwallet.com/forums/finance/1113199/

The spreadsheet is for my personal use, so that's going to stay up-to-date for sure.
If anyone wants to add their card to this spreadsheet, let me know in this thread or PM me (quicker).

Anyone devise a similar system that they'd care to share?

I have little 1x2 post-it notes taped onto the back of my cards (right below the mag strip, of course), I put the 5% categories and Jan-Mar 12 or Apr-June 12 I write kinda small, so I can get all four quarters on one po

Like wam1, I used to put labels on the back of each CC. Now I use a folded cheat sheet, the size of a register receipt, in my wallet.

CKritiv1 said:   clutchcargo777 said:   MoneyOCD said:   I think you got Citi Dividend wrong for Q2

Earn 5% Cash Back when you use your Citi Dividend Card from
April 1, 2012 through June 30, 2012 at:
The Home Depot® and on Home Furnishing and
Home & Garden purchases once you enroll.

I think you're right. I lumped them all into Home Improvements. I'll add Home Depot and leave
Home and Garden in Home improvements? I need to look at MCC codes for Home furnishings. Do
they really break it down to just furniture stores? Would that include BedBugs and Beyond?

I spoke to a CSR @ Citi earlier today to get some idea of the types of stores that would qualify for the 2Q 5% Home Improvement category on the dividend platinum card. She mentioned that Home Depot, Lowes, paint stores like Sherwin-Williams and hardware stores such as Ace Hardware are included, but stores like BB&B aren't, as it is a home furnishings, not home improvement store. I think Chase Freedom had BB&B included as part of home furnishings last year and I was able to pick up some GCs there, but that isn't offered this year.

Thanks. GC's was what I had in mind.

bauzer71487 said:   With the 5% Grocery on Chase Freedom you should be able to hit the gas stations attached to those stores.

E.g. meijer and Kroger gas didn't count in Jan-Mar, so they should count now. Or, buy gift cards for your preferred gas station at the grocery store.

Kroger gas counted for me on my chase freedom. I think it may be the opposite come next month. I'll be buying a Kroger gift card, then using it at the pump.

Good idea on the app; you should think about converting to HTML5 and deploying the app to the web so it won't be limited to one platform; I'd be interested in doing this if you aren't.

Discover Card (up to 1% on all other purchases):
-------------------------------
April - June
5% on Restaurants, Movies up to $1,500 in spending.

July - September
5% on Gas, Movies, Themeparks up to (TBD) in spending

Oct-Dec
5% on Department Stores, Electronics Stores, Toy Stores, Movies up to (TBD) in spending

Updated for Q3