Latest / QB Power Hour Podcast / Daily Sales Summaries and LightSpeed QB Integration
Transcript
- 0:32Dan DeLong (2): April Fools, everybody.
- 0:36Dan DeLong (2): Rachel, where are you?
- 0:42Dan DeLong (2): Alright, that fantastic.
- 0:45Dan DeLong (2): You
- 0:46Rachel D: got me.
- 0:46Rachel D: You got me.
- 0:51Dan DeLong (2): Welcome everybody to a QB Power Hour and I pulled up the wrong video intro video.
- 0:58Dan DeLong (2): But thank you for joining us here today.
- 1:02Dan DeLong (2): Sorry.
- 1:03Dan DeLong (2): Today is I think April Fools is being played on me.
- 1:10Dan DeLong (2): I have a very horrible internet.
- 1:13Dan DeLong (2): Sound was horrible right before going live.
- 1:16Dan DeLong (2): And of course now I've done some challenging things with the wrong intro video.
- 1:22Dan DeLong (2): But here we are.
- 1:24Dan DeLong (2): Today we're gonna be talking about daily sales summaries and, unpacking the Lightspeed QuickBooks integration, for summarizing sales data in point of sale from QuickBooks.
- 1:38Dan DeLong (2): My name's Dan DeLong, owner of Dan with and school of Bookkeeping.
- 1:41Dan DeLong (2): I worked at Intuit for nearly 18 years co-host in today, as well as the workshop Wednesdays.
- 1:50Dan DeLong (2): And the feature D the feature D.
- 1:54Dan DeLong (2): Oh my God, I can't say it.
- 1:55Dan DeLong (2): The feature, deep dive guest at the unofficial Facebook accountant podcast.
- 2:01Dan DeLong (2): So thank you for joining us here today.
- 2:04Dan DeLong (2): Now normally this would be Matthew joining us today, but unfortunately he's not feeling well, and he was, he sent me a video he's I know it's April 1st, and this is not an April Fools joke because he, had on video, he had his hair all it's 9:00 AM on, his time.
- 2:24Dan DeLong (2): So this was like very early in the morning for him to be sending a video, but playing the part of Matthew today is Rachel Doci.
- 2:33Dan DeLong (2): Thank you for for, filling in on such short notice coming out of the yoga.
- 2:40Dan DeLong (2): And,
- 2:41Rachel D: I was literally coming out of the yoga room and I was like, no problem.
- 2:44Rachel D: And I ran home.
- 2:46Dan DeLong (2): So for those that that don't know you, tell, us a little bit about your job.
- 2:53Rachel D: Sure.
- 2:53Rachel D: So in addition to co-hosting workshop Wednesday with you, where we always talk about something fun every week, my firm is called Net Deposited and we do all kinds of different bookkeeping and accounting, but one of our focuses specifically with what we're gonna talk about today with, these aggregated sales postings, which we do a lot in e-commerce bookkeeping, and we do a lot of that at net deposited and not necessarily just e-commerce, but even gosh, with everything it seems like everybody's using a POS system.
- 3:32Rachel D: So we do a lot of that at net deposited and I'm very active in the QuickBooks world and just happy to be here.
- 3:42Dan DeLong (2): All right.
- 3:42Dan DeLong (2): Thanks again for filling in on, such short notice.
- 3:46Dan DeLong (2): And we did a a daily sales summary workshop on the workshop.
- 3:51Dan DeLong (2): On the workshop Wednesday over at School Bookkeeping.
- 3:54Dan DeLong (2): So yeah, we just did
- 3:55Rachel D: like the other week.
- 3:56Dan DeLong (2): Yeah, so that was like a dress rehearsal for the QB Power Hour, which a little bit of information about the QB Power Hour, just turning in for the first time.
- 4:07Dan DeLong (2): It's every other Tuesday at 12 noon.
- 4:10Dan DeLong (2): We are available or for CPE credit or we do have a channel over at earmark to be able to get those CPE credit for for accounting professionals.
- 4:23Dan DeLong (2): We now have six, prior webinars available there on the earmark.
- 4:31Dan DeLong (2): Housekeeping.
- 4:32Dan DeLong (2): We're gonna be talking about the topic of, today.
- 4:35Dan DeLong (2): So if you have any specific questions about about the topic please put them in the q and a so we can make sure that we can capture those.
- 4:43Dan DeLong (2): If you're watching on the streaming platforms of YouTube which, oh my gosh, my computer just restarted.
- 4:53Dan DeLong (2): I hate Mac.
- 4:54Dan DeLong (2): I'm, sorry.
- 4:55Dan DeLong (2): I hate Windows machine.
- 4:58Rachel D: That's why I use a Mac.
- 5:00Dan DeLong (2): Yeah.
- 5:01Dan DeLong (2): Yeah.
- 5:01Dan DeLong (2): I was telling my son, Macs just don't crash.
- 5:06Dan DeLong (2): Yeah.
- 5:06Dan DeLong (2): Out of the blue like Windows machines do.
- 5:10Dan DeLong (2): So if you hear a jet engine that's my machine restarting in the background.
- 5:20Dan DeLong (2): So if you have the some q and a specific questions about what the topic that we're talking about today, please put those in the q&a.
- 5:27Dan DeLong (2): If you have general comments about whether you prefer Mac or windows, please put those in the comments or the, and then of course we have the, handout available there.
- 5:39Dan DeLong (2): Noah, if you can throw that, those links in the variety of places that we need them to go so that we can do that.
- 5:48Dan DeLong (2): 'cause I would've done that on the other machine that just restarted.
- 5:52Dan DeLong (2): So here we go.
- 5:55Dan DeLong (2): We also have a QB power Hour store for all your QB power hours, swag needs.
- 6:04Dan DeLong (2): Wireless chargers mugs, whatever.
- 6:08Dan DeLong (2): So let's let's talk about what's on the agenda today.
- 6:10Dan DeLong (2): Daily sales summaries is we're gonna unpack what they are, who needs them and then do a little demonstration of, doing them in QuickBooks online.
- 6:22Dan DeLong (2): And then we'll transition a little bit into Lightspeed point of sale and how they are handling the daily sales summaries.
- 6:30Dan DeLong (2): Now, all of this came up because over at School Bookkeeping, we have quick answers, feature which allows anyone, to, chat with with us there.
- 6:43Dan DeLong (2): And someone came in with a, challenge, because, they were using a subway.
- 6:53Dan DeLong (2): They, had a subway franchise that they were working with.
- 6:56Dan DeLong (2): And, subway had its own way to integrate into QuickBooks Online, and it was doing that with a daily sales summary.
- 7:06Dan DeLong (2): And, very familiar with how this all plays out with desktop and, QuickBooks online.
- 7:14Dan DeLong (2): But it, was integrating into QuickBooks online and there's a, snag.
- 7:20Dan DeLong (2): And that's what we really wanna unpack here is, there's a, yeah.
- 7:24Dan DeLong (2): But
- 7:25Dan DeLong (3): When
- 7:26Dan DeLong (2): it comes to doing daily sales summaries and QuickBooks online and and we'll talk about that as it relates to Oh yeah.
- 7:34Dan DeLong (2): Sales.
- 7:34Dan DeLong (2): I think I
- 7:35Rachel D: remember, yeah.
- 7:36Rachel D: It was the sales tax.
- 7:37Dan DeLong (2): Yeah.
- 7:38Dan DeLong (2): We'll, do that now.
- 7:40Dan DeLong (2): Oh, crap.
- 7:44Dan DeLong (2): Day is just a horrible technology day.
- 7:48Dan DeLong (2): But we did have some prior webinars.
- 7:50Dan DeLong (2): We do a, series here on, on the QB Power Hour called Niche Nuances.
- 7:54Dan DeLong (2): So I wanted to make sure that those were available in the handouts.
- 7:58Dan DeLong (2): We did convenience Stores with Alicia Kaz Pollock.
- 8:02Dan DeLong (2): She does she actually literally wrote a book about, handling convenience stores.
- 8:10Dan DeLong (2): They will typically not integrate with QuickBooks, depending on what, what's software they're using or if they're just using cash register.
- 8:22Dan DeLong (2): So that is that's a good, good one to review.
- 8:26Dan DeLong (2): And then we also had William English join us to talk about retail.
- 8:32Dan DeLong (2): I, was looking at this thumbnail too look how, young we looked.
- 8:36Rachel D: I know
- 8:37Dan DeLong (2): with Michelle and myself there.
- 8:39Dan DeLong (2): That was
- 8:39Rachel D: before I knew you too.
- 8:40Rachel D: Yeah.
- 8:42Dan DeLong (2): Wow.
- 8:43Dan DeLong (2): I think that was amid amidst the throes of Covid.
- 8:46Dan DeLong (2): Alright.
- 8:48Dan DeLong (2): All right.
- 8:48Dan DeLong (2): So our first poll question just to get things started here.
- 8:51Dan DeLong (2): What version of QuickBooks do you support your clients with?
- 8:54Dan DeLong (2): Has QuickBooks online or desktop or both?
- 8:59Dan DeLong (2): Whether that is now Rachel you, primarily or solely use QuickBooks Online.
- 9:04Dan DeLong (2): Or desktop or what, does it Yeah.
- 9:06Rachel D: I, used to use desktop a long time ago.
- 9:10Rachel D: That's where I originally learned desktop.
- 9:13Rachel D: When I learned QuickBooks, sorry, I was in desktop way back in the day.
- 9:18Rachel D: But when I started my business net deposited, I really wanted to exist in the cloud.
- 9:23Rachel D: So that was 2019.
- 9:26Rachel D: I completely learned QuickBooks online and never looked back, so I only used QuickBooks Online.
- 9:35Dan DeLong (2): Gotcha.
- 9:38Dan DeLong (2): And when we first started.
- 9:40Dan DeLong (2): Working together.
- 9:41Dan DeLong (2): You because you specialize in the inventory and, retail or e-commerce space.
- 9:49Dan DeLong (3): Yeah.
- 9:50Dan DeLong (2): Getting these daily sales summaries into QuickBooks is, a key workflow Yes.
- 9:57Dan DeLong (2): In, your practice.
- 9:58Rachel D: It's, really key.
- 9:59Rachel D: And with that, I remember I didn't really know a lot of the specifics of why'cause most of my clients sell stuff, even though we do, support service-based businesses now more than ever.
- 10:17Rachel D: 'cause inventory's driving me nutty, but we do support stuff.
- 10:21Rachel D: And there's so many different nuances about dealing with inventory and QuickBooks online that I really just needed to unravel every little thing and understand what it can do and what it can't do.
- 10:35Rachel D: So there's so many.
- 10:37Rachel D: Different elements to these sales summaries and why you would need it versus when you wouldn't wanna use it.
- 10:45Rachel D: And yeah, that, that's not really an answer but, basically there, there's just so much to know that it's really, helpful to zero in on one thing, focus on it, talk about it, understand why it's important to do a summary this way versus that way.
- 11:05Rachel D: Gotcha.
- 11:06Dan DeLong (2): Yeah, it looks like most of the folks are agnostic to the QuickBooks platform.
- 11:12Dan DeLong (2): About 59% support, both but then like you, 31% solely with QuickBooks online.
- 11:19Dan DeLong (2): So let's talk a little bit about daily sales summaries, what they are, who needs them and just unpack that a little bit here.
- 11:28Dan DeLong (2): But really what this boils down to is turning.
- 11:33Dan DeLong (2): The, Z out store close at the end of the day into a, sales transaction into, QuickBooks.
- 11:41Dan DeLong (2): And that may be something that happens automagically through whatever application that you're, that you might be using or entering it in, individually inside of, QuickBooks.
- 11:55Dan DeLong (2): But yeah, and
- 11:55Rachel D: I'll say that like we, we talked about this method specifically in the workshop Wednesday, and using a sales receipt entry form in QuickBooks online is definitely the traditional way.
- 12:08Rachel D: There's, other ways to get sales summaries into QuickBooks Online, but I just wanted to say that because I thought that was very confusing when I first started learning it this way.
- 12:20Rachel D: There, there's journal entries, there's different ways to get it in there, but I just wanted to say that.
- 12:27Dan DeLong (2): Yeah.
- 12:27Dan DeLong (2): The the type of transaction that you're going to be entering in these sales summaries is certainly going to either augment or pass the baton to, to, to the next workflow that might be necessary, or, put a limitation on that, depending on what what it is that you completely do inside of the, QuickBooks Ecosystem.
- 12:53Dan DeLong (2): So who really needs them?
- 12:55Dan DeLong (2): Let's talk about some of the the industries that, that will use those.
- 13:01Dan DeLong (2): Maybe the integration is not needed or not functioning right?
- 13:05Dan DeLong (2): So if they're using like a physical cash register, right?
- 13:09Dan DeLong (2): There's no way to set that on top of your computer and get it to go into QuickBook, right?
- 13:15Dan DeLong (2): End of.
- 13:17Dan DeLong (2): You're gonna zero out your your cash sales or your cash register for that day.
- 13:22Dan DeLong (2): And it's going to give you, in, general what was sold, what's taxable, what's not taxable what and the payment methods that you took throughout throughout the day on those cash registers.
- 13:38Dan DeLong (2): So that will be one in reason for, using a daily sales summary inside of QuickBooks.
- 13:44Dan DeLong (2): The integration is just not there.
- 13:46Dan DeLong (2): Or if they, want to do departmental accounting, right?
- 13:51Dan DeLong (2): So retail.
- 13:53Dan DeLong (2): Convenience store e-commerce.
- 13:55Dan DeLong (2): We talked about some of those, industries, they don't manage inventory or sales data in, in two redundant systems.
- 14:04Dan DeLong (2): So they're not necessarily needing to track their inventory comings and goings in a perpetual, action.
- 14:11Dan DeLong (2): And that's very,
- 14:11Rachel D: very common that we wouldn't do that in QuickBooks online.
- 14:15Dan DeLong (2): Because as we've talked to ad nauseum on the workshop, QuickBooks online is, great for inventory tracking if it's you are a reseller of goods.
- 14:29Dan DeLong (2): But not if you need to know much more of anything else about those goods where it is landed, costs all those advanced inventory functions.
- 14:38Dan DeLong (2): So if they're not tracking those perpetual inventory, daily sales summers that are, okay.
- 14:45Dan DeLong (2): Or they're using QuickBooks for, category tracking of
- 14:49Rachel D: Yeah.
- 14:50Dan DeLong (2): Again, those departmental things.
- 14:54Dan DeLong (2): So there's a little bit of pre-work when it comes to setting up QuickBooks for, the daily sales summary itself, right?
- 15:02Dan DeLong (2): So first is to create some kind of customer for your counter sale, right?
- 15:07Dan DeLong (2): So things that you can call it whatever you want.
- 15:11Dan DeLong (2): QuickBooks point of sale call the counter tail, right?
- 15:15Dan DeLong (2): But you can call that customer whatever it's Right.
- 15:19Dan DeLong (2): A, you can even do it by register if you wanted to, right?
- 15:24Dan DeLong (2): Just creating a customer to put on the, sale transaction.
- 15:29Dan DeLong (2): Yeah.
- 15:29Rachel D: And just like we, we do a lot of Shopify accounting and bookkeeping, and I always just create Shopify customer and that's if I'm bringing them in and using a sales receipt and, I need to put a customer in the field.
- 15:46Rachel D: We just do Shopify customer.
- 15:49Dan DeLong (2): Yeah.
- 15:50Dan DeLong (2): And I saw in the like the q and a that somebody was asking for, can we have a Power hour on Shopify integration with qbo, there's probably about 34 different ways to bring in a Shopify transaction.
- 16:04Dan DeLong (2): There's one built in directly into QuickBooks with through commerce to all of the other ones.
- 16:10Dan DeLong (2): I saw another person's using show go.
- 16:12Dan DeLong (2): And that was actually something that William had mentioned on the, prior power Hour.
- 16:20Dan DeLong (2): But the next thing after you set up a customer is setting up your desired chart of accounts.
- 16:27Dan DeLong (2): How much detail or general generality are you gonna need in the chart of accounts, side of things.
- 16:34Dan DeLong (2): So you just wanna set up, those chart of accounts first, and then set up items.
- 16:41Dan DeLong (2): Typically, they're gonna be non-inventory items.
- 16:43Dan DeLong (2): For each source of revenue or each of those items that are going to be pointing to those accounts that you've set up.
- 16:52Dan DeLong (2): So this will be, your, sources of revenue.
- 16:56Dan DeLong (2): So if you're gonna departmentalize the sales or just something as simple as these were taxable and these were non-taxable, because you have to have that differentiation on the sales transaction itself as to what was taxable and what wasn't.
- 17:12Dan DeLong (2): Payment methods you're gonna set up items for payment methods.
- 17:17Dan DeLong (2): And then sales tax, is there's a caveat there about sales tax.
- 17:24Dan DeLong (2): 'cause that's what we're really, Dr that's what's really driving the distinction of, doing this inside of QuickBooks online versus desktop.
- 17:36Dan DeLong (2): 'cause QuickBooks desktop does actually have a payment method or a payment item, and those are treated.
- 17:44Dan DeLong (2): And distinctly from QuickBooks Online, where QuickBooks Online does not have that type of item when you specify that.
- 17:52Dan DeLong (2): So that is a, unique distinction between the two.
- 17:56Dan DeLong (2): And that's one of the reasons, but you don't necessarily want to do a daily sales summary if you're doing sales tax inside of QuickBook online.
- 18:08Rachel D: Yeah.
- 18:08Rachel D: Then when you're dealing with multi-state though, it's, you don't wanna use the sales tax, the center in QuickBooks Online even'cause you, that's just it's, not sophisticated enough for that.
- 18:23Rachel D: Can I ask you a question though?
- 18:24Rachel D: Are Okay?
- 18:25Rachel D: Yeah.
- 18:25Rachel D: So with regards to Lightspeed,'cause that's what we're talking about.
- 18:30Rachel D: Does Lightspeed specify that you need to have the items.
- 18:36Rachel D: Set up as non-inventory as such in QuickBooks Online so that it'll find the non-inventory item and then post it if you're doing a sales receipt.
- 18:47Rachel D: Do you have to have those items set up?
- 18:50Dan DeLong (2): Yes.
- 18:50Dan DeLong (2): Yeah, you do wanna set up those items ahead of time?
- 18:53Dan DeLong (2): 'cause guess what?
- 18:54Dan DeLong (2): Just, what's that?
- 18:56Rachel D: I was just gonna say, in this world of automation and connectivity, I am really deep in that, and I'm working with an app right now that you cannot have the item set up for syncing.
- 19:11Rachel D: It wants to create the item, a non-inventory item, but you cannot have them set up already.
- 19:19Rachel D: It's so funny because like in these.
- 19:22Rachel D: It with the differences of the mapping and how things need to be set up to get the data over to QuickBooks online.
- 19:31Rachel D: They're so wildly different.
- 19:33Rachel D: And so one of'em, you have to follow this, these steps and set up your items ahead of time so it can find the item.
- 19:41Rachel D: Usually in the settings they'll be, if it doesn't find the item, it will create a new item and most of them are like that.
- 19:50Rachel D: But now I'm working in an inventory app where Zoho in that you can't sink anything over if there's an item and non-inventory item, it's gotta be all no items.
- 20:04Dan DeLong (2): Interesting.
- 20:05Dan DeLong (2): I know.
- 20:06Dan DeLong (2): Yeah.
- 20:06Dan DeLong (2): It sounds like Zoho a control freak.
- 20:09Dan DeLong (2): It's I'm gonna do this my way.
- 20:11Rachel D: Yeah.
- 20:12Rachel D: So it's, really interesting that every time I feel like I have a workflow down, okay, create the customer, set up the desired chart of accounts, set up the items.
- 20:23Rachel D: Oh, now all of a sudden now I'm working on one where no items.
- 20:28Dan DeLong (2): Yeah, The, all these different details and nuances of the, apps that integrate and how they integrate is certainly not universal.
- 20:39Rachel D: Yeah.
- 20:40Rachel D: Yeah.
- 20:41Rachel D: It's, wildly different
- 20:43Dan DeLong (2): right now, if you are using inventory and you want to track some of these things, these, you're gonna want to create income accounts and non-inventory items as well.
- 20:54Dan DeLong (2): And those will match to match the, point of sale systems.
- 20:59Dan DeLong (2): And then if you do purchases, you want those purchases coded to inventory asset, even though inventory is not used.
- 21:07Dan DeLong (2): For, this process.
- 21:09Dan DeLong (2): And then you would do, periodic adjustments to get those alignments of inventory value into QuickBooks.
- 21:19Dan DeLong (2): You wouldn't necessarily use inventory items and track those inventory items because the accounting is gonna be all sorts of differently handled.
- 21:27Dan DeLong (2): And really that's the big distinction about this whole, process is where's the inventory source of truth typically that's going to be in your point of sale system or or somewhere else other than inside of QuickBooks.
- 21:43Dan DeLong (2): So you can, you just want QuickBooks to mirror the accounting value that wherever you're tracking your inventory in.
- 21:54Dan DeLong (2): Yeah.
- 21:54Dan DeLong (2): Do you have any thoughts about, to add to that?
- 21:58Rachel D: Yeah.
- 21:59Rachel D: And this is really confusing.
- 22:00Rachel D: I'm telling you like I encounter people every single day that And my clients too, that they think they need to track inventory in both.
- 22:10Rachel D: That's a, confusing thing that I run into a lot, that they're tracking their ups and downs of quantities elsewhere and they think that they need to also track the ups and downs of, and quantities in QBO and all they're doing is like pulling their hair out, going, I'm tr I'm going up and down here and I'm trying to go up and down here.
- 22:32Rachel D: The same thing.
- 22:32Rachel D: No, we don't do it like that.
- 22:34Rachel D: Ups and downs of the individual quantities in your inventory system, whether that's Shopify, whether that's Lightspeed, whether that's wherever, valuation only in QBO on the balance sheet.
- 22:50Rachel D: That's it.
- 22:50Rachel D: We're not even using the inventory valuation.
- 22:54Rachel D: We're not, or the inventory summary report.
- 22:56Rachel D: Nothing like that.
- 22:57Rachel D: It is literally inventory is turned off.
- 23:00Rachel D: We have a value of inventory on the balance sheet.
- 23:03Rachel D: That's it.
- 23:04Rachel D: Period.
- 23:04Rachel D: End of story.
- 23:05Rachel D: You can, like you said, decrease that inventory with a monthly cogs entry or something.
- 23:10Rachel D: If you wanna pull that from your system, like if you're using Katana or something, you can go and pull your monthly cost of goods sold and post them.
- 23:18Rachel D: I typically pull in systems that will push a cost of goods sold entry with every point of sale.
- 23:25Rachel D: 'cause that's perpetual inventory.
- 23:28Rachel D: But even still, all you're doing is with a, COGS entry, decrease inventory, increase cogs a little bit with every single sale.
- 23:38Rachel D: It's just a balance sheet thing.
- 23:39Rachel D: That's it.
- 23:41Dan DeLong (2): Yeah.
- 23:42Dan DeLong (2): Now, now this slide is the Alice's restaurant.
- 23:46Dan DeLong (2): Slides got circles and arrows and, paragraphs on the back of each one.
- 23:51Dan DeLong (2): But, so I'm dating myself on that reference for those that may or may not have understood that.
- 23:59Dan DeLong (2): But the, daily sales repeat, and there's a link here to the Intuit article to and we'll, cover that as, as well.
- 24:07Dan DeLong (2): But you're gonna be creating that daily sales zero out tape from the point of sale system, and then use as$0 sales receipt to manually enter that into QuickBook.
- 24:21Dan DeLong (2): Now you're gonna be depositing it to the, deposit two is, is, important because if you put it to o undeposited funds inside of QuickBooks, you're gonna have all these$0 sales receipts.
- 24:37Dan DeLong (2): Sitting in positive funds, and that's a waste, right?
- 24:39Dan DeLong (2): So just put it to another clearing account or some other non non undeposited funds account so that when you record these sales receipts, it doesn't clog up your bank deposit screen.
- 24:55Dan DeLong (2): And then you'll want to use sales departments to track all that you want to or sales items, those sales items to track the differences that, that you want.
- 25:07Dan DeLong (2): So you would enter in I had a, like a mailboxes, et cetera type of type of client.
- 25:14Dan DeLong (2): They had their own unique point of sale system for, that, it was a franchise.
- 25:20Dan DeLong (2): And it did not integrate with with QuickBooks Desktop.
- 25:25Dan DeLong (2): He started at the time and then he didn't wanna pay for the integration in when he did finally go to QuickBooks Online.
- 25:32Dan DeLong (2): But it also gave him the ability to keep.
- 25:37Dan DeLong (2): Track of the numbers.
- 25:38Dan DeLong (2): He was very interested in the days sales, what was going up and going down.
- 25:43Dan DeLong (2): So he had created all of these items for faxing and shipping and packaging and gift card, or not gift card, but greeting cards.
- 25:53Dan DeLong (2): He had those they have all sorts of little extra things inside of that, the mailboxes themselves.
- 26:00Dan DeLong (2): So he wanted to keep track of all of the sales of those, different little things.
- 26:03Dan DeLong (2): He got it out of his point of sale system.
- 26:05Dan DeLong (2): So he would create those items and put'em into his daily sales summary.
- 26:12Dan DeLong (2): And then after you've got your sales your overages, your shortages, your gift cards, all the things that you do want to track, which increase the value of this daily sales receipt, then you would put paint those payment methods as negatives onto the daily sales summary.
- 26:35Dan DeLong (2): And that's why you would essentially be entering these daily sales summaries as nothing as a$0 sales receipt, which would then, do the accounting of here's what I sold, and then here's the payments that I received.
- 26:51Dan DeLong (2): And those payments are then gonna go to unde positive funds or wherever you need them to be deposited so that the money movement then happens.
- 27:00Dan DeLong (2): And then we've got the, Intuit article linking here.
- 27:06Dan DeLong (2): Let's let's ask our second polling question of do you use daily sales summaries?
- 27:11Dan DeLong (2): Yes.
- 27:11Dan DeLong (2): I enter'cause a variety of ways.
- 27:14Dan DeLong (2): You can enter them manually.
- 27:15Dan DeLong (2): You enter them automatically through an integration, maybe through a utility import, or, you need to record the sales by customer and you wouldn't do that sort of thing.
- 27:27Dan DeLong (2): Do you find Rachel that is mostly daily sales for.
- 27:34Dan DeLong (2): For the clientele that you work with?
- 27:39Dan DeLong (2): Nope.
- 27:39Dan DeLong (2): You're muted.
- 27:41Dan DeLong (2): I can't hear you.
- 27:46Dan DeLong (2): Oh.
- 27:47Dan DeLong (2): We have the same problem as before.
- 27:49Dan DeLong (2): Did you turn around?
- 27:50Dan DeLong (2): What about now?
- 27:50Rachel D: Can you hear me?
- 27:51Dan DeLong (2): There we go.
- 27:51Rachel D: There you're okay.
- 27:54Rachel D: It's half and half.
- 27:55Rachel D: I have people that I do bring in individual sales receipts on automation.
- 28:01Rachel D: And like what I was explaining before, we have certain situations which it'll create the item based on the mapping that I've set up in the original system.
- 28:13Rachel D: And then I have other situations where we have to have the items created, mapped to where we wanna go, and it still brings it over on individual sales receipts.
- 28:24Rachel D: I typically, when we're using point of sale.
- 28:27Rachel D: I typically have, I typically always use a sales receipt.
- 28:31Rachel D: I don't use an invoice because I don't want it to hit undeposited funds.
- 28:37Rachel D: I want it to point to a specific clearing account because, like for example, if my client's using something like Stripe to collect those payment methods, I wanna point it to Stripe Clearing because those payouts that are gonna come in through Stripe, I wanna clear out that clearing.
- 28:55Rachel D: And a lot of times they have more complexity.
- 28:57Rachel D: They have some other, they're using QuickBooks payments also, maybe with invoices they're sending out.
- 29:02Rachel D: So I like to separate those clearings.
- 29:05Rachel D: And for that reason I, am like, when you're talking about clearing accounts, you're speaking my language, but yeah and then the other half the people, yeah, we do use a daily sales summary.
- 29:19Rachel D: Usually the, connector tools that I use will put it in a journal entry.
- 29:26Rachel D: So rather than pointing to product service items, we're just pointing it specifically to the accounts revenue and then the clearing and then sales tax or something like that.
- 29:37Rachel D: But I, we do still have situations where we will literally go in and maybe take a month's data not a daily one, but maybe for like super simple clients we're doing, we'll take a month's data and we'll post like a month sales receipt that way.
- 29:55Dan DeLong (2): Yeah.
- 29:55Dan DeLong (2): And, like you, I think a lot of people are, it depends.
- 29:59Dan DeLong (2): Yeah, right?
- 30:00Dan DeLong (2): You don't always, you don't always do this, entering manually.
- 30:04Dan DeLong (2): So yeah, I didn't put it in as a multi check box option.
- 30:08Dan DeLong (2): But yeah, so it looks like entering manually is is.
- 30:13Dan DeLong (2): Majority that are doing that.
- 30:16Rachel D: Yeah.
- 30:16Rachel D: and and it really, the mapping can get complex once you do it, you really develop the mind for it.
- 30:24Rachel D: And then you can go in and figure it out and, but yeah, it's I understand it sometimes can be tedious.
- 30:33Rachel D: All right,
- 30:34Dan DeLong (2): This article here is and LinkedIn in the, handouts.
- 30:40Dan DeLong (2): This is actually a really good robust robust article, really walking you through this very process where it talks about creating the customer for daily sales, setting up the accounts for, daily sales.
- 30:54Dan DeLong (2): So you're gonna have the, in the income accounts, the clearing accounts overages and shortages for your, cash drawer for those cashiers with sticky fingers or clumsy fingers that drop a quarter underneath a cash bar or something like that.
- 31:12Dan DeLong (2): I'll set those.
- 31:15Dan DeLong (2): And then setting up those items that point to point, to point to it, and then all of the extra, items and where they, go.
- 31:28Dan DeLong (2): As I was reading these things, the, the check the check item, I'm quite, I'm not quite sure why it goes to the account of check.
- 31:39Dan DeLong (3): Doesn't seem right,
- 31:40Dan DeLong (2): but I, think that would be, I think that would be positive funds in here.
- 31:45Dan DeLong (2): Somebody got copy, paste happy.
- 31:47Dan DeLong (2): Yeah, because it's just check check, across the, chart here.
- 31:51Dan DeLong (2): But, unless you, have a, distinct, check depositing process, right?
- 31:59Dan DeLong (2): These are Mobile deposits or something like that.
- 32:02Dan DeLong (2): But normally that would just go to un deposit funds and then you would be putting this in as a daily sales template, putting in the and then putting this as a recurring transaction, right?
- 32:14Dan DeLong (2): So you would save this as a memorized transaction.
- 32:19Dan DeLong (2): And then every day when you have that, the, Z Out store close.
- 32:27Dan DeLong (2): Tape or receipt or whatever it ends up printing on.
- 32:32Dan DeLong (2): You would then just enter in the amounts, just down the list, right?
- 32:36Dan DeLong (2): So this this this failed receipt should be mirroring the exact same format of your, Z out tape, so that you can just go down the list of the amounts and, enter those in.
- 32:50Dan DeLong (2): So you start with a$0 sales receipt that is, that has nothing on it.
- 32:56Dan DeLong (2): David has a template, and then just go into recurring templates, use it, and then just enter the amounts, record it, and you're done.
- 33:05Dan DeLong (2): Right?
- 33:05Rachel D: And this is all supposing you, you're, you don't have something that's automating it for you, right?
- 33:12Rachel D: Yeah.
- 33:14Dan DeLong (2): This is, the entering the manually method.
- 33:17Dan DeLong (2): Got it.
- 33:17Dan DeLong (2): That, the 37% of our folks are, seeing that's what they're doing.
- 33:22Dan DeLong (2): And then you would go in and enter that and this I can make this bigger.
- 33:27Dan DeLong (2): Yes.
- 33:27Dan DeLong (2): I, so this is the breakdown, right?
- 33:32Dan DeLong (2): You've got your daily sales income of 1,080.
- 33:37Dan DeLong (2): You're on this on this screen.
- 33:40Dan DeLong (2): And then the payment methods of cash, check, visa, MasterCard, American Express, discover, any kind of overages as negatives, which zero that out.
- 33:50Dan DeLong (2): Now they do mention here, and I just wanted to go back up here.
- 33:55Dan DeLong (2): I saw it, somewhere because it was talking about.
- 33:59Dan DeLong (2): Sales tax.
- 34:00Dan DeLong (2): Okay, maybe that's down, here later.
- 34:04Dan DeLong (2): So the next thing is then depositing your daily sales.
- 34:08Dan DeLong (2): All of these items of payment methods are gonna be linked to wherever they need to go.
- 34:13Dan DeLong (2): And that's gonna be passing the baton to to the next step.
- 34:18Dan DeLong (2): Whatever that workflow happens to be.
- 34:21Dan DeLong (2): And then you're just gonna make those deposits grouping your credit cards together, taking out the fees, whatever it is that that you wanna be able to do with that deposit sample.
- 34:33Dan DeLong (2): Right where it's bringing in the cash check visa, MasterCard, American Express, all in one to make that lump deposit.
- 34:43Dan DeLong (2): Maybe you don't go rushing down to the bank every day to deposit your cash, right?
- 34:49Dan DeLong (2): Cash is gonna accrue or build up inside the undeposited funds.
- 34:54Dan DeLong (2): And then.
- 34:55Dan DeLong (2): You take all of the cash, three days worth of sales, an thousand some dollars, then you lump those things together, make those deposits to mirror reality.
- 35:07Dan DeLong (2): Now, okay, now where did it go?
- 35:10Dan DeLong (2): Because I saw it earlier.
- 35:14Dan DeLong (2): Let me make this a little easier to see for me.
- 35:18Dan DeLong (2): Because it, it's something about, okay, I'm just gonna find it here about there.
- 35:24Dan DeLong (2): It's okay.
- 35:24Dan DeLong (2): Yeah.
- 35:25Dan DeLong (2): It's a little blurb here.
- 35:27Dan DeLong (2): Make sure you use your tax rate is set up properly, is this little tiny thing here, right?
- 35:34Dan DeLong (2): So by doing it this way you can see that, and this is what Paul prompted the whole topic here.
- 35:45Dan DeLong (2): By doing it this way, we have our taxable sales.
- 35:48Dan DeLong (2): Of this first item, and then we have negative items as, non-taxable, right?
- 35:57Dan DeLong (2): So to QuickBooks Online, it doesn't know a diff the difference between the cash check and Visa MasterCard as a negative, as the daily sales income line item above it, right?
- 36:11Dan DeLong (2): So to QuickBooks it is recognizing this on in, QuickBooks as a negative sale, right?
- 36:21Dan DeLong (2): So because it cash is$327 as a negative and it's non-taxable.
- 36:28Dan DeLong (2): When you run your sales tax report, you have positives for the, for the, 10 80, for the thousand dollars and 80, 80 cents.
- 36:41Dan DeLong (2): But then you have these negatives as negative sales.
- 36:44Dan DeLong (2): So that's what started this whole this whole conversation is someone was having some challenges because they were coming in as sales receipts like this from their subway franchise, but then he was going to remit the sales tax and ran the sales tax report.
- 37:05Dan DeLong (2): The gross sales said zero, for a whole month.
- 37:10Dan DeLong (2): It was zero.
- 37:12Dan DeLong (2): I think you're muted again.
- 37:14Dan DeLong (2): Sorry.
- 37:15Dan DeLong (2): I saw you say something.
- 37:16Rachel D: Sorry.
- 37:16Rachel D: Yeah, no, it screws up your sales tax report.
- 37:19Rachel D: It's super frustrating.
- 37:21Rachel D: Yeah.
- 37:23Dan DeLong (2): So he had gross sales of 87,000 or taxable sales of$87,000 and non-taxable sales of negative 87,000.
- 37:33Dan DeLong (2): And thus giving him gross sales of nothing.
- 37:36Dan DeLong (2): So that was that, that, that was a challenge for him because he was using, QuickBooks to help him fill out the, sales tax reports.
- 37:45Dan DeLong (2): And those reports were essentially useless in this manner, right?
- 37:50Dan DeLong (2): Yeah, because, because in QuickBooks it was recognizing the ins and the outs of the sales receipt negative and a positive sale, right?
- 38:02Dan DeLong (2): Because these items, unlike QuickBooks Desktop, they're not specifically marked as payment items, right?
- 38:08Dan DeLong (2): So it doesn't know the difference between it and a payment, right?
- 38:11Dan DeLong (2): So it handles the, the accounting rate.
- 38:17Dan DeLong (2): But this is the, yeah.
- 38:18Dan DeLong (2): But of this whole thing, whoop, where did it go?
- 38:23Dan DeLong (2): So non-taxable sales or non-sales items are sales items to QuickBooks and the sales tax reports, are, a challenge.
- 38:33Dan DeLong (2): And the other thing is you could potentially, so this$1,080 that's, here at the top, is a summary of all of the sales, for that, day.
- 38:50Dan DeLong (2): You, this may be 20 different transactions at varying different dollar amounts which are going to have sales tax calculated at the time of that sale, not at a grand total of 10 80.
- 39:07Dan DeLong (2): So potentially by doing it this way also.
- 39:11Dan DeLong (2): And counting on QuickBooks to recalculate the sales tax, not putting in your sales tax items on the sales, trans sales receipt itself.
- 39:20Dan DeLong (2): It's going to potentially recalculate your sales tax and it's gonna base its calculation on$1,080, which may have some fluctuations with routing.
- 39:35Dan DeLong (2): So that's another potential issue when it comes to doing it this way and sales tax.
- 39:42Rachel D: Dan what's your, what's, what would you say then to somebody that's this is, I I am doing the bookkeeping for somebody's franchise, or I am a franchise, small franchise owner, and I am this is the way that I've been taught.
- 39:58Rachel D: This is the way I know how to do it, and I wanna put my daily sales receipts in this way.
- 40:03Rachel D: What would you suggest to them?
- 40:06Dan DeLong (2): Yeah, so if you're using.
- 40:09Dan DeLong (2): If you are using QuickBooks to, help you with the, sales tax reporting side of things, then a daily sales summary is not the, best way to handle that.
- 40:21Dan DeLong (2): And, I would as it's a pain, as it would be not just one transaction for the daily sales, it would be the invoice payment rec avenue.
- 40:32Dan DeLong (2): Because payments are, payments they're treated as payments and they don't have, the the, challenges that a negative sales item that,
- 40:46Rachel D: Right.
- 40:47Rachel D: So rather than a sales receipt, you'd have them use an invoice in which there would be a receive payment associated with it.
- 40:57Dan DeLong (2): Now you still potentially could have that same issue by summarizing your sales and sales tax recalculating.
- 41:04Dan DeLong (2): But that's all gonna also come out in the wash when you actually do the filing.
- 41:09Rachel D: Yeah.
- 41:10Dan DeLong (2): Because they are going to ask and that's gonna recalculate as well.
- 41:14Rachel D: cause doing it that way, you don't, you, all you're seeing on that invoice is income,
- 41:21Dan DeLong (2): right?
- 41:22Dan DeLong (2): Yeah, exactly.
- 41:23Dan DeLong (2): Which segues really nicely into how Lightspeed point of sale handles this.
- 41:29Dan DeLong (2): And this was one of the things that we've Matthew and I have been talking about what we're gonna the direction that we're gonna be heading.
- 41:37Dan DeLong (2): The CUNY Power Hour to, is really understanding the, things that are really important for QuickBooks online in that, ecosystem, because of the shallow end of the pool, the functionality of QuickBooks.
- 41:53Dan DeLong (2): You.
- 41:55Dan DeLong (2): It's not designed.
- 41:56Dan DeLong (2): QuickBooks online is not designed to be a point of sale system.
- 41:59Dan DeLong (2): Yeah.
- 41:59Dan DeLong (2): So you often need to have other things that, that synchronize.
- 42:05Dan DeLong (2): And, we want to get into, some detailed analysis of how these apps actually send data to quick, right?
- 42:14Dan DeLong (2): So if you're using something like Bookkeep with Lightspeed, that's gonna be handled completely different than if you're using Lightspeed's point of sale and built in built in integration.
- 42:26Dan DeLong (2): So
- 42:27Rachel D: under, and that's not shows
- 42:29Dan DeLong (2): up QuickBooks.
- 42:30Dan DeLong (2): That's really what we want to unpack with some of these app integrations moving forward.
- 42:38Rachel D: Yeah, and I was just gonna say, that's not to say that you can't use a connector with a point of sale automation tool.
- 42:48Rachel D: And do both.
- 42:49Rachel D: 'cause you're only mapping one thing from one and ma one thing from the other.
- 42:51Rachel D: So this is, I just have to say, this is why I love QuickBooks online because like you said, the shallow end of the pool there's just these functionalities, but it's engineered to work with all of this other stuff and instead of doing the things in QuickBooks online, we're now doing the things elsewhere and just funneling the data in there to QBO and it the, capabilities are endless.
- 43:22Rachel D: You can grab data from here and from there and put it all together and it can get really complex.
- 43:27Rachel D: But the whole point is, that QBO can support it and QBO can do it.
- 43:32Rachel D: So it's really, neat.
- 43:33Rachel D: I love that part of it.
- 43:35Dan DeLong (2): Yeah, and that's that's the, environment that we're, in now, right?
- 43:42Dan DeLong (2): It's, yeah.
- 43:46Dan DeLong (2): Especially with something like QuickBooks Enterprise.
- 43:49Dan DeLong (2): For desktop, a lot of things were done stoop to nuts inside of, QuickBooks.
- 43:56Dan DeLong (2): Now we're with QuickBooks Online and some of the glass ceilings that we're bumping into you have to have this hodgepodge of technology to integrate into, QuickBooks, and you're using QuickBooks as the, foundation of your, finance and your accounting.
- 44:17Dan DeLong (2): But the way that information comes in is going to either allow you to make usable reports or not, depending on how that information comes in.
- 44:29Dan DeLong (2): The main thing that I wanted to, point out about, Lightspeed Lightspeed has, taken a page from, Intuit.
- 44:37Dan DeLong (2): They have.
- 44:39Dan DeLong (2): Acquired other companies and assimilated them into their
- 44:43Rachel D: yay,
- 44:44Dan DeLong (2): into their ecosystem.
- 44:46Dan DeLong (2): We
- 44:46Rachel D: love that.
- 44:47Rachel D: Right?
- 44:48Dan DeLong (2): So if you've had an, interaction or an experience with, Lightspeed, there are a variety of different series of, lights speeds.
- 44:57Dan DeLong (2): Their flagship product right now is called Xer, which is not the light feed from 2, 3, 4 years ago.
- 45:06Dan DeLong (2): They have, that is the R series.
- 45:09Dan DeLong (2): So just the, amount of QuickBooks that are out there can get, challenging.
- 45:19Dan DeLong (2): The you might want to take a look at it again if you may have had a, poor experience because they understood that it wasn't the greatest thing and then they, went out, found another point of sale system that does work a little better.
- 45:34Dan DeLong (2): 'cause when we talked with.
- 45:38Dan DeLong (2): Before he talked about Lightspeed then, and he was using Cho go to integrate because the integration didn't do what he wanted it to do.
- 45:46Dan DeLong (2): But to your point, you're, not beholden to using only the Lightspeed integration.
- 45:54Dan DeLong (2): You could use a sales connector like book like bookkeeper or sender or ility a lot of those other connectors or integrators do allow for
- 46:07Rachel D: yeah, they allow for multiple payment methods so you can use the, one of your choosing.
- 46:13Rachel D: And I, my clients are very particular on the POS system they wanna use because of the rates.
- 46:20Rachel D: And the, it really, there is flexibility for them to keep using what they wanna use.
- 46:27Dan DeLong (2): Just QuickBooks point of sale Lightspeed specializes in hard goods.
- 46:32Dan DeLong (2): So you know, things that are actually, available to tangible, to hold and, whatnot.
- 46:40Dan DeLong (2): Those are their, in their industries that they specialize in.
- 46:44Dan DeLong (2): I did hate the fact that they said the word seamless integration.
- 46:48Dan DeLong (2): I know you,
- 46:48Rachel D: you do hate that
- 46:49Dan DeLong (2): that is a trigger word for me.
- 46:52Dan DeLong (2): But, their, integration is actually pretty, good with the exception of inventory adjustments.
- 46:59Dan DeLong (2): But we're not talking about that.
- 47:02Dan DeLong (2): But Lightspeed does allow mapping to QuickBooks Daily sales summary items.
- 47:09Dan DeLong (2): This just a screenshot here of their integration page.
- 47:15Dan DeLong (2): So you have the dropdowns and that will pull in the item listing from, your QuickBooks.
- 47:21Dan DeLong (2): So you can map to specific items listed here.
- 47:25Dan DeLong (2): So that's one of the things with the pre-work in, setting up QuickBooks and Lightspeed, is that you do have to set up those items ahead of time, otherwise you won't see them to be able to map them to this one here.
- 47:39Dan DeLong (2): With the product types, this does allow you to map Lightspeed product types to QuickBooks, right?
- 47:46Dan DeLong (2): So you, if you're, if you've departmentalized your, your, inventory inside of Lightspeed, you can set up those items.
- 47:54Dan DeLong (2): So that you have if it's clothing store, you've got shirts and men's and pants and all those different types of items.
- 48:02Dan DeLong (2): You can map those independently.
- 48:04Dan DeLong (2): Oh, that's awesome.
- 48:05Rachel D: Awesome.
- 48:06Rachel D: Awesome, And then,
- 48:08Dan DeLong (2): and then what Lightspeed does is it sends the coffee of the gold to QuickBooks on a daily basis as well.
- 48:14Dan DeLong (2): It's one transaction, it's a journal entry.
- 48:16Dan DeLong (2): It's not split out like that department.
- 48:20Dan DeLong (2): So just keep that in mind.
- 48:22Dan DeLong (2): And it also sends purchase orders, store credits, sales on account all those things that you would be doing inside of the point of sale system over to QuickBooks.
- 48:34Dan DeLong (2): And it does it automatically, right?
- 48:36Dan DeLong (2): And as soon as you close the register, it creates that sales transaction over in QuickBooks.
- 48:43Dan DeLong (2): You don't have to go and click on something that says.
- 48:47Dan DeLong (2): Send to QuickBooks or anything like that.
- 48:49Dan DeLong (2): As soon as you do the task that you're doing, whatever that is, that's the trigger to get it over into QuickBooks.
- 48:57Dan DeLong (2): And then it also allows for mapping of specific sales tax items, right?
- 49:02Dan DeLong (2): So it does, so you don't have that rounding or recalculation, because when you point it to the right sales tax item or the sales tax method inside of QuickBooks, it's just going to take the amount that was collected and put that dollar amount in there.
- 49:20Dan DeLong (2): It's not gonna allow QuickBooks to recalculate.
- 49:25Dan DeLong (2): And, potentially have this rounding issue of pennies and cents.
- 49:31Dan DeLong (2): So it's daily sales summaries are created as invoices and the payment methods are created as customer payments applied to that invoice, right?
- 49:42Dan DeLong (2): You're not gonna have this problem with with sales tax by using the Lightspeed built in integration.
- 49:49Dan DeLong (2): And this is not something that you have to pay for extra, right?
- 49:51Dan DeLong (2): It's just one of the, payment opt, or I'm sorry the, levels of, QuickBooks.
- 49:57Dan DeLong (2): If you have accounting integration, you would just get the, flavor of Lightspeed X Series that, that allows you to do that.
- 50:06Dan DeLong (2): If you find that this is you need your details or you need something else, then you would purchase the one that doesn't have that, right?
- 50:13Dan DeLong (2): So it's not something that you're and there's other things that come in with that flavor of Lightspeed as well.
- 50:20Rachel D: Why do people have till discrepancies,
- 50:24Dan DeLong (2): till discrepancies?
- 50:25Rachel D: It drives me crazy.
- 50:30Dan DeLong (2): That requires a human to do things.
- 50:33Dan DeLong (2): So humans make mistakes, whether it's counting the money or fraud.
- 50:42Dan DeLong (2): Yeah.
- 50:42Dan DeLong (2): Or dropping things.
- 50:45Dan DeLong (2): I worked at Pizza, my, all, all through college.
- 50:48Dan DeLong (2): I dropped coins all over the place so that, that comes in at the end of the day when you're sweeping, right?
- 50:55Dan DeLong (2): Oh, there's where it went.
- 50:57Rachel D: All, I'm doing is exposing myself to be so very anal.
- 51:04Dan DeLong (2): All right.
- 51:05Dan DeLong (2): They are offering a a promotion actually.
- 51:08Dan DeLong (2): Ooh, very cool.
- 51:09Dan DeLong (2): This month or three months of the service.
- 51:12Dan DeLong (2): And one of the things that I really like about Lightspeed as well is they reef they charge.
- 51:19Dan DeLong (2): Their customers for an implementation.
- 51:22Dan DeLong (2): They give five sessions of training for, to train the store so you don't have to tell them how to use all this stuff.
- 51:32Dan DeLong (2): They then they break it down in, in five different topics of sales and inventory management and e-commerce and, those types of things.
- 51:41Dan DeLong (2): And then they charge them, I think it's$300, to do the, implementation, but upon completion of those five sessions, they get it back.
- 51:51Dan DeLong (2): Oh.
- 51:52Dan DeLong (2): And so that's
- 51:53Dan DeLong (3): really cool.
- 51:53Dan DeLong (3): They know
- 51:54Dan DeLong (2): And they, realize that if they, if people don't know how to use it, they're not gonna use it and they're gonna, and they're gonna cancel.
- 52:01Dan DeLong (2): I kind of wish QuickBooks would do this of Yeah.
- 52:04Dan DeLong (3): Hey,
- 52:04Dan DeLong (2): we'll charge you$500 to figure out how to train you how to, use these things.
- 52:12Dan DeLong (2): On demand sessions.
- 52:14Dan DeLong (2): And then when you complete it, then you get that money back.
- 52:18Dan DeLong (2): And then it, gets people a little bit more familiar with the product using it.
- 52:24Dan DeLong (2): Now, one of the things I wanna mention about these, sessions is those people are very focused on using Lightspeed and as they should, right?
- 52:36Dan DeLong (2): Like they, they know how to use Lightspeed.
- 52:41Dan DeLong (2): They don't know how it's gonna all integrate and respond to, QuickBooks.
- 52:47Dan DeLong (3): Yeah.
- 52:48Dan DeLong (2): I, first time that I did recommended this to a client, I sat in on those sessions so that I could be available to help explain, and understand a little better, right?
- 53:01Rachel D: Yeah.
- 53:01Rachel D: That sometimes happens.
- 53:03Dan DeLong (2): And if they are using something else.
- 53:07Dan DeLong (2): Another point of sale system.
- 53:09Dan DeLong (2): They will migrate the, data customers and vendors, and their items into their Lightspeed to get it set up for them.
- 53:19Rachel D: Hey, Dan, quick question.
- 53:20Rachel D: Do you know if you can use Lightspeed within e-commerce channels?
- 53:25Dan DeLong (2): Yes.
- 53:27Dan DeLong (2): It actually the, way that they they explain it is they've had a Shopify integration longer than Shopify has a, has had an integration with its own product.
- 53:39Rachel D: Because let me tell you.
- 53:41Rachel D: The fact that Lightspeed can separate by product type.
- 53:46Rachel D: Product type in Shopify is a very big deal.
- 53:50Rachel D: And those eco most e-commerce connectors can only grab the class and or location.
- 53:58Rachel D: And so if it can grab something like the product type, I haven't seen anything else that can do that.
- 54:04Rachel D: I'm gonna, I'm gonna go in and do some research on this because if you can, map the Shopify product type to its own product service item, and thus its own income account, that's huge.
- 54:17Rachel D: You can separate things on the p and l.
- 54:19Rachel D: I have a client where I literally go in and do it manually'cause I haven't found anything that I can separate by Shopify product type.
- 54:27Dan DeLong (2): Yeah.
- 54:27Dan DeLong (2): And another another point of interest is that every register is it creates a, daily sales summer summary for each register.
- 54:37Dan DeLong (2): And e-commerce channels are considered a separate register Yeah.
- 54:41Dan DeLong (2): As well.
- 54:41Dan DeLong (2): Yeah.
- 54:41Dan DeLong (2): So when those e-commerce sales come in to to the Lightspeed they will be sent as a separate customer
- 54:50Rachel D: Yeah.
- 54:51Dan DeLong (2): Over, over into QuickBooks as well.
- 54:53Rachel D: That's very cool.
- 54:54Rachel D: And really what, just to, what I mean is on the p and l, like for your clients, it's so cool.
- 55:01Rachel D: You can have like Shopify sales, but then you can have furniture sales.
- 55:07Rachel D: Hardware sales,
- 55:09Dan DeLong (3): yeah.
- 55:09Rachel D: But wa wallpaper sales and, you typically can only do that on the vertical, like by the class.
- 55:17Rachel D: So this, that's cool.
- 55:18Rachel D: Exactly.
- 55:20Dan DeLong (2): And, then as I said, so this is this is the inside of.
- 55:25Dan DeLong (2): Why is this?
- 55:27Dan DeLong (2): Is, I updated my Mac, so now it's asking me all sorts of questions as well.
- 55:33Dan DeLong (2): But this is the the QuickBooks app settings inside of a, of Lightspeed.
- 55:38Dan DeLong (2): This is where you can just click the dropdown and find find the mappings.
- 55:44Dan DeLong (2): If you wanted to map the product types you would have to, I think to your point if it's a Shopify product type, you would have to map those product types as well inside of the, yeah, you'd have to map
- 55:59Rachel D: them ahead of time.
- 55:59Rachel D: But yeah, as long as
- 56:01Dan DeLong (2): they're, as long as they're mirroring what you have at Shopify, then of course it's gonna send those things over as, as you tell them to.
- 56:11Dan DeLong (2): And then your expense information, li any li liabilities that you have gift cards.
- 56:18Dan DeLong (2): Store credit those types of things that you wanna map specifically to again, you just make sure that those items are set up in, in your QuickBooks to handle the accounting, because that's what Lightspeed is gonna be using when it, sends it over.
- 56:37Dan DeLong (2): There we are, right on time.
- 56:39Dan DeLong (2): Oh, and I just wanted to mention that this all came up because of a quick answer that, that somebody reached out to us over at school of Bookkeeping.
- 56:50Dan DeLong (2): So if you have questions, you want to, get some support, you can do that over at School Bookkeeping as well.
- 56:59Dan DeLong (2): And maybe your topic is gonna be featured on on a future QB Power Hour.
- 57:05Dan DeLong (2): So let's, real quick Noah, go ahead and launch the last poll question, which is, was this information useful?
- 57:12Dan DeLong (2): Did you learn something new?
- 57:15Dan DeLong (2): Rachel, was it useful for you?
- 57:16Rachel D: Yes.
- 57:17Rachel D: Oh my gosh.
- 57:18Rachel D: I didn't even really I'm familiar with Lightspeed, but really getting to see the differences of, what it can do.
- 57:27Rachel D: Oh my gosh.
- 57:27Rachel D: I'm very impressed because I haven't really looked at their Yeah.
- 57:31Rachel D: And this is settings.
- 57:34Dan DeLong (2): Yeah.
- 57:34Dan DeLong (2): There's no silver bullet for a one try, one size fits all anymore.
- 57:39Rachel D: No, there's not.
- 57:40Dan DeLong (2): And that's really what into my pain we want.
- 57:43Dan DeLong (2): And that's what we really wanna unpack, and, compare for these workshops.
- 57:53Dan DeLong (2): And the power Hour that we're doing here is really getting into the, how this data, as much as they would say works with QuickBooks.
- 58:06Dan DeLong (2): And, integrates with QuickBooks in what way?
- 58:09Dan DeLong (2): The biggest example is as.
- 58:12Dan DeLong (2): Our friends at Bookkeeper we've used bookkeeping before.
- 58:15Dan DeLong (2): They will only bring in transactions as journaling, right?
- 58:20Dan DeLong (2): They do a really good job of that.
- 58:22Dan DeLong (2): But if you are using something like like sales tax or a functionality that requires, QuickBooks to have its functionality that isn't the best solution to bringing ev, bringing that data over, yeah, there are some things that it will do really well, but understanding how that information gets over, that's really things that, that Matthew and I are gonna be focusing on with QB Power Hour moving forward.
- 58:52Dan DeLong (2): Rachel, I really appreciate you at such short notice filling in and coming in, and hopefully, the folks that that watched I can't tell because my restarted in the middle.
- 59:06Dan DeLong (2): Everything happen.
- 59:09Dan DeLong (2): But we really appreciate you all joining us here today on the QP Power Hour next time on the, 15th.
- 59:17Dan DeLong (2): Fully expect not everybody to be showing up here because that is the tax deadline of April.
- 59:24Dan DeLong (2): We'll be talking about some QuickBooks online updates or QuickBooks ecosystem updates.
- 59:30Dan DeLong (2): We'll be talking about the, tag migration and the death of tags.
- 59:36Rachel D: Yeah, that's going away.
- 59:39Dan DeLong (2): And we'll be fielding some questions out of the out of the Facebook group.
- 59:43Dan DeLong (2): So appreciate you joining us here today, and we'll see you next time on the QB Power Hour.
- 59:48intro (2): Have a great day, everyone.