Couldn't save up enough money? Often ending up the month with a bad check? If you want to take control of your spendings and achieve your financial goals, you need to start planning your budget. And Google Sheets is a great free alternative to different financial apps that often have to be paid!
To follow along our tutorial, make your copy of the practice sheet: https://bit.ly/rw-budget-tracker
Watch the next part of our Budget Series on how to Plan a Budget here: https://youtu.be/12-q_I7N6JY
After watching this video, you’ll learn how to:
Work with the budget tracking templates
Follow your personal income and expenses
Use different Gsheets functions
Transfer data fromone sheet to another
Timestamps on how to:
0:00 Why to start Budgeting
0:10 What is a Personal Budget
0:38 Why to use Google Sheets for Personal Budget Management
0:48 What you'll learn in this video
1:08 How Budget Tracking Works
1:28 Template structure
2:09 Define your Income Sources
2:49 How to create a dropdown list in Google Sheets
3:33 Gsheets Shortcut for the today's date
4:17 Types of Expenses
4:50 Savings and Financial Goals
5:35 Total your expenses and income using the SUM/SUMIF functions in Google Sheets
9:04 Summary
Read Railsware article about Google Sheets: https://bit.ly/gsheets-article
Watch our videos on SUM https://youtu.be/PzNglh81NAM functions in Google Sheets!
Try Coupler.io for the safe data import from various tools to GSheets. Visit Coupler.io website for more details: https://bit.ly/best-gsheets-addon
Join Railsware team http://bit.ly/railswarecareers
We’d love to hear from you! Share your cases of dealing with your personal budget in the comments Make sure to subscribe to Railsware Product Academy and hit the bell button to learn more spreadsheet tips from our next videos!
Design and video production: Oleg Gorovoi
Case creator: Natalia Gorovaia
Speaker: Karina Plastun
#PersonalBudget #GoogleSheetsBudgetTemplate #HowToTrackBudget #GoogleSheetsTutorial