Categorizing Credit Card Expenses

Jim Haas

I use my credit card for a wide variety of expenses: groceries, gasoline, mobile phone, clothing, etc. Currently, I classify all credit card expenses in a "Credit Card Misc" category, because I am too lazy to go thru a 60-80 line credit card statement every month and classify each line into a category based on the merchant. Naturally, this seriously compromises my ability to analyze my expenses.

I have attempted to address this by downloading the monthly CSV from the card issuer and running it thru an Excel macro I wrote to assign a category based on merchant name - crude at best, given the inconsistency of merchant names, even within a "chain store".

I understand that this is at least as much a card issuer issue as it is a Quicken issue, but I am hoping the community of Quicken users might have some ideas. (The card-issuer side was not much help...).

Thanks.

volvogirl

Don't know how Mac Quicken works but for credit cards I like to tell people.....

The proper way is to set up a credit card ACCOUNT and enter the charges into it when the purchase is made and assigning it to a category. Then when you pay the bill you TRANSFER the payment from your checking account to the credit card account. Then when you download the payment from the bank you match it to the one you already entered.

When you enter the payment in your checking account you put the credit card account name in for the category using square brackets around the name to indicate it is a transfer...like this… [credit card] or newer versions have a Transfer column.

I used to do it the wrong way for years!  Then I wised up and now enter them properly. I would split my credit card payment into all the categories on one transaction in my checking account. And since I always pay more than the bill I would need to figure the difference and put it to another category.  But then I needed to have them entered on the date the charges actually happened. So I finally set up a credit card account. It makes it much easier to enter and balance!