Free Spreadsheets to Analyze Your Past Money Trends

Here’s a curated selection of helpful spreadsheet templates from the Tiller Community to help you analyze your past spending trends.

This knowledge is essential for creating an effective budget. But even if you don’t want to make a budget, reviewing your past trends is essential for optimizing how you use your money.

Once you’ve reviewed your past finances, here are free templates to help you plan your budget.

Start with your Foundation Template

Tiller Foundation Template for Excel

Monthly Budget Sheet

Yearly Budget Sheet

Categories Sheet

Unified Transactions Sheet

The spreadsheets below were created to extend Tiller’s Foundation Template, which already includes sheets for tracking expenses, net worth, and monthly and yearly budgets.

Out of the box, the Foundation Template can help you analyze past trends and plan your financial future.

But, of course, part of the fun of managing your money with a spreadsheet is manipulating your data and viewing it from several perspectives.

Read: How to Get Your Foundation Template Ready for the New Year

Categorize your transactions

Your transaction categories are one of the most important parts of any system you use to track your money. 

They’re how you discover a subscription charge you didn’t expect. Or see that you’re overspending on groceries, but not saving enough for vacation. Or how you find an extra $100 you might put toward your credit card bill. 

Unless most of your transactions are categorized, none of the templates below will be helpful. If you have a lot of uncategorized transactions, AutoCat can quickly help you get organized.

Read: 4 Tips for Choosing Your Budget Categories (Plus Suggestions)

Compare past spending by category

See your actual past spending totals vs budgeted amounts

See what you spent on subscriptions and recurring expenses

Review changes to your net worth

Review changes to your net worth over the past months and years.

See your past balance trends