Roger Davies
[ rogerdavies.net ] [ [email protected] ]
  • About Me
    • Call Me
    • Talk Archive
    • #iamindexing
    • mormon.org/Roger
  • Portfolio
    • Soft Serve Direct
    • Magrath Lions Club
    • Magrath Museum

Personal Finance Management - Another how to

19/4/2023

1 Comment

 
Other the past several years I have been using an online spreadsheet to manage my finances. It started with a monthly template which was added to, modified and refined into a yearly running check register that I find quite useful today. I have made a sample template to share with interested family and friends (that is you now)!

If you do a search for 'google sheets personal finance templates' you will discover 100's or even 1000's of free templates offered up. Many are more complicated. Some are more colorful. I don't know if my new offering will be of much interest, but it is what I use and I like it. Simple and effective. 

The link to this sample template is found at:  https://docs.google.com/spreadsheets/d/1iq9vZ41E43QfR_JEQj_MQjXvyboBKd2ybWG7Fnr8uTs/edit?usp=sharing
where you can simply 'save as copy' and start customizing it to fit your needs.
Pros:
  • Using it as a google sheet allows me to access and update from any computer/device/phone in the world, although a desktop computer is most convenient.
  • Entering details as soon as possible allows me to remember and document the what and why .. not as much 'honey, what did we spend $xxx on three months ago?'. 
  • Recurring transactions are easily copied and reused .. just insert new line, copy, paste, update dates and info.
  • Split transactions are fairly simple .. just add one line for each part of the split. eg 20 of 100 to Grocery and 80 of 100 to Merchandise ..
  • Completely customizable - if you want 1000 expense categories, you can. If you have 100 bank accounts, you can have those tracked as well.
Cons:
  • Completely customizable - if you mess up .. oops. However, Google Sheets does have a nice undo/history feature that can help you un-mess-up ..
  • No auto offsite backup .. although Google Cloud is backed up .. if you ever lose your Google account or credentials you may be in trouble. I like to download an offsite copy to use as a local spreadsheet backup just in case. Easy! Click File > Download > OpenDocument or Excel and save the .ods or .xlsx file to your local computer
  • Not a double entry system .. so as a workaround I just use the Transfer category and TWO offsetting entries for bill payments and the like eg "100 expense for Bill Payment in Checking" and "100 income for Bill Payment in Credit Card 1" with same dates .. it seems to work.
  • You MAY have to learn how to use or just get around a spreadsheet - ouch
  • You MIGHT get addicted to knowing just where your money is going and how much you have left!
1 Comment
English Escorts Brighton link
6/4/2025 06:36:02 am

I appreciate the simplicity of this spreadsheet approach.

Reply



Leave a Reply.

    Roger Davies

    My mom (and my grandkids) couldn't be at all my public speaking assignments, so I post them here for them/her and you to read ..

    Disclaimer: These thoughts are not official church policy and in the end are but my own current ideas on the subject(s) 'mingled with scripture'. Regardless, I hope they are of some value to you, dear internet browser.

    Archives

    May 2023
    April 2023
    January 2023
    June 2020
    April 2020
    October 2019
    July 2019
    August 2018
    April 2018
    July 2017
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    March 2013
    February 2013
    January 2013
    September 2012
    August 2012
    July 2012
    June 2012
    April 2012
    March 2012
    February 2012
    December 2011
    November 2011
    October 2011
    August 2011
    July 2011
    June 2011
    July 2009
    July 2008

    Categories

    All
    Baptism
    Choice
    Christ
    Christmas
    Council
    DB
    Endure
    Faith
    Family
    Fasting
    Forgive
    Gratitude
    Grow
    HC Talk
    Heart
    Hold To The Rod
    Humility
    Love
    M1
    M2
    M3
    M4
    M5
    M6
    M7
    Marriage
    Ministering Angels
    Missionary
    Prayer
    Preparation
    Pride
    Repentance
    Sabbath
    Sacrifice
    SC
    Temple
    Tithing
    Trek
    Truth
    WE

    RSS Feed

Powered by Create your own unique website with customizable templates.