How Do I Make a Personal Budget Spreadsheet?

Article Details
  • Written By: A.E. Freeman
  • Edited By: M. Scarbrough
  • Last Modified Date: 01 April 2014
  • Copyright Protected:
    Conjecture Corporation
  • Print this Article
Free Widgets for your Site/Blog
Solar energy currently harnessed for electricity represents less than one-tenth of 1% of global energy production.  more...

April 21 ,  1509 :  Henry VIII became the king of England.  more...

You can make a personal budget spreadsheet by using the spreadsheet software that came with your personal computer or by purchasing an office software package and using the software included with that. Before you can make a personal budget spreadsheet, you will need to determine both your monthly income and your monthly expenses. Some people do this by recording every purchase they make for a month, including any debt payments or bills. Others collect every receipt and divide them into categories, then tally the amounts at the end of the month.

Open the software program. You may be able to find a template for a personal budget spreadsheet online or you can make your own. Prepare one spreadsheet for each month. If you are making your own personal budget spreadsheet, prepare one column for your income for the month. At the top of the column, type "Income." Enter =SUM(A2:A15) in the 16th row, where "A" is the column's letter and "2" and "15" are the row numbers. As you enter your paychecks into the income column, they will automatically be added in the =SUM row.


Create categories for expenses on your personal budget spreadsheet. Common categories include housing costs, utilities, car payments and other transportation, groceries and personal items. Examine your receipts to see what you commonly spend money on and base the categories on that. Determine the amount for each category based on your recorded expenses. Ideally, your expenses will total less than your net income. If they do not, you will have to figure out ways to cut back on certain categories.

Give each expense category its own column. Type the name of the category in the top row of the column and the target amount several rows down the column. In the row above the target, type =SUM(B2:B20), substituting B with the column's actual letter and the numbers with the actual row numbers. Next, in the row below the target expense, type =SUM(B21:B22), where row 21 is the row with the totaled expenses for that category and row 22 is the target amount. The sum will help you see at a glance how much you have left in each category or if you have gone over in any one category.

If you would like, you can also program your personal budget spreadsheet so that it totals all your expenses for the month as well as your targeted expenses and then compares them to your income. In a column to the right of the other columns, in the same row as the expense tallies, type =SUM(B21:Z21), where "B" and "Z" are the first and last expense columns and "21" is the tallied row. Then in the row with the target expense amounts, type =SUM(B22:Z22), which will total all the targeted expenses. Type =SUM(B23:Z23) in the row just below to figure out the difference between your actual and targeted expenses.


Discuss this Article

Post your comments

Post Anonymously


forgot password?