 Zero Accounting Software 2023. Bank Reconciliation Month Number 2. Checks and Account Decreases. Get ready to become an Accounting Hero with Zero 2023. Here we are in our Custom Zero homepage. Going into the company file we set up in a prior presentation. Get great guitars. Duplicating some tabs to put reports in like we do every time. We're going to do four duplications this time. So bear with us. Right-click and duplicating the tab. Right-click in the duplicated tab and duplicating again. Right-click in the duplicated tab and duplicating again. And one more time, right-click in the duplicated tab to duplicate again. Back to that first duplicated tab, second one in the series. We're going to go to the Accounting drop-down. Open up a balance sheet type report. Tab into the right. Accounting drop-down. Income statement. I'm doing a comparative income statement here, but you can open whichever income statement you have. Tab into the right. We're now going to go to the Accounting drop-down. Look at our reports. I would like to open a bank reconciliation. I'm going to say bank rec. And there we have that. I'm going to tab to the right and do that one more time with another bank reconciliation. Accounting drop-down reports and once again typing in bank rec. Bank rec. There we have it. Alright, so then we've got the bank rec. We're recting the bank because Little Hand says it's time to rock and roll. Alright, let's do the range up top. The bank rec. Range dropping it down and bringing it down to, let's say, custom range here. Let's make this one for February 1 to February 28. And then this is going to be the checking account. The ending balance. We're picking up from our bank statement at 101.590.05. And update it. Tab into the left. I'm going to do another bank rec for January, the first one we did so we can compare and contrast the two as we do our data input. Let's make this from Jan to Feb. Jan to Jan 31. Jan beginning to Jan end. This will also be the checking account and our ending balance for Jan was 6124185. So 6124185. Half confidence in 6124185. I know what I'm doing. I got the number right. Alright, let's go to the tab to the left and income statement looks good. Tab into the left. Let's make a comparative balance sheet to do that. I'm going to hit the drop down. Customize the date. I'm going to start in Jan. Jan 1. Let's go to Jan. Hold on a second. Jan 31. And then update it. And then I'm going to edit the layout and add a column up top. Date column, the date of Feb. Alright, you might want to save this report so you don't have to do that every time, but we might do it a few times because it's fun to do. So there we have it. And we can see that the ending balance for Feb is 9577906 showing on our bank reconciliation 9577906, but that's different than our bank statement, which we could see there and we could see over here. We last time entered the reconciliation for the deposits. Now we're moving on to the decreases, the checks and other decreases. Alright, let's go back to the first tab. Accounting drop down. We're going to go into our bank account information and into the reconciliation section. Drop down here. And where's that? It's not doing it. It's not doing it. There we go. Alright, so we have our three tabs. So the tab to the right is the account transactions, middle tab, bank statement transactions, and the tab to the left is the reconciliation. So now we're just going to match these two out as we go. I'm going to look at the bank statement as we do it so we can kind of tie out to the bank statement as we go. Remember, every time you do this, if you're checking it off from the bank statement, you want to go from the bank statement to the books because if it's on the bank statement, it needs to be on the books unless the bank is wrong, which isn't normally the case. But if it's on the books and not on the bank statement, then it might not be wrong. It might just be an outstanding item, something that we wrote, we knew about, but the bank doesn't because it has not yet cleared. That's why we go from the bank to the books. So we've got the three, five, seven, two, seventy. Let's go and say, alright, three, five, seven, two, seventy. There it is. Notice I'm missing the check number. So notice the things that can tie out and help us out are going to be the dollar amount, the date, which will become more relevant if the date is electronic transfers are used and less relevant if they're physical checks, but then you have the check number if there's a physical check. Now also note that this one here was written in January, even though it cleared in February. So what does that mean? When I add this, it's not going to change the January bank rec. So if I go to my January bank rec, I have these outstanding items. And so here's our outstanding items down below. I think this is the one we were looking at, is it? Yeah, this one right here. That's not going to go away, but it will go away on the bank rec for February, where we have these outstanding items, outstanding items here. And these are payments, the three, five. I think that's the one. Is it that we wrote? Yeah, the one we wrote in January. It'll go away here. It'll have cleared here, but it won't be a reconciling. So you see what I'm saying. All right. So let's go ahead and add it and just check that out. So if I go back on over here, update, it didn't change the January bank rec. The January bank rec still has it outstanding, but the Fed bank rec, if I update it has changed, it should no longer be down here as an outstanding payment for the Fed bank rec. So this is one that was written in February. I think it's the same dollar amount, but it was written in February. So that's not the same one. All right. Let's go back on over. Same thing here. Let's screenify this. If I get, if I may greenify, we're on the 410 next time, 410. Boom. This one also written in January, but cleared in February. Same situation just like you would expect. If we wrote it in January, it didn't clear in January. You think it would clear in Feb as it dead. Okay. So we're going to say that one is good. And then the 185640. So 185640 also written in Jan, clearing in Feb. Cool. No problem. And then we've got the 200 and the 130. Let's see if we can do two at the same time, the 200 and the 130. I'm checking them both off without even looking in between because my memory is like a trap of steel that nothing gets out of because steel is really strong material. One, three, five, eight, seven, three. One, three, five, eight, seven, three. Looks good. Moe B to the end. Let's do two at a time again. 180, four, six, eight, seven, seven, which had pennies in it. And I even remembered the pennies even though it wasn't around number 180, four, six, eight. That's how far my memory extends, which is pretty much super human right there. 185640. 185640. That was a long number. I didn't want to try two at a time right there because I had like more digits than the other one. I don't want to look stupid. 10080. All right, there's that one. Okay. And then we have these two down here, which once again are not on our system. So we don't have those two here. I don't think, right? 500. So here's the 500. And notice it's matching out to the wrong one over here. It's matching out to staples. That can happen sometimes if we don't have as much detail as we would need to match these two things out because this one isn't, shouldn't be matching to staples. And the check number often helps out in correcting any kind of problems like that. So if you don't have as much detail to match these out, it just shows that you do have to still kind of be careful to make sure that you're tying these out because the system is trying to match it out unlimited information, right? It's trying to match it out on just the amount and the date and possibly like a check number if it has a check number to go with. And then possibly vendor data, which would be the memo detail if it has it, which would have more of that detail if you were using electronic transfers in the memo section. So this one isn't actually right. I need to create something.