Latest / QB Power Hour Podcast / 03.13.24 - Shopify Connectors - Which to Choose? w/ Guest WeIntegrate
Transcript
- 0:31Dan DeLong: All right.
- 0:31Dan DeLong: Welcome to another QB power hour, where today we're going to be talking about Shopify integrations, which wants to choose, say, if you ever have looked at the app store or that burning question of my client has Shopify.
- 0:44Dan DeLong: I don't wanna get that into QuickBooks Online.
- 0:47Dan DeLong: Um, this is the webinar for you, because we'll be talking about some of the things that are already in QuickBooks online and some of the things that are out there.
- 0:56Dan DeLong: If you've ever looked at the app door and done a Shopify, keyword search for Shopify and see that there's quite a few Shopify connectors out there.
- 1:05Dan DeLong: It is.
- 1:06Dan DeLong: Quite complicated as to determine which one works best, right?
- 1:12Dan DeLong: So Michelle,
- 1:12good to see
- 1:14Dan DeLong: you.
- 1:14Dan DeLong: Good
- 1:14Michelle Long: to see you.
- 1:16Michelle Long: Yes.
- 1:17Michelle Long: Hey, it's a nice sunny spring day.
- 1:20Michelle Long: So I am looking forward to Doing this because it is confusing when you look out there and you see all those different apps.
- 1:26Michelle Long: So I think I love this because I don't know about some of you people but I get analysis paralysis and it gets You spend a lot of time going in there and analyzing them So i'm very excited about this today and glad to have you guys joining it.
- 1:39Michelle Long: So my name is michelle long I am a cca and i'm the owner of long for success And glad to have you all joining us been a contract trainer for intuit since 2007 author of five different books Check them out if you're interested And there's the links to the group on Facebook, as well as LinkedIn.
- 1:56Michelle Long: And love to have you guys join us there and continue the conversation.
- 2:00Michelle Long: Dan, go ahead.
- 2:02Dan DeLong: Yeah.
- 2:02Dan DeLong: My name is Dan DeLong owner of Danwith where we transform businesses through technology.
- 2:06Dan DeLong: And part of that is connecting their.
- 2:09Dan DeLong: QuickBooks online with their Shopify.
- 2:11Dan DeLong: And really glad to have Marc and Gennady here from WeIntegrate to talk about their solution.
- 2:16Dan DeLong: Worked at Intuit for nearly 18 years, co hosting today as also the co host at Workshop Wednesdays over at School of Bookkeeping and doing some of the tech editing duties at the, or for the QBO for Dummies series of books.
- 2:31Dan DeLong: So Marc and Gennady, you want to Introduce your panel.
- 2:33Dan DeLong: It looked like you're, you brought a whole list of folks
- 2:36today.
- 2:38Marc Kalman: Absolutely.
- 2:39Marc Kalman: Absolutely.
- 2:39Marc Kalman: And thanks Dan and Michelle for having us today.
- 2:41Marc Kalman: We're really excited to share how we integrate Shopify with QuickBooks online, if you've heard how I did that.
- 2:47Marc Kalman: But I am Marc Kalman.
- 2:48Marc Kalman: I'm one of the co founders here and I've been involved with SAS based operation and inventory warehousing accounting systems for over 20 years focusing on the small business Marcet.
- 3:00Marc Kalman: And we saw a real big need here in helping automate the bookkeeping process between systems such as Shopify and QuickBooks online.
- 3:08Marc Kalman: And.
- 3:08Marc Kalman: We integrate.
- 3:10Marc Kalman: So Gennady, would you like to take your turn?
- 3:12Gennady Kleyner: Yes.
- 3:12Gennady Kleyner: Thank you for that.
- 3:13Gennady Kleyner: Marc and Dan and Michelle, thanks for having us.
- 3:15Gennady Kleyner: My name is Gennady Kleiner.
- 3:16Gennady Kleyner: I'm responsible for the technology for we integrate and a co founder.
- 3:22Gennady Kleyner: I have over 25 years working with the various size organizations.
- 3:27Gennady Kleyner: From small to large integrating various types of systems and have been using QuickBooks probably since the early 90s.
- 3:36Gennady Kleyner: I would say at this point.
- 3:37Gennady Kleyner: So very near and dear to the pains that folks are going through.
- 3:43Dan DeLong: All right thanks for joining us.
- 3:44Dan DeLong: And then you've got Randy.
- 3:46Dan DeLong: He's not with us today, but I want to talk a little bit about your relationship with Randy.
- 3:51Dan DeLong: Johnston
- 3:52Marc Kalman: Yeah, absolutely.
- 3:53Marc Kalman: So we had the fortune of connecting with Randy maybe about a year or so ago.
- 3:58Marc Kalman: And initially it was just to see if he would be interested in writing up some stuff on us.
- 4:02Marc Kalman: I found him Through the CPA periodically that he affiliates with and in conversations we had he just was like really into what we're doing and thought we're taking a really unique approach, compared to some of the other systems out there doing and, just became a real big gel.
- 4:16Marc Kalman: So he joined our advisory board.
- 4:18Marc Kalman: He's actively participates.
- 4:20Marc Kalman: And giving us, guidance and stuff and we have, calls all the time and opportunities to really help take his experience and blend that into what we're bringing to Marcet.
- 4:30Dan DeLong: Yeah, it's always good to see a familiar face with a new player in the Marcet.
- 4:33Dan DeLong: So great to see you and Randy teaming up there.
- 4:38Dan DeLong: So the little details about the QB power hour it's every other Tuesday at noon Eastern.
- 4:42Dan DeLong: You never know where we're going to be.
- 4:44Dan DeLong: I am somewhere in Georgia driving up the I 95 corridor, live from Cracker Barrel Cracker Barrel parking lot today.
- 4:54Dan DeLong: But you can always check out our website for upcoming events.
- 4:58Dan DeLong: As well as go to qbpowerhour.
- 5:00Dan DeLong: com slash resources for the PDFs of the slides recordings and the podcast.
- 5:05Dan DeLong: And if you are listening to the podcast and you feel like that is worthwhile for others, please put a review in for the podcast, because that's what.
- 5:14Dan DeLong: Triggers the whole algorithm thing.
- 5:16Dan DeLong: So appreciate you putting in a review for the podcast because we do have several folks listening as a replay.
- 5:24Dan DeLong: I'm not sure if they just like hearing our voices.
- 5:26Dan DeLong: Michelle after the fact, because it is really hard to look at slides.
- 5:31Dan DeLong: When you're on the, when you're listening on your Apple podcast or wherever you get your podcast from, but if you could put in a review that would really help us out letting us getting that information to other folks if you have a little housekeeping, if you have some questions about the specific topics that we're talking about there today, we'd please put them in the Q& A because it makes it real, a lot easier for us to to follow up with that.
- 5:56Dan DeLong: If you have general comments we have the chat available for that and Gennady will be handling some of the Q& A and chat duties for the WeIntegrate side of things.
- 6:06Dan DeLong: Please keep them on a still, no, I'm kidding.
- 6:09Dan DeLong: Please put those specific questions in the Q& A but if you have general, general comments about Cracker Barrel or the I 95 corridor, please put them in the chat.
- 6:20Dan DeLong: We also have the links there for the for the webinar archives.
- 6:24Dan DeLong: So you can watch other replays as well.
- 6:27Dan DeLong: So something that's new for the QB power hour is we're trying to simulcast and get get more folks the ability to see and participate in the power hour rather than just doing it through this through this webinar format.
- 6:41Dan DeLong: So we're simulcasting on our Facebook group inside of YouTube as well as LinkedIn.
- 6:45Dan DeLong: There's no need to register but the challenge is you can't really participate as much as you can if you register on, on the zoom zoom webinar, but.
- 6:54Dan DeLong: If you're, if you just be happen happening to pop by and you want to watch a great, that certainly is okay.
- 7:02Dan DeLong: There is a QR code on this screen because of, oops, I'm trying to remove it off of the the simulcast, but I can see it's like a.
- 7:11Dan DeLong: There's two on what, what's going on YouTube and Facebook.
- 7:15Dan DeLong: There's two two QR codes.
- 7:17Dan DeLong: But because our Facebook group is the privacy settings are private, right?
- 7:22Dan DeLong: So not everybody can see these global posts and whatnot.
- 7:25Dan DeLong: If you participate in the comments there on the group.
- 7:30Dan DeLong: It will just show up as Facebook user, which is just exactly somebody said that these very same thing.
- 7:36Dan DeLong: They said hello, but it says Facebook user.
- 7:39Dan DeLong: So we have no idea what that, who that person is, if we wanted to follow up, but You can scan the QR code and it will allow us to be able to, or allow Facebook to see you or the streaming platform just to, to see your name so that we can see who's commenting and and be able to address you by name rather than Mr.
- 8:00Dan DeLong: Facebook user.
- 8:02Dan DeLong: And let's go ahead and stop that.
- 8:04Dan DeLong: Okay.
- 8:04Dan DeLong: Perfect.
- 8:05Dan DeLong: Another thing for 2024 is We're taking a stab at a store and michelle and I we do this out of the kindness of our heart there are expenses and things like that where they go along with with doing this sort of thing so to help help us out.
- 8:19Dan DeLong: We appreciate you want to check out some of the store items that we have on online, not using shopping we have some time and electricity based swag there.
- 8:28Dan DeLong: So chargers and coffee mugs and those types of things to be able to show your love for for the power hour, get out if you feel so inclined.
- 8:38Dan DeLong: Thank you.
- 8:39Dan DeLong: And Michelle and I are nominated among other folks for the top 100 this year.
- 8:45Dan DeLong: Voting is open.
- 8:47Dan DeLong: So please if you are so inclined, please click on the link there and vote for up to three.
- 8:52Dan DeLong: You've got an extra vote there.
- 8:53Dan DeLong: If you're sharing the love for Hill and I that'd be great.
- 8:56Dan DeLong: You still have one other but there's a lot of people that come to QB Power Hour who are among this list it's it's a pretty nice yearly, yearly thing.
- 9:05Dan DeLong: And, we hope to see some new faces as well in this list.
- 9:09Dan DeLong: So our agenda today we're going to, we're going to set the stage for the options for Shopify sellers, right?
- 9:16Dan DeLong: There are, when it comes to getting Shopify information into QuickBooks there's choices about detailed information or summary.
- 9:25Dan DeLong: And that really just depends, knowing having the answer to that question will certainly help guide.
- 9:31Dan DeLong: In these myriad of questions or myriad of options that are out there, we'll talk about the Shopify connector inside of QuickBooks because it certainly is important for those in the accounting profession to at least know that it's there and the idea of what it does well, what it doesn't do so well.
- 9:51Dan DeLong: And where it fits what lane it, it basically occupies in the Shopify online QuickBooks online space.
- 9:59Dan DeLong: And then we'll talk about we integrate, for, because typically what we'll see with anything that, that that is in QuickBooks directly is it does the short, the shallow end of the pool, right?
- 10:11Dan DeLong: It does a little bit well.
- 10:13Dan DeLong: But typically most people are looking for more than what that does.
- 10:17Dan DeLong: And then that extends the search to what, what else is out there.
- 10:21Dan DeLong: And as Michelle had mentioned, the analysis paralysis of, trying to find the right the right fit for what it is that I want to, that we wanna do.
- 10:32Dan DeLong: And we'll talk about what we integrate does well over the Shopify connector.
- 10:37Dan DeLong: So we'll start off with our first poll question.
- 10:41Dan DeLong: Which is not on my screen.
- 10:43Dan DeLong: There it is how many clients do you have shopify stores, right?
- 10:49Dan DeLong: So this is this is a fairly common Situation when it comes to the shopify and Marcer wanted to toss a question over to you while people are asking here what have you seen as far as you know you start you're starting with shopify as your sales channel connector and you know your game plan is You know to go to other connectors, but why Shopify first?
- 11:13Marc Kalman: Yeah.
- 11:13Marc Kalman: Because when we would run such surveys like this overwhelmingly anywhere from 50 to 70 percent of the need was focused on Shopify.
- 11:23Marc Kalman: Obviously that's not the only factor that would go into such a decision, but we also saw that, from our perspective and our experiences and the conversations we had with.
- 11:31Marc Kalman: Bookkeepers and accounting professionals that were working in that space.
- 11:35Marc Kalman: Um, Shopify is easy to use, so people gravitate to it.
- 11:39Marc Kalman: But their thoughts around integration seemed to be that there were some systems out there, but it wasn't, quite the fit they were looking for.
- 11:46Marc Kalman: So we saw a bit of a problem that was causing people aggravation and an opportunity that was 50 to 70 percent of the Marcet.
- 11:55Dan DeLong: We're taking a look at the sharing the results here.
- 11:59Dan DeLong: It looks like of their clientele majority is less than 25%, but then those with none is about 30, 33%.
- 12:08Dan DeLong: I would be curious how how that stacks up against others, as far as, other sales channels like Amazon, eBay, and, those types of things.
- 12:16Dan DeLong: But yeah it seems to be.
- 12:19Dan DeLong: The most common, online Marcetplace to work with they do a really good job of Marceting.
- 12:25Dan DeLong: But it's certainly one of those things that, that people see first.
- 12:30Dan DeLong: In general, Marc what is the, what, what's the attraction of Shopify, other than the fact that, that's what, Other people seem to use
- 12:40Marc Kalman: well, I mean it is easy to get started, you know when you look at some of the other e commerce platforms that are out there some take a little bit more tech savvy, you know to your fingertips and your thought process to set up, we've looked at some others but shopify is easy.
- 12:54Marc Kalman: It's a single thread environment nice platform to kick off It's affordable, you know for the most part and just makes it a great starting point for many e commerce businesses that are just getting started, like the Marcet shifting, right?
- 13:06Marc Kalman: A lot of people are, getting tired of their day job or working to supplement themselves, particularly in this economic condition here.
- 13:12Marc Kalman: And you find that, it's a great way to have a side hustle.
- 13:16Marc Kalman: We're also seeing a lot of folks in Amazon, which is probably one of the areas we're going next.
- 13:20Marc Kalman: Another cool thing about Shopify, too, by the way, is they have these connectors now that you connect into these different Marcetplaces such as Amazon and Facebook.
- 13:29Marc Kalman: So it becomes a one stop shop for everything.
- 13:32Dan DeLong: Gotcha.
- 13:33Dan DeLong: Excellent.
- 13:34Dan DeLong: So let me go ahead and stop sharing there on the poll.
- 13:38Dan DeLong: Yeah, so let's talk a little bit about.
- 13:40Dan DeLong: Those connectors and the common question.
- 13:43Dan DeLong: And when I worked at Intuit, this was still, a common question, but there's, it's almost information overload, when it comes to, it's a simple question.
- 13:54Dan DeLong: How do I get my Shopify information into QuickBooks online?
- 13:57Dan DeLong: And every one of them, you go to the app store and go to, apps.
- 14:02Dan DeLong: com or apps.
- 14:02Dan DeLong: com.
- 14:04Dan DeLong: Yeah, QuickBooks online, the app center and do a search for Shopify.
- 14:09Dan DeLong: You can see, I just did one and it was 38 results for for something with having to deal with Shopify.
- 14:17Dan DeLong: All of them say seamless integration.
- 14:20Dan DeLong: But which one to choose?
- 14:22Dan DeLong: We partner also with bookkeep, as a Shopify connection or a connector of information to into QuickBooks, but they do things entirely different than you did.
- 14:34Dan DeLong: So like there, there's a difference in, in how these things are going to come in.
- 14:39Dan DeLong: You can see here, there's a A2X on this on the, on this screen and they're in the They're in the bookkeep A2X realm where their information comes in but they, it comes in as a journal entry where the journal entry method is, that's going to have some limitations with what you do in your workflows after, the integration, after that information comes in, yeah it'll post, Correctly to the right general ledger account.
- 15:10Dan DeLong: But the challenges and we'll talk to this a little bit when we get to, deeper dive into the, we integrate piece of things is that there's workflows that you're not able to do because of the way things are coming in into QuickBooks online Michelle I've been monopolizing most of the conversation is this.
- 15:30Dan DeLong: Something that you've experienced over with working with with consulting with businesses as far as, this kind of question of getting things into into QuickBooks from Shopify.
- 15:42Michelle Long: I wasn't listening very closely.
- 15:44Michelle Long: Sorry.
- 15:45Michelle Long: I was trying to help someone.
- 15:47Michelle Long: I'm sorry.
- 15:47Michelle Long: I was trying to help someone troubleshoot with them.
- 15:50Michelle Long: Allow pop ups to do the poll questions and stuff, but I did hear what you were saying about how they all say seamless and how they don't all come in correctly.
- 15:58Michelle Long: I was listening to some of it.
- 16:00Michelle Long: And that is the thing that's really frustrating for me.
- 16:02Michelle Long: And it is difficult to do that and to do the testing to see how they all come over and they don't all come over.
- 16:09Michelle Long: seamlessly and they don't all come over cleanly or the way that you want them to.
- 16:14Michelle Long: And that is what's very frustrating for me when I get in there because This is where desktop is definitely got the advantage.
- 16:22Michelle Long: It was much easier to do testing and have a testing environment and stuff than it is with QuickBooks online.
- 16:28Michelle Long: It, even if you've got that backup feature with some of those apps that you can use to where you can do some of that, it's just not as easy in the online route.
- 16:37Michelle Long: And so that's why I like what we're doing here today, talking about this with we integrate and everything, because that really helps us to cut through all the clutter of the 38 revolts out here and cut to the chase and get,
- 16:50Dan DeLong: and those are the ones that are just on the app store, right?
- 16:53Dan DeLong: There's plenty of others that are, like under the table.
- 16:58Michelle Long: Yes, if you look at all of them, then you have 138, so that's why I'm glad we have, we integrate here to get through all of this for us and get to cut through the chase and cut through the clutter and get to what really works and what really integrates well and cut through some of that for us,
- 17:17Dan DeLong: yeah.
- 17:17Dan DeLong: And I certainly understand appreciate Marc, all of the integrate puns that we can throw with the name of your company, right?
- 17:24Dan DeLong: And we do as well.
- 17:25Dan DeLong: Thank you.
- 17:27Dan DeLong: That's my design.
- 17:29Dan DeLong: Yeah.
- 17:31I
- 17:31Dan DeLong: appreciate that.
- 17:32Dan DeLong: And Janice was talking in the chat here about having an issue with Shopify holding accounts and clearing accounts, and that seems to be one of the things that.
- 17:43Dan DeLong: That is part of the challenge with getting information from, an online sales channel into QuickBooks, because there is this delay, right?
- 17:54Dan DeLong: There's a delay between the time that things are sold.
- 17:57Dan DeLong: And then there's a, from the time when money shows up in the bank, which, is the grand scheme in the grand scheme of things is, Accrual based, right?
- 18:08Dan DeLong: Wide, right?
- 18:08Dan DeLong: Even if it's just, invoices and then payments Do your, for your customers, there's a gap in time.
- 18:15Dan DeLong: And then if you're doing electronic payments of some sort with those in invoice payments, that will take some time before it actually shows up into the bank.
- 18:24Dan DeLong: So to Janice's point, or her question in the chat here is that holding or clearing accounts has been the answer for most of these connectors when you're dealing with.
- 18:37Dan DeLong: Okay.
- 18:37Dan DeLong: How do I deal, how do I get the sale in there into QuickBooks?
- 18:41Dan DeLong: And then the, days later the payout is going to come.
- 18:45Dan DeLong: And then, on a side note, if you're dealing with Amazon, that could be two weeks from the time of the sale.
- 18:51Dan DeLong: So you've got this passage of time that you have to account for when it comes to, money coming into the bank.
- 18:59Dan DeLong: sales of things that, that happen.
- 19:02Dan DeLong: And there's other things that happen with that sale, like shipping and fees and all sorts of other things that people just tend to say screw it.
- 19:12Dan DeLong: I'll just account for everything in the bank feed.
- 19:14Dan DeLong: And Michelle that's not, that's a no, right?
- 19:18Michelle Long: Not to mention possible chargebacks or any of those things that can be thrown in there.
- 19:23Michelle Long: So it can get really messy.
- 19:26Michelle Long: Yeah, it gets really quickly.
- 19:30Dan DeLong: Messy is probably the nicest way to describe it.
- 19:34Michelle Long: Yeah, I'm trying to keep it PG here.
- 19:36Michelle Long: When
- 19:37we spoke
- 19:37Gennady Kleyner: to So far, it's another common
- 19:40Michelle Long: term you hear.
- 19:41Michelle Long: When we spoke
- 19:42Gennady Kleyner: to many accountants when we were designing this, there was a Line in the sand that was drawn and some folks said, we live and die by journal entries and are the said no, we can't have that.
- 19:53Gennady Kleyner: We need to know exactly what's happening.
- 19:55Gennady Kleyner: And so even the holdouts with the journal entries when we showed them when we create actual sales receipts.
- 20:03Gennady Kleyner: When we create actual deposits when we create actual refunds, there's no needle in the haystack.
- 20:09Gennady Kleyner: And so we don't require those clearing accounts as a result.
- 20:12Gennady Kleyner: And life has become so much simpler for
- 20:14folks.
- 20:17Dan DeLong: Yeah, this is great.
- 20:19Dan DeLong: Let's talk a little bit about what's included in the QuickBooks Commerce Connector which, if we go back to the last slide, it's the 1st 1 there.
- 20:27Dan DeLong: Go figure on how into its connector Gets top billing there when you when you do that, but you can see it's got two and a half stars as far as the as far as the rating is concerned with 280 reviews look at some of these other ones.
- 20:41Dan DeLong: There's much more high and there's higher results of that and that sort of thing but as far as the what's included inside of Commerce the commerce connector, which is we've done a few QB power hours in the past, and we'll have links to those as well, if you're like, what the heck is commerce but commerce is included based on the level of QuickBooks online.
- 21:01Dan DeLong: So with regards to how many connectors you can have, which currently they only have three connectors available which is silly that plus in advance is unlimited, but they're.
- 21:15Dan DeLong: That's a future that's a future based thing, they're definitely looking into other connectors as well on the road map but shopify amazon and ebay, which is like the greatest hits of Online sales channels and they all handle things differently.
- 21:31Dan DeLong: Shopify being a an online Shopping cart, Amazon being a Marcetplace and eBay being like the American Express of shopping carts.
- 21:42Dan DeLong: They do things on their own method.
- 21:44Dan DeLong: They could be a shopping cart, but they're also a Marcetplace as well.
- 21:49Dan DeLong: So they're like a hybrid type of thing.
- 21:51Dan DeLong: So you, with SimpleThread you get one, Essentials you get up to three, and then Plus and Advanced is unlimited connections.
- 22:00Dan DeLong: All right.
- 22:00Dan DeLong: So in the past, we had the QB Commerce connection power hours.
- 22:05Dan DeLong: We had Aaron Walsh Dyer talking with us a little bit about that last year.
- 22:10Dan DeLong: And then we also had the folks from QB Commerce.
- 22:14Dan DeLong: Come on last year and talk about the future of it.
- 22:17Dan DeLong: That was what more than nine months ago, and I haven't seen much more change to be quite on.
- 22:25Dan DeLong: So it's a slow boat as far as the future getting now, but there are some things that are coming in the future with QB farmers that are cool, like variants, right?
- 22:35Dan DeLong: And this will be part of the.
- 22:38Dan DeLong: Products and services with coming into your list of being able to actually do variances.
- 22:44Dan DeLong: Now there was a hint of sales orders coming in and this is all part of in service to, the this solution, being able to do these things, but they're not there yet.
- 22:56Dan DeLong: So that's you can take a look at those things as well, but here's what it does and what it does pretty well.
- 23:01Dan DeLong: It records sales and refunds.
- 23:04Dan DeLong: It records the payout deposit, it records the channel fees, it records shipping income, and then it also allows you to enter in sales tax because it's actually creating a sales transaction inside of QUIC.
- 23:19Dan DeLong: So you can look at, there's going to be an overview, there's there's orders and there's payouts, right?
- 23:25Dan DeLong: So that you'll see those different things.
- 23:28Dan DeLong: Being able to those different areas of your connector being able to be brought in into into QuickBooks.
- 23:34Dan DeLong: What doesn't it do, right?
- 23:36Dan DeLong: It won't track inventory, right?
- 23:38Dan DeLong: So even though you're selling things on Shopify and those may be inventory items, the transactions that come into QuickBooks aren't.
- 23:49Dan DeLong: Based on an item, right?
- 23:52Dan DeLong: That may be a future state, but as of today it does not, right?
- 23:56Dan DeLong: So those sales that are going to be recorded.
- 23:59Dan DeLong: Yes, they're sales and they're in affecting sales tags You're only going to have one sales item that you can map that to in the setting So that means all of your sales are going to one sales item inside of QuickBooks Now you'll see the order And there may be some reference to what would actually have been sold, but in the memo, for example, or the detailed description, but the actual item that's going to be posting to is going to be mapped in the settings and therefore you only will have that one item to be able to use, right?
- 24:36Dan DeLong: I was testing this out before, last week.
- 24:39Dan DeLong: I have a client who's using he was testing out.
- 24:41Dan DeLong: We integrate with.
- 24:43Dan DeLong: The Shopify connector and some other ones that are out there.
- 24:46Dan DeLong: We won't mention and we were We had it.
- 24:50Dan DeLong: I tried to have it mapped to an inventory account and those things wouldn't post right because it said hey You can't do that.
- 24:57Dan DeLong: And he only had one item for sale So it was like hey, this is perfect because I can choose the one item That's the inventory item.
- 25:04Dan DeLong: But as soon as you choose an inventory part as a sales item those orders then don't post.
- 25:09Dan DeLong: So you won't be able to track inventory inside of QuickBooks online.
- 25:14Dan DeLong: And maybe that's what you want, right?
- 25:16Dan DeLong: Not being able to track, track inventory.
- 25:19Dan DeLong: And if that, is where your client's workflow exists, maybe they're doing it entirely in Shopify.
- 25:25Dan DeLong: And then you're just managing the information in QuickBooks.
- 25:29Dan DeLong: That's a possibility to be able to do that.
- 25:32Dan DeLong: Another big challenge is that the sales are going to be recorded on the date of the payout.
- 25:38Dan DeLong: Terrible.
- 25:39Dan DeLong: That's a, if you're wanting to account for the revenue, then great.
- 25:45Dan DeLong: Do it on the day that it was actually sold.
- 25:49Dan DeLong: Michelle, would you agree that is, that's like a, I
- 25:54Michelle Long: agree.
- 25:54Michelle Long: And the other big thing I have a problem with the QB Commerce is the cost of control.
- 26:00Michelle Long: It's it's missing, you don't account for the cost.
- 26:04Michelle Long: And so QB Commerce is a great, like the one.
- 26:08Michelle Long: It has a lot of room for growth and improvement.
- 26:12Michelle Long: But, change is slow, as you said on there.
- 26:16Dan DeLong: The things that that we've been the horizon.
- 26:19Dan DeLong: And, Marc, you can probably attest to, yeah we'd love to do all these things all at once.
- 26:24Dan DeLong: But, there, there is a, no, there's a process, to, to making these things come in that, I think the best way that I I heard it described as code or programming code is like a ball of rubber bands, right?
- 26:38Dan DeLong: And you don't know what you're going to be modifying when you go into and change that code.
- 26:45Dan DeLong: And maybe it's in the middle of the ball and you got to take all of the other rubber bands off.
- 26:49Dan DeLong: In order to fix one thing and then you got to put all those rubber bands back in the exact same way or else You've got a mess on your hands which is part of the challenge of making, changes to Basically a live product when you're dealing with a with an online That's based software, right?
- 27:06Dan DeLong: So that change has been coming, pretty slow with regards to the commerce connection, right?
- 27:13Dan DeLong: So let's go ahead and launch our next poll of do you have clients using the commerce accounting or QB commerce or on the left side you've got that commerce option.
- 27:25Dan DeLong: Do you have clients using that?
- 27:27Michelle Long: Have you come across any clients using this, Dan?
- 27:30Dan DeLong: Yeah, I've been curious as to what it looks like.
- 27:32Dan DeLong: I've been using it mostly For testing purposes, just to see, what it does and what it does well.
- 27:38Dan DeLong: And, there may be a lane that, that a client is driving through that uses that, which is okay.
- 27:46Dan DeLong: But typically you're going to find that be the shallow end of the pool when it comes to that sort of thing.
- 27:54Michelle Long: Yeah.
- 27:54Michelle Long: I haven't.
- 27:56Michelle Long: Had a client using it and I definitely haven't had a reason to recommend it.
- 28:01Michelle Long: Yeah
- 28:01Dan DeLong: The one one thing this is off topic with amazon one of the things about amazon and amazon is a unique individual Unique situation altogether, like completely different than a shopping cart uh, like shopify but amazon Will will basically impound your fee or pounder, basically everything's a fee, but they'll impound your your money, and basically hold onto your money for two weeks and then every 14 days is when they do a deposit.
- 28:34Dan DeLong: One thing that, that I did like about the commerce connection is that because there's a two week span of the money coming in when it does that over a period, It creates two transactions in the right period, right?
- 28:50Dan DeLong: So your your month end would be allocated appropriately as far as what sales occurred when but again, it's one item.
- 28:59Dan DeLong: So there's no inventory with that.
- 29:02Dan DeLong: And the one I did on January for.
- 29:06Dan DeLong: That included December it, put it in the wrong date for, it put it in 12 31 20 23 or 2024.
- 29:14Dan DeLong: So it put it in the wrong year the last years sales.
- 29:18Dan DeLong: But I did appreciate that was only for the year.
- 29:20Dan DeLong: Months were fine.
- 29:21Dan DeLong: But that's curious.
- 29:22Dan DeLong: That's that's, a different animal altogether.
- 29:25Dan DeLong: So go ahead and I'm going to go ahead and stop sharing and kind of pass things over to to Marc there, but I didn't want to share the results of the poll.
- 29:33Dan DeLong: It looks about 7 percent tried it, didn't work as expected.
- 29:37Dan DeLong: We're not too surprised, but 10 percent are currently using it.
- 29:41Dan DeLong: And It does have a place.
- 29:43Dan DeLong: No 65 percent of you said this was the first time I've heard about e commerce.
- 29:48Dan DeLong: So that's a, that's good.
- 29:50Dan DeLong: That's good as far as an education piece.
- 29:51Dan DeLong: And then they, maybe they tried and then 20 percent have tried it and had some issues with it.
- 29:58Dan DeLong: So Marc, let's talk about the other end of the pool that, that people are needing and where integrate, where we integrate can come in.
- 30:08Marc Kalman: Yeah, absolutely, Dan.
- 30:09Marc Kalman: Appreciate that.
- 30:10Marc Kalman: And hopefully you guys can see my screen.
- 30:11Marc Kalman: Okay.
- 30:12Marc Kalman: There's lots of things we could share and show today and we will get into a live demo here in a couple minutes.
- 30:17Marc Kalman: Want to focus in on maybe these five key points for today.
- 30:21Marc Kalman: I will make a couple of general statements for starters.
- 30:24Marc Kalman: I know we're talking a lot about Shopify and I don't know about you, but as soon as I hear Shopify, my brain goes into the e commerce online world.
- 30:31Marc Kalman: But let's not forget, Shopify also plays a pretty significant role these days in the POS world.
- 30:36Marc Kalman: And I do want to point out, if anybody has any clients whether they're exclusive POS on Shopify or a hybrid our one connection can support all of it.
- 30:45Marc Kalman: One of the things that we have built into WeIntegrate, which we'll show a little bit about in, in our demonstration, is we have a really keen address algorithm that helps QuickBooks better understand.
- 30:55Marc Kalman: To what reference a sale is being processed in a particular locale so it knows how to organize sales tax properly, right?
- 31:03Marc Kalman: Because Shopify in inherently is a, multi-location, tax collecting type of an environment that deals with Nexus and all that stuff, and knows the difference between an online sale in a physical locate store in different locations.
- 31:16Marc Kalman: QuickBooks, has that capability, but like when you think about how you're putting a.
- 31:20Marc Kalman: Sales receipt into the system when you're doing it manually even, right?
- 31:24Marc Kalman: There's no sort of.
- 31:26Marc Kalman: Way that QuickBooks knows how to default which address you want, right?
- 31:29Marc Kalman: So unless you specifically change it on the sales receipt and know how to do that, know that it's even relevant, your taxes won't line up in the right place.
- 31:36Marc Kalman: So we have a really cool algorithm that makes that flawless and accurate.
- 31:40Marc Kalman: We'll get into that a little bit.
- 31:42Marc Kalman: And the other thing when we go through this process is to think about that something you said earlier, Dan made me think to say this is that We don't reinvent the wheel with what we're doing.
- 31:51Marc Kalman: We just figure out how to, make sure QuickBooks is, to the best it can be.
- 31:55Marc Kalman: But at the end of the day, what we're simply doing is we're emulating the process as if you were sitting in front of a computer without you having to sit in front of a computer.
- 32:02Marc Kalman: And so it inherently goes well with the way people are used to running their bookkeeping practices.
- 32:08Marc Kalman: Okay.
- 32:08Marc Kalman: So the five areas we want to focus in on here is we want to talk about some of the value that we bring by creating and updating sales receipts and refunds, by the way, that come from Shopify into QuickBooks online.
- 32:20Marc Kalman: Dan, you mentioned about sales items earlier.
- 32:22Marc Kalman: We do give up options, right?
- 32:25Marc Kalman: So as an example, and I'm not going to cover this as much of the demo.
- 32:30Marc Kalman: So I'm just going to mention it now is when you do think about.
- 32:33Marc Kalman: Customer management and item management, right?
- 32:35Marc Kalman: Some people like the idea of bringing sales receipts in.
- 32:38Marc Kalman: They like that idea over journal entries for all the reasons you mentioned earlier.
- 32:43Marc Kalman: But on the other hand, sometimes people get intimidated by that because now they're thinking, Oh my goodness, if I get a thousand sales, am I going to get a thousand one time customers now clogging up QuickBooks?
- 32:52Marc Kalman: And people don't, some people don't want that.
- 32:55Marc Kalman: I don't actually want that, but a lot of people don't want that.
- 32:58Marc Kalman: So you get to choose if you want the customer details coming in, or would you rather it go to just a bulk customer?
- 33:04Marc Kalman: You can decide in our system.
- 33:06Marc Kalman: Same thing with items, right?
- 33:08Marc Kalman: So you can decide, hey, inventory is great.
- 33:10Marc Kalman: I want to manage inventory or I want to manage my sales by items.
- 33:14Marc Kalman: But maybe I don't, maybe I still want that sales receipt coming in, but I don't want those item details.
- 33:19Marc Kalman: So same thing.
- 33:20Marc Kalman: You can decide if you want to, track those details or load it in as a bulk item.
- 33:24Marc Kalman: And by the way, when you do choose to track details, you have options on how you want to map, right?
- 33:30Marc Kalman: So you can map like on a customer side, things like email to email or phones and names and all that sort of stuff.
- 33:36Marc Kalman: And then on the items you can do.
- 33:38Marc Kalman: Standard product name matching.
- 33:40Marc Kalman: You can do skew matching.
- 33:41Marc Kalman: I heard you mentioned variants earlier.
- 33:43Marc Kalman: We support variants as well.
- 33:45Marc Kalman: So it's all cool things you get to choose from.
- 33:47Marc Kalman: So that's one point.
- 33:48Marc Kalman: Another point is in this demo, you're going to see that we do it fast, right?
- 33:51Marc Kalman: You mentioned about the sale getting booked on the payout date with us.
- 33:55Marc Kalman: The sale gets booked instantly.
- 33:57Marc Kalman: Generally speaking from the time it goes from Shopify to QuickBooks, usually it's within seconds, it's a minute or two at most.
- 34:04Marc Kalman: And you'll see that.
- 34:05Marc Kalman: Yeah.
- 34:05Marc Kalman: Yeah.
- 34:06Marc Kalman: By
- 34:06Dan DeLong: the time you get to look at it on the dashboard.
- 34:08Dan DeLong: It's already posted.
- 34:10Marc Kalman: Yeah, which when you think about the next topic inventory is a critical component, right?
- 34:14Marc Kalman: Because if you truly do intend to manage inventory in QuickBooks, right you want it's all about how fast and how accurate and right because seconds can make the difference between You know whether I have it or I don't have it or my customer thinks I have it and I really didn't have it and how you deal with those stock out situations, but we do have a way to update inventory inside of QuickBooks.
- 34:35Marc Kalman: And I'll show you that here today.
- 34:37Marc Kalman: And then one of our newest features that people are incredibly excited about, Dan included, by the way is that we now have Shopify payouts coming through.
- 34:46Marc Kalman: And we've separated the concept of we let sales be sales.
- 34:50Marc Kalman: And we let payouts be payouts.
- 34:52Marc Kalman: So now you can have your sales come in book the sale at its gross level As it should in let's call it, Instant time right as soon as possible as it comes in from one time customer place the order recognize your inventory adjustments Etc.
- 35:08Marc Kalman: And then three days later when that payout comes through, we bring that payout in, auto create the deposit, reconcile against those sales.
- 35:16Marc Kalman: So you don't have to now think, Oh my goodness, I have to check off a thousand sales that came in on that payout.
- 35:21Marc Kalman: Nope.
- 35:22Marc Kalman: We do that for you all automatically.
- 35:24Marc Kalman: And we take all the fees and we drop it down at the bottom of the payout.
- 35:27Marc Kalman: So your net payment is a hundred percent accurate, the bank statement, which now you can reconcile against your actual sales.
- 35:35Dan DeLong: So Michelle's top video on YouTube of how to clean up the undeposited funds account is basically a non issue anymore with this because it does all that for you.
- 35:47Dan DeLong: Yeah.
- 35:48Dan DeLong: Yeah.
- 35:48Dan DeLong: Sorry, Michelle.
- 35:48Dan DeLong: Hey,
- 35:50Michelle Long: that's great.
- 35:52Michelle Long: That is absolutely great.
- 35:53Michelle Long: And you know what, Marc?
- 35:54Michelle Long: I can't believe nobody's done it before.
- 35:57Michelle Long: It seems so obvious, but I'm so glad you guys are doing this because Oh, thank you.
- 36:03Michelle Long: Thank
- 36:03Marc Kalman: you.
- 36:03Marc Kalman: Yeah, I get it.
- 36:05Marc Kalman: Definitely.
- 36:05Marc Kalman: It was obvious to us when we got in there, I can tell you it was very tricky.
- 36:09Marc Kalman: So we can understand why people may not do it.
- 36:12Marc Kalman: But but it was Yeah, I'm glad to hear you say that because that you know we do the value to us is when you know people like yourselves, state see these sorts of things that shows us that we're on the right track to making the kind of difference that we're looking to make.
- 36:24Marc Kalman: Which is awesome.
- 36:25Marc Kalman: And then another awesome thing we'll talk about today, too, by the way, is our tax management capabilities, I guess I'll call it, but not that we're managing taxes, but we ensure and we make sure that the taxes in QuickBooks are 100 percent accurate with the taxes that are in Shopify.
- 36:41Marc Kalman: And that takes on two, two focuses.
- 36:43Marc Kalman: One is that the actual amounts are accurate, right?
- 36:46Marc Kalman: So if you've tried to do this sometimes.
- 36:49Marc Kalman: You might see where QuickBooks gets like pennies off per transaction because, sometimes there's some rounding things differently between two systems.
- 36:56Marc Kalman: And then the other is, as I mentioned before, where those taxes are actually supposed to get located, like which agency is that tax associated with.
- 37:04Marc Kalman: And then, That other one about tax nexus, right?
- 37:07Marc Kalman: Physical nexus versus economic nexus, where you have to get add ons to manage all this again, we have this algorithm built in that, that lets QuickBooks be as smart as Shopify when it comes to those things.
- 37:19Dan DeLong: Yeah.
- 37:19Dan DeLong: And you're really using, the information that you get from Shopify as the guidance of what this should actually be, you know, cause things will change.
- 37:29Dan DeLong: After, the transaction posted or anything like that.
- 37:32Dan DeLong: So you use Shopify as your source of truth of what to tell QuickBooks and leave it up to customers or leave it up to clients to make things a little bit challenging when it comes to that sort of stuff.
- 37:44Dan DeLong: So let's we've got, other, screenshots and things like that in the slides.
- 37:48Dan DeLong: So if people want to download the.
- 37:50Dan DeLong: The slides off the website, they can certainly, go through some of these things, but I want you to, I want to take a look in your dashboard and show, and highlight some of these things.
- 38:00Dan DeLong: So to answer to with the, with your payout functionality that I think that is a game changer in this in this space, right?
- 38:09Dan DeLong: Because of all of the connectors that I've seen and looked at is that everybody wants to use these clearing accounts, right?
- 38:16Dan DeLong: And then that just makes more work for the accountant.
- 38:18Dan DeLong: To make sure that the transactions that are deposited and the payouts are deposited match right so that instead of reconciling the bank account, you're also reconciling these clearing accounts on top of all that, but you're taking a different approach where this is actually going through undeposited funds of all things right the payments to deposit is actually going into the undeposited funds and you can't make a deposit and this was a thing that I was like leery about using under positive funds because it is a special QuickBooks account and I'm not talking like short bus special account, but it's got some functionality tied to it inside of QuickBooks to make sure that you do this right so that it's not causing a problem with your connector versus the reality of what's coming in.
- 39:11Dan DeLong: But the goal is.
- 39:13Dan DeLong: When a payout comes in, it gets deposited through under positive funds into the bank into the into the bank account.
- 39:21Dan DeLong: And then the bank feed just then matches to that because the bank feeds coming from Shopify are horrible because there's just Shopify transfer.
- 39:32Dan DeLong: What was that for?
- 39:34Dan DeLong: Was that the payout or was that a fee that I had to pay?
- 39:38Dan DeLong: Or was, what was that?
- 39:40Dan DeLong: That, that came in or was it a refund or whatever it is, it's hard to tell just from the bank feeds, but if you have all that information in there, in the bank account, and then the bank feed comes in then it just matches because that's what it's looking at first is the amount and you guys again, take that.
- 40:00Dan DeLong: Gospel according to Shopify as the amount.
- 40:03Dan DeLong: And that's what typically will show up in the bank.
- 40:06Dan DeLong: I'm sorry.
- 40:07Dan DeLong: I stole your thunder.
- 40:08Marc Kalman: No, please do.
- 40:12Marc Kalman: And, and one other thing too Dan, as we had discussed previously is that for those that maybe, if, cause, cause we integrate allows you to connect multiple Shopify.
- 40:21Marc Kalman: Stores right to one reintegrate account and load all that into QuickBooks online.
- 40:26Marc Kalman: So one concern that we've heard is if you start doing that and I have all this going into undeposited funds, how can you segment it, right?
- 40:33Marc Kalman: Cause maybe you want to put, one store, one thing, your account or one or another, right?
- 40:37Marc Kalman: That sort of thing.
- 40:38Marc Kalman: But we have in our defaults, a setting at the connection level.
- 40:43Marc Kalman: Where you can specify a location a QuickBooks location comes right out of your QuickBooks table into our system.
- 40:49Marc Kalman: And you pick a QuickBooks location so that when your sales get posted, you could have one channel posting a one location in undeposited front, on the sale and the other two other, so when you go to filter your undeposited funds, you now do that by location and emulates that same concept of splitting out, those sales that you're trying to keep track of.
- 41:07Dan DeLong: Yeah.
- 41:08Dan DeLong: Cause that was my other big concern about using undeposited funds is that if every, all of the sales receipts are coming into undeposited funds, that's going to make a huge problem, especially if people are using undeposited funds for other things that aren't, Shopify based, right?
- 41:24Dan DeLong: Like they create an invoice and they receive a deposit, goes through undeposited funds.
- 41:29Dan DeLong: Oh, good Lord.
- 41:30Dan DeLong: How do I get through this mess?
- 41:31Dan DeLong: So your point, you can set up locations and then choose the location on the positive fund screen to only show specific locations so it can weed out those extra transactions.
- 41:45Marc Kalman: Yeah, exactly.
- 41:46Marc Kalman: Cool.
- 41:46Marc Kalman: So I'm just jumping ahead to where people would have to do this, although I have to do it.
- 41:50Marc Kalman: It's just part of the demo.
- 41:52Marc Kalman: Is I think the first thing we'll do, we'll get, I'm going to focus on the, that payout since we've kind of like, discussed it right now.
- 41:59Marc Kalman: So it might as well, like on that, but before I do that, I'm just gonna drop a couple of quick sales in that we will run the payout against in the demo.
- 42:06Marc Kalman: So I can show a couple of things.
- 42:07Marc Kalman: One is I will show how we process the sale and how that goes into QuickBooks.
- 42:12Marc Kalman: And then people can also see how fast it generally does go.
- 42:16Marc Kalman: So I'm just going to make up some fake.
- 42:19Marc Kalman: Customers here
- 42:21Dan DeLong: Yeah and while you're doing that I wanted to address the question in the chat Is that shopify handles different payment methods and how does this connection handle those methods?
- 42:31Dan DeLong: So as long as it's coming through shopify payments, like there's a recent change where amazon pay is now being in included in shopify payments So as long as they have some kind of connection Into shopify payments Then this will continue to do this I think the best word in the Intuit buzzword is automagically to be able to do this now, if they're using something outside of that PayPal or Sezzle that where it's, completely outside of the Shopify payments realm then this won't work.
- 43:06Dan DeLong: That's not like the end, the be all and end all that's on your radar for, for that to work for other payment methods.
- 43:14Marc Kalman: Correct.
- 43:14Marc Kalman: Correct.
- 43:15Marc Kalman: I'm going to go ahead and push through the cell.
- 43:17Marc Kalman: Just one thing I want to point out is, so I put this sale in for an address at a New York Manhattan and Shopify knew enough to calculate tax on it because one of the locations we have set up inside of Shopify is a New York address, right?
- 43:30Marc Kalman: So Shopify, just pointing out as we do this, Shopify knows how to auto calculate that.
- 43:34Marc Kalman: So we get a total here of 100 and 16 cents.
- 43:37Marc Kalman: And we'll go ahead and process this in one order.
- 43:39Marc Kalman: Okay.
- 43:40Marc Kalman: And then I'm just going to drive the same exact thing for you on a second order real quick.
- 43:43Marc Kalman: And then we will show the output of that and do the payout.
- 43:50Dan DeLong: And your main focus is let's start with Shopify because that's the most commonly used one.
- 43:57Dan DeLong: And then you'll take all these learnings and move them into other channels.
- 44:01Dan DeLong: So like Ross was mentioning in the Q and a, what about Squarespace, what about WooCommerce?
- 44:06Dan DeLong: What about, Fill in the blank, you're going to take these learnings that you're learning with, the big hairy beast of Shopify and then, Taking those into the other sale online sales channel.
- 44:18Marc Kalman: That is correct.
- 44:18Marc Kalman: Yes and we chose to go deep into shopify first, you know You just go deep and really knock out everything we can and then yes Take that and move over to the next one Do you regret
- 44:30Dan DeLong: that decision?
- 44:32Marc Kalman: Not at all Because it's been part of what's like showing people that there's a, there's another way to do this, right?
- 44:39Marc Kalman: That, that can make things a lot easier.
- 44:41Marc Kalman: I'd rather help people get really easy on one thing, right?
- 44:45Marc Kalman: Eat
- 44:46Dan DeLong: the elephant first, and then, everybody else is kittens and kittens and puppies.
- 44:51Dan DeLong: Exactly.
- 44:52Dan DeLong: All right, so this one And what's interesting
- 44:54Gennady Kleyner: is that Shopify has recently opened itself up to other platforms.
- 45:00Gennady Kleyner: So we now have Shopify orders coming through from Amazon and eBay and others that, that are going through Facebook Marcetplace.
- 45:09Gennady Kleyner: So they're basically being the consolidator and we obviously support that from the get go.
- 45:15Gennady Kleyner: And so we're now having those types of orders come through as well.
- 45:19Dan DeLong: Yep, yep,
- 45:20Marc Kalman: exactly.
- 45:21Marc Kalman: One thing I thought I was about to mention before I switched over, so that second sale I did based out of Georgia, and Shopify knew not to charge tax on that one because I don't have a physical location set up inside of Shopify for Georgia.
- 45:33Marc Kalman: Got it.
- 45:34Marc Kalman: Now you'll see we already have a number two here, the two sales we process and on one other point real quick, just so there's no confusion, I am inside of WeIntegrate today because I am demoing how it works.
- 45:45Marc Kalman: WeIntegrate is a sort of set it and forget it type of a system.
- 45:49Marc Kalman: So you don't have to come in here.
- 45:51Marc Kalman: There's no buttons to push.
- 45:52Marc Kalman: Just build a connection and then everything automates whether you're in our application or not.
- 45:57Marc Kalman: But you can come in here,
- 45:58Dan DeLong: it's a crockpot application.
- 46:00Dan DeLong: You just load your ingredients and then, wait.
- 46:03Dan DeLong: Wait for dinner.
- 46:05Dan DeLong: Exactly.
- 46:05Marc Kalman: And now you'll see here these two lines here at the top.
- 46:08Marc Kalman: These are the two orders I just processed out of Shopify.
- 46:10Marc Kalman: So we're showing you Shopify orders number 1552 and 1553.
- 46:14Marc Kalman: For their total amounts.
- 46:16Marc Kalman: You can see, if you remember what I showed on the screen the whole total of the first one was 116, which includes some shipping and tax, and this one doesn't have any tax at all.
- 46:25Marc Kalman: And We show you the ship status and pay status here.
- 46:27Marc Kalman: So we take a little bit more of an operational flow on what we do too.
- 46:31Marc Kalman: So for example I'm just going to rest for one minute here.
- 46:34Marc Kalman: I think we've got enough time.
- 46:35Marc Kalman: So I'm going to squeeze it in is if I take Shopify, if I take one of these orders and if I if I take one, let's say I take the second one here.
- 46:55Marc Kalman: And if I open it up and now I want to fulfill it, whether I'm doing it in Shopify or a third party app or even a third party warehouse connected to, to Shopify and that fulfillment is done right here.
- 47:08Marc Kalman: I'll just put some values in right into the screen, whatever tracking number, and then we'll leave start tracking for carrier, et cetera, et cetera.
- 47:16Marc Kalman: And then say fulfill what will happen in we integrate first of all.
- 47:22Marc Kalman: And I'll just keep that.
- 47:23Marc Kalman: A couple seconds here.
- 47:25Marc Kalman: So I'll just point back over here.
- 47:26Marc Kalman: So we show you the pay status that we've been paid, the ship status.
- 47:30Marc Kalman: They're still showing us open.
- 47:31Marc Kalman: They haven't shipped yet.
- 47:32Marc Kalman: They've been received, a certain period of time ago.
- 47:35Marc Kalman: And then last sync.
- 47:36Marc Kalman: This is the last time it went, got connected here with QuickBooks.
- 47:39Marc Kalman: And you can see that one that I shipped now shows that it's been partially shipped, right?
- 47:43Marc Kalman: Less than a minute ago.
- 47:44Marc Kalman: If I hover over here, we show you the actual date and time.
- 47:47Marc Kalman: But now we show you the QuickBooks sales receipt number that got generated inside of QuickBooks, right?
- 47:51Marc Kalman: So 3174.
- 47:53Marc Kalman: And then on this one, it was 3173.
- 47:56Marc Kalman: We do give you an option that you can map the Shopify order number as the QuickBooks sales receipt number if you want.
- 48:01Marc Kalman: Or you could use the QuickBooks.
- 48:03Marc Kalman: Auto generated number both have a place, but regards to which we choose, we make sure it's clear to you that there's a connection between this sales receipt number and this order number.
- 48:12Marc Kalman: I'm just going to quickly go in here and show you these two sales that we just generated and then we'll go ahead and run that payout through for the deposit.
- 48:21Marc Kalman: So here are the two sales receipts, 3173 and 3174.
- 48:25Marc Kalman: You'll see here in the memo, we show you the actual Shopify order numbers right here.
- 48:30Marc Kalman: So you don't have to go very far to see that, this sales receipt is that order number.
- 48:34Marc Kalman: You'll notice they are exactly to the penny of what I showed on the Shopify side.
- 48:40Marc Kalman: If I come into this first one here for 116, I'm sorry, 100 and 16 cents you'll see that the the taxes I'll see if that rolls.
- 48:50Marc Kalman: Sorry.
- 48:51Marc Kalman: Just give me a second.
- 48:51Marc Kalman: There we go.
- 48:52Marc Kalman: The taxes are all accounted for.
- 48:54Marc Kalman: It knew the, it knew to do all the taxes while I was loading.
- 48:58Marc Kalman: And one of the ways that we accommodate that is, we show you here the ship to.
- 49:03Marc Kalman: And address information.
- 49:04Marc Kalman: But then we also replaced the ship from based on that physical location that we saw inside of Shopify.
- 49:10Marc Kalman: So QuickBooks now sees this as a ship to New York from New York scenario and knows that on its own, not just that it needs tax, which we overwrite anyway from Shopify, but then where to put that tax, like that tax belongs to that New York tax agency.
- 49:25Marc Kalman: And you can see it's 8 and 18 cents right out of Shopify.
- 49:30Dan DeLong: And if it's a return, it would just be a return receipt with the exact same information.
- 49:35Marc Kalman: Correct.
- 49:36Marc Kalman: And because we're doing that too, when the payouts are coming through and they have those returns embedded inside of them it it will it will account for it properly.
- 49:46Marc Kalman: It's really cool.
- 49:47Marc Kalman: All right, so that while Gennady, maybe while you're processing that payout, I am going to go ahead and show this other second sale receipt real fast.
- 49:54Dan DeLong: We might go over a little bit.
- 49:56Dan DeLong: Especially if folks have, good questions that I'm seeing, rolling in here as well, but we do want to make sure that we see this payout because this is, that is the biggest game I'm just going to say it's a game changer in this space where you're actually going through undeposited funds.
- 50:19Marc Kalman: Okay.
- 50:19Marc Kalman: So on this sales receipt here this one is the second one they did when I shipped to Georgia.
- 50:25Marc Kalman: So you see it shipped to Georgia.
- 50:27Marc Kalman: You'll notice the address here is you wouldn't know it by inherently, but you see it's a different address.
- 50:32Marc Kalman: This is based on the default QuickBooks address now, because we couldn't find a, an address matching our algorithm to control that physical nexus.
- 50:40Marc Kalman: So what will happen is.
- 50:41Marc Kalman: And I'll show you in the nexus area in a second here that gets tracked by QuickBooks is economic nexus tool.
- 50:47Marc Kalman: But you'll see down here at the bottom, there's no sales tax applied.
- 50:51Marc Kalman: And the total comes out to the exact penny that was on the Shopify side.
- 50:54Marc Kalman: One of these, we also do by the way remember I did that fulfillment on the Shopify site.
- 50:59Marc Kalman: It's a little website sidestep, and then I came back and dropped that in there.
- 51:03Marc Kalman: So when that comes available, we go back, we update the sales receipts.
- 51:06Marc Kalman: We have all that tracking information here on the sales receipt for those that need it.
- 51:10Marc Kalman: And we also are loading the shipping fees here as a line item.
- 51:13Marc Kalman: On the P& L, it comes out exactly the same, but there's more value here.
- 51:17Marc Kalman: It helps us better control the sales tax as well.
- 51:19Marc Kalman: But in addition to that, we're now able to show you a the service level.
- 51:23Marc Kalman: So you can see the shipping service level here is economy.
- 51:26Marc Kalman: It could be rush, it could be whatever.
- 51:27Marc Kalman: But then we also, when Shopify sends us the tracking info, in this case, like the URL to track the package we add that to that reference as well.
- 51:36Marc Kalman: Just give me some, a little additional extra value.
- 51:39Marc Kalman: To Dan's earlier point, you'll see it here on, under Positive Funds.
- 51:42Marc Kalman: So that's an example of sales receipts.
- 51:45Marc Kalman: And now I am told the payout has been processed for those two orders I just did.
- 51:50Dan DeLong: Typically, this would be a couple days later, right?
- 51:53Dan DeLong: The reality is that Shopify doesn't process payments this quickly.
- 51:57Dan DeLong: But in your testing environment so a couple days have passed.
- 52:01Dan DeLong: There's now a payout.
- 52:02Dan DeLong: So let's take a look at that.
- 52:04Marc Kalman: Yes, a couple days have passed.
- 52:06Marc Kalman: It's a great narrative action like that.
- 52:08Dan DeLong: And while you're bringing this up, I'm going to throw up the last the last poll.
- 52:12Dan DeLong: Sure.
- 52:12Dan DeLong: So if people do need to drop off at the top of the hour they can do and where'd it go?
- 52:18Dan DeLong: I had it.
- 52:18Dan DeLong: Oh, there
- 52:19it is.
- 52:19There we go.
- 52:23Dan DeLong: So we'll just launch that poll about learning more about WeIntegrate.
- 52:33Dan DeLong: Alright has it, did it post already?
- 52:35Dan DeLong: I missed it.
- 52:36Dan DeLong: I blinked.
- 52:38Marc Kalman: Hey, what did the payout post?
- 52:40Marc Kalman: Yeah yeah, it actually it did so i'm in the so we have a checking account that we set up in our demo called Shopify checking one and here's the the payment that just came through right?
- 52:49Marc Kalman: So we took the two cells together put them together the net deposit is 177.
- 52:54Marc Kalman: 41 If I hover over the split here, you'll see that pops up.
- 52:58Marc Kalman: I don't you guys can see the hub over You'll see there's two sales receipts, right?
- 53:03Marc Kalman: They're on there minus
- 53:08Dan DeLong: Go ahead and edit that because one thing I really like about what you do is account for the fees separately and there's reference to it.
- 53:16Dan DeLong: So if you scroll all the way down to the, out of the bottom or what Michelle tells you to do and how to clean up credit card charges in undeposited funds in order to get that payout that the bank deposit to actually match is to put, negative dollar amounts in the bottom.
- 53:34Dan DeLong: And you actually split them out individually with the reference number to the transaction.
- 53:40Dan DeLong: You'll be able to see all of that in one place.
- 53:43Dan DeLong: And you don't have to necessarily go hunting for what was this 3.
- 53:48Dan DeLong: 01 for?
- 53:49Dan DeLong: Oh, the reference number here, that's the Shopify order number.
- 53:53Dan DeLong: I can go and check on that if need be, if it's if it's an odd amount or something like that.
- 53:59Marc Kalman: Exactly.
- 53:59Marc Kalman: And we also have an overflow scenario too.
- 54:02Marc Kalman: So if for some reason, if like deposit came through and the payout was for, 10 sales and, for some reason, only nine of them are in QuickBooks for whatever reason, that, that overflow would get thrown into an unmatched account for whatever that variation variant would be.
- 54:18Marc Kalman: Differences.
- 54:18Marc Kalman: And at least it kind of hones you in on, Hey, it was able to reconcile everything that it had, gave you like this overflow, what's called clearing account kind of scenario.
- 54:29Marc Kalman: It didn't disrupt the fact that your payment matched your bank.
- 54:31Marc Kalman: And now you just deal with that small piece of discrepancy and figure out what went wrong on that and make your adjustment.
- 54:37Dan DeLong: And the biggest concern, that I had when you were telling me that you were going to be thinking about using undeposited funds as your payment deposit account was.
- 54:46Dan DeLong: What if there is a payment that Or a sale that's not posted, right?
- 54:52Dan DeLong: Or you know if you can't use you know Because it's going through and checking off the sales receipt in the payments to deposit section And then accounting for the fees.
- 55:01Dan DeLong: What if somebody got click happy?
- 55:04Dan DeLong: deleted the sales receipt by mistake or it never posted because it Because of there was some error How do you handle that deposit and that situation because the reality is funds were deposited You Just because they're not in undeposited funds, shouldn't stop the payment from actually depositing.
- 55:23Dan DeLong: So how do you handle that?
- 55:24Marc Kalman: Oh yeah.
- 55:25Marc Kalman: I'm sorry.
- 55:25Marc Kalman: I'm sorry.
- 55:26Marc Kalman: That was a question.
- 55:27Marc Kalman: And that's what I meant.
- 55:27Marc Kalman: The same way I handle the other scenario.
- 55:29Marc Kalman: I'm sorry.
- 55:30Marc Kalman: I'm sorry.
- 55:30Marc Kalman: I thought it was related to that.
- 55:31Marc Kalman: Yeah.
- 55:32Marc Kalman: So we have in our system, you can set up a default account where you can place a post unmatched monies.
- 55:39Marc Kalman: So if if the deposit, was a thousand dollars.
- 55:42Marc Kalman: And, the payout's a thousand dollars.
- 55:44Marc Kalman: We want to make sure that when that deposit here in QuickBooks gets created, that it's also a thousand dollars, right?
- 55:50Marc Kalman: Cause Dan's point is money's still coming in, right?
- 55:53Marc Kalman: It's just a matter of why did it come in?
- 55:55Marc Kalman: And so we make sure we ensure the integrity of the deposit.
- 55:58Marc Kalman: So if there's something we cannot find for some reason something's out of balance or, sales or speed went rogue that variant value will wind up getting posted to that unmatched account.
- 56:11Marc Kalman: And you get the opportunity to call it what you want, and you just set it up inside our system that this account gets used for this purpose.
- 56:18Marc Kalman: And then we we post those overflow amounts, could be positive or negative first to that.
- 56:23Marc Kalman: So in the grand
- 56:24Dan DeLong: scheme of things, it will go into, some kind of nebulous account unmatched sales or whatever it is that you want to call it.
- 56:30Dan DeLong: And that's the account that you really need to look at and see okay.
- 56:35Dan DeLong: This is my problem child account to look through as opposed to the entire clearing account and to someone's point You have to use undeposited funds.
- 56:44Dan DeLong: The answer is no you can still use your clearing accounts if you're If that's what you, if that's what you used to, and you don't want people to touch on depositive funds, you can certainly not do that.
- 56:56Dan DeLong: This is one of those things that, what are you going to do with your free time when you're not needing to clear up all the clearing accounts?
- 57:04Dan DeLong: Exactly.
- 57:05Dan DeLong: Exactly.
- 57:08Marc Kalman: And so it makes it clear.
- 57:09Dan DeLong: Michelle, to you, this was like a blind Taste test, right?
- 57:13Dan DeLong: Like you, there's a blind reaction.
- 57:16Dan DeLong: What do you think?
- 57:17Michelle Long: I am very impressed.
- 57:19Michelle Long: I love how slick and streamlined it is.
- 57:22Michelle Long: And I think it's pretty cool.
- 57:24Michelle Long: I really do love it and everything.
- 57:26Michelle Long: The only one thing I was sitting here wondering about, and it doesn't happen very often.
- 57:31Michelle Long: But occasionally you'll have a net deposit for the day that's negative because you had returns like let's say in january after the holidays And everybody's returning their christmas gifts or their holiday gifts that they didn't like or something So at the end of the day when that deposit comes up negative Is that going to cause any problems?
- 57:52Michelle Long: No That one had two transactions Let's say there were five transactions for the day or whatever and a negative deposit for the day You Is that going to cause any problem?
- 58:03Marc Kalman: No, it, it does not Michelle.
- 58:04Marc Kalman: It actually, it works well because you'll see, we have like even in here, we've shown that we have some refunds in here, so whether it's positive or negative, it comes in and creates a deposit and we do it.
- 58:16Michelle Long: That's awesome.
- 58:18Michelle Long: That is just awesome.
- 58:19Michelle Long: Yeah, i'm impressed.
- 58:20Michelle Long: I love it So I encourage people there's been some great discussions in the chat I've been watching them and everything and I encourage people to call you all because there's been a lot of discussions Can I do this?
- 58:30Michelle Long: Can I do that?
- 58:31Michelle Long: What about this?
- 58:32Michelle Long: What about that?
- 58:32Michelle Long: I encourage everybody to schedule a demo with you all.
- 58:35Michelle Long: And follow up with you for their specific questions and things like that,
- 58:41Dan DeLong: so The big takeaway that i'm seeing where we're We integrate, specializes is when you need to account for the inventory inside of QuickBooks and you're solely using Shopify.
- 58:56Dan DeLong: That's where we integrate would do really well.
- 58:58Dan DeLong: There are other applications out there that will do multiple sales channels, and maybe they even, work with the payouts and those types of things.
- 59:06Dan DeLong: But the price point for doing that is, is significantly more than what we, when we integrate will charge.
- 59:13Dan DeLong: Because typically you would say, Marc, mostly the pricing strategy for, um, for this industry is volume of sales and number of sales.
- 59:23Dan DeLong: Channel to connect and you guys adopt that as well.
- 59:28Dan DeLong: But if you're just talking Shopify and and Shopify payments and inventory I don't think anyone comes close to, to where your price point is.
- 59:38Dan DeLong: The other players that are out there, you're looking at like a hundred dollars a month.
- 59:42Dan DeLong: For.
- 59:43Dan DeLong: Their lowest right option where you're, significantly less than that.
- 59:49Dan DeLong: Yeah, have a free trial
- 59:51Marc Kalman: We have a 15 day free trial correct and then for those that are Let's say under 500 transactions per month.
- 59:59Marc Kalman: You can get started for as little as 19 a month And you get access to the full features that we showed today for that price.
- 1:00:08Marc Kalman: And when, there are some other vendors out there around the same price point, but what you'll see is where, we're 19 a month and they might be 19 a month.
- 1:00:17Marc Kalman: For the 19 a month with our competitor, you may get, let's say 200 orders a month, 200 documents a month, and with us, you get 500, not more or less.
- 1:00:29Michelle Long: Yeah.
- 1:00:30Michelle Long: Not to mention the time saving, it makes everything so much easier.
- 1:00:36Michelle Long: I think you guys really hit it here.
- 1:00:39Michelle Long: I think you guys really hit the nail on the head and you did some stuff today.
- 1:00:43Michelle Long: Seems very obvious and you're like, why didn't anybody do this sooner?
- 1:00:47Michelle Long: So kudos to you and job well done.
- 1:00:50Michelle Long: So I encourage people to, call with additional questions, schedule a demo and check it out for themselves.
- 1:00:56Michelle Long: So great job.
- 1:00:58Dan DeLong: Thank you.
- 1:00:59Dan DeLong: All right.
- 1:01:01Dan DeLong: We did run a little over, so this is the power hour.
- 1:01:05Dan DeLong: 10 minutes plus.
- 1:01:06Dan DeLong: However
- 1:01:08Michelle Long: everybody dig these days.
- 1:01:11Michelle Long: We plus dig.
- 1:01:12Dan DeLong: I know.
- 1:01:13Dan DeLong: Shopify Plus Power Hour plus.
- 1:01:15Dan DeLong: Yeah.
- 1:01:15Dan DeLong: This is the after show We appreciate you all joining us.
- 1:01:20Dan DeLong: Marc and Ani, I appreciate you joining us from We Integrate and Michelle, it's always great to see you.
- 1:01:25Dan DeLong: So we'll be here in a couple weeks with more Marceting advice from the folks at wizard of Ads.
- 1:01:32Dan DeLong: How you can build a story for, for a Marceting firm.
- 1:01:35Dan DeLong: So we'll talk to that then next time.
- 1:01:38Dan DeLong: And we'll see you next time on the QB power hour.
- 1:01:40Dan DeLong: Have a great day, everyone.
- 1:01:41Dan DeLong: Man, thank you so much.