 QuickBooks Desktop 2023, bill with inventory connected to PO or purchase order. Let's do it, within two-its, QuickBooks Desktop 2023. Support Accounting Instruction by clicking the link below, giving you a free month 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. Here we are in QuickBooks Desktop, sample rock castle construction practice file provided by QuickBooks going through the setup process, maximizing the home page, going to the view drop-down, open windows to have the open windows list open, reports drop-down going down to the company and financial P&L profit and loss or income statement, tab 0101242123124, January to December, I'm going to increase the font size by going to the customize report, fonts and numbers, change the font, go to 12, okay, yes please, okay, I know I'm doing this quickly, but this is going to be the routine format that we do each and every time here. So we're going to go to the company and financial and then down to the balance sheet standard, change the date to 123124, I believe is the year we want, customizing the report up top, fonts and numbers, change that font size, bring it on up to 12, okay, yes please, and okay. All right, now we got the open windows going back to the home page and we've been considering the vendor section here. So remember that the vendor section represents money eventually going out to someone else, someone who's providing us goods and services that we're using within the business, the easiest way to pay someone else would just to be having electronic transfers, for example, for expenses, which would be like using a check form, but we might be using the bank feeds in that situation, it would be the most easy way to just basically be dependent on the bank feeds, or we might write physical checks in which case we want to write the checks and then we want to let the checks clear and reconcile the checks with a bank reconciliation, or we could move to an accrual process where we enter the bill first, which increases the accounts payable, and then we pay the bill with in essence a check form, but this is going to be a special check that we talked about before that's decreasing the accounts payable, the other side's decreasing the check-in account, and then we added the inventory. So you'll recall last time we entered the purchase order, and now we're thinking about the next step in the inventory process. With inventory, the question will be, do I want a perpetual inventory system or a periodic inventory system? If you have a periodic inventory system, you might not be using the inventory within QuickBooks because that's the perpetual inventory system, and instead, track the inventory outside on said Excel sheet or something like that, where you would count the inventory periodically into the day, into the week, or into the month, and then make your adjustments on a periodic basis. We might talk more about that in a future presentation, or if you want to track the inventory perpetually within QuickBooks, which does add a level of complexity to the process, which we'll talk about a lot more in our sample problem, then you're going to track the inventory. Now, even if you're tracking the inventory, you still might not be using purchase orders because the purchase order would only be used if you have the capacity to request inventory without actually paying for it until you receive it. So you'll recall that if you make a purchase to something like Amazon.com, and you request something that you're going to buy there as an individual, typically you pay for it when you make the purchase, and so you've already paid for it, therefore financial transaction happening at that point in time. The purchase order would be that scenario we are imagining, for example, ordering something from China like 100 cups or something like that, and we have the capacity to request the 100 cups without actually paying for them until we receive it. So then when we receive it, then that's going to be the step we're at here. That's when we enter the bill at that point in time, because now we've got the inventory, and then we're going to pay that bill at a future point in time. So that's going to be the process. In essence, we have a purchase order requesting inventory. We imagine the inventory coming in, let's say, to our warehouse, for example, and then we're going to see we're going to open up the the cups and we're going to see a bill in there with it, and we can compare the the inventory that we received to the purchase order, and then we can enter the bill at this point in time. So let's take a look at some of the open purchase orders. The purchase orders will not be reflected on the financial statements. So to track the open purchase orders, the open requests, we could go to the vendor center, which could be here, or we can go to the vendor drop down vendor center here. We've got the two tabs up top, the vendors and the transactions. If we got a particular receipt of inventory, we can find then that particular vendor, look it up that way, or we might look at all the transactions related to vendors, consider the purchase orders, and then possibly filter the purchase orders by all the purchase orders. This would include the ones that have been fulfilled, or we might search for the open purchase orders. So here are the open purchase orders. Let's look at this first one here, double clicking on that purchase order. So this is what was requested. We sent this out to this vendor and requested lumber the quantity 35 at a rate of 100, and the amount 3500. So now let's imagine we've got that, and we're going to enter the bill for it and increase the inventory. So what I'm going to do is I'm going to copy this. I'm going to close this back out and then go back to my home page so we can see the process. And we've got the purchase order. Now let's imagine we're receiving the inventory here. I'm going to say we've received it with a bill. So that's typical process. I'm going to paste the vendor in here. So there's the vendor and when I hit tab, then it's going to say there's an open purchase order exists for this vendor. Do you want to receive against one or more of these orders? I'm going to say yes. Notice this is connecting for us very nicely. This is a really nice kind of feature. And again, it's a level step up from what you might think of from just an accounting perspective. If you just learned debits and credits as the building blocks of creating the financial statements and like an accounting course or something like that, then you might not really imagine all the added benefits that can come into play with these things that aren't really necessary when you're thinking about just debits and credits to build the financial statements. But clearly from a bookkeeping standpoint, they make the organization a lot easier. So I'm going to say yes. We're going to check off this purchase order. I'm going to say okay. And then it populates our bill for us. So here's going to be the population. We've got the vendor. We've got the date. We've got the address and the amount 1500 that pulled in automatically given by the purchase order. Now notice down here when we looked at the bill before, I'm going to I'm going to close out. It's got the purchase orders to be received one here, just to note I'm going to close this out though. When we looked at the bill before, we got the two tabs down below. The expense tab is the one that we would be using when when we know the expense account or we know the account that we want to be entering the bill for. So if it was like a utility bill or for buying like office supplies or something like that. But if we're buying inventory, we have to go to the items. The items are something we haven't really talked about yet how to set them up. That's going to be a vital point to make the whole process as easy as possible. Once the items have been set up, then this connection process is a lot easier to do with a bookkeeper that might not know all everything about about how the whole system is working, right? That's the point. We want to make sure that we can set things up. So the data input process, whether it be done by ourselves or someone else is as easy as possible. So we'll talk about how to set up the items in future presentations. But the reason they're necessary is because we don't want to just hit an account like inventory, meaning from a journal entry standpoint, you might just say, what's going to happen? Well, there's going to be an increase in accounts payable because it's a bill. The other side, it's going to go to inventory. Why don't I just go over here and type in inventory on the expense side of things because we're tracking on a perpetual inventory basis. And we want to track not only inventory, but the sub ledger of the kind of inventory we have and then use our flow assumptions, which in the QuickBooks desktop is the average flow. You know, there's first in, first out in the weighted average method. If that doesn't make a lot of sense, we'll talk a little bit more about it when we actually go through the practice problems in QuickBooks. We'll dive into that in a bit more detail, but that's the basic ration out. Now, I'm not actually going to record this. I'm just going to close this out. I'm going to imagine what's going to happen though. We're going to increase the accounts payable. The other side is going to go to inventory. I'm going to close this out so I don't add any data to it. And I'm going to say no. And then I'm going to go to the balance sheet. We are in the balance sheet. If I scroll down on the balance sheet, we know we entered a bill, which is an increase to the accounts payable. That's what a bill does. So I can double click on the accounts payable, drilling down on it, changing the first date from 010124. And so there we have it. Now, this first one I don't think was inventory related. I'm going to double click on it, drill down on it so we could see the bill. And we could see it's not inventory related because it's on the expensive side of things, or at least it's not tracking the inventory within the system on a perpetual inventory method. Closing this back out. If I choose like this one here, I think we'll have inventory. If I double click on it, we're going to say, okay, there's the bill. We could see it's got an inventory because it's using the items tab. And so here's the inventory. Now, this particular company is a little bit more confusing with inventory because there's basically two kinds of inventory tracking that you may be in. And you want to make sure that when you're doing bookkeeping, you're understanding kind of the specialties of the fields that you are in. So you could have like a job cost system or one in which the inventory is going to go through the work and process account, meaning you're going to buy raw material. It's going to go through work and process. And then you'll have the finished goods, which typically would be a job cost system, but could also be a process cost system. And then you could have the kind of inventory system where you just buy inventory, you mark it up, and then you sell it. That would be the more easy way for the accounting process because when you buy the inventory, the bill then would just be recording the inventory at the cost, increasing the accounts payable, also increasing the inventory side. And then when you sell the inventory, you're going to have to decrease the inventory, record the expense at that point in time, the cost of goods sold. We'll talk more about the sales side of things when we get to the revenue cycle. So I'm going to close this back out. Notice that we're not going to spend a whole lot of time on a job cost system. I believe we have a course that goes specifically into that if you want to, but that's more of a specialty area as is a process cost system. So those are things to keep in mind in terms of your type of business, what kind of bookkeeping you want to do. If you're a bookkeeper, do you want to specialize in those particular areas? If so, then you got to do some specialized work within them. Okay. And then up top, we've got inventory, which is going to be an asset account. So notice if we're tracking inventory in the system, we are doing an accrual thing at that point in time because if it was a cash based system, we would just be expensing the inventory when we bought it, if we paid cash for it, right? Or whenever we paid cash for it, that's when we would be recording the transaction to inventory. And in an accrual system, how we normally record inventory, we have to go to an accrual system generally because we want to track the inventory on the balance sheet. And then we want to want to record it as an expense, not when we bought the inventory, but when we sell the inventory. So the inventory is going to go up when we buy the inventory for the cost. And then when we sell the inventory, we're going to expense it in the form of cost of goods sold, which we'll talk about next time. And we're also going to have to record the sales price when we sell the inventory. And that's the kind of stuff that the QuickBooks system will help you to do if using a perpetual inventory system, although it does kind of complicate things a bit. You might ask, is it possible for me to just to just expense the inventory when I pay for it, have an easier inventory system? If you don't have that much inventory on hand all the time, like you could try to do something like that, right? You could try to stay on a cash based system. But note that oftentimes your taxes, if you have a substantial amount of inventory, the IRS will want you to be more in an accrual based system with regards to inventory. So you want to make sure to talk to your accountant about your inventory system. And you have one that's appropriate for you. But in any case, if I double click on the inventory and change the first day at 010124, so now we've got the inventory increasing with a bill. So whenever we entered the bill, increases accounts payable, increases the inventory, and then it's going to be decreased with the invoice because the invoice is the sales document that's going to be decreasing the inventory. I'm going to close this back out. Now the reason we couldn't, we have to use that item to record the inventory is because we have related sub ledgers tracking the inventory. So if I go to the reports up top and go down to the inventory and go to the inventory valuation, notice that all other reports other than the balance sheet and income statement are really feeding into or connected to providing more detail about the balance sheet and income statement. I'm just putting the end of the year here. And so there we have it. So now we've got the amounts of inventory here. We've got the average cost. So it's using a weighted average cost, I believe, in terms of a flow assumption, FIFO, LIFO, weighted average. And then this is the asset value, which is at the $30,683.38. That should tie out to what is on the balance sheet, $30,683.38. So that's the general idea. Let's jump back on over to the homepage real quick. So notice when we go through the inventory process, inventory is course going to flow through from the vendor side of things to the customer side of things. So just a quick recap on what inventory is going to do. We're going to request the inventory. If we have a system where we can request before we pay for it, like requesting coffee cups from China or something like that, then that's and that's not going to record any transaction. Then we imagine we get the coffee cups with a bill in it. We're going to make sure we're going to count the coffee cups and compare them to the purchase order to make sure that we got the right order. Then we're going to enter the bill into the system. This records the transaction increase in the accounts payable and it increases the inventory because we had received the inventory at that time with the use of the item, which also increases the sub ledger tracking the items on a weighted average method. Then of course we can pay for the bill in a similar way that we've seen in the past. We might have adjustments that we need to do for inventory from time to time. Possibly we have like over short adjustments, for example. And then in the future, we're going to sell the inventory and notice if you're using inventory, you kind of have to use the sales forms like an invoice or a sales receipt. So even if you're on a cash basis, typically I have to use a sales receipt because if you just use the deposit, then you can't track the items properly generally. So then you record a sales receipt or an invoice and if it was an invoice we'll talk about next time. It would increase the accounts receivable. The other side would be going to sales, but that would be for the sales price. Notice you need that inventory item to know when you enter the transaction the difference between the sales price and when you go to a grocery store that's what you see on the checker, the sales price. But it also needs to know the cost so that it can decrease the inventory that is on the books at cost and record the related expense related to us using the inventory at that point in time cost a good sold. So that gets a little bit more confusing. The sales side of the inventory gets a little bit more confusing because that's when we see the two different plays of the cost and the sales price. So we'll talk about that more when we get down to the customer section. But again, when you look at the inventory cycle, the inventory cycle will be part in the vendor side because we're buying inventory and part in the customer side because of course, we're then going to be selling the inventory.