Soft Serve Direct
ROGER DAVIES MAGRATH, AB CANADA
  • Home
    • Twitter
    • Twitter Feed
  • inMagrath152
  • News
    • MagrathOpen Wifi
    • Pharmacy
  • Contact Us
    • Map
    • Phone
  • Search
  • Favorites
    • Magrath Chamber of Commerce
    • Magrath Lions Club
    • Magrath Museum

Personal Finance Management - Another How To

22/4/2023

0 Comments

 
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 (view only)
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!

fyi *repost* originally posted at rogerdavies.net
0 Comments

Planned Spending 101

17/10/2014

0 Comments

 
We recently enjoyed a one night training here in Magrath by Mr Keith Russell of Cardston area. He presented a plan for prioritizing and elimination of debt through his method of 'planned spending' aka 'debt free spending'. Over a period of several years he has lived, taught and refined his program mostly as a community service. It got me enthused again on catching up on recording my own personal and business accounting - usually I wait until the tax man requireth his fees. His method takes recording of past expenses one step further, and after requiring entry of current cash flows, it looks at planning for expected upcoming expenses as well ..  

Read More
0 Comments

    Author

    Roger Davies of ssdirect.com

    Archives

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

    Categories

    All
    Accounting
    Email
    Family Safe
    Hardware
    Internet
    Linux
    Software
    Wifi

    RSS Feed

Powered by Create your own unique website with customizable templates.