5697130-1701885651165_restream
===
[00:00:00] [00:00:30]
[00:00:38] Dan DeLong: Welcome to another Workshop Wednesday. We are live with more people. This, of course, is. Casual conversations for serious workflows is our little tagline. We are coming in for a landing on the e commerce fundamentals.
And the last week we talked a bit about sales bridges as we call, which is [00:01:00] basically a piece of technology that gets between your sales channel and your. Accounting channel and brings that sales data in together, right? And we talked about a variety of different ones and we wanted to bring on Marc and Gennady, from WeIntegrate and I saw I met these folks a couple What was it say about six months ago? And we were talking about their their bridge and they specialize in Shopify. So that's why I [00:01:30] wanted to have Rachel be like a blind reaction here as we talk about that.
And then cause you guys do something a little bit unique than the other sales bridges out there. So Marc, if you want to talk a little bit about the history of we integrate and how you came to be and what it is you're hoping to solve for it yet. Do you want to share your.
We have a few slides, but most of all, you want to focus on the on a demonstration today.
[00:01:58] Marc Kalman: Yeah, that'd be great, Dan. Thank you. And [00:02:00] Rachel, we really appreciate the opportunity of speaking with you guys today and your audience and having a chance to, have these casual conversations about these very serious workflows.
Yeah, do you want me, I'll flip over to, I have a little deck I can walk us through and talk a little about the history and maybe some of the key points that we would like to highlight for today. There we go. Okay. Awesome. Very cool. As yeah. Dan, as you mentioned we are, we integrate we are newer to the Marcet.
So a lot of people may not have heard of us yet, although the word seems to be spreading pretty [00:02:30] quick, which we're excited about. We do currently focus primarily on Shopify into QuickBooks online, both web store, as well as POS from the same tool. Over time, once, once we, and our focus and our thought was, we want to go deep on Shopify first really address the primary issues that we're hearing out there in the Marcetplace.
First and then move on to other channels so we do have that on our roadmap to get into other opportunity areas of like e commerce such as [00:03:00] Amazon and etsy and all the other common connections that people would need to effectively run their business as far as our company is concerned
Yeah Gennady and I have been in software, supply chain, e commerce operations for quite some time. I'll let Gennady speak for himself since he's here.
But I myself have been involved about 25 years mostly as an entrepreneur. I co founded a very successful EDI provider, supply chain focusing on small businesses, built out [00:03:30] an ERP system for small businesses that did really well and won awards, and now here we are with WeIntegrate. And it was during the time that I was with the ERP, solution that the concept of integrating Shopify with QuickBooks Online came about, and here's why.
We would call these small businesses, and we found a very interesting reaction when we talked to a small business and say, ERP. We either got people hanging up on us because they were scared, [00:04:00] Or hanging up on us because they didn't know what an ERP was, right? And we found out that a lot of times what they really just needed were very efficient tools to integrate a particular source such as Shopify with their financial systems and not the whole gamut of what Complex ERP system would offer them, particularly at the smaller stage.
Something also interesting that we found was that, um, even though they're categorized as small businesses, they actually have big business needs, right? [00:04:30] And right. Cause there was a time long time ago, actually not too far ago, where small businesses would generally compete with the main other main street businesses.
But because of this trend and, e commerce being one of them and this, global market now. Small businesses are competing head to head with big businesses. The problem is those big businesses do, in fact, have enterprise systems and automating big budgets, and they hire people just to make sure that those processes don't break right where a lot of small businesses like I've had clients that [00:05:00] had products that were selling it every.
single bed bath to be on store in the country at the cash register, but the product was very tiny and they stock them in their garage and they had a couple of people helping them. And how does a small business like that process for orders for a thousand stores without enterprise tool? Problem being is it has to be easy to use and it has to be affordable, right?
So that. Methodology and thought process has carried full forward and it's going to get a gun. I and I focus heavily on here with our solution for we integrate [00:05:30] and Gennady. I'll turn over to you. You can maybe share your background.
[00:05:33] Gennady Klayner: Sure. Thanks for that. Marc. Yeah. So I started my career working at.
Some very small companies doing value added reselling types of services. And we actually at a couple of them built accounting tools, bill billing tools, medical coding and things like that. So I experienced early on what it is like. To essentially deal with the small side of the things that Marc just mentioned where the [00:06:00] needs of the small organizations really don't far off from what the bigger ones are looking for as well.
And as I went. And further my career and started working at these large organizations. I saw that there's a lot of parallels there, the same types of things that the large organizations are suffering from are the same types that the small and medium sized businesses are suffering from as well.
And yeah we wanted to bring a solution that streamlines things. Automates things and [00:06:30] takes advantage of today's technical environments into the hands of these smaller organizations.
[00:06:36] Dan DeLong: tHat's awesome, because that's really where, I think, small business owners, being able to do things that the big guys do without having acts, but they don't have the time budget or.
Expertise to be able to do those things in an enterprise type of space, this gives, this gives them a lot more leverage. And is that kind of the [00:07:00] driving force behind? Yeah, exactly. Yeah,
[00:07:02] Gennady Klayner: exactly. We don't feel that, organizations have to spend an arm and a leg for some of the basic features out there that, larger enterprises take really for granted, but obviously can afford to pay for it.
And so the more that we can empower the small businesses with some of these tools that have been available for a long time and evolve them to a point where they're very simple, very well integrated. We are going to be basically making lives a whole lot [00:07:30] easier for folks.
[00:07:31] Dan DeLong: That's awesome.
And then I also noticed Randy Johnston there. Now he's not here, but that's a that's a familiar face. How did that how did that introduction happen or how did, how is he helping out?
[00:07:44] Marc Kalman: Yeah, that's glad you asked. So Randy is an advisor. He's an official advisor on our board of advisors.
And we've been working with him for about a year now. And we just connected with him just to, initially it was just from his experience in the industry and the opportunity to maybe, pick up a little bit [00:08:00] of media play. And then just as we talked we hit it off and he had given us some good feedback right off the bat that we appreciated.
And, things gelled well, and he liked what we were doing a lot. Like you mentioned, thought we're doing something a little bit different. Then others he's seen in the market and he joined our board and he's been very helpful, very instrumental. And all the ways you could probably imagine he has been over the past year, giving us great advice, guiding us down the right direction, but particularly from the accounting perspective, which is really nice.
[00:08:29] Dan DeLong: Yeah. [00:08:30] Now, when you go to the Intuit app store and you search for the word Shopify you're presented with. At least, what, 30 or 40, different applications that claim, right? I'll take your sales data from Shopify and I'll put it in your QuickBooks, right? And Rachel, you probably could attest to, that there is a variety of different ways to get that information in there in, into QuickBooks.
But it all, with an accountant or. [00:09:00] accounting professional, the devil's in the details. And and so tell us a little bit about what, what makes we integrate Shopify integration a little bit different.
[00:09:12] Marc Kalman: Sure. Happy to. So for starters we're trying to look at what problems we're trying to solve, for, and realizing that, some of these problems may have been solved before and some of them may have been solved before in a, let's just say a different way than, a week. Think, maybe they should be solved. And it doesn't necessarily make [00:09:30] one right or wrong, right? There's always gonna be schools of thought, right?
This is the way to go or this is the way to go. And that's great. That's why there's, multiple companies that do what we do. But one of the things that we found that was paramount was speed, right? Efficiency of data and that, when you think from the merchant's perspective for a moment maybe not necessarily from the accounting perspective it may, right?
And we talked to different accounts, some don't care and some do, right? Depends on, what elements of part of the business they're operating, but when we [00:10:00] think about data exchange between disparate systems. Speed is important. Speed is very important. Speed can make the difference of a quality decision being made properly or not being made properly.
Particularly when you think of things like inventory where if if there's like a one hour delay on inventory getting updated that can have a major impact on customers going to maybe another site that you're selling from. That hasn't properly been updated in time and someone buys an item that turns out that you're [00:10:30] actually out of stock on and now you have to deal with a customer service issue, right?
Or having quality data available when you're trying to make cash flow. Assessments, right? Is it time we did I get my information today, or do I have to wait three to five days, to understand the value of something, right? So we found that quality of data is important. We also found, and I know some of you are going to react when I say this, we found that in many cases having details on documents can be [00:11:00] more advantageous than having summary information.
Of sales. And so we've taken a stance for right now anyway, and it seems to be. Holding true to at least the audience of people that say, yes, I do want details. Some of you are out there saying that right now. And some of you are saying right, we have an answer for that. In fact, I had a great demo with somebody the other day that is a big fan of one of our competitors that focuses a lot on.
Both journal entries and stuff from the [00:11:30] payouts. And so we started the conversation that way. And then by the time we were finished she was very intrigued and very interested and very excited about what we're doing, the approach that we're taking. And I'm happy to, talk more about that as we go through the call here.
But we do find that there's value in data, right? And here's why data gives us the ability to make better. Decisions, right? Sometimes, when we have more data, we can make better decisions. From an even from an accounting perspective, bulk data [00:12:00] sounds great, right? Until something goes wrong, right?
And I'm sure everybody out here has never had anything go wrong before and hasn't had a waste time trying to track down what the problems were or figure that stuff out. But we find that's some feedback that we've received. We found that there's also when you think about terms of how, bulk data might save you time up front of putting data into the system, , it does add the value, or the, you have to start working with clearing accounts and managing clearing [00:12:30] accounts, we hear can be burdensome at times especially when you're carrying over from one month to the next month.
[00:12:36] Dan DeLong: I'M sure, Rachel, you totally disagree with that, right?
[00:12:41] Rachel Dauchy: Yeah, that's all I do. But can we ask you a question? Are you saying that you don't do summarized bulk entries, or you do?
[00:12:50] Marc Kalman: Not yet. Not at this time. We are. So it's individual sales receipts. Correct. It's individual sales. But we, what we do with that though, Rachel, is we came out [00:13:00] with, we give people options on how they want to bring the data in.
We listened carefully to what the complaints about details were and we try to do our best to give people options so that we can address those complaints. So one of those is, the assumption is if I get individual sales in, then I'm gonna have a million customers clogging up my QuickBooks account.
So we give people the option to do that if they prefer, right? If they want to clog up their system with a million customers, they can, or they can map all of that to a single bulk customer[00:13:30] as well. Same thing with items. They can track item details if they want. Or they can load it all to a bulk item.
What's nice though is even when we do that, on the actual sales receipts and refund receipts, we keep what we refer to as breadcrumbs because the data that is displayed on those sales receipts is minuscule being able to show you on the sales receipt who the customer was, what the address was if you need it, which actually we used to our advantage, by the way, in helping do sales taxes, which I'll talk about [00:14:00] in a second.
Know, we're still able to map all that to a bulk customer. But in the event that you do have to go track some. Things down that didn't go right. You can go to the sales receipt and see all the details right there on the sales receipt if you need it.
[00:14:14] Gennady Klayner: And the other thing to note is every feature that we put in we didn't do this in a vacuum.
We worked with a lot of accountants, a lot of pro advisors. We listened. More than we spoke, we took a lot of great notes. We showed them our [00:14:30] prototypes and different iterations and the bulk of the folks that we spoke to. That's ultimately what the consensus turned out to be is what they ultimately wanted because they were struggling with lack of those details.
When something went wrong, and usually, as they tend to happen,
[00:14:49] Dan DeLong: And if you're using, if you're using QuickBooks for helping with the, as the basis of your business ecosystem, which is really what's what QuickBooks is mission is right to be the [00:15:00] ecosystem of small business, and you then defer all of your inventory management, you can work with.
Activities to Shopify. Now you're unable to make some of the key critical business decisions in QuickBooks, because you've now put that in another. In another application or another land now, there may be a there may be a good cause for that. Or there may be a good use case for that.
But that's what I'm seeing in this in this landscape [00:15:30] with okay, this push to QuickBooks online. And it does do things okay for the things that, that you do things in and Rachel, as we had discussed, right? If you're managing your inventory. In QuickBooks, right?
There's only a certain number of of use cases for that. And in this case, it's the reseller, as you would call it. I buy stuff and I sell stuff in order to track that in for information inside of your QuickBooks. [00:16:00] And so that, that does leave out okay, people who need to you know, track their manufacturing or, multiple inventory management.
Workflows, but you know as time goes on you'll be able to You know bridge that gap no pun intended right Marc. Yeah
[00:16:18] Rachel Dauchy: For this kind of thing for people that do manage their inventory and QuickBooks something like this is great because I'm thinking of I make all my clients give me [00:16:30] access in Shopify, but in the event that maybe we don't have all the access that we need in Shopify and when there's mistakes, oftentimes I have to go to Shopify and go to the order and go to the source and.
search and, find various things in Shopify. And in this situation, if it's bringing, maybe even if it does have a generic Shopify customer if I've got the order number and I, want to look and see some of the specific detail on the order, and I do have it [00:17:00] there in QuickBooks, then.
I have a team and then we can skip that. Okay, then I have to log in with my user into Shopify and so on and so forth. Cause I feel like part of half my day is giving access for people to get into this, that, and the other. So if it's in QuickBooks, then people like my team can have the detail that they need.
To, complete month end, or reconcile, or do whatever they need to do. That is a little bit [00:17:30] easier. If, for some reason, I don't have the access yet, or, whatever reason.
[00:17:37] Marc Kalman: Isn't that a
[00:17:37] Gennady Klayner: lot of work? Yeah, that's a lot of what we used to hear. And still hear a lot from the folks that we speak to.
And, to be quite frank from a software development standpoint, it's a lot harder to grab all those details and to synchronize all those details and the level of details that we do. And so that's one of the reasons also that we wanted to tackle that first. Because [00:18:00] giving you a subset of that and just giving you, very little information is a lot easier to do for us once we've got.
The more vast majority of that
[00:18:09] Marc Kalman: taken care of. Exactly.
[00:18:11] Dan DeLong: Like you're you're third and fourth bullet points about importing the Shopify sales tax into QBO and managing physical and economic nexus in QBO. Yeah, I'm
[00:18:21] Rachel Dauchy: very curious to see what they mean about that. Yeah,
[00:18:25] Marc Kalman: we are very excited to show you.
tHis
[00:18:28] Dan DeLong: is what, this is what [00:18:30] applications end up doing is they end up app. Amputating the feature functionality inside of QuickBooks by the way that they integrate into QuickBooks. If you're paying your sales tax and you find a way to be actual, actually use.
Sales tax in QBO, which, there's a lot of arguments for pros and cons of doing that and how it's actually, handled and especially when you have, multiple economic nexuses in multiple different states, how is that going to [00:19:00] be, that, that's just a headache waiting to happen for the salt of the earth, the sales and local tax folks.
But yeah. If you are using QuickBooks for some of these, for some of these functions and it's sending over journal entries you're, that's now, it's a feature that you can't use now because of the way that is now bringing in that data. So now you have to figure out another.
Work around for something that's a should be a core [00:19:30] function, you know inside of
[00:19:31] Marc Kalman: QuickBook, right? Exactly, and I
[00:19:34] Dan DeLong: just realized Marc that my logo was over top of your head. So I apologize I'm gonna reach I'm gonna shift us around. So now we're down to bottom. So Now the the closed captions are over us all.
So we're all
[00:19:48] Marc Kalman: equally distributed, right? Yeah that's a great point you bring up, Dan, and that's one of the things that so as, the basis behind, like the details, we try [00:20:00] to, you Understand that, time is money and, one of the issues that, bookkeepers have with details is it can consume more time.
So every feature that we're rolling out, we're thinking about that. In fact it's not out yet. And we'll keep it between us and this audience, right? It's soon to be out. In addition to what we find when it comes to things like payouts, right? Our competitors, they do a nice job of taking those payouts and using those payouts to create the sales, right?
Days [00:20:30] later after the sale occurred. AnD so what we looked at, we were like Hey, we're getting the sales in immediately. Like literally immediately within seconds of the transaction occurring on Shopify and we have all the data And so now we can give the bookkeepers a perspective of you know what here's my actual sales that I got this month well when the payouts come in couldn't we also take those payouts and bring those payouts in and You know the number one complaint we heard about the detail was having to [00:21:00] go in and create deposits And you know there's a thousand sales receipts Check off a thousand sales right to recreate that deposit manually So we said we could do that for you Right and we could take those payouts and bring them in and we have the sales We know which sales are on the payouts and just create the deposit for you automatically So you don't have to
[00:21:20] Dan DeLong: do that.
And that's what we were and that's what we were discovering When we were talking about the other sales bridges A couple weeks ago is that a lot of times, a lot of [00:21:30] bridges are great about bringing in that detail and that sales information into your QuickBooks, but that nebulous payout is not.
Is not connected and that's why you end up having to use these clearing accounts and then it's more of a manual reconciliation process for someone like Rachel to go through and make sure that everything that was deposited is deposited and refunds and fees and all those things are balanced out.
But you [00:22:00] take a different approach to that as opposed to Okay. Everyone else out there. I think that's a key distinguisher, I think, of what we integrate does. We integrate does. Even though it's a plural pronoun, it's a singular verb. So
[00:22:18] Rachel Dauchy: is it posting a payout? To be expected, deposit entry, is that what it's doing?
[00:22:26] Dan DeLong: Why don't we just go right into a demo, Marc, and then
[00:22:29] Marc Kalman: you can [00:22:30] show it. Yeah, so I could, we could talk that through. Yeah, I could absolutely show that. And we could definitely go into a demo. Do you want me to start that now? Yeah, okay, cool. All right. Just let me have to flip to a different screen So when it comes to the payout though we are still working on it.
It's not ready for prime time yet I can show you though how it's going to work but if you want me to show you the orders first or you want me to start with that? Yeah question let's,
[00:22:53] Dan DeLong: Let's start from the beginning, and work, work through and then build up to that [00:23:00] PST resistance of the
[00:23:01] Marc Kalman: pair.
Love it. All right. Sounds great. All right. So this is we integrate it's web based. And when you first set up a client when a client is getting it for the first time, there's a very simple, multi step wizard. You just walk through. It's like one type of question per page.
It guides you through. If, when you've done one and you go to the next one, you're familiar with it. It's very simple. It takes less than 10 minutes to set up. The key is making sure that QuickBooks has the elements set up inside of QuickBooks that you need in order to, connect [00:23:30] things the right way.
We have help guides. We have a whole online portal, by the way, a community you could tap into. And, there's other pro advisors out there and we created a special room that you guys can share ideas and collaborate on it if you want. But we have all the help guides you need. And of course, support to help you get through stuff.
I'm not going to take a whole lot of time at all because I don't think anyone's here to understand, to spend time on settings, but just to show you that we have a series of settings. We do settings at two levels. We do it at a high level and then we do it at a store level. So things that might be common [00:24:00] across sales, such as, when we create a sale, where's it going to go, right?
So you want to, in our case, you might not have to use clearing accounts anymore. You go into the undeposited funds because those payouts are going to come in and create deposits. There's a couple other things I just want to point out. These, when you see a Manila, Manila drop down in our system, it's usually an indicator that the data that's part of that drop down is custom to the QuickBooks company you've created.
So this is just a custom list of, accounts. that relate to deposits and banks and stuff that I would link to where if you [00:24:30] see like a gray background it's, these are static options you can choose from that'll impact the experience inside of QuickBooks. For example, you get to decide when we create those sales receipts, who should create the sales receipt number.
Do you want QuickBooks to use their sequencer or do you want to use the Shopify order number? As a sales receipt number. Oh, that's
[00:24:49] Rachel Dauchy: cool. We have problems with that.
[00:24:51] Marc Kalman: Okay, cool. I like to hear that. And I'll tell you, Rachel, too, we also have it where even if you choose the QuickBooks online number, we make a natural [00:25:00] connection.
It'll be like, and you'll see when I do the demo here in a second, that even from QuickBooks, you'll know that this sales receipt number is the Shopify order number without
[00:25:09] Rachel Dauchy: having to. That's cool. Cause I have people that are also creating sales receipts. QuickBooks themselves, so they get confused on what order number, I mean what number to use next because we've also got sales receipts coming in from connectors and so it throws them [00:25:30] off.
They don't know what to do. And I don't have a way of changing that,
[00:25:33] Marc Kalman: right? Exactly.
[00:25:34] Dan DeLong: Exactly. That brings up an interesting point. I just want to put a pin in your demo there. So if you're using Sales receipts, Rachel, then it's going to pick up the next sequence from the Shopify order.
Is that what ultimately happens? Yeah. Potentially
[00:25:49] Rachel Dauchy: you've got duplicated
[00:25:50] Dan DeLong: numbers, which QuickBooks doesn't like.
[00:25:55] Rachel Dauchy: Yeah. And so they, although they're creating invoices, not sales [00:26:00] receipt, not sales receipts though, but it won't default to the next. Available number from the last one that they did because it's accumulating all the Shopify order numbers.
And it's and then in some other cases, it's if it's a different payment processor, it's like throwing a different number on there and sometimes it can get really convoluted. Anyway, I like the fact that there's this designation. It's nice. Yeah,
[00:26:27] Marc Kalman: great. Thank you. Another thing to
[00:26:28] Gennady Klayner: point out the [00:26:30] settings that Marc is showing here, these are the same ones that you would have set in that initial wizard.
And so after you've set it in the wizard, if you want to come and tweak them they're basically available to you at any time.
[00:26:42] Dan DeLong: You're not carving anything in stone. No, exactly.
[00:26:45] Marc Kalman: Exactly.
[00:26:45] Rachel Dauchy: And you guys said that you didn't want to go over settings, but settings is like the one thing where everything gets messed up.
So I always need to pay a ton of attention to settings cause that it's just the, always, that's always where the [00:27:00] most important stuff is,
[00:27:01] Marc Kalman: right? Okay. Hey, we're happy to spend a demo doing settings.
On that topic. So I. I switched over to our refund settings, which as you can tell is very similar to the sales settings, right?
At the high level the options that it gives you the one difference here is at the bottom. So we've learned a little bit the hard way as we were going through the process that Shopify and QuickBooks don't always see eye to eye on how to solve a problem. And then always play nice in the sandbox together, right?
So refunds is one of those examples, right? Because [00:27:30] Shopify will let you create a refund. For an item, or based on an item, I should say, as well as just opening up an order and issuing a 20 refund, with no item associated with it because, let's say, the shipment arrived late or something, or the customer wasn't happy and QuickBooks doesn't like the latter.
In fact, it will reject it a hundred percent of the time when that happens. In speaking with Intuit, they said the best practice they recommend following is that you create a service item dedicated for handling those types of refunds that don't have [00:28:00] items. And then what? So what we do is when what we refer to it as a no item refund comes in the door.
You can map it to the item now. My example, I'm calling this item no item refund for store one. The point here is this came from my custom QuickBooks list, so you're free to, you name it, whatever you wanna name it, and then you just pick it off the list and you map it here, right? But it gives you a place to store all those refunds inside of QuickBooks that don't have, does that
[00:28:26] Dan DeLong: mean that all have items?
Does that mean that all refunds will go to that? [00:28:30] Or all refunds that don't have inventory associated
[00:28:33] Marc Kalman: with it? iTems specified. Inventory is the issue, it's the item itself. If the refund has an item, so let's say there was three items ordered, customers returning one of them, and item, and a refund is getting issued against that one item or a partial refund is getting issued for some reason against that one item, then that will go in, Branch QuickBooks with no problem, against the item that it's for.
This is only for the situations where there is zero [00:29:00] items on the refund at all. And this gives you a place to put those refunds.
[00:29:07] Gennady Klayner: Yeah, for example, what we found some of our merchants tend to refund a certain dollar amount when the
[00:29:14] Marc Kalman: order is delayed in fulfillment.
[00:29:17] Gennady Klayner: And so they're refunding it on the Shopify side, but there's no item associated to it.
[00:29:22] Marc Kalman: So that's what that's for
[00:29:24] Dan DeLong: leave it up to customers to be very creative in, in handling those things. And [00:29:30] then leaving it up to the accounting professional to sort it out.
[00:29:33] Marc Kalman: Rachel?
All right, so I'm going to fast forward to get into some other settings since everybody's excited about the settings. Just I'll do it. I'll show you very quick. One thing. So I went to our connections area here which is where you manage the actual connections, right? So in a we integrate account, there's one QuickBooks company and you can, disconnect it and reconnect it or, put a different company attached to it.
But you [00:30:00] could have Unlimited Shopify stores. So even though we're only doing Shopify right now, there's no limit to the number of Shopify stores that you can have. And knowing that, one store is not always the same as another store, whether it be, same items, but one's, B2C and one's B2B or someone selling housewares in one store and fashion or another, how they might want to treat. The data from each store might be different, right? So we give you store level control over that. And I'm going to go into this one store Sydney [00:30:30] star boutique to show you the settings we have. So we have three tabs here at the top. We have customer matching item matching, and then sales and deposits.
So under customer matching the way I have this store currently set is in fact, you go to a bulk customer. That I called bulk shopify store one again for you to call it whatever you want to call it But I could manage those customer details if I choose So you could come in here and you can then say how do I want to match it, right?
So you get a primary match as a default which this would be [00:31:00] shopify and this would be quickbooks, right so I could match let's say any option here email company name first name last name or any combination of Things you see here to, some field in QuickBooks, whether it be the customer name, email, or the phone number.
moSt people probably would say something like email to email, but, I like to do email to customer name if you want. And then you have an optional secondary match that you can click on. So let's say email to customer didn't work so now let's try phone to phone. We found stuff like that works really [00:31:30] well with some of the companies that have been around for a while, like their older family businesses and their primary use of Shopify as a POS.
In that old family business, they have customers, since whatever, and a lot of those customers don't have email addresses. So they might try to do an email to email first for the newer customers and then default to phone. It also works well for B2B. There's B2B use case here.
So if you want to have one store that does B2C and B2B, we have a cool way of being able to address that. But that's optional. And then you [00:32:00] tell us, or we integrate, we'll be, can be set to say, okay, so let's say I'm trying to find a match and I can't find a match. That customer doesn't exist in my QuickBooks yet.
What do you want? What should I do? You have two choices. You could then just, throw it back into a bulk customer, like a customer clearing account, if you will, that you can go and deal with on your own. Or, we can go ahead and create the customer for you. Or we'll pull the Shopify data in, add a couple of additional fields that are not You know, privy to Shopify and then go ahead and create that new customer.[00:32:30]
So that's the option there. But I'm going to keep this as bulk. And under item matching, we have the same thing. I'm going to load today into bulk items, so you can see how that works. We let you map to a gift card liability when the gift cards are sold. But I could do details, like we said. So here, we can match, the most, as we Shopify requires a name or title, and QuickBooks requires a name.
So those are, Always the guaranteed ones that will have values, but that may not work for some people, right? So we do [00:33:00] offer the ability to map skew plus variant as well as UPCs from Shopify into your choice of skew or product name into QuickBooks, depending how the QuickBooks company is set up. And just like with customers, what should we do if we can't find a match?
We can go ahead and create that new item for you or let you load it into a bulk. Item clearing account that you'll deal with separately. So give you those two choices And then under sales and deposits we have two area two things [00:33:30] or two main categories right now the first is because we're pulling those taxes in from Shopify and the way QuickBooks works in the sense that It will let us override the taxes, for the main part of the system where the items are, but it won't let anybody overwrite the taxes when taxes has to be assigned to shipping.
So again, in speaking with Intuit, what they recommended is create a shipping line item that goes to whatever shipping income account you [00:34:00] have. And then we map all the shipping to that line item because we're asking people to do that as a preferred method. We're bringing, we're adding a couple pieces of value to that for data that you weren't able to see before.
Number one,
you can, because it's a line item, you can announce shipping on a sales receipt. In addition to that the Shopify shipping type, let's say a service level, let's say it's, economy versus rush. [00:34:30] As an example, we pull that into the description of the shipping line item so you can now see that in QuickBooks as well.
Then, under deposits, and this is part of our, soon to be released, so shh, don't tell anybody about this part yet. We we so when we're going to create the deposit, which bank account should we map this deposit into for the store, right? You create your checking account where, what account are we going to map the Shopify fees to?
And again, you have the option to add class. [00:35:00] And then what should we do with all the stuff that doesn't have? A match, if you will whatever comes in that payout, that might be like quote unquote miscellaneous category stuff, or we can't find the sale to match it against, put it all into this, sales account, quote unquote clearing account, and then you can deal with it later, but we'll give you the details on that, and I'll walk us through an example there.
So before I get into some document processing, are there any other questions you guys want to ask about the settings? Okay, all right, let's do it. Rachel's chomping at the bit.[00:35:30]
[00:35:30] Rachel Dauchy: Okay, let's say I'm not managing my inventory in QuickBooks at all. Where, I don't see settings for COGS.
[00:35:39] Marc Kalman: tHe cost of goods we pull in from QuickBooks.
[00:35:42] Rachel Dauchy: Yeah, but do you have the option to map the cogs to different classes and that kind of thing? And group based on SKU or any of that? Because I know that, this is beneficial for matching the item in QuickBooks, but in [00:36:00] the situation that I still want to bring in sales receipts into QuickBooks this way, but I'm not managing inventory in QuickBooks.
[00:36:08] Marc Kalman: YEah we don't have that set at the moment, that'd be a great enhancement for us to bring to Marcet. Okay. Yeah.
[00:36:15] Rachel Dauchy: Because I have some people with that situation. We still want sales receipts, but cause we still can do undeposited funds is fine, but I, but we're not managing inventory and QuickBooks cause they're [00:36:30] manufacturers or something like that.
[00:36:33] Dan DeLong: And also see this with like Shopify point of sale, for example, if you're if you're, managing the inventory there and not in. Not in your QuickBooks, you really just want the financial impact to come over, which could come over as a, at the end of the day, or as a group, one big transaction, as opposed to, each individual sale, causing a COGS to
[00:36:59] Rachel Dauchy: be, an entry.
Yeah, so I [00:37:00] would say that this situation is ideal for or to utilize all of these settings and functions would be for somebody that's managing their inventory in Yeah.
[00:37:09] Marc Kalman: Okay.
[00:37:10] Gennady Klayner: Yeah. Okay. But even if you're not managing the inventory, that's ultimately where the bulk customer sorry, the bulk item comes in where you don't really care about the inventory side of it, but you're still able to create that sales receipt and still capture all those
[00:37:24] Marc Kalman: details.
Okay. Okay, cool. [00:37:30] So how about I'll go and process a couple documents so you can see how the data flows between Shopify and QuickBooks. All right. All right, so I'm going to go to this Shopify store we have here. You'll have to excuse my web design, or my store design.
I'm going to just add a couple of products. Now what I'm going to do is I'm going to put in Cuz, oh yeah, before I send this over, I actually, you know what, I want to show you a couple things real quick, so I'm going to backtrack. Let me, it looks like is QuickBooks still open? Oh, good, one more time, [00:38:00] perfect.
Okay, when it logs you out in the middle of a demo, Okay, so I want to show a couple things. So I'm gonna go over to taxes, since we've been talking about taxes, and I'm gonna come under Call attention to a couple areas here. So the first one is, where's my New York?
There it is, okay. So we have New York tax, right? Showing up here, on here, and then we have under [00:38:30] economic nexus. We have Illinois, right? And you can see, we've already been tracking some economic nexus here. Cause Okay, this is cool.
[00:38:42] Rachel Dauchy: Cause I never touched the sales tech center, but now I'm seeing that I could use this even for people that are managing their inventory in QuickBooks.
To bring them in this way so that way we can use this and it's more visibility for my client to see where they're [00:39:00] You know the nexus tracker and then even as the payment gets applied it can get applied to its own thing instead of just
[00:39:07] Marc Kalman: one bulk, right Exactly. Exactly. Okay. So here I'm going to I'm going to do, I'm going to go ahead and process order from, just order from Shopify.
And the first thing I'm going to do is I'm going to do it for for New York and I'll do an order for New York and then I'll process the same exact order. Let's say for Chicago. So I can show you that or just where so let's go ahead and check this out. Let me come up with a fake name [00:39:30] here.
I'll call it Terry Tester today at test.
[00:39:35] Gennady Klayner: com. Let me go through this
[00:39:38] Marc Kalman: real quick. And then we'll assume there's a 10 Main Street in Chicago.
If anybody's from Chicago, you'll have to excuse me on that. Illinois, and I'll just pick a zip code at random. Okay, I'll go with the one that Shopify recommends. And you'll notice you know what? Actually, I'm going to take a step back here, too. Let me show [00:40:00] you something. In this is the back end of the Shopify store that I'm processing that order for if I come into settings here, I just want to call out, right?
So we have our business address here, which is in New Jersey, right? It's just a test address here. And under this location, we have three additional addresses. We have the New York, New warehouse, a Kansas warehouse and a South Carolina warehouse. So Shopify, because of this, knows that there's four physical locations that exist throughout the United States, and Shopify knows how to take that and manage [00:40:30] the physical versus economic nexus, right?
So if I put an order in for New York, Shopify will know. That they should charge tax. If I put an order in the shipping to Illinois, Shopify also knows not to charge tax, right? And you'll see that as I go ahead and doing this. QuickBooks, on the other hand, does not know that inherently, right?
Because QuickBooks is focused on pretty much one address. And it's not designed to be a multi address system out of the box, but we trick it and I'll show you how we trick it. [00:41:00] You have your ways. We have our ways. I'm going to come in here and I'm going to first process this order for Illinois and you can see there's no tax over here and the total of the order comes to 75.
99 with the 15 economy shipping. And I'm going to put a fake credit card number in here. I'm
[00:41:18] Rachel Dauchy: sitting here wondering, how are they going to trick it? Maybe just turn it on?
[00:41:22] Marc Kalman: You'll see. You'll see.
[00:41:26] Dan DeLong: I think Rachel's sitting on the edge of her seat. I think it's actually, [00:41:30] she
[00:41:34] Marc Kalman: Okay, so I put the first order through.
Now I'm going to go through, I'm going to do the same exact thing, same exact order, same shirt.
[00:41:42] Rachel Dauchy: Because I think you can just go into the sales tax center and just say, I have an obligation in this state now, turn it on, right?
[00:41:51] Marc Kalman: But and you can, and that's primarily how that part works. The issue though is that when QuickBooks figures out which tax agency to, [00:42:00] uh, assign a tax to, it, it does it based on the information that's presented on the sales receipt.
[00:42:08] Rachel Dauchy: Yeah, and then it creates a separate GL account for that one, and then you can't ever undo that. Okay, I need to know exactly! Tell me now!
[00:42:20] Dan DeLong: Demanding. We're almost
[00:42:21] Marc Kalman: there, we're almost there. so We're gonna see. Terry has a sister, Tara. Tara. Tara Tester. [00:42:30] That's what comes to mind. You know how many times I've had to come up with these big names. Tara Tester. And Tara Tester lives in, let's say, 2500 Broadway, here in New York City. And Tara, being a New Yorker it has to have things shipped faster.
We're going to pay 36. 90 for shipping. Now you'll notice Shopify made the association, right? New York physical address shipping to New York. So now we need to charge New York tax, 8. 70, [00:43:00] for a total of 106. 59. So I'll come in here and use the same fake credit card number I used before.
And we'll go ahead and process that. Order.
All right. Order's through. Now let's come back to the integrate. You'll see we have a red bubble one here at the top. So that first order that I processed has already gone through. And I'm going to show you that here in a second, but keep your eye on that one. Just like another [00:43:30] couple of seconds.
Now it's become a two, right? That's that's how fast we integrate. And this is a demo system. Wow. That's pretty cool. Thanks.
[00:43:41] Dan DeLong: Thanks. And there wasn't anything that you had to do to push it over there. You.
[00:43:45] Marc Kalman: Exactly. That's a very
[00:43:46] Dan DeLong: good point. As soon as it gets, as soon as it gets in there
[00:43:49] Marc Kalman: it's there.
Exactly. Yeah. I'm showing you through the system today, but most of our clients come in here periodically when they need to. But yeah, whether you come in our system or not, it's truly set it and [00:44:00] forget it. Once the connection is made, it just automates whether you do something or not. And so just, these are the two orders that came through.
Right, 1334 and 1333. You'll notice if you remember the amounts I showed you on Shopify, they're to the penny here. We give you some additional options where you can hover over the person's name and get the address to be able to ship to email. Eventually we're going to have details here, but we're trying to focus on the things that people are most interested in right now.
And this is like a later thing. People are getting all the data inside of, you QuickBooks.[00:44:30] Then you'll see here we give you statuses, right? So this is something we think we do, it's cool. We show you workflow. So we show you that both of these have been paid. Paid in full, in this case, versus partially paid, or partially refunded in this case.
And then we give you shipping status, right? Neither of these have been shipped, whereas this one has been partially shipped. When something is shipped complete, we move it to the fulfilled sales folder. And then, same thing here for cancellations, refunds, and you see our new payouts folder over here with the private feature logo there.
Now when I come over here to these two [00:45:00] columns, this is the date we received it and we integrate, which is usually, instantly for the most part. And then this is the last time we did a sync up with QuickBooks. And you'll see this one the first one went in, and if I hover over this, even from here, Rachel, you can see that there's the order number for 1333 all the way on the left.
That's the Shopify order number. When I go into QuickBooks, I'll see it on their sales receipt 2866 because I'm doing the different numbers. But obviously if someone's doing, using the order number from Shopify as a [00:45:30] sales receipt number in QuickBooks, it would have the same value. Does it, will it still
[00:45:34] Rachel Dauchy: show a reference for 1333 or no?
[00:45:38] Marc Kalman: Yes, it will. So if I go over the quickbooks. I get
[00:45:45] Rachel Dauchy: excited by the strangest stuff.
[00:45:48] Marc Kalman: And by the way, just for the record, when we came up with that capability, Gennady's the one that said, one day we're going to demo this in front of Rachel and she's going to ask that question. So we better be ready.[00:46:00]
But here you can see here they are, right? And here's the reference. So you can see sales receipt number 2867. And we also show you which store it came from in the event that you have multiple stores that you're processing. Yeah,
[00:46:15] Rachel Dauchy: because some of these people are going to have hundreds in a day.
That's why I'm saying
[00:46:19] Marc Kalman: this. Yeah exactly. And just wrapping this part up to show you that, that other question I've been making you wait to answer about how do we trick cookbooks.
[00:46:29] Gennady Klayner: And Marc, this is where [00:46:30] I go and wait, there's more.
[00:46:34] Marc Kalman: Yeah, so you could see here a couple things and there is actually, there's more, and then there's more on the more but here we have the bulk customer that we're loading this into, right?
And we're showing you the, what we call the breadcrumbs, right? On the sales receipt. So if you have to track this information down, it's here. And now you'll notice that here, the ship to state says Illinois and the ship from defaulted to which you. You might not have known this, but [00:47:00] the default address here inside of QuickBooks is this New Jersey address.
Okay? And there's no tax. When I come down here, by the way, just showing you the bulk item approach here as well. We load it all into this bulk item in QuickBooks, so it's not taking up that space there. But we give you the breadcrumbs of the items here as well. And how much the rates were from Shopify, etc.
Here you can see the shipping fee, that it's economy shipping. There's no taxes signed, and it ties out to the exact penny of 75. 99. [00:47:30] And this will get tracked by QuickBooks economic nexus tracker, as I showed you earlier, because QuickBooks now says I have a sales receipt that has a different ship from, than the ship to, so aha, so I need to track Illinois as a nexus.
If I come into the New York order I processed.
[00:47:52] Rachel Dauchy: Because it knows that you currently don't have Nexus there, but it still needs a track.
[00:47:58] Marc Kalman: It's exactly. [00:48:00] And then what will happen is eventually it'll catch up when it hits the threshold and it knows to move that over to the taxi. Yep.
Exactly.
[00:48:06] Rachel Dauchy: I like having that in QuickBooks. I'm, I used to be like, I didn't want anything in QuickBooks, but now like just from practice, I'm hearing some weird noise, I don't know from what, but I feel like now after like practical experience and dealing with some clients and seeing what they want to see and seeing how.
They understand the concept of Nexus a little bit better when that's [00:48:30] in QuickBooks You know what? And now I like that in there
[00:48:33] Marc Kalman: cool. Awesome and by the way, it's not saying you can't you know Even though QuickBooks has it there if someone wants to use another add on, solution, right?
Nothing's stopping that from happening, right? But at least, like you said, at least QuickBooks is in there and it's being tracked correctly. And
[00:48:47] Rachel Dauchy: then also, guess what? If they're sending out invoices from QuickBooks as well, even if they're sending out wholesale invoices, doesn't that all need to be [00:49:00] factored into Nexus tracking?
So this is consolidating all of the Nexus tracking.
[00:49:06] Marc Kalman: Exactly. Exactly. 100 percent
[00:49:08] Dan DeLong: correct. And then this allows you to use something like Davo, connected to your QuickBooks, to be able to impound those sales tax fees so that the business owner doesn't spend that on behalf of the state. And then get a nasty letter.
Yeah.
[00:49:25] Rachel Dauchy: And like the alternative is you have to dump your sales data if it's in an [00:49:30] external thing and it's not tracking the nexus. And then you have a client that's invoicing from QuickBooks online. Still, you have to consolidate it all together to see, if they're not, cause I have, I'm dealing with this right now.
One client is in a non connected inventory. IMS that I can't connect Avalara, so I have to manually crunch the numbers and track the nexus and add in the QuickBooks invoices. It's aggravating. I hate it.
[00:49:57] Marc Kalman: WE could talk after the show and [00:50:00] I'll be with that. One thing, one point I want to make, cause I know we're running out of time here too on that topic.
To call your attention. So you can see, I opened up that second sale that I created for the sales receipt 2867 here in QuickBooks. And you'll notice the ship to here now says New York, right? Cause that's where the customer ship to this is Tara tester. And what we did was we changed the ship from using the Shopify address for New York, since we, we checked that there was a match.
So we managed our logic on the Shopify side before we pulled the sale and made QuickBooks [00:50:30] use that New York address as the ship from. So now QuickBooks says I have a New York address going to a New York facility and knows how to deal with that
[00:50:39] Rachel Dauchy: properly. Oh, wait a second. Now you lost me. Wait, so you did that in the settings?
[00:50:45] Marc Kalman: No, this is not a setting. This is this is just live matching part of our logic, our algorithm logic that we use when we're pulling the cells from Shopify. This is secret sauce stuff. Secret sauce, yeah. Yeah, exactly. It's the magic [00:51:00] behind moving integrators. There is worst to sheer sauce
[00:51:02] Dan DeLong: in the
[00:51:05] Rachel Dauchy: Okay, so you're saying if the ship to is New York, then we're going to change the ship from to New York.
So those two correspond, only if
[00:51:16] Dan DeLong: they have a safe
[00:51:17] Marc Kalman: yeah,
[00:51:19] Rachel Dauchy: only if it, yeah, okay. Okay.
[00:51:22] Marc Kalman: Yeah. By the way, we do similar thing with. POS as well, right? For, if you have any clients that have multiple POS locations through one Shopify [00:51:30] connection and those POS locations are in different tax agency zones we find that, so we can replace the location of sale based on that store's physical which helps track the sales tax in QuickBooks correctly as well.
[00:51:44] Gennady Klayner: And we're doing that based on analyzing as Shopify orders are coming in and we are writing them out to QuickBooks. That is a part of what we're doing internally to do that.
[00:51:57] Rachel Dauchy: Man, that's cool. I haven't seen this [00:52:00] before. Where you can actually bring the individual sales receipt in with the state, ship to, and then track that.
I'm telling you I go through craziness sometimes and this is real cool.
[00:52:13] Dan DeLong: This is why I told Rachel, don't do any research on WeIntegrate before, because I want this blind, honest reaction from Rachel when
[00:52:22] Marc Kalman: she actually does get
[00:52:23] Rachel Dauchy: to see it. Yeah, it's really cool. By the way, I also love the name, because when you go into the not Shopify yes, yeah, Shopify [00:52:30] App Store, but even the QuickBooks App Store.
I like the name. It's just we integrate, it just tells you what it does.
[00:52:38] Dan DeLong: It's like changing your Thai restaurant to Thai food near me.
[00:52:42] Marc Kalman: OR I actually saw a restaurant in New York says you eat here. If
[00:52:49] Dan DeLong: you only get the restaurant that says, I don't care. Because that is, that's the restaurant that every married couple ends up going to.
I don't care, [00:53:00] you decide.
[00:53:04] Marc Kalman: So anyway, the jokes. So
[00:53:10] Dan DeLong: then another dis Distinction is what happens with those sales receipts with regards to payouts. So let's talk a little bit about that.
[00:53:20] Marc Kalman: Yeah, sure. Absolutely. Then this is part of what's still in process. And by the way just one other quick comment. I won't take the time during the demo to show you, but you see how the three fields here on the sales receipt for ship [00:53:30] via ship date and tracking number when that actually does happen in Shopify and order is fulfilled. We receive that information also fairly instantly from Shopify, and we load that all up here for people. So if you ever need to track that information here, you see it here again, and then
[00:53:47] Dan DeLong: you're not eliminating the functions that they could feasibly using in QuickBooks because they're using some other application to bridge the data between them.
So that's. [00:54:00] That's what I like about the way that you handle these things is that you still use the native functions inside of QuickBooks when possible. Yeah, that's pretty
[00:54:08] Rachel Dauchy: cool. So it updates that shipping information after the fact. It brings it in from Shopify.
[00:54:15] Marc Kalman: Correct. And we also add down here, so let's say there's multiple, Shopify creates the link where you can track the shipment.
We add those links here as well under the shipping free line item. Do they
[00:54:25] Rachel Dauchy: have to be using Shopify shipping or does it work if they're using [00:54:30] ShipStation?
[00:54:30] Marc Kalman: I Think it works if they use ShipStation as well, but I'll come back to you to confirm that, pretty sure. Oh, there's a question, Dan.
[00:54:40] Dan DeLong: I'm on full screen.
So looking so is the Shopify from Doug's leader of all, if the Shopify transaction ID also repeated in the reference number in QuickBooks, it appears to be the same number.
[00:54:55] Marc Kalman: thAt's. Yeah, sorry, go ahead. This would be a
[00:54:59] Dan DeLong: [00:55:00] good because I want to create a report that lists sales by reference number to compare with Shopify reports.
[00:55:07] Marc Kalman: Yes, that is, yes. Yeah, it's a setting. Sure. Yes. Short answer is
[00:55:12] Dan DeLong: yes.
[00:55:17] Marc Kalman: Okay, cool. Yeah, it's in
[00:55:19] Rachel Dauchy: the memo, right? Isn't it in the memo?
[00:55:22] Gennady Klayner: It's also in the memo and yeah, it's part of the settings on what you actually want to be displayed in the memo field, as well as what you [00:55:30] want to be set displayed in the reference number. Okay, cool.
[00:55:34] Marc Kalman: And then, okay. So coming over to payouts, let's talk payouts, right?
So this is just again, this is still in process. So you guys are getting a chance to see behind the curtain. In fact, if there's, if anybody wants to, we always take good feedback from people as we're building. That's what we try to do from our product management perspective. But you'll see here we have the Shopify payout number coming through the date of the payout, the [00:56:00] gross amount, the fees, and then that amount.
And this is the amount that should match the bank currency. Of course, how many sales are associated with that payout. And now we're showing you the status of the payout, right? So when the payout gets scheduled at Shopify we're going to bring it in here until we integrate, we're not going to push it to QuickBooks yet, but we're going to bring it in here.
Why? So we can give you visibility. Now we understand Shopify does give some visibility on that already, we're a, we're trying to build out some value here. And number two, that's, if you [00:56:30] have multiple stores and I have to go check that in multiple places, we're here, you can come to one place and see it all.
Yeah.
[00:56:36] Rachel Dauchy: Also may not have access to Shopify payout.
[00:56:40] Marc Kalman: Good point. Sure. So we're going to show you a schedule so you can see that, from a cash flow management perspective, you can get a little visibility into what to expect. Then we show you that it's in transit, right? So we'll change the status on it and then it goes to paid.
Once it goes to paid, we're going to use that data and auto create the deposit [00:57:00] ticket inside of QuickBooks online for you. And when we do that, because we have all the orders associated here and we know. Even if you use a different sales receipt number versus the order number from Shopify, we know how to match it.
We're going to check off all those sales receipts for you so that, that fear of having to check a thousand sales receipts to match up a deposit, don't worry about it. We're going to make that go away because we're going to do that for you automatically. And then what we're going to do is we're going to take the fees and put, at the bottom of the deposit where the We're [00:57:30] going to put all the fees down there and assign it to the account you specified in your settings as well as any additional items that came in on the payout that would go at the bottom to inclusive of any kind of offsets that might occur.
In the natural course of the process to ensure that payout matches the bank and now we're going to give you visibility where I don't think, and you guys can know better than us, but we don't believe anybody does this where because usually with a provider like us, you either get the sales or you get the payouts.
We're [00:58:00] bringing you both and we have the details so we'll be able to call your attention any sales that have not yet been paid, right, easily enough if that happens, right? Because we're not building the sales from the payout.
[00:58:13] Dan DeLong: Rachel, what are you going to do with all your spare time?
[00:58:16] Rachel Dauchy: I hate to burst your bubble, but the other providers also bring in the payout because I do that all the time.
But what I, but I will say is I like the fact that it is matching up. With the payout because now I don't ever have to worry [00:58:30] about undeposited funds because what I'm saying is if it's going to match the payout and I'm not using a clearing account and I'm and I am just using undeposited funds. And let's say I have maybe 5 or 6 different checking accounts because I have a different checking account for each Shopify store.
And then, but everything is funneling into undeposited funds, but it's pulling it and matching it. And I don't have to worry about undeposited funds. I definitely like that. I'm very reluctant to do that, but if it's, if this is foolproof, then, [00:59:00] um, then that's good.
[00:59:02] Marc Kalman: Yeah,
[00:59:02] Dan DeLong: That was my feedback to them when I saw this, because using undeposited funds, it has a plus sign in that undeposited funds.
Has a list, right? So everything that's waiting to be deposited will just show up there as I go through it as opposed to a clearing account where did it get deposited? Is it, how do I actually match that up? So being able to tie the transactions into a [00:59:30] deposit, then you'll be able to see what was actually part of that deposit, right?
But the challenge is that once you've now set foot in undeposited funds, then there's things that you can't do, like undo transactions that have been deposited. So that was my. Yeah,
[00:59:49] Rachel Dauchy: It can get a little risky sometimes, especially when your client is also invoicing out of QuickBooks and you've got their crap and undeposited funds too.
But I want to ask you guys one thing before we [01:00:00] have to wrap it up. I didn't hear you guys mention PayPal. My favorite.
[01:00:06] Marc Kalman: Yeah, we we on PayPal it's something that we're still working on. Okay.
[01:00:11] Rachel Dauchy: Yeah. Cause I, no I'm not even being sarcastic. I actually love PayPal.
[01:00:15] Marc Kalman: Yeah,
[01:00:16] Gennady Klayner: it's on our radar, but we wanted to stop start with the 1st 1 as we incubate this and make sure that it does what folks are expecting to do 1st
[01:00:26] Dan DeLong: and I do and I do and appreciate the fact that you guys are digging [01:00:30] deep into the.
into the Shopify vertical, right? And then you're picking up your learnings along the way and being able to say this works great, or this doesn't work great. So that when you go into other sales channels as you have your roadmap for, okay, let's tackle Amazon, let's tackle eBay, let's tackle WooCommerce or the other online sales channels, whatever that might be, you'll be able to lather, rinse, [01:01:00] repeat for using the shampoo analogy.
[01:01:03] Marc Kalman: Yeah,
[01:01:05] Dan DeLong: they'll all have their own, they'll all have their own nuances to them, but you'll have this good framework to be able to take to other Marcetplaces and sales channels moving forward.
[01:01:16] Rachel Dauchy: Yeah, I have to say the most impressive thing for me was the utilization of the sales tax center because I feel like the when I first started getting to a lot of different integrations and [01:01:30] becoming an integration. know how person, or I guess if you want to say specialist. I feel like a lot of the the theme of it was just keep everything out of QuickBooks, like just dump all the data in QuickBooks, but I appreciate doing more things in QuickBooks with even if you're not managing your inventory in QuickBooks, I appreciate utilizing these things in QuickBooks.
I want to use more things in QuickBooks, [01:02:00] I really do. And I really like that, and I also like the fact that just Dan these, all these bridges, you say bridge, I say connector, are just so wildly different. And, it's really confusing to a lot of people, but really spending the time and understanding how every single one of these works.
This is really different than a lot of the other ones. And so I really appreciate what you guys have done.
[01:02:28] Dan DeLong: Thank you. And our half hour [01:02:30] workshop went about 40 minutes over.
[01:02:34] Rachel Dauchy: Yeah, I know. I was like, when are they going to get into PayPal?
[01:02:39] Marc Kalman: Sorry.
[01:02:44] Dan DeLong: So talk a little bit about your promotion that you're
[01:02:46] Marc Kalman: offering. Yeah. Yeah. So we're excited to to share with with your audience here that if you go ahead and scan that QR code and you go ahead and register for a free trial by December 22nd, we're going to take a 20 [01:03:00] percent off your first three months and it comes with a 15 day free trial.
No obligation, no credit card necessary. You just sign up. The, obviously the caveat is you need a QuickBooks, company to test with and a Shopify store to test with, but yeah, you can go give it a shot. And we're happy to spend some time and answer questions and look forward to working with y'all.
Can I put this
[01:03:20] Rachel Dauchy: on this special? Can I repost it on my website, on my blog?
[01:03:24] Marc Kalman: Absolutely. We would love that. Cool. That would be great.
[01:03:28] Rachel Dauchy: I have so many followers.
[01:03:29] Marc Kalman: Yeah, we'll connect with you [01:03:30] offline on that for sure. I'm just kidding. I don't really. Five. All right.
[01:03:37] Dan DeLong: Good comment. Good comment from Doug. He calls it digital plumbing is is the way that he does all these connectors.
So appreciate you Marc and and joining us here today on our extended version of workshop Wednesday. What happened to Marc there? He turned blue. Oh,
[01:03:56] Marc Kalman: here I am. Yeah, sorry. Yep. [01:04:00] Yeah,
[01:04:00] Dan DeLong: getting the business goes on whether you're on a workshop or not. Yep. All right. Again, thanks. Thanks everybody for joining us.
And next time on the workshop is we're going to be talking about we're going to be shifting gears a little bit and talking about lightspeed lightspeed point of sale. And for those people that have, that are still in the QuickBooks point of sale, And want to migrate to another option. What we're going to do is have a side by side comparison over the next four workshops, whereas this is what you [01:04:30] do in QuickBooks Point of Sale, and this is how you do it in Lightspeed.
So we'll have a Thunderdome of point of sales on the workshop. So hopefully you can join us if you have some retail clients or if you are retail client yourself you want to know how am I going to do things from QuickBooks point of sale into Lightspeed. So we appreciate you joining us.
So hopefully y'all have a great day and we'll see you next time on the workshop wednesday.[01:05:00]
