Live from Seattle, Washington, it's The Cube at Tableau Conference 2014. Brought to you by headline sponsor, Tableau. Here are your hosts, John Furrier and Jeff Kelly. Okay, hello everyone. I'm John Furrier with SiliconANGLE. This is The Cube, our flagship program. We go out to the events and extract the symphony noise. We are here live in Seattle, Washington with Tableau's data 14 conference and it's exciting. A lot of news going on all around the web. Certainly, if you're watching this, you're also well aware of the Apple Live event happening in Cupertino and Silicon Valley. Where all the innovations seem to be around user interface. We're breaking that down, going under the hood here at Tableau's user conference. I'm John Furrier. My co-host this week is Jeff Kelly with Wikibon Chief Analyst and Big Data. Jeff, we're about to kick off two days of coverage here at Tableau. I gotta say, you couldn't ask for a better trend connect by having the Apple event going on live where they introduced the iPhone 6 with huge screens, the iWatch, I posted up on our crowd chat, crowdchat.net slash data 14. Apple, really innovating around what has always been the innovation, the user interface, user experience. We are seeing mobile and cloud really changing the game for everybody and certainly Apple with today's event highlights the Tableau's value proposition which is under the hood, analytics, visualization of data. And the keynote this morning, we heard the CEO talking about PostScript and PostScript, as we know, Steve Jobs and the original Apple really set the stage for typefaces which created the computer revolution. We are now living in a big data revolution and it's so exciting. User experience, this is all about the user experience and making use of the data. That's absolutely right and it is interesting that this show happens to fall on the same day as Apple's announcement around the iPhone. And we heard a lot in the keynote around, well, a couple different areas that I think are really important for Tableau. One is cloud, the other is mobile. So, for Tableau, they're growing very quickly. They have been called the darling of data visualization tool that data scientists love to use, business analysts love to use. Increasingly, business users, people who are not necessarily trained in data visualization or analytics are using Tableau because of the ability to manipulate data very easily. But there are, of course, a lot of competitors hot on their heels as well. You know, when Tableau kind of hit the scene, they position themselves as a modern alternative to more stodgy business intelligence applications like business objects or Cognos. But now that Tableau's been around for a while, they've got competitors that are younger and more maybe arguably more modern than they are. So there's a few areas, as I mentioned, that Tableau really has to focus on, I think, cloud, mobile and the user interface are three of those areas. And we're going to hear a lot about that this week. Well, we're excited to be here. We want to thank Tableau for sponsoring theCUBE to get out here and do the editorial coverage of this great event. And Tableau is really one of those new companies that have emerged out of this revolution around data analytics, cloud, mobile and social. Obviously, with social data, with all kinds of data, internet of things, you name it, data is the new oil, it is the new currency, it is the new value. And what you're seeing here is the revolution of making it usable. The user interface, it's all about the user interface. And again, I'm so excited, Jeff, because we're data geeks here at SiliconANGLE and Wikibon on theCUBE. We love to extract the data. And certainly, we're going to talk to a lot of folks here on the technology, and also talk about the future products from Tableau. And more importantly, the Tableau community, as it's called by the CEO, is really a community. They have a very loyal base of customers who love the product. It's really liberating. We see companies like Tableau and Splunk on a slew of other startups out there making sense of the data, from the randomness and the looseness of the data, from the diversity of data, making sense of it's the number one thing. And I got to tell you, it's super exciting, but Tableau has competition. They win public, they're still losing money, they're investing, they have partnerships, there's a lot of international growth, we hit start on an announcement today. And obviously, mobile and cloud continue to drive the mega trend of this transformation. And companies who aren't having a data science practice or having native data into all their products will be at risk of being irrelevant. So we will be certainly documenting that and talking to the customers, but I want to hear what people are doing with data. People are betting their careers on platforms these days and there are not a lot of solid platforms because it's an emerging market. I want to get your take. As people make bets, Jeff, on their careers, they need to provide value. Investment has to turn into value. What's your take and what's your assessment of that? Well, certainly, we hear a lot about all types of knowledge worker, whatever kind of line of business you're in, whatever area of the business you happen to be in, you've got to be able to be more data savvy. I think that's clear. The question is, how do you actually, what does that translate to in practical terms?  Or does that mean using data and the data points that are available to you, whether it's maybe not through an application such as a Tableau, that's actually integrated into your overall workflow? Is that a way to do it? So there's all different ways that data impacts the knowledge worker. Whether people are betting their career on this, I mean, certainly we've seen the explosion in the interest around data scientists as the big data theme has really emerged. There's a lot of skills that have to be kind of blended to be a solid data scientist. You've got to have the analytic skills, the visualization skills, but you also have to have the math skills and of course the business acumen. So there's a lot of opportunity for those types of people, but I think I wanted to go back for a second to the keynote today. So Christian Chabot, of course, is a pretty dynamic speaker. We learned that last year at this show. He gets the crowd pretty worked up and he's very, very focused and it seems Tableau as an organization is very, very focused on their customers. Being customer centric is another theme of kind of this modern economy and I think Tableau is clearly there. Christian talked a lot about in his keynote about enabling users to unleash their inner creativity. He kind of mentioned that this data visualization is not about kind of automating your routine tasks. It's about allowing users to be artists. He talked a lot about how creativity and unleashing ideas is really important for any kind of modern BI platform. However, he's never seen those words used in a modern or I should say in a business intelligence RFP. So he is trying to adapt. He and his company have really taken a new approach to BI and it seems like it's taking a little bit of time for the enterprise to kind of catch up and understand how to leverage these new tools. Now that said, companies growing like crazy as I mentioned, the most recent quarter, they announced they added 2,200 new customers. They're up to 1,500 employees. Revenue was way up, up 80% last quarter but they still they lost a little bit of money because of course they're investing heavily in both R&D. As Christian Chabot mentioned in the keynote, they're going to invest more in the next two years in R&D than they have in the last 10 years at Tableau.  So it's really interesting, going to be interesting to watch them as they adapt and see if they can keep their customer focus when they're growing at this break next week. You know, I agree with you. I think in looking at the keynote, some highlights to me that were fascinating. First of all, just to kind of disclaimer, I love Tableau. I'm a big fan of the company because two reasons. One is the founders built a business from scratch and bootstrapped it with customer, serving customers and then obviously they raised a huge round of financing on top of that and then obviously with that finance, they really needed it but it was for extra growth. So the founders built a viable business. They're company builders. They built a real business and then took on additional financing to give that rocket fuel that they needed to achieve the success they had. But the highlights to me in the keynote were very telling. You mentioned the creative minds unleashing the power of the creative mind. Again, a thread back to Apple, the Apple announcement today. The other comment was photography. This kind of reference to photography and how film costs money and then now when the cost goes to zero, when you have unlimited experimentation with photography, a whole nother revolution takes place and really the digital photography analogy really is viable because what that basically says is the cost of film went to zero, essentially. Then the unleashed creativity becomes paramount there. So that's the same exact trends you're seeing with data visualization. Essentially, data is the key asset in applications. And again, this is an ironic tie-in to the Apple event today because what Apple's doing is again, at a whole consumer level, leading this consumerization around data, apps, visualization, content presentation. The iWatch is a revolution. Not new, Samsung had one, but the iPhone 6, a bigger screen. Visualization is content just like photography. So I think Tableau's messaging and their vision is absolutely on the money. I think we are in the very early innings of this explosion of data visualization. And I'm just so excited. I think these guys are really well positioned. That being said, there's a ton of competition. Platform, all these other companies. Tell me, break that down for me. Well, there's absolutely a lot of competition. So there are, as I mentioned earlier, so when Tableau emerged, they really positioned themselves as a modern alternative to the more stodgy, the slow business intelligence, enterprise applications of the past. But, you know, Tableau's been around for a number of years now, and now there are new approaches to data visualization. Some based in kind of these new big data approaches, so you've got Hadoop specific visualizations, for instance. You've also got a lot of cloud players who are, and mobile players, mobile first business intelligence and analytic data visualization players that have come on the scene, that are putting pressure on Tableau from a, not necessarily from a competitive standpoint in terms of the revenue. Certainly Tableau is well beyond any of these smaller startups in terms of revenue and company size, and they've got stockholders, they're actually a public company. But just in terms of, they're putting a little bit of pressure on them to remain cutting edge in terms of their mobile capabilities and their cloud, their software, and service capabilities. So the good news is we did hear a little bit about that today in the keynotes. So we heard a little bit about something that's called Project Elastic, where Tableau is really creating a new mobile application. Dave Storey, who's going to be our first guest coming up in a moment, talked about really rewriting Tableau for the tablet, really making it intuitive, really focusing on people who are not power users, really just business users, even consumers potentially, to use this new application to analyze all that data that's in your iPhone from your Fitbit app or whatever healthcare app you might be using. So that's interesting. And in contrast to Apple, we talked about some similarities with Apple. The contrast to Apple is, while Apple gets a ton of covers, they are still a pretty, they've got about 15% of the mobile phone market. I heard their former CEO on CNBC this morning talking about how one of the sayings inside Apple was we sell to the people who love us. So Apple, despite all this coverage, is really not a huge consumer mass product like a Samsung, like the other smartphones out there. It is a fairly elite group that uses a lot of the Apple products. Come on, it's the number one selling smartphone. It's got 15% share. It's not exactly like it's got an overwhelming market dominant position in that sense. It's clearly the best integrated software hardware smartphone, but it's not the, I don't think you could argue that it's got the traction in terms of the larger market, worldwide market that some of the Google and Android phones have. They're just less expensive, the Android phones. So anyway, my point, and please take, let me hear your opposing view, but I think that the point is Tablo is trying to reach the entire audience. Is the most dominant iPhone on the market period. Android has more market share, but again, that's on pure volume. In terms of sales, in sales, iPhone dominates, and it's not 15%, it's 42% market share, so I wouldn't call that shabby. And so, certainly, Android has the quote share lead. But iPhone is definitely a dominant phone, it's not 15%, just to get the numbers straight on that. But the thing is, is that the iPhone and the iPad have 80% market share, 54% market share, the iPad has 80% market share, but this talks about the project elastic. This brings up some of the leadership things. So to come back to the Apple thing, what I would say about Tablo is, Steve Jobs and Apple, when he took it over years ago, now they're obviously one of the most performing companies in business history, it was about building great products. And to me, I see that we are in this modern era of rapid innovation, rapid life cycles of products, softwares eating the world, whatever you want to say, you are seeing product leadership being rewarded at great lengths. And so one of the things about Tablo has is that they have market leadership on the product side. So product leadership always will trump other gimmick-oriented products. I think the eye watch may be a little bit of a gimmick, but I'm going to definitely get one. So that's what I'm looking for, Jeff, is here, is to look at the product leadership capabilities of Tablo, what are they doing to advance the products, and two, what are the customer use cases for the successful next generation visualization? Visualization, as we've been covering Hadoop for now four years now, big data analytics, the killer app is visualization. So we want to dig into the hood. Well, I think the killer app is visualization, but it does need to be tailored to specific use cases, to specific users, whether that's a vertical focus, whether it's oil and gas industry, retail manufacturing, but even then digging even deeper into the specific role, whether you're a salesperson on the front line, whether you're in the manufacturing side of the business, and then from a, I think those are where some of the killer use cases come in, and which is interesting, this morning, we saw the announcement around some partnerships Tablo is established with some application providers that are vertically focused in healthcare, retail, and other places. So I think that's a good strategy from an OEM perspective for Tablo, because I think one of the challenges of a horizontal platform, a horizontal business intelligence platform, is that it gets you 80% of the way, but kind of getting that final 20% can be a challenge. So by aligning with some of these more vertically focused application providers, I think that's one way to kind of close that gap and kind of increase its usefulness even further. Jeff, we're going to have some fun with the Apple. You know I'm an Apple bigot. I live in Silicon Valley, I love Apple. You're more on the East Coast, so you don't have that loyalty like I have, but we're going to have some fun. I think comparing and contrasting to Apple will be fun. We can debate the different market shares, because I think, depending on how you look at the international market, say China, for instance, the fragmentation of the numbers, I don't believe. First of all, IDC reports weird numbers, so I'm not necessarily going to give them any credit on having accurate numbers, but if we look at total volumes, we will look at that. Either way, the verdict is clear. Smartphones are the preferred user interface. Data First is the strategy for companies, and visualizations will be the key. So we're going to be breaking it down here, inside theCUBE, here live in Seattle, Washington. We are here at the Tableau Data 14 conference. If you want to join us, you can tweet us at crowdchat.net slash data 14. Go to crowdchat.net, our new engagement container technology in public beta right now. You can just sign in. You don't need to get a beta request to comment. Go to crowdchat.net slash data 14. Join the conversation. I'm John Furrier with Wikibon analyst, Jeff Kelly, talking big data visualizations here in Seattle. We'll be right back after this short break.


Hello everybody welcome back to another mid-journey tutorial going to show you how to combine art and images in mid-journey to make unique creations art and artists with images how do you do it first step you want to go to your finder or your explorer and grab the images I'm going to grab the first image will be let's go with Queen Elizabeth and I'm going to drag and drop that and I'm going to hit enter so it's now inside mid-journey so you'll see once it's done uploading there we go I've got it now I'm going to grab the other image I'm going to use this red-headed lady and she's going to go inside it too so I'm using these because you know Queen Elizabeth was a famous red-headed queen and we've got this attractive red-headed lady and let's see what we can make in terms of like some sort of new age monarch okay good now the next step is you want to go and you want to type in forward slash imagine and then hit enter and that gives you the prompt now I'm going to click on the left click on the Queen Elizabeth which is the art and then I'm going to right click and I'm just going to copy that link and now in the prompt I'm going to command V on a Mac control V on a on a PC and paste it in going to hit space bar now I'm going to do the same thing I'm just going to go ahead I'm going to click on it copy link although you can do it the other way and now I'm going to paste that in when I do this this mid-journey version 4 automatically knows to combine the images let's hit return or enter and see what happens here you go you're going to see that it's waiting to start while it while it does its thing I'll show you one other thing you can do imagine and then you can come you know take the two shots combine them like this and then let's go ahead and grab the first one here actually before I forget we're going to take Queen Elizabeth copy that link drag and drop that in now we've got both of them in there now I'm going to hit space bar and watch this I'm going to go on a beach low angle shot oops low angle shot so you can see here we can actually give it ideas and oh wow that's coming out like Ronald McDonald so far low angle shot head tilt and photo realistic there you go and I hit enter now we've given it we've not only combined the images but we've also combined them and giving it ideas as to what we want and you can actually work by doing this you can combine high quality pictures or photos like this with art and it's a blast I'll come back when this one's done and we'll show you what we got all right welcome back so here's the first set where this is just the two images combined together together with no prompts with no descriptors and it has done an incredible job this looks a lot like the lady in the picture and it also looks like Queen Elizabeth right down to the dress with some of the cool patterns on the dress on this one we put her on a beach with a low angle shot head tilt photo realistic click on it incredible work like look at this this looks actually that looks like a girl I dated years ago amazing this is how you take a piece of art and a photo and combine them inside mid-journey


Terrence, how are you, mate? G'day, mate. Let's go for a bike ride. I'll just go grab my... Oh, for f**k's sake. What's wrong, mate?  You don't know. Know what? You're wearing white bibs, mate. Yeah, so?  Well, stop looking down there, mate. Have you ever heard of the saying, stands out like dog's balls? That's what we're talking about. Right, there. It's... blatant. Well, what do you want me to do about it, mate? It's easy. Just wear dark-coloured bibs like the ones I'm wearing. Being the magnificent Peddler bibs. Easily the most comfortable bibs I have ever worn. And as many RCA members say, once you've gone Peddler, it's pretty hard to go back. There'll be a code down below, CAMNICLES10. Peddler, don't normally give out these codes. I've had to push them a little bit. Thank you, Peddler. Check it out below. A little bit of commission comes back to supporting the channel. I don't have dark-coloured bibs, mate. You can borrow a pair of my Peddler bibs. That's fine. I'll go get something. Hang on a sec. You want me to wear your bibs. So what you're saying is you want my bowls to touch your bowls. Mate, they're washed. They're cleaned. And most importantly, they'll hide that weapon of yours. No, no, no, no, mate. I'll deal with that thing for this one ride today. And can you just promise me in the future you'll wear some dark-coloured bibs? Is that thing moving? Probably. That's impressive, mate. But you will wear black bibs for me in the future. All right, done deal. Done deal. Mate, I'll just grab my bike. Let's go. Oh, for f***'s sake. What's wrong, mate?  I'm done. I'm out of here. Enjoy your ride.


Educating children is one of the best ways to build fire safe Victoria for generations to come. Not only can children be influenced for life but they'll often go home and influence their families as well. The fire safe kids program has been developed for pre-primary through to grade 6 students. Fire Safe Youth is a new program developed for secondary students from year 7 through to year 10. Today, April Himmelrich from the Basin Fire Brigade is at the local primary school to tell us more about these programs and how you can get involved. Our endorsed and trained CFA volunteers and career firefighters will go along and present a lesson including fire safety messages with an age appropriate fashion. So they'll include lots of fun activities and using the mascots like Captain Koala and all of his friends. The fire safe kids programs are delivered in the school environment in the classroom perhaps alongside the CFA mobile education unit. There are a variety of lessons. Most are based around home fire safety or the bush fire safety and prevention. As a brigade member you could get involved in the program by becoming a trained presenter. You would need to complete a two-day training session and you would need to be available during the school hours. So you could talk to your captain about this for more information or you could get the information from your community education coordinator at your local region.


Uniform neck ties can be tied with any type of standard neck tie knot that presents a neat military appearance. This video will show you how to successfully tie one of the most common knots, the Windsor knot. Start with a tie around your neck. The wide end of the tie should be on your dominant side and the small end on your non-dominant side. Take the wide end and cross it over the smaller side. Then bring that wide end up and through the loop formed at the neck. Once you bring it through, overlap the wide end down to the right side of the small end and then loop behind the small end towards the left. Bring that wide end from the left up to the front and through the neck loop. Take the wide end and cross it over the smaller side.  Now that you've tied a tie, let's make sure your tie agrees with the Marine Corps Order 1020. The tie is between half an inch above and below the belt buckle. Now you're good to go. Also, don't forget to place your tie clasp between your third and fourth button for the top of your khaki shirt.


With just five minutes on the clock, starting from scratch, I'm gonna build the absolute best man team I can. I've spent millions of coins building teams, but something I've never done is had a time limit. So, I'm gonna start a stopwatch for five minutes. The rules are simple. Soon as that clock hits zero, my hands are off the controller. The only other rule, the most I can spend per player is 100K, but we've got a lot of positions to fill. There's 13 positions to fill. Again, only 11 on the field at a time. Can't forget about special teams either. Start. All right, let's go. Player, instead of going for all the perfect positions right off the bat, I'm just gonna go quality 86, 87. I'm gonna go all type, all offense. All offense.  Let's start it up. Brady, no, I don't want Brady, but Gabe Davis. Gabe Davis is a beast. Let's start right there. How much time? We're only 30 seconds in. You're shitting me. We're not only 30 seconds in. No, I don't want my rewards right now, bro. Okay, wide receiver, great. No, I don't want Brady. I don't want Wentz. Oh, dude, Donald Parham is absolutely insane. This guy's massive. Insane tight end, insane wide receiver. Let's get it. I need to pick up a hat back. Nick Chubb, no, Jonathan Taylor's 147K. Okay, Nick Chubb, it is. Nick Chubb, congrats. Welcome to the squad. Holy shit, I thought this was gonna be way easier. What? How expensive are you? Oh, let's just go 84, 85, all offense. I just gotta start picking up positions. And at 230, we gotta go to defense. 230, we gotta go to defense. Give me some online, bro. I don't want Kyle's Juicy Juice. Okay, Isaiah Wynn, fine. Oh my God, this clock is ticking so fast. Why does it pop this up, dude? I don't care. Just let me in. We might just have to bail on offense, bro. Left guard. This is so hard. All right, as long as we out here, we got a powerhouse wide receiver, powerhouse hat back. We got a solid offensive line and a great tight end. Okay, this is actually good. I could be going 86, 87, because these guys are cheap, but I'm scared that I'm not even gonna get them. Let's get free safeties in corners so we don't get torched over the top. Let's go right there next. All defense. Not 84, 85, but give me 86, 87, right? Dude, I'm starting to think the way 2K does it is actually pretty smart. You know 2K lets you buy the players and it just goes to your collection bin or whatever?  I have two minutes after you shitting me. Oh, it's all linebackers right now. Darius, Liner, Josh, Allen. Linebackers are filled out. I don't have a great user right now, but I'll be able to sub somebody in. Winfield, sure. A minute 30, bro. This is actually impossible. Oh my God, I've never noticed how laggy. I have always noticed how laggy it is, but I've never really noticed it till right now, till I'm in absolute shambles trying to build a squad. Darius, Sleisher, first thing I see. Okay, let's get a stud then. Let's get a stud. Get an amazing corner. He's gonna have to just do like full clamps for us. Is that a gross overpay? I can't even tell. Denzel Ward, 70K, damn, whatever. He's a beast. Corners, free safeties, corners, free safeties, linebackers. I told you, I'm a professional YouTuber. You can still see that. You can still see that. Let him on, sure. Welcome, buddy. Welcome. What am I missing? 25 seconds, what am I missing? No D-line. I need an MLB, MLB, I need a user. I need a user, I need a user. Anzalone, sure. Five, four, three, two, come on.  Anzalone. Quick question for you.  Now, trust me, I see you guys' comments. I know you all think you could beat me. That's why I'm partnering with Run Your Pool on an awesome giveaway. Run Your Pool is the premier sports pool hosting service. That could be for anything. March Madness, Fantasy Football, NFL Pickham. You could win a copy of Madden 23. Madden Cash to open some packs. And a chance to compete against myself and your other favorite Madden creators. All you have to do is join the Madden Creator Pool. It's a weekly NFL Pickham contest and we'll be giving out prizes every single week of the NFL season. Literally all you have to do is pick the winners of each NFL game. If you pick the most games right, you're gonna win a prize. And of course, the absolute best part, it is completely free. So if you think you're always gonna win some NFL games, you've got a real good shot here. 10 people are gonna win a copy of Madden 23. First place each week is gonna get $25 in Madden Cash and we'll be giving away jerseys to the top three finishers. I recommend getting a Zach Wilson jersey but hey, it's up to you guys. So click the link in the top of the description. Join the Madden Creator Pool and Run Your Pool.  I hope I see all the boys there and enjoy the rest of the video. Shit! Oh my God, I didn't pick up a corp! Oh my God, no bro! Bailey Zap, but I'm thinking I can't wait to sub this guy out. I don't have anybody! Oh my God, because Brady and Wentz were there and I didn't want either and I think I was thinking I was gonna go back and, oh my God.  All right, Bailey Zap, you gotta take us to the promised land, buddy, because I absolutely goofed that. All right, half back, I did get an awesome half back. Wide receiver, I got Gabe Davis. That Gabe Davis is amazing.  Donald Parham straight up might be the best tight end in this game right now so I'm happy we got him. I got half an O line and no quarterback. What was I doing? Damn, I thought this was gonna be so much easier. This is what we have on offense. Khalil Shakir, Kyle Phillips are still getting reps. Nick Zakelji and Lysina Smith, those are tough names. Wow, I really did not think this would happen. I'm not gonna lie though. I actually picked up a lot more on defense than offense and I think just kind of riding on the coattails of our defense is gonna have to be the strategy here and I think we'll be able to do it. So to save time, I actually doubled up on free safeties instead of getting a legitimate, legitimate strong safety. The only problem is these free, oh, I should have gone double strong safety because free safeties can't play sub linebacker but actually that's okay. That's okay because I actually did pick up a middle linebacker as my last purchase. I do like our outside linebackers though. Josh Allen and Darius Leonard is an amazing outside linebacker core and a lot of times I don't use four linebackers on the field anyway so this is all we're gonna need. So we are a 77 overall. Let's make sure we mess with, so specialties can't really mess with we can put in a kicker turner just in case by some miracle we're able to return one. I'm gonna go reach for it on Nick Chubb. Don't know how good that is this year but it is two ability points now and he used to always be one. Recuperation and freight train. Literally I'm gonna have to run the ball to the left with Nick Chubb or get absurdly lucky with Bailey's app. All right, I'm gonna give him on the ball. I'm kind of worried that with no D line my opponents can be able to run the ball against me like really, really effectively. So I think making our left outside linebackers like prepared to stop the run. I'm gonna go unstoppable force on both. Definitely my favorite ability. I'm Josh Allen. I'm gonna go out my way, dominant impact, blocked wins versus wide receivers, hat backs and tight ends. It's been a long time since I played with a silver quarterback because in Wheel of Mud I always have a quarterback. 77 overall, Bailey's app. We gotta look at the captain of the ship here, Bailey. 63 speeds, 73 throw power, horrible accuracies but he's got 71 shorts. I think, what am I talking about bro?  Is this a Super Bowl? This guy's in a Super Bowl. This guy's gonna be so happy bro. Probably going into one of his first Super Bowls of Man 23 and he sees this lineup, bro. He sees Bailey's app in the middle of the huddle. Carson Wentz, does he run the ball to start out? Absolutely he does. Great job gentlemen. Could throw underneath. Could throw right here. Where are you throwing, sir? Where are you throwing? Don't tell me I'm gonna take a Super Bowl from this man with Bailey's app, bro. Dude, he's looking at Bailey's app right now. Probably like, bro, who is that? You know he's just so beyond confused right now. This is gonna be so hard. There's Nick Chubb, great throw. Way to get the first. Move the sticks. There he is again. Great catch. Good job, Bailey's app. Well he sees it, but great block. Chubb, let's go.  Oh, there's Nick Chubb. Great ball, run through him. Yes, Nick Chubb. Beautiful, wide open. Kind of a sketchy throw. That was really slow coming in. But it's third and two, nice work. Go right up the middle. Got it, got the first. It's all we need. I'm going to him.  Where was that to, bro? All right, I'm running to the weak side. I just don't think he expects a great hard cut, but J. Ron Curry's got through. I really need a touchdown. I'm looking for Gabe Davis, or I'm looking for Donald Parham here. There's Davis, there's Davis. Great throw, great catch. We're down to the- Bailey's app, baby. Himmy, Himmy Neutron. This is a super low. Dude, we got a turnover and a touchdown. Every possession is very, very, very important here. Please tell me I didn't just get a loss for that. 400-mock coin, source seasons pro loss. Ah! Ah! It's so dumb, dude, my wifi's still going. Everything's still perfect.  All right, well, let's start a new season. See if Bailey's app can go off once again. I'm in such a good time with Bailey's app, bro. Wow, nice team by my opponent.   It's Ray Rice. Oh, he's drunk and dead! Oh, that could have been spooky right there. Second and seven. Dude, EA ruined Bailey's app's career day. Now I'm playing Daniel Jones and he's kind of got me up. Does he run it again or does he get spooked now and pass it? I feel like he gets spooked and passes. Ah, ah, that's bad. Tough, nice study. Also, just fun fact, I did just DM- I did just DM Breeze Hall. He said, bro, we gotta hop on the game soon, so. We don't care. We don't care. First and 10 down by seven. Let's see what you got, Zap. Keep the passes simple. That's what I love about you, Bailey's app. He's honestly consistently hitting the easy passes though. Like, I'm gonna go Nick Chubb here.  Bro, oh my God.  That was one of the most frustrating things I've ever seen. Nick Chubb sat there stuck on the linemen. Eight or nine seconds and then ran up field instead of running his route. And then Bailey's app threw it to Michael Barson. Does he run it? I'm in trouble if he does. He doesn't. Okay, I got a shot here. Halfback, halfback, halfback. Go, go, go, go, go. I'm getting laser beam. This is a sad, sad day. Great throw. All right. He jumped a little early there. Dude, Bailey's app's career day now has one interception on it, dude. No one is more upset right now than Bailey's app. Oh boy. I'll go tree, bro. Who are you? That's like my backup tight end. Just slang it out there, dude. Proud of you. How does he just user detackle? All right, third and sixth. Oh, big blitz. Dude, linebacker blitz zero. I'm playing a true cheeser, bro. Damn, I was having a great game in the Super Bowl.  But hey, great pass, great completion. Let's go get a touchdown. Beauty. Hold that block, Parham. Oh, Parham had him for a little bit but lost it. He had held that. It's a tutty. Block, Parham, now we're gonna throw Gabe Davis underneath. Yup, yup. Great angles, great angles. Dude, it's kind of weird. Every time I run the ball, he switches to a detackle. Like before the play. All right, why is wide open? Okay, Kyle Phillips, you caught it. I am proud of you for that. I had Parham.  I think I gotta run that again and I got a laser beam at the Parham, dude. He was so open. It's the next shot with nine seconds left for on the three. Bailey's up is him. Let's put up a pointer too, boys. Donald Parham, Donald Parham.  All right, I say we go Donald Parham because this is man coverage. Donald Parham, I need you here, buddy. Ooh, bad ball. That was honestly, I liked that, bro. He's in man coverage. It's a one on one. He's a big guy. I gotta trust him here. Go, go, he's there. Damn, nice play. And that's gonna be 21-0. Damn. I don't know. Maybe if I had, wow, Shiloh Shakir.  You really almost made that tackle. I think if you have a better quarterback, they throw that ball a little faster and it's actually a touchdown. Or maybe I should aggro it, but I'm gonna save us the pain of getting washed 42-0. Damn, man. I just wish I could have played that Super Bowl. Bailey's app was having such a good day. That's the five minute challenge right there. If I ever do this again, I promise I won't be getting a quarterback. I'll be using Bailey's app because he's him. All right, boys. Hey, I love you. Thanks for watching as always. I'll see you guys in the next video. Peace.


Good morning all. Mr. Mayor, I am Christopher Chacarico, Senior Executive Director of the New York City Public Schools Office of Food and Nutrition Services. And at this time, I'd like to welcome to the audience Chancellor David Banks. Thank you, gentlemen. This is a special day as we kick off the New York City Public Schools' Chefs in Schools initiative. It's been a long time coming, and we're very happy to begin this work. Last year, we developed several recipes with the Chef's Council. And we are very thankful to our partners at Wellness in the Schools and Nancy Easton. Please give them a nice round of applause. Thanks to this Mayor and this Chancellor, we are transforming the way we feed children in New York City. And without further ado, I'd like to invite the Mayor up here to speak a little bit about that. Mayor Adams. So much really, really excited as I look out and see, you know, the food service workers who are here. When I was in school, our office were not that cool, you know? And my mom was a food service worker. And mommy did more than serve food. She, you know, there was just a, in every spoonful, there was a spoonful of just really love and commitment. And she treated each one of the children at Amstead Daycare Center as her own. And those children walk past your serving locations or how, what the Chancellor is doing, to really change the structure of our cafeterias and turn them into experience. We all want experiences when we go out. And what we are doing around food, this whole team, is just, this is just so bold. And just when people talk about reimagining schools, they don't really focus on the power of food. And I've been talking about it for some time. And, you know, sometimes, you know, you lose votes when you talk about taking away someone's hot dog and pizza and some of those other things, but it's the right thing to do. I waited until I was in my mid-50s before being diagnosed with type 2 diabetes. The doctor told me I was going to be blind in a year. He said I was going to lose some fingers and toes because of the late stage of my diabetes, high blood pressure, cholesterol was high, had an ulcer.  I walked into my doctor's office not taking any medicine. And I walked out with nine different pills. You know, I felt like Dwayne Reed by the time I walked out of here. And, you know, I just really believed that I needed a fighting chance. And it was amazing that when I went home and googled, reversing my diabetes and not living with my diabetes, all this information came up about food.  In all those years, I thought it was my DNA. And it wasn't my DNA, it was my dinner. It was what I was eating. And that's the mission that I have been on because food is not only connected to our physical anatomy. It is connected to our emotional stability at the same time. And we started this journey several years ago with my team. One of them is here now, Rachel Axerson, who has been with me throughout this entire journey. Criss-crossing the globe. And if you ever want to lose friends, start telling them to stop eating something that they eat. Or, you know, no one invites you to dinner anymore.  But what we want to do is not to criticize or critique. We want to inform. We want people just to make the choices that they need to make. When I look at my five siblings, each one of them are going through some major health care crises, from cancer to early signs of dementia, to just chronic diseases. And I slowly introduced them to a healthy lifestyle. And if someone would have just given us this information earlier, it would have changed the trajectory of my mom, who I lost two years ago, to diabetes and heart disease and high cholesterol. And all of you, I'm really sure if you were to close your eyes and do a reflection, every one of you knows someone that's going through a chronic disease if you're not going through it yourself.   You sit down at the keyboard and you're thinking about that next test. You're thinking about the next operation. You're thinking about hospice care for your family member. You know, I think about my older sister now, who she's just got admitted into the hospital a few days ago. She has been going in and out of the hospital for the last few months. And how empowering it is to something simple as changing your diet. And that's what you guys and ladies are going to do. You are going to take these children, who the numbers of, I think it was 70%, Rachel, the last number, 70% of our 12-year-olds have early signs of heart disease. That's just unimaginable. And it's not easy. Food is like crack. You get hooked on food. And when I changed my diet, I used to wake up in the middle of the night dreaming about fried chicken.  You just feel addicted. And then our babies are inundated with all of this bad food everywhere they go. You go to my affluent communities. They have whole food. Go to the South Bronx and Harlem. They have junk food. Every public housing, you see all the junk food that's surrounding them.  We're pumping them up with processed oil filled, sugar filled, unnatural, unhealthy food.  And we're going to change the dynamic in a very bold way. The country will follow us. We're on the right side of history. We're on the right side of history. And so Nancy Easton and the whole wellness and school team, we've been rocking with them for a little bit. We've been doing our thing around healthy food. It's the foundation and the basis of life, this new program of chefs in the schools program. Just your look.  That alone is going to tell children something different is happening here. Just your look. It says something is going to happen differently. And over the next two years, 60 wellness in the schools chefs will offer individualized culinary training to all our school workers and 1,200 school builders. This would help you guys develop the skills that you need to prepare new plant-based culturally relevant meals cooked from scratch. And we are launching this for with all our public schools students. Food must look good. They must taste good. That's my theme music. I normally walk on to Jay-Z. I gave him an award last night. It was good seeing him. And you know what's interesting about food, Rachel? When Beyonce decided she was going to go plant-based, millions of people started looking at it. That's the power of incredible messengers. So these meals will provide more than just nutrition. They would expose our students to flavorful and healthy eating, because food have to taste good.  You know, it has to taste good. Like you think about Miles, a food service worker at PS 165. This story, I enjoyed this story so much. Fatima, an inquisitive, an energetic third grader who came up to him on the line and said, I only want salad today. That says it all. And he talks about how impactful it was looking in our eyes, understanding that our children are thinking differently. And you know what? These babies are ready. They are ready. They want to grow good food. They want to see it. They want to put it on their plate. They want to eat it. They want to try something different. And you are at the forefront of it, right here in the city. This is the greatest city on the globe. So that makes you the greatest school food employees on the globe. That makes us the greatest public educational system on the globe. Let's make it happen. Let's heal young people one plate at a time, one meal at a time. Thank you so much. Thank you, Mr. Mayor. Your vision has inspired us to do this work. With that said, Chancellor Banks has tasked us with reimagining the dining experience in all of New York City schools. Not only that, but he's allowing us, supporting us to create these healthy, plant-based, innovative recipes to have children eating healthy in all of the buildings we serve food in. With that said, I'd like to invite the Chancellor of the New York City Schools, David Banks. Morning, everybody. We can try one more time. Morning, everybody. It's good to see you all. The Mayor's feeling good. We came in. The sun is out. I mean, we were under the rain clouds. Assemblymen for so long. And it starts to have an effect on your psyche. It really does. So I'm very appreciative to have the sun out and warm weather. It feels good. And it feels good to be here with each and every one of you today. This is a beautiful facility. It's a beautiful, like, old school auditorium. And the energy that we felt even as we walked into the lobby, right, Mayor? You could feel it. A tone gets set when you walk into a school from the very beginning. From the folks who greet you at the front door. And so I want to say thank you to everybody. It's Principal Nacotri here with our school principal. Where is he? Principal Nacotri, thank you so much for welcoming us here to your school this morning. You cannot have a great school without a great school principal. And I see our superintendent here as well, Gary. Thank you so much, man, for being here for your leadership as well. I'm going to be very brief. We are here in so many ways with this level of innovation because of our mayor. I'm a person who believes in healthy eating. I could do better. But I get it. I'm not a person that's locked in on old habits. Like, don't tell me about changing my dietary habits. I believe in health. I believe in taking care of yourself. Many people don't know that when I was in the 11th grade, I started reading books myself about healthy eating. And one book in particular by Dick Gregory, political activist, comedian, but he became a health czar as well. And it was called Cooking with Mother Nature. And because of my reading that book in the 11th grade, I stopped eating red meat on my own. Nobody else told me to do it. I was just educating myself. And I've not had any red meat since the 11th grade. I have raised four children. None of them have ever had it. And they never missed it. They never ate any pork. There's a lot of processed stuff that they never had because they don't miss it because they never had it. And I think that's what the mayor is trying to say. If we in fact want to change these health challenges that we have in our society, you have to start as early as possible. And so that's what this is all about. For every one of us who are adults in this room, who all went to school, from the beginning of time, kids have always complained about lunch in the lunchroom.  That's always been the case. But what the mayor is talking about is how to ensure healthy eating. But how do we make it something where the kids don't dread going into the lunchroom to eat? You can make it sexy. You really can. And it can be fun. As the mayor said earlier, he said, you know, it's got to taste good. But I also said to one of my friends here with the chef, it's got to look good, too, on the plate. That's the first thing. And before you taste it, your eyes are being introduced to it. And so all of that matters. And that is why we brought so many of you together as chefs and celebrity chefs to come together to help us. Help us make this appeal. Help us make this something that everybody would want to be a part of. I'm so appreciative deeply, really, for the mayor's leadership on this. I'm just trying to activate as much as I can on his vision for doing this. Because as I came into this office as Chancellor, this was not necessarily my major priority. It had a lot of issues that we have in our school system. But I'm so glad that he has been so steadfast on this because you can dramatically change lives for the better over the long haul when we get it right. So many of you have spent the last year creating these scratch-based menus and really putting your best thinking and your best skills together to come up with those menus. And so we are thrilled now that we're getting ready to go to phase two. And Kate, Nancy, and everybody who's been really driving this and leading this work, thank you. Because when we think about professional development in our schools, it's always been about teachers and reading and math. A level of significant professional development for our food service workers to take their work to another level that's never been done before. Not like this. Not like this. That all is part of the re-imagined school experience. Because if kids are walking into the cafeteria and saying, I just want to have salad today, think about how cool that is. That's transformative. Who says that? And you're right, man, the power of celebrity as well. So when the Beyonce's of the world is so many of these celebrities who now become vegans or more healthy eaters, young people pay attention to that. And they also pay attention to our mayor, who they see every day, who is a celebrity in his own right. He don't have as many followers as Beyonce, but that's OK. He got more than enough. And the kids in New York pay attention. And they hear it. And it matters. And so bringing all of you together, we can't thank you enough for what you've done and what you're getting ready to do. Rachel, thank you. Rachel Atchison, I met Rachel before we even came into office. And she's been a right hand for the mayor. But on this issue, this has been her issue. This is her passion point. She believes deeply in this. And you have to have people who believe deeply in that that it's actually going to push something to the finish line. We're all here because of you, Rachel. Your passion for this, coupled with our mayor, you got him to write that book. He put the word out. And it made it the values that the mayor says are important. People will move based on that. And we're all here today because of that. And kids' lives are going to be better. They're going to be healthier because of that. All of you as our chefs, thank you. All of our ambassadors, Chris, who are in your office, who've been working to do this here, thank you. God bless you. We're going to actually transform the lives of kids in ways that you may not appreciate today. But you'll see it over the long term. And a lot of times, elected officials don't invest in things like this because you may not see the payoff until later on. But we have a leader who said I'm making the investment in the long term because it's the right thing for kids. And we can make it sexy at the same time. So let's go do it. Thank you, everybody. Thank you very much, sir. We owe both of you a thank you because you are allowing us to do this work to improve school menus across the system. So thank you very much. I also want to recognize some other folks in the audience. Kate McKenzie, Mayor's Office of Food Policy, Emma Videra, the New York City Public Schools COO, Deputy Chancellor, who also give us the support and allow us to do this work. Now let's talk a little bit about this work and what we are doing. We have cook ambassadors across all the districts in New York City that are going to be working closely with the chefs in schools as well as all schools in their districts. So I'd like to bring up at this time Lisa Davison. Lisa Davison, our coordinator of kitchen learning and development. Lisa. Good morning, everyone. So it's having the opportunity to really share in our accomplishments and get together that make me really appreciate the magnitude of the work that we're doing here together. And I know I speak for the majority of the people in this room when I say that it really is about the outcome and seldom about the process. Whatever the task is, we get it done, right? So I'd like to take a moment, an opportunity to celebrate this process and our work together and how it'll shape our future in our office. So in our collaboration with Wellness in the Schools and the Chef Council, we are beginning to do something that's never been done before. And the magnitude of that as the mayor mentioned and the chancellor mentioned is gonna be felt nationwide, okay? We are changing the way students eat and how they think about food. And that is no small task. So thank you for your continued support in our work and your belief in our vision. It's felt throughout this entire organization. And to my Cook ambassadors, not only are you going to be asked to continue to serve the 32 districts in which you live, but your efforts in creating recipes, continuing to uplift others is gonna pioneer the way this organization imagines professional development and how we continue into the future and how we affect the students that we serve. And you do it all with a smile, every single challenge, and I so appreciate that. And to our mayor and our chancellor, everything we do for these students is because we have your support. And reimagining what our cafeteria experience is gonna be is the foundation. So I thank you from the bottom of my heart and from our office because I know that with your vision, we're gonna continue to change the world. And this is a national celebration. Thank you. Appreciate those words, Lisa. Now, our last speaker, chef Turner. Where is he? See him, he's gonna talk a little bit about the chefs in school's work. Thank you for the warm welcome and good morning. First, I wanna say it's an honor and a pleasure to come and speak before you today, Mr. Mayor. My name is Turner. Some of my friends call me royalty here in New York City, but I'm here to talk about wits. I'm a chef with wellness in the schools here today on behalf of my fellow chefs in the schools. Although we've only just begun in September, I can personally attest to the impact of this nonprofit initiative. I've been assigned to two schools, PS310 and 160 based in Brooklyn, where we can see the excitement beaming from the children's eyes at the sheer sight of a new dish. Even more so, it is inspiring and reassuring to know that these recipes are plant-based, scratch-cooked, and culturally relevant to the student body of New York City. As a child, I personally adored my fair share of obstacles, navigating life as a husky kid. Now, health and wellness is of the utmost importance to me. And this all started with the foods I decided to eat, and that keyword is decided. At PS160, the impression of a chef in a public school kitchen has already begun to produce positive results. Our lead cook, Margaret, has begun to grow fond of rallying her team together each morning for a wellness check, where we break down the day's workload, and we also just take that time to say hi and check in on one another. This is one shining example of a lasting impression our work provides. But why, you might ask? Well, besides growing up with a lack of nutrition, we believe that the engine to these children's success is fueled by whole and nutritious foods. It starts in the cafeteria.  In the beginning, we were pushed to believe that the kids don't want vegetables. They don't like it. I come to find that this cannot be further from the truth. In fact, they are craving them. It is up to us as responsible adults and leaders of our community to give these students access and knowledge to real food. Thank you so much. Appreciate that, Chef Turner. It's really important that we always ground us up in the work that we are trying to do to make the lives of New York City children better. I have two small asks before we actually stop this and move our way to the back. The main ask is going to be if I can ask everyone to stand up. We knew it was gonna be hard to get a picture so we figured everyone stay right in place. We got a photographer right behind us to get a nice picture with all of us to commemorate and start this work. Thank you very much. Chancellor and Mayor, there are some samples in the back of the food that we're serving. Thank you. Thank you guys. Actually...


QuickBooks Online 2024, new customers set up and accounts receivable beginning balances. Get ready, because we're going to Bookkeeping Cloud 9 with QuickBooks Online 2024. First, a word from our sponsor. Yeah, actually, we're sponsoring ourselves on this one because apparently the merchandisers, they don't want to be seen with us.  Like our crunching numbers is my cardio product line. Now, I'm not saying that subscribing to this channel, crunching numbers with us, will make you thin, fit, and healthy or anything. However, it does seem like it worked for her, just saying. So, yeah, subscribe, hit the bell thing and buy some merchandise so you can make the world a better place by sharing your accounting instruction exercise routine. If you would like a commercial free experience, consider subscribing to our website at accountinginstruction.com or accountinginstruction.thinkific.com. Here we are in our Get Great Guitars 2024 QuickBooks Online sample company file. We set up in a prior presentation, continuing to lay down those foundational items necessary to run the normal accounting process. The normal accounting process being a cyclical process, including the input of transactions typically done with the use of forms, forms located in the plus or new button broken out by cycles of customer cycle or sale cycle, vendor cycle or expense cycle, employee cycle or payroll cycle. We then communicate with customers, vendors and employees with the help of the centers found on the left side, sales center or customer center, expenses center or vendor center, payroll center or employee center. In order to get the foundational items set up, which are typically more of a one time thing instead of a cyclical thing, those are typically found under the cog. We've been looking at the your company items. We're now looking at some of the lists, one of the primary lists being the chart of accounts, which typically can also be found over here in the transactions chart of accounts on the right hand side. And we're now going to be imagining we're pulling our data in from a prior accounting system. We want to also put the beginning balances in as we add our accounts. This time, we're also going to be talking about customers, which is another foundational item that we might lay down from the start, if we know or have a customer list, or we might create as we go as we do business. So let's take a look at our beginning balances. Once again, these are as of the end of the prior accounting system. We're imagining that we're going to stop that one at 12 31 23 and then start the new accounting system. January of the current year, 2024. If there's some overlap, if we were using the prior accounting system for part of 2024, we might want to run the two systems parallel for that part of the year so that we can get the full year in the current accounting system. Our strategy is to take the balance sheet items. We don't have any income statement items because they rolled out to equity. Take the balance sheet accounts from our prior accounting system, put them in our new accounting system and move forward from there. But we can't do that with just a journal entry. We have to do that by acknowledging that each account might have its own special needs and take care of those needs as we go. We started with the most difficult one inventory. If you're tracking inventory on a perpetual inventory system, because we had to then enter the inventory items that make up this balance. Now we want to think about the accounts receivable, the next kind of most difficult one, typically. And that's because I can't just enter this as the beginning balance, this 20,500 because it's consisting of multiple different customers and because I want to be able to track the outstanding balances in my receivable center and the customer center so that I can communicate with those customers and follow up on collection with those customers. So what we want to do then is add the customers themselves and then add these beginning balances to each customer and then the other side of the transaction will fall out in one way or the other to the equity section. Now most likely, because it's accounts receivable, if we use this method, what's going to happen when we put beginning balances per customer into QuickBooks? QuickBooks will create an invoice most likely, right, because the invoice is the account that increases the accounts receivable. The other side of the invoice typically goes to the income statement, income. However, as long as we put it in the books as of a date before December 31st of before January 1st of 2024, which means we're going to put it in there as December 31st, 2023, the income statement will roll into equity. So I don't care if it goes to opening balance equity to owner's equity or to income, it will end up in some kind of equity account. That is the point. Let's check it out. So if I go back on over here, then we're going to be going into our sales area and this is kind of like our customer center. And then you can go into the customers. This is basically our list of customers. So if you had a new company file, notice we put this generic customer in there already. But if you already had a new company file, then what would happen is you might just try to construct your customers as you go, meaning you might just do business and as you do business, you add your customers. For some businesses, the customer data is a lot more important than other businesses. So for example, if you have like a Shopify store or something like that, you probably don't have a lot of information about your customers because you're just trying to sell them like one off sales typically or have them repeat visit to your website. So all you really need is the information to record the customer and have the payment information and possibly get them on your newsletter. And that's what you need for that kind of system. If you work at a restaurant or something like that, it's a similar thing. You probably aren't getting a whole lot of data from your customer, at least not in your system. You know your customers personally if you're in an on ground type of store that could help, obviously. But you might not need a lot of information, just collecting money at the point of sale. But if you're in some kind of businesses that have a lot of repeat businesses, such as if you're in a law firm or CPA firm, then it might be the case that you really want to have a lot more detailed communication with particular customers because a lot of your business is more reliant on a certain group of customers that you're going to have a lot of repeat communication with. So again, that will kind of change how you're going to set up your customers. So in other words, when you set up your file, you might already have a customer list which you highly prize and value given the fact that that customer list is the primary tool that supports your business because those are the people that you... So then you want to make sure that you import the customers, put all the detail that you can. If you have shipping information, you put that information in here and all that kind of stuff. However, if you're in other kind of businesses like a Shopify store or something like that or you have on ground sales, then in some cases you might not even put the customers in here because if you have a sales at a restaurant, then you might just have one generic customer and you're just recording everything as sales at the restaurant, not to a particular customer because you don't need to mail them an invoice or anything. And if you're in a Shopify store or Amazon or something like that, all the customer data is probably being kept on the third party website. So maybe you don't need to pull it all into here. So just some things to think about with the customers. You might create the customers as you do the invoices and the sales receipt forms in a lot of cases, in which case you might not need to upload a whole list of customers. But if you have anything that's in accounts receivable, meaning you're doing a full service accounting system and that you're invoicing people, then it becomes a lot more important to track the customers because you have to follow up on the billing to make sure that you can collect on it. And if we're entering a beginning balance, therefore we have to, of course, add the customer. So this is going to be our data. We're going to imagine that that accounts receivable has supporting data of this. We have the name, first name, last name, company name, main phone, the billing address, the email, the customer balance, and the as of date, which I'm going to change here, to 2023. And that is really important because we want to put it in there as of the prior accounting period so it rolls out to income if QuickBooks records this as it most likely will with an invoice put in the other side to the income statement. All right, that's going to be the general idea. Now note that if you download this kind of information from another system and then you need to upload it into QuickBooks, some problems that you could come up with. One is that you might end up in a situation where one system records the name like this, like first name, last name, and another system wants to record it last name and then first name. Or you might have a system where it has it listed out like this and then but really you want to be breaking out the first name and the last name, something like this. So just note that there's some nice little tricks that you can use, same with the billing address. You might have the billing address all in one cell sometimes, or some other places might be breaking out the number versus the city and the state and the zip code.  If you can get this thing into Excel, sometimes you can deliminate or separate stuff with the use of the commas. And sometimes there's other techniques if there's only like... So let me give you just a few tricks here. You can look up a lot more depending on what your needs are on the internet. So let's take these ones here. If I was to copy this and I'm just going to put them down here and let's imagine that I needed to put these together. One way to do that is with a formula. So I could say this is going to be equal whatever's in this cell and then I tie it together. I think about doing that with the and as a not. You could think of it as kind of a not, but I don't want to put it right next to this one. I could do that and this, but then I'm missing the space. So let's go back in there in between this after this and I need a space. You have to use the space as a text to put a text in a formula. You have to put quotes around the text quote space text. And then I need another and to tie in that space to the next piece, which is Anderson. So that I'm going to say and again and boom, there we have it. And then you can copy that down. So that's one way that you can do it. Now, if you don't want a text in here, then then you simply copy this and paste it one, two, three. So now it's not a formula anymore so that you can save it as like a CSV file easily because it doesn't have any formulas in it. Now, if you wanted to go the other way and put a comma between them, then that's the same kind of idea, but you're just going to start with this one. This equals this one. And then I'm going to say and and then quotes and then this time a comma and then quotes to put the comma in there and then tie together and with the first one and boom. So now we have it with a comma. We want we might also want to space after the comma. If I double click in there, we have the comma and then the space. I can put both of those in one spot and then copy that down. Boom. That's another idea that that you could use. Now, if you need to break something out, let's go the other way and say it's this way. And now I need to break that out to two cells because it's only in one cell. You could select this one and we can go to the data up top and within the the data tools over here, you've got text two columns. So in text two columns, it's now saying deliminated characters such as comma or tabs and so on. I'm going to pick that one. And then I want to say that there's a space between them. So that's what I want to use to break it out. So I'm going to say, okay, and then finish. So now it puts it into like that. Let's just show that same thing over here with the whole address right with an address.  And now I want to break this out to columns. Well, I could select this. Let's just do it again for this one. I'll say that data and I want to make it into columns. And this time it's going to be deliminated characters such as comma or tabs separated each field. This one says fields are aligned in columns with spaces between each. That's what we have here. We've got a comma and a space. So that's the one we want it defaulted to the correct one. It's breaking it out. So boom, and let's just do it. And so now it broke it out into its separate fields. So just a couple techniques. Those are common kind of problems that people run into when you try to try to export to a spreadsheet and then import to another spreadsheet. There might be a different format of the fields. Let's see if we run into that problem now that we have some tools to deal with it as we go into our worksheet over here. If we want to add a new customer, you could do so with the new button here if we wanted to enter them one by one, which we only have three. So that would be easy to do. But we're going to try to upload it. Let's just go through the customer fields though to get an idea of what it's here. So let's just tap through it. You've got the title, first name, middle name, last name, company name. This is going to be the display name. That's why it's got an asterisk. So that's going to be the only thing you really need because it's the only asterisk one. But you might want all this other information. Email, again, might not be important. Unless, of course, it is really important if you're invoicing the client. It wouldn't be important if you're just dealing with someone like a food truck or something like that and collecting the money at that point in time possibly, although you might want them their email for your mailing list, which is another thing. So the phone number, mobile phone, fax, other website name out to print on checks. If you're doing checks, is it a subcustomer that deals with like job costing kind of things? Typically we have a whole nother course or section on that. Then we've got the address, which will be important if you're shipping things to them and possibly important if you're dealing with some kind of sales tax situation where you have to apply it possibly to where they're located. And then we've got the notes and attachments attached. We've got the payments primary payment method, which could be, you know, whatever the payment methods that we are using. And then the terms, if we send them an invoice, we might want to set their particular terms or just use our default terms for all customers. I use company default English versus other languages, which is pretty neat that we could change like the language of the forms we're giving them. That would be nice possibly for some people credit limit, additional information customer type. So we could start typing to create a customer type. If we want to create customer types, possibly helping us to group our customers by type. And then this customer is tax exempt, meaning sales tax. When we issue a invoice or sales form, are they exempt to tax? Usually not. Usually it'll be with the default. We went over that in our sales tax setup process. And then we could set the sales tax that they're subject to here. If we don't do that, it'll use the default settings based on location. And then the beginning balances. You would never use this unless you're first starting up the file, which we are doing at this point in time. So you'll notice that we are going to have a field showing the customer balance, which will be the opening balance. If you put something in there, QuickBooks will create a journal entry. You don't typically want to do that after you do the setup process because every new customer will you'll invoice them to have to have a balance. So let's close that out. I'm going to say, do you want to leave without saving? Yes, we do. So we could do it that way. Or it says import customers here. And then we've got the multiple customers. So notice they still have the import field here. I didn't see the import field in the products and services that they generally had here. So notice you can imagine that they might try to put it in the same place we went up top. So if that button goes away for whatever reason, and they want to move it over here, then you can imagine them doing that into the import data under tools, import data. And so if I go into that, we've got the bank data. There's our customers, vendors. We did this with the products and services. But since they still have that button there, and it makes sense to me that they would within the center, I'll go back into the sales center. I'm going to use it here. We're in the new customers dropdown. It makes sense to me to have the import customers here. So first time importing customers, all your customer information must be in one file. So the top row of your file must contain a header title for each column of information. Custom name is the only required field. So select a CSV file or Excel file. So they've expanded from what we saw with the products and services they want a CSV or an Excel file. So we might just be able to use our Excel file. But we probably want to use their template just like we did before to make sure the headers line up. So what I would do is open up their template and use their headers and then line up our information to it. Let's see what they have here. How did they save this? Is it a CSV file or Excel file? It looks like an old Excel file. Let's save it as, I'm going to put it in my folder here. I'll say boom, save it in my folder. And it's actually an Excel file, an old one, 2003. So we're going to put it there and we'll say this is going to be customer list and balances Excel. So I'll save that. I don't need to convert it to a CSV it looks like. So I'm going to just use their thing here. So here we have the same information up top, the name, the company, the customer type, the email, the phone, the mobile and so on. So let's just look at, let's delete this down here. I don't need this right click and delete that. And then I'll just see if I can pull in my information. So if I go from here, I've got the name. So here's the name, boom. See if I can pull that in here. So they have the name in the same format where it has first and last name. So I'm going to say, okay, that's the format they want. We'll put this here. Hold on. I lost my copy. I'll just copy that and put that here. And then the company name, the company name, I'm just going to say is the same thing. Company name. So I'm going to go. Dirt company name. I lost it again. Copy and then boom customer type. So I'm not going to put a customer type. We could get more detail on that than the email address. I think I have an email address. Let's go from this one, this side over this way. So I don't keep losing my, here's my emails. So I'll copy that, pull that over here. Email addresses. Phone number. So let's copy that. We could have multiple different phone numbers, but I just got the main phone number here. Main phone. I'll just put in here. Let's go. And then delete everything below it. And then mobile. I don't have a fax. I don't have, I don't have a website. I don't have that. And then there's street addresses. So notice we ran into that issue here, right? Because now they've got the street as street, city, state, zip, and then United States. Okay. So now we've got our issue. So now we can apply the technique that we thought about. We could say, okay, I need to break this out. So I'm going to take this billing address over here. I'll copy it over here. And I'll just do the same thing we did before. Let's see if I can do all of them at once. Does it allow me? Let's go to the data. And then I'm going to say convert to a column. And then I want to fields aligned in column with spaces between characters such as comma. I'm going to do the second one. Okay. I think I have to do it. I think I have to do it one at a time. So I'm going to go in here data. To text. There. Yeah. I have to do it one at a time. Boom. Okay. It's a little tedious. If you had a whole long list, but not too bad. Better than copying and pasting each one of them one at a time. So I'm going to say, did, did, did. Okay. So now we have it. So now I can say this is going to be, what do they want it looking like? They want the number this, this, this. Okay. So now these three need to go together on these three. Okay. So, and I'm going to get rid of the commas here too. I don't need this comma. Do I need that comma? Get rid of these commas. That's kind of annoying. It's kind of tedious. You know what I could do on, on that thing, by the way, I could like to get rid of those commas, I could take this whole thing and then say, I want to go to the home tab and say, I want to find the commas and go boom. And then on the replace, I say find the commas and replace them with nothing. Right. Next, or find all, and then replace all. Okay. There we go. So that pretty easy way to remove the commas. Now I need to combine these three back together again. And how did this get, this one road, Beverly Hills, this got off. So there we go with that. All right. So let's go. I know I'm doing this kind of, let's see if I can combine these three together. This equals this. And then I'm going to say and tying it together with a, with a, with a space space and then and tying it together to this. And then I'm going to say and tying it together quotes with a space and then and this tying it together with an and and wait, no, that's it. That's all I need. You're getting to getting it. All right. So there we go. So now I can just say, let's copy those three. Okay. And then I'm going to copy it again and paste it one, two, three. So it's not a formula. Okay. So let's copy that and see if that works. So then if I go back on over here, it wants these three. So I'll put that here and then delete this and then it wants a city field. So I can go back on over to this one and say this was the city. Beverly Hills got broken out. Okay. That's great. So let's do this again. This equals this and space quotes space this. This and quote space and then and again, tying it together to this doing Beverly Hills. Copy that. I'll just copy that and these all three of these, but no, it's a formula now. Paste it one tooth. Oh my goodness. Let's go back over here, copy it, paste it one, two, three, and then copy it and go back on over and paste it to these three Beverly Hills. And I'm just going to say California. So California and then the zip code 90210 California zip code is going to be here. 90210 boom and we'll keep the country United States. Okay. That's cool. Opening balances. Then I have where were the opening balances. We have this one opening balances copying those and put that over here. Opening balances boom. And then I'm going to say that the date, look at the format of their date. Do we need it in that format? That's going to be 2023 dash 31. No, dash 12 dash 31. So year month day. Okay. I think that's right. You probably okay. So there we have it. So I think that's it now. And this if we sum up the balances. That should add up to 20,500, which is the amount here, 20,500. So I know that I did that a little bit possibly not as smoothly as I could have, but a couple things to do. I think everything is in there. So we've got the name, the company, customer type, email, phone, mobile facts, street, city, zip, state, zip country. That's good enough for our example, I believe. Let's go ahead and save it. Let's say save it and close it. We'll close this one as well. And then I'm just going to upload the Excel worksheet. I don't say I don't need to save it as a CSV file this time because they, they're not requiring me to customer list and balance. It's got the old look, the old look. It's not a CSV file. I don't think it's just an old Excel 2003. So they're going way back, way back. All right. So let's update it. I don't think you need to use an old version, by the way. I think they're using that template. It used to be that you use that template so it didn't mess people up that had the old version of Excel. But I mean, that's pretty far back. So I think most people have upgraded from that point if they're using QuickBooks online in any case, but in case customer list and balance Excel, that's the right one, isn't it? I'm talking too much, but I have to because that's what I do. Otherwise it'll get boring, but it's hard to concentrate when I'm talking so much. Okay. So there it is. So we're going to say next. So now the headers line out. They're going to line up perfectly now because we picked our headers up and lined them up to the same headers in the worksheet. Instead of trying to upload our worksheet and then tie out the headers, which is the other methods you could use, which might work. But I think this is actually easier if you just take their template and then put your information into their template, then the headers should tie out. So there we have it. It's pulling in. And so name, company, email, phone, street, city, zip. Let's make sure we have the date correct. 1231-2023 because we're starting January, 2024, movie B to the N, BN. So there we have it. So now we're back in our customer area, which you will recall is under the sales tab and then customers close in the hamburger. So now we've got our three customers plus this generic customer we set up before. Now, if you hit the dropdown once they're set up, you can send reminders, create statement, create invoice, create sales receipt, and so on and so forth. And you can make them inactive if you so choose. Notice they all have balances in them now. So if I go into a particular customer, they have an invoice there. Like, well, I didn't create an invoice. How did it do that? It did that when we entered the beginning balance there. Why is that important? Because you have to have the invoice. If you're going to collect on it, if it was a journal entry in there, when you receive payment on it, you wouldn't be able to tie it out to the invoice. So even though it's not the same invoice that we put into the prior system, it's still an invoice, right? So it put down here just service item. So it just charged it to a service item so it can put the other side most likely to income. Now, if you don't want it to go to income, possibly you want it to go to opening balance equity. You could create an item that then goes possibly to opening balance equity, the equity count if you want to. But if this goes to the income statement, like you would assume it would, not a problem if it's in the prior period to when you're going to start in this period, in our case 2023, which will roll into retained earnings as we start the new period in 2024. So now I can collect on this, right? So I have this, if I receive a payment on it, I can simply go to the receive payment, which we'll see in the future, and I can get a payment on it just like we would with a normal invoice as if we issued the invoice normally with an invoice form, which an invoice form would of course look like this. Here's the attachment to the invoice form. All right, let's close this out. Let's close this out. We'll also be able to track that information if I go back to the customers internally in the all sales area. So we have our invoices in here and our invoices tab. We have our invoices in here, right? And then we can see the impact on the financial statements. So let's do that. Let's open up the hand boogie. Let's go down to the reports and words. Doneday. Doneday. Okay, there they are. Calm down. Close up the hand boogie. Let's right click on the balance sheet and open link in a new tab. Right click the profit loss, the P&L open in a new tab. If we go on to that balance sheet then and scroll up. Let's go back to 2023 now. So I'm going to go from 010123 tab, 123123. We entered everything as of December 31st, 2023. That's at least what we're trying to do. So on the balance sheet, AR we entered last time. Here's the inventory we entered last time. AR we entered this time. There's 20,500. That looks right. That looks like this balance. Good. Okay, if I go into it, what's comprising that? How did QuickBooks do that? Well, we entered the beginning balances and QuickBooks created an invoice from it. So if I go down and drill down on the invoice, we're going to say, hey, look, I didn't enter an invoice like that. All we did was enter a beginning balance into the data input. Well, QuickBooks has to enter a journal entry because that's how the double entry system works. And the entry that it uses or the format that it uses to increase accounts receivable is the form of an invoice. And the other side you would think would be going to sales. That's what it looks like. That looks good. Mui B to the end, BN. Let's go back on over. The other side you would expect is now in net income. It's meaning it's pulling in from the income statement. Okay, let's go to the income statement then and check it out. Closing up the hand boogie, changing that range, bringing it back to 0301, 0123 tab, 1231, 233 tab, run it to refresh it. There's the service income. So they dumped it into service income. You might say, well, that might not be perfectly right or whatever because it was last year or maybe it was some other kind of income instead of service income. But it doesn't matter because we don't care about 2023 because we have that information in our prior accounting system. It's closed. It's over. All we need to know is that that amount is going to roll into the equity section, which it does, right? It's down here in net income. So as long as our balance sheet is good, we're okay. Why? Because if I go to my income statement, when I reset the income statement starting in the current year, it's like we're driving a car and we reset the Odominator every time we have a new journey, right? So it goes back to zero. So I'm going to bring this back to zero, 010124 to 123124. So if I'm measuring performance in 2024, nothing's in it. So I'm okay with something being in there last year because I reset the Odomator as of the current year. So we have a clean slate where we need the clean slate. If I go back to the balance sheet, how does that work on the balance sheet? Well, it's an income to here. If I go to the next date up, then it's going to roll into retained earnings. So if I go from 010124 to 123124, then it's going to take that number that was in income, roll it into retained earnings. Remembering that retained earnings is kind of like a corporation type of account or name of the account, but it's all the closing processes, all the same. The system for QuickBooks will close out your income statement to the balance sheet and it'll show this net income to show the process separately, even though that's not actually an account, and then roll it into the retained earnings on a yearly basis, not on a monthly basis. It will do it on a yearly basis even if you change the dates to like a monthly kind of setup. That's why you want to have like a whole year's worth of data in one accounting system, even if that means that you have to basically run a few months or whatever part of the year you need to in the current year that you're switching in, which might be good because then you can run a parallel accounting system for some time to see if it's accurate and then move forward to it. So there it is. So that our plan has worked because now it's in the retained earnings. We've got this amount in opening balance, which we'll put into retained earnings. If it was a partnership, we would then at the end of the process have to break out the retained earnings between the partners or whatever. If it was a corporation, we'd have to break out the retained earnings to the retained earnings versus the common stock at the last step. If it was a sole proprietorship, we'd have to put it all into retained earnings and possibly change the name to the owner's equity or something like that because retained earnings is not the proper name if you're a sole proprietorship. Those little touches, by the way, could really make people feel like you know a lot more about what you're doing. If you get your retained earnings setup right, I mean if it's a sole proprietor and you have stuff in opening balance equity that if you're anything and you have stuff in opening balance equity, it doesn't look as professional. You probably want to clean that up. You have retained earnings as the name of the account, but it's a sole proprietor. Not the end of the world, but doesn't look exactly correct. Touching that up and calling it owner's equity would clean it up a bit, make it look a little bit nicer. If it's a partnership, you would have capital accounts, right? But they're basically the same thing. Let's do one more thing. If I go back up top to the accounts receivable, we should now have a sub ledger breaking it out by customer, which we already saw internally over here in the customer center. So we can see that internally this amount is being broken out by customer this way. But we also can see that in a sub ledger. So let's right click on this tab, duplicate it to see the sub ledger report breaking out accounts receivable by customer, scrolling down to the reports, closing up the hand boogie so we can boogie on a bigger dance floor. We've got the show who who owes you. So all of these reports are supporting accounts receivable. The classic kind of just sub ledger playing sub ledger is the customer balance detail or customer balance summary. Let's go into the detail one and see what we have here. So as of custom dates, let's just make it 1231 to four. We've got the invoices. Here's Anderson Jones Smith invoices and those invoices five thousand seven five eight thousand tie out to the twenty thousand five hundred and that amount is what is on our our balance sheet over here twenty thousand five hundred. So they're there that that's the general process for entering that. Let's go ahead and open one more thing the trial balance because that's the easiest report to see us constructing this step by step. So I'm just going to type in trial balance because QuickBooks doesn't give the trial balance any respect puts it on the bottom of the reports treats it like Rodney Dangerfield even though he was the like the funniest guy around. Oh one oh one two four to twelve thirty one to four. Let's do that. So that will give us then accounts receivable. Here's the balance sheet. Here's the asset of inventory opening balance equity and retained earnings. Note that if I bring it back and notice there's no subtitles look how much easier that is to look at than this. This looks like we have a lot going on even though we've only we've only got like two entries that we put into the thing because of all the subtotals and this would if I bring this back to the prior year. Oh one oh one two three twelve thirty one two three. We've got some detail in here it looks like a lot's going on over here. It's cleaned down you can say OK this is pretty straightforward even though it's in debit credit format now if I bring this back to oh three what happens what's going to happen if I bring because I entered this as of twelve thirty one twenty three if I bring this back then this retained earnings is going to break out the part that was assigned to income. So I'm going to say run it and so now I don't have a retained earnings right instead I've got the opening balance which you can think of maybe as the beginning retained earnings and then the income statement account of revenue or sales. If I pull out the trustee calculator we can see of course that that means when I construct this the equity section on the balance sheet is including the income statement the income statement is part of retained earnings or owner's equity or whatever you want to call it capital account depending on if it's a corporation partnership sole proprietor right right so I had sales twenty thousand five hundred plus the two eight nine six is going to give us the twenty three three ninety six which if I go up one more date I just go boom then you get the this plus this would be the twenty three three ninety six right it's going to be twenty thousand five hundred plus two eight nine six twenty three three ninety six so that's it that relationship between the balance sheet and the income statement is something that a lot of people don't fully understand and as we construct this it's the easiest way to see it as we build it step by step we can see that the that if I was to look at this trial balance and break out the income statement of it what's it going to do going back again it's going to say that the retained earnings the retained earnings which we can kind of imagine is opening balance equity is kind of representing everything that's rolled into retained earnings that hasn't been distributed in the form of dividends if corporations or draws if a sole proprietorship for prior periods and then the income statement accounts revenue minus expenses are broken out into a long form which are going to just add up to net income is going to be the current performance which is just part of the equity right all of that rolls into the equity it's all part of equity so normally for external reporting purposes we don't usually break out net income we say on the balance sheet it's part of equity it's part of retained earnings already QuickBooks is trying to show that relationship by showing you the net income when you're in the prior year<PHONE_NUMBER>23 and run this isn't an actual account the net income it's trying to show you that the net income is in here it really should all be part of retained earnings right and we just know that the income statement shows the last year we're looking at it in terms of years it shows the last years of performance which is part of the equity section included in retained earnings if it was a corporation the capital accounts if it's a partnership and the equity accounts if it's a owner's equity if it's a sole proprietor alright we'll continue on with adding the beginning balances next time