Anyone manage their personal finances by spreadsheet?

Discussion in 'Off-Topic' started by Trice, May 17, 2019.

  1. Sigmapolis

    Sigmapolis Well-Known Member
    SuperFanatic SuperFanatic T2

    Aug 10, 2011
    16,208
    5,268
    113
    Male
    Washington, DC
    Ratings:
    +20,177 / 1,163 / -4
    I made a CSV file tonight with 14.5 million rows.

    Halp.
     
    • Funny Funny x 1
  2. SECyclone

    SECyclone Well-Known Member
    SuperFanatic SuperFanatic T2

    Sep 29, 2011
    1,656
    281
    83
    Pella
    Ratings:
    +1,769 / 65 / -0
    My high school had multiple finance classes. I’m sure a lot do nowadays
     
  3. Cyched

    Cyched Minister of Culture
    SuperFanatic SuperFanatic T2

    May 8, 2009
    14,400
    4,601
    113
    Ankeny
    Ratings:
    +21,846 / 351 / -0
    I took a business class in HS that went through budgeting, finance, etc. Useful, but not everyone took it.
     
  4. Cyched

    Cyched Minister of Culture
    SuperFanatic SuperFanatic T2

    May 8, 2009
    14,400
    4,601
    113
    Ankeny
    Ratings:
    +21,846 / 351 / -0
    Nerd
     
  5. Cyched

    Cyched Minister of Culture
    SuperFanatic SuperFanatic T2

    May 8, 2009
    14,400
    4,601
    113
    Ankeny
    Ratings:
    +21,846 / 351 / -0
    I use Mint, but am intrigued by Personal Capital. Are most of the tools free? Looks like you have to pay for some of the wealth management stuff.

    Mint works for me right now, but curious if anyone has used both Mint and PC, and what advantages either one has over the other.
     
  6. Sigmapolis

    Sigmapolis Well-Known Member
    SuperFanatic SuperFanatic T2

    Aug 10, 2011
    16,208
    5,268
    113
    Male
    Washington, DC
    Ratings:
    +20,177 / 1,163 / -4
     
    • Like Like x 1
  7. h-man64

    h-man64 Member

    Oct 18, 2006
    74
    7
    8
    Male
    Risk Consultant
    West Des Moines
    Ratings:
    +12 / 0 / -0
    I use both. The budgeting tool on Mint is better. The Personal Capital retirement tool and asset allocation tools are great.

    It is free to sign up and use the tools, but they will contact you to do some investing with them. I did and pay .90% in management fees which is reasonable. They are somewhat of a robo-adviser, but depending on how much you invest, you get two advisers that are assigned to your account. Mine have been very good. I love what they do in regards to tax loss harvesting. They automatically balance your asset allocation according to your risk tolerance which is nice.
     
    • Like Like x 1
    • Agree Agree x 1
  8. Trice

    Trice Well-Known Member

    Apr 1, 2010
    2,523
    417
    83
    Ankeny
    Ratings:
    +2,661 / 108 / -1
    Wasn't seeking financial advice, but thanks.
     
  9. dirtyninety

    dirtyninety Well-Known Member

    Oct 6, 2012
    6,287
    657
    113
    Ratings:
    +2,921 / 203 / -24
    Meh.....Millenials be bailing me out.
     
    • Agree Agree x 1
  10. ruxCYtable

    ruxCYtable Well-Known Member

    Aug 29, 2007
    6,097
    596
    113
    Male
    Ratings:
    +1,877 / 235 / -6
    My tiny little local CU built a better tool than Mint for tracking all accounts and instantly calculating net worth.

    For savings, I have spreadsheet with good old-fashioned Accounting 101 t-accounts to separate savings that is for different purposes. Simple, works great.
     
  11. Kami6348

    Kami6348 New Member

    Aug 12, 2016
    20
    12
    3
    Male
    Ratings:
    +18 / 0 / -0
    Personal Capital offers the app for free. They will pester you about scheduling an appt with an advisor. This will end in the advisor trying to get you to use their advisory service. I don't use their advisory service as I was an RIA for 15 years so I'm comfortable with just continuing the passive approach, primarily DFA funds, that I advised on.

    I think PC has better reporting and is easier to navigate. Mint's hook is budgeting. Mint pesters you with on screen credit card and other offers. I just ignore these but they take up real estate something PC doesn't do.

    As I said in an earlier post either of them will capture all your transactions and simplify the job. I only export transactions annually and then just for archival and analysis. You could do this more frequently if you thought that working with the detail helps you.
     
  12. cygrads

    cygrads Well-Known Member

    Jul 27, 2007
    3,703
    279
    83
    Retired and just tired.
    Altoona, IA
    Ratings:
    +1,392 / 99 / -3
    I used to exclusively use spreadsheets for everything. Then I read an article on Nerdwallet that compared different websites. I started with Personal Capital and used it for free for several years for retirement planning. Really easy to work with and you can setup many scenarios and assumptions and compare. I finally pulled the trigger and are having them manage my investments and so far so good. Getting ready to retire soon and since we don't have pensions it's completely our savings so Personal Capital's retirement planning models using 5,000 Monte Carlo simulations to calculate the outcomes gives me a lot more comfort to go ahead and pull the trigger on retirement. I still use a spreadsheet for budgeting.
     
    • Like Like x 1
  13. randomfan44

    randomfan44 Well-Known Member

    May 30, 2015
    6,541
    451
    83
    Ratings:
    +3,007 / 455 / -73
    My financial advisor has tools way better than some manual spreadsheet that has to be babysat 10 hours a month.
     
    • Agree Agree x 1
  14. Cyched

    Cyched Minister of Culture
    SuperFanatic SuperFanatic T2

    May 8, 2009
    14,400
    4,601
    113
    Ankeny
    Ratings:
    +21,846 / 351 / -0
    Thanks.

    Mint has worked well for me, been using it since I graduated college. I agree that the ads are getting annoying - I keep getting ads for an Amex card I already have :rolleyes: They also have connectivity issues from time to time, and seem to be getting more frequent.

    I'll keep using Mint, but my finances aren't too complicated either. Will probably look into PC at some point down the road.
     
  15. norcalcy

    norcalcy Well-Known Member

    Oct 20, 2010
    1,908
    318
    83
    Ratings:
    +1,317 / 48 / -0
    Interesting thread with lots of points of view. Different things work for different people. The point of intersection appears to be that people in this discussion are quite intentional about managing their personal finances. That would seem to be the key.
     
  16. Trice

    Trice Well-Known Member

    Apr 1, 2010
    2,523
    417
    83
    Ankeny
    Ratings:
    +2,661 / 108 / -1
    More super valuable information. Great contributions here, keep them coming.
     
    • Funny Funny x 1
  17. mdk2isu

    mdk2isu Well-Known Member

    Jan 30, 2013
    4,404
    877
    113
    Male
    Not of this World
    Ratings:
    +3,629 / 136 / -3
    Cool story. Maybe some people, you know, actually enjoy managing their own finances? What a concept.
     
    • Like Like x 1
  18. cygrads

    cygrads Well-Known Member

    Jul 27, 2007
    3,703
    279
    83
    Retired and just tired.
    Altoona, IA
    Ratings:
    +1,392 / 99 / -3
    Can't we have one thread on this board where we don't bag on other posters.
     
  19. Trice

    Trice Well-Known Member

    Apr 1, 2010
    2,523
    417
    83
    Ankeny
    Ratings:
    +2,661 / 108 / -1
    Follow that conversation back to its origin and tell me who's bagging on whom. I started the thread to see if other people had a common interest. No need for someone else who doesn't share that interest to weigh in without anything constructive to add.
     
    • Agree Agree x 2
  20. DreamyCy

    DreamyCy Active Member

    Nov 13, 2013
    881
    30
    28
    Ratings:
    +275 / 44 / -2
    The fact that you would say 10 hours means you probably have no clue how to build a spreadsheet. It takes me like 20 minutes to update our spreadsheet for monthly spending. I don’t know how anyone can feel good about their finances when they don’t know where their money is going.
     

Share This Page