Community
Wiki Posts
Search

Keeping track of manufactured spend

Thread Tools
 
Search this Thread
 
Old Sep 20, 2014, 1:35 pm
  #166  
 
Join Date: Dec 2010
Location: Indianapolis
Programs: Hilton-Diamond Lifetime Platinum AA UA, WN-CP, SPG Gold.
Posts: 7,377
Quicken can do it easy, track it and even generate a report.
satman40 is offline  
Old Sep 20, 2014, 2:14 pm
  #167  
 
Join Date: May 2014
Posts: 193
Originally Posted by unkinected
Forgive me mods if this violates the ToS regarding self-promotion, but since this thread is specifically devoted to tools for keeping track of MS and I'm not using a referral link, I thought I'd share. Feel free to delete.

I have a site manspender.com. I think it does a lot of the things people have requested here, and we're actively developing it to add features. Check it out if you're interested.
Thanks! I just registered. Looks great!
Peridot83 is offline  
Old Sep 21, 2014, 9:02 am
  #168  
 
Join Date: Aug 2013
Posts: 240
Originally Posted by ZeroMile
this how I do it in quicken, $504.95 (1 OV purchase), split: $499.54 Category to checking account (where the money deposited), $4.95+0.46 MO Category as MS expenses. when the reward posted/deposited in the account, category as MS income.
Sorry that I am kind of acting a newb here. I have been thinking about this/ trying to interpret what you are saying for about 10 minutes. Not clear on what you are saying, though.

Are you saying that you split the credit card transaction as some kind of a "transfer" to two separate accounts (checking account and some kind of expense account)? One is an actual checking account and one is a virtual account for the fees. Are you using some sort of liability account for the fees?

Or are you just entering the fees by hand and not having them linked to anything (creating a new item, as opposed to the aforementioned "split transfer")?
Silverthunder is offline  
Old Sep 22, 2014, 7:48 am
  #169  
 
Join Date: May 2014
Posts: 201
Originally Posted by Silverthunder
Sorry that I am kind of acting a newb here. I have been thinking about this/ trying to interpret what you are saying for about 10 minutes. Not clear on what you are saying, though.

Are you saying that you split the credit card transaction as some kind of a "transfer" to two separate accounts (checking account and some kind of expense account)? One is an actual checking account and one is a virtual account for the fees. Are you using some sort of liability account for the fees?

Or are you just entering the fees by hand and not having them linked to anything (creating a new item, as opposed to the aforementioned "split transfer")?
I do a similar thing using a program called "You Need a Budget" (which is a very awesome philosophy/tool, but that's a separate topic).

I have a "virtual" account called "MS Cash Account." A $500 OV purchase, for example, goes in as a split transaction. A $500 transfer from the purchasing CC to the "MS Cash Account" and a $4.95 purchase against a "MS Fees" category. When I go to liquidate the OV, I make a transaction FROM the "MS Cash Account" to wherever it's going (BB, Serve, MO, whatever).

So this process involves creating a virtual cash account to keep track of the GCs I have, and a category to keep track of the fees I'm accumulating. I also have a "MS Income" category that is obviously used to keep of any income I receive from MS, such as CC cash rewards, portal CB, etc.
unkinected is offline  
Old Sep 22, 2014, 8:19 am
  #170  
 
Join Date: Oct 2013
Programs: Hyatt Globalist No More..., Hyatt Explorist, Hilton Diamond, SPG Platinum, Marriott Platinum
Posts: 4,375
Originally Posted by Silverthunder
For the people that use Quicken, do you use the asset and liability accounts? Or do you guys just put the gift card load amounts (or whatever you label the category) as a checking account?
Originally Posted by ZeroMile
this how I do it in quicken, $504.95 (1 OV purchase), split: $499.54 Category to checking account (where the money deposited), $4.95+0.46 MO Category as MS expenses. when the reward posted/deposited in the account, category as MS income.
I do almost identical thing on Mint.com. For the credit card charge, I mark it as "Gift Card Purchase" if I am not liquidating immediately that day or the next OR "Money Order" OR "Bill Pay" OR "Prepaid Load". Then when I get the money into the appropriate checking, prepaid, etc. acct I mark them the same. I take the fees used for purchase (e.g. $4.95) or money order fee (e.g. $0.89), etc and split that off into the category "Cashback Bonus". And any positive money I get cashback (i.e. credit card cashback or portals) also goes into that category. This way it's easy to see if I am missing money anywhere. Every month my "money order", "prepaid load", etc category has a $0.00 balance. (I found $500 missing this way. I had an unused gift card sitting in a bag in my car. Good thing I caught it and didn't throw the bag away!)

Trying to put into an asset group or whatever would take too long given the amount of GCs I buy a month.
cdancer20 is offline  
Old Sep 22, 2014, 8:28 am
  #171  
Suspended
 
Join Date: May 2010
Posts: 2,998
Man, there's a LOT of over complication going on here.
Stoughton is offline  
Old Sep 22, 2014, 3:49 pm
  #172  
 
Join Date: Dec 2013
Posts: 3,507
Originally Posted by Stoughton
Man, there's a LOT of over complication going on here.
+1. I mean I don't have the best MS tracking system but I have a rough idea of how much CB/points that I should get back and I just check my statement to confirm this and post them to my spreadsheet. I don't try to keep track of it to the very penny. I do keep track in a running list in a spreadsheet of GC value and GC fees just so I know how much in Fees I have shelled out so far.
ericdabbs is online now  
Old Sep 22, 2014, 6:33 pm
  #173  
 
Join Date: Aug 2013
Posts: 240
Originally Posted by unkinected
I do a similar thing using a program called "You Need a Budget" (which is a very awesome philosophy/tool, but that's a separate topic).

I have a "virtual" account called "MS Cash Account." A $500 OV purchase, for example, goes in as a split transaction. A $500 transfer from the purchasing CC to the "MS Cash Account" and a $4.95 purchase against a "MS Fees" category. When I go to liquidate the OV, I make a transaction FROM the "MS Cash Account" to wherever it's going (BB, Serve, MO, whatever).

So this process involves creating a virtual cash account to keep track of the GCs I have, and a category to keep track of the fees I'm accumulating. I also have a "MS Income" category that is obviously used to keep of any income I receive from MS, such as CC cash rewards, portal CB, etc.
That's interesting. So this software that you speak of lets you transfer part of the charge to these separate accounts. The only way that I can think for Quicken to do something similar is to (1) delete the payments that would normally show on your credit card transaction history; and (2) enter in these transfers that you speak of instead.

Also, I am not in love with your naming of the accounts. I prefer names that start out with different letters (instead of them both starting with "MS"). this way data entry is quicker with fewer errors.

Originally Posted by cdancer20
I do almost identical thing on Mint.com....
I can't use Mint.com because it can't go back very far in time. I am not aware of a way to bring in older transactions (say from early 2013) into Mint.com. Then again, maybe there is a way.

Originally Posted by Stoughton
Man, there's a LOT of over complication going on here.
Let the flaming of my posts begin lol

Last edited by Silverthunder; Sep 22, 2014 at 6:39 pm
Silverthunder is offline  
Old Sep 22, 2014, 6:37 pm
  #174  
Suspended
 
Join Date: May 2010
Posts: 2,998
Originally Posted by ericdabbs
+1. I mean I don't have the best MS tracking system but I have a rough idea of how much CB/points that I should get back and I just check my statement to confirm this and post them to my spreadsheet. I don't try to keep track of it to the very penny. I do keep track in a running list in a spreadsheet of GC value and GC fees just so I know how much in Fees I have shelled out so far.
I do track to the cent, and it's all on 1 page. Liabilities, Assets, Pending, net - updated daily, checksummed Tues & Fri. Also has countdown to target spend, monthly totals, and few other things.
Stoughton is offline  
Old Sep 22, 2014, 7:40 pm
  #175  
 
Join Date: Oct 2012
Posts: 299
keeping track...

I have a method for keeping track of the fees paid on all the GC. In the last 15 month of my MS hobby, I have never thrown out 1 GC. When I return home from my rounds or work, I dump all the used cards in this box I have in my garage that I keep adding to, it contains all the OV/VR/VGC/MCGC/PP MY Cash cards. and I think that's it. And the box is heavy. Actually don't want to spend the time figuring. So... 1) what do most folks do with the used cards..2)are they recyclable? Don't really care about #2, but trying to act concerned.
barrytuneup is offline  
Old Sep 23, 2014, 5:35 am
  #176  
 
Join Date: Oct 2013
Programs: Hyatt Globalist No More..., Hyatt Explorist, Hilton Diamond, SPG Platinum, Marriott Platinum
Posts: 4,375
Originally Posted by Silverthunder
I can't use Mint.com because it can't go back very far in time. I am not aware of a way to bring in older transactions (say from early 2013) into Mint.com. Then again, maybe there is a way
I'm not aware either. I just started using Mint in like 2012 or whatever and it always seemed to start on the date that I created that acct. If Quicken has that ability, that's great! But of course, I would expect Quicken to have far better ability since you pay for it.
cdancer20 is offline  
Old Sep 23, 2014, 5:50 am
  #177  
 
Join Date: May 2010
Posts: 688
I just use a spreadsheet and I track my purchases by month, cards I used to make the purchase, and GC's that I actually purchased. This let's me track how much MS'ing I do each month.

I don't keep track of all the fees but I try to stick to the lowest fee cards to minimize the cost.

Last edited by rtraveler; Sep 23, 2014 at 6:09 am
rtraveler is offline  
Old Sep 23, 2014, 7:44 am
  #178  
 
Join Date: May 2014
Posts: 201
Originally Posted by Silverthunder
That's interesting. So this software that you speak of lets you transfer part of the charge to these separate accounts. The only way that I can think for Quicken to do something similar is to (1) delete the payments that would normally show on your credit card transaction history; and (2) enter in these transfers that you speak of instead.

Also, I am not in love with your naming of the accounts. I prefer names that start out with different letters (instead of them both starting with "MS"). this way data entry is quicker with fewer errors.
Well, "MS Fees" is a category, not an account. There's no transferring per se to "MS Fees."
unkinected is offline  
Old Sep 23, 2014, 10:05 am
  #179  
 
Join Date: Aug 2013
Posts: 240
Originally Posted by cdancer20
I'm not aware either. I just started using Mint in like 2012 or whatever and it always seemed to start on the date that I created that acct. If Quicken has that ability, that's great! But of course, I would expect Quicken to have far better ability since you pay for it.
Yes, Quicken can sometimes get older history. Although a lot of banks don't support this. I think I figured out a 2 step way to convert a PDF bank or credit card statement into a Quicken file. There is some leg work involved, though (but not much).

Originally Posted by unkinected
Well, "MS Fees" is a category, not an account. There's no transferring per se to "MS Fees."
Ok, that's the functionality that I am familiar with in Quicken.
Silverthunder is offline  
Old Sep 23, 2014, 8:55 pm
  #180  
 
Join Date: Apr 2009
Location: 787
Programs: Too many to list
Posts: 1,306
I make it simple.
20K buffer on my checking account and every Monday morning routine - pay cc bills on line .
As far as managing MS I have spreadsheet and do one card at a time. So if I got approved for 5 cards I write them down, sort columns by how much time I have (1) and amount (2). Bang, two month later its all done. Usually its takes 2-3 weeks just because I have old blue and recently fell in love with flex perks and arrival cards.
ThePointsCollector is offline  


Contact Us - Manage Preferences - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

This site is owned, operated, and maintained by MH Sub I, LLC dba Internet Brands. Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Designated trademarks are the property of their respective owners.