Latest / QB Power Hour Podcast / Making Bulk Edits in QuickBooks [5.26.26]
Transcript
- 0:22Dan DeLong: Welcome everybody to another QB Power Hour.
- 0:25Dan DeLong: Hopefully those of you that were in the waiting room got the full experience of the video because we're not gonna be having the video play while I'm trying to figure out how to From advance the slides.
- 0:41Dan DeLong: Let me know if if that worked well.
- 0:44Dan DeLong: Put it in the, put it in the chat or, something like that because we wanna get started with the content today because we have a lot to talk about.
- 0:54Dan DeLong: And we might even get
- 0:55Sharrin Fuller: to- Oh, yeah, Intuit keeping us active over here.
- 1:01Dan DeLong: Yeah, and Anna Burke is,"What video?" So that d- that doesn't sound promising, Sharrin.
- 1:07Sharrin Fuller: It's, so it was just the doo doo-
- 1:10Dan DeLong: Yeah
- 1:10Sharrin Fuller: Doo.
- 1:11Sharrin Fuller: Join our communities and find us over here, and- you don't get CP for this anymore.
- 1:17Sharrin Fuller: So all right, no one saw it.
- 1:18Sharrin Fuller: Yeah.
- 1:19Sharrin Fuller: You and I will have to test it later.
- 1:20Sharrin Fuller: It's okay.
- 1:20Sharrin Fuller: We'll
- 1:21Dan DeLong: have to test it.
- 1:21Dan DeLong: Okay.
- 1:22Dan DeLong: So yeah, the little intro video that, that starts when we're, when we start the Power Hour talks about the housekeeping and all of that stuff, and that should be playing in the waiting room as you're waiting.
- 1:37Dan DeLong: Now, if you just got here and you weren't sitting in the waiting room, then you wouldn't see the video.
- 1:43Sharrin Fuller: Yeah.
- 1:45Dan DeLong: We'll tech- we'll check
- 1:46Sharrin Fuller: it out.
- 1:46Sharrin Fuller: Hold on.
- 1:47Sharrin Fuller: In case they missed it, doo- doo Doo, doo.
- 1:52Sharrin Fuller: Pretty- very nice
- 1:54Dan DeLong: Am I on?
- 1:54Dan DeLong: You, are.
- 1:54Dan DeLong: All right.
- 1:55Dan DeLong: You are.
- 1:55Dan DeLong: You, you- All right you've been around, you've been around the QB Power
- 1:58Sharrin Fuller: Hour.
- 1:58Sharrin Fuller: I'm on YouTube.
- 2:01Sharrin Fuller: Lisa was in the waiting room for 30 minutes.
- 2:04Sharrin Fuller: Damn.
- 2:04Dan DeLong: Whoa.
- 2:05Dan DeLong: L- so Lisa, did you see the video?
- 2:08Sharrin Fuller: Yeah.
- 2:08Sharrin Fuller: Or do you- Apparently not, but Lisa- Okay.
- 2:11Sharrin Fuller: All right.
- 2:12Sharrin Fuller: Go ahead, Dan.
- 2:12Sharrin Fuller: Do your thing.
- 2:12Dan DeLong: Yeah, okay.
- 2:13Dan DeLong: Today we're gonna be talking about making bulk edits in QuickBooks.
- 2:17Dan DeLong: We'll talk a little bit about desktop, and we'll talk a little bit about QuickBooks Online, but we'll talk about some of the ways to make mass changes inside of QuickBooks.
- 2:28Dan DeLong: We do wanna shout out, since apparently the video didn't say that we do have some spotlight sponsors, and this is how it keeps the QB Power Hour free for all the attendees.
- 2:40Dan DeLong: Please check them out and support them.
- 2:44Dan DeLong: Now, if you wanna connect with Sharrin and I and not get so interruptive back and forth because we don't rehearse the QB Power Hour- I
- 2:54Sharrin Fuller: don't even look at the slides, you guys.
- 2:56Sharrin Fuller: I have no idea what we're talking about till it's in my face.
- 2:59Sharrin Fuller: I'm not gonna lie here.
- 2:59Sharrin Fuller: Dan is the, Dan lifts, I show up.
- 3:02Sharrin Fuller: That's it.
- 3:04Dan DeLong: But if you wanna- So if you wanna connect with us on an uninterrupted basis we each have our own communities.
- 3:10Dan DeLong: What is your what is your commu- and I know it's Clone Conquer, but what is- Fix Businesses, Dan what is the takeaway?
- 3:16Dan DeLong: I
- 3:16Sharrin Fuller: get owners unstuck.
- 3:18Sharrin Fuller: If you're stuck and you can't get out of it, and you're like,"I don't even know.
- 3:21Sharrin Fuller: Do I hire?
- 3:21Sharrin Fuller: Do I fix something?
- 3:22Sharrin Fuller: Do I bring in tech?
- 3:23Sharrin Fuller: And if I do, I can't even do it," I help you get out of that.
- 3:26Dan DeLong: So it's advising the advisor.
- 3:29Sharrin Fuller: I have a community, and I do one-on-one advisory.
- 3:32Dan DeLong: Excellent.
- 3:33Dan DeLong: And then mine is more focused on getting the most out of QuickBooks, right?
- 3:37Dan DeLong: Yes.
- 3:37Dan DeLong: So if you have some questions or concerns about,"Oh, I want to get more out of QuickBooks or make things more efficient," that's where that's where School of Bookkeeping comes in.
- 3:48Dan DeLong: We are...
- 3:49Dan DeLong: If you're joining us for the first time, we have changed a little bit about the QB Power Hour, and we've made some categories of our of our w- webinars, so we have different ones in there.
- 4:07Dan DeLong: We've also made individual registrations.
- 4:11Dan DeLong: If you're still part of the recurring one, that's gonna expire after next time.
- 4:16Dan DeLong: So if you're tired of getting two alerts from me that- I
- 4:22Sharrin Fuller: get four, just saying.
- 4:26Dan DeLong: And I get, at least 16 so- Okay so so I'm, I'm-
- 4:30Sharrin Fuller: You're four times better than I am, Dan, when
- 4:32Dan DeLong: all those- I'm eating my own dog food when it comes to- when it comes to updating myself, that's gonna expire after the next one to- so hopefully everybody got the memo now that we've moved over to individual registrations.
- 4:48Dan DeLong: You can check out those on our website and put them on your calendar as well.
- 4:54Dan DeLong: So today we're gonna be...
- 4:56Dan DeLong: Hopefully, we get past the Intuit news part.
- 4:58Dan DeLong: And
- 4:59Sharrin Fuller: I- Oh, you started with that.
- 5:01Sharrin Fuller: Oh.
- 5:01Dan DeLong: Yes.
- 5:02Sharrin Fuller: Smart.
- 5:03Dan DeLong: Yeah so we're gonna talk about the, some of the news that happened on cue, like right before the Power Hour about the QuickBooks Payroll changes, as, as well as the Q3 results and the announcements that that occurred immediately following.
- 5:25Dan DeLong: So we'll, try to maintain a concise conversation about that, but-
- 5:32Sharrin Fuller: Come on I
- 5:33Dan DeLong: can't guarantee that.
- 5:35Dan DeLong: But then we'll go
- 5:36Sharrin Fuller: into- My parents used to say that too, my teachers
- 5:40Dan DeLong: But we do wanna g- get into m- bulk editing tools that are in QuickBooks Desktop and Online and some external tools.
- 5:48Dan DeLong: And over at School of Bookkeeping, we're gonna be having a bulk edit cohort.
- 5:52Dan DeLong: So if we're not talking too much about enough about what the bulk editing there will be an opportunity for more- concise or not as not as unscripted with the cohort that we have.
- 6:11Dan DeLong: So Sharrin, launch the first poll question, please.
- 6:15Sharrin Fuller: You got it.
- 6:16Sharrin Fuller: Launch.
- 6:17Sharrin Fuller: Launch.
- 6:17Sharrin Fuller: Which
- 6:17Dan DeLong: version of QuickBooks do you support your clients with?
- 6:21Dan DeLong: And while that, while you're answering that, we're gonna go right into the what burns Sharrin's smores, and we'll talk about some- Get it out Intuit news and updates.
- 6:31Dan DeLong: So-
- 6:31Sharrin Fuller: Get it out
- 6:32Dan DeLong: first, first thing, you may have received a, an email in the last couple weeks about the QBO payroll changes.
- 6:39Dan DeLong: It is going, undergoing a verbiage change from QBO Payroll to QBO...
- 6:44Dan DeLong: or no, Workforce, sorry.
- 6:47Dan DeLong: So it's gonna be changing that terminology, and that seems to be a theme over the last couple weeks of terms changing.
- 6:57Dan DeLong: But basically QuickBooks or Intuit purchased a human capital management company, acquired a ma- h- human cap- human capital management company as a new acquisition.
- 7:07Dan DeLong: They are changing the name to, from just Payroll to Workforce because those the HSM or HCM companies is gonna bring bring to the fold, at least that's the promise, that there will be more HR-related things.
- 7:26Dan DeLong: Now, Sharrin, you're you're a fan of Rippling, which is, which would that
- 7:30Sharrin Fuller: be- I am a Rippling fan
- 7:33Dan DeLong: would that be in the same vein as an HS- HCM?
- 7:37Sharrin Fuller: Oh, yeah.
- 7:38Sharrin Fuller: They're all using that HCM and HCA, human capital...
- 7:42Sharrin Fuller: Sorry.
- 7:43Sharrin Fuller: That's the new we got, we all got over CAS, and now they're bringing this in.
- 7:47Sharrin Fuller: It's just basically payroll and looking at the data.
- 7:50Sharrin Fuller: But yeah, same thing.
- 7:52Sharrin Fuller: It makes sense in the evolution of Intuit to have everything in one stop.
- 7:57Sharrin Fuller: They move the accounts out of the way.
- 7:59Sharrin Fuller: You bring in just the end user business owner, and they're like,"Oh, I have Intuit.
- 8:04Sharrin Fuller: I need nothing else.
- 8:05Sharrin Fuller: This is my whole back office system.
- 8:08Sharrin Fuller: I process everything," right?
- 8:10Sharrin Fuller: So it makes sense.
- 8:11Sharrin Fuller: They're moving in the right direction even though the, their HR product sucks.
- 8:16Dan DeLong: Yeah, which was I think Mammoth was the was the company that they were working with, and I don't know what the what the outcome for that is.
- 8:28Dan DeLong: Probably it's gonna be the way of Melio when Intuit incorporated its own QuickBooks Bill Pay.
- 8:37Sharrin Fuller: Yep
- 8:37Dan DeLong: Melio got the boot.
- 8:40Dan DeLong: There is a link in the slides for the Firm of the Future article.
- 8:45Dan DeLong: I did just put in the chat the, Whoops, I didn't put it in the chat.
- 8:51Dan DeLong: I meant to put in the chat today's handouts.
- 8:55Dan DeLong: Yeah,
- 8:55Sharrin Fuller: they've already asked me twice, but-
- 8:58Dan DeLong: There you go
- 8:58Sharrin Fuller: didn't want to, didn't want to interrupt
- 9:01Dan DeLong: That is in the chat there.
- 9:03Dan DeLong: Which I would've normally done during the intro video, but we don't have the intro video, so we're still, working through this.
- 9:11Dan DeLong: But there is a link there for the Firm of the Future article and the handout, so you can download that.
- 9:18Dan DeLong: So with change typically comes a pricing change or update.
- 9:24Dan DeLong: This is also on the Firm of the Future article as well, so you can take a look at it there.
- 9:30Dan DeLong: But the pricing changes for payroll have not heard anything about pricing changes for, QuickBooks Online.
- 9:38Dan DeLong: That get-- that did get hinted at on the third quarter results call, which, we're gonna talk a little bit about in the next slide.
- 9:47Dan DeLong: But the changes with payroll is, all being related to the employee-- the per employee cost.
- 9:57Dan DeLong: They're not changing any of the base costs.
- 9:59Dan DeLong: It's all just dealing with the- the per employee cost.
- 10:04Dan DeLong: So Workforce Payroll, which is-- was Core, QBO Payroll Core is increasing by fifty cents an employee.
- 10:13Dan DeLong: Then Workforce Premium is adding a three dollar surcharge to the employee cost.
- 10:20Dan DeLong: And the Workforce Elite is getting a, quite a jump from twelve to seventeen per employee.
- 10:27Dan DeLong: And then Premium and Elite are having this optional fif-- five dollars per employee add-on for the benefits administration.
- 10:38Dan DeLong: All that is we don't know the details of what that actually means, but we know that is going to be-- there's gonna be a charge associated with that.
- 10:50Dan DeLong: That's what we do know.
- 10:50Sharrin Fuller: Yeah.
- 10:51Sharrin Fuller: Yeah
- 10:52Dan DeLong: the ef-- the effective date for these pricing changes is July first if you're directly being billed by Intuit.
- 11:01Dan DeLong: So after-- So your next billing after that will in-incorporate these changes.
- 11:06Dan DeLong: If you are participating with a QuickBooks solution provider, the QSP channel those prices don't go into effect until after September first.
- 11:17Dan DeLong: If you have clients who are currently on a promotion they will not be affected by the pricing change until this promotion ends.
- 11:26Dan DeLong: So those are the, dates involving the, those pricing changes.
- 11:31Dan DeLong: So speaking of workforce changes Intuit had its third quarter results call last week and made some pretty interesting announcements.
- 11:45Dan DeLong: Basically, the third quarter is the results of tax season, right?
- 11:50Dan DeLong: Because Intuit's fiscal year begins on October first-- or I'm sorry, August first, excuse me.
- 11:57Dan DeLong: So their third quarter is right around the TurboTax tax preparation filing season, right?
- 12:07Dan DeLong: Working added to it, I didn't realize how heavily, How heavy that was that business unit the, tax preparation side of things was for Intuit, right?
- 12:23Dan DeLong: I was...
- 12:24Dan DeLong: I grew up, I cut my teeth in QuickBooks, right?
- 12:26Dan DeLong: So we were all in that particular business unit.
- 12:31Dan DeLong: So with this third quarter you look at the charts and all the things that, are readily available out there about Intuit as a publicly traded company.
- 12:43Dan DeLong: Q- Q3, or the third quarter, is typically the largest revenue source for Intuit.
- 12:50Dan DeLong: And as they were talking about it, it was...
- 12:53Dan DeLong: it underperformed, right?
- 12:55Dan DeLong: Because TurboTax being the do it yourself model is the, is getting disrupted, right?
- 13:04Dan DeLong: That's, really what it, boiled down to.
- 13:06Dan DeLong: They lost share, they lost some revenue on the, TurboTax side of things from my analysis of, what what they said.
- 13:17Dan DeLong: This is the season, right?
- 13:19Dan DeLong: The where QuickBooks then either looks at its budget, looks at those results of the third quarter- and makes makes adjustments based off of that.
- 13:29Dan DeLong: And the, easiest way that they make adjustments is by changing the workforce changing the, the number of badged employees that, that work for Intuit.
- 13:40Dan DeLong: So they announced a large reduction.
- 13:47Dan DeLong: It was seven- 17% of the workforce.
- 13:50Dan DeLong: One thing I do want to point out is that they increased their number of employees from the last time they had a huge layoff like this, right?
- 14:01Dan DeLong: You look back at the last time, it was like 9 or 10% of the workforce re- reduction.
- 14:06Dan DeLong: They had less of a headcount than What they laid off with what they had today, or recently when they announced these, the- these layoffs.
- 14:16Dan DeLong: So- at some point they do acquire employees.
- 14:21Dan DeLong: And, that could be part of the part of, the whole thing is that it could be a, an acquisition that caused the, raise in headcount.
- 14:31Dan DeLong: But I experienced- Yeah Several, iterations of this.
- 14:37Dan DeLong: Sharrin, go ahead.
- 14:38Sharrin Fuller: I saw...
- 14:39Sharrin Fuller: So first of all, shout out to Intuit.
- 14:41Sharrin Fuller: They did it right this time.
- 14:43Sharrin Fuller: When they did the layoff, they actually didn't go,"Hey, 50% of these people sucked." Yeah.
- 14:47Sharrin Fuller: "But we're not telling you which 50%." So shout out to Intuit for not doing that again.
- 14:53Sharrin Fuller: Secondly, I was going through my LinkedIn trying to figure out who, and it was a lot of Credit Karma people.
- 15:00Sharrin Fuller: Almost significantly- Credit Karma staff.
- 15:04Sharrin Fuller: So that, again, Intuit pisses me off.
- 15:09Sharrin Fuller: Yes.
- 15:09Sharrin Fuller: But, it tracks, right?
- 15:15Sharrin Fuller: I know...
- 15:15Sharrin Fuller: Does everybody want me to be angrier, right?
- 15:17Sharrin Fuller: I'm- Okay, just making sure.
- 15:19Sharrin Fuller: Just making sure they're not...
- 15:20Sharrin Fuller: But they bought Credit Karma.
- 15:23Sharrin Fuller: And honestly, Credit Karma can be so automated in AI that they're like,"We had all these people, we don't need them anymore." So not only that, most of the departments that they had that stand alone on Credit Karma, they merge into whatever they had in Intuit.
- 15:38Sharrin Fuller: So that being said, I think they needed to get rid of all the Credit Karma people, but at the same time took a chance to get rid of some others that they won't announce- were underperforming because that went so well last time.
- 15:50Sharrin Fuller: So- Yeah anyhow, like I said, if you're in my community, if you watch anything I do, if your job isn't client facing, relationship facing, they're gonna try to replace you with computers,
- 16:02Dan DeLong: yeah.
- 16:03Dan DeLong: And, that seemed to be the the biggest thing is that TurboTax and Credit Karma, they aligned the the business units under one thing.
- 16:14Dan DeLong: The middle management components and, the teams that were part of both TurboTax and Credit Karma, because that's really the- personal finance side of Intuit.
- 16:28Dan DeLong: There was some redundancies in, positions and those roles were eliminated.
- 16:33Dan DeLong: It's hard to believe that there's 3,000 of them that were redundant, but that is, That's what they said.
- 16:44Dan DeLong: These changes they happen pretty frequently, and being Yeah A part of this being part of the, of this experience it became part of the culture.
- 16:58Dan DeLong: Just working there that, okay, we're in the fourth quarter.
- 17:02Dan DeLong: Who is it this year, right?
- 17:04Sharrin Fuller: Yeah.
- 17:05Sharrin Fuller: And it's never anybody that expected it.
- 17:07Sharrin Fuller: People that'll say,"Oh, hey, I was there for 15 years." I'm like at least you get a longer severance package." Like- Yeah Almost, I, it...
- 17:15Sharrin Fuller: Almost everybody that I know used to work at Intuit.
- 17:17Sharrin Fuller: You did, Hector did, Allison did.
- 17:20Sharrin Fuller: I cannot believe how many of you ding-dongs used to work at Intuit.
- 17:25Sharrin Fuller: Ding-dongs,'cause I just can't work for the man.
- 17:28Sharrin Fuller: So- Just saying.
- 17:31Dan DeLong: But, Whoops to their credit they typically, they do this catch and release thing where they, they reorganize, and they restructure, and they make re- requisitions.
- 17:45Dan DeLong: And it's instead of the culture of,"Hey, we think you would do better in this position," they just- ever, right?
- 17:55Dan DeLong: And then allow folks to look at what's available and reapply, right?
- 18:02Dan DeLong: And a lot of times that's what happens, is that people don't actually have to turn in their badge because all they do is just reapply for another position and get rehired for that position.
- 18:13Dan DeLong: And, that way they're it- I get it that they're getting the type of people that they want for those positions.
- 18:23Dan DeLong: And those people are putting in the initiative to get those positions.
- 18:29Dan DeLong: But it is, a lit- it is a little stressful.
- 18:32Dan DeLong: I think that's- Yeah the nicest way to-
- 18:33Sharrin Fuller: I feel bad.
- 18:34Sharrin Fuller: And the problem is, Dan, is that everybody's laying off right now, like everybody.
- 18:38Sharrin Fuller: I, it, all these big, corporations.
- 18:41Sharrin Fuller: So it's scary'cause it's like, where are they gonna go?
- 18:45Sharrin Fuller: I, if you look across the accounting channel, almost all, not almost all, but a large portion of the tech that you see at conferences, they're getting rid of their partner program.
- 18:56Sharrin Fuller: They're sending in their sales and marketing people to the booths instead of their big old partner program, right?
- 19:02Sharrin Fuller: They're spending less money on trying to get us into their product.
- 19:07Sharrin Fuller: I have a few ideas around that.
- 19:09Sharrin Fuller: But there's, where are these people gonna go?
- 19:12Sharrin Fuller: What are- what are we going to do?
- 19:14Sharrin Fuller: Are we all just gonna rebuild robots for a living?
- 19:16Sharrin Fuller: What are we going to do?
- 19:19Sharrin Fuller: I think we need to start torching the AI plants and the AI field circ- Let's just, all of us accountants uprise.
- 19:28Sharrin Fuller: We can do it.
- 19:29Sharrin Fuller: There's more of us than them.
- 19:30Sharrin Fuller: I'm just saying.
- 19:31Sharrin Fuller: I
- 19:31Dan DeLong: know.
- 19:31Sharrin Fuller: We're strong.
- 19:33Sharrin Fuller: That had nothing to do with what you were saying.
- 19:35Sharrin Fuller: But I said, it anyways.
- 19:37Dan DeLong: You did.
- 19:38Dan DeLong: All right.
- 19:39Dan DeLong: Let's let's talk about what we're, supposed to talk about today.
- 19:43Dan DeLong: We will actually, in an upcoming QB Power Hour, we are gonna be talking about robots versus humans.
- 19:51Dan DeLong: And and so we will continue this this chat conversation about-
- 19:58Sharrin Fuller: Hey, that's mine.
- 19:59Sharrin Fuller: I'm actually hosting that one.
- 20:02Sharrin Fuller: Yeah.
- 20:02Dan DeLong: I'm interested-
- 20:04Sharrin Fuller: I know
- 20:04Dan DeLong: to see what you come up with.
- 20:06Sharrin Fuller: I know.
- 20:07Dan DeLong: The bulk changes making mass changes inside of QuickBooks.
- 20:11Dan DeLong: Let's talk about some of the reasons that you would make mass changes, right?
- 20:17Dan DeLong: Incorrect categorization rules, bank rules or something that, that were functioning or not, functioning properly.
- 20:27Dan DeLong: You maybe have to clean up some of the lists updating the customers with their address or, Making changes that you might need.
- 20:38Dan DeLong: But it, especially in QuickBooks Online, a lot of those changes are individual, right?
- 20:43Dan DeLong: So it ends up being a, a rote clicking thing.
- 20:48Dan DeLong: And then with the inability, I think, for keyboard shortcuts to be as useful as they are in Desktop it becomes m- some of, somewhat of a challenge sometimes, right?
- 21:02Dan DeLong: So y- and then if you are moving a client from Desktop to QuickBooks Online, a lot of times you need to make some post-migration changes.
- 21:13Dan DeLong: And so sometimes you want to do that in one fell swoop, right?
- 21:19Dan DeLong: So let's talk about some of those tools, right?
- 21:21Dan DeLong: So in Desktop bulk editing tools, the biggest one, and I think I think it was...
- 21:30Dan DeLong: A lot of times when I talk to people about Desktop and making ma- bulk changes to lists, a lot of people didn't even realize that Add/Edit Multiple List Entries was an option.
- 21:44Dan DeLong: And that is one of the things that they, if they wanted to update something they would, call in first okay, I got a spreadsheet, and I just need to bring it in." and sometimes those particular things that they were dealing with didn't have a way to get in outside of some kind of third-party tool, which we'll talk a little bit about.
- 22:07Dan DeLong: So the Add/Edit Multiple List Entries allows for that to happen.
- 22:12Dan DeLong: You can customize the columns to match your Excel spreadsheet.
- 22:16Dan DeLong: There are built-in Excel-ish, Ex-Excel-esque types of things like copy down and things of that nature where you can show these lists, whether they be customers or vendors or your items list and then make those mass changes in one fell swoop.
- 22:38Dan DeLong: Obviously, the bank feed you can do a lot of undoing or ignoring as far as making vast, mass changes.
- 22:48Dan DeLong: There is tools and utilities for the income tracker or the bill tracker where you can do a lot of things in, bulk of sending or printing transactions.
- 22:59Dan DeLong: And then, of course, with Enterprise and, and/or your Accountant Edition, you've got some batch tools in there where you can batch create transactions individually with with invoices as well as other options very similar to what in, Advanced with batch enter transactions but also batch cla- batch reclassifying and deleting or writing off invoices and fixing unapplied customers and vendors payments, merging vendors.
- 23:33Dan DeLong: A lot of tools are inside of QuickBooks Desktop to do a lot of things at once.
- 23:40Dan DeLong: In QuickBooks Online there are batch actions on most places.
- 23:47Dan DeLong: The bank feed undo is the ability to remove a lot of transactions that have been added to your QuickBooks through the register if they've been posted or un- you want to unmatch them.
- 24:01Dan DeLong: You can batch undo them.
- 24:04Dan DeLong: You've, of course, got the batch reclassify transactions and batching transactions.
- 24:10Dan DeLong: And in QuickBooks Online Advanced, you've got the spreadsheet sync s- which is an add-on that's included with QuickBooks Online Advanced for Excel or Google Sheets we did do a workshop on school bookkeeping about making bulk edits with spreadsheet sync, so there's a link there for that because that took us about 45 minutes, and we're not gonna take that 45 minutes right now.
- 24:38Dan DeLong: So if you wanna check it out, go ahead.
- 24:42Dan DeLong: Second poll question: What tools do you use to make bulk changes inside of QuickBooks today?
- 24:48Dan DeLong: Is it the tools inside of QuickBooks, or maybe there's other tools that that you use.
- 24:57Dan DeLong: Karen, in, in your history of QuickBooks, do you is that-
- 25:04Sharrin Fuller: I use the QuickBooks tool.
- 25:06Sharrin Fuller: It's always been...
- 25:07Sharrin Fuller: Honestly, it's been progressively better from when it first started.
- 25:11Sharrin Fuller: That's why that one time when I...
- 25:12Sharrin Fuller: Remember I messaged you.
- 25:13Sharrin Fuller: I'm like,"Where the hell is my toolbox?" I need to, I needed to make bulk edits and yeah.
- 25:21Sharrin Fuller: You can make'em in so many places now.
- 25:23Sharrin Fuller: I haven't...
- 25:24Sharrin Fuller: Back in the day, I used to use Transaction Pro, which before it was called Transaction Pro Importer or Transaction Pro Deleter.
- 25:32Sharrin Fuller: They actually had two different websites.
- 25:33Sharrin Fuller: You remember back in 2000, like- Yeah 14.
- 25:36Sharrin Fuller: Anyhow, for desktop.
- 25:38Sharrin Fuller: And I used that until QuickBooks started adding it in.
- 25:41Sharrin Fuller: I make...
- 25:43Sharrin Fuller: I'm...
- 25:44Sharrin Fuller: I am in Books.
- 25:44Sharrin Fuller: I still stay in Books to keep on top of it, but I, yeah, I utilize it like crazy.
- 25:50Sharrin Fuller: I haven't seen a need, what I'm saying, is I haven't seen a need for a third party at, yet, yet.
- 25:56Dan DeLong: Yet.
- 25:57Sharrin Fuller: I'm sure I'll get I'm sure I'll get people pointing in on how I'm wrong.
- 26:03Sharrin Fuller: But I just haven't seen it, honestly.
- 26:05Sharrin Fuller: It's one of the things QuickBooks does right, and it should.
- 26:08Sharrin Fuller: It should.
- 26:08Sharrin Fuller: They should.
- 26:09Sharrin Fuller: This should be something that you should not need a third party for, in my opinion.
- 26:14Dan DeLong: Yeah.
- 26:14Sharrin Fuller: Yeah.
- 26:15Dan DeLong: So- It's just,
- 26:16Sharrin Fuller: yeah, it's just- Good job being average with your product.
- 26:19Sharrin Fuller: Sorry.
- 26:20Sharrin Fuller: I'm just angry at, I'm so angry at them.
- 26:22Sharrin Fuller: I don't know why.
- 26:23Sharrin Fuller: They've done nothing to me except piss me off.
- 26:27Sharrin Fuller: They haven't personally...
- 26:27Sharrin Fuller: Actually, that's not true.
- 26:29Sharrin Fuller: They, their representatives have personally said things to/about me- so maybe I am justifiably bitter.
- 26:37Dan DeLong: Old jaded.
- 26:39Sharrin Fuller: Jaded, or I just- have no filter, but whatever.
- 26:44Dan DeLong: Maybe
- 26:44Sharrin Fuller: both.
- 26:44Sharrin Fuller: See, most everybody here, 76% are QuickBooks only.
- 26:48Sharrin Fuller: 26% are Right Tool, and then 16 are SaaS transaction.
- 26:52Sharrin Fuller: When some- when you guys, the six, the seven of you that said something else, can you drop in the chat what it is?
- 26:57Sharrin Fuller: I'd be curious to know.
- 26:58Sharrin Fuller: But go ahead.
- 26:59Sharrin Fuller: If it's Go ahead, Dan.
- 27:00Sharrin Fuller: I'll get- Zed
- 27:00Dan DeLong: Access or something like that.
- 27:02Dan DeLong: But yeah, there's, Oh,
- 27:03Sharrin Fuller: Keeper.
- 27:03Sharrin Fuller: Keeper does do it now.
- 27:04Dan DeLong: That's true.
- 27:05Dan DeLong: That's true All right, so QuickBooks can only do so much, right?
- 27:10Dan DeLong: So each tool has its limits, right?
- 27:12Dan DeLong: So if you're not using QuickBooks Online Advanced, you don't get access to spreadsheet sync to, to do those things or the batch transactions or some of the other utilities or tools that, that might be in there, the workflow automations and those types of things.
- 27:34Dan DeLong: And, oftentimes those batch actions are limited to only certain functions.
- 27:39Dan DeLong: 'cause like you can go in on a, vendor screen and update You know, historical transactions and that's part of a batch batch action.
- 27:51Dan DeLong: But if you wanna...
- 27:52Dan DeLong: It's always seems to be the shallow end of the pool and it's like what about this?" And then,"Oh, we don't do that," right?
- 28:01Dan DeLong: Type of thing.
- 28:02Dan DeLong: And then there's the challenge of discovery, right?
- 28:05Dan DeLong: Like, where do you go to find these things?
- 28:09Dan DeLong: There's Each screen might have a different view or, look of that, right?
- 28:15Dan DeLong: Like when you're importing in Desktop, that's when it tells you,"Hey, you could go over to add, edit, remove or add, edit multiple list items in Desktop." So a lot of people didn't even realize that it's there, and they have to tell you"Hey, it's over here instead." batch transactions, you can't edit all types of transactions, and results vary on what you can actually edit, right?
- 28:45Dan DeLong: Even if it's on the invoices where it's something that you can.
- 28:49Dan DeLong: And then Advanced, the custom fields is a manual process, right?
- 28:54Dan DeLong: There's really cool things that you can do with those custom fields, but if you can't batch edit them that's a challenge, right?
- 29:01Dan DeLong: And that, became evident to me because I moved Helped, a company move from Desktop to Online, and they were using vendor type as a as a field, and that's not a field in QuickBooks Online.
- 29:19Dan DeLong: So we had to turn that into a custom field so that they could categorize their vendors by type.
- 29:26Dan DeLong: But they have 8,000 vendors, and to edit-
- 29:32Sharrin Fuller: Yeah
- 29:33Dan DeLong: Each particular there's 2,000 active, I should say.
- 29:38Dan DeLong: So 2,000 vendors editing advan- the custom fields was a manual process without some kind of alternative to be able to do that.
- 29:52Dan DeLong: The, external utilities there are, plenty as people are, are- Oh, yeah are saying.
- 29:58Dan DeLong: We're gonna focus primarily on Saasant and Right Tool Tool Pro.
- 30:04Dan DeLong: I love that,
- 30:05Sharrin Fuller: Saasant.
- 30:06Sharrin Fuller: Saasant.
- 30:07Sharrin Fuller: I don't know why, I just always loved the name.
- 30:09Sharrin Fuller: Probably'cause my sassy Sharrin emoji that I have, but Saasant.
- 30:14Dan DeLong: Yeah.
- 30:15Dan DeLong: Now there are others, right?
- 30:18Dan DeLong: You, mentioned them Transaction Pro or TPro or whatever they're calling themselves these days.
- 30:26Dan DeLong: Zed Access Automate Transaction- Ooh the Da- Data Transfer Utility.
- 30:30Sharrin Fuller: Yeah.
- 30:32Sharrin Fuller: I have a, I wanna know, I wanna hear your opinion on this.
- 30:37Sharrin Fuller: So all these third-party integrations got created because Intuit didn't have it yet, Right.
- 30:44Sharrin Fuller: Uncat.
- 30:45Sharrin Fuller: Let's talk about Uncat.
- 30:47Sharrin Fuller: Love Brandon, his daughter's adorable.
- 30:48Sharrin Fuller: They bring the best stuff to all the conferences.
- 30:52Sharrin Fuller: But at what point does a product like Uncat no longer become relevant or something we need when QuickBooks...
- 30:59Sharrin Fuller: I still don't think QuickBooks does uncategorize well, like getting it to your clients at all.
- 31:03Sharrin Fuller: I would never use it.
- 31:05Sharrin Fuller: But our project management tools really do.
- 31:07Sharrin Fuller: Same with these type of things.
- 31:09Sharrin Fuller: Obviously Intuit has spent some time y- researching other products that are doing well, like Double.
- 31:16Sharrin Fuller: I think Double does something, then Intuit does it, right?
- 31:19Sharrin Fuller: And I was just talking to Ben about it.
- 31:20Sharrin Fuller: I'm like,"Ben, Intuit's copying you.
- 31:22Sharrin Fuller: Isn't that is, doesn't that give you some sort of like ego trip?" And he goes,"No.
- 31:27Sharrin Fuller: I, yeah, it's great to see a big old product steal all our ideas and get paid for it." I'm like,"Okay, makes sense." But I'd still be like,"Ha th- so at what point do you think we start, like these third-party integrations start becoming irrelevant?
- 31:42Dan DeLong: It's it's part of...
- 31:45Dan DeLong: I- it's an interesting phenomenon, right?
- 31:49Dan DeLong: Is that and, truth be told the first time I heard of Keeper at Scaling New Heights, I went to talk to them.
- 31:58Dan DeLong: And the individual telling me what they do, I was like isn't that already in QBOA right now?" You know- Yeah That was the, impression that I left with.
- 32:09Dan DeLong: I'm like, well-
- 32:10Sharrin Fuller: Yeah
- 32:11Dan DeLong: but to- Yeah A power user of Keeper or Double you will definitely say it does a lot more than what those things do.
- 32:22Dan DeLong: And and I think that's where- Intuit or QuickBooks And they're
- 32:28Sharrin Fuller: not wrong
- 32:30Dan DeLong: Yeah.
- 32:30Sharrin Fuller: I totally think they do.
- 32:31Sharrin Fuller: Uncat was the best at uncategorized.
- 32:34Sharrin Fuller: And then Double started adding it in.
- 32:36Sharrin Fuller: Client Hub has it.
- 32:37Sharrin Fuller: Financial Sense has it.
- 32:39Sharrin Fuller: And so it really makes me think.
- 32:40Sharrin Fuller: I'm like I, f- I don't, I know I want to see Brandon succeed, and I know there'll always be a small amount for him, but it's like I really would've wished somebody would've brought, bought his product.
- 32:49Sharrin Fuller: And I don't mean to call him out directly, I just...
- 32:51Sharrin Fuller: He's just such a good guy, and I, always think about that.
- 32:54Sharrin Fuller: But I see things like Tool, which apparently will always be there because QuickBooks they're doing it better.
- 33:01Sharrin Fuller: Plus I have to show love for Hector even though he pissed me off on his LinkedIn post the other day.
- 33:06Sharrin Fuller: But anyhow he just really supported them, and I was like,"Yeah, never mind." But yeah, it just makes me think about whenever I go to the conference, I'm like,"You'll be obsolete.
- 33:15Sharrin Fuller: You'll be obsolete.
- 33:15Sharrin Fuller: You'll be obsolete.
- 33:16Sharrin Fuller: You'll..." And then they never show up again, and you're like,"Yeah,'cause-" I guess- You know, if you see a need, fill a need
- 33:22Dan DeLong: In the...
- 33:23Dan DeLong: In the grand scheme of things, it's where do do they continue to expand their offering, right?
- 33:32Dan DeLong: Uncategorized or Uncat, right?
- 33:36Dan DeLong: That was the need that they filled, and they ended up building a whole branding thing around it, right?
- 33:42Dan DeLong: So eventually when it gets to the point of where QuickBooks does catch up or other third parties do it better than those things, that could very well be a challenge for, them to continue to remain relevant, right?
- 34:03Dan DeLong: Yeah.
- 34:04Sharrin Fuller: Yeah
- 34:06Dan DeLong: But that doesn't mean that they're not, right?
- 34:11Sharrin Fuller: Yeah
- 34:12Dan DeLong: speaking of Right Tool, right?
- 34:14Dan DeLong: It- there's constantly things for to improve on.
- 34:20Dan DeLong: And, Yeah And, as to Hector's benefit he uses it enough and he can see those limitations.
- 34:29Dan DeLong: Yeah.
- 34:30Dan DeLong: And he has said,"This is an app or, an extension that shouldn't exist."
- 34:35Sharrin Fuller: Yeah.
- 34:36Sharrin Fuller: Yeah, exactly.
- 34:37Sharrin Fuller: But the, I guess the, good thing is, for something like Right Tool, they can move much faster because they- Yeah don't have to go through 17 departments and approval and boards.
- 34:46Sharrin Fuller: They're just like,"This is an issue.
- 34:48Sharrin Fuller: Everybody's telling us this issue.
- 34:49Sharrin Fuller: Let's code it in." like, it's that simple, and it'll be ready in a week.
- 34:52Sharrin Fuller: Yeah.
- 34:53Sharrin Fuller: So they can move faster, but I still think that Intuit, honestly, most of them probably just have people that sit in their product, and they're like,"We need to add this, we need to add this, we need to add this." and they don't want to put them out of business.
- 35:05Sharrin Fuller: They actually like them because they're probably saving them a shit ton of money on R&D.
- 35:10Dan DeLong: Yeah.
- 35:10Sharrin Fuller: A double subscription and a Right Tool subscription, and they're like,"That's my...
- 35:14Sharrin Fuller: Our R&D is$17 a month."
- 35:18Dan DeLong: Exactly.
- 35:20Dan DeLong: So let's talk a little bit about Saasant.
- 35:23Dan DeLong: They have just like QuickBooks, they have a desktop product, and they have an online product.
- 35:29Dan DeLong: And there is a hybrid product called the Migration Level, but it's still on the the desktop side.
- 35:39Dan DeLong: One of the things that I use it myself mostly for for conversions or migrations.
- 35:47Dan DeLong: There is a migration option between desktop to desktop, right?
- 35:52Dan DeLong: So when you have these large companies that have a lot of data in them maybe there's some damage in the file and it can't be fixed taking a subset of data and moving it into another QuickBooks desktop file, is a really cool option.
- 36:12Dan DeLong: Or if they tend...
- 36:15Dan DeLong: One of the challenges of QuickBooks desktop is multiple people could be in different company files.
- 36:21Dan DeLong: And maybe one user did all this data entry in the wrong company file, and they want to be able to consolidate or merge them, right?
- 36:31Dan DeLong: This is, the tool or u- utility that, that allows you to do that relatively streamlined, right?
- 36:40Dan DeLong: One of the things I really appreciate about it is that during the Migration Wizard, it will say,"Hey, this preference is turned on in the source file, and it's not on...
- 36:50Dan DeLong: And here's what it is in, the target.
- 36:53Dan DeLong: Maybe you might want to change that." Or there's a little checkbox to actually interrupt the migration if there's an error, right?
- 37:01Dan DeLong: Because you may have a, A contingent transaction, right?
- 37:06Dan DeLong: If you, if an invoice doesn't come over, then of course the payment that paid that invoice won't come over, and the deposit made off of that payment won't come over.
- 37:14Dan DeLong: So you want to make sure that the prerequisite transactions make the journey, and having it pause the migration rather than just skipping over it and then you have to deal with the outcome or the consequences is part of a challenge.
- 37:30Dan DeLong: There's other tools and utilities in there.
- 37:32Dan DeLong: There's a PDF to Excel utility where you can extract bank statements and those types of things built into the tool.
- 37:43Dan DeLong: You can, What was the other thing?
- 37:48Dan DeLong: There, there are some automation options.
- 37:50Dan DeLong: So if you just plug in a a file, you can automatically map it.
- 37:55Dan DeLong: You just plug it in, and it makes those changes for you.
- 38:00Dan DeLong: It is an annual subscription but it's about three hundred dollars for the top tier, right?
- 38:07Dan DeLong: So it's there's no limit on the, number of transactions that you, do with with Saasant for Desktop.
- 38:15Dan DeLong: With Saasant for Online, just like QuickBooks Online, it has a company aspect to it a company connection a-a-aspect.
- 38:24Dan DeLong: And then within that company aspect, you have different tiers of things that you can do.
- 38:31Dan DeLong: There are multiple tiers or multiple company options, a multiple bulk bulk option where you can purchase a connection to three or ten and then you can swap things out, right?
- 38:44Dan DeLong: So if you're doing a project for a particular client you can add them to your multiple company billing.
- 38:52Dan DeLong: And then when you're done with that, you can kick them out and then add another company to it.
- 38:58Dan DeLong: And those they work on credits, though on the, QuickBooks Online side of things.
- 39:05Dan DeLong: Each particular import, export, or deletion is a credit, and it's based off a line item, right?
- 39:14Dan DeLong: So if you have one invoice with fifteen line items, that's fifteen credits.
- 39:18Dan DeLong: But on a multiple billing, they pool them for you, right?
- 39:23Dan DeLong: So if you have a company that doesn't necessarily need five thousand credits they can be- Yeah Essentially utilized for a bigger project that you might have.
- 39:36Dan DeLong: Just keep in mind when you're swapping connections out, like if you have a three, three company and you're swapping things in or out, there may be a billing cycle that needs to occur.
- 39:50Dan DeLong: So it's not like you can just keep swapping them out each day, right?
- 39:54Dan DeLong: Keep that in mind.
- 39:57Dan DeLong: But there's links in there to, check them out.
- 40:00Dan DeLong: And then Tool Pro is I think fast becoming an accountant's
- 40:07Sharrin Fuller: favorite friend.
- 40:08Sharrin Fuller: Yeah, I hear about it everywhere.
- 40:09Sharrin Fuller: They say if you have QuickBooks, you need Right Tool.
- 40:12Sharrin Fuller: Yeah.
- 40:13Sharrin Fuller: You have to have it.
- 40:15Dan DeLong: Now there's tons of batch features.
- 40:18Dan DeLong: I, I took a screenshot of the settings when you're in Tool Pro which is the paid version.
- 40:27Dan DeLong: There is a Right Tool free where you can just do...
- 40:30Dan DeLong: You get a free option, but it doesn't have any of these batches batch functionality.
- 40:36Dan DeLong: But you can see all the options that you can switch on or off.
- 40:39Dan DeLong: This was very useful.
- 40:44Dan DeLong: I'm trying to think of a better way to say for that the use case that I was just talking about where they were- using the right, the vendor type field in desktop, and then turned it into a custom field, right?
- 41:01Dan DeLong: Because you can update custom fields on transactions vendors, customers.
- 41:08Dan DeLong: There's a lot of other pretty neat things there, like changing the case, right?
- 41:13Dan DeLong: If you have your all-caps customer
- 41:17Sharrin Fuller: You can say-
- 41:17Dan DeLong: Oh
- 41:18Sharrin Fuller: my God.
- 41:19Sharrin Fuller: They...
- 41:19Sharrin Fuller: It really does that?
- 41:20Sharrin Fuller: Oh.
- 41:21Dan DeLong: Yeah.
- 41:22Sharrin Fuller: Those customers- Oh, yeah are always in their 70s.
- 41:24Sharrin Fuller: Why?
- 41:25Sharrin Fuller: Like, why are you yelling at me, Claude?
- 41:28Sharrin Fuller: Yeah.
- 41:28Sharrin Fuller: Wait, Cla- Clive?
- 41:30Dan DeLong: You can change the case of your customers.
- 41:34Dan DeLong: You can swap out the display names, right?
- 41:37Dan DeLong: So if if they're names versus customer companies you can, use the, Right Tool Pro to, do that.
- 41:45Dan DeLong: Cost of the Right Tool Pro is$75 monthly for the first user, and then 25- Oh, that's
- 41:52Sharrin Fuller: good
- 41:53Dan DeLong: for each additional user.
- 41:55Dan DeLong: And there's no...
- 41:56Dan DeLong: Be- because the way that Tool Pro works is it's a browser extension, right?
- 42:03Dan DeLong: Yeah it sits over top of the browser.
- 42:04Dan DeLong: There's not a per company cost to, to Right Tool Pro.
- 42:10Dan DeLong: And Hector has been so nice and gracious to give us a QB Power Hour promo.
- 42:17Dan DeLong: So for the first year, you get$15 off that first user.
- 42:21Dan DeLong: So it ends up being$60 a month.
- 42:23Dan DeLong: Basically you can add a second user almost for 10 bucks, right?
- 42:28Dan DeLong: You can learn about that there.
- 42:31Dan DeLong: Whoops
- 42:32Sharrin Fuller: So- I should show you what just hit my inbox right now.
- 42:35Sharrin Fuller: Oh, what's that?
- 42:35Sharrin Fuller: Intuit QuickBooks and Mineral.
- 42:37Sharrin Fuller: If you have QuickBooks Workforce Premium, you already have Mineral.
- 42:40Sharrin Fuller: The...
- 42:40Sharrin Fuller: Tomorrow we're doing a live Mineral walkthrough.
- 42:42Sharrin Fuller: There you guys go.
- 42:43Sharrin Fuller: There you go.
- 42:43Sharrin Fuller: Tomorrow they're doing a live walkthrough, whoever the hell this is.
- 42:47Sharrin Fuller: Oh, Mineral, trustmineral.com.
- 42:52Dan DeLong: So we are doing at School of Bookkeeping, we are doing a deeper dive cohort at School of Bookkeeping in mid-July.
- 43:00Dan DeLong: So after Scaling New Heights settles, but before Intuit Connect we will be doing four live sessions.
- 43:09Dan DeLong: We will dive into the desktop options the, QuickBooks Online options, and then talk a- talk about Saasant desktop and online, and then do some workshopping with with Right Tool Pro.
- 43:24Dan DeLong: It's$279 for the cohort.
- 43:26Dan DeLong: They are reco- going to be recorded, so if you can't attend those live sessions, you can always watch them later.
- 43:32Dan DeLong: And there are discounts available if use our referral link for any of these external tools.
- 43:40Dan DeLong: So you can check that out.
- 43:44Sharrin Fuller: Questions you said- And you can also get...
- 43:45Sharrin Fuller: Privacy, you mean you can get the trial during that month too, so they could sign up for your thing, try it out while they're doing all that stuff, and then decide which one they want to keep and use, right?
- 43:55Sharrin Fuller: Exactly.
- 43:55Sharrin Fuller: That's what I would do.
- 43:56Sharrin Fuller: Yeah, and so-
- 43:57Dan DeLong: That's
- 43:57Sharrin Fuller: how I would do it
- 43:58Dan DeLong: there, there never seems to be...
- 44:00Dan DeLong: And I think that's part of the challenge with all of this is that there's not like a silver bullet because custom fields are solely not...
- 44:14Dan DeLong: They're not, a great option for the Saasant, right?
- 44:18Dan DeLong: Biggest issue with, with these external tools with you're u- if you're using custom fields or definable custom fields, especially in QuickBooks Online Advanced, and let's not get too Into the weeds with the tags issue.
- 44:40Dan DeLong: But when tags turned into a custom field, Yeah a definable drop-down, as its solution, and now that's stuck in all of, all the versions of, QuickBooks Online these third-party applications really can't integrate with that, right?
- 45:00Dan DeLong: It was always one of the limitations of the API for for pl- things like Saasant or Transaction Pro, is that they couldn't directly integrate with the custom fields, right?
- 45:13Dan DeLong: So that's where Tool Pro and Saasant could be used in conjunction with each other, right?
- 45:22Dan DeLong: So there's things that- Yeah Saasant can do that Tool can't do, and vice versa, right?
- 45:28Dan DeLong: So if you did need to update your custom fields, Tool Pro would be a great utilization for that.
- 45:35Dan DeLong: And a- as it sits right now, it's really the only option.
- 45:39Dan DeLong: And then to your point, Sharrin when the API gets on board- with all of these third parties and they figure out the way to integrate with with those custom fields, that will limit the value or lower the value- Yeah of Right Tool Pro, right?
- 45:58Dan DeLong: So- I don't know.
- 45:58Sharrin Fuller: I still think Tool will be, always be a few steps ahead of Intuit.
- 46:02Sharrin Fuller: I think that's the point.
- 46:03Sharrin Fuller: And I also want to point out- Yeah to everybody that you are watching in real time my, the virus my husband shared with me develop.
- 46:10Sharrin Fuller: At first I got on this call, Dan"Dan, I'm not feeling too well." Now I'm like So you guys have all watched me progressively get sicker- Fierce.
- 46:18Sharrin Fuller: in the last 45 minutes, just so you know.
- 46:21Dan DeLong: We'll do a time lapse.
- 46:22Dan DeLong: In real time.
- 46:23Dan DeLong: We'll do a time lapse of, Yeah of
- 46:24Sharrin Fuller: how- Of me holding my paper towel to my nose'cause I can't get up to blow it yet.
- 46:29Sharrin Fuller: Ugh
- 46:31Dan DeLong: Go
- 46:32Sharrin Fuller: ahead.
- 46:32Sharrin Fuller: Yeah I, just always think that Tool's gonna be ahead.
- 46:35Sharrin Fuller: They have to.
- 46:36Sharrin Fuller: Yeah.
- 46:36Sharrin Fuller: That's their whole business model.
- 46:38Dan DeLong: Yeah and I think, and that's a great point for any technology a company, right?
- 46:44Dan DeLong: Yeah.
- 46:44Dan DeLong: Th- in order to remain and have that value, they are gonna have- Yeah to continue to, evolve and continue to add features and functionality, right?
- 46:56Dan DeLong: Resting on your laurels is- Yeah Is, just going to allow you to be- to get overtaken, right?
- 47:08Dan DeLong: And, you're gonna be lapped if you're not continually improving.
- 47:14Dan DeLong: 'Cause QuickBooks will continue to go at its own pace and and these functions and features we're, all just sitting here waiting for some of this to happen, right?
- 47:28Dan DeLong: And if you, and if you-
- 47:29Sharrin Fuller: Yeah
- 47:30Dan DeLong: wait for it to happen, you will con- just continue to wait, and be, get to do whatever it is that you're allowed to do when it actually gets- You know, a- as a f- as a function inside of QuickBooks.
- 47:45Dan DeLong: So that's where these tools fill the gap, right?
- 47:51Dan DeLong: And that could be a right tool thing, could be- I
- 47:53Sharrin Fuller: wish this was around back in the day when I was heavily doing bookkeeping.
- 47:58Sharrin Fuller: I would've loved this.
- 47:59Sharrin Fuller: Some of us had to do it the old school way.
- 48:02Dan DeLong: Yeah.
- 48:03Sharrin Fuller: Right click, delete.
- 48:05Sharrin Fuller: Right click, delete.
- 48:07Dan DeLong: Yeah.
- 48:07Dan DeLong: Ugh.
- 48:08Dan DeLong: I had I, I had a situation where somehow duplicate sales tax items got into QuickBooks Desktop.
- 48:19Dan DeLong: W- they were using some kind of integrated application that just- kept creating duplicate sales tax items.
- 48:27Dan DeLong: Probably it was in the thousands, right?
- 48:31Dan DeLong: It was all ZZZZZ sales tax.
- 48:35Dan DeLong: Or something like that.
- 48:37Dan DeLong: And in that particular case it was something that was manual.
- 48:44Dan DeLong: There was no- Yeah there was no utility that I could use to do that because there were transactions associated with those duplicates.
- 48:52Dan DeLong: So it wasn't something you
- 48:53Sharrin Fuller: could delete.
- 48:54Sharrin Fuller: Tryin' to undo it, yeah.
- 48:55Sharrin Fuller: It's crazy.
- 48:56Sharrin Fuller: It's, it is- Yeah it is nuts to me.
- 48:58Sharrin Fuller: Transaction Pro Deleter, which I know that's not what it is anymore, but that's where I...
- 49:03Sharrin Fuller: Where really what I use is when something imported, you're like,"Son of a..." But even then, you'd have to, you didn't get to identify, like you can now.
- 49:11Sharrin Fuller: You guys have it so easy now.
- 49:13Sharrin Fuller: All of you younger people, if you weren't doing this 15 years ago, you don't know what it's like 15-plus years ago.
- 49:21Sharrin Fuller: If you start throwing out- I'm
- 49:22Dan DeLong: dying
- 49:22Sharrin Fuller: over
- 49:23Dan DeLong: here a M- in my day,
- 49:25Sharrin Fuller: I used to- Back in my day.
- 49:27Sharrin Fuller: I've been doing this for, what, 20 years?
- 49:29Sharrin Fuller: Over 20 years now.
- 49:31Sharrin Fuller: 22.
- 49:32Sharrin Fuller: We
- 49:32Dan DeLong: had to use keyboard shortcuts- So and we
- 49:34Sharrin Fuller: loved it.
- 49:34Sharrin Fuller: Dude, I had Quicken on a Macintosh, like one of those big gray things with the bottom.
- 49:40Sharrin Fuller: I'm not even joking.
- 49:41Sharrin Fuller: It was, like, all green.
- 49:42Sharrin Fuller: The screen was the green cursor.
- 49:46Dan DeLong: Yeah.
- 49:46Sharrin Fuller: Wow.
- 49:46Sharrin Fuller: And as
- 49:46Dan DeLong: Murph was saying- By the s- yes, that's what Mer- That's- that was M- what Merge was for, and that's what we had to do, is we had to- Yes manually merge 9,000 sales tax items
- 49:58Sharrin Fuller: each one.
- 49:58Sharrin Fuller: I was gonna say, Murph used a whole abacus and a chisel in a
- 50:03Dan DeLong: cave.
- 50:05Dan DeLong: But I just paid my son 100 bucks or whatever.
- 50:10Dan DeLong: "Hey, would you like to just rote click ar- around in QuickBooks and merge?" Because there was no tool that allowed you to merge transact or merge list items because that it needed that prompt of,"Hey, this item's already in use.
- 50:30Dan DeLong: Would you like to merge them?" And then you, it would...
- 50:33Dan DeLong: You'd have to actually say yes to that in QuickBooks and, there's no tool that, that actually does that for you.
- 50:41Dan DeLong: So those were part of the challenges that you have with these third parties.
- 50:48Dan DeLong: There might be a message or a prompt that can't be done.
- 50:54Dan DeLong: So I think as we get into operational AI where you see the mouse moving around or you're able to program those types of things that's gonna be something that will eliminate a lot of inefficiencies when it comes to how fast can you actually click and type inside of- Yeah inside of QuickBooks.
- 51:19Dan DeLong: Did we miss any any comments, concerns, questions?
- 51:24Sharrin Fuller: No I hit, all them up.
- 51:27Sharrin Fuller: It was quiet today, which is crazy.
- 51:31Sharrin Fuller: Even Murph was not as not as nuts as he normally is, so anyhow.
- 51:39Sharrin Fuller: But no, I think we got them all.
- 51:41Sharrin Fuller: This is...
- 51:42Sharrin Fuller: Honestly, I do think I don't know how anyone could be in QuickBooks without something like that, unless you're really not...
- 51:49Sharrin Fuller: It really depends.
- 51:50Sharrin Fuller: If you're just doing minor stuff, but if you're doing cleanup at all, I feel like you have to have right tools.
- 51:53Sharrin Fuller: It's like an investment.
- 51:54Sharrin Fuller: You figure if you charge 150 bucks an hour, if it saves you an hour, then you've made your ROI,'cause it's only 75 bucks a month, right?
- 52:03Sharrin Fuller: So you only have to save 30 minutes a month to break even, when you're gonna save way more than that,
- 52:08Dan DeLong: exactly.
- 52:09Sharrin Fuller: Anyhow.
- 52:10Sharrin Fuller: So
- 52:11Dan DeLong: the next time on the QB Power Hour we'll be having Fishbowl on to talk about their catch of the day.
- 52:17Dan DeLong: So we threw a, pun in there of fish and catch.
- 52:22Dan DeLong: So we'll be joined by Kendrick, who is their chief evangelist, and walking through some of the some of the options that are available inside of Fishbowl.
- 52:34Dan DeLong: You can check that out on our website and register for that.
- 52:38Dan DeLong: And
- 52:38Sharrin Fuller: bring your Fishbowl pins.
- 52:41Dan DeLong: Your fidget spinner swipe.
- 52:43Sharrin Fuller: Oh my God.
- 52:44Sharrin Fuller: Love it.
- 52:44Sharrin Fuller: Yes.
- 52:46Sharrin Fuller: Love it.
- 52:48Dan DeLong: All right.
- 52:50Dan DeLong: Let's roll the last- I'm ready poll question for this
- 52:53Sharrin Fuller: session.
- 52:53Sharrin Fuller: I feel like I don't care about this question because- honestly if you answer no, I don't care.
- 53:00Sharrin Fuller: Dan cares.
- 53:00Sharrin Fuller: Sure.
- 53:00Sharrin Fuller: If you answer no, I'm like no." we- No, you know how many people are gonna say no we can't lean them all.
- 53:07Sharrin Fuller: Now everybody's gonna, everybody's gonna say no.
- 53:10Sharrin Fuller: Nah.
- 53:11Sharrin Fuller: I would, to spite me.
- 53:13Sharrin Fuller: You know we can see who you are, right?
- 53:15Sharrin Fuller: Oh, seven of you are jerks.
- 53:19Sharrin Fuller: Dan, it's not you, it's me.
- 53:21Sharrin Fuller: They your information's very useful.
- 53:23Sharrin Fuller: I'm the one that they're like-"Why is she here?
- 53:26Sharrin Fuller: What happened to Matt?
- 53:27Sharrin Fuller: Bring Matt back."
- 53:29Dan DeLong: We'll, find out when you actually start,
- 53:32Sharrin Fuller: There you go.
- 53:34Sharrin Fuller: Carol wants to know what the bulk changes cohort is That was the one you just did, right?
- 53:40Sharrin Fuller: Yeah.
- 53:40Sharrin Fuller: Carol, the slides are in there, and then-
- 53:42Dan DeLong: Yeah
- 53:42Sharrin Fuller: Dan, you want to send those over to her?
- 53:45Dan DeLong: Yeah.
- 53:46Dan DeLong: This cohort is-
- 53:47Sharrin Fuller: Also answer yes, right?
- 53:49Sharrin Fuller: If you answer yes, Dan will reach out to you.
- 53:51Dan DeLong: Exactly.
- 53:52Dan DeLong: Yeah.
- 53:53Dan DeLong: Okay.
- 53:53Dan DeLong: So this is the deep dive cohort that we're doing at School of Bookkeeping where we're gonna have four sessions in July, where we talk about these things a little...
- 54:04Dan DeLong: In a more intimate setting, right?
- 54:06Dan DeLong: So we'll deeper dive into what the things that you can do in Desktop, the things that you can do in QuickBooks Online and then what options that you have with SaaSSant on Desktop and and/or Online, and Tool Pro.
- 54:23Dan DeLong: So you can check that out there.
- 54:26Dan DeLong: And like I said, there are discounts available if you activate some of these things, if you don't have them already
- 54:35Sharrin Fuller: Love it.
- 54:36Dan DeLong: All right.
- 54:38Sharrin Fuller: He- Dan, I need to hop over in your thing and see what else you teach, because I have so many people that are just starting businesses in my community, and they're like,"How do you do this?" I'm like,"I don't teach you that, but Dan does." You're welcome.
- 54:49Sharrin Fuller: I teach you how to run the business and how to be efficient and how to only work three days a week.
- 54:53Sharrin Fuller: I don't teach you how to do actual work.
- 54:56Sharrin Fuller: Other people can do that.
- 54:57Sharrin Fuller: And
- 54:58Dan DeLong: yes, and then I'll get you down to one day a week.
- 55:00Dan DeLong: Oh, yeah.
- 55:01Dan DeLong: It's all those, QuickBooks efficiencies that we'll be
- 55:04Sharrin Fuller: figuring out.
- 55:05Sharrin Fuller: There you go.
- 55:05Sharrin Fuller: That's pretty at my last firm I only worked five hours a weekend, there you go.
- 55:12Sharrin Fuller: I guess it can be, done if you have the right efficiency set up.
- 55:16Sharrin Fuller: That's my new hashtag.
- 55:17Sharrin Fuller: I'm the hashtag efficiency expert.
- 55:21Sharrin Fuller: Wah-wah.
- 55:22Sharrin Fuller: There you go.
- 55:22Sharrin Fuller: All right, show us your next slide.
- 55:24Dan DeLong: Oh, that's it.
- 55:26Sharrin Fuller: Oh, that was it?
- 55:27Sharrin Fuller: That is it.
- 55:28Sharrin Fuller: The next steps?
- 55:29Dan DeLong: Yes.
- 55:29Sharrin Fuller: Oh, my goodness.
- 55:30Sharrin Fuller: We ended on time?
- 55:32Dan DeLong: This is the, this
- 55:33Sharrin Fuller: is a
- 55:33Dan DeLong: first.
- 55:33Sharrin Fuller: I wanna...
- 55:34Sharrin Fuller: We have five minutes left just to just, can we go back to talking crap about Intuit- Yeah, wanna talk about Intuit?
- 55:39Sharrin Fuller: and then we lay everybody
- 55:39Dan DeLong: off?
- 55:41Dan DeLong: So what are your
- 55:42Sharrin Fuller: thoughts?
- 55:43Sharrin Fuller: So- Oh, my God.
- 55:44Sharrin Fuller: I was just, honestly, I laughed, because when you do this everyone said they, they learned via an email and a calendar invite.
- 55:52Sharrin Fuller: I understand it's thousands upon thousands of people, but what's the right way to fire that many people without notice?
- 55:58Sharrin Fuller: Like, how, there, I guess there's no right, you can't physically bring that many people in, so I guess there's no right way, right?
- 56:09Dan DeLong: Yeah.
- 56:09Dan DeLong: Yeah,
- 56:09Sharrin Fuller: I was- Would you prefer to be fired from a company that you've been with for 40 freaking years or whatever?
- 56:16Sharrin Fuller: I'd be pissed.
- 56:16Sharrin Fuller: Yeah.
- 56:17Sharrin Fuller: There's just no right way.
- 56:18Dan DeLong: Yeah, there's never a great way to do it.
- 56:22Dan DeLong: The the solace is that Intuit has done this a lot, and it's kind of-
- 56:29Sharrin Fuller: Oh, I
- 56:30Dan DeLong: know.
- 56:30Dan DeLong: I just know it's
- 56:30Sharrin Fuller: great
- 56:31Dan DeLong: They have really great practice at it, right?
- 56:34Sharrin Fuller: Yeah.
- 56:35Dan DeLong: In in my, tenure there-
- 56:38Sharrin Fuller: That's what they sell.
- 56:39Sharrin Fuller: We fire your, employees for you.
- 56:41Sharrin Fuller: We are good at it.
- 56:45Dan DeLong: In the last few years that I was there, you know- Yeah if they would've asked for volunteers, I would've raised my hand.
- 56:51Sharrin Fuller: Yeah,
- 56:52Dan DeLong: but I was and, they do these things in all sorts of different ways, right?
- 56:58Dan DeLong: It's, they- Put people into a meeting, a virtual meeting, or,"Hey, log into this"- Yeah and then they give the announcement.
- 57:09Dan DeLong: There were stories of a, There was one time, there was one time they took, they, exited people out of the building, took them to a spring training game, because in Tucson they do spring training, and at that point anybody who did not go to that event was informed.
- 57:33Dan DeLong: Which- Which was interesting.
- 57:36Sharrin Fuller: So if you couldn't make it, so my dad or my dad's on his deathbed, they're like,"Yeah, sucks to be you.
- 57:42Sharrin Fuller: We all die.
- 57:43Sharrin Fuller: You should've came to this event"?
- 57:45Dan DeLong: No, not that.
- 57:46Dan DeLong: They, I mean- Oh they invited ev- If you didn't get the invite, then that's that's-
- 57:50Sharrin Fuller: Oh That- Only the people invited were So they brought all the people.
- 57:54Sharrin Fuller: Okay.
- 57:55Sharrin Fuller: Okay.
- 57:55Sharrin Fuller: Yeah.
- 57:56Sharrin Fuller: Did, it, do you remember my book, the story about how they fired the one girl that worked with us?
- 58:00Sharrin Fuller: They took us all to l- breakfast.
- 58:02Sharrin Fuller: We're like,"Where's Christina?" And they're like-"Oh, so she's actually being fired right now.
- 58:08Sharrin Fuller: We didn't want you guys in there when we did it." Yeah.
- 58:09Sharrin Fuller: We're like, I'm like, I was so pissed'cause she was my- my assistant.
- 58:14Sharrin Fuller: I'm like,"Excuse me?
- 58:16Sharrin Fuller: You took us to breakfast and you plied me with mimosas while you fired my assistant that we..."'Cause we were a small group- Yeah very close.
- 58:22Sharrin Fuller: And I'm like,"This was shitty." But then I, now that I own a business, I think there's no right way to...
- 58:27Sharrin Fuller: Honestly, when I let somebody go, I have to be cold and be like,"Didn't work out.
- 58:33Sharrin Fuller: Sorry.
- 58:34Sharrin Fuller: You wanna talk about it more?
- 58:35Sharrin Fuller: Sign your severance agreement, the separation agreement.
- 58:37Sharrin Fuller: I'll pay you, and then we can have a chat about it." But you gotta protect your assets and the rest of your company, and it sucks.
- 58:43Sharrin Fuller: It's just the hardest part of owning a business is people.
- 58:46Dan DeLong: Yeah.
- 58:47Sharrin Fuller: I mean-
- 58:47Dan DeLong: Yeah that's-
- 58:48Sharrin Fuller: Anyhow
- 58:48Dan DeLong: I, made a conscious effort or, a thought in my mind that I was not going to have employees because I did not want to have that conversation.
- 59:00Sharrin Fuller: Yeah.
- 59:00Sharrin Fuller: It's hard, especially when you hire family and friends.
- 59:04Sharrin Fuller: So if you want- if you hire family and friends, you better be prepared to fire family and friends, and that never goes the way you think it will.
- 59:12Sharrin Fuller: I've lost so many friends that I've, was helping them out by giving them a job and then they turned out to be crap employees.
- 59:19Sharrin Fuller: Maybe some my fault, but no, not, some of them were not.
- 59:22Sharrin Fuller: And then I never talked to them.
- 59:23Sharrin Fuller: They got pissed when I fired them.
- 59:25Sharrin Fuller: I'm like what do you want me to do?
- 59:27Sharrin Fuller: You were stealing time." what do you want me to...
- 59:30Sharrin Fuller: What do I do here?
- 59:31Sharrin Fuller: I'm saying we're still gonna go get beers.
- 59:33Sharrin Fuller: I should be like,"F you stole from me." But anyhow, it's just crazy, so anyhow.
- 59:38Sharrin Fuller: That's a whole topic.
- 59:39Sharrin Fuller: Yeah.
- 59:40Dan DeLong: Never a never a great conversation to have or to- No Even consider
- 59:46Sharrin Fuller: having.
- 59:47Sharrin Fuller: You wanna know the best part is when you're doing so well in business you hire somebody that does it for you.
- 59:51Sharrin Fuller: I had a director of operations- my four-foot, four-foot nothing.
- 59:55Sharrin Fuller: She's like 4'8", 97 pound Cuban Monica- and I would send her because any time I'd have to fire somebody I would be violent.
- 1:00:03Sharrin Fuller: I'd be sick for like days and knowing that I was gonna have to let somebody go,'cause just the anxiety of knowing that how they're gonna feel.
- 1:00:10Sharrin Fuller: They're not gonna be able to pay their rent, and I lost my job, and how do I tell my spouse?
- 1:00:13Sharrin Fuller: So I would make her do it.
- 1:00:14Sharrin Fuller: I don't care.
- 1:00:15Dan DeLong: Yeah.
- 1:00:15Sharrin Fuller: I paid her.
- 1:00:15Sharrin Fuller: Yeah,
- 1:00:16Dan DeLong: she would-
- 1:00:16Sharrin Fuller: You're the fire- Do- You're the, chopping block.
- 1:00:19Dan DeLong: Yeah, sh- she would just go in and say- I have no shame
- 1:00:21Sharrin Fuller: in that
- 1:00:22Dan DeLong: Hey, what was your favorite subject in high school?
- 1:00:25Dan DeLong: Mine was history, and so are you."
- 1:00:27Sharrin Fuller: He's...
- 1:00:28Sharrin Fuller: She was even colder about it than I am.
- 1:00:30Sharrin Fuller: Oh, wow.
- 1:00:31Sharrin Fuller: Oh my God, exit interview.
- 1:00:32Sharrin Fuller: There was no exit interview.
- 1:00:34Sharrin Fuller: Exit interview was,"Why did you suck?
- 1:00:36Sharrin Fuller: Oh, you didn't know you sucked.
- 1:00:37Sharrin Fuller: Now you do, but just kidding." All right, Dan, this was a great way to end this very informative webinar.
- 1:00:46Dan DeLong: All right.
- 1:00:46Dan DeLong: We will see you next time on the QB Power Hour when we talk with Fishbowl, and we hope you all have a great day.