 Yeah, we could have just kept lists to the music, but I know we have work to do. So thank you everybody for joining this webinar. I'm so excited about this one, downloading transaction into QuickBooks online and desktop. Gonna learn how to enter hundreds of QuickBooks transactions in a matter of minutes. Let me show you how you can engage today just for those who may be new. You can type your questions in the chat or in the Q&A. We're going to sing a recording within four to eight hours. You'll get that really, really soon. If you learn something new today, which I know you will, go ahead and share it on social media and make sure you tag us at TechSoup. If you need to close caption, tap on the CC button at the bottom of your screen. Somebody has already done that. And I want you to share about Quad. I don't know if you are a member of Quad yet, but Quad is amazing, if you haven't heard of it. Quad is a new platform we have here at TechSoup. And one of the good things about Quad, if you come in this community, you can have 10 members use the courses. I know a lot of times you pay for courses, just you, but there's so many other benefits to being a member of Quad. I'm gonna put the link to Quad in the chat window in just a moment. But I'm gonna turn this over to Greg so he can get with the QuickBooks webinar. Greg, go ahead, take it away. All right, man, hey guys, how's it going? So we only have an hour, so this is gonna be quickity quick. Wanna find out, put it in the chat, and by the way, I should tell you, so if you wanna ask me a question while I'm talking, put it in the chat. I will see it, like Pam wants to know how do you join Quad, Aretha. I can see that, Sandy liked the music. Whereas if you have a longer question, Barbara Starley, who is a CPA as well, she specializes in houses of worship. Barbara is gonna be manning the Q&A on the back end. Say hello to everybody, Barbara. So okay, cool. But so if you have any questions for Barbara, please ask there. And how many of you have seen me teach before? Put it in the chat. Who has seen me teach before? Yes or no? We've got 144 people here. Who has seen me teach? Wow, okay, so it looks like most people have. Wow, that's amazing. Wow, it's like almost everybody has. That's insane. Okay, cool. Well, then I don't need to talk about myself. The only thing that I will say is yes, I'm a CPA. I specialize in nonprofits and I own the company. QuickBooks made easy for nonprofits. And I'll just go to that site because I did want to highlight. We have twice a year. We do a three day webinar series. It's two and a half hours a day for three days. And it's coming up for people that are using the desktop version at the end of this month. And in the beginning of next month, it's going to be for people that are in the online edition. So October 31, the first and second for people using desktop, November 7th, 8th and 9th for people that are using the online. Normally it's 299. We're going to give you a discount coupon that I'll give you at the end of the session for $40 off, although there's the code TS40 off. But anyway, so what we're going to do today is we are going to cover downloading, how to connect your QuickBooks with your bank for downloading transactions. And what I'm speaking of is both for bank accounts, checking accounts and savings accounts. I'm also talking about credit cards that you use to buy stuff with. That's specifically what we're referring to. This is a feature that's available both in desktop as well as online edition. And I should probably ask that poll now. I'm kind of curious to see who's using desktop and who's using online. So I'm going to launch a little poll here. I see all our answering in the chat. Thank you, but I'm kind of curious who's using QuickBooks desktop and who's using QuickBooks online? Go ahead and answer in the polls here. So we've got 156 people here and so far 122 of you have answered. A number of you are doing both. So make sure you answer in the poll. One person says neither. So I'm wondering, workstation one, why are you here? Oh, hey, Allison, how are you? Cool, Allison with TechSoup is here. Love, Allison. I'm going to go ahead and end the poll and share the results. And here we have 54% of you have QuickBooks online. 38% of you have QuickBooks desktop. And then about 10% of you are using both, all right? So here you can see the results right there. Okay, so I'll stop sharing. So, and by the way, in case you don't know this, QuickBooks online, go to QuickBooks online. QuickBooks online looks like this. This is QuickBooks online, all right? And then this is QuickBooks desktop, all right? And so we'll take a look at both of those. Both of these softwares will allow you to download transactions from the bank. We're going to show you how to connect the bank. We're going to show you how to download the transactions and we're going to show you how to point them and add them to your QuickBooks file, all right? So I don't even think I need to worry about this. All right, so how to connect your QuickBooks to your bank for downloading transactions, all right? So I'm going to do this. I'm going to do it nice and slow. There is a recording. You'll get the recording. I am kind of curious though. I have another poll I'm going to ask because I'm sure some of you are already downloading. So let's see what your level of experience is with downloading transactions from the bank. Never done it before. I set it up, but I'm not using it. I've used it a bit and messed things up. I use it well, but have some questions. And I know it really well, but I'm hoping to have some extra tips given to me. So I mean, hey, it's free session. Why not, Ram? So we got 166 people now. We're almost, everybody has answered. Trina put in the chat. I may use QBO Plus for nonprofit, but I've never used it. What are the differences between Plus and Advanced? So this has nothing to do with downloading transactions, Trina. But I'll tell you, you really should be using Advanced. It's $160 a year with TechSoup versus Plus, which is $75 a year. You can have up to 25 users in at the same time with QuickBooks Advanced instead of five, the QuickBooks Plus. The major thing that I like about Advanced is that it allows you to back up your data file so that you can rewind your data file and get back to where you were before you screwed things up. You can't do that with Plus. You can do that with Advanced. Brookfield, I don't cover importing IIF files. This is about downloading from the bank. I do cover that in my big sessions, but won't be covering that here. So here's the result. As you can tell, over half of the people here have never even done it before. So that means that there are about 35 people that know it pretty well and have very particular questions. So we're gonna try and get you covered too, but gotta be understanding that there are people that have no clue what's going on. So we'll have to be careful to make sure that everybody is happy. Okay. Stripe, somebody mentioned about Stripe. We're gonna talk about connecting from bank. The Stripe does not connect directly to QuickBooks. You have to use a third-party app. The one that I like to recommend is Sender, S-Y-N-D-E-R, Sender, but it costs money, all right? So enough of that. Let's move on. So the first thing that I want to explain for people that hear, oh, good, I can connect my bank to QuickBooks. I don't have to enter a bunch of transactions. It works really good for credit cards and debit cards transactions, is they get scared because they're afraid that what QuickBooks is gonna do is it'll not only download the transactions, it'll assume what the expense account is and it'll just add it to your file and it might be pointed to the wrong place or it might've already been entered manually by you with your fingers and now you've got double entries in there. So people get scared about it. So I wanna explain something to you. Let me tell you what's not happening. When you connect your bank to QuickBooks, what's not happening is the bank is not correcting, is connecting directly into QuickBooks. That is not what's happening. What happens is when you connect to your bank, it goes into a waiting room, okay? I call it a waiting room. Some people call it a holding tank. It's basically a location that's within your QuickBooks program, but it's not part of your financial statements yet. It's not been subtracted or added to your bank account. It's just a list somewhere almost like an IIF file, Brookfield. It's just sitting there waiting to be added and then what you do is you go through each transaction in the list, you go through her, you look at him, you look at her and you decide where you wanna point them and then you add them to QuickBooks, okay? So let's take a look at what that waiting room looks like. The waiting room in the online edition, to get to it, there's a couple of different ways you can go to get to the waiting room. You could click on bank transactions right there, but actually I like to go over here and anytime there's a bank account that's connected, you'll know it because if there's any transactions that need to be added, it'll be in blue. So there's 27 transactions in the waiting room, waiting to add to QuickBooks for this checking account and there's 79 for the savings account and there's 56 for this American Express account, all right? And I can just click right on there and take me to the waiting room. So here is the waiting room right here. Now I've got three accounts that I have connected, all right? And I'll show you how to connect an account in a second, but these are all of the transactions, these transactions are not in QuickBooks, they're in a waiting room, okay? If you are in the desktop version, we go to banking, we go to bank feeds and we go to bank feeds center and this is where your waiting room is and your waiting room is gonna look very similar. And where is the waiting room? There it is right there. I'm gonna go ahead and click on it. Now this waiting room, it's kind of broken out. There's recognized, partially recognized, unrecognized and already added. I'm gonna go to the unrecognized. This is where the majority of them are. So this is what it looks like in QuickBooks desktop. This is what it looks like in QuickBooks online, okay? So let's talk about how to add, okay? So that's the first thing we're gonna do is gonna show you how to add, okay? Now I'll do it with the online edition first. The online edition is free to add, okay? And it's free to download. All the banks pretty much work with it and it's free. The desktop edition costs money sometimes, not from Intuit, but from your bank. Whereas the online edition is always free, okay? But they both kind of work the same. So to do this in the online edition, it says link account right here. So I can probably click there and it'll take me right where I add an account. So I'm gonna put the name of my bank. I'm gonna put Wells Fargo. Now what it does is it's going to go to your bank's website and it's gonna go to not some backend thing at your bank that you can't access. It goes to the same website that you go to to access your bank information and look at statements and transactions and stuff like that. So if you don't have your username and your password, your boss does, you'll need to get it from them in order to make this work. And if they won't give it to you, then you need to ask them, why are you having me do the accounting? If you don't trust me. Anyway, I'm gonna go ahead and click sign on. And each bank kind of does it a little bit differently, but this one, Wells Fargo is gonna send me a text to verify that I'm actually the person because it's gonna access my bank account. So, and I'm gonna put my little code in here that it gave me, okay? And then I'm gonna click submit, okay? So it's giving me all of my bank accounts, okay? They're right there. And so let me scroll down to the bottom here. I'm kind of hiding this from me because it kind of has a bunch of private information. There we go, all right. So I'm gonna go ahead and click continue. And then here's all of my bank accounts. I click connect. And then it's going to connect. So after it connects, let me see where I am, my, where is my, there it is right there. So now it's connecting. And once it connects, and I think I have to hide this again, sorry, because I think it gives me actual information, yeah. So once it connects, I want you to see, it gives me a listing of each account with the balance in the account. And then I'll show you this first one. And then over here, it's asking me, hold on, yeah. At the bottom, let me go back to the bottom here, hold on. I need to hide some of this stuff so I can see it. Okay, there's a little connect button and it asks you which one do you wanna connect. So I check off which one that I wanna connect. And when I decide that I wanna connect it, I'll just show you. When you check it off, so I clicked on this and then this pops up. So what you do, this is where you connect it to the bank account that's in your chart of accounts list. Okay, and we'll just connect it to this one. Okay, so that's what you do. Now when you're done, I need to move this over again, I'm so sorry, but in order to do this, well, I have to do it for in real life and then you get to see everything, but let's see here. Gonna make this a little bit smaller and we'll go down to the bottom. Okay, cool. So at the bottom of the screen, there is going to be, and this is a screen a lot of people miss, and all this happens in the desktop as well. So don't worry guys, but it says how far back do you wanna pull transactions from? Now, here we are in October. I probably don't wanna pull transactions from the beginning of the year, okay? I could because again, they're just gonna be in the waiting room. They're not gonna be added automatically. And once they're in the waiting room, you can throw them away out of the waiting room if you want to, or you can add them or you can match them, which I'll show you if it's already in QuickBooks, so it won't duplicate. I'm just gonna say I want this month, okay? Now, if it's a credit card that you're doing, I'm gonna give you a suggestion. Listen very carefully. For those of you that are gonna download credit cards, I'm gonna give you a suggestion. You know how a credit card, the billing cycle ends in the middle of the month like the 17th or the 15th or whatever. So what you wanna do is here we are in October. So if I'm gonna connect my credit card, let's say my credit card statement drops on the 11th of October. So I don't wanna download any transactions from the 11th of October backwards because I'm just gonna use my old method for that. I'm just gonna enter the bill and pay it or whatever. I wanna start using it for the next billing cycle. So what I would do is if it was a credit card, I would click custom and I would pick the date October 12th. So then all the transactions that get downloaded would be from the credit card statement that's coming up next. Does that make sense to y'all? Did that make sense to y'all? Put it in the chat. Does that make sense? Y'all put it in the chat. Okay, cool, okay? So, cool. All right, great. So if it's for a bank account, I would probably just do the ones for the current month. So I'm gonna say 10-1 and then I'm gonna click connect. Now, what it's gonna do is it's going to download the transactions. They're not gonna be in QuickBooks. They're gonna be in the waiting room, okay? So it's only gonna take a second. It brings in the transactions. Wow, we're only 20 minutes in and we're already learning. Okay, so now here is my home page but we should see that new bank account. There it is right there with 48 transactions to review and here's the 48 transactions here, okay? Now let's go over to QuickBooks desktop. For those of you that have been waiting, let me show you how to add an account from QuickBooks desktop, okay? So chat me up. Where are you? I'll only take a second for this, guys. Where are you? Put it in the chat. Are you a desktop user? Let's hear it. It's your time to shine. All right, okay, cool. Now, desktop, you're gonna go to banking, you're gonna go to bank feeds and you're gonna go to setup bank feed for an account right there. Now, when you do this, I will tell you, the online people have it better than you. The online people, they connect it once, they never have to worry about it again. It downloads transactions automatically every day and it's always free. People that are in the online edition have it really good. People in the desktop version, not so much, okay? Now there are some banks like American Express. If you have an American Express card, you put American Express as your bank, you click continue, you put your username and your password here. Hopefully they hide it. Yeah, we click log in and then you get a very similar screen like we did before. You pick the car just as like picking the bank, you authorize and then after that, it's connecting right now. And then just like with the online edition, it's going to ask you, now, I've already connected this car so that's why it's saying that it's running into a problem but it will ask you what date range you wanna download to and it'll ask you what card you wanna connect to so it works the same way. And then once you have the American Express downloaded, it will appear in the bank feeds and I'm gonna go to the banking, go to bank feeds, here's the bank feed center and it doesn't look exactly the same as the online edition but it's similar with the little block up here, here's all the unrecognized transactions and we'll add them but we're gonna talk about those in a second, okay? See, I already had the Amex connected, that's why it gave me an issue, all right? All right, so when it comes to most other banks, besides American Express, when I go to add a bank, I'll do one for Wells Fargo. I wanna show you something. I'll put in my username and my password. Let me move this out of the way so you, yeah, I'll put it over here, okay? Let you know I'm doing this for real at least, right? And okay, it gave me an issue so it's saying that I don't have the right login information, so that's unfortunate. Let me try a different bank. I'm gonna go ahead and get out of here and try a different bank. I will tell you, I'm not surprised that this is happening with the online edition. It's a lot tickier and set up an account. I'm gonna try this one more time. Let's see, Bank of America. We go here, yeah, and again, you're gonna use your user ID and your password and I don't have a Bank of America account so it's not gonna work. So I can't show you the next screen here, unfortunately, but the connection will work the same, all right? The one thing that I wanted to tell you, there was a screen I wanted you to see that I can't get to appear in the desktop because I can't get into my file, but the screen will tell you sometimes that there is a direct connect and there's a web connect. And if you're in desktop land, the direct connect is gonna cost money and you're gonna need to call your bank and tell them that you want to pay them. It's like $10 or $15 a month in order to have a direct connect. The advantage there is that you don't have to, you just push a button and it downloads. Most of the time though, with desktop users, they literally are going to their bank's website and they're downloading a file, a web connect file from the bank's website is what they're doing. And the only way I can show you that is to go to my own personal bank's website. Don't necessarily wanna do that here, but does anybody have any questions about downloading directly from the website, going to the website and creating a file that you import and connect? Does anybody know or have dealt with that before that's in the desktop world and has questions? You just simply go to your website. I mean, I'll start it here. You go to your Wells Fargo website and once you sign in, you've gotta find where the downloaded transactions are. I'll just go to one of my accounts here and I'll go to this one and let's see where it is. I'm looking at my transaction here and I need to find where you download. Look at that download account activity. It's in a different place on every single bank, but you click here, you pick what time period you wanna download and you're gonna be looking for something that says web connect, okay? So this is how you'll do it for free, okay? So I'm gonna click done it. The interface seems clunky. Have to re-log in each time for the download file. That's correct. Every time you have to go back into the site, I'm gonna download the file. It's downloading right now. It's right up here. It's called checking six QBO. I'm gonna see where it is in the folder. I wanna recognize where it is. There it is right there in my downloads. So then what you do to actually import it in to your desktop file is you go to file, utilities, import, web connect file. You click it and then you go to where you had that file downloads right here. This is not for the faint of heart. I click checking, I click open and then it wants to know which account do you wanna connect it to? A lot of people make the mistake of creating a new account which was be wrong. Instead, what you would wanna do is you would wanna point it to your existing account. You click continue. The transactions will be downloaded and then you'll be able to access them through the bank feeds, all right? And then you'll be able to add them. So we're going back in. So now, look, there's the checking account right there. So we have 237 transactions that we downloaded here and here's the American Express with its transactions right there. Is that better? I feel like I did that a little better. So just kind of summarizing in the online edition it's automatic, it happens for you. It's easy, it's free. In the online edition, unless you wanna pay money you have to go to your bank's website, create a web connect file, download it to your computer and then import it in. It's still a cool thing to do, okay? But one thing also about the desktop version is that if you have an old version like Bruce has 2021, after this year you're probably not gonna be able to download anymore, okay? Because after three years of the desktop version it stops working with this download feature, okay? And Steve says the transaction list looks different for him. So there's a couple of different ways of looking at the transaction list, Steve. If you go to where your preferences are and you go to where is that thing? Let's see if it's desktop view. There's a place that controls what, maybe it's under banking or checking. Let's see if it's here. Here we are, bank feeds. There's an advanced mode, there's an express mode and there's a classic mode. I'm in the advanced mode. So take a look at that, Steve, all right? All right, so now once we have the transactions in I'm gonna go back to the online edition. So listen very carefully, okay? I'm gonna go back to my little deck here. We showed you how to download transactions. Now we're gonna show you how to point them. WebConnect, buddy, not CSV, WebConnect, okay? So how to point them. So these transactions, we'll start with the online and then we'll go to the desktop. There is my online edition. Oh, it's over here. So the first thing we're gonna do is I just want you to understand what the theory behind how this is gonna work. What you're supposed to do is you can think of this as like a waiting room, okay? And every day you go into the waiting room and if you're on the online edition it's just gonna have new transactions. If you're on the desktop version you probably are gonna have to download probably just do it once a week. But anyway, once it's in the waiting room what you need to do is clear out the waiting room, okay? You need to get rid of all these things. Now there are three ways that you can get rid of them. One of them is you can simply add them, okay? So we'll do one where we just add it, okay? This $120. This was a fee that I had to pay QuickBooks for something, all right? So what you never wanna do, never is you never wanna click the add button before you've made sure that it's pointed correctly. And you can't tell whether it's pointed correctly until you click on it and it opens up something called the system tray. And this system tray will tell you what the name of the vendor is, payroll service. See it guests, salaries and wages, it's wrong. So this is really payroll service fee. Well, I'll just put it to bank charges, okay? If you understand how to use QuickBooks you know that you use classes for to break out your expenses by function program admin or fundraising. I'm gonna go to admin for this. And if you wanna use QuickBooks to track grants this is where you would point it to a grant, okay? So I'm gonna go ahead and click one of the grants here. You can if you want add an attachment of a literal receipt if you would like to. And then when I'm done I'm gonna click add. But before I click add I just want you to see we're on the blue one, there's 27 transactions I'm about to add one of them, okay? And actually you know what? I think I'm gonna go to the bank account too just to kind of really hammer home the point of what's happening here. I'm gonna open up a second instance of QuickBooks and I'm gonna go to the chart of accounts list. Let's go to the chart of accounts list. And right now we are adding transactions for the Bain bank account 2725. If you look at the chart of accounts it says there is this bank balance that's the column this is the transactions as they exist at the bank. This is the column that tells you what's in actual QuickBooks. That's why it says QuickBooks balance. So right now there's $176,700 and 44 cents. And there are 27 transactions that I need to add. So I'm gonna add this one for $120. I'm gonna click add. Now instead of 27 transactions there's 26 transactions. And if I go back to my register and refresh the screen instead of it being 176,700 now it's 176,580. So does that make sense to y'all? Does that make sense? So that's how to add. Now somebody already asked a really good question what if I wanna split it, okay? This was my payroll right here. I'm gonna open up this and let's say I need to split it. There's a big split button right here. I'm gonna click split and this is where I can split it. So I'll put salaries and wages. I'll put a part of it to one class and I'll put a different part of it to another class. I'll put this part, this is salaries for the guidance center. This is admin salaries. This is paid for out of a grant. This is not, okay? And I can add other fields if I want to. So I'll say 5,000 of it just to make it easy here is going to the human is going to the guidance center and the rest of it 43, 43, 10 is admin. So now I'm gonna add that. So I'll click and before I do that, 176, 580, apply and accept. So now it's asking us, do you wanna create a rule? Do you want to use the same category for all expenses from QuickBooks? We definitely don't. I don't like telling QuickBooks to create a rule on its own. I wanna create rules and I'll show you how to do that in a second. So I'm just gonna click no here, okay? But now there's only 25 transactions, okay? And if I go back over here, this is 176, 580, I'm gonna refresh and now it's 167, 237. So it's gone down. Now, what if after I added something, I decided that I didn't want to add it the way that I did. I wanna undo it and redo it again. You see this field that says categorized when I click on it, it shows me everything I added and I can if I want to undo, I'll undo that 120 and now it's it back at 26, I go back to 26 and then my 120 is back where it was waiting to be added again, all right? So that is the online edition and that's how you add, okay? Now I'm gonna show you how to add in the desktop version. It's pretty simple. You tell me, how do you think that you would add? Well, you could push this add, should you push this add before you've checked where it's going? What do you think? Yes or no? Absolutely not. What do you think I would do to click this to open it up so that I can see more of it? Anyone know how to open it up so I can see where it's being pointed? So you would think you could just click on it, but you can't. So if you go over here to the right, add more details, add more details. So I'm gonna click add more details and here's where I can say where it's going to. I can say who it is that got this. I can say what expense account to point it to point it to telephone, right here. If it's paid for out of a grant, I can put it there. I can have it go to a particular class, okay? You see add line here. Yes, Kathy, add line and you can split it. Isn't that kind of cool, Kathy? How you can ask a question even though there's like 180 people in here I can give you, isn't that neat? So anyway, I'm gonna save it and add it to the register but before I do that, just like I did in the online edition there's 337 transactions that I got to enter, okay? And let's go into the, it won't even let me go in there, darn it. Well, there's 337, I'm gonna go ahead and save and it'll add it and now there's 336. You see where it says added to register right there? We'll click it and there it is. Can I undo it? No, I can't. Okay, so that's one difference between the online and the desktop version. Now the next question people always ask is what happens if the transaction's already in there? Can I match it so that I don't add it again? Jazz. I don't know, all of you all weren't here but at the very beginning of the session I asked what do you want, steak, chicken or fish? And here we are 45 minutes in and Jazz says steak. So I think I love you, Jazz. All right, so anyway, don't worry, we only got 20 minutes more and we're done. So what I'm gonna do to kind of show you this, I'm gonna take this one for 120 and I'm gonna add it manually because conceivably it would have already been entered and then you would wanna match it but it's not entered so I need to add it. So I'm gonna go to plus new and I'm gonna add it as an expense and what was it, it was 10, 12. So I'm just kind of doing this so you can see how it'll match stuff, all right? So this was 10, six, we'll say it doesn't have to be the exact same date. And we'll just leave that blank and we'll say it was $120 and we'll point it to admin and we'll point it to a grant. All right, so I'm gonna go ahead and save this and then I'm gonna go back over here and now the 120, can we match it? Well, it's gonna try and find a match. I'm gonna refresh the screen. Well, let's see if it finds a match. Look at that, one match found. Isn't that kind of cool? So when I click match, it's not gonna add it again. It's simply going to attach the downloaded information to the transaction that's already in QuickBooks, okay? So I'm gonna go ahead and click match. And so there was 26, I'm gonna click match. Now there's only 25. When I go here, I'm gonna refresh this screen. I'm just gonna refresh the screen and I'm gonna show you what this $120 transaction that we entered manually looks like. I gotta go back to it, here it is. Now when I look at the transaction, you see this little thing right there? It wasn't there before. This tells us that this was entered manually and then the bank matched it, okay? It even tells us, okay, it was manually matched. Of course, I can unmatch it if I don't want it to be unmatched, okay? So if you have a payable, Brookfield wanted to know, so I'm gonna unmatch this. Let's do a bill for $120 and see if we can match that $120 to a bill. Well, actually let's pick a different one. Let's pick, we'll pick this through, we'll pick this 187.50. So this is capital web group on 10.11. So I'm gonna do a bill. And this is for those of you that enter bills and I'm gonna do a bill for $187.50 and let's see, $187.50 and let's see, I'm gonna save it and let's see if it recognizes it. Where's that $187.50? There it is, I'm gonna refresh it. Sometimes it recognizes it, sometimes it doesn't, but let's see if it thought that perhaps this payment went with this bill. Let's see, doesn't look like it at this point, but of course it thinks that the name of the vendor is capital two. So I'm gonna get rid of that vendor name and then let's see if perhaps it does a little bit better. Now, it's still sitting here. Is there a way that I can get rid of the name? The memo says capital group. So it may not recognize it because it's looking for something that says capital group. Yeah, that's just the description field. It should work, but maybe it's not. Let's see if we pick find match. Look at that, it found it. So that's the other thing you can do. You can pick find match and then it'll match it, okay? The only other thing that I wanted to tell you about matching has to do with deposit. So in answer to your question, yes, you can match a payment to a bill, okay? Deposits, how many of you use sales receipts? And that's the screen right here, sales receipts. And I'm gonna go back to the desktop in a second, but how many of you use sales receipts here? Yeah, they're called donor receipts in the desktop version, yes. So if you use these or you use invoices, does anybody use invoices? Anybody use invoices? So I wanna show you something. When it comes to sales receipts or invoices, you can match deposits to those as well. Let me show you. You see this $4,615 deposit? Do you see the number six right here? Anybody know what this number six means right there? Here, I'll zoom in to make it bigger. Anybody can guess why there's a six here? This all came down from the bank. This dollar amount, the whole transaction, we're just in the waiting room. What's the six mean? It means that it brought the images down as well. So I can actually click on this. This is so cool. Wells Fargo does this. I can make the picture bigger. And then I can see there are one, two, three, four, five transactions, and each one is showing. If I go to the next transaction, it would be, there'll be a check. Where's the other ones? That's that. That's that. Oh, next image. There it is. So there's a check, there's a check, there's a check. So this is really kind of cool to see what makes up the deposit and it's right in the bank feed. So what you can do is, I'm gonna click on this one to open it up. And then I'm gonna click find match. And then all of my sales receipts and all of my payments and all of my invoices will be there and I can pick and choose which ones total up this amount, all right? Which is amazing. So then I'm gonna click save. So what this does is it basically means you don't have to record a deposit. It'll record the deposit for you and match it to the sales receipts. Yeah, isn't that nice? And the invoices, so I'll save that one and now we're at 25, okay? Now in the desktop version, the matching is gonna work the same way. In fact, it already recognized one. There was a transaction in here for $51.01. I'll actually show you that I have it in here. Where is the find? Edit, find. Amount, 51.01, there it is. So here's a transaction that I entered. This was for a credit card. Here's a transaction right here, all right? And it noticed it, it matched it. It was like, wow, I see that, it's matched. So when I click confirm, that's gonna simply take it out of here, 336. And now we're at 335, okay? And I'll go back to here. It's interesting, I wonder if I close this and reopen it, I wonder if when I look for it, it'll have some sort of an attachment now. Let's see if it does. It doesn't look like it. I don't see anything here, okay? Will it match batches of checks that are deposited remotely? Yeah, that's what I just did. It'll allow you to pick multiple ones. That's what I just did in the online transactions, okay? So I wanna answer questions because we only have like 10 minutes left, but there's one more thing I need to teach you and that's the rules. So let me just show you about the rules. I'll do it in the desktop first and then I'll do it in the online. Rules helps automate this to where you don't have to fix where they think things are going to be pointed. So first thing I'm gonna do is I'm gonna highlight this downloaded as or I'm gonna click it so it's in order. So all the stuff that's together, like you see this roasters, I go to roasters all the time. So what I'm gonna do is I'm gonna create a rule. Yeah, you're right, Francis. Not all banks are gonna give you the images, but Wells Fargo does and I think Bank of America does too. But anyway, watch this rather than clicking on each roasters every time I go to roasters, I put it to meals. So I'm just gonna create a rule. So I'm gonna click rules, add rule, and then I'm gonna call the rule roasters. That's just the name of the rule. Description, if the description begins with contains, I'm gonna put contains. And then what they're referring to is this description right here. You see this, this right here, this is a description that came down from the bank. So anytime the word roasters is in it, then I'm gonna want it to recognize it, roasters. There's no apostrophe. And then I can tell it, make the payee, whatever I want the payee to be. Maybe I just have a generic payee called restaurants because I don't want each restaurant adding to my vendor list. I'll just make it this instead. And then I'm gonna point it to, well, I'm gonna point it to office supplies, even though it's a meal, that way I can hide the fact that I'm using the company credit card to buy my meals. I bet you didn't think you'd get that kind of help here. And then this is where you can point it to a grant and a class. So this is basically a rule now, okay? So anytime it sees roasters, I'm gonna go ahead and save it, it's now going to recognize it. So I'm gonna go back over here to where roasters is. And now if you go to recognized, all of the roasters are here, you see? So, and I can still click on them to make sure that they are pointed correctly, but the rule is there. If there's an exception, Sherry, that's why you wanna check and change it. So maybe for one of them, it's different. But I'm gonna say all of these are good and I can add them all at the same time. I'm gonna click add. And then now they've all been added based on the rules, okay? Same, the rules are even better in the online edition. Look at the rules in the online edition. Let me show you, this is the coolest thing. I'm gonna go to the Amex for this and then we'll finish. I'm gonna sort by description. I think that's how you need to go through the list anyway, short it by description because that kind of gets you the same stuff usually in the same place. So here's three roasters here, so we'll do that. So I'm gonna go up to the rules, which is right here, rules and go to rules. These rules are cooler and you'll see why in a second. Roasters, money out, description contains roasters and the expense account. I wanted it to be office supplies. Let me see if it just lets me type. Oh, the transaction, this is a transaction type. It's an expense because it's a credit card. So I would put it to an expense. That's the type of transaction. And then this is going to office supplies and here's the payee and this is the customer. So I'm creating the rules. So far it looks very similar, but look at this. You see a sign more, here's where you can put the class. So I'll put the class, but let's see, there should be. One thing I wanna make sure that you don't do is you see where this says automatically confirmed transactions always make this turned off. If this is turned on, that thing that I told you where it automatically goes into the waiting room, but it doesn't go into QuickBooks, if this is on it will automatically go into QuickBooks. And I think that's crazy, particularly if you have some exceptions. So there should be another field here where I can also add splits. There it is right there, add a split. So this is something that you can't do in the online edition, but you can do with your rules in the desktop. So I'm gonna say make 49% of it go to fundraising and make 51% of it still go to office supplies but put it to perhaps a different program and you can keep adding splits if you want. So I'm gonna go ahead and click save, all right? And now when we go back to the transactions, we'll go back to where those are, then there should be rules now, yep, see? So now these have rules, I'll open them up, click edit the split and we can see it did the math for me, 994 and 1035 versus the next one, which was edit, which was 1049 and 1092. So I'm gonna go ahead and just check off all three of those and I'm gonna click accept and it takes them right out, all right? So it will memorize the customer's name as well. I just didn't put it in there, all right? So a couple of quick things and then we'll do questions, but in general, the goal is connect it, I want you to try it today. I want you to connect it today, you do not have to add things to your books and as a matter of fact, just to kind of make you feel a little bit better, what I can do is I can check all of these and I can exclude and it removes them all from the waiting room. So if it freaks you out, you can remove them all from the waiting room just as quickly as you added them, it won't mess up your books, all right? Okay, so if you need more training, we have our three-day webinar series coming up, if you haven't taken it, it's fun. It's two and a half hours a day, three days. This is the ones for the desktop, this is the one for the online and it gives you, when you click on it, this is all the information on it, all the different things we're gonna be covering and the code is, let me show you where the code is. Here's the code right here. It's TS40 off. So we've got five minutes left and I want to answer questions. So let's see. Terry said, in QuickBooks Online, how do you add a credit card? Well, it's very easy. If it's Amex or then you just, well, I'll just link account here. So if it's, I assume like a Visa or a Mastercard, you pick the bank that it's connected to and you go through the exact same features that I did here, nothing different, okay? So Terry, there's nothing unusual. Do you have a question about it? Kathy, can receipts be uploaded to the desktop? I think that I missed it. Yes, they can. When you are in a transaction in the desktop, can you add a receipt? So if you notice, let me see if I click Add More Details, it doesn't let you add the receipt when you're in the middle of entering the transaction, but once the transaction is entered, then you can add the receipt. And there's actually, I'm gonna go ahead and click here, you see this little attach file? Here's where you can attach a receipt. And actually there's an app that you can get on your phone where you can take a picture of the receipts and then you can upload them. And there's a whole receipt link where you can add them. I don't have this turned on here, but there's a whole feature for that. But the shorter answer is yes, you can do it. What if credit card is not connected to the bank? What credit card is not connected to a bank, Aretha? American Express. You just pick American Express. That is your bank. So if it's not and you go to add an account, doesn't matter whether you're in desktop or online, you just type American Express. Oh, okay, cool. Okay, and they ask this their own bank. Let's see, Ken, I'm trying to see. Do we have to refresh linking banks and credit cards in the online aversion? Shiland, no, you don't. It happens automatically. Karen has a really long question. Been using sales receipts, put it to undeposited funds. When I have a batch of checks, then I do a deposit. The deposit is as it was, sales is as it was. What you're doing, Karen, is fine. The batch is, then I do a deposit. Each deposit has your checks, sales is as it was. Yeah, no, that's perfect. Karen, you're doing everything right. Let's see, who else? I think that's it. Let me look at the bottom here and see. Can you go over how to properly add transfers from the waiting room? Transfers are a pain in the butt. What this means is this is when you're transferring money from one account to another account, all right? Maybe you're transferring money from the savings to the checking or from the checking to the savings. I think I had one here, if I'm not mistaken. Did I? Let me see, this is over here. I thought I had one of these in here. Let's see. Let's see it here. There it is. Here's a transfer. So basically, if you click on this, you want to open it up. And basically, what this means is you are in the Wells Fargo savings account. So this transfer, you pick the other bank account that it transferred from. So let's say it transferred to the savings, and then you click add. Now, presumably that same transaction will appear in the download from the savings account. And it'll connect it. It'll say that's been paired with another transaction. And then you just confirm the pair. Now, one thing about these transfers, a lot of times you'll go in here and it'll say record transfer when it's not really a transfer. This happens because the smart computer, the AI, reads the word transfer in the description, whereas it's not really a transfer. It's not going from one bank account to another. The word transfer is just in here, okay? So in that case, you click on it and click categorize and change it from a transfer to a transaction, and then you entered it, okay? Is there a resource to help me set up and manage PayPal correctly in QBO? That's something, PayPal is a bank account like any other account. So you would handle it the same exact way as any other bank accounts that you have. I talk about it in the three-day series. We updated our QuickBooks desktop to 2023 when we download transactions, it's saved in a new bank account. Yes, you can merge the two bank accounts for Amina and then it'll merge them together, okay? Barbara is saying, there's a question here. Is QBO app usable for any QBO level, simple start? Are you saying Barbara, can you come on the line and tell me, are they talking about, what's a QBO app? Do you think they're just talking about downloading transactions? I think she's asking the app that you can take pictures. Oh, so I don't know the answer to that question. I didn't either. But if you go to QBO app for receipts, I need to go to the app store. This is a little automation. I don't know what it works for, but I think if you Google it, you'll be able to, I would teach it, but I don't have the time right now. I don't know if it works with essentials. So I don't know if it works with simple start or essentials, but to be completely honest with you, you really need to have QuickBooks Plus or QuickBooks Advanced anyway, okay? Any special thing about when you use a Venmo account? Not really, a Venmo account should be the same as a PayPal account, it should be a separate bank account. Can you please show us how to merge two bank accounts? So you merge the same way you merge any accounts. You change the name of one to the name of the other. So let's say I wanna merge these two. Now it may give me an issue because they're both connected to the bank, but let's try it. So I'm gonna change the name of this checking account to this checking account. I'll do these two and see if it takes the merge. I'm gonna go ahead and edit this one. Well, actually I'm gonna edit this one. I'm gonna copy the name, control C, because it's gotta have the exact same name in order for it to merge. And then I'm gonna edit and I'm gonna change the name here, control V. I'm gonna get rid of the account number and then I'm gonna see what happens if I try and merge it. It says it'll merge, I click merge, I click save. We cannot merge two accounts that are both set up for online banking or web connect. So you'll need to disconnect it first, merge and then reconnect it, okay? To do that, we'll go to where our bank accounts are, are where the download it is. We're basically going into the waiting room. Do you see this little tiny, well, let me zoom in here. You see this little tiny pencil right here? So if we click on this, edit sign in info, edit account info, let's edit the account info. You see where it says disconnect this account? I'll check the box, it disconnects it. You may have to do that anyway periodically when the connection becomes distorted or frayed and it gives you issues, you may have to disconnect and reconnect, all right? So obviously we have a lot more questions that we could answer. We are four minutes over. How are y'all feeling about downloading? Is this something that you feel a little bit more comfortable trying? What do y'all think? We feeling good? Now one thing, and Barbara, do you wanna make the point? I'll let you make the point because Barbara has very strong feelings about relying on downloading transactions instead of entering things manually, okay? So tell me, Barbara, when do you think they should enter it manually and match it versus just relying on the download? What are your thoughts? Well, for me, the problem with waiting for the things to come into the holding tank is that you're basically doing bank balance accounting. And so if you have large checks that you've written and they haven't cleared, you might think you have more money in the bank than you really have if you haven't recorded the check, right? Or in the case, like I work with a lot of houses of worship, as Greg mentioned. And so if you have a big deposit, let's say it was a lot of cash and you don't ever put that deposit in and somebody takes the cash and doesn't ever go to the bank, you're never gonna know that, right? Because you don't have any check and balance with that. So I like to stay ahead of the download personally and then do lots of matches. Like everything that comes into the holding tank should be a match and anything that isn't a match, you're like, ooh, why did that happen? But for sure, credit cards, 100%, I would connect those in a heartbeat because there's always somebody on staff that isn't giving you their receipts and it takes you so long to reconcile your credit card statement. So if you haven't started bank downloads, at least start there, it'll save you so much time. I agree, start with the credit card and I will tell you, and this is true for the desktop as well, when you go to reconcile a credit card, what's so amazing is that all of the transactions that are downloaded, they will already be checked. So doing a bank rec or a credit card rec becomes very quick because all the transactions are already checked that came from the download. And this is almost always there. I can do a year's worth of bank recs in like five seconds, literally, okay? All right, is QBO customizable for nonprofit use? Absolutely, that's what we teach in our three day training. All right, Aretha, I'm gonna turn it back over to you. I'm gonna put the little thing up for you to get the coupon $40 off the training because it's coming up. It's a good time to sign up. Yes, and that was awesome. I'm going to my quick books right now because you just taught me something today. Thank you so much. Just a reminder, this is recorded. I'm gonna plan to send this to you by tomorrow. So look for that coupon, the slides and the video recording by tomorrow. Thank you, Greg. Everybody have a great day, bye-bye. All right, thank you, bye-bye.