Скачать или смотреть (Part 3) Build it with Me: Automated Budget Spreadsheet (Monthly Income Entry and Tracking)

The most automated personal budget spreadsheet: Enter Income and Recurring Expenses only once, the formulas do the rest! Calendar view automatically updates every month. Transactions Table pulls in your predefined settings once you select the description from the drop down.

This is the third video in my Build it with me: Automated Budget Spreadsheet series. In this video, we set up the Start Here Tab with dropdown, and write the formulas for the Income Entry portion of the dashboard on the Budget Items tab.

Purchase the completed template at: https://slickspreadsheets.etsy.com/li...

00:00 - Intro
2:39 - Start Here Tab
4:54 - Dashboard Moving Timeline, (edate)
7:41 - Primary, Secondary, Tertiary Income User Entry Setup (conditional formatting)
10:54 - Pay Periods per month (begin Nested If statement with absolute reference)
12:28 - Calculating # of weekly pay periods in a month
17:02 - Calculating # of Every 2 Weeks pay periods in a month
27:33 - Calculate total monthly income
28:27 - Outro

#googlesheets #budgetplanner #budgeting2024 #spreadsheet