Latest / QB Power Hour Podcast / 10.8.24 - E-Commerce Fundamentals
Transcript
- 0:30Dan DeLong: Actually it's not Michelle and Dan today, quite a different Segway going into today's QB power hour, but we appreciate you joining us here today, Michelle is still on her trip of a lifetime in Papua New Guinea.
- 0:43Dan DeLong: So joining us today, we have some extra special guests but today we'll be talking about e commerce fundamentals and I really had to look up how to spell intricacies of going online because that is a tough word to spell off the top of your head.
- 0:59Dan DeLong: If you're not familiar with the intricacies of spelling.
- 1:02Matthew Fulton: Do you ever spell something so bad that even spellcheck just doesn't understand you?
- 1:08Dan DeLong: All the time.
- 1:09Matthew Fulton: Yeah.
- 1:09Matthew Fulton: Okay.
- 1:09Matthew Fulton: Thank you,
- 1:12Dan DeLong: That's a good, that's a good poll question.
- 1:14Dan DeLong: of course, everybody knows who Michelle is.
- 1:16Dan DeLong: She's she's off gallivanting the world doing her semi retirement today.
- 1:21Dan DeLong: Coho co-hosting today.
- 1:23Dan DeLong: My name is Dan DeLong, owner of Danwidth and School Bookkeeping.
- 1:25Dan DeLong: Worked at Intuit today as well.
- 1:33Dan DeLong: Workshop Wednesdays oddly enough on Wednesdays and we'll pass it over to Matt joining us today for a guest host
- 1:43Matthew Fulton: Hello everybody.
- 1:43Matthew Fulton: Matthew Fulton here with park web business solutions and qb community live the facebook group Actually just want to use my a couple quick seconds here to do a big shout out and to everybody in florida And the east coast that's you know been affected by all these different storms and the upcoming storms so hope everybody's safe and
- 2:03Dan DeLong: Stay dry this this time.
- 2:07Dan DeLong: And joining us for another time.
- 2:09Dan DeLong: You've been on the Power Hour before, Rachel, but let's for those that don't know Tell us a little bit about yourself.
- 2:16Rachel Dauchy: Sure.
- 2:17Rachel Dauchy: So I, like you said, also, I'm a co host with you with the workshop Wednesday, which I really enjoy.
- 2:24Rachel Dauchy: And I am just one of those folks that really enjoy inventory.
- 2:28Rachel Dauchy: So I, that's my background before I came into the QuickBooks world.
- 2:32Rachel Dauchy: So I really fell into e commerce and retail, and now I'm doing a lot of manufacturing and inventory setup and that kind of thing.
- 2:40Rachel Dauchy: So yeah, I do that.
- 2:42Dan DeLong: We appreciate you joining us and we'll actually unpack a little bit about the spider web of industries that you could actually get involved with with just e commerce in general.
- 2:54Dan DeLong: You can, you actually came from the inventory space professionally before you became a bookkeeper, right?
- 3:02Rachel Dauchy: Yep.
- 3:02Rachel Dauchy: So I've always worked in goods based businesses, consumer packaged goods and operations and accounting.
- 3:08Rachel Dauchy: And it's not, it's funny, it's not necessarily one type of industry.
- 3:13Rachel Dauchy: It's really the way we do it.
- 3:16Rachel Dauchy: Manage the inventory, the connectivity, the automation, is really what kind of we're talking about when we're talking about the e commerce specialty.
- 3:24Rachel Dauchy: It's not necessarily just, it can be a service business, it could be digital downloads, it could be all kinds of different things that they're selling.
- 3:34Dan DeLong: Yeah, they definitely, there is no one size fits all when it comes to this type of industry.
- 3:40Dan DeLong: So a little bit about the QB Power Hour every other Tuesday the first QB power hour of the month, which is this one is eligible for TP and credit.
- 3:49Dan DeLong: Thanks to our friends over at Makers Hub.
- 3:51Dan DeLong: Ted is lurking in the background, making sure that we fulfill our duties with poll questions and making sure that those certificates get emailed out post the work, the webinars.
- 4:02Dan DeLong: We appreciate you joining us for that.
- 4:04Dan DeLong: You can always go to the qbpowerhour.
- 4:07Dan DeLong: com slash resources.
- 4:08Dan DeLong: Website for the PDFs of the slides, the recordings, the podcast, and as well as other resources.
- 4:14Dan DeLong: A little bit of housekeeping, if you have specific questions about topics that we're talking about today, please put them in the Q& A, it makes it a lot easier to follow up and make sure that we're addressing your questions.
- 4:26Dan DeLong: As I see the webinar chat is scrolling by They tend to get lost there, so it's really hard to manage that sort of thing, but thank you to Matt joining us today, because he will do I see he's typing already in there, so he's helping out with that.
- 4:41Rachel Dauchy: Yeah, thank goodness for Matt.
- 4:43Rachel Dauchy: I always say that.
- 4:44Rachel Dauchy: Yes.
- 4:47Dan DeLong: And of course, we're we're simulcast or streaming on the Facebook and social media channels.
- 4:53Dan DeLong: If you are on the Facebook group and want to participate please use that QR code so that we can see who you are when you when you communicate or engage in the conversation.
- 5:03Dan DeLong: We do have, of course, the KB Power Hour store to check things out.
- 5:07Dan DeLong: NRCP credit thanks again to Makers Hub for making that available.
- 5:12Dan DeLong: You get one hour.
- 5:13Dan DeLong: You do have to participate, meaning that you have to answer the poll questions.
- 5:16Dan DeLong: And then we have a survey.
- 5:18Dan DeLong: Post post webinar.
- 5:19Dan DeLong: Our agenda today is we'll be talking about, and this all came up about a year ago.
- 5:24Dan DeLong: Rachel and I started a series of a workshop on the workshop Wednesday over at school bookkeeping about the nuances of e commerce.
- 5:34Dan DeLong: And and we're going to talk about in real high level, just what we talked and unpacked during the, I don't know, what was it, Rachel?
- 5:41Dan DeLong: Was it it was like a couple.
- 5:43Dan DeLong: A couple months of workshop that we really dug in there into the conversations.
- 5:48Dan DeLong: And
- 5:48Rachel Dauchy: we also like to talk about it a lot too.
- 5:51Rachel Dauchy: So it's not that it's so complicated.
- 5:53Rachel Dauchy: We just love to chat about it.
- 5:55Dan DeLong: It was it was definitely a, an eye opening discussion on both our parts, but we really want to talk about really high level what we discussed there and we've created we've taken and repurposed those those workshops and turned them into an e commerce fundamental course over at School of Bookkeeping as well.
- 6:13Dan DeLong: Want to review all that things that, a deeper dive that what we're talking about here today.
- 6:18Dan DeLong: We'll share those links at the end of the webinar, but really we want to talk about, selling online in general shopping cart versus a marketplace, what the, what that is inventory is going to be specific typically it's a specific nuance of this type of industry and that as we're going to unpack is really the, um, when you're talking to a client, where the inventory source of truth is really going to determine a lot of other answer, a lot of other questions that you might have when you're working with them.
- 6:51Dan DeLong: So typically they don't come to you and say, here's my business.
- 6:55Dan DeLong: Help me.
- 6:56Dan DeLong: Or do they?
- 6:56Dan DeLong: They
- 6:57Rachel Dauchy: do sometimes.
- 6:59Matthew Fulton: They come to you and say, here's my business, help me.
- 7:01Matthew Fulton: But they don't say, here's all of my business, help me.
- 7:06Matthew Fulton: And oh, by the way, I forgot to mention these two other things I'm going to add on next week when you tell me not to do anything and so forth.
- 7:13Rachel Dauchy: Exactly.
- 7:14Rachel Dauchy: It usually comes in the form of a surprise.
- 7:21Dan DeLong: And I'll add PayPal to all my sales channel.
- 7:24Dan DeLong: And then there's always a sales tax concern when it comes to that.
- 7:27Dan DeLong: We'll talk about those types of concerns omni channel selling cause typically e commerce or a, a shopping cart as a gateway drug.
- 7:37Dan DeLong: Hey, they want to they want to sell other places as well.
- 7:40Dan DeLong: Hey, if I can just do it here, I can do it.
- 7:42Dan DeLong: I can do it at Walmart or or Amazon or eBay or multiple channels.
- 7:48Dan DeLong: What's one more, right?
- 7:49Dan DeLong: It's like when you have a triplet, um, what's one more baby.
- 7:53Dan DeLong: And then you get a surprise.
- 7:55Dan DeLong: Yeah.
- 7:55Dan DeLong: And then shipping and fulfillment will definitely be a concern for e commerce salute e commerce, the e commerce industry.
- 8:03Dan DeLong: And then we'll unpack some of the tech solutions that, that will help streamline, hopefully these processes, sales connectors, the inventory management system and then QBO desktop synchronization.
- 8:16Dan DeLong: And then if time permits, we'll have some Q and A.
- 8:20Dan DeLong: So our first poll question while we're Doing this, let's launch that.
- 8:25Dan DeLong: It's a two parter, right?
- 8:26Dan DeLong: One, you need CPE credit for today's webinar, and two, you currently have clients in the e commerce space.
- 8:33Dan DeLong: So Rachel, what really drove you to this state?
- 8:38Dan DeLong: What made you get into this type of industry?
- 8:42Dan DeLong: Why would you do such a thing?
- 8:44Rachel Dauchy: First of all, I was very familiar with inventory and inventory measurement and movements, but I ended up when I first started with QuickBooks online and I've used all other kinds of inventory softwares, my, whole professional career, but I hadn't used QuickBooks online.
- 9:02Rachel Dauchy: I had used QuickBooks desktop.
- 9:04Rachel Dauchy: And when I first started it, I was so clueless about QuickBooks online that I thought I had to connect everything to automation.
- 9:11Rachel Dauchy: I thought that was a requirement.
- 9:13Rachel Dauchy: It's just funny how you just assume certain things.
- 9:16Rachel Dauchy: I screwed it all up.
- 9:17Rachel Dauchy: And so it took me a while to unravel it and figure it all out.
- 9:22Rachel Dauchy: So when I did that, I realized, oh, I can really service these e commerce clients.
- 9:26Rachel Dauchy: I just taught myself so many different things.
- 9:29Rachel Dauchy: And then I realized, oh, this is such a great advantage because even though I wasn't an inventory expert I know much more now, but I thought, wow, I can really use these few things that I know.
- 9:41Rachel Dauchy: And.
- 9:42Rachel Dauchy: Just pick this niche And then set myself apart from a lot of other people and all you people on the call you might even hear the same thing A lot of bookkeepers and accountants will say I don't touch inventory but if you equip yourself with a few key fundamentals, you can certainly do it and then not, set yourself apart.
- 10:03Rachel Dauchy: And now you're in a league of your own, and you don't really have to compete with as many people.
- 10:08Rachel Dauchy: So that was really important to me.
- 10:10Rachel Dauchy: And that's really how my experience has worked out.
- 10:14Rachel Dauchy: So you
- 10:14Dan DeLong: had you had that knowledge, intimate knowledge of inventory management, and then just
- 10:20Rachel Dauchy: Yeah, I did, but I also learned so much more as I went along.
- 10:26Rachel Dauchy: Of, okay, it's gotta work like this, I gotta have a COGS entry, okay.
- 10:31Rachel Dauchy: Now that I discovered this connector is posting transactions individually, this connector is posting transactions.
- 10:38Rachel Dauchy: Batched for the day.
- 10:40Rachel Dauchy: How am I going to get my COGS entry?
- 10:43Rachel Dauchy: Just figuring out so many different things.
- 10:45Rachel Dauchy: How is my COGS reporting going to work in this situation?
- 10:49Rachel Dauchy: You just learn so much as you go along, almost inadvertently, that it just works out that way.
- 10:56Rachel Dauchy: Yeah, so
- 10:57Dan DeLong: you definitely don't go into this sort of industry expecting to know everything.
- 11:03Rachel Dauchy: No, and you can't because you just don't.
- 11:05Rachel Dauchy: A lot of these, what we're going to get into, they, a lot of these tech companies, SaaS, companies that sink into QuickBooks do it differently.
- 11:15Rachel Dauchy: That's why they're different companies.
- 11:16Rachel Dauchy: They don't all do it exactly the same.
- 11:18Rachel Dauchy: And I know Matt and Dan, you guys are so knowledgeable and well connected with so many different companies.
- 11:25Rachel Dauchy: And so just the further that you go along is now I have you just learn how everybody does me think it does everything and how these things are connected and how it works.
- 11:34Rachel Dauchy: But I will say, I'll just say this because I think we're probably going to get into this.
- 11:39Rachel Dauchy: You don't have to be an inventory expert to do this kind of e commerce bookkeeping and accounting.
- 11:46Rachel Dauchy: I get very involved in the inventory and help my clients with the movement and housing of their inventory.
- 11:57Rachel Dauchy: I personally don't get involved in their shipping and fulfillment.
- 12:00Rachel Dauchy: That's something that they have to take care of.
- 12:02Rachel Dauchy: I am not involved in that at all.
- 12:04Rachel Dauchy: I know other bookkeepers and accountants that do not get involved in where their inventory is housed.
- 12:10Rachel Dauchy: And they're just doing the bookkeeping.
- 12:13Rachel Dauchy: And they're just, accounting for the cogs and making sure everything is timely.
- 12:17Rachel Dauchy: It's really up to you.
- 12:19Rachel Dauchy: There's no rules and that's what I've learned along the way is you just find, what you really like and what your inclination is towards this type of thing and you can pick and choose and I now am getting involved in, we'll talk about this a little bit later, but an IMS, which is where you manage this inventory, a cloud based IMS, the way that it used to be done in QuickBooks Desktop, but now we're doing it in a cloud based situation.
- 12:45Rachel Dauchy: That's my jam.
- 12:46Rachel Dauchy: So I don't, nobody has to do it the way I do it.
- 12:49Rachel Dauchy: There's a lot of different ways to get involved in it.
- 12:53Rachel Dauchy: Yeah.
- 12:53Dan DeLong: Matthew, what do you, Where's your experience from?
- 12:56Dan DeLong: Is it more of you found a client that brought all this to your attention or was it more of a specialty for you to
- 13:03Matthew Fulton: found a couple clients over time that kind of brought it to my attention and then always being a button pusher like that likes to try to break things and better understand it.
- 13:13Matthew Fulton: I personally try to stay away from having to track true physical inventory where I can especially within QuickBooks online, because if it's a mess, it's a mess and which there's a question actually from Carolyn, which I'm sure we'll get to that's was asking about having issues trying to upload inventory for weekly batch update of thousands of items in QBO.
- 13:36Matthew Fulton: I know some.
- 13:37Matthew Fulton: Apps that can externally do it, but I'm sure you may know other items that can be done other ways.
- 13:42Matthew Fulton: But prefer to stay away from some quite a bit of the e commerce stuff, but everything's e commerce now.
- 13:48Dan DeLong: Yeah, about four years ago Pretty much everybody needed to at least have that e commerce discussion.
- 13:54Dan DeLong: Even people that met in person needed to have some way to sell something online that didn't require people to be in person.
- 14:05Dan DeLong: No, we had we've, we've talked a lot about this.
- 14:08Dan DeLong: Type of topic in prior to be power hour.
- 14:12Dan DeLong: So I wanted to make sure that I really had the availability to review those.
- 14:17Dan DeLong: We did have Veronica Wasik on several years ago.
- 14:20Dan DeLong: And she is one of those people that Rachel was mentioning that.
- 14:24Dan DeLong: Doesn't get involved
- 14:26Rachel Dauchy: with, that,
- 14:27Dan DeLong: That's her turn, her engagement is I'll live in the QuickBooks and I'll get you set up, so that it comes into QuickBooks in the way that I wanted to, you do everything else, and then they'll help it helps her corral the cat, heard the cats a little better when you have that, Framing in an expectation setting.
- 14:48Dan DeLong: So she has a great great workshop or QB power hour there.
- 14:52Dan DeLong: We did have William English on to talk about his specialty of retail when he was out in the on the other side of the the Intuit badge.
- 15:00Dan DeLong: Now he's a QB assisted team lead.
- 15:03Dan DeLong: Funny how things work full circle.
- 15:05Dan DeLong: We did have WebDuality on to talk about their solution.
- 15:09Dan DeLong: And then I had a couple of Amazon sellers that I was working with do a panel discussion of what it's like to work with that, that drunk uncle of selling, selling selling on Amazon.
- 15:23Dan DeLong: So you can always check those check those out there.
- 15:26Dan DeLong: They hold no punches of their feeling towards towards Amazon.
- 15:30Dan DeLong: Oh, we don't want to start them.
- 15:31Dan DeLong: Welcome everybody to another Oh!
- 15:33Rachel Dauchy: Oh boy, okay, see i'm not the only one dan.
- 15:37Matthew Fulton: Oh, wait Actually michelle told us we're allowed to blame everything on her when she's not around remember.
- 15:41Matthew Fulton: That's right.
- 15:42Matthew Fulton: I forgot about that
- 15:43Dan DeLong: So if you're considering specializing in e commerce if we haven't scared you enough these are the things that you're Potentially find yourself specializing in the inventory management selling online Consulting and these are things that you can Go down that rabbit hole and and maybe find yourself a home in like Rachel is finding inventory management and those types of things to be really where she, he finds her passion regarding and all of these other things.
- 16:13Dan DeLong: Maybe she's working with another.
- 16:16Dan DeLong: Partner, you know that can handle those things.
- 16:18Dan DeLong: So it comes in as a a team, you don't have to wear all the hats here
- 16:23Rachel Dauchy: Yeah, there is that situation going on for sure.
- 16:26Matthew Fulton: Is this considered niching the niche or niching the niche?
- 16:30Dan DeLong: Depends on what whether you're north of the canadian border or not, I think that's where the The pronunciation we'll have to ask sean at katana tomorrow when we have him on the workshop What he says But then there's eat online selling consultant, right?
- 16:48Dan DeLong: Like you could be specializing in setting up Shopify, from start to finish marketplace consulting.
- 16:55Dan DeLong: All right.
- 16:55Dan DeLong: And, do you really want to deal with Amazon?
- 16:58Dan DeLong: You can get into those types of services, the retail aspect of e commerce, right?
- 17:03Dan DeLong: Do they have a brick and mortar store in addition to selling on then of course, that leads up to the point of sale system.
- 17:09Dan DeLong: What are they using to track those those sales?
- 17:12Dan DeLong: And then of course, The 64, 000 question of how that data gets into QuickBooks.
- 17:17Dan DeLong: And then of course
- 17:18Rachel Dauchy: Yeah, or do, can I even manage inventory in QuickBooks with this situation?
- 17:22Rachel Dauchy: Somebody that was, we were just, the chat maybe was saying something about the thousands of SKUs.
- 17:29Rachel Dauchy: I would never do that in QuickBooks online, even if I was only managing one channel.
- 17:34Rachel Dauchy: So that should I do it here or should I not do it here?
- 17:37Rachel Dauchy: There is so much potential for advisory.
- 17:42Rachel Dauchy: This is my advisory.
- 17:44Rachel Dauchy: I do this all day, every day.
- 17:47Dan DeLong: Yeah.
- 17:47Dan DeLong: And then those retail channels, they're going to have specialized service offerings that they might need, right?
- 17:53Dan DeLong: Like the customer rewards, right?
- 17:56Dan DeLong: Those types of things that they could potentially be needing.
- 18:00Dan DeLong: All of those things could be.
- 18:01Dan DeLong: Be part of your technological advisory services, if that's what you want to specialize in, and then sales tax is going to be a huge concern for somebody selling online, especially if they don't realize that they've crossed the economic nexus in a certain state those things are going to necessarily be, uh, that, that kind of someone looking out for them, I think is, that's probably the best place.
- 18:29Matthew Fulton: So this is one of the areas, yeah.
- 18:30Matthew Fulton: That I'm really interested to learn a little bit more about today as well.
- 18:34Matthew Fulton: And when I think of e commerce and a lot of people I'm helping.
- 18:38Matthew Fulton: Even just having communities and online and selling subscriptions of that nature It's e commerce because as you're going to talk about payment gateways versus sales channels And you're when you reach nexus in these different places so i'm excited to hear a little bit more about some of that stuff as we're all building out these new communities for each other
- 19:00Dan DeLong: Yeah, and then, of course, shipping and fulfillment.
- 19:02Dan DeLong: So all of these could be, you could be a generalist in just this area, just one of these areas or a, I'm sorry, generalist in all of these areas or a specialist in just one of these areas.
- 19:13Dan DeLong: Lots of areas of places to, to focus on.
- 19:16Dan DeLong: Lots of rabbit holes to find yourself jumping down in this particular area, right?
- 19:24Dan DeLong: Let's first talk, talk about where you sell things, right?
- 19:27Dan DeLong: Selling online you're gonna have some options and and Rachel, we had unpacked this whole idea of a marketplace versus an online shopping cart.
- 19:37Rachel Dauchy: This is something we address heavily in the course in School of Bookkeeping.
- 19:43Dan DeLong: Yeah.
- 19:43Dan DeLong: So talk a little bit about what a marketplace is versus versus an online shopping cart, because simple thing is, Hey, I want to sell stuff online, but the question is where and how, and the.
- 19:56Dan DeLong: Depending on where you do those things will determine a lot of other workflows, right?
- 20:03Rachel Dauchy: Yeah, so one thing that we talked about before is asking questions of a new potential client or even somebody that you already have as a client and maybe they're looking to get into this.
- 20:15Rachel Dauchy: Or maybe you have them as a client and it's, Surprise! I do this too! And that happens as well.
- 20:22Rachel Dauchy: There's always some core questions you always want to ask.
- 20:25Rachel Dauchy: And if they're selling stuff, where are they selling that stuff?
- 20:30Rachel Dauchy: Or where do they want to sell that stuff?
- 20:33Rachel Dauchy: Some people sell that stuff in one retail store, where I'm just taking on like a pack and ship store.
- 20:40Rachel Dauchy: And I'd consider that e commerce, because they're selling a whole bunch of stuff in their store, and we're collecting those Those that revenue through a POS system.
- 20:51Rachel Dauchy: So anyway, that and that we can talk about a more later, but basically it's where am I selling this stuff?
- 20:59Rachel Dauchy: If I'm selling it online or in a store, am I selling it on a marketplace and a by marketplace?
- 21:07Rachel Dauchy: I mean something like Amazon and dad had a really good analogy to this before.
- 21:12Rachel Dauchy: It's basically like a swap meet.
- 21:14Rachel Dauchy: It's not your swap meet.
- 21:17Rachel Dauchy: It's a place that you go to and there's a whole bunch of other vendors.
- 21:21Rachel Dauchy: So you're one of many, right?
- 21:23Rachel Dauchy: So you're going to a place where you know there's going to be a lot of buyers.
- 21:28Rachel Dauchy: That's a marketplace.
- 21:30Rachel Dauchy: So Amazon's a marketplace.
- 21:32Rachel Dauchy: Etsy's a marketplace.
- 21:34Rachel Dauchy: Walmart has a marketplace.
- 21:37Rachel Dauchy: Walmart retail is not a marketplace.
- 21:40Rachel Dauchy: But Walmart marketplaces.
- 21:42Rachel Dauchy: And then there's a whole bunch of other e com marketplaces out there.
- 21:46Rachel Dauchy: And the main commonality that they all have is that they're what is called a marketplace facilitator.
- 21:53Rachel Dauchy: Meaning, they collect the sales tax from your buyer, they then remit that sales tax to the state, and they also file the return.
- 22:05Rachel Dauchy: That is an advantage of going with somebody like Amazon or eBay or another kind of marketplace.
- 22:13Rachel Dauchy: You still have to record the sales tax coming in the sales tax going out, but you are not accruing a sales tax liability.
- 22:23Rachel Dauchy: That is the most important thing.
- 22:26Rachel Dauchy: That's enticing to people because they don't want to deal with sales tax.
- 22:30Rachel Dauchy: And I get it.
- 22:31Rachel Dauchy: Sales tax sucks.
- 22:32Rachel Dauchy: So they'll often be willing to pay the high fees of something like a marketplace.
- 22:39Rachel Dauchy: The other option would be a, what'd you call it?
- 22:44Rachel Dauchy: Like your own, whatever.
- 22:46Rachel Dauchy: Yard
- 22:46Dan DeLong: sale.
- 22:46Dan DeLong: Yeah,
- 22:49Rachel Dauchy: so your own website would be something like Shopify or WooCommerce or something like that where it's your own business like joeshardwarestore.
- 23:01Rachel Dauchy: com.
- 23:01Rachel Dauchy: It's your own domain and you are responsible for the traffic of getting people to your website.
- 23:08Rachel Dauchy: You also have to collect the sales tax and then you have to remit the sales tax.
- 23:13Rachel Dauchy: And because it's online, if you're in an online store, people could be buying from anywhere.
- 23:20Rachel Dauchy: And so that collects what we call economic nexus.
- 23:24Rachel Dauchy: That's all I'm going to say about that.
- 23:26Rachel Dauchy: We have a course on that in the workshop, but in school bookkeeping.
- 23:30Rachel Dauchy: But the other piece of that would be if you have your own retail store, your own salon or your own, whatever.
- 23:37Rachel Dauchy: where you're collecting your own payments and then you're obligated to pay your own sales tax.
- 23:44Rachel Dauchy: I lump that under e commerce because I'm usually taking some kind of electronic POS payouts.
- 23:52Rachel Dauchy: And so again, and Matt, you probably know all about this.
- 23:55Rachel Dauchy: This is something that is also needs to be synced to QuickBooks Online.
- 24:01Rachel Dauchy: To post the revenue, because I'll ask you guys one question.
- 24:05Rachel Dauchy: We talk about this all the time in this course.
- 24:09Rachel Dauchy: Do we post payouts to revenue?
- 24:13Rachel Dauchy: No, never ever.
- 24:18Rachel Dauchy: So in quick, now here's the beauty with QuickBooks online.
- 24:21Rachel Dauchy: This is all sinking into QuickBooks online.
- 24:24Rachel Dauchy: You bookkeepers out there.
- 24:27Rachel Dauchy: What posts revenue?
- 24:29Rachel Dauchy: A sales receipt, an invoice, or a journal entry.
- 24:34Rachel Dauchy: So that's how the revenue comes in.
- 24:37Rachel Dauchy: The payouts can sometimes come in two days, three days, two weeks later.
- 24:42Rachel Dauchy: It really depends.
- 24:44Rachel Dauchy: So that all these are things to know about but the main question is find out from your potential client or your client where they are selling and again you can be a expert get some information on the fees involved in either and position yourself to be an expert and hey you might want to consider something like amazon yeah the fees are high but look at the the advertising potential you can get from that.
- 25:15Rachel Dauchy: Or don't do that.
- 25:17Rachel Dauchy: Maybe go the Shopify route.
- 25:19Rachel Dauchy: Maybe you're a Google SEO specialist and you have some insight into that and can help your client, navigate that world.
- 25:27Rachel Dauchy: And I don't know anything about that.
- 25:29Rachel Dauchy: So that's where I would reach out to somebody like Matt, who's an SEO expert.
- 25:34Matthew Fulton: Probably Dan It's better.
- 25:36Matthew Fulton: But can I try to summarize to make sure I heard?
- 25:39Rachel Dauchy: Yeah
- 25:39Matthew Fulton: a big difference between it being it's like a marketplace What you're telling us is it's important for us to talk to the client to number one understand where they are selling everything and then to You also need to know how you get paid for everything you sold.
- 25:56Rachel Dauchy: Yes,
- 25:57Matthew Fulton: because depending on how you get paid if it's going through a sales channel where you're selecting it through Authorized.
- 26:06Matthew Fulton: net or any of these other different ones that are paypal which Dan and I were joking paypal is the only six letter four letter word out there.
- 26:15Matthew Fulton: Yeah
- 26:15Rachel Dauchy: There's a million and one different ways to collect that money You
- 26:20Matthew Fulton: Yep.
- 26:20Matthew Fulton: And so when you have that control, that's talking about the shopping cart.
- 26:24Matthew Fulton: And then the shopping cart has to have a really good understanding of sales tax, pinpoint rooftop type stuff that to save your rear down the future.
- 26:33Rachel Dauchy: Yeah.
- 26:34Rachel Dauchy: And then there's also, and I, maybe we'll get into this a little bit later, but there's all kinds of automated sales tax apps.
- 26:40Rachel Dauchy: That I'm looking a lot into numeral right now that will track that nexus.
- 26:46Rachel Dauchy: And so it'll determine, that's a whole separate webinar that we could do about what achieves nexus.
- 26:52Rachel Dauchy: But there's a lot of resources online about that.
- 26:55Rachel Dauchy: That's something that's really important to know.
- 26:57Rachel Dauchy: But it, software can do it for you.
- 27:01Dan DeLong: And the big thing is there's pros and cons to either, either route, right?
- 27:05Dan DeLong: So you're in, in, in what you had mentioned about the marketplace is you're going to have sales tax calculated by them.
- 27:12Dan DeLong: They're going to be handling the customer service and of most of these sale and then on the.
- 27:18Dan DeLong: Individual online shopping cart, Shopify being, an example of one, all of the end to end, you're going to own that, right?
- 27:26Dan DeLong: So another analogy I would say is if you're a farmer, you can set up a farm, stand on the side of the road and you have control of everything.
- 27:36Dan DeLong: From customers coming in, how those things are fulfilled and everything.
- 27:40Dan DeLong: Or you take all your goods over to a farmer's market.
- 27:43Rachel Dauchy: Yeah.
- 27:44Rachel Dauchy: And
- 27:44Dan DeLong: that will have, foot traffic already built in because people know that there's a farmer's market Yeah.
- 27:50Dan DeLong: And such a dick larger
- 27:50Rachel Dauchy: audience.
- 27:51Rachel Dauchy: Yeah.
- 27:52Rachel Dauchy: And by the way, Shopify, and I'm a Shopify partner.
- 27:54Rachel Dauchy: Shopify by far in my opinion, is the best they actually have.
- 27:59Rachel Dauchy: I don't know most of the market share, not most, a significant number, I used to know it off the top of my head, of all online sales.
- 28:07Rachel Dauchy: And I think last year they were responsible for 65 billion worth of online sales.
- 28:12Rachel Dauchy: They're by the way, Shopify payments is a payment method powered by Stripe.
- 28:18Rachel Dauchy: It has the most powerful shopping cart.
- 28:20Rachel Dauchy: Most integrated, most integrate ability.
- 28:25Rachel Dauchy: Is that a word?
- 28:27Rachel Dauchy: Yeah.
- 28:28Rachel Dauchy: Integratable of all the people in the QuickBooks ecosphere that are building apps to get data into QuickBooks.
- 28:35Rachel Dauchy: Shopify is by far the best.
- 28:40Dan DeLong: But you can certainly find yourself into those rabbit holes of what apps and add ons
- 28:45Rachel Dauchy: in
- 28:46Dan DeLong: the Shopify space.
- 28:48Dan DeLong: But the next biggest thing, and this is probably the biggest key factor to determine when you're taking on an e commerce client, is inventory management.
- 28:58Rachel Dauchy: Yeah,
- 28:58Dan DeLong: determining where that source of truth is it going to be in the online sales channel?
- 29:03Dan DeLong: Is it going to be in QuickBooks or is there something that's necessary in between the online sales channel and QuickBooks to manage that inventory?
- 29:12Dan DeLong: Because that's going to really dictate the workflow, the purchasing, receiving sales tax And your sales tax I'm sorry, your technology solutions Rachel, what are you what are your thoughts about that?
- 29:22Rachel Dauchy: Yeah.
- 29:22Rachel Dauchy: So as, so the first important question, like I said, was determining where are they selling?
- 29:29Rachel Dauchy: The next important thing to determine is.
- 29:32Rachel Dauchy: Where is my inventory going to live?
- 29:35Rachel Dauchy: But before you ask that question, you have to know, and this is where a lot of people are very confused and clients are very confused.
- 29:45Rachel Dauchy: And it's this, are they drop shipping or are they carrying an inventory?
- 29:52Rachel Dauchy: Meaning are they buying goods that they're either storing in their garage, in a warehouse, In a fleet of warehouses and are they shipping out their own stuff?
- 30:06Rachel Dauchy: That is extremely important because a lot of people come to me as dropshippers, they don't understand that they're even dropshipping.
- 30:13Rachel Dauchy: And what that means is, they're not holding an inventory, they are Facilitating, they're getting the inventory that's over here with some other provider and they're making the sale and that provider is shipping it.
- 30:29Rachel Dauchy: So they're not actually buying the inventory, recording the sale and putting it to inventory and then recording a cost of goods sold entry at the point of sale.
- 30:41Rachel Dauchy: That's not happening.
- 30:42Rachel Dauchy: So if they're drop shipping, they're not holding any kind of inventory and it's actually quite simple.
- 30:48Rachel Dauchy: And we talk about that in the school of bookkeeping.
- 30:52Rachel Dauchy: If they are buying goods for either resale or.
- 30:56Rachel Dauchy: Sorry, if they're buying goods for resale, then they're holding an inventory.
- 31:02Rachel Dauchy: Then it shoots off into, am I holding the inventory on the balance sheet?
- 31:08Rachel Dauchy: Or am I actually just hitting cost of goods sold right away with this inventory?
- 31:14Rachel Dauchy: That hitting the cost of goods sold right away with the inventory, isn't my preferred way to do it.
- 31:19Rachel Dauchy: It's the easy way, and it's not, it could cause them to be upside down on their P& L.
- 31:26Rachel Dauchy: We'll talk about that another time, but that is the most important question to know.
- 31:31Rachel Dauchy: Aside from, am I dropshipping?
- 31:34Rachel Dauchy: Am I not dropshipping?
- 31:34Rachel Dauchy: That requires some really listening to them to understand.
- 31:39Rachel Dauchy: But if they are fulfilling their own stuff, then we have to determine, Can I manage that in QuickBooks?
- 31:50Rachel Dauchy: The most important thing out of this whole other question besides what are they selling?
- 31:55Rachel Dauchy: And this is crucial.
- 31:57Rachel Dauchy: If they are buying raw materials, assembling those raw materials into a finished good, and selling it, automatically no QuickBooks Online.
- 32:10Rachel Dauchy: They cannot do it.
- 32:11Rachel Dauchy: Now, if they're buying stuff, putting it in their garage, warehouse, or any other fulfillment house, and it's just reselling it, they can do it in QuickBooks Online.
- 32:24Rachel Dauchy: And let's say, for example, and I'm going to keep it really simple.
- 32:27Rachel Dauchy: Let's say, They're a wholesaler and they're, so no sales tax.
- 32:31Rachel Dauchy: So they're buying goods, let's say from China, finished goods.
- 32:34Rachel Dauchy: They're putting it in a warehouse and then they are selling to a wholesaler, sending them an invoice.
- 32:42Rachel Dauchy: Let's say not even doing an, any kind of e commerce thing.
- 32:46Rachel Dauchy: They're just wholesaling.
- 32:48Rachel Dauchy: They can then manage those items in QuickBooks online.
- 32:52Rachel Dauchy: 100 percent I would even say if they've got thousands of SKUs, they can do it in QuickBooks online.
- 32:58Rachel Dauchy: Because they're setting that inventory up to when the purchasing is made goes into inventory and then when they sell it with an invoice, it decreases the inventory and hits cost of goods sold.
- 33:11Rachel Dauchy: So that's an example of can I do it in QuickBooks or can I not do it in QuickBooks?
- 33:18Rachel Dauchy: So Dan, you have a whole bunch of other of why can't I do it in QuickBooks.
- 33:23Rachel Dauchy: So why don't you give an example of that?
- 33:26Dan DeLong: Yeah.
- 33:27Dan DeLong: So we so yeah, so we've we've unpacked this and this is one of those rabbit holes that we ended up going down in managing the inventory.
- 33:34Dan DeLong: So we've created a separate course for managing inventory.
- 33:39Dan DeLong: Can you do it in QuickBooks online?
- 33:41Dan DeLong: I I wrote a blog on the firm of the future of what you can do, but really those three things what you mentioned there is if they're reselling, I buy stuff and I sell that same stuff.
- 33:51Dan DeLong: I've got maybe some periodic inventory that I want to keep track of but I don't do anything fancy, right?
- 33:57Dan DeLong: So I don't.
- 33:58Dan DeLong: I don't need to track like I have a a client who's a distributor of alcohol and the tax even Napa Valley, so it's wine and tequila.
- 34:07Dan DeLong: I don't know why they go from one end of the spectrum to the other, but Carol, California, he buys in a, Base unit of measure of a bottle, but he's got to tell the state how many gallons he has at a certain, at the end of the year, because the fact man wants to know how many gallons that is.
- 34:28Dan DeLong: So we have to convert that to to a volume discount, so to speak to do that, and that's not something you're going to get out of QuickBooks online.
- 34:37Dan DeLong: You're going to need some kind of third party application in order to get those same reports.
- 34:43Rachel Dauchy: Yeah, so and then so let me just give like a really quick little example because somebody just asked inventory can be tracked in QuickBooks Enterprise.
- 34:52Rachel Dauchy: It's not really an issue of can I track it or can I not track it?
- 34:58Rachel Dauchy: It's a matter of the complexity that can be involved.
- 35:02Rachel Dauchy: So so again, like this poll question that Dan's asking, do you recommend tracking inventory in QuickBooks?
- 35:08Rachel Dauchy: Yes.
- 35:09Rachel Dauchy: Certain situations, yes, and I'll give you a perfect example of a client of mine that we do track it with a periodic inventory, okay?
- 35:18Rachel Dauchy: This is a retail store.
- 35:21Rachel Dauchy: They sell very expensive musical instruments and a very low volume of it, okay?
- 35:26Rachel Dauchy: This is a very ideal situation for a periodic inventory.
- 35:30Rachel Dauchy: In the store, they collect their payments through Stripe, right?
- 35:34Rachel Dauchy: The invoices come in, but with those invoices, we don't have a COGS entry.
- 35:40Rachel Dauchy: All it's doing is just collecting revenue, right?
- 35:43Rachel Dauchy: Revenue payment.
- 35:44Rachel Dauchy: That's it.
- 35:45Rachel Dauchy: At six month mark, we count the inventory, and at that point, decrease inventory, increase COGS.
- 35:54Rachel Dauchy: That's it, end of story.
- 35:56Rachel Dauchy: But we can track the ins and outs with of the sales with QuickBooks Online, which is really nice, but that inventory just stays put, right?
- 36:08Rachel Dauchy: So now a perpetual inventory, the same thing, let's just say like I have the other client with that we're going to onboard with the, box store, right?
- 36:18Rachel Dauchy: The where they're selling, I don't know, tape and boxes and staplers and mailers and stuff.
- 36:25Rachel Dauchy: Those can all go into QuickBooks Online as inventory items, if you're using Plus or Advanced.
- 36:32Rachel Dauchy: And we can, when we make those purchases, increase the value or increase the quantities of those, use that reporting in QuickBooks Online.
- 36:43Rachel Dauchy: It's only one channel.
- 36:44Rachel Dauchy: It's just one store.
- 36:45Rachel Dauchy: And then they're, they're invoicing from QuickBooks Online, the inventory goes down, hits cost of goods sold right away.
- 36:54Rachel Dauchy: The reason that we would need an external hub for inventory is because we would need a complexity of something like we do in QuickBooks Enterprise, where we're multi channel or, all kinds of different complexity.
- 37:11Rachel Dauchy: And now the advantage of that versus doing it in QuickBooks Enterprise, it's cloud based, and I can sink in all kinds of other stuff, and I can use reporting tools, and my client can be cloud based, and I can be cloud based, and that's where somebody like Matt can jump on this because he's an expert on all this cloud software and you don't have to remote into your client's desktop enterprise computer, which is not for me.
- 37:40Rachel Dauchy: That slows down my business.
- 37:42Rachel Dauchy: I can't really scale like if I'm using one provider like sin seven, like I can scale a lot better because I have everybody Feeding the data into qbo and i'm using something like since 7 where everybody goes on it.
- 37:55Rachel Dauchy: I use katana, too But for me as a firm owner, I don't have to spend all this time going into somebody's desktop computer So just wanted to address that really quick.
- 38:05Matthew Fulton: Are you familiar with fishbowl?
- 38:07Rachel Dauchy: Yeah, I do but fishbowl is also a desktop software that you would have to remote into They do have a cloud based solution right now, but it can't really do much, and it also can't be multi channel.
- 38:19Rachel Dauchy: The last time I talked to them, They told me that, but that might have changed by now.
- 38:24Rachel Dauchy: I can't be on a cloud based IMS that can only manage one channel.
- 38:28Rachel Dauchy: Something like SYN7 to me is perfect.
- 38:31Rachel Dauchy: You can dropship.
- 38:32Rachel Dauchy: You can also do holding an inventory.
- 38:35Rachel Dauchy: Something like Katana, you cannot drop ship.
- 38:38Rachel Dauchy: So it's a total workaround.
- 38:39Rachel Dauchy: There's just different advantages to other, to, to different cloud based
- 38:44Matthew Fulton: IMSs.
- 38:44Matthew Fulton: Part of the reason I was asking just real quick was Kate had asked in the questions about specific about Fishbowl and fulfillment.
- 38:52Matthew Fulton: Can COGS all be managed in Fishbowl?
- 38:55Matthew Fulton: Yes, it can.
- 38:56Matthew Fulton: Yeah.
- 38:56Matthew Fulton: And so
- 38:57Rachel Dauchy: The advantage of using an IMS.
- 39:00Rachel Dauchy: Is that the invoicing can go, is going from that platform and it just syncs all to QBO.
- 39:08Rachel Dauchy: And hey, guess what?
- 39:09Rachel Dauchy: If you don't want it to sync that way, you can bypass it with a connector like Cinder or Bookkeep or PayTracker or whatever.
- 39:16Rachel Dauchy: And then you can pull your COGS monthly from the IMS, post them to QuickBooks.
- 39:22Rachel Dauchy: And actually I'm training a client to do that later today.
- 39:25Rachel Dauchy: I'm working in Katana with them.
- 39:27Rachel Dauchy: And we actually bypass we post the revenue with Cinder.
- 39:31Rachel Dauchy: But because we don't want to be beholden to updating the cogs in Shopify all the time, we want them from the IMS.
- 39:38Rachel Dauchy: We're going to pull them from that and post them manually to QuickBooks Online.
- 39:43Rachel Dauchy: There's all kinds of different ways you can be creative and do it.
- 39:47Rachel Dauchy: And it really is based on their needs.
- 39:51Dan DeLong: Absolutely.
- 39:53Dan DeLong: So yeah, we can definitely probably spend the entire work power hour talking about your favorite topic.
- 40:00Dan DeLong: Yeah, for sure.
- 40:01Dan DeLong: And like
- 40:01Rachel Dauchy: somebody is saying, yes, you can do it in QuickBooks Enterprise, but I jumped onto QBO five years ago from, complex situations like SAP.
- 40:11Rachel Dauchy: I like the cloud Setup and so for me, all I do is get notifications all day long about how quick enterprise is No, no longer supported or I don't know what, but or maybe it's the pro and premier that are no longer being sold.
- 40:28Rachel Dauchy: And I don't know how long enterprise is going to be supported.
- 40:31Rachel Dauchy: If they're going to be doing updates, I don't know.
- 40:34Rachel Dauchy: And my business, I'm building it to, to scale and also to be a longterm business.
- 40:41Rachel Dauchy: I don't want to.
- 40:42Rachel Dauchy: I don't want to get myself involved in something that may be going away.
- 40:47Dan DeLong: Yeah, you just end up finding yourself a new solution in, or having this conversation, a little bit down the road.
- 40:54Rachel Dauchy: Yeah.
- 40:54Dan DeLong: I'm reminded of several political policies that do the same thing, where they just, oh, we'll just, Increase the debt ceiling.
- 41:01Rachel Dauchy: Yeah.
- 41:02Dan DeLong: Speaking of government policies, we've got sales tax considerations, which we had a really nice series with Avalara.
- 41:10Dan DeLong: They are probably the gold standard of of sales tax collecting remittance services.
- 41:16Dan DeLong: There are others that are out there but we're really unpack more things, that really involve.
- 41:21Dan DeLong: With sales tax, what do I sell?
- 41:23Dan DeLong: What kind of products do I actually sell?
- 41:25Dan DeLong: Is it services?
- 41:26Dan DeLong: Is it hard goods?
- 41:27Dan DeLong: Where do I sell it?
- 41:28Dan DeLong: Which un unlocks this.
- 41:30Dan DeLong: Specific topic of nexus and is really concerning or a concern for a for an e commerce seller selling across the lines of whether it's a physical nexus or an economic nexus who do I sell it to, right?
- 41:45Dan DeLong: Maybe they're wholesalers and they have a resell sales tax.
- 41:48Dan DeLong: Um, or a reseller certificate.
- 41:51Dan DeLong: That's the word I was looking for where they don't get charged sales tax.
- 41:55Dan DeLong: And then there's this other option of when do I sell it?
- 41:58Dan DeLong: Maybe it's during a sales tax holiday or something like that.
- 42:02Dan DeLong: So all of those things fall into this.
- 42:05Dan DeLong: Then diagram of, is it collecting sales tax?
- 42:07Dan DeLong: And then it's the amount of what do I have to collect?
- 42:11Dan DeLong: Is it a luxury item or food and beverage?
- 42:14Dan DeLong: The category of the item, all those go into that.
- 42:17Dan DeLong: In the essence of time, there's links there for the, for those workshops.
- 42:21Dan DeLong: You can get free access to these workshops and all the other workshops that we do at School of Bookkeeping.
- 42:26Dan DeLong: Those links are there in the slides.
- 42:29Dan DeLong: Shipping and fulfillment is another Workflow concern do they do that themselves or we talk about this idea of a 3PL with Unpack that for us Rachel.
- 42:41Rachel Dauchy: That means a third party logistics.
- 42:42Rachel Dauchy: So that's basically is somebody else housing and fulfilling their inventory for them and Oftentimes they'll arrange their shipping for them as well.
- 42:53Rachel Dauchy: And
- 42:55Dan DeLong: You mentioned dropshipping before.
- 42:57Rachel Dauchy: Yeah.
- 42:57Rachel Dauchy: Would
- 42:57Dan DeLong: a 3PL be considered a dropshipper if they are doing the selling?
- 43:02Rachel Dauchy: That's a really good question.
- 43:04Rachel Dauchy: I don't know if that's technically considered dropshipping because I think That is still, if it lives in the 3PL, it's still technically your inventory.
- 43:15Rachel Dauchy: No, I would say no.
- 43:17Rachel Dauchy: If it's on somebody else's balance sheet, that's technically dropshipping.
- 43:21Rachel Dauchy: I'm just grabbing that sale and then I'm accounting for the cost of goods sold at that time.
- 43:28Rachel Dauchy: That's usually how dropshippers do it.
- 43:30Rachel Dauchy: It's not any kind of periodic or perpetual inventory.
- 43:33Rachel Dauchy: But yeah, so a 3PL is basically when you get large enough, you want to house and ship your inventory.
- 43:43Rachel Dauchy: I used to work for a bottling facility and we used to have 3PLs in California, Texas and New York because obviously that cuts down on the shipping across the country.
- 43:54Rachel Dauchy: And so the order, depending on the ship address gets routed to whatever 3PL and then it ships from there.
- 44:03Rachel Dauchy: Now there's all kinds of integrated software that you, cloud based software that you can use for that like ShipStation.
- 44:10Rachel Dauchy: And that can be integrated into your IMS.
- 44:13Rachel Dauchy: So it knows where, when exactly it shipped.
- 44:18Rachel Dauchy: So that is actually accounting for the sale date.
- 44:22Rachel Dauchy: And so there's no confusion about that.
- 44:25Rachel Dauchy: So it's um, I'm really a big fan of, like I said before, cloud based everything, everything's set up on automation.
- 44:33Rachel Dauchy: So that way it's running in real time, very smoothly.
- 44:38Rachel Dauchy: And yeah, it takes a bit of time to really understand all these different moving pieces, but the accounting behind it is not that difficult.
- 44:48Rachel Dauchy: And if you really, just understand this basic okay, I'm buying goods and I'm putting them into inventory and I'm really only going to account for the cost.
- 45:00Rachel Dauchy: When the item is sold, then your sale posting is also going to have a COGS entry.
- 45:09Rachel Dauchy: And by the way, if you're tracking inventory in QuickBooks Online, that QuickBooks invoice also has a COGS entry when you have inventory turned on.
- 45:21Rachel Dauchy: If you are managing inventory in QuickBooks and anybody on this call, you're And you are doing it and it's working great and they have a simple enough situation.
- 45:30Rachel Dauchy: Look at one of those invoices, look at the transaction journal and you'll see that COGS entry that's posting along with it.
- 45:39Rachel Dauchy: It's really cool to understand the movements that are happening and you're recognizing that cost of goods sold on a true accrual basis, which is going to give you that P and L on an accrual basis, but you really need to track your cogs in the period that the item was sold.
- 46:01Rachel Dauchy: Because if you're buying all your inventory up front.
- 46:04Rachel Dauchy: In the beginning of one year, and then let's say you're slow all year, and then you sell everything the following year you want to make sure that you're recognizing the cost of goods sold in the time that it's sold, and that's really important for business intelligence.
- 46:20Rachel Dauchy: If you're just, hitting cogs right away with all your purchases.
- 46:23Rachel Dauchy: It's the quick and dirty easy way to do it, but I know people that have done it that way.
- 46:29Rachel Dauchy: Again, it just really depends on what they're selling and maybe is the stuff low cost and they just expense it right away and it's not really that big of a deal.
- 46:36Rachel Dauchy: It really just, like Dan and I always say, it just really depends.
- 46:40Rachel Dauchy: It just, Take a look at what they're selling, look it up online, do some research, look at, there's all kinds of inventory accounting resources out there.
- 46:50Rachel Dauchy: What you know I was just trying to think of that one like accounting Whatever 101 thing to look up and look like what does cogs mean?
- 46:58Rachel Dauchy: Just all these different things and you can get some information on that
- 47:03Dan DeLong: And just to touch loop back to shipping there is an option in quickbooks to be able to print your own shipping labels in inside of quickbooks online, but If you're not managing the sale in quickbooks online You're not going to be able to do that.
- 47:19Dan DeLong: So that's again, talking about the The priority of where is your inventory going to be living?
- 47:26Dan DeLong: And that's where you're going to be doing all of the other workflows.
- 47:30Dan DeLong: That's
- 47:30Rachel Dauchy: yeah and that's really important to know because I and i've talked to a lot of different providers about this And when my situation I use quickbooks to collect the data not necessarily do the stuff.
- 47:47Rachel Dauchy: I do the stuff You outside of QuickBooks, I then bring the data into QuickBooks.
- 47:53Rachel Dauchy: So I have a consolidated financial statement, right?
- 47:56Rachel Dauchy: So for people that are used to doing all the stuff in QuickBooks online, it might feel a little weird, that's what I'm saying is you can bring that sale into QuickBooks, have your sale, and then create a shipping label.
- 48:10Rachel Dauchy: It's really At this point, I pick and choose what do I want to do in QBO and or do I want to do anything in QBO?
- 48:19Rachel Dauchy: Do I just want to leave it as a bucket and just dump all the data in it?
- 48:24Rachel Dauchy: It's just, there's a lot of flexibility now of how do I want to do this?
- 48:29Rachel Dauchy: And it's really cool because you're not just, you don't have to do it a certain way, which is the way I thought when I first came into it, I thought I had to do it this way.
- 48:40Rachel Dauchy: The cloud gods were up there saying, you have to do it this way.
- 48:45Rachel Dauchy: Otherwise you're going to be penalized.
- 48:47Rachel Dauchy: And as long as you're following, the What, accounting rules, whatever, there's all kinds of different solutions that you can stumble onto and perfect.
- 48:56Rachel Dauchy: It's really neat.
- 48:58Dan DeLong: So we want to make sure that we cover, at least gloss over the rest of the topics here.
- 49:05Dan DeLong: So multi channel filling, this is like an omni channel where you're selling online a multiple outlet, where you've got this hybrid of selling in Shopify and Amazon, it's exponentially more complex as the image here here's the father, the expectant's father, he was expecting one baby, oh, now there's three at at the same time various payment methods across all of those sales channels, multi currency if they're selling in internationally, and then there's that four letter word of, PayPal.
- 49:41Dan DeLong: And then all of that boils down to how do I get my sales data into QuickBooks?
- 49:46Dan DeLong: We have these a variety of sales connectors that we call them or bridges.
- 49:51Dan DeLong: We're not quite sure exactly what the terminology of it all is.
- 49:54Dan DeLong: But we had we integrate on, we talk about.
- 49:57Dan DeLong: Comparison of Webgility versus Vendor and then there's Bookkeep and A2X that do summarize transactions.
- 50:05Dan DeLong: All of those things are unpacked in, in that as well.
- 50:09Dan DeLong: And then, Oh, there's this other thing.
- 50:11Dan DeLong: QuickBooks has its own connection.
- 50:13Dan DeLong: What about that, right?
- 50:14Dan DeLong: There's one thing that, you seamlessly connect your sales channels, there's there's a few yeah, buts.
- 50:20Dan DeLong: You can't use inventory when you're using these sales channel connectors in the commerce section of QuickBooks online.
- 50:27Dan DeLong: You've got a limited.
- 50:29Dan DeLong: Amount of sales channels to choose from and those sales post on payout.
- 50:34Dan DeLong: So if you,
- 50:36Rachel Dauchy: I think they created that just so they can say that they have it.
- 50:39Rachel Dauchy: I don't use those.
- 50:40Rachel Dauchy: Natia, have
- 50:41Dan DeLong: you have you gone down this rabbit hole inside of QuickBooks Online?
- 50:45Dan DeLong: No,
- 50:46Matthew Fulton: my I would not, no, it's not worth doing that.
- 50:49Matthew Fulton: It's getting on into a dark tunnel with the sound of a train coming and the train doesn't have a light on because you already know that you're going to get hit by something.
- 50:58Matthew Fulton: Pay at the thing I want to add on is paypal.
- 51:00Matthew Fulton: There should be no commingling of paypal ever if you're going to use paypal like
- 51:05Rachel Dauchy: Such a good point,
- 51:05Matthew Fulton: right?
- 51:06Matthew Fulton: if you really have to do it set up different paypal accounts for other personal stuff, but
- 51:14Dan DeLong: So we we talk about the there's one size fits all Doesn't fit all like for all of your sales connector needs, right?
- 51:21Dan DeLong: Maybe you have a client who's only in Shopify and they want that detail inside of QuickBooks reintegrate is actually a really good solution for them.
- 51:29Dan DeLong: Their price point is significantly less than something like a Cinder or WebGility if they're only using Shopify if you're not needing the sales detail, Bookkeep is a fantastic place to Sales connector to bring in those and split the sale versus the payout and reconcile those two So we talk about the pros and cons of each one
- 51:51Matthew Fulton: one thing i'm
- 51:51Dan DeLong: working
- 51:52Matthew Fulton: Go ahead one thing on this real quickly when you're able to use a software that's going to do either sales receiver or an invoice You can actually take advantage of bundles and you can bundle things in and get more metrics from reporting as a sneaky way.
- 52:08Matthew Fulton: And you can't do that when journal entries are being used.
- 52:12Matthew Fulton: Just food for thought.
- 52:13Rachel Dauchy: Yeah.
- 52:13Rachel Dauchy: And just to also say, Cinder does either journal entries or sales transactions.
- 52:21Rachel Dauchy: And with the sales transactions, you can do either sales receipt or invoice.
- 52:27Dan DeLong: We'll launch the last poll question as we're talking through the last last thing here.
- 52:32Dan DeLong: Obviously, this is just touching on the surface of some of these topics and it, and they do get into the weeds really quickly as we've as we've been able to unpack just in, in this hour.
- 52:45Dan DeLong: So we've unpacked those, expanded them, made them easier to consume.
- 52:49Dan DeLong: We tried to take each topic.
- 52:52Dan DeLong: And turn it into at most five minutes, a five minute discussion.
- 52:56Dan DeLong: You can go into these courses and these lessons, ask questions in the comments.
- 53:01Dan DeLong: We'll answer them.
- 53:02Dan DeLong: There is a community in, in there outside of the social media spectrum where you can ask more specific questions as well.
- 53:10Dan DeLong: And then there's options of mentorship.
- 53:13Dan DeLong: Hey I want to.
- 53:14Dan DeLong: Go right in, I've got this client and I need to, I need some help sorting through some of these things.
- 53:19Dan DeLong: We've got that there as well.
- 53:21Dan DeLong: And you'll also have access to that managing inventory course as well.
- 53:24Dan DeLong: We have a 30 day free trial needs a promo code, a work, you'd be power, our users, all that great stuff there.
- 53:31Dan DeLong: Yeah.
- 53:31Dan DeLong: And I'm a member of that
- 53:34Rachel Dauchy: school of bookkeeping community too.
- 53:35Rachel Dauchy: And I've gotten more involved in the community and answering questions and stuff.
- 53:39Rachel Dauchy: So it's really cool.
- 53:42Dan DeLong: All right, so we did launch the poll question there and it looks like a lot of people got some good information here.
- 53:48Dan DeLong: I did want to answer one question live and I flagged it.
- 53:52Dan DeLong: Where did it go?
- 53:53Dan DeLong: The question was
- 53:54Matthew Fulton: by Wayne, who said, My client primarily sells via website, but he has added marketplaces like Amazon.
- 53:59Matthew Fulton: Shopify has a process to manage the marketplace within Shopify.
- 54:03Matthew Fulton: So is it good to let Shopify manage this, or is there an app that should be in the middle instead?
- 54:09Dan DeLong: Yeah.
- 54:10Dan DeLong: That's that's a it's depends answer, right?
- 54:13Dan DeLong: Because bringing that into into shop in those Amazon sales into Shopify.
- 54:18Dan DeLong: The question is what's going to happen with the payout regarding his Amazon sales?
- 54:24Dan DeLong: Because as we.
- 54:26Dan DeLong: As you understand with Amazon, the payout is significantly delayed when it comes to that, that particular marketplace.
- 54:34Dan DeLong: And of course they throw out all the fees.
- 54:37Dan DeLong: The storage fees, the I looked at this transaction fee.
- 54:40Dan DeLong: I I made this be so complicated.
- 54:43Dan DeLong: You don't argue when you contact Amazon seller central.
- 54:47Dan DeLong: All of those fees are thrown in there and those come two weeks later.
- 54:52Dan DeLong: And Oh, and then you also have refunds and returns and all of those things.
- 54:56Dan DeLong: That is probably not going to be as detail oriented by bringing that sale into Shopify.
- 55:03Dan DeLong: And then trying to reconcile that sale to the payout is going to be significantly harder by just bringing the sale into the Shopify Ecosystem and then bringing that into into QuickBooks.
- 55:17Dan DeLong: That's going to be a complicated answer.
- 55:20Dan DeLong: You probably want to keep those things separate and keep those things and clearing with a separate clearing account.
- 55:25Dan DeLong: I
- 55:27Rachel Dauchy: know Amazon has the ability to do that now, bring it into Shopify.
- 55:31Rachel Dauchy: So then you can manage your inventory within Shopify using something like Stocky.
- 55:35Rachel Dauchy: I would use an IMS over that.
- 55:38Dan DeLong: Especially when you have that additional complication of multiple sales channels.
- 55:43Dan DeLong: Keeping those separate and maybe in something else.
- 55:46Dan DeLong: And other people were using, Fishbowl as a route to do that.
- 55:50Dan DeLong: Keeping those outside of that.
- 55:51Dan DeLong: So we appreciate you all joining us here today.
- 55:53Dan DeLong: We did talk a lot about some of the specific nuances of E commerce Rachel, appreciate you joining us today.
- 56:02Dan DeLong: You're a wealth of knowledge in this area and Matthew I appreciate you and your insights as well.
- 56:08Dan DeLong: Any closing thoughts Matthew on what we talked about today?
- 56:12Matthew Fulton: No, I have, it's fun being up here and still actually being in listening and learning mode.
- 56:18Matthew Fulton: It's why I still attend these myself all the time.
- 56:20Matthew Fulton: There's so much that I can learn.
- 56:22Matthew Fulton: And I learned about Dan's uncle.
- 56:24Dan DeLong: Yeah, that's the uncle that always shows up at the holiday dinner.
- 56:28Dan DeLong: You're not quite sure what's going to happen with Amazon, it's probably, you're not probably going to like it.
- 56:34Dan DeLong: All right.
- 56:34Dan DeLong: So we will see you all next time on the QB power hour.
- 56:37Dan DeLong: And if you're so inclined to join us tomorrow on the workshop Wednesday, we'll talk more with Rachel.
- 56:43Dan DeLong: Then with, we're actually comparing QuickBooks enterprise, the desktop enterprise to a cloud based solution of Katana.
- 56:50Dan DeLong: So join us tomorrow.
- 56:52Rachel Dauchy: So much more things now that they used to have.
- 56:56Matthew Fulton: And
- 56:57Dan DeLong: thank you to
- 56:57Matthew Fulton: Makers Hub also, right?
- 56:59Dan DeLong: Yes, absolutely.
- 57:01Dan DeLong: And we'll see you next time on the QB Power.
- 57:03Dan DeLong: Everybody have a great day.