Spreadsheet for Tracking and Growing Your Net Worth

I’ve written in the past about how to manage your money. This article is a quick-hitter; I want to share a spreadsheet I use to track the balance and growth of my accounts, which ultimately helps me track and grow my net worth.

Here are the steps:

Step 1: Copy and paste the spreadsheet to a new Google sheet or click on
File then Download as Microsoft Excel

Step 2: Customize the spreadsheet by adding the name of your accounts and updating any formulas as needed (so you get the correct sum of all of your account balances)

Step 3: Set a reminder to fill out the spreadsheet on the first of every month

Step 4: Calculate how you’ll divide up your income each month to determine how much you can contribute to savings and investments. This is the formula I’m currently using:

Income =

1/3 of Income is for Rent/Home/Utilities =

1/3 of income is your spending budget (food, play, travel) =

1/6 of income goes directly into savings =

1/6 of income goes directly into investments =

Step 5: Set up automatic deposits to contribute to your savings and investments monthly

Access the spreadsheet on my website here.

Originally published at https://www.kasiamanolas.com on June 2, 2020.