Latest / QB Power Hour Podcast / Shopify Showdown: Comparing Shopify connectors in QuickBooks [04.14.26]
Transcript
- 0:23Dan DeLong: Welcome to another QB Power Hour.
- 0:25Dan DeLong: Uh, today is our first in this new series of app Showdowns.
- 0:31Dan DeLong: 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.
- 0:48Dan DeLong: Uh, this today.
- 0:50Dan DeLong: Uh, my name is Dan DeLong, owner at Danwidth and School of Bookkeeping.
- 0:53Dan DeLong: 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.
- 1:05Dan DeLong: And admin of the Facebook group, uh, that we, uh, that.
- 1:10Dan DeLong: Ties to this to this webinar series.
- 1:13Dan DeLong: And joining us today is my co-host over at, uh, workshop Wednesday, Rachel DCI's, filling in for Sharrin today.
- 1:22Dan DeLong: Uh, for those that, um, haven't, uh, experienced the wonderment of Rachel tell us a little bit about yourself.
- 1:30Rachel Dauchy: Wonderment.
- 1:31Rachel Dauchy: Wow.
- 1:34Rachel Dauchy: Well, thanks Dan.
- 1:35Rachel Dauchy: I'm really happy to be here and, um, there's a lot of neat information on that slide there.
- 1:40Rachel Dauchy: 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.
- 2:02Rachel Dauchy: So I've got a lot of insight.
- 2:05Rachel Dauchy: And
- 2:05Dan DeLong: you just got back from, uh, shop Talk, uh from, uh, which is a conference in Las Vegas.
- 2:11Dan DeLong: What is, uh, what is that all about?
- 2:14Rachel Dauchy: Oh, that was so cool.
- 2:15Rachel Dauchy: That was by far my favorite conference that I have ever been to.
- 2:18Rachel Dauchy: 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.
- 2:34Rachel Dauchy: They were all there, Stripe, PayPal.
- 2:37Rachel Dauchy: 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.
- 2:47Rachel Dauchy: Keep my, um keep, myself abreast of all of this information.
- 2:54Dan DeLong: Alright.
- 2:54Dan DeLong: 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.
- 3:07Rachel Dauchy: Yeah.
- 3:08Dan DeLong: And, we'll be talking about some of the things that you and I have done since then.
- 3:13Dan DeLong: Mm-hmm.
- 3:14Dan DeLong: Um partnering together about this particular industry.
- 3:18Dan DeLong: But today we're, we're gonna be focusing on the, uh, the Shopify connections.
- 3:23Dan DeLong: 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.
- 3:33Dan DeLong: Me over at School Bookkeeping and Sharrin over at clone and Conquer.
- 3:38Dan DeLong: And little bit about the updates to the QB Power Hour.
- 3:43Dan DeLong: We have.
- 3:44Dan DeLong: 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.
- 3:57Dan DeLong: 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.
- 4:09Dan DeLong: 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.
- 4:24Dan DeLong: 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.
- 4:35Dan DeLong: So, uh, you might see some, some mismatches there and apologize for that, but.
- 4:41Dan DeLong: It's all gonna be, it's all gonna be Okay.
- 4:45Rachel Dauchy: Good.
- 4:46Rachel Dauchy: Reassured.
- 4:47Dan DeLong: Yes.
- 4:48Dan DeLong: 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?
- 5:00Dan DeLong: 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.
- 5:13Dan DeLong: 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.
- 5:33Dan DeLong: What, uh, what, what is your thought process about, you know.
- 5:38Dan DeLong: Choosing one or, or do you, do you, subscribe to, well this, all of these could work
- 5:45Rachel Dauchy: well, like you just said, they all are very different and it's just not a one size fits all type of thing.
- 5:54Rachel Dauchy: Mm-hmm.
- 5:54Rachel Dauchy: 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.
- 6:11Rachel Dauchy: Uh, diving into that for quite a while, I realized, well, wait a minute.
- 6:15Rachel Dauchy: You have to back up a step and you have to realize, what am I trying to accomplish?
- 6:19Rachel Dauchy: 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.
- 6:44Rachel Dauchy: It really depends on what you're trying to accomplish.
- 6:46Rachel Dauchy: So you really want to ask yourself that question first.
- 6:50Rachel Dauchy: I, is it, do you have a client that's asking you for something specific?
- 6:55Rachel Dauchy: Are you trying to look at something specific?
- 6:58Rachel Dauchy: Maybe you're doing some kind of advisory.
- 7:01Rachel Dauchy: So there really is.
- 7:03Rachel Dauchy: A litany of different things that you can do with these different apps.
- 7:09Rachel Dauchy: Some work better than others, some work differently than others.
- 7:14Rachel Dauchy: Right?
- 7:14Rachel Dauchy: 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,
- 7:44Dan DeLong: right?
- 7:45Dan DeLong: Yeah.
- 7:45Dan DeLong: So that's, uh, this is our agenda for today.
- 7:47Dan DeLong: We'll be talking a little bit about some Intuit news where, um.
- 7:53Dan DeLong: We wanna make sure that people are aware about, uh, the canny option for feedback.
- 7:58Dan DeLong: That's not that's not an adjective, that's a noun.
- 8:03Dan DeLong: Canny is the avenue, uh for, feedback, and we'll talk a little bit about that.
- 8:09Dan DeLong: 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.
- 8:24Dan DeLong: Uh, what is available inside of QuickBooks online.
- 8:27Dan DeLong: And then we'll talk about what is available outside of QuickBooks Online.
- 8:32Dan DeLong: Uh, breaking down the, summary integrations or the detail integrations or when you need something that's more than just Shopify.
- 8:40Dan DeLong: So that's, that's hopefully everything that we'll we'll get into today.
- 8:44Dan DeLong: It is a lot to cram into an hour.
- 8:47Dan DeLong: Uh, we do have additional resources because, uh, Rachel and I have spent.
- 8:52Dan DeLong: The last couple years talking about these, these features or this function.
- 8:58Dan DeLong: Um, and we do have you know, some courses and content available over at school bookkeeping, uh, to review at another another time.
- 9:08Dan DeLong: All right, so let's start off with the first poll question with how many clients do you have who use, uh, Shopify?
- 9:16Dan DeLong: 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?
- 9:35Dan DeLong: What's so great about Shopify?
- 9:37Rachel Dauchy: Because it's the best,
- 9:40Dan DeLong: but why?
- 9:41Rachel Dauchy: Well, I'm biased.
- 9:43Rachel Dauchy: I'm a Shopify partner and reseller and can collaborator and.
- 9:48Rachel Dauchy: Let me just say this.
- 9:49Rachel Dauchy: 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.
- 9:59Rachel Dauchy: Wow.
- 10:00Rachel Dauchy: You could really understand how significant Shopify is in this space there.
- 10:07Rachel Dauchy: Shopping cart power is so incredible that I, you can, you can have a multimillion dollar e-commerce brand on the Shopify platform.
- 10:19Rachel Dauchy: 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.
- 10:37Rachel Dauchy: I mean, it's limitless.
- 10:38Rachel Dauchy: It's really what you can do.
- 10:40Rachel Dauchy: They can do it what you can imagine.
- 10:42Rachel Dauchy: They can do it.
- 10:43Rachel Dauchy: It's just very powerful.
- 10:44Rachel Dauchy: Uh, I like the reporting.
- 10:46Rachel Dauchy: I like the ability, the, you know, the, the working with the products.
- 10:54Rachel Dauchy: 'cause I, I also deal with inventory management and we don't manage the inventory in Shopify.
- 11:01Rachel Dauchy: We can have a whole other discussion about that.
- 11:03Rachel Dauchy: We're not gonna get into that now.
- 11:04Rachel Dauchy: But I do go into the product setup.
- 11:08Rachel Dauchy: I do look at variance.
- 11:10Rachel Dauchy: I do look at cost goods sold.
- 11:11Rachel Dauchy: I do look at things like that.
- 11:13Rachel Dauchy: And just in terms of sometimes when I need to dig around Shopify, I can usually find what I need.
- 11:21Rachel Dauchy: Some of the other platforms not so much.
- 11:25Dan DeLong: Mm-hmm.
- 11:26Dan DeLong: Yeah.
- 11:27Dan DeLong: And, and, um it, it's kind of like Shopify is the QuickBooks of e-commerce, right.
- 11:33Dan DeLong: It's a, it's a really good entry point.
- 11:36Dan DeLong: It, it does a lot of things for a lot of people.
- 11:39Dan DeLong: And then there's this whole app ecosystem or plugins.
- 11:43Dan DeLong: For when you need to need it to do more than it does right out of the box.
- 11:48Rachel Dauchy: Yeah.
- 11:49Rachel Dauchy: And I just wanna speak to Nicole really quick.
- 11:51Rachel Dauchy: Um mm-hmm.
- 11:51Rachel Dauchy: There's some nuance when you're dealing with wholesale.
- 11:54Rachel Dauchy: 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.
- 12:06Rachel Dauchy: When you're managing that in one Shopify admin, I would do a second Shopify store just for wholesale.
- 12:12Rachel Dauchy: 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.
- 12:25Dan DeLong: Yeah.
- 12:25Dan DeLong: Looking at the, poll results looks like, uh, 71%, uh, are only a few clients, uh, using, using Shopify.
- 12:33Dan DeLong: So there are a, a handful or smattering of, uh of, of, us with.
- 12:41Dan DeLong: Shopify, uh, Shopify clients.
- 12:43Dan DeLong: So let's, uh, let's talk a little bit about the Intuit news and updates and talk about canny feedback for accountants.
- 12:51Dan DeLong: And I meant to put the link in the slides and it looks like it's not there.
- 12:55Dan DeLong: But there is a new-ish feedback channel that is available and, and focused on the accountant community, right?
- 13:06Dan DeLong: 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.
- 13:19Dan DeLong: 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.
- 13:26Dan DeLong: So Intuit has, has rolled out this is the second coming of this thing.
- 13:31Dan DeLong: Um, this, uh, something similar, uh, they had, oh, probably in like 2013.
- 13:39Dan DeLong: But.
- 13:40Dan DeLong: 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.
- 13:53Dan DeLong: But right now they, they're focusing this, uh, this feedback on three major areas.
- 13:59Dan DeLong: The bank feeds modern reports and payroll, uh, which are three big concerns for the, accounting community.
- 14:09Dan DeLong: 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.
- 14:32Dan DeLong: This allows you to, to look at the previous, uh, submissions and just.
- 14:38Dan DeLong: Upvote it and, and say Me too type of thing with those things.
- 14:43Dan DeLong: 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.
- 15:05Dan DeLong: 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.
- 15:19Dan DeLong: If you have feedback, this is a great way to, to put that in to see if it's already there.
- 15:25Dan DeLong: And then you get digests sent to, to your email when there is updates to those things.
- 15:32Dan DeLong: So it's a, it's a pretty interesting, experiment that they're doing with the accounting community.
- 15:39Dan DeLong: I believe the website is intuit.canny.io.
- 15:45Dan DeLong: I'll have to look that up.
- 15:47Dan DeLong: And, uh, let's just see if that actually works before I put it in the chat.
- 15:57Dan DeLong: And it is.
- 15:57Dan DeLong: Okay.
- 15:57Dan DeLong: 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.
- 16:06Dan DeLong: Or checking it out if you have and forgot about it.
- 16:12Dan DeLong: So that's, uh, that's something to, just keep in mind about feedback.
- 16:17Dan DeLong: I think this is part of the challenge of, Intuit is that they have a lot of data and a lot of feedback.
- 16:25Dan DeLong: And, you know, if, if you have different places to put in feedback, it, it ends up being.
- 16:33Dan DeLong: Spread out and maybe not consolidated.
- 16:36Dan DeLong: I'm, my hope is that this becomes the feedback channel.
- 16:40Dan DeLong: Uh, but of course, like anything else that Intuit puts out, it's not gonna get any notice if it's never used.
- 16:48Dan DeLong: Check it out and, uh, and we will see how this evolves over, time.
- 16:55Dan DeLong: Alright uh, so as mentioned, uh, Rachel and I did a workshop series, uh, which was very low key.
- 17:03Dan DeLong: And, and you know the, idea of, of the workshop series is it's casual conversations for serious workflows.
- 17:11Dan DeLong: Uh, so we don't really go into a lot of demos or deep dives.
- 17:16Dan DeLong: It's really just a conversation that we have about those things.
- 17:21Dan DeLong: You know, we certainly can, you know, share, you know, screens and those types of things on the, on the workshops.
- 17:27Dan DeLong: But our main goal is to have conversations about these concepts and topics.
- 17:33Dan DeLong: 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.
- 17:45Dan DeLong: And then of course, sales tax is gonna always creep up into that picture.
- 17:51Dan DeLong: Um, and then dealing with, uh, Shopify fees and expenses.
- 17:55Dan DeLong: So, uh, we created a playlist.
- 17:57Dan DeLong: So you can just, uh, click on the link there in the, in the, the handouts.
- 18:02Dan DeLong: I'll watch the playlist at, your, at your leisure.
- 18:06Dan DeLong: Or you can, uh, you know, go into the school of bookkeeping and we have those in there as well.
- 18:12Dan DeLong: So one of the bigger concepts about e-commerce is this concept of, of clearing accounts.
- 18:20Dan DeLong: 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.
- 18:38Rachel Dauchy: Yeah.
- 18:38Rachel Dauchy: So even though I work in inventory and e-commerce, I'm an accountant.
- 18:45Rachel Dauchy: I'm an accountant first.
- 18:47Rachel Dauchy: I'm also working on my master's in accounting, believe it or not, right now.
- 18:50Rachel Dauchy: 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.
- 19:08Rachel Dauchy: To think about it.
- 19:09Rachel Dauchy: The best way is it is eventually going to clear out.
- 19:15Rachel Dauchy: That's why it's called a clearing account.
- 19:17Rachel Dauchy: 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.
- 19:29Rachel Dauchy: So for example, in oh yeah, so, so you've got undeposited funds and accounts receivable.
- 19:38Rachel Dauchy: So those are classic examples of a clearing account, right?
- 19:41Rachel Dauchy: So you're posting some revenue in accounts receivable, and then when the payment comes in, it's going to clear that out.
- 19:50Rachel Dauchy: So it's a pretty simple concept, but in e-commerce, one of the reasons that we use a clearing account is because.
- 19:58Rachel Dauchy: The payments don't always come in.
- 20:02Rachel Dauchy: Well, I'm not gonna say don't always, never come in individually.
- 20:07Rachel Dauchy: They come in in a batch.
- 20:09Rachel Dauchy: So it, there are times in which we post the revenue to QuickBooks in either a individual sale or a summary for the day.
- 20:22Rachel Dauchy: But either way, that's still getting posted to revenue.
- 20:25Rachel Dauchy: And so, and as we know in accounting, revenue is a credit.
- 20:29Rachel Dauchy: 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.
- 20:47Rachel Dauchy: Sorry about that.
- 20:48Rachel Dauchy: That was my backpack.
- 20:48Rachel Dauchy: So that's really how it works in a nutshell, using debits and credits.
- 20:51Rachel Dauchy: And I'm sorry too, you used debits and credits, but.
- 20:55Rachel Dauchy: It's really the best way to explain it and understand it.
- 20:58Rachel Dauchy: And I can talk about debits and credits forever.
- 21:00Rachel Dauchy: So if anybody wants to chat about that.
- 21:02Rachel Dauchy: 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.
- 21:15Rachel Dauchy: And so I'm more than you know, available and welcome to chat with anybody one-on-one.
- 21:22Rachel Dauchy: 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.
- 21:33Rachel Dauchy: So it can get really complicated really quickly.
- 21:36Rachel Dauchy: So that's, I just wanted to add that on there of.
- 21:39Rachel Dauchy: You know why sometimes we kinda have to stay away from the ultra complex when it comes to that, but mm-hmm.
- 21:46Rachel Dauchy: There usually always is a very ultra complex answer that we can tailor to everybody's situation.
- 21:53Rachel Dauchy: But when you are doing e-commerce, accounting and bookkeeping, you gotta use a clearing account.
- 22:00Rachel Dauchy: If you're thinking that you're not going to, you're not gonna do it.
- 22:05Rachel Dauchy: Right.
- 22:05Rachel Dauchy: That's I'll die on that hill.
- 22:07Rachel Dauchy: You must use a clearing account.
- 22:10Dan DeLong: Yeah.
- 22:10Dan DeLong: 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?
- 22:19Rachel Dauchy: It depends on if you want to deposit to the clearing account there.
- 22:23Rachel Dauchy: It really depends.
- 22:24Rachel Dauchy: There are some situations where if, depending on the connector that I'm using, I will map and set up and create a.
- 22:34Rachel Dauchy: Sales posting.
- 22:35Rachel Dauchy: And then I'll also automate and create a payout posting.
- 22:38Rachel Dauchy: And so there I'm getting match, match, match, match, And the bank feeds don't need to deposit anything.
- 22:44Rachel Dauchy: 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.
- 22:52Rachel Dauchy: I mean the, the payout portion I will then deposit, said payout into the clearing account.
- 22:58Rachel Dauchy: And in that situation, you wanna set it up as a checking account.
- 23:03Rachel Dauchy: And Dan can get into the nuance of QBO.
- 23:07Rachel Dauchy: You can't deposit into another current asset account.
- 23:10Rachel Dauchy: And so it really depends.
- 23:13Rachel Dauchy: Yeah.
- 23:13Rachel Dauchy: I hate answering that way, darn it.
- 23:15Dan DeLong: That is the common answer.
- 23:18Dan DeLong: That would, it has to do with depends, right?
- 23:21Dan DeLong: 'cause there, because there is no silver bullet, you know, one size fits all right.
- 23:26Dan DeLong: But, um.
- 23:27Rachel Dauchy: Yeah.
- 23:28Rachel Dauchy: And as a, as a advisor, you know, everybody's advisory, my advisory is in this space.
- 23:33Rachel Dauchy: It's an inventory management e-commerce accounting and sales tax and, and that kind of thing.
- 23:41Rachel Dauchy: It, does require a lot of questions.
- 23:43Rachel Dauchy: It does require a lot of digging and nuance and finding out a lot of this stuff before you dive in.
- 23:49Rachel Dauchy: So that's why we're having this session.
- 23:51Dan DeLong: Right.
- 23:52Dan DeLong: 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.
- 24:09Dan DeLong: My Shopify sales into, QuickBooks.
- 24:12Dan DeLong: Right?
- 24:12Dan DeLong: So there is going to be, there's a variety of ways.
- 24:15Dan DeLong: And of course the answer of how do you do that?
- 24:18Dan DeLong: What's the best way to do that is of course it depends.
- 24:21Dan DeLong: Mm-hmm.
- 24:23Dan DeLong: It will depend on some considerations that we're gonna be talking about and the application, their budget those types of things.
- 24:30Dan DeLong: 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.
- 24:47Dan DeLong: And so there are a lot of ways, uh, or considerations when determining which way is available.
- 24:54Dan DeLong: 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.
- 25:08Rachel Dauchy: And there's also hand keying in the orders.
- 25:11Rachel Dauchy: And
- 25:12Dan DeLong: yeah,
- 25:12Rachel Dauchy: 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?
- 25:25Rachel Dauchy: And so they're, they'll hand key them in.
- 25:27Rachel Dauchy: So that is a thing too.
- 25:30Rachel Dauchy: You know, in our world of apps, we don't need to do that anymore,
- 25:36Dan DeLong: right?
- 25:37Dan DeLong: And, um, so let's, let's kind of go into this, uh, this Shopify Showdown selecting the right tool.
- 25:43Dan DeLong: And here's where the challenge comes in, right?
- 25:46Dan DeLong: 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.
- 25:54Dan DeLong: I did it right before the, uh, the session today.
- 25:57Dan DeLong: I got 41 results for the word Shopify.
- 26:01Dan DeLong: And you can see two of them are essentially the same thing.
- 26:05Dan DeLong: Shopify connector by QuickBooks or Shopify for QuickBooks Online.
- 26:09Dan DeLong: Are they are, they, one of the one in the same thing or not?
- 26:13Dan DeLong: I don't know.
- 26:13Dan DeLong: Because they've got the same icon.
- 26:17Rachel Dauchy: Yeah.
- 26:17Dan DeLong: 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?
- 26:27Dan DeLong: That's, aren't they the same thing?
- 26:30Dan DeLong: Well, they may or they may not be.
- 26:32Dan DeLong: Right.
- 26:32Dan DeLong: But the core features of these Shopify sales connectors are they're going to post or bring in, in, in their way.
- 26:41Dan DeLong: Not necessarily the way that you want, but the way that that application is designed to work.
- 26:46Dan DeLong: Sales and return information.
- 26:48Dan DeLong: 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.
- 27:12Dan DeLong: Uh, so for the payment processor.
- 27:16Dan DeLong: So would you say, Rachel, that that in a nutshell is what these what these sales, Shopify sales connectors are designed to do?
- 27:25Rachel Dauchy: Yeah.
- 27:25Rachel Dauchy: They do it for you, which is great.
- 27:27Rachel Dauchy: Yeah.
- 27:27Rachel Dauchy: I mean, we're at the point now where we're, not just data entry clerks, right?
- 27:33Rachel Dauchy: Mm-hmm.
- 27:34Rachel Dauchy: We are relying on automation tools to bring in this data.
- 27:40Rachel Dauchy: We verify the data, right?
- 27:42Rachel Dauchy: So now we can.
- 27:44Rachel Dauchy: Beyond, we can go beyond data entry.
- 27:47Rachel Dauchy: We can truly do more analysis for our clients and build our firms in a completely different way like I have.
- 27:56Dan DeLong: And that's why you have these things funneling through the clearing accounts, right?
- 28:03Dan DeLong: Uhhuh?
- 28:03Dan DeLong: 'cause the payouts are gonna be a grouping of individual sales transactions.
- 28:09Dan DeLong: 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.
- 28:18Dan DeLong: And eventually there will be a payout of that hitting the bank account minus fees and.
- 28:26Dan DeLong: Depending on how they paid for it.
- 28:27Dan DeLong: Right?
- 28:28Dan DeLong: 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.
- 28:38Dan DeLong: 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.
- 28:50Rachel Dauchy: Yep.
- 28:50Rachel Dauchy: Right?
- 28:50Dan DeLong: And that's, yep.
- 28:51Dan DeLong: And
- 28:51Rachel Dauchy: I use a clearing account for every single payment method, for every single marketplace, for every single platform.
- 28:59Rachel Dauchy: I, that's the way I do it.
- 29:01Rachel Dauchy: 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.
- 29:09Rachel Dauchy: A lot of different payment methods.
- 29:10Rachel Dauchy: It just gets too convoluted for me.
- 29:12Rachel Dauchy: And I have clients that are omnichannel.
- 29:15Rachel Dauchy: I mean, we've got payment methods and things coming in from all over the place.
- 29:19Rachel Dauchy: So as an accountant, it's really the better way, um, at least for my brain to do it,
- 29:26Dan DeLong: right?
- 29:27Dan DeLong: So there are a lot of things to consider, right?
- 29:30Dan DeLong: As far as determining what might be the best route to go.
- 29:35Dan DeLong: And so here's just a smattering of, some of those considerations, right?
- 29:40Dan DeLong: So,
- 29:40Rachel Dauchy: yeah,
- 29:41Dan DeLong: big thing I think the first thing to determine with your client is where is that inventory source of truth gonna be?
- 29:50Rachel Dauchy: Because that is the number one consideration.
- 29:52Rachel Dauchy: Absolutely most important consideration is inventory source of truth,
- 29:57Dan DeLong: right?
- 29:58Dan DeLong: Because if you are managing your inventory inside of QuickBooks, then everything has to be in service to that.
- 30:04Dan DeLong: So that is going to.
- 30:07Dan DeLong: Rule out or allow various other options.
- 30:12Dan DeLong: 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.
- 30:28Dan DeLong: Which one's the best for this or that, or, you know, what, what its ideal fit is for.
- 30:32Dan DeLong: So don't worry, there will be a, a summary at the end, right?
- 30:39Dan DeLong: But the
- 30:39Rachel Dauchy: inventory source is true.
- 30:40Rachel Dauchy: Yeah.
- 30:40Rachel Dauchy: And I just wanna just say really quick too, there, you can manage your inventory in QBO.
- 30:45Rachel Dauchy: I mean, I know that's a big point of contention for a lot of different people out there.
- 30:52Rachel Dauchy: In on workshop Wednesday, we have talked about this many a time.
- 30:57Rachel Dauchy: There are, and so I'm not even gonna get into it.
- 31:00Rachel Dauchy: I'm just gonna say yes you can, if it's simple enough.
- 31:04Rachel Dauchy: If there's not a lot of skews, if you're just on one platform, yeah.
- 31:08Rachel Dauchy: 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.
- 31:24Rachel Dauchy: I have clients that manage their inventory in QBO.
- 31:28Rachel Dauchy: Right.
- 31:28Rachel Dauchy: And for that reason are, you gonna, are you gonna say what type of connection we want?
- 31:35Rachel Dauchy: If they're doing that,
- 31:37Dan DeLong: yeah.
- 31:37Dan DeLong: Then you'd want some detail, you know?
- 31:40Dan DeLong: Yeah.
- 31:40Dan DeLong: The sales detail.
- 31:41Rachel Dauchy: Yeah.
- 31:41Rachel Dauchy: So in that situation, you want individual sales transactions and so you need that,'cause you need the item information.
- 31:49Rachel Dauchy: Right.
- 31:49Rachel Dauchy: You need to know on the sales receipt.
- 31:51Rachel Dauchy: And by the way, I usually will always use a sales receipt when those are coming into QBO.
- 31:59Rachel Dauchy: I don't ever use an invoice.
- 32:01Dan DeLong: Try not to use an invoice.
- 32:03Dan DeLong: Yeah.
- 32:03Rachel Dauchy: Yeah.
- 32:04Rachel Dauchy: Because I don't need it to hit AR because it's a point of sale transaction.
- 32:08Rachel Dauchy: You right.
- 32:08Rachel Dauchy: It's not a.
- 32:09Rachel Dauchy: I'm giving you an invoice and then you pay me 30 days later.
- 32:12Rachel Dauchy: No, it's a point of sale transaction.
- 32:15Rachel Dauchy: I'm recording the point of sale and I'm recording the offset, the clearing account of where I'm expecting that payout.
- 32:22Rachel Dauchy: So easy peasy.
- 32:24Dan DeLong: Yeah.
- 32:25Dan DeLong: So like this feeds into the next topic of, you know, Shopify Omnis sellers or, multiple channels, right?
- 32:32Dan DeLong: Because once they start selling on, on Shopify that's kind of like the gateway drug of e-commerce, right?
- 32:39Dan DeLong: 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.
- 32:52Dan DeLong: 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.
- 33:05Rachel Dauchy: 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.
- 33:12Dan DeLong: Right?
- 33:12Dan DeLong: But then you have an omni seller who's selling in more than one place, Shopify and Amazon, for example.
- 33:20Rachel Dauchy: Mm-hmm.
- 33:20Dan DeLong: Right?
- 33:21Dan DeLong: And now there's a consideration of, how do I tell those different two.
- 33:27Dan DeLong: Platforms how much I have available to sell.
- 33:31Dan DeLong: Because Amazon is pretty, uh, annoying when
- 33:36Rachel Dauchy: Yeah,
- 33:36Dan DeLong: you don't have, when you sell something and you can, and you can't chip it, right?
- 33:41Dan DeLong: They They.
- 33:42Dan DeLong: wag their finger seriously at the Amazon sellers when they're not, you know, when they put stuff on back order, right?
- 33:50Dan DeLong: So that, that becomes a consideration when we're talking about o Omni sellers also selling with, with Shopify.
- 33:58Dan DeLong: 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,
- 34:15Rachel Dauchy: if that's the case, well, you can't do that now.
- 34:16Rachel Dauchy: I just spoke to Amazon at Shop Talk.
- 34:19Rachel Dauchy: Mm-hmm.
- 34:19Rachel Dauchy: And they actually now have a functionality within Amazon to connect your Shopify and manage that inventory.
- 34:28Rachel Dauchy: Again, this stuff is, that technology is changing so fast.
- 34:32Audio Only - All Participants: So,
- 34:32Rachel Dauchy: so fast.
- 34:33Rachel Dauchy: That was as of they, the guy told me as of like a month before that they finally got that completed.
- 34:41Rachel Dauchy: So I'm gonna be learning a lot more about that as well.
- 34:44Rachel Dauchy: And so it's really wild how fast this stuff changes.
- 34:50Dan DeLong: And then so another consideration is, is how they're collecting funds, right?
- 34:54Dan DeLong: Is it all through just Shopify payments, which is the preferred method?
- 34:58Dan DeLong: Are they using some other payment processor to, to actually do the processing?
- 35:04Dan DeLong: If their PayPal, their potential buy now, pay later maybe they'll throw in a loan.
- 35:10Dan DeLong: Uh,
- 35:10Rachel Dauchy: yeah.
- 35:11Dan DeLong: Well, yeah.
- 35:11Dan DeLong: And in Shopify,
- 35:12Rachel Dauchy: by the way, you, they've got native integration with hundreds and hundreds of other third party gateway.
- 35:19Rachel Dauchy: 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.
- 35:28Rachel Dauchy: We manage that elsewhere.
- 35:29Rachel Dauchy: Okay.
- 35:29Rachel Dauchy: We push levels to the storefront.
- 35:32Rachel Dauchy: So Shopify is best at native integrations, reporting if you need a Shopify loan.
- 35:40Rachel Dauchy: 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.
- 35:54Dan DeLong: Yes.
- 35:54Dan DeLong: And, uh, there are, there are plenty of other considerations like sales tax, right?
- 36:01Dan DeLong: Which is a huge consideration where they're collecting and, submitting sales tax, right?
- 36:07Dan DeLong: 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.
- 36:19Dan DeLong: Uh,
- 36:20Rachel Dauchy: so yeah, and sales tax, by the way, is another area where Shopify excels in comparison to WooCommerce, which I deal a lot with.
- 36:28Rachel Dauchy: WooCommerce is the worst when it comes to sales tax.
- 36:31Rachel Dauchy: Shopify highly outperforms WooCommerce.
- 36:37Dan DeLong: So I, I'm throwing up the, uh, second poll question.
- 36:41Dan DeLong: Have you ever, have you tried the internal Shopify connector?
- 36:44Dan DeLong: Uh, looks like it's pretty evenly of, uh, yes.
- 36:47Dan DeLong: Still using it, and yes, I turned it off.
- 36:51Dan DeLong: 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.
- 37:03Dan DeLong: Uh, so let me go ahead and end the poll and share the results there and we'll, we'll talk about that.
- 37:10Dan DeLong: Uh, Shopify Sales connector.
- 37:11Dan DeLong: What is available, uh, inside of QBO?
- 37:15Dan DeLong: You can't beat the price, uh, because it is free.
- 37:18Dan DeLong: Uh, depending on your your version of QuickBooks, uh, you get, I think one sales connector with with Simple Start three with sh.
- 37:33Dan DeLong: Essentials.
- 37:34Dan DeLong: I couldn't, I couldn't think of it there for a second.
- 37:36Dan DeLong: And then, uh, it's unlimited at plus in advance.
- 37:40Dan DeLong: 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.
- 37:50Dan DeLong: Um,
- 37:50Rachel Dauchy: yeah, and I love how Ben has said it's turned to garbage as of November, 2025.
- 37:55Rachel Dauchy: I love that he has like a specific date
- 38:00Dan DeLong: when that occurred.
- 38:01Rachel Dauchy: I think it's before then, but that's okay.
- 38:04Dan DeLong: It does
- 38:05Rachel Dauchy: enter.
- 38:05Rachel Dauchy: And for the Shopify connector, how are you managing your inventory, Dan?
- 38:11Dan DeLong: You would have to manage your inventory inside of QB at that point, right?
- 38:16Rachel Dauchy: It's only for if you're managing your inventory in QBO.
- 38:20Dan DeLong: 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.
- 38:38Dan DeLong: 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.
- 38:46Dan DeLong: It was before, uh, apparently it went to garbage, so we may, in
- 38:50Rachel Dauchy: November,
- 38:52Dan DeLong: we might need to, uh, uh, revisit that, that workshop, uh, again, but, uh, check thing, check that out there.
- 38:59Dan DeLong: But it is there, it's available.
- 39:01Dan DeLong: 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.
- 39:10Rachel Dauchy: And, you know, I will say it's also not great for high volume.
- 39:14Rachel Dauchy: 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.
- 39:25Rachel Dauchy: I don't use it, but I it's definitely, it.
- 39:28Rachel Dauchy: It'll do the job if you've got a simple scenario.
- 39:33Dan DeLong: and then, you know, when, when looking outside of QuickBooks there are a variety of considerations of the, of those applications, right?
- 39:42Dan DeLong: Like the type of posting that they will do.
- 39:44Dan DeLong: Maybe it's a summary transaction that is not a sales transaction, but a financial transaction of like a journal entry.
- 39:54Dan DeLong: 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.
- 40:08Dan DeLong: 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.
- 40:27Dan DeLong: 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.
- 40:45Dan DeLong: And then synchronizing the item, quantities and prices across those, uh, marketplaces and, and chopping carts.
- 40:53Dan DeLong: And then.
- 40:55Dan DeLong: When they have additional inventory needs that are being handled outside of QBO, determining which one that you're, that you're doing.
- 41:04Dan DeLong: 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.
- 41:15Dan DeLong: As well.
- 41:15Dan DeLong: That's kind of like, um, the advanced options when it comes to all of that.
- 41:22Rachel Dauchy: But it can all be done.
- 41:24Dan DeLong: It can be done.
- 41:25Dan DeLong: Right.
- 41:25Rachel Dauchy: And it's actually when you get into the advanced pieces of it too, it actually becomes really fun.
- 41:30Rachel Dauchy: I know.
- 41:30Rachel Dauchy: That's really crazy.
- 41:31Rachel Dauchy: Yeah.
- 41:32Rachel Dauchy: Don't hate me for saying so, but it really is.
- 41:35Rachel Dauchy: It really is.
- 41:35Rachel Dauchy: Because you
- 41:35Dan DeLong: get excited about the word PayPal, so
- 41:38Rachel Dauchy: I know, I know.
- 41:38Rachel Dauchy: I love You're already, but, but I like it because.
- 41:41Rachel Dauchy: Then, you know, I oftentimes, I, I have to collaborate with people.
- 41:46Rachel Dauchy: 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.
- 41:55Rachel Dauchy: I like it.
- 41:58Dan DeLong: So let's talk about the, uh, summary option, right?
- 42:01Dan DeLong: Yeah.
- 42:01Dan DeLong: 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.
- 42:10Dan DeLong: Um, there are others that enable you to do summary transactions like Ility and Cinder, and we'll talk about those.
- 42:17Dan DeLong: Uh, but essentially what they're doing is they're posting journal entries.
- 42:22Dan DeLong: And by doing that, it could impact workflows or reports in QuickBooks online, right?
- 42:29Rachel Dauchy: Yeah,
- 42:29Dan DeLong: absolutely.
- 42:29Dan DeLong: 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.
- 42:39Dan DeLong: 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.
- 43:04Dan DeLong: So it's just something to keep in mind when you are considering these two.
- 43:09Dan DeLong: So here is the side-by-side comparison.
- 43:12Dan DeLong: We're not gonna comb through all of these these differences or distinctions.
- 43:17Dan DeLong: 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.
- 43:28Dan DeLong: A couple years ago before, before a uh, before Rachel came into my world, where we talked about those types of things.
- 43:38Dan DeLong: Uh, there you can review them on the QB Power Hour website.
- 43:44Dan DeLong: One thing that I really appreciated about, uh, bookkeeping is that it updates original transactions.
- 43:49Dan DeLong: 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.
- 44:11Dan DeLong: That, that's what I appreciate a lot because it, it just updates the initial, uh, initial transaction.
- 44:21Dan DeLong: And, and, of course you'll have an access point to, to open it, right?
- 44:24Dan DeLong: So if you're, if you have a link link there.
- 44:28Dan DeLong: talk a little bit about, uh, Rachel, how a two x uh, handles some of these some of these posting things.
- 44:36Rachel Dauchy: Yeah.
- 44:36Rachel Dauchy: 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.
- 44:46Rachel Dauchy: Like, I want them all, yay.
- 44:49Rachel Dauchy: They're all good.
- 44:52Rachel Dauchy: And you know, it's not like one is better than the other.
- 44:55Rachel Dauchy: And you know, you really do kind of have to figure out, what am I trying to accomplish?
- 45:01Rachel Dauchy: Because it's not like one is garbage and one is amazing.
- 45:04Rachel Dauchy: I mean, it's not that.
- 45:05Rachel Dauchy: Mm-hmm.
- 45:05Rachel Dauchy: It's just that they're slightly different.
- 45:07Rachel Dauchy: And so in my opinion, a two x is a little more simplistic.
- 45:12Rachel Dauchy: And that's fine.
- 45:13Rachel Dauchy: Sometimes that's what people want.
- 45:15Rachel Dauchy: And so, so that's fine.
- 45:17Rachel Dauchy: Um, bookkeeping, you have the ability to get a lot more granular.
- 45:22Rachel Dauchy: Um, and then, I mean, you can just see there's more line items on this side.
- 45:25Rachel Dauchy: It can do more things.
- 45:27Rachel Dauchy: But having said that, H two X has.
- 45:31Rachel Dauchy: Profitability reports, dashboard and bookkeeping doesn't have that yet, even though they're working on it.
- 45:36Rachel Dauchy: But technically, if you're going to talk about what it does technically is they both post journal entries, right?
- 45:42Rachel Dauchy: So, um, yeah, exactly.
- 45:46Rachel Dauchy: Murf.
- 45:46Rachel Dauchy: 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.
- 46:13Rachel Dauchy: Okay?
- 46:14Rachel Dauchy: And we know the payout data isn't always going to be exactly what the sales data is because.
- 46:20Rachel Dauchy: Sometimes things happen by the time we get to the payout data, but that's how a two x has engineered their product, right?
- 46:27Rachel Dauchy: 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.
- 46:48Rachel Dauchy: And then your expected payout is going to be directly to cash on the debit side.
- 46:54Rachel Dauchy: Or to clearing account if you were gonna do it that way.
- 46:57Rachel Dauchy: 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.
- 47:06Rachel Dauchy: Bookkeeper on the other hand, creates a sales journal entry.
- 47:11Rachel Dauchy: They call it a sales summary entry.
- 47:13Rachel Dauchy: And it's got the sales detail, all of the things.
- 47:17Rachel Dauchy: And then the debit offset is the expected cash payout to the clearing account, by the way, not just one clearing account.
- 47:26Rachel Dauchy: 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.
- 47:45Rachel Dauchy: And so affirm, you know, like all these things.
- 47:48Rachel Dauchy: So it's one sales journal entry.
- 47:51Rachel Dauchy: And then another journal entry for the payment, and that would be a credit to the clearings and then a debit to cash.
- 47:59Rachel Dauchy: So when you're looking at that detail, you're seeing a sales entry and a payment journal entry.
- 48:04Rachel Dauchy: And then if it's doing cogs, that's a third entry.
- 48:07Rachel Dauchy: Same with HUX.
- 48:08Rachel Dauchy: If it's posting cogs that's a, separate entry.
- 48:11Rachel Dauchy: But now I believe it or not, I actually appreciate the two separate entries.
- 48:16Rachel Dauchy: Again, my clients are complicated.
- 48:20Rachel Dauchy: I deal with heavy, heavy volume, and so I like the two separate entries for the way I do the accounting.
- 48:29Rachel Dauchy: Everybody's different.
- 48:30Rachel Dauchy: You may have your preference but that's technically how they do it.
- 48:35Rachel Dauchy: That's how they've engineered it.
- 48:37Rachel Dauchy: I like it that way.
- 48:39Dan DeLong: Yeah.
- 48:40Dan DeLong: 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.
- 48:55Rachel Dauchy: Yeah.
- 48:55Rachel Dauchy: And so even though, and this is, this is complicated.
- 48:58Rachel Dauchy: 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.
- 49:08Rachel Dauchy: Bookkeep has a bit of an edge because they're posting it, they're actually.
- 49:13Rachel Dauchy: Scraping the backend of the sales detail and it actually ties out with the financial summary which is a specific report in Shopify.
- 49:25Rachel Dauchy: And so every single day, those two journal entries are going to tie out to the finance summary report in Shopify.
- 49:35Rachel Dauchy: H two X's entry does not do that.
- 49:38Rachel Dauchy: Book Keeps entry does do that.
- 49:41Rachel Dauchy: The only time that it doesn't, there may be some settlement issues.
- 49:45Rachel Dauchy: 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.
- 49:56Rachel Dauchy: But again, Shopify is a great place to go to look to see what happened.
- 50:01Rachel Dauchy: Right.
- 50:01Rachel Dauchy: And so that is, I think the edge that Bookkeep has is their proprietary engineering.
- 50:11Rachel Dauchy: And, I know the owner and the engineers and I talk to them frequently.
- 50:15Rachel Dauchy: They ha they have created the ability to do that.
- 50:17Rachel Dauchy: And a two x does not do that.
- 50:20Dan DeLong: Yeah.
- 50:21Dan DeLong: So the, somebody's asking, the bookkeeper anticipates the amount of the payout deposit of the bank.
- 50:25Dan DeLong: Does it ever get it wrong?
- 50:27Dan DeLong: We, you you, ultimately are going to connect both the Shopify for sales and whatever the payment processor is, right?
- 50:36Dan DeLong: 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.
- 50:56Dan DeLong: Of course they live in a we all live in a world where things don't always go right.
- 51:02Rachel Dauchy: Yeah.
- 51:03Rachel Dauchy: And I just wanna say also, I, we, uh.
- 51:08Rachel Dauchy: We do, Dan and I do a lot of talk about reconciling clearing accounts on the workshop.
- 51:12Rachel Dauchy: And I also do e-commerce training through school of bookkeeping.
- 51:16Rachel Dauchy: And I can train somebody specifically on reconciled clearing accounts.
- 51:19Rachel Dauchy: 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.
- 51:30Rachel Dauchy: And this is where you really wanna have a firm understanding of debits and credits as a bookkeeper.
- 51:36Rachel Dauchy: Don't just be trained on QuickBooks Online.
- 51:39Rachel Dauchy: 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.
- 51:44Rachel Dauchy: 'cause your revenue is always a credit.
- 51:48Rachel Dauchy: Your expected payout is gonna go to the debit.
- 51:51Rachel Dauchy: 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.
- 52:00Rachel Dauchy: So you reconcile that at the end of the month.
- 52:03Rachel Dauchy: And then I, there was one other thing.
- 52:05Rachel Dauchy: It was, um.
- 52:06Rachel Dauchy: Oh, the net deposit.
- 52:08Rachel Dauchy: I wanted to answer this'cause this is the name of my business.
- 52:11Rachel Dauchy: My business is called Net Deposited.
- 52:13Rachel Dauchy: So why don't you record your net deposit to revenue, Dan?
- 52:18Rachel Dauchy: Why?
- 52:20Dan DeLong: Uh, because that you don't, have any insight into what actually made that up.
- 52:26Dan DeLong: The splits of that you're just gonna be posting it and you're likely breaking the workflows of what, right?
- 52:33Rachel Dauchy: And cash payout cash is cash.
- 52:35Rachel Dauchy: Cash isn't revenue, right?
- 52:37Rachel Dauchy: 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.
- 52:47Rachel Dauchy: But guess what?
- 52:49Rachel Dauchy: That's not what you wanna do.
- 52:50Rachel Dauchy: When you're doing inventory accounting, you wanna recognize your cost of goods sold at the same time as your revenue.
- 52:56Rachel Dauchy: So you must do accrual accounting.
- 52:59Rachel Dauchy: Um, and, and if you're, if in these days, if you're going to be doing the accounting.
- 53:05Rachel Dauchy: On a consumer packaged goods business, you wanna look at profitability.
- 53:09Rachel Dauchy: 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.
- 53:25Rachel Dauchy: Cash isn't revenue.
- 53:26Rachel Dauchy: Revenue is revenue.
- 53:29Dan DeLong: Okay.
- 53:29Dan DeLong: So we have, uh, we have five minutes to go through all of the other, uh, oh, sorry.
- 53:34Dan DeLong: Okay,
- 53:34Rachel Dauchy: let's, let's go fast.
- 53:36Dan DeLong: So we will likely run, run a little long.
- 53:38Dan DeLong: If you can stay great.
- 53:39Dan DeLong: That's, fine too.
- 53:41Dan DeLong: 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.
- 53:49Dan DeLong: Um, so we did have, uh, we integrate on the QB power hour.
- 53:52Dan DeLong: They are a really great connection.
- 53:54Dan DeLong: So if you wanna compare the QuickBooks connector with with something that, that.
- 54:00Dan DeLong: That, is outside of quick the QuickBooks ecosystem.
- 54:04Dan DeLong: This would be a good connection or, or comparison for the two we integrate is a Shopify only connection.
- 54:11Rachel Dauchy: Mm-hmm.
- 54:12Dan DeLong: Um, and it's the uniqueness of we integrate is that the payouts actually post through EP positive funds
- 54:19Rachel Dauchy: Yeah.
- 54:19Dan DeLong: Instead of the clearing accounts.
- 54:22Dan DeLong: Right.
- 54:22Dan DeLong: 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.
- 54:41Rachel Dauchy: Yeah.
- 54:42Rachel Dauchy: And like, remember what I said about 20 minutes ago, I like to split those payment methods up into their own clearing accounts.
- 54:48Rachel Dauchy: 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.
- 54:55Rachel Dauchy: 'cause if you're on.
- 54:57Rachel Dauchy: TikTok channel you know, all these various integrations through Shopify, they all pay out through Shopify payments.
- 55:03Rachel Dauchy: Yeah.
- 55:04Rachel Dauchy: So you can use something like this and it will be great for your sales tax if you wanna manage that in QBO.
- 55:11Rachel Dauchy: Also,
- 55:13Dan DeLong: now, when you are dealing with multiple sales channels and you're looking for a cost effective route pay tracker is a really good
- 55:23Rachel Dauchy: yeah.
- 55:24Dan DeLong: Option.
- 55:25Dan DeLong: Uh, they are from nine
- 55:26Rachel Dauchy: a month, by the way.
- 55:27Rachel Dauchy: Super cheap.
- 55:27Dan DeLong: Yeah.
- 55:28Dan DeLong: Uh, from the makers of Sasan.
- 55:30Dan DeLong: So if you use, uh, Sasan you know, importer, exporter, delete, um, you know, they, they work in the same.
- 55:37Dan DeLong: Realm, you know, it's the same on, uh same, company.
- 55:41Dan DeLong: 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.
- 55:49Dan DeLong: And of course, uh, Rachel and I did a workshop slash demo, uh, on our workshop.
- 55:55Dan DeLong: 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.
- 56:09Dan DeLong: Uh, sender and Ility, I think are the two major players that are out there, uh, that do that.
- 56:16Dan DeLong: And there is the the comparison of that.
- 56:20Dan DeLong: The big thing that Ility does over, uh, sender is it does allow for quantity and price thinking across multiple sales channels.
- 56:30Dan DeLong: 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?
- 56:41Dan DeLong: Mm-hmm.
- 56:41Dan DeLong: So a lot of those things need to align, right?
- 56:43Dan DeLong: And Web Agility does have a desktop integration.
- 56:47Dan DeLong: Um, they do integrate with QuickBooks Desktop, uh, as well.
- 56:51Dan DeLong: So for those people that are still on.
- 56:54Dan DeLong: QuickBooks Desktop and managing their inventory inside of QuickBooks Desktop, that does give them a viable option as well.
- 57:02Dan DeLong: And with Shopify.
- 57:03Rachel Dauchy: Yeah.
- 57:03Rachel Dauchy: And I don't know Web Ility very well.
- 57:04Rachel Dauchy: You're a web ility expert?
- 57:06Rachel Dauchy: Um, I, I, unfortunately I don't know much about it.
- 57:09Rachel Dauchy: I haven't really used it.
- 57:10Dan DeLong: Yeah.
- 57:11Dan DeLong: And with Shopify, it will actually do, um, product listings on Shopify web agility.
- 57:16Dan DeLong: 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.
- 57:25Dan DeLong: Oh,
- 57:25Rachel Dauchy: cool.
- 57:26Dan DeLong: So it's, uh, uh, kind of neat.
- 57:28Dan DeLong: Now, you, you are more familiar with, uh, with sender.
- 57:30Dan DeLong: What does, what does Cinder do, well that you've seen?
- 57:39Rachel Dauchy: 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.
- 57:49Rachel Dauchy: Get sender because I never have issues with that.
- 57:54Rachel Dauchy: I, and I, first of all, I prefer Cinder's user interface.
- 57:58Rachel Dauchy: Um, I like their dashboard.
- 58:00Rachel Dauchy: Um, I like their ability to, uh, it's called rollback if you need to un post something.
- 58:07Rachel Dauchy: 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.
- 58:21Rachel Dauchy: We're in Katana, we're in something else.
- 58:24Rachel Dauchy: But, um, we still use the individual sales postings through Cinder just because it's so fantastic.
- 58:31Rachel Dauchy: And I'm not gonna use the one in QBO.
- 58:34Rachel Dauchy: It's too slow, it's too clunky.
- 58:36Rachel Dauchy: And sometimes I have issues with the returns.
- 58:39Rachel Dauchy: So Cinder is, in my opinion, by far, the best connector when it comes to individual sales transactions.
- 58:48Dan DeLong: Mm-hmm.
- 58:49Dan DeLong: Yeah.
- 58:49Dan DeLong: 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.
- 58:59Dan DeLong: Uh, one thing that sender it, it provides you a link or an access to that sale.
- 59:05Dan DeLong: So you're able to see the sale that was downloaded.
- 59:08Dan DeLong: But if you actually wanna see the who the customer was and everything, that's the, sales detail.
- 59:14Dan DeLong: Uh, you have to have access to the client's Shopify or their sales channel, whatever that happens to be.
- 59:22Dan DeLong: 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.
- 59:31Dan DeLong: Uh, but in web ility, you can see the sales detail in the, application without having access to those other things.
- 59:40Rachel Dauchy: Yeah,
- 59:41Dan DeLong: that's really cool
- 59:42Rachel Dauchy: because that's it.
- 59:42Rachel Dauchy: A lot of times you do have to go to the portal to go pull up the sales information.
- 59:48Rachel Dauchy: Yeah.
- 59:48Rachel Dauchy: And so you know, cinder works really well with WooCommerce too.
- 59:52Rachel Dauchy: Just FYI, if you know anybody is, has a client on WooCommerce site or do channels
- 59:56Dan DeLong: as well.
- 59:57Rachel Dauchy: I like it.
- 59:57Rachel Dauchy: Yeah.
- 59:58Dan DeLong: Yeah.
- 59:58Dan DeLong: 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.
- 1:00:17Dan DeLong: So here's, uh, as promised the summary of all of the options.
- 1:00:24Dan DeLong: 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.
- 1:00:41Dan DeLong: Um, and then when you have one last thing, this is a little bit more advanced, so if you, gotta go, you gotta go.
- 1:00:48Dan DeLong: That's great.
- 1:00:50Dan DeLong: 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.
- 1:01:00Dan DeLong: Using here, we're not talking about Excel, uh, but they're actually using an inventory management solution app.
- 1:01:09Dan DeLong: 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.
- 1:01:20Dan DeLong: What, when you have a client that's using these kinds of applications, what, um, what surprises have you seen?
- 1:01:28Dan DeLong: Or do they work just splendidly?
- 1:01:31Rachel Dauchy: Well, you really need to have, for really any of these.
- 1:01:34Rachel Dauchy: 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.
- 1:01:45Rachel Dauchy: You, really wanna make sure you understand the inventory workflow, even if you're doing it in QBO.
- 1:01:49Rachel Dauchy: But, um, Katana, I would say is great for manufacturing.
- 1:01:55Rachel Dauchy: Meaning I'm assembling items together to create a finished good.
- 1:02:00Rachel Dauchy: It's, not the greatest for heavy e-commerce.
- 1:02:02Rachel Dauchy: I'll say maybe one Shopify store.
- 1:02:05Rachel Dauchy: It's fine.
- 1:02:07Rachel Dauchy: And, but since seven core I am.
- 1:02:10Rachel Dauchy: Very involved with that app.
- 1:02:13Rachel Dauchy: I work with the team there.
- 1:02:15Rachel Dauchy: I am Albe at since seven summit this August.
- 1:02:19Rachel Dauchy: That is the one that I have most of my training and specialty in multi-channel, um, purchasing.
- 1:02:26Rachel Dauchy: Speaking of purchasing subtle is actually a great somebody was talking about, can I do the purchasing in Shopify?
- 1:02:34Rachel Dauchy: No, you can't.
- 1:02:35Rachel Dauchy: So you really wanna make sure that, again, you're following that purchasing inventory workflow.
- 1:02:40Rachel Dauchy: You can do it in settle and then settle will even keep a list of your inventory items.
- 1:02:47Rachel Dauchy: And with, I don't know, like FIFO costing or weighted average costing or something like that.
- 1:02:51Rachel Dauchy: You're not gonna get any of that inventory valuation in Shopify.
- 1:02:56Rachel Dauchy: It's really just a place to list, these are my items and here's how many I have.
- 1:03:02Rachel Dauchy: You know, you use an app like this and you're really going to utilize a proper inventory costing method.
- 1:03:09Rachel Dauchy: Oh yeah, we did leave out fishbowl.
- 1:03:11Rachel Dauchy: Sorry.
- 1:03:11Rachel Dauchy: Yeah, I actually have some clients on Fishbowl too.
- 1:03:14Rachel Dauchy: 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.
- 1:03:21Rachel Dauchy: They do have a web based product too, but,
- 1:03:25Dan DeLong: Yep.
- 1:03:25Dan DeLong: Which they'll be coming on the Power Hour in June
- 1:03:28Rachel Dauchy: Yeah.
- 1:03:29Rachel Dauchy: To talk about so and so we definitely have a relationship with them.
- 1:03:31Rachel Dauchy: Yeah.
- 1:03:32Rachel Dauchy: They're a thing.
- 1:03:33Rachel Dauchy: For me personally, I'm a very heavy, since seven core user, it's totally cloud-based.
- 1:03:39Rachel Dauchy: And there's no hosting, um, you know, in the web, like nothing like that.
- 1:03:43Rachel Dauchy: No additional cost for that.
- 1:03:46Rachel Dauchy: And I think that's a really excellent a advantage that it has.
- 1:03:52Dan DeLong: Right.
- 1:03:52Dan DeLong: And and that's, and this slide here is really talking, speaking to what those inventory management solutions are designed to do.
- 1:04:00Dan DeLong: They're designed to manage the inventory, right.
- 1:04:03Dan DeLong: So they're, they're designed to, to have things come in and, and so that you can.
- 1:04:08Dan DeLong: See that source of truth of your inventory, right?
- 1:04:12Dan DeLong: And, you know, sales made online are gonna be part of that, right?
- 1:04:17Dan DeLong: Yeah.
- 1:04:17Dan DeLong: And so what they're not really concerned about is did you get paid for those sales that you made?
- 1:04:24Dan DeLong: And so a lot of them are a little bit light on the payout option, right?
- 1:04:30Dan DeLong: 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
- 1:04:41Rachel Dauchy: No.
- 1:04:41Rachel Dauchy: And the thing with that is will it sync a payment?
- 1:04:45Rachel Dauchy: Yeah, of course.
- 1:04:45Rachel Dauchy: 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?
- 1:04:55Rachel Dauchy: You've got a.
- 1:04:56Rachel Dauchy: Record payment that's coming over also to undeposited funds.
- 1:05:00Rachel Dauchy: 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.
- 1:05:10Rachel Dauchy: Another one that we didn't talk about was finale inventory.
- 1:05:13Rachel Dauchy: They have a special integration with H two X.
- 1:05:17Rachel Dauchy: 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
- 1:05:36Dan DeLong: Right.
- 1:05:36Rachel Dauchy: You're syncing over your, well, we, I'm not gonna get into that complexity, but we can talk about that in right now.
- 1:05:44Rachel Dauchy: Right,
- 1:05:45Dan DeLong: right.
- 1:05:45Dan DeLong: 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
- 1:06:03Rachel Dauchy: accounts.
- 1:06:03Rachel Dauchy: Right?
- 1:06:03Rachel Dauchy: Yeah, for sure.
- 1:06:04Rachel Dauchy: And the slippery slope of all of this is.
- 1:06:08Rachel Dauchy: I know it feels and sounds complicated and it just requires a little bit more understanding.
- 1:06:17Rachel Dauchy: And that's why we're here.
- 1:06:18Rachel Dauchy: We specialize in this, like I train in this area, I offer coaching.
- 1:06:24Rachel Dauchy: Um, my firm is net deposited.
- 1:06:26Rachel Dauchy: We handle nothing but these clients.
- 1:06:30Rachel Dauchy: And well, not nothing, but we handle a large amount of these clients.
- 1:06:33Rachel Dauchy: And so we really specialize in this area and I'll create a custom setup, you know, bypass this and do that.
- 1:06:39Rachel Dauchy: So if you're feeling frustrated, there is help.
- 1:06:43Rachel Dauchy: And so there, that's the thing.
- 1:06:46Rachel Dauchy: It's a slippery slope.
- 1:06:46Rachel Dauchy: It feels like, well this is all gonna be a mess.
- 1:06:49Rachel Dauchy: Trust me, it's a lot of information.
- 1:06:52Rachel Dauchy: It will set you up for absolute complete.
- 1:07:01Rachel Dauchy: Automation.
- 1:07:01Rachel Dauchy: It'll be, it's, it's wonderful is what I'm trying to say.
- 1:07:04Rachel Dauchy: It's really, really great.
- 1:07:05Rachel Dauchy: Right.
- 1:07:05Rachel Dauchy: When it's set up, and
- 1:07:06Dan DeLong: 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?
- 1:07:16Dan DeLong: This is, going to get you ahead, get
- 1:07:18Rachel Dauchy: involved in this, and you'll always have a job.
- 1:07:20Rachel Dauchy: 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.
- 1:07:32Rachel Dauchy: Yeah.
- 1:07:32Rachel Dauchy: They'll still add a new, your cl your client will add a new item the wrong way into this system.
- 1:07:38Rachel Dauchy: It's constantly needs to be troubleshooted.
- 1:07:40Rachel Dauchy: So there is job security in this for sure.
- 1:07:44Rachel Dauchy: Yeah.
- 1:07:44Rachel Dauchy: 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.
- 1:07:52Dan DeLong: Yeah.
- 1:07:53Dan DeLong: Last couple topics here is, um, and somebody was asking, well, how do you get in touch with Rachel?
- 1:07:58Dan DeLong: And that'll be on the next slide.
- 1:08:00Dan DeLong: so Shopify expenses, right?
- 1:08:02Dan DeLong: So this is one of those things that a lot of applications have kind of left out, right?
- 1:08:08Dan DeLong: Uh, so the monthly charges that Shopify charges, uh, shipping for one.
- 1:08:14Dan DeLong: 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.
- 1:08:28Dan DeLong: But those shipping charges come separately.
- 1:08:30Dan DeLong: They, are not part of this clearing account situation of sales versus, uh, expected payouts.
- 1:08:37Dan DeLong: Like they don't take the shipping charges out of the payouts.
- 1:08:40Dan DeLong: They charge them separately, right?
- 1:08:42Dan DeLong: Because they might build up a threshold and say, oh, we need to charge them now for, all their shipping charges.
- 1:08:49Dan DeLong: Shopify has a wonderful ecosystem of plugins, right?
- 1:08:54Dan DeLong: And those apps will charge Shopify, and then that'll show up on your billing, uh, statement as well.
- 1:09:01Dan DeLong: And Shopify doesn't do this outta the kindness of the heart.
- 1:09:04Dan DeLong: So they, have their own, so subscription costs, right?
- 1:09:07Dan DeLong: Yeah.
- 1:09:07Dan DeLong: But the.
- 1:09:08Dan DeLong: You might want to have those things separated out, right?
- 1:09:12Dan DeLong: Your shipping charges, your Shopify plugins and your Shopify subscription fees, but nobody really manages that all too well.
- 1:09:20Dan DeLong: 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.
- 1:09:53Dan DeLong: 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.
- 1:10:03Dan DeLong: 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.
- 1:10:12Dan DeLong: 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.
- 1:10:25Dan DeLong: Over at School of Bookkeeping, it's, it's live, it's available.
- 1:10:28Dan DeLong: 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.
- 1:10:39Dan DeLong: I did put in the chat as well.
- 1:10:41Dan DeLong: Uh, that we uh, Rachel the email address.
- 1:10:46Dan DeLong: So if you want to copy that, uh, or Rachel, if you wanna put it in the chat just, as well.
- 1:10:52Dan DeLong: If, uh, people want shoot you a quick email, uh, you can do that as well.
- 1:10:56Rachel Dauchy: Yep.
- 1:10:57Rachel Dauchy: It's just rachel@netdeposited.com.
- 1:10:59Rachel Dauchy: Right.
- 1:11:00Dan DeLong: But it's, uh, creatively, you, you drop the A or I don't know which is more prevalent.
- 1:11:06Dan DeLong: It's,
- 1:11:07Rachel Dauchy: it's plain.
- 1:11:07Rachel Dauchy: E-L-R-A-C-H-E-L.
- 1:11:12Dan DeLong: So I'm gonna throw up the last poll question here.
- 1:11:14Dan DeLong: Uh, as we as we come in for a landing, was it useful if you wanted to get, uh, in touch with Rachel?
- 1:11:20Dan DeLong: We can, uh provide that information to, uh, Rachel and then she can, uh, reach out directly.
- 1:11:27Dan DeLong: But Rachel, any, uh, closing thoughts as we, uh, come in for a landing here?
- 1:11:32Rachel Dauchy: No, other than I'm just gonna keep studying all these apps and, and as they add more things, just keep learning.
- 1:11:42Rachel Dauchy: And, um, I personally love this niche.
- 1:11:45Rachel Dauchy: I think it's great.
- 1:11:47Rachel Dauchy: And, um, I think something like, I don't know, there's$65 billion worth of e-commerce, like in just last year alone.
- 1:11:58Rachel Dauchy: It's not going anywhere.
- 1:12:00Rachel Dauchy: 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.
- 1:12:11Rachel Dauchy: But, um, yeah.
- 1:12:15Dan DeLong: Yeah.
- 1:12:16Dan DeLong: And then you said the word worldwide and I see this.
- 1:12:19Dan DeLong: Are you Sure?
- 1:12:20Rachel Dauchy: I don't know.
- 1:12:21Rachel Dauchy: I think that was just the United States.
- 1:12:23Dan DeLong: Yeah.
- 1:12:23Dan DeLong: So, yeah, that's, um.
- 1:12:25Dan DeLong: But also, you know, that adds up additional considerations, right?
- 1:12:29Dan DeLong: If they're shipping worldwide or, you know, multicurrency all other issues, uh, as well, uh, if they are in a worldwide shipping
- 1:12:40Rachel Dauchy: situation.
- 1:12:40Rachel Dauchy: 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.
- 1:12:50Rachel Dauchy: So it's really, um the, advantages of using something like Shopify, I just can't like, preach it enough.
- 1:12:58Rachel Dauchy: It's really incredible.
- 1:13:00Dan DeLong: So, uh, next time on the, uh, power Hour.
- 1:13:03Dan DeLong: If you haven't registered for it already, please do.
- 1:13:06Dan DeLong: Um, individual one, we're going to be having, um, a representative from, uh, Relay the financial institution talking about passing the baton.
- 1:13:16Dan DeLong: We had her come on a couple of our workshops.
- 1:13:20Dan DeLong: 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.
- 1:13:34Dan DeLong: 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.
- 1:13:45Dan DeLong: So, uh, join us, uh, for that in a couple weeks and we'll see you next time on the QB Power Hour.
- 1:13:50Dan DeLong: Have a great day, everyone.