Create a powerful income/expense gig work tracker spreadsheet EASILY

#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: www.amazon.com/hz/wishlist/ls...
Scott's KZbiny stuff wish list:
www.amazon.com/hz/wishlist/ls...
💢 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):
👉 www.ninite.com
◼ Defraggler (used to defragment and organize your files):
👉 www.defraggler.com
◼ Open Office (Microsoft Office FREE replacement)
👉 www.openoffice.org
💢 Hey, do you want even MORE in-depth techie stuff? Check out my friend Nico's page, Nico Knows Tech:
👉 / nicoknowstech
💢 FOLLOW ME ON SOCIAL MEDIA:
✔ Twitter: / askmecomputers
✔ Facebook: / askyourcomputerguy
✔ LinkedIn: / ask-your-computer-guy-...
✔ Instagram: / askyourcomputerguy
✔ Discord: / discord
** 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

[@summertime11413]

You are an 'Excellent Teacher'! GOD certainly gifted you in this area, for sure🙏🏾🤗. For YEARS I've kept away from Excel because I've always been lousy at Math🙄 .... But you've explained this so clearly. Thank you and bless you.❤🇬🇧 UK

[@AskYourComputerGuy]

Thank you! What a super-sweet thing to say! I'm so glad my video was able to help you out! Sometimes, we just need to know where to start ;)

[@dina-ls1rw]

I watched both the intro video to excel and this one and they were both very helpful! Thank you!

[@AskYourComputerGuy]

Thank you so much! Glad they helped you out :)

[@PawfectLuxurySofas]

That was Excellent ,very well explained and EXACTLY what i needed right now. Thank you soooo much 😊

[@AskYourComputerGuy]

Glad it was helpful!

[@grimsnig]

Wowyou made this so simple to understand. Thank you! You are a really good teacher.

[@AskYourComputerGuy]

You're very welcome!

[@user-wz9hf1zd2v]

Excellent! I can follow a fellow OCD person SO MUCH BETTER than the average teacher. Great! Thank you!

[@AskYourComputerGuy]

😂👍

[@bmanmitch2005]

Thank you , You sir have help me understand excel so much better than most other KZbinrs so far! I am an Excel beginner trying to better my skills

[@AskYourComputerGuy]

Thank you! That means a ton!

[@kathleenmcauley8054]

Thanks for this, love it! And you have a great voice, nice and soothing :) K

[@AskYourComputerGuy]

Thanks for listening

[@LLStacheLarry]

Awesome teacher and showing and explaining.

[@AskYourComputerGuy]

Thank you! That means the world to me! 👍❤️

[@cosmicaurastudios]

was helpful :) I was able to follow along and will be using this moving on into the year, i was using a premade template before but it's nice to be able to know how to start from scratch & i learned a bit as a complete beginner to excel, thank you!

[@AskYourComputerGuy]

Glad it was useful for you! 👍

[@bluevaro505]

I way back in the early 90's built a P&L/Inventory system in Lotus 123. I had no experience with spreedsheet like lotus or anything like it.

[@thatlatinguy9039]

I was tryna keep that running totals for DD in one column and I made a separate column for it. For some reason it didn’t click that I could just place it a t the top of the column until I saw your video. I was always tryna place it at the bottom and couldn’t/haven’t figured out if there is even a way. But thanks to your video, at least I can have everything in one column.

[@AskYourComputerGuy]

Nice! Glad it helped!

[@user-du6gu4kt8z]

This was so GREAT! I have taken hours of Excel classes at work and never gained the knowledge that you shared. You share in a style that is understandable for the average Excel user :) One question...when I do your final formula pulling the Bills sheet to sheet one, I keep getting an error that says there's something wrong with the formula. I've reviewed it a few times and have the correct cell & row references. Was wondering if there is an updated formula or something?

[@AskYourComputerGuy]

Thank you for the compliment! I appreciate that! Check the cell to make sure it says "Bills" not "Bill's". That extra apostrophe about drove me crazy 😂

[@NZdolmiogrin]

The part at 29:40 where you say you have to do it 52 times, you actually dont! if you highlight the dates+the extra rows underneth you can continue the patern using the cross in the right corner. hope this makes sense! Just make sure you are not highlighting rows from above the dates only underneth. you can also continue the pattern for the weekly inserted numbers by doing the same thing! Hope this helps :D

[@AskYourComputerGuy]

If the spreadsheet didn't have blanks where the subtotals, I agree. Doing it your way works, but it will "date" those rows too 🥲

[@NZdolmiogrin]

@@AskYourComputerGuy you just need to copy the blank rows also. Just make sure you copy the 2 blank rows underneath. I have done it myself and worked perfect :) perhaps I’m not explaining myself right. Love the spreadsheet btw has helped me so much!

[@NZdolmiogrin]

@@AskYourComputerGuy perhaps it’s just excel that it works in?

[@AskYourComputerGuy]

Perhaps 🤷‍♂️

[@kernebld5336]

Awesome video, the content provided I can apply to my financial approach for income and expense. Still, I saw you had additional information on your bills sheet beside the daily and weekly calculations. I saw you had something labelled balance sheet can you provide some insight on why you have it on the sheet.

[@AskYourComputerGuy]

Thanks so much, glad you found it useful. What you were probably looking at was my individual credit card notes. I keep up with my balances, due dates and APR just as "notes" for reference. They don't serve any real purpose in the spreadsheet

[@racerx6]

Fixed a friends computer for $100? That is a customer, not a friend!! LOL!!! Great video

[@AskYourComputerGuy]

LOL thx

[@DJaquithFL]

Extremely helpful considering the transition from accounting software from one-time pay over to monthly subscription only. An alternative video might be an idea for free and local financial accounting software. I'm a QuickBooks slave so I'm pretty ignorant in this category of alternatives. Personally I know lots of businesses are trapped on a non-upgradable version of QuickBooks Pro but only if they use an outside payroll service. Otherwise, they're stuck with a monthly or yearly subscription service from now to eternity. It's crazy, Intuit doesn't even sell a one-time pay version of their personal Quicken anymore. Speaking for myself, it's way too invasive for me to have my financials on some third-party website. The banks are regulated whereas these companies are not.

[@AskYourComputerGuy]

Agree. My suggestion is always go on eBay, buy the last version of QuickBooks on CD or DVD, and unless you need "new features and support" (most people don't), use that. Forever. QuickBooks and accounting hasn't changed in 100 years, why do you need to keep paying for "new" stuff that isn't new? 👍

[@kimbo12]

31:52 💀 good news is, it'll only take 52 hours to spreadsheet the year. This video was super helpful, and I only say "52 hours" because of me, being me lol

[@AskYourComputerGuy]

LOL glad you found it useful 👍

[@lp115lp]

Very enlightening! This was the stumbling block I ran into when planning on my online business. I know people who've lost their (physical) businesses due to the IRS and the business owners' accountants screwing-up so that always made me shy away from starting a business and relying on W2 and 1099 (contractor) jobs. 🙂 I just KNEW I had good ideas for businesses after seeing others successfully pursue the same but everytime I searched online for such tools as THIS provides I was scared off. Question though. You noted the need to create a template with 52 sections (weeks). Are there any automated tools to do the repetitive functions - plug and play template creators? And automated tax accounting?

[@AskYourComputerGuy]

I'm sure there are and honestly I wish I knew them. This started out as basically a plus and minus column type of thing and it evolved into what you see. So I've just done the weeks by hand. Minor inconvenience but it works

[@Deltasquadformingup]

hey! It's good to see you Wow you've gotten like 7K extra subs since I last saw you! I've learned a lot about PC's and stuff from you and your vids but I have 1 question, I recently came across something called the Your File Is Ready To Download.exe "virus" or what ever it is I immediately tried deleting it it says Need permission from (Enter my username on my pc) I try this a few more times and no such luck. So I used Malware bites to scan for threats and it found 23 of them (It removed them all) I did a second scan after and no threats popped up, but the original file I downloaded is still there even though Malware bites says there are no threats is it good? Will I just have to "live" with this .exe on my pc or is there a way I can forcibly remove it?

[@AskYourComputerGuy]

Hey buddy! Good to see you again! Yes you can remove it. There is a free utility called "unlocker" that will delete ANY file (may require a reboot. You should be able to find it on Bleeping Computer

[@Deltasquadformingup]

@@AskYourComputerGuy Alright I will do that! Do you still do livestreams?

[@Deltasquadformingup]

@@AskYourComputerGuy ok, so I tried that and while it was installing evreything turned grey except the file and it said something and said file cant install my antivirus said malicious fe detected or something so I removed it and I restarted my computer and now evreything was back to normal 3 Cmd's poped up and went away 5 seconds later the file is already there and it looks like I tried that earlier and now Malware bytes found something called PUP.Op abylon I just installed it, would it be a good idea to disconect from wifi?

[@AskYourComputerGuy]

Haven't done a livestream since I had a couple hundred subscribers LOL. Honestly I hadn't even thought about doing another one since only about 3 people were tuned in...but now I have a few more people that might enjoy one. I should probably make that happen sooner than later huh?

[@AskYourComputerGuy]

Check your startup items. You might have some boogers running at startup that you can remove. You can disable any of the items, it won't hurt your system. If you don't know what it is, or are pretty sure it's not "legit", disable and after the next reboot, see if you have any different results. I don't think disconnecting from internet is necessary at this point

[@bhavneshparikh8283]

How to add subcategory? How to maintained payment ? transfer? etc process like cash bank google etc

[@AskYourComputerGuy]

Subcategory where? For income source, or a new bill? I show in the video exactly how to add a new item, row or column for each. And maintaining "payment", if I understand you, is simply entering the number into a cell. If you're looking for automation / bank connection stuff, this is not for you. This is just a Ezcel income tracking spreadsheet...you would need something like QuickBooks or Quicken to handle the more advanced stuff that you want.

[@bhavneshparikh8283]

@@AskYourComputerGuy sub category income or expense and payment paid various type cash Google Bank etc and interal transfer

[@AskYourComputerGuy]

I would just insert another column *after* you have all the formulas plugged in. It will automatically adjust the individual cell counts that way. That's what is easiest for me. You should be able to just select a column where you want the new one, then from the menu bar, "insert | column"

[@bhavneshparikh8283]

@@AskYourComputerGuy suppose transfer Google to bank cash to bank

[@AskYourComputerGuy]

I think you're thinking of this of more of "money management" and less "tracking". I set this up solely for knowing at any point during the week where I was for the remainder of the week. How your money is sent back and forth is really not something you can do with this. Ok, maybe you could implement it, but not this particular spreadsheet. This is just for tracking income and expenses. How and where you move your money is an entirely different thing :)

[@dustincarr3215]

Child support $500. lol. That's cheap!

[@AskYourComputerGuy]

Well it WAS $500 to her ...plus another $1000 for the two. Then one of them turned 21. Now I've just got 2 years left on the last one :)