• Skip to main content
  • Skip to footer

SeedTime

SeedTime Money (Christian Personal Finance)

  • Home
  • About
  • Podcast
  • The Book
  • The Course
    • True Financial Freedom
    • The Real Money Method
    • The 10x Investing Course
  • Newsletter
    • The Tools We Use
    • 25 Ways to Save Money
    • 10 Budgeting Spreadsheets
    • How We Travel For Free
    • 5 Bible Verses You Should Know
    • 35 Ways To Make Money
    • Beginner Investing
    • 7 Passive Income Ideas
    • Is Tithing for today?
    • 31 Legit Home Biz Ideas
  • Churches

Free Spreadsheet To Get Your Financial Life On One Page

January 20, 2020 By Bob Lotich, CEPF®

2888 shares
  • Facebook146
  • Email

Financial Life on One PageWhen 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 😉

Financial_Life_on_One_Page_(FLOP)

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 fighting to get out of debt.

The reason it was such 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.

Related Posts

  • Free Debt Snowball Spreadsheet
  • How Cars Affect your Financial Freedom
  • 4 Financial Lessons from Solomon (The Richest Man Ever)
  • 7 FREE Printable Budgeting Worksheets
2888 shares
  • Facebook146
  • Email

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 and is the best-selling author of Simple Money, Rich Life and has been named a top 20 social influencer in personal finance. His writing has been featured on Forbes, The Huffington Post, Yahoo Finance, CBN, Crosswalk, Patheos and others. He has been a full-time writer since 2008 and loves uncovering financial wisdom in the Bible as well as discovering the best tools and strategies to help you put more money in your pocket.

Reader Interactions

Comments

  1. robshirley says

    July 16, 2008 at 12:01 pm

    hey bob, great info.. i’m excited to learn tons from you informative and fun website.

  2. bob says

    July 16, 2008 at 12:06 pm

    @rob
    thanks!! glad you could stop by!

  3. Chandler says

    July 16, 2008 at 4:38 pm

    How can you talk about premature death and making sure your spouse is taken care of and not mention life insurance?

    What if your FLOP says : Your Broke ! Just something to consider when doing your financial planning.

  4. bob says

    July 16, 2008 at 9:20 pm

    @Chandler
    you must be an agent 😉 but, seriously though, I agree it should be something to think about when creating something like this. I mean why not, if the whole point is to make your spouse’s life easier if you are gone, isn’t life insurance the first thing that comes to mind?
    Good point and thanks for sharing.

  5. cory says

    July 17, 2008 at 6:44 am

    Bob, could you post the FLOP as a PDF? I don’t have excel, and my spreadsheet program won’t open it. 🙁

  6. Bjorn says

    July 17, 2008 at 1:22 pm

    Bob,
    Thank you for your FLOP template. I had been setting up something very similar and will now ‘piggy-back’ on what you have come up with.

    You have been a great help.

  7. Bjorn says

    July 17, 2008 at 1:24 pm

    Cory,

    I believe you can download a free-version of Excel that allows you to load spreadsheets. Maybe start with http://www.microsoft.com or search ‘free excel reader.’

    Hope that helps you.

  8. bob says

    July 17, 2008 at 1:51 pm

    cory,
    the easiest way would be to go to docs.google.com and import the file, that way you can still use it as a spreadsheet. It doesn’t import perfectly, but it works enough to get the job done…

    Unless the PDF format has advanced in a way that I am not aware of I don’t think you will be able to use it – view only I assume.

  9. NtJS says

    July 22, 2008 at 11:27 am

    Love the concept. I’m eager to give this a try!

  10. bob says

    July 22, 2008 at 1:08 pm

    @NTJS
    let me know how you like it!!

  11. Mark says

    January 27, 2010 at 4:58 pm

    When you calculate your assets, a wedding ring shouldn’t be counted unless you are willing to sell it. Few people would.

  12. Shahid says

    June 2, 2010 at 12:20 pm

    I agree. Great article and very informative. Thank you very much for the template.

  13. Jensons says

    June 7, 2010 at 1:38 pm

    Loved the idea of your FLOP. I think finances is one of the strongest ways Christians fall flat on their face today. We are to have a shining testimony in every area of life and this has been very encouraging. Thank you for sharing such a persaonal part of your family to help teach others.

  14. Cathy says

    September 8, 2010 at 11:54 pm

    This is really good. It took my Dad more than a year to get access to late Mum’s account. Such information would have made life easier for himhis would

  15. Understanding says

    December 20, 2010 at 2:51 pm

    My spouse and I seem to have a different view of reviewing finances together. My spouse finds it distrusting or is offended. Now bills are paid by spouse and reviewed by the other spouse for logging purposes. No discussions really, just posting amounts for the month. I don’t see how accountability is shared here. There seems to be a your money, my money mentality with little acknowledgement to this gap. I tend to feel that something is not fully disclosed.

  16. Tere says

    August 29, 2011 at 8:24 pm

    Hi, I downloaded your template, but when I tried to open it, it locked up my computer for a while until I trashed the download. Is this using an old version of excel? Do you have an updated template? Thanks.

  17. KC @ PsychoMoney says

    January 17, 2012 at 12:24 pm

    Great advice. I do need to clean up my passwords. If something did happen to me right now I am sure it would be more than a mess for the next person to clean up.

  18. Jonathan K says

    January 17, 2012 at 1:42 pm

    This is good advice. I started using a FLOP after reading an article by Bob last year. We keep our Daily Expenses Ledger, Monthly Budget, Savings Account Balances, Gift Card balances, and login information in it.

    We started going over the finances about once a month, talking things through, and our finances have gone from good to great! We’ve also found that having an allotted amount (Cash) for each spouse as an allowance has resolved a majority of the conflicts we had over money. I can go watch movies at the theater or grab a bite to eat at work and she can shop for clothes as long as it is within the allowance budget. And we don’t have to know the details of each other’s allowance spending either.

    Any purchase over $50 we do discuss together. That is great advice.

  19. Gerard Ordoyne says

    February 4, 2012 at 2:35 pm

    A great service you are doing Bob, I’m excited to learn more.

  20. David Washington says

    November 13, 2012 at 10:05 am

    Great Informaiton that everyone needs and they did not teach in the early stages of life. Death is never easy for those that live on. I do have a word document from my mothers friend that will help anyone be more ready after a tragedy happens. What to do with documents, where to file for Benefits, how many death certificates do you need etc. If anyone is interexted please email me or let me know where I can post or I can send in to you and you can post if you think it is worth the time.

    • Angela says

      November 24, 2020 at 11:34 am

      David, I know your comment is super old. The way I look at it, you’ve had lots of time to perfect it ! LOL. I would definitely be interested in you posting this information or a link to where you have it available online.

  21. Rosalie Banal says

    December 29, 2012 at 12:29 am

    This is so awesome…thank you for sharing. I just finished mine 🙂 More power and God bless!

  22. sarah from Ghana says

    June 27, 2013 at 3:39 am

    Hey Bob,

    I am truly blessed to be receiving such counsel and advice from you. It very beneficial at this stage of my life. Appreciated.

  23. Luz says

    July 10, 2013 at 9:47 am

    Great advise! I love all the help.

  24. Michael Kampff says

    September 30, 2013 at 6:25 pm

    Great advice! I did something similar about 18 months ago, and it’s been an eye opening experience. The ability to see how net worth is trending is interesting, but also holds us accountable to the choices we’re making and has more tangible value than a number on a bank / credit statement. I update my info on a quarterly basis.

  25. Sandra at Thistle Cove Farm says

    January 15, 2014 at 11:57 am

    This is good information although, I’d never sell jewelry unless absolutely necessary. There’s too much sentimental value attached. I’m in process of writing a book to prepare folks for the possibility/eventuality of a spouse dying. Dave and I were going to sit down on Monday morning, me with a 3-ring notebook, and he was going to prepare me for when he wouldn’t be around. He had cancer and was given 1 to 1.5 years; he dropped dead of a heart attack on Saturday morning. There is SO much each of us can do to make it easier on the one left behind.

  26. Kerry says

    January 15, 2014 at 7:08 pm

    I’m going to suggest FLASSH. Financial Life in A Snap SHot. Sounds a little cooler than FLOP to me. Feel free to use it if you like.

    • Bob says

      January 16, 2014 at 10:35 am

      Good suggestion Kerry! Definitely cooler 😉

  27. Camille says

    February 27, 2014 at 10:03 pm

    Thank you for allowing other people to glean from your experience. I appreciate how you have written instructions and comments in layman’s terms.

  28. Donovan says

    April 19, 2014 at 5:05 pm

    Hey Bob. Valuable information. I’m grateful especially that I have had a chance to learn this even before getting married. Thanks

  29. Travis Peters says

    May 19, 2014 at 5:09 am

    Great idea! I totally need to make one of these for my wife and I. I’ve had the thought several times, if I was on an extended trip or for some reason couldn’t get to our finances, how would my wife know what to do? Thanks for the great tip. Pretty cool that this article was written several years ago and is still blessing people. Great website, thanks.

  30. B says

    January 9, 2015 at 11:33 pm

    Great spreadsheet, man! But remember the rule: If it’s not generating money, it’s not an asset.
    If you have paid for that house and cars in cash, or generate rent that covers the loan you have on them and other maintenance fees, they are an asset, else you cannot count them as an asset. Do not listen to bankers that tell you your house is your greatest asset, when in fact you’re working all the time to gain money to cover for them.

  31. Sonia says

    January 11, 2015 at 3:56 pm

    I came across your web sight when I googled “how to create a budget for home”.
    I filled out the FLOP document.

    Do you have a budget template?

    • Bob says

      January 12, 2015 at 9:30 am

      Here are a bunch you can check out – https://seedtime.com/10-free-household-budget-spreadsheets/

  32. frank says

    May 21, 2016 at 9:45 pm

    Thanks, Bob! I also once or twice thought about it. Just like in your family, I’m keeping an eye on all the finances (my wife doesn’t like figures). So, I thought ‘what will happen if I’m gone, and my wife doesn’t know our whole value’! Thanks again!

    • Lauren (SeedTime Editor) says

      May 23, 2016 at 10:15 am

      You’re welcome, Frank! Thanks!

    • Bob says

      May 25, 2016 at 11:23 am

      You are welcome Frank!

  33. Catherine Tomy says

    May 29, 2016 at 9:58 pm

    A very good post. Thanks a lot for sharing this. Good Work. Keep it Up.

  34. Richard says

    June 3, 2016 at 11:57 am

    Just stumbled on this Bob and we’re keen to make use, thank you. Is it possible to change it for £ sterling, rather than $ dollars? many thanks

    • Lauren (SeedTime Editor) says

      June 6, 2016 at 10:03 am

      Great, Richard! You can save a copy and edit it however is most helpful for you!

  35. Angela Ankers says

    August 18, 2018 at 7:15 am

    I clicked on both links to download the FLOP and neither worked for me. Is there another place I can try, please? I am using Chrome.

    Thank you.

  36. Ann says

    November 9, 2018 at 1:55 pm

    I have tried several times to input my email to get a copy of your FLIP. When I get to the @ symbol it disappears and freezes the screen. Is there another way to get a copy?

    • Lauren (SeedTime Editor) says

      November 13, 2018 at 10:21 am

      Sorry about that Ann – I’ll send you a copy now!

  37. Kyle says

    May 1, 2019 at 9:41 am

    I cant get the download for the FLOP 🙁 could you please send one to my email!? Thank you!

    • Lauren (SeedTime Editor) says

      May 2, 2019 at 1:57 pm

      Just emailed you, Kyle!

  38. Dividend Power says

    October 4, 2021 at 6:05 am

    A spreadsheet is an easy way to keep a budget, always has been.

Footer



SeedTime is a 2x Plutus award winning website.
seedtime money logo


seedtime is accredited with the BBB and has an A+ rating
seedtime instagram seedtime money youtube channel seedtime money twitter with Bob Lotich


Our book Simple Money, Rich Life was named 2022 book of the year!
  • Home
  • About
  • Blog
  • Podcast
  • The Book
  • Courses
  • Press
  • Churches


Privacy Policy | Terms | Reviews | Contact | 636-344-0438
625 Bakers Bridge Ave Suite 105-134 Franklin, TN 37067
©2007-2023 · SeedTime (Formerly ChristianPF)
2888 shares
  • 146