With ThinkTech on Spectromosi 16, Hawaii's weekly newscast on things that matter to tech and to Hawaii. I'm Elisa Anderson. And I'm Cynthia Sinclair. In our show this time, we'll review the most recent top five ThinkTech talk shows and staff pick. We'll check out the elements of the best of the best and get a handle on the public issues and guests involved. ThinkTech produces more than 35 talk shows every week in our downtown, high-tech green screen studio. Our ThinkTech talk show offerings are very diverse, and their coverage is also very diverse, covering things you might never have otherwise known. Every week, ThinkTech chooses its top five ThinkTech talk shows from the week before, based on the number of views each of them has had on the Internet. For this past week, the winning show is where it follows. Number one, from the series Beyond the Lines, hosted by Rusty Kamori. It was called Hokuwa General Manager Dwayne Komine, Beyond Condos. He talked with Dwayne about his receipt of the national award for best condo general manager in the United States, and why he is a successful leader. Dwayne shared valuable insights about leadership, creating a culture of excellence, and dealing with the biggest adversity of his life. I kind of like the business, so I applied. My brother got me to apply at Iekoi Tower. Okay. From there, I worked on a hands-on resident manager, meaning that I worked in the yard. I worked with the employees. Then, from that point, I really liked what I was doing and playing music. I decided to enhance my education, so from that point, I went to Royal Capital Plaza, which was the first condominium in the Kakako District and under the AIDS CDA ruling. From Royal Capital Plaza, I was asked to go to Nauru Tower, which was run by Nauru Fosfates Royalty's Development. From that point, I was recruited by a Kobayashi-Magnathean group to open up a pool. You've really went through a lot of places. It's so amazing how you started as a janitor, and now you're the general manager of one of the most prestigious buildings in Hawaii. You're part of the Institute of Real Estate Management. That's a great organization. I remember a few months ago, I was a guest speaker for them. Tell me about that organization. It's a well-organized organization where education and just getting facts and learning about your career. I started about 30 years ago, and the class or the organization had about 15 students. I became president, and when I left a couple years later, I left with about 300 memberships. I increased for the certification as known nationally. And what is ARM, A-R-M? Accredited Residential Manager. Again, it's nationally recognized. Most people in the industry prefer an ARM that they would like to hire or interview. And Wayne, let's talk about Hoku again now. When you became general manager, obviously they had McNaughton and Kobayashi. They wanted that vision of being at the top of the highest standard of luxury living. Tell me about that situation at the beginning. When I got hired by the Kobayashi and McNaughton team, it was very trying. I had to put condo living and resort style living together. And I knew a lot about condominiums, but not so much in the resort style. Number two from the series, Lillian's Vegan World, hosted by Lillian Koumik. It was called Just Like Cheese. Look out, Dairy, vegan cheese is a happening thing. With guest Ryuko Mura, the discussion was about Ryuko's vegan journey. How, why, and the benefits since going plant-based for her, and about vegan cheeses and tasting. So this is that down-to-earth, they carry a large range. That spiciness and dressing. That has some spicy peppers in it, so a little bit of bite, which is nice. And it, you know, stimulates the palate a little bit. And let's have a look at the next one, which is the, yes, Dire Medium Cheddar. Also dairy-free, all of these, dairy-free, soy-free, non-GMO, non, it's just so, so wonderful that these products are out there. This one is the same one ounce, about 28 grams. This, this is also a great one for sandwiches. Ryuko, I know that you like your sandwiches too, so you might enjoy this one. Have a try. This goes great, you know, with crackers and stuff. Great for parties, because who doesn't like cheese and crackers? You know, olives, pickled onions. You can also add some of the vegan meat, like some ham slices. Oh, I agree, it's delicious. How would you eat that? I would eat it with crackers. Yes, they're really good with crackers. So nice little cheese platter going on here. Would you be satisfied if you had that, like a picnic or a... Of course, I would eat more than such this way. I agree, so, you know, all these cheeses are available in Honolulu too. Let's have a look at one more, which is the last one, and that is the Monterey Jack style. This one has a lot of bite to it. It's almost like a mix between the Parmesan and the cheddar I found. This I prefer, I love it on its own, to eat it just as it is, but it actually works great melted. Melted toasted sandwiches or incorporated into some baked dishes. So this is also available at Down to Earth for $5.90. You can get all of these on sale sometimes, so do look out when they're on sale. It's a great time to do some tasting. And on that note, have a taste. Actually, this one was the Parmesan, I think I made a mistake. Oh, okay. Yeah. The Parmesan. Is that the one that you tried? This is the Parmesan. Yes. So this is the Jack. Mm-hmm. Number three. From the series, The Hawai'i Smooth Jazz Connection, hosted by Gwen Harris, it was called Zanik Kapala Lindsey, The Music Man. In this episode, we discuss Zanik's career in music and his upcoming projects and events. During the show, Zanik played in the studio. He plays guitar in ukulele and other instruments. My heart to you, I'm ready. No matter where the road might lead. As long as I can feel you here beside me. So let the heavens fall. I won't care at all because I'm ready. To let my soul break through. After all the years I'm not afraid to start again with you. Sometimes I may stumble along the way. But I can finally say goodbye to yesterday. If you're ready. Won't you take my hand. And promise that we'll always be together. Please whisper now as we take this vow. I'm ready. Please whisper now as we take our vow. I'm ready. That was beautiful. Thanks. That was beautiful. Number four, from the series Think Tech Tech Talks, hosted by Jay Fidel. It was called Vex Robotics in Hawaii. Robotics are alive and well in Hawaii, with guests Art Kimura and Rin Kimura. They are the organizers of Vex Robotics in Hawaii and spoke about robotics for students in Hawaii, including students in elementary, middle, and high school. After all, we need to encourage our students to study robotics. Hawaii Challenger is because it gave me a relationship with NASA. Following that, I can bring up the next slide. The beginnings of First Robotics and then Vex Robotics in Hawaii. Actually, let me talk a little bit about this. In October I was involved in a PBS special, The Future of Work. Primarily, it looked at how machines, artificial intelligence, robotics is affecting the jobs and the workplace and how it's replacing a number of jobs. That was when they had the 40 people in the big room. That's right. And Leslie Wilcox runs around and everybody gets a chance. Exactly. That's a good program. And I remember that. The Future of Work. That's not an easy question either. It was a difficult time because the hotel workers weren't in strike. I think hotel workers realized that a lot of their jobs would be replaced by machines. This all goes through diversification, the E word. Absolutely. And in the second part of our show, we're going to talk about that in some detail. Okay, keep going. Next slide. Sorry. This is when you're supposed to kick him and go to the next slide. He's not responding. Too much. So as educators, this is our question. How do we train students for jobs in the future that has not been created? It's really difficult for us as educators and parents to think about what jobs will be like 15, 20 years from now when our children will be out. In Hawaii. Our workforce in Hawaii. We're talking about right here. Specifically. Yeah. Our beginnings is 1999. By a chance meeting in Hilo, I met a NASA engineer, Mark Leal, who had been in Hilo to represent NASA in the building of the Future Emilo Astronomy Center. He offered us two scholarships in a first robotics course, which eventually went to McKinley High School and Wailoa High School. Two of the most famous programs in Hawaii and nationally. And that was our beginning. And along the way, we brought in VEX about 15 years ago as a training program for fall program that children could learn in the fall and then first would happen in the spring. Eventually, the two first and VEX had a divorce nationally. And because of that. That was Cayman. Okay. Well. That's a great story. And so VEX became its own entity and first continued on. So VEX in Hawaii has grown enormously. There's four different programs right now. One for elementary children called VEX IQ from grades four to eight. There's a program called VEX VRC or some people call EDR. Number five from the series Quok Talk. The culture of women hosted by Crystal Quok. It was called LGBT discrimination in Asia. How this impacts Asian American LGBT communities in the U.S. With guest Justice Sabrina Shizue McKenna of the Hawaii State Supreme Court. Justice McKenna shared her experiences and reflected on her recent talks in India, Japan and Hong Kong on issues of gender and LGBT issues. Bridging Asia and Asian American understandings on how socially sensitive issues like gender affect us all. Gives us a deeper understanding of LGBT communities in Asia. And the need for more conversations on gender issues worldwide. I think all women.  Right. And so we can. We are from the perspective we understand discrimination. And I think, you know, as a feminist and I think feminists in general. It's not just about promoting women. It's about creating equal rights for all. And so I think having women within the judiciary really, really does change perspectives. I think that, you know, it was after 1972 and Pat C. Mink's Title IX law where the significant increase in women in the judiciary, women lawyers, women in law schools, then women in the judiciary. I think attitudes for domestic violence laws changed. Sexual assault laws changed in the United States. That's something that I'm saying in India. I was actually invited by a law school, gender-global law school with which U.H. does have a sister relationship. Okay. And we actually accept summer volunteers from externs from that law school in the summer because it's a, you know, India is an English common law system. Right. Their education at that level is all in English. So they can actually, they don't have a language barrier. Right. Right. And at the same time it's a very deeply rooted kind of additional male dominated. Yeah. Exactly. And there's so few women. And it was interesting because I was interviewed by the news agency representative, a wonderful person, very, I think very open-minded and enlightened person. But he was, you know, saying, we now have three women out of 31. And I, we only had one last year. And I was like, that's tokenism, you know, one out of 31 is tokenism. And it's really, there's very few women in the high courts, which is like the state supreme court. Right. Very few women. And I said, you know, really you need to have a system. So. And how did they react to that? Well, I think I was talking to the men. And I was talking to some of the male supreme court justices. And they said, I think the ones that I'm talking to are the enlightened ones. Okay. So that depends on your kind of following. Exactly. Exactly. That would be interesting. I'm not sure how that would cut. Yeah. I have hope for change. You know, I'm very careful for change. And I went to several law schools. And there were many women law students. And they're so bright and so driven. And, you know, I just have great hope for the future of India. And of course, Japan, my home country, I've gone, I spoke at the Gender Law Society for the first time a couple years ago.  Okay. And that time, you know, I was open about my own sexuality. And it was amazing because after I spoke, several people, several of the professors got up and they came out. Wow. People around me are like, oh my God. See, it takes somebody like you to open up and then people kind of trickle in and share. Right. People start opening up, you know. And here's our staff pick. From the series, Community Matters, hosted by Marcia Joyner. It was called Sister Cities with Havana. Honolulu, Lake Havana is an island city with guest Jesus Puerto. The U.S. Sister City program began in 1956 when President Dwight Eisenhower proposed a People to People Citizen Diplomacy Initiative. This initiative links jurisdictions in the U.S. with communities worldwide. Now, more than 2,000 cities, states and counties are partnered in over 140 countries around the world. In this show, we discovered a deeper understanding of the complexities and wonders of Cuba. Its history is a leader in the field of universal education, its world-recognized literacy, its vibrant preventative health care system, and current trends in its tourism industry. U.S. policy towards Cuba. But President Trump has continued to, even though there's been a reversal of many of the forward-moving shifts that President Obama had made, there's still plenty of those changes in tact. And I think Trump made an announcement in 2017 that there's still interest to support Americans who are interested in engaging and seeking opportunities to do business in Cuba. So that's still promising. And our commercial airlines are still flying there. The planes are going over the pool. So Delta has flight. United, JetBlue, Southwest, American Airlines does as well. The problem, part of the problem, as the United States is repairing its relationship with Cuba, a wide variety of social and economic systems in Cuba are likely to transform in a short time. So Americans will establish with relationships and knowledge of Cuban culture and government officials, small business entrepreneurs, health care systems and hospitality industries are needed to forge a partnership between Americans and Cubans. And that is where the opportunity is for us in Kauai to connect with the sister city program. You can always find the links to these shows in our daily email advisories. You don't already get our daily email advisories. You can sign up to get them on thinktechkauai.com. These are only stampings from the top five and staff pick from across our 35 weekly talk shows. There are, of course, many more. To see these top five and staff pick shows in their entirety, go to thinktechkauai.com or youtube.com slash thinktechkauai. Great diversity, great community, great content at ThinkTech. If you have questions or comments about these or any of our shows, please let us know. And yes, it's okay to share them with your friends and colleagues. Thanks so much for watching our shows and for supporting our efforts at ThinkTech. Aloha, my name is Jay Fidel and I'm the CEO of ThinkTech Kauai. ThinkTech is a study in citizen journalism. The value of citizen journalism is that all the people involved become more actively engaged in a more thoughtful examination of the world around them. By this interaction, we can build a more dynamic, productive community dialogue. We can become more curious, more aware, and better informed and educated. We can separate the wheat from the chaff and raise the clarity of our collective thinking. And Lord knows we need that clarity in these difficult, divisive, and most interesting times. Now more than ever, watch us, follow us, and like us. We're ThinkTech at thinktechkauai.com. And now let's check out our ThinkTech schedule of events going forward. ThinkTech broadcasts its talk shows live on the Internet from 11 a.m. to 5 p.m. on weekdays. Then we broadcast our earlier shows all night long and on the weekends. And some people listen to them all night long and on the weekends. If you missed a show, or if you want to replay or share any of our shows, they're all archived on demand on thinktechkauai.com and YouTube. For our audio stream, go to thinktechkauai.com slash audio. And we post all our shows as podcasts on iTunes. Visit thinktechkauai.com for our weekly calendar and live stream and YouTube links. Or better yet, sign up on our email list and get our daily email advisories. ThinkTech has a high-tech green screen studio at Pioneer Plaza. If you want to see it or be part of our live audience or if you want to participate in our shows, contact shows at thinktechkauai.com. If you want to pose a question or make a comment during a show, call<PHONE_NUMBER> and help us raise public awareness on ThinkTech. Go ahead, give us a thumbs up on YouTube or send us a tweet at ThinkTechHI. We'd like to know how you feel about the issues and events that affect our lives in these islands and in this country. We want to stay in touch with you and we'd like you to stay in touch with us. Let's think together. We'll be right back to wrap up this week's edition of ThinkTech. But first, we want to thank our underwriters. Okay, Cynthia, that wraps up this week's edition of ThinkTech. Remember, you can watch ThinkTech on spectrum OC16 several times every week. Can't get enough of it just like Cynthia does. For additional times, check out oc16.tv. For lots more ThinkTech videos and for underwriting and sponsorship opportunities on ThinkTech, visit thinktechkauai.com. Be a guest or a host, a producer or an intern and help us reach and have an impact on Hawaii. Thanks so much for being part of our ThinkTech family and for supporting our open discussion of tech, energy, diversification and global awareness in Hawaii and, of course, the ongoing search for innovation wherever we can find it. You can watch this show throughout the week and tune in next Sunday evening for our next important ThinkTech episode. I'm Elise Anderson. And I'm Cynthia Sinclair. Aloha everyone.


Hi everybody, and welcome to Downloading Transactions into QuickBooks for Non-Profits and Charities. This is a little bit about ReadyTalk, which is the webinar tool that we will be using today. You will all be silent. You should be able to hear me through your computers, mic, and speakers. If for some reason you do want to just call in and hear over the phone, there is an alternate phone line that we will be able to give to you. You just let us know if you would like that. Because you are all muted today, you will need to ask any questions via the chat pane. You should see that on your screen now. If you have any questions, comments, either about the ReadyTalk platform or about the content of the webinar, just chat us in there and we will be able to answer your question.  So if you have a question, don't feel the need to raise your hand, just go ahead and chat us the question. If you do lose your Internet connection, you can reconnect at any time using that link that you used to join for the first time. And if for some reason you are still having problems, you can call ReadyTalk Support at<PHONE_NUMBER>. And just as a reminder, we are going to be recording today's webinar and we will be posting the webinar both on the TechSoup website and on our YouTube page. We will be sending out the recording as well as additional materials either later today or tomorrow. And so you will have those for your perusal if for some reason you need to leave early or you just want to review it later. So again, this is Downloading Transactions into QuickBooks for Non-profits and Charities. My name is Kyla Hunt. I am going to be your facilitator today from the TechSoup end. And with us for the content piece is Greg Bosson from QuickBooks Made Easy and also assisting with chat is TechSoup's Becky Weighan so you will see her name pop up in the chat box. So with that I am going to go ahead and hand it over to Greg to get us started. Cool. Hey everybody, and thank you Kyla. That was wonderful as usual. So this is me. That's the picture of me, Greg Bosson. And I want to find out if anybody has heard me teach before. So just chat there, yes I've heard you, or no I haven't, something like that so that I can find out how many people have heard me teach before. I am a CPA with an accounting practice actually in Atlanta. And I specialize in non-profits. I'm from Atlanta, Georgia so that's my Southern accent coming out. Although I don't think I have one, other people do. Let's see, Mary has heard me. So that's cool. This is good. I can see what you guys are saying. I saw somebody say that they're your biggest fan. Oh really? That's cool. All right, great. I'm paid that person for that comment so that works. So let's see, I specialize in non-profits and then I'm the owner, the founder of QuickBooks Made Easy. And we specialize in training for specific industries and one of my biggest industries that I train in is nonprofits. I have training seminars live around the country and as a matter of fact, here we go. This is a list of upcoming seminars. We actually have one next week in San Antonio, Texas that yes, you can still sign up for. And then during the summer I'm going to take some time off and I'm also going to do a lot of writing, coming up with new training products. And then starting in the fall, we start again and those are some of the cities that we're going to. So if you are in one of those cities, I would recommend you come to the seminar and you can see me live. Of course, you've got to see whether I'm any good first. We'll talk about how to sign up for live seminars and also how to get the training products in a minute. So this is the agenda for today. And so this is a little out of order. The second thing which says benefits of downloading transactions, the second bullet, that's what we're going to do first. We're going to talk about why it's a good idea to download transactions. And then we're going to spend the majority of the time actually doing it. So we'll be demoing all of the downloading of transactions both for checking and for credit cards. And I'm really excited about this because I did teach this. I developed this class and taught it a couple of weeks ago for about 12 or 13 people. So this is the first time teaching it on the big screen here. And I don't know that I've seen a class in this before, but yet so many people want to know how to download. So I'm excited about it. Anyway, so it says we're going to do questions at the end, but we'll do questions whenever and whenever I feel like taking a break, I'll stop and I'll ask Kyla to ask me any questions. Although I can kind of see people here. I can see what people are asking. No, I haven't taught in Vegas yet, but maybe I will do that. So anyway, let's get started here because we only have an hour. All right, so the first thing that I wanted to cover is what the advantages are of downloading transactions. So just so that you understand what we're talking about here is instead of manually entering transactions, we're talking about from our online bank account or credit card account online, we're talking about downloading the transactions and importing them into QuickBooks. Obviously, it's much faster than manually entering the transactions. That's obvious. And so that's the main benefit of it. You don't have to sit and enter each credit card transaction. If you have credit cards, I'm sure a lot of you do. That's a lot of individual transactions that you have to enter. You probably end up not entering them individually. You probably end up waiting until the end of the month entering them lumped by account or something.  And then you're not really entering the transactions on the date they occurred. You're entering them at the end of the month when you get the statement and so the timing is not really correct. So it's obviously better than entering debit card transactions too. And those are important. Those are subtracting out of your bank account and you don't find out about them until the end of the month when you get the bank statement. If we lived in fantasy land, which some of us do, the person who has the debit card would be giving you the receipts every day, but of course that only happens in fantasy land. Anyway, then you don't really know what your bank account balance is because you don't have the debit card transactions entered. So it's nice to be able to download them. Let's see. So another thing, and you might be wondering this, when you download a transaction, how does it know what expense account to put it to? Well, there's an auto recall feature within the downloading part of QuickBooks that will remember, oh, the last time we downloaded a transaction from Office Depot, we put it to office supplies. So this one should go there too. So it's smart. It remembers this stuff. Let's see. So when you download transactions, and you'll see this in a minute, it actually, it'll download all the transactions, but it recognizes that some of the transactions have actually already been entered in QuickBooks. If you write checks in QuickBooks, a lot of us do write and print our checks out of QuickBooks. It's not going to enter those checks. Again, it's going to match them to ones that are already in QuickBooks. And then it will give you the ability to add the transactions that have not matched. So we're going to do that. We're going to download. We're going to match some transactions, and we're going to add some ones that aren't matched. One thing that's really neat is you can actually point downloaded transactions to accounts receivable or accounts payables. So that's pretty cool. We'll do that too. And the best thing about it is it's free, usually. It's almost always free. All right, so those are the advantages. Real quickly, this is exactly what we're going to do. First thing we're going to do is we are going to show you how to set it up for the first time. And actually, if anybody in here has already downloaded transactions and they're here because they have questions about it, let me know that. Text me up and let me know that. No, I haven't been to St. Louis. Well, I've been, but not to teach. But I would go there as well. All right, so that was for Deanna. So first we're going to look at how to set it up the first time. Then we're going to show you how to download transactions. Then we're going to look at the downloaded transactions, and we're going to show you how to match the ones that have already been entered into QuickBooks. And then we're going to show you how to enter the other ones. We're going to look at dealing with something called the renaming rules which I will explain to you when we get there. It's one of the more, let's say, fun parts. We'll say fun, fun parts of dealing with downloading transactions. If you understand the renaming rules and can work with them, they're going to make life a lot easier for you. And then I'll show you at the end how to turn off the feature in case you decide that you need to. So Gloria says, is the line still on hold? So apparently she's not being able to hear me. All right, so what we're going to do is we're going to click, I'm going to go ahead and share my screen now. So there might be a second delay, but you should be looking at QuickBooks right now, and I no longer can see chats. So Kyla, you'll have to talk to me. If I need to know something, just feel free to interrupt me at any moment. Let's see. So the first thing that I want to teach you is this is a surprise. This has nothing to do with downloading transactions, but it's something that I just found out recently so I wanted to tell you about it. We are using version 2013 of QuickBooks. That's what you're seeing up on the screen. And those of you who have been using QuickBooks for a while, if you got version 2013, I'm sure you were upset because it doesn't look as pretty. I had a big ol' long webinar on the changes, but one of the main things people didn't like is because it's not as pretty, it's not as colorful. This icon bar up here is in black, and it's harder to read the icons because it's just kind of black and white, and people were complaining about it. In addition to that, the background of these toolbars here and the title bar and the homepage bar is all in black. Well, everybody complained and complained and complained. So they just came out with a fix, and once you download the fix, and that happens automatically, you have this new preference. So I'm going to show it to you, Preferences. And it's under the Desktop View Preferences. And it says, it's this one right here, Switch to Colored Icons Light Background for the top icon bar. This is the top icon bar up here. So this is what it looks like initially, but if I click this, now it looks a little bit better. Isn't that kind of cool? And then the other thing is, if you don't like this black color, you can change it. Company File Color Scheme. I'll go to orange. Look at that. I don't think you would like that. We'll do blue-green. I don't like that either. Blue-purple. We'll go back to the top. But anyway, so wasn't that cool? Kyla, are they commenting on that at all? Does anybody like that? Kyla, I see no comments, but I think it's cool. No comments whatsoever. Kyla, I mean not about that. We did have a couple other questions. Not a very impressive response there. But anyway, as long as me and you like it, that's all that really matters. I just see one person said it's very cool. Okay, good. Thank you for the one person. All right, so now what I'm going to do is I'm going to show you how to set up. And again, what we're talking about, we're not talking about going to your bank account and downloading a transaction and then trying to figure out how to import it. This is fairly seamless. This downloading happens from within the QuickBooks program. So I'm in the QuickBooks program and I'm telling you, this is exactly what you would do back at your office. And if you have an older version of QuickBooks, you've been able to do this for a while now. This is not a new feature. It's been around for years. So what I'm going to do is, first thing you got to do is you got to set it up. And you set it up for each bank account on its own. So I'm going to go to Banking and I'm going to go to Online Banking and I'm going to go to Set Up Account for Online Services. So I'm going to click that button there. It has to close the other windows in order to do this. And the first thing that it wants to know, guys, is it wants to know which account in your chart of accounts list or are you wanting to link to a bank account?  So you can download into a credit card account in QuickBooks as well. And look at this, Other Current Liability. It will download into another current liability account, which means if you have a loan, equity line, mortgage, what have you, anything where you can get the information online, you can download into this Other Current Liability if it's a loan. So I think that's pretty cool. So we're going to do it both for a checking account and then we're going to do it for the American Express account. So first I'm going to do it for my checking account. So I click Checking, click Next. Now it wants to know the name of my bank and look at all of the banks that are here. Look at all of this. All of these banks have gotten the import coding documents from Intuit to enable them to write an import file that will work with QuickBooks. So just for fun Kyla, let me know. I want you guys out there in the world that are listening to me. If you know of a really small bank that you don't think is here, let Kyla know what it is and she'll let me and I'll check a couple of them. So tell me a bank that you're like, oh I wonder if they have that bank. I'm watching to see if anybody has it. Okay, here we go. Home Federal Bank of Tennessee. Okay, Home Federal, where is Home Federal Bank? Oh there it is, Home Federal Bank of Tennessee. How about that? And we'll do one more. Okay, let's do First Bank of Conroe. Okay, there's probably a ton of First Banks. First Bank of Conroe, C-O-N-R-O-E. Oh wow, okay that person wins. Where in the heck is Conroe? It's in Texas, it's outside of Houston I think. That's interesting. Well maybe it's interesting. Anyway, so what I'm going to do is I like to help as many people as possible.  And what we're literally going to do guys is I'm going to walk you through the process which means we're going to be going to the Wells Fargo website. You do it through the program and that's where you create the link. But I really want you to experience this like it will really happen. So I'm going to click Wells Fargo, and I'm going to click Next, and then it's doing a little bit of updating the information about the financial institution. Now there's something we need to talk about. So there are two methods that we can do this. We can do it Direct Connect or Web Connect. So both of them will allow you to download transactions. The difference between the Direct Connect versus Web Connect is that the Direct Connect, once you go to the website first of your bank, and we're going to go through there in a second to do the original link, you don't have to go into your bank's website anymore. Anytime you want to download transactions you simply push a button and it goes to the website, puts in your passcode and username and downloads all the transactions that occurred since the last time you downloaded. And that's pretty cool. The problem with the Direct Connect is that it costs money. And as a matter of fact, it can cost like $10, $15, $20 a month to do this. Now you do get other features when you do this. Oh, by the way, that money that you pay, $10, $15 a month, it goes to the bank. It does not go to QuickBooks so it has to do with whatever the bank wants to charge for this. But there is an advantage in addition to downloading transactions, you can upload transactions. In other words, you can write a check, push it, and not print it, but rather send it through the Internet to the bank and they'll print the check and send it out to the vendor. So you can upload transactions too. But this costs money and I'm cheap. And to be honest with you, going to the website to download transactions through QuickBooks is real quick and easy. It's not a big deal. So I'm going to go with this Web Connect one because it's free. So that's what I do and that's what most of my clients do. So Web Connect, it is free. You can upload transactions but you can download. So I'm going to click the Web Connect. I'm going to click Next. So it's explaining that we've got to go to finish the setup. We have to go to the bank's website. We would have to have done this even if we did the Direct Connect. It's just that we'll need to go to the website each time because we're doing the free one. So you click it and the first thing that's going to happen is these help windows pop up because I know people have a lot of questions about this. But since you're taking the seminar, you don't need that because you have me. And where we are now is we are in the Wells Fargo website. Do you recognize it?  Now what I'm going to do here is I don't want you to know my username or my password. So I'm going to stop sharing for a second and it'll go back to the slides. Kyla, did that work? Kyla Yes it did. Kyla Good. And I'm putting in my username and my password. Whoops, I don't know how to type. Okay, so I'm signing on to my site and so now I'm on my site so I'm going to start sharing again a bit of a delay and then you should be good to go. So now you can see my bank accounts. I'm kind of trying to hide the balances here because this is actually, well it's an account that we don't really use anymore, but anyway, so I'm going to click my business account and this is where you need to understand your own bank's website because you've got to figure out where to go to get to where the downloaded transactions are. Now I picked Wells Fargo because a lot of people have that and I'm just going to scroll right over here and scroll down a little bit and you will see all these individual transactions but at the top you see download activity. Now it may be in a different place for you but this is where it is in the transaction area at Wells Fargo site so I'm going to click download activity. Alright, so now what you're going to see, and this is again, it might be different, the screens might look a little different depending upon what bank you're at but one of the neat things about the WebConnect, rather than doing this directly but doing it the freeway, the WebConnect, is that you can pick and choose what time period you want. So I'm going to download transactions from February the 1st to February the 10th. Now you can download transactions for more than just 10 days. It looks to me like in Wells Fargo land you can do 18 months at a time. And this is something where you would probably go in once a month or once a week or once every two weeks you download transactions. When you go in and put a date range if you forget the last time you downloaded it so you just kind of maybe redownload some of the older transactions, it's not going to do that. In other words, if you pick an older date the second time you come in and you say, well now the second time I download I want to do 2-1 through 2-28. Well all the old transactions that are already downloaded it won't download them again. It only downloads once. So you don't have to worry about remembering the date range that you picked each time. Anyway, so then you picked the file format and I did see somebody out there that was downloading into Quicken. Works a little different in QuickBooks but apparently in Wells Fargo land you can download into Quicken but we want to download into QuickBooks. And let me tell you something, the first time that I went into this screen when I signed up for this, QuickBooks wasn't an option. So I was like, well I understand. So I called Wells Fargo the online tech support and they just turned a switch on and in 2 seconds it appeared. So I had to sign out and sign back in again and then it was there forever. So if for some reason QuickBooks isn't turned on with your bank's website then you may need to call them but that's not a reason not to download. I mean it's still pretty easy to do this. Once it's on it's on. It only took a couple of minutes. So I'm going to click QuickBooks right here. Oh, notice how there's two QuickBooks. There's one that says IIF. Don't use that one. That's for really old files. Use the one that says WebConnect. That's the one you're supposed to use. So I'm going to click download. And then what it's doing is it has downloaded a file. It's a file and it wants to know and the file has the transactions in it. You could probably look at it. It's like a CSV file almost. You could probably open it up in Excel and look at it if you wanted to go crazy but actually I'm not sure that that's true. I like to say things that I don't know are true all the time. Anyway, so we could either save the file which seems kind of ridiculous. Instead we want to open the file and by opening the file it's going to open all the individual transactions and it's going to attempt to place them within your QuickBooks file. Now it's going to give you one more shot at maybe saving it and doing it later if you want to. But no, I'm going to import the transactions now and I'll just uncheck this so this window will go away. There's not really a need for this window anyway, but they're just giving you another chance to save it. But we just want to import them now. I'm going to click OK. Now if you're not listening, listen to me because this is where people make a mistake the first time they go in here without training. What people do is it wants to know where you want the transactions to be imported to. In other words, which account in your chart of accounts list. Now I know you maybe remember a few minutes ago we told at which bank account we wanted to download into you, but for some reason it's asking us again here. And one of the options is create a new QuickBooks bank account and it gives you a name that you can change. And people do this all the time. They pick this one. And then what happens is it creates a bank account and it downloads the transactions to that bank account. So then when you go into your chart of accounts list, I can't get to it from here, but when you go into your chart of accounts list you'll have two bank accounts, the one that you've been using all these years and then a new one with the downloaded transactions. And so then you have to merge the two into the same account and you end up losing all your old bank. It's a big mess. So don't do that. So instead what I want you to do is click use an existing QuickBooks account and then you get your drop-down list of your bank accounts here. Here's the checking account and we click continue. All right, so your WebConnect data has been successfully read into QuickBooks. You can view the data by going into the online banking center. So we are done. We could go into the online banking center right now and if you do that, or we can go into it later. So I'm just going to exit out of this screen. I'm done. Everything's finished. But what it's doing is it's gone into, this is what this is called is the online banking center. Now we'll come back to this in a second, but what I wanted to explain to you is the transactions are here and we are going to add them into QuickBooks. They're here, but they're not completely in QuickBooks yet. I can escape out of this window and just go back into my regular old QuickBooks, go home for the day, and then whenever I wanted to actually put the transactions in QuickBooks, in other words finish the process, I go to banking, online banking, online banking center, and I end up back at that other window. I didn't mention this before. The online banking center can be viewed in two ways. One is side by side and the other is up and down. The up and down method was around for years. And if you choose that method, what that means is you see for whatever bank account you're downloading into, you see the register at the top and then at the bottom you have a list of your downloaded transactions and you try and take them from the bottom and place them into the top. In the newer versions of QuickBooks 2009 and after you have a side by side mode where all your downloaded transactions appear on the left side of the screen and then on the right side of the screen, you manually put them into QuickBooks by moving them to the right side of the screen. So we're going to use the side by side mode. That's what most people use. I'm going to click, do not display the message in the future so I'm not even going to be given the choice anymore. I like the side by side mode. So I click continue. All right, so now we are at the point where we will finish entering the transactions that we've downloaded into QuickBooks. So I'm going to stop for just a second and see who has questions about setting this thing up. So Kyla, do you want to decide if I have any questions for me?  There were quite a few questions at the beginning just to people wanting to verify if this works in versions before 2013. Kyla Yeah, and I mentioned it but I'll say it again. I'm using version 2013 but it works in all the versions of QuickBooks. It's worked for years. You've been able to download transactions for years so it's not a new feature by any stretch of the imagination. Kyla Okay, great. And we have some questions. Does it handle credit unions and then specifically Canadian credit unions? Kyla Does it handle any bank that is on that list it will handle. And yes, there are tons of credit unions that it lists. So that person who wants to know about a Canadian bank, we should probably go back and see whether or not it's on that list. And even if it's not on the list, there are still manual ways of getting an import file. You want to talk to the bank about it just to see whether or not they create a file that works with QuickBooks but it's kind of a question for the bank if we don't see it on the list. So we'll look and see in a minute. Kyla Okay, and that's basically what you would, because we did have a couple of questions asking what to do if their bank is not on the list. So you would just talk to the bank. Kyla Yeah, you want to call the bank and they will know whether or not they have an import file that is compatible with QuickBooks. And then what you would need to do is manually, you'll have to download it and then go to File, Utilities, Import. And then if they give it to you in an II format the bank does, you'll click here. If they give it to you in a WebConnect format you'd click here. So rather than using the features that we're using you still can do it through this Utilities. Kyla Okay, but you've got to make sure the bank works with QuickBooks. Next question. Kyla Is WebConnect free even from Wells Fargo? We just had a few questions about verifying is WebConnect free? Kyla It's free. WebConnect versus DirectConnect is the one where they charge you a monthly fee. The benefit is you can upload transactions and also you don't need to go to the website after the first time. It just downloads from the last time you picked the download. That's DirectConnect. That costs money. But that's not what I'm teaching and that's not what I'm recommending. I'm recommending WebConnect. And WebConnect is free for Wells Fargo definitely. It's free for almost all the banks out there. I don't know of a bank that it's not free for. Kyla Okay. And we had two people asking the difference between QuickBooks online to just QuickBooks. Kyla Well the online version of QuickBooks does have the ability to download transactions as well. But I haven't looked at that. I don't know how different it is from this one. I wouldn't imagine it's very much different. But the program itself, the online edition, is very different than the desktop version of QuickBooks. It's not as, well, they're making it better. Kyla We'll do one more question. Kyla Off the top of your head do you know which file format you would use for QuickBooks online because somebody had asked that. Kyla No I don't. I don't. So if you have a question like that, make sure that you ask me. And I'm going to put my contact information up at the end. But we have a pretty vibrant Facebook situation going on these days. And so I encourage you to find me on Facebook and friend me, and then ask me the question and I'll be glad to answer you. Okay, so let's go on because all we've done at this point is we've gotten 13 transactions, but we want to add them into QuickBooks. All right, so this is where things get kind of interesting. So I got to see the transactions. Where are they, right? So I could either click on the number 13 to get them, or I could click on checking, or I could click Add Transactions to QuickBooks and click checking. Any of the three of those, when I click it, it's going to open up this side-by-side window that I was talking about. So what we have here is we have a left side and a right side of the window. So the left side of the window has all the transactions. There are 13 of them to be reviewed and added into QuickBooks. And they're going to break the whatever you have. In this case, we only have 13. You could have 100. You could have 5,000. But anyway, they break it into three different groups. There are certain transactions, 5 to be exact, of the 13 that QuickBooks has found a match for. In other words, the system says, you know what, 5 of the transactions of the 13, I think they've already been entered into QuickBooks. Now it doesn't show you those matched transactions, but if you click the word show here, and I'm going to do it, it shows you the 5 matched transactions. And there they are right here. Then there is, at the bottom, unmatched transactions, 8 of them. Those are transactions that it downloaded that it doesn't see in QuickBooks because you didn't enter it probably. And we'll show you how to enter those. And then there's this third option in the middle. And in this particular file, we don't have any yet. New transactions created using renaming rules. Don't worry about it. We'll talk about it in a second. You'll understand this turns out to be one of the most powerful parts of downloading transactions, but we're going to worry about it in a second. So the first thing we're going to do is, I want you to think about this like a game. It's a game. And the name of the game is, we got 13 things over here. We want to make sure they're all in QuickBooks, and we want this to go to zero. In other words, we want to get rid of all 13 of these. And then we know that our QuickBooks will basically match the bank because all the download transactions will have been entered. So that's the game. We want to get this to go to zero. So the first thing I'm going to do is I'm going to click on the first matched transaction. And a matched transaction, again, is a transaction that it thinks the system thinks is already in your data file. So here's the first one. I'm clicked on it. If I click on this one, it'll go to that one, but we're going to click on the first one here, check number 5405 for $1,630.06. Now, the system is smart, and it found in QuickBooks in your data file, or in the data file here, it found a check number 5405 in the same amount. So it's thinking this must be that. And it's asking you, is this a match or is this not a match? Now, I'm going to say it's a match. So when I say it's a match, I'm going to click it. But when I click it, I want you to look over here. You see how we have 13 over here? I'm going to click confirm the match. It goes down to 12. So we've started our game. The game is to remove the things off of here by either matching them to QuickBooks or adding them in. So here is another transaction. That it's found a match for. This was some sort of a draft that went out of the bank account. We had already entered it in, and here it is coming out of the bank account. So there's the downloaded transaction. Here it is in QuickBooks. I'll confirm the match. Now, let me tell you something guys. When this program, once you start using this thing, it's going to start matching a ton of transactions for you. We only had five, but it's going to match a ton of them. So rather than confirming them individually, you can confirm them as a group by clicking Add Multiple. So if I click Add Multiple, it's going to give me all those transactions that are left. The unmatched ones will be up here, but the matched ones is what I want to look at. They're down here. So these three other ones are matched. In other words, they've already been found in QuickBooks. And they're checked off. And so what I'm going to do is by clicking Add Selected, there it goes. It matched all three of them. So now all three of those are gone. So now we're down to eight. So those are transactions that QuickBooks has already confirmed that are in QuickBooks. And I just confirmed the match for sure. And now what we're left with is eight transactions that need to be reviewed. Now it's saying they're unmatched, and it says that they need to be added to QuickBooks. That may not be the case. Sometimes the system doesn't recognize that the transaction has already been entered into QuickBooks. And so what we're going to do here is I'm going to show you how to manually connect one of the transactions over here with QuickBooks. And we're going to do it for expenses. In other words, money going out. So here is a check for $42.67. At least it's showing as a check on the downloaded transaction pane here on the left. Now I don't want to enter it. It's just suggesting I enter it. But I don't want to enter it here.  And when it comes to an expense, one of the things you can do is you can just enter it, record as an expense. Or you can, all the way at the bottom here, match to an existing QuickBooks transaction. So I'm going to click that. And then what we're going to have here is it's showing me the downloaded transaction. And then it's going to give me a list. Now here it's just giving me all the transactions as of the last 30 days. But I'm going to tell it to show all because it didn't appear in the last 30 days. So I'm going to click Show All. And then it's going to give me all the transactions here that have been recorded in the bank account. And I can look for this $42.67. Now I can look for it by scrolling up and down. But I can also click on the tops of these titles. So if I click on Payment, it's going to be sorted by dollar amount from the lowest to the greatest. So real quickly I can see, oh look, there's a $42.67. And then you can kind of, what happened in real life is you say, oh yeah, I remember they recorded as a check but I had recorded as a journal entry or something like that because it wasn't literally a check or what have you. For whatever reason. So I'm going to click on that one and if you scroll down to the bottom here, Confirm Manual Match. So I'm going to click it. Now we're down to 7. So that's how you can manually look for transactions that really are already in there. It's just that QuickBooks didn't catch it. Now another thing that's kind of cool is if you enter bills in QuickBooks and then you pay the bills online, that's what happened with this check right here. This check is actually to scan it energy. I'm not sure why the description is Bank of America here. The downloaded transactions have all kinds of weird things in the description field that happens from time to time. And that's one of the reasons why sometimes it won't find a match. But when one exists. But in this case, we paid it's scan of energy. It's a gas company. And we paid them maybe with a bank check. So that's why it says Bank of America. But we didn't record it in QuickBooks. But we had entered a bill for it. So if you enter bills, you can actually match these to outstanding bills.  I'm going to click Select Open Bills in QuickBooks. I'm going to type the name of the vendor that this transaction relates to, Scan of Energy, press the Tab button, and it will give me a list of outstanding bills. So I'll check off this one, and I will click Add to QuickBooks. So what this is doing is it's adding this check into QuickBooks and it's telling QuickBooks that it has to do with this bill and it's reducing the bills. So I'm going to click it. Now we're down to 6. Pretty cool, huh? All right. So the next one that we see up here coming out of the bank, we're going to handle the deposit at the end. So mainly I'm just going to do the expenses right now. Bank card, this is something that it can't find a match for. And this is actually my Visa merchant fee. So this is the first time I'm going to teach you how to actually enter a transaction because the rest of these I matched either manually or automatically or against a bill. This is the first time I'm going to show you how to just enter something. And this happens a lot. This is a draft that comes out for the merchant fee. So what it's going to do is it's going to allow me to basically record the transaction in QuickBooks right here. Just like I was going to do it on a right check window. As a matter of fact, the payee links to the names list in QuickBooks like the vendor list. And you'll see down here somewhere I have Visa Bank Card Center. And then it wants to know the account to point it to. So I'm going to pick, let's see, I'll just pick Bank Service Charges. Notice what's missing here. Say I wanted to enter it to a class. There's no place to enter a class here. So Kyla, I'm going to ask a question. What would I push to get the class feature to show up? See if anybody knows how to make that show up. Kyla If you know, go ahead and type that into the chat pane. Kyla Yes. I want to see. Kyla Michelle says show splits. Kyla Yes. If you click this thing right here, then all of a sudden the information that you're used to seeing in the right checks window or on the inner bills window appears. And you can point it to a class. And we'll point it to the administrative class. In another webinar that I cover, we talk about how you can use the customer job field to track restricted grants. And you could use this for that. So anyway, I'm going to click Add to QuickBooks. Now when I click Add to QuickBooks, a warning pops up, not a warning. Renaming Rule Created. So listen very carefully guys because this is one of the most important things in this hour. It says, all future downloaded transaction from this downloaded payee will be renamed to Visa Bank Card Center. What are they talking about? What they're talking about is that import file from Wells Fargo that downloaded payee name was Bank Card. And so it's saying all future transactions from that payee, Bank Card, are going to be renamed Visa Bank Card Center. In other words, it's basically saying anytime I get a download transaction that says Bank Card, I'm going to assume that you mean Visa Bank Card Center and that's the vendor name I'm going to point to the transaction. This becomes really important because an additional thing that QuickBooks does is that once it knows the vendor name, it says, well, the last time there was a transaction that was pointed to Visa Bank Card Center, it went for credit card fees and actually bank charges. So it's going to remember that and it's going to automatically put the account. So this is that auto recall that I was talking about, but it's connected to this renaming rule. So in other words, you download the transaction from Bank Card, it created a renaming rule, said okay we're going to point it to Visa Bank Card Center in the future and oh by the way Visa Bank Card Center always goes to the bank service charge account. So I'm going to click okay. Now notice what happened. I should have shown this to you before. There was an additional transaction to Bank Card in the downloaded transactions list on the left and now it's been put here, new transaction created using renaming rules. So I'm going to show it. So basically there was an additional Visa Bank Card Center download and so when I click on it, it's assuming it was downloaded as bank card. It's using that renaming rule, changing it to Visa Bank Card Center in the vendor list and then remembering that it goes to bank charges. So if you've got a lot of, this is really helpful with credit cards by the way, but debit cards too, if you keep charging to the same place over and over again, it's going to automatically remember this stuff and it's going to make the process of getting these transactions into QuickBooks very quick. I'm going to show you that. It's going to be more obvious when we do the credit card thing. Now one thing that it doesn't remember and this is kind of a downfall is it doesn't remember the class. It remembers the account but not the class. So you've still got to push the clear spit splits and put the class in each time but I'll click add to QuickBooks. Great. So now we're down to three. So we've got two checks and an IRS. So I'm just going to add those in real quick. And while I'm doing that, who has questions? Go ahead and let me know if you have questions. Okay, great. We just had a question asking if QuickBooks still has a limitation on the number of customer and vendor names. Okay, yes. There's a limitation of $14,500 in the Premier Nonprofit Edition of Customer and Vendor Names. Anybody else got a question?  Does the Enterprise version of QuickBooks is it the same process for that? Yeah, it works the same place in the Enterprise. I'm going to stop you now Kyla because there's a couple more things I want to teach. I see that we're getting close to the end. I'm going to leave these two checks here but what I would want you to do is enter both of them. You want this down to zero, okay? And I'm going to go to the deposits. Now when it comes to deposits that it can't match, what it's going to want you to do is record a deposit. It's going to want you to record a deposit if it can't match it.  Just like with expenses, you have an option that says Match to Existing QuickBooks Transaction. And then you can pick Show All, and you can look through all the deposits to see if you can find one. Now the other thing is if you are going to record a deposit in QuickBooks, you can record it as a deposit by using this section down here. But if you're the type of person who enters invoices in QuickBooks and then receives payments against them, then you can point this deposit against a payment that's sitting in undeposited funds. Finally, if you use sales receipts to enter your donations, then those automatically go to undeposited funds as well. And then when the deposit hits, you can point them against the sales receipt. You can also point against invoices directly. If you invoice, but you don't ever bother telling QuickBooks when the payment's been received because you don't know it, it just kind of hits the bank, then you can point a payment directly to an invoice. And here's one, and here's an invoice, and these two go together. So I'm going to link them, and click Add to QuickBooks. So I'm going to do one more thing. I just want to show you, so again the goal is to get to zero, but I'm going to click Finish this later. I'm going to sign up for American Express now, and this will just take a second. And actually, well yeah, I'm going to walk you through this. Set up account for online services. I'm going to do it for a credit card now. So I'll do it for my American Express card, and American Express, and American Express right there. We click Next.  You get the two questions, so it works the same for credit cards as it does for debit. Transactions here, you can pick in American Express Land. They downloaded all these. You want to pick QuickBooks, and then you want to pick your time period. I'm going to do this card, and I'll do it from April 27th to the present, and then I'm going to pick Download. It's going to download the file. I'm going to open it, and it's going to ask me once again what account I want to point it to. I'll point it to the American Express account that I created in QuickBooks, and then the Online Banking Center now has two accounts. I'm going to go to the American Express Web Connect, and there's 29 transactions. So I'm going to click them. Here's the 29 transactions. None of them are matched. So the last thing, this is, and then I'll stop and take questions. So again, you do the same thing. You would just go down here entering all of these, but I'm going to click on the Description column, and I'm going to let you see that we'll just do USPS. We have 1, 2, 3, 4, 5 transactions to the Postal Service. So watch what happens here. USPS. And this is important guys. So I'm going to click at it, and I'm going to point it to Postage and Delivery, and I'll point it to a class. Click Add to QuickBooks. Now it's going to create a renaming rule. It's going to say anytime it sees this USPS.com, blah, blah, blah, blah, it's going to assume that it's USPS. So what that should mean is that these other 4 transactions should automatically be renamed. And when I click OK, they aren't. They're still there. And here's why. And you may find this problem a lot. You think that you've told, well, whenever you see USPS, make it go to USPS, and it doesn't seem to remember. It has to do with the renaming rules.  USPS, the renaming rule here is USPS.com Space Click Washington. That's very detailed. If you look at the transaction here, let me close out of here for a second. Oh, you can see it right there. There's actually numbers right here. But when it made the renaming rule, it dumped the numbers. And it did it because it was trying to help us because it thinks, well, we don't want numbers every single time because one USPS, even though it's USPS.com, the numbers might be different each time. I know if you go to a gas station like Shell, and then you go to a different Shell gas station, to you it still goes to gasoline expense, but the downloaded name will have a different store number on it. So they're trying to help us here by removing the numbers. But since the numbers were in the middle of the word, now it doesn't recognize this. So what you want to do in these cases is you want to, right here, you can change it. So what I'm going to say is I'm going to get rid of all these other words and just say, as long as it says USPS.com, it's going to recognize it. So I'm going to click Save, and then I'll close it, and now all four of them have moved. So now I can just show them all, and I can add multiples. Four new transactions, right? I'll click Add multiples, and then there they are renamed. They're up here. And the last thing I'll say is when it comes to credit cards, rather than entering each one individually, you can just go through here and assign them on the fly like that, and do it for each one of them, and then you click Add Selected. And I'll just click OK there, and boom, I've already got it down to 23. And let me tell you something guys, once you've been using this credit card one for a little bit, it's going to remember where everything goes, and there will be very few that are unmatched. It's going to make life a lot easier for you. The other thing that's neat about using this is it makes your bank recs really easy. You still have to do bank recs by the way. The transactions that have been entered, I'm going to get out of here, you'll see them in your register. By the way, any account that is set up for online banking will have this lightning bolt on it. So we have these two accounts set up for online banking. And when I double click on them, this column here, which is usually where you would check off a transaction, or a transaction gets checked off when it's cleared the bank. See, I hadn't cleared the bank yet. It's been downloaded though. So once you go through a bank rec and check off in a bank rec, then this lightning bolt will change to a check. A check will check like that. But it makes doing the bank recs easier because all the transactions, particularly for the credit card account, they're downloaded as of the date they actually occurred. So it makes doing bank recs real quick. Credit card recs anyway, they're real quick. If you want to turn off the feature, you edit an account from the chart of the accounts list, and anything that's been set up for online banking, you will see another tab here called Online Services. And we'll click it, and then you can click Deactivate. So let's, and then that removes it. Let's go ahead and use the rest of the time to take some questions. And while we're doing that, I'm going to come back to the slide here. Okay, so I know we only have a few minutes. Well, maybe I'll do this, Kyla. You tell me if I'm missing something. So this is, these are two places to go to get more information. My product, and I'm going to give you a little discount coupon in a second for my training products that you can sign up for, and also live seminars, and also technical support. But we have a training product called The Essentials, and it's listed at the TechSoup site. You can get it at TechSoup, and that's the link for it. And this is where to go to get QuickBooks, I assume, correct? Kyla Yep, that's right. That's for all. Kyla All right. And then questions, let's do a couple of questions. Kyla Sure, we have one person who is asking. Kyla Oh, is it worth upgrading from 12 to 13? Not necessarily. The program only gets better. It doesn't get worse, but you don't have to upgrade every year. Kyla What happens if you have two checking accounts in your QuickBooks? Kyla Then you would go in and set up a second checking account for online banking. You don't have to just set up one. You can set up multiples. You just go back through the process, and you'd set up a second bank account. You can set up as many as you want. Kyla Okay. And do you know if QuickBooks can download from PayPal? Kyla Can QuickBooks download from PayPal? You know, I don't, there is a download feature. I don't know if it's through the online banking center or not, but I'll check while we're talking. What's the next question? Kyla As a non-for-profit, most transactions are donation deposits. How would the deposits show up on the statement without first manually entering them in QuickBooks to create the deposit? How about it save that step? Kyla Oh, I see. Oh, that's a really good question. If you just matched it to an outstanding invoice, I guess, does it show up as a sales recede, or does it show up as a journal entry? And I don't know the answer to that question. That person should find me on Facebook and ask me because I need to know the answer to that. Kyla Okay. And I can't… Kyla I don't see PayPal as an option here. I believe that PayPal may have some sort of an import feature, but I don't see it through QuickBooks. So what we did today wouldn't necessarily work for PayPal. Kyla Okay. And just so everybody knows, for one, if for some reason we did not get to your question today, go ahead, find Greg. I'll be sending out all that contact information and the coupon codes and the follow-up email that should go out later today or tomorrow.  And we are working towards the day when every nonprofit, library, and social benefit organization has what they need to fulfill their own mission. And I just want to do a couple of really quick thank yous. I want to thank ReadyTalk for their webinar support. I want to thank Greg and QuickBooks Made Easy for this fabulous webinar today. And of course, I want to thank Becky on the back end for supporting me with chat. And of course, I want to thank all of you for your time. I know that your time is precious, and I really do appreciate you joining us today. And if you could, just take two minutes to fill out the survey that should pop up at the end of the webinar. I would greatly appreciate it. It really does help us in creating better and more webinars in the future. So again, thank you everybody. Thank you Greg, and I hope everybody has a great day. Cool.


T.F.N.N. The Tiger Financial News Network. T.F.N.N. Headline News Update. Good morning everyone, Basel Chapman. Here is the 10 o'clock Tiger Financial News Network on Monday, the 26th of February. Just finished the, this is the 9 o'clock show that Tommy Jr. does. That's the market kickoff. Great show. And now I've got the 10 o'clock show. Great programming at T.F.N.N. Dows up 94 at 39,223. Here's the Chapman, we've inside track repellent zone. We'll see how it either breaks out above it or it stalls right in the red and green mini channel because the S&P same thing. S&P here we go. S&P is trading right now up 151 at 5,090. Friday was a high for the Dow, so far no new high, all-time high. But the S&P has made a new all-time high at 5,097.66. Nice action in the inside track repellent zone. Let's go to the QQQ, NDX100 trading vehicle. I've got this as having made a new all-time high on Friday, just about 440. It's trading right now at 436.62 down 17 cents. The technicals are starting to weaken, although the S&H which really leads the QQQs is still doing very nicely. It didn't make a new high today. It got repelled on Friday at the Chapman inside track repellent zone. And the QQs, semiconductor is up 91 cents at 209.58. Let's go to gold. Gold was down earlier on, trying to run it a little bit. It's now down 12 at 2037, sitting on those two moving averages, the pink nine-peered moving average and the black 14-peered moving average. The 2025 level is really that magnitude of the 200-peered moving average. Really important, but look at this. The Dow really hasn't done very much. It's down 14 ticks at 103.80. Crude oil tried to rally last week and then started to fail. Today it's up 40 cents at 76.87, but it's really not acting all that well. And if you go to the bonds, let's go to bonds, bonds right now are unchanged at 119 and 230 seconds at the low end of the run. Therefore, the yields are at the higher end of the spectrum. So with that said, in my Tiger Technicians Hour coming up right now, I'm going to discuss some of the actions, some of the things we're looking at for this week that I discussed with my subscribers before my hour long video, both of you, over the past weekend, this past weekend, every weekend, as long as I'm in town. And let's get to the market as soon as we get back. That's a chapter of Tiger Technicians Hour coming up. I hope you serve the fields.


Hey guys, welcome back to my channel. My name is Sinali. If you guys don't already know me, and today I'm going to be filming a skincare routine for you guys. A lot of you have been requesting this video lately and I decided to film it for you guys. Just a little disclaimer, obviously my skin is not like the most perfect thing in the world, but before we get into the products I use, I just want to like kind of give you like a background story on my skin throughout the years. So when I was little I always had skin diseases like if it wasn't eczema, it was folliculitis. If it wasn't folliculitis it would have been like a wart skin disease. Like it almost felt like I had every skin disease which obviously I didn't. I probably had like five different ones at different times, but you know it was a lot for a little girl to handle. So my main one was eczema. I've had that my whole life. I still had it to this day a little bit and that definitely made my self-confidence drop to like a hundred to like a zero. And even my dad said that I had baby acne when I was little, so you know that just goes to show you that I never really had perfect skin. Now that I'm an adult and I actually know how to take care of myself, I feel like my skin has gotten so much better. I do get a little bit of eczema here and there like on my upper lip and just all over my body sometimes, but nowhere near what it used to be. If you knew me in fifth grade I think that was my worst year ever and my whole face was just swollen and raw. Like felt raw because I was just like itching it and eczema was all over it. So I did have rough days, but you know started from the bottom and we're here and I feel so good about my skin. And now I just want to share all my great tips with you guys. All right so the first products I'm going to be talking about is actually face hair removal. So the first one I have is this tweezer man little face tweezer thing. It's really cool. It's kind of complicated to learn how to use because me and my roommate literally sat there for hours trying to figure out how to use this, but basically this thing is curved so this flat side is supposed to go on your face. And then there's little arrows on the sides to tell you which way to turn it. So then you just take the tool and put it on your face and then rotate the knobs while you push the tool up if that makes sense.  There is an alternative painless tool. I know you probably have seen this before.  So all you have to do is turn the switch on and pretty much just shave your face with it. It's super fast.  This tool only cuts off your hair like at the base of it while this tool tweezes your hair out of the root. So obviously this is going to last longer so it just depends on your pain tolerance and how long you want it to last. So I wanted to share that with you guys because I've only recently been shaving and tweezing my face and it has made the world of a difference when I put on my makeup. It just goes on more flawless and it just looks a lot more flawless when I don't have all this peach fuzz on the side of my face. So next thing I want to talk about are masks. So this past January I had to splurge on the Glamglow Mask. I only bought it because it came with this little one and it was the same price as just one of these. So I lucked out on getting both of these for a really good price. Now that I have this I really don't use any other mask and if you were deciding between both of these I really like this one because it has some exfoliating properties in it. So when you do wash it off you can really exfoliate with it. But this white one I would just use for like a spa treatment that's what I personally do.  So obviously these are not in my daily skincare routine but I did want to share them with you guys because masks are a vital thing of skincare. So I don't really get zits and pimples all that much but what I do get is whiteheads all over my nose. It is so gross. But these Biore nose strips help so much. It leaves my nose feeling so incredibly soft and you can not even like feel the bumps and it's not as noticeable. Unfortunately it doesn't like take every single whitehead off your nose but it does get rid of majority of it. So when my nose is like really bad I'll take one of these because they are kind of expensive so I don't want to do it like on an everyday basis so maybe I'll do it like once or twice a week. So speaking of those whiteheads on my nose I wanted to show you guys this tool right here. It's called the pimple popper tool. So you put your pimple right in between these bars right here and then you scrape out the oil. You might have seen this tool on Instagram. There is an account called Dr. Pimple Popper and this doctor's job is literally to like get the pus out of pimples. Like what? I want to get my pimples taken out by a doctor but since I don't really want to spend all that money I just have this tool and it works just as well but I will tell you guys that this tool is really addicting because right when I get a pimple I just want to scrape all the oil out but you cannot do that because you're going to get a really bad scar and it's just going to be even worse than having a pimple. So you do have to wait a little bit just to make sure it's kind of ready to get out and then you can go in with this tool and just scrape the oil out. So when I do get pimples on the first and second day I usually try to ice them. They do go down significantly but if they don't then when they're ready to pop then I'll just use this tool. So at night when I want to take off my makeup I use my Bioré charcoal pore minimizer. I have been using this for maybe over two years or at least over one year. I know that for a fact this was in my last skincare routine and I really like Bioré products. It has beads inside of it so it's really helpful to clean all that gunk off your face at the end of the day. So after I use the Bioré product I usually go in with this. It's the Clarisonic Deep 4 Daily Cleanser. I actually got this with my Clarisonic because I got the Deep 4 package so it came with this product and a little face mask. I really like this product because I feel like it tightens my face after I use it. Like it just feels so soft and it just like feels rejuvenated. So I usually go in with this and my Clarisonic after I take off all my makeup because sometimes I just don't want to get my Clarisonic brush too dirty with all my makeup and I also use this every single morning and it makes me feel so refreshed.  So the last product is from First Aid Beauty. So I usually use the Ultra Repair Cream but those days when I'm going to be out in the sun all day I use the Ultra Repair Pure Mineral Sunscreen Moisturizer.  If you guys use any of these products or even if you use anything different comment them down below because I'm always on the lookout for new products to try. So I will see you guys in my next video. Bye guys!


A modern missile, symbol of America's power, progress, and hope for the future. Equally, symbol of a vital challenge. From whence will come tomorrow's scientists and engineers? This film is the story of a joint effort by your Army, New Mexico State University, and Texas Western College to help meet that challenge. This is United States Army headquarters, White Sands Missile Range, New Mexico. Out on the range, an Army hawk awaits firing. Project engineers check over this swift destroyer of low-flying aircraft. This is Don Hart, junior project engineer. Don is a new full-time employee at White Sands, but not new to missile technology. In fact, Don's background assures a promising career. How did he acquire this background? In short, how did Don Hart get here? At New Mexico State University, formerly A&M College, there is a man who can answer that question. He was Don's first faculty advisor. How did Don Hart get there? Well, to start the beginning, it was at our local high school here in Las Cruces, New Mexico that I first met Don. The occasion was College Day, oh, some five years ago. I remember joining the representatives from other colleges and universities. And our common purpose was to encourage promising students to continue their formal education. Don Hart was one of the young people I talked with that day. Don stood in the upper quarter of his class and wanted to go on to college. But there seemed to be problems. He felt he would like to be a missile engineer, but he wasn't sure that he was cut out for it. And with older brothers in college, money too was somewhat a problem. I asked if he had considered the cooperative training program jointly conducted by the US Army at White Sands Missile Range, New Mexico A&M, and Texas Western College. Later at Don's invitation, I called it his home. Yes, Mr. Hart had heard of the White Sands Co-op program. It helped students work their way through college, didn't it? Well, I agreed, but explained that the primary purpose is to give practical work experience to supplement classroom theory. For Don, the program offered a way to discover early if engineering was for him. At the end of our talk, I felt that the hearts were favorably considering the co-op program. My impression proved correct. Don enrolled in New Mexico State University that summer. Later, he took the examination for entrance into the cooperative training program. The examination includes a general aptitude test. At the same time, the same examination was being given at Texas Western College in neighboring El Paso and at other points throughout the nation. The examination over, Don looked in the direction of the missile range. He wondered about his future, his career in the missile field. On the other side of the picturesque organ mountains lies White Sands Missile Range. I am the educational counselor for co-op students here at White Sands. I remember the day several years ago that Don Hart and his group first reported. Out at the launch site while we waited to see an Army Nike Ajax fired, I briefed them on the training program. I explained that as college freshmen, trainees are assigned civil service pay grade GS2, as sophomores grade GS3, as juniors GS4, and as seniors pay grade GS5. I explained that pay is received only during the work periods, about six months of each year, and that the co-op student is a full-fledged government employee with full rights, privileges, and responsibilities. I further explained that students are assigned work within the field of their special interest. Forty. His first assignment was to the Corporal Missile Project, as his major he had chosen electrical engineering with an option in electronics. He was now under the wing of his immediate supervisor and experienced graduate engineer. In the months that followed, Don was introduced to the world of electronics. Perhaps he was a little confused at first. But his time passed, his confidence grew. A number of strange new terms crept into his speech, such terms as shake table, impact test, high altitude chamber, and climatic test. The more Don learned of missile technology, the more he thought he was going to like it. He grew to rely upon his supervisors. The supervisor is a key figure in any cooperative education program. He not only assigns appropriate tasks, but evaluates the student's work, reports on his progress, and reviews his monthly work reports. In fact, the supervisor's role is so vital, he is sometimes called a field faculty member. Yes, my supervisors were a big help. So was everybody, my faculty advisor, the people at White Sands, and the other co-ops in my class. There were times I needed help. Take that course in vacuum tube amplifiers, for instance. That one really had me stumped. But the life of a co-op is not all work. I'll never forget the experiences in ROTC. Then there were the sports events, the social occasions, and life in the fraternity house. This is the rocket engine test stand where I worked in my junior year. This stand was built to hold a rocket engine stationary while as much as a half million pounds of thrust blasts from its nozzle. These are the portholes of the instrumentation room where I worked. I'll never forget the excitement I felt during my first actual static test. The countdown was x minus 30 minutes. My job was to assist in checking out the instrumentation. Frankly, the assignment had me worried. I'd managed to pass that course in vacuum tube amplifiers and other qualifying courses, but I didn't feel I'd really grasped many of the finer points. As we checked over the instrumentation, propulsion experts performed the last precise operations prior to firing. Time is x minus 5 minutes. All personnel, clear test area, and take cover. As the minutes ticked away, the complex instrumentation system was readied by careful plan. Banks of recorders were set to register hundreds of channels of information on the engine's temperatures, pressures, thrust levels, relay operations, and flow rates. Time is running on x minus 20 seconds, x minus 20 seconds. 10, 9, 8, 7, 6, 5, 4, 3, 2, 1, 0. Thanks to this and similar practical experiences, the theories they taught me in the classroom began to make a lot more sense. I felt more certain than ever I found the right field. A conference was called during Don's senior year. We wanted the students' help in evaluating the co-op program. These students had worked in practically every major operation on the missile range. Civil engineering majors had learned surveying techniques for highly precise positioning. Electrical and mechanical engineering students had helped to fire the missiles and to track them through their supersonic flight. Physics majors had helped operate the intricate chain radar system. Co-op students had also helped conduct hundreds of other operations of widely different types. And after the tests were made, co-op mathematics students assisted in computing the data. Yes, co-ops have made a valuable contribution in carrying out the White Sands mission. After five years of study and work experience, Don's class received their degrees. He and a number of other graduates accepted positions at White Sands. Well, that's how Don Hart got here. He's now a full-time professional employee at White Sands missile range. Classification, electronic engineer, future unlimited. Twice each year, Don will see the new class of co-op students on the viewing stands. He knows they face a challenge. Very survival may depend upon Don and his colleagues. In any event, the big challenge will remain. A challenge as big as space is big.


My name's Sam Cutler. I'm an intraday equities and options trader And I've been trading full-time for about three years now two years prior to that I was trading for a hedge fund in Amsterdam and before that I was playing professional golf on the European tour So when I was trading in Amsterdam for a hedge fund out there I was mainly trading European equities on strictly news and momentum and After doing that for two years I had done fairly well and wanted to branch off by myself and I was actually planning to move back here to the U.S. So I wanted to start trading the U.S. markets And sadly I failed doing that by myself for the first few times the same strategies Just didn't really carry over and I couldn't really figure it out. I had always followed Dan on Twitter I heard some of interviews on chat with traders and I figured I'd give him a try to just learn a new process To trading the U.S. markets and ever since then I've kind of stuck with them because the process is it's golden It's life-changing so prior to joining Dan in the daily webinar. I was really struggling with my consistency I'd have huge swings coming from the fund world I was used to putting on pretty large size in my trades and when I started doing that with my own money and I'd Go up X amount in a day and immediately see it disappear It start to get me pretty shaking and I just knew it really wasn't sustainable for a long run So with Dan and his help I really developed confidence to gain this consistency that I've seen for the past year in my trading You know you do a lot of your own work with him and well But he really he does a really good job at coaching you every day on how to do the work and how Important it is to put in the time and to teach you this process that he's spent the last 20 years developing and working on Some of the biggest lessons I've learned is staying patient and waiting for your opportunities and you don't have to trade every day Dan always says this too in the webinar that when beta rests you rest So that's something that I've written down and I'm taking that very seriously because the biggest losses that I have Stem from being impatient not waiting for anything to confirm or just sitting there getting too antsy and trying to put On a trade that there's no rhyme or reason to it. I Mainly now I'm not gonna say I only do it I'd like to only trade the process that Dan teaches But every now and again we get a little excited and we run off on our own opinions and to be honest That's when I've lost. I've kept all my stats the year that I've been running with Dan I'm running on his strategy a 71% win rate and The past 60 days I've had four red days and those have come from deferring from the process and trading an opinion So needless to say I Got to stop doing that and I got a really really focus on just sticking to the process and letting things come to you naturally I'm huge on stats. I track all my trades in excel with the probabilities on the time frames at which it trades to and all of my best trades Are held for a minute to five minutes on these intraday pivots and when they confirm, you know beta just runs There's no second guessing it you can tell within a minute or two if it's gonna go or if it's not and if it's not gonna go You get outbreak even and then when you start sitting hoping and wishing and adding to losers Everything just goes against you and and with Dan and his process. I've seen I believe Last month the average winner was about two dollars and seventy five cents and the average loser was about forty cents So that's that's really where the process comes in is Dan's really really meticulous on risk management and implements that in your mind The process that Dan has, you know, that's just it's truly amazing. I've traded a lot of different strategies and his is just The consistency you find in it and the confidence that it brings about in yourself is truly It's pretty remarkable actually sometimes you got to kick yourself and you know You find yourself just hitting the keys every day and you know like it's it shouldn't be this easy and it's not easy But as a trader, you know what I'm saying it some days. It's just like wow. It's really It just happens like that the access a trader community is just amazing and I'm not gonna lie I have three four guys that I talked to every day on the phone from the live webinar that we exchange ideas when we have Rough days where there we lean on each other even with stuff going on in personal life I've had a pretty rough last month personal why speaking and all of these guys have reached out to me every single day Checking on how I'm doing seeing if I need anything, you know Tell me when this virus is over where I'll got to get together and go meet up somewhere And it's just in the discord chat to everyone's always there at the end of the day Just asking how would everyone do would you guys trade? What are you struggling with? You know, it's not just then it provides value in this live webinar It's everyone that's in there alongside of them and there's some veteran traders in there as well that have Really really strong traders. I would say this community is for someone who wants to grow as a trader develop a process But also grow as a person mentally and understand That trading isn't an overnight thing. It takes time. It takes discipline It takes practice and it takes patience and Dan has been there to guide you through every step of that And it's just truly a blessing to have found Dan and been able to do that 100% I would recommend access a trader to anybody looking to grow their portfolio grow their mindset expand their strategies Or if you're brand new to trading, I couldn't recommend someone better to start trading with than Dan