If you are in need of a detailed budget worksheet with a large variety of budget categories, our Household Budget Worksheet for Excel, Google Sheets or Open Office will help you compare your actual spending to your intended budget on a monthly basis. If you prefer to create a budget for the entire year, use our family budget planner. For budget worksheets that cater to individuals rather than households, try the yearly personal budget spreadsheet or the personal monthly budget template.
To use this template, fill in the cells highlighted with a light-blue background (the “Budget” and “Actual” columns). You’ll want to replace the values in the Home Expenses category with your own. Our article “How to Make a Budget” explains how to use these spreadsheets to create your budget. You may also want to read the article “How to Budget”.
The purpose of this worksheet is to help you compare your monthly budget with your actual income and expenses. You record your desired budget for each category in the “Budget” column. This represents your goal – you’re trying to keep from spending more than this amount. At the end of the month, you record in the “Actual” column how much you really spent during the month.
The cells in the “Difference” column use conditional formatting to make negative numbers red. In this spreadsheet, the calculations are set up so that negative numbers are bad. If you spend more than you budgeted, the Difference between the Projected and Actual values will be negative, and if your Actual income is less than your Projected income, the Difference will be a negative number.
The Monthly Budget Summary table totals up all your income and expenses and calculates the Net as Income minus Expenses. If your Net is negative, that means you have overspent your monthly budget.
Adding or Removing categories: The household budget template contains a very detailed list of categories, which you may or may not need. If you add or remove any categories, just make sure that the formulas used for the totals don’t get messed up.