QuickBooks Online. Customize report. Get ready to start moving on up with QuickBooks Online. We're going to be using the free QuickBooks Online test drives searching in our search engine for QuickBooks Online test. Support Accounting Instruction by clicking the link below giving you a free month membership to all of the content on our website, broken out by category, further broken out by course. Each course then organized in a logical reasonable fashion, making it much more easy to find what you need than can be done on a YouTube page. We also include added resources such as Excel practice problems, PDF files and more like QuickBooks backup files when applicable. So once again, click the link below for a free month membership to our website and all the content on it. Drive selecting the option that has Intuit.com and the URL Intuit being the owner of QuickBooks. We're going to be picking the United States version of the software and verify that we're not a robot. Zooming in by holding down control up on the scroll wheel currently at 125% on the zoom and selecting the cog dropdown. Just to note that we're currently in the accountant view as opposed to the business view. We'll try to toggle back and forth between the two of you so you can get a look at where things are located in them. Right clicking on the tab up top as we do every time to duplicate the tab so we can put reports in it. Right clicking the duplicated tab to double duplicate duplicate again as that's thinking tapped to the left reports on the left. We're going into the balance sheet report going to the tab to the right as the balance sheet report is thinking down to the reports on the left hand side. This time the profit and loss the income statement the P and the L going to close the hamburger otherwise known as the hamburger and then do the range change up top. We're going to go from 010122 tab 123122 tab January through December run it to refresh it tab to the left close the hamburger and then scroll up changing the range in from 010122 tab 123122 tab and run it to refresh it. There's the setup process we do every time we've been focusing in on our balance sheet noting that the balance sheet and income statement are our major two reports. All other reports for the most part giving us more information more detail about one or multiple line items on these major two financial statement reports. We've been looking at the customization of these reports up top primarily focusing in the prior presentation on the items that are housed in the ribbon. As well as this little section down here and then the editing of the header up top. Now we're going to move to some of these items in the customized area noting that as we do some of them will be duplicated. So we'll see some of the same items in here. We won't spend a lot of time on the same items and that these will be the similar customization components for other reports as well. So also just realize that when you're looking at these customization components you're typically going to want to think about how they're going to apply. Primarily based on whether the report is a balance sheet type report in that it reports something as of a point in time or an income statement type of report profit and loss type report. Which has a range of beginning and an end and some of these functionalities will differ depending on whether it is reporting something as of a point in time or has a range to it back to the balance sheet. Let's go into the customized up top. So we've got our general a little arrows or our triangles. If I close them all we've got general we've got rose columns we've got filters and we've got headers and footers. Let's just go into the general item up top where we have the report period that mirrors the report period here on the left and our date our custom dates. We won't go over that in more detail because we've seen that we've got the cash versus a cruel which was also over here if I close this out right there. So remember that you want to keep it on a cruel for the most part because you're not switching from cash to a cruel kind of accounting system. You want to use it just to look at a cash report reporting versus a cruel possibly I won't go into that in detail again but just be aware of that. Take a look at the prior presentation for more detail on it and then we got the number format. So the number format we have the options of divide by 1000 without sense except zero amounts. So if we divide by 1000 that's a way that we can kind of slim down the look and feel of the report. So if I was to say I want to divide by 1000 for example and run the reports now you've got smaller numbers. So if you have a financial statement that has big numbers then you can divide it by 1000 to round it down and that could be a useful way to make it a little bit cleaner of a report to be looking at. If you run it or customize it again and I divide by 1000 and remove the sense then it's going to remove the decimals here which I don't think we're representing pennies. In that case they were rounding to two decimals out after dividing by in essence a thousand. If I then customize it again and I turn that back on this is the default divide by 1000 off and we have the pennies and the pennies on now we're back to the standard. Notice sometimes a lot of the times even if if you don't want to divide by 1000 removing the pennies is often useful for external reporting because the pennies are usually not relevant for decision making purposes. And that's usually the criteria as to whether you would divide by 1000 or remove the pennies for external reporting. If I rounded this to the thousands would that be enough information for the decision making purposes that I'm in at this point. If I'm normal decision making purposes the pennies aren't usually helping my decision therefore external reporting oftentimes it would be useful to just remove the pennies without sense. So the report still makes sense but it's not doesn't have sense in the terms of the pennies are now gone. It's a little bit cleaner of a look. So I often will do that for external reporting purposes noting that for external reporting purposes to look in the field is you know half the battle. That's going to be not that you're fighting your clients or anything but that's going to be important right. So then you've got the drop down here the negative numbers as negatives versus brackets. I tend to actually like the brackets on the negatives and then you can make them read to make them stand out even more. Do we have any negative numbers here. There's a negative number opening balance equity and equities negative. That's not good. So those kind of pop a little bit more. You might not want the red that might be a little too much but the red could be useful. And that gives you a little bit different looking feel and the negative numbers kind of stand out a bit with the brackets. So I kind of like the brackets personally. That's what we will be practicing with when I do external reporting purposes. So then I'm going to go back to the default just to see the default. So this is back to the default. If I go back to the customize and we have the accept zero amount. If I turn that off then we have the zeros that are included within here. Now that's a little bit of a of a tricky kind of item because I'm going to go back in here and say except zeros.  And so now we've got the zero. Now normally when I think about this zero here I would usually go to the the option that we saw last time which was to say in here and the active say I want it active or not. If it's active the zero will show up so you can drill down on it. And if you say you don't want to see the zero you can remove the zero for external reporting purposes. So that's where I would usually go to kind of remove the zero if I want it for external reporting purposes personally. Customizing again. So then we've got those items. Those are in the general. I'm going to collapse the general and go into the rows and columns. So we've got the totals. This mirrors what we saw over here and this item mirrors what we saw here in this dropdown. So I'm not going to go into those in more detail because that kind of mirrors what we saw last time on the left. I don't know why they put it in both areas. But I'm assuming I think they had it in here first and then they put it over here in the ribbon and then they didn't take it out of over here and I don't know what their thought process is. They might change that at some point but there it is filters. So filters are great tools to basically be filtering down on the data of course. Now oftentimes the filters not something you're going to use so much on a balance sheet report. But if I start on the balance sheet report and I drill down say on the checking account. Now I have a performance report which has a lot of information I could filter on. So notice I've got one of the major filtering items is the transaction types. So in the cash account we've got all these different kind of transaction forms that we used to create the transactions within here. That's a common filtering type. So if I want to see increases I might filter by deposits. If I want to see decreases I have checks you know another kind of form. So for example if I run the filter in here notice I still have the customize in report now because the customize option is basically there for all reports. So I've got the same options I go into here and I go to filters then I've got the distribution account is the checking account. Oftentimes you look at the transaction type. So if I want the transaction type I can then say if I want like decreases I can look at the checks. I can look at the I might want to include the bill payments the pill payment credit card. I might want to look at the paychecks add all the decreases here that I'm trying to kind of think about. And then then where's the expense form something like that and run it. So now I've got the decreases so that filtering option quite useful. You also might filter by name for example so I might go up top and customize and so you've got account you've got by name. So if I filtered by name then I could I could pick someone you know that we pay by name that could be another way that would be quite useful or common depending on the report that you're using. I count by customer or vendor or employee so would and then product service what we're selling depending on what we're sorting by notice that a lot of these sorting options. Again they're going to be more or less useful depending on the reports that you're looking at. So there's your your filtering options. So let's close that out. We'll do some more filtering some depending on our needs as we go through the practice problems.  Those are the ones that are the checking accounts going to impact you know all the financial statements and and therefore the filtering options quite useful oftentimes within them. So let's go to customize up top and the filters. So we had our filters here. Let's then I'm going to collapse these and let's go then to our headers and footers headers and footers. So now you've got on the header side you've got the company name so you could remove the company name often not generally what you might do but then and then you could change the company name if you wanted to adjust it up top. Same with the title. This might be quite common if you did something like a comparative balance sheet which will test out doing later. So note if I close this out and I said I wanted to do a quarter by quarter balance sheet. Then now I've got multiple quarters here. So if I go back up top here and I said if I customize and I look at my my headers and footers maybe the balance sheet is not all I want. Maybe I want a comparative balance sheet or our quarter by quarter quarter balance sheet. Let's say just comparative balance sheet or something like that. And then also the date that says as of right here might not be applicable because that's as of just one period and now I have multiple periods. Now I can't really change the dates but I could just remove it and then this little item right there will go away. So now I've got comparative balance sheet and I've got the dates right here so I don't really need the repetitive date up top and that could be a way that's a nice kind of formatting tool that you want to keep in mind when you start to do and customizations for comparative reports and filtering and analysis reports for example. And then on the footer you've got the date prepared time prepared report basis. Now if I close this out you can't really see it right now but if I was to view this on the print preview and scroll down to the footers here you've got the accrual basis. Here's the date and the time so maybe you don't want that stuff down there on the footer. So I'm going to go up top and say customize and then footer this obviously would only really be useful for external reporting. So when you actually print these out and provide them to a client that's when you're when they're actually going to be printed as a PDF or something and then you could tell what you want on that footer down below which now doesn't have that information on it. Closing this back out customizing so so that would be the footer date time prepared report basis. And then if I put those back on you also have the alignment so the header is defaulted as center aligned I think so you could left align it left aligned. Let's just test them out. So now I've got it left aligned. If I was to print it. You've got a left aligned up top left aligned here. I close this back out. Let's just go through the variance of them middle I think is the default. So let's right align it right align. And so now it's right aligned. So these you know most people would probably center it but it might give you a bit different look and feel if you were to make the change you know you can have a little bit of a differentiation between yourself and others with that. And remember when you're doing the external reporting making it you know doing a just a little kind of customization things can make it feel like you're you know you're putting a little bit more of an added touch in it and you don't have as much customization in the online version and say the desktop version which allows you to change the fonts to some degree as well as the colors and whatnot. So doing a couple of those changes could be useful changing the title to make it customize. It gives you you know shows a little bit more effort on it possibly and if you export it of course to excel then you can use Excel to do a whole lot more customization if you wanted to do that although that becomes more tedious because then every time you do your report and you'd have to export it to excel and do the added whatever adjustments that you're doing within Excel. So the any adjustments that you can do within the system would be useful because then it would be easier to do your possibly month end your end reporting and generate them easily. And notice that once you make these changes you can then memorize the report so then I can kind of save the report so that in following periods if I want to save the customized report if I saved it like this. And I could add we'll talk about adding groups later but if I save the report and then I go back to the first tab and I'm going to go I'm going to refresh it. And then go down to the reports on the left hand side and then go into my customized reports now I've got my comparative balance sheet. So you might want to start saving like your customized reports in terms of the reports that you would want to use externally possibly which might have different formatting than the reports that you use internally. And and therefore and that'll allow you to at the end of the period just generate these custom reports quickly and then put them together as a package to provide them to your clients on whatever a monthly baseless quarterly basis in a yearly basis possibly. So those are going to be the formatting there remember that these formatting tools will typically be applicable not just to the balance sheet but other reports as well but the effectiveness of them and or which ones you might use and how they'll be used will differ. Primarily and often about on whether or not you're talking about a balance sheet type of report that reports as of a point in time or an income statement type of report that has a time range. So let's go back to the first tab real quick and then hit the cog drop down switch to the business for you just to locate where things are at under the business for you just so we see the the two views if I go to the home page. This is obviously our home page we went to the reports which is under the business overview here. So there's our reports there's the standard there's the customized under the reports section and in the bookkeeping area. That's where we have our our our I was looking for the chart of accounts that's where we've got our chart of accounts right chart of accounts is right here under the bookkeeping area I think we open that up. Those are the primary areas that we've that we've looked at so you should be able to find them under either view that you that you work with with whichever one is your preferred view that just a different layout but it's all the same stuff.


Hey there friends, how's it going? My name is Kevin and this video is sponsored by Dragon Raja, which is a AAA quality console game in your pocket. It's optimized and adapted to provide a superior gaming experience on your phone using the latest technology of Unreal Engine 4. It has a crazy immersive environment. For example, little touches like standing in the street causes traffic jams, slippery streets and snowy nights can cause spills, and your mood matters. Your character can get cold, hungry, happy, upset and these moods impact your performance in and out of fights. There are lots of different fun and real interactions that are waiting for you to try in-game, realistic climate changes and seasonal cycles, architecture styles and scenes from all over the world. It has a fantastic character creator which, if you watch my videos, is very important to me. Also, a new unique class is available for the first time this month. The fighter can combine your fighting skills to create new ones and also summon a personal robot. Clare Housing is also a new feature in Dragon Raja unless you create and customize your home like you would in Avatar. And another thing I love is your choices affect how the story unfolds, which is always fun. There's also a career system, you can become a famous chef or powerful movie star, as long as it's not a YouTuber, I'm sure anything would be fun. If you want to check it out, the link will be in the description. Thank you very much to Dragon Raja for sponsoring the video. It helps me out a whole bunch and thank you very much for watching as well. And without further ado, I hope you enjoy the video. Hey there friends, how's it going? My name is Kevin and today we're doing something a little bit different. You see, before this whole lockdown thing, I used to get together and play board games with friends pretty often and I really, really enjoyed it and it's left a void in my life to be honest. Now I don't have any friends to play with but I figured, why not play some board games by myself? Wow, that's probably the most depressing thing I've ever said. So I figured a good one to play by myself would be the game of life to see where it all went wrong. What led me to this? So we got Kevin here, Kevin here and Kevin there. We're gonna play three pieces and I'm thinking surely one out of three is gotta be a good life. Alright, first we gotta roll to see who goes first. Alright, that's nine for me, six for me and five for me. Yes, I go first. I'm gonna start off by going to college. Five, let's see. One, two, three, four, five. Lose next turn.  I'm a weird man. Oh wait, I forgot. They need to get jobs now. Okay, they each get a career card.   No, you can't be a teacher. You don't have a degree. That goes back in.  Ooh, you get paid 90,000. Well, why the fact that I bothered going into college? Wait, wait, but that's also me.  Okay, something is wrong there. Alright, so blue Kevin gets a payday of 20k one.   This is difficult. Wait, no, I skipped my turn, which means it's my turn. So Kevin, you take the seven. A skiing accident.  But you get paid. I am not going to be able to keep on top of this Christ Almighty. It's already getting very confusing. I don't know why. This is actually kind of interesting. I didn't expect it to be, which is not a good thing to be saying about a video you're making for hundreds of thousands of people. Oh, God, that's scary. But what I mean about it is being surprisingly interesting is that I don't like red Kevin, even though that's me. I don't want him to win. I hate him. White Kevin is the best. Oh, no, like not in a race way, like just color. I want to stop talking.  It's probably the most relatable thing I've ever said for most of you.  I hate him.  He's loaded. It's not fair. Wait, I'm loaded. This is great. Okay, finally, I get my job, along with my other personalities getting their jobs. I don't know anymore. So since I went to college, I get to draw three of these and three salaries and pick whichever one I want. I think I'm going to take the biggest salary. I'm quite selfish like that. I'm greedy. I want to be a superstar. Lose next turn. For fuck's sake. At least I get my payday of 80k. You know what? I'll wipe my debt immediately. Like, is it just me or do we all hate Red Kevin? He's sitting over there with his smug face up and living in that lovely cul-de-sac. Move across country, pay 10k. On, because he landed on one that has this little symbol, the 10k that he used to pay goes to blue Kevin. He's earned that. Jesus, he's such a straight edge. He landed on say no to drugs and now he's on don't drink and drive.  I'm kidding. Please don't do those things. They're bad. All right. I'm a role model. White Kevin is the best. All right. White Kevin is getting married. This is his wife. She is scoliosis.  I don't know why I hate him so much. Like, it is me. I am all of these players. I should be happy. I'm winning and I'm getting a house first. Fantastic. Please be cheap. Honestly, getting expensive house in this game seems just pointless to me. 80k. All right. That's not too bad, but I can't afford it. Oh, wait. No, I passed payday. My payday is 80k. Okay, great. Then free house and a baby boy. God, that seems irresponsible since I don't really have the money for this. And my wife is scoliosis. It's going to be a hard on her wedding reception. Pay 10k. I'm sorry, blew me. You. I don't deserve this. I want blew me to do well. I feel like he's a trier God bless him.  Attend a Hollywood premiere. I don't have to pay it because I'm attending my own premiere.  Feels good. And in fact, I'm going to buy a stock with my money. I have like no money. I don't care. I'm buying a stock. And now anytime the number nine comes up, I get 10k. Oh, and I passed my payday as well. So I get 80 grand. This is good actually. This is nice. Buy furniture, pay 10k.   Oh, and I just realized it's a sales person one. So that doesn't go to the bank. It goes to the villain, red Kevin. Are you invested yet? Because I'm really invested like way more than I thought I'd be. All right, red, you're getting a house. I hope you get something expensive because I think in a newer game, you can make money on houses, but this is the very old one and it doesn't actually do anything for you.  He got one of the cheapest ones and it's actually Oh, okay. I was gonna say it's actually kind of nice, but no, it's split in half from an earthquake. I don't know if you'll be able to get insurance on that bad boy. Like it says 10k. All right, I'm gonna try and play it fair. If I were him, I would buy insurance on that because it's so cheap. So that's integrity for you. Oh wait, they passed two paydays.  One house is blue getting. Let's take a look. 100k for a country college. I mean, it's nice, but just really have the cash for this to be honest with you. It gets a salary of 20. I don't know why I call him he. It is me. I'm honestly just getting very confused by this whole thing. All right, I'm gonna put in my 50 that I have there. Keep five and then take out a bank loan of 60, I guess. The bank loans, you can take out a bank loan of 20 and you have to pay 25 back. I do, but I get to choose my way. No, not a hope. Am I putting my money into red Kevin's pockets? I'll pay it in medical bills. Thank you very much. Oh my God, he's to pay 20k. This isn't fair. Like that's his whole payday from there is to pay. I'm getting screwed, but I'm also doing really well at the same time. Trade salary card with any player. Yes, blue, you're trading it with red. Screw him.  He had a comment.  Tree falls on house, pay 15k of insured, but he bought insurance. Bastard. He's always one step ahead. Oh God, blue's having a baby. Yeah, not sure if that's responsible. You're not doing the best. Actually, no, you just went from 20 to 90k. Blue Kevin, you're doing well for yourself. You have multiple kids. Keep spitting. I'm out for all I care. You're financially secure. Even though in this world, your paycheck can change at any second. Okay. I think as blue Kevin, I'm going to pay off my bank loan. So, I owe 75k for that. Good move. Me. And you know what?  Who knows what's going on at this point. I actually don't know who's winning. I'm pretty sure it's red Kevin.  Just realized I landed on a nine there as well. So, I get my 10k. Pretty sure I've missed out on that multiple times by now. It's just hard to keep track of everything. Tree falls on house. Oh God, blue landed on a two, but I just got him insurance. Phew. I almost got screwed. Taxes due for red, but he just lost his high paying job. So, he doesn't even have to pay that much, which is good. I think for me, is it bad? I don't know anymore. I don't know what I'm doing like rooting for me and against me. I don't, I don't know. I perfect sake blue. Look, you still have a chance. Don't get angry. I think blue me is gonna buy car insurance too. I seem like a responsible person when I'm blue.  Win beautiful baby contest. Dude, you don't have a baby. Where did you get the baby from? Red Kevin is a villain.  Pay 25k for an African safari, but you're the travel agent, so you don't pay it. But we're very much in line with each other. Blue is behind for ages, but get some high rolls here, which I like to see. Right? Best seller. What? Why? I guess they're a sales person. Maybe it's something to do with the property they bought. Maybe they fixed it up. I don't know. But either way, they get $80,000. It's honestly so difficult to not call them day. Like it's me. It's just weird. I can't get my head around it. Stock market slumps return one stock. Fack off. There goes my 50k. I spent taxes due off. Fack. At least you get your payday. Give to Art Institute. Pay 25, and you collect how much? 20? So you get 15. I'm positive I've made multiple banking errors at some point. I think I'm doing all right, but it's just got to have happened. It does get a bit overwhelming when you're trying to keep track of three accounts that are all yours. Daycare. Pay five per child. Fack sake. Can you give me a discount? My wife is Coleosis. Oh god, what's this? Burglar. Pay 50k if not unsure. Well, blue is always prepared. Level headed blue. Back at it again with the insurance. You know, everything is going so right for blue. I'm starting to dislike him. By which I mean me. But I disliked me way before I started playing this game. So maybe I'm already there. I'm not sure. Trade salary card with any player I just got. Well, probably going to want revenge on blue, I guess. As lovable as blue me is. Probably swap that back. I like blue again now. I just like an underdog. Two paydays for me. Not that that clarifies anything for you. That's a confusing statement. Nine. If only I had my feck in stock that was stolen off me. For feck's sake, blue. You used to be sensible. Now you're buying a sailboat really? Like you're back down to 20k salary. You can't be doing this. You've gotten used to the high roller lifestyle. You just got a payday, but we still have to pay out more because of your reckless spending. And what's worse is we got to give it to red Kevin over there who's already loaded. He is the 1%.  Even though really it's, I'm sick of the 33%. Help the homeless. Look at him. He's probably recording it and posting it to YouTube as well. He never does anything good. Unless there's something in it for him. Win Nobel Peace Prize. I deserve this. What have I done? I guess I am a superstar. I do deserve this. Screw the scientists and all the people making the world a better place. I wrote a nice song that goes like... Produce rock video. Wait, how much? 100k?  You're going off the rails. You're having a midlife crisis. And what's better is that goes straight to me, the superstar. It's supposed to be me for landing on it, but it's great to be me that it has to be paid to me. Finally. Red is actually losing some of my money. I don't know. Have tattoos removed? Or sorry. Have tattoos removed? Pay 100,000. Okay. He's snapped out of his midlife crisis, but still is paying so much money. I wonder what his tattoo would have been. Looking components. Whatever I find first. RPG kit. This, this is what his tattoo was. Yeah, I can see why he got it removed. Leave it over with him as a reminder. Pay 50k per child. Can I have a discount? My wife is scoliosis. Like, sir, that's not a thing. Stop asking for it. Hired jockey for your racehorse. Pay 65.  Or good. I don't know. I don't know who I'm rooting for anymore. Kind of back on blue's side because he's making such foolish choices and it's just like blue Kevin just needs a break. Trade salary with any player. It's kind of useless now, but take it from me, I guess. Take a hike. Red.  I'm amazed by how close we all are. How close I am to me. I don't know, dude. I still haven't grasped this even though we're right around the bend to the end.   You have no kids. I don't understand how many kids you've stolen. Winning baby beauty contest and becoming a grandparent. I don't get it. I've just realized I've not collected any of these paydays for any of us, so let me sort this out real quick. There you go. It's blue Kevin. There's your 60k year old for the three paydays. Don't be getting any Cyclops tattoos, please. Spin again if not in the lead. Good job, blue. Good job. Eight. I think you're straight into retirement. Yes, you are retiring. Okay, so this is how it works.  If you do in fact have the most cash, if you go into this one, you get these four lifetiles which have bonuses. If you go into this one, you just pick up one. It's pretty obvious that blue does not have the most money. It's the right call. The red is going in there. Pretty confident in myself that I have the most money. It's true no matter what. I definitely have the most money. Pension. Collect 20,000 times. It's still 60k, I guess. It just wasn't a very high roll. Wait, six? Hold on a sec. Oh, no. Okay, no. They still have the most money, I think. Yeah, it was actually close enough. It's between red and white, I think. You know, blue is a lot of life cards which gets you extra money. I don't know. It's all up for grabs. White is now retiring. I don't think I can beat them. I'm just going to go into this one, the modest retirement home, and take my one card. Okay, and red gets these four cards. Okay, so now I have to add up all the money and see where we stand. Okay, wait, one second. I'm going to need something for this. There you go. Accountant. I'm going to need this for a second to be able to add this up. I'll just put it at the bottom of my screen there. I'm going to try and change it all into 100s just to make it easy on myself. Wait, how much? Oh my God. Wait, I had so much money under here. For fex's sake, I should have gone to the other place. I stacked things on the wrong things.  Oh, I think I could have gotten those life cards. 255 for blue. 945. This is a bit messy in cash for white Kevin. Oh, red Kevin was hiding some cash too, actually. Wait, hold on a second. Oh my God, this was actually really close. 900, and oh wait, there's more there. Jesus Christ. 950k. Okay, I just lost to me. Or sorry, I just beat me. 950. But now the life cards come into place. Let's see what white Kevin accomplished with his life. Invented a new ice cream flavor. The solution to pollution. Run world record mile, open a health food chain, and family horse wins Derby, which is a grand total of 600. Blue Kevin, what did you get up to with your life? You want a dance contest? You discovered a new planet? You pulled surprise? Invented a new sport lifetime achievement award? Not surprise, to be honest. Build a better mousetrap and find new energy source. Fuckin' hell, you were up to a lot. So that's 650 added on. It's blue Kevin has come last, regardless of what has happened. Now red Kevin, what did you get up to? Swim the English Channel. You became president. You designed a new computer. Got a Nobel Peace Prize. Composed a symphony. Painted a masterpiece. A toy invention sells big. You cure the common cold. Humanitarian award. And you climb Mount Everest. Okay, I am amazing. I've read all those. It's like I was red Kevin all along. 1.45 million in cards. Which brings my total to 2.4 million. I've won. I've done it. I've won. But I also lost twice. So I don't know how to feel about that. And of course the winner deserves a prize.  All right. Well, that was fun.   Like I said, I don't know. I've mixed feelings on this, but I had a good time. A very strange experience, but I thought this was fun. So let me know what you thought of it. I think I'm going mad, but I hope you enjoyed. That's the main thing. I hope you're staying safe. And yeah, thanks very much for watching. I really appreciate it. And I hope to see you next time. Bye for now.


All right, let's begin. So this video is going to be a beginner's guide to investing. It's going to be pretty simple to the point and very basic understanding of what investing is What prompted me to make this video was the fact that I meet a lot of people in real life who have no idea What investing is and very very few of them actually invest in anything and they're missing out on a great opportunity to make some money So let's get started and let's just start with the contents of this video So in this video, I'll talk about what investing is The things you need to complete before you start investing the compounding effect and the summary of a few different types of different investment vehicles As well as why I prefer investing in equities Let's get started So let's start with the basic definition of what is investing? So investing is spending money on assets such as a stock market real estate or precious metals like gold and silver With the intention of their value increasing and returning a profit to you Very simple There were several reasons why you should be investing to save up for retirement to earn some extra income through dividends and as a hedging is inflation No matter what your investing goal is it is essential to start saving and investing as early as possible to take advantage of the compounding effect I'll talk more about the compounding effect later on in the video and I cannot stress this enough how important investing as early as possible is What you should do before you start investing So the three things I would recommend you do before you start investing is to a have an emergency fund Get rid of your high interest debt and have a financial roadmap So let's get started with what is an emergency fund every person specifically every intelligent investor should save money in an emergency fund The purpose of having this emergency fund is to just basically help you out to any unexpected situations that you may incur such as a hospital bill Emergency travel or unemployment It will also ensure that during such times you're not forced to sell your investments to raise liquidity and your assets can continue to compound safely This fund will should always be liquid and is insurance for yourself and your investment saving you to any financial stressors It'll also make you less emotional with your trading and investing as you have a backup plan Never ever put all your money Into the in any sort of investment always keep some liquid cash that you might need in case of an emergency So let's start how to make an emergency fund very simple start by calculating the monthly expenses that you and the people dependent on you incur This includes your total expenses So everything from rent groceries gas and all online subscriptions and recurring costs This is purely your total expenses and you should not take into account any of your income So after calculating this number you can multiply this by the number of months worth of expenses that you want saved up I would recommend anywhere between three and six months and of course is determined by your risk tolerance Number two pay off your high interest debt I highly recommend you guys to pay off your high interest that before you start investing So high interest debt in this case is that anywhere between an interest rate of over five to ten percent Most investment strategies are unlikely to pay off as well as you just simply paying off your high interest that that you may have This is because paying off your debt is a guaranteed way of making money as a dollar saved is a dollar earned If you owe money on high interest credit cards The wisest thing you can do under any market conditions is to pay off the balance info as quickly as possible Chances are that your debt will outpace the growth of your investment and you will have a net negative return despite all your effort So to put this into context the S&P 500, which is one of the best ETFs Since its inception has only given it has given a rate of return of about eleven point eighty eight percent annually And if you have a debt that's over twelve percent interest rate You are essentially just canceling out any of the investment returns that you might get So if I want to just pay off your high interest That and the third and final one would be to draw financial roadmap This is especially if you have never made a financial plan before so it takes some time out of your day Let me take an honest look at your entire finances situation The first step to successful investing is figuring out your goals and your risk tolerance either on your own or with the help of a Financial professional if an investing goal is of a longer time frame such as eight to ten years You can allocate your money to high-risk assets such as equities that have high return but are risky However for goals of a shorter time frame such as two to three years You might be better off just allocating your money in low risk assets such as precious metals like gold that have low returns But also are also less risky than these factors will all strongly influence your investing journey Which markets you pursue and what assets you buy and how often you handle these assets Now let's get to the interesting part, which is the compounding effect The compounding interest is one is is when you earn interest on both the money You have saved and the interest you earn and compounding interest produces excellent results when you give it time as a generous interest on top of interest The longer you invest the greater the compounding effect and your returns over 25 years are over five times as much as the returns over a 10-year period So all the one would assume that the returns the return difference between 10 and 25 would be about 2.5 It is not the case. So let me just demonstrate this with a quick example In this example, we will be assuming that you have put a $10,000 initial deposit with no additional contributions into the S&P 1,500 which is historically given a rate of return of about 11.88% since its inception Take a look at the compounding effect. So after 10 years or 10,000 is roughly $30,000 But after 25 years, it's a hundred and sixty five thousand dollars So it's a huge difference if you start investing at the age of 18 That's compared to when you start investing at the age of 28 those 10 years worth of compounding in the compounding returns that you miss out on is huge I've attached the link for the calculator so you can play around with your own investment plan and see how powerful compounding can actually be over time Now let's just talk about the different types of investment vehicles such as equities real estate and precious metals There are many more like crypto, but these are the three I will be just mentioning briefly and why I prefer investing in equities So what are equities? Investing in stock equities are basically the in the stock market So investing in stocks is about just buying ownership in companies Your shares in the company can increase or decrease in value depending on how well the company performs and Companies that continue to generate profits tend to provide a much higher return than those do not some simple stuff There are more volatile than investing in real estate or precious metals. So real estate requires Generally requires a higher sum higher capital allocation and precious metals while they are quite safe They also do not provide such a great return The best way would be to diversify across all these all of these three mediums So you're not just stuck in equities. So you have equities real estate and precious metals like gold That would be a very well diversified portfolio Another way in another ETFs in are basically just a bunch of basket of stocks and bonds that trade in the market These are generally more diversified and therefore less risky than just picking individual stocks So the S&P 500 is just basically the top 500 companies in the United States And when you invest in the S&P 500 your money is spread across 500 different companies rather than the one simple company What would just one individual company? So your money is much more spread out much more diversified and therefore as a result is much more safe Rather than just picking a simple picking one company And that's about it. If you guys are interested in more simple content related to investing and stocks please do let me know I will I do have plans of making more stuff like this and Just let me know if you have anything that you'd like me to cover or like anything that you are interested in that I should look more deeply into but for now, this is about it. Thank you very much


I know you work hard to make the best lifestyle choices, so you can improve your health, destiny, and longevity. And there's lots of information out there on how to do just that. So where do you start? Well, we start with the facts. Welcome to the Nutrition Facts Podcast. I'm your host, Dr. Michael Greger. My job is to bring you the latest peer-reviewed nutrition and health research, and share it with you here. Today on the show, the mighty vitamin B12. Did you know B12 is an essential nutrient that your body can't make useably on its own, so you need to get it from your diet or supplements? Today we start with the best green light sources of B12. A regular reliable source of vitamin B12 is critical for anyone eating a plant-based diet, either vitamin B12 supplements or vitamin B12 fortified foods. I've talked about my B12 supplement recommendations, either 50 micrograms a day or once a week doses of 2,000 micrograms. I think that's the simplest, cheapest way, taking it once a week. That's how I'd do it. But if you don't want to take supplements, you'd have to rely on B12 fortified foods. In which case, you'd have to eat three separate servings of B12 fortified foods, each ideally sustaining at least 190% of the so-called daily value on the product's nutrition facts level. How does that make any sense? And what's the term daily value even mean? The term daily value is used to designate to both the DRV daily reference values and the RDI reference daily intakes that are based on the recommended daily allowances all to limit consumer confusion. Aren't you less confused now? Anyway, the daily value of B12 was set at 6, which has recently changed to 2.4 in 2020, making it all the more confusing. And so 190% of 2.4 is about 4.5. Plug that into the equation and you get about 1.16 absorbed from each serving, times three times a day, and poof! There's your 3.5 for the day. Okay, so how much nutritional yeast would that be, a commonly B12 fortified food source? It depends on the brand. Going alphabetically, Bob's Red Mill brand has 730% per quarter cup, so you'd only need about four times less than that to make up a serving, so around one tablespoon. So one tablespoon of this brand sprinkled on each meal and your B12 would be taken care of. Braggs says it's even more potent at 563% per tablespoon, so just a teaspoon three times a day should suffice. Dr. Ferman's brand is explicitly unfortified, so it contains zero B12, so that's an important lesson, where you can't just assume nutritional yeast has B12. So you like finding the bulk section? You have no idea what it contains, unless you actually see the package. Starting with the Frontier Co-op brand, Zero B12. Cal brand has 500% of the daily value of B12 per three rounded tablespoons, so one rounded tablespoon should suffice as one of the servings. Now brand has more, with two teaspoons of sufficing. Red Star has 333% per one and a half heaping tablespoon, so a serving would be like one tablespoon, but not only some of Red Star's nutritional yeast varieties have any B12 at all, so just remember to check the label. Finally, Trader Joe's looks like 1.5 tablespoons, could count as one serving, so it looks like Braggs is the most potent currently available. There are all sorts of other B12 fortified foods, from plant-based meats and milks to breakfast cereals and energy drinks, but are there other green light sources, meaning plant foods from which nothing bad has been added or nothing good has been taken away? What about various algae-type products like spirulina, which are advertised as natural vitamin B12 sources? Not only do they not actually contain B12, that's usable for humans, it's even worse than that. They may contain B12 analogs, look-alike molecules that can even block your absorption of real B12. I was excited to see that there was an herbal tea with B12, but so little you'd have to like quadruple bag it, if you didn't want to take a pill, which again, I think is really the best way. The easiest option would probably be leaf-side foods. I've always loved them because they center their ingredients around my daily dozen. Unfortunately, people see them citing my science and think I have some sort of financial relationship, but of course I have no financial ties to any food company, drug company, supplements, kitchen gadgets, no personal financial ties with any commercial entity whatsoever. I'm happy to voluntarily plug leaf-side. Though as their food has kept me from starving on the road on many occasions, they're freeze-dried, so they're light and easy to travel with, and I just use my hotel room coffee maker to make hot water and poof. Okay, but anyway, each of their meals has 75 micrograms of B12, so one a day and you get all your B12 without having to take a supplement, but it's only 100% green light if you specify you want the salt-free versions. They have no added salt-fat sugar versions of all their products at no extra cost, but you have to specify that when you order. In our next story, we look at the optimal vitamin B12 dosage for kids, pregnant women, and seniors. Universal improvement of B12 status appears to be a nutritional imperative with possibly profound beneficial effects, particularly at the bookends of life at old age and infancy. I've explained the rationale for my recommendations to take vitamin B12 supplements once a week, once a day, or alternately eat sufficient daily vitamin B12 fortified foods, but for those over age 65, those guidelines go out the window. The recommendations change to everyone, taking a high daily dose of 1,000 micrograms every day. Starting at age 50, everyone, meat-eaters and vegans alike, should be taking B12 supplements or eating B12 fortified foods, but over age 65, 50 a day may not do it. Even 100 a day doesn't seem sufficient. Researchers investigated three doses and found that most didn't normalize their MMA until after the 1,000 microgram dose, MMA suppression is a measure of B12 sufficiency, but they just tested 2,500 and 1,000, maybe 250 or 500 would do it. Researchers set out to find an adequate dose at that age, and it seems we need at least about 650 to 1,000 a day in most people, hence my 1,000 a day recommendation after age 65. Okay, what about the other end of the life cycle? The consequences of B12 deficiency and insufficiency can be devastating in infancy and childhood. And this is not just a problem for plant-based pregnancies. Vitamin B12 insufficiency during pregnancy is common, even in non-vegetarian populations, about a quarter of all pregnant women aren't getting enough B12, and that number rises to nearly 1 in 3 by the third trimester.  Thankfully, even severe brain atrophy can be substantially reversed with B12 supplementation, but better not to become deficient in the first place. The solution proposed by a group of French pediatricians is to recommend against raising vegan kids at all, since B12 supplementation is necessary. And they're not alone, to vegan or not to vegan. In 2016, two professional organizations, the U.S. Academy of Nutrition and Dietetics, and the German Nutrition Society, issued conflicting statements. The U.S. Academy said that even strictly plant-based diets are appropriate for all stages of the life cycle, whereas the German group echoed the French group, saying, since you have to take B12, we can't recommend a vegan diet for pregnant women, lactating women, infants, children, or adolescents. To confuse the matter further, the American Academy of Pediatrics appeared to have it both ways. In one place, repeating the U.S. Academy's position while in another place is stated that vegan diets should not be recommended for children. But I think they're just saying the same thing. Everyone agrees that a non-B12 supplemented plant-based diet is a bad idea. That's part of what the U.S. Academy means by well-planned. Everyone eating plant-based, but especially pregnant and breastfeeding women, must ensure a regular, reliable source of vitamin B12, meaning B12 supplements or B12 fortified foods. But then you may be able to get the best of both worlds. That's why there are reviews with titles like this. Plant-based pregnancy is danger or panacea. Danger, if you don't take your B12, but following a plant-based diet during pregnancy may be protective against the development of preeclampsia, pre-gravid obesity, and minimize exposure to DNA-damaging agents. It may also protect our newborns from the onset of pediatric diseases, such as pediatric wheezing, diabetes, neural tube defects, oral facial clefs, and some pediatric tumors. Vegan pregnant women have a lower than average rate of caesarean section, less postpartum depression, and lower neonatal and maternal mortality, with no complications or negative outcomes that are higher than average. In addition, a lower incidence of what used to be called toxemia, a potentially dangerous pregnancy complication known as preeclampsia. Overall, plant-based diets seem to confer protection to both mothers and newborns by not only reducing the risk of several pregnancy-related issues, but decreasing the risk of childhood disease. Children following plant-based diets might have a low risk of developing obesity, obviously less exposed to drugs used in animal production, and a favorable anti-inflammatory profile of cell signaling factors. But again, everyone on a plant-based diet has to get enough B12. Pregnant breastfeeding women can just follow my 50 micrograms a day recommendation for non-pregnant adults, or 2,000 a week, though they suggest breaking up those doses into two halves to boost absorption. After infants are weaned, they can start on 5 micrograms a day. From ages 4 through 10, they can ate half the adult dose of 25 a day, and then at age 11, they can do 50 a day or 2,000 a week. You don't have to worry about taking too much. It's water-soluble, and you'll just end up with expensive pee. In our last story about vitamin B12, we've got one word for you— cyanocobalamin. Say that five times fast. I've talked about the optimal dose of vitamin B12 supplements for adults, as well as in childhood, pregnancy, and old age to prevent vitamin B12 deficiency. But what if you already have it? How much do you have to take to treat it? Your doctor might want you to get vitamin B12 injections, but oral B12, even for those who can't absorb it well, has long been considered one of medicine's best kept secrets. It's now considered well known that orally administered B12 supplements are as effective in overcoming deficiency states as intramuscular injections when you get up to taking 1,000 micrograms a day. How long do you have to take 1,000 a day for? It depends on how low your levels start out. Because B12 status in pregnancy is so critical, there's a suggestion that plant-based women get a check throughout pregnancy and to adjust supplementation as necessary. Note the recommendations for pregnant breastfeeding women are the same as everyone else over the age of 10. So if you're a teen or adult diagnosed with vitamin B12 deficiency, you'd take 1,000 micrograms a day for one to four months, depending on how low you start out, before going back to a regular maintenance dose of 50 a day or 2,000 a week, with toddlers and small children taking smaller doses. There are two main types on the market, though. Methylcobalamin, marketed as methyl B12, and cyanocobalamin, typically marketed as just vitamin B12. Methyl is more expensive, so it must be better, right? Wrong! Cyanocobalamin is the most used form due to its high stability. See, methylcobalamin is less stable than cyanocobalamin, and is particularly susceptible to photodecomposition, meaning destruction from being exposed to light. There's no advantage to using the light-sensitive forms of cobalamin, such as methyl B12, instead of the stable cyano forms, which are readily converted into the body into the type you need where you need it. The one major exception may be kidney failure, though. Methylcobalamin may be better for those with impaired kidney function. It's been speculated that oral methylcobalamin, or injected hydroxycobalamin, may also be preferable in smokers, though it has yet to be confirmed. Because methylcobalamin is less stable, you'd probably want to take much higher doses. So, for example, in those with kidney failure, you'd be taking 1,000 to 2,000 micrograms a day compared to just 50 micrograms of cyanocobalamin, and some with normal kidney function. Another reason to use the cyanocobalamin, as opposed to the more expensive kinds, is that it has a track record of safety and efficacy, whereas, for example, in one study, even up to 2,000 micrograms a day of methylcobalamin wasn't enough to correct vitamin B12 deficiency in one of three vegans they tested it on. The bottom line is that so-called coenzyme forms of B12, like methyl B12 or adenyl B12, also known as adenosyl B12, are not likely to be superior to cyanocobalamin, which is more stable. Cyanocobalamin appears to be best suited for oral supplementation, which is why I specify its use in my recommendations. Note I also recommend ideally taking it separately as a chewable sublingual or liquid supplement. Why can't you just get it as part of a multivitamin or something? Because various vitamins and minerals mixed into the same pill can destroy active B12. Forming B12 analogs, B12 locologs, that not only can our body not use, the analogs can be potentially harmful because they can inhibit the transport of what little B12 is left. That's why using multivitamins can even be counterproductive for the supplementation of vitamin B12, and this isn't just in theory. There was a tragic case of severe vitamin B12 deficiency in an infant born to a vegan mother who thought she was doing everything right, taking a multivitamin that contained B12, though it may have also just been an inadequate dose. Why chewable or sublingual? Absorption is boosted when the B12 mixes with saliva, since you secrete a B12 binding protein from your salivary glands that helps transport B12 safely through the digestive tract. Having people chew a tablet of B12 and their B12 levels go up 10 times more than just simply swallowing the exact same pill. Vegans boosted out of deficiency, chewing a B12 supplement, but nothing, and those who just swallowed it whole. Maybe they had some sort of absorption problem or something? No, because then if you tell them to start chewing it instead of swallowing it whole, their levels shoot right up as well. My latest book, How Not to Diet, I suggest a third option to B12 fortified foods and supplements, brushing twice daily with a B12 fortified toothpaste, which was put to the test in two double-blind, randomized, placebo-controlled studies. Participants were instructed to use the toothpaste two times a day for two minutes at a time, and indeed was able to correct the markers of B12 insufficiency in the blood of vegans and among the elderly. But that was on average. Unfortunately, it didn't work in every last person, which is why it's not included in my recommendations. Though, look, if you get your levels tested before and after brushing for a few months and they go up, then you can presumably stick with it. In summary, a vitamin B12 deficiency is not to be messed around with, with the potential to cause a wide range of disorders of the gut, blood, brain, and nervous system, with the ever-increasing demand for cleanliness in our food chain, which is a very good thing. It is of special importance that we secure a regular, reliable source, and the safest, cheapest, healthiest source is B12 supplements, or GreenLite B12 fortified foods. We would love it if you could share with us your stories about reinventing your health through evidence-based nutrition. Go to nutritionfacts.org slash testimonials. We may share it on our social media to help inspire others. To see any graphs, charts, graphics, images, or studies mentioned here, please go to the Nutrition Facts podcast landing page. There you'll find all the detailed information you need, links to all the sources we cite for each of these topics. For a vital, timely text on the pathogens that cause pandemics, you can order the e-book, audiobook, or the hard copy of my last book, How to Survive a Pandemic. For recipes, check out my new How Not to Diet Cookbook. It's beautifully designed with more than 100 recipes for delicious and nutritious meals. And all proceeds ever seen from the sales of all my books goes to charity. NutritionFacts.org itself is a non-profit, science-based public service, where you can sign up for free daily updates on the latest in nutrition research via bite-sized videos and articles. Everything on the website is free. There's no ads, no corporate sponsorship. It's strictly non-commercial. I'm not selling anything. I just put it up as a public service, as a labor of love, as a tribute to my grandmother, whose own life was saved with evidence-based nutrition.