 QuickBooks Desktop 2023, company preferences, sales and customers, and sales tax preferences. Let's do it within 2-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. Get great guitars practice file we set up in a prior presentation. We are continuing on going through the preferences which can be found in the edit drop-down preferences down below, noting it's useful to go through the preferences with a fresh or new company file so you can see what the default preferences are and which of those preferences may need to be changed depending on the particular situations of the company you are setting up. Also note this time we're going to be turning on the sales tax as well and that will be a bit of a longer process than some of the other preferences. I'm first going to maximize the homepage over here and then go to the edit drop-down and go down to the preferences. So last time we went through the reports, let's go to the sales and customers and then we'll hit the big one, the sales tax, which means we're actually going to turn on and set up the sales tax. So we'll go through the sales and customers fairly quickly. My preferences tab up top, add available time costs to invoices for the selected job. So I have it here, the preference default, ask what to do. I'm going to go ahead and keep that as the default preference. Company preferences, you've got the usual shipping method. These are the defaults. We can add a shipping method if we so choose. We've got the warn about duplicate invoice numbers. That's typically a good internal control. So we will keep that. Choose template for invoice packing slips. So what's going to be the packing slip we will use. We're going to keep the default at the into it packing slip. Enable collections center, going to keep that off by default. Custom pricing, no custom pricing. Enable custom pricing. We will keep the default to have it as enabled custom pricing. We're not going to get into a lot of detail with the different kind of pricing and grouping options as you can get through with the practice problem. Maybe we'll focus more on that in future presentations, but we're going to keep the defaults here. OK, let's move to the sales tax. So now we have in the my preferences on the sales tax, nothing here. Company preferences, the default is to, of course, not have any sales tax on because one of the difficulties with the sales tax will be that in the United States, it's going to be different from state to state. It's not going to be a federal tax. So you're going to have to do a little bit more customization when you turn on the sales tax, similar to a usage tax that might be seen in other countries. We're going to have to be charging basically the customers for the tax and then collecting those tax and giving that in some way to whoever's charging the tax, the city and the state. So just a quick recap on how the sales tax works and what needs to be set up for the sales tax. Closing this out real quick. When we make a sale, if we have sales tax typically to run the sales tax properly through QuickBooks, we're going to usually have to use the invoice and the sales receipt as the forms that we'll be selling when we sell things as opposed to just using a deposit form. Now, if you have a system set up where you just want to use the deposit form and you don't want to use the create sales receipt, possibly you can come up with like a manual method to calculate the sales tax. But generally, if you want the system within QuickBooks to properly calculate the sales tax as you made the sale, usually you got to use the forms that are necessary to create the sales invoices and the sales receipts. When you create the invoice and the sales receipt, we're then going to enter items and the items are going to be the things generally which will determine whether or not they will be subject to sales tax or not. That's why you have to use these two forms because they use the items. So that means that when you set up the sales tax, there's kind of three components to the sales tax. You've got to determine who's subjecting you to sales tax, which sales tax are you subject to which will be dependent generally by location in the United States. And then you've got to determine which items are subject to sales tax that you are selling. They're usually in the United States, not usually service items, but usually they are going to be actually goods that are sold to the end user or typically the ones that are most commonly subject to sales tax. So when we set up the items, which will do in a future presentation, this is where the items will be, will say on these items that they'll be subject to the sales tax. And then you also have to think about, are there any customers that are exempt from the sales tax? So in other words, when you create an invoice, then typically you'll have the sales tax turned on, the item will determine whether or not they're gonna charge sales tax on the invoice or sales receipt, but you might have a particular customer that is not subject to sales tax because they're not the end user possibly. And so therefore you could go into the customers and change the default for those particular customers to show that they are not subject to sales tax. Those are the kind of things you gotta think about. So you've got turning on sales tax, you've got then the items that you're gonna have to deal with, we'll do in future presentations, and then you've got the customers which might not be subject to sales tax. Okay, this time we're gonna turn it on, edit dropdown, preferences, sales tax, company preferences, we're gonna say yes, we have sales tax. Then we'll go through these items, let's just kind of review them first and then we'll add the sales tax items here. So it says here set up sales tax item, add a sales tax item for each country, district, parish, et cetera, where you collect sales tax. We'll get back to that shortly. And then it says assign sales tax code. Sales tax codes determine if the item you sell are taxable or non-taxable, taxable item code will be tax, non-tax, non-tax, meaning when we set up our inventory items we will tell the system whether they be subject to tax noting that in that context, the tax we're talking about is not an income tax but a sales tax. So is it subject to sales tax or not, right? These will be what's gonna determine or what it's gonna look like. And then identify taxable amounts as T for taxable when printing. Okay, so that'll give us our code as to whether or not it's subject to sales tax. So when do you owe sales tax? As you invoice date or upon receipt of the payment. So in other words, when are you gonna actually charge the tax? I'm gonna keep this for now. I'm gonna close this out. You must specify the most common. I'll keep that, we won't go out for now. I'll just pull it over here. When we make the sale, if it's an accrual method, then right here, this is when you actually earn the revenue on an accrual basis. And that's usually the form that you're gonna use to create the sales tax, but you didn't actually get paid at that point in time. So maybe in some situations, you might be able to not actually charge the sales tax until you actually get paid because otherwise you can imagine situations where you charged the sales tax, you paid the sales tax, but you didn't actually collect the sales tax from the customer. So when you're setting up the sales tax, you need to determine, do I need to calculate the sales tax at the point of the invoice if using the invoice or can I set it up to wait until I receive the payment before I actually get charged the payable of the sales tax? If you have create sales receipts, meaning you're on a cash basis system, like at a check register, you get paid at the same time, it's not really an issue because you got paid at the same time and that's when the sales tax will be charged. We're gonna keep the default as when you invoice and then the question will be when do you pay sales tax? So note the process that's gonna happen here when you make a sale with an invoice or a sales receipt, you're gonna charge whatever you charge and then you're gonna have to also tack on the sales tax. When you tack on the sales tax, that means you're collecting the money that you get to keep and you're collecting sales tax money that you gotta give to the state or the local government whoever's making you charge the sales tax. So it's gonna have a payable that's gonna go up as you make the sales. So as you make the sales, you're now holding on to this payable that's increasing this liability that's increasing that you need to pay at some future point. The question is when do you have to pay it? Because logistically, clearly, if it's January, for example, you're gonna collect sales all through January, do I have to pay the government every time I make a sale? No, typically you gotta pay, well, they might say you collect all the stuff for January, for example, and then you need to pay it to us by the end of February, right? So you gotta pay all those stuff that you collected in January by February. That would be monthly. If you don't have as much sales tax and it would be dependent on location as well, they might say, well, you just collect sales tax for the whole quarter and then you give it to us by the month after that quarter. That's another way. And if you don't have much sales tax at all, it usually will be dependent upon the state, but also they're gonna be more concerned if you make more sales. If you make more sales and collect more sales tax, more likely they're gonna want their money sooner. If you don't have that much sales, they might say, okay, you could just give it to us quarterly. And if you have small sales, it could be annually. That will be dependent on where you're located, however. Okay, so we're just gonna set up a generic sales tax for our practice problem. I'm gonna try to charge it just at 5% generic so that it's a fairly easy number for us to determine. So let's add our sales tax items here. So we've got, when we look at the items, we've got the sales tax item and the sales tax group. So I'm gonna set up two sales tax items and then group them together because oftentimes you have state sales tax and local sales tax and you could get more complex than that depending on where you are. So we might have multiple sales tax people that are charging us or making us charge sales tax. We have to set up multiple items then and then group those items together so that that grouping will be the code that shows on the invoice or sales receipt. So I'm gonna set up two items and then group them together just for an example. So sales tax item, and I'm just gonna say, this is, let's just call this the state sales tax, maybe California sales tax and then the description will be sales tax. Okay, let's say California sales tax and then the rate, I'm gonna put this at 4%. I'm just making it up. It will be dependent upon where you are located when you're setting up your sales tax items and then the agency, I'm gonna set up a new agency and again, I'm just gonna make up the agency here just for our generic purposes, California sales tax department. This is just a generic vendor that we're setting up that we're gonna have to pay once the sales tax becomes due. This is just a generic problem because it will be dependent, just giving you an idea of how it might be set up so we can get a nice even 4% and the next one for the state or the city will be 1% to get us the 5%. So let's do that. We're gonna say, okay. And then I'm gonna add, I'm gonna say add enough. So if I hit the dropdown now, we've got that one. I'm gonna add another one and this is gonna be another sales tax item and then I'm gonna group them together. So this is gonna be, I'm imagining for the city. Once again, just generic city sales, sales tax. So now I'm imagining that I'm subject also to city sales tax. And then I'm gonna say this is .01 or no, I can't say that it wants me in a percent, 1%. Okay, and then I'm gonna add another vendor because this is gonna go to the city tax collector. So it's called them generic name. It's just a generic problem because it will differ from place to place. So I'm gonna set that up. I'm gonna say, okay. And now I'm subject to paying both of those people. So every time I make an invoice, I have to have those two combined. That's when we're gonna need a group. So the group will look, I'm gonna add a sales tax item and then make a sales tax group. And then the group name is gonna be, I'll just call it California. And city sales tax. And then I'll copy that group name. And then you might wanna make it, obviously you'd make it more specific for the city tax in California, but this is just for the generic tax purposes. So we've got the California tax and then the city tax that I'm choosing here. So now these two taxes, I'm combining them together. They're for, these are two different entities supposedly that are gonna be getting the tax that I'm gonna have to charge for this one group. I'm gonna say, okay. And that's gonna be my default. Your most common sales tax is gonna be my group, the California and cities or California and city sales tax. There it is. So now if I was to say, okay. Make all existing customers taxable. Now the customers, again, you could have the customers that are non-taxable, but I'm gonna make the default that the customers are going to be taxable. And if any customers are not subject to tax because they're not the end user, for example, then we can go in there and change that. So make all existing non-inventory and inventory parts taxable. I'm gonna keep that as the default as well. So when we make the inventory or items, set up our items that we're selling, the default will be taxable and we'll have to say don't be taxable if we want to change that. QuickBooks must close the items. So I'm gonna say, okay. So now if I go into the company dropdown homepage and we made a sales item, like an invoice. So then if it's taxable, here's our taxable items down here. Now, if I entered an actual item, which I haven't set up yet, the item would be determining which of these tax codes would be subject to and it would hopefully be choosing this one by default, which would then make a 5% sales tax. So that's the general idea with the sales tax. Now you can imagine situations where you make sales in different locations and so on and so forth, and you could be subject to all kinds, like different sales taxes throughout the United States. So then you can set up the different groupings depending on who's subject to what and it can get quite complex, but you can see how you can kind of set that system up to hopefully be able to automatically charge the appropriate sales tax when you're doing your business. If you're in one location, then that hopefully will be easier because then you can know who you're subject to sales tax to and set that up and then it should be done basically automatically. So remember that there's a couple components to the sales tax. We just turned the sales tax on. You can also find those if you go to the lists dropdown and you go to the sales tax code. These are the two codes, taxable and non-taxable, that will show when you see the items and if you go to the lists and we go to the item lists, then we've got our sales tax items here. So you can add sales tax items by going to the item dropdown or rise up in essence and you could have new items that you could set up here and continue that process thusly or that way as well, instead of going into the preferences tab to set those items up. You can change these items if I right click on them and edit the item. Then we can make adjustments to the items and so on. Then once these are set up we are then gonna make inventory items. So I can make a new item and call it an inventory or a service item, the things that we sell and so forth. And then say whether or not they're gonna be subject to tax or not. So there's our tax code items. So if they're subject to tax then that means sales tax. That means when I sell an inventory item here with an invoice or sales receipt subject to sales tax it's gonna charge sales tax unless we tell them that that particular customer is not subject to sales tax. All of our customers we said by default will be subject to sales tax. If we have anything that are not even though the item usually is subject to sales tax then we have to say that particular customer is not subject to sales tax. And then hopefully as we make our invoices and sales receipts it'll all be done automatically from that point forward. So we just turned it on this time. We'll get more into sales tax. You know when we start processing adding items we'll talk about sales tax and then when we start making sales we'll talk about sales tax of course and then we'll talk about how to pay the liability as we see that liability accrue as we enter invoices and sales receipts.