Tracking credit card spending
One of the issues that I struggled with when I first started using a credit card again was how to track my purchases. I use Quicken, and I have a number of categories for all of my expenses. I even had a category called “credit” that was leftover from my credit card mis-using days. However, I knew that I didn’t want to track things using a generic category like “credit”, because what would “credit” tell me about what I’d actually bought? Nothing. I wanted to be able to see exactly where I was spending my money at a glance, instead of having it fall into a black hole.
That’s when it hit me — I could just set up my credit card as an account in Quicken as well. This would allow me to track what I’m actually spending the money on. It also makes it easy to reconcile my credit card statement. So when I make a purchase using my credit card, I follow these steps:
1. Make purchase & place receipt in my planner while in the store.
2. Enter receipt into Quicken under the relevant credit card account as a debit.
3. List the payee & the actual category that the purchase falls into. (Such as Auto:Insurance, Dining, Personal:Haircuts, etc.)
4. Update the payment amount, which is listed as a deposit from my checking account.
5. My Quicken checking account is automatically updated with the new withdrawal amount.
6. Shred receipt if under $20 and not for a physical item that might need to be returned.
7. File receipt if it’s something I need to keep.

All of that red looks depressing, but I figure that’s actually a good thing. It keeps me aware of exactly how much will be automatically withdrawn from my checking account to pay my credit card — especially since I see the withdrawal coming up in my checking account as the payment date approaches. It feels like a real expense, which is a good thing since that’s exactly what it is. And, I can monitor how things stand with regard to my spending plan.
Related Websites- Are You Emotionally Invested In Your Credit Card? I was listening to the Dave Ramsey show on my way to work this morning, and Dave was talking to a caller on his show...
- Save Time, Money and Space in Over 80 Ways If you're looking for handy gadgets, tools and various items that can save you time, money or space (or all three!) this list of more...
- Simplify Your Financial Record Keeping With a Credit Card Despite the bad reputation credit cards have earned over the years, they really do offer numerous benefits when they're used correctly. With financial discipline, a...



September 5th, 2007 at 7:15 pm
Bravo! I think the current advice that most people will give you is to cut out credit card use altogether. While that would be great if it were doable, I don’t think it’s realistic. I use an almost identical system myself to keep the credit card monster under control.
September 8th, 2007 at 5:59 am
A great idea! I just wish Quicken/MS Money was more canadian-oriented.. I’ve had to resort to using Excel.
1. For tracking daily expenses – cash, credit cards, banks, whatever
2. For tracking credit card line items – each time my CC posts a line item, I put it in my Excel sheet, then I make a little column that matches up my payments to clear each line item.. E.g. Expense 1 = $50, Expense 2 = $50, one Payment of $100, I mark all 3 columns with “A”, so I can data filter and sort it to see that I paid, and the blank spots are what I haven’t cleared yet. I do this for all 3 credit cards (2 personal, 1 corporate)
3. Budget for the month, tied in to the expenses I track in #1
4. Loan amount and how much I paid towards it, tied to the expenses/budget in #1 and #3
PHEW..
It takes a while to really do all of it, but I find it keeps me busy (good), keeps my mind off shopping (v. v. v. good), and has really shown me where all of my money has been going (best).
September 17th, 2007 at 5:24 am
The most issues that I struggled with when I first started using a credit card again was how to track my purchases. I wanted to be able to see exactly where I was spending my money at a glance.