PDF download Download Article PDF download Download Article

This wikiHow teaches you how to create a record of your expenses, income, and balance on a day-to-day basis using Microsoft Excel. There are personal budget templates that you can use to speed up the process, or you can create your own personal budget file from scratch.

Method 1
Method 1 of 2:

Using Templates

PDF download Download Article
  1. It's a dark-green app with a white "X" on it.
  2. It's at the top of the Excel window.
    • On Mac, first click File in the upper-left corner, then click New from Template… in the drop-down menu.
    Advertisement
  3. Doing so will bring up a list of personal budget pre-made templates.
  4. Click on a budget template whose title and preview both look like they'll suit your needs. This will open the template's page, where you can review more information about the template.
    • "Expense budget" and "Basic personal budget" are two excellent templates in this context.
  5. It's to the right of the template's image. Doing so will open the template in Excel.
  6. This step will vary depending on your selected template; most templates will allow you to list your expenses and their respective costs, and then calculate your total spending.
    • Most templates come with built-in formulas, so any changes that you make to one part of your template will update everywhere else.
  7. Once you've completely created your budget, all that's left to do is save it onto your computer. To do so:
    • Windows - Click File , click Save As , double-click This PC , click a save location on the left side of the window, type the document's name (e.g., "Personal Budget") into the "File name" text box, and click Save .
    • Mac - Click File , click Save As... , enter the document's name (e.g., "Personal Budget") in the "Save As" field, select a save location by clicking the "Where" box and clicking a folder, and click Save .
  8. Advertisement
Method 2
Method 2 of 2:

Making a Manual Budget

PDF download Download Article
  1. It's a dark-green app with a white "X" on it.
  2. You'll find this in the upper-left side of the page.
    • On Mac, skip this step if a blank Excel presentation opens when you open Excel.
  3. Starting with cell A1 in the top-left corner of the sheet, enter the following:
    • A1 - Type in "Date"
    • B1 - Type in "Expense"
    • C1 - Type in "Cost"
    • D1 - Type in "Income"
    • E1 - Type in "Balance"
    • F1 - Type in "Notes"
  4. In the "Expenses" column, type in the name of each expense that you know of (or anticipate) for at least a month, then enter the cost of each expense in the "Cost" column across from the pertinent expense names. You should also enter the date to the left of each expense in the "Date" column.
    • You can also just type in a month's worth of dates and only fill in the cells in which you have expenses.
  5. For each date, enter the amount that you'll earn on that day in the "Income" column. If you won't earn anything, just leave the cell for that day blank.
  6. Taking into account how much you've spent and how much you've earned on any given day, enter the remaining total in the "Balance"
  7. If any payment, balance, or day has a different outcome than usual, make a note of it in the "Notes" column to the right of the row in question. This will help keep unusual or large payments easy to remember.
    • You might also type "Recurring" next to a row containing an expense for a subscription or a monthly (or weekly) service.
  8. Click the first empty cell below the "Cost" column, then type in the following: =SUM(C2:C#) where "#" is the number of the last filled cell in the "C" column. Press Enter when you're done to enter the formula and display the total cost of all of your expenses in this budget.
    • You'll use this same exact formula for the "Income" and "Balance" fields as well, except that you'll use "D" and "E" respectively instead of "C".
  9. Once your budget is complete, you just need to save it on your computer. To do so:
    • Windows - Click File , click Save As , double-click This PC , click a save location on the left side of the window, type the document's name (e.g., "Personal Budget") into the "File name" text box, and click Save .
    • Mac - Click File , click Save As... , enter the document's name (e.g., "Personal Budget") in the "Save As" field, select a save location by clicking the "Where" box and clicking a folder, and click Save .
  10. Advertisement

Expert Q&A

Search
Add New Question
  • Question
    Why do my budgets never turn out correct?
    Samantha Gorelick, CFP®
    Financial Planner
    Samantha Gorelick is a Financial Planner based in New York, New York. She is the Owner of Take Root Financial, a firm that provides accessible financial coaching and advocacy to help clients feel rooted in their financial lives. Before starting Take Root, she was the Lead Financial Planner at Brunch & Budget, a financial planning and coaching organization. She also spent 4 years working at Heron Wealth as a Wealth Advisor. Samantha has 10 years of experience in the financial services industry and has held the Certified Financial Planner™ designation since 2017. Samantha specializes in personal finance, working with clients to understand their money personality while teaching them how to build their credit, manage cash flow, and accomplish their goals. She received a Certificate in Financial Planner from the NYU School of Professional Studies and received a BA from Bard College.
    Financial Planner
    Expert Answer
    A lot of people make the mistake of being unrealistic about how much they actually spend every month. Sit down and take a serious look at your spending habits over the course of the past 3-6 months before making your budget so you have a sense for what you can cut back on.
Ask a Question
      Advertisement

      Tips

      • This is also possible using templates in Google Sheets if you don't have access to Microsoft Excel.
      • The formulas in both the template version and the manual version of the personal budget should recalculate the total at the bottom of a column if you change one of the column's numbers.
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Thanks for submitting a tip for review!
      Advertisement

      Warnings

      • Your budgets will most likely turn out to be a little bit inaccurate, as there is almost always an expense that you'll forget about or have to add in later.
      Advertisement

      About This Article

      Article Summary X

      1. Open Excel.
      2. Search for a budget template.
      3. Select a template and click Choose .
      4. Fill out the template.
      5. Save the file with a new name.

      Did this summary help you?
      Thanks to all authors for creating a page that has been read 570,910 times.

      Is this article up to date?

      Advertisement