 QuickBooks Online 2022, setting up bank feeds. Get ready because it's go time with QuickBooks Online 2022. Here we are in our bank feed practice file. We set up with a 30-day free trial. Holding down control, scrolling up a bit to get to the 1, 2, 5% we're currently in the home page otherwise known as the Get Things Done page. In the business view as compared to the accounting view if you want to change to the accounting view it's something you can do by going to the cog up top switch to accounting view down below. We will be toggling back and forth between the two views either here or by jumping over to the sample company file currently in the accounting view. Back to the bank feed practice file. We're going to be looking into setting up the bank feed so there's a couple ways that you can't do it. Note you might think that the first thing you would do is go into the banking section in this business view here but this is where they have some other stuff mainly looking at that are related to the bank including meet your money goals, pay and get paid your way and so on and so forth some of which would be added on type of features like up-selling, some kind of things within QuickBooks which would be related to the banking. So we're going to go down to here you could go down to the bookkeeping area and set up the bank feeds by going to the transactions up top and then go into your banking section and then down below you've got to connect the account that's one way you can do it another way you might think about it is to say let's go into the chart of accounts and then possibly add a new account which would be an account that typically has the type related to a bank feed so that would be a checking type of account or a credit card type of account because those are the types of accounts that typically have financial institutions related to them so if you were to make a new account you would make sure to set them up as an account that has a financial statement related to it like a type of account which would be the cash account or the credit card account now as you do that I would not be in the account the business view but rather the accounting view because it's a little bit easier to add accounts in that way on the accounting view now if you were in the accounting view you could then go down to the same areas would be in in other words the banking section on the left-hand side that's where you'd be actually looking into your bank transactions in the banking information up top in the sample company the account has already been set up so you've got some bank fee transactions that are in place we haven't set them up so they're not in place at this point in time or you could go down to your accounting tab below where you would then have your chart of accounts and you could possibly set up a chart of accounts this being the type of account that would typically be linked to the bank feed so you might set up the account first so we're going to go back on over to this side open up the left-hand side on the hamburger let's go to the transactions up top now we're not going to actually fully connect this time we're just going to give an example of how to connect this time usually the connection itself is actually the easiest component of the bank feeds process connecting the account could take a little bit of work in terms of the financial institution a little bit different from institution to institution but the actual connection is usually not that difficult to set up what you want to consider with the connection is how much data do I want to be pulling in do I want to be pulling in say one month worth of data one year's worth of data what's my cutoff do I already have data in the system so that you can make sure that you got the right cutoff to get the amount of transactions that you want to be pulling in from the bank feeds there are in essence two ways that you can set up bank feeds or get information from the bank that's going to go into your accounting system one is to connect directly to the bank which is a little bit easier typically but you might not be able to go as far back in time and the second is to go into your financial institution download the financial transactions and then upload them into QuickBooks which is an option that might be useful especially for the first time that you're setting up the bank feeds because you may not be able to go as far back in time if you need like a whole year's worth of data or multiple years worth of data then it might be easier you might be able to get more of that data from the financial institution directly so those are the things to keep in mind we have the connect account or upload transactions here so the connecting to the account obviously would be the physical connection that would allow us to connect and pull the information let's take a look at the upload transactions first just to consider it it says here manually upload your transactions open a new tab and sign in to your online bank account export your bank statement in .csv.qfx or .qbo.ofx or txt format now these are common types of formats possibly not common types but for uploading their common types of format normally the easiest one would possibly be a .qbo that's not a qbo data file QuickBooks Online in other words but rather it's a data file very common in most financial institutions now if you don't have that one then often times you'll be using a .csv which is kind of like an Excel document stripped of all the Excel formatting within it so you can use those basically to upload your bank statement here so number three upload your bank statement drag and drop or select files and then on the right hand side bring in transactions automatically this is where you have your linking of the accounts to save time on entering bank transactions this is trying to get you back into that automatic link process instead of using the upload manual upload process let's close this back out and then go into the tab to the left which is the connecting to the bank which would be the direct connect to the bank so linking to your bank account would go through this process now note the accounts down below they have some common financial institutions these would be financial institutions we would have our banking with or possibly our credit card as well that we can do our connection with you can also then show more down below here and we can basically also just type in the financials institutions so bank, something and you can have a whole bunch of other banks a lot of different banks the number of banks that they're being able to pull in even banks that aren't the most the largest banks are still in here so they're getting a pretty large bank of banks in their system a big bank of financial institutions credit cards also like American Express American Express you can connect the credit cards we'll talk more about the credit cards as well I think it's easiest to think first about transactions related to the checking accounts once we have that down we'll go on to the credit card types of transactions and you also have some accounts like a PayPal account which is really really nice that they have PayPal because I don't think that the version on the desktop version has the same capabilities for the connection of the PayPal so we might explore that in a little bit more detail as well if your financial institution isn't here then it's likely that you still might be able to use the process of uploading the transactions by going to your financial institutions downloading the QBO typically a QBO file or the CSV the basically Excel spreadsheet file and then uploading them to the system so let's just pick an account let's pick like Bank of America here now here's the sign up process sign into the account Bank of America start by selecting the Bank of America accounts you want to connect with into it the makers of QuickBooks Online Education go to the bank site to sign in and choose which accounts to connect then we'll return you here and bring you to your transactions so you can go to directly to the bank account there's going to be some difference possibly from financial institution to institution as to how much security or what are the different types of security measures you're going to need to connect because you clearly need to have access to the bank data to get access that's the most confusing step which could still differ from financial institution to financial institution however it's usually fairly straightforward once you get the details of it if you have problems with it you may have to contact your financial institution in some instances but usually it goes fairly straightforward so what we're going to do is we're basically going to stop here and then we're going to go we're going to actually enter the data into the system and we'll do that on more of a manual type of basis noting that either basis that you use once the data is in the system then you're in the same kind of limbo area you've got the bank feeds directly from the banks into your system either because you uploaded them or because you downloaded them from the bank then put them into the system either method will get you into the same spot in general having all that information in what I would call bank feed limbo transactions that have been input into the system but for which they have not been approved have not been finalized the last pieces of information such as the account the vendor the customers have not been entered and that's what we would need to do and then we'll get into doing that part of the process so of course then you've got the login information on the right hand side so we're going to basically we're going to stop it here and then in future presentations we'll get into a bit more detail on uploading the data and then working with the data that's in what I would call bank feed limbo just note that as you create the data before we finish this off in your chart of accounts if you did not already have an account set up for that particular checking account it would then of course add an account which would be a cash type of account a checking account type of account which would then be linked to the bank feed data that it would be pulling in the data however would not be in the system yet it's something that we're going to have to approve and pull into the system something that we can further automate in the future with bank feed rules but no matter what kind of system you're in even if you're completely dependent on the bank the first month the first few months possibly you will need to do substantial work to make sure to pull that information in the proper way set up the proper rules to make the automation of the bank feeds better more automated save more time as time passes