When to record Credit Card charges on Expense spreadsheet

[Amethyst]

I'll bet this has been discussed before, but darned if I could find a thread. Then again, I'm too lazy to spend more than 10 minutes searching

My new year's resolution is to be more OCD about our finances. To that end, I'm setting up spreadsheets for monthly expenses and investments.

We use a credit card for all discretionary expenses--everything, that is, except taxes and payroll deductions. What would make more sense--record items actually purchased in December, under December on the spreadsheet, or record them under January, since that's when I pay the CC bill? Or is it a wash?

Thanks,

Amethyst

[ziggy29]

For my budgeting, the money is gone the moment I whip out the plastic, so if I buy something on December 21 which is paid off on January 16, the expense is recorded for December 21.

You can do it any way you want, but I prefer this method because it forces me to treat the money as spent as soon as I make the charge.

[REWahoo]

I'm with Ziggy on this one. All charges are recorded in the month they are incurred, not when I pay off the monthly CC balance.

[Notmuchlonger]

Yeah if its charged in Dec. I put it in Dec.

[bbbamI]

Ditto..charge in Dec, post in Dec...

[Amethyst]

OK...it's unanimous! Record the expense at the time of purchase. Thanks, folks. A.

[TromboneAl]

Here's another reason to post them when the charges are made: If you use Quicken or another app to track your expenses, that's the way the program will do it.

[OAG]

It is also the way the IRS figures it too. Which makes it a good idea (if it helps you with taxes) to prepay medical/dental expenses (or others) - like a kids braces - puts the expense into the year you charge it.

[retire@40]

Quote:

Originally Posted by OAG It is also the way the IRS figures it too. Which makes it a good idea (if it helps you with taxes) to prepay medical/dental expenses (or others) - like a kids braces - puts the expense into the year you charge it.

With a couple of exceptions, prepaid medical expenses are not deductible.

The expense has to be incurred in the same year for the payment to be deductible that year.

[Alan]

Quote:

Originally Posted by Amethyst OK...it's unanimous! Record the expense at the time of purchase. Thanks, folks. A.

To be OCD you need to do it this way.

I'm lazy these days - I record the whole of the cc monthly statement for the approx. month it applies to. I just got my Jan statement but I record against Dec since all but 4 of the charges happened in dec.

[OAG]

Quote:

Originally Posted by retire@40 With a couple of exceptions, prepaid medical expenses are not deductible. The expense has to be incurred in the same year for the payment to be deductible that year.

Sorry I was not clear enough. Example (I was alluding to) is a dental bill for $XX,XXX to get the braces etc, in for a child set up on an installment plan where you pay the dentist by the month - the total cost is what it is and you decide to pay it off (early) in December via a CC.

[JOHNNIE36]

You guys slay me. What's with all the spread sheets and Quicken and when do you record something? What's the difference if you purchase it in December and record it in January or vice-versa. I don't get what all the fuss is over. It tells me you don't have anything better to do than make out spreadsheets. I like to operate on the principal of "decide on purchase-pay by plastic-receive bill-pay bill". You remind me of a golf buddy that records every shot, what club he used, how many putts, how many chips, up and downs and greens in regulation. He records all that info in his computer. My question to him is "now what are you going to do about it?"
Not much!!

[OAG]

Quote:

Originally Posted by JOHNNIE36 You guys slay me. What's with all the spread sheets and Quicken and when do you record something? What's the difference if you purchase it in December and record it in January or vice-versa. I don't get what all the fuss is over. It tells me you don't have anything better to do than make out spreadsheets. I like to operate on the principal of "decide on purchase-pay by plastic-receive bill-pay bill". You remind me of a golf buddy that records every shot, what club he used, how many putts, how many chips, up and downs and greens in regulation. He records all that info in his computer. My question to him is "now what are you going to do about it?" Not much!!

Tax implications? We RE that is why we have to do this sort of stuff - lots of time on our hands.

[SecondCor521]

Quote:

Originally Posted by JOHNNIE36 You guys slay me. What's with all the spread sheets and Quicken and when do you record something? What's the difference if you purchase it in December and record it in January or vice-versa. I don't get what all the fuss is over. It tells me you don't have anything better to do than make out spreadsheets. I like to operate on the principal of "decide on purchase-pay by plastic-receive bill-pay bill". You remind me of a golf buddy that records every shot, what club he used, how many putts, how many chips, up and downs and greens in regulation. He records all that info in his computer. My question to him is "now what are you going to do about it?" Not much!!

I agree with you -- if you're not going to perform any analysis on the data, then it's a waste of time, whether it's finances or golf.

Personally, I do record all my transactions in Quicken and Excel. For one thing, it helps me keep track of 43 accounts. About half of those accounts are directly or indirectly involved in my AOR, which earned me $11,281.06 in the last nine months of 2008. Examining my expenditure records has also helped lead to a YOY reduction in my expenditures of $5,892.96.

Perhaps those sums are not much to you. To me they matter a great deal. To each his own.

2Cor521

P.S. -- I also play golf, but I don't keep track of all the stats your friend does -- usually just the standard strokes per hole and strokes per round, and often the number of putts and number of penalty strokes.

E.T.A. -- To OAG's point above, I firmly believe that tracking finances in an OCD way can also lead to FIRE far earlier than otherwise possible. I'm on track to retire by age 47. (46.96 actually.)

[Notmuchlonger]

I track spending. It takes me about 5 hrs a year. 1 hr per quarter plus a little extra. I know where every dollar went. So yes, I wasted 5 hrs per year. Those who don't waste 5hrs per year tracking expenses are so so so much further ahead in life


You see where this leads don't you.... yeah I know you do

[Khan]

Quote:

Originally Posted by Notmuchlonger I track spending. It takes me about 5 hrs a year. 1 hr per quarter plus a little extra. I know where every dollar went. So yes, I wasted 5 hrs per year. Those who don't waste 5hrs per year tracking expenses are so so so much further ahead in life You see where this leads don't you.... yeah I know you do

OCD on expenses leads to FIRE.

[Alan]

Quote:

Originally Posted by Khan OCD on expenses leads to FIRE.

Although I no longer itemize like I used to I do believe this to be true and tracked everything. When you put things into categories you can really see where your money goes and zero in onto places to save.

DW and I were just discussing this an hour ago, sitting in a coffee shop having a drink after shopping. We know how much we spend each year and should be just fine in ER but if things went t*ts up such as happened to lots of folks recently, then we are very comfortable that we can cut back a lot and still be very comfortable because we know exactly where the money is going plus we've been there before - not like some folks who have only known wealth and suddenly have to make huge cuts in their living expenses. (e.g. how do we tell the maid that we can't keep her on)

[mews]

Quote:

Originally Posted by Khan OCD on expenses leads to FIRE.

Or, perhaps to staying FIREd, if the trigger was already pulled.

I found that being OCD last year a) really slowed my spending (Do I really want to record 21.92 spent on a weird purple whatsit? Maybe not! ) and let me do some mid-year and year-end analysis, to reroute money from low-priority 'wants' to a better class of frivolity.

The sushi is not negotiable.

ta,
mews

[REWahoo]

Quote:

Originally Posted by JOHNNIE36 You guys slay me. What's with all the spread sheets and Quicken and when do you record something? What's the difference if you purchase it in December and record it in January or vice-versa. I don't get what all the fuss is over. It tells me you don't have anything better to do than make out spreadsheets. I like to operate on the principal of "decide on purchase-pay by plastic-receive bill-pay bill". You remind me of a golf buddy that records every shot, what club he used, how many putts, how many chips, up and downs and greens in regulation. He records all that info in his computer. My question to him is "now what are you going to do about it?" Not much!!

Johnnie, one of the things you'll discover if you hang around this forum for a while is none of us are exactly alike (thank goodness) and "different strokes for different folks" seems to make the world go round. You may also discover that replying to a straightforward question with a response that may be interpreted by some as insulting could earn you a similar response to one of your future posts. That's something we don't want to encourage since it leads to nasty little spats and too much work for the mods.

[dex]

I record it when paid - taken out of my checking account.
This allows me to figure out my cash needs for the month and transfer it from savings to checking.