Skip to main content

Tracking Spending and Budgeting

In order to keep my finances on the up and up, and to make sure I can save what I need to save, I set a monthly budget and I adhere to it by tracking every penny I spend.  To do this, I developed an excel spreadsheet with multiple worksheets.  I have 7 tabs in my spreadsheet: Checking, Cash, Savings, Fidelity, TIAA-Cref, Budget, and Income.

At the start of the month, I outline my anticipated spending in the budget, and my anticipated income in the income tab.  Whenever possible I get very specific in my budget.  For instance, I don't know how much I will spend on groceries, so I estimate, but I do know that I spend $4.95 every Monday at the bakery for my loaf of bread.  So Bread has it's own budget line ($4.95 X # of Mondays in the month).

Then, I open this document every day to record every purchase made with my checking account, or with cash.  ATM transactions are debits in the "Checking" tab that align with credits in the "Cash" tab.  The tally in the cash tab should always be exactly what's in my wallet; the tally in the Checking tab should always be exactly what's in my account.

Savings refers to the emergency fund that I am building up in an ING account.  I make monthly deposits, so these show up as debits in my checking account and credits in my savings account (interest being the other credit).  TIAA-cref and Fidelity refer to my 403B accounts.  The deposits to these happen pre-tax and include employer contributions, so the credits in these accounts do not refer to debits from checking.  For these accounts, there is just one monthly update, but having the tabs reminds me to keep track of my short-term and long-term savings. 

I created the different sheets using the accounts and budgets ledgers in the excel gallery (trying to create my own from scratch didn't go well).  For each item (checking, cash, etc.) just look for a ledger that has the details you want to record.  I use fairly simple sheets for savings and retirement, but detailed sheets for checking and cash. 

Also, choose your categories in the budget carefully and make sure the categories you use in checking and cash align with the appropriate budget items.  Each budget item should have a different category so your spending gets aligned correctly. Bread is 'bread' and groceries are 'groceries', so that my purchases from Metropolitan bakery are categorized as 'bread' and my purchases from Farm Fresh Express are categorized as 'Groceries.'  This allows you to then filter your spending by category to see how much you've spent in that particular category (don't forget to examine checking and cash). 

You can email me at drdustinkidd@gmail.com if you'd like a blank template version of this workbook.  It is a pain in the ass, but it makes a big difference with getting a handle on your spending. 




Comments

Popular posts from this blog

Teaching Tools

I've added two new teaching tools to my regime this semester. 1. Skitch . Skitch is both a desktop application that lets you capture images easily, and a website that allows for easy image sharing . I'll use it this semester to capture images that we can discuss in class, and to take pictures of the blackboard at the end of class (to capture interesting brainstorming sessions). I can upload the pic via email, straight from my phone, and the students will have access right away. I can use the image capture software to circle parts of the reading, charts, graphs, etc. and bring those to the surface for discussion. 2. Slideshare . This program allows you to upload PowerPoint presentations to the Web. I uploaded all of my slides for the semester to one page where they can be accessed from any computer. It allows me to worry less about carrying the slides on a USB drive or having to upload them to the course Blackboard page, which sometimes doesn't open. It also makes fo...

Fashion Favorites

I'm in a list-making mood. Here's my current fashion favorites. T-Shirts: Obey . I buy them at South Moon Under . I'm eying this one now. For white T-shirts, I like Calvin Klein and for plain color t-shirts, I like American Apparel . Jeans: I think Diesels are the best. I also like Joe's Jeans . Dress Shirts: My best ones are TailorByrd . They have contrasting collars and cuffs. Shoes: Just bought a pair of Via Spiga ($50 at Daffys). But I prefer Unlisted , by Kenneth Cole. Sneakers: Really like Timberlands . Socks: American Apparel makes great socks. The black 3-stripe calf length can function as dress sock or athletic socks, and they don't leave black fuzz on your feet like most dress socks. Watches: Love my Nixon . Hoodies: I like both Obey and American Apparel . Wallets: Gama-GO Short-sleeve button-downs: I have several of these, but the only one that keeps looking crisp is by Banana Republic . Underwear: Diesel and 2Xist . Rainjacket...

Board Recruitment Resources in Philadelphia and Beyond

http://dustinkidd.blogspot.com 1. Business on Board : A function of the Arts and Business Council. Provides training to prospective board members and connects them with local arts organizations. 2. Philadelphia's Young Nonprofit Leaders : Provides training and resources for staff and volunteers, including board members, for local nonprofits. "Young" is broadly defined. 3. Blue Avocado : An online magazine about non-profit boards. 4. Board Cafe Archives : The predecessor to Blue Avocado. Has a nice section on recruitment and diversity. Here's a good one . 5. BoardnetUSA : A board recruitment and placement website. Like Monster.com for boards. 6. VolunteerMatch : Similar function to BoardNet. 7. Bridgestar : Connects corporate employees to nonprofit service. 8. Eide Bailley : Non-profit toolbox. Includes a nice short article about board service. 9. BoardSource : Recruitment and Orientation resources. More resources throughout the site. 10. Wharton Nonprofit Board...