 broke out the amounts to be per check rather than per journal entry in the general ledger so that we can match them out to the bank statement. That's gonna be one of the common type of problems that we do face within the bank reconciliation. We wanna make sure that we are inputting the same grouping into our books as the bank reconciliation, the bank statement so that it's easier for us to just tick and tie them out and see which amounts are tying out to the banks. If we don't do that, we can still reconcile but it's a little bit more difficult because then we have to combine amounts and find which ones match out and I'd rather just have it be checking, ticking and tying them for an example like this. What we're gonna do now is just tick and tie everything out. I start from going from the bank statement to our books meaning I'm gonna check everything off on the bank statement and see if it has cleared the books and then go the other way, go from the books back to the bank statement to double check everything. Before we start that, we're gonna have our two components of the bank reconciliation. One's gonna be the bank side and one's gonna be the book side and so we'll start with the beginning balances so in terms of the beginning balance it's gonna be the ending balance here but it's the beginning balance for our reconciliation. This is where we are at before we put any reconciling items in. So this is the balance in other words as a February 28th on the bank statement and that's gonna be 99296 and then we have the book balance. This is the book balance at the end of the month but the beginning of our bank reconciliation and that's gonna be 99116. So at the end of the day we're gonna get to this ending balance down here and hopefully they will then match and if we tick and tie everything out we think that they should have to match. Now just to note where we have started here just to get an idea of this. Remember that all of this blue stuff that's the stuff we checked off already that should match out to the beginning balance now that's all the cleared stuff that has happened thus far within the business. So if we highlight that this plus this plus this minus this minus this minus this plus this plus this minus this minus this I'm holding, I'm letting go I'm holding down control and clicking on the blue items. Blue item, blue item, blue item. And then just looking down here and let an Excel sum that up it sums it up to 109.415. The blue items that we checked off in other words are our cleared balance. Those are our beginning balance. So that matches our beginning balance that has already cleared. The blue items are here. Then we're gonna record our activity and check off all the activity that happened in the bank statement as of February in our books as of January and February depending on when we wrote the check. So we wrote some of these in January some of them in February which have been cleared in February here on the bank statement. Let's take a look at that we'll go through the deposits first and we're just gonna tick and tie this information out. We have the 956 on the deposit and the only thing we have other than the deposit really is the date and that date is not gonna match our date because we wrote the check date as of the point in time when we made the deposits and it takes a little bit of time for it to clear the bank. So note the date will always be closed but sometime after the deposit date in our books. And that's why it's important to get the deposits matched up correctly so that we can match this stuff out as easy as possible. I'm just gonna highlight these. I'm gonna make them green. Say we found that and we found that so we're good there. Here's the 12, 250. We're just gonna do the deposits first. That's gonna be something that we wrote in February. So we found that. I'm gonna highlight that here. We're gonna highlight that there and say we found that. Here's the 825. I see it on both sides. So we're gonna say here it is there and here it is there. So those are gonna be the deposits and yes, we have this other one but we're going from here to here now so I'm not gonna worry about this other deposit yet. What we're gonna do now is go through the checks and here's the check. We really have a little bit more detail. We still have the date but we also have the check number. Now our general ledger isn't showing the dates and the check numbers because it would get too long and messy if we had the problem with that there so we tried to shorten it out but we typically would have a little bit more information in terms of check number when marking the stuff off in a computer system and that can give us a little more help. Note the dates will be even further off however because we wrote the check and the date at the point in time when we wrote the check and it takes a lot longer for a check to clear the bank so the dates here are gonna be much later. So we'll go ahead and check these off. So here's the 11. We see it there. I'm just gonna make it green. There's the 11. There's the 500 and I know this is a tedious task but it is, this is how it's done and then there's the 500 and there's the 360. Here's gonna be the 360. There's the 3539. Here's the 3539. There's the 630. Here's the 630. So we've tied all those out and that's all information that we actually wrote in January and didn't clear the bank until February. Then we have the 1,359. That's gonna be up here so I'm gonna highlight that and that's gonna be this item. Then we have the 168. So we had to skip them. Notice they're not quite in the same order. That's okay. That could happen on the bank statement. That's fine. That's the one just because of when, it depends on how the bank statement's being ordered. If it's ordered by date, then that's likely to happen because it's likely that different people deposited their checks at different rates. So we're gonna say this is gonna be this item. Here it is here. We have the 123. There it is there. Here it is here. We've got the 380 or the 830 here. And here we've got the 648. That's gonna be here. And it's a skipped a few. So we didn't see a couple of those. That's okay. It's not in order. We're gonna just check them all off. And then we have the 3513 here and here. So now we've tied everything out that are the checks. Then we have these two items, the withdrawals and the bank service charges. Those are gonna be items we don't see over here. I don't see the withdrawals and we don't see the bank service charges. And so those are gonna be items that we're gonna have to adjust for. So I'm gonna make these yellow and say that I don't see these over here. I'm gonna have to do something about that and see what happens or see what we can do about it. And then we'll go from the other side. We found all these highlighted ones. Let's see, double check the ones that have not been highlighted. We have this deposit here. It's not over here. So I'm gonna make that yellow too and say we gotta do something about that. These two are here. I don't see them over here. So we're gonna make that yellow. These two are over here. I don't see them over here on the bank statement. We'll make that yellow. And this.