Scribd
Upload
424 views12 pages

Welcome To The Second Edition of The MS & Reward Program Spreadsheet!

This document provides instructions and a template for tracking manufactured spending, credit card rewards, and point balances. It outlines rules for updating the spreadsheet each month and coloring cells to track money loads. The spreadsheet then shows credit card spending in each month, money loads by account, current point balances, and redeemed points to calculate total point value earned. It also includes sections to list Serve/Redcard accounts, credit cards owed money, and personal credit card information.

Uploaded by

Brian
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
424 views12 pages

Welcome To The Second Edition of The MS & Reward Program Spreadsheet!

This document provides instructions and a template for tracking manufactured spending, credit card rewards, and point balances. It outlines rules for updating the spreadsheet each month and coloring cells to track money loads. The spreadsheet then shows credit card spending in each month, money loads by account, current point balances, and redeemed points to calculate total point value earned. It also includes sections to list Serve/Redcard accounts, credit cards owed money, and personal credit card information.

Uploaded by

Brian
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
  • Introduction and General Instructions: Provides introductory notes and general instructions for using the MS & Reward Program Spreadsheet effectively.
  • Credit Card Spending and Points Tracking: Details a record of manufactured spending and GC points earned through various credit cards over several months.
  • Account Balances and Liabilities: Lists balances across different accounts and outstanding liabilities related to personal finance management.
  • Version History Documentation: Documents changes and updates made across different spreadsheet versions highlighting key improvements and bug fixes.
  • List of Cards and Accounts: Provides an extensive list of credit cards and accounts grouped by issuer or brand, useful for reference.

Welcome to the second edition of the MS & Reward Program Spreadsheet!

Here are a couple ground rules to help you get the most of this spreadsheet.

1) Add new cards or reward programs by right clicking the last item in the
list and choosing "Insert One Above" in the MS & Reward Program sheet.
2) Update reward programs on the last day of the month. Make sure all information is correct
going into a new month.
3) You should not have to change any colored cell other than MS amounts
The MS fields will change automatically after adjusting.
of the "DO NOT MODIFY - ADVANCED" sheet. Make sure when adding reward programs in
the last 3 digits are the CPP. Example: Reddit Rewards 1.2
placed on each credit card, while the area below that is how much spend you have put on each
MS method (Serve/Redcard/VGC/etc).

MS Loads are colored as such:

Please delete this sheet to get started! Enjoy!


Current Version: 2.04

ams in

Redcard Key
0-999
1000-1999
2000-2999
3000-3999
4000-4899
4900-5000
Manufactured Spending + CC Points
Credit Card MS Jan Feb Mar Apr May Jun Jul Aug Sep Oct
South West Premier 2,450 2,000 2,950 1,000 500 0 0 0 0 0
IHG 1,000 2,000 1,000 3,000 2,000 0 0 0 0 0
Starwood (SPG) Business 2,500 500 50 2,200 2,500 0 0 0 0 0
South West Plus 2,000 0 3,000 0 4,000 0 0 0 0 0
Starwood (SPG) Preferred 500 1,000 3,000 0 600 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
Monthly Totals 8,450 5,500 10,000 6,200 9,600 0 0 0 0 0
MS Accounts Jan Feb Mar Apr May Jun Jul Aug Sep Oct
Redcard AB 3,450 1,000 5,000 0 0 0 0 0 0 0
Redcard GJ 5,000 4,500 5,000 0 0 0 0 0 0 0
Serve HU 0 0 0 3,500 4,600 0 0 0 0 0
Serve PB 0 0 0 2,700 5,000 0 0 0 0 0
Monthly Totals 8,450 5,500 10,000 6,200 9,600 0 0 0 0 0
Current Point Balance Jan Feb Mar Apr May Jun Jul Aug Sep Oct
British Airways 1.7 600 600 600 600 600 0 0 0 0 0
Southwest 1.4 0 0 940 109,787 110,117 0 0 0 0 0
American Airlines 1.7 0 0 50,127 103,240 104,250 0 0 0 0 0
Starwood 2.4 0 0 13,110 2,284 2,600 0 0 0 0 0
Citi ThankYou 1.6 15 0 0 0 25,223 0 0 0 0 0
Starwood 2.4 25,711 38,332 51,755 114,884 82,117 0 0 0 0 0
Chase UR 2.1 3 51,207 5,476 0 26,450 0 0 0 0 0
IHG 0.7 2,000 2,000 2,500 83,515 57,332 0 0 0 0 0
Hyatt 1.8 2,118 2,118 2,173 2,173 12,454 0 0 0 0 0
American Airlines 1.7 0 53,033 84,279 84,279 39,834 0 0 0 0 0
Redeemed Points Jan Feb Mar Apr May Jun Jul Aug Sep Oct
Starwood 2.4 7,000 0 0 0 0 0 0 0 0 0
Chase UR 2.1 0 0 51,827 5,476 0 0 0 0 0 0
Hyatt 1.8 0 0 0 0 66,000 0 0 0 0 0
American Airlines 1.7 50,000 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
Points Rewards Earned 2015
Nov Dec Totals Grand Total Total Points Point Value
0 0 8,900 39,750 641,280 $11,028.35
0 0 9,000
0 0 7,750
0 0 9,000
0 0 5,100
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0
Nov Dec Totals Grand Total
0 0 9,450 39,750
0 0 14,500
0 0 8,100
0 0 7,700
0 0
Nov Dec Totals Value Total Value
0 0 600 $10.20 $7,618.99
0 0 110,117 $1,541.64
0 0 104,250 $1,772.25 Grand Total
0 0 2,600 $62.40 460,977
0 0 25,223 $403.57
0 0 82,117 $1,970.81
0 0 26,450 $555.45
0 0 57,332 $401.32
0 0 12,454 $224.17
0 0 39,834 $677.18
Nov Dec Totals Value Total Value
0 0 7,000 $168.00 $3,409.36
0 0 57,303 $1,203.36
0 0 66,000 $1,188.00 Grand Total
0 0 50,000 $850.00 180,303
0 0 0
0 0 0
0 0 0
0 0 0
Redcard/Serve Accounts Current Cash
Email Address 1 Name 1
Email Address 2 Name 2 $1,000.00
Email Address 3 Name 3 $500.00
Email Address 4 Name 4

Cards Owed Money To MS Key


IHG $1000 Outstanding
SW Premier $1000 Payment Sent
Person 1 - Credit Card Information
Credit Card Bank Issue Statement Date Annual Fee
Starwood (SPG) Business AmEx 3/15/2015 $65
IHG Chase 3/15/2015 $49
Sapphire Preferred Chase 1/6/2015 $95

Totals $209

Person 2 - Credit Card Information


Credit Card Bank Issue Statement Close Annual Fee
South West Plus Chase 2/18/2015 $69
South West Premier Chase 2/18/2015 $99
Starwood (SPG) Preferred AmEx 2/11/2015 $65

Totals $233
Limit
$6,000
$12,000
$5,000

$23,000

Limit
$10,000
$6,000
$5,000

$21,000
Current Version 2.03

Version 2.04 - 5/31/2015


* Changed title on MS & Reward Program tab, cell A22, to "Current Point Balance" to help clarify.
* Changed a few areas on the instructions sheet, nothing important.

Version 2.03 - 4/20/2015


* Automated the selection of months in fields E23 to E32. Thanks /u/linkx2252 and /u/gmptvu !

Version 2.02 - 4/7/2015


* Fixed bug on cell B15 not calculating correctly for some reason
* Stated that P3 and P17 should match in the instructions

Version 2.01 - 4/5/2015


* Changed N22 to N23 on the instruction sheet. My bad.
* Added Citi Double Cash to list of credit cards
* Added monthly totals to the Redcard loads sheet
* Changed wording on the instructions
* Made card choices on "Credit Card Information" the standard drop down

Version 2.0 - 3/29/2015


* Created Instruction Sheet
* Made Redbird colors generate automatically
* Added fixed reward programs
* Added fixed credit cards to choose from
* Created MS & Reward Sheet
* Created Credit Card Information Sheet
* Released Spreadsheet Publicly
* Simplified the formula for point valuations

Version 1.0
* Created Manual Spreadsheet
help clarify.

/u/gmptvu !
AmEx Membership 2.0
Barclay Arrival+ 0.8
Capital One 1.0
Chase UR 2.1
Citi ThankYou 1.6
Diners Club Rewards 2.1
FlexPerks 1.6
Aeroplan 1.6
Alaska Airlines 2.0
American Airlines 1.7
ANA 1.7
Avianca 1.7
British Airways 1.7
Delta Airlines 1.2
Flying Blue 1.3
Frontier 1.1
JetBlue 1.5
Singapore Airlines 1.5
Southwest 1.4
United 1.5
Virgin America 2.0
Virgin Atlantic 1.5
Club Carlson 0.6
Hilton 0.5
Hyatt 1.8
IHG 0.7
Marriott 0.7
Ritz-Carlton 0.7
Starwood 2.4

Gold Delta
Gold Delta Business
Platinum Delta
Blue Cash Preferred
Blue Cash
Platinum Delta Buisiness
Delta Reserve
Everyday
Everyday Preferred
Premier Rewards (PRG)
Premier Rewards (PRG) Business
Platinum
Platinum Business
Starwood (SPG) Preferred
Starwood (SPG) Business
Mercedes-Benz
Hhonors
Hhonors Surpass
Jetblue
Blue Sky
Blue Sky Preferred
Alaska
Alaska Business
Asiana
Asiana Business
Spirit
Virgin Atlantic
Virgin Atlantic Black Card
Virgin Atlantic White Card
Bank Americard Cash
Sallie Mae MasterCard
US Airways
Arrival +
Arrival
Frontier
Frontier
Hawaiian
Lufthansa
Frontier Business
Hawaiian Business
Venture Rewards
Venture One Rewards
Quicksilver Rewards
Sapphire Preferred
Freedom
Ink Plus
Ink Cash
Hyatt
IHG
Marriott
Marriott Business
Ritz Carlton
Fairmont
South West Plus
South West Premier
South West Business
United Explorer
United Explorer Business
United Club
British Airways
AAdvantage Platinum
AAdvantage Business
AAdvantage Executive
AAdvantage Gold
Double Cash
Expedia+
Expedia+ Voyager
Hilton Reserve
Hilton Visa
Thankyou Premier
Thankyou Preferred
Thankyou Preferred Student
Citi Prestige
Virgin America
Virgin America Premium
Discover It
Discover It Miles
Aeroplan
FlexPerks Travel (Visa Sig)
FlexPerks Travel (Amex)
FlexPerks Select+
Club Carlson Premier
Club Carlson Business
Club Carlson Rewards
Wells Fargo Propel World
Wells Fargo Propel 365

You might also like