Latest / QB Power Hour Podcast / 11.19.24 - Sales Tax in QuickBooks Online
Transcript
- 0:30Dan DeLong: Good morning everyone.
- 0:31Dan DeLong: Welcome to another QB Power Hour.
- 0:34Dan DeLong: Michelle is not joining us today, unfortunately.
- 0:36Dan DeLong: She has a memorial to attend to today.
- 0:39Dan DeLong: So she's not gonna be joining us today, but we do have a great expert panel with us.
- 0:46Dan DeLong: We have Alicia Katz, Pollock, and, spot or You're back.
- 0:53Dan DeLong: Okay.
- 0:55Dan DeLong: didn't know where you went there for, Matthew joining us on our.
- 1:01Dan DeLong: Riveting discussion of sales tax in QuickBooks online.
- 1:06Dan DeLong: I know edge of your seat only is necessary for today.
- 1:11Dan DeLong: But go ahead.
- 1:12Dan DeLong: I'm going to toss the ball over to Alicia to, introduce herself.
- 1:17Dan DeLong: Everybody knows me and Michelle and oh, Hi
- 1:24Matthew Fulton: guys, most everybody here probably knows me as well.
- 1:26Matthew Fulton: Matthew, my friends call me spot, founder of parkway business solutions and QB community live Facebook group and a non lover of sales tax.
- 1:35Matthew Fulton: So this is going to be an exciting conversation.
- 1:39Matthew Fulton: I'm sure.
- 1:39Matthew Fulton: Put a one in the comments if you love handling sales tax.
- 1:42Matthew Fulton: Yeah,
- 1:46Dan DeLong: So Alicia, I forgot to put your bio slide in here.
- 1:50Dan DeLong: I know you're going to talk a little bit about yourself and I'm going to stop sharing for a second so people can see you, but Introduce yourself for those that don't know who in the world you are.
- 2:00Alicia Katz Pollock: All right.
- 2:02Alicia Katz Pollock: My name is Alicia Katz Pollack and my company is Royal Wise Solutions at royalwise.
- 2:06Alicia Katz Pollock: com.
- 2:07Alicia Katz Pollock: And what I do all day, every day is QuickBooks setups, cleanups, troubleshooting, and especially training.
- 2:14Alicia Katz Pollock: And I have a huge training program at learn.
- 2:17Alicia Katz Pollock: royalwise.
- 2:18Alicia Katz Pollock: com.
- 2:19Alicia Katz Pollock: I'm the co host of the unofficial QuickBooks.
- 2:22Alicia Katz Pollock: books, accountants, podcast with Hector Garcia.
- 2:25Alicia Katz Pollock: I've been a top 50 women in accounting.
- 2:28Alicia Katz Pollock: I've been a top 10 pro advisor.
- 2:30Alicia Katz Pollock: And really what my passion is for some reason, I'm just like incredibly, I have this geek love.
- 2:38Alicia Katz Pollock: Thing with QuickBooks.
- 2:39Alicia Katz Pollock: And so I tell to tell everybody how to use it.
- 2:43Dan DeLong: Yes.
- 2:43Dan DeLong: And that's one of the things I think as we unpack sales stack today, it's not as bad as we might as it might get the wrap.
- 2:53Dan DeLong: It's more of just like anything else, it's how you set it up and how you use it.
- 2:59Dan DeLong: Yeah.
- 2:59Dan DeLong: There's some nuances to it and those types of things, but as we'll unpack here that it's not so it's not, terrible.
- 3:11Alicia Katz Pollock: No, it's really not.
- 3:12Alicia Katz Pollock: It's the sales tax module.
- 3:14Alicia Katz Pollock: If you use it it's like dead on accurate, but there's so many different places where you can be using it wrong.
- 3:22Alicia Katz Pollock: And so that's what I'm here to show you is like all the things to watch out for.
- 3:27Dan DeLong: Let me go ahead and reshare my slides so we can do a little housekeeping.
- 3:31Dan DeLong: A little bit about the QB power hour.
- 3:33Dan DeLong: It's every other Tuesday at noon Eastern.
- 3:37Dan DeLong: It's now eligible for CPE credit only on the first one.
- 3:40Dan DeLong: So if you're keeping score at home, this is the second one of the month.
- 3:43Dan DeLong: So unfortunately, our friends at makers hub are not here to KELOLAND dot com.
- 3:46Dan DeLong: Help us with the CPE credit, but Alicia your your, platform does give eligible CPE.
- 3:55Dan DeLong: So that's so if you don't like what you're seeing here today, go over to Alicia's website and you'll you can watch the same thing and get CPE credit for it.
- 4:06Dan DeLong: But a little bit about we have the, some resources, the PDFs of the slides, recordings and podcasts always available at qbpowerhour.
- 4:14Dan DeLong: dot com slash resources and we will share the link for today's handouts as well in the chat and questions.
- 4:25Dan DeLong: So if you have questions today, you're welcome about sales tax or things of that nature specific topics that we're talking about today, please put them in the Q and a, because it will be super helpful for us to follow up with that.
- 4:38Dan DeLong: If we can't answer it live on the webinar today if you have general grumblings, like Matthew said about, I hate sales tax, please put them in the chat, so we'll.
- 4:50Dan DeLong: Meant because it, as it gets scrolls by sometimes it's hard to catch all these things as they go by.
- 4:56Dan DeLong: So if you have a specific question, please put in the q and a general comments.
- 5:00Dan DeLong: Put in the, chat or else I'll hide it on you.
- 5:03Dan DeLong: And then that no one will be able to chat.
- 5:08Dan DeLong: We have a store.
- 5:10Dan DeLong: Please check it out if you have the time.
- 5:12Dan DeLong: No CPE for today.
- 5:14Dan DeLong: It's only the first web webinar of the month for our friends at Maker Sub help out with that.
- 5:20Dan DeLong: And we've got some that's the last slide.
- 5:23Dan DeLong: So nevermind that, but let me go ahead and stop sharing and then I'll hand it, on over to Alicia to kick us off and bring us up here with a sales tax in QuickBooks online.
- 5:35Alicia Katz Pollock: Okay, is my title slide up?
- 5:38Dan DeLong: It is.
- 5:39Alicia Katz Pollock: All right, excellent.
- 5:40Alicia Katz Pollock: What what Dan was teeing me up for is, this session today is really just a synopsis of the essentials of my full sales tax in QuickBooks Online class.
- 5:52Alicia Katz Pollock: I actually have a two hour class with CPE.
- 5:56Alicia Katz Pollock: And so what I'm going to talk about today is understanding how the sales tax module works setting it up, the activities of collecting it, the sales tax center, making payments, and some of the reports now and I saw MB in the chat said what about troubleshooting?
- 6:15Alicia Katz Pollock: Sales tax is wrong.
- 6:16Alicia Katz Pollock: That is what I don't have time to talk about today.
- 6:19Alicia Katz Pollock: And so the con, the continuation of that conversation would be in my course.
- 6:24Alicia Katz Pollock: And I'll give you a link to that at the at the end.
- 6:27Alicia Katz Pollock: All right.
- 6:28Alicia Katz Pollock: That's about me, but we did that already.
- 6:29Alicia Katz Pollock: Dan, go ahead with your first poll
- 6:32Dan DeLong: and all right.
- 6:33Dan DeLong: I'm still trying to share.
- 6:34Dan DeLong: Okay.
- 6:35Dan DeLong: Yes.
- 6:35Dan DeLong: Do you, so do you assist setting up sales tax for your clients?
- 6:40Dan DeLong: So yes, no, or maybe it's just not even in your, scope of expertise.
- 6:49Dan DeLong: So Alicia what, how did you get, like, how did you dive into sales tax and enough to want to teach people how to use.
- 7:00Alicia Katz Pollock: The grand irony is that I live in Oregon and we don't even have sales tax.
- 7:03Alicia Katz Pollock: Yeah,
- 7:04Dan DeLong: I was thinking that too.
- 7:06Alicia Katz Pollock: Yeah, so it's not even an issue for me, but I live right across the river from Washington.
- 7:12Alicia Katz Pollock: And so I have a lot of clients in Washington and I have a lot of clients in Oregon who do work in Washington, which gives them nexus.
- 7:20Alicia Katz Pollock: And so I had to learn the sales tax piece.
- 7:23Alicia Katz Pollock: The rest of it is just because that's my job is to know everything about QBO.
- 7:27Alicia Katz Pollock: And so I can't let This incredibly important topic slide.
- 7:31Alicia Katz Pollock: So I have to dive in on it.
- 7:35Dan DeLong: Yeah, it's definitely something that is a core function if you sell anything which is typically most businesses, right Matthew?
- 7:44Dan DeLong: Exactly.
- 7:45Matthew Fulton: Yeah, sales tax, one of my favorite ones was dealing with a used car dealership down here in Ventura.
- 7:52Matthew Fulton: And that's always a fun item because you have to record sales tax based on where the person's residence is in California.
- 8:00Matthew Fulton: So you've got all these different districts, you're having to break everything out was just always such a major nightmare and we'd have to have our own little worksheets to try to validate it.
- 8:10Matthew Fulton: So it just pushes you in to figure it out.
- 8:13Matthew Fulton: Nowadays, with everything.
- 8:14Matthew Fulton: We have clients all over the place.
- 8:15Matthew Fulton: You just have to know the things.
- 8:17Matthew Fulton: It's tough to stay on top of it all.
- 8:20Alicia Katz Pollock: Really true.
- 8:21Alicia Katz Pollock: And in this poll for the people who are saying no, they don't assist their clients in getting set up.
- 8:26Alicia Katz Pollock: Once you see what we're going to do today, you might want to actually add this into your scope of work and then bump up your rate for doing it.
- 8:35Dan DeLong: Yeah, especially if you're if you're used to.
- 8:37Dan DeLong: Just trying to set it up inside a desktop where the entire burden of knowing all of the things is, on who is setting it up.
- 8:47Dan DeLong: QuickBooks Online assists in some of that process.
- 8:53Alicia Katz Pollock: Exactly.
- 8:53Dan DeLong: Let me go ahead and end the poll and I'll show you the results.
- 8:56Dan DeLong: Looks like 69 percent do, that.
- 9:00Dan DeLong: I had to make sure I didn't just say do.
- 9:03Dan DeLong: Crap, now I did.
- 9:06Alicia Katz Pollock: Yeah, there
- 9:06Dan DeLong: you go.
- 9:07Alicia Katz Pollock: All right, I'm going to go ahead and dive in.
- 9:09Alicia Katz Pollock: Now if you've ever had a session with me, you know that I kind of fire hose you with information.
- 9:15Alicia Katz Pollock: And so you probably will want to go back and watch the recording.
- 9:19Alicia Katz Pollock: I am going to try and cram in as much as I can into the 50 minutes that we have.
- 9:24Alicia Katz Pollock: So you do have the handouts.
- 9:27Alicia Katz Pollock: Dan, you can put the, there it is, there's the handout.
- 9:31Alicia Katz Pollock: All right.
- 9:31Alicia Katz Pollock: So let's talk about what is QBO's sales tax center.
- 9:36Alicia Katz Pollock: Now, if you're coming over from desktop, this is one of the things that's great about it is that there's a, it's almost completely automated and in desktop.
- 9:45Alicia Katz Pollock: You had to put in sometimes a sales tax line to calculate your sales tax manually, and then you had to update your sales tax percentages back in the day.
- 9:54Alicia Katz Pollock: QBO is way more automated, and so you, all you have to do is set up what state you're with what products are taxable and how, and which clients are taxable and how, and then QBO will do all of the math to bring those three factors together and do all of your tracking.
- 10:15Alicia Katz Pollock: So the sales tax is calculated in every single transaction, and the thing that's nice about this is that the rates are updated automatically when there is a rate change up or down.
- 10:25Alicia Katz Pollock: You don't have to go in and fix your QuickBooks.
- 10:29Alicia Katz Pollock: It will automatically do that.
- 10:32Alicia Katz Pollock: One of the questions in the chat is, am I going to be speaking to Canadian taxes?
- 10:35Alicia Katz Pollock: And unfortunately, I'm not.
- 10:37Alicia Katz Pollock: This is specifically for U.
- 10:38Alicia Katz Pollock: S.
- 10:41Alicia Katz Pollock: Okay, so let's talk about how sales tax is calculated, and right now I'm just talking on the big scope.
- 10:48Alicia Katz Pollock: You have to have economic nexus in your state, and so every state has a threshold.
- 10:54Alicia Katz Pollock: Sometimes it's by dollar amount, sometimes it's by the number of transactions, sometimes it's by the dollar amount of the transactions.
- 11:02Alicia Katz Pollock: It also makes a difference whether you're doing work out of your office or whether you're selling off of an e commerce marketplace because if you're selling on Amazon, they're actually going to manage all the sales taxes for you and all the state nexus and then you don't have to do anything.
- 11:18Alicia Katz Pollock: They just draw the taxes and they pay them on your behalf.
- 11:22Alicia Katz Pollock: In most states, services are exempt and you're only paying sales tax on actual physical tangible goods, but that is not 100%.
- 11:30Alicia Katz Pollock: And.
- 11:31Alicia Katz Pollock: Also, some retail sales may have different rates, depending on the region, depending on the product.
- 11:37Alicia Katz Pollock: And there's all of this to think about and all of this to understand.
- 11:43Alicia Katz Pollock: Now, one of the things that's nice is that you'll start by setting up the states where you know you have to.
- 11:49Alicia Katz Pollock: to pay your sales tax, but QBO will keep track of your sales for you and test your economic nexus.
- 11:55Alicia Katz Pollock: And then if you wind up passing one of the thresholds for a particular state, it'll actually give you an alert saying, Hey, you are now eligible to pay sales tax in that state.
- 12:07Alicia Katz Pollock: And the, good news is that once you hit that threshold, that's when you start collecting sales tax.
- 12:15Alicia Katz Pollock: So you don't have to retroactively go back and pay sales tax on sales.
- 12:19Alicia Katz Pollock: That you did not tax it's moving forward,
- 12:23Dan DeLong: but it's unless you pass the threshold and don't set it up And then the state decides to tell you hey, you should have set this up Two years ago.
- 12:32Dan DeLong: And by the way, you owe us back taxes and penalty.
- 12:36Alicia Katz Pollock: Said.
- 12:37Alicia Katz Pollock: Yes, exactly.
- 12:39Alicia Katz Pollock: Okay.
- 12:41Alicia Katz Pollock: Now, the next element is state versus local.
- 12:45Alicia Katz Pollock: Some states just have one tax across the whole state.
- 12:49Alicia Katz Pollock: Others break it up by city or by county or by parish.
- 12:53Alicia Katz Pollock: And QBO knows that.
- 12:55Alicia Katz Pollock: So when you go into your state, if it's California, all you have to do is set up California sales tax.
- 13:01Alicia Katz Pollock: But if you're in, for instance, here, Alabama, you need to actually go in and set up the sales tax for each of these regions.
- 13:09Alicia Katz Pollock: And then QBO will recognize when either you or the client is in those regions and adjust the sales tax accordingly.
- 13:19Alicia Katz Pollock: One of the elements of that is whether the state is origin based or destination based, meaning that some states calculate the sales tax based on your office's address.
- 13:30Alicia Katz Pollock: And that's easy because you just have one sales tax no matter where you are.
- 13:35Alicia Katz Pollock: Some of them are not.
- 13:37Alicia Katz Pollock: Do the taxation based on where the work is being performed, where the client's address is.
- 13:42Alicia Katz Pollock: And that means that you may have to manage sales taxes for all kinds of regions everywhere where your clients are.
- 13:50Alicia Katz Pollock: And when that happens they do it based on the customer's billing address or the shipping address inside your QuickBooks.
- 13:57Alicia Katz Pollock: And I'll say more.
- 13:58Alicia Katz Pollock: About that in a moment.
- 14:02Alicia Katz Pollock: Okay.
- 14:03Alicia Katz Pollock: And because location matters in many states, it's really important that you're gathering the address information of the clients, because if you're, let's say it's an in state client, Tax your local taxes are applied.
- 14:22Alicia Katz Pollock: If if it's origin based, the local taxes are based on the company address.
- 14:27Alicia Katz Pollock: And if it's a destination state, the local taxes are based on the shipping address for the client.
- 14:33Alicia Katz Pollock: So if you have shipping turned on, that's what it's looking to is the shipping address, not necessarily the billing address.
- 14:39Alicia Katz Pollock: So you have to stay conscious of that.
- 14:42Dan DeLong: Somebody mentioned in the Q and a, I'm just going to toss this one out here about, The customer's addresses and their clients and that they had to copy and paste it.
- 14:52Dan DeLong: And that's why, right?
- 14:54Dan DeLong: It's, it has to be in that shipping address field in order for QuickBooks to know where is, where it's actually going.
- 15:02Alicia Katz Pollock: I will address this specifically.
- 15:05Dan DeLong: Okay, perfect.
- 15:06Alicia Katz Pollock: Okay.
- 15:07Alicia Katz Pollock: And then just to mention if it's a state like California where they do their district and their local taxes based on the shipping address, but the county taxes are based on the origin of the transaction, meaning your office.
- 15:20Alicia Katz Pollock: And so there's that hybrid happening, and that's why we love this module because it really does, track all of that for you.
- 15:29Alicia Katz Pollock: It's that rooftop mapping you're talking
- 15:30Matthew Fulton: about, right?
- 15:30Matthew Fulton: Because we have, Westlake Village pretty close to me here.
- 15:34Matthew Fulton: And one part of the town is considered part of Los Angeles County.
- 15:37Matthew Fulton: The other part is Ventura County.
- 15:39Matthew Fulton: So we've all probably got those stories in different states of on one side of the street you have a different tax rate than another side of the street that you have to be aware of.
- 15:47Alicia Katz Pollock: Yeah, everything really matters.
- 15:49Alicia Katz Pollock: I like that, map image that you just gave.
- 15:52Dan DeLong: Yeah, it's like my, next door neighbor when I was a kid went to a different elementary school than I did.
- 16:00Alicia Katz Pollock: Okay, and then the other element is that the invoice date also matters because it tracks rate changes.
- 16:06Alicia Katz Pollock: But then there's also states that have sales tax holidays.
- 16:09Alicia Katz Pollock: For example, in September, August and September back to school.
- 16:12Alicia Katz Pollock: Some states will.
- 16:14Alicia Katz Pollock: Waive the taxes on office supplies so that the kids can go get their office supplies and not pay sales tax on that.
- 16:20Alicia Katz Pollock: So QBO does recognize sales tax holidays in the states where those are eligible.
- 16:28Alicia Katz Pollock: So now we need to set up the sales tax center.
- 16:31Alicia Katz Pollock: And so when you go to the sales taxes, it's in the left hand navigation under taxes.
- 16:38Alicia Katz Pollock: The first thing it's going to confirm is your company address.
- 16:41Alicia Katz Pollock: So this is where it's using the seller's address.
- 16:44Alicia Katz Pollock: Unless it gets overridden with all the other stuff I'm about to show you.
- 16:47Alicia Katz Pollock: So you make sure your address is in there correctly.
- 16:50Alicia Katz Pollock: Then you add in your agencies.
- 16:53Alicia Katz Pollock: If you're converting from desktop, it will match your agencies.
- 16:57Alicia Katz Pollock: But if this is a new file, you'll have to go tell it, these are the states where I am doing business.
- 17:03Alicia Katz Pollock: And then it will know which local and district taxes to apply.
- 17:07Alicia Katz Pollock: You don't need to micromanage it.
- 17:11Alicia Katz Pollock: As I mentioned, there's some states that are home rule states, and so it recognizes which ones have their own sales tax rules.
- 17:18Alicia Katz Pollock: And when you make the payments, it knows, it'll tell you which ones go to what locality or do you, need to, and you do, as I mentioned, have to set up the individual locations if that's part of your eligibility.
- 17:41Alicia Katz Pollock: After you've selected where you are, where you know you have to pay your taxes, then it will ask about your frequency.
- 17:49Alicia Katz Pollock: Depending on your volume, every state has different thresholds, and so maybe you do have to pay every single month.
- 17:55Alicia Katz Pollock: Maybe you have low volume in a particular state and you only have to pay annually.
- 18:00Alicia Katz Pollock: It will ask you on that, and if you're not sure, call your Department of Revenue.
- 18:05Dan DeLong: Is that typically the case where it's based on sales volume dictates the frequency and state by state,
- 18:13Alicia Katz Pollock: it'll actually like right here, it pops up and it's telling you, okay, in Arizona, if you only have 2, 000 in taxes, then you can do it annually.
- 18:23Dan DeLong: Yeah, and that's, based off of the liability, not necessarily the growth sales, right?
- 18:29Alicia Katz Pollock: Yeah, that's the sales tax liability amount, so how much taxes are you going to have to pay?
- 18:33Alicia Katz Pollock: Eh, if it's not that much, then they're not going to make you jump through the hoops.
- 18:37Alicia Katz Pollock: Okay.
- 18:39Alicia Katz Pollock: Then, you also have the ability of making custom rates, and if you are in a state where you have a use tax, maybe you make a custom rate for your use tax.
- 18:50Alicia Katz Pollock: Maybe you have some specialty taxes, like I have a client a gas station in North Carolina, where we had to make a specialty tax for the hot food that he sells inside the gas station deli.
- 19:01Alicia Katz Pollock: So that needed its own special tax rate because he had to pay it to another agency, so we set up an extra one.
- 19:08Alicia Katz Pollock: Also, so you can get creative with it.
- 19:10Alicia Katz Pollock: I mentioned in Oregon, we don't have that.
- 19:12Alicia Katz Pollock: Sales tax.
- 19:13Alicia Katz Pollock: So what, but we do have local taxes where I have to pay a different tax in the city of Portland versus the tri state area next to it versus the rest of Oregon versus anywhere else.
- 19:23Alicia Katz Pollock: So I actually made my own custom rates for those locations so that I could run a report and know exactly how much city tax and Multnomah County tax I needed to pay.
- 19:33Alicia Katz Pollock: So you can get creative with it.
- 19:39Dan DeLong: Another poll.
- 19:40Alicia Katz Pollock: Go for a poll.
- 19:41Dan DeLong: All right.
- 19:42Dan DeLong: So this one is for those of you that do set up sales tags how many jurisdictions do they, do you find that they tend to have?
- 19:51Dan DeLong: Is it one?
- 19:51Dan DeLong: Is it multiple, but less than five or it's, good Lord, it's more than five.
- 19:57Alicia Katz Pollock: Wow.
- 19:57Alicia Katz Pollock: We're pretty even across the board on this one and this just shows you how complicated that is.
- 20:05Alicia Katz Pollock: Yeah.
- 20:06Alicia Katz Pollock: And, you're always better off setting up more than you need if you're not sure if you have Nexus, you might as well.
- 20:14Alicia Katz Pollock: No, I take that back.
- 20:15Alicia Katz Pollock: Nope.
- 20:15Alicia Katz Pollock: Nevermind.
- 20:16Alicia Katz Pollock: That is wrong.
- 20:18Matthew Fulton: Murph actually put in the chat a question and want to make sure I answered it correctly.
- 20:22Matthew Fulton: He was asking, you'd mentioned that when you migrate from a desktop to online, it'll try to match up your sales tax rates for you.
- 20:33Matthew Fulton: So he was asking, QBO first?
- 20:37Matthew Fulton: But if you're doing a migration, my understanding is once you do that migration, it's going to overwrite everything in the file.
- 20:44Matthew Fulton: Anything that you put in there, you'd have to then go in and just try to realign it.
- 20:48Matthew Fulton: I think what you were saying is the automatic ones that exist or pop up, if you have the same things in desktop, that's when it's going to see those the same name and try to establish those for you.
- 20:57Matthew Fulton: Is that right?
- 20:58Matthew Fulton: Yeah.
- 20:58Alicia Katz Pollock: Yeah.
- 20:59Alicia Katz Pollock: And Murph may know some secret sauce that I don't about this, but in general, like you said, when you do a migration, it overwrites everything in the file anyway, so it doesn't make sense to do it.
- 21:09Alicia Katz Pollock: And know that when you are in that that transition period between software desktop calculated it differently, and it's not going to necessarily be in QBO ready to tee up for payment.
- 21:23Alicia Katz Pollock: And so you'll have that transition time of your old sales tax versus your new sales tax that you will have to be conscious of
- 21:30Dan DeLong: without getting too too, deep in the weeds because we want to make sure we, yeah I'm, on here is Desktop and QuickBooks Online handle sales tax fundamentally different, right?
- 21:45Dan DeLong: You've got an item on your item list for sales tax and sales tax groups and the, calculation method and there's no such thing in, QuickBooks Online.
- 21:55Dan DeLong: So there is.
- 21:57Dan DeLong: A path to the automated sales tax, but it's not immediately going to set that up as it goes through because of the way it handles it over instead of QuickBooks online for the automatic.
- 22:09Dan DeLong: All
- 22:10Alicia Katz Pollock: right.
- 22:10Alicia Katz Pollock: So for sake of time, let's go ahead and move forward.
- 22:14Alicia Katz Pollock: I need to at least cover my fundamentals.
- 22:16Dan DeLong: Yeah.
- 22:17Alicia Katz Pollock: Yeah.
- 22:18Alicia Katz Pollock: All right.
- 22:19Alicia Katz Pollock: So the, this poll pretty much across the board is, it was, yeah, even.
- 22:26Dan DeLong: Yeah, multiple but less than five was the was the most.
- 22:32Dan DeLong: All right.
- 22:34Alicia Katz Pollock: Oops, moving on.
- 22:36Alicia Katz Pollock: Sorry, hit your button.
- 22:38Alicia Katz Pollock: Okay, now here's the part where people, most people fall down is that you actually do need to pay attention to the sales tax for each product and service, and if you only have a couple, then okay, but if you have thousands of products and services, this can be a bear.
- 22:59Alicia Katz Pollock: Basically there are exceptions, but retail products are usually taxable, and services may or not, may or may not be taxable, so you have to know that in your particular area.
- 23:10Alicia Katz Pollock: And you can see on the image right here down at the bottom.
- 23:15Alicia Katz Pollock: There's either taxable or non taxable and if you go with the taxable based on location only it's going to just do all the default stuff for general taxability in that location and if something is not taxable for some reason it will still respect that but you mark your products taxable if they are taxable in any way.
- 23:38Alicia Katz Pollock: any circumstance, then you do say it's taxable, and then you let the system correct for whether or not you're going to collect tax in that particular situation.
- 23:49Alicia Katz Pollock: Now where it gets more complicated is that some locations have specific taxes.
- 23:55Alicia Katz Pollock: Some will say this service is taxable at this rate, but this one's taxable at this different rate.
- 23:59Alicia Katz Pollock: Or they have different rates for software, digital goods, communications, medical devices, food and beverages, clothing.
- 24:06Alicia Katz Pollock: Florida, for example, has all kinds of crazy taxes.
- 24:09Alicia Katz Pollock: They have different taxes for hair ribbons and flags.
- 24:12Alicia Katz Pollock: Their commercial real estate rentals are different rate than residential.
- 24:18Alicia Katz Pollock: And you want to go into these products.
- 24:22Alicia Katz Pollock: all of your products, if possible, and see if there is actually a specific subcategory that it's eligible for.
- 24:31Alicia Katz Pollock: For example, in this one if you are selling hunting apparel hunting apparel with blaze orange and reflecting materials, that has a specific tax rate somewhere in the U.
- 24:43Alicia Katz Pollock: S.
- 24:45Alicia Katz Pollock: And if that's what you're selling, check it off so that wherever it matters, it's handled.
- 24:51Alicia Katz Pollock: Same thing here, you can see athletic helmets, aqua shoes athletic clothing suitable for everyday wear, like yoga pants, versus athletic clothing not suitable for everyday wear, like your protection cup.
- 25:04Alicia Katz Pollock: You want to actually go through So you actually want to go through your products and look and see if there is a specific category for it and apply those specific categories, then if the customer lives in that area, then it will give them that specific sales tax rate.
- 25:23Dan DeLong: And it's important to note that these categories, just like you said there, when you said something that was, very specific, just because you see these categories in here does not mean they apply to you in your particular case, because, like you said, somewhere in the United States, Hunting apparel with blaze orange or reflective material has a unique consideration for sales tax.
- 25:48Dan DeLong: Doesn't mean that it does in your particular jurisdiction.
- 25:54Alicia Katz Pollock: And that's where you let QuickBooks make the decisions for them.
- 25:57Alicia Katz Pollock: You just say what is correct and then it will adjust it if needed.
- 26:03Alicia Katz Pollock: Okay, then the next element is that you also have to set your default taxes for, your customers as well.
- 26:12Alicia Katz Pollock: Most of your customers are going to be taxable, but some are tax exempt.
- 26:16Alicia Katz Pollock: Non profits, wholesale with resale, and some Native American reservations some churches, there's all kinds of different taxability.
- 26:29Alicia Katz Pollock: And you can go into every customer as well, and in the customer detail card, there's a section at the bottom to mark whether they are tax exempt, and then you can put in their resale number or their certificate number and keep track of why that customer doesn't pay sales tax.
- 26:48Alicia Katz Pollock: Also, if for some reason you need an override, and honestly, I don't think I've ever really had one of these, where you're selecting a specific tax rate for a customer, then you have that ability also.
- 27:00Alicia Katz Pollock: I'll do that with I was talking about using the custom rates for Oregon, like City of Portland and Multnomah County.
- 27:06Alicia Katz Pollock: That's where I'll go in and say, this customer lives in City of Portland, this customer lives in Multnomah County, and then that will work.
- 27:14Alicia Katz Pollock: Override the tax settings, but in general, you don't do custom rates.
- 27:19Alicia Katz Pollock: You just do based on location.
- 27:23Dan DeLong: Caleb asked in the, chat what about like partial exemptions like farmers in California?
- 27:28Dan DeLong: Is that something that you could do inside of here where it's, I don't know what the rules are.
- 27:33Dan DeLong: So
- 27:33Alicia Katz Pollock: here's, here are some of the list, but not the whole list.
- 27:37Alicia Katz Pollock: And so there's just some that are general.
- 27:40Alicia Katz Pollock: And so you can pick off of the list, I'm not, this is just one section of the whole big list.
- 27:45Alicia Katz Pollock: So I'm not sure Farmers is on it, but if it is, then you would pick it.
- 27:49Alicia Katz Pollock: Or you just mark it exempt because you know that they're exempt.
- 27:52Dan DeLong: And then your exemption details, you can put in their certificate number or anything like that.
- 27:58Alicia Katz Pollock: Okay.
- 27:59Alicia Katz Pollock: And Donna's asking a, question.
- 28:02Alicia Katz Pollock: If she has commercial rental sales tax and product sales tax and has the same agencies, do you need two sales tax items for each?
- 28:09Alicia Katz Pollock: One for rental sale?
- 28:11Alicia Katz Pollock: So, that's where it's different from desktop.
- 28:13Alicia Katz Pollock: You, it's, you set your product.
- 28:15Alicia Katz Pollock: Whatever service you're putting on your invoices, whatever product you're putting on your invoices, that's what you set and tell it what it is, and then QBO will make the decisions for you.
- 28:29Alicia Katz Pollock: So yeah, rental sales would be a different line item than product sales.
- 28:32Alicia Katz Pollock: You have different products, so that's what you set the tax on.
- 28:38Alicia Katz Pollock: Okay, so now let's talk about the ins and outs of using the taxes on your sales forms to collect.
- 28:45Alicia Katz Pollock: And so there's a lot of different places where it matters.
- 28:50Alicia Katz Pollock: So the first one is that if an item is set to be taxable, there'll be a check mark right here.
- 28:59Alicia Katz Pollock: And so that's looking at, yes, this is a taxable item, or no, this is not a taxable item.
- 29:04Alicia Katz Pollock: But I'm going to, tell you something important right here, and that is that toggling this tax on and off is a bad idea.
- 29:14Alicia Katz Pollock: Hypothetically, it works because it turns off the tax on the item, but it doesn't always work on the reports.
- 29:21Alicia Katz Pollock: And they told me they've fixed this, but a couple people have told me it still doesn't work.
- 29:27Alicia Katz Pollock: So if you have a service item or a product that is sometimes taxable and sometimes not.
- 29:33Alicia Katz Pollock: taxable, make two of them, make one the item taxable and one the item non taxable and pick it on the form instead of toggling the check mark on and off.
- 29:45Alicia Katz Pollock: That will save some of your reporting headaches later on.
- 29:49Dan DeLong: Keep the hair where it's supposed to be.
- 29:51Dan DeLong: Yeah.
- 29:52Dan DeLong: Don't pull it out.
- 29:55Alicia Katz Pollock: okay.
- 29:55Alicia Katz Pollock: So that was part one was the taxability on that item.
- 30:00Alicia Katz Pollock: The second is the location of the sale matters and the new invoices handle this more elegantly than the old invoices did where the, you see right now it says location of sale hidden.
- 30:13Alicia Katz Pollock: That's what.
- 30:14Alicia Katz Pollock: The that tells you what taxable region it's using and if you're shipping an item, then make sure you click add shipping info and what that will do is open up a shipping box and then make sure that you have the bill to ship to matching like you can copy pasted or you can go back if it's going to be a more A multi use client, go back to the client card and make sure that their shipping info is in there as well.
- 30:45Alicia Katz Pollock: Whatever is in the ship to will override.
- 30:49Alicia Katz Pollock: All the other location settings.
- 30:52Alicia Katz Pollock: So the ship from is telling you the default.
- 30:55Alicia Katz Pollock: The ship to is, overriding it.
- 30:58Alicia Katz Pollock: On the old ones and on sales receipts, there's also a box on the far right hand side that says location.
- 31:05Alicia Katz Pollock: That's the same as what is now the ship to.
- 31:08Alicia Katz Pollock: From and if you're in one of those sales forms, whatever you want the shipping to calculate, you can copy it and paste it into that shipping location, not shipping location.
- 31:17Alicia Katz Pollock: Sorry, location box.
- 31:19Alicia Katz Pollock: Unfortunately, I don't have a screenshot for it, but that will override it as well.
- 31:24Alicia Katz Pollock: So this is super important.
- 31:26Alicia Katz Pollock: If you're looking at your shipping and it's looking at your tax and it's not calculating right, use that it.
- 31:33Alicia Katz Pollock: Add shipping info box to get your overrides.
- 31:38Alicia Katz Pollock: now down at the bottom we have the select tax rate and it says automatic calculation.
- 31:46Alicia Katz Pollock: That's what you want most of the time.
- 31:48Alicia Katz Pollock: You do not want to override that with something specific to your state or any of those customs.
- 31:53Alicia Katz Pollock: It works best if you just let it roll.
- 31:57Alicia Katz Pollock: So this is what you want.
- 32:00Alicia Katz Pollock: The ideal situation for how you want it to look.
- 32:03Alicia Katz Pollock: And like I said, PebCat, that means problem exists between chair and keyboard.
- 32:08Alicia Katz Pollock: It means you're doing something wrong.
- 32:10Alicia Katz Pollock: This is where, if you need to override the, tax, you do it in that ship to box.
- 32:16Alicia Katz Pollock: Okay, now down in the bottom right hand corner of your invoices and your sales receipts, you also have this little these little arrows.
- 32:26Alicia Katz Pollock: Is your sales tax before or after your discounts?
- 32:30Alicia Katz Pollock: If you take the discount first, get a total, and then you tax that total, then, you want it by default, but if you want to do the tax and then give the discount at the end, you have that option.
- 32:45Alicia Katz Pollock: So use, click that little arrow and it will rotate the two fields.
- 32:51Alicia Katz Pollock: Now, sometimes you're like, how did they, where did that come from?
- 32:55Alicia Katz Pollock: There is a little let me show it to you.
- 32:59Alicia Katz Pollock: Oh, I don't have it on here.
- 33:00Alicia Katz Pollock: There's a little see the math.
- 33:02Alicia Katz Pollock: Oh, there it is.
- 33:02Alicia Katz Pollock: It's right there.
- 33:03Alicia Katz Pollock: Thank you.
- 33:04Alicia Katz Pollock: Where it says, see the math underneath these.
- 33:07Alicia Katz Pollock: When you click on see the math, it will actually open up and tell you everything about where that calculation came from.
- 33:15Alicia Katz Pollock: The customer's not tax exempt, the location of the sale is this address here's the state tax and all of the relevant county, district, parish taxes, and the total rate that's being applied.
- 33:30Alicia Katz Pollock: And then it'll show you the products and services, and if it says uncategorized standard rate applied, then you just have it on that default of taxable.
- 33:40Alicia Katz Pollock: If you had it for hair ribbons, it would show you what that tax rate is, so it shows you exactly where it came up with the logic.
- 33:49Alicia Katz Pollock: You have the ability to override it by clicking on override this amount, but you better have a really good reason for doing that, and if it's So if you have a problem with your settings, you should actually backtrack, go fix it, and then calculate the invoice before you re, before you resend it.
- 34:09Alicia Katz Pollock: Okay, so that's how it's doing all of the all of the calculations.
- 34:15Alicia Katz Pollock: You have complete transparency, but that you have to have three whole different elements all lined up and dialed in to make it work well.
- 34:24Dan DeLong: Yeah.
- 34:24Dan DeLong: It's actually the way I, tend to explain it to people with sales tax is there's four themes, right?
- 34:31Dan DeLong: It's what you sell, who you sell it to, when you sell it and where you sell it.
- 34:37Dan DeLong: And with that sometimes of when do you sell it because there could be a holiday or day that particularly, you know, that changes the whole thing.
- 34:47Dan DeLong: And then as far as how much is calculated based on those categories and those types of things, right?
- 34:55Alicia Katz Pollock: Exactly.
- 34:56Alicia Katz Pollock: That's a great summary.
- 34:58Alicia Katz Pollock: And there's a question in the Q& A.
- 34:59Alicia Katz Pollock: Some items want some customers want items drop shipped to various addresses.
- 35:04Alicia Katz Pollock: That's what the ship to is for.
- 35:05Alicia Katz Pollock: You can put it in that ship to just on that one invoice.
- 35:08Alicia Katz Pollock: It doesn't have to be on the customer's card for forever.
- 35:13Alicia Katz Pollock: Okay, so now the sales tax center.
- 35:16Alicia Katz Pollock: It's super important that you use the Sales Tax Center to pay your taxes.
- 35:23Alicia Katz Pollock: What this is showing you is the current accruals, what's up and coming, what you paid in the past, what's overdue.
- 35:31Alicia Katz Pollock: There are also, there's a button here for the sales tax settings, so that you can adjust your settings.
- 35:36Alicia Katz Pollock: This is also right here, where is the economic nexus tracker, where you can go and see how close you are to hitting your thresholds.
- 35:43Alicia Katz Pollock: In different states, and it's also where you go for the reports.
- 35:47Alicia Katz Pollock: Now, on the screen that I'm on, the reports button is on the left.
- 35:50Alicia Katz Pollock: I think that's just because I had the image shrunk.
- 35:53Alicia Katz Pollock: The reports button is usually over on the right hand side.
- 35:56Alicia Katz Pollock: So here, in this example, I've got Arizona and California, and you can see that Arizona has a green box around it, so right now it's showing Arizona's taxes, and then if I clicked on California, it would show California.
- 36:08Alicia Katz Pollock: California's taxes.
- 36:10Alicia Katz Pollock: And then down below the fold on this, you would see every single month you would see if the tax was accumulated, if it's overdue, if you've paid it, it should all say zeros.
- 36:21Alicia Katz Pollock: And you can also see what is up and coming.
- 36:25Alicia Katz Pollock: When you go into the sales tax button that was over on the right hand side, this is where you can see your automatic sales tax agencies and also the any custom rates that you have set up.
- 36:40Alicia Katz Pollock: There is also a history that's the part down below the fold that I was talking about where you can see.
- 36:46Alicia Katz Pollock: Everything about all of your sales tax payments themselves.
- 36:54Alicia Katz Pollock: Now, the upcoming and overdue payments, those are those rows that we just saw.
- 37:00Alicia Katz Pollock: You first, like I said, click on the state.
- 37:03Alicia Katz Pollock: You can adjust the year.
- 37:04Alicia Katz Pollock: You can see this year and last year, but you can't go before further back than that.
- 37:09Alicia Katz Pollock: I wish you could and then you do want to initiate the sales tax payment from this center.
- 37:16Alicia Katz Pollock: Don't just write a check and then categorize it to the sales tax because it's not going to change these numbers.
- 37:23Alicia Katz Pollock: So you go in and you use this where it says view tax return, and then that will start the process of making the payment, but it doesn't make the payment for you.
- 37:33Alicia Katz Pollock: It's not like payroll tax.
- 37:35Alicia Katz Pollock: You still have to go to your state's department of revenue.
- 37:38Alicia Katz Pollock: In order to pay it, however, they are in the process of working on automated payments through the system.
- 37:46Alicia Katz Pollock: They have rolled it out in North Carolina, and they are working systematically through all 50 states in order of complexity, and so I think it's going to take a couple years, but eventually we're all going to be able to pay the taxes right from this window.
- 38:03Alicia Katz Pollock: Okay so now under the reports, there's also three buttons for tax liability reports.
- 38:11Alicia Katz Pollock: I'll, go show the reports in a few minutes.
- 38:13Alicia Katz Pollock: I've got other stuff I want to talk about first.
- 38:16Alicia Katz Pollock: Okay, so there is a reports button.
- 38:20Alicia Katz Pollock: Okay, now when it's time to make your sales tax payments.
- 38:25Alicia Katz Pollock: So like I said, you click view tax return on the far right hand side.
- 38:31Alicia Katz Pollock: And then you'll get a report up that will show you your gross sales, your non taxable sales, your taxable sales, and the tax amount.
- 38:41Alicia Katz Pollock: Now, I'm The, this, there's also a view tax liability report right down, whoops, I didn't mean to do that down at the bottom of it so that you can actually see this in report format.
- 38:53Alicia Katz Pollock: And when you pay this, it will reduce this tax liability down to zero.
- 38:58Alicia Katz Pollock: to zero.
- 39:00Alicia Katz Pollock: Now that gross sales and non taxable sales and taxable sales are calculated not necessarily off of whether you collected the sales tax or not.
- 39:09Alicia Katz Pollock: And there's a couple of you on this call.
- 39:13Alicia Katz Pollock: Jeff Weathers, I know that you've been battling these reports.
- 39:16Alicia Katz Pollock: And that's because if people are unchecking the sales tax check mark, these reports are actually generated off of how many times did this product sell and how much, how was it taxable or not at the time, which may be different than whether you collected the sales tax or not.
- 39:37Alicia Katz Pollock: And that's why I say if it's sometimes taxable and sometimes not.
- 39:42Alicia Katz Pollock: Make two items
- 39:44Dan DeLong: very similar to payroll forms.
- 39:47Dan DeLong: If you were using a desktop to create payroll forms There are some things on that form that are pulling in data from QuickBooks And there's some things on that form are that are being calculated based on the data that gets pulled QuickBooks So that's an example of those things and I don't want to stress Something that you mentioned and this process here because a tax payment You Inside of QuickBooks is a special transaction.
- 40:14Dan DeLong: And, even though you're physically you physically may be writing a check or doing an ACH going into the bank register and paying your sales tax, that way.
- 40:28Dan DeLong: Is not going to it's not, the prescribed workflow, right?
- 40:32Dan DeLong: And that's, where things get off the rails
- 40:36Alicia Katz Pollock: where
- 40:36Dan DeLong: I've seen people put it to sales tax expense which is never an expense to the company, unless, they're doing it wrong.
- 40:46Dan DeLong: And then there's a fee, associated with that
- 40:49Alicia Katz Pollock: and I'm actually going to get
- 40:50Dan DeLong: through here.
- 40:51Alicia Katz Pollock: Yeah, going with what you just said, one of the things that I want to emphasize is in this history, if you either manually categorize transactions to the sales tax liability or you change any transactions that have already been processed you may go from number from zero back up to some numbers.
- 41:13Alicia Katz Pollock: In here, and I always reconcile my sales tax liabilities to zero to make sure that all the sales tax collected is what was paid and that no sales tax expenses were categorized from the banking feed, as an, that should have been an expense for other reasons that are in there or vice versa.
- 41:34Alicia Katz Pollock: So I always reckon reconcile my sales tax to zero and I keep an eye on these changes.
- 41:40Alicia Katz Pollock: Now, occasionally, I do see numbers pop up back into here, but after I do the research, my sales tax liability is still zero, and I just don't worry about it at that point.
- 41:51Alicia Katz Pollock: I just otherwise, you pay, you start paying sales tax whack a mole, and you'll make a change to make this zero here, and then it'll affect something somewhere else down the line, and it's just not, it's not worth it.
- 42:02Alicia Katz Pollock: You don't have to work that hard on it.
- 42:05Alicia Katz Pollock: But when you are so going back to the conversation about, paying your sales taxes.
- 42:13Alicia Katz Pollock: So after you have when you have this report up, you then go to your Department of Revenue website and you put in these numbers.
- 42:21Alicia Katz Pollock: They'll ask you, how much was your gross sales?
- 42:23Alicia Katz Pollock: How much was your non taxable?
- 42:24Alicia Katz Pollock: Whatever numbers they ask for, they'll tell you what your sales tax is supposed to be.
- 42:29Alicia Katz Pollock: And sometimes it's right on the head, sometimes there's a rounding error, and it's off by a couple cents.
- 42:34Alicia Katz Pollock: But if you find that the number that they're telling you is completely different, then you need to go back and check your settings.
- 42:42Alicia Katz Pollock: now, if it's a small amount, That you are adjusting.
- 42:46Alicia Katz Pollock: There's that link, but, there's this link right here for add an adjustment.
- 42:54Alicia Katz Pollock: And then when you add the adjustment, you'll pick the reason.
- 42:58Alicia Katz Pollock: Was it a sales tax prepayment?
- 43:00Alicia Katz Pollock: Is it a rounding error?
- 43:01Alicia Katz Pollock: And you'll pick the adjustment date.
- 43:03Alicia Katz Pollock: And then you'll pick the account that you are going to adjust to.
- 43:07Alicia Katz Pollock: Now, the thing is that if you're adjusting up, it needs to be an expense category.
- 43:13Alicia Katz Pollock: And if you're adjusting down, it needs to be an income category.
- 43:16Alicia Katz Pollock: I sometimes have two sales tax adjustments or I have sales tax adjustment income.
- 43:21Alicia Katz Pollock: And then I just put the sales tax adjustment expense just in taxes paid or sales taxes paid.
- 43:28Alicia Katz Pollock: And the reason for that is that when, if you If you overcollected, then you have a little bit of extra sales tax, and so that's income.
- 43:38Alicia Katz Pollock: And if you undercollected, you're paying out of pocket, so it's an extra expense.
- 43:43Alicia Katz Pollock: Now, if you're talking just a couple bucks, it's absolutely not worth micromanaging it.
- 43:48Alicia Katz Pollock: But if you're talking, you've got either a consistent discrepancy or large dollar amounts, then you need to go back and double check your systems.
- 43:59Matthew Fulton: A good example of this, and somebody actually has mentioned it in the comments also, is I was helping one client with their sales tax, and their state, if you paid early, you would get a credit back every month.
- 44:10Matthew Fulton: So you always had this trailing credit piece that you had to enter in as the credit to get it to where you could zero out your sales tax payment every single month.
- 44:19Alicia Katz Pollock: Exactly, So after you set these adjustments, the total tax due should now match what it says on your Department of Revenue website.
- 44:29Alicia Katz Pollock: And then you click record the payment, and then it'll give you the, place to say what date and what bank account you're paying out of.
- 44:37Alicia Katz Pollock: And then this should match exactly the amount that comes in from the banking feed.
- 44:42Alicia Katz Pollock: And what this is doing, like Dan said, is this is actually making not an expense, but an actual sales.
- 44:48Alicia Katz Pollock: Tax transaction that is hitting the liability account to zero it out.
- 44:54Alicia Katz Pollock: And then that's what I reconciled together.
- 44:59Alicia Katz Pollock: Okay.
- 45:00Alicia Katz Pollock: Now, Right now, you still do have to pay on your Department of Revenue website, and like I said you, they're still the boss, and so you want to pay what they, say and like I mentioned, they are working on direct pay, North Carolina is up and running I saw another state go by, but I can't remember what it was my question to them is what if we've got these small discrepancies How are you working that out?
- 45:28Alicia Katz Pollock: And I have no answer for that.
- 45:29Alicia Katz Pollock: That remains to be seen.
- 45:31Alicia Katz Pollock: I'm sure they're wondering that themselves.
- 45:35Alicia Katz Pollock: Okay.
- 45:36Alicia Katz Pollock: Now, when what's super important here is that when you see the transaction in the banking feed, you match it to that sales tax payment that was made.
- 45:46Alicia Katz Pollock: I see a lot of pebcax.
- 45:47Alicia Katz Pollock: I see a lot of people will type in and say, This was my sales tax expense.
- 45:52Alicia Katz Pollock: And either they're duplicating it in the sales tax liability, Category or there have an extra expense and then it doesn't reconcile.
- 46:02Alicia Katz Pollock: So always, Pay with the sales tax center, match in the bank feed.
- 46:11Alicia Katz Pollock: Now, something else that is really cool, they just added reminders.
- 46:16Alicia Katz Pollock: When you're looking at the sales tax screen and you're looking at Department of Revenue, you can add a reminder that you can then have it pop up in your reminders, which show up Only in your home dashboard, if you happen to click on it and notice it.
- 46:33Alicia Katz Pollock: But I use reminders.
- 46:34Alicia Katz Pollock: So it's part of my routine.
- 46:37Alicia Katz Pollock: And so you can also have it email you and then you can say, Oh send it seven days before the deadline or remind me again, one day before the deadline so that you don't forget to pay your sales tax.
- 46:50Alicia Katz Pollock: So this was a nice little value added that just showed up a few months ago.
- 46:54Alicia Katz Pollock: It hasn't been there for very long.
- 46:59Alicia Katz Pollock: Okay, like I mentioned I actually, oh, so it was Wisconsin was, the other one.
- 47:06Alicia Katz Pollock: They are beta testing automatic payments.
- 47:08Alicia Katz Pollock: I love this line.
- 47:10Alicia Katz Pollock: We're still working out pricing.
- 47:12Alicia Katz Pollock: We'll let you know before you're charged.
- 47:15Alicia Katz Pollock: Yeah.
- 47:16Alicia Katz Pollock: This goes to that concept that I've been talking about this on my podcast that Intuit is beginning to rethink how they present QuickBooks and now they're thinking about it as what we take for granted as the features, they're now Thinking about it in terms of modules like add-on modules like QuickBooks payments.
- 47:37Alicia Katz Pollock: We just think about QuickBooks Payments as that's how QuickBooks works, but they think of payments as an add-on module payroll is an add-on module.
- 47:45Alicia Katz Pollock: Online bill pay is an add-on module, and now this sales tax payment is also going to be a.
- 47:52Alicia Katz Pollock: Added on module.
- 47:54Alicia Katz Pollock: So they'll, it'll be free for probably a couple of years until they work out the kinks until they've decided it's worth paying for.
- 48:00Alicia Katz Pollock: And all right, I'll get off my soapbox.
- 48:05Alicia Katz Pollock: Okay.
- 48:07Alicia Katz Pollock: Next I want to talk about the different sales tax reports.
- 48:10Alicia Katz Pollock: I already mentioned the basic sales tax liability report, and that's the one that is available right inside the sales tax payment when you go in to make it.
- 48:21Alicia Katz Pollock: And what this does is it breaks down your gross income, non taxable and taxable amounts by state, by city, by jurisdiction by all the counties.
- 48:34Alicia Katz Pollock: So you can see what goes to each place, and then you can click on any one of those and it will show you all of those relevant transactions.
- 48:44Alicia Katz Pollock: So if you're looking at that going, huh, my sales tax is high, you can drill in and then go see huh, why did cool cars pay 175 in sales tax?
- 48:55Alicia Katz Pollock: That's a lot of tax.
- 48:55Alicia Katz Pollock: And then you can go look at the invoice to go do some research on it.
- 49:01Alicia Katz Pollock: Another one is the taxable customer list, and so really it's just a customer contact list, but it's filtered for your customers who are marked as taxable, and for most of you, that's going to be most of you.
- 49:20Alicia Katz Pollock: There's also a non taxable transaction review report.
- 49:24Alicia Katz Pollock: And so this will allow you to see any transactions that didn't have sales tax applied.
- 49:29Alicia Katz Pollock: So you can go, Huh, wait, why didn't I charge them sales tax?
- 49:36Alicia Katz Pollock: And there's a taxable sales summary as well.
- 49:40Alicia Katz Pollock: And this is nice because now you can actually see your now this isn't in the Sales tax center.
- 49:46Alicia Katz Pollock: This is in the reports center.
- 49:48Alicia Katz Pollock: So you go to reports to go find this one.
- 49:50Alicia Katz Pollock: This is cool, because this will allow you to see how much sales tax you collected by product.
- 49:58Dan DeLong: Is this by products inside of QuickBooks?
- 50:01Dan DeLong: Or is this by categories that you've assigned those products?
- 50:06Alicia Katz Pollock: No, this is by the products on your products list.
- 50:09Dan DeLong: Got it.
- 50:10Dan DeLong: Okay.
- 50:12Alicia Katz Pollock: Okay.
- 50:13Alicia Katz Pollock: Now, sometimes QBO's sales tax is not enough.
- 50:19Alicia Katz Pollock: Maybe you do business all the way across the country and you have 50 states that you need to pay tax on.
- 50:27Alicia Katz Pollock: Here are some of the situations when QBO's built in sales tax, automated sales tax module is not sufficient.
- 50:35Alicia Katz Pollock: Again, national sales.
- 50:37Alicia Katz Pollock: Maybe you have international sales.
- 50:39Alicia Katz Pollock: Maybe you have some really complex local taxes.
- 50:42Alicia Katz Pollock: Maybe you're doing e commerce, or sometimes your sales are not recorded through QuickBooks and they're recorded in some other software.
- 50:51Alicia Katz Pollock: So in those cases, you can't use QBO's software.
- 50:54Alicia Katz Pollock: It's not sufficient or it's just too much.
- 50:58Alicia Katz Pollock: Work for you.
- 50:59Alicia Katz Pollock: So the two most popular third party apps are Avalara and TaxJar, which I think was recently bought by Stripe, but both of those are sales tax solutions that you can add into your commerce site or the your POS system or other And then they synchronize to QBO and either you're paying your sales taxes through those solutions or they do the work and you still pay it through QBO depending on your specific situation.
- 51:33Dan DeLong: And the perfect segue is next QB Power Hour, we're actually having Avalara come on to talk about some of their, solutions and how that would actually work.
- 51:43Dan DeLong: Like somebody was mentioning in the chat we have a POS system that's dumping things into, QuickBooks.
- 51:50Dan DeLong: And it's only doing that as one lump transaction.
- 51:53Dan DeLong: So it's really difficult for, QuickBooks online to, parse that out.
- 51:59Dan DeLong: And that's true.
- 52:01Dan DeLong: It is actually going to be pretty difficult when it's in there.
- 52:04Dan DeLong: QuickBooks is pretty good at doing what it's told.
- 52:08Dan DeLong: But if something is telling it to do things the way you don't want it to, then you have to find some alternative solution to do that.
- 52:16Dan DeLong: And this may be a good use case for something like that.
- 52:20Alicia Katz Pollock: Absolutely.
- 52:22Alicia Katz Pollock: Okay, good.
- 52:23Alicia Katz Pollock: Now, some questions have gone by in the chat about what to do about fixing sales tax collection errors, but we only have five minutes left, so obviously I can't go into all of that.
- 52:36Alicia Katz Pollock: And I mentioned that what I just went through today is really just the essentials.
- 52:41Alicia Katz Pollock: of the setup of it.
- 52:42Alicia Katz Pollock: It's not everything that there is to know.
- 52:45Alicia Katz Pollock: You're asking all kinds of good questions that I don't have time to answer.
- 52:48Alicia Katz Pollock: Although I think I'd be able to get a couple of them.
- 52:51Alicia Katz Pollock: So I do have a full sales tax class.
- 52:55Alicia Katz Pollock: That's two hours.
- 52:56Alicia Katz Pollock: It does have C.
- 52:57Alicia Katz Pollock: P.
- 52:57Alicia Katz Pollock: E.
- 52:58Alicia Katz Pollock: And Pick up from here and I go into a what do you do when I forgot to charge my customer sales tax and I'm going to go after them to go get the sales tax or vice versa.
- 53:10Alicia Katz Pollock: What if you charge somebody sales tax but you weren't supposed to?
- 53:13Alicia Katz Pollock: How do you refund them?
- 53:15Alicia Katz Pollock: So I those are two examples of of.
- 53:19Alicia Katz Pollock: The troubleshooting that I talk about in my class.
- 53:22Alicia Katz Pollock: Also, I just told you a bunch of stuff when I teach the class, I actually go into the product.
- 53:29Alicia Katz Pollock: Somebody was just saying where are those reminders in my class?
- 53:33Alicia Katz Pollock: I actually make a reminder.
- 53:35Alicia Katz Pollock: I actually go through and I do the sales tax setup and I go into the products and I do the choosing and I demonstrate everything that I just told you.
- 53:44Alicia Katz Pollock: So that class is definitely like the place to go next.
- 53:51Dan DeLong: Okay.
- 53:52Dan DeLong: Anything, else you on your, slides there?
- 53:56Alicia Katz Pollock: Yeah, just let me do it.
- 53:56Alicia Katz Pollock: Let me do the quick wrap up and then we can either take questions or, go into yours.
- 54:03Alicia Katz Pollock: Here's again that sales tax link.
- 54:05Alicia Katz Pollock: This link over here actually has an affiliate code on it, and that actually gives Dan and QB Power our credit for the referral.
- 54:14Alicia Katz Pollock: And I know I gave you a direct link and a QR code.
- 54:17Alicia Katz Pollock: But if you'll do them the honor of hitting that affiliate link and Dan, if you have any way of pasting that into your webinar chat, then I'd love to share the.
- 54:28Dan DeLong: It is on the, it is on our the landing page that we made for you on our site.
- 54:32Dan DeLong: So if where the handouts are so you can access it right from there as well.
- 54:38Alicia Katz Pollock: Okay, excellent.
- 54:39Alicia Katz Pollock: And I've mentioned my program a couple times.
- 54:42Alicia Katz Pollock: We call it the Royal Wise Owls, which stands for the on demand web based learning solution.
- 54:46Alicia Katz Pollock: And I have an entire learning management platform with over 50 different QuickBooks classes that are from everything from I've never used it before.
- 54:54Alicia Katz Pollock: I'm converting from desktop.
- 54:55Alicia Katz Pollock: I have no idea what's going on.
- 54:57Alicia Katz Pollock: All the way up through deep dives like this in sales tax, and you can take individual classes or I have a whole membership program where the bronze is like the core classes that everybody needs.
- 55:14Alicia Katz Pollock: The silver is access to the full entire library.
- 55:17Alicia Katz Pollock: The gold also includes an hour with me every single month where we can do hands on work inside your books.
- 55:23Alicia Katz Pollock: The all the memberships come with a monthly members meeting.
- 55:27Alicia Katz Pollock: That I call an open mic where people just pepper me with questions until I cry uncle and then the silver and gold actually have a second, we call it a second mastermind meeting and so there's lots of opportunity for community.
- 55:44Alicia Katz Pollock: If you are with an accounting firm, we also do custom branded training portals.
- 55:49Alicia Katz Pollock: If you need to implement train, QuickBooks training at your firm, I can help with that.
- 55:53Alicia Katz Pollock: I do have a partner program.
- 55:55Alicia Katz Pollock: If you want to recommend my classes to anybody else, like you saw, that we can do affiliate links for you.
- 56:00Alicia Katz Pollock: And I also do content licensing as well.
- 56:04Alicia Katz Pollock: I mentioned that I'm with the unofficial QuickBooks accountants podcast.
- 56:08Alicia Katz Pollock: And so definitely check me out.
- 56:10Alicia Katz Pollock: Check us out on your favorite podcasting app.
- 56:15Alicia Katz Pollock: And I think we have one more poll that we have to run.
- 56:18Alicia Katz Pollock: Yeah.
- 56:19Dan DeLong: Really just would these help?
- 56:21Dan DeLong: Was this helpful?
- 56:22Dan DeLong: Did you learn something new?
- 56:23Dan DeLong: I know I did, and I think I know a lot, but one, one of the things I wanted to mention really quickly, Alicia, and I really appreciate you doing this.
- 56:35Dan DeLong: The.
- 56:36Dan DeLong: The sales tax function inside of QuickBooks is entirely hinged in on a sales transaction, right?
- 56:45Dan DeLong: So if you're using something that brings in journal entries or brings in transactions that are not sales transactions, sales taxes, you're going to be, you're going to be frustrated on on using sales tax.
- 57:00Dan DeLong: So I wanted to call that out just to make sure that people Might be importing things in or doing things.
- 57:07Dan DeLong: If it's not on a sale transaction, that sales tax is not going to be calculated properly.
- 57:12Alicia Katz Pollock: That's a really crucial point.
- 57:13Alicia Katz Pollock: So I'm glad that you brought it up.
- 57:14Alicia Katz Pollock: So we're talking invoices.
- 57:16Alicia Katz Pollock: We're talking sales receipts.
- 57:18Alicia Katz Pollock: We're talking also credit memos and refunds also affect sales tax.
- 57:24Matthew Fulton: So the flip side of this as well, which was a question was asked earlier, is now if you also take into consideration where you're buying stuff and if you're paying tax on the purchase or if you're not, and you need to be able to record that to to file your sales tax, like a use tax, so forth.
- 57:41Matthew Fulton: Okay.
- 57:41Matthew Fulton: That's where you have to create your own separate line item, and you'll be putting those on your bills or your expenses, recording the amount there, so then when you go, the sales tax center is only going to show you the actual sales tax, that's owed, you'd pull up the separate report to figure out what your adjustment would be before you finish your filing, basically.
- 58:01Alicia Katz Pollock: Yeah.
- 58:01Alicia Katz Pollock: Now, some of you are in really complicated situations where you actually need to go in and cross reference your reports and make sure that it's all working.
- 58:09Alicia Katz Pollock: And I hear from people, honestly, that it doesn't quite match up sometimes.
- 58:15Alicia Katz Pollock: But for normal routine sales, you're, within spinning distance enough that your, state's not going to care if you're off by three bucks.
- 58:27Dan DeLong: Exactly.
- 58:28Dan DeLong: So I appreciate that.
- 58:30Dan DeLong: That was like a.
- 58:32Dan DeLong: Sandwich mushing of, sales tax.
- 58:35Dan DeLong: Alicia, I really appreciate you joining us today.
- 58:39Dan DeLong: And really unpacking the E I don't know.
- 58:48Dan DeLong: What do you, what are the nuances of it?
- 58:52Dan DeLong: Met a lot for words.
- 58:55Dan DeLong: And, I wanted to really thank you and Matthew for joining us today.
- 59:00Dan DeLong: as we're coming up on Thanksgiving, Having folks like you in this community, willing to, educate the folks that, that need it is, just one of those things that we were talking at, into a connect about just how this community is, so unique.
- 59:21Dan DeLong: That we, being able to lift us up and elevate each other is is fantastic.
- 59:32Dan DeLong: And.
- 59:33Dan DeLong: Just a little thing that I, created from my little AI helpers that I have is a gratitude guided meditation.
- 59:42Dan DeLong: It's totally free.
- 59:43Dan DeLong: You can check it out on on School of Bookkeeping.
- 59:47Dan DeLong: I put it in the chat there.
- 59:49Dan DeLong: You can, it just allows you five minutes of just really Thankfulness, reflectiveness, and guiding your just taking a little break so that sometimes we get so wrapped around the, minutia of things that we're doing each day.
- 1:00:07Dan DeLong: Just really need a, reset and hopefully that's, that, that helps.
- 1:00:13Matthew Fulton: Thank you.
- 1:00:13Matthew Fulton: I'm grateful for it.
- 1:00:16Dan DeLong: And then one last thing I wanted to, I know we're a little over, if you guys can stay, that's totally fine.
- 1:00:22Dan DeLong: We wanted to talk about Michelle.
- 1:00:25Dan DeLong: And as that she is, he is semi retiring and since he's not here and hopefully she's not watching, we can talk about her behind her back.
- 1:00:38Dan DeLong: But what I was hoping to do is the last QB Power Hour this year is surprise Michelle.
- 1:00:48Dan DeLong: And what I wanted to do is, create just a space where you know, people who have had interactions with her or been affected by impacted by, Michelle, I know I have.
- 1:01:02Dan DeLong: A, just a moment to to express their appreciation for for Michelle, and I'm trying to create a, a little, video.
- 1:01:15Dan DeLong: So there's a link that I just put in the chat.
- 1:01:18Dan DeLong: If you want to click on it you can record a little thank you video or just anything that a memory of you with Michelle or impact that, it might had in this, whole service here, we'll create and compile those, those snippets for her and we wanted to share that with her as a thank you for our last Community Power Hour, which will be December Before the holidays, let's see, that's going to be the 17th of of December.
- 1:01:56Dan DeLong: So if you have time on your calendar you can, join us.
- 1:01:59Dan DeLong: Great.
- 1:02:01Dan DeLong: And we'll, make that a little bit more, Pretty flowing conversational.
- 1:02:08Dan DeLong: It may not take the whole hour.
- 1:02:09Dan DeLong: It may take two hours.
- 1:02:10Dan DeLong: I don't know.
- 1:02:14Dan DeLong: Appreciate if you could help us out with with sharing your thoughts about about Michelle and the impact that, that you've had or that she's had over over your career.
- 1:02:31Alicia Katz Pollock: Michelle taught me one of the most important things that I needed to know about bookkeeping.
- 1:02:36Alicia Katz Pollock: I remember it at my first QuickBooks Connect and that was that Opening balance equity needs to be zero, and you zero it out by moving it to retained earnings.
- 1:02:46Alicia Katz Pollock: That fact had escaped me 15 years ago, I did not know that, and I remember, I still actually remember Michelle I have a visual of her saying that, because it was just like, I have work to do.
- 1:02:58Alicia Katz Pollock: Yeah,
- 1:03:02Matthew Fulton: many things learned from her.
- 1:03:04Matthew Fulton: My best memories, of course, are having the opportunity to hang out and talk with her at the different conferences.
- 1:03:08Matthew Fulton: But I want to remind everybody, we're counting on the fact that she's not going to go back and watch this episode.
- 1:03:13Matthew Fulton: So that also means don't go and tell her what we're trying to do.
- 1:03:17Matthew Fulton: We're going to do our best to try to keep this a secret on something that's publicly available knowledge wise, but don't tell anybody.
- 1:03:22Matthew Fulton: So except your friends.
- 1:03:25Dan DeLong: Yeah.
- 1:03:26Dan DeLong: So we want to try to keep it a surprise, but I, It's bound to leak out, but I'm sure she'll act surprised even if she, knows.
- 1:03:38Dan DeLong: Awesome.
- 1:03:39Dan DeLong: All right.
- 1:03:39Dan DeLong: I appreciate y'all joining us here today on the QB power hour.
- 1:03:43Dan DeLong: We'll see you next time.
- 1:03:44Dan DeLong: Again we'll be having Avalara on to talk about a little minutia details about those things that we need help with with a service or software that that can help out with with sales tax.
- 1:03:57Dan DeLong: And we'll see you next time and have a great Thanksgiving, everybody.