Can someone post their excel layout sheet?
Aug 9, 2014 | 10:07 am
#16
Join Date: Oct 2012
Location: BOS
Programs: MR, UR, AA, AS, HH Gold, SPG Gold, HGP, RR
Posts: 708
You should be tracking the date the bonus points are received, especially with Chase as they now are stating minimum 24 months since last bonus received in order to get another from each specific program (ie Marriott, United etc.) I also track the date the spend is met. You want the approval date as that is what starts the clock on your spend. You could also add columns for retention bonus and/or cancel date.
Additionally, I track the last time I used each card so I can ensure that none get closed for lack of use.
Additionally, I track the last time I used each card so I can ensure that none get closed for lack of use.
Aug 9, 2014 | 11:21 am
#17
Join Date: Jul 2014
Posts: 197
I have these columns: card name, owner (to track mine and SO), sign-up date, annual fee, sign-up bonus, spend requirements ($, months), deadline for meeting spend, statement cut, earning (points/$), cancel date, credit pull date.
To track spending, I use Quicken.
To track spending, I use Quicken.
Aug 12, 2014 | 9:00 am
#18
Join Date: Jun 2013
Posts: 60
Aug 15, 2014 | 10:46 am
#20
Join Date: Aug 2009
Location: Left Coast
Posts: 892
One of the points & miles bloggers (Milenomics) posted a Google Doc form/spreadsheet which can be used for tracking.
I've used Quicken for 15+ years to track everything, but I find it helpful to keep a secondary record with Excel for various things. That spreadsheet posted by MasterCharge is pretty slick.
Speaking of which, when you record, say, a purchase of VGC which are later unloaded via BB, are you recording both as a positive number (so that $5K worth of VGC and the same $5K unloaded records as $10K total), or are you recording one positive and one negative, so the net is $0?
I've used Quicken for 15+ years to track everything, but I find it helpful to keep a secondary record with Excel for various things. That spreadsheet posted by MasterCharge is pretty slick.
Speaking of which, when you record, say, a purchase of VGC which are later unloaded via BB, are you recording both as a positive number (so that $5K worth of VGC and the same $5K unloaded records as $10K total), or are you recording one positive and one negative, so the net is $0?
Aug 15, 2014 | 4:20 pm
#21
Join Date: Jun 2013
Posts: 555
I use a heavily modified version of one I found on here last year. I have a main sheet for the card list ('Account History'), and a second sheet for credit exposure by issuer and hard pull calendar. Here are some useful formulas for those of you who might be interested:
Will give you the number of open accounts with A2 (Chase).
Will give you your current exposure with A2 (Chase).
- Let's say A2 on the exposure sheet is the certain issuer we want to know about, for example Chase.
- Let's also say column C on the main 'Account History' tab is approval type, and any account there that doesn't say Denied is considered to have opened at some point.
- Also, column E is a closure date, and any row with that entry is considered a closed account.
- Column M is the lender.
- Column N is the CL.
=COUNTIFS('Account History'!M4:M500,"*" & A2 & "*",'Account History'!C4:C500,"<>Denied",'Account History'!E4:E500,"")
=SUMIFS('Account History'!N4:N500,'Account History'!M4:M500,A2,'Account History'!E4:E500,"")
Aug 15, 2014 | 4:29 pm
#22
Join Date: Jun 2013
Posts: 555
Next up, a hard pull calendar. Note that because this involves formulas that will recalculate results based on the current date when you open the excel doc, every time you open it you will be asked to save changes even if you didn't change anything.
Gives you the number of pulls from the issuer in A2 in the past 2 years (roughly)
Gives you the number of pulls from the issuer in A2 in the past year (roughly)
Gives you the number of pulls from the issuer in A2 in the past 6 months (roughly)
- I use the abbreviations EQI, EXP, and TRN
- Let's say A2 on the exposure/calendar sheet is the issuer whose pulls we want to know about.
- Column B on 'Account History' is the date of application
- Column F on 'Account History' is the bureau pulled (multiple is allowed, ex EQI/EXP)
=COUNTIFS('Account History'!B4:B400,">"&TODAY()-730,'Account History'!F4:F400,"*"&A2&"*")
=COUNTIFS('Account History'!B4:B400,">"&TODAY()-365,'Account History'!F4:F400,"*"&A2&"*")
=COUNTIFS('Account History'!B4:B400,">"&TODAY()-183,'Account History'!F4:F400,"*"&A2&"*")
Sep 10, 2015 | 8:27 pm
#23
Join Date: Apr 2014
Posts: 18
if anyone want a copy of the spread sheet here's a link to download http://stashbox.org/1563918/Spend%2B...DTemplate.xlsx i saved it as read only, so once you download it just save an editable copy to use for yous spending, deposits, etc.
it has built in formulas to auto calculate spending and deposits, i.e daily, monthly, year to date, etc.
it has built in formulas to auto calculate spending and deposits, i.e daily, monthly, year to date, etc.