 QuickBooks Online 2022, cash payment for inventory linked to purchase order or PO. 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 from the free 30-day trial, holding down controls, 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 go to the accounting view, it's something that you can do by going to the cog up top, switching to the accounting view. We will be toggling back and forth and or taking a look at the accounting view in the sample company file just to get a feel for where different things are located in the different views. Going back on over to our QuickBooks file, we did last time entered purchase orders. We did so by hitting the plus button up top. We went down to the purchase order, the purchase order representing a request for inventory in our case for guitars from the vendors. When we enter the purchase order, we're not actually having any impact on the financial statement that being the balance sheet or the income statement, but whether having a request. In other words, we haven't made a payment. We don't have claim to the actual inventory at that point in time. We expect then the inventory to be received and be received with in essence a bill in it. In other words, we're going to imagine in our epic story about great guitars. We're going to get some boxes of guitars with possibly bills inside of them that are going to request payment. We can enter the bill in our system at the point in time we get them or possibly we can make the payment directly at this point in time, which is what we'll do this time. We're going to enter a check or an expense form paying the bill directly when we receive it being in essence more on a cash basis in that sense. Next time or next month we will then use the bill form to link to the purchase order just to get an example of the two items or the two methods we can use. So first let's open a few tabs up top. We're going to go to the tab up top, right click on it, duplicate that tab. Go to the tab to the left, right click on it again, duplicate it again. Go to the tab to the left, do it one more time, right click and duplicate again. We're going to be opening reports as that is thinking. Let's see where the reports are located in the accounting view jumping over to the sample file in the accounting view reports are on the left hand side in the reports area jumping back on over to the business view. I'm in the second tab, the reports here are located in the business overview area and then we're going to go into the reports section. We'll start off opening our favorite report the balance sheet report. It needs no introduction a report that tells us exactly where we stand at a point in time. We're going to say that the range is going to be 010122 to 123122 and run it. And then we'll go to the tab to the right of it, go back to the business overview this time opening up the PL, the profit and loss, the income statement. It can be called closing up the hamburger and then doing the range change from 010122 to 123122 and running it. Lastly, there's nothing in it by the way that's what we want at this point in time. Lastly, we're going to go to the tab to the right, go back to the business overview and this time we're going to be opening up the trustee trial balance otherwise known as the TB trial balance which doesn't stand for tuberculosis. It's trial balance. That's what the TB stands for, closing the hamburger, doing a range change from 010122 to 123122 and running it. There's the trustee trial balance. Okay, let's go back to the first tab. If we're tracking the purchase orders, I'm going to go back to the 125%. We then could go here. I can go to the get paid area and say let's imagine in our story here that we now have these boxes of guitars that we have received. We can then go into the vendor area if we want to track the purchase order for the guitars. We can say, oh, that box is from Epiphone. We can go into Epiphone and we can see the activity here for the purchase orders and then create a related bill for it or in our case, we're going to try to connect it with a check or expense form or you can track for all the open purchase orders which in this case are not in the same vendor center area as they are in the accounting view. In other words, if I went to the accounting view, if I went into the expenses area, then you've got the same vendor section that we're looking at and you also have this expenses tab which allows us to sort by transaction type for basically the vendor cycle. In the business view, they have stored that under the bookkeeping little calculator tab here instead of in the vendor center area under the transactions which makes sense. It could grow on me. I kind of like it, but it's different. So let's give it a chance for crying out loud. So we're over here in the expenses area and then I can close the hamburger and you can sort it by the purchase orders and then the open purchase orders for example and then apply that and now you can see all the purchase orders that are open which would be a common way to be tracking that information. You can also run a report for the open purchase orders. Okay, so I'm just going to go and open up the hamburger again and let's just open a check type of form assuming that we're just going to, instead of, we got a bill. Now remember there's a difference between a bill that we get in just normal language. We got a bill from the vendor and a piece of paper that's in the box and us entering the bill into the system because I got a bill doesn't mean I need to enter the bill into the system because in our system bill means that we're increasing accounts payable and I'm not going to increase accounts payable. Instead I want to write a check directly. So therefore I got a bill that's a physical bill but I'm not entering a bill into the system. I'm just going to write a physical check because the check is going to be the decrease of the check in account. So you can see the difference in language that you don't use day to day versus these forms which have a very specific meaning. Bill meaning we're going to increase accounts payable and not pay it at this point. Check meaning we're going to decrease the check in account and we are going to pay it and we're going to pay it with a physical check which will have a check number related to it. So we're going to go into the check form here and check that out. It's going to be going from the cash account and the payee. We're going to say it's epiphone. So I'm going to type in epiphone epiphone and notice what it does here that says hey I'm paraphrasing. QuickBooks is like hey we've got these two purchase orders that are outstanding is that what you're paying epiphone for and we're like yeah it is. Let's just add those in directly. We're just going to add those in and I'll add both of them into the same check. Both of them, boom. And there we have it and then we can close that up. So now we've got our check and we've got the check number is 1004. I'll keep that. The date, let's bring it on up to 14, January 14th in our story. So two days later we got the guitars from epiphone that we ordered and notice it's not a category item here because we're not going to apply it to a category. We're not applying it to the inventory account directly but rather we're going to have our inventory items down below. So here's all of our inventory items. I'm going to notice it gives you a little link thing here indicating that it's linked to a purchase order which I believe you can click on. I won't click on it here but it might tie you to the purchase order. Also it's tying in the particular customers for the customers that we had connected to the purchase order, to the purchase orders here. Now before recording this I'm actually going to close it without recording it because I want to take a look at a billable feature just to see how it would apply here and some limitations possibly with it. So I'm going to say, do you want to leave without saving? I'm going to say yes. And then I want to go up to my cog icon up top and just show this billable setting which is in the accounts and settings. And then it's going to be in the expenses area on the left hand side. So we'll be in the expenses area. And then we're going to go on down to the billing and expenses information. So this item here says make expense items billable adds a line item that could allow you to basically make something billable on the expenses. So I'm going to turn that on and then we have the option of marking up with a default. So this would be possibly useful if for example you were entering billable items and as expenses like gas or utilities that you wanted to pull over to an invoice so that you can apply the customer on the bill and pull it over to the invoice and then you can mark it up with a percent markup if you wanted to. So you can say I'm going to pull over my gas fill or something like that and then I'm going to mark it up by some markup percent when I pull it over to the invoice. I'm not going to choose that one here. You can have it track billable expense and items as income. And this is another kind of issue that you would like it to pull in from a billable expense to an income line item generally. In other words, you would like it not to be a reimbursement generally which is one of the problems of not using basically items when you use this billable type of feature. It would be nice that it wouldn't for example have a decrease to utilities if you made something billable but instead had an increase to an income account. You can have it in a single account or in multiple accounts here. I'm going to keep that as is and then you've got the sales tasks. I'm going to keep that where it is. Now this could be nice for the purchase of the inventory but it has a bit of a problem in that I believe it's still going to pull in the cost of the inventory instead of the sales price when we use this kind of billable feature. And that's kind of a limitation here with regards to the connection. So I just want to point, just show you how that could work. And so let's take a look. So I'm going to save that. Let's go save it. And then I'm going to say save and done. And then I'm going to go back in. I'm going to recreate my expense form or my check form hitting the plus button going back into the check form. And let's make our check for epiphone. So I'm going to say epiphone on the check. And so it's coming out of the cash account. Once again, I'm going to purchase I'm going to pick up my two purchase orders to populate it. So that pulls it in for the purchase orders. And so that looks good. And so then it's as of the 14th, we've got our number, check number looks good. And so I think this should have been 104. I'm going to change that for the practice probably 104 on the check number. And then the categories down here. Now epiphone is pulling in the total is at the 3780. So that looks correct. And then these two items I'm going to mark off as billable attempting to tie this bill on over to the invoice that I'm going to create. In other words, when I make an invoice, when I turn around and invoice this item, then I'm going to make it to Eric music and try to pull this information into the invoice. Now I believe there's going to be a bit of a problem though because it's going to try to pull them in at the costs here. And you would think it would be nice. And I believe this works a little bit better on the desktop version for some reason, because if you have the actual inventory items, then you would think it would pull in the income item or the income amount, not the cost amount, which is what we're paying for. The retail amount is what it should pull in. But by using the billable item, I believe it's going to basically pull in the cost amount. So let's just check that out. So I'm going to save it. I'm going to say save it and close it. And we'll enter the invoices later, but just to take a look at it. Now if I was to turn around and say I'm going to sell this with an invoice now to say Eric music, and I was to type in Eric music, Eric music and typing that in, then we've got our information on the right. I'm not going to save this, but if I just add this in, I can see that we have then the rate at the 400. Notice that if I type in actual an ELP guitar, the rate that we're selling it for should be 500, not the 400. And of course I should have made it taxable on the actual bill itself to make it a taxable item. But that's not really the problem here. The problem is the fact that it should be pulling in basically using the item for the sales price. So that billable, you got to be careful with that billable item. The two things that you want to be careful about with the billable item is, one, if you use a billable item, is it charging the proper income account when you pull it in to the invoice? And number two, if you're using inventory, is it charging the right amount on the form in terms of the sales price versus the cost? So we'll take a look at that a little bit more when we get to the invoice. I'm not going to record this at this point in time. Just kind of be aware of that. I'm going to say, do you want to leave without saving? I'm going to say yes. The check, actually, if we go to the balance sheet and see the impact of the check form, we can go into the cash. And we'll, of course, we'll then see the check, which will be a decrease to epiphone. There it is. If I drill down on it, then we're going to have our check form here. So that looks good. So then I'm going to close this back out and then scroll back on up and go back then to my report. The other side did not go to the income statement. It went to inventory. So if I open my inventory report here, then we have our activity for the inventory. And it puts it in here by the individual items on the invoice instead of the lump sum of the invoice. And then I go back on over. We can also look at the sub ledger for inventory because this should tie out to the sub ledger tracking by inventory items since we're tracking on a perpetual inventory system. Let's take a look at the second tab to do that because there's nothing in the profit and loss yet. Open it up the hamburger. Let's go down to the reports, which is in the business overview reports. And let's type out an inventory report, inventory valuation summary, let's say. And then I'm going to close up the hamburger, scroll up just a bit. And now this should reflect what is currently in the system. We're currently at the 39,976. We've got these quantities of our inventory units. 39,976 is the 39,976 here in the balance sheet. Now if I went back on over to the first tab, we can also see that if I went into my transaction at detail information, for example, and so we did that by going into the bookkeeping area and we looked at the expense side of things, closing the hamburger. If I was to filter this by all purchase orders, applying that out, then we've got these purchase orders. And then of course now we can sort it by the ones that have been fulfilled. And so I only want the open purchase orders and scrolling down and applying that, that reduces it down here. So now we're going to say we got another one. Let's say we're going to make a check for the Gibson USA ones. I'm going to open the hamburger. I'm going to hit the plus button and we're going to make another check. We're going to do this with a check form to pay off the bill that we got from the box of guitars from Gibson. So I'm going to type in Gibson USA and tap, tap. And once again, paraphrasing. QuickBooks is like, hey, there's two purchase orders. Do you want to use those to populate the check? And we're like, yeah, thanks, QuickBooks. That's really helpful. So we populate that in there and we're going to say, okay, let's tap through this thing then. And so let's say this is on the 15th. We'll bring it up to the 15th. Check number is checking out. So we're going to go down and say there is the population here. And we got this first one once again that it gives us the reminder of the customer. We could make it billable. I'm going to go ahead and do it. I'm going to make it taxable too, but it's also again going to pull in the amount of the price at cost, most likely when we make the invoice. So we're going to turn around and sell it, but it's probably going to pull that in at the cost. So we got to be mindful of that. I just want to point that out and show that and we'll see it more when we make the invoices. Let's save it and close it and check it out. So we can see here that if we're in our bookkeeping area that we were left with only the one purchase order that's still open. So it filtered that down again. If we go then to the tab to the right, our balance sheet and drill down on the cash account, we're going to see another check that went out for, in this case, Gibson USA. There's the check. I can drill down back to the source document. If we wanted to, going back up top, going back to our balance sheet, we see the other side should be in the inventory. There it is going into the inventory. We've got a purchase. The purchase happening in this case with a check for multiple items. Notice these two checks are adding up to the same amount. They put it in there line by line here for these two lines on the purchase. So I'm going to go back on up top. I'm going to go back and close this out and scroll back up top. Notice just one more thing to notice. I'm going to go in there again that you've got the link. It shows you the link up top with the two linked transactions, which if you click on are the purchase orders, which of course you can then go into the purchase orders to show you that linked transaction which is nice. Closing that back out and scrolling back up top and going back to our report summary. And so let's then go to the inventory report which I think was in the middle. Refresh that one running it. That's at the 46868 now, which should tie out to the balance sheet in the inventory 46868 and it does. So let's do it again. Going back to the first tab. Let's do it one more time. Uno, vase, moss. We're going to say this is going to be another purchase order. I actually know what am I doing? That's not a purchase order. Hold on a sec. This better be the last one because you're losing it man. This is going to be a check. This is going to be a check. That's what we're doing. I know what I'm doing. What are you talking about? I know what's going on here. This is going to be for diamond head. For the ukuleles and once in paraphrasing QuickBooks is like, I have a purchase order. Do you want to add the stuff from the purchase order? And we're like, yeah, we do. Notice the link that populates up top. So you can kind of check out the purchase order if you want to. And then we can tab through this. We'll keep it at the 15 here. We got the check number is on the six. So we can scroll down. We got the ukuleles that pulled in. We're not tying them out to any particular person. We just like to have some ukuleles in the shop in case someone wants to pick one up. Come on in, pick up a ukulele. So we'll save that one, save it and close it. And then obviously nothing is now in our transactions in the bookkeeping area. If I was to go into the get paid and the paid area and search by vendor, I could for example go into the diamond head ukulele area and we could see the detail here which we had a purchase order and we had a check that was linked to the purchase order. If we go then to our reports, holding down control, scrolling up again, once again, checking account is gonna have another check in it. And we're gonna say diamond head, there it is. There's the 72, scrolling back up. The other side on the inventory account, inventory, checking on that, drilling down to the source doc which is a check in this case. Let's check out that check. Shall we? There it is. There's the check there. Checked it out. And then we're gonna go back on up. And we know that the inventory account too will be tying out to the sub ledge or the sub report. You could call the inventory summary, the 469-40. 469-40, let's refresh the inventory valuation. And so there are 469-40 there. The ucs that we have, the DUC ucs at four of them left thus far at this point. Okay, let's go back to the trial balance so we can see everything in one area and just kind of review where we stand at this point in time. This is where we're standing firmly on this trial balance ground. This is our left foot, the debits in the right foot, the credits. And so you can check out where we're at at this point. If you tie out, that's great. If not, check the date ranges to see if the date ranges are the thing that's throwing you off. And we'll then do a transaction detail report at the end of the section, which will be another area that you can use to kind of check where you stand and what might be some differences if there are any.