Free Spreadsheet To Get Your Financial Life On One Page (2024)

written by Bob Lotich, CEPF® | Managing Money, Productivity, Simplify

Free Spreadsheet To Get Your Financial Life On One Page (1)When I was about 14 years old, my uncle suddenly and unexpectedly went home to be with the Lord.

He had meticulously taken care of the finances for their family and left my aunt on a very solid financial foundation.

Obviously, this didn’t take away the pain of him being gone, but his preparation eliminated additional stress that would have been present without it.

It’s one of those things we all prefer not to think about, but it is always better to be prepared. My aunt is still reaping from what my uncle sowed by having his things in order.

My FLOP

Being impacted by my uncle’s premature death and wanting to do everything I can do to help my wife, I decided to create a system for keeping things organized.

It has been a work in progress over the last few years, but has evolved into a very helpful tool. Simply put, it is a single file or location for all your financial account details. I call it a FLOP (Financial Life on One Page). FLOP sounds a little cooler than FLOOP, but not much 😉

Free Spreadsheet To Get Your Financial Life On One Page (2)

Click Here to Download Excel or Google Sheets template

In adding to it over the last few years it has come to have three main purposes. The first being that it is a:

1. Balance Sheet

One of the best pieces of advice I received when I started my journey to clean up my finances was to keep a balance sheet. I didn’t really understand why at the time, but I did it anyway. I have updated it twice a year since then and it was a great source of encouragement as I was fightingto get out of debt.

The reason it wassuch a source of encouragement is because a balance sheet not only takes into account the debt you have been paying off, but all of your good financial decisions as well. So increasing your savings, paying down debt and making wise purchases all will affect your balance sheet in a positive way.

Also, looking at the size of your debts or assets does not necessarily give an accurate report of your financial condition. To get a accurate picture of your financial situation, you need a balance sheet to calculate your net worth. It is very easy to do and is just a big subtraction problem:

Assets – Liabilities = Net Worth

As with most things, you are either moving forward or you are going backwards. If you are increasing your assets or minimizing debts, your net worth should be growing. If your net worth is getting smaller, then it is an indication that you should re-evaluate how you are spending your money. And even if your situation is not very encouraging, it will force you to see the financial truth so you can make adjustments as needed.

In case you missed it earlier, read how to create a balance sheet.

2. Organize all my login information

In this day in age, where you just about need to login to open your refrigerator, it can be difficult keeping track of all your login information.

After adding all your accounts in the balance sheet section above, you should have all your account information listed already and you can just add a column to add your login for that company. If you use various passwords you could list them in another column as well, but consider using a password hint rather than the actual password. I still come back to my FLOP at least once a week to figure out a login that I forgot about.

3. Financial roadmap for my wife

The third and most important reason for my FLOP is for my wife. In most families, one person manages the finances and has a better understanding of the overall financial picture. I am that person in my family. Are you that person in yours?

If so, would your spouse (or other beneficiaries) know where to find your financial information? Insurance policies, bank accounts, investment accounts, safe deposit boxes?

I know for my personal situation, I know a bit more about our financial details than my wife does. I use my FLOP to layout all of the pertinent details for my wife, if she ever needed them. It contains the name, phone number or web address of each institution, our account numbers for those institutions and any other pertinent info that may be needed.

I then burned the file to a CD and kept it in our safe. Every year or so I put a copy of the updated FLOP in there.

Losing a loved one is a terribly difficult process. Having a “roadmap” prepared in advance for your loved ones is a great way to help eliminate unnecessary stress.

Homework

  1. Click this link to Download the Excel or Google Sheets template.
  2. Spend some time filling it out.
  3. Discuss with your spouse where they can find it if they ever need it.
Free Spreadsheet To Get Your Financial Life On One Page (3)

About Bob Lotich, CEPF®

Bob Lotich, CEPF® is a Certified Educator in Personal Finance and has over 15+ years experience writing about Biblical personal finance. He is the award-winning author of Simple Money, Rich Life and has been named a top 20 social influencer in personal finance. Check out his on-demand Christian financial class for couples, small groups and churches called True Financial Freedom.

Free Spreadsheet To Get Your Financial Life On One Page (2024)

FAQs

How do I make a financial spreadsheet? ›

How to create a budget spreadsheet
  1. Choose a spreadsheet program or template.
  2. Create categories for income and expense items.
  3. Set your budget period (weekly, monthly, etc.).
  4. Enter your numbers and use simple formulas to streamline calculations.
  5. Consider visual aids and other features.

What is the 70/20/10 rule money? ›

The 70-20-10 budget formula divides your after-tax income into three buckets: 70% for living expenses, 20% for savings and debt, and 10% for additional savings and donations. By allocating your available income into these three distinct categories, you can better manage your money on a daily basis.

What is the 50/30/20 rule? ›

The 50-30-20 rule recommends putting 50% of your money toward needs, 30% toward wants, and 20% toward savings. The savings category also includes money you will need to realize your future goals.

How do I keep track of personal finances in Excel? ›

  1. Keeping up with your expenses doesn't have to be a tedious task. ...
  2. To enter your income, go to the "Income" sheet. ...
  3. To enter your expenses in your Excel budgeting template, go to the "Expenses" sheet. ...
  4. Let's add a budget column so that we can compare our actual expenses to our budget.
Nov 14, 2023

Does Excel have a financial statement template? ›

A: Yes. Excel has a range of financial templates, including income statements, cash flow statements, and balance sheets.

Does Excel have financial templates? ›

Free personal budgeting templates for managing your money

Easily customize any of these budget templates in Microsoft Excel—feel free to change the font, graphics, and more to make your budget feel more personal. Once you've added the finishing touches to your budget template, save it to your devices or print it out.

What is the 30 rule for money? ›

The idea is to divide your income into three categories, spending 50% on needs, 30% on wants, and 20% on savings. Learn more about the 50/30/20 budget rule and if it's right for you.

What's the 30 day rule with money? ›

With the 30 day savings rule, you defer all non-essential purchases and impulse buys for 30 days. Instead of spending your money on something you might not need, you're going to take 30 days to think about it. At the end of this 30 day period, if you still want to make that purchase, feel free to go for it.

What is the #1 rule of budgeting? ›

The 50/30/20 budget rule states that you should spend up to 50% of your after-tax income on needs and obligations that you must have or must do. The remaining half should be split between savings and debt repayment (20%) and everything else that you might want (30%).

Is $4000 a good savings? ›

Are you approaching 30? How much money do you have saved? According to CNN Money, someone between the ages of 25 and 30, who makes around $40,000 a year, should have at least $4,000 saved.

How to budget $5000 a month? ›

Consider an individual who takes home $5,000 a month. Applying the 50/30/20 rule would give them a monthly budget of: 50% for mandatory expenses = $2,500. 20% to savings and debt repayment = $1,000.

How much should a 30 year old have saved? ›

Fidelity suggests 1x your income

So the average 30-year-old should have $50,000 to $60,000 saved by Fidelity's standards. Assuming that your income stays at $50,000 over time, here are financial milestones by decade. These goals aren't set in stone. Other financial planners suggest slightly different targets.

What is the easiest way to track your finances? ›

Read on for five ideas to try.
  1. Open separate bank accounts. If you're a visual person, compartmentalizing your money may help you track your spending. ...
  2. Download an app. ...
  3. Label envelopes. ...
  4. Break out the pen and paper. ...
  5. Create a spreadsheet.

What is the best way to track personal finances? ›

One popular option is using a budgeting app. You can also use a spreadsheet or get to basics by using a pen and paper. Whatever method you choose, make sure it's something you'll stick to and is easily accessible.

What is a sinking fund account? ›

Sinking funds are money you set aside each month for specific savings goals. They allow you to save for infrequent expenses and plan for large expenses over time. Having sinking funds can help prevent you from withdrawing money from your emergency fund or going into debt to pay for things.

What is the 70/20/10 model with examples? ›

With the 70:20:10 model you learn 70% from on the job experience and from doing. You learn 20% from others in the way of observing, coaching and mentoring. 10% is down to formal training like courses, reading and online learning.

What is an example of a 70 20 10 budget? ›

70 20 10 Budget example

Let's say your income is $5,000 a month after taxes. By this rule, $3,500, 70% of your income, would be for all expenses. Then 20%, or $1,000, is for saving. Last, $500, or 10%, is for giving or debt payoff.

What is the 40 40 20 budget rule? ›

The 40/40/20 rule comes in during the saving phase of his wealth creation formula. Cardone says that from your gross income, 40% should be set aside for taxes, 40% should be saved, and you should live off of the remaining 20%.

Is 50/30/20 or 70/20/10 better? ›

The 70/20/10 Budget

This budget follows the same style as the 50/30/20, but the percentages are adjusted to better fit the average American's financial situation. “70/20/10 suggests a framework of 70% of your income on essentials and discretionary spending, 20% on savings and 10% on paying off your debt.

Top Articles
Latest Posts
Article information

Author: Horacio Brakus JD

Last Updated:

Views: 6431

Rating: 4 / 5 (71 voted)

Reviews: 86% of readers found this page helpful

Author information

Name: Horacio Brakus JD

Birthday: 1999-08-21

Address: Apt. 524 43384 Minnie Prairie, South Edda, MA 62804

Phone: +5931039998219

Job: Sales Strategist

Hobby: Sculling, Kitesurfing, Orienteering, Painting, Computer programming, Creative writing, Scuba diving

Introduction: My name is Horacio Brakus JD, I am a lively, splendid, jolly, vivacious, vast, cheerful, agreeable person who loves writing and wants to share my knowledge and understanding with you.