As featured in The Wall Street Journal, Money Magazine, and more!

Tracking My Cash Spending

by Flexo on August 21, 2006

in Software

Somehow, I haven’t been diligent enough in tracking my cash spending. According to my Quicken software, my cash account balance is about $550. That means I should have $550 in my wallet and coin jar. That is obviously not the case. My lowest cash balance was $50 in May 2005. Since then, the recorded balance has grown in spurts to its current amount. Here’s a screenshot from Quicken (click to enlarge).

cash-balance.jpg

In reality, I have $80 in my wallet plus $20 in coins at the most. I’ll need to adjust my account for the $450 variance over the past year, at $37.50 a month. I’m thinking of categorizing these adjustments as Food:Dining Out or Food:Convenience. These categories most likely contain transactions I’d be inclined to forget to record in the software, for example, while I’m out of town on weekends.

Feel free to share how you handle these discrepencies. They can really add up over time if left unadjusted.

VN:F [1.7.5_995]
Rating: 0.0/5 (0 votes cast)


About the Author

Flexo, the owner and creator of Consumerism Commentary, has been blogging and writing for the internet since 1995 and has been building online communities since 1991. Find out more about him and follow him on Twitter.

If you enjoyed this article, get the free RSS feed or get daily emails.

Join the free Consumerism Commentary newsletter. Enter your email address here to receive weekly emails with behind-the-scenes information, exclusive giveaways, and money tips.



Related Entries on Consumerism Commentary

{ 7 comments… read them below or add one }

1 brett August 21, 2006 at 12:15 pm

If the discrepancy is a “good guy” (i.e. the amounts I should have are less than what I actually have) I just throw it into additional capital gains on my savings accounts.

If the discrepancy is a “bad guy” then I apply the amount to wine expenditures. Wine is one of the few areas of our budget where we spend way more than what is necessary, so that’s what gets hit when an expected bad guy appears.

UN:F [1.7.5_995]
Rating: 0.0/5 (0 votes cast)

Reply to this comment

2 D August 21, 2006 at 12:35 pm

Ouch. I hate not knowing where my money went.

Suggestion, to fix this loss of info:

1. Acquire a manilla envelope or a small cash bag.
2. Keep in your vehicle.
3. Receive receipts for EVERYTHING – yes even that morning coffee.
4. Place receipts in envelope.
5. Once a month carry envelope into house and enter on Quicken.

Note – sometimes receipts are not available. What I do for my husband is add to the envelope a small note book. He quickley writes in any thing without a receipt. Which, he hates, so he always remembers to ask.

UN:F [1.7.5_995]
Rating: 0.0/5 (0 votes cast)

Reply to this comment

3 J.D. August 21, 2006 at 2:21 pm

Dude! I have this problem all the time. I’m a huge advocate of using cash instead of credit, but this is one of the very real drawbacks. It’s just not as easy to track cash, especially since it’s easy to walk away from a cash purchase without a receipt. During those periods that I try to go exclusively cash-based, I carry a pen and notecard with me to write down every transaction. Most of the time, though, I’ll come to the end of a week and wonder, “Where did that $15 go?” And I never do know. I need to have a special Quicken category for “unknown cash expenses”.

UN:F [1.7.5_995]
Rating: 0.0/5 (0 votes cast)

Reply to this comment

4 Tricia August 21, 2006 at 11:22 pm

When we have cash, there is always an overage in our cash account because of missed expenses. Almost always I stick them to dining or groceries. Food is usually the culprit. A pop here, a snack there. It all adds up.

I think your idea of spreading it out over the months is a great idea.

UN:F [1.7.5_995]
Rating: 0.0/5 (0 votes cast)

Reply to this comment

5 Flexo August 22, 2006 at 1:35 am

My project for the remainder of August and September will be to try to write down my cash expenses right away so I don’t forget to add them later. Thanks for all your suggestions. I’ll add expenses every month going back for the last year as Food:Convenience.

UA:F [1.7.5_995]
Rating: 0.0/5 (0 votes cast)

Reply to this comment

6 Madame X August 22, 2006 at 10:12 am

Do you use a PDA? I use Pocket Quicken on my Palm and synch it to desktop QUicken– entering the little cash transactions on my Palm throughout the day makes them so much easier to capture. And it’s a great way to look like a geek in public.

UN:F [1.7.5_995]
Rating: 0.0/5 (0 votes cast)

Reply to this comment

7 Id R August 31, 2006 at 3:50 pm

I have the same problem with Quicken. The cash amounts never seem to reconcile, but I don’t sweat it because it is usually small amounts.

Since almost of the cash in my possession comes from the ATM, I let Quicken sum up the amount of ATM withdrawals at the end of the month and then compare that to my Cash account which I use to record all of my cash expenditures. Then, every month I have a reversing entry to cancel out the ATM withdrawals, because withdrawing money from the ATM isn’t ’spending’ it, it’s more like withdrawing it. Just like paying a credit card bill isn’t really spending, it’s paying, since the spending happened some time before the payment

UN:F [1.7.5_995]
Rating: 0.0/5 (0 votes cast)

Reply to this comment

Leave a Comment

Note: By submitting your comment you are agreeing to these terms and conditions. If you attempt to post spam, including promotional linking to a company website, your comment will be deleted.

Previous post: Question of the Day #15

Next post: More Carnivals and Free Stuff