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

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.

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).

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

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.

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.

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.

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.

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

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).

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

[IMG][/IMG]

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

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! ^

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.

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.

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