While Mrs. AR and I don’t typically keep a firm budget, every so often I like to keep tabs on our expenses and see where there is room for improvement.
This tool provides an easy way to do that, as well as a useful way to forecast expenses for the year as well.
We use Personal Capital to tie all the data together, and from there I enter it all down into this spreadsheet.
My spreadsheet works with both Google Sheets and Microsoft Excel. It is a simple and easy to use template.
How to Use The Expense Tracker Template
First up, go ahead and download the Simple Yearly Budget & Expense Tracker Template
- For both Google Sheets and Microsoft Excel users, click here to “make a copy” of the Simple Yearly Budget & Expense Tracker
- For Excel users only, you will then want to click “File” then –> “Download” –> “Microsoft Excel (.xlsx)”
Ok, now that you’ve got the file, you need to go ahead and start to fill it out.
- Enter the Budget Year, and the Data Entry Date
- Fill out your Yearly Budget (Column C)
- If you don’t currently have a budget, it will be useful to enter in last year’s expense information as a starting point.
- Next Up, Fill out the Year-to-Date Expense Data (Column D)
- Log in to Personal Capital (or your CC)
- Pull up a report for Year-to-Date Expenses
- Search and log each expense category or major expense
- Projected Expenses (Column E) will auto-populate as you do so
And that’s that. You’ll be able to see any expenses that are projected to be over budget in red, and anything under budget in green:
As you can see by my made up numbers, we are under-budget. Whoop!
Staying on-budget is harder than ever these days.
I know that I’ve gone over budget myself this year, and to stay on track, my wife and I look over which areas we might be able to cut back on, subscriptions we may want to cancel, or service providers that might make sense switching.
My recommendation: indulge in the things you love, and cut out the rest!
I hope this helps you, and please let me know if you have any questions at all!
Hey! Can you recommend any iphone app with the similar functionality? Thank you.
I personally use and recommend Personal Capital. It makes it easy to sort through my budget and view expenses by category. Can’t go wrong with using it and my manual budget tracker!