PRETTY GOOD BUDGET PROGRAM USER GUIDE
Contents
1. Move your cursor to the category you wish to select from the list at the top of the page and click on that category This will enter that cell address as shown below Tap the Enter key on your keyboard and the name of that category will be inserted into the APPLY TO CATEGORY cell SPENDING amp ENTERTAINMENT GROCERIES 4 HEALTH amp GROOMING MORTGAGE RENT HOME amp LIFE WSURANCE savnes Type click on category above and Enter 1 417 31 Enter current balance in bank account and enter amounts in each catego 2 Jan Safeway APPLY TO CATEGORY AMOUNT Type click on catagory above and Enter 1 417 31 ROCERIES cA 23 06 If the transaction is a debit type a minus sign preceding the amount to make it negative The BALANCE of the account in this example is now automatically reduced by the amount of the transaction and because the GROCERIES category was selected the amount of this transaction is also automatically deducted from the GROCERIES expense category leaving a new balance in that category VERIFY is automatically adjusted to equal BALANCE CONTINUE TO ENTER TRANSACTIONS Continue entering transactions in the same way Enter the DATE the PARTICULARS of the transaction type an equal sign in the APPLY TO CATEGORY cell click on the desired category in the list and tap the Enter key on the keyboard You may find it faster to type the name of the expense categ2. a zero balance UTURE SHOP INE OF CREDIT a AR LOAN It is important in keeping a budget to keep a o record of your credit card charges even if you FRSONAL LOAN pay the balance owing each month This will help you determine and adjust the amounts of your PROJECTED EXPENSE CALCULATIONS Fin al g g mi As you enter items in the list of CREDIT CARDS AND DEBTS these names will automatically appear as column headings in the CREDIT CARDS amp DEBTS worksheet 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 o M a d F H EXPENSE CALCULATIONS Fa TRANSACTIONS i i Recording of debts will be explained in this user guide after the following sections explaining entering BUDGET TRANSACTIONS Before proceeding further be sure to save the workbook as BUDGET 2006 or the name of the year you are recording Each time you enter transactions be sure to save your changes THE TRANSACTIONS WORKSHEET All financial transactions debits and credits are entered in the TRANSACTIONS sheet of this workbook Simply click on the TRANSACTIONS tab at the bottom of the sheet to access this page EX Microsoft Excel Budget 2006 File Edit wiew Insert Format Tools Data Window Help
3. each item but you will want to designate the two separate categories in the APPLY TO CATEGORY column One line will be for HEALTH amp GROOMING and the next for GROCERIES Apply the appropriate amount to each category as you would not want GROCERIES expenses to be deducted from your HEALTH amp GROOMING budget HEALTH amp GROOMING GROCERIES ENTERING CREDITS AUTOMATICALLY When your pay cheque is deposited you will enter it as a credit a positive amount and you will then have the option of letting the program automatically enter your deposit amongst the various EXPENSE CATEGORIES or of entering amounts manually into each EXPENSE CATEGORY To have the deposit automatically distributed amongst your EXPENSE CATEGORIES enter the phrase REGULAR DEPOSIT in the APPLY TO CATEGORY cell You can type in the cell click on REGULAR DEPOSIT at the top of the sheet and tap Enter on the keyboard or simply type in REGULAR DEPOSIT Enter the amount as a positive number without a minus sign REGULARDEPOsIT OF TOTAL DEPOSIT 10 58 Type click on cath Enter current balance in bank account and enter amounts in each categor Safeway GROCERIES Esso VEHICLE FUEL amp MAI ATM Withdrawl Spending Money London Drugs Pay Cheque The amount of the deposit will be automatically distributed amongst your EXPENSE CATEGORIES based on the percentage of the deposit each EXPENSE CATEGORY should receive These
4. y SUE AE red z eM A SRY SPE o Sze 4 MO aria E13 A B z SPENDING amp ENTERTAINMENT HOUSE amp TARD MAINTENANCE ay AE Cooper Computer GROCERIES HEALTH amp GROOMING C n itin MORTGAGE f RENT CLOTHING o su I g PROPERTYTAxES investments ie cr seal irc ce pig PROPERTY TASES INVESTMENTS Virus Removal Matware Removal UTILITIES MISC EXPENSES Computer Security File Restructuring Reformatting Sottware amp Hardware Insiallation VEHICLE PAYMENTS amp INSURANCE 55S AES rca ile Ede ES YEHICLE PATMENTS amp INSURANCE YACATION Dennis Cop seniems 20 BE SGO0 YEHICLE FUEL amp MAINTENANCE CHRISTMAS tuton cablelan net Oo OO ma e d e PARTICULARS APPLY TO CATEGORY AMOUNT Type click on category above and Enter 1 417 31 Enter current balance in bank account and enter amounts in each categorg YERIF YT must equal BALANCE 44h hI EXPENSE CALCULATIONS CREDIT CARDS amp DEBTS Ready ti start In the columns A B C amp D under the yellow headings you will enter the DATE of each transaction PARTICULARS of the transaction where you purchased an item to which EXPENSE CATEGORY the transaction will be applied and the AMOUNT of that transaction All calculations to adjust the BALANCE in your chequing account and the remaining funds available in each expense category will be carried out automatically by formulas written in the cells under the blue column headings WARNING
5. 0 to 173 00 and now the VERIFY column equals the BALANCE column Whenever transactions are entered in this program either debits or credits always ensure that the amount in the blue VERIFY cell equals the amount in the BALANCE cell to its left If the VERIFY amount is less than the BALANCE there has been a mistake and additional funds must be added to an EXPENSE CATEGORY If the VERIFY amount is greater than the BALANCE too much money has been entered in an EXPENSE CATEGORY and therefore the amount entered in one of the categories must be decreased VERIFY MUST ALWAYS EQUAL BALANCE ENTERING TRANSACTIONS Once the chequing account balance has been entered amounts have been distributed in the EXPENSE CATEGORIES and VERIFY equals BALANCE you can begin entering transactions You may find it advantageous to begin keeping your budget immediately after a pay deposit in order to ensure there are funds in each category but this is not necessary Entering a pay deposit will be explained later In this example we will start the budget at the beginning of the year Begin by entering the date of the first transaction and the particulars of where the transaction occurred Then in the cell under APPLY TO CATEGORY type an equals sign Type click on category above and Enter 1 417 31 Enter current balance in bank account and enter amounts in each categorg FERIF YT must equal BALANCE 2 Jan Safeway
6. CERIES VEHICLE FUEL amp MAINTENANCE VEHICLE PAYMENTS amp INSURANCE CLOTHING 76 7 4 AMOUNT BALANCE VERIFY CLOTHING INVESTME 1 417 31 15 38 TE 4100 00 0 00 40 00 0 00 46 15 40 00 0 00 0 00 0 00 40 00 46 15 0 00 40 00 0 00 0 00 0 00 40 00 0 00 An alternate and more accurate way of recording this transaction would be to apply the original cost of the parka 59 95 as a DEBIT in the CLOTHING category and then record the interest charge of 16 79 separately to the MISC EXPENSE category In this example the CLOTHING expense category would now have a positive balance of 2 19 7 26 Jan 26 Jan a Jan 28 Jan 30 Jan a0 Jan 30 Jan a0 Jan 30 Jan 31 Jan 1 Feb 1 Feb 1 Feb 5 Feb 5 Feb PARTICULARS Berkshire Investments Home Hardware Sale of Used Computer Future Shop Mew Computer Pay Deposit Car Payment AutoPlan Party Supplies ATM Withdrawl Spending Money Service Charges Pay Deposit ATM Withdrawl Spending Money Mortgage Safeway Esso ar Pavinien 16 Feb Sears Interest on Sears Invoice Type click on category above and Enter GROCERIES INVESTMENTS HOUSE amp YARD MAINTENANCE SAVINGS SAVINGS VEHICLE PAYMENTS amp INSURANCE VEHICLE PAYMENTS amp INSURANCE SPENDING amp ENTERTAINMENT SPENDING amp ENTERTAINMENT MISC EXPENSES SPENDING amp ENTERTAINMENT MORTGAGE J RENT GROCERIES VEHICLE FUEL amp MAINTE
7. ERIFY MUST ALWAYS EQUAL BALANCE CREDIT CARDS amp DEBTS To properly manage your finances it is important that you keep track of any money you owe including Credit Card transactions car payments line of credit mortgage and any personal loans You should be aware of all outstanding balances and their current status if you are to properly manage your budget The third worksheet in this program CREDIT CARDS amp DEBTS will help you to manage this data To open the CREDIT CARDS amp DEBTS worksheet simply click on the tab at the bottom of the page MASTER CARD PERSONAL LOAN AMERICAN EXPRESS FUTURE SHOP LINE OF CREDIT Wo CAR LOAN jo MORTGAGE Pod Type click on category above and Enter ee PLY TO CATEGO CREDIT TOTAL AMOUNT OWING MASTER CARD Sf co oe e The names of all your Credit Cards and creditors should be already listed at the top of this page as well as on blue column headings across line 12 If not return to the EXPENSE CALCULATIONS worksheet and enter this information in the CREDIT CARDS amp DEBTS section of that sheet In row 13 of the CREDIT CARDS amp DEBTS worksheet enter the outstanding balance in the blank cell under each category This number must be entered as a negative number preceded with a minus sign if there is money owing If there is no money owing type a zero 0 MASTER CARD i FUTURE SHOP iE LINE OF CREDIT These entries will be automatically totaled and displayed
8. IT IS VERY IMPORTANT THAT YOU ENTER DATA ONLY IN SPECIFIED CELLS DATA ENTERED IN AUTOMATED CELLS WILL CORRUPT THE FORMULAS The following instructions will explain into which cells you will enter information and which cells are updated automatically CURRENT CHEQUING ACCOUNT BALANCE The first step in entering your financial transactions in this program is to enter the current balance in your chequing account Enter your balance in the first cell under the blue heading BALANCE APPLY TO CATEGORY AMOUNT BALANCE VERIFY SPENDING amp ENTERTAINMENT Type chick on category wich and Enter 1 417 31 150 00 1 500 00 500 00 158 75 5158 76 1 58 7A na 77 30 od 536 5 54 a JE The amounts in the cells to the right of the shaded cells under each EXPENSE CATEGORY may then be manually changed from those automatically entered You may prefer that some categories have a smaller amount than entered and some larger The total of the amounts entered are reflected in the blue VERIFY column and that amount must equal the balance in your account If the VERIFY amount is less than the BALANCE as in the example to the right you must enter more funds in one or more categories In this example there is a difference of 23 00 so an additional 23 00 must be added to one of the categories 1 1 500 00 The amount entered in the category SPENDING amp ENTERTAINMENT is in this example increased by 23 00 from 150 0
9. Jan Great Vest Life HOME amp LIFE INSURANCE 47 00 0 00 25 Jan London Drugs HEALTH amp GROOMING 20 00 0 00 GROCERIES 10 00 0 00 26 Jan Berkshire Investments INVESTMENTS 100 00 0 00 l Siete BLT i L Imi T rT GPa a bt LII CIL og t Lt pm Zi Jan Sale of Used Computer SAVINGS I50 00 350 00 4276 86 2o Jan Future Shop New Computers SAVINGS BYSO 00 F50 00 321 14 0 00 321 14 This extra income may be deposited in your SAVINGS or VACATION column or if one of your other categories is in the hole into that category If you know the category into which you want to deposit this extra income you can enter the title of that category in the APPLY TO CATEGORY column and the specified category will reflect that deposit In the example above the money received from the sale of the used computer was deposited in the SAVINGS category because a new computer would be purchased the next day and would be deducted from that category Even though the SAVINGS category in the example above now has a negative balance of 321 14 after the purchase of the computer the other categories remain unaffected and the balance in them remains the same There is still in this example 88 46 set aside for a vacation even though the SAVINGS column is temporarily in the hole As the required 46 15 is deposited into SAVINGS from each bi weekly pay cheque the negative balance will gradually decrease and will after seven pay
10. NANCE m PAY TE Ty re IT Ply CLOTHING MISC EXPENSES 10 00 100 00 42 75 350 00 750 00 1 500 00 350 00 63 00 79 50 100 00 14 00 1 450 00 100 00 800 00 475 00 35 00 if IRNI 59 95 16 79 59 95 vat O0 42 19 Hl 0 00 100 00 0 00 40 00 40 00 46 15 0 00 0 00 40 00 40 00 40 00 46 15 0 00 40 00 40 00 40 00 a O0 96 15 3 05 3 05 3 05 3 05 42 30 42 30 42 30 42 30 42 30 42 30 00 45 00 45 00 45 58 45 00 45 i 45 MISC EXPENSE AMOUNT CLOTHING INVESTMENTS E 1 417 31 15 38 46 15 0 00 0 00 0 00 40 00 40 00 46 15 0 00 0 00 40 00 40 00 414 00 46 15 0 00 40 00 0 00 a o YEAR END At the end of the year you will want to save the current years budget to a disk for future reference Be sure to take note of the final ACCOUNT BALANCE as well as the balance in each EXPENSE CATEGORY in order to enter these figures in a fresh budget template for the New Year Examine the Total Amounts Spent To Date at the top of each EXPENSE CATEGORY to determine if an adjustment will be required in your PROJECTED EXPENSE CALCULATIONS in the new workbook If one or more categories ended up with expenditures greater than you had anticipated you should consider increasing the amount you had originally entered in the PROJECTED EXPENSE CALCULATIONS To help offset this increase categories that had fewer
11. ORIES BELOW MAY BE CHANGED TO SUIT YOUR OWN BUDGET NEEDS i EXPENSE CATEGORIES 7 PERW SPENDING amp ENTERTAINMENT GROCERIES MORTGAGE RENT umtesSOOCSC SSSY HOME amp LIFE INSURANCE f VEHICLE PAYMENTS amp INSURANCE HOUSE amp YARD MAINTENANCE aome mesmes f VACATION OOO o i CHRISTMAS SPENDING amp ENTERTAINMENT is a category for the cash you want to have on hand for your own personal spending such as a night out at the movies dinners with friends sporting events lottery tickets wine and beer barbeque parties etc Try to allow yourself a reasonable amount of spending money from each pay cheque because 1f you don t have sufficient spending cash you will probably not stick to your budget In order to make a budget work effectively you must be sure to PAY YOURSELF FIRST In the next section enter the letter corresponding to the frequency of your pay cheques ENTER THE LETTER CORRESPONDING TO HOW OFTEN YOU ARE PAID L7 WE RECEIVE A CHEQUE ONCE A MONTH I WE RECEIVE A CHEQUE TWICE A MONTH T WE RECEIVE A CHEQUE EVERY TWO WEEKS WENTER LETTER IN THIS CELL L WE RECEIVE A CHEQUE EVERY WEEK If you and your spouse partner each receive a pay cheque every two weeks but they are received on alternate weeks then there would be a cheque deposited each week so you would enter letter D THE HARSH REALITY When a letter is entered representing a weekl
12. PRETTY GOOD BUDGET PROGRAM USER GUIDE TABLE OF CONTENTS NTRODUCTIO XPENSE CATEGORIE PROJECTED EXPENSES HE HARSH REALIT REDIT CARDS amp CREDITOR HE TRANSACTIONS WORKSHEE URRENT CHEQUING ACCOUNT BALANC NTERING TRANSACTION ONTINUE TO ENTER TRANSACTIONS ENTERING CREDITS AUTOMATICALL LR Sea en ee ce ee THE PRETTY GOOD BUDGET PROGRAM DEVELOPED BY DENNIS COOPER THE PURPOSE OF KEEPING A BUDGET IS NOT TO MERELY RECORD TRANSACTIONS BUT TO FORECAST EXPENSES FOR THE YEAR AND ENSURE THERE ARE SUFFICIENT FUNDS AVAILABLE TO COVER EACH OF THE PROJECTED EXPENSES I developed this program as a means of managing my own finances and to ensure that I would have necessary funds set aside to cover projected expenses For several years I had maintained a budget using ledger books and entering every transaction by hand When I began working with Spreadsheet programs however I realized that the use of formulas written into cells would be perfect for maintaining a budget and so I gradually developed this program the PRETTY GOOD BUDGET PROGRAM At first reading of this USER GUIDE maintaining a budget may appear complicated and confusing but once you become familiar with the program you will find it is very easy and hopefully that it really is a PRETTY GOOD BUDGET PROGRAM The satisfaction of having funds available to meet your expenses when they are due should make the learning process w
13. RANSACTIONS CREDIT CARDS amp DEBTS ri They will also appear automatically in a category list at the top of the TRANSACTIONS worksheet ES Microsoft Excel Budget Template Eq File Edit Yiew Insert Format Tools Data Window Help le Bea Sa sa r amp 4 i ara Diy SPENDING amp ENTERTAINMENT 4 HOUSE amp YARD MAINTENANCE GROCERIES HEALTH amp GROOMING MORTGAGE RENT crore PROPERTY TAXES N ESTMENTS VEHICLE PAYMENTS amp INSURANCE ACATION a O o O WEHICLE FUEL amp MAINTENANCE CHRISTMAS a O O Oo OO 4 0 on ee Ra A PARTICULARS APPLY TO CATEGORY Type cick on category above and Enter Enter current balance in bank account and enter amounts in each category C YERIF TY must equal BALANCE Never manually enter any titles of expense categories in the TRANSACTIONS worksheet but only in the appropriate section of the EXPENSES CALCULATIONS worksheet PROJECTED EXPENSES In the yellow area of the section PROJECTED EXPENSE CALCULATIONS on the EXPENSE CALCULATIONS sheet enter the amount of money that you estimate you will need to cover each of the EXPENSE CATEGORIES Enter the projected expense for each category into ONLY ONE column for each category either in PER WEEK BI WEEKLY PER MONTH or PER YEAR These amounts may be calculated based on your expenses during the previous year THE NAMES OF THE EXPENSE CATEG
14. Used Computer 26 Jan Future Shop New Computer 30 Jan Pay Deposit 30 Jan Car Payment 30 Jan AutoPlan 30 Jan Party Supplies 30 Jan ATM Withdrawl Spending Morne 31 Jan Serice Charges Feb Fay Deposit VEHICLE PAYMENTS amp INSURANCE VEHICLE PAYMENTS amp INSURANCE SPENDING amp ENTERTAINMENT SPENDING amp ENTERTAINMENT MISC EXPENSES ld 4 gt HD EXPENSE CALCULATIONS TRANSACTIONS f CREDIT CARDS amp DEBTS In comparing the BALANCE in your budget with the balance in your chequing account keep in mind that any cheques written and recorded in your budget may not yet appear on your Bank Statement The Bank will have no record of a cheque until it has been cashed So if the BALANCE in your budget does not match the balance shown in your chequing account ensure that there are no outstanding cheques that would cause the difference If you have accidentally recorded an incorrect amount in one of your budget entries and your Bank Statement shows the correct amount simply find that entry in your budget and change the amount of the debit or credit Formulas in the program will automatically update all your balances to reflect this correction If your chequing account balance still differs from your budget BALANCE after comparing all entries you can change the BALANCE in your budget to coincide with the bank statement Be sure though to also adjust one of your EXPENSE CATEGORIES by that same difference to insure that V
15. ata Window Help Adobe POF Cells F cr appear as as in the example on the left they oe Ge are too large to fit the column If this happens click sett Selection on Format on the menu then Column and then on Autofit Selection as shown on the right The column widths in this program were set for an Excel zoom level of 75 and a screen resolution of 1024x768 2K kK OK 2K OK OK ok ok OK ok OK OK OK KK KK OK KKK KK KK KKK KKK KKK KKK KKK KKK KKK KKK KKK KKK KKK KKK KKK KKK KKK KKK KKK K KKK KK KK SETTING UP THE PROGRAM 8 SPENDING amp ENTERTAINMENT 9 GROCERIES ors m There are three worksheets in this workbook 12 UTILITIES 13 HOME amp LIFE INSURANCE s EXPENSE CALCULATIONS 14 VEHICLE PAYMENTS amp INSURANCE 15 VEHICLE FUEL amp MAINTENANCE m TRANSACTIONS 16 HOUSE amp YARD MAINTENANCE 17 HEALTH GROOM CREDIT CARDS amp DEBTS 19 INVESTMENTS 20 MISC EXPENSES 21 SAVINGS 22 VACATION if f 4 To access each worksheet simply click on the Tab ra IJ title at the bottom of the worksheet 25 ENTER THE LETTER Q WE RECEIVE A CHEQUE ONCE A MON The first sheet you must access in order to set up I WE RECEIVE A CHEQUE EVERY the program is the EXPENSE CALCULATIONS f EFP gP LIST ALL YOUR CREDIT worksheet 34 CREDITCARDSAND DEBTS 4 Ready In the EXPENSE CATEGORIES section of the sheet PROJECTED EXPI EXPENSE CALCULATIONS e
16. cheques become positive again At the same time after those seven weeks the balance in the VACATION category would have increased to 357 68 If any extra income were to be received during that time it could be deposited into SAVINGS to help reduce that deficit If you adhere to this budget you will not find yourself in a situation where for instance you could not afford to go out for dinner because your car insurance was due The funds for your car insurance would have accumulated in your VEHICLE PAYMENTS amp INSURANCE column and the money in your SPENDING amp ENTERTAINMENT category would be intact even if your SAVINGS were temporarily in the hole When one category falls into a negative balance the other categories may still continue to grow and satisfy the goal of your budget which is to ensure that necessary funds will be available when payments become due MONTH END At the end of each month you will have a detailed record of all your expenses and income as well as a current statement of the funds available in each EXPENSE CATEGORY Itis VERY IMPORTANT that you compare your records with your Bank Statement either on line or with the statement you receive by mail at the end of the month Insure that every item shown on your Bank Statement has been entered in your budget and that the balance in your Bank chequing account matches the BALANCE shown in your budget For instance Bank Service Charges will have been deducted from your cheq
17. d automatically in the TRANSACTIONS worksheet of the program They will automatically appear as column headings HOME amp LIFE INSURANCE 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 FOAN FOLD 0 00 0 00 0 00 0 00 0 00 4 gt M EXPENSE CALCULATIONS f T
18. ell worthwhile If you have any questions about this program please email me at computerconsulting shaw ca with a subject line PRETTY GOOD BUDGET K KEKE K E K KE K KE KE K E E K E KE KE E KE KE K E KE K E KE K K KE K K E KE K E E K E KE KE E E KE E E E K KE KE K K K K K E E K K K K K K K K K K K K K K K K K K K K K K K K K K K By using this program to manage your personal finances you agree to the following terms This PRETTY GOOD BUDGET PROGRAM is free to use for your own personal finance management and will not be sold to others This program carries no guarantee of financial success Neither Dennis Cooper nor Cooper Computer Consulting will be held liable for any financial problems real or imagined resulting from the use of this program You may share this program with others whom you feel might benefit from it but if you forward the budget template to others you must forward this USER GUIDE as well You must not alter the program or this USER GUIDE or manipulate the formulas in the program If you do not agree with these terms you must delete the program from your computer I sincerely hope you will find this program helpful in managing your finances and if you do please tell others about it so they might benefit from this program as well PLEASE NOTE AMOUNT BALANCE VERIFY BALANCE VERIFY 417 31 tances reser eao While entering data in this Spreadsheet 1f numbers Format Tools D
19. examine them for interest charges and make sure you record these charges as DEBITS in the CREDIT CARDS amp DEBTS sheet ENTERING CREDIT CARD PAYMENTS AS TRANSACTIONS Any payments recorded in the CREDIT CARDS amp LOANS worksheet must of course also be recorded in the TRANSACTIONS worksheet in order to maintain an accurate balance of the chequing account as well as to update the available funds in the EXPENSE CATEGORIES In the example below the 76 74 invoice received from Sears is paid on Feb 16 and because the credit card was used to purchase a parka the DEBIT 1s applied to the CLOTHING category This category is now left with a negative balance of 14 60 26 Jan 26 Jan a Jan 28 Jan 30 Jan 30 Jan a0 Jan a0 Jan 30 Jan 31 Jan 1 Feb 1 Feb 1 Feb 5 Feb 5 Feb _15 Feb 16 Feb PARTICULARS Berkshire Investments Home Hardware Sale of Used Computer Future Shop Mew Computer Fay Deposit Car Payment AutoPlan Party Supplies ATH Withdrawl Spending Money Service Charges Pay Deposit ATM Withdrawl Spending Money Mortgage Safeway Esso ar Payment Sears APPLY TO CATEGORY Type click on category above and Enter INVESTMENTS HOUSE amp YARD MAINTENANCE SAYINGS SAVINGS VEHICLE PAYMENTS amp INSURANCE VEHICLE PAYMENTS amp INSURANCE SPENDING amp ENTERTAINMENT SPENDING amp ENTERTAINMENT MISC EXPEMSES SPENDING amp ENTERTAINMENT MORTGAGE RENT GRO
20. expenses than anticipated at the end of the year might have their PROJECTED EXPENSE CALCULATIONS decreased If you find that the required amounts to be deposited in each EXPENSE CATEGORY do not meet your needs feel free to change the values in the PROJECTED EXPENSE CALCULATIONS section on the first sheet EXPENSE CALCULATIONS to adjust these required amounts A budget should be flexible allowing you to make adjustments to meet your own financial demands Remember though that the goal of your budget must be to ensure that necessary funds will be available when payments become due I sincerely hope this PRETTY GOOD BUDGET will help you Good Luck Dennis Cooper If you find that this PRETTY GOOD BUDGET PROGRAM helps in managing your finances please share it with others Dennis Cooper 10542 Seaton Rd Lake Country B C V4V 1K4 250 766 3600
21. ght The reduction of 17 29 in the SAVINGS category has now adjusted the VERIFY column by that amount and VERIFY now equals BALANCE as shown below AMOUNT 1 417 31 1 500 00 23 864 1 476 14 35 00 1 441 14 1 391 14 1 400 00 Derer AFE 79 MHINE aS Remember that if VERIFY is greater then BALANCE the amount put into one or more of the expense categories must be reduced If VERIFY is less then BALANCE the amount deposited into one or more of the expense categories must be increased VERIFY MUST ALWAYS EQUAL BALANCE OTHER CREDITS You may at times receive money other than your Pay Cheque to be deposited in your account This could be a bonus an Income Tax Rebate or in the example below money received from the sale of an item APPLY TO CATEGORY AMOUNT Type click on category above and Enter 1 417 31 Enter current balance in bank account and enter amounts in each category YERIFT must equal BALANCE 2 Jan Safeway GROCERIES 25 06 4 Jan Esso VEHICLE FUEL amp MAINTENANCE 35 00 0 00 5 an ATM Withdrawl Spending Money SPENDING amp ENTERTAINMENT 50 00 0 00 10 Jan London Drugs HEALTH amp GROOMING f 26 35 0 00 15 Jan Pay Deposit 1 400 00 20 56 1f Jan Safeway GROCERIES F40 62 0 00 20 Jan Mortgage MORTGAGE J RENT 4500 00 0 00 22 Jan Esso VEHICLE FUEL amp MAINTENANCE 32 00 0 00 Za Jan BC Hydro UTILITIES 63 00 0 00 23 Jan Terasen Gas UTILITIES 4100 00 0 00 24
22. gn PARTICULARS ii APPLY TO CATEGORY AMOUNT BALANCE Type click on category above and Enter 1 417 31 Enter current balance in bank account and enter amounts in each categorg C YERIFY must equal BALANCE 2 Jan Safeway GROCERIES 4 lJan Esso VEHICLE FUEL amp MAINTENANCE S Jan ATM Withdrawl Spending Moneys SPENDING amp ENTERTAINMENT HEALTH amp GROOMING 5ll 14 Jan Pay Deposit 1 400 00 LEAVE CATEGORY BLANK Each Expense Category contains two columns 1 The left column records credits and debits and the right column will automatically update the balance remaining in that category CREDITS amp DEBITS reflecting each credit or ae ee IN LEFT COLUMNS debit DO NOT ENTER DATA You will never manually enter any data in the right hand columns of the categories as these columns are automatically updated through formulas written in the cells Debits in the left hand columns are also automatically inserted when you apply a category in the APPLY TO CATEGORY column while entering transactions Credits however may be entered automatically or manually in the cells in the left column When your pay cheque is deposited you can manually enter the required amount in the left column of each category a a AMOUNT BALANCE VERIFY EEN amp ENTERTAINMENT GROCERIES MORTGAGE RENT PROPERTY TAXES 4 417 31 ee 100 00 mu Lae za o 34 62 pE The figures appearing in each expense category ba just
23. in column F under TOTAL AMOUNT OWING ENTERING CREDIT CARD TRANSACTIONS You are now ready to begin entering credit card transactions and payments on other loans This is done in the same manner as when entering budget transactions on the previous worksheet Type the DATE and the PARTICULARS of the transaction such as what was purchased or where a payment was made In the APPLY TO CATEGORY column type an equal sign and click on the category at the top of the page to which you will apply the transaction EF Ph chick on category above and Enter SIRE TN 149 830 00 149 830 00 Tap the Enter key on your keyboard and the name of the selected category will appear in the APPLY TO CATEGORY field Enter the amount of the transaction in the CREDIT column 1f it is a payment or in the DEBIT column 1f the amount is being charged If the transaction is a DEBIT be sure to type a minus sign first to enter it as a negative value In the example below a parka was charged to a Sears Card for a value of 59 95 The TOTAL AMOUNT OWING is automatically updated to reflect this charge and the amount of the purchase is automatically recorded in the SEARS column Type chick on catagory above and Enter SETE 28 Jan Winter Parka 149 899 95 149 889 95 In the next example below a Mortgage payment of 800 00 is entered as a CREDIT and the TOTAL AMOUNT OWING is automatically updated as is the amount owing in the MORTGAGE col
24. nter titles for all the THE NAMES OF THE EXPENSE CATEGORIES BELOW MAY expenses you must meet throughout the year The examples BE CHANGED TO SUIT YOUR OWN BUDGET NEEDS preexisting in the worksheet are suggestions for yearly e e e e expense categories but your own list may differ depending Sa CATEGORIES on your personal needs E SPENDING amp ENTERTAINMENT GROCERIES MORTGAGE RENT Simply replace the text in any of these categories that do not PROPERTY TAXES apply to your needs with more appropriate titles For E EE SURNE example if you do not own a home and therefore do not 14 VEHICLE PAYMENTS amp INSURANCE pay property taxes you might replace that category with VERITE FUEL MAINTENANCE A A a HOUSE amp YARD MAINTENANCE Pet Expenses Ski Pass Golf Club Fees or some other EAL TILE GROOMING expense for which you must set aside funds You must limit CLOTHING INVESTMENTS your expense categories to 16 so it may be necessary to MISC EXPENSES combine similar expenses under one title 21 SAVINGS VACATION CHRISTMAS Do not rearrange these categories by cutting and pasting but rather retype the titles in this section if necessary If you have less than 16 expense categories simply enter a letter X in place of unneeded category spaces at the bottom of the list EXPENSE CATEGORIES As category titles are entered in the EXPENSE CALCULATIONS worksheet they are also entere
25. ory in the APPLY TO CATEGORY cell rather than typing and clicking on the selection If you do be certain to type the name of the category exactly as written in this list or the formulas in the program will not recognize your entry Do not type the sign if you choose this option FEHICLE PATMENTS amp INSURANCE __ 200 Nn Type click on category above and Enter 1 417 31 Enter current balance in bank account and emg amounts in each category YERIFYT must equal BALANCE Jan Safeway ROLCERIES 4 Jan Essa Enter the amount of the transaction and remember to type a minus sign first if it is a debit In the example below the transaction of 35 00 has been automatically deducted from the VEHICLE FUEL amp MAINTENANCE expense category and the balance in that category has been automatically reduced from 75 00 to 40 00 APPLY TO CATEGORY AMOUNT VEHICLE FUEL amp MAINTENANCE 2006 Type click on category above and Enter 1 417 31 Enter current balance in bank account and enter amounts in each category YERIF T must equal BALANCE 5 00 3 J Jan Safeway GROCERIES 0 00 75 00 4 Jan Esso VEHICLE FUEL amp MAINTENANCE 35 00 40 00 In the following example 30 00 was spent in one receipt on Jan 25 at London Drugs 20 00 of this amount was for hand soap and shampoo but the other 10 00 was for canned soup and crackers In a case like this you do not need to obtain separate receipts for
26. percentages are automatically determined by formulas in the program so never change them on this sheet If the amount of your deposit is less than the required amount to meet your expenses based on your PROJECTED EXPENSES and the frequency of your pay cheques the amount placed in each category will be less than the amount displayed in each EXPENSE CATEGORY title If the deposit 1s more than required though each EXPENSE CATEGORY will receive more w OF TOTAL DEPOSIT 10 am aE L 10 58 52 26 05 05 2 44 44 L 11 40 40 AMOUNT AMOUNT Cara amp ENTERTAINMES GROCERIES MORTGAGE RENT PROPERTY TAXES ii LIATI 417 31 150 00 369 23 34 62 1 400 00 In the example above the amount normally allotted to SPENDING amp ENTERTAINMENT is 150 00 as displayed under the category title As the deposit of 1400 00 is less than the required bi weekly deposit of 1417 31 displayed under AMOUNT however the automatic allocation of funds would place 148 17 into that category rather than 150 00 If you would prefer to have more control over the amount going in to each EXPENSE CATEGORY and wish to raise the amount in some categories and lower it in others you can enter the division of the deposit into the expense categories manually ENTERING CREDITS MANUALLY If you choose to enter your credit manually you will leave the APPLY TO CATEGORY cell blank Enter the amount of your deposit as a positive number with no minus si
27. tion in order to accurately reflect the new balance in the SEARS account which is 0 00 Type click on category above and Exter APPLY TO CATEGORY 2o Jan Winter Parka 1 Feb Mortgage Payment MORTGAGE 149 069 95 15 Feb Car Payrient CAR LOAN 146 739 95 20 Feb DVD virite 145 099 95 146 823 21 Interest charges must also be deducted from any mortgage or loan payments entered as a CREDIT In the example below a mortgage payment CREDIT of 800 00 was recorded on Feb 1 and a Car Loan payment was entered as a CREDIT on Feb 15 However when the bank statement is received at the end of the month it is revealed that 240 00 of the mortgage payment and 75 00 of the Car Loan payment was applied to interest rather than principle These interest payments must therefore be recorded as DEBITS in order to accurately reflect the balances of money owing T TOTAL AMOUNT OWING CARLOAN _ Bere Bee 149 830 00 26 000 00 28 Jan Winter Parka 149 889 95 26 000 00 1 Feb Mortgage Payment MORTGAGE 149 089 95 26 000 00 15 Feb Car Payment CAR LOAN 148 739 95 25 6450 00 20 Feb DVD Writer FUTURE SHOP 145 599 95 25 650 00 26 Feb Payment SEARS 146 823 21 25 650 00 AR 145 840 00 25 650 00 Tere STON Ae ars Arron AF wo H 20 Feb Mortgage Interest MORTGAGE 240 00 149 080 00 28 Feb interest on Car Payment CAR LOAN 75 00 B24 725 00 Whenever invoices for credit cards or bank statements are received be sure to
28. uing account so these charges must be entered in your budget HOME amp LIFE wsunance saves SSS PARTICULARS Cooper Computer Consulting Computer Lessons Custom Training Videos Virus Removal Matvare Removal Computer Security Pile Restructuring Reformatting Sottware amp Hardware Installation Custom Spreadsheet Programs Budget Templates Photo Restoration image Manipulation Web Design Dennis Cooper n 250 766 3600 tutor cablelan net mo 0i om a eet e 22 Jan 2a Jan Essa At Hydro APPLY TO CATEGORY fype chick on category above and Enter YVEHICLE FUEL amp MAINTENANCE UTILITIES AMOUNT 1 417 31 1 892 17 1 829 17 E o0 0 00 1 729 17 T29 0 00 1 682 17 682 0 00 1 662 17 BBZ 0 00 1 652 17 652 0 00 1 552 17 552 0 00 1 509 42 509 0 00 1 859 42 859 0 00 1 109 42 109 0 00 2 609 42 609 150 00 2 259 42 259 0 00 2 196 42 196 0 00 2 117 92 117 478 50 2 017 92 EET 4100 00 2 003 92 003 0 00 3 453 92 453 1450 00 3 453 92 453 0 00 3 453 92 453 0 00 dh 3 453 92 453 0 00 3 453 92 453 0 00 3 453 92 453 0 00 3 453 92 453 0 00 3 453 92 453 0 00 UTILITIES HOME amp LIFE INSURANCE HEALTH amp GROOMING GROCERIES INVESTMENTS HOUSE amp YARD MAINTENANCE SAVINGS SAVINGS 23 Jan Terasen Gas 2 4 Jan Greatest Life 26 Jan London Drugs 26 Jan Berkshire Investments 26 Jan Home Hardware 2f Jan Sale of
29. umn pe cinka on catego above and Enter PPLY TO CATEG MORTGAGE eh EE 00 28 Jan Winter Parka 59 95 mn 1 Feb Mortgage Payment MORTGAGE snaa 800 00 i E 089 a aE zo A car Payment below is recorded in the same manner as the Mortgage payment and the CREDIT is reflected in the CAR LOAN column Type cick on category above and Enter 149 630 00 a 2o Jan Winter Parka SEARS 149 999 95 26 000 00 1 Feb Mortgage Payment MORTGAGE F1 49 089 95 t26 oog 00 15 Feb Car Payment CAR LOAN 145 739 95 p25 650 00 ADJUSTING FOR INTEREST CHARGES It is very important to remember when charging an item to a Credit Card or making a mortgage payment or car loan payment that the amount of the CREDIT transaction will be offset by a DEBIT interest charge These interest charges must be accounted for when recording CREDIT CARD amp LOAN transactions In the example below the original cost of the parka charged to the Sears credit card was 59 95 However when the Sears invoice arrives interest charges and other fees have increased the required payment to 76 74 The payment of 76 74 recorded on Feb 26 was applied as a CREDIT against the original charge of 59 95 in the SEARS column and it appears as though there is now a positive balance of 16 79 in that column The additional charges that were added to the original invoice however have not yet been recorded These interest charges must now be entered as a DEBIT transac
30. under the title are the amounts determined by your PROJECTED EXPENSES and the frequency of your pay cheques to be set aside in order to meet your expenses You can enter that amount in the left column of each category on the same line as your pay deposit But you may increase or decrease the specified amounts as you enter them depending on the amount of the deposit If your deposit is less than required you will enter less in some categories and if it is more you will enter more VERIFY THE BALANCE Once you have deposited amounts into each EXPENSE CATEGORY you must verify that the balance of funds in all categories is the same as the BALANCE in your account AMOUNT BALANCE VERIFY 1 417 31 In the example on the right the amount in the VERIFY column 1 500 00 after the Pay Deposit is 17 29 more than the BALANCE in the 23 86 1 476 14 359 00 1 441 14 450 00 1 391 14 account This indicates that the amount of the Pay Deposit was not enough to allow the required amount to be entered into each 96 35 category One of the categories will have to be adjusted to reflect 51 ano o0 that shortfall of 17 29 ems The required amount to be set aside for SAVINGS is 46 15 and that was the amount entered as shown in the Mon on the left However in order to adjust for the difference of 17 29 as determined above this 46 15 must be reduced by the shortfall of 17 29 to 28 86 as shown in the example on the ri
31. y bi weekly or monthly pay cheque the program will automatically determine how much money must be allocated from each pay cheque for each expense category in order to cover all your yearly expenses For example a deposit every two weeks would be automatically divided as shown below in order to meet the PROJECTED EXPENSES entered in the earlier sample For instance to ensure that Property Taxes of 900 00 would be available when due 34 62 must be set aside from each bi weekly cheque Based on the PROJECTED EXPENSES and the frequency of deposits the amounts needed for each category are calculated by the program and automatically entered below each category heading in the TRANSACTIONS worksheet Never manually alter these amounts shown on the TRANSACTIONS sheet Formulas in the program will automatically calculate all these amounts for you The total amount of money that must be deposited from your pay cheque is also automatically calculated and entered on this sheet based on the PROJECTED EXPENSES and the frequency of your cheques aaa APPLY TO CATEGORY AMOUNT BALANCE Type click on catagory above and Enter EE p amounts in each category YERIFY must equal E EPP E Te 0 00 In this example in order to meet your PROJECTED EXPENSES with a bi weekly pay cheque you must deposit 1417 31 into your chequing account every two weeks The HARSH REALITY of a budget is that if you do not earn the amount calculated b
32. y the program to meet your PROJECTED EXPENSES you must either CUT BACK YOUR EXPENSES or find a way to EARN MORE MONEY If the amount needed for your budget is more than you are earning then you must adjust the calculations for your PROJECTED EXPENSES You may have to cut back on your Savings Vacation Clothing or Christmas plans and perhaps re examine your personal spending habits If the amount needed for your budget is less than you earn then you can put more money aside in the Savings Investments or Vacations categories If you are working in a profession where your income fluctuates and is different with each pay cheque you may find that you will be short of the required deposit on one pay cheque but you may earn extra on the next In this case you will simply adjust your deposits so that categories that are shorted on one pay cheque will be compensated on the next Remember that the purpose of a budget is not to simply track your spending but to ensure that funds will be set aside to cover all of your expenses no matter how often you are paid CREDIT CARDS AND CREDITORS In the next section of the EXPENSE LIST ALL YOUR CREDIT CARDS AND CREDITORS CALCULATIONS worksheet you will list all CREDIT CARDS AND DEBTS n your credit cards and creditors any money that you owe SA CREDIT CARDS AND DEBTS M MASTER CARD MERICAN EXPRESS Enter the names of all the credit cards you have SEARS even if they currently carry
Download Pdf Manuals
Related Search