FlyerTalk Forums

FlyerTalk Forums (https://www.flyertalk.com/forum/index.php)
-   Manufactured Spending (https://www.flyertalk.com/forum/manufactured-spending-719/)
-   -   Tracking Methods (https://www.flyertalk.com/forum/manufactured-spending/1546183-tracking-methods.html)

carsonheim Jan 28, 2014 3:20 pm


Originally Posted by kd1000 (Post 22240788)
Most folks seem to keep detailed information and receipts .. for some reason I didn't see much value in keeping receipts once I deposit my GC's and the money is in my BB account.. I rely on by credit card statement and BB / bank account statement to tally in and out every week.

Are there any risks that I should be worried about by not having receipts ?

http://www.flyertalk.com/forum/manuf...hone-call.html

trippinbilly Jan 28, 2014 5:09 pm


Originally Posted by kd1000 (Post 22240788)
Most folks seem to keep detailed information and receipts .. for some reason I didn't see much value in keeping receipts once I deposit my GC's and the money is in my BB account.. I rely on by credit card statement and BB / bank account statement to tally in and out every week.

Are there any risks that I should be worried about by not having receipts ?

I haven't been concerned about it either until now. I started small several months ago, but now its getting to the point where keeping some records would make sense. I still don't do much MO/CA but it is increasing. I deal with a small credit union and might find another bank too if I increase the money side. For now, I have some room before I need to do that.

nmp0 Jan 28, 2014 6:17 pm


Originally Posted by kd1000 (Post 22240788)
Most folks seem to keep detailed information and receipts .. for some reason I didn't see much value in keeping receipts once I deposit my GC's and the money is in my BB account.. I rely on by credit card statement and BB / bank account statement to tally in and out every week.

Are there any risks that I should be worried about by not having receipts ?

Just be careful of the cards that let you load VR and then tell you your account is locked unless you fax in all your receipts and copies of cards to prove the money is yours (see Univision thread).

junkbin Jan 28, 2014 6:59 pm

CamScanner on my phone. Cards with receipts and filled out MO's. Track transaction via tags through mint.com but BB duplicates ALOT!!

KYBOSH Jan 28, 2014 11:16 pm

Some ppl track. Some ppl don't. It is time consuming but if you make it part of your routine and have the patience then it's not an inconvenience at all.

I read on another forum where some people found 10K in GCs they didn't know they had/lost.

Personally I can't afford an oversight like that.

MkMooney Jan 29, 2014 12:35 am

Quickbooks.

It takes some time to enter all the transactions, but it's awesome for up to the minute profit and loss, exactly how much you spent on any fees etc, and all your [supposed] balances, how much each company owes you for cashback.

If you don't know how to use quickbooks it's probably not worth it to start just for MS.

busymike Jan 29, 2014 7:03 am

I have been stepping up my game in this department lately, as my spend has grown in size and complexity (and, thankfully, profit).

I bought a NeatDesk scanner used on eBay for ~$240.00. It's not perfect but it gets the job done just fine for what I need it for. The software is basic, but it works. The wife has gotten sick of my mountains of spent gift cards sitting in piles around the house. Now, I feed them through the scanner and pitch them. I scan every card that comes through the house once it is finished. I also scan every receipt from my MS activities. Right now, I do the scanning once every two weeks on average. So I just sort the receipts by store, not clustered together in a money circle. I assume that an audit would be a headache no matter how well organized the receipts are, so I'll just deal with that if it were to ever come up.

In terms of keeping track of my transactions in a register, I wanted something relatively easy to enter, so I looked for an app for my ipad. For now, I've settled on an app called "Accounts2". It allows you to set up accounts and do D/C transactions with multiple accounts. I've been using it for about two weeks now. I probably reconcile the accounts every three days or so.

The problem I have is that I am very thorough in developing my strategies. So, before I begin, I know exactly how much profit I intend to derive. Keeping track of every detail seems silly when I can just do (My initial spend) * (My calculated margin) = My profit. Then, all I really need to track is my spend per month for a particular type of activity.

SeahawkRaptor Jan 29, 2014 10:08 am

I am anal about my finances in general so I use quicken. Even though it is a bloated piece of crap it is still the best way to keep good records and track how much you are actually making from these activities. I have separate accounts for each re-loadable card so when I buy a reload the CC transaction shows as a transfer to that card's account and an expense category for the associated fees. From this I can run a quick report to see how much I am really making. It helps that I am earning cash and not miles but if you were earning miles you would just create an entry where the cost of a ticket used was entered as cash back received.

I also use the mobile app to snap a picture of each receipt so the receipt is attached in quicken to the transaction should a problem arise.

On the physical side I have two expanding files where I store each type of churn source and receipt. Each month I discard the cards from the month before so this weekend I will empty the December folder and start filling it with February. That way I have the physical receipt and card for a minimum of 30 days which is more than enough time to find out if there is a problem.

Fico2Go Jan 29, 2014 10:20 am

Evernote.com is a great service that lets you search files and content of scanned documents. Could help.

zceuxbhjutf Jan 29, 2014 12:34 pm


Originally Posted by KYBOSH (Post 22243734)
I read on another forum where some people found 10K in GCs they didn't know they had/lost.

Personally I can't afford an oversight like that.

Yeah, most of the answers don't discuss how an oversight like that would be detected.

I have a spreadsheet that records events (=records in a database). A GC purchase would be two events: the 500 and the ~4.95. I code the 500 with the last 4 digits of the GC and I code the fee with "-1". A BB "debit" load would code the last 4 digits of the GC. With that system, it's trivial to use a pivot table to detect a code with only one record (which would mean a GC was bought but not drained).

mayday23 Jan 29, 2014 1:01 pm

I'm new to the game, but this is what im' using

[IMG]http://s1.postimg.cc/5hna5xfcb/MS_Plan.jpg[/IMG]

nuclfusion Jan 31, 2014 6:06 pm


Originally Posted by MkMooney (Post 22243943)
Quickbooks.

It takes some time to enter all the transactions, but it's awesome for up to the minute profit and loss, exactly how much you spent on any fees etc, and all your [supposed] balances, how much each company owes you for cashback.

If you don't know how to use quickbooks it's probably not worth it to start just for MS.

Just out of spite, I started using QB for my MSing :D

It actually works very well. I know I can accomplish the same with a good Excel spreadsheet, but this makes it easier to combine a few of my endeavors, such as my nasty Staples habit. Quick glance and I know what rebates are outstanding, how much, detailed recording, etc. Pretty slick. Thanks! ^

skibum85 Jan 31, 2014 6:17 pm

YNAB is great for tracking MS, and it's currently on sale via MacUpdate (yes, the software key works on windows)

I get nothing from this link:
https://deals.macupdate.com/deal/153...-need-a-budget

There's also a free 30 day trial.

kd1000 Jan 31, 2014 6:21 pm

I recently ran into accounting problem when I combined my regular spending with MS activities across several cards... had a hard time tallying the accounts ( since i conveniently forgot about some large purchases) ... looks like its about time to get more organized.

ericdabbs Jan 31, 2014 7:20 pm


Originally Posted by mayday23 (Post 22247374)
I'm new to the game, but this is what im' using

[IMG]http://s1.postimg.cc/5hna5xfcb/MS_Plan.jpg[/IMG]

Nice spreadsheet. I might take that template and do something similar.


All times are GMT -6. The time now is 5:26 pm.


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