Welcome to the Consumerist Archives

Thanks for visiting Consumerist.com. As of October 2017, Consumerist is no longer producing new content, but feel free to browse through our archives. Here you can find 12 years worth of articles on everything from how to avoid dodgy scams to writing an effective complaint letter. Check out some of our greatest hits below, explore the categories listed on the left-hand side of the page, or head to CR.org for ratings, reviews, and consumer news.

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.

1. Scroll to the current month.
2. Enter your current balance in the “Starting Balance” box at the top left.
3. Enter your credits and debits on the appropriate dates they will hit your account. Use positive numbers for money getting added credits, and negative numbers for when it’s getting taken away.
4. The green “Total” will change to reflect your total overall balance.

Use it as is, compare it to your own, or mod to fit your own needs.

Lauren says it’s “quite nifty,” and also uses it as a calendar.

Here’s the excel code for the totaler for those who like to look under the hood: