Keeping track of manufactured spend
#92
Join Date: Mar 2007
Location: Midwest U.S.A
Programs: Too many to list. Since the early 90's.
Posts: 1,407
Wife and I also use Excel for all our churning and ms record keeping and have for many years. Of course, we keep it locked with password protect and other ways to keep it very secure. It is our life on there, so worth more than gold. It does not exist on any phone nor will it ever, but that is our preference. Keep it safe!!
#95
Join Date: Mar 2014
Location: NC
Programs: CITI, Barclay, Fidelity Amex, CC
Posts: 128
http://www.flyertalk.com/forum/manuf...red-spend.html
http://www.flyertalk.com/forum/manuf...ng-system.html
http://www.flyertalk.com/forum/manuf...-accounts.html
Search is your friend. I used keyword track. Have fun.
http://www.flyertalk.com/forum/manuf...ng-system.html
http://www.flyertalk.com/forum/manuf...-accounts.html
Search is your friend. I used keyword track. Have fun.
#97
Join Date: Mar 2014
Location: NC
Programs: CITI, Barclay, Fidelity Amex, CC
Posts: 128
As for SS#s, I need one, plus DL, DOB, etc for each AP and Serve acct I operate. And I need them handy for when I call in to CS. Does anyone else, by the way, find themselves frequently impersonating someone of the opposite sex?
#99
Join Date: Feb 2014
Location: PHL
Posts: 930
If all you have is information like what you bought, when you redeemed it, etc., there is not anything people can do with it. Heck, even if you are storing your VR numbers on Excel, it is probably safe. Just sensitive things like SSNs, DL numbers, etc. are best not stored.
#101
Join Date: Jul 2008
Posts: 245
I tried Quickbooks online but it wouldn't let me split payment properly on a moneymaker like the officemax $15 off $250 visa gift cards. If I bought $1000 and the credit card charge is 1000 + 34.65 - 60, it would not let me do the 1000 as a transfer to uncashed gift cards + mark the 34.65 as a purchase fee and mark the 60 as cash back. I could do journal entries to resolve but did not like the extra step. Any tips?
#102
Join Date: Feb 2012
Location: LAX
Programs: AA, TY, UR, UA, US, WN, MR, SPG
Posts: 1,453
I tried Quickbooks online but it wouldn't let me split payment properly on a moneymaker like the officemax $15 off $250 visa gift cards. If I bought $1000 and the credit card charge is 1000 + 34.65 - 60, it would not let me do the 1000 as a transfer to uncashed gift cards + mark the 34.65 as a purchase fee and mark the 60 as cash back. I could do journal entries to resolve but did not like the extra step. Any tips?
#103
Join Date: Apr 2013
Posts: 102
I tried Quickbooks online but it wouldn't let me split payment properly on a moneymaker like the officemax $15 off $250 visa gift cards. If I bought $1000 and the credit card charge is 1000 + 34.65 - 60, it would not let me do the 1000 as a transfer to uncashed gift cards + mark the 34.65 as a purchase fee and mark the 60 as cash back. I could do journal entries to resolve but did not like the extra step. Any tips?
#104
Join Date: Mar 2014
Location: NC
Programs: CITI, Barclay, Fidelity Amex, CC
Posts: 128
#105
Join Date: Feb 2014
Posts: 60
I'm well versed in excel, but excel doesn't work for iPad or iPhone. So I prefer to use the google spreadsheet which can be easily accessed on all of my devices.
Google spreadsheet is pretty robust these days and even supports more complicated excel formulas like indexing, sumifs, and nested if statements. I use google spreadsheets to track all of my MS purchases, costs of those purchases and cash back earned on purchases. I also run all of that data through a dashboard (summary) so I can see my monthly MS spend, net cost/gain, and how much has been put on which cards. I think google spreadsheets are the way to go until Microsoft provides excel cloud support for iPhone and iPad.
Google spreadsheet is pretty robust these days and even supports more complicated excel formulas like indexing, sumifs, and nested if statements. I use google spreadsheets to track all of my MS purchases, costs of those purchases and cash back earned on purchases. I also run all of that data through a dashboard (summary) so I can see my monthly MS spend, net cost/gain, and how much has been put on which cards. I think google spreadsheets are the way to go until Microsoft provides excel cloud support for iPhone and iPad.