Shopify Showdown: Comparing Shopify connectors in QuickBooks [04.14.26]

WEBVTT
00:00:23.164 --> 00:00:25.294
Welcome to another QB Power Hour.
00:00:25.353 --> 00:00:31.143
Uh, today is our first in this new series of app Showdowns.
00:00:31.143 --> 00:00:48.094
Today we're gonna be having an a a, plethora of, apps to compare here with the Shopify Showdown, comparing Shopify connectors in QuickBooks with, not Sharrin, but a special guest, which will, um, finally be revealed.
00:00:48.183 --> 00:00:50.344
Uh, this today.
00:00:50.344 --> 00:00:53.914
Uh, my name is Dan DeLong, owner at Danwidth and School of Bookkeeping.
00:00:53.914 --> 00:01:04.713
Worked at Intuit for nearly, uh, 18 years co-hosting today, also over at School of Bookkeeping, doing a workshop on Wednesdays, oddly called Workshop Wednesdays.
00:01:05.524 --> 00:01:09.813
And admin of the Facebook group, uh, that we, uh, that.
00:01:10.819 --> 00:01:13.489
Ties to this to this webinar series.
00:01:13.819 --> 00:01:22.188
And joining us today is my co-host over at, uh, workshop Wednesday, Rachel DCI's, filling in for Sharrin today.
00:01:22.248 --> 00:01:30.078
Uh, for those that, um, haven't, uh, experienced the wonderment of Rachel tell us a little bit about yourself.
00:01:30.948 --> 00:01:31.849
Wonderment.
00:01:31.909 --> 00:01:32.569
Wow.
00:01:34.123 --> 00:01:34.974
Well, thanks Dan.
00:01:35.153 --> 00:01:40.668
I'm really happy to be here and, um, there's a lot of neat information on that slide there.
00:01:40.668 --> 00:02:02.688
But yeah, I specialize in e-commerce, accounting and bookkeeping and yeah, so with that we use a lot of automation tools and, um, I've spent a lot of time deep diving into the weeds with a lot of these tools and so, uh, spent a lot of time talking about it as well.
00:02:02.688 --> 00:02:04.819
So I've got a lot of insight.
00:02:05.149 --> 00:02:05.239
And
00:02:05.929 --> 00:02:11.929
you just got back from, uh, shop Talk, uh from, uh, which is a conference in Las Vegas.
00:02:11.929 --> 00:02:13.579
What is, uh, what is that all about?
00:02:14.058 --> 00:02:15.019
Oh, that was so cool.
00:02:15.019 --> 00:02:18.498
That was by far my favorite conference that I have ever been to.
00:02:18.498 --> 00:02:34.758
It was basically every e-commerce platform and marketplace was there, including Walmart, Amazon, Etsy, and Shopify of course, and WooCommerce and all kinds of things, and including payment platforms.
00:02:34.758 --> 00:02:37.038
They were all there, Stripe, PayPal.
00:02:37.338 --> 00:02:46.938
It was really cool and I had a lot of conversations with a lot of different companies there, and there's just a lot of stuff going on that I wanted to.
00:02:47.449 --> 00:02:53.868
Keep my, um keep, myself abreast of all of this information.
00:02:54.528 --> 00:02:54.769
Alright.
00:02:54.774 --> 00:03:07.549
There's, there's, there is a lot to know, uh, when it comes to, you know, this particular, uh, niche and you had come on the Power Hour, I think a couple years ago talking about, you know, the e-commerce niche nuances.
00:03:07.699 --> 00:03:07.968
Yeah.
00:03:08.959 --> 00:03:13.248
And, we'll be talking about some of the things that you and I have done since then.
00:03:13.729 --> 00:03:13.848
Mm-hmm.
00:03:14.088 --> 00:03:18.498
Um partnering together about this particular industry.
00:03:18.498 --> 00:03:23.568
But today we're, we're gonna be focusing on the, uh, the Shopify connections.
00:03:23.598 --> 00:03:33.739
Now if you wanna get connected with, uh, either myself or Sharrin, uh, you can log in or, or connect to with us on our respective platforms.
00:03:33.739 --> 00:03:37.639
Me over at School Bookkeeping and Sharrin over at clone and Conquer.
00:03:38.329 --> 00:03:42.889
And little bit about the updates to the QB Power Hour.
00:03:43.253 --> 00:03:43.524
We have.
00:03:44.179 --> 00:03:57.558
Since gone to individual registrations those of you that were attached to the recurring that's going to ultimately expire in probably, uh, three or four more webinars.
00:03:57.558 --> 00:04:09.498
We're trying to make sure that people, all the people that were part of that recurring series, uh get the memo that we are moving to the, individual registrations.
00:04:09.889 --> 00:04:23.689
Uh, and you're experiencing that overlap of if you are registered for one of the individual ones and you're also still registered under the, the recurring, you're gonna get two reminders.
00:04:24.379 --> 00:04:35.689
And we're trying to keep them in sync, but that's one of the reasons that we're moving to individual ones because it was very difficult for that recurring to be in sync with what reality is.
00:04:35.689 --> 00:04:40.788
So, uh, you might see some, some mismatches there and apologize for that, but.
00:04:41.613 --> 00:04:43.983
It's all gonna be, it's all gonna be Okay.
00:04:45.963 --> 00:04:46.233
Good.
00:04:46.293 --> 00:04:47.103
Reassured.
00:04:47.524 --> 00:04:48.093
Yes.
00:04:48.454 --> 00:05:00.423
Uh, so this is, uh, one of the the, the quarterly series is that we're trying to, um, incorporate in the power hour where this is an app showdown, right?
00:05:00.423 --> 00:05:13.653
Because I think, uh, and, and Rachel, we, we've kind of talked about this over at the, over at the workshop there's, no like silver bullet when it comes to the, integration of choice.
00:05:13.653 --> 00:05:32.103
And maybe you have one that is the the first one that you, that you deal with, but then there's always those individual necessary needs from, from a business that might need more than, than maybe your app of, choice.
00:05:33.244 --> 00:05:36.819
What, uh, what, what is your thought process about, you know.
00:05:38.178 --> 00:05:44.449
Choosing one or, or do you, do you, subscribe to, well this, all of these could work
00:05:45.528 --> 00:05:54.139
well, like you just said, they all are very different and it's just not a one size fits all type of thing.
00:05:54.139 --> 00:05:54.228
Mm-hmm.
00:05:54.918 --> 00:06:11.869
And so when I first started looking into a lot of apps several years ago, I kind of had that same misconception that I think a lot of people have, which is all I needed to do is bring the transactions over to QBO and then, you know, after.
00:06:11.913 --> 00:06:15.244
Uh, diving into that for quite a while, I realized, well, wait a minute.
00:06:15.634 --> 00:06:19.293
You have to back up a step and you have to realize, what am I trying to accomplish?
00:06:19.653 --> 00:06:44.163
And it's not just bringing the transactions over to QBO, I mean, there's various things that you want to happen when it comes over to QuickBooks Online, whether it's managing some type of inventory, or you want things to appear a certain way on the p and l, or you are trying to do some class tracking or location tracking.
00:06:44.163 --> 00:06:46.144
It really depends on what you're trying to accomplish.
00:06:46.144 --> 00:06:50.584
So you really want to ask yourself that question first.
00:06:50.584 --> 00:06:54.843
I, is it, do you have a client that's asking you for something specific?
00:06:55.233 --> 00:06:58.834
Are you trying to look at something specific?
00:06:58.834 --> 00:07:00.783
Maybe you're doing some kind of advisory.
00:07:01.053 --> 00:07:03.574
So there really is.
00:07:03.994 --> 00:07:08.944
A litany of different things that you can do with these different apps.
00:07:09.303 --> 00:07:14.403
Some work better than others, some work differently than others.
00:07:14.524 --> 00:07:14.613
Right?
00:07:14.673 --> 00:07:44.103
And so it's really important to, maybe not for everybody that's listening to have a deep understanding of all of them, maybe like I do, but, and you do Dan too but, really to have a foundational knowledge of the key issues, uh, not issues, but the key characteristics of some of the well-known connectors out there, including the Intuit connectors,
00:07:44.163 --> 00:07:44.434
right?
00:07:45.153 --> 00:07:45.363
Yeah.
00:07:45.363 --> 00:07:47.793
So that's, uh, this is our agenda for today.
00:07:47.793 --> 00:07:52.459
We'll be talking a little bit about some Intuit news where, um.
00:07:53.238 --> 00:07:58.999
We wanna make sure that people are aware about, uh, the canny option for feedback.
00:07:58.999 --> 00:08:01.728
That's not that's not an adjective, that's a noun.
00:08:03.319 --> 00:08:09.139
Canny is the avenue, uh for, feedback, and we'll talk a little bit about that.
00:08:09.439 --> 00:08:24.379
Uh, but then we'll break down into the Shopify sales connectors, what they are, what are what's, one of those, some of those considerations that you wanna, uh, work with in, in talking things through with your clients, uh, or prospective clients.
00:08:24.408 --> 00:08:27.259
Uh, what is available inside of QuickBooks online.
00:08:27.649 --> 00:08:31.728
And then we'll talk about what is available outside of QuickBooks Online.
00:08:32.149 --> 00:08:40.369
Uh, breaking down the, summary integrations or the detail integrations or when you need something that's more than just Shopify.
00:08:40.369 --> 00:08:43.818
So that's, that's hopefully everything that we'll we'll get into today.
00:08:44.688 --> 00:08:47.058
It is a lot to cram into an hour.
00:08:47.418 --> 00:08:51.859
Uh, we do have additional resources because, uh, Rachel and I have spent.
00:08:52.219 --> 00:08:57.948
The last couple years talking about these, these features or this function.
00:08:58.489 --> 00:09:07.639
Um, and we do have you know, some courses and content available over at school bookkeeping, uh, to review at another another time.
00:09:08.028 --> 00:09:16.308
All right, so let's start off with the first poll question with how many clients do you have who use, uh, Shopify?
00:09:16.548 --> 00:09:34.668
Now, Rachel, that is not the only player in, town when it comes to a, a sales channel, a Shopify, but why is Shopify kind of like the first place that, that Shopify tends to, or, or sales channel that, that people team to gravitate towards?
00:09:35.178 --> 00:09:36.589
What's so great about Shopify?
00:09:37.428 --> 00:09:38.688
Because it's the best,
00:09:40.399 --> 00:09:41.028
but why?
00:09:41.989 --> 00:09:43.219
Well, I'm biased.
00:09:43.219 --> 00:09:47.899
I'm a Shopify partner and reseller and can collaborator and.
00:09:48.754 --> 00:09:49.714
Let me just say this.
00:09:49.744 --> 00:09:59.433
If you happen to be at Shop Talk in Las Vegas a couple weeks ago and you saw Shopify's booth, it was like the size of a city block.
00:09:59.913 --> 00:10:00.063
Wow.
00:10:00.063 --> 00:10:07.234
You could really understand how significant Shopify is in this space there.
00:10:07.594 --> 00:10:19.264
Shopping cart power is so incredible that I, you can, you can have a multimillion dollar e-commerce brand on the Shopify platform.
00:10:19.264 --> 00:10:37.683
So Shopify really is meant, and this is what they'll tell you, Shopify is meant to create a Shopify store in a day, which you could, and start with basically nothing and scale that up to a multimillion dollar enterprise in a matter of weeks or months.
00:10:37.683 --> 00:10:38.974
I mean, it's limitless.
00:10:38.974 --> 00:10:40.683
It's really what you can do.
00:10:40.714 --> 00:10:42.844
They can do it what you can imagine.
00:10:42.874 --> 00:10:43.504
They can do it.
00:10:43.714 --> 00:10:44.854
It's just very powerful.
00:10:44.913 --> 00:10:46.323
Uh, I like the reporting.
00:10:46.698 --> 00:10:54.109
I like the ability, the, you know, the, the working with the products.
00:10:54.139 --> 00:11:01.578
'cause I, I also deal with inventory management and we don't manage the inventory in Shopify.
00:11:01.609 --> 00:11:03.499
We can have a whole other discussion about that.
00:11:03.499 --> 00:11:04.969
We're not gonna get into that now.
00:11:04.999 --> 00:11:08.568
But I do go into the product setup.
00:11:08.568 --> 00:11:10.399
I do look at variance.
00:11:10.399 --> 00:11:11.808
I do look at cost goods sold.
00:11:11.808 --> 00:11:13.458
I do look at things like that.
00:11:13.458 --> 00:11:20.808
And just in terms of sometimes when I need to dig around Shopify, I can usually find what I need.
00:11:21.198 --> 00:11:25.038
Some of the other platforms not so much.
00:11:25.663 --> 00:11:26.083
Mm-hmm.
00:11:26.874 --> 00:11:27.163
Yeah.
00:11:27.224 --> 00:11:33.288
And, and, um it, it's kind of like Shopify is the QuickBooks of e-commerce, right.
00:11:33.288 --> 00:11:36.259
It's a, it's a really good entry point.
00:11:36.769 --> 00:11:39.379
It, it does a lot of things for a lot of people.
00:11:39.379 --> 00:11:43.068
And then there's this whole app ecosystem or plugins.
00:11:43.399 --> 00:11:48.318
For when you need to need it to do more than it does right out of the box.
00:11:48.649 --> 00:11:49.038
Yeah.
00:11:49.038 --> 00:11:51.408
And I just wanna speak to Nicole really quick.
00:11:51.438 --> 00:11:51.774
Um mm-hmm.
00:11:51.859 --> 00:11:54.048
There's some nuance when you're dealing with wholesale.
00:11:54.048 --> 00:12:05.778
I would never recommend you can do it, there's some workarounds and tricks to do it with a tax exempt customer, but I would not do wholesale and retail in one Shopify store.
00:12:06.168 --> 00:12:12.948
When you're managing that in one Shopify admin, I would do a second Shopify store just for wholesale.
00:12:12.948 --> 00:12:24.259
Or if you are dealing with more complexity when you're doing retail and wholesale, I would wholesale out of an IMS and we'll get to that at the end of the, of the hour.
00:12:25.428 --> 00:12:25.609
Yeah.
00:12:25.609 --> 00:12:33.918
Looking at the, poll results looks like, uh, 71%, uh, are only a few clients, uh, using, using Shopify.
00:12:33.918 --> 00:12:40.548
So there are a, a handful or smattering of, uh of, of, us with.
00:12:41.854 --> 00:12:43.774
Shopify, uh, Shopify clients.
00:12:43.774 --> 00:12:50.553
So let's, uh, let's talk a little bit about the Intuit news and updates and talk about canny feedback for accountants.
00:12:51.063 --> 00:12:54.573
And I meant to put the link in the slides and it looks like it's not there.
00:12:55.413 --> 00:13:06.604
But there is a new-ish feedback channel that is available and, and focused on the accountant community, right?
00:13:06.604 --> 00:13:19.413
We, because we, we tend to have pretty good feedback, uh, because we're, we use it regularly and putting it into the gear and send feedback.
00:13:19.413 --> 00:13:26.073
It, it's just kind of this sending it over the wall and you, there's really no closed loop when it comes to that.
00:13:26.073 --> 00:13:31.653
So Intuit has, has rolled out this is the second coming of this thing.
00:13:31.714 --> 00:13:38.673
Um, this, uh, something similar, uh, they had, oh, probably in like 2013.
00:13:39.778 --> 00:13:39.999
But.
00:13:40.683 --> 00:13:53.313
What this allows you to do is to, you can essentially use your, your Intuit login same login that you use, or your same email address and, and password that you use for for your QuickBooks.
00:13:53.644 --> 00:13:59.884
But right now they, they're focusing this, uh, this feedback on three major areas.
00:13:59.884 --> 00:14:08.793
The bank feeds modern reports and payroll, uh, which are three big concerns for the, accounting community.
00:14:09.543 --> 00:14:31.114
But what this allows you to do is to see other people's feedback and you can upvote it, uh, so that, so you don't have to keep putting in individual, like, you know, if Rachel and I put in the exact same feedback, it requires somebody else to combine those into now two pieces of feedback for the same thing.
00:14:32.313 --> 00:14:37.833
This allows you to, to look at the previous, uh, submissions and just.
00:14:38.734 --> 00:14:43.443
Upvote it and, and say Me too type of thing with those things.
00:14:43.504 --> 00:15:05.254
And on top of all of that, Intuit product developers or, um, you know, development or project managers or product managers, uh, that are overseeing these, some of these initiatives will provide context ask for more information if they need to on those specific feedbacks that are there.
00:15:05.644 --> 00:15:17.524
Um, and then they'll, be able to put them into things that are under review things that are planned to be rolled out, and things that are already, uh, released.
00:15:19.504 --> 00:15:25.774
If you have feedback, this is a great way to, to put that in to see if it's already there.
00:15:25.774 --> 00:15:32.014
And then you get digests sent to, to your email when there is updates to those things.
00:15:32.014 --> 00:15:39.379
So it's a, it's a pretty interesting, experiment that they're doing with the accounting community.
00:15:39.379 --> 00:15:45.318
I believe the website is intuit.canny.io.
00:15:45.318 --> 00:15:47.058
I'll have to look that up.
00:15:47.538 --> 00:15:54.828
And, uh, let's just see if that actually works before I put it in the chat.
00:15:57.048 --> 00:15:57.558
And it is.
00:15:57.558 --> 00:15:57.828
Okay.
00:15:57.828 --> 00:16:05.958
So I'm gonna put that in the, chat here so that everybody has, uh, access to, setting that up if you haven't already.
00:16:06.739 --> 00:16:10.908
Or checking it out if you have and forgot about it.
00:16:12.619 --> 00:16:16.609
So that's, uh, that's something to, just keep in mind about feedback.
00:16:17.359 --> 00:16:24.948
I think this is part of the challenge of, Intuit is that they have a lot of data and a lot of feedback.
00:16:25.849 --> 00:16:31.908
And, you know, if, if you have different places to put in feedback, it, it ends up being.
00:16:33.693 --> 00:16:36.004
Spread out and maybe not consolidated.
00:16:36.663 --> 00:16:40.114
I'm, my hope is that this becomes the feedback channel.
00:16:40.474 --> 00:16:46.024
Uh, but of course, like anything else that Intuit puts out, it's not gonna get any notice if it's never used.
00:16:48.693 --> 00:16:54.274
Check it out and, uh, and we will see how this evolves over, time.
00:16:55.173 --> 00:17:03.874
Alright uh, so as mentioned, uh, Rachel and I did a workshop series, uh, which was very low key.
00:17:03.874 --> 00:17:10.923
And, and you know the, idea of, of the workshop series is it's casual conversations for serious workflows.
00:17:11.374 --> 00:17:16.534
Uh, so we don't really go into a lot of demos or deep dives.
00:17:16.594 --> 00:17:21.064
It's really just a conversation that we have about those things.
00:17:21.874 --> 00:17:27.243
You know, we certainly can, you know, share, you know, screens and those types of things on the, on the workshops.
00:17:27.243 --> 00:17:32.794
But our main goal is to have conversations about these concepts and topics.
00:17:33.213 --> 00:17:45.814
Uh, so we talk about the different components, uh, of a e-commerce business, different sales channels versus marketplaces, inventory management and considerations about that.
00:17:45.814 --> 00:17:51.453
And then of course, sales tax is gonna always creep up into that picture.
00:17:51.903 --> 00:17:55.713
Um, and then dealing with, uh, Shopify fees and expenses.
00:17:55.713 --> 00:17:57.723
So, uh, we created a playlist.
00:17:57.723 --> 00:18:01.564
So you can just, uh, click on the link there in the, in the, the handouts.
00:18:02.344 --> 00:18:06.153
I'll watch the playlist at, your, at your leisure.
00:18:06.153 --> 00:18:10.973
Or you can, uh, you know, go into the school of bookkeeping and we have those in there as well.
00:18:12.979 --> 00:18:20.929
So one of the bigger concepts about e-commerce is this concept of, of clearing accounts.
00:18:20.929 --> 00:18:37.068
So Rachel, you wanna just kind of set the stage of, clearing accounts why they're, why they're necessary when it comes to, you know, e-commerce and, and how you ultimately end up using them in this, type of, uh, industry.
00:18:38.209 --> 00:18:38.568
Yeah.
00:18:38.568 --> 00:18:45.828
So even though I work in inventory and e-commerce, I'm an accountant.
00:18:45.828 --> 00:18:47.058
I'm an accountant first.
00:18:47.058 --> 00:18:50.118
I'm also working on my master's in accounting, believe it or not, right now.
00:18:50.509 --> 00:19:07.493
And so, um, there's a lot of reasons that we use clearing accounts, but in specifically e-commerce, one of the main reasons is exactly what you wrote here, a temporary account to account for the passage of time and really.
00:19:08.388 --> 00:19:09.288
To think about it.
00:19:09.499 --> 00:19:15.048
The best way is it is eventually going to clear out.
00:19:15.169 --> 00:19:17.058
That's why it's called a clearing account.
00:19:17.088 --> 00:19:29.298
So I may put something on the credit side on one day, and then the next day I'll put something on the debit side and then it'll clear out to zero.
00:19:29.719 --> 00:19:38.209
So for example, in oh yeah, so, so you've got undeposited funds and accounts receivable.
00:19:38.209 --> 00:19:41.568
So those are classic examples of a clearing account, right?
00:19:41.568 --> 00:19:50.538
So you're posting some revenue in accounts receivable, and then when the payment comes in, it's going to clear that out.
00:19:50.538 --> 00:19:57.769
So it's a pretty simple concept, but in e-commerce, one of the reasons that we use a clearing account is because.
00:19:58.338 --> 00:20:02.358
The payments don't always come in.
00:20:02.419 --> 00:20:07.548
Well, I'm not gonna say don't always, never come in individually.
00:20:07.548 --> 00:20:08.929
They come in in a batch.
00:20:09.138 --> 00:20:21.798
So it, there are times in which we post the revenue to QuickBooks in either a individual sale or a summary for the day.
00:20:22.219 --> 00:20:25.098
But either way, that's still getting posted to revenue.
00:20:25.429 --> 00:20:29.239
And so, and as we know in accounting, revenue is a credit.
00:20:29.479 --> 00:20:47.419
So what we do is we post the expected payout to the debit side, and then when that cash deposit comes in, we credit the clearing account, thus clearing out the clearing account and debit cash.
00:20:47.419 --> 00:20:48.078
Sorry about that.
00:20:48.078 --> 00:20:48.858
That was my backpack.
00:20:48.858 --> 00:20:51.979
So that's really how it works in a nutshell, using debits and credits.
00:20:51.979 --> 00:20:54.048
And I'm sorry too, you used debits and credits, but.
00:20:55.023 --> 00:20:58.834
It's really the best way to explain it and understand it.
00:20:58.834 --> 00:21:00.814
And I can talk about debits and credits forever.
00:21:00.933 --> 00:21:02.824
So if anybody wants to chat about that.
00:21:02.824 --> 00:21:15.513
And then one other thing that I'll say is one of the reasons that we do kind of keep this you know, more conversational than really getting into the nitty gritty, especially as it pertains to inventory, is it's hard.
00:21:15.814 --> 00:21:22.263
And so I'm more than you know, available and welcome to chat with anybody one-on-one.
00:21:22.263 --> 00:21:33.153
When it comes to the managing of the inventory, it is so closely related to the movement of financial information when we're talking about this topic.
00:21:33.423 --> 00:21:36.544
So it can get really complicated really quickly.
00:21:36.544 --> 00:21:38.499
So that's, I just wanted to add that on there of.
00:21:39.423 --> 00:21:46.294
You know why sometimes we kinda have to stay away from the ultra complex when it comes to that, but mm-hmm.
00:21:46.564 --> 00:21:53.763
There usually always is a very ultra complex answer that we can tailor to everybody's situation.
00:21:53.973 --> 00:22:00.544
But when you are doing e-commerce, accounting and bookkeeping, you gotta use a clearing account.
00:22:00.663 --> 00:22:05.314
If you're thinking that you're not going to, you're not gonna do it.
00:22:05.314 --> 00:22:05.614
Right.
00:22:05.703 --> 00:22:07.443
That's I'll die on that hill.
00:22:07.534 --> 00:22:08.854
You must use a clearing account.
00:22:10.263 --> 00:22:10.564
Yeah.
00:22:10.564 --> 00:22:18.334
And, and you, uh, you typically will set them up either as a ba you, set them up as bank accounts or other current assets, or does that matter?
00:22:19.144 --> 00:22:23.554
It depends on if you want to deposit to the clearing account there.
00:22:23.554 --> 00:22:24.574
It really depends.
00:22:24.574 --> 00:22:33.213
There are some situations where if, depending on the connector that I'm using, I will map and set up and create a.
00:22:34.038 --> 00:22:35.419
Sales posting.
00:22:35.449 --> 00:22:38.808
And then I'll also automate and create a payout posting.
00:22:38.808 --> 00:22:44.568
And so there I'm getting match, match, match, match, And the bank feeds don't need to deposit anything.
00:22:44.719 --> 00:22:52.608
If oftentimes maybe I'm using something that's a little more obscure and it can only post the revenue and it can't post the sale.
00:22:52.608 --> 00:22:58.878
I mean the, the payout portion I will then deposit, said payout into the clearing account.
00:22:58.878 --> 00:23:03.769
And in that situation, you wanna set it up as a checking account.
00:23:03.769 --> 00:23:06.769
And Dan can get into the nuance of QBO.
00:23:07.429 --> 00:23:10.278
You can't deposit into another current asset account.
00:23:10.278 --> 00:23:12.828
And so it really depends.
00:23:13.219 --> 00:23:13.429
Yeah.
00:23:13.429 --> 00:23:14.808
I hate answering that way, darn it.
00:23:15.919 --> 00:23:17.568
That is the common answer.
00:23:18.199 --> 00:23:20.538
That would, it has to do with depends, right?
00:23:21.499 --> 00:23:26.778
'cause there, because there is no silver bullet, you know, one size fits all right.
00:23:26.778 --> 00:23:27.469
But, um.
00:23:27.858 --> 00:23:28.189
Yeah.
00:23:28.189 --> 00:23:33.888
And as a, as a advisor, you know, everybody's advisory, my advisory is in this space.
00:23:33.888 --> 00:23:40.398
It's an inventory management e-commerce accounting and sales tax and, and that kind of thing.
00:23:41.509 --> 00:23:43.729
It, does require a lot of questions.
00:23:43.788 --> 00:23:49.219
It does require a lot of digging and nuance and finding out a lot of this stuff before you dive in.
00:23:49.219 --> 00:23:50.749
So that's why we're having this session.
00:23:51.588 --> 00:23:51.919
Right.
00:23:52.489 --> 00:24:08.868
And so so this, comes into the conversation when someone has a Shopify business and they have QuickBooks and they want to investigate the option of, well, how do I get.
00:24:09.483 --> 00:24:12.574
My Shopify sales into, QuickBooks.
00:24:12.574 --> 00:24:12.844
Right?
00:24:12.844 --> 00:24:15.933
So there is going to be, there's a variety of ways.
00:24:15.933 --> 00:24:18.574
And of course the answer of how do you do that?
00:24:18.604 --> 00:24:21.124
What's the best way to do that is of course it depends.
00:24:21.723 --> 00:24:21.814
Mm-hmm.
00:24:23.044 --> 00:24:30.003
It will depend on some considerations that we're gonna be talking about and the application, their budget those types of things.
00:24:30.364 --> 00:24:46.953
Uh, but in, in the grand scheme of things, a sales sale, a Shopify sales connector, or we would, you know, I would call'em a bridge, is a way to get those sales and sales transactions into QuickBooks in a usable way.
00:24:47.614 --> 00:24:54.364
And so there are a lot of ways, uh, or considerations when determining which way is available.
00:24:54.364 --> 00:25:08.433
There is you know, a Shopify connection inside of QuickBooks online, and then there's, uh, a host of other apps that do essentially they adver, they all advertise the same thing, but.
00:25:08.808 --> 00:25:11.959
And there's also hand keying in the orders.
00:25:11.959 --> 00:25:12.318
And
00:25:12.439 --> 00:25:12.679
yeah,
00:25:12.888 --> 00:25:25.189
I would rather die than do that, but I'm saying that because sometimes I have conversations with business owners or their team or whatever, that not everybody knows everything, right?
00:25:25.189 --> 00:25:27.739
And so they're, they'll hand key them in.
00:25:27.739 --> 00:25:29.298
So that is a thing too.
00:25:30.439 --> 00:25:35.749
You know, in our world of apps, we don't need to do that anymore,
00:25:36.439 --> 00:25:36.709
right?
00:25:37.788 --> 00:25:43.999
And, um, so let's, let's kind of go into this, uh, this Shopify Showdown selecting the right tool.
00:25:43.999 --> 00:25:46.459
And here's where the challenge comes in, right?
00:25:46.459 --> 00:25:53.898
Like if you do it, if you go to apps.com or the QuickBooks online apps app center and type in the word Shopify, you get.
00:25:54.439 --> 00:25:57.558
I did it right before the, uh, the session today.
00:25:57.558 --> 00:26:01.189
I got 41 results for the word Shopify.
00:26:01.519 --> 00:26:04.909
And you can see two of them are essentially the same thing.
00:26:05.929 --> 00:26:09.439
Shopify connector by QuickBooks or Shopify for QuickBooks Online.
00:26:09.439 --> 00:26:13.489
Are they are, they, one of the one in the same thing or not?
00:26:13.489 --> 00:26:13.999
I don't know.
00:26:13.999 --> 00:26:16.189
Because they've got the same icon.
00:26:17.088 --> 00:26:17.269
Yeah.
00:26:17.298 --> 00:26:26.598
So you'd have to go look and see if that is, well, why does this one have 4.8, uh, star reviews with 4,600 reviews and this one has 2.2?
00:26:27.919 --> 00:26:30.288
That's, aren't they the same thing?
00:26:30.288 --> 00:26:31.999
Well, they may or they may not be.
00:26:32.509 --> 00:26:32.838
Right.
00:26:32.838 --> 00:26:41.328
But the core features of these Shopify sales connectors are they're going to post or bring in, in, in their way.
00:26:41.509 --> 00:26:45.828
Not necessarily the way that you want, but the way that that application is designed to work.
00:26:46.128 --> 00:26:48.078
Sales and return information.
00:26:48.919 --> 00:27:12.003
Things of, you know, that, that impact that sale shipping costs, sales tax, you know, those, all those considerations or, parts of that sale, and get that into QuickBooks and then reconcile the payout in some, manner with those transaction fees that they lovingly charge.
00:27:12.453 --> 00:27:15.394
Uh, so for the payment processor.
00:27:16.263 --> 00:27:25.023
So would you say, Rachel, that that in a nutshell is what these what these sales, Shopify sales connectors are designed to do?
00:27:25.384 --> 00:27:25.773
Yeah.
00:27:25.834 --> 00:27:27.634
They do it for you, which is great.
00:27:27.723 --> 00:27:27.784
Yeah.
00:27:27.844 --> 00:27:33.874
I mean, we're at the point now where we're, not just data entry clerks, right?
00:27:33.878 --> 00:27:34.169
Mm-hmm.
00:27:34.384 --> 00:27:40.354
We are relying on automation tools to bring in this data.
00:27:40.534 --> 00:27:42.663
We verify the data, right?
00:27:42.693 --> 00:27:43.983
So now we can.
00:27:44.628 --> 00:27:47.118
Beyond, we can go beyond data entry.
00:27:47.118 --> 00:27:55.338
We can truly do more analysis for our clients and build our firms in a completely different way like I have.
00:27:56.449 --> 00:28:03.259
And that's why you have these things funneling through the clearing accounts, right?
00:28:03.263 --> 00:28:03.403
Uhhuh?
00:28:03.769 --> 00:28:09.378
'cause the payouts are gonna be a grouping of individual sales transactions.
00:28:09.378 --> 00:28:17.989
So if you are putting into this OnDeck circle, all of the sales of the sales of sales are, are are coming in into QuickBooks.
00:28:18.409 --> 00:28:24.979
And eventually there will be a payout of that hitting the bank account minus fees and.
00:28:26.013 --> 00:28:27.874
Depending on how they paid for it.
00:28:27.874 --> 00:28:28.144
Right?
00:28:28.144 --> 00:28:38.223
And we talked about, you know, the buy now pay later or different options, PayPal as a payment method, those are going to hit the bank account in a different fashion.
00:28:38.763 --> 00:28:50.104
And so that's, that's why you would use these clearing accounts so that some transactions go into the PayPal clearing account and then the PayPal deposit comes in at a later date.
00:28:50.398 --> 00:28:50.618
Yep.
00:28:50.618 --> 00:28:50.778
Right?
00:28:50.778 --> 00:28:51.148
And that's, yep.
00:28:51.183 --> 00:28:51.364
And
00:28:51.364 --> 00:28:59.223
I use a clearing account for every single payment method, for every single marketplace, for every single platform.
00:28:59.284 --> 00:29:00.604
I, that's the way I do it.
00:29:01.473 --> 00:29:08.884
I, I think that's the way most people do it, but that's the way I do it, just because when I've got one clearing account for.
00:29:09.378 --> 00:29:10.999
A lot of different payment methods.
00:29:10.999 --> 00:29:12.648
It just gets too convoluted for me.
00:29:12.648 --> 00:29:15.439
And I have clients that are omnichannel.
00:29:15.439 --> 00:29:19.249
I mean, we've got payment methods and things coming in from all over the place.
00:29:19.249 --> 00:29:25.759
So as an accountant, it's really the better way, um, at least for my brain to do it,
00:29:26.058 --> 00:29:26.358
right?
00:29:27.348 --> 00:29:30.229
So there are a lot of things to consider, right?
00:29:30.288 --> 00:29:35.388
As far as determining what might be the best route to go.
00:29:35.749 --> 00:29:40.429
And so here's just a smattering of, some of those considerations, right?
00:29:40.429 --> 00:29:40.759
So,
00:29:40.909 --> 00:29:41.118
yeah,
00:29:41.118 --> 00:29:49.788
big thing I think the first thing to determine with your client is where is that inventory source of truth gonna be?
00:29:50.209 --> 00:29:52.249
Because that is the number one consideration.
00:29:52.278 --> 00:29:57.288
Absolutely most important consideration is inventory source of truth,
00:29:57.888 --> 00:29:58.068
right?
00:29:58.548 --> 00:30:04.459
Because if you are managing your inventory inside of QuickBooks, then everything has to be in service to that.
00:30:04.969 --> 00:30:06.588
So that is going to.
00:30:07.038 --> 00:30:11.538
Rule out or allow various other options.
00:30:12.348 --> 00:30:27.439
When we, get to, you know, the the, difference of, and, uh, but before we get in too deep, I wanna let people know that at the end there is, uh, a slide that puts a side by side comparison of all of the ones that, that we're gonna be talking about here today.
00:30:28.249 --> 00:30:32.959
Which one's the best for this or that, or, you know, what, what its ideal fit is for.
00:30:32.959 --> 00:30:38.509
So don't worry, there will be a, a summary at the end, right?
00:30:39.048 --> 00:30:39.318
But the
00:30:39.318 --> 00:30:40.034
inventory source is true.
00:30:40.034 --> 00:30:40.153
Yeah.
00:30:40.153 --> 00:30:45.019
And I just wanna just say really quick too, there, you can manage your inventory in QBO.
00:30:45.048 --> 00:30:51.378
I mean, I know that's a big point of contention for a lot of different people out there.
00:30:52.699 --> 00:30:57.439
In on workshop Wednesday, we have talked about this many a time.
00:30:57.979 --> 00:31:00.318
There are, and so I'm not even gonna get into it.
00:31:00.378 --> 00:31:03.739
I'm just gonna say yes you can, if it's simple enough.
00:31:04.324 --> 00:31:08.763
If there's not a lot of skews, if you're just on one platform, yeah.
00:31:08.884 --> 00:31:24.993
If you're not concerned about it pushing inventory levels to your platform, there are situations in which you can, and sometimes even it's easier to do in QBO if they're not wanting, if your client isn't really wanting anything, all that complex there.
00:31:24.993 --> 00:31:28.114
I have clients that manage their inventory in QBO.
00:31:28.114 --> 00:31:28.203
Right.
00:31:28.233 --> 00:31:35.284
And for that reason are, you gonna, are you gonna say what type of connection we want?
00:31:35.284 --> 00:31:36.334
If they're doing that,
00:31:37.594 --> 00:31:37.804
yeah.
00:31:37.864 --> 00:31:40.144
Then you'd want some detail, you know?
00:31:40.144 --> 00:31:40.203
Yeah.
00:31:40.203 --> 00:31:40.864
The sales detail.
00:31:41.314 --> 00:31:41.614
Yeah.
00:31:41.614 --> 00:31:49.144
So in that situation, you want individual sales transactions and so you need that,'cause you need the item information.
00:31:49.144 --> 00:31:49.503
Right.
00:31:49.503 --> 00:31:51.394
You need to know on the sales receipt.
00:31:51.933 --> 00:31:59.973
And by the way, I usually will always use a sales receipt when those are coming into QBO.
00:31:59.973 --> 00:32:01.923
I don't ever use an invoice.
00:32:01.923 --> 00:32:03.088
Try not to use an invoice.
00:32:03.088 --> 00:32:03.368
Yeah.
00:32:03.663 --> 00:32:04.054
Yeah.
00:32:04.054 --> 00:32:08.314
Because I don't need it to hit AR because it's a point of sale transaction.
00:32:08.314 --> 00:32:08.794
You right.
00:32:08.794 --> 00:32:09.394
It's not a.
00:32:09.798 --> 00:32:12.558
I'm giving you an invoice and then you pay me 30 days later.
00:32:12.558 --> 00:32:14.838
No, it's a point of sale transaction.
00:32:15.108 --> 00:32:22.278
I'm recording the point of sale and I'm recording the offset, the clearing account of where I'm expecting that payout.
00:32:22.338 --> 00:32:23.659
So easy peasy.
00:32:24.378 --> 00:32:24.528
Yeah.
00:32:25.159 --> 00:32:32.028
So like this feeds into the next topic of, you know, Shopify Omnis sellers or, multiple channels, right?
00:32:32.028 --> 00:32:39.108
Because once they start selling on, on Shopify that's kind of like the gateway drug of e-commerce, right?
00:32:39.943 --> 00:32:52.034
Hey, look at all these other places that I could sell, uh, stuff online like Amazon or or Walmart marketplace or TikTok shop or, you know, various other places to put those things in.
00:32:52.034 --> 00:33:04.544
So when you're deter once, once you've established where your inventory source of truth is, like Debbie just said in the chat, my client is managing their inventory in Shopify, which is possible, you know, you can do that.
00:33:05.294 --> 00:33:11.384
It's not, you're not gonna get a full inventory workflow, though it can't do purchasing, but we can talk about that offline.
00:33:12.403 --> 00:33:12.733
Right?
00:33:12.733 --> 00:33:20.443
But then you have an omni seller who's selling in more than one place, Shopify and Amazon, for example.
00:33:20.653 --> 00:33:20.743
Mm-hmm.
00:33:20.983 --> 00:33:21.134
Right?
00:33:21.134 --> 00:33:27.013
And now there's a consideration of, how do I tell those different two.
00:33:27.544 --> 00:33:30.483
Platforms how much I have available to sell.
00:33:31.054 --> 00:33:35.584
Because Amazon is pretty, uh, annoying when
00:33:36.243 --> 00:33:36.513
Yeah,
00:33:36.604 --> 00:33:41.344
you don't have, when you sell something and you can, and you can't chip it, right?
00:33:41.584 --> 00:33:42.798
They They.
00:33:42.798 --> 00:33:50.568
wag their finger seriously at the Amazon sellers when they're not, you know, when they put stuff on back order, right?
00:33:50.568 --> 00:33:58.098
So that, that becomes a consideration when we're talking about o Omni sellers also selling with, with Shopify.
00:33:58.519 --> 00:34:15.048
And Shopify in their infinite wisdom would, could potentially say, well, let's just connect your Amazon to Shopify and now you have the way to get it inside of QuickBooks, but now that it further complicates the connector that you might be utilizing,
00:34:15.108 --> 00:34:16.699
if that's the case, well, you can't do that now.
00:34:16.699 --> 00:34:19.623
I just spoke to Amazon at Shop Talk.
00:34:19.623 --> 00:34:19.824
Mm-hmm.
00:34:19.909 --> 00:34:27.829
And they actually now have a functionality within Amazon to connect your Shopify and manage that inventory.
00:34:28.039 --> 00:34:32.148
Again, this stuff is, that technology is changing so fast.
00:34:32.494 --> 00:34:32.943
So,
00:34:32.943 --> 00:34:33.543
so fast.
00:34:33.543 --> 00:34:41.313
That was as of they, the guy told me as of like a month before that they finally got that completed.
00:34:41.583 --> 00:34:44.434
So I'm gonna be learning a lot more about that as well.
00:34:44.434 --> 00:34:49.264
And so it's really wild how fast this stuff changes.
00:34:50.463 --> 00:34:54.123
And then so another consideration is, is how they're collecting funds, right?
00:34:54.123 --> 00:34:57.784
Is it all through just Shopify payments, which is the preferred method?
00:34:58.173 --> 00:35:02.914
Are they using some other payment processor to, to actually do the processing?
00:35:04.083 --> 00:35:10.054
If their PayPal, their potential buy now, pay later maybe they'll throw in a loan.
00:35:10.173 --> 00:35:10.534
Uh,
00:35:10.534 --> 00:35:10.923
yeah.
00:35:11.389 --> 00:35:11.719
Well, yeah.
00:35:11.719 --> 00:35:12.438
And in Shopify,
00:35:12.858 --> 00:35:19.474
by the way, you, they've got native integration with hundreds and hundreds of other third party gateway.
00:35:19.713 --> 00:35:27.574
So what I want to clarify is when I say Shopify is the best, I am not saying Shopify is the best at inventory management.
00:35:28.068 --> 00:35:29.358
We manage that elsewhere.
00:35:29.449 --> 00:35:29.838
Okay.
00:35:29.958 --> 00:35:31.878
We push levels to the storefront.
00:35:32.059 --> 00:35:40.518
So Shopify is best at native integrations, reporting if you need a Shopify loan.
00:35:40.969 --> 00:35:52.489
All kinds of different things that, that it's creating a store like in a snap, it's got all kinds of benefits to it, not necessarily with inventory management.
00:35:54.364 --> 00:35:54.844
Yes.
00:35:54.844 --> 00:36:01.293
And, uh, there are, there are plenty of other considerations like sales tax, right?
00:36:01.293 --> 00:36:07.833
Which is a huge consideration where they're collecting and, submitting sales tax, right?
00:36:07.833 --> 00:36:19.204
If, uh, depending on how that in information is getting from Shopify into QuickBooks, you know, they may be severing, uh, work workflows based on how that information is coming in.
00:36:19.204 --> 00:36:19.233
Uh,
00:36:20.014 --> 00:36:28.083
so yeah, and sales tax, by the way, is another area where Shopify excels in comparison to WooCommerce, which I deal a lot with.
00:36:28.474 --> 00:36:31.713
WooCommerce is the worst when it comes to sales tax.
00:36:31.773 --> 00:36:36.153
Shopify highly outperforms WooCommerce.
00:36:37.849 --> 00:36:40.789
So I, I'm throwing up the, uh, second poll question.
00:36:41.179 --> 00:36:44.329
Have you ever, have you tried the internal Shopify connector?
00:36:44.748 --> 00:36:47.958
Uh, looks like it's pretty evenly of, uh, yes.
00:36:47.958 --> 00:36:50.268
Still using it, and yes, I turned it off.
00:36:51.289 --> 00:37:02.898
Uh, so about 50% of the people who have tried it have turned it off, um, and, and the, rest are not even trying it or it's not applicable to what they do.
00:37:03.588 --> 00:37:09.858
Uh, so let me go ahead and end the poll and share the results there and we'll, we'll talk about that.
00:37:10.099 --> 00:37:11.659
Uh, Shopify Sales connector.
00:37:11.659 --> 00:37:14.539
What is available, uh, inside of QBO?
00:37:15.318 --> 00:37:18.018
You can't beat the price, uh, because it is free.
00:37:18.378 --> 00:37:32.329
Uh, depending on your your version of QuickBooks, uh, you get, I think one sales connector with with Simple Start three with sh.
00:37:33.543 --> 00:37:34.114
Essentials.
00:37:34.114 --> 00:37:36.153
I couldn't, I couldn't think of it there for a second.
00:37:36.483 --> 00:37:39.244
And then, uh, it's unlimited at plus in advance.
00:37:40.563 --> 00:37:49.594
But uh, I think there's only, uh, four or five, uh, that are, that are ultimately, uh, available as a sales connector that Intuit creates.
00:37:50.193 --> 00:37:50.463
Um,
00:37:50.463 --> 00:37:55.653
yeah, and I love how Ben has said it's turned to garbage as of November, 2025.
00:37:55.983 --> 00:37:58.474
I love that he has like a specific date
00:38:00.393 --> 00:38:01.264
when that occurred.
00:38:01.713 --> 00:38:03.784
I think it's before then, but that's okay.
00:38:04.969 --> 00:38:05.349
It does
00:38:05.599 --> 00:38:05.949
enter.
00:38:05.969 --> 00:38:10.414
And for the Shopify connector, how are you managing your inventory, Dan?
00:38:11.884 --> 00:38:16.083
You would have to manage your inventory inside of QB at that point, right?
00:38:16.083 --> 00:38:19.083
It's only for if you're managing your inventory in QBO.
00:38:20.974 --> 00:38:38.884
You know, it, it, uh, it manages it works fairly well if it, if you are, if they're only doing Shopify and they're only doing Shopify payments any of those additional considerations, uh, it tended to get a lot more complicated for sure.
00:38:38.974 --> 00:38:46.653
And, uh, I did a workshop with, uh, Matt Fulton, uh, over at, uh, school of Bookkeeping and where we, we were kind of talked through, uh, some of these things.
00:38:46.653 --> 00:38:50.914
It was before, uh, apparently it went to garbage, so we may, in
00:38:50.914 --> 00:38:51.273
November,
00:38:52.054 --> 00:38:59.313
we might need to, uh, uh, revisit that, that workshop, uh, again, but, uh, check thing, check that out there.
00:38:59.313 --> 00:39:01.233
But it is there, it's available.
00:39:01.233 --> 00:39:09.333
You can, you, you can test this out in conjunction with another because you're not, there's no cost in doing that because there's no cost for the, for the app.
00:39:10.173 --> 00:39:14.193
And, you know, I will say it's also not great for high volume.
00:39:14.733 --> 00:39:23.733
It's, if you've got fee sales coming in here and there maybe, and your client's very cost conscious or whatnot try it.
00:39:25.293 --> 00:39:28.773
I don't use it, but I it's definitely, it.
00:39:28.773 --> 00:39:31.324
It'll do the job if you've got a simple scenario.
00:39:33.753 --> 00:39:42.393
and then, you know, when, when looking outside of QuickBooks there are a variety of considerations of the, of those applications, right?
00:39:42.393 --> 00:39:44.764
Like the type of posting that they will do.
00:39:44.764 --> 00:39:53.344
Maybe it's a summary transaction that is not a sales transaction, but a financial transaction of like a journal entry.
00:39:54.094 --> 00:40:08.373
There may be, uh, applications that allow you to map to, generic items so that you're not necessarily tracking the inventory, but you wanna recognize the sale and see the sale and that history inside of QuickBooks.
00:40:08.373 --> 00:40:27.184
So you can do that with generic items, or you can have the item detail come over so that, again, if QuickBooks online is your source of truth for your, inventory, you wanna have the sale that's created in Shopify Mirror, the sale that's created in inside of QuickBooks.
00:40:27.184 --> 00:40:44.434
So you, you have those potential options, additional sales channels those, considerations for, they're selling on multiple Shopify stores, for example, uh, or their marketplace versus, uh, a sales, a, an online chopping cart.
00:40:45.454 --> 00:40:53.224
And then synchronizing the item, quantities and prices across those, uh, marketplaces and, and chopping carts.
00:40:53.614 --> 00:40:54.213
And then.
00:40:55.009 --> 00:41:04.248
When they have additional inventory needs that are being handled outside of QBO, determining which one that you're, that you're doing.
00:41:04.248 --> 00:41:15.199
If it's sending over detailed item descriptions over into QuickBooks, like QuickBooks Online is the inventory management, but they're doing somewhere else that further complicates things, uh mm-hmm.
00:41:15.438 --> 00:41:15.829
As well.
00:41:15.829 --> 00:41:21.949
That's kind of like, um, the advanced options when it comes to all of that.
00:41:22.639 --> 00:41:23.838
But it can all be done.
00:41:24.199 --> 00:41:25.099
It can be done.
00:41:25.099 --> 00:41:25.369
Right.
00:41:25.489 --> 00:41:30.619
And it's actually when you get into the advanced pieces of it too, it actually becomes really fun.
00:41:30.619 --> 00:41:30.889
I know.
00:41:30.889 --> 00:41:31.759
That's really crazy.
00:41:31.759 --> 00:41:31.818
Yeah.
00:41:32.628 --> 00:41:35.059
Don't hate me for saying so, but it really is.
00:41:35.059 --> 00:41:35.568
It really is.
00:41:35.568 --> 00:41:35.778
Because you
00:41:35.778 --> 00:41:37.878
get excited about the word PayPal, so
00:41:38.478 --> 00:41:38.878
I know, I know.
00:41:38.878 --> 00:41:41.003
I love You're already, but, but I like it because.
00:41:41.943 --> 00:41:46.384
Then, you know, I oftentimes, I, I have to collaborate with people.
00:41:46.384 --> 00:41:55.864
I bring in, you know, another somebody else maybe that's an expert in this and I can really get into the meat of solving an issue and it's satisfying.
00:41:55.864 --> 00:41:56.523
I like it.
00:41:58.773 --> 00:42:01.384
So let's talk about the, uh, summary option, right?
00:42:01.384 --> 00:42:01.393
Yeah.
00:42:01.393 --> 00:42:09.724
So, uh, two of the players that, um, that we're gonna talk about they only do summary, and that's Bookkeeper and A two X.
00:42:10.173 --> 00:42:16.864
Um, there are others that enable you to do summary transactions like Ility and Cinder, and we'll talk about those.
00:42:17.224 --> 00:42:21.393
Uh, but essentially what they're doing is they're posting journal entries.
00:42:22.443 --> 00:42:29.253
And by doing that, it could impact workflows or reports in QuickBooks online, right?
00:42:29.259 --> 00:42:29.318
Yeah,
00:42:29.478 --> 00:42:29.798
absolutely.
00:42:29.798 --> 00:42:38.798
So it's, it's just something to keep in mind that these transactions that are gonna be coming over, and some of'em some are, are, are very, uh, neat and, uh.
00:42:39.724 --> 00:43:04.684
Insightful on how they, how they come over, but because they are journal entries and not sales transactions, that is going to have a significant impact on customer reports that you might be running or sales tax implications and those types of things because it's not using the prescribed workflows of those features inside of QBO.
00:43:04.684 --> 00:43:09.094
So it's just something to keep in mind when you are considering these two.
00:43:09.963 --> 00:43:12.244
So here is the side-by-side comparison.
00:43:12.244 --> 00:43:17.403
We're not gonna comb through all of these these differences or distinctions.
00:43:17.403 --> 00:43:27.063
I did put some some in bold that I wanna make sure that we, we, we talk about, we had bookkeeper do a series with, uh, with the QB power hour.
00:43:28.353 --> 00:43:38.568
A couple years ago before, before a uh, before Rachel came into my world, where we talked about those types of things.
00:43:38.628 --> 00:43:42.289
Uh, there you can review them on the QB Power Hour website.
00:43:44.179 --> 00:43:49.759
One thing that I really appreciated about, uh, bookkeeping is that it updates original transactions.
00:43:49.759 --> 00:44:10.878
So when you make transactions, uh, or post them, and then you make changes or realize, oh there's a new version or a new a new account that I wanna wanna add, you can go back to the original posting and after you make those changes and it will update, you don't have to delete the transaction and repost it.
00:44:11.628 --> 00:44:19.068
That, that's what I appreciate a lot because it, it just updates the initial, uh, initial transaction.
00:44:21.643 --> 00:44:24.889
And, and, of course you'll have an access point to, to open it, right?
00:44:24.889 --> 00:44:27.289
So if you're, if you have a link link there.
00:44:28.909 --> 00:44:35.119
talk a little bit about, uh, Rachel, how a two x uh, handles some of these some of these posting things.
00:44:36.244 --> 00:44:36.574
Yeah.
00:44:36.574 --> 00:44:46.534
So and I think like maybe speaking to what Murph said earlier is that, you know, there's this like, oh, there's all these solutions.
00:44:46.534 --> 00:44:48.213
Like, I want them all, yay.
00:44:49.264 --> 00:44:50.733
They're all good.
00:44:52.023 --> 00:44:55.384
And you know, it's not like one is better than the other.
00:44:55.443 --> 00:45:01.204
And you know, you really do kind of have to figure out, what am I trying to accomplish?
00:45:01.503 --> 00:45:04.324
Because it's not like one is garbage and one is amazing.
00:45:04.353 --> 00:45:05.253
I mean, it's not that.
00:45:05.259 --> 00:45:05.369
Mm-hmm.
00:45:05.454 --> 00:45:06.934
It's just that they're slightly different.
00:45:07.684 --> 00:45:11.103
And so in my opinion, a two x is a little more simplistic.
00:45:12.333 --> 00:45:13.594
And that's fine.
00:45:13.594 --> 00:45:15.543
Sometimes that's what people want.
00:45:15.903 --> 00:45:17.914
And so, so that's fine.
00:45:17.974 --> 00:45:21.903
Um, bookkeeping, you have the ability to get a lot more granular.
00:45:22.324 --> 00:45:25.534
Um, and then, I mean, you can just see there's more line items on this side.
00:45:25.534 --> 00:45:26.583
It can do more things.
00:45:27.934 --> 00:45:30.483
But having said that, H two X has.
00:45:31.278 --> 00:45:36.108
Profitability reports, dashboard and bookkeeping doesn't have that yet, even though they're working on it.
00:45:36.588 --> 00:45:42.559
But technically, if you're going to talk about what it does technically is they both post journal entries, right?
00:45:42.858 --> 00:45:46.009
So, um, yeah, exactly.
00:45:46.039 --> 00:45:46.278
Murf.
00:45:46.309 --> 00:46:13.579
So, okay, so H two X, basically what it's doing is it's going to Shopify and it's going, Hey, um, let me look at the payout detail, and from that payout detail, I am going to put together a journal entry and I'm gonna post it to QuickBooks Online, however, it's posting it on the sales date, but from the payout data.
00:46:13.969 --> 00:46:14.358
Okay?
00:46:14.358 --> 00:46:19.998
And we know the payout data isn't always going to be exactly what the sales data is because.
00:46:20.478 --> 00:46:27.858
Sometimes things happen by the time we get to the payout data, but that's how a two x has engineered their product, right?
00:46:27.889 --> 00:46:47.838
It's grabbing the payout detail and it's then formulating a journal entry and it's creating one journal entry that's got your sales information as a credit, to revenue, and then all of the other things, discounts, returns, sales tax, yada, yada, yada.
00:46:48.588 --> 00:46:53.478
And then your expected payout is going to be directly to cash on the debit side.
00:46:54.108 --> 00:46:57.168
Or to clearing account if you were gonna do it that way.
00:46:57.168 --> 00:47:05.748
So, um, but I think the way they do it is they just do it directly to cash, because then the cash payout comes in, boom, matches with that, call it a day.
00:47:06.438 --> 00:47:11.148
Bookkeeper on the other hand, creates a sales journal entry.
00:47:11.148 --> 00:47:13.518
They call it a sales summary entry.
00:47:13.923 --> 00:47:17.494
And it's got the sales detail, all of the things.
00:47:17.733 --> 00:47:26.103
And then the debit offset is the expected cash payout to the clearing account, by the way, not just one clearing account.
00:47:26.313 --> 00:47:44.853
If your seller on Shopify, and I had a seller on Shopify that was using, using seven, eight different payment methods, they were using simple pay bread, PayPal, Shopify payments, some other things and it, the, um, debit side would split into seven different expected payouts.
00:47:45.873 --> 00:47:48.574
And so affirm, you know, like all these things.
00:47:48.844 --> 00:47:50.583
So it's one sales journal entry.
00:47:51.213 --> 00:47:59.134
And then another journal entry for the payment, and that would be a credit to the clearings and then a debit to cash.
00:47:59.344 --> 00:48:04.114
So when you're looking at that detail, you're seeing a sales entry and a payment journal entry.
00:48:04.324 --> 00:48:07.114
And then if it's doing cogs, that's a third entry.
00:48:07.233 --> 00:48:08.403
Same with HUX.
00:48:08.434 --> 00:48:11.434
If it's posting cogs that's a, separate entry.
00:48:11.643 --> 00:48:16.983
But now I believe it or not, I actually appreciate the two separate entries.
00:48:16.983 --> 00:48:20.733
Again, my clients are complicated.
00:48:20.793 --> 00:48:28.954
I deal with heavy, heavy volume, and so I like the two separate entries for the way I do the accounting.
00:48:29.463 --> 00:48:30.364
Everybody's different.
00:48:30.364 --> 00:48:35.284
You may have your preference but that's technically how they do it.
00:48:35.523 --> 00:48:36.994
That's how they've engineered it.
00:48:37.864 --> 00:48:38.764
I like it that way.
00:48:39.393 --> 00:48:39.634
Yeah.
00:48:40.219 --> 00:48:54.949
And, um, I think the bottom line is you know, when we talked to, we were talking about this a little yesterday, that bookkeeper looks at it from the sales side of things, whereas Yeah, A two x looks at things of the, from the payout.
00:48:55.583 --> 00:48:55.873
Yeah.
00:48:55.873 --> 00:48:58.849
And so even though, and this is, this is complicated.
00:48:58.849 --> 00:49:08.148
Even though it's looking at the payout detail, it is posting it on an accrual basis, but you're gonna get a later posting'cause it's gotta wait for that payout detail.
00:49:08.329 --> 00:49:12.528
Bookkeep has a bit of an edge because they're posting it, they're actually.
00:49:13.789 --> 00:49:24.918
Scraping the backend of the sales detail and it actually ties out with the financial summary which is a specific report in Shopify.
00:49:25.458 --> 00:49:35.809
And so every single day, those two journal entries are going to tie out to the finance summary report in Shopify.
00:49:35.869 --> 00:49:37.849
H two X's entry does not do that.
00:49:38.989 --> 00:49:40.938
Book Keeps entry does do that.
00:49:41.208 --> 00:49:45.079
The only time that it doesn't, there may be some settlement issues.
00:49:45.978 --> 00:49:55.938
I have done this for such a long time now, now I can recognize when that happens and I can, if I'm doing a clearing reconciliation, maybe I'll go to that one day and I'll look in Shopify and see exactly what happened.
00:49:56.268 --> 00:50:01.188
But again, Shopify is a great place to go to look to see what happened.
00:50:01.338 --> 00:50:01.699
Right.
00:50:01.699 --> 00:50:09.139
And so that is, I think the edge that Bookkeep has is their proprietary engineering.
00:50:11.268 --> 00:50:15.228
And, I know the owner and the engineers and I talk to them frequently.
00:50:15.559 --> 00:50:17.989
They ha they have created the ability to do that.
00:50:17.989 --> 00:50:19.579
And a two x does not do that.
00:50:20.748 --> 00:50:20.929
Yeah.
00:50:21.438 --> 00:50:25.759
So the, somebody's asking, the bookkeeper anticipates the amount of the payout deposit of the bank.
00:50:25.759 --> 00:50:26.809
Does it ever get it wrong?
00:50:27.259 --> 00:50:36.559
We, you you, ultimately are going to connect both the Shopify for sales and whatever the payment processor is, right?
00:50:36.559 --> 00:50:54.739
So those assuming that those, all those connections are accessible to bookkeeping,'cause they do have, you know, significant amount of integrations available it will pull it from, that and push to the clearing account that you have, set up to be able to do those things.
00:50:56.119 --> 00:51:02.119
Of course they live in a we all live in a world where things don't always go right.
00:51:02.688 --> 00:51:03.378
Yeah.
00:51:03.384 --> 00:51:06.918
And I just wanna say also, I, we, uh.
00:51:08.088 --> 00:51:12.648
We do, Dan and I do a lot of talk about reconciling clearing accounts on the workshop.
00:51:12.648 --> 00:51:16.728
And I also do e-commerce training through school of bookkeeping.
00:51:16.728 --> 00:51:19.458
And I can train somebody specifically on reconciled clearing accounts.
00:51:19.818 --> 00:51:30.619
But I had mentioned before that in that regardless if it's a two X or bookkeep, when it's posting a journal entry, you have a debit side and a credit side.
00:51:30.619 --> 00:51:36.739
And this is where you really wanna have a firm understanding of debits and credits as a bookkeeper.
00:51:36.739 --> 00:51:39.619
Don't just be trained on QuickBooks Online.
00:51:39.619 --> 00:51:44.898
Make sure you're, if you're gonna do this kind of bookkeeping and accounting, make sure you have a firm grasp on debits and credits.
00:51:44.929 --> 00:51:47.929
'cause your revenue is always a credit.
00:51:48.139 --> 00:51:50.929
Your expected payout is gonna go to the debit.
00:51:51.168 --> 00:52:00.199
Then when the payout comes in, you debit cash, which is an increase in cash, and then you credit your clearing account, clearing it out.
00:52:00.349 --> 00:52:02.628
So you reconcile that at the end of the month.
00:52:03.619 --> 00:52:05.358
And then I, there was one other thing.
00:52:05.358 --> 00:52:06.199
It was, um.
00:52:06.918 --> 00:52:08.268
Oh, the net deposit.
00:52:08.298 --> 00:52:11.119
I wanted to answer this'cause this is the name of my business.
00:52:11.119 --> 00:52:12.918
My business is called Net Deposited.
00:52:13.188 --> 00:52:18.889
So why don't you record your net deposit to revenue, Dan?
00:52:18.949 --> 00:52:19.369
Why?
00:52:20.418 --> 00:52:26.478
Uh, because that you don't, have any insight into what actually made that up.
00:52:26.478 --> 00:52:33.438
The splits of that you're just gonna be posting it and you're likely breaking the workflows of what, right?
00:52:33.438 --> 00:52:35.509
And cash payout cash is cash.
00:52:35.719 --> 00:52:37.369
Cash isn't revenue, right?
00:52:37.548 --> 00:52:47.748
So if you were, maybe you're doing, you know, a simple cash basis, you know, accounting for an e-commerce client, you could post your cash payouts.
00:52:47.929 --> 00:52:48.798
But guess what?
00:52:49.068 --> 00:52:50.239
That's not what you wanna do.
00:52:50.239 --> 00:52:56.358
When you're doing inventory accounting, you wanna recognize your cost of goods sold at the same time as your revenue.
00:52:56.509 --> 00:52:58.429
So you must do accrual accounting.
00:52:59.298 --> 00:53:04.938
Um, and, and if you're, if in these days, if you're going to be doing the accounting.
00:53:05.418 --> 00:53:09.528
On a consumer packaged goods business, you wanna look at profitability.
00:53:09.798 --> 00:53:25.429
Uh, never in a million years would I recommend doing cash basis for, um, meaning non GA compliant accounting For an e-comm business, you wanna do accrual, you wanna recognize your cost of goods sold, um, against your revenue.
00:53:25.429 --> 00:53:26.509
Cash isn't revenue.
00:53:26.509 --> 00:53:27.679
Revenue is revenue.
00:53:29.123 --> 00:53:29.414
Okay.
00:53:29.914 --> 00:53:34.159
So we have, uh, we have five minutes to go through all of the other, uh, oh, sorry.
00:53:34.164 --> 00:53:34.333
Okay,
00:53:34.333 --> 00:53:35.059
let's, let's go fast.
00:53:36.349 --> 00:53:38.418
So we will likely run, run a little long.
00:53:38.418 --> 00:53:39.528
If you can stay great.
00:53:39.918 --> 00:53:40.818
That's, fine too.
00:53:41.148 --> 00:53:48.918
Uh, but we are obviously recording and we will share the recording if you do have to, uh, go and you can jump to that, that part there.
00:53:49.338 --> 00:53:52.728
Um, so we did have, uh, we integrate on the QB power hour.
00:53:52.728 --> 00:53:54.469
They are a really great connection.
00:53:54.469 --> 00:53:59.969
So if you wanna compare the QuickBooks connector with with something that, that.
00:54:00.889 --> 00:54:03.679
That, is outside of quick the QuickBooks ecosystem.
00:54:04.429 --> 00:54:11.509
This would be a good connection or, or comparison for the two we integrate is a Shopify only connection.
00:54:11.748 --> 00:54:11.898
Mm-hmm.
00:54:12.139 --> 00:54:19.309
Um, and it's the uniqueness of we integrate is that the payouts actually post through EP positive funds
00:54:19.429 --> 00:54:19.668
Yeah.
00:54:19.728 --> 00:54:22.099
Instead of the clearing accounts.
00:54:22.099 --> 00:54:22.369
Right.
00:54:22.369 --> 00:54:41.509
So and you know, it, it does add up, it does add some additional conveniences as well as potential concerns because if you have all of their payments going into undeposited funds, your, all of your sales from Shopify that could be an unruly mess.
00:54:41.838 --> 00:54:42.139
Yeah.
00:54:42.139 --> 00:54:48.438
And like, remember what I said about 20 minutes ago, I like to split those payment methods up into their own clearing accounts.
00:54:48.438 --> 00:54:55.728
So in this situation, if you're using, we integrate and you're just using Shopify payments, which by the way, Shopify payments I love.
00:54:55.728 --> 00:54:56.659
'cause if you're on.
00:54:57.199 --> 00:55:03.798
TikTok channel you know, all these various integrations through Shopify, they all pay out through Shopify payments.
00:55:03.858 --> 00:55:03.949
Yeah.
00:55:04.009 --> 00:55:11.268
So you can use something like this and it will be great for your sales tax if you wanna manage that in QBO.
00:55:11.268 --> 00:55:11.929
Also,
00:55:13.278 --> 00:55:23.449
now, when you are dealing with multiple sales channels and you're looking for a cost effective route pay tracker is a really good
00:55:23.989 --> 00:55:24.228
yeah.
00:55:24.259 --> 00:55:24.768
Option.
00:55:25.068 --> 00:55:25.893
Uh, they are from nine
00:55:26.293 --> 00:55:27.054
a month, by the way.
00:55:27.063 --> 00:55:27.653
Super cheap.
00:55:27.684 --> 00:55:27.974
Yeah.
00:55:28.793 --> 00:55:30.498
Uh, from the makers of Sasan.
00:55:30.498 --> 00:55:37.219
So if you use, uh, Sasan you know, importer, exporter, delete, um, you know, they, they work in the same.
00:55:37.998 --> 00:55:40.759
Realm, you know, it's the same on, uh same, company.
00:55:41.119 --> 00:55:49.009
Uh, they do have a section for automation, so that you're able to basically create some automating rules of how these things actually post.
00:55:49.728 --> 00:55:55.009
And of course, uh, Rachel and I did a workshop slash demo, uh, on our workshop.
00:55:55.668 --> 00:56:09.559
So there's a link there for, uh, more of that now when we're getting into the details and we really need, uh, additional details or you need, customizations between the two.
00:56:09.918 --> 00:56:16.789
Uh, sender and Ility, I think are the two major players that are out there, uh, that do that.
00:56:16.789 --> 00:56:20.358
And there is the the comparison of that.
00:56:20.389 --> 00:56:30.648
The big thing that Ility does over, uh, sender is it does allow for quantity and price thinking across multiple sales channels.
00:56:30.648 --> 00:56:41.088
If you have, you know, your Shopify and your Amazon and you wanna make sure that both of them are synchronized and QuickBooks online is your source of truth, right?
00:56:41.094 --> 00:56:41.193
Mm-hmm.
00:56:41.273 --> 00:56:43.909
So a lot of those things need to align, right?
00:56:43.909 --> 00:56:46.938
And Web Agility does have a desktop integration.
00:56:47.268 --> 00:56:51.349
Um, they do integrate with QuickBooks Desktop, uh, as well.
00:56:51.349 --> 00:56:53.898
So for those people that are still on.
00:56:54.244 --> 00:57:01.264
QuickBooks Desktop and managing their inventory inside of QuickBooks Desktop, that does give them a viable option as well.
00:57:02.134 --> 00:57:03.009
And with Shopify.
00:57:03.009 --> 00:57:03.208
Yeah.
00:57:03.208 --> 00:57:04.653
And I don't know Web Ility very well.
00:57:04.653 --> 00:57:06.753
You're a web ility expert?
00:57:06.784 --> 00:57:09.364
Um, I, I, unfortunately I don't know much about it.
00:57:09.364 --> 00:57:10.384
I haven't really used it.
00:57:10.804 --> 00:57:11.074
Yeah.
00:57:11.523 --> 00:57:16.983
And with Shopify, it will actually do, um, product listings on Shopify web agility.
00:57:16.983 --> 00:57:25.684
We'll do shop Shopify listings, so you, you can create a new item inside of your desktop and then post that listing on Shopify through their desktop products.
00:57:25.684 --> 00:57:25.713
Oh,
00:57:25.713 --> 00:57:26.074
cool.
00:57:26.494 --> 00:57:28.114
So it's, uh, uh, kind of neat.
00:57:28.114 --> 00:57:30.784
Now, you, you are more familiar with, uh, with sender.
00:57:30.784 --> 00:57:36.753
What does, what does Cinder do, well that you've seen?
00:57:39.213 --> 00:57:48.753
I've even heard, seen a couple people talk about this in the chat, but for anybody that's frustrated about a connector not posting refunds or returns.
00:57:49.264 --> 00:57:52.983
Get sender because I never have issues with that.
00:57:54.273 --> 00:57:58.264
I, and I, first of all, I prefer Cinder's user interface.
00:57:58.324 --> 00:58:00.693
Um, I like their dashboard.
00:58:00.724 --> 00:58:06.963
Um, I like their ability to, uh, it's called rollback if you need to un post something.
00:58:07.414 --> 00:58:21.813
And, um, for when I need to bring in individual sales receipts, a lot of times, even if I'm not managing inventory in QBO, I actually have a couple clients in which we're managing the inventory in an IMS.
00:58:21.813 --> 00:58:24.454
We're in Katana, we're in something else.
00:58:24.454 --> 00:58:31.474
But, um, we still use the individual sales postings through Cinder just because it's so fantastic.
00:58:31.474 --> 00:58:34.324
And I'm not gonna use the one in QBO.
00:58:34.324 --> 00:58:36.034
It's too slow, it's too clunky.
00:58:36.034 --> 00:58:39.903
And sometimes I have issues with the returns.
00:58:39.934 --> 00:58:48.244
So Cinder is, in my opinion, by far, the best connector when it comes to individual sales transactions.
00:58:48.244 --> 00:58:48.253
Mm-hmm.
00:58:49.579 --> 00:58:49.849
Yeah.
00:58:49.849 --> 00:58:59.148
And one of the things that we talked about in our comparison, uh, when we did the workshop is the connection that you need to have in order to confirm the sale.
00:58:59.659 --> 00:59:05.748
Uh, one thing that sender it, it provides you a link or an access to that sale.
00:59:05.748 --> 00:59:08.043
So you're able to see the sale that was downloaded.
00:59:08.043 --> 00:59:14.568
But if you actually wanna see the who the customer was and everything, that's the, sales detail.
00:59:14.958 --> 00:59:21.289
Uh, you have to have access to the client's Shopify or their sales channel, whatever that happens to be.
00:59:22.309 --> 00:59:31.039
So it does give you it takes you to the door, but doesn't necessarily have all the details inside of the app itself unless they've changed it that I know of.
00:59:31.458 --> 00:59:40.429
Uh, but in web ility, you can see the sales detail in the, application without having access to those other things.
00:59:40.833 --> 00:59:41.193
Yeah,
00:59:41.434 --> 00:59:42.094
that's really cool
00:59:42.094 --> 00:59:42.813
because that's it.
00:59:42.813 --> 00:59:48.304
A lot of times you do have to go to the portal to go pull up the sales information.
00:59:48.574 --> 00:59:48.664
Yeah.
00:59:48.664 --> 00:59:52.233
And so you know, cinder works really well with WooCommerce too.
00:59:52.233 --> 00:59:56.784
Just FYI, if you know anybody is, has a client on WooCommerce site or do channels
00:59:56.784 --> 00:59:56.958
as well.
00:59:57.278 --> 00:59:57.559
I like it.
00:59:57.784 --> 00:59:58.173
Yeah.
00:59:58.713 --> 00:59:58.864
Yeah.
00:59:58.893 --> 01:00:17.403
So if that's not part of your engagement, where you're not, you don't have collaborator access of their Shopify then, and, and they need detail, then Ility might get the nod because you, don't need those, uh, that access because you can see the sales detail, uh, directly within, ility.
01:00:17.403 --> 01:00:22.623
So here's, uh, as promised the summary of all of the options.
01:00:24.199 --> 01:00:40.759
Rachel and her team there have, have really kind of broken down comparing the the pricing, the different syncing options, most ideal situation, uh, key strengths and limitations of, of all of the things that we've, talked about here today.
01:00:41.449 --> 01:00:48.498
Um, and then when you have one last thing, this is a little bit more advanced, so if you, gotta go, you gotta go.
01:00:48.498 --> 01:00:48.949
That's great.
01:00:50.329 --> 01:00:59.239
So when you're, when inventory is not the source of truth inside of QuickBooks online and there are inventory management solutions that might be.
01:01:00.949 --> 01:01:08.298
Using here, we're not talking about Excel, uh, but they're actually using an inventory management solution app.
01:01:09.228 --> 01:01:20.028
Those apps will typically have a sales or sales connect bridge to Shopify or whatever place that they're, that they're that they're doing.
01:01:20.509 --> 01:01:28.039
What, when you have a client that's using these kinds of applications, what, um, what surprises have you seen?
01:01:28.039 --> 01:01:30.048
Or do they work just splendidly?
01:01:31.039 --> 01:01:34.954
Well, you really need to have, for really any of these.
01:01:34.954 --> 01:01:44.434
I would go through their software training and really make sure that you understand how the software works, but then I would make sure that you have a working knowledge of the inventory workflow.
01:01:45.724 --> 01:01:49.443
You, really wanna make sure you understand the inventory workflow, even if you're doing it in QBO.
01:01:49.744 --> 01:01:54.483
But, um, Katana, I would say is great for manufacturing.
01:01:55.114 --> 01:01:59.014
Meaning I'm assembling items together to create a finished good.
01:02:00.483 --> 01:02:02.614
It's, not the greatest for heavy e-commerce.
01:02:02.614 --> 01:02:05.344
I'll say maybe one Shopify store.
01:02:05.344 --> 01:02:06.094
It's fine.
01:02:07.474 --> 01:02:09.393
And, but since seven core I am.
01:02:10.054 --> 01:02:12.693
Very involved with that app.
01:02:13.804 --> 01:02:15.393
I work with the team there.
01:02:15.393 --> 01:02:18.514
I am Albe at since seven summit this August.
01:02:19.414 --> 01:02:26.523
That is the one that I have most of my training and specialty in multi-channel, um, purchasing.
01:02:26.884 --> 01:02:34.204
Speaking of purchasing subtle is actually a great somebody was talking about, can I do the purchasing in Shopify?
01:02:34.204 --> 01:02:35.043
No, you can't.
01:02:35.043 --> 01:02:40.353
So you really wanna make sure that, again, you're following that purchasing inventory workflow.
01:02:40.503 --> 01:02:46.893
You can do it in settle and then settle will even keep a list of your inventory items.
01:02:47.313 --> 01:02:51.393
And with, I don't know, like FIFO costing or weighted average costing or something like that.
01:02:51.634 --> 01:02:56.373
You're not gonna get any of that inventory valuation in Shopify.
01:02:56.373 --> 01:03:01.293
It's really just a place to list, these are my items and here's how many I have.
01:03:02.134 --> 01:03:08.614
You know, you use an app like this and you're really going to utilize a proper inventory costing method.
01:03:09.784 --> 01:03:11.373
Oh yeah, we did leave out fishbowl.
01:03:11.373 --> 01:03:11.704
Sorry.
01:03:11.704 --> 01:03:13.804
Yeah, I actually have some clients on Fishbowl too.
01:03:14.074 --> 01:03:21.244
The only reason we didn't bring up fishbowl is because it's really a desktop product and, uh, we're not gonna like really get into that.
01:03:21.244 --> 01:03:24.393
They do have a web based product too, but,
01:03:25.233 --> 01:03:25.353
Yep.
01:03:25.653 --> 01:03:28.023
Which they'll be coming on the Power Hour in June
01:03:28.324 --> 01:03:29.193
Yeah.
01:03:29.193 --> 01:03:31.864
To talk about so and so we definitely have a relationship with them.
01:03:31.864 --> 01:03:32.134
Yeah.
01:03:32.134 --> 01:03:32.704
They're a thing.
01:03:33.094 --> 01:03:38.403
For me personally, I'm a very heavy, since seven core user, it's totally cloud-based.
01:03:39.454 --> 01:03:43.653
And there's no hosting, um, you know, in the web, like nothing like that.
01:03:43.653 --> 01:03:46.804
No additional cost for that.
01:03:46.804 --> 01:03:52.563
And I think that's a really excellent a advantage that it has.
01:03:52.623 --> 01:03:52.893
Right.
01:03:52.893 --> 01:04:00.903
And and that's, and this slide here is really talking, speaking to what those inventory management solutions are designed to do.
01:04:00.903 --> 01:04:03.483
They're designed to manage the inventory, right.
01:04:03.483 --> 01:04:07.563
So they're, they're designed to, to have things come in and, and so that you can.
01:04:08.539 --> 01:04:12.949
See that source of truth of your inventory, right?
01:04:12.949 --> 01:04:16.938
And, you know, sales made online are gonna be part of that, right?
01:04:17.224 --> 01:04:17.514
Yeah.
01:04:17.518 --> 01:04:24.259
And so what they're not really concerned about is did you get paid for those sales that you made?
01:04:24.528 --> 01:04:30.438
And so a lot of them are a little bit light on the payout option, right?
01:04:30.438 --> 01:04:41.634
So they may have their own integration into, into QuickBooks, but you'll likely not find that they are concerned about the Shopify payments payout with the
01:04:41.733 --> 01:04:41.954
No.
01:04:41.954 --> 01:04:45.018
And the thing with that is will it sync a payment?
01:04:45.018 --> 01:04:45.949
Yeah, of course.
01:04:45.949 --> 01:04:55.759
You can sync your individual sales over from your IMS, like for from Kaan or CIN seven Core, and it'll also sync a record of payment, right?
01:04:55.759 --> 01:04:56.219
You've got a.
01:04:56.838 --> 01:04:59.958
Record payment that's coming over also to undeposited funds.
01:05:00.259 --> 01:05:10.489
But again, you're gonna get a batched payout, and so I usually will, um, still use bookkeeper and I know that there are a lot of people that do.
01:05:10.489 --> 01:05:13.728
Another one that we didn't talk about was finale inventory.
01:05:13.998 --> 01:05:16.728
They have a special integration with H two X.
01:05:17.193 --> 01:05:36.664
For this exact purpose, manage your movements in finale inventory, but then a two x is gonna grab the sales data, post it to your, um, your in, uh, accounting software and the expected payout data, post it to your accounting software so that way you've got match match, match, and then
01:05:36.664 --> 01:05:36.873
Right.
01:05:36.934 --> 01:05:44.329
You're syncing over your, well, we, I'm not gonna get into that complexity, but we can talk about that in right now.
01:05:44.329 --> 01:05:44.489
Right,
01:05:45.153 --> 01:05:45.454
right.
01:05:45.454 --> 01:06:03.213
But I mean, all of this is in service to, you know, making your life a little easier when it comes to the bank feed of matching transactions as opposed to posting transactions or setting up a an automation or a rule inside the bank feed to go to those various clear
01:06:03.213 --> 01:06:03.393
accounts.
01:06:03.393 --> 01:06:03.483
Right?
01:06:03.483 --> 01:06:04.474
Yeah, for sure.
01:06:04.474 --> 01:06:06.929
And the slippery slope of all of this is.
01:06:08.074 --> 01:06:17.014
I know it feels and sounds complicated and it just requires a little bit more understanding.
01:06:17.014 --> 01:06:18.724
And that's why we're here.
01:06:18.724 --> 01:06:24.393
We specialize in this, like I train in this area, I offer coaching.
01:06:24.664 --> 01:06:26.494
Um, my firm is net deposited.
01:06:26.494 --> 01:06:29.103
We handle nothing but these clients.
01:06:30.304 --> 01:06:33.844
And well, not nothing, but we handle a large amount of these clients.
01:06:33.844 --> 01:06:39.393
And so we really specialize in this area and I'll create a custom setup, you know, bypass this and do that.
01:06:39.603 --> 01:06:43.713
So if you're feeling frustrated, there is help.
01:06:43.833 --> 01:06:46.023
And so there, that's the thing.
01:06:46.023 --> 01:06:46.833
It's a slippery slope.
01:06:46.833 --> 01:06:49.443
It feels like, well this is all gonna be a mess.
01:06:49.773 --> 01:06:52.833
Trust me, it's a lot of information.
01:06:52.923 --> 01:07:00.844
It will set you up for absolute complete.
01:07:01.219 --> 01:07:01.909
Automation.
01:07:01.969 --> 01:07:04.309
It'll be, it's, it's wonderful is what I'm trying to say.
01:07:04.309 --> 01:07:05.539
It's really, really great.
01:07:05.688 --> 01:07:05.809
Right.
01:07:05.809 --> 01:07:06.733
When it's set up, and
01:07:06.733 --> 01:07:16.338
it's, and this is, this is an industry that will allow you to when, if you're concerned about the you know, bookkeepers going away because of ai, right?
01:07:16.699 --> 01:07:18.378
This is, going to get you ahead, get
01:07:18.378 --> 01:07:20.599
involved in this, and you'll always have a job.
01:07:20.869 --> 01:07:32.268
All of this constantly needs to be troubleshooted, by the way, even when it's set up on auto post, even when it's mapped perfectly, even when it's doing all the things you want it to do, it'll still break.
01:07:32.268 --> 01:07:32.329
Yeah.
01:07:32.568 --> 01:07:38.418
They'll still add a new, your cl your client will add a new item the wrong way into this system.
01:07:38.869 --> 01:07:40.938
It's constantly needs to be troubleshooted.
01:07:40.998 --> 01:07:43.818
So there is job security in this for sure.
01:07:44.028 --> 01:07:44.088
Yeah.
01:07:44.119 --> 01:07:51.858
But when it is set up and it's working properly and you've got high volume clients, it's the only way to do this.
01:07:52.579 --> 01:07:52.818
Yeah.
01:07:53.914 --> 01:07:58.474
Last couple topics here is, um, and somebody was asking, well, how do you get in touch with Rachel?
01:07:58.474 --> 01:07:59.614
And that'll be on the next slide.
01:08:00.543 --> 01:08:02.164
so Shopify expenses, right?
01:08:02.164 --> 01:08:08.523
So this is one of those things that a lot of applications have kind of left out, right?
01:08:08.528 --> 01:08:14.224
Uh, so the monthly charges that Shopify charges, uh, shipping for one.
01:08:14.224 --> 01:08:28.144
So all the things, if you're using the Shopify shipping manager, you know, to create your own shipping labels and those types of things, they charge that at once a month or, you know, periodically throughout the month, depending on their volume.
01:08:28.533 --> 01:08:30.423
But those shipping charges come separately.
01:08:30.724 --> 01:08:37.293
They, are not part of this clearing account situation of sales versus, uh, expected payouts.
01:08:37.293 --> 01:08:39.993
Like they don't take the shipping charges out of the payouts.
01:08:40.293 --> 01:08:42.543
They charge them separately, right?
01:08:42.543 --> 01:08:48.064
Because they might build up a threshold and say, oh, we need to charge them now for, all their shipping charges.
01:08:49.219 --> 01:08:54.048
Shopify has a wonderful ecosystem of plugins, right?
01:08:54.048 --> 01:09:00.889
And those apps will charge Shopify, and then that'll show up on your billing, uh, statement as well.
01:09:01.189 --> 01:09:04.429
And Shopify doesn't do this outta the kindness of the heart.
01:09:04.429 --> 01:09:07.488
So they, have their own, so subscription costs, right?
01:09:07.488 --> 01:09:07.548
Yeah.
01:09:07.548 --> 01:09:08.118
But the.
01:09:08.913 --> 01:09:12.274
You might want to have those things separated out, right?
01:09:12.274 --> 01:09:20.913
Your shipping charges, your Shopify plugins and your Shopify subscription fees, but nobody really manages that all too well.
01:09:20.913 --> 01:09:51.634
So we did a workshop with a demo of, um, of how to be able to take that CSV file with that bill that you get either by getting it from your client or getting it directly if you have access to the Shopify portal, uh, and being able to download that CSV and use, uh, SAS ant importer, uh, which Murph was saying that now the pay tracker and the importer are now kind of conver combined, uh, into one application.
01:09:53.118 --> 01:10:03.078
But using, uh, Sasan tool to be able to automate bringing those in so that it automatically, uh, splits those out for you based off of how you how you wanna see that.
01:10:03.078 --> 01:10:11.538
So we, we did that there, um, o over at School of Bookkeeping, and if you need more help, if you wanna talk to you know, consult with Rachel.
01:10:12.259 --> 01:10:24.378
We've created an e-commerce fundamentals course at School of Bookkeeping, where we talk about these, this terminology, the inventory considerations and, and the going into the sales connector review as well.
01:10:25.158 --> 01:10:28.099
Over at School of Bookkeeping, it's, it's live, it's available.
01:10:28.279 --> 01:10:39.469
You can access it for 30 days and, uh, you know, if you need one-on-one time with Rachel, you can you can set up, set that up through through the course there as well.
01:10:39.469 --> 01:10:41.059
I did put in the chat as well.
01:10:41.884 --> 01:10:46.594
Uh, that we uh, Rachel the email address.
01:10:46.594 --> 01:10:52.533
So if you want to copy that, uh, or Rachel, if you wanna put it in the chat just, as well.
01:10:52.533 --> 01:10:56.583
If, uh, people want shoot you a quick email, uh, you can do that as well.
01:10:56.944 --> 01:10:57.064
Yep.
01:10:57.069 --> 01:10:59.404
It's just rachel@netdeposited.com.
01:10:59.404 --> 01:10:59.554
Right.
01:11:00.333 --> 01:11:06.724
But it's, uh, creatively, you, you drop the A or I don't know which is more prevalent.
01:11:06.724 --> 01:11:06.844
It's,
01:11:07.359 --> 01:11:07.658
it's plain.
01:11:07.658 --> 01:11:10.234
E-L-R-A-C-H-E-L.
01:11:12.094 --> 01:11:14.463
So I'm gonna throw up the last poll question here.
01:11:14.884 --> 01:11:20.913
Uh, as we as we come in for a landing, was it useful if you wanted to get, uh, in touch with Rachel?
01:11:20.913 --> 01:11:26.073
We can, uh provide that information to, uh, Rachel and then she can, uh, reach out directly.
01:11:27.154 --> 01:11:31.083
But Rachel, any, uh, closing thoughts as we, uh, come in for a landing here?
01:11:32.929 --> 01:11:42.649
No, other than I'm just gonna keep studying all these apps and, and as they add more things, just keep learning.
01:11:42.649 --> 01:11:45.378
And, um, I personally love this niche.
01:11:45.408 --> 01:11:46.969
I think it's great.
01:11:47.029 --> 01:11:55.578
And, um, I think something like, I don't know, there's$65 billion worth of e-commerce, like in just last year alone.
01:11:58.038 --> 01:11:59.418
It's not going anywhere.
01:12:00.139 --> 01:12:11.868
More and more people are selling online and, you know, now that there are more AI tools to help facilitate this it's just gonna be even more prolific.
01:12:11.868 --> 01:12:13.639
But, um, yeah.
01:12:15.439 --> 01:12:15.679
Yeah.
01:12:16.158 --> 01:12:18.798
And then you said the word worldwide and I see this.
01:12:19.279 --> 01:12:19.668
Are you Sure?
01:12:20.724 --> 01:12:21.043
I don't know.
01:12:21.048 --> 01:12:23.448
I think that was just the United States.
01:12:23.453 --> 01:12:23.604
Yeah.
01:12:23.743 --> 01:12:25.069
So, yeah, that's, um.
01:12:25.713 --> 01:12:29.163
But also, you know, that adds up additional considerations, right?
01:12:29.163 --> 01:12:39.514
If they're shipping worldwide or, you know, multicurrency all other issues, uh, as well, uh, if they are in a worldwide shipping
01:12:40.689 --> 01:12:40.769
situation.
01:12:40.769 --> 01:12:50.104
Yeah, well that's another reason you wanna use Shopify, because Shopify markets is, allows you, in the US to sell worldwide and receive your currency in the US dollar.
01:12:50.104 --> 01:12:58.054
So it's really, um the, advantages of using something like Shopify, I just can't like, preach it enough.
01:12:58.054 --> 01:12:59.253
It's really incredible.
01:13:00.498 --> 01:13:03.139
So, uh, next time on the, uh, power Hour.
01:13:03.139 --> 01:13:05.599
If you haven't registered for it already, please do.
01:13:06.019 --> 01:13:16.458
Um, individual one, we're going to be having, um, a representative from, uh, Relay the financial institution talking about passing the baton.
01:13:16.788 --> 01:13:19.998
We had her come on a couple of our workshops.
01:13:20.838 --> 01:13:34.219
So we are gonna be talking about how Relay, uh, streamlines the, banking connection and, adds to some of the functionality, uh, inside of QuickBooks online, uh, from a banking perspective.
01:13:34.939 --> 01:13:45.229
And how accounting professionals, uh, can partner with Relay to have it be part of their own tech stack that they recommend to, uh, to their clients.
01:13:45.229 --> 01:13:50.389
So, uh, join us, uh, for that in a couple weeks and we'll see you next time on the QB Power Hour.
01:13:50.509 --> 01:13:51.378
Have a great day, everyone.