Updates to QuickBooks Desktop Migration
===
[00:00:00]
Introduction and Casual Banter
---
Dan DeLong: Oh, welcome to another workshop Wednesday, brought to you by school bookkeeping.com, where it's casual conversations for serious workflows and where you can learn QuickBooks your way. Hi Rachel, how are you today?
Rachel D: I'm good. How are you?
Dan DeLong: All right. It seems like we just did this I know, like yesterday,
Rachel D: I know, [00:01:00]
Dan DeLong: Rachel filled in for Matthew who filled in for Rachel in the workshop.
So it was like, we tried it was like a substitute swap.
Rachel D: If only I could swap places with him in Ventura, California. That would be better.
Dan DeLong: Right?
Rachel D: Rain at home.
Dan DeLong: Oh, it's rainy there. That lake effect?
Rachel D: No, it is a lake effect in the summertime. It rains all summer. It's crazy. It's I would. I would not wanna stay here forever.
Alright,
Dan DeLong: If if you have a new location for Rachel, she's she's open for discussion.
QuickBooks Desktop vs. Online
---
Dan DeLong: Alright today we're gonna be talking about so some of the updates to to the desktop migration. We. We did a workshop a long time ago, and I'll actually share [00:02:00] my screen in a, second there.
And it was a workshop that I had, I was forced to do by myself. So I really have been wanting to update this anyway because I hate when I have to do a workshop when nobody's there to bounce, off things. Yeah.
Rachel D: And I'm sure there's probably a lot of changes anyway. You're so good at migrations that every little detail I.
Dan DeLong: Yeah. Now we were talking yesterday on the QB Power Hour. You started with QuickBooks Desktop. In your QuickBooks journey, and then just did immediately said, I did, no, I don't want any of this. And I moved to
Rachel D: QuickBooks. No in the early two thousands I used QuickBooks Student Edition, but I, it's really when I came back to QuickBooks about five years ago.
And I completely started with QuickBooks Desktop, but I didn't know anything about QuickBooks Online. And when I discovered QuickBooks Online I realized it had a little bit more cloud. Flexibility [00:03:00] for me, but I do love QuickBooks Desktop. It just doesn't really work for my business, but as an as a software, I love it.
Yeah.
Dan DeLong: Yeah, it's definitely got, and we've, talked about this. I've got a, blog article about QuickBooks Desktop is a dog, QuickBooks Online as a cat, right? If you're a dog lover, that's totally different. You don't really like cats. If you're a cat lover, you don't really like dogs, and if you're an animal lover, it really doesn't matter.
But like a, dog, you can teach QuickBooks tricks and how to fetch
Rachel D: Yes. A little bit more. Good dog.
Dan DeLong: You're a little bit more able to do some, magic there. Whereas a cat just enjoys your company occasionally, or, points to the bottom of the empty food bowl.
Rachel D: Yeah. Things
Dan DeLong: that, and like we
Rachel D: were saying yesterday, I mean it there, QuickBooks Desktop, it's so robust and you can do everything you need [00:04:00] to in your business in QuickBooks Desktop Enterprise especially. But QuickBooks Online is really more geared to, integrating with other apps that you're doing a lot of the stuff elsewhere and feeding the financial data back to QuickBooks.
They're just two different things.
Rachel D (2): Yeah.
Dan DeLong: Yeah. It's apples and oranges. As the case may be now.
Migration Challenges and Considerations
---
Dan DeLong: There are a lot of trigger events as of late causing people to reevaluate whether it's a good time to, to move. The biggest lever that Intuit is pulling is pricing, especially with, the model of, QuickBooks licensing desktop, right?
You can have as many QuickBooks Company files as you, want. So a lot of, a lot of companies that have multiple entities are finding that pricing being a [00:05:00] barrier because QuickBooks Online
Rachel D (2): Yeah.
Dan DeLong: Is per a company file or a company subscription per entity. So I. That makes it a little bit challenging to to swallow the, cost of doing a subscription for each of those companies.
So they're, trying all sorts of things with Yeah. Multi-company discounts and those types and promotions. QuickBooks Ledger is a great option for accounting professionals who have. Clients with multiple entities that are low, yeah. Basically made up clients.
So there's all sorts of different things out there, that QuickBooks is using to encourage
Rachel D (2): Yeah.
Dan DeLong: Move to the cloud, but it doesn't come without its, issues. There's a, there's often a, some surprises when it comes to [00:06:00] workflows or feature sets or, navigation is a huge, yeah.
Is a huge challenge for the learning curve. If you look at the marketing that's out there I. It's seamless, right?
Rachel D: Oh, you hate that word.
Dan DeLong: Seamless migration. Once you spend
Rachel D: hours calibrating it, setting it up, making sure everything is correct, then it's seamless.
Dan DeLong: Exactly. So just because they have the word QuickBooks in front of them doesn't mean that, it's apples and apples, right? It's, it is apples and oranges. There are workflows that are built in between both of those applications that, should work, right? It should should transition as the name is a word I'm trying to search for.
But, [00:07:00] it doesn't always. Pan out that way. Yeah, and actually I have a
Rachel D: couple I, when you get to that, I have a couple questions for you because I am actually working with a client right now that you actually did the migration for me. And there's a few other things that I'm curious to know if it comes over from QuickBooks desktop to QBO and I've learned much more about what comes over but I still don't know at all.
So yeah, when we get there, I have to ask. Skew
Dan DeLong: Yeah. And this that's part of the challenge is understanding right, what will and what won't make the journey. And Howard who's watching this on on Facebook's at QuickBooks Desktop, has a lot more features than QBO without having to pay the extra fees.
That is what the way it sits currently. And I fully expect Intuit's terms and conditions to change to,
Rachel D: to cause that. Yeah I'm, sure they will. [00:08:00] I'm sure they will. And then also, it's, for me, it's gotten to the point where
Rachel D (2): It
Rachel D: A factor is also how long have you been on QuickBooks desktop?
Because I think that staying with quick QuickBooks Desktop comes into play more if they've got a lot of years. Of history in there. Oh yeah. It's or if somebody is new to the QuickBooks world and they're like what should I get? Desktop or online? For me, the obvious answer is online.
I wouldn't start a new desktop file. But the issue is more when you've got some businesses that have been in there for a while and they've got all this stuff it becomes. Do I bring it all over or do I just start a new thing or there's so many different questions to ask.
Dan DeLong: And that's that, that's a great segue, right?
Understanding Targets and Data Transfer
---
Dan DeLong: Because, the size limitation was always, I. A consideration, a key factor, a consideration of when you're talking with your customer about is it time to [00:09:00] move? Because if they've been using QuickBooks Desktop for decades or several years at least they could potentially have a lot of data to transfer.
And originally I'm trying to. Go back in the way back machine, I think it was a hundred megabytes was the, file size. That was the limitation of moving. And then they transitioned to this limitation of targets.
Which was a, factor. And it was, i, think it was I, don't know the, specific numbers.
I think it was like 150,000 was the original one, and then they bumped it up to 350,000, and then it went to 750,000. And as of February, as of today, which I, noticed it in February. It might have been prior to that, it's now 1.2 million.
Rachel D (2): Oh my goodness.
Dan DeLong: Is the limitation of the number of [00:10:00] targets now.
That a, that segues nicely into the question of what in the world is a target? And the simplest way, without getting too lost in the weeds here, a target is the number of references. Two line items on a transaction, right? If you have an invoice with five line items on it, that's six targets because the, header information of the of the transaction, which is called the source, is also a target, but is one target.
And then the line item details are. Each a target each one is a target, right? Okay. It's not a transaction limit, right? Because if you have one transaction with 400 line items on it, that's a lot more information than a, transaction with one. Yeah. So that [00:11:00] is the indicator of how much information can, transfer over, but that doesn't equate to years or number of transactions or anything like that.
So
Rachel D: that could only be maybe one year of of a complex company. And then so you could bring over targets, but there's a lot of other things you can't bring over, attachments.
Dan DeLong: Exactly. So the, so initially that was the part of the discussion. It's Oh, and typically part of the engagement when you're moving companies over from desktop to online, it's okay, we have to clean up this information first or trim it off, or choose a starting point because the migration tool didn't give you the ability to bring over all the information if you wanted to.
Now that conversation is, doesn't have to be part of the [00:12:00] conversation because with a limitation of 1.2 million targets, there's a lot of data that can now come over, right?
Should you, that's a question. That's a, that's another conversation, right? Can you. Yes. I tend to take the the mindset of, let's just see, right?
Because we don't know what we don't know until we try.
Rachel D (2): Yeah.
Dan DeLong: And, rather than combing through somebody's desktop data, and checking all the preferences and the settings and those types of things, let's just see in a. This is my way to, to approach things. Let's just see if that data converts as it is and evaluate the difference between the desktop and the online [00:13:00] using a an import summary that.
QuickBooks makes available, right? Yeah. Yeah. That's my approach. That doesn't necessarily mean that's the best approach, but typically like the projects that I've been working on with you, Rachel, I don't know anything about these customers, right? So I don't have any history, prior history, prior working knowledge of their QuickBooks desktop files.
So that seems to what works best for me, in going about this, if, if you, if this is a client of yours and you have some history working knowledge of them and hey this, desktop data prior to me getting involved is garbage and we don't want that, then that's, you already have that, that con can have that conversation with your client we're gonna purge it off.
Yeah,
Rachel D: that, that's such a good point. Because I'm the same way. If I know that it's garbage, I. I don't wanna bring [00:14:00] over the history in this situation. Their data was, seemed to be fairly accurate, but it was a lot of it, so we really just wanted to bring starting balances.
Dan DeLong: Yeah.
School Bookkeeping Resources
---
Dan DeLong: So in school, bookkeeping, we have I, I'm, what I'm trying to do there is, give people a choice of choosing their own adventure, right?
Because. Yeah, there's a lot of resources that are out on, Intuit's website intuits articles and whatnot, but they are constantly changing and, sometimes it's, hard to find some of these resources. So I'm trying to compile all of the useful resources and articles and put them in one place so that people can, have a one stop shop when it comes to.
Alright, if I want to do this myself, let's go ahead and and use this as our guidance. Or if you're, if you've never [00:15:00] touched QuickBooks Desktop and you don't want to, then you have a, you have an option there, or if you've already converted the company file and have some questions about it, you have some resources and options there as well.
So let me share my screen here. So this is our course that we have of com. Just converting QuickBooks desktop to, to online. See there's the work. There's the old workshop that I did by myself just staring into the abyss and, going through this. But I've broken it down into, mI migration best practices, which is what I just talked about there. And then specific inventory or specific QuickBooks workflows that you wanna have a conversation about, especially with your clients. The inventory considerations. We had talked about that on a workshop. I added that as a, course content.
What about. [00:16:00] Payroll what happens to with payroll when that comes over from desktop to online maybe payments, right? Or whether I should convert or not. Talking about the file size limitations that we had just mentioned, what is that? What data converts as far as the terminology or the features or the preferences or transactions and items.
So all of that information now is, in one place so you don't have to go hunting for all of those things. Does this, Rachel does this, is this a good place to ask your question about what does and what doesn't come over?
Rachel D: Yeah. I was curious. Yeah so I know that, my thought escaped my head, but I was more curious to know about the things you've set up in QuickBooks desktop, like memorized [00:17:00] transactions or recurring transactions or things like that.
Does any of that stuff come over?
Dan DeLong: Yeah. Yeah. So this would be, the the place to go to do that? Yes. This is the course. So like you would go in here and see the items from desktop. How do they, come over, oh, okay.
Rachel D: Oh gosh, that course is awesome List.
Yeah. It's got everything.
Dan DeLong: What moves to QuickBooks online assemblies how they, come over. You were asking about memorized transactions.
So that would be. Probably down here in transactions.
Oh, those are reimbursables. And I believe we have a search function here. Do we, let's see. There is a search for something, [00:18:00] recurring and we'll just look at that. If I could type in there.
There it is. It's in lists. Ooh. Nope.
Is it scheduled? It should be en lists. Yeah. Recurring transactions in QuickBooks Online. Yes. They, do come over, but they aren't scheduled. So that's what it boils down to, is that, yeah.
Rachel D: Yeah. You can go in then and set the schedule.
Dan DeLong: Yeah, exactly, because and, the reason behind that is especially if you have recurring transactions tied to an automatic payment, yes.
You wouldn't want them to come over and schedule again and run again if they if you haven't completed all of those processes. It's a cart before the horse type of thing. But yes, this is the, course that we have is available, [00:19:00] anyone who's with, that goes with the premium for accountants.
There is a 30, 30 day trial. And you could put that QR code up there for for the 3, 3 30 day trial. 'cause you can access this course for 30 days. Before you even pay for our membership options. So you have that as a, as all as an option here. So lemme go back to what I was doing here.
There we go. So we've got whether or not to convert. 'cause this is, a conversation that you want to have with your client if you don't know as. What's gonna happen to that, data. Or this could be an also a really good resource after the conversion happens to understand why certain data didn't come over the way you had [00:20:00] expected.
Yeah. And then there's just steps to actually do the conversion.
Live Conversion Walkthrough
---
Dan DeLong: And I'll walk through a live conversion. Here. I should have done that first so I could. Maybe get it done by the time the workshop is over. And then doing from all of doing the conversion, how to tell what didn't transfer and steps if they didn't.
And if you needed help what options that you might have. I wanted to walk through the, process here. So let me share my. Other screen here. 'cause one of the big things is especially now with with people doing a lot of migrations or doing a lot of QuickBooks consulting in the cloud, using QuickBooks online, a lot of people might be using Mac, or just solely using QuickBooks online.
And in order to move from [00:21:00] desktop to online, you need. Access to QuickBooks Desktop in some way, right? And you can't do it on a Mac, right? Like you can't download QuickBooks for Mac, get the guy get, the, your client's file and use QuickBooks for Mac to convert that file. So there are QuickBooks at least understands that, and, gives you access to a, QuickBooks online, online tool, right?
So here in this article. For moving QuickBooks Desktop to online, there is a web migration tool and this gives you access to an instance of QuickBooks Pro or Premier or QuickBooks Enterprise or QuickBooks Mac to, to be able to, if you have those files, and you're not gonna do anything in the desktop to clean them up first.
Solely all you need is the ability [00:22:00] to have QuickBooks, to be able to move things over. Then you have this the, these these links in here to be able to do that. And it's just a, an online instance with QuickBooks in it to, for the sole purpose of uploading a file to, to bring it to QuickBooks online.
So let's go into QuickBooks Desktop here. Now I've got, just got a sample company here open and in order to do this, and I'm using the QuickBooks Enterprise. So there is a kind of a secret code to get this process started because normally you would go to the company menu and then at the bottom of the company menu, there would be an option to export to QuickBooks.
Online Enterprise doesn't have that.
Rachel D (2): Oh, okay. So you
Dan DeLong: have to bring up the product information window first. And incidentally, this is where we're talking about targets. Oh,
Rachel D: you can see that. [00:23:00] That there,
Dan DeLong: yeah. Very cool. So in this particular file is there's 5,937 targets, which equates to 1,219 transactions.
In this particular, that's not a
Intro (2): lot
Dan DeLong: Company file.
Intro (2): Yeah.
Dan DeLong: The keyboard shortcut is holding the control key pressing B, then Q at the same time, and then clicking. Okay. And that brings up this this process. Now this is something that I noticed earlier about getting your data getting your desktop data, company data ready for migration.
There's a checklist right here on this screen, and we open it up. And it spins for a while. It gives some pretty good options here. Double check your list of active customers, 'cause that's gonna play a part in what happens with those transactions.
QuickBooks Vendor and Payroll Setup
---
Dan DeLong: Over into [00:24:00] QuickBooks. Doing the same thing for vendors, doing the same things for accounts categorizing and reconciling your transactions.
And then it has a section for payroll. Make sure that the profile, the employee profile is complete. This is huge for for the transition of, payroll because after your data comes over the financial data, then it tries to set up payroll, and if anything derails the setting up of payroll for you then.
It just stops. And then you have to take the take that baton and pass it over.
Rachel D: Yeah. And I can't deal with a derailed payroll. I hate it when payroll derails. I have to say I love this checklist. This is, even, I could do this,
Dan DeLong: right? I, and I saw it a couple times.
I'm like what's that all [00:25:00] about? And so I actually started checking it out. I was like, actually, that's pretty cool.
Importance of Data Backup and Verification
---
Dan DeLong: Backing up your data, some of the other things to do, and then run the verify tool to make sure that the data is clean before you move it over because this is all gonna result in a case of garbage in.
Garbage out, right? So if there's damage transactions the damage could potentially make the journey, right? Or it could just stop the, the transfer of data altogether. So let's go back here and get this started.
Starting the QuickBooks Online Tool
---
Rachel D: Now, is this the tool that you usually always use, Dan?
Dan DeLong: I typically will use just an instance of QuickBooks Desktop, right?
So I am in the company file, if I'm not using the online tool here. For, this workshop, I just wanted to make sure that people were aware that online tool [00:26:00] existed. So the first thing is to. Just get started and then it's gonna ask you, would you bring all of your data or lists and balances, right?
So right from the top, if you even if you're bringing over nothing except just the lists and the transactions, you know that there's lots to clean up or we just wanna, we just want to. Pick up the baton and there's so much information in there that you don't necessarily wanna burden QuickBooks online.
With that, you could choose just to bring over lists and balances only. We're gonna choose all, all versions now.
Handling Inventory in QuickBooks Online
---
Dan DeLong: And then we talked about bringing over inventory. You can choose to track inventory using FIFO or not to choose. Don't move them over. If you choose not to move inventory, the items still come [00:27:00] over.
They're just non-inventory parts, non-inventory as opposed to inventory.
Rachel D: Now what if you do choose yes. And you have, both assembly items and finished goods in. Desktop. How will it bring it over to QBO?
Dan DeLong: Yeah, so every item, and that's where those that resources comes in handy. Every every, as every item, assembly item and regular inventory items will just be made as inventory parts.
Inventory. Okay.
So historical transactions, the financial impact of. Items that were assembled, will come over properly. They won't look like they did in QuickBooks Desktop, right? Because in order to account for that, it will have to. Modify that transaction so that it puts the individual component on the invoices that as they were sold.
So that [00:28:00] makes things look a lot differently with regards to assemblies because as we know in the cat QuickBooks online, there is no such thing as an inventory assembly, right? So all of those items, they'll get set up as regular inventory parts. And historical transactions will come over as, and the financial impact of those transactions should be, should make the journey.
Yeah. It's just the other moving forward after you've made that transition, it's not going to have the, the assembly items and the, they're just same assembly, the process all and all of those things as, you'd had before.
Rachel D: Yeah. There's no differential between them. They're all just regular inventory items.
Dan DeLong: Exactly. So then that that raises the question and typically when you have that sort of, [00:29:00] type of information, I can't spell on. All right. I can't type and talk at the save time, but let's see here. Let me at least get this going here. So when you have the, the issue, oh, now it's asking for all this, stuff.
Let me get a code, which is over here.
That's 2 4 4. Let's just fill that in there. So those inventory assembly items, they come over as just regular inventory parts. But this conversation is something that you would have with your client as soon as they say they have assemblies, right? What are we, what's the plan for that? Because knowing what's gonna happen.
When it comes over, then it becomes a matter of there may be some other things that you might need in there, right? [00:30:00] So let's find a conversion. Demo trial that I made.
Client Trials and Workflow Transition
---
Dan DeLong: Typically, I like to make trials and this is part of my best practice here of the way I go about this.
I'll create a trial subscription within my QuickBooks Online accountant, and that will then give me the access as the accountant user and the primary admin. It's just a trial. Then I can invite them. Invite the client to those companies, and they can poke around, see how the, how well the data came over, see if their workflows transition.
I let them do that because again, I don't know what their workflows are and the time and discovery of being able to do that. A lot of people don't. Don't necessarily see the value in doing that until it's too late. So I shift that burden to them. [00:31:00] Yeah. Have them go through with their team.
I set them up as access all access, but not an admin. Because I don't want them to start using this as their full, fully functioning. QuickBooks Online subscription. They may already have another one, or we may wanna this process may take months. And we wanna make sure they're in the right version at the right time.
Rachel D: Yeah, your process is incredible. I'm really impressed.
Dan DeLong: Thank you. Now you know what I'm doing on the, in the back end here.
Rachel D (2): Yeah.
Dan DeLong: And this is new. They used to not have, they used to have a screen here that had three lines on it. And.
New QuickBooks Migration Features
---
Dan DeLong: Yeah, once it's uploaded, what would happen?
It would say, all right, we got it from here. This has changed. So that this status bar is, it's one status bar, right? And [00:32:00] it tells you, and I don't know if you just missed it, right? It, while it's uploading, it will say, keep this window open. And then once it's uploaded. It's now saying it's still got the status bar, but it says your QuickBooks desktop data will continue to migrate to QuickBooks online even if you close this window.
So in the past, this was the, okay, I got it. We got it from here. If you want, you can actually now see an estimated time of how much it, how long it's gonna take for that, that data to actually, that's
Rachel D: really cool.
Dan DeLong: Be finished, right? Yeah. So it gives you an idea even though it says 3%.
It's gonna say take 22 minutes. So we're not gonna wait 20, 22 minutes. 22 minutes
Rachel D: for a seamless switch. That's what it says. Yeah.[00:33:00]
Dan DeLong: Said that again. So that's that's the new process, of moving it from inside of QuickBooks. It's the same general process of what we had in there before. There's just some new screens. The check, the checklist was one thing. And and this, status bar is another up until this point.
Post-Conversion Checklist and Resources
---
Dan DeLong: Now inside of our course we have, some resources that are still available with with Intuit or with with inside of QuickBooks is again, it's just finding them right. So in here we have a, post. Desktop migration checklist which is available outside of, a add intuit.
But again, trying to find it is part of the challenge. So we have it here in our downloads and, [00:34:00] resources page on school of bookkeeping when you go and download it. This spreadsheet is really cool. I'm gonna move this over and then. There we go. So it they created a spreadsheet, right?
Which has just got some instructions on one tab the client profile as far as their name, address, primary contact information. This is typically something that you might do during the, the discovery process of what it getting the details right. Any notes or anything like that.
And then what to do with pre pre and post, right? So you ver verify data and set up check and make sure that the, balance sheets, oh, actually this is post-conversion. You wanna make sure that the balance sheets for all dates and all. On an accrual basis, they match, right? And then you can just mark these as completed [00:35:00] or whether or not they're, work in progress.
And it just goes down the list of things to check, right? And then workflows and assignments is really cool too because you have, who is supposed to do what, right? So you could do. You can, this will help you in that process of assigning who's gonna do what, is the feature even in use, right?
So this is customer invoices, the fe is the feature in use. You could say it's in use. And then who's gonna do, who's gonna train? Train it or whether or not it's a training is required or not. And then who it is gonna be assigned to, right? And then they also have a little. Checkbox here of well, helping people decide if they need essentials or plus, or advanced, right?
If they're using this purchase orders, right? If that's in use, then [00:36:00] they at least need, plus, right? Because it's listed here. So it's a, pretty cool, option for for somebody who's working with their client to make sure that they have all their, bases covered.
Yeah. And make it a game plan between between you and the client of who's gonna do. What keeps you organized? So this is a really cool checklist and spreadsheet Yes. That Intuit's made available, for accountants. So that's available in in the school bookkeeping. Just collected it for you and put that in in a resource for you as well.
Oops, go to the right place. Now once this one here is this lesson here is really great. About how do you tell [00:37:00] what went o what came over and what didn't, right?
Import Summary Report and Troubleshooting
---
Dan DeLong: So as the primary accountant, and that's the first accountant to be listed on the file, right? So if you are the, if you were the second accountant in the mix, the.
The first accountant is gonna get this, import summary report that comes, that gets emailed automatically, right? So when you get one oops. No, we don't want that. Where is, I've got too many things shared and showing. Once it's done and looking at the other file, we got 17 minutes, so I'm not gonna wait 17 minutes.
There is a spreadsheet that's provided that has an overview of. The [00:38:00] file and says gives some pertinent information about the file, whether inventory was turned on or whether they're using payroll. A lot of those things that you would have to go through the file. But then it's got an summary of customers, vendors, transactions form templates those, all those things.
Then it will tell you. Here's what the, here's what we counted in desktop and here's what we counted in QuickBooks Online, and there's a column for the difference.
Rachel D (2): Oh, very cool. And
Dan DeLong: It'll also give you a link to, to look at what that difference, why that difference is showing.
So you can see where
Rachel D: it's coming from.
Dan DeLong: Exactly. That's why I take this approach, because that import summary is so helpful in identifying the stragglers. Yeah. [00:39:00] Yeah. Because yeah
Rachel D: You don't wanna be told error and then what is it?
Dan DeLong: Yeah. And it will, typically tell you why why there was a problem.
So that takes a lot of the detective work out of the mix to let you know, okay, I can't create this item because I. You map the wrong account, right? Or yeah. Or something like that. So now I have some some things to do and a list of who to look at, right? Yeah. So here's a listing of these items.
They have improper accounts associated with them. So I had one where they had done some creative. Contra accounting and they had set up items where the income and the expense were income accounts for both. But they showed up in the same grouping. Yeah. So that they could collapse 'em [00:40:00] at the top of the, of their profit and loss report, which is fine.
And you can do that in QuickBooks Online, but you can't transition a, an item in that state. Into QuickBooks online. So that's now a conversation of, okay, we can fix it in desktop so that they get created, but we're gonna then have to go back into those same items and put them back the way you want them.
Rachel D: Yeah.
Dan DeLong: If that's the way you want them. That would've been a lot of detective work and legwork to come up with, okay, here's the scope, right? You've got 42 items in this case I would've had to do it individually. Try to find it, here it's all just itemized for you in that import summary report.
Really cool. And resource that Intuit makes to help you in some of this detective work. Rather [00:41:00] than you putting on your Sherlock Holmes cap and try to comb through and look for clues yourself right. Now, sometimes you don't wanna do any of this stuff, right? A lot of people just wanna be hands off.
School of Bookkeeping Resources
---
Dan DeLong: Maybe they started with QuickBooks Online and never touched desktop. So we have a couple resources available for you as well at School of Bookkeeping, to be able to help you. So one thing is, whoops, you don't wanna do that. We have a, on our tools and resources page at the top of QuickBooks or our School of Bookkeeping we have a data conversion guide.
And really what this is a self-guided adventure, to allow you to work through. This whole process of, converting and making sure that this data will [00:42:00] convert. There's other options in here, if you're coming from Sage, for example, or NetSuite or and you want to get to QuickBooks online we have, some resources in here too.
But if you're just converting from desktop to online this. Resource here will ask you the questions to at least give you an idea that, yes, this file will come over, or maybe it won't. Are they, if they're using payroll, here's some things to look at. And then you can choose, okay the course might help me out.
I'm fine with the course. Or maybe I need some guided assistance and. That's that's just a way to, to work through some of those questions that you might not even know that you needed to ask. But you'll also be able to, work with us there if if you have any follow up questions about your project.[00:43:00]
And then lastly at School of Bookkeeping, we are bundling school of bookkeeping with with QuickBooks online. And I. As, because QuickBooks is making it so enticing to move to QuickBooks online if you bundle. Our elite version of school bookkeeping, which includes a quick answer, chat resource.
We will move, we will move your data for you if you purchase a subscription through us. Oh.
Rachel D: Oh, very cool.
Dan DeLong: And that's just. Getting the data, moving it over and providing you with the results as far as the import summary is concerned and helping you make that game plan.
So with with quick quick answers, you'll be able to ask some quick questions. You'll have access to all of our tutorials and video resources on [00:44:00] how do I do these things to help create that or help with your transition. Post-conversion game plan and the
Rachel D: training plan.
Oh, that's so helpful, because it's not always, you don't just go into QuickBooks online and know how to use all the things. Sometimes you need help.
Dan DeLong: Yeah. Yeah. And like, where did this go? Or why didn't this come over? That's a that's an that's a question that you can, an ask in quick answers and we can help, help determine why that is. Or I had 10 shipping addresses for my customer. Why didn't they come over? They don't. There is no such thing as multiple shipping addresses and QuickBooks online oh, okay. You gotta have someplace to go.
Intro (2): Yeah. In order
Dan DeLong: to know, in, in order to put it there.
Yeah. So that is, all of the, resources in a nutshell. We still have 10 minutes, [00:45:00] so I'm not gonna wait 10 minutes because we're already over our allotted allotted time. We'll just assume
Rachel D: it came over seamlessly.
Dan DeLong: Yeah. We'll give you an update next week when we talk about that.
Final Thoughts and Conclusion
---
Dan DeLong: Any, thoughts some thoughts on this, Rachel?
Rachel D: No, it's great. I love it. I, am one of those people where I, I. Like to rely on the experts migrating my data for me.
Dan DeLong: Yeah. So I mean it's it's, it certainly could be, it's a challenge, right? And I certainly would love to have been involved with the companies from the get go, so I would know, right?
Yeah. But there's a lot of things that are surprises, right?
Intro: Yes.
Dan DeLong: You could ask all of those questions on the. On the spreadsheet and they will still never tell [00:46:00] you that they, put a Citibank vendor as their taxed, right?
Rachel D (2): Yeah.
Dan DeLong: Vendor. Exactly. So
Rachel D (2): Exactly.
Rachel D: And then happen mean, but you have so many incredible resources in the School of bookkeeping that one could do it on their own and it's great.
Dan DeLong: Yeah. And if you have questions you can ask on the, on a specific lesson. For clarity or let us give us feedback. It's Hey. This is old and we can do another workshop to make sure we're updated. And that's what we're gonna do, is we're gonna repurpose the topics in that we've covered here and re-update them into, those lessons so that we keep it accurate.
So we appreciate you joining us here today on another workshop. And as always we'll see you next week and hope you have a great day. [00:47:00] [00:48:00]
