A tour of the spreadsheets I use to organize my life

I like to use paper for planning my weekly spreads and checklists, but have made the switch from printables to spreadsheets over the years for planning many things including:

1. Budget income and expenses

I used paper for budgeting during my university days when I didn’t have many responsibilities. But once I reached proper ‘adulthood’ there were many more expenses and it just made more sense to track this is Excel when I can easily compare years, quickly do average calculations and forecast expenditure all within a few tabs of an Excel file, instead of dozens of sheets of paper and a calculator.

I like visually comparing goals versus actual via graphs, which is super quick and easy to do in Excel.

Read more: Why I switched from paper to excel spreadsheets for budgeting

monthly budget spreadsheet simple easy to use automatic formulas financial year calendar income expenses stocks investments debt savings tracker template

One of the spreadsheets I use to track my budget

I have another version of the spreadsheets that I use for tracking my business income and expenses which is very handy when it’s time to do my BAS and submit my taxes.

business income and expenses spreadsheet, etsy, online, profit, loss, accounting, tax time, shop financial, etsy seller tool, shop management, trend, reporting, tax reporting-min

Business income & expenses tracking spreadsheets

2. Meal planning

I’ve tried various methods of meal planning over the years including against each day on the weekly spread, using a meal planning sidebar sticker, sticky notes, and monthly calendars. But I’d move things around so often so I switched to spreadsheets. Now it’s much quicker to just cut and paste to move things around in seconds.

I use this one in Google Sheets on my iPad. That way I can take my iPad to the kitchen and update the spreadsheet on the go while I’m checking what I have on hand in the fridge / freezer / pantry and writing out my grocery list.

meal planning breakfast lunch dinner snacks family menu plan monthly editable customisable excel spreadsheet template google sheets mac

I keep a bank of my favorite recipes and their ingredients on a separate tab in the same spreadsheet.

our favorite recipes index excel spreadsheet organizer meal planning google sheets organisation grocery list food inventory

3. Travel planning

Planning holidays is my favorite thing to plan! I’m always thinking about the next trip I want to take. I like to plan really detailed itineraries. I use these spreadsheets I made which I did a full tour of (including video) in this post, in conjunction with an itinerary template I created in Microsoft Word (which can you read more about in this post).

In the spreadsheets I keep:

1. Handy info reference page
2. To do list
3. Budget
4. Attractions (and their cost)
5. Itinerary by Month
6. Itinerary by Week
7. Flight Comparison
8. Accommodation Comparison
9. Car Rental Comparison
10. Transfer comparison
11. Tour comparisons
12. Travel insurance
13. Spending Tracker
14. Before We Leave Checklist
15. Packing List
16. Outfit Planner

travel planning spreadsheets itinerary excel organizer color coded template

4. Master Task List

I shared more about how I use this spreadsheet in this post.

I mainly use the spreadsheet for blogging tasks and a to keep an organized to do list of all my ideas for future blog posts. However, I wanted the spreadsheet to be flexible so you could really use it for whatever you like depending on what categories you choose to.

You can download a copy of this spreadsheet for free (here). Existing blog subscribers can login to the free printables library to download here.

master task list excel organizer how to keep track of everything in your life using 1 simple spreadsheet can be used in google

5. Annual goals overview

I use this for my annual overview to keep track of holidays, goals for my shop and personal things I want to do (usually photo books which don’t sound like they’d be much work but I take so many photos they turn into a mammoth task).

Related post: How I plan and make travel photobooks (plus download my workflow printable)

I wanted to be able to quickly add new things and delete items if I change my mind. I was forever erasing things in my paper planner, or running out of room to add new things so switched to using a spreadsheet.

annual overview spreadsheet excel template printable color coding once a month tasks other tasks and projects goals routine habit custom all about planners how I plan a year in advance

6. Investment property

I sold my investment property last year (read more about how I did it without a real estate agent in this post), but used these spreadsheets for the nearly 7 years I owed it. Much easier than doing manual calculations on paper, and then I could just send a copy of the Excel file to my accountant at tax time.

Related post: How I planned and sold my investment property (without a real estate agent)

investment property spreadsheet planner tracker income expenses annual profit loss buying and selling costs rental income tracker

7. Home inventory

I created this spreadsheet when I was renewing my insurance so I could more accurately determine how much cover I needed, rather than looking at items and trying to remember how much I’d paid for them.

It now serves another purpose. When I recorded almost everything I owned (as I wasn’t going to do an inventory of every single book / pen / piece of clothing), it helped me realise (well, stopped trying to deny), that there was a bit of stuff I’d had for years but wasn’t using that I could probably sell on marketplace.

home inventory spreadsheet valuables home contents insurance calculator spreadsheet quick easy simple first home owner moving

Home Inventory spreadsheets

I also made renovation planning spreadsheets which I used to plan my parents bathroom renovation and my sister’s kitchen renovation. I also use it to do a feasibility check when house hunting, to see if the renovations I’d like to make are actually within my budget.

8. Share tracking spreadsheets

I made these spreadsheets back in 2018 when I started investing in the share market. These have evolved over the years and I now use them to keep track of:

1. Helpful resources
2. My investing rules & research questions
3. 10 year summary
4. Annual summary
5. My dividends tracker
6. Share holdings
7. Shares watch list
8. International shares watch list
9. Share trading tracker
10. Share dividends tracker
11. Share price tracker

share tracking spreadsheets excel google sheets numbers for mac stocks australia usa tax time dividends tracker dividend yield tools research analysis annual summary tax franking credits

A tour of the spreadsheets I use to keep track of my share portfolio 

Weekly Planning

A few years ago I did try weekly planning using an Excel spreadsheet, but found that I prefer to keep my weekly planning to paper. If it’s on my computer it’s buried amongst everything else I have open on the screen, especially all of the spreadsheets I just mentioned!

how to use microsoft excel to plan your week digital planning tools ideas inspiration tips color coding computer app

More Planning tips

Found this post helpful? Pin it!

a tour of the spreadsheets I use to organize my life money budget home travel planning graphs organizational spreadsheet to do list share tracking meals

You’ll Also Love

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.