Budgeting & Expense Tracking from Student to Sole Proprietor (Free Excel/Google Sheets Download)
Вставка
- Опубліковано 21 січ 2022
- Regardless of whether you have $100 or $100M in your bank account, if you don’t know how to manage your money, budget, and control expenses, you’re going to end up in debt. In this video, I share how I budget and track expenses as well as the app I use to track my net worth (=assets - liabilities) across different investing accounts.
𝗗𝗼𝘄𝗻𝗹𝗼𝗮𝗱 𝗺𝘆 𝗯𝘂𝗱𝗴𝗲𝘁𝗶𝗻𝗴 𝘀𝗽𝗿𝗲𝗮𝗱𝘀𝗵𝗲𝗲𝘁 𝗵𝗲𝗿𝗲(Excel / Google Sheets): docs.google.com/spreadsheets/...
𝗜𝗻𝘀𝘁𝗿𝘂𝗰𝘁𝗶𝗼𝗻𝘀 𝗼𝗻 𝗗𝗼𝘄𝗻𝗹𝗼𝗮𝗱𝗶𝗻𝗴 𝗦𝗽𝗿𝗲𝗮𝗱𝘀𝗵𝗲𝗲𝘁:
1. For Google Sheets Version: Click File 🠒 Save as Google Sheets
2. For Excel: Click File 🠒 Download 🠒 Microsoft Excel
If you have any questions or are having some technical difficulties with the spreadsheet, please leave me a comment below!
If you’re an instructor who would like to access my slides, please reach out on:
Twitter: / stephanieyzhou
Instagram: / breakingbaddebt
Disclosures: There are no conflicts of interest to disclose. These slides are for education purposes only. Any information, views, and opinions expressed are solely those of the presenter and are not a substitute for financial advice specific to your personal situation.
#budgeting #excel #googlesheets
𝗗𝗼𝘄𝗻𝗹𝗼𝗮𝗱 𝗺𝘆 𝗯𝘂𝗱𝗴𝗲𝘁𝗶𝗻𝗴 𝘀𝗽𝗿𝗲𝗮𝗱𝘀𝗵𝗲𝗲𝘁 𝗵𝗲𝗿𝗲(Excel / Google Sheets): docs.google.com/spreadsheets/d/1ea28kB6qlRc4MANNlCJQELqHkiEYo_VO/edit?usp=sharing&ouid=115371376482977326107&rtpof=true&sd=true
𝗜𝗻𝘀𝘁𝗿𝘂𝗰𝘁𝗶𝗼𝗻𝘀 𝗼𝗻 𝗗𝗼𝘄𝗻𝗹𝗼𝗮𝗱𝗶𝗻𝗴 𝗦𝗽𝗿𝗲𝗮𝗱𝘀𝗵𝗲𝗲𝘁: I have it as View Only to prevent people from permanently modifying the publicly shared version, but if you want your own modifiable version:
1. For Google Sheets Version: Click File 🠒 Save as Google Sheets
2. For Excel: Click File 🠒 Download 🠒 Microsoft Excel
If you have any questions or are having some technical difficulties with the spreadsheet, please leave me a comment below!
𝗖𝗵𝗲𝗰𝗸 𝗼𝘂𝘁 𝗺𝘆 𝗼𝘁𝗵𝗲𝗿 𝗹𝗲𝗰𝘁𝘂𝗿𝗲𝘀 𝗮𝘁:
1. How Do Doctors Get Paid? Intro to Physician Payment Models: ua-cam.com/video/X5uOkB0BuW0/v-deo.html
2. Intro to Personal Finance: Residents & Medical Students: ua-cam.com/video/UAQU0O8WgtY/v-deo.html
3. From Resident to Staff Doctor: Job Search, Starting Practice, Getting Paid: ua-cam.com/video/CuDsEY2C_OU/v-deo.html
Hi Dr. Zhou,
Thank you for this, it is very useful!
Just 1 thing: I added a year total row at the very bottom (as month 13) so that I can have a pie chart of my entire year-to-date. I'm not sure if this would benefit others, but I think that it will be useful for me to see my overall yearly picture, especially for bigger things like car expenses, travel, etc. which may not be consistent month-to-month.
Thank you again for taking the time to share this and the video!
Best,
Élise
@@elised9397 Thanks Elise, that's a great idea - it's good to see how people are customizing their spreadsheet
Hi thanks for this, it is very useful! I'm having a problem with downloading. When I try to download microsoft excel when I try to open the file I get a prompt that says there is a problem with the content. I try to recover the document, but can't open it. Is there another way to get a excel copy?
@@BamBam983 Interesting - when I try to download on excel, I don't seem to get that error message. Have you tried saving it as a Google Sheets (which would allow you to edit the document instead of view only) and then downloading it from there? Let me know how it goes
@@BreakingBadDebt That worked! Thanks!
Awesome, thank you
Amazing channel! Thanks for sharing the spreadsheets love them
I wish I had these sessions during residency. I’m learning all this as a new staff. Your channel is amazing!
Thanks, Mark for your support!
Love your channel ♥️♥️
Thanks for your support!
Thank you so much for this excel sheet, it is wonderful! Is there a way to get a cumulative pie chart for a full year in your excel or is it just by month?
Thank you for the spreadsheet! Very helpful! My question is, if I want to delete a few of the cash inflow categories or even the investment section, how do I do so to reflect on the actual spreadsheet and pie chart (reflecting 100% and not just grey area for being blank). Look forward to your reply!
This is super helpful. Is there a way to add more categories for expenses and have that be captured by the graphs etc? Thanks so much!
Hi Mike, that might be hard to do b/c it'll shift a lot of columns around...what I've done is change the name of some of the categories, combined similar categories, or put under miscellaneous.
thank you so much for the spread sheet and for sharing all of this info
You're welcome, glad it's helpful!
Thank you so much for this video and the spreadsheet! I was wondering how you keep track of the money you have saved from the previous month for the next month? For example, in December I had money saved for my January rent, however, since everything restarts in January putting in my rent brings me into the negative. Is there a workaround for this?
Thanks for your question - In your cash inflows, you can either change a column title to Balance Carry Forward and put the amount there at the beginning of the month. Or just write Balance Carry Forward (Dec 2021) as an item and put the amount carried forward in the miscellaneous section.
May you clarify what needs to be done from trainee to staff to become a sole proprietor of a business? I know that this allows me to deduct business expenses, without having to incorporate. Your video also clarified that as a sole proprietor, I file my taxes differently on the T2125 form. Other than registering for a business account at the bank, do I need to necessarily register for anything on the Canadian or provincial websites? Or does that only need to happen for a business HST number?
When you graduate and become a staff physician, you are also a sole proprietor that can deduct business expenses. You only get the business number when you incorporate and the HST number is only for if you make >$30K in non clinical income (i.e. teaching/admin). There isn't really anything additional to register for as a sole proprietor, whereas all those things you mentioned is for a corporation.