 QuickBooks Desktop 2023. Download bank fee transactions from the bank. Let's do it within to it, QuickBooks Desktop 2023. Support accounting instruction by clicking the link below, giving you a free month membership to all of the content on our website broken out by category, further broken out by course. Each course then organized in a logical, reasonable fashion, making it much more easy to find what you need than can be done on a YouTube page. We also include added resources, such as Excel practice problems, PDF files, and more like QuickBooks backup files when applicable. So once again, click the link below for a free month membership to our website and all the content on it. Here we are in QuickBooks Desktop Bank Feed Practice file we set up in a prior presentation. Last time we talked about the different ways that we can get the information from the bank into our system, generally including two ways, one being the actual connection to the bank and downloading directly from the bank to QuickBooks, two being downloading the data file from the bank and then importing that into the QuickBooks system. Either of those two methods once done will basically put us in the same point where we've got the data in the system and we can then use it to construct or verify the data in our accounting system. So we could do that just to recap by going to the banking dropdown, we've got the bank feeds here, you've got set up bank feed or an account and then we've got the import web connect file. So we in our practice problem are gonna download directly from the bank and then we're going to be importing the file. Also note last time we went to the lists drop down chart of accounts. We are gonna be constructing accounts that are gonna be bank type of accounts. Those are the ones that are gonna be connecting to the bank feed. Note and remember that when you're connecting directly to the bank, you wanna make sure that it goes far enough back that you can get the data that you need. So for example, the connection directly to the bank is usually the easiest thing to do but sometimes there's limitations in terms of how far back you can go for the data if you're trying to construct an entire year or multiple years, for example, you wanna make sure it goes far enough back to get the data you need. If it does not, possibly then you could go to the bank directly and try to download the file from the bank and then see if you can get more information or the information you need. That's one reason why you might want to do the download from the bank rather than the direct connection. For the practice problem, it also works well for us here. So that's what we will be doing. So if you go to your financial institution, then in every financial institution is different but typically most of them will have access to data. There's two ways that you get the data. Typically you got your statements over here which are usually gonna give you your data in a bank statement format, typically a PDF or a printout type of format but that's not formatted in such a way that you can upload to QuickBooks as easily as possible. So usually there's some other way that you can download the transactions. So in this, for example, you've got the download account activity here and then this is an example of a webpage of a bank. And then if you go into there, usually you're gonna have something like this. For example, the range that you want the data, the range is gonna be important because for example, if you don't have any data at all thus far, you can just start your QuickBooks when you started your company and that's fine, you can just go forward from there. But if you had prior data in the system, then you wanna make sure that you're not duplicating data so you wanna set up the range to pick up the appropriate range. And again, if you're going way far back into the past, then there might be some restrictions in terms of how much data you can get, how far back you can go. Now usually you're gonna have some formats that you can download the data in. The easiest format to upload to QuickBooks would be the QuickBooks format here. And really you can still think of it as just basically raw data that is coming from the bank that would normally be the same kind of stuff that you would see on a bank statement but formatted in such a way that it's just basically raw data that can be as easily as possible uploaded then into QuickBooks. Now the other thing, option this one has is the Quicken. Don't get those two mixed up. Quicken used to be owned by QuickBooks but then I think it was purchased by somebody else. It's another program so it's not the same thing. So you're not gonna be able to easily upload a Quicken file to the QuickBooks. Make sure you got QuickBooks and not Quicken. And then if you can't get either of those, then you've got like this comma deliminated. And comma deliminated, if you opened it up in like a Word document, again, it's raw data that's broken out by commas but you could open it up in Excel sheet which is probably one of the more common ways to open it. And it will look just like a CVS file. You might hear it called, which is kind of like an Excel sheet without all the formatting involved in it. So this is another kind of raw data format that many accounting softwares will allow you to upload into the system. But QuickBooks desktop for some reason is a little bit picky on that. They want the actual QuickBooks file not the comma deliminated. We might talk about that more in the future. Most banks do have a QuickBooks downloadable item but some do not. And so for example, something like a sometimes PayPal can be a problem. We might talk about PayPal later where you've got this comma deliminated situation and then you'd have to convert it possibly into a QuickBooks type of file in order to upload it. So we might dive into that in a little bit more detail but the easiest file would be just a QuickBooks file. Most financial institutions have that file available. Now just to see what the files would look like if you were to download the file this is the QuickBooks software. We noticed that when we had opened the company file that we had a company file that looked like this. This is the company file. I'm gonna make this a little smaller like that. And then we've got this is the one I downloaded from the bank in a QuickBooks file. So it looks like a QuickBooks icon like this file but it's not the program. This is a data package that has a bunch of data in it. And then I downloaded the comma deliminated one which looks like an Excel file but it's not actually an Excel file if I right click on it. And I say I wanna show the properties of it. Show the properties. You can see it's basically a .csv file. The comma separated values file. So you can open it in Excel but it's gonna have different formatting to it because it's trying to strip away all the Excel stuff in it. If I right click on this one and just take a look at the properties of this one you can see it's a .qbo which leads you to think that it's like a data file but this is actually not the actual data file for your company file is QuickBooks data from the bank which gets a little bit confusing. But anyway, so it's OFX data qbo and notice it says qbo which you might think is an online thing and it is you can do the same thing for online but it's also the data file that you upload to you can upload to the desktop version. Closing that out, notice if I open up this file you wanna kinda get an idea of the raw data that's going into QuickBooks, right? So the raw data that's going into QuickBooks is basically just like this isn't the same data but it's just like the bank statement a mock bank statement has your increases and your decreases deposits and the checks when you look at the data that's coming in from the bank it's gonna have the same thing it's just gonna be an increase or decrease to the checking account it's gonna have a date, the date that cleared not the date that you did the transaction but if you had electronic transactions then again those are the easiest ones typically to use and the dates will be fairly relevant and then you've got bank memo data over here the bank memo data is useful because oftentimes you can use the memo data to create vendors and customers they won't create vendors and customers automatically so you gotta make sure that you're using the data that you have to create the vendors and customers we'll talk more about that when we get back to uploading this but that's the general theme so now that we have this downloaded next time we will upload the data into the system so remember the two ways that you can actually get the banking data in place most of the time you're just gonna set up and you're gonna connect directly to the bank but for a couple different you might have multiple different reasons why you wanna actually just download the data possibly for the first time you're entering the data to get more information or possibly in a practice situation maybe you don't wanna set up the bank feed for whatever reason but would rather just upload the data once we get the data into the system we'll be in basically the same spot meaning our data will be in what I call bank feed limbo it's in the system but not used to create the financial statements or double check our financial statements and then we'll have to start manipulating that data so that it will create the financial statements and so that it will make future transactions future bank feeds more automated each and each month we do this the easier it should be because we should be able to automate more and more of the process so we'll talk more about that next time