GOOGLE SHEETS FOR HOUSEHOLD BUDGET HOW TO
GOOGLE SHEETS FOR HOUSEHOLD BUDGET DOWNLOAD

As you add transactions, the dashboard will automatically update, including the pie charts for income and expenses.

Make sure to choose a category from the dropdown for each transaction.

In the month sheet, add all of your expense transactions for the month in the Monthly Expenses panel and add all of your income transactions for the month in the Monthly Income panel.

Next, navigate to the monthly Income & Expenses sheet by clicking on the tabs at the bottom with the correct month name.

Then, add up to 10 income categories and enter your estimated monthly income in each category.

Start in the Dashboard by adding and editing up to 15 expense categories and your planned monthly spending in each category.

The personal budget template will then appear in your Google account.

In the Google Sheets window, click the Make A Copy button.

GOOGLE SHEETS FOR HOUSEHOLD BUDGET DOWNLOAD

Click the Download Budget Template button in the email, and then on the Gumroad product page, click on the link to save the budget template to your Google Account.You will immediately receive an email from Gumroad. On the next page, enter your email address and click Get.Go my Gumroad listing and click the I Want This button.

GOOGLE SHEETS FOR HOUSEHOLD BUDGET HOW TO

How to download my personal budget template

View your planned versus actual savings for that month.

Compare your actual versus planned monthly spending for each category.

Enter each of your transactions (expenses and income) for that month.

On each monthly income & expenses sheet, you can:

View your savings over the entire year.

View your monthly spending trends by category over the entire year.

View your average expenses over the entire year.

View your monthly income, expenses, and savings trends over the course of the year.

Add up to 10 income categories and enter your estimated monthly income in each category.

Add up to 15 expense categories and enter your planned monthly spending in each category.

Home Budget Worksheet - Our original selection of home budget worksheets.Get my ultimate monthly personal budget template for Google Sheets for free! On the dashboard, you can:.

Personal Budget Spreadsheet The 12-month version of the personal budget version.Personal Monthly Budget - Like the one above, but less detailed, and designed to fit on a single page.Family Budget Planner - This is the 12-month version of the household budget spreadsheet listed above.Money Management Template - Record transactions to automatically populate the budget vs.If you add or remove any categories, just make sure that the formulas used for the totals don't get messed up. If your Net is negative, that means you have overspent your monthly budget.Īdding or Removing categories: The household budget template contains a very detailed list of categories, which you may or may not need. The Monthly Budget Summary table totals up all your income and expenses and calculates the Net as Income minus Expenses. 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.

In this spreadsheet, the calculations are set up so that negative numbers are bad. The cells in the 'Difference' column use conditional formatting to make negative numbers red. At the end of the month, you record in the 'Actual' column how much you really spent during the month. This represents your goal - you're trying to keep from spending more than this amount. You record your desired budget for each category in the 'Budget' column. The purpose of this worksheet is to help you compare your monthly budget with your actual income and expenses. You may also want to read the article ' How to Budget'. Our article ' How to Make a Budget' explains how to use these spreadsheets to create your budget. You'll want to replace the values in the Home Expenses category with your own. To use this template, fill in the cells highlighted with a light-blue background (the 'Budget' and 'Actual' columns). 42 Effective Ways to Save Money Budgeting Tips for the New Year Using the Household Budget Worksheet

Google sheets for household budget