Instructions For the Software Glen Financial Spreadsheet Version

© Software Glen 2007-2024

The purpose of this Financial Spreadsheet is to provide an individual the means to budget and track one's finaiancial

condition on one page. Unfortunately some of the better personal financial packages (Money, Quicken) do not allow the

kind of Financial Statement that provides a snapshot of the cashflow and tracking of it from month to month, and a way

to track financial indicators beside net worth. This provides a Rich Dad (www.richdad.com) compatible view. However,

most of the financial software packages don't define assets and liabilities like Kiyosaki does. That is assets put money in your pocket

and liabilities take money out of your pocket. This spreadsheet uses those definitions. See below for more indicator definitions.

Orange fields are for user input. All others are disabled for input.

1. Put year and name on Graphs page.

2. Fill out the default budget, expenses on the Defaults Budget and Budget Detail Page tab. (in that order)

This requires deciding what items you want to appear in expenses, and what income you want the default to be.

All defaults budget amounts for expenses can be overridden monthly, however, item tags cannot.

3. Make sure that you have set up budget for both income and expenses. Once you do it for one year it becomes easier for the next.

1. Fill out the actual income and expenses for each month in only orange fields in the month's Detail tab. The spreadsheet computes

the rest. The summary of each of the month's detail will be found in that month's tab. Only fill out the Detail unless you are

changing a month's budgeted expenses. Otherwise don't enter anything into the month's tab but in the month's detail tab.

Some people update it once every week or so during the month to get a "feel" of the cashflow. If you have all the numbers,

it only takes less than 15 minutes/month to complete.

2. Fill out earned income (job), passive income (portfolio, real estate).

3. As time progresses check out the Graphs page to get a feel of your current financial trends.

4. The Totals page gives you a Year-To-Date prospective.

- % of money kept after expenses

- % of Net Worth easily convertible to cash

%money working

- % of money invested

- monthly debt expense to income ratio in %

%inc to taxes

- % of income used for taxes

- times passive income can cover expenses

%On Housing

- % of income used for housing exp

- passive monthly return annualized

- % of net worth not income producing

- number of years you can live on assets

- items that provide positive cashflow

- items that provide negative cashflow

This FS concentrates on expenses and not that much on income as most income is easily catorgorized in the 3 areas, or are

part of a business or RE and considered in a separate spreadsheet. This was meant to be a personal and not a commercial

Financial Statement that could fit on one page per month. Some default items descriptions have to remain fixed.

To allow a one page Financial Statement per month, you can only have 16 expense classes of items so plan accordingly.

It uses it to compare changes to January. If you have the financial spreadsheet for last year make sure it is named FS2023

and put its location on the Graphs page. If it is or if you don't have a FS2023 then then don't worry about it.