One of the very first things I did when I moved out for college (age 18) was to create a spreadsheet to track my tiny income and the few expenses I had at the time.
I’ve always loved a good spreadsheet!
At the time, it was an extremely simple spreadsheet that helped me visually see where my money was going and how much I had left at the end of each month.
It was NOT a budget — it didn’t limit how much I could spend on certain categories, it just tracked how much I actually spent, month after month, in various categories.
Now, almost 2 decades later, Dave and I still use the same basic idea of “tracking our saving and spending” — although I have beefed up the spreadsheet a bit over the years.
And I transferred it over to a Google Doc. 😉
It’s so simple, even a child could do it — I promise!
This finance tracking workbook is a great tool if you don’t want a budget.
Truthfully, we’ve never used a traditional “budget”.
I know — you’re shocked!
Budgets have always felt too restrictive for me, as Dave and I are natural savers and don’t need to worry much about overspending.
As long as I keep tabs on how much we’re spending in certain categories, I can easily pinpoint where we could cut back if we had to, or notice less-than-ideal spending trends.
If you’re not gung-ho about budgeting, I’d still encourage you to try tracking your finances for a few months or a year. It might be eye-opening.
I know it’s been fun for us to look back over the years and see how we’ve increased spending in some categories (ahem, groceries) while cutting back in others (travel, entertainment). And also, how our income, investments, and giving have morphed over the years.
It’s also a great first step for budgeting!
That said, if you’d like to create a budget but just don’t know where to start or how much to allocate for gas, groceries, restaurants, etc. my Finance Tracking Workbook is a great first step.
By tracking your finances for several months (better yet, do it for a whole year) you’ll quickly and easily be able to see how much you actually spend in a whole bunch of different categories.
This will allow you to create a much more realistic budget based on your current spending (not some random percentage suggested in a book or article).
For example, if you set an arbitrary grocery budget of $400 a month… you might be frustrated, wondering why you can’t ever stick to your budget. However, if you first track your spending and realize your “normal” grocery spending is closer to $800 a month, you can set a more realistic budget (maybe $700 a month) so you’ll have a better chance of succeeding and sticking with your budget!
Make sense?
Ok, let me show you the workbook!
When you open the workbook as a Google Doc, you’ll see a page of simple instructions, explaining how to save A COPY of the workbook to your own Google Drive (you won’t be able to edit the original).
At the bottom of the workbook, you’ll see 7 additional tabs (or worksheets):
- Income
- Debt (reduction)
- Bills
- Expenses
- Giving
- Investments
- Summary
Once you save a copy of this workbook to your own Google Drive, you’ll have the freedom to change the names of each tab, move the tabs around, add new tabs, or even completely delete the tabs I’ve created.
In fact, you will be able to edit EVERYTHING in this workbook to make it super functional for your specific needs!
Surprised?
You’re welcome. 😊
Within each tab/worksheet, I’ve broken the year into 12 months (see left column on photos below), and I’ve broken each month into 4 weeks (each row = one week), which makes it easy to track how much you’re making and spending on a weekly, monthly, or yearly basis.
OK, let’s dive in…
1. INCOME:
Whether you want to create a budget or not, it’s crucial to know how much income you generate on a monthly and yearly basis. Without this information, it’s almost impossible to create an accurate budget.
And even if your goal isn’t to create a budget, it’s still important to know your average monthly income.
Use the INCOME worksheet to track all your various forms of income in one place.
2. Debt Reduction:
If you don’t have any debt, give yourself a pat on the back and delete this worksheet!
If you do have debt, the DEBT REDUCTION worksheet is the place to record how much you’re putting toward each debt on a monthly and yearly basis.
You can also record any extra, principle-only payments you make.
Related Reading: How we paid off our mortgage 24 years early.
3. BILLS:
Use the BILLS worksheet to track recurring expenses (natural gas, electricity, trash, cell phone, Netflix, car insurance, etc. )
Feel free to adjust the column headers to whatever works for your own “bills”.
I personally put different bill amounts in different rows — this is because each row represents one week, so if a bill is due on the 3rd week of the month, I put it in the 3rd row for that month. Or if the bill is only quarterly, I post it every 3 months.
4. EXPENSES:
In my opinion, expenses are different than bills.
I use the EXPENSES worksheet to track variable expenses such as:
- groceries
- gasoline
- restaurants
- clothing
- vacations
- home renovations
Again, you can adjust the column headers to be anything you want them to be.
The EXPENSES worksheet is the one I use the most often… partially because we have lots of small daily and weekly expenses to enter, but also because I like being able to quickly know how much we’ve spent in any given month or in any specific category.
It’s eye-opening to see the exact amount I’ve spent on groceries or clothing in any particular month or year. The numbers could indicate that we’re stewarding our resources well, or they could be a red flag that we need to be more intentional in certain areas.
Related Reading: Stop Money Leaks by Tracking Your Expenses
5. GIVING:
Quickly and easily track all your charitable giving and donations in the GIVING worksheet.
I have this worksheet set up to track multiple different donations (again, you can change this for your needs) and it’s always sort of a game for me to see if we can surpass our percentage of giving each year (see “SUMMARY” page for the percentages).
This worksheet can be helpful as tax season rolls around too (all your charitable donations listed in one place).
And it’s a great way to monitor your spending during the holidays if you keep track of your “gifts” spending.
6. INVESTMENTS:
Even if you can only invest $10 a month, you should still do it!
I’m not an investment expert but we do pay someone to be our “investment expert” because we know how important it is for us to make wise choices with our money now.
I use this worksheet as a simple way to track our monthly investments.
Related Reading: How we automate our saving and investing.
Related Reading: How to start saving for retirement.
7. SUMMARY:
The SUMMARY worksheet is, well… the summary!
I have all the formulas set up so your totals from the previous six worksheets will automatically calculate and show up on the SUMMARY worksheet.
I love this at-a-glance snapshot of our finances at any given point during the year!
I’ve also added percentages to this sheet so you can instantly see what percentage of your income is going towards giving, bills, expenses, debt, and investments. This has been a fun stat for me to track over the years.
Note: The percentage values will show an error message until you actually record an income (see image below).
So that’s my simple system to track our savings and spending (say that 5 times fast!)
And it’s free, so you don’t have anything to lose by giving it a try. 🙂
When I enter information:
One of the most frequent questions I get about this workbook is:
How often / when do you enter your info on the spreadsheet?
In many ways, it has become somewhat of a daily thing for me — most evenings after the kids are in bed, I’ll open up the workbook and enter anything from that day.
It takes less than a minute.
Sometimes I go a few days if there’s not much to enter.
I have a spot right next to my computer where I save any receipts that need to be entered, and I have a “To Record” folder in Gmail where I save any digital receipts, income statements, or bills until they are recorded.
Again, it’s a super simple system, but it has worked for me from my poor college days through 2 moves, 4 children, and 12 years of running a business!
If you’re looking for an easy way to get a handle on your saving and spending, I hope my Finance Tracking Workbook will work for you. Please let me know if it does 🙂
Once you start tracking your income, expenses, bills, debt, etc., you’ll have a much better handle on your overall financial situation… which means that if/when you want to create a budget, you’ll be able to use “real data” and not just throw out arbitrary numbers.
And if you don’t want to take the next step of creating a budget, you can simply enjoy looking back over the years and comparing your saving and spending (or maybe I’m the only weird one who likes to do that!)
Open my FREE workbook, make a copy, save it to your own Google Docs or your computer, and start tracking your saving and spending!
Gloria says
I love this Finance Tracking Workbook but I am not computer savvy. Can someone tell me how I add more columns across and more lines down for each month. I am confused. Thank you
Andrea says
Hi Gloria, it might be easiest to “google” your question. Chances are a video tutorial will pop up and they’ll walk you through the process.
Betsy Gilberti says
Hi Andrea,
Thank you for sharing your file, so smart! I have been weirded out by the idea of using a percentage budget before seeing the footprint as single or a family, where you live, in a specific year, and then stressed by unrealistic guidelines or feeling like a failure for not meeting the demands. Your plan to view spending first has greater hope of a realistic approach to spending success.
Hoping to use this successfully in 2023. My concern is my need to continue being a dinosaur and using Excel. Other than dates, did you change anything else from the original Excel version if I would like to copy that one?
Andrea says
oh good — I’m thrilled my approach feels more realistic to you (that’s my goal!)
I did change a few things from the Excel version (like adding in the percentages) but it’s basically the same. If what you’re using currently works for you, then just keep using it!
Molly says
Thank you, thank you for sharing! Finance-wise, I think very similarly to you. I do have a question though..when entering bills, do you enter them in the month that you receive the bill, or do you enter them in the month you pay the bill? I receive some bills in the middle of the month, and then pay them at the beginning of the next month (before the due date). Does that make sense? Or do you pay them right on the due date? I’m scared to do this in case I forget:)
Andrea says
Hey Molly!
All our bills are set to auto-pay and charge directly to our credit card (which is then automatically deducted from our bank account every month)… so I don’t actually ever sit down to “pay the bills”. That said, when I get the payment receipt via email, I save it in my “to record” folder in Gmail and eventually enter it into my finance tracking spreadsheet in the week/month it was PAID.
Amanda says
Thanks for sharing this! I’m going to give it a whirl, starting this week! Wishing you and all the viewers a Happy New Year!
Andrea says
great! I’m thrilled for you (and your finances!)
Happy New Year, Amanda!
Rhonda says
Thanks Andrea. I’m going to give this a try. I’ve used your “Important Information Binder” template for a few years, and now I don’t even give it much thought (updating is so easy). I have my own simple “budget” spreadsheet, but I don’t really drill down with 100% real data. We’ll see if my arbitrary numbers match very close to the real numbers!
Andrea says
YES — once you have the documents created how you like them, it’s so quick and easy to update them. The hard part is just getting started!
Jamie Gottlieb says
My husband created a similar spreadsheet and fills it out for us. I am thankful he is so organized and tracks our spending. We have a yearly meeting in Jan. to look back and see what we need to adjust in terms of spending, investing, etc.
Andrea says
yay — so glad your hubby is so organized with your finances 🙂
Fran says
Wishing you and your family a very Merry Christmas and a wonderful New Year ❤️
Andrea says
Thanks so much Fran 🙂
Pat says
Love this!! What a great start!! The hardest part is to start and you made it sooo easy!! Thank you
Andrea says
The hardest part is ALWAYS getting started — I’m happy to make that just a bit easier for folks!
Kim Utz says
I have loved and used this tool for years now and have customized it for my needs. One thing I am wondering if it does that I just don’t know how to do is to capture the summary information by the month as well as the yearly running total? I hope that question makes sense!
Andrea says
yay — that’s fantastic news. I’m thrilled that you have personalized it and made it work for you and your family!
So… to do a summary by month, you’d need to set up a new worksheet and have 12 separate “summaries”. You could copy and paste the chart on my main “summary” worksheet, and then change the formula so it takes the total from the monthly rows instead of the total from the entire sheet.
Not exactly sure how to explain this — let me know if you have more questions (maybe just shoot me an email: andrea@andreadekker.com)
Nancy says
Thank you so much! Merry Christmas!
Andrea says
you’re very welcome, Nancy!
Calliope says
LOL…If we were twins, it is unlikely that we’d be so…similar.
I fill in an almost identical excel file since I was a university student.
And I,too, do it every night before bed.
Super helpful for me, not so much for my husband though!
Andrea says
hahaha — so funny!
Glad you have your own spreadsheet that’s working well for you! 🙂
Angel says
Just what I was looking for after an exhausting search for the right forms, thank you thank you thank you
Andrea says
yay! Glad to help!