Uploaded May 2023 | Updated September 2026, 2 weeks ago
#excelbasics
#incometracker
#gigworktracker
Do you have multiple income sources that you need to easily keep track of? Do you do gig work that you need to track? What about your expenses? Or a budget? In this video, i show you how to easily create a basic, but very powerful, spreadsheet that will make keeping up with your money an absolute snap! Enjoy, and please comment and let me know what you think!
Hope you guys enjoy this!
👉 If you enjoy this video, please like and share it.
👉 Don't forget to subscribe to this channel for more updates.
👉 Subscribe now: cutt.ly/mOW7myv
*** TIMESTAMPS ***
00:00 - how to create a self employed gig work income and expense tracker
00:44 - overview of the final product
01:16 - choosing your spreadsheet program
01:38 - creating the basic spreadsheet layout
16:21 - formatting Excel cells to show currency
21:10 -calculating weekly totals for one income category
23:17 - calculate year to date (YTD) totals for all income sources
24:35 - calculate daily income averages
33:33 - how to create a separate worksheet for bills and expenses
43:04 - how to figure out the daily over/under for your budget and weekly income tracker
Help support the channel!
Scott's Computer Stuff wish list: amazon.com/hz/wishlist/ls/2CUVNWTUF9J12?ref_=wl_share
Scott's YouTubey stuff wish list:
amazon.com/hz/wishlist/ls/POI6B4LK90RH?ref_=wl_share
💢 ALL the tools that I *highly* recommend and use personally every day...
Hardware ---
◼ 142-piece magnetic electronics precision screwdriver set with 120 bits
👉 amzn.to/3exdNeb
◼ StarTech 4-bay USB 3.0 hard drive docking station 6Gbps
👉 amzn.to/3z6zNpG
◼ StarTech 2-bay USB 3.0 hard drive docking station SATA 6Gbps
👉 amzn.to/3sAGZt0
◼ Netgear A6100 wifi adapter
👉 amzn.to/3DWUp5p
◼ Godshark NVME to USB adapter M.2 SSD to Type-A USB 10Gbps
👉 amzn.to/3FGw3O8
◼ Cordless, rechargeable air duster 6000mAh 10w fast-charging
👉 amzn.to/3pzJWIa
💢 Helpful/useful everyday software ---
◼ Back up your CRITICAL data automatically with Carbonite!
👉 bit.ly/3qvWMqe
◼ Ninite (used to automatically download and install your favorite software):
👉 ninite.com
◼ Defraggler (used to defragment and organize your files):
👉 defraggler.com
◼ Open Office (Microsoft Office FREE replacement)
👉 openoffice.org
💢 Hey, do you want even MORE in-depth techie stuff? Check out my friend Nico's page, Nico Knows Tech:
👉 youtube.com/nicoknowstech
💢 FOLLOW ME ON SOCIAL MEDIA:
✔ Twitter: twitter.com/AskMeComputers
✔ Facebook: facebook.com/askyourcomputerguy
✔ LinkedIn: linkedin.com/in/ask-your-computer-guy-953248217
✔ Instagram: instagram.com/askyourcomputerguy
✔ Discord: discord.gg/jPwMdc3MVW
*** Affiliate link notice ***
Some links included in this video are affiliate links. The creator may make a small percentage
from any products you purchase through one of these links. This comes at ZERO extra cost to you, and greatly helps to support the growth of this channel. Thanks so much for watching!pmyruudaothoo
#excelbasics
#incometracker
#gigworktracker
Do you have multiple income sources that you need to easily keep track of? Do you do gig work that you need to track? What about your expenses? Or a budget? In this video, i show you how to easily create a basic, but very powerful, spreadsheet that will make keeping up with your money an absolute snap! Enjoy, and please comment and let me know what you think!
Hope you guys enjoy this!
👉 If you enjoy this video, please like and share it.
👉 Don't forget to subscribe to this channel for more updates.
👉 Subscribe now: cutt.ly/mOW7myv
*** TIMESTAMPS ***
00:00 - how to create a self employed gig work income and expense tracker
00:44 - overview of the final product
01:16 - choosing your spreadsheet program
01:38 - creating the basic spreadsheet layout
16:21 - formatting Excel cells to show currency
21:10 -calculating weekly totals for one income category
23:17 - calculate year to date (YTD) totals for all income sources
24:35 - calculate daily income averages
33:33 - how to create a separate worksheet for bills and expenses
43:04 - how to figure out the daily over/under for your budget and weekly income tracker
Help support the channel!
Scott's Computer Stuff wish list: amazon.com/hz/wishlist/ls/2CUVNWTUF9J12?ref_=wl_share
Scott's YouTubey stuff wish list:
amazon.com/hz/wishlist/ls/POI6B4LK90RH?ref_=wl_share
💢 ALL the tools that I *highly* recommend and use personally every day...
Hardware ---
◼ 142-piece magnetic electronics precision screwdriver set with 120 bits
👉 amzn.to/3exdNeb
◼ StarTech 4-bay USB 3.0 hard drive docking station 6Gbps
👉 amzn.to/3z6zNpG
◼ StarTech 2-bay USB 3.0 hard drive docking station SATA 6Gbps
👉 amzn.to/3sAGZt0
◼ Netgear A6100 wifi adapter
👉 amzn.to/3DWUp5p
◼ Godshark NVME to USB adapter M.2 SSD to Type-A USB 10Gbps
👉 amzn.to/3FGw3O8
◼ Cordless, rechargeable air duster 6000mAh 10w fast-charging
👉 amzn.to/3pzJWIa
💢 Helpful/useful everyday software ---
◼ Back up your CRITICAL data automatically with Carbonite!
👉 bit.ly/3qvWMqe
◼ Ninite (used to automatically download and install your favorite software):
👉 ninite.com
◼ Defraggler (used to defragment and organize your files):
👉 defraggler.com
◼ Open Office (Microsoft Office FREE replacement)
👉 openoffice.org
💢 Hey, do you want even MORE in-depth techie stuff? Check out my friend Nico's page, Nico Knows Tech:
👉 youtube.com/nicoknowstech
💢 FOLLOW ME ON SOCIAL MEDIA:
✔ Twitter: twitter.com/AskMeComputers
✔ Facebook: facebook.com/askyourcomputerguy
✔ LinkedIn: linkedin.com/in/ask-your-computer-guy-953248217
✔ Instagram: instagram.com/askyourcomputerguy
✔ Discord: discord.gg/jPwMdc3MVW
*** Affiliate link notice ***
Some links included in this video are affiliate links. The creator may make a small percentage
from any products you purchase through one of these links. This comes at ZERO extra cost to you, and greatly helps to support the growth of this channel. Thanks so much for watching!pmyruudaothoo
