 QuickBooks Online 2023. Rental income, estimate and customer deposit or down payment. Get ready to start moving on up with QuickBooks Online 2023. Here we are in our Get Great Guitars Practice file. We started up in a prior presentation using the 30-day free trial. We also have opened the free QuickBooks Online sample company. If you want the two open at the same time, we suggest using Incognito or another browser. You can open Incognito by selecting the three dots if using Google Chrome in the browser and picking the Incognito window and then typing into the search engine, QuickBooks Online Test Drive. We're going to be using the sample company to compare the accounting view, the one Get Great Guitars is in, and the business view, the one the sample company is in. If you want to change between the two, you can select the cog up top, switch the view down below. We're going to be opening a few tabs like we do every time, so we'll do it fairly quickly here. We're going to right click on the tab up top to duplicate it. We're going to right click on support accounting instruction by clicking the link below, giving you a free membership to all of the content on our website broken out by category further broken out by course. Each course then organized in a logical reasonable fashion, making it much more easy to find what you need than can be done on a YouTube page. We also include added resources such as Excel practice problems, PDF files and more like QuickBooks backup files when applicable. So once again, click the link below for a free month membership to our website and all the content on it. The tab up top and duplicate it. And then we're going to go to the tab to the middle and down to the reports on the left. Open up one of the favorite reports. Of course, it's everybody's favorite, the balance sheet. Everybody loves the balance sheet. It's the favorite. And then if you're in the business view, by the way, the reports are located in the business overview and the reports on the left hand side. Let's move on over to the income statement tab to the right and open up the income statement. The other favorite report also known as the profit and loss report. Close up the hamburger and change the range. 010123 to 022823. I'm going to change it from total to month by month so we can see the side by side. Jan Feb tote. Jan Feb tote. Year to date. Tab to the middle. Close the boogie. Scroll up to the top. Change the range. 010123 tab to 022823. And I'm just going to run it without doing that date thing. That's the setup process that we do every time. Let's go to the first tab now and we are now imagining that we have a rental kind of situation. So we here re-rent the guitar equipment. So we're renting out basically a band set. So if we open up a trusty flow chart, remember that we're in the customer cycle here. Couple different ways the flows could happen. One easiest way, you just have work from like YouTube when you get paid and you just deposit it and record the income possibly with the bank feeds or you're at a cash register. You get the money at the cash register and then you make the deposit or in the type of industry that you're going to get do the work first and then invoice the client. Then you have to send an invoice, track the accounts receivable, record the receipt of the payment and then the deposit. And then in some businesses we might get the receiving of the payment first. Possibly in situations where we have a business structure that's designed like that such as application sales, for example, where we have a subscription model, we might then get paid before we actually provide the service. Or we might get a down payment and that's what we're talking about this time. So we have a rental kind of situation where we're getting advanced payment for the completion of the task that we expect to have happen in the future as kind of a commitment so that the customer will follow through. So in that type of situation in our scenario, we've got banned equipment and we're going to say we can let you rent the equipment instead of selling the equipment for say a weekend, for example, then how are we going to structure that process so that we can make that happen? The idea is going to be that if someone calls in, they can request the rental equipment at some point in time and we can use an estimate form to think about what's going to happen. That's what we're going to do this time and give them an estimate of how much it'll cost and so on and so forth. The estimate doesn't actually record a transaction but it can be used to later populate the invoice when we actually facilitate the transaction. So over the phone, we can give them an estimate and possibly take a down payment at that point in time based on the estimate to commit them into actually taking the equipment. Of course, we're going to say, if you don't rent it, if you don't give us the down payment, people are renting this equipment like hotcakes. So you're going to want to lock it down with a down payment. Otherwise, I just can't guarantee that we're going to have it here when you come into the shop, right? So then we get the down payment. Now then we have that down payment issue, which is how am I going to record that? Because now I'm going to receive the payment before I make the invoice. So usually, I think most from a bookkeeping standpoint, we're going to use the method of recording a received payment and not applying it to anything because we have not yet made the invoice making a negative receivable, which isn't perfect from a bookkeeping standpoint, but easily adjustable with adjusting entries. And we've talked about that in depth in a prior presentation. So I won't go into all the pros and cons, but we have another method you could use if you want to use another method to put it into like unearned revenue or liability account at the start. And so that's going to be what we'll do here. And then we'll make the invoice when the rental actually happens and apply out the advanced payment to it and receive the rest of it and then make the deposit. So that's the general idea. So let's imagine someone's calling us up. They're saying, hey, we want to rent band equipment. We've already set up, by the way, the items on the left hand side. So if I go to the left hand side and we go to the sales area and we go into the products and services, we have our items. By the way, if you're in the business view, that's located under the get paid and paid area, get paid section and the products and services there. And then we put all of our rental stuff down here under a rental category, which is shown by this little tag in the items. And we said, we're only going to have the baseline band set. We're not going to be renting out like one drumstick or anything like that. So you've got to pay us at least the two thousand. But if you want to add on to it from that point, then you can add on possibly have more complex guitars or expensive guitars from there or something. And maybe that's the system that we set up so that the data input can be as easy as possible. So someone working over the phone can hopefully come up with an estimate fairly easily without having to get too crazy thought process on it. So we're going to go customer's estimate. Someone's calling in. What's the customer's name? It's going to be customer number five. Are you kidding? Customer number five? Customer number five. What kind of practice problem is this? Can't you come up with a name for crying out? Okay. Okay. Custom got a little lazy on the names, all right? Customer number five. So we're going to say that customer number five is then on the date, we're going to say 022723 is when they called in and we're going to make an estimate. We're going to say what do you want customer number five? And they're like, we want a band set. So we're saying, you know, the base band set, if you want it, is going to be according to this here. You have to get that at least and it has like two guitars, a drum set and an amplifier. And so that's the baseline. But they're like, yeah, but we want another to add a guitar to it. So we're like, okay, if you want to add another guitar, we can, we can save that for you as well. And so that's going to, but that's going to cost you, they want two more guitars. They say, well, it's going to be $50 each for two more guitars that we have to hold on to here to make sure that we don't rent them out to anybody else because people are coming in all the time trying to, trying to rent out our guitars. And they also want an amplifier. So we're going to say, all right, you want an amplifier to okay. And so they're going to, they want four of those, we're going to say four amplifiers. They really want to piss people off. Okay. So there we have it. So that's going to come out, that would come out to 200260. And so then we can give them that we can, we could schedule that we're going to hold on to this equipment to make sure that it's available when they come in and so on. And then we can use this number to try to estimate how much, try to estimate how much down payment we want. We might have a system of saying 10% down or something like that. But note that this will not actually record anything. It'll just make an estimate, no impact on the financial statements. So I'm going to go ahead and save and close that. We're going to say, all right, we'll see you when you come in for the equipment. And then when I track this, then it's in the sales area over here, and I can go into the customers, we can go into the customers, and we can check out customer number five that way, or we could do it this way, we can hit the estimate, which is probably the best way to do it, hit the estimate up top, there's customer number five, we've got an open estimate, we can populate an invoice with that. We also have on this side, if we go into the sales tab, your estimates tab here. So you can sort your estimates this way. And you've also got your all sales items where you can use this to hit the dropdown and sort by estimates. By the way, that one's located in a little bit different place on the business view. So in here, we've got the get paid, paid area, there's your customers, there's your estimates. But if you want to go to that sales thing, it's located under the bookkeeping tab, and then transactions, and then the sales thing. So they kind of threw that one through you a curveball on that one. So you got to wait till it curves over the plate so you can so you can hit it. So there's the estimate on that one. Okay, so now we're going to record the receive payment that we would base on the estimate. So now we're going to say, if I look at the flow chart, we're going to say, okay, we made an estimate to help us to save the guitars and not not so we have them on hand. And then so we're going to reserve the guitars. And then we're going to go to the receive payment here before we make the invoice. So I'm going to say, okay, let's go to the receive payment. And let's go to the forms. And we're going to enter a receive payment. And this is where we get the advanced payment. This is kind of like an undeposited funds kind of problem. And I'm going to say this is going to be for customer number five. And so it says fives payment doesn't have an open invoice, we can't apply it to anything because remember the receive payment decreases the accounts receivable, but it doesn't have a specific sub ledger account for customer number five to decrease. So for the sub ledger, it'll have a negative amount in there. But that's okay. That's just what we want. I'm going to say it's for $200. I made up the $200 in practice. You might base the $200 based on the estimate taking like 10% of the estimate or something like that. If you were to do a system like that, I'm going to say the payment is just going to be cash. Even though it went over the phone, it would probably like be like a credit card or a or an electronic transfer. But I'm just going to record that just to do our normal kind of process. And then we're going to be putting it into the payment to deposit it instead of directly into the checking account as our normal process so we can group them together in using the deposit form like we normally do. So what's this going to do? It's going to create a decrease to the accounts receivable, but a negative receivable for the customer sub ledger for customer five that we can then apply out to an invoice that will make in the future. The other side's going to go into our cash type account, but the payment to deposit account. So let's save and close it and check that out. And it's giving us our little our message here. I'm going to say that's okay. Save it as a credit that we can apply out. That's what we want to do. So I'm going to go to the tab to the right and then run it to refresh it. And then we've got here there's the $200 and the payment to deposit. And then in the accounts receivable, the A to the R we've got the $200 down here. That makes sense. But there's a sub ledger thing. Notice there's no impact on the income statement, by the way, because even though we got money, we haven't done the work. You haven't done the work to earn the money. So let's open up a new tab. I'm going to I'm going to duplicate the tab and look at the sub ledger for accounts receivable A to the R reports on the left hand side, closing up the buggy and scrolling down who owes you. Let's take a look at the customer balance detail report. And then that looks good. So this is for customer number five. There we have that negative amount. That's not exactly correct because it should be a positive liability. But as we discuss in the other advanced discussion, the last advanced discussion, it works quite well logistically. That's why we use it. There is another method you can do if that really, if you really want to, but we can adjust that periodically to make the financial statements correct using an adjusting entry type of process. So I think this actually works quite well because internally, if I go to the left hand side, and I go to my sales tab, and I look at my customers, if this customer comes in, then I've got this nice estimate on the left that I can search by over here and say, oh, yeah, you have an estimate that I can make an invoice out of. Let's hit it again because I unsorted it. There you are. If I go into that, there it is. Oh, yeah, you've got an unapplied payment of $200. I see that we received that. That is quite nice because you can have someone who didn't do the estimate before that doesn't know what is going on can look at this information and see pretty plainly what's happening from the bookkeeping side of things and say, oh, okay, well, now I'll use the estimate to make an invoice. But before we do the invoice, let's just record the deposit now. Don't get ahead of ourselves. We've got this $200 in payments to deposit. I'm just going to use the deposit form to take it out of there and put it into the checking account. So I'm going to go to the first tab and just hit the plus button going to make the deposit. And we've got into the checking account or keep the date. I'm just going to check off that one deposit. Notice that I could have deposited it directly into the checking account considering I'm not combining it with any other deposit. However, if I have a system where I'm putting everything through that payments to deposit account, I probably don't want to switch back and forth between that method and another method because that'll just be confusing, right? So it's just I'll just always basically do this method. I kind of like doing it anyways, because even if I don't have a batching situation that I need, it will then show the forms and the transaction detail that are increased in the checking account, all those deposit forms. So let me just show you that. And so if I record this, we say save and close. And I go into the balance sheet and I go into the checking account. We now have a deposit down here for the 200. If I recorded the sales receipt directly into the checking account, I could do that. But in the transaction detail, the increases then maybe sometimes deposits and sometimes sales receipts, which isn't a problem. But you have to note that when you do your sorting and stuff up top, if you wanted to customize and filter your transactions by increases to the checking account and transaction type, which is fairly common thing to do, you couldn't just pick deposits, you got to pick all the forms that are increases. And if you have multiple forms, other than just deposits and possibly transfers, you just have to be aware of that. It's not a big deal. It's not going to mess anything up. But it gives you something to think about, you know, if you if on which methods you want to use the other side is going to go over here to the to the payments to deposit, which is now back down to zero because it's a clearing account going into that. And it went back down to zero. We get to see it ticking and tying out. And again, note that that the payment here would, if we deposited this, if we deposited it directly into the checking account, then and one of my look, I'm looking at these two, these are the two. This one is the customer deposit that I'm looking at customer number five. And okay, so it's a little weird for the order because there's a lot of activity on the 27th. But if I recorded this payment directly into the checking account, then of course it would show an increase to the checking account with a payment form, instead of the increase to the checking account being the deposit form, right? That's the general idea. The deposit forms in here are actually decreasing a cash type of account, but this is a clearing account designed to do that. That's that's the idea of the clearing account to hold on to the cash and to make the deposit. Okay, so there's that. So next time we're going to have our customer come in, where we actually give them the guitars and whatnot. And and then we make will make the invoice at that time. So the story will continue. It'll be exciting. There'll be thrills and and exciting things along the way. So continue on tune in next time. But for now, let's open the reports and just see where we stand here, closing the hand boogie, typing in trial balance, trial balance. And then we'll change that range from 010123 to 022823. Going to look at it on a month by month, side by side, run the report. There it is. There's Jan. There's Feb. If your numbers tie out to our numbers, that's great. Then I'm not saying we're doing it that everything's perfect. We might be standing on on quicksand, but we're standing or sinking together, which is which is lovely. And if if not, if we're not together on the same page, the same place of quicksand, then try expanding the range. And if there's a range change issue, then see if you can change the date to make it to fix it, which is something that's good to do in the practice problem. But be careful doing that in practice. And we will be running a transaction detailed report at the end of the second month of data input to further drill down on any differences.