How to Create a Personal Budget Using Microsoft Excel

Table of contents:

How to Create a Personal Budget Using Microsoft Excel
How to Create a Personal Budget Using Microsoft Excel

Video: How to Create a Personal Budget Using Microsoft Excel

Video: How to Create a Personal Budget Using Microsoft Excel
Video: Formulas in Excel 1 - Round Numbers in Excel with Round Function to the Nearest Decimal or Integer 2024, November
Anonim

This article provides a guide on how to record your daily expenses, income, and balances using Microsoft Excel. There are patterns you can use to speed up the process or you can create a personal budget file from scratch.

Step

Method 1 of 2: Using Pattern

Make a Personal Budget on Excel Step 1
Make a Personal Budget on Excel Step 1

Step 1. Open Microsoft Excel

This program has a dark green X icon.

Make a Personal Budget on Excel Step 2
Make a Personal Budget on Excel Step 2

Step 2. Click the search box

This box is at the top of the Excel window.

On Mac, click File in the upper left corner, then click New from Templates… on the drop-down menu.

Make a Personal Budget on Excel Step 3
Make a Personal Budget on Excel Step 3

Step 3. Type budget in the search box, then press Enter

Personal budget pattern options will appear on the screen.

Make a Personal Budget on Excel Step 4
Make a Personal Budget on Excel Step 4

Step 4. Choose a pattern

Click the budget template whose title and appearance match your needs. The pattern page will appear and you can check more information about the pattern.

"Expense budget" and "Basic personal budget" are good choices

Make a Personal Budget on Excel Step 5
Make a Personal Budget on Excel Step 5

Step 5. Click Create

This button is to the right of the pattern image. The pattern will appear in Excel.

Make a Personal Budget on Excel Step 6
Make a Personal Budget on Excel Step 6

Step 6. Fill in your pattern

This step varies depending on your chosen pattern; most patterns can be used to record expenses and expenses and calculate your total expenses.

Most patterns come with a formula so any number changes you make will change the numbers in other parts

Make a Personal Budget on Excel Step 7
Make a Personal Budget on Excel Step 7

Step 7. Save your personal budget

After completing your personal budget, save the file on your computer. To do so:

  • Windows - Click File, click Save As, double click This PC, click the save location on the left side of the window, type the name of the document (for example, "Personal Budget") into the "File name" box, and click Save.
  • Mac - Click File, click Save As…, enter a document name (for example, "Personal Budget") in the "Save As" box, select a save location by selecting the "Where" box, select a folder, and click Save.

Method 2 of 2: Creating a Manual Budget

Make a Personal Budget on Excel Step 8
Make a Personal Budget on Excel Step 8

Step 1. Open Microsoft Excel

This is a program with a dark green X icon.

Make a Personal Budget on Excel Step 9
Make a Personal Budget on Excel Step 9

Step 2. Click Blank workbook

This button can be found at the top left of the page.

On a Mac, skip this step if the Excel file opens automatically when you open Excel

Make a Personal Budget on Excel Step 10
Make a Personal Budget on Excel Step 10

Step 3. Enter a title

Starting from the box A1 in the top left corner, enter the titles below:

  • A1 - Type "Date"
  • B1 - Type "Expense"
  • C1 - Type "Cost"
  • D1 - Type "Revenue"
  • E1 - Type "Balance"
  • F1 - Type "Notes"
Make a Personal Budget on Excel Step 11
Make a Personal Budget on Excel Step 11

Step 4. Enter the expenses and the date of the month

In the “Expenses” column, type the name of the expense you know (or anticipate) for at least one month, then enter the amount of each expense in the “Cost” column according to the expense name. Also note the date of each expenditure in the "Date" column.

You can also type the date for a month and fill in the fields on the date the expenditure was made

Make a Personal Budget on Excel Step 12
Make a Personal Budget on Excel Step 12

Step 5. Enter your income

For each date, enter the amount of money you earned that day in the “Revenue” column. If you get nothing, clear the box.

Make a Personal Budget on Excel Step 13
Make a Personal Budget on Excel Step 13

Step 6. Enter the balance

After calculating the expenses and income per day, enter the amount in the “Balance” column.

Make a Personal Budget on Excel Step 14
Make a Personal Budget on Excel Step 14

Step 7. Add notes

If any payments, balances, or days are not the same as usual, make a note in the “Notes” column to the right of the row. These notes will help you remember large or unusual payments.

You can also type "Regular" to the right of the row containing your regular monthly (or weekly) expenses

Make a Personal Budget on Excel Step 15
Make a Personal Budget on Excel Step 15

Step 8. Enter the formula

Click the first empty box under the “Expenditures” column, then type:

=SUM(C2:C#)

"#" is the last column of numbers entered in the box in column "C". Press Enter when you're done to enter the formula and display the total expenses in this budget.

Use this formula for “Revenue” and “Balance”, but use “D” and “E” instead of “C”

Make a Personal Budget on Excel Step 16
Make a Personal Budget on Excel Step 16

Step 9. Save your personal budget

Once your budget is complete, save it on your computer. To do so:

  • Windows - Click File, click Save As, double click This PC, click the save location on the left side of the window, type the name of the document (for example, "Personal Budget") into the "File name" box, and click Save.
  • Mac - Click File, click Save As…, enter a document name (for example, "Personal Budget") in the "Save As" box, select a save location by selecting the "Where" box, select a folder, and click Save.

Tips

  • You can also use patterns in Google Sheets if you don't have access to Microsoft Excel.
  • The formula in the pattern version and the manual version will recalculate the total at the bottom of the column if you change the number in any column above it.

Recommended: