 QuickBooks Desktop 2023. Enter service items. Let's do it within two weeks. 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. Get great guitar practice file. We set up in a prior presentation going through the setup process we do every time. Maximize on the home page to the gray area. Going to the view dropdown, noting that we have the hide icon bar and open windows list checked off. Open windows open on the left hand side. We're now going to be setting up our service items, those things necessary to make the data input of our sales forms, invoices and sales receipts. As easy as possible so that the financial transactions can be created by them having an impact on the end result balance sheet income statement or profit and loss and the other reports related to it. Now note how sophisticated your items are will depend on the needs of your company, which will depend typically on the industry you are in and how large your company is. So note that you could be in an industry where you have like gig work, you're just getting paid by YouTube or something like that. In which case you might not use the sales forms at all, skip that and just enter the deposits as a deposits possibly using bank feeds recording the other side to income. Now that means that you're going to lose some of the added detail that you get on some subsidiary reports breaking out sales by item, for example. But that might be a worthwhile system if you have a very easy kind of business or industry that you are in like gig work. But you might be in a system where you have a cash register situation where you're imagining someone's entering data into the cash register as you make a sale. And in that case, you're going to need items to help the data input be as easy as possible. You can imagine a situation like a grocery store where you have a checker entering the data, they might not know what the items mean. They might not know the end impact on the financial statements, but they can still do the data input. And we can even do the data input these days with an automatic checkout. But the items and all that has to be set up properly to make that work. And if you're entering an invoice, then that means that you have to basically bill the client that will depend on the industry you're in like a bookkeeper law firm, for example, have to enter the invoice and then track the accounts receivable. If we enter or look at an invoice or sales receipt, we see the items down below the items are the things that we're going to be selecting. So if you imagine someone coming up to the cash register and giving a guitar that they're going to buy, then the item we can find that guitar and that will list out what we're going to charge. So that's how the items are going to work. Now there's inventory items are going to be more complex because they're going to have to track the inventory as we enter the data. Now we're going to be looking at service items, which do not have an inventory component, which will typically be easier. And but you still want to kind of think in detail how you're going to be billing someone. So for example, if you're in a service item like a law firm or like a CPA firm, then you might be saying, okay, the standard billing process. If you were a partner, for example, you enter the time of you and your staff, and then you have a billable rate for the time that you're entering. And that's how you create the invoice. That's one way that you can do it fairly straightforward, easy way, not very sophisticated items that you have to set up that way. But a lot of times the law firms and the CPA firms are using other systems that might be easier to go through the billing process and more transparent to the customers. So for example, for a bookkeeper, you might try to look at using the transaction forms, the transaction detail forms, how many transactions you're making on a monthly basis. And try to bill people by saying, hey, if we enter this many transactions for you, you're within this range, this then is going to be the bill. So you might run a transaction list by date, for example, and count the transactions or export it to Excel and just let Excel account the transactions. And that's a little bit more concrete. And that can actually make the agonizing situation of counting your hours and so on a little bit easier. So you might want to, even if you're in a service area, try to think about what's the structure of your billing process. Is there a way that you can move away from just an hourly billing and try to say, I'm going to bill by what I'm doing. And that could also limit the work. Work just kind of increases over time and you're doing more and more stuff and you're kind of charging in the same amount and whatnot. So that's going to be the work creep or something they call it like that. So in any case, you want to keep those things in mind. Now also note, as we enter these items, we're going to be thinking about the beginning balances that we want to enter into the system. For the items, we have to deal with the inventory items, but we're not going to be entering inventory items of this time. This is kind of the precursor to inventory items, which will have a balance sheet component to it. If we already have inventory on hand, the inventory service items don't have any physical inventory that we need to be tracking. It's just going to be what we're charging for our services in the future. Okay, that said, you might get your items possibly from the prior accounting system. If you have a prior accounting system or you want to then structure what those items will be. And then if you have a prior accounting system, you might be able to export those items, say to an Excel worksheet. So you have a list of those items and then we'll try to enter them into QuickBooks as efficiently as possible. So how can we do that? If we go back into QuickBooks, go to the lists dropdown, we're looking at the item list now. So we have here, these are the sales tax items, which those are also called items because they drive the sales tax calculation. But usually we're thinking in items, the main two things are inventory and service items. Now if I wanted to add a new item, I can go to the items dropdown or rise up because it goes like up and go to new up top. And then I can choose service item or inventory part. So notice service item is a lot less detailed inventory part. I got to enter these sales prices. So we could enter the service items one at a time as we go here, or we could, I'm going to close this out. We could as we enter invoices, I could enter the item as I enter an invoice make a new item just to enter the item on the go as we enter data. Or if we have a bunch of items that were setting up beforehand, which if you're starting a new company file is probably the best way to do it because then you think about the items that you're going to be setting up, then we can enter multiple items. So I'm going to go to the rise up. And I'm going to say that we want to have add edit multiple items, add edit multiple items. Okay, so we're going to do that. And then the the dropdown says do we want service items or inventory parts, we're going to be looking at service items, active service items that what that's what we typically want to see not inactive service items these are the ones that are going to be live ready to go. And then we have the headers up top. So notice it's got item name, sub item sales price income account. Now what I would like to do is customize these headers to match what my data is formatted in. In other words, if I export of these items, for example, from a prior software, I want to tie out my headers with what is in the QuickBooks system so that hopefully I could just copy this data, and then just paste it down here in Excel, or in QuickBooks. So to do that, I'm going to have to, I'm going to have to make sure that I have the the same formatting of sales the same headers up top. So we could go to the customize up top and say all right let's look at this. So on the right hand side we've got the chosen columns so you could so you can see it's in vertical order here, mirroring the horizontal order item name sub item, right item name sub item sales price. And then we have the other available columns on the left hand side. So these are going to be what's required typically we definitely have the have the item name, we might not need a sub item category, the sales price that's what's going to be needed because it's going to be needed to populate. When we make an invoice or sales receipt income account that's going to be the account that will be impacted when we create the invoice and the sales tax code, whether or not it's going to be taxable or not. And then we could have these other items full item name purchase description, we're not purchasing anything that would be more of an inventory part, the cost, there is no cost because it's a service item preferred vendor, we don't have a vendor because we're not purchasing. So these are mainly going for the service item and inactive. Okay, so now let's see if I can mirror this I've got the item name and then the sales description and the purchase description I probably don't need a purchase description, and then the sales price. Okay, so so we've got the item name, and then the sales description so I don't need a sub item so I'm going to put my cursor on this, I can add and remove so I want to remove this one. I'm going to remove. And then I'm going to add the sales description by clicking on this one, and then add, then I'm going to move it up by hitting this item and move it up to the second one. So item name sales description. Okay, and then it's got purchase description which I don't think I need, but I can add it whatever it's not going to hurt. Okay, okay, add the purchase description, move it up. Okay, so then the next one is going to be what's next, where's my Excel sheet. So next we have the sales price and the income account. So now we've got the sales price here, income account. Now I should have the sales tax code, because it's non taxable. So I'm going to I'm going to add one more line to my sheet over here, call it sales tax code. And I'm just going to say non, because none of these are taxable, I think that's the code for it. So I think that'll work. And let's format this with some borders around it. Okay, so now if I go back on over, I say, okay, now I've got the item name, sales description, purchase description, and then sales price. So that looks the same. And it needs to be non tax. Okay, so I should be able to copy this stuff. I'm just going to highlight it now in my Excel worksheet, control C copy, and just drop that in right there, control V, or paste. And I think that looks good. So now notice that my items are kind of generic for this particular company. So I chose like a diagnostic right that seems kind of an unusual thing possibly for our guitar business, we're having a diagnose sounds like a car business or something like that. So these are kind of random items, but bear with me they're they're going to be the sort of service items services not active. So now I get this account right here is not set up. So they've got on the chart of accounts. So if I look at the chart of accounts lists chart of accounts. I look at my income account that I have to assign it to. This is the account that's going to be hit by the service items. When I sell the service items. And notice, we're kind of focusing on selling guitars, which means we're selling inventory. But I also want to look at the service items as well so we can see the distinction between the two. So that's why we made up kind of some service items so we can see the two. So in other words, when I make my invoice or sales receipt, this is going to increase accounts receivable. The other side is going to go to some income account run by the item. So I have to set up my income account. So here in my chart of accounts sales is usually what we use when we're selling to a inventory. So we might want to say service item income or something like that. So let's just make one here. I'm going to hit the drop down or rise up. And I'm going to say a new I need a new account. I'm going to make it an income account. That's important. That's the type of the account. Next, and I'm just going to call it a service revenue service revenue or service income just a generic name. I'm not going to name each service that I do, because if I do this properly, I should have sub accounts that will then further break down by item. So I don't want to have all everything I do broken down into item by item on the income statements. That's a key component because sometimes people fall into that trap. I don't want to break it out by customer or have too many customer accounts on the income statement, right, or any, or too many. I just want the full categories of what I'm selling. And then the sub accounts or the sub ledgers, the other reports will give us more detail. All right, save it. So there we have it. Hopefully I spelled that right. If I didn't, I apologize. And then I'm going to change these to service revenue. And service is not an active account. I know that's why I'm changing it. QuickBooks. That's why I'm trying to fix it. Service revenue. Okay, and then service revenue. Okay, so there we go. So there we have it. So we got diagnostics. $68. It's non taxable, meaning we're not subject to sales tax because in the United States, services usually are not. We'll have to deal with sales tax when we get to the the inventory hourly service one, whatever that is, that's pretty generic. But you know, that's what we're going to do with our practice. And then hourly service to is $100. And then the tuning support. So this is tuning support. We charge a lot to tune your guitar. Let's give you some fancy tuning. You've never seen the way we tune the guitar. It's like some ancient tuning method. Okay, so then we're going to say let's save it and close it. And zero items recorded have been saved. Okay. And so there we now for some reason it gave me an error to add an expense account which I shouldn't need because because these are service items. And so but I chose an expense account I customized and I added the expense account from here on over. So I removed it. I add the expense account. And then I chose the expense account of cost of goods sold. Nothing should be going to cost of goods sold because these are service items. And we're not buying and selling or tracking any inventory. So I'm not sure why it required that but I'm going to say and then say save and changes. Then if I go back on over. Now we've got these items set up. So we've got these. This is in our items list chart of account item list right here. And so now I'm sorry lists items list. Okay, so there's our diagnostic and there's our items now if we wanted if we wanted to adjust any of these I can right click on it and edit the item. And then you can see it on a single item mode where we've got the name the sub item if there were one. And then we've got The cost there is no cost and then the sales price at the 68 Notice that this being checked off this service is used in a simple is or is performed by subcontractor. That's kind of why we've got this description we shouldn't we don't need that for this particular item. So I can uncheck that and then you've got a more simplified field here. So that's probably why they needed the expense field. I'm going to say okay, not sure exactly why. Edit. I'm going to edit this one edit the item. So again I don't really need these. I don't think it'll make a difference, but I'm going to uncheck that right click edit the item uncheck that Just so it's it's simple when we go in there and look at it. And then this one. I'm going to edit that item and uncheck that here. Okay, so then when I record something Tuning I spelled wrong great. That's great. Tuning whatever I'm going to I'm going to just keep it. So bear with me on that if it's spelled wrong. That drives you crazy. I'm sorry. We're going to go back to the home. Now when I enter something into an invoice, Then I now I can just choose the item. So whatever we did, we should be able to choose it again. These are kind of generic items. But but if I did a diagnostic, we should be able to come up and just be able to plug that in for someone that doesn't know anything about the item. The rate should pull up and I can just enter that into the system as quickly as possible. Either entering an invoice, which will then increase the accounts receivable other side go into that service income. No sales tax being taxed on it. Or if I entered a sales receipt, like at a cash register, again, I can choose whatever item would be applicable and be able to charge. No sales tax being applicable because this item doesn't have sales tax applied to it. And then of course, again, if you if you don't need the items and you're waiting for an electronic transfer from like a YouTube or some gig work, Then if you enter like a deposit, you don't have the same item component. But by not using the items, by not using the sales receipt and the invoice, you lose some of the added detailed reports you might otherwise have, Which would be the sales by customer and sales by item reports. So next time we'll we'll do a similar thing with the inventory items, which is a bit more complex because we have to deal with sales tax. And we have to deal with the cost of the of the inventory as well as the sales price. Think about the purchasing side as well as the sales side. Think about entering the bill or the check as well as creating the invoice and the sales receipts, the items being involved in those processes.