How to Make and Share a Family Budget in Google Sheets

0

If you want to create a budget and share it with your roommates, Google Sheets is a great option. Use a template or build a budget from scratch, then share it so you can all work on it together.

Use a Google Sheets budget template

Google Sheets makes it easy to set up a monthly or yearly budget with its templates. On the main page, select the template gallery at the top.

Google Sheets Template Gallery

You will see Monthly Budget and Yearly Budget options in the Personal section. Choose one and it will immediately open for you to get started.

Google Sheets Budget Templates

Monthly Budget Template

The monthly budget template has sheet tabs for entering transactions as they occur and then displaying a summary of those transactions.

Google Sheets Monthly Budget Summary

When entering your income and expenses, you can select a category from the drop-down list. This helps the summary sheet give you an overview of where your money is coming from and where it is going.

Google Sheets Monthly Budget Transactions

You can also take advantage of the Planned and Actual features of the model to see how well you estimate your monthly budget.

Google Sheets Monthly Budget Income and Expense Summary

Annual budget template

Similar to the template above, an annual budget template lets you view your income and expenses throughout the year. You have separate sheet tabs for income and expenses as well as a summary tab to see the whole year.

Google Sheets Annual Budget Spending

Simply enter the amounts in the categories provided for incoming and outgoing money. Rather than a detailed monthly view by entering transactions as you go, you enter amounts for the month.

Google Sheets Annual Budget Revenue

You will then see a preview as the year progresses with that model.

Google Sheets Annual Budget Summary

Use a third-party budget template

If you’re looking for a different type of budget template, a third-party option might be the way to go. Vertex42 offers free Google Sheets templates for family, personal, project, and weekly budgets. Let’s check one out.

RELATED: How to Create Expense and Income Spreadsheets in Microsoft Excel

This family budget planner template is a good option to see everyone’s income and expenses at a glance.

Vertex42 Family Budget Planner

The Income section contains slots for wages, interest, dividends, and gifts to cover where the money came from.

Vertex42 Family Budget Planner Income

You can then use the Towards Savings section for money you want to set aside for emergencies, retirement, or investments.

Move on to the expense sections that are broken down by type. So you have domestic expenses, children, daily life, transport, health, etc.

Vertex42 Family Budget Planner Savings and Expenses

To see how the money is flowing, you have a nice summary section at the top with totals, net, and balances for expenses and savings.

Summary of Vertex42 Family Budget Planner

Check out the Help tab for tips on how to get started with this helpful family budget planner template.

Create a budget from scratch

If after looking at Google spreadsheets and third-party templates, you don’t see one that quite suits your needs, you can create one from scratch. Google Sheets offers useful functions for adding income and expenses as well as subtracting amounts for remaining money.

RELATED: 9 Basic Google Sheets Functions You Need to Know

While there are different ways to set up your budget sheet, depending on the type of items you want to track, you can create a simple income and expense budget sheet for your household or family. Select a blank sheet, then give it a name.

Name a Google Sheet

For a monthly budget, enter the months in a row at the top of the sheet. You can then use an income section with the types of income listed in the first column and an expense section with those types in the first column.

Income, expenses and month in one sheet

At the bottom of each section, you can add totals. Select the cell where you want the total expenses, click the Functions button on the toolbar and choose “Sum”.

Sum from the Functions drop-down menu

Select the cell range for the total and press Enter or Return. You can use the fill handle to drag the formula to the remaining cells on the right. Then do the same for the expense section.

SUM function for total revenue

If you want, you can subtract the total expenses from the total income at the very bottom of the sheet. Select the cell where you want this difference and enter the subtraction formula. In our case it is:

=B7-B14

Subtraction formula for remaining money

You can then see how much money is left at the end of each month.

If you want more details about your income and expenses, you can also add totals for each line. For example, you can see the total salary amount as it increases throughout the year. Or, you can add sections for savings and investments or various sections for different types of expenses.

Revenue totals for a line

Since you’re creating this budget from scratch, you can make it as detailed or detailed as you want. The basic functions of Google Sheets can help you with the calculations you need.

Share the budget

Whichever option you choose to create your budget in Google Sheets, sharing is simple. You can provide those you share with access to make edits, allowing them to add their own amounts. Alternatively, you can just grant them access to view the budget if you prefer.

RELATED: How to share documents on Google Docs, Sheets and Slides

Select the Share button at the top right of the workbook and enter email addresses or contact names. On the right, use the drop-down menu to grant permissions to the sheet for each person.

Share permissions in Google Sheets

Optionally add a message, click “Send”, and those you share with will receive an email with a direct link to the sheet.

Share option with message

Keeping track of your budget is important for good money management. And with Google Sheets, you can create a budget in minutes.

For other ways to use Google Sheets, also learn how to create your own calendar!

Share.

Comments are closed.