How to write a monthly personal budget using OpenOffice.org Calc (spreadsheet)

A budget is simply a plan for where your money will go this month. By giving every dollar a name, you ensure that your dollars don't just walk away. Using OpenOffice.org's Calc program (the spreadsheet program) will make the process of writing a budget simpler.



  • OpenOffice.org software (available for free download)

Open OpenOffice.org Calc. Typically this can be found by clicking the Start menu (on Windows), going to "Programs" or "All Programs", then clicking on OpenOffice.org 2.4 (or whatever version you have installed), and then clicking on "OpenOffice.org Calc". If you do not have a copy of OpenOffice.org, you can download a copy from http://www.openoffice.org
In the first row, type in the following headers. Column A - "Item" Column B - "Income" Column C - "Expenditure" Column D - "Running total"
In the cell D2 (column D, row 2), enter the following formula =SUM($B$2:B2)-SUM($C$2:C2).
Copy the contents of cell D2. Do this by first selecting the cell by clicking it (so that it is highlighted in blue), and then by pressing Ctrl+C or going to the "Edit" menu and selecting "Copy".
Now, select the cell D3 by clicking, and then hold down the shift key and press the down arrow on your keyboard until you have selected, say, the first 50 cells in column D. (All the selected cells with be highlighted.)
Paste the copied contents of D2 into those cells either by pressing Ctrl+V or by going to the "Edit" menu and clicking "Paste". You should now see a zero in every cell that you pasted into. This process so far set up the formulas for the automatic running totals.
Now, start by entering all of the coming month's expected income. Enter a description for the item in column A and the amount in column B. (There is no need to write anything in column C, but one could enter 0, if desired.) For example, if you expect 2 paychecks of $2000 each and then $100 from a tag sale, you might enter the following into the following cells. Cell A2 - "Paycheck 1" Cell B2 - 2000 Cell A3 - "Paycheck 2" Cell B3 - 2000 Cell A4 - "Profits from yard sale" Cell B4 - 100 You should note that column D automatically provides a running total.
Now start entering your projected expenses, preferably in order of importance. Enter a description in column A and the amount in column C. For example, your first 3 expenses might be the following. Cell A5 - "Giving" Cell C5 - 410 Cell A6 - "Food" Cell C6 - 350 Cell A7 - "Mortgage" Cell C6 - 800 Notice that the amount in column D becomes small each time you enter a new amount. The amount shown in column D is how much money you have left.
Continue to enter expenses until every single dollar is spent. If you find that your expenses exceed your income, go back and make adjustments to non-critical budget items to make up for the deficit. If you find that you have extra money after all items are accounted for, then you must come up with something to do with the excess money. (Otherwise it will find a way to simply disappear.) You could use the excess money to save for emergencies, save for retirement, save for children's college education, paying off the house early, saving for Christmas presents, or saving for a vacation.
Spend the amounts in your budget, and no more!



Copyright 2009 by Michael Nehring