After I uploaded my quick n easy excel budget spreadsheet yesterday, Consumerist reader DangerP sent over his to share with everyone. His is pretty cool! In addition to the regular cash flow and recurring billing item tracking, it also has a built-in worksheet for doing a debt snowball, tracking long-term debts, and an overall budget dashboard. Update: new excel file replaced to fix formula issues some people where having.
Back by popular demand after the file on our server got messed up, it’s Consumerist’s easy excel budget spreadsheet! It lets you track your cash flow and expenses, and plan for upcoming purchases and bills. Use it properly and you’ll never overdraft again.
It’s hard to beat an excel spreadsheet for quickly shifting between a granular and top-level view of your personal finance situation. Here’s reader Lauren’s account balance spreadsheet she made to keep track of her expenditures, past, present, and future, and itemize her budget.
One unpleasant surprise about switching to USAA from Washington Mutual is that I could no longer download all my transactions in .CSV format. When I was with WaMu, this made it very easy to import all my banking into my tricked out Excel sheet I use to manage my finances. USAA only lets you download in Quicken or Microsoft Money’s proprietary formats. Cutting and pasting the transactions as they appear on the website, even in Print mode, still is less than perfect. What I found out though is you can use a personal finance management site like Mint or Wesabe to do most of the grunt work for you. UPDATE: Reader Stephen pointed out there is a handy link at the bottom of the USAA page that lets you export as .CSV. I didn’t see this link because I was looking at the “download fund activity link,” which doesn’t have a .CSV option.
Do you have so many credit cards that you could sew a pair of pants from them? Confused as how to get rid of them? Try this handy Excel spreadsheet to generate a custom strategy for becoming debt-free.
How to calculate compound growth in Excel using the RATE function. [AllFinancialMatters]
Like a crime scene investigator catching a serial killer, you keep meticulous records of every call you make to customer service. And then you lose the slips of paper (maybe you even scribbled on the backs of receipts, hm?). Instead of tossing your gumshoes, screw on your green plastic visor and bust out the Excel.