 Zero Accounting Software 2023 credit card reconciliation for month number two and month number three. Get ready to become an accountant hero with zero two thousand twenty three. Here we are in our custom zero homepage going into the company file we set up in a prior presentation the bank feed file. We're going to duplicate those tabs to put our favorite reports in right clicking the tab up top to duplicate it. We'll right click the tab again and duplicate the duplication back to the tab to the middle opening up the famous balance sheet report. Tabbing to the right hitting the drop down hitting the income statement report up for this one and then we'll change our range on the income statement. Let's just do the whole year of two thousand twenty two on the income statement and then we'll change our range more specifically on the balance sheet. So I'm going to go from Jan two thousand twenty two to December two thousand twenty two the thirty first of it and update it. And then to the balance sheet I'm going to now be reconciling for the period end of September. So that's our next reconciliation date. Let's actually by the way let's do it this way. Let's let's let's put three months next to each other. So I'm going to do a custom date range to do that and I'm going to go to the drop down and let's go to actually October the end of October. And then use zero's really cool date edit layout field down here to bring in the prior two months as well. And to do that I'm just going to say add a field up top and I want it to be a date field. And so on the date I want to bring this one back to September. And so there it is. So September looks good. Let's add another one. Another date field and let's do it with a date up top. And this one's going to be for August August. So now we've got the current October September and August. Okay. And so let's update it. And then we've got this super cool report that shows the credit card balances lined up for October, September and August. Now last time we did a reconciliation for August the first bank reconciliation which is really the only one that causes problems. Oftentimes with a credit card because you might have that beginning balance issue that you have to deal with. Once we do that then our balances are usually pretty on target. So if I go into August there's the 52271 and there's the balance 52271. There is no difference because we don't have any outstanding checks and deposits because we constructed our books directly from the bank feeds. Let's actually open the bank reconciliation report now. Right click it on the tab to the right duplicating it and then we'll go to the accounting dropdown and into the reports. And let's open up a bank reconciliation bank reconciliation bank. And so we're now going to be doing this for the following month. So let's first take a look at that month we'll say drop down. Let's go to the 2022 bring it back to August and the 31st and then we're going to go to let's actually do the 1st of August. And then to the 31st July August 2022 31st and then this is for the credit card and the tricky thing here is you just got to make sure you put a negative for the credit card. So 52271 so negative negative 522.71 and there we have it we reconciled everything so we don't have anything outstanding at this point in time. And so the two things match it should be the way it should go basically going forward. Let's do the same report. I'm going to copy it right click and duplicate it for the month of September. So I'm going to go and say now let's do August September 1st to September 30th and now I'm going to change the balance to be. This is October September 717.22 so negative negative 717.22 and update that report. So there we have it and notice it should basically tie out pretty much automatically now because we don't have that same beginning balance problem. So this is the amount from the balance sheet. Here's the amount from the balance sheet. If I go back on over credit card 717.22 and we're going to say September 717.22 and that's the amount on the books as well. So everything ties out. Let's go to the first tab just to look at the bank reconciliation process. If I go to the accounting drop down and we go into the bank accounts then we can say all right let's go into the credit card and see what has happened. So the account transactions this is what we have entered that is related to the credit card. But we constructed all these transactions directly from the credit card bank feeds all except this beginning balance entry. Once we have this entry in if everything else is being constructed directly from the bank feeds everything should be good to go. We should be basically reconciled. You can see the first tab over here. There is nothing more to reconcile. We've pulled everything.