 QuickBooks Online 2022, pay sales tax. 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 a 30-day free trial, holding down control, scrolling up a bit to get to the one to 5%. We are currently in the homepage, otherwise known as the get things done page. Wanted to change to the accounting view, it is something you can do by going to the cog up top, switch to accounting view down below. We will be toggling back and forth between the two views, either here or by jumping to the sample company currently in the accounting view. Going back to our get great guitars, opening a few tabs to put reports in. Tab on top, right clicking on the tab up top to do so, duplicating it back to the tab to the left, right clicking again, duplicating another time. Back to the tab to the left, right clicking again, and duplicating again as that is thinking. Let's see where the reports are located over in the accounting view, which is on the left-hand side under reports. If we go to the business view, it's a little bit deeper down, but not too far of a dive into the business overview section. Computer still thinking, that's okay, take your time computer. It's in the reports area, reports area, and then we're gonna close up the hamburger. We're gonna open one of the faves here, which is of course the financial statement report. It's still thinking, I hit the wrong reports area. There we go, now we're rolling. And then we're gonna go into the balance sheet, and then we'll do the range change up top from 01012223122 run it, tab to the right, and then down to the business overview, go into the reports, close in the hamburger, go into the PNL, profit and loss, other financial statement reports, changing the range this time from 010122 to 022822, and then doing a month-by-month comparison, running that one, so now we've got January Feb, the total, we're currently on the month of Feb, go into the tab to the right this time, back to that sweet spot of the 125%, go into the business overview, let's type in, close it up the hamburger, and then type in the trial balance so that we can find it. That's what we want this time. The good ol' trustee TB range in the change in up top from 010122 to 123122, that's not right. 123122 is what I said, fingers do what I said when you're typing down there. Everything's gotta work together around here. Okay, so now we're gonna go into the first tab and you'll recall from prior presentations when we've been entering the sales documents, which include the invoices and the sales receipt. If there was sales tax imposed, we've been increasing the account, which would be a sales tax liability account, which they've been putting into the name of a vendor, which in our case, we're in California, sales tax in the United States being something that is applied on a state and local basis as opposed to a federal basis, therefore changing on your location. And they put it in here by the vendor name, the tax authority that we would be paying, California Department of Tax and Fee Administration. Now, of course, we're gonna have to pay that. That's what we're going to do this time. So just a quick recap on the sales tax. If we go to the tab to the left, there's three things that you need to set up to get the sales tax working properly in general. One is gonna be that you have to turn the sales tax on and that's usually the most complex part because you also have to think about, you know, the states and locales that you're gonna be applicable to sales tax and then two, set up your items to be applied out to the sales tax and three, determine if you have any customers that might be exempt from sales tax so that you can name them out even though they might be purchasing something that otherwise would be subject to the sales tax. So a quick recap of that, if we went to the taxes down below, this is where we set up the sales tax in a prior presentation so that sales tax is going to be set up and again, the setup process will differ from location to location and you might be subject to multiple sales taxes and you gotta determine, you know, which agency you're gonna be subject to tax for depending on the type of business that you are doing. Once that is set up, we went to the, to the paid, get paid and pay area, which if you were in the accounting view, by the way, you got the taxes down below, the get paid and pay area would be the sales area up top and we went into our products and services and then when we set up our items, we determined whether or not the items would be taxable or not. You can see the taxable items with the check box here. Typically we're looking at the items that are going to be physical items, inventory units that we're selling to, the income customer in general, most of the time the service items usually not subject to the sales tax and then we thought about the idea that we might have people that we sell something to that would be subject to sales tax but that are exempt for some reason or another and that in that instance, we would have to go into the actual customer, go into the detail for that customer and mark off that they're not going to be subject to the sales tax even if they would otherwise purchase something subject to the sales tax, that's the general concept. Then once we set up the sales tax, let's see what then happens. If I go into a customer, for example, and let's take a look at an invoice, checking out an invoice, is this actually, is this a customer that has, I'd like to see one that has inventory related to it and this one does not. Going out of that one, let's find one with inventory. Let's look at Mr. Anderson. Mr. Anderson's always one of our best customers, got a lot of stuff going on with always up to some mischievous thing. Mr. Anderson, it seems like. So let's go into an invoice. Let's try, this one's has a partial payment. Let's go into this one here and see what we've got. So now we've got an invoice. If I go down, we sold some items subject to tax and you can see the tax calculation down below. Now remember the tax calculation tries to keep adjusting it because we wanted that, we wanted the generic 5%. So I kept on going in here and every time I go into an invoice, it tries to update the tax, but I want the generic 5%, which is gonna be that. So whenever you go into an invoice, it's gonna try to change it if you're using this practice problem. So just be aware of that. And so it would look something like this. Now on the sales tax, what basically happens, we're gonna say that the accounts receivable goes up by the 3,622.50 and then the sales go up by the 3,550. What we charged the sales tax then here is what is increased in the liability account. It's not hitting the income statement. And that's what I wanna stress right now because whether you're doing this yourself or you're working with a client, you can easily imagine a situation where the tax would hit the income statement. In other words, you can say, well, why don't I charge revenue of the 3,622.50 and then I would have a sales tax expense of the expense. And those two things would net out making net income in essence the same as the method we're using now. You might get a question or you might ask yourself the question, if I'm paying sales tax, why don't I have a sales tax expense? And if you always doing taxes, I would think that would be a deductible expense for federal income taxes. The reason you don't have an expense is because we didn't put the income on the income statement. We put only on the income statement what we charged and we're thinking of ourselves in essence as a collection agency. That's what the government in essence thinks of us as the business, we're their tool to collect the sales tax and then give it to the government. So that means that we're not gonna report income because it's not really our income. We're just the collecting agent that is required to collect the tax and then pay it on over. So what's gonna happen now then, if I close this back out, is when we go to the balance sheet, now we've got this sales tax liability account, which would act just like a other liability, like an accounts payable liability. And we of course are gonna make a check, write a check for it and pay it off lowering the liability, lowering the cash account, the checking account. Now that's a fairly straightforward transaction. We could do it with just basically a check and we will end up doing it with a check here or an expense form. But note that normally you would wanna do it through the little widget, which would help us to kinda do the calculation and it would give us a special check saying, hey look, you used a little widget to calculate the sales tax. Also just remember, one of other little wrinkle with the sales tax is that you're gonna collect the sales tax and then determine how often you have to pay it. In other words, in our case, we're imagining that month of January where we went by, we collected the sales tax when we made the sales and now we're gonna pay it by the end of February. So by the end of February, we're gonna pay the sales tax that was accrued upwards in January and then we're still gonna have an outstanding sales tax payable for the sales that were made in February, which we will pay in March. That will depend, that kind of schedule will depend on the level of your sales as well as who's gonna be the tax collector in that area. So you're gonna have to determine how often do you have to pay the sales tax and what's the schedule look like for doing so. So let's imagine we're gonna do the sales tax. Now if I go to the left tab, normally you'd hit the hamburger here and we'd go into the taxes area down below and we've got the sales tax up top. So we'd be in the sales tax and it would be accruing our sales tax here and we can use this system to say this is the sales tax that is gonna be due and go through the process of paying it. But one of the problems of working on the online system where it's in real time is it doesn't really let us jump into the future. So that would for me be jumping into the future and I don't have that capacity here because it's only gonna give me so much range to go up and down. So usually you would want to use the widget here if you were working this type of system with the sales tax so that it will give you a special sales tax calculation type of check that will work within the sales tax system. Although sales tax isn't usually all that complicated if you only have one agency at least that you're paying the sales tax for and so right in the check, we can write the check. So we can't do that here. That's what you would typically want to do. So we're just gonna write a check for the sales tax straight out, write the check. Now we could then look at a report. There's a couple of reports that we can take a look at to see how much would be due. And also I just wanna point out that if I hit the drop down the what we're doing here in order to accrue the sales tax properly you would have to use the sales forms in this method the invoice and the sales receipts those are the reports that are calculating the sales tax if in other words, you were for example just using a bank feeds and using the bank deposit in order to calculate your sales the deposits being the sales then you're gonna have to kind of figure out what your sales tax will be because they're not using the items in order to determine the sales tax. So if you're trying to get to a cash basis system one in which for example you're dependent on the bank feeds and you owe sales tax then you're gonna have to figure out how you can calculate the sales tax within your system. So in any case, now let's say we're gonna run a report let's go to the tab to the right right click on the tab and duplicate the tab and we do have some sales tax reports we can run although we can just look at the general ledger account as well. So we'll look at both methods. Let's go into the reports close up the ham burger and I'm just gonna type in up top sales tax. What did I do? Hold on a second. I clicked on something. I don't wanna go away. Let me do my thing here. Okay, we're back. I don't know what happened. So I'm gonna say then that we want this to be sales tax liability report sales tax liability report. Let's pick that one up and enter that. And then I'm gonna then close out the hamburger and let's do the date range for just January. So 010122 to the 12, let's say 0228. No, let's say 013122 run it. Okay, so that's gonna be the sales tax that we owe or has been accrued upwards in the month of January that we owe in February that we're currently going to pay. You could do that same calculation if I went to the first tab here, for example. And I was to say, okay, let's go up to the balance sheet and say the end date was on 013122 and run that. And you could just see at the end of January we had an amount due that we need to pay in February of the 234385. So there's the same 234385 on this report. If I run this report for the whole time period, 0123122 ending date, we get to the ending point, the 289755. If I go back to the balance sheet and I put in the ending date here of 0123122, run that and scroll on back down. We then get the 289755. You can also think about it as looking at the GL account by going into this item. And this is all the activity that was created from the invoices. So you can see the invoices and the sales receipts, the two sales documents. And if I go down to the end of January, there's the last one that happened in January. Our ending balance right there was the 2343.85, which we're gonna pay in February. And then everything that has accrued upwards in February is gonna be outstanding, which we would pay in March. So let's go back to the tab to the right. Let's type in that this is going to be 022822 and run it. And so that's what we're going to pay. Now I'm gonna write two checks to do this because in California, there's usually you pay the California sales tax and then the city tax. And because that is what is on our bank statement for when we do the bank reconciliation, I need to have two checks to do that. So that's, you can't really see that right here, but that's what we're gonna do to tie into our bank reconciliation. So I'm gonna hit the plus button. I'm gonna write a check. And again, you would normally want to do this with the sales tax widget if we were practicing in real time. But because we're working in the future and this practice problem, or at least I am, I'm just gonna write a physical check. So I'm gonna call this city tax, city tax, California. And I'm gonna set that up as a vendor. That's not the actual vendor. I just made up city tax for California. It's gonna be cash that I'm gonna say. So we'll take that coming out of the checking account. And this is going to happen on, let's go 022822. And then the check number 1020, I will keep that. And then down below, it's gonna go to the sales tax or what do they call it, the department? Oh my goodness. This crazy name that they had up here, which was the California Department of Tax. So it's gonna be california, California Department of Tax fees, blah, blah, blah, blah, blah. And that was for, I'm gonna have two checks. The first one's gonna be for the 1875.08. And again, this, where did I get that number? I got it from my practice problem worksheet that I set up. And the two checks are gonna add up to this total 2897.55. So this is a little tweak, bear with me for it, because that's what we're gonna have for our, we'll need that when we do our bank reconciliation, have it in two different checks. So this is gonna decrease the checking account, decrease that liability account. I'm gonna save and new and do another check for the rest of that component. Save and new and do it again. So this is gonna be, this is gonna be, I'll call this the state sales tax, California, I'm just making that up as the vendor that will be paying. And it's on 228 again, check number. And this is going to, I forgot the account again. It's called California Department of blah, blah, California, California Department. I can't spell California. I've only lived here my entire life, okay? Spelling's not my forte, what do you want from me? So there's the 468.77, that'll get us up to the 2897.55 between the two checks, hopefully. And so let's say save it and close it this time and then see where we end up. Let's go then to the balance sheet on the right-hand side and then go back on over to our reports, holding control, scrolling up a bit. And then we're gonna go down into our liability, California Department. So we've got 55369 left. If I go into that account, hold control, scroll down. We can see then we made the payment down here. We've got the payment at some point. There's the check that we wrote that looks good. And then the other side, of course, what is that? There's the check that we wrote. There should be two checks that we wrote. They spaced them out for some reason. It's because of the alphabetical order within the same date. Okay, they're both there. I see what's happening. And then we're gonna go up top to the cash account. Take a look at it and we see if we scroll on down. Checking it out, we got the two checks there. That looks like it should. No impact on the income statement. So we're not gonna have any sales tax expense on the income statement as we discussed before. If I look at my sales tax reports on the right-hand side, then we can take a look at what should be left then, what has accrued on from 02, 01, 22, to 12, 31, 22, let's say in the month of February on, we only have February, that's 553.7, that has accrued in February, which we're going to be paying off in March. That should match out to what's on our balance sheet. We would suspect or suppose, and if we scroll down, I think that will indeed be the case if I remember 55369 and 55370, we're off by a penny. That's it, I can't take that off by a penny. Okay, that's okay, that's okay, I guess. That's okay, I guess, it is only a penny, right? 55369, 55370, right. Okay, so there we go, the point is no impact on the income statement here because sales tax is going to be off income statement, we didn't record the revenue, we're not going to record the expense, it goes through the payable, and you would want to do it with the widget and practice generally, even though the sales tax, in many cases might not be the most complicated thing to calculate, but it's nice to use the little widget if you're practicing in real time, difficult to do if you're doing a practice problem outside of real time sometimes, so that is that. Let's go on over to the trial balance, see what we stand at this point. Gonna run it, refresh it, here's where we stand. Check out your numbers, if you're following along and you're tying out, then great. If not, try a date range change because sometimes it's a date issue and we'll be printing out a transaction detail report at the end that could be used to diagnose the differences.