How to keep track of travel reimbursment

[RunHappy]

I've been a long time user of mint but have realized I have outgrown it.  It is good for keeping track of a general budget, but just doesn't fit my needs.  I want to keep a more detailed account of my taxes, 401k, as well as expenses.  Mint just can't do that for me.

I decided to create an Excel spreadsheet because at work I'm a big excel nerd and know it pretty well and I already own it.

My question is how to keep track of my paychecks and travel reimbursements? I get paid twice a month, so should I have a row for each or just combine it into one line item?

Also how should I keep track of my travel expenses?  I travel often and get reimbursed often. This amount varies.  It typically hits my bank account then I immediately pay off my credit card. I've read I should just ignore this amount but I don't feel right doing that because it does it my account and I have to account for paying the credit card somehow.

Thanks! 

[curler]

I'm assuming that your spreadsheet has some sort of budget categories (e.g. food, rent etc).  I'd just add another category for travel expenses.  You would also put your reimbursements in that category, and they should just net out to 0 once you get fully reimbursed. 

[RunHappy]

yes I have that category.  I also only use 1 credit card for all business expenses so that should be pretty easy to do. 

Not sure why that didn't occur to me!  Thanks!

[klystomane]

Not sure what your thoughts are on this, but I have a credit card dedicated to business travel.

[RunHappy]

Yes I have an AmEX rewards card where I only put business expenses on it. It makes it easier to separate it out from my regular life expenses.