 QuickBooks Online 2022. Bank Reconciliation Month 1 Overview. Get ready because it's go time with QuickBooks Online 2022. Here we are in our gig-grade guitar practice fire. We set up with a 30-day free trial, holding down control, scrolling up a bit to get to the 1-2-5 percent. Currently in the home page, otherwise known as the Get Things Done. Accounting View. If you wanted to change to the Accounting View, it's something you can do by going to the cog up top and switch to the 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. We're going to be opening a few tabs up top by going to the tab up top, right-clicking on it, duplicating that tab, back to the tab to the left, right-clicking on it again, duplicating it again. As that is thinking, let's jump on over to the sample company to note where the reports are located in the Accounting View, which is simply on the left-hand side in the Reports area. Back on over to the Business View, second tab reports in the Business Overviews section and then in the Reports on the left-hand side. We're going to close up the Hamburg Sheet Report, the big, balanced sheet scrolling up top. We want to keep this range changed from January or 010122 to 013122 and then go to the Report to the right tab to the right and we're going to go into the Business Overview, check out the Reports and then close the Hamburg Err going to the Profit and Loss, the P&L, the Income Statement and we got once again the range for January the month of January. We're focused in on here. Let's go back to the first tab. We are of course looking into the balance as the cash account. We want to go through the bank reconciliation process which will be reconciling the difference between the cash account on our books, in this case for January 31st, 2022, to that on the bank statement for the same date. This will be the first bank reconciliation. We'll take a look at two which is going to be having its own kind of problems oftentimes that we want to look at after you do the first bank reconciliation. Usually then things will be a little bit easier for the following reconciliation. What we will be doing if we go on to our bank statement, here is our bank statement, mock bank statement. We've got the summary up top for what has happened, beginning balance, additions and then the subtractions. Here is our ending balance which we would think would tie out to what is on our books here. It does not of course due to the fact that there are outstanding checks and deposits and possibly some things that we have not recorded on our books that actually took place and they are on the bank statements, things that we will have to make adjustments for. Then we of course have the detail on the bank statement for the actual deposits giving us the date and the amount and we've got the checks giving us the date and possibly the check and the amount as well. If there were electronic transfers then we'd have the date and the check items. We'll get into those items in a bit more detail but the general idea is that we're going to be ticking and tying off from the bank statement and the books. So if I go back on over we can start the reconciliation process by going to the first tab. I'm going to hold control, get down to the 1, 2, 5% going to go to the bookkeeping area. If you were in the accounting view it would be in the accounting area and then the reconcile tab. And here it's going to be in the bookkeeping area reconcile tab. Closing the hamburger it says match the books to the bank. Connect accounts for easier reconcile. We'll talk about bank feeds in the bank feeds section. We'll do some bank reconciliation using bank feeds as well in that section. We're not going to turn on the bank feeds here at this point. Keep yourself on track, find the holes in your accounting get things tidy for a tax time. We're going to go ahead and say get started here. So let's get started. So it says reconcile like a pro, get your books in bank to agree with each other. I'm going to say maybe later here because I think they're trying to get me to connect to the bank feeds again. We know it takes time to get used to the new stuff. Watch the start or reconcile guide walk through the news thing here. So I'm going to close this fact out and then here we have a reconciliation process. So which accounts you want to reconcile? It's going to be typically the cash accounts, the checking accounts are the ones we're going to reconcile. And then we've got the add the following information. Now note that the beginning balance is already in place here because that was the beginning balance that we put in the system. And when we first set up our accounts we put that beginning balance in because we were imagining that that's the balance that we got from our prior accounting system. And this is often a problem with the beginning balances. So in other words it could be the case that we have a prior accounting system we're trying to then take the data from it put it into our system not by putting all the prior period data in but by starting the cutoff as of this point in time entering the beginning balances and at this point in time which would include the beginning balance for cash. That would mean we'd have to put whatever's on the trial balance whatever's on the balance sheet for the starting point in our case January 1st, 2022 the cash amount from the prior accounting system which for us was 25,000. However that 25,000 doesn't match what is on the bank statement which says 30,000 up here. And the reason that's most likely could happen or could happen if you're switching accounting systems is because the amount on our books as of the beginning balance had outstanding checks and deposits. So it didn't tie out exactly to what's on the books for the bank as of that point in time. So if we were doing bank reconciliations prior to that point then we can take a look at the prior bank reconciliations and we can determine outstanding amounts and basically we can deal with those and put those into place but for now I just want to recognize that. That's going to be a problem with the beginning balance. My beginning balance doesn't actually tie out because I had to put the beginning balance on our books to tie out to make the beginning balance correct for the beginning balances from my prior bookkeeping which isn't matching what's on the bank statement. So we'll take a look at how to fix that basically as we go through the bank reconciliation process and we just want to note it and reconcile or check it or note it now. And then we're going to put the ending balance in place which is going to be the 61-24185. So let's say that so it's going to be 6161-241.85 and the date of the ending balance is going to be the end of January in our case. So enter the service charge or interest earned. Now these are areas where you could basically put common kind of differences and enter them at this point. So the idea of the bank reconciliation is if it's on the bank statement and not on our books we're going to have to add it to our books unless the bank is incorrect. However the bank is usually correct so if it's on the bank and it's not on our books we'll have to add it. If it's on our books and it's not on the bank it might be an outstanding check or deposit which is still okay that's going to be one of the reconciling items. The common items that are on the bank but not on our books would be interest earned and fees that the bank charged because we didn't know about them until we got the bank statement which we could add as we go here. Now I don't like doing that because I would rather basically just add it when I'm doing the bank reconciliation process so I typically don't use these items and if there's any differences then I'll add them basically as we go. So I'm going to go ahead and skip that and start the bank reconciliation. Okay so let's just see what we have here in terms of the layout of their bank reconciliation process. We've got up top the statement ending balance. This is the balance on the statement here. So if I see my ending balance on the bank statement that's going to be the 61 241 85 and remember I'm going to take everything off on the statement. So if I had the same beginning balance which I don't have right now it's off by that 5000 because it's the first bank wreck but if we did have the same beginning balance and I take everything off then we would have a cleared balance in our system which would match this ending balance and that's the process of reconciling. So this is my starting, that's my statement balance. Here's my cleared balance which includes the beginning balance which is off by that 5000 so that's going to be a problem we're going to have to deal with and then we've got everything that we're going to take off. So if I take off deposits and it checks increases and decreases these are the items that are going to be ticked off then on down below. The difference between these two up top is going to represent our difference on the right hand side. So in other words if I take this 61 61 241.85 minus the 78000 in this case which represents the beginning balance minus the payments plus the deposits for the cleared items that I checked off down below just randomly that's going to give us our 16 758 15 difference. So our goal here is to tick everything off and if this beginning balance was correct and I tick everything off that is on the bank statement which would include this number and this number then I would basically accumulate these two numbers right in here and these two numbers the ending balance has to reconcile and that's what you really want to get in your head when you do the bank reconciliation it has to work and hopefully we'll convince you of that as we go through that so that you have confidence that that if something's not right you can go back in there and you could basically figure out what the difference is. Now note that you might get to a point where you're saying okay the difference is down to like $5 here and maybe I'm going to force it to reconcile once it's down to $5 I'll just enter the difference because I'm pretty close that's pretty close but you don't typically want to do that because a difference of $5 on this difference may mean that your ending cash balance is pretty close right so if you just enter an adjustment for it not a big deal with regards to ending cash possibly because you're tying out to what's in the actual bank but that difference could be a result of large or a lot of transactions meaning you could have 10 deposits and 20 checks that were not entered for example that happened to end up to summing up to a $5 difference so anything other than zero on this difference column gives you a much lower confidence about basically the transactions the reconciling items which gives you a much lower confidence not just about like the ending balance and cash but all the transactions that are impacting the rest of the financial accounting so you want to get this down to zero and it should be really possible to do given the fact that it has to work meaning if you're taking time off exactly what is on the bank statement then the ending balance has to basically clear out it should be a pretty easy process to do okay I'm going to uncheck these off if you go to the edit info up top that takes us to the info that we had previous input our beginning balance so if we enter the wrong ending balance for example we can adjust that here and I'm going to close this back out then we've got the save for later so you can basically enter this information and then save it and go get a cup of coffee or something as you end it go have lunch or whatever and then finish it later and then you can save for later you can finish it now if you did that while you didn't have this at zero it might give you an error message and then it would possibly you could tell it to force an adjusting entry so it would then make an adjusting entry for the difference which again you don't really want to do you shouldn't have to do that generally I'm going to then you got this little closing button so expand it so I'm going to close this up so you get a little bit smaller of a window and you can see more of the transactions down below as you're still zoomed in you've got your transactions down below these are going to be the transactions that you're ticking and tying of course to the bank statement and you're just going to check them off as you go so here's the 60,000 for example on the bank statement or the 65 we're going to check that off right here and that's going to add up top and we're going to basically take and tie everything off that way then you've got your filters on this side which you don't use that much because you got your kind of filters on this side which is pretty much all you need usually but let's take a look at the filter drop down you've got a search button up top which could be useful you've got the cleared cleared status so if for example I had this one item checked off and I wanted to filter if I had a long bank reconciliation and I want to filter by cleared items and apply that then I'm going to see just the cleared items or of course I might want to filter by the unclear items and then I can see the items that have not yet been cleared so that could be useful it's not something I use often I don't think it's going to help you too much on an average size bank reconciliation but possibly for a very long one transaction type not usually something that you're going to be filtering with in here but possibly you got the payee that you can filter by again might be useful in some instances if you're looking at a bank statement you know who the payee is and you're trying to find something typically not the most useful thing though and then you've got the statement date so the ending date right here is the default date on the ending date now that means that this happens to be as of the end the cutoff date is January 31st so if I scroll down there's no transactions after January 31st and that should make sense we shouldn't need in other words we entered data in February I shouldn't need to see the February data in January because if I entered it into my system before the bank knew about it there shouldn't be anything I entered in after the cutoff date in this case January 31st that cleared the bank it's possible to go the other way it's possible for us to have entered something at the end of the month for example that has not yet cleared the bank the bank didn't know about it but it shouldn't be possible for us to enter something into our books on our side after the cutoff date and then the bank cleared it you know within the cutoff date right that shouldn't happen so that's going to be the standard filter that will be put in place but you could hit the drop down you could say well I want to see all the data so we could say everything and that'll pull in for us January and then we got February down below also note that these filters are on the right hand side so you can clear the filters this way clearing the filters I'm going to go back in and say and switch it back statement ending date so now we've got everything through the end of January now the filters that you're probably going to use most commonly and we'll take a look at these filters in more detail when we do the reconciliation are the payments these are going to be the outflows so now I can focus just in on the outflows which is quite useful comparing that to the bank statement just looking at the outflows on this side or switching on over to the deposits which would be the increases and I can then compare that to the increases on this side so that is a useful tool for the bank rex you can also sort by the date and by type and so on normally you're going to be sorting by date note that when you're comparing to the bank statement the dates are not going to be perfectly lined up because if we're doing a full service accounting system especially if we have checks that we're dealing with we're going to often be entering items in our books earlier possibly quite a bit earlier then they're going to hit the bank so we can't really depend on the date although we can depend on it more for electronic transfers and possibly and most likely deposits as well so that's going to be that and then if we go to the right we've got our printing option and we've got the cog on the right hand side so we've got the columns that are being shown the type the reference the account the payee the memo the bank status now these you might like remove some of these if you want to get a little bit closer like you might be saying maybe I don't need the memo or the type or the account and I just want to have the amount and the date right and have this close as close as possible so you have a less cluttered field that you'll be working with because possibly these items aren't helping you to enter the data but I'm going to keep them all on for our practice problem and the display I'm going to keep on as regular down below see if I can scroll down I'm going to keep it as compact that's going to keep it as compact you can experiment with those if you would like to change those items and toggle them around as well so that's going to be the general layout that we will do next time we'll get right into it we'll start taking and tying off the deposits