BudgetLifeStyle Systems
Copyright © 2001 Version 1.0
BudgetLifeStyle Tutorial
Because I want you to take full advantage of the extreme flexibility of the BLS templates, I've created this tutorial. The BLS Templates are best viewed at 800 x 600 resolution. If you have opened the "Sample" template, you may feel intimidated, but don't be. I put notes everywhere to explain the obvious, plus the flexibility and information available to the user. You can make your template as simple or as informative as you wish. As you can see by the Sample, you can insert text in various sections as reminders of specific activity.
Click on the bookmarks below or continue to scroll down and read.
Reason for Different Templates:
The first thing you need to know is the reason for the different templates.
BudgetLifeStyle Systems is just that, a system of budgeting based on your paydates. You
need to know how much you should put in your checking account out of each paycheck for the
expenses you have. If you get paid every week, use the " weekly" template. If
you get paid every two weeks or twice a month use the "biweekly" template. If
you get paid once a month you can use either template depending on the information you
want. I would recommend the biweekly template for a monthly pay period.
NOTE: AFTER YOU OPEN THE TEMPLATE YOU INTEND TO USE, AND BEFORE MAKING ANY ENTRIES,
RENAME THE TEMPLATE WITH "SAVE AS" TO A NAME OF YOUR CHOICE. THIS WILL KEEP THE
ORIGINAL CLEAN TO START THE NEXT YEAR WITH.
TIP: CREATE A COPY WITH "SAVE AS" CALLED "PLAY". USE THIS COPY TO PLAY WITH UNTIL YOU GET THE FEEL FOR HOW THE TEMPLATE WORKS.
BudgetLifeStyle Templates use a four (4) week per month standard as a bases for budgeting, and monthly payments as a control standard for expenses. The BLS templates divide each monthly payment by two (2) or four (4) depending on which template you are using, this tells you how much you should have available for each bill either per week or biweekly. We all know there are fifty two (52) weeks per year not forty eight (48) and twenty six (26) biweekly segments per year not twenty four (24). The use of the (4) week standard per month has it's advantages. (1.) The standard makes the math easier, we don't have to use (4.333) per month in the formula. (2.) It forces us to use a little less money per month than we actually earn to cover our bills, thereby creating a small edge in our favor, at least in theory. (3.) When the extra pay period check shows up it's like a bonus because we had not used it in our calculations.
Picking a Month to Start:
After choosing a template to use, you can start your budget in any month. If you happen to be in the month of March click on the March tab at the bottom of the template. When you make your entries, the remaining months will fill in for you. January and February will not be affected by the entries.
Determining Expenses and Payment Amount:
Remember, every dollar that comes out of your checkbook is an expense in one form or
other, even if it's for personal spending. If the bank charges you a monthly service fee
for your account, this is an expense item or bill. You don't send a check, but it is
deducted from your checking account every month label it "Bank Fees". If
you have an "ATM" card and the bank charges you a $15.00 annual fee, it's an
expense item. The bank may automatically deduct it, but you must know what you need in
your checking account for this bill every month. Like most of us you will not remember
when the mysterious deduction will take place. If you designate $1.25 per month ($15.00
divided by 12 ) as the "ATM FEE", when the bank deducts it, the money should be
there. If you don't do this and your checking account happens to be tight (close to short
) when the bank wants to deduct this payment, you could be paying "over drawn"
fees all over the place. You know how the banks love fees!
Another expense item is "Miscellaneous". The only difference with this expense
is, you may not know what you will spend any given month. You do not need to enter a
monthly amount for this type of expenditure. The template will deduct from your checking
account any amount associated with "Miscellaneous" and give you a total for the
month. For example your ATM card use, most of the time it will be used for cash
withdrawals for pocket money, you can just list this under "Spending" or
"Misc.". (Note: in the "Amount Due After Payment" column it will show
as a negative number, because no amount is listed under the "Monthly Payment"
column. This is normal for this type of listed item.). If you want to know how much you
specifically took with your ATM card, then label it, such as "ATM USE". Every
time you use your "ATM" card, associate the amount with "ATM USE"
instead of "Misc". Because you don't know how much you will use the card leave
the monthly payment amount blank or zero just like "Misc". At the end of the
month you will see how much you took out of your account with the "ATM" card. Do
not create labels for each occasional expense such as, "bought Mary shoes". If
you buy Mary shoes every month, maybe you should label it. If you don't, you might
reference this expense to "Miscellaneous". If you want to know how much you
spend on Mary, then create a label called "Mary" and reference everything you
spend on Mary to this item number and label.
Because BLS Templates use a Monthly amount as a payment and control method, you need to
convert your expenses to a monthly amount. Regardless of how many times a year you pay any
specific bill, it must be broken down to a monthly payment.
For Example:
If you pay your Life Insurance premium once a year ( annually), divide the premium by 12
to get the monthly amount. This is the amount you should be putting aside every month for
this bill. If you pay your Auto Insurance premium once every 6 months (semi-annually),
divide the premium by 6 to get the monthly amount etc.. For the expenses that fluctuate
every month, the amount you use as a monthly payment will be an estimate. If you choose
the highest monthly payment you ever made for a specific bill, the odds are you will
always have more than enough to pay the bill at any given month. You can pick any amount
that you feel should be the norm and use that figure as your average payment, you can
always adjust the amount later if it's way off. You can also use the method in the Gas and
Electric example below. How the templates handle these and other types of payments are
explained further on. As you use the template it will become clearer and really very easy
to use.
In this example which is loosely based on my own expense, $183.70 is the average, but, I set a monthly figure of $210.00 as my average in my budget. That may seem high, but when the bills come in that are less than that, I have money left in my budget to cover the higher bills or those miscellaneous goodies I just had to have. I found it advantageous to use the high side for my bills, and use the low side for my income, mentally it helps keep me in check.
Example: Monthly Gas and Electric Bill
Month |
Amount | Total to Date |
January | $285.75 | $285.75 |
February | $265.80 | $551.55 |
March | $225.23 | $776.78 |
April | $198.75 | $975.53 |
May | $145.60 | $1121.13 |
June | $98.63 | $1219.76 |
July | $164.97 | $1384.73 |
August | $210.75 | $1595.48 |
September | $174.50 | $1769.98 |
October | $121.50 | $1891.48 |
November | $126.68 | $2018.16 |
December | $186.23 | $2204.39 |
Average | $183.70 | $2204.39 ÷ 12 |
Arranging and Entering Expense Items
If you read the Introduction you may remember BudgetLifeStyle does not arrange expenses in categories. All expenses for the month are available on one page for review and control.
In the "Expense Item" column enter your bills there. Again, remember every deduction from your checking account is some sort of expense, even for cash and should have an item label.
In arranging your expense items, try to list them in some logical order. In the
"Sample" template I listed "Rent/Mortgage", "Property Tax",
"Electric", "Heat", and "Phone" in the same general area of
the list. To me these bills relate to the "House" so I kept them together. It is
not necessary to do this, you can arrange the list in any order you wish. To me it creates
some sort of organization.
Note: Try to arrange your list in the order you want right from the beginning when you
start your template, it makes it easier to add other items should the need arise. Also
note, if you change the arrangement of your list later in the year, the "Paid to
Date" column will not reflect the correct total in the right row for the previous
payments. The "Paid to Date" column is valuable for showing the total you've
paid for any item at any point during the year. Example: If "Rent" is in
"Ref. No.1" row, from January to March and in April you change the location of
"Rent" to "Ref. No.10" row, the "Paid to Date" column in
"Ref.1" will only show 3 months total Rent paid. The "Paid to Date"
column in "Ref.10" will show 9 months rent paid from April to December. If you
wanted every previous month to match, you would have to go back and re-reference every
entry etc.before the change. After you enter the list, enter the payment amount in the
"Monthly Payment" column for each item.
Depending on the template you use, the "weekly" or "Biweekly" payment
column will fill in automatically. Notice the "Pay Date" columns, they also fill
in.
Entering Income Source
Enter a label for the income source(s) in the "Income Source" column. See "Sample" template.
If a source of income is your paycheck use your net income (take home pay) as the amount.
If you are using the "Weekly" template, and get paid every week, enter your net pay in the "Weekly" column. The "Monthly" column will calculate automatically. No entries can be made in the "Monthly" column directly. If your spouse gets paid every (2) weeks, divide your spouses net pay by (2) to get a weekly amount to enter. If you have an income source that pays you once a month, divide that source by (4) to get a weekly amount.
If you are using the "BiWeekly" template. Multiply your weekly net pay by (2), enter your spouses net pay as is, divide a monthly source by (2).
If all sources of income are "Monthly" divide each by (2) or (4) depending on the template you are using.
Notice the difference between the "Expense Items" and the "Income Source" it calculates automatically. The remaining months will also fill in.
Entering Deposits
Notice the "Pay Date" columns continue down through the "Deposit" section of the templates. In the "BiWeekly" template there are (3) columns (1), (2), and (3). In the "Weekly" template there are (5) columns (1), (2), (3), (4) and (5). If you enter a deposit in "Pay Date" column #1 the "Checkbook Balance" row will total the deposits in the #1 column. The total will carry across all the columns including, the "Amount Due After Payment" column. The checkbook balance in this cell in the "Amount Due After Payment' column should be the correct and final balance in your checkbook. When you make a payment the amount is deducted from the balance in this cell. The "Checkbook Over/Short" row in column #1 will subtract your total expenses from the total deposits entered that pay period. The "Checkbook Balance" row should be the balance in your checkbook if you didn't make any payments yet. The "Over/Short' row will be either negative or positive depending on whether you deposited enough money to cover your bills or not that pay period. See: "Sample" template.
Entering Checkbook Balance to Start
Enter your correct checkbook balance in the first upper left cell in the first column under the words "Enter Checkbook". See "Sample" template. Once you've made this entry, you no longer have to enter your checkbook balance in every remaining month. The final checkbook balance in the "Amount Due After Payment" column will automatically carry over to the next month. You only need to enter your additional deposits in each month.
The "To Whom Paid" section of the template is where you enter all the information for your payments. If you open the "Sample" template this section should be self-explanatory, especially if you read the previous information in this tutorial. WARNING: Get into the habit of entering the basic detailed information i.e., check numbers etc. not just the "Ref No." and "Amount". It will help you find any errors you've made. I use these templates and have found "Goofy" errors on my part.
When you enter a payment, and associate a "Ref No" to it and an amount, the following happens. I'll use the Electric bill in the "Sample" as an example. Here we designated $80.00 as a monthly average payment. On the 5th of January we used check #102 to pay the bill of $75.00 dollars. To have the template do what it should we reference #3 in the "Ref No" column and entered $75.00 in the "Payment Amount" column. In the "Paid this Month" column you'll see the $75.00 posted. Because we designated $80.00 as a monthly average payment, there is $5.00 left over or "Amount Due After Payment". As far as the template is concerned you didn't pay the full bill of $80.00. The $5.00 will now carry over to the first week in February. If you check February you will see $25.00 as the first week amount due not the customary $20.00 and $85.00 due for the month not $80.00 dollars. If the $75.00 was the full bill for electricity that month enter a zero in place of the $5.00, doing this tells the template the bill is paid and no remaining amount is due and will not carry over.
Another type of payment is over paying. Let's look at the "Phone" bill in the "Sample". On the 8th of January we used check #103 for the phone bill, referenced number 6 and entered $52.45 as the amount paid. If you notice the "Paid this Month" column the $52.45 is there, but the "Amount Due After Payment" column has a negative $2.95 in it. This indicates you paid more than you set up as an average monthly payment, for your phone bill. The negative number will not carry over, because as far as the template is concerned, if you paid more than you set up, the bill must be paid in full for the month. The advantage of this number coming up rather that just a plain zero, is you see if your constantly paying more than you think you should and by how much.
Tracking Payments and Due Dates
Since the objective is "Cash Flow", tracking becomes important. Try to decide how you want to track when you initially set up your template. Each bill can use any of the following methods and can be combined in the same template. There are (3) basic ways you can track with the BLS Templates. (1.) The simplest, just enter your expenses and payments. (2.) You can accumulate the funds for a given expense a month ahead of time (in the previous month). (3.) You can set up the amount due to total up in the week you will send out the payment.
Method # 1
This is the simplest method to use. Just enter your expense items and monthly payments and
the template will total the amounts due. When you make your payment it will be deducted
from the month's total and your checkbook balance. This method is based on the assumption
all the bills are due at the end of the month. This allows the (4) weeks necessary to
accumulate the amount that will be due at the end of the month.
Method # 2
You may want to use this method for bills due on the first of the month like Rent for
example. Let's say your rent is due on the first of the month, (which most usually are)
because your monthly rent payment is broken down into four (4) equal weekly payments,
(depending on the template) you must in theory, wait four weeks to accumulate the total
amount. For example, assume your monthly rent of $800.00 dollars is due April 1st., you
should set up March to be the accumulation month for the rent, so at the end of March you
will have $800.00 dollars available to pay April's rent. To avoid double entries and keep
confusion to a minimum enter the payment in March's "Expenses Paid" section not
in April's, and in the "To Whom Paid" column, enter "Aprils rent". In
the month of April you will be accumulating the rent money for May, at the end of April
pay May's rent etc.. For any payments that are due before the end of the month, you can do
the same as the above example or try the next method.
Method # 3
Another way to track is by carrying the amount necessary to cover the payment over to the
next month. Let's use a car payment example. The payment is $400.00 per month and due the
21st of the month, which is the third week of the month. Make the entries in the template
as usual, "car payment" in the expense item list, and $400.00 in the monthly
payment column. To accumulate 4 weeks worth of payments by the third week of next month
use the following method. After you make the $400.00 payment this month a "zero"
will appear in the cell in the "Amount Due After Payment" column. Change the
"zero" to 100 in this cell, it will appear as $100.00 dollars. This $100.00 will
carry over to next month and show up as $200.00 in the first week column and add up to
$400.00 in the third week column. Once you've made this change, the results in the example
will continue every month. You can use this method for bills due any week of the month.
Let's try the same bill but this time it's due the second week of the month. After you
make your $400.00 payment all you need to do is enter $200.00 instead of $100.00 in
the cell, next month the first week column will now show $300.00 and the second week
$400.00 dollars. You will notice the third week shows $500 and the fourth week shows
$600.00 this is what you should accumulated for the full month without making payments.
Once you make the $400.00 payment $400.00 from $600.00 will leave the $200.00 to carry
over to the next month.
If you try this in your "Play" template, if you made one, you'll see how this
works.
As you can see the BudgetLifeStyle Templates are flexible and complete. Virtually all the information you need for your budget is right in front of you.