 QuickBooks Online 2022, deposits from payment to deposit or undeposited funds. Get ready because it's go time with QuickBooks Online 2022. Here we are in our Get Great Guitars practice file that we set up with our free 30-day trial. Holding down control, scrolling up just a bit to get to that 1-2-5% we're currently in the home page, otherwise known as the Get Things Done page and the business view as opposed to the accounting view. If you wanted to change to the accounting view, it is something you can do by going to the cog up top, switching to the accounting view down below. We will be toggling back and forth either here or by jumping over to the sample company file to take a look at where things are located in the two different views. Let's open a few tabs now. We're going to go to the tab up top to do so. Right-click on it, duplicate that tab. Back to the tab to the left, right-clicking on it, duplicating it again one more time. A duplicate of the duplication process going to the tab up top, right-clicking on it and duplicating another time. As that is thinking, let's jump on over to the sample company file to look at where the reports are located in the accounting view, which is pretty straightforward. It says reports right on the left-hand side. That's where they're located. If we then go back on over to the business view, we're now in the second tab looking for the reports here. It's in the business overview section and then into the reports. Let's open up the balance sheet first, one of our FAVES reports. Closing up the hamburger range change up top from 010122 to 12123122 and run it. And then we're going to go to the tab to the right and we're going to go to the business overview. Open up the other FAVES report, which is going to be the profit and loss, the P&L, the income statement closing up the hamburger and then doing the range change from 010122 to 1232 and running that report. And then tab to the right one more report, the less well-known but also great report is going to be the trustee trial balance, the TB, which is easiest to find by typing in up top, trial balance, because that's what it's called. And then it pulls it right up for you. Closing the hamburger, doing the range change up top from 01012123121 and actually I'm on 22, aren't I? 22. It's 2022. 2000 double deuce. There we go. Now let's run it. Run it. Did I get the date right on the, now I'm like worried that I got it wrong. I did it right. I did it right. Okay, let's go back to the first tab. Now in prior presentations, let's keep it here on the balance sheet. In prior presentations, we were entering transactions related to the sales cycle, including invoices that we then received payments on, as well as sales receipts. And instead of putting that information or those payments, those receipts directly into the checking account, we put them into a clearing account, which they are now calling payments to deposit. It used to be called undeposited funds, same concept, just a different name, which is a good example of basically the changes that QuickBooks online will make as you go forward. There'll be cosmetic changes usually in terms of names of the website and where things are located. The double entry accounting system behind those changes in essence remain in the same because it's the double entry accounting system. So now we have items in here, if I click on that, that we can then deposit into the checking account. Now why would I put the money in here instead of depositing them directly into the checking account when I made the, when I received the payments or when I made the sales with the sales receipts? Because if we did that, then it's possible that the grouping in our books would not match out what is on the bank statement, making the bank reconciliation more difficult. Scrolling back up, we're going to go back to then our reports. Let's get a quicker look at this in our, our float chart over here. This is a picture of the desktop float chart, but it's just a picture of, you know, the flow of the accounting process and we have the same account names here. So for example, on the full accrual process, we entered an invoice and then we get the payment later, then we got the received payment form. We could at this point deposit it directly into the checking account with the received payment form. And if the payment that we're getting is one payment that we expect to also be on the bank statement, that might be a good way to go. Although you're still going to have some kind of confusion in that when you look at the increases to the checking account, you're now going to have received payment forms as well as deposits that will be increases to the checking account instead of in essence, just deposits and possibly transfers. So that's one other thing to keep in mind. But if you're going to have multiple payments such as cash payments or credit card payments that you then need to group together because they're going to be deposited in the checking account with multiple payments in the same deposit in the bank statement, you want to mirror that in the books by putting them into undeposited funds or this other name that they made, which was deposits to be deposited or payments to be deposited, which will then be deposited into the deposit account with the deposit form, the deposit form being really useful here because then it will link to that undeposited funds or that clearing account, whatever they call it, to help us group the deposits. When you're using the create sales receipts, which just means we're going to get paid at the same point in time that you did the work, imagining a cash register situation. It's very likely that you'll need the undeposited funds because if you're collecting something like cash or credit card sales, it's likely that you're going to have multiple sales grouped together that will then hit the bank statement with one lump sum and therefore you want to then use the clearing account to then group your deposits into the same format. So if that means that when I use the deposit now, I really want to use the actual deposit form. I'm not going to go to the register as we did before, meaning if you had a deposit that wasn't from your customers, such as a deposit from the loans or a deposit from the deposit from you, the owner, you might just go into the register and enter the deposit. However, here you want to use the deposit form because the deposit form has the feature to link to that undeposited funds account, which is really nice. Also note that if you use bank feeds and you are utilizing just the deposits and depositing the funds and recording it as revenue at the point in time that you just get the deposit, you're losing some of the flexibility that QuickBooks has designed into it to use the sales forms of either the invoice or the create sales receipt, which may be appropriate for some businesses, but there's a trade-off between some of the more added detail you would get if you were to use, say, the create sales receipts as opposed to just basically depending on the deposit form that more detailed including things like being able to break out your sales by customers and be able to break out and run reports on your sales by items that you're selling, which you're not using items, the inventory and service items, if you're just recording revenue at the point in time that you get the deposits. Okay, so let's jump back on over and we're going to jump back on over here. There's the big leap. I leap. That was a huge leap back on over to QuickBooks. So now let's go to the first tab and to do this straightforward process, we're going to hit the drop-down button and we're going to say that in the past we entered an invoice and then we received some payments that we put into that clearing account, undeposited funds or deposits or payments to be deposited and we entered some sales receipts. Both of those items going into the clearing account. Now if I go to the deposit form, it will automatically pick up those items, giving us the option to choose them to make a deposit grouped in the same format that it will appear on the bank statement. So we're going to go into the cash account, which is our checking account. We're going to say the deposit date is going to, well let's keep those, do that in a second. The ones we're going to check off down here are going to be the last two for, we're going to check off the two, three, this one and then let's check off the five, one, this one. I'm going to check off these two to start out with and I'm going to imagine that we're depositing those at the same point either because their credit card receipts that got grouped together in that way or if you had cash payments that you're going to the store with, that's the imagination of the two scenarios, which you would commonly have where you would group those two together, they then hitting the bank account in that grouped format. So let's put the date up top. I'm going to say this happened, let's say on the 20th, I'm going to say it happened on the 20th. So what's this going to do? It's going to increase the checking account by the total and it's going to be in there as one lump sum in kind of like a GL or activity account of the total of the 7570.85. It's going to decrease the clearing account which used to be undeposited funds, which is now the amounts to be deposited cash to be deposited or something like that. And in there it's going to show them separately so that you can see the detail in the clearing account going up and going back down by the detailed accounts. So let's go ahead and save it and close it and check it out. Save it, close it and let's go on over to the balance sheet for the checkout and we're going to go into the cash account which is an as essence our checking account here drilling down on it and we see the deposit here at the 7570.85. That one number we expect to be on the bank statement. If I drill down on it, there's two amounts that are included in there from the sales receipt activity. So that is what we expect to see in the bank statement making it easy for us to just check it off when we do the bank reconciliation instead of us having to add together the two transactions when doing the bank reconciliation which makes reconciling really more difficult and you want that thing, you want that process to be as easy as possible. Okay and then the other side is going to the deposit payment to be deposited, going into that this is what used to be the undeposited funds. Here's where we see the detail so we see it broken out in the two items here which we can match out to the increase. There's the increase, there's the decrease, there's the increase, there's the decrease, so we get that nice matching impact when we look at the detailed account for the clearing account. Let's do it again. Okay let's go back to the first tab and do it again. We're going to hit the plus button again. We're going to deposit the rest of them and make the deposit bank deposit. Now obviously if you were to run this routine, if you if you were in a situation where you worked at a store and you had a cash register, you would most likely go to the bank at the end of each night hopefully if possible or possibly at least once a week and make the deposit and that's when you would be basically grouping this information. If you have credit card payments then you've got to think about how the credit card company and your bank are grouping the deposits so that you can mirror that transactions on your when you're entering the system into your QuickBooks to make it as easy as possible. So we're going to go into the checking account. I'm going to say this happened on the 21st let's say just to change things up and I'm just going to check the rest of them off these being the three other payments that we received from three different people that were imagining either from cash or credit card or for whatever reason we are then depositing into the bank at one lump sum that being the 20,500 and that's what we expect to see on the bank statement. So we're going to say what's this going to do? It's going to increase the checking account by one lump sum 20,500. It's going to decrease the clearing account which used to be called undeposited funds which are now payments to be deposited by the three individual amounts allowing us to tick and tie off the activity in the clearing account. Let's save it and close it and check it out. This time let's do it on the trial balance going over to the trustee trial balance and then we can drill down on the checking account here and we should have one lump sum one lump sum at the 20,500 which of course we can drill back down on. Notice the detail over here says the deposit it's kind of nice to have all your increases in essence being deposits whereas if you use the received payment or the sales receipts to deposit directly into the checking account you're going to have those forms kind of show up in here and that makes it a little bit more confusing not too bad but it's kind of nice to have the only thing increase in your checking account being the deposit form as well when you sort your data so there it is I'm going to close this back out and then if I go back then to the to the report and look at the other one which was in what used to be called undeposited funds but now we're using the name of I can't even remember payments to deposit payments to deposit notice it's a zero amount and it doesn't disappear over here and sometimes it'll disappear on if you go back to the balance sheet and if I was to if I was to run this again then and you go down here that the reason it's still there if it disappears that's because your settings are showing in the settings that you're only looking at the items that have a balance in it so in other words if you went to this drop down and you're showing active if I show if I show non zero items here for example which you might want to do for reporting purposes then you're not going to see that account because it's a zero item remember that if you're showing the active items which is quite useful for internal reporting then it's going to show that zero item because there was activity in it at this point which is good because you want to be able to drill down on it to see what the activity is and here is the activity notice it's going in and out this time not with a lump sum but giving you the details so you can tick and you can tie tick and tie tick and tie that's the name of the that's the name of this game let's go back on over back to the back to the report so there there is that also just note that there's no impact on the income statement at this point in time because we're just taking it out of one basically cash account to the other so if I was to run this or refresh this nothing new nothing new happening over here so let's go on over to the trial balance just to see where we stand at this point in time let's make it make sure it's a fresh report and this is where we are at so you can check your numbers if you if you match out to what we have here and you're following along great excellent good work if not then possibly change your date range it's often a date range issue and you can you can then at the end of the section we'll be running a transaction detail report which is another good tool to see where any differences may be