 QuickBooks Online 2022 bank reconciliation month number one deposits get ready because it's go time with QuickBooks Online 2022. Here we are in our get great guitars practice file we set up with a 30-day free trial holding down control scrolling up a bit to get to the one to five percent currently in the home page otherwise known as the get things done page. Paired to the 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 switching to the account view on down below we will be talking back and forth between the two views either here or by jumping over to the sample company file currently and the accounting view going back to the get great guitars opening up a few tabs we can put reports in by going to the tab up top right clicking on it and duplicating it back to the tab to the left one more time right clicking and duplicating as that is thinking going to jump back on over to the sample company file to locate where the reports are at in the accounting view happens to be on the left hand side under this set of letters that spell out reports and then we're going to go back on over to the business view see where the reports are at they're under the business overview and then reports and we'll close up the hamburger opening up the balance sheet you'll be surprised to note balance sheet this time just to change things up so this is going to go from January 1st to January 31st 2022 I'm gonna run it and scrolling down we're looking at that cash account once again and we'll go tab to the right and open up the business overview this time we want the income statement closing up the hamburger and going into the profit and loss profit and loss range the month of January up top there we have it let's go back to the balance sheet we're focusing in on the cash account we're doing the bank reconciliation for the first month the first month often having some unique problems especially with the beginning balance we talked about last time and we're going to then be comparing the detail the detail in essence in here that's in if I drill down to the transaction detail when we go to the reconciling section the reconciling widget down below so this is we're basically going to take and tie out this detail to the bank statement giving us that verification that everything those transactions are properly entered that verification provided by the reconciliation so let's go to the first tab here and we're going to go back down to our reconciling which was under bookkeeping if you were in the other view the accounting view it would be under accounting and so right it would be under accounting down here not my accountant accounting so if we go into the bookkeeping I can resume the reconciliation because we started it last time it's going to be in our cash or checking accounts let's resume I would like to resume please and so here is our layout we're trying to get this difference down to zero and we had that one glitch that we're going to keep in mind as we go that being that this beginning balance is not exactly tying out is not exactly correct in other words I'm going to go up top here and open up this carrot so we've got then the statement balance that's going to be the balance on our statement for the ending balance you'll recall so if I go back to our statement that's going to be then the Indian balance that's what we're trying to basically get to and then we've got the activity and I've unchecked everything at this point which is just the 25,000 this is where our major problem is because on the bank statement the beginning balance is the 30,000 we'll talk more about that later but we're going to keep that in mind as we go through the reconciling process and then we've got the payments and deposits that's what we're going to be entering here we're going to be entering the deposit side of things that gives us our difference on the right we want to get that difference down to zero if we had the same beginning balance and we checked off the same payments and deposits then the cleared activity would have to get to zero the items that would not be checked off would then be the reconciling items going to close up the carrots we got a little bit more space down below and we're going to be sorting in essence by date down below and then I'm going to be toggling to deposits and selecting the deposits item so I'm going to go back then to our our bank statement and just a quick recap on the deposits they should be easier if you have your full accounting system set up properly in other words the deposits should be something that you can take and tie off fairly quickly in part because usually the deposit don't have a big timing difference you put the deposits into your system fairly close to when they're going to clear the bank therefore you can depend on the date field pretty pretty heavily a lot more so than you could when you're looking at checks actual physical checks which take a lot longer for them to actually clear the bank resulting in the date field not being as relevant and then the other field that you have basically for sure is going to be the amount field that you can use to basically tie in the deposits now you could have some other fields depending on the type of industry you're in so in other words if you're getting paid from electronic transfers from like platforms or anybody you might then have information in the memo section of the bank transfer that could give you information about the customer that gave you the money as well so you could have some added detail but if in the minimum amount of detail if you just basically took money and deposited it into the bank then you would have the amount that was put into the bank and the date that that was put into the bank so where you could run into problems on the deposit side of things if we jump on over to our flow chart here this is the desktop version flow chart but just to give you an idea note that if you if you're not using properly the receive payment and the create sales receipts and you would need to use them then you could run run into problems with the deposits in other words if for example I'm collecting sales throughout the day and I have like a hundred sales that I make throughout the day and I just record them basically with us a sales receipt for example into my checking account so that I have a hundred different deposits into the checking account but at the end of the day I walk to the bank and deposit those 100 different sales that were cash sales as one lump sum in the bank then when I do the reconciliation process I'm going to see one lump sum on the bank and on our books we're going to have a hundred different deposits that we put in our system and we're going to have to do this big reconciliation process or of each deposit as we do the reconciliation you don't want that what you want to do instead it's create a system that you are using the undeposited funds whatever the clearing account is called this time deposit you know amounts to be deposited or something so that when you enter the sales receipt the other side goes into that undeposited funds or the clearing account whatever it is and then you take it out of the clearing account deposit all 100 items into your bank as one lump sum so they hit the checking account as one lump sum so that the reconciliation process will be as easy as possible the other time it's it's quite common that people run into problems if they're getting paid by some some in between type of service for example credit cards the credit card company is going to take multiple sales items most likely and deposit them in your system and in a lump sum kind of method and so if you're putting your sales on your side one by one and they're hitting the bank you know one by one then you're gonna have a reconciliation kind of problem at that point as well you can have to work with the credit card company the bank and your accounting system to try to figure out how you're supposed to group your account your deposits together to make the reconciliation process as easy as possible if you do that if you do that properly then the reconciliation process should be quite easy on the deposit side of things because again the date and the amount should be all you need really to tick and tie these items off okay so let's go back on over and so what we'll do as we do the ticking and tying remember you want to go from the bank statement you want to have it in your head that you're going from the bank statement to your books and you can go either way like you might say well why don't I go from my books to the to the bank statement you could do that but note that everything on the bank statement is going to be on your books unless the bank is incorrect and that's not usually the case so that means that if you go from the bank to the books then you have to be able to find it on your books if you go from your books to the bank it's quite possible there's going to be some items that didn't clear the bank because they're outstanding that's actually what we're looking for so you can get a little bit mixed up when you go from the from your books to the bank you'll never get mixed up if you go from the bank to the books so if we that's what we'll do here we got the date of 130 we've got the amount of the 65,000 we're going to go on over to the books here and there is the 65,000 I'm going to check it off right there notice that the date here is 1 1 2 2 that's when we entered it and if I look at the bank statement it's going to be 1 3 so the dates here is just a practice problem they might not be perfect all the time but the general idea would be that the bank statement date is always going to be after the book date if we did the full service accounting system we entered the deposits on our side and then they cleared the bank even an electronic transfer or an actual deposit if we go to the bank and deposit cash is going to take a little bit of time for it to clear the bank and that's why it's still possible for us to have those outstanding items although that little bit of time is going to be way smaller possibly like one to three days then a check which could take like a month you know you can have checks outstanding for a long period of time depending on who you're paying to check to okay so then once it's checked off I'm going to right click on it and highlighted and so this is something that would be great to have two screens for or actually a physical piece of paper that you would be checking off as you go then I'm looking for the 50,000 on the one five date so 50,000 on one five there is the 50,000 that looks good so I'm going to go back on over it happened on one two that's when we actually wrote or deposited it and it cleared the bank on one five so that seems reasonable so I'm going to go back on over and say let's highlight that and check it off you might say well what would happen if I had multiple deposits for the same amount again that's that could totally happen but you should be able to say the amount and the date which should be fairly close should help you to be able to tick and tie everything out and so then we've got the 757085 on 123 757085 going back on over there it is so that looks good and I'll go back and tick it off tick it off it's ticked off watch out because that one's ticked off and then 20,500 we're going to go on over 20,500 so there is that one and that one's going to be ticked off you got to be careful with these when you're doing it because you're working with stuff that's going to be ticked off so the okay so that I'm gonna go back on over so notice that this one we we deposited on 25 125 and it's not on the bank statement I would be concerned with that of course because you would think it would have cleared in January if it had five days to do so but if I if I look at it I can go into my bank statement and say did it clear in February if it cleared in February then I'm like okay that's fine it cleared in February I'd like it to clear faster I might be able a little upset but it cleared in February so I'm confident that I have that money and that's not really what I'm looking for I'm not just trying to confirm that that item has cleared I'm trying to see what the differences are with regards to the timing differences so I can get this balance down to zero so I can reconcile exactly which not only confirms the unclear items but also confirms all other transactions that in essence is our goal so when we do the bank reconciliation after I do the other side the deposit the payment side of things and add any transactions that need to be added this hopefully will be down to zero and when we do the bank reconciliation then this outstanding item is going to be what QuickBooks uses to construct the bank reconciliation so this is what I mean about this ticking and tying off is what most people think of that as the bank reconciliation this is this this is the process of reconciling which is very vital to do but the bank reconciliation is when QuickBooks takes this outstanding item and uses it to make a for a form called a bank reconciliation which will look something like this where that's going to be that outstanding deposit well we'll match the cleared balance the stuff that we checked out off and then we've got that outstanding deposit of the 347250 which I think is the same right 7250 right there which is going to be a reconciling item so that's going to be what we'll do next time of course we'll go we'll go on to the to the payment side of things you can make sure you could save it for later save it for later and then we'll be back later to do more stuff