 QuickBooks Online 2022, rental income, invoice, receive payment and deposit. Get ready because it's go time with QuickBooks Online 2022. Here we are in our get great guitars practice file we set up with our 30-day free trial. Holding down control, scrolling up a bit to get to the 125% currently in the home page. Otherwise known as the get things done page in the business view as compared to the accounting view. So if you want it to change to the accounting view, it's something you can do by going to the cog up top and switching to the accounting view down below. We will be toggling back and forth between the two views either here or by jumping over to the sample company file currently in the accounting view. Let's open up a few tabs. We're going to right click on the tab up top to do so, duplicate it back to the tab to the left. Right click on it again, duplicate it again back to the tab to the left. One more time, right clicking on it, duplicating it again as that is thinking. Going to jump back on over to the sample company just to note where the reports are located which is on the left hand side reports. If I go back then to the business view reports are located in the business overview currently in the second tab. We're going to be opening up our favorite report when the reports area closing the hamburger. That being the balance sheet, the big balance sheet. Opening it up and ranging the changing up top from 0101 222 1231 222. Run it and then tap to the right, tap to the right going into the business overview. Again this time closing the hand bug and going down to the P&L profit and loss income statement. Changing the ranging. Let's do this with a 0101 222 0228 222. Switching things up and then hit the drop down here. Let's take a look at the monthly month by month running it so that we can see the January activity, the January activity, the February activity and the total we're currently in the month of February entering data at this time. Tab to the right going down to the business overview. Let's open up as well the P&L, the trial balance, the trial balance. That's what I'm trying to say. Trial balance. I haven't seen it for a while so I'm a little out of practice with it. Closing the hand bug, doing the range change up top from 0101 222 1231 222. Run it, holding control, scrolling up just a bit. Go back to the first tab. In prior presentations we imagined a scenario that we're going to be selling some rental equipment in our Get Great Guitars shop. And that's going to be our band set. So we went into the get paid and paid area. We went into the products and services. We set up our service items. Imagining that people are going to rent band set, the standard band set having then a couple guitars, a drum set and an amplifier. And then they can add some added stuff if they want to. This is located by the way if you were in the other view, the accounting view in the sales area and products and services. And then we went and had customer number five come in and request that they want to rock and roll. One of these weekends. And so they requested, so we're going to go into the get paid, paid area and the customers tab now. Closing up the hamburger and we set up an invoice. So if we go down or we set up an estimate, I'm sorry, an estimate for customer number five as we can see here, here's our estimate. And then we said we want a down payment to reserve the equipment because we got like a bunch of people that want to rock and roll with our guitars and amplifiers. So if you want to reserve it, you got to give us a down payment. The payment needs to be down. So they gave us a down payment of the of the 200, which down here looks nice and easy to tie out because it's unapplied at this point in time. So when they come in, we can then say, OK, now we're going to finish the sale, making the estimate into an invoice and then possibly applying out the $200 to it, collecting the rest of it. We might want to have another down payment as the rental equipment is out or something like that or hold on to their first child or something to make sure they give our equipment back. Maybe something like that. But in this case, we're going to go ahead and say we're going to create the invoice. So now we're imagining customer number five comes in and they're like, all right, we need our band equipment that we asked for that we reserved. We can either create the invoice over here with the estimate. Or if I was, for example, to make a new invoice up top for customer number five, like so, like so, and then say this was customer number five. Then QuickBooks is going to say, hey, I'm paraphrasing. We've got this estimate. Do you want to make this invoice from the estimate you made? And we're going to say yes, QuickBooks. That is super helpful. I appreciate the fact that you're able to do that because that's amazing. And so if we go through here, we're going to say there's the 227, everything pulled in from the estimate. So that looks good. Why doesn't this close out? Close out, carrot. And then down here, we've got no sales tax applied. You can see the little links because it pulled over from the estimate and they wanted. And we could just be like, yeah, that we've got your, you got your band set, which has got the two guitars, the drum set and the amplifier. And then you got your two added guitars that you can have. And then we've got the super, the four more amplifiers so that you can really be a super loud. And so there it is. Now, notice they're going to say, hey, I applied the $200 out here, but we don't see it calculated here. But if I close this, I'm going to save it and close it. These books will usually automatically apply. So I'm going to go back into my customer area and then notice that they automatically applied the payment out. So if I go back into the invoice, it now says it's partially paid so I can go back into it. And then if I wanted to print it out at this point in time and give it to the customer or send it out, it has now the item at the bottom of the $200 that the amount that's received. So this is the amount that was charged. This is the amount that we received that has been applied out. And this is the balance that is due. What's this going to do when we record it? It's going to be increasing the accounts receivable because it's an invoice for customer number five. It's going to increase it by the $2,260, not the $2,060 because the $200 has already been recorded. It's already on our financial statements. So this stuff at the bottom isn't really part of our financial transaction. It's for the good of the customer. It's not part of the transaction we're making. The transaction we're making is the $2,260, which will increase the accounts receivable and then net against that payment that we already received resulting in a balance still owed to us of the $2,060 here. And then the other side is going to go to the rental income driven by the items. No tax. No, there's no inventory. There's no cost to goods sold because we're not selling inventory. So let's close this back out. Now notice that they automatically applied out this payment. Let's see what that looks like. If I go into this payment, you'll recall that when we made the payment, it wasn't tied out to any invoice because there was no invoice. So QuickBooks said, hey, we got an invoice that you can tie the payment out to now and they automatically tied it out. If they did not do that, we could go in here and basically tie out the payment to the invoice. So now let's close this out and let's take a look at what happened in the financial statements going over to the big balance sheet. Let's run it to make sure we got fresh stuff that we're working with. And we said we got the AR, the A to the R, the A slash R. So then it's down here on customer five, the 200260. That looks good. Going to go back up top back then to our report. The other side is going to be on the income statement. Let's go to the income statement and make sure it's fresh running it to freshen it up. And now we've got it in our new line item and equipment rental. We didn't have any last month. We got it this month because we started a new revenue stream right here. That's what we did. So there we have it. There's our items there for invoice 1023 going back up back to the report. If we wanted to make the sub ledger, which would tie out to the accounts receivable. Let's do that right clicking on the tab to the right to do it. Let's duplicate the tab because I don't want to remove my trial balance. I want that here too. I want all my reports. Let's add another one. Go to the reports on the left hand side, close up the hamburger, scroll down to the section where people owe you money. And we're looking at the customer balance summary, which in essence is the sub ledger report of the accounts receivable. We're going to do the date change because I'm working in the future here. Custom date at 12. What did I highlight the whole 1231 to two run it? And then we can see with with the customer number five. Did I hit the summary? I'd rather have the detail. Hold on a second. I'm going back in here. I want the detailed report. I want to see stuff happening, not just the ending balance down here. So we're going to who owes you. Let's go to the customer balance detail report. Sorry about that. Let's do it again. Custom date working in the future 1231 to two run it. And then they're just showing me the invoices. I want to see the payments too. So I'm going to, I'm going to customize this report filters down here. Let's do some filtering. And this filter, I want to see all the activity, all the stuff that's going on around here. And so then if I go down to the customer number five, there's the activity. So now we've got the prepayment and the invoice ties out to it. And again, notice how nice that works out from a bookkeeping standpoint. It's still records this negative amount, which isn't great for financial reporting standpoints. But from a bookkeeping standpoint, once I am able to see that it's outstanding, I see a payment that's going to be applied out automatically by the system. And it links to the invoice beautifully and everything ties out nicely. So if I go back to the first tab, I can see that here too by going to the customer tab. I can close up the hand buggy. And if I go down, I can see everything, everything looks like it should here. I got the estimate that happened, the payment that was happening. It was unapplied before. Now I made the invoice. It's applied back out. Everything looks nice from a bookkeeping standpoint, even though you're ending up with that negative receivable when you have the payment as opposed to a positive liability, a problem you can change and fix by simply doing an adjusting entry periodically at the end of the month or the end of the year. So if I then go back to, let's finish this thing out. And by that, I mean, let's imagine that we're now going to receive the payment and then deposit it. So I'm going to go back up top and say, let's hit the, let's go to the first tab, back up top. And we could say we're going to receive the payment obviously right here. I can hit receive payment or I could go up top, hit the plus button and then say we're going to receive the payment, receive the payment. And so I'm going to select that item. Customer number five is going to be pulled up and the QuickBooks should be able to pull up the invoice down below. There it is. Okay. Let's just make this on the 28th now. I'm just going to say cash for practice purposes and it's going to go into the clearing account which used to be called undeposited funds which is now they put in payment to deposit same thing. We're going to then check the invoice that we have down below which was the total amount of $2,260 originally but only $2,060 remaining. That's what we're going to imagine we're receiving at this point in time in the Epic story of get great guitars. So this is going to be increasing the clearing account, payment to deposit. The other side then decreasing the accounts receivable and decreasing the sub ledger for customer number five. Save it and close it. And then let's go to the tab to the right, tab to the right and run it. And then we're going to say we've got now the clearing account which used to be called undeposited funds now called payment to deposit. Now should have another thing in it. Notice the trend that's going up. It goes back to zero, goes up or down, goes back to zero and so on and so forth because it's a clearing account. Now it went up by that $2,060 which will be going back down shortly because we will be depositing it into the bank. The other side should be decreasing the A to the R otherwise known as the accounts receivable A slash R. Rrrrr. Scrolling down. We're going to see that there's customer number five. That looks good. Let's go back up top and go back to our report and then nothing happening on the income statement from this transaction. If we go to the sub report for the customer balance detail report and run it and take a look at customer number five. We see the activity that's been happening here. We had the first payment and then the invoice then the invoice happened and then the second payment. I'm in the wrong area, aren't I? Customer number five is up here. You've got the first payment and then the invoice happened and then the second payment. So everything looks like it's tying out there. If I go back to the first tab and then I close up the hamburger. We're in customer number five. We can see the activity here. I'm going to hold down control, scroll down just a bit. So now we had the estimate that we made the first payment for and then we invoiced and then we've got the second payment and everything, the story is pretty clear just with regards to the documents that are being used, the forms that are being used if you're familiar with those forms. Although the order is a little bit different because of the prepayment. Okay, let's make the deposit now. Let's go to the balance sheet tab and say now we've got this money in the clearing account which is the payments to deposit and we think it's going to hit the bank just with that same number because we're just going to take this money to the bank with one deposit. So let's put that in the bank. We're going to go then to the first tab ham boogie and plus button and then bank deposit. Ham boogie plus button to the bank deposit. Cash account. Let's just put it in there as the 28th. We're just going to check off that one deposit we need to make. We expect it to then hit our books for the amount of 2060 in the cash account as well as the bank statement making the reconciliation easy to do. So let's go ahead and save it and close it and then take a look at the final step that we have just made by going to the big balance sheet. Big balance sheet. So we're going to go then into cash and cash should have this deposit that has now been made. We have made a deposit. I made it from scratch. So we're going to go down here. There is our deposit for 2060 going back up top and the other side the other side of the equation or the T account is in the payments we deposit back down to zero. This is the clearing account formally known as undeposited funds but they got a name change. People got mad at undeposited funds a lot because it's kind of confusing. So they thought, well maybe we'll just change the name. If I change my name no one will be mad at me anymore because I'm a confusing account. So it goes back down to zero just like it should. Clear it back out because it's a clearing account. Not a temporary account mind you but a clearing account which is different. They're different those things. Let's go back to the so that's that. Let's go to the trial balance and just see where we stand at this point in time. I'm going to run it again run it again and this is where we stand. So if you stand like with the same numbers on your left leg and your right leg your debits and your credits then that's good. If not try changing the date range. It's often a date range issue and we'll be looking at the transaction detailed report at the end which is a great tool for diagnosing any differences.