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.
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.
Monthly Budget Template
The monthly budget template has sheet tabs for entering transactions as they occur and then displaying a summary of those transactions.
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.
You can also take advantage of the Planned and Actual features of the model to see how well you estimate your monthly budget.
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.
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.
You will then see a preview as the year progresses with that model.
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.
The Income section contains slots for wages, interest, dividends, and gifts to cover where the money came from.
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.
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.
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.
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.
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”.
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.
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:
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.
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.
Optionally add a message, click “Send”, and those you share with will receive an email with a direct link to the sheet.
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!