Latest / QB Power Hour Podcast / Moving Desktop to Online - Latest Updates [08.19.25]
Transcript
- 0:23Dan DeLong: welcome to another QB Power Hour.
- 0:26Dan DeLong: We're gonna be talking about moving QuickBooks Desktop to QuickBooks Online, the latest updates.
- 0:31Dan DeLong: So we're not we've done lots of best practices and things like that in the past, and we'll share those resources as we go through as we go through our time today.
- 0:44Dan DeLong: But what we want to focus on today is.
- 0:46Dan DeLong: The latest changes since the last time that we've talked about the desktop migration.
- 0:51Dan DeLong: And so there's some pretty cool things that that Intuit has been working on especially if it's dealing with payroll and attachments.
- 1:02Dan DeLong: We'll talk a little bit about that.
- 1:04Dan DeLong: So again my name is Dan DeLong, owner at Danwidth and School of Bookkeeping, worked at Intuit doing all these things with desktop migration when the call, when you would call in and it didn't work, right?
- 1:15Dan DeLong: 'cause that never happens.
- 1:18Dan DeLong: The co-hosting today, also at over at Workshop Wednesdays at School of Bookkeeping and the feature Deep Dive host over at the unofficial QuickBooks Accountant Podcast.
- 1:30Dan DeLong: And I'm almost in, almost done with tech editing.
- 1:35Dan DeLong: The next session of QBO for Dummies, which is.
- 1:38Dan DeLong: Really interesting this time of year because with the new user interface, they are the au I don't I, don't I don't envy the author trying to write a book about QuickBooks online in the midst of a ui change.
- 1:57Dan DeLong: But the, not me Matthew, unfortunately, again, is not joining us today, but Phil in sliding in is Sharrin Fuller.
- 2:05Dan DeLong: So Sharrin for those that don't know who you are, give a little give a little.
- 2:13Sharrin Fuller: I, ate Matt disappoint everybody.
- 2:17Sharrin Fuller: I feel like people jump on this thing to see when Matt's gonna be back and they see my face.
- 2:20Sharrin Fuller: They're like twice.
- 2:22Sharrin Fuller: Sharrin Fuller accounting firm owner times three, almost a former accounting firm, owner times three.
- 2:29Sharrin Fuller: Super excited for that.
- 2:30Sharrin Fuller: Now just working on helping accountants and accounting firms really grow their business and work.
- 2:37Sharrin Fuller: On it, not in it.
- 2:38Sharrin Fuller: And just jumping in where, wherever I can here.
- 2:42Sharrin Fuller: And also, we come from a QuickBooks only firm.
- 2:47Sharrin Fuller: It's all I've known, all I've grown to love.
- 2:48Sharrin Fuller: And with love, there is hate, but you can't have hate without love.
- 2:52Sharrin Fuller: So here I am.
- 2:54Dan DeLong: Here we are.
- 2:54Dan DeLong: All right.
- 2:56Dan DeLong: So let's talk a little bit about the QB Power Hour if you're just joining us for the first time.
- 3:01Dan DeLong: It's every other Tuesday at noon Eastern.
- 3:04Dan DeLong: And now that I'm driving around the country, I don't know what time I'm in.
- 3:11Dan DeLong: But we do have CPE credit available through earmark there's the QR code for that, and there's link in the in the slides there to be able to access our channel.
- 3:26Dan DeLong: All of our prior ones are available there.
- 3:29Dan DeLong: As of today, except today's.
- 3:32Dan DeLong: And then of course, if you need to, you can go to qb power hour.com/resources for PDFs of the prior slides, past recordings as well as the podcast audio as well.
- 3:45Dan DeLong: All right, so today we're gonna talk a little bit the Intuit News.
- 3:49Dan DeLong: We're, we've been incorporating some of the latest, and I don't wanna say greatest, but the news that Intuit has, done since the last time, and we wanna talk about it.
- 4:01Dan DeLong: Maybe there was a Facebook post about it or something like that.
- 4:04Dan DeLong: And we want to, just calibrate, that's the word I was looking for about about that topic.
- 4:12Dan DeLong: But really our topics the meat and potatoes of what we're gonna be talking about today is the desktop conversion.
- 4:19Dan DeLong: Some new options more data.
- 4:21Dan DeLong: They're allowing for more data.
- 4:23Dan DeLong: We'll talk about that.
- 4:25Dan DeLong: There are some checklists inside of QuickBooks Desktop, and one of those unraveled the payroll I issue that we're gonna be talking about later on.
- 4:39Dan DeLong: The ability now to do accounting only migrations when you already have a payroll subscription.
- 4:47Dan DeLong: And then attachments, which was always a, I don't know, it was just a sad conversation when somebody said, Hey, do you do attachments?
- 4:58Dan DeLong: Move?
- 4:59Dan DeLong: And then the short answer was, no, they didn't, but now they do.
- 5:04Dan DeLong: Which which is cool.
- 5:06Dan DeLong: And then we'll give you some resources at the end there.
- 5:10Dan DeLong: So let's start with our first polling question.
- 5:14Dan DeLong: Do you help?
- 5:17Dan DeLong: Where'd it go?
- 5:17Dan DeLong: It just, I have five monitors.
- 5:20Dan DeLong: Yeah.
- 5:21Dan DeLong: Check one and see where they went.
- 5:23Dan DeLong: Do you help clients with desktop migration?
- 5:26Dan DeLong: Now, Sharrin, since you were QBO or QB only as, as far as your firms, did you do that as part of your scope of work?
- 5:34Dan DeLong: Oh, yeah.
- 5:35Sharrin Fuller: We haven't done one for a hot minute, I can tell you that.
- 5:37Sharrin Fuller: I think the last time we did a mar migration was like 20, or Jesus, was it in the, I was gonna say 2020 something, but it had to have been in the teens.
- 5:47Sharrin Fuller: 1918 haven't done one since then.
- 5:53Sharrin Fuller: There were workarounds to get it to work.
- 5:55Sharrin Fuller: Properly.
- 5:56Sharrin Fuller: So I would love, I'm really excited to see what people have to say about it now.
- 6:02Dan DeLong: Yeah.
- 6:02Dan DeLong: Probably back then you, we typically back in the day.
- 6:06Sharrin Fuller: Thanks Dan.
- 6:07Sharrin Fuller: Thanks.
- 6:07Sharrin Fuller: Yeah.
- 6:08Dan DeLong: Back in the last decade when you just needed to do these things, you probably had some of the conversations of we're gonna have to.
- 6:17Dan DeLong: Purge off some of your detailed data or, yeah.
- 6:20Dan DeLong: Maybe we're just gonna start over.
- 6:22Dan DeLong: When we Yeah.
- 6:23Dan DeLong: When we, come over to QBO, because you end up having this conversation of this isn't gonna come over properly.
- 6:31Dan DeLong: Or we, you, you've been using desktop too long And, those types of things.
- 6:38Dan DeLong: So now some of those conversations have shifted as far as what you're able to do and the big Yeah.
- 6:47Dan DeLong: But when you have a lot of these conversations is like when you're using desktop payroll and moving over to QuickBooks on online typically that conversation was we're gonna have to set up payroll again.
- 7:05Dan DeLong: Because it just doesn't migrate over very well.
- 7:09Sharrin Fuller: Yep.
- 7:10Dan DeLong: But I don't wanna spoil it, but I am I did a migration just a couple weeks ago.
- 7:20Dan DeLong: They their retail establishments, so high turnover, right?
- 7:24Dan DeLong: So they had lots of employees in, their QuickBooks Desktop, 431 employees active not all active, but historically, and all of them came over to QuickBooks online, and the direct deposit was set up, and it was the, their paid, their pay types was set up.
- 7:47Dan DeLong: It was the clouds parted for me because it was just one of those things where you're just like, oh my goodness, I'm not dreaded.
- 7:55Dan DeLong: I'm not looking forward to setting up 431 employees, even if it's not all the active employees.
- 8:03Dan DeLong: So let's go ahead.
- 8:06Dan DeLong: Where's my cursor?
- 8:08Dan DeLong: Get up.
- 8:09Dan DeLong: Find it.
- 8:10Dan DeLong: All right.
- 8:10Dan DeLong: So yeah, it looks like this Zoom decide to pop up differently.
- 8:16Dan DeLong: Yeah, we go.
- 8:16Dan DeLong: So about the need to be, feel more comfortable.
- 8:21Dan DeLong: Okay.
- 8:21Dan DeLong: So looks like that's our, main answer of that.
- 8:26Dan DeLong: And then a lot of people do it all the time.
- 8:28Dan DeLong: So let's go ahead and kick us in here.
- 8:33Dan DeLong: So the new options with desktop migration, more data, right?
- 8:38Dan DeLong: So originally the a lot of times when you look at, what's, able to move over the key number, the key data specific aspect I can't think of the word right, is targets, right?
- 8:55Dan DeLong: And of course, that always begs the question what the heck is a target?
- 9:00Dan DeLong: But basically it's a link in a transaction to something else in.
- 9:05Dan DeLong: In your QuickBooks data file and you have an invoice, it's got a customer on it, it's got items on it, and multiple line items, and those are pointing to accounts.
- 9:14Dan DeLong: All of those things go into the target calculation.
- 9:19Dan DeLong: So it's not just the size of your file, it's the size of the transactions that are in the file.
- 9:28Dan DeLong: And a as of July, it was 1.5 million and, or I'm sorry, in February I noticed it was upgraded to 1.5 million.
- 9:38Dan DeLong: And then the last couple times that I've done a conversion, it's now 2 million on the Intuit article.
- 9:45Dan DeLong: So it really does allow for a lot of data to to be moved over.
- 9:54Dan DeLong: I was just talking with with somebody, considering they have 2.3 million, but they've been using QuickBooks Desktop since 2000.
- 10:04Dan DeLong: So almost 20 years of data, right?
- 10:06Dan DeLong: So that is not bio like a brick.
- 10:09Sharrin Fuller: Yeah.
- 10:11Dan DeLong: It's a very large,
- 10:12Sharrin Fuller: throw it at someone and hurt'em.
- 10:16Dan DeLong: So the double side of that coin the other side of that coin is yeah.
- 10:23Dan DeLong: Just because it's eligible to come over doesn't mean it was used properly.
- 10:27Dan DeLong: And sometimes that, that data is then going to be the creative ways that people use QuickBooks, especially in QuickBooks desktop, because you can do a lot of things that you maybe know, not aren't supposed to.
- 10:43Dan DeLong: But those things are gonna bubble up to the surface.
- 10:47Dan DeLong: Take that with a grain of salt.
- 10:49Dan DeLong: Just because it's eligible to come over doesn't mean it should come over because it may cause more problems when it actually does come over.
- 10:58Dan DeLong: Now inside of QuickBooks desktop, there's now some checklists.
- 11:02Dan DeLong: And that checklist actually triggered this whole being able to migrate payroll properly.
- 11:11Dan DeLong: So it was actually a key thing that we're gonna, we're gonna unpack a little bit here.
- 11:19Dan DeLong: And inside of the QuickBooks desktop right now, you have a, migration status, right?
- 11:24Dan DeLong: In desktop.
- 11:25Dan DeLong: So you'll be able to see before it was just like you said it, and then once it said, yeah, we got it, and and then you waited.
- 11:36Sharrin Fuller: Yeah.
- 11:36Dan DeLong: And you had no idea the expectation of how long that was gonna take.
- 11:42Dan DeLong: You just waited for an email and hope that email shows up, or just sit there and knock on the door of, QuickBooks online, waiting to be led in.
- 11:54Dan DeLong: And then you do have the option now for accounting only.
- 11:58Dan DeLong: If you have QuickBooks Online payroll subscription you, in, in the past you, you couldn't bring that accounting data into QuickBooks Online payroll.
- 12:10Dan DeLong: Because when there was payroll already established it just stopped the, the, conversion from actually taking place.
- 12:19Dan DeLong: So then you had this situation where you had a QuickBooks Online subscription and a QuickBooks Online payroll subscription, and they never talked.
- 12:26Dan DeLong: They talked to each other Yeah, that with an export, but they weren't completely integrated.
- 12:32Dan DeLong: And another thing you have there is lists only.
- 12:38Dan DeLong: You have some options when the file is too big and you want to take that line in the sand approach, you can choose lists and balances.
- 12:46Dan DeLong: But now you can also choose lists only and choose some of those lists.
- 12:51Dan DeLong: So right there from within the, the desktop migration.
- 12:56Dan DeLong: Now I've just been rambling on there.
- 12:59Dan DeLong: Sharing.
- 12:59Dan DeLong: Are you just do you have something to add to that or?
- 13:04Dan DeLong: I do.
- 13:05Dan DeLong: It's uhhuh
- 13:05Sharrin Fuller: It's all been no, this is great.
- 13:07Sharrin Fuller: I'm thinking about this and I'm really just thinking back like how I'm reading some of the questions I'm thinking about, like what a.
- 13:14Sharrin Fuller: When you got a large file, you had to archive things out, things like that.
- 13:19Sharrin Fuller: And all of a sudden they're like, Hey we're letting you guys do all this great.
- 13:23Sharrin Fuller: And I think'cause everybody keeps saying, oh, I'll never get off of desktop, and I see things like this.
- 13:27Sharrin Fuller: And I'm like, I don't think they're going to give you a choice.
- 13:31Sharrin Fuller: This just tells me they're trying to make it so easy and accommodating.
- 13:34Sharrin Fuller: Like they just said, if have quick QuickBooks do it for you, they wouldn't even touch it back in the day because they made more money on their desktop.
- 13:41Sharrin Fuller: Anyhow, it's just interesting to me.
- 13:42Sharrin Fuller: But definitely something that's needed if you're, if they're really trying to migrate their longtime enterpriser users off it's a good thing at least if they're the desktop, people are gonna have their hands tied behind their back.
- 13:55Sharrin Fuller: At least they have options.
- 13:57Sharrin Fuller: And they're not gonna be in a struggle bus.
- 14:00Sharrin Fuller: That's my opinion.
- 14:01Dan DeLong: And then it all comes down to how that data actually does make the journey.
- 14:07Dan DeLong: And QuickBooks has a really robust article.
- 14:10Dan DeLong: The challenge is if you hand that to a customer they may not understand.
- 14:17Dan DeLong: The full effect of what it is.
- 14:19Dan DeLong: And so I've decided to take that article and create a resource on school bookkeeping here.
- 14:28Dan DeLong: I just wanna open that up here.
- 14:31Dan DeLong: There it is.
- 14:32Dan DeLong: Okay.
- 14:33Dan DeLong: If I scroll down here, where did it go?
- 14:37Dan DeLong: It's supposed to be right here.
- 14:39Dan DeLong: Why is it not?
- 14:40Sharrin Fuller: Because you're in preview mode, Dan.
- 14:42Sharrin Fuller: That's why.
- 14:43Dan DeLong: It's not supposed to come on.
- 14:45Dan DeLong: Where are you?
- 14:46Dan DeLong: There it is.
- 14:46Dan DeLong: It just needed.
- 14:47Dan DeLong: There
- 14:47Sharrin Fuller: we go.
- 14:50Dan DeLong: It does need to speak.
- 14:52Dan DeLong: Go up to space in the back.
- 14:55Dan DeLong: So I created a little spreadsheet in here and you're able to, assuming that you can click on this.
- 15:03Dan DeLong: There we go.
- 15:04Dan DeLong: You can sort for sort, I'm sorry, filter the spreadsheet for specific workflows.
- 15:11Dan DeLong: Let's just click out on this here on now.
- 15:14Dan DeLong: There we go.
- 15:15Dan DeLong: So an example so we have, does it exist in QuickBooks Desktop?
- 15:19Dan DeLong: Does it exist in QuickBooks Online?
- 15:21Dan DeLong: And then Dan's Pro tips here what's different about the QuickBooks online versus desktop?
- 15:29Dan DeLong: And more importantly, does it convert?
- 15:34Dan DeLong: So just kinda looking at the chart of accounts.
- 15:36Dan DeLong: Yes, of course.
- 15:37Dan DeLong: It's you have chart of accounts in both QuickBooks Online has an additional account type called detail type which, doesn't exist in QuickBooks desktop.
- 15:51Dan DeLong: So if you're importing right from Excel, then that's a consideration, right?
- 15:57Dan DeLong: So you don't have that consideration when it's QuickBooks desktop doing it.
- 16:03Dan DeLong: And then of course here, the QuickBooks will move, doesn't convert.
- 16:07Dan DeLong: Your QuickBooks online will move the accounts and assign them the detail types.
- 16:10Dan DeLong: You can change this later if you like bank account numbers and notes do not convert, right?
- 16:15Dan DeLong: So it's just one of those things to give you an idea of and, then set your expectations as to what's actually gonna happen during the conversion.
- 16:26Dan DeLong: Go down here to multiple shipping.
- 16:29Dan DeLong: This is really cool.
- 16:30Sharrin Fuller: Is this online?
- 16:31Sharrin Fuller: This is online for anybody, right?
- 16:32Sharrin Fuller: See, this is totally free.
- 16:34Sharrin Fuller: This is a look at this Cool little, this is, I'm gonna bookmark this.
- 16:39Dan DeLong: Yeah.
- 16:40Dan DeLong: And then multiple shipping addresses, right?
- 16:44Dan DeLong: Yes, in QuickBooks Desktop you can have up to 10,000 multiple shipping addresses.
- 16:49Dan DeLong: I'm not sure if that's across all of your customers or for each customer, but either way, that's a lot of multiple shipping addresses.
- 16:58Dan DeLong: Yeah, enterprise gives you a hundred thousand and in QuickBooks online, womp, right?
- 17:05Dan DeLong: No, not support it.
- 17:08Dan DeLong: So that becomes a challenge, right?
- 17:10Dan DeLong: So then this is now a conversation starter with between you and your client.
- 17:15Dan DeLong: Do I have multiple shipping addresses?
- 17:19Dan DeLong: Yeah, the feature with Bill to, or Bill with Parent exists and you have the, same hierarchy.
- 17:26Dan DeLong: But typically what you're gonna need to do is come up with a game plan of how if multiple shipping addresses per customer is a thing, right?
- 17:36Dan DeLong: So we're gonna need to make a game plan about that.
- 17:39Dan DeLong: And then what happens when it actually converts?
- 17:42Dan DeLong: It only converts one shipping address and not perfectly right?
- 17:47Dan DeLong: So it comes through as a one line item or one, one item or one field instead of splitting it out address line one, two, city, state, zip.
- 17:58Dan DeLong: So you're probably gonna need to go through and modify some of those shipping addresses too.
- 18:04Sharrin Fuller: I have thoughts on that real quick.
- 18:06Sharrin Fuller: Can I say, ask something?
- 18:07Sharrin Fuller: So what would you, I know what I would suggest, but if your clients came to you and said, how would you do, what would you tell them how to solve for that situation?
- 18:17Dan DeLong: I, it really just begs more questions like what you could do.
- 18:21Dan DeLong: Yeah.
- 18:22Dan DeLong: In with projects and sub customers.
- 18:25Dan DeLong: So that's probably how I would if they wanna stay within QuickBooks
- 18:32Sharrin Fuller: online
- 18:33Dan DeLong: Is setting up projects or, jobs in that hierarchy because then you'll have the bill with parent option.
- 18:41Dan DeLong: So Yeah.
- 18:41Dan DeLong: Which is what
- 18:41Sharrin Fuller: matters and where you can run the report.
- 18:43Sharrin Fuller: Yeah.
- 18:44Sharrin Fuller: And I was thinking I would just set up probably a different sub customer for each shipping location if I had to track it that way.
- 18:49Sharrin Fuller: 'cause then I'm rolling it up.
- 18:51Sharrin Fuller: I don't know, I was trying to solve for something that we probably aren't looking to solve for right now, but
- 18:58Dan DeLong: Someone
- 18:58Sharrin Fuller: wants to know.
- 18:59Dan DeLong: That's probably what I would recommend is if they wanna stay within the QuickBooks ecosystem and not look into some other application that might be able to support the multiple shipping addresses per person.
- 19:15Dan DeLong: So you have access to that.
- 19:17Dan DeLong: Okay, so let's talk a little bit about the checklist and the status.
- 19:21Dan DeLong: This is contextual based on the file, right?
- 19:24Dan DeLong: So here in the screenshot it's got one of nine and when I go through a little walkthrough here, it'll say zero of, I'm sorry, zero of nine.
- 19:34Dan DeLong: So there's nine things for me to look at based off of the current file that I'm in.
- 19:39Dan DeLong: And in the sample company, there's only six.
- 19:42Dan DeLong: So it, is contextual in that checklist based off of features and functions that you have evaluated.
- 19:50Dan DeLong: And then you're gonna have or, activated, I should say and you're gonna see the estimated time.
- 19:55Dan DeLong: When I did one this morning it gave me 20 minutes and estimated time of 20 minutes, and it was actually correct, and it will give you a status at the end, right?
- 20:05Dan DeLong: So say, oh, we couldn't do it, or your QuickBooks online has a new home, right?
- 20:11Dan DeLong: So you'll be able to see that all within desktop.
- 20:15Dan DeLong: And at the point of where it's what I call baking, right?
- 20:19Dan DeLong: You combine the ingredients into, the bowl, put the put the cake in the oven, and it's baking where it's processing the the imported file.
- 20:32Dan DeLong: At that point you, can leave QuickBooks Desktop if you want.
- 20:36Dan DeLong: You don't have to keep it open, but if you do, just keep it open there, you can see the status as it's going through and then afterwards, right?
- 20:45Dan DeLong: So there's, some post-conversion best practices that we we've talked about here in the past.
- 20:52Dan DeLong: Doing this as the accountant user, you actually get a better import summary report.
- 20:57Sharrin Fuller: That comes
- 20:58Dan DeLong: rather than the migration hub report that you can download or anybody can download as soon as you go and log into QuickBooks.
- 21:08Dan DeLong: But if you do this as an accountant user you get a better import summary to give you an understanding as to why things happened the way they happened.
- 21:18Dan DeLong: And then there is a to-do list checklist that Intuit made available, but I don't know, I can't find it anymore.
- 21:25Dan DeLong: So I just stole it and saved it for the internet.
- 21:31Sharrin Fuller: There you go.
- 21:33Dan DeLong: But if you wanna get that checklist, it's really, it's actually pretty cool because it has like free.
- 21:39Dan DeLong: Pre pre-work like to go through some of these things that we were seeing on the conversion checklist on the, spreadsheet.
- 21:47Dan DeLong: But you can assign who's going to do that and things.
- 21:51Dan DeLong: So that built in, it has dropdowns and whatnot.
- 21:55Dan DeLong: And on the other, on some of the other tabs that are in there, it gives you you, you can specify like who's gonna do what, right?
- 22:06Dan DeLong: And over here on the right this little check boxes gives you an understanding of what level of subscription that they would need based off of functions and features that they would workflows that they would need to have.
- 22:22Dan DeLong: So make sure you put'em in the right, right version to begin with.
- 22:27Dan DeLong: Typically, I recommend start with advanced'cause you typically get the best.
- 22:33Dan DeLong: Feature set.
- 22:34Dan DeLong: And then you also get a discount that first year.
- 22:37Dan DeLong: And then at the end of that promo you can decide, okay, I'm not using all of these features.
- 22:42Dan DeLong: I can downgrade at that point.
- 22:45Dan DeLong: All right, so let's walk through migration here.
- 22:48Dan DeLong: Here we go.
- 22:49Dan DeLong: We already had that.
- 22:50Sharrin Fuller: You put some work into this, didn't you?
- 22:52Dan DeLong: I know.
- 22:53Dan DeLong: All right, so I'm gonna share over here and my, okay.
- 23:00Dan DeLong: I'll just do the entire screen.
- 23:01Dan DeLong: Hopefully I don't go into a vortex.
- 23:06Dan DeLong: All right.
- 23:08Dan DeLong: And I've got a whole bunch of Zoom stuff in the way.
- 23:11Dan DeLong: All right.
- 23:12Dan DeLong: So here is just a sample company, right?
- 23:15Dan DeLong: And and I know some of you're saying, Hey, you can't migrate a sample company.
- 23:20Dan DeLong: Yes, as long as you can remove the sample company flag.
- 23:27Dan DeLong: When I was there.
- 23:28Dan DeLong: This was a fireable offense telling people about this, but Hector Garcia's got a video about it.
- 23:36Dan DeLong: If they they want to take out a Hector and myself, they can.
- 23:40Sharrin Fuller: There you go.
- 23:41Sharrin Fuller: All right.
- 23:41Sharrin Fuller: Come at me, bro.
- 23:42Sharrin Fuller: Just kidding.
- 23:42Sharrin Fuller: Don't.
- 23:43Sharrin Fuller: Yeah, please don't into it.
- 23:43Sharrin Fuller: Please don't.
- 23:46Dan DeLong: All right.
- 23:47Dan DeLong: So if you go to help and about, you bring up the, help and about screen, and then you press control ALT DB or d debug and then go back to the help menu.
- 24:01Dan DeLong: You have this little extra tell tech support option, which gives you a lot of cool things that you can do in the desktop file that you can't normally do.
- 24:12Dan DeLong: But one of them is toggle the Sample Company Flag.
- 24:15Dan DeLong: So if you're in the sample company and you want to turn it into a real company, you can do that.
- 24:21Dan DeLong: Or if you're in a real company and you just want to turn it into a sample company, you can do that too.
- 24:27Dan DeLong: But that's a, that's an option in there.
- 24:30Dan DeLong: All right.
- 24:30Dan DeLong: So to to get to the point of migrating this is enterprise.
- 24:39Dan DeLong: So you don't have the the company drop from the company menu.
- 24:43Dan DeLong: You don't have this option that says export to QuickBooks Online.
- 24:48Dan DeLong: So in enterprise you have to bring up the product information window, and then once you're in there, you hold the control and t say BQ, and then click okay.
- 25:05Dan DeLong: Okay.
- 25:05Dan DeLong: And there it comes and hope that this screen comes up.
- 25:11Dan DeLong: All right.
- 25:11Dan DeLong: And then once you're in there, just.
- 25:14Dan DeLong: This is what I was talking about, this checklist, right?
- 25:16Dan DeLong: You can click on the checklist and it will open up this checklist eventually and give you some ideas of things that you should probably do before migrating, right?
- 25:29Dan DeLong: Like double check your list of active customers, right?
- 25:32Dan DeLong: So you wanna make sure that the customers who are inactive should be inactive.
- 25:38Dan DeLong: And one of the big things about that is you don't wanna have an inactive customer with a balance or an inactive inventory item that has a quantity on hand.
- 25:49Dan DeLong: Because when it tries to re inactivate them, there will be a problem.
- 25:54Dan DeLong: So that's just one of the things that you want to comb through prior to doing to doing the conversion.
- 26:01Dan DeLong: And then anything else in here you just wanna take a look at?
- 26:06Dan DeLong: Now I have to close outta this and start all over.
- 26:08Dan DeLong: 'cause that checklist thing, which is usually what you would be doing, is actually, yeah.
- 26:14Dan DeLong: Oh I, should check this.
- 26:15Dan DeLong: So I should not convert my, data just yet, but we're gonna throw caution into the wind and just go right for it and get the zoom stuff out of the way.
- 26:32Dan DeLong: And we're gonna get started.
- 26:33Dan DeLong: Now, I recommend doing setting it up inside of your QuickBooks Online accountant first, so that you already have the subscription in place.
- 26:43Dan DeLong: You're already listed as the accountant user and then you can of course transfer your, stuff over to your clients, right?
- 26:51Dan DeLong: So here's the option.
- 26:52Dan DeLong: When you the first option that you're given is, do I want to bring over all my company data or do I want to bring over lists and balances?
- 27:02Dan DeLong: And then when I choose.
- 27:03Dan DeLong: Bring over list and balances, then I have all lists and balances, and you have a little help bubble there of what will actually come over or if I just only want to choose lists, and then I have a dropdown of which list that I wanna choose, right?
- 27:17Dan DeLong: So these are the choices of the options of say you don't wanna bring over the items because they did make such a mess of their inventory and you wanna start over, or something along those lines.
- 27:30Dan DeLong: So those are the options there.
- 27:31Dan DeLong: I'm gonna choose all data and then this whole question about inventory tracking.
- 27:40Dan DeLong: Do I wanna track inventory?
- 27:42Dan DeLong: If yes, then I gotta choose A-F-I-F-O date because QuickBooks Online uses fi first in, first out Cal cost calculation, QuickBooks desktop uses weighted average.
- 27:54Dan DeLong: Or if you're using advanced inventory, it does use FIFO.
- 27:59Dan DeLong: But keeping in mind all about.
- 28:03Dan DeLong: You that's a whole nother topic about the inventory considerations of, moving things over.
- 28:10Dan DeLong: Or you could choose don't move over inventory.
- 28:13Dan DeLong: And what that does is it actually turns every single inventory item during the conversion into non-inventory parts.
- 28:21Dan DeLong: The financial impact of all of that actually is is handled based on historical transactions.
- 28:30Dan DeLong: But every inventory part becomes a non-inventory part.
- 28:34Dan DeLong: And then you can go through and clean up the items, turn on the, inventory for those items if you wanted to, or just start fresh if you want, but you gotta have the item in your item list or your products and service list in order for the historical, impact of those transactions to make the journey.
- 28:56Sharrin Fuller: And part of me would wanna transfer it over and just journal it out.
- 29:00Sharrin Fuller: I don't know that I would trust the process enough.
- 29:02Sharrin Fuller: I'd feel I'd rather transfer it, look at my balance sheet or my inventory on my desktop, confirm it went over correctly, and then go in and make one huge journal entry, readjusting and removing my inventory.
- 29:15Sharrin Fuller: That's just me.
- 29:15Sharrin Fuller: I just, that scares me.
- 29:18Dan DeLong: Yeah.
- 29:18Sharrin Fuller: Doesn't migration's scary?
- 29:21Dan DeLong: And that's part of the best practices here is that doing this as a, in a trial version of QuickBooks Online before doing it for a live subscription it always will give you a good guidance as to what we're in for, right?
- 29:36Dan DeLong: So there's only so much that you can do with QuickBooks combing through the data and the settings.
- 29:44Dan DeLong: To really see what is it gonna actually do today?
- 29:48Dan DeLong: So I tend to do it in a trial.
- 29:51Dan DeLong: You get the import summary that's gonna give you some guidance as to what you may want to take care of.
- 29:58Dan DeLong: And I did this prior to the session today and I got the import summary, and of course it didn't match.
- 30:07Dan DeLong: This is a good example of doing that.
- 30:10Dan DeLong: So at this point, you're gonna choose a date and what date you actually choose.
- 30:16Dan DeLong: There is a good question.
- 30:20Dan DeLong: But that's a conversation, right?
- 30:22Dan DeLong: And then what's gonna happen is gonna, assuming you're signed in, which I was, and I am, I think it does have Zoom window, is it is, it's giving me a, conniption there.
- 30:40Dan DeLong: Lemme start this over here.
- 30:47Dan DeLong: All these things are in the way of this one screen.
- 30:51Dan DeLong: All right.
- 30:52Dan DeLong: All right.
- 30:53Dan DeLong: Then you, it's gonna ask you to sign in if you're not already signed in.
- 30:59Dan DeLong: And then once you sign in, then it's gonna give you a list of companies that you might wanna bring these that are available to, to bring them into.
- 31:09Dan DeLong: I'm like, actually not gonna sign in at this point because everybody knows how to sign in.
- 31:15Dan DeLong: But it'll bring a list of companies and if there's already payroll in there, it will say, you can bring over accounting accounting only.
- 31:24Dan DeLong: And then at that point you start walking through, it just starts the process of, uploading and gives you, that, gives you that status.
- 31:32Dan DeLong: Lemme go ahead and stop sharing here and we'll restart sharing over here.
- 31:39Dan DeLong: And there we are.
- 31:40Dan DeLong: Okay.
- 31:41Dan DeLong: So far, so good.
- 31:44Dan DeLong: All right, so that's the process of, migrating with the new options that are, available.
- 31:52Dan DeLong: While that's processing we want to talk a little bit about the Intuit news.
- 32:00Dan DeLong: We've talked a lot, a little bit in the past about the login issues, the vulnerability of accountants and bookkeepers and ProAdvisors of potentially having their email login, intuit login compromise.
- 32:19Dan DeLong: So on the tails of that a lot of people have gone in and noticed, hey, there wasn't a code that was sent.
- 32:28Dan DeLong: And so they go in and they check a setting inside of their Intuit account, and lo and behold, they see that two step verification is turned off.
- 32:37Dan DeLong: And of course under that, it, under that circumstance, that will be concerning, right?
- 32:45Dan DeLong: Like that, that normal process of not getting your code and then going in and seeing that there's a setting that would send that code turned off.
- 32:57Dan DeLong: Is concerning, right?
- 32:58Dan DeLong: Like the logical concern, right?
- 33:01Dan DeLong: So I spoke to the folks over at Intuit and just wanted to make sure that people are aware there is a difference between multi-factor authentication and the two-step verification process or the two step verification setting inside of your account.
- 33:20Dan DeLong: So it's the same but it's different, right?
- 33:23Dan DeLong: So the same, that multifactor authentication and two step verification results in the same thing, you get a six digit code which will verify.
- 33:35Dan DeLong: Your, identity when you get, when you try to log in, but they're different in that multifactor authentication or MFA is mandatory.
- 33:45Dan DeLong: You cannot opt out of MFA.
- 33:49Dan DeLong: But this will occur when a new login is detected.
- 33:53Dan DeLong: So if I were to sign into QuickBooks Desktop for the first time, it's gonna ask me to verify my myself when I go and sign in, if I hypothetically move from Cold Water Michigan to outside of Chicago and sign in sign into QuickBooks, that is a new login, even though it may have happened on the same day, but because I'm now physically in a different location that is a new login to, to to Intuit, so that is gonna send me a code.
- 34:27Dan DeLong: Two step is actually an optional thing.
- 34:31Dan DeLong: It's an extra layer of security that you are opting into your login, and by default, they're turned off.
- 34:39Dan DeLong: So don't be surprised when you go and check your login and see that two step is turned off.
- 34:45Dan DeLong: Yeah.
- 34:45Dan DeLong: Now, if you turned it on and you know that you opted in and it's turned off, that's a different story.
- 34:53Dan DeLong: And that's, I think where the, line that we're, drawing here is that if you didn't, if you turned on two-step verification and it's now turned off, then that's a reason to question like what happened.
- 35:09Dan DeLong: But by, and by and large, if I go in and look at most of my accounts, I don't have two step verification turned off.
- 35:18Sharrin Fuller: You
- 35:18Dan DeLong: don't, I don't have the option for turn.
- 35:23Dan DeLong: I don't have it turned on.
- 35:25Dan DeLong: I rely actually on the pass keys.
- 35:28Dan DeLong: Which is a third.
- 35:30Dan DeLong: Oh, the keys.
- 35:31Dan DeLong: Got you.
- 35:31Dan DeLong: Which is the third option.
- 35:33Sharrin Fuller: I am a VPN user.
- 35:35Sharrin Fuller: 'cause I've watched too much Edward Snowden, and so I I have to do it every single time, so I didn't realize that it wasn't just a thing.
- 35:45Sharrin Fuller: I know this has been a, in your group and a lot, this has been a huge controversy lately, so I feel like they solved for a problem.
- 35:53Sharrin Fuller: We weren't asking, but at least it's a step in the right direction.
- 35:56Sharrin Fuller: I don't know.
- 35:56Sharrin Fuller: It's a step in the right direction.
- 35:58Dan DeLong: So they created a nice a nice article talks about the difference between the MFA and the two step verification, as well as talking about some of the passkey options as well.
- 36:11Dan DeLong: And we've got some resources there about what passkey are with.
- 36:16Dan DeLong: But by the way, with passkey, you don't have to.
- 36:19Dan DeLong: Use the code, right?
- 36:21Dan DeLong: So that, I mean that both of these processes are removed out of the issue.
- 36:27Dan DeLong: Be when, you use a pass key.
- 36:30Dan DeLong: I just get really confused about passkey when I log in.
- 36:34Sharrin Fuller: You prefer it more than I'm, actually talking about murf here in the q and a'cause he likes using the q and a instead of the chat, but Murph's old.
- 36:42Sharrin Fuller: It's okay.
- 36:44Sharrin Fuller: I prefer the two fa because I wanna know if I have a pass key, they can't get in.
- 36:50Sharrin Fuller: I like knowing that when I get to go and log in, it's set you a code and if I'm just sitting there on my couch watching tv, I'm like, who is trying to get in my account?
- 36:58Sharrin Fuller: And then I go in and I, freak out.
- 37:01Sharrin Fuller: But I have a couple things I use a passkey for.
- 37:03Sharrin Fuller: Like Google.
- 37:03Sharrin Fuller: Does it work the same?
- 37:05Dan DeLong: Yeah, it's you can use biometrics, right?
- 37:08Dan DeLong: So I have a, yeah.
- 37:09Dan DeLong: Fingerprint
- 37:11Sharrin Fuller: option watch.
- 37:11Sharrin Fuller: I watch too many movies, too many to cruise movies.
- 37:15Sharrin Fuller: I don't like it.
- 37:18Dan DeLong: And it, it seems like a really smooth process.
- 37:22Dan DeLong: And we talked about this a little bit on the unofficial QuickBooks Accountants podcast with Alicia.
- 37:29Dan DeLong: And we brought in Jamie, her husband, who is a Mac guy, and he talked a lot about what past he's actually do and and what they actually solve for.
- 37:42Dan DeLong: And one of the things that they solve for is trying to remember what your damn password is.
- 37:46Dan DeLong: Yeah.
- 37:47Dan DeLong: Because that's typically what happens when.
- 37:52Dan DeLong: You want.
- 37:54Dan DeLong: Logins are the bane of our existence these days and trying to remember strong.
- 37:58Dan DeLong: And which hold on.
- 38:01Sharrin Fuller: Let's take one step back here.
- 38:03Sharrin Fuller: You say, remember you're not using something like one pass.
- 38:06Sharrin Fuller: I couldn't even tell you what my pa Oh my gosh.
- 38:09Sharrin Fuller: I'll go to my team.
- 38:10Sharrin Fuller: I'm like, why is your password your dog's name delete new password?
- 38:14Sharrin Fuller: I can't.
- 38:14Sharrin Fuller: No, I have, oh yeah, I watch that.
- 38:16Sharrin Fuller: My watch towers almost just a thousand every day.
- 38:19Sharrin Fuller: 'cause I go crazy.
- 38:19Sharrin Fuller: Course.
- 38:20Sharrin Fuller: I'm like, we have people's data.
- 38:22Sharrin Fuller: Yeah.
- 38:23Sharrin Fuller: Everybody out there.
- 38:24Sharrin Fuller: Of course I do you see this?
- 38:25Sharrin Fuller: If I find out that you're writing down your passwords or you're using your anniversary or something as your password for your clients, I'm coming to your door and we're gonna handle this.
- 38:33Sharrin Fuller: That's all right.
- 38:34Sharrin Fuller: Go ahead, Dan.
- 38:35Dan DeLong: But yeah, of course if you use a password vault but sometimes those aren't synchronized across various devices and why is it working here?
- 38:48Dan DeLong: And then I hate it when Google Chrome password.
- 38:52Dan DeLong: Vault and the password vault you're using Start fighting on the same website and I can't see behind, you know what the popup that came up.
- 39:02Dan DeLong: It's come on.
- 39:03Dan DeLong: Which login is it?
- 39:04Dan DeLong: I don't know, but the pass key is like, Nope.
- 39:06Dan DeLong: Okay, I'm in.
- 39:09Dan DeLong: But we got that there.
- 39:10Dan DeLong: Okay, so next polling question.
- 39:13Sharrin Fuller: Alright.
- 39:14Sharrin Fuller: I can't wait to see this one.
- 39:15Dan DeLong: Do you have two step verification?
- 39:18Dan DeLong: Wait.
- 39:19Dan DeLong: Okay.
- 39:20Dan DeLong: Why does it do that?
- 39:22Dan DeLong: What's it doing?
- 39:24Dan DeLong: No it, every time that I launch the poll on the monitor above my computer the pole jumps down to the left, to the
- 39:33Sharrin Fuller: mine, goes over here to my, I have three monitors.
- 39:35Sharrin Fuller: It's over here in the upper left hand corner and I don't know why.
- 39:39Sharrin Fuller: So Dan, I know you're gonna ask me I know this, I know our back and forth thing here now, so I know you're gonna ask me.
- 39:45Sharrin Fuller: And I think I made that blatantly clear that I actually just went through, we did an audit with our entire team and the one thing, and what made me do this is seeing all the activity of two FA and the issues that people breaking into QuickBooks.
- 39:58Sharrin Fuller: The one thing that I didn't love about Intuit is I have zero control to turn on or off to FA for my team.
- 40:04Sharrin Fuller: I can log in and see if they have it on, but I can't force them to do it.
- 40:08Sharrin Fuller: So now I have, which I can't stand, I don't like manual.
- 40:12Sharrin Fuller: I have this monthly thing where I go in and I make sure that two FA is not shut off for anybody.
- 40:17Sharrin Fuller: And if they do, I kick them out and make them get a new password.
- 40:19Sharrin Fuller: I'm mean.
- 40:22Sharrin Fuller: I don't wanna claim on my insurance of the
- 40:24Dan DeLong: finger from Sharrin.
- 40:25Dan DeLong: You don't want,
- 40:27Sharrin Fuller: nobody wants this, Dan.
- 40:32Dan DeLong: All right.
- 40:32Dan DeLong: And I see Jolene in the q and a.
- 40:34Dan DeLong: So it's is MFA and two-step verification only QBO related or also QBDT.
- 40:41Dan DeLong: So this is Intuit account related.
- 40:44Dan DeLong: So anytime that you sign into anything Intuit related that you uses an Intuit account, that is, whether that's gonna be the MFA or two-step verification, right?
- 40:57Dan DeLong: So this could be TurboTax, this could be.
- 41:00Dan DeLong: Credit Karma.
- 41:00Dan DeLong: This could be anything that could be Intuit related.
- 41:07Dan DeLong: As far as a log,
- 41:08Sharrin Fuller: no, you have T sheets and you should have this on as an accounting firm owner or an accountant at all.
- 41:13Sharrin Fuller: If you have any sort of insurance, like this is a huge, thing.
- 41:17Sharrin Fuller: And with the hackers nowadays, they're good.
- 41:19Sharrin Fuller: You should have some sort of level of protection on absolutely everything beyond MFA in my, actually, in everybody's opinion, this isn't just mine.
- 41:28Sharrin Fuller: This is everybody's.
- 41:29Sharrin Fuller: Yeah.
- 41:29Sharrin Fuller: So go turn'em on right now while you're listening.
- 41:31Sharrin Fuller: Alright.
- 41:33Dan DeLong: All right, so let's go ahead and let's, we're close on the ending here, so I just wanna share the results.
- 41:40Dan DeLong: So hooray.
- 41:42Dan DeLong: Half of you have it turned on already.
- 41:45Dan DeLong: Good job.
- 41:48Dan DeLong: All right.
- 41:49Dan DeLong: Okay.
- 41:50Dan DeLong: Now we're gonna talk about migrating best practices with payroll, right?
- 41:56Dan DeLong: So what happens to payroll during the migration?
- 42:00Dan DeLong: So the financial impact of payroll is migrated before anything regarding the payroll setup process takes place.
- 42:09Dan DeLong: So your employee lists are gonna come over your paycheck liability, your paychecks and liability checks.
- 42:15Dan DeLong: They get turned into regular checks with the accounting impact of that paycheck to be recorded liability adjustments.
- 42:26Dan DeLong: There is no such thing as a liability adjustment in QuickBooks Online payroll or, QuickBooks online without payroll for that matter.
- 42:34Dan DeLong: So they get turned into journal entries, right?
- 42:36Dan DeLong: So the financial impact makes the journey before payroll setup occurs, right then.
- 42:42Dan DeLong: Then the payroll setup.
- 42:45Dan DeLong: Process actually starts after the migration.
- 42:48Dan DeLong: So this is where employee setup occurs, and earnings deductions the direct deposit information.
- 42:57Dan DeLong: And then with regards to actual payroll data, only the current year is gonna come over and be set up because you do it today, right?
- 43:09Dan DeLong: We're in August.
- 43:10Dan DeLong: QuickBooks online payroll is only gonna be concerned about the current year with regards to form filings and tax payments, right?
- 43:18Dan DeLong: So it doesn't care what happened last year, right?
- 43:22Dan DeLong: So keep that in mind that if you're gonna run payroll reports, you're not gonna get them out of the, prior years once this, occurs.
- 43:33Dan DeLong: But you are gonna get year to date payroll payroll amounts so that they're, paycheck pay stub.
- 43:42Dan DeLong: There we go.
- 43:43Dan DeLong: So the pay stub is accurate.
- 43:45Dan DeLong: So you'll see the current pay and the year to date as well as the tax payments because the end of the year you're gonna have the W twos and the year annual form filings that QuickBooks is gonna be able to do.
- 43:57Dan DeLong: And it needs to know all that information for the first year.
- 44:05Dan DeLong: What was I gonna, I thought was this link takes me back over here.
- 44:09Dan DeLong: Okay.
- 44:12Dan DeLong: Next.
- 44:13Dan DeLong: Okay oh, there we go.
- 44:14Dan DeLong: I had another slide.
- 44:17Dan DeLong: So this was the nugget that I saw in that checklist.
- 44:21Dan DeLong: So thank you QuickBooks for pointing me in the right direction.
- 44:25Dan DeLong: So in the checklist there is a, down here, I'll make this a little bigger because I saw okay, Sharrin squinting her eyes.
- 44:35Dan DeLong: In the checklist, there is this setup admin role, permissions in desktop to migrate payroll, direct deposit to QuickBooks Online.
- 44:44Dan DeLong: The QuickBooks online admin must have admin role permissions in QuickBooks Desktop.
- 44:52Dan DeLong: This is not, I'm logging into QuickBooks as the admin, I'm logging into the Intuit account inside of QuickBooks as the primary admin.
- 45:04Dan DeLong: So this is, gets really confusing when we're talking about admins, account, user so on and so forth, right?
- 45:12Dan DeLong: And lo and behold I, come on now.
- 45:16Dan DeLong: So over here, so we, we showed that F two control one screen.
- 45:23Dan DeLong: You'll see this here in the upper right where it talks about Intuit account information.
- 45:30Dan DeLong: That is what it's talking about.
- 45:31Dan DeLong: So whoever's the primary admin in the company needs to be the primary admin who's doing the migration.
- 45:39Dan DeLong: If you want payroll to make the journey, if payroll's not an issue, this is not this is not an issue, right?
- 45:47Dan DeLong: So if you're not gonna be, if you're gonna be using rippling or Gusto or a DP or any time outside of payroll service on pay or anything else, this is really not, this is a moot point anyway.
- 45:59Dan DeLong: 'cause the financial impact is gonna make the journey regardless of what you do here, right?
- 46:03Dan DeLong: So first thing is to update QuickBooks Desktop.
- 46:07Dan DeLong: Make sure you're on the latest version of, desktop.
- 46:10Dan DeLong: The Intuit ID for admins need to match, right?
- 46:14Dan DeLong: So if you're doing this as the accountant, you are an admin by default as the accountant user inside of QuickBooks Online.
- 46:22Dan DeLong: You don't have to be the primary admin in the QuickBooks Online.
- 46:28Dan DeLong: So that's fine.
- 46:29Dan DeLong: But if your login is not the primary admin inside a desktop, then that's going to be a problem when payroll comes to try to migrate, right?
- 46:39Dan DeLong: So there is a way to reset that, right?
- 46:43Dan DeLong: If you've brought in the the file local to your machine and you're doing it locally, then you can reset the the Intuit id, which is just temporary for the conversion process.
- 46:59Dan DeLong: So I've created a little blog about it, right?
- 47:04Dan DeLong: And we talk a little bit about the desktop or Intuit talks about the desktop versus Intuit logins and how they relate.
- 47:11Dan DeLong: But down here we've got a little scribe.
- 47:13Dan DeLong: So I'm just gonna walk through that process here, right?
- 47:16Dan DeLong: So here's the Intuit account information.
- 47:18Dan DeLong: If it's empty or if it's not yours, then this process, you want to continue through this, right?
- 47:26Dan DeLong: So you're gonna close out of that.
- 47:29Dan DeLong: And then when you go to the help menu, there's a little button here that says, make it bigger.
- 47:37Dan DeLong: Reset tuit ID settings.
- 47:41Dan DeLong: You gotta be signed in as the, QuickBooks admin.
- 47:45Dan DeLong: This is the admin user that you're signing in into.
- 47:48Dan DeLong: Quick, thanks for bringing out the glasses.
- 47:53Dan DeLong: You have to be signed in as the admin, right?
- 47:56Dan DeLong: A-D-M-I-N.
- 47:57Dan DeLong: When you sign in to into QuickBooks in order to see this option, right?
- 48:03Dan DeLong: So just click on reset the settings.
- 48:07Dan DeLong: It's gonna say, Hey, are you sure you gotta type in Yes.
- 48:11Dan DeLong: In that process.
- 48:13Dan DeLong: And then it will reset.
- 48:15Dan DeLong: It'll say Your Intuit ID settings were reset and you've been signed out of your account.
- 48:21Dan DeLong: Sign in again.
- 48:22Dan DeLong: So you go back to company my company, and then click on sign in.
- 48:29Dan DeLong: Should be over here, but I somehow it got cut off on the screech.
- 48:34Dan DeLong: So over here where it says, manage your account, there's a sign in button or a link right above that.
- 48:39Dan DeLong: And then you just say, Hey, I'm the admin of this company.
- 48:45Dan DeLong: And then go through the process of signing in.
- 48:48Dan DeLong: And then when you go back and check the the F two or the product information window, you should see your login information.
- 48:58Dan DeLong: And as long as that login is the same login that you're doing the conversion on, you're good, or at least you should be.
- 49:06Dan DeLong: That's the theory.
- 49:09Dan DeLong: Like I was saying I've done this a couple times and it works really slick now.
- 49:17Dan DeLong: It doesn't set it up right away, right?
- 49:19Dan DeLong: Like after you get that infor that email that says, Hey, you're ready.
- 49:24Dan DeLong: It still has to go through and set that up for all those employees and, whatnot.
- 49:30Dan DeLong: But like I was saying, that 431 employees got set up and set up properly.
- 49:36Dan DeLong: The year to date information came over.
- 49:39Dan DeLong: It was really just a matter of checking those things as I was going through, rather than running reports, trying to find them in the desktop and make sure that they and entering that information, which is never in the same order.
- 49:54Dan DeLong: It's maddening.
- 49:55Dan DeLong: If you've ever tried to set up pay payroll and QuickBooks online after a migration from desktop FICA or social Security or Medicare, they're never in the same order as QuickBooks Online.
- 50:08Dan DeLong: And then this whole thing of first quarter, year to date, you gotta put in as opposed to first quarter and what's in the current quarter or something like that.
- 50:18Dan DeLong: So it's it does get a little maddening when you're trying to do that.
- 50:24Dan DeLong: Huge huge breakthrough, I guess is, and if, you are migrating payroll if you do this process it again, try it out first before before telling your client, yeah, it'll set it up fine.
- 50:42Dan DeLong: Because I was even doing this and contacting Intuit, and they were like, this ain't gonna work for you.
- 50:48Dan DeLong: They were giving me the you might as well buckle up and, I was, glad to, to report that they were incorrect.
- 51:00Dan DeLong: All right, so real quick before we wrap up here, migrating attachments, this this is a little unique situation because attachments in desktop, they are stored in the same location as as the company file, but they are not part of the backup, right?
- 51:24Dan DeLong: All of those attachments that you have attached to customers or transactions when you have a lot of attachments, that is a concern or a consideration because they they just never came over.
- 51:44Dan DeLong: And in QuickBooks Desktop, once they're attached, the, they're, the originals aren't needed.
- 51:51Dan DeLong: Because what QuickBooks does is it copies it into a folder wherever the company file happens to be located, which, if you're in a multi-user environment, that is typically on a server somewhere, right?
- 52:04Dan DeLong: So that gets a little bit complicated.
- 52:09Dan DeLong: As we, were talking about this.
- 52:10Dan DeLong: So in the past, it wasn't possible to migrate with, desktop migrations, you typically needed a third party to move all of them, and the price tag to do all of that was.
- 52:23Dan DeLong: Really hot.
- 52:26Dan DeLong: So the caveats here is that the files actually need to be local, right?
- 52:31Dan DeLong: So this is now a consideration or complication when we're talking about a multi-user environment because the company file location is gonna be the located on a server.
- 52:43Dan DeLong: So just like desktop desktop migration is gonna have a problem if you migrate from the, from across the server.
- 52:52Dan DeLong: You want to have those local and you also want to have the attachments local as well.
- 52:57Dan DeLong: And it has to be done inside the QuickBooks Desktop.
- 52:59Dan DeLong: You can't use the online web portal to, to migrate your data and attaches, and they have to be less than 30 megabytes.
- 53:07Dan DeLong: So all of your video files that you've attached to, your to your customers or whatnot, they aren't gonna come over'cause they're probably too big.
- 53:17Dan DeLong: They may not even be the file site.
- 53:19Dan DeLong: File type.
- 53:20Dan DeLong: And that's where a
- 53:20Sharrin Fuller: loom link comes into play.
- 53:24Dan DeLong: Exactly.
- 53:25Dan DeLong: So these are the supported file types.
- 53:27Dan DeLong: Oh I'm, glad gif will come over because all of the memes that you've attached to your customers,
- 53:34Sharrin Fuller: the what the fry from Futurama Take My Money.
- 53:38Sharrin Fuller: That's the one I use the most, I think.
- 53:41Dan DeLong: There we go.
- 53:41Dan DeLong: So those are the types of attachments that will go.
- 53:45Dan DeLong: Now when you, the process is of course, you need to locate that documents folder.
- 53:51Dan DeLong: I, I put a frequently asked questions Intuit article.
- 53:56Dan DeLong: It's really robust prior slides so you can access that later.
- 54:02Dan DeLong: But you wanna go and you wanna find the locations of your documents.
- 54:07Dan DeLong: Typically you're gonna need to compress it or zip it into one.
- 54:11Dan DeLong: File and then move it local, wherever your company file is, and then extract it in that same location, wherever that company file happens to be located, and then clean up the links, right?
- 54:25Dan DeLong: Once you've moved it and you've changed the location, you're gonna wanna make sure that they go through and repair the links, because now the path is totally changed.
- 54:35Dan DeLong: So you wanna make sure that it's it's attached again.
- 54:39Dan DeLong: All right, so I did, okay, so here is the import summary, right?
- 54:46Dan DeLong: That, that came over.
- 54:48Dan DeLong: It will tell me it tells me here that there were three hundred, seven hundred and thirty nine transactions in the company file and desktop, and there were 713 17 that came over, right?
- 55:01Dan DeLong: So what you don't get on the regular import summary is this little link here to see the transaction details.
- 55:09Dan DeLong: Here's my problem, right?
- 55:10Dan DeLong: So a bunch of build assemblies didn't come over, right?
- 55:14Dan DeLong: Which is not unexpected because you don't have such a thing as a build assembly.
- 55:20Dan DeLong: But I might wanna look at these build assemblies that are in there to see if there's something that could be done at that point.
- 55:29Dan DeLong: And there was also some altered transactions of a inventory adjustment was turned into a journal entry, right?
- 55:35Dan DeLong: So just because it didn't come over doesn't mean that it didn't have the same financial impact.
- 55:41Dan DeLong: So you'll also be able to see that with accounts, right?
- 55:44Dan DeLong: So just because there discrepancy doesn't necessarily mean there's a reason to panic.
- 55:49Dan DeLong: So purchase orders just isn't even used that's not an account that's used inside of QuickBooks online.
- 55:55Dan DeLong: So this is a non-issue, right?
- 55:58Dan DeLong: Vendors there were other type or other names they got turned into into vendors.
- 56:05Dan DeLong: It's really just all it's saying there.
- 56:08Dan DeLong: And then it just gives you, an idea of actually what happened.
- 56:11Dan DeLong: So I did, so this is the this is the company and I just wanted to show in the attachments there is, there are the atta, oh, I wanted to show before I did it, but I'm not gonna do that on the other.
- 56:30Dan DeLong: I have these in my document center in the, desktop file.
- 56:34Dan DeLong: And here they are.
- 56:35Dan DeLong: They, came over.
- 56:37Dan DeLong: I just put some there were actually three and one was attached to a sales order.
- 56:44Dan DeLong: Any guesses why it didn't come over?
- 56:46Dan DeLong: Because sales orders don't exist inside of QuickBooks online.
- 56:51Dan DeLong: So it did bring over the two and it did attach them.
- 56:54Dan DeLong: So here on my invoice here is the the attachments are there, so if I go down, enough of you roll down, there's.
- 57:07Dan DeLong: There's the attachment.
- 57:08Dan DeLong: So I've got my CSV file that I happen to attach, and there it is, it's already attached and I can look at it.
- 57:15Dan DeLong: Oops, there.
- 57:18Dan DeLong: So it's there, right?
- 57:19Dan DeLong: So that's a huge win for the migration process.
- 57:27Dan DeLong: Oh, I've been sharing the last, poll question for since I, launched it.
- 57:34Dan DeLong: But let's close up with was this information useful?
- 57:39Dan DeLong: Share it any.
- 57:41Dan DeLong: Final thoughts before we wrap up?
- 57:42Dan DeLong: I'm
- 57:43Sharrin Fuller: excited for anybody who's doing conversions nowadays.
- 57:46Sharrin Fuller: 'cause this is not how it was back in the day.
- 57:48Sharrin Fuller: It was not at all.
- 57:50Sharrin Fuller: But then again, desktop probably didn't have the level that they had.
- 57:53Sharrin Fuller: Quick Bot online didn't have the level that they had.
- 57:56Sharrin Fuller: So I think it's really cool for anybody that wants to come over.
- 57:59Sharrin Fuller: I also love that Intuit is helping them do it.
- 58:01Sharrin Fuller: Regardless of what the motives are, the fact that we do less is amazing.
- 58:06Sharrin Fuller: And knowing that it's done right.
- 58:08Sharrin Fuller: So I, think this is great.
- 58:09Sharrin Fuller: It can be a little overwhelming and if you're a solopreneur, this is a lot of time, so I would probably let Intuit handle it, charge for it.
- 58:17Sharrin Fuller: 'cause you still gotta be the middle man, but it's, this is very informative, especially about the payroll.
- 58:22Sharrin Fuller: That's really cool.
- 58:24Dan DeLong: Yeah.
- 58:24Dan DeLong: I I actually got a a customer or a client who ha is trying to go from enterprise to QuickBooks Online.
- 58:35Dan DeLong: And their response from Intuit was, it's not gonna work.
- 58:40Dan DeLong: And because they have 120, they have 120,000 customers.
- 58:46Dan DeLong: And
- 58:48Sharrin Fuller: Yeah, that's a little's.
- 58:48Sharrin Fuller: That's where you just, honestly, you export the list and the data, you archive the file, you have it for reference, and you start a new file at the beginning of the year.
- 58:57Sharrin Fuller: I know that's terrible, but sometimes when your file's too heavy, if you're, if you haven't file that heavy, you should be on something super enterprise or like a big one.
- 59:06Sharrin Fuller: But I know that's what Intuit's trying to be now.
- 59:09Dan DeLong: Yeah.
- 59:09Dan DeLong: And they also have negative inventory, so running a condensed Oh things like that is, is a big challenge.
- 59:18Dan DeLong: So we are where there's will, there's a workaround and we are actually getting to a, breakthrough point with them.
- 59:25Dan DeLong: Just because it says it's failed, it doesn't mean that it's not an option.
- 59:30Dan DeLong: Yeah.
- 59:31Dan DeLong: Yeah.
- 59:32Dan DeLong: So Sharrin, again, I thank you for filling in for, Matthew today.
- 59:36Dan DeLong: Yes.
- 59:37Dan DeLong: And you'll continue to be our snarky.
- 59:42Dan DeLong: Yay.
- 59:42Dan DeLong: But I'm also having fun in
- 59:44Sharrin Fuller: the questions, so I hope I'm being at least helpful there.
- 59:47Sharrin Fuller: 'cause there were 33 of'em.
- 59:48Sharrin Fuller: Most of them were Murph, but that's okay.
- 59:52Sharrin Fuller: We'll take that.
- 59:52Sharrin Fuller: Oh man,
- 59:52Dan DeLong: he's asking what the hell is negative inventory.
- 59:55Sharrin Fuller: I Murf, it's a thing.
- 1:00:00Sharrin Fuller: We've seen it.
- 1:00:01Sharrin Fuller: I also want everybody, I am offering anybody on this call 90 days free to my clone and conquer hub, pop in, get some free stuff, nope, no, no pressure purchase nest.
- 1:00:12Sharrin Fuller: No pressure either.
- 1:00:14Dan DeLong: Exactly.
- 1:00:15Sharrin Fuller: As opposed to, again.
- 1:00:16Sharrin Fuller: So
- 1:00:17Dan DeLong: we appreciate you joining us today and next time we're gonna have a method being joining us wherein when we what I've found is that they have become a great.
- 1:00:31Dan DeLong: Bridge when workflows that were critical in QuickBooks Desktop and you need them in, QuickBooks Online.
- 1:00:38Dan DeLong: And we're gonna talk about how they can save the day for those desktop migrations that just went awry.
- 1:00:45Dan DeLong: So hopefully you join us in a couple weeks when we have that.
- 1:00:48Dan DeLong: And until then, have a great great day and we'll see you next time on the QB Power Hour.