Latest / QB Power Hour Podcast / The Open Tab : Your Space for Questions, Updates, and Clarity [05.12.26]
Transcript
- 0:22Dan DeLong: welcome to another QB Power Hour.
- 0:25Dan DeLong: This this week is the open tab, which is all about Intuit updates and yammerings back and forth between, Sharrin and myself.
- 0:39Dan DeLong: My name is Dan DeLong, owner of Danwidth and School of Bookkeeping, worked at Intuit for nearly 18 years, doing the co-hosting today.
- 0:47Dan DeLong: And Sharrin, back from her whirlwind tour of where have you been?
- 0:54Dan DeLong: You're muted.
- 0:57Sharrin Fuller: Sometimes I feel me being muted might be better for the wellbeing- of the universe.
- 1:00Sharrin Fuller: But I just got back from Marietta at a small business conference where I was the opening keynote.
- 1:07Sharrin Fuller: I'm gonna say that- 500 times'cause I am really proud of it.
- 1:10Sharrin Fuller: I will post that video soon.
- 1:11Sharrin Fuller: As you should be.
- 1:11Sharrin Fuller: Or if you're in my community, I've actually...
- 1:13Sharrin Fuller: They did a whole professional thing.
- 1:14Sharrin Fuller: They're posting it.
- 1:15Sharrin Fuller: And then I was at GrowCon- GrowCon is amazing.
- 1:19Sharrin Fuller: If anybody has not been, you need to go.
- 1:22Sharrin Fuller: I'm just telling you.
- 1:22Sharrin Fuller: I had...
- 1:23Sharrin Fuller: I spoke there too, but aside from that, there...
- 1:26Sharrin Fuller: it is a really good conference.
- 1:28Sharrin Fuller: It's different than the rest, so I Sharrin approved.
- 1:31Sharrin Fuller: And now I'm back getting community stuff ready, because tomorrow I leave for Mexico for six days, and then I go ba- straight to San Diego for Firm Growth Forum, where I'm on a panel.
- 1:41Sharrin Fuller: So-
- 1:42Dan DeLong: Wow
- 1:43Sharrin Fuller: just a little bit of a break, a little bit.
- 1:45Dan DeLong: Do you even know what time it is?
- 1:47Dan DeLong: It you've gotta have time zone fatigue.
- 1:49Sharrin Fuller: And I was home last week for about three days, and my husband got up and just left the house, and I was sitting in my office and I text him, I go,"Hey, where'd you go?" And he goes,"Oh my God, I completely forgot you were even home.
- 2:03Sharrin Fuller: I'm so used to you not being here." Wow.
- 2:05Sharrin Fuller: So I think I'm gonna get him a surrogate wife or something while I'm out.
- 2:08Sharrin Fuller: I feel bad.
- 2:09Sharrin Fuller: Just to do sports stuff with.
- 2:12Sharrin Fuller: Nothing else.
- 2:13Dan DeLong: Yeah, you gotta dress up with- Anyhow dress up in
- 2:15Sharrin Fuller: a- He just made...
- 2:16Sharrin Fuller: He heard that- a different wife he goes,"What?" Oh, and we're in the middle of hockey playoffs.
- 2:21Sharrin Fuller: So I have a lot going on in life right now.
- 2:26Dan DeLong: Yes, as my, It's insane as my Philadelphia Flyers got swept
- 2:30Sharrin Fuller: Yeah, that was sad.
- 2:33Sharrin Fuller: I can't talk.
- 2:34Sharrin Fuller: We're two...
- 2:34Sharrin Fuller: What are we, 2-2 in the Ducks and- Yeah yeah, we're trying to decide, are we gonna go out on a catamaran on Thursday or are we gonna actually watch the game?
- 2:42Sharrin Fuller: So- it's a hard, it's a hard one.
- 2:45Sharrin Fuller: I don't know.
- 2:47Dan DeLong: All right.
- 2:47Sharrin Fuller: All right.
- 2:47Sharrin Fuller: Back to work, guys.
- 2:48Sharrin Fuller: Back to work.
- 2:50Dan DeLong: For those of
- 2:50Sharrin Fuller: you that are
- 2:51Dan DeLong: just- Go Ducks!
- 2:52Sharrin Fuller: You Donna offer this right now with this Duck crap.
- 2:55Sharrin Fuller: What is this?
- 2:56Sharrin Fuller: We ain't d- we ain't doing this, Donna.
- 2:58Dan DeLong: Some Southern Californians-
- 3:00Sharrin Fuller: Ugh
- 3:01Dan DeLong: put- throwing in their, local cheer.
- 3:04Dan DeLong: For those of you join- joining us for the first time some updates on our webinar series.
- 3:11Dan DeLong: We have switched to a individual registration so that you can add them to your calendar, you can plan out farther.
- 3:17Dan DeLong: We do have on the qbpowerhour.com website those registrations up until, I think, mid-June somewhere.
- 3:27Dan DeLong: So you can go in and see what topics we're planning instead of the, two-week shuffle as we had been doing on the recurring series before that.
- 3:37Sharrin Fuller: So
- 3:38Audio Only - All Participants: much
- 3:38Dan DeLong: work.
- 3:38Dan DeLong: But we have...
- 3:39Dan DeLong: Yeah.
- 3:40Dan DeLong: But we have- Not for me.
- 3:42Dan DeLong: Yeah.
- 3:42Sharrin Fuller: Clearly.
- 3:45Dan DeLong: Some- Ugh at some point we are gonna get Sharrin involved in creating some of these slides.
- 3:50Sharrin Fuller: I have c- in July.
- 3:51Sharrin Fuller: I'm in July.
- 3:52Sharrin Fuller: I've got a couple- That's right in July and August I will host,
- 3:55Dan DeLong: exactly.
- 3:56Dan DeLong: So we have our, our recurring themes of the open tab and take it to the limit and beyond bookkeeping, niche nuances, is the grass greener?
- 4:04Dan DeLong: So we're trying to categorize or consolidate some of these topics into like-minded.
- 4:11Dan DeLong: We are also kicking around some ideas of, each- QB Power Hour having a s- a segment or a section inside like we have been doing with Intuit News for each one.
- 4:23Dan DeLong: We've been thinking of some of those ideas as well inside of each each webinar.
- 4:29Dan DeLong: So stay tuned for that.
- 4:31Dan DeLong: And I've lost my mouse.
- 4:32Dan DeLong: There it is.
- 4:33Dan DeLong: Okay.
- 4:33Dan DeLong: So the agenda today, we are...
- 4:35Dan DeLong: Oh, I didn't update the agenda slide.
- 4:38Dan DeLong: Dan.
- 4:38Dan DeLong: That's what I'm looking at.
- 4:40Dan DeLong: Womp.
- 4:40Sharrin Fuller: Dan honestly, the fact that we even try to have an agenda here is great.
- 4:45Dan DeLong: Yeah.
- 4:46Sharrin Fuller: I love it.
- 4:46Sharrin Fuller: So we- I love your, effort.
- 4:51Dan DeLong: So it's a hidden agenda today.
- 4:53Dan DeLong: All right.
- 4:54Dan DeLong: No, it's it's actually correct with the exception of the topic for the Intuit News.
- 4:59Dan DeLong: We talked about that last, time.
- 5:02Dan DeLong: So it'll be a surprise what we're gonna be talking about in the Intuit News segment.
- 5:08Dan DeLong: But we are gonna be focusing on a couple major areas, for the most part.
- 5:14Dan DeLong: And it will be around the enhanced inventory receiving because I have been on a soapbox about this new feature and function.
- 5:26Dan DeLong: I was talking about it a little bit on the un- unofficial QuickBooks Accountants podcast with Alicia Katz Pollock.
- 5:34Dan DeLong: I've written a blog.
- 5:35Dan DeLong: And so I wanna make sure that people have everything that they need, especially for the accountants in the room that might might be surprised if a client inadvertently- No.
- 5:47Dan DeLong: Oh turns it on and, wondering that if if it's broken or not broken, then, and it's...
- 5:55Dan DeLong: or if it's working as designed, or if it's designed poorly.
- 5:59Dan DeLong: So we wanna talk through that as far as the enhanced inventory receiving with the item receipts.
- 6:05Dan DeLong: And then we'll we'll talk about some of the desktop migration enhancements.
- 6:11Dan DeLong: Intuit has started to socialize that moving to QuickBooks Online is an upgrade which is a, That's a that's a stretch, I think.
- 6:25Dan DeLong: Especially if you're using- Oh QuickBooks.
- 6:28Dan DeLong: If you're using QuickBooks Desktop and using the functions and features of QuickBooks Desktop you might find that some of these things are,
- 6:37Sharrin Fuller: It used to be- Yeah I don't know.
- 6:40Sharrin Fuller: I d- I used to only know Desktop.
- 6:42Sharrin Fuller: I was d- I was Desktop, and going to Online, I'm like,"What is this crap?" And then you use Online for so long, I go to Desktop and I'm like,"I forgot how to use Desktop." But Desktop does so much more.
- 6:52Sharrin Fuller: But don't get used to it, folks.
- 6:53Sharrin Fuller: It's going away.
- 6:54Sharrin Fuller: You all can stomp your feet and sand all you want, it's going away.
- 6:58Sharrin Fuller: So everybody's mad at me- It is for saying that, but watch.
- 7:01Dan DeLong: It's- Watch It's not if, but
- 7:03Sharrin Fuller: when I've been saying it for five years.
- 7:05Sharrin Fuller: And they never will.
- 7:08Dan DeLong: It's not if but when- All right, go ahead but we don't know.
- 7:11Dan DeLong: It's- we don't know- Yeah specifics, right?
- 7:13Dan DeLong: But,
- 7:13Sharrin Fuller: They're waiting to see how much we freak out.
- 7:15Sharrin Fuller: Honestly, I'm a cloud girl but...
- 7:21Dan DeLong: And then we'll talk about some of the, the, Facebook groups common posts that we've seen over the, in the, over the last month or so.
- 7:30Dan DeLong: So Sharrin, our first poll question.
- 7:33Dan DeLong: Today- Yes launch.
- 7:35Sharrin Fuller: I'm launching
- 7:35Dan DeLong: it.
- 7:35Dan DeLong: That look of surprise as you go,"Oh."
- 7:37Sharrin Fuller: I need the presenta- where'd it go?
- 7:39Sharrin Fuller: I need the thing on the other side that tells me what the next slide is.
- 7:43Sharrin Fuller: Oh, yeah.
- 7:43Sharrin Fuller: Or I could just have it open.
- 7:44Sharrin Fuller: It's not like I don't have access to all of this.
- 7:48Dan DeLong: There we go.
- 7:48Sharrin Fuller: Full immersion.
- 7:48Sharrin Fuller: I don't like to come prepared because I feel like that's your thing,
- 7:53Dan DeLong: that's right.
- 7:54Dan DeLong: It's the Odd Couple in us, right?
- 7:55Dan DeLong: And I'm, I'm-
- 7:56Sharrin Fuller: Yeah
- 7:56Dan DeLong: I'm the Felix and you're the Oscar
- 7:59Sharrin Fuller: I'll take it right now.
- 8:00Sharrin Fuller: All
- 8:00Dan DeLong: right.
- 8:02Dan DeLong: Which is not fair, right?
- 8:03Dan DeLong: I should be the Oscar because you can see by my hat,
- 8:07Sharrin Fuller: No,
- 8:07Dan DeLong: dude
- 8:08Sharrin Fuller: I am legit the Felix in every aspect of my life except for when I travel.
- 8:12Sharrin Fuller: We've seen pictures of my hotel room.
- 8:14Sharrin Fuller: And this webinar series.
- 8:17Sharrin Fuller: Other than that, I'm the Felix, so- There we go I'm excited to not be.
- 8:21Dan DeLong: All right.
- 8:22Dan DeLong: Yes, this is what we were going to talk about.
- 8:25Dan DeLong: The ProAdvisor recertification, which is probably why we are a little bit dipping on the on the atten- on the live attendance today.
- 8:34Dan DeLong: The, because I did get some notification that our session is com- is conflicting with a QuickBooks recertification webinar at the same time.
- 8:46Dan DeLong: For those of you that are watching, for watching the re- the replay afterwards welcome.
- 8:54Dan DeLong: And we hope you passed your certification.
- 8:57Dan DeLong: But that is the recertification is, expiring June 30th.
- 9:02Dan DeLong: If you don't take the certific- the recertification, this is an annual thing then you end up having to take the entire exam, which is instead of two modules of 10-ish questions you have to take eight, nine, 10.
- 9:18Dan DeLong: I don't even remember how many sections of the- regular certification exam there are.
- 9:26Dan DeLong: There are also in the ProAdvisor training, there's other foundational training that's in there.
- 9:34Dan DeLong: QuickBooks level two which was the advanced certification.
- 9:39Dan DeLong: And client advisory services foundation training, Intuit bookkeeping certification, and Intuit enterprise suite certification.
- 9:48Dan DeLong: None of those are required.
- 9:50Dan DeLong: As, a matter of fact, I don't think any of them are required.
- 9:52Dan DeLong: It used to be a requirement.
- 9:53Sharrin Fuller: Oh, Dan, it's lip service now.
- 9:55Sharrin Fuller: This whole certification thing, I was g- not going to say anything.
- 9:57Sharrin Fuller: I was waiting for you to ask so I could go on.
- 9:58Sharrin Fuller: Oh, no, you- But, no.
- 10:00Dan DeLong: I was,
- 10:00Sharrin Fuller: just not getting it.
- 10:00Sharrin Fuller: I, it, the whole certification thing to me is just yeah, we're just feeding the masses some bread crumbs to keep them happy.
- 10:09Sharrin Fuller: I don't think the certification means crap because I think the whole partner channel's going to go away.
- 10:13Sharrin Fuller: I think the whole accounting piece that they do for us is going to go away.
- 10:16Sharrin Fuller: I think it's going to go away before they get rid of desktop, personally, in my opinion.
- 10:21Sharrin Fuller: Yeah.
- 10:21Sharrin Fuller: Should we take bets?
- 10:22Dan DeLong: The, it- at Intuit Connect they were going to s- they, they were talking about in May, so here we are in May talking about the, again they, always love this word of reimagining things.
- 10:36Sharrin Fuller: Yeah.
- 10:38Dan DeLong: They were going to talk about what the reimagined QuickBooks ProAdvisor- The reimagined is
- 10:43Sharrin Fuller: Quick-
- 10:44Dan DeLong: ProAdvisor cert- They want
- 10:44Sharrin Fuller: to be like...
- 10:45Sharrin Fuller: Yeah, sorry
- 10:47Dan DeLong: whatever the PreAdvi- There you go ProAdvisor is they're going to start socializing that pretty soon.
- 10:55Dan DeLong: I know- Yeah Insightful Accountant had Jocelyn on or Jacqueline, sorry on there talking about that.
- 11:03Dan DeLong: I did not attend that, so I don't know the specifics about anything that anybody said there.
- 11:07Dan DeLong: I
- 11:07Sharrin Fuller: don't attend anything they do anymore because it's just na, na, na.
- 11:10Sharrin Fuller: Ted leaving tells us everything.
- 11:13Sharrin Fuller: Ted, who has been face of Intuit, that man wasn't like...
- 11:17Sharrin Fuller: That man jumped ship.
- 11:18Sharrin Fuller: He saw what was in the wor- He saw, And this is my opinion.
- 11:22Sharrin Fuller: This is not- Yeah I do not know Ted and I aren't friends.
- 11:24Sharrin Fuller: He saw the writing on the wall.
- 11:26Sharrin Fuller: He saw the next year and said I'm out.
- 11:29Sharrin Fuller: I'm not going to these conferences and letting these accountants like Sharrin walk up to me and verbally abuse me.
- 11:33Sharrin Fuller: I'm not doing it.
- 11:34Sharrin Fuller: I'm not being the face of this anymore," and he jumped ship.
- 11:37Sharrin Fuller: So be prepared.
- 11:39Sharrin Fuller: That's all.
- 11:40Sharrin Fuller: That's all I have to say.
- 11:41Dan DeLong: Do you, think he left on his own?
- 11:43Dan DeLong: He saw it-
- 11:43Sharrin Fuller: Absolutely and then left?
- 11:44Dan DeLong: Or, was
- 11:45Sharrin Fuller: he- Absolutely.
- 11:46Sharrin Fuller: I- I think I, absolutely...
- 11:48Sharrin Fuller: They probably said,"This is what it i-," in my opinion.
- 11:50Sharrin Fuller: Yeah.
- 11:51Sharrin Fuller: I don't care.
- 11:52Sharrin Fuller: This is my opinion.
- 11:53Sharrin Fuller: The, views expressed by Sharrin- I think he saw that he's been- are not
- 11:55Dan DeLong: necessarily
- 11:55Sharrin Fuller: he has been very committed to this, right?
- 11:58Sharrin Fuller: He has been very- him and Jess McCracken are very committed to this partner channel.
- 12:04Sharrin Fuller: It's their life, and I guarantee you Ted w- was let in on whatever their new thing is, and Ted was like nope, I can't be a part of that.""I'm going to go do something else with someone better.
- 12:14Sharrin Fuller: Sorry, bye." see?
- 12:16Sharrin Fuller: Do- Donna agrees See?
- 12:19Dan DeLong: And if
- 12:19Sharrin Fuller: Donna
- 12:19Dan DeLong: agrees, then-
- 12:20Sharrin Fuller: If Do- Donna worked at Intuit for a while until she was on this show,
- 12:25Dan DeLong: and then...
- 12:26Dan DeLong: Okay.
- 12:27Dan DeLong: So close that chapter- Sorry, Donna of what, what burned Sharrin's s'mores.
- 12:33Sharrin Fuller: Sharrin's s'mores are burnt.
- 12:34Dan DeLong: That's right.
- 12:36Dan DeLong: So enhanced inventory receiving.
- 12:38Dan DeLong: I wanna talk a little bit about this topic.
- 12:42Dan DeLong: We had mentioned this a little bit before on the last open tab, where we were talking about item receipts being available inside of QuickBooks Online now, right?
- 12:53Dan DeLong: So the situation or the, circumstance where this bubbles up to the surface is that the reality of managing your inventory is gonna be...
- 13:08Dan DeLong: Could, potentially have two options, and one of those options is you've received the merchandise separate from the time that you've received the bill or paid for said merchandise, right?
- 13:23Dan DeLong: In QuickBooks Desktop, they used this terminology of an item receipt which evolved into this option of enhanced inventory receiving, which was a feature or function that you could specify.
- 13:39Dan DeLong: Because in reality, QuickBooks Desktop, an item receipt was a bill that you couldn't pay, right?
- 13:47Dan DeLong: So it affected- Yeah, yep the exact same accounts fundamentally, right?
- 13:55Dan DeLong: An item receipt affected accounts pay- the accounts payable balance for the vendor, but when you went to pay bills, you couldn't actually pay said item receipt because it wasn't a bill to pay.
- 14:06Dan DeLong: You had to put a check mark on the bill received inside of Desktop, and that turned it into a bill.
- 14:13Dan DeLong: The problem with that is that it turned it into a bill on the date of the item receipt, which is now not the same thing in reality, right?
- 14:22Dan DeLong: You always wanna try to match the QuickBooks reality to what actually happened in reality.
- 14:30Dan DeLong: And in reality, when you've received merchandise in January, you wanna receive the merchandise in January.
- 14:37Dan DeLong: When you receive the bill in, February, you wanna receive the, bill in February, right?
- 14:44Dan DeLong: So that's now two different events, and the check mark of bill received did not allow for that.
- 14:51Dan DeLong: So what ended up happening is that they added inside of QuickBooks Desktop this option called Enhanced Inventory Receiving, which then, separated those two- Transactions on item receipt and receiving a bill against said item receipt into two separate events.
- 15:14Dan DeLong: So that way you could keep your...
- 15:16Dan DeLong: It was like the Mc- the McDLT of of QuickBooks.
- 15:20Dan DeLong: It allowed you to keep the hot side hot and the cold side cold.
- 15:24Dan DeLong: So if you have any idea of what I'm referencing, that shows your age.
- 15:31Dan DeLong: But it allowed you to keep those two events separate.
- 15:36Dan DeLong: and and then, But the way or the mechanism that it allowed for that to happen is that all of your inventory receiving had to occur on item receipts, regardless of whether you've got the bill at the same time that you've received the items, right?
- 15:55Dan DeLong: So that is, And then the the account that it ended up using is this account called Inventory Offset.
- 16:03Dan DeLong: So instead of going through accounts payable, like a bill and item receipt were doing, the item receipt would post against inventory offset, and then the bill would offset to inventory offset, and that was the clearing account essentially that tho- those two events would flow through.
- 16:25Dan DeLong: And that allowed you to in the bill put in any changes or things that actually were billed differently, or if there were additional charges or things that they were charging for to receive against those item rece-- or to offset against those item receipts, right?
- 16:46Dan DeLong: So in QuickBooks Online, they have given you that choice into, QuickBooks Online, right?
- 16:56Dan DeLong: So when you go to Settings, Sales, Products and Services, you have this choice of selecting what transaction equates or what transaction will be your in-inventory receiving method, right?
- 17:12Dan DeLong: Bills and expenses or item receipts.
- 17:17Dan DeLong: You have, that choice, right?
- 17:19Dan DeLong: The challenge is, that when you select that option to be item receipts, it permanently changes that setting, and that desktop was the exact same way.
- 17:31Dan DeLong: When you en- when you enabled enhanced inventory receiving it...
- 17:36Dan DeLong: All of your receiving had to occur through item receipts, even if you wanted to have a single transaction.
- 17:45Dan DeLong: But you have to now use item receipts because, and this is where I think accountants and bookkeepers are, going to get surprised I think is the the politest way to say this.
- 17:59Dan DeLong: So when you...
- 18:00Dan DeLong: And I'll show it in a, demonstration in a short- shortly That when you have this set to item receipts being the source of truth for receiving inventory, when you enter a bill and put items on it, it will not affect the right accounts because it's expecting the item receipt to do that for you.
- 18:24Dan DeLong: So we have an item receipt blog on schoolbookkeeping.com where we just talk about this whole process.
- 18:32Dan DeLong: I do put the podcast when I talked about it with Alicia Cass Pollock on that blog, so you can listen to the blog there, or you can listen to the podcast there on the blog.
- 18:42Dan DeLong: And of course read all about it if you want to.
- 18:47Dan DeLong: And now, so let's do a little demonstration.
- 18:50Dan DeLong: Okay.
- 18:51Dan DeLong: So here in QuickBooks Online, this is the sales rep-
- 18:56Sharrin Fuller: Demo time.
- 18:56Sharrin Fuller: Thanks for the song.
- 18:58Dan DeLong: Everybody wake
- 18:59Sharrin Fuller: up, it's demo time.
- 19:01Sharrin Fuller: Oh my God, let's record that.
- 19:03Dan DeLong: That's right.
- 19:04Dan DeLong: Let's have a little jingle.
- 19:05Sharrin Fuller: I got sidetracked because Vegas just blocked Cassidy from being able to interview with Edmonton as their head h- hockey coach- Oh and I am in a whole different world here right now.
- 19:16Sharrin Fuller: I just want everybody to know, hockey first.
- 19:18Sharrin Fuller: All right.
- 19:18Sharrin Fuller: Go ahead, Dan.
- 19:19Sharrin Fuller: Let's demo this.
- 19:20Dan DeLong: All right.
- 19:21Dan DeLong: So in sales in your preferences or account and settings, you go into sales, and then under products and services you'll have this inventory receiving method.
- 19:31Dan DeLong: Your, it does have that new flag in front of it.
- 19:34Dan DeLong: You can see in my case, it's grayed out.
- 19:36Dan DeLong: I can't change it.
- 19:38Dan DeLong: It even tells me right below that,"This setting can't be changed," because I went past that point of no return of turning on item receipts as my inventory receiving method.
- 19:49Dan DeLong: So normally you would just go into your item receipts, which...
- 19:56Dan DeLong: Now, where are they?
- 19:58Dan DeLong: Now I couldn't find them.
- 20:01Dan DeLong: I d- I've fumbled around with this before.
- 20:05Dan DeLong: And where are they hiding?
- 20:10Sharrin Fuller: Dan, I wanna- I missed- restart on this demo.
- 20:12Dan DeLong: Yeah.
- 20:13Sharrin Fuller: I already don't like whatever product we're looking at right now.
- 20:16Sharrin Fuller: I hate
- 20:16Dan DeLong: it.
- 20:16Dan DeLong: It should be in here in the, under the
- 20:18Sharrin Fuller: vendors
- 20:19Dan DeLong: section.
- 20:19Sharrin Fuller: Mimbusa! Honestly, it was probably there last night, and you woke up and it's gone.
- 20:22Sharrin Fuller: Oh, yeah.
- 20:22Sharrin Fuller: I am telling you that.
- 20:23Sharrin Fuller: How many times have I messaged you, I'm like,"Dan, where'd it go?
- 20:25Sharrin Fuller: Where'd it go?" I know.
- 20:27Sharrin Fuller: Even Claude don't know.
- 20:31Dan DeLong: Wherever it is- Is it in Google?
- 20:33Dan DeLong: You end up...
- 20:34Dan DeLong: Somebody help me out.
- 20:36Dan DeLong: But what I really wanted to demo here is I'm gonna, I'm gonna receive some inventory items with a bill.
- 20:44Dan DeLong: Now that setting is turned on.
- 20:45Dan DeLong: All right, so I've got some really expensive Beach Mint gum here,$5 for a 10 count.
- 20:53Dan DeLong: 3 Musketeers king size for six bucks, which somehow- Oh my gosh has a description of
- 20:59Sharrin Fuller: like- That is how much they are now.
- 21:01Sharrin Fuller: Does anybody here remember when candy bars were 39 cents at Walmart, and the king size were, like, 89?
- 21:08Sharrin Fuller: I went to 7-Eleven the other day,$4.59 for a king size PayDay.
- 21:13Sharrin Fuller: $4.59 for nuts and sugar.
- 21:15Sharrin Fuller: Insanity.
- 21:16Sharrin Fuller: Insanity.
- 21:18Sharrin Fuller: All right, finish.
- 21:19Sharrin Fuller: I just had to make sure that I was- not alone in this.
- 21:22Dan DeLong: And they're small.
- 21:22Sharrin Fuller: No, nobody cares.
- 21:24Dan DeLong: And they're
- 21:24Sharrin Fuller: small.
- 21:24Sharrin Fuller: Yeah, the king size are not king anymore.
- 21:26Sharrin Fuller: They're like normal.
- 21:28Sharrin Fuller: It's m- I just stock up on Halloween.
- 21:30Sharrin Fuller: They're barely- I'm like, I'm going trick-or-treating and saving candy for the year because I can't afford candy bars anymore.
- 21:36Sharrin Fuller: This is just crap.
- 21:37Dan DeLong: They're barely prince size.
- 21:39Sharrin Fuller: And I can't drive to get candy bars.
- 21:41Sharrin Fuller: I walk around my neighborhood and steal candy from my neighbors.
- 21:43Sharrin Fuller: Yeah.
- 21:43Sharrin Fuller: That's what I'm doing this year from now on.
- 21:45Sharrin Fuller: A nickel, Charity.
- 21:47Sharrin Fuller: All right.
- 21:47Sharrin Fuller: Goddamn don't, age yourself here.
- 21:51Dan DeLong: Thank you.
- 21:51Dan DeLong: Charity she, mentioned if you put the s- term in the search bar Yes item receipts up, up at the top, that will that will bring up the actual way to get to it.
- 22:00Dan DeLong: And then of course you could bookmark it or, what have you if regardless of where they might move the option later.
- 22:08Dan DeLong: Yeah.
- 22:08Dan DeLong: Which I should've realized that before.
- 22:11Sharrin Fuller: When we started.
- 22:12Sharrin Fuller: You know what?
- 22:12Sharrin Fuller: I love it because when you do demos like this and it moves, and Dan you're the, expert.
- 22:17Sharrin Fuller: When everybody, anybody- Yeah asks anything about QuickBooks, I'm like,"Go to Dan." I love, and I'm sure everybody else loves seeing this, that you as the expert are even like,"What the..." It makes you feel better.
- 22:27Sharrin Fuller: Weird.
- 22:27Sharrin Fuller: And then it also- sees how Dan fixed it, so I think it's a good thing.
- 22:31Sharrin Fuller: I hope it was planned.
- 22:31Sharrin Fuller: If not, pretend it was'cause that was brilliant.
- 22:34Sharrin Fuller: Keep going.
- 22:34Dan DeLong: There we go.
- 22:35Dan DeLong: So we have some inventory items in here that as I selected my vendor named Vendor it, prompted with,"Do you want to refill pre-fill from the last one?" Which I said yes instead of no, so it just brought over a whole bunch of inventory items.
- 22:51Dan DeLong: I'm gonna save it, and then we're gonna take a look at the, transaction journal under the hood, which under more and clicking transaction journal.
- 23:03Dan DeLong: Waiting.
- 23:06Dan DeLong: A little bit more waiting.
- 23:08Dan DeLong: Okay, so you see that the inventory items themselves are offsetting instead of accounts pay- or inventory asset we are looking at every inventory item that's on there is inventory offset.
- 23:25Dan DeLong: So even though I went straight to a bill and I said- I, here's I'm, receiving this bill with these, this merchandise.
- 23:34Dan DeLong: It is posting to inventory asset.
- 23:37Dan DeLong: It is not posting to- The inventory asset account that you have specified on the items, which one would expect to see, right?
- 23:48Dan DeLong: So we have seen,
- 23:50Sharrin Fuller: So Dan, I am- Yeah paying half attention in my normal way- because I have seven screens open.
- 23:56Dan DeLong: That's
- 23:56Sharrin Fuller: 25%- It's not supposed to do that more
- 23:57Dan DeLong: than usual.
- 23:58Sharrin Fuller: I know.
- 23:59Sharrin Fuller: It's not supposed to do that, right?
- 24:02Dan DeLong: It's
- 24:02Sharrin Fuller: under
- 24:03Dan DeLong: normal.
- 24:03Sharrin Fuller: That's, it's extra steps.
- 24:04Sharrin Fuller: Under nor- So now I'm gonna have to go into my balance sheet and I'm gonna have to make a journal entry-
- 24:09Dan DeLong: No
- 24:09Sharrin Fuller: to adjust out...
- 24:10Sharrin Fuller: No?
- 24:10Sharrin Fuller: Okay, you're gonna keep showing me.
- 24:11Sharrin Fuller: No, you- Okay you
- 24:12Dan DeLong: don't have to, right?
- 24:13Dan DeLong: You just need to make sure that these transactions that are, that you're following the proper workflow
- 24:19Sharrin Fuller: of- Okay.
- 24:20Sharrin Fuller: So what I'm say- Of- What I'm thinking here is somehow the dis- the actual item set up or whatever was actually set up in the, the- No Like a product.
- 24:27Sharrin Fuller: Okay, I haven't used inventory in QuickBooks in 10 years, so I swear to God, I have, I know QuickBooks.
- 24:36Sharrin Fuller: I do not...
- 24:37Sharrin Fuller: Inventory, I have not used in so long,
- 24:40Dan DeLong: but as Jan is asking in the, question, how do you fix this inventory
- 24:44Sharrin Fuller: option?
- 24:44Sharrin Fuller: Yeah, that's what I'm asking, Jan.
- 24:45Sharrin Fuller: That's what I was trying to ask without asking it, so thanks, Jan.
- 24:48Sharrin Fuller: I'm gonna go ahead and click answer live.
- 24:51Sharrin Fuller: Absolutely.
- 24:51Sharrin Fuller: There
- 24:51Dan DeLong: you go.
- 24:52Dan DeLong: Yeah.
- 24:53Dan DeLong: Now, we now what we could normally do is is just use this to copy what would be great and maybe Tool has an option or while they're, while we're waiting for Intuit to actually have the option to copy to item receipt would be the perfect option because you have the same thing, just not in the in, a, in an item
- 25:22Sharrin Fuller: receipt.
- 25:22Sharrin Fuller: Dan, if you don't update your Speechify or click out of that- I'm gonna go crazy.
- 25:26Sharrin Fuller: Thank you.
- 25:26Sharrin Fuller: Sorry.
- 25:27Sharrin Fuller: Oh my God, make it go away.
- 25:29Sharrin Fuller: My OCD can't take it.
- 25:31Sharrin Fuller: Okay, thank you.
- 25:32Sharrin Fuller: Sorry.
- 25:35Sharrin Fuller: All right.
- 25:36Sharrin Fuller: All right.
- 25:37Sharrin Fuller: Keep going.
- 25:37Sharrin Fuller: I'm interested in this.
- 25:38Sharrin Fuller: So- You see me, I'm not even caring if people are looking in, I'm paying attention, because I'm really, interested.
- 25:43Dan DeLong: So let's create a new, item receipt.
- 25:49Dan DeLong: Let's go back here, new item receipt.
- 25:51Sharrin Fuller: You're gonna show us how to do it right.
- 25:52Dan DeLong: Vendor.
- 25:54Sharrin Fuller: Not the Canadian vendor, eh?
- 25:56Sharrin Fuller: We don't have- maple syrup set up, just because- And now the challenge is- I love Canadians.
- 25:59Sharrin Fuller: I've been accused of not liking Canada.
- 26:00Sharrin Fuller: I love Canada.
- 26:02Dan DeLong: And, what we're finding here is that as soon as I put this on an, item receipt, I don't get the prompt like I do for every other transaction type that says,"Hey, would you like to use the last item number?" But
- 26:13Sharrin Fuller: Dan, this feature is now 7.95 more a month on your subscription, just so you know- That's right because we created an upgrade for you.
- 26:20Dan DeLong: So I'm gonna select what I think were the c- the most- That was a snort Common ones.
- 26:28Sharrin Fuller: I think
- 26:28Dan DeLong: I'm
- 26:28Sharrin Fuller: hilarious
- 26:30Dan DeLong: I'm just choosing some items here.
- 26:33Sharrin Fuller: Water Malone?
- 26:36Dan DeLong: Watermelone.
- 26:37Dan DeLong: What-
- 26:38Sharrin Fuller: This is Canadian.
- 26:41Dan DeLong: Oh, I got to put in- Hey I got to wait, speechify.
- 26:45Dan DeLong: So let's put in...
- 26:48Dan DeLong: And I'm just gonna go down the list here and just choose-
- 26:51Sharrin Fuller: Honestly, Dan, this is just really wo- seeing all these candy bars is just really pissing me off- that I paid$4.59 for a PayDay,'cause I did, I'm not gonna lie.
- 26:58Sharrin Fuller: I did pay for it.
- 26:59Sharrin Fuller: Yeah.
- 26:59Sharrin Fuller: I really wanted that damn candy bar.
- 27:03Dan DeLong: So now when I save this so now I can look at the transaction journal.
- 27:08Dan DeLong: As we had seen, every inventory item in a bill was pointing to inventory offset, so is every item receipt, but it's, So
- 27:18Sharrin Fuller: it's du- doubled now then is what we're seeing?
- 27:20Sharrin Fuller: I just- Is it's doubled?
- 27:21Dan DeLong: It's doubled, it's doubled.
- 27:23Dan DeLong: Okay.
- 27:23Dan DeLong: It's it's doubled, but it's, the debits versus the credits, right?
- 27:27Dan DeLong: So-
- 27:28Sharrin Fuller: Okay
- 27:28Dan DeLong: this, the bill, so let's just customize this and add.
- 27:32Sharrin Fuller: Oh, no, I see the debit/credit, but what about the other one trans?
- 27:34Sharrin Fuller: Yeah.
- 27:35Sharrin Fuller: So I know you just entered the other- Yes transaction.
- 27:37Sharrin Fuller: You're gonna remove one.
- 27:38Sharrin Fuller: So what you're showing us here...
- 27:39Sharrin Fuller: Oh, okay.
- 27:40Sharrin Fuller: Derp, I see this.
- 27:42Sharrin Fuller: So the other one came, it's an inventory offset, right?
- 27:44Sharrin Fuller: Oh, it's, now you just came and you credit out the inventory offset and moved it back to a debit.
- 27:48Sharrin Fuller: So essentially it's ju- almost a journal entry, but it, this is double entry, right?
- 27:53Sharrin Fuller: We, why did we have to do this twice?
- 27:55Sharrin Fuller: So I feel like you just had to do one thing, one thing two times, which is, honestly, why would I not just use Xero, which is every t- thing I have to do in there you have to do twice.
- 28:06Dan DeLong: This is allowing you to separate your, the receiving of the item-
- 28:12Sharrin Fuller: Okay
- 28:12Dan DeLong: different from the
- 28:13Sharrin Fuller: receipt of the bill.
- 28:13Sharrin Fuller: It's just so different than what I'm used to, right?
- 28:15Sharrin Fuller: Yeah.
- 28:16Sharrin Fuller: I just remember before I'd have a, PO or a sales order.
- 28:20Sharrin Fuller: Yeah.
- 28:20Sharrin Fuller: And then you'd receive against a sales order.
- 28:22Sharrin Fuller: When you received it, then you'd push it to a bill and you reconcile against your bill.
- 28:26Sharrin Fuller: It was really that simple.
- 28:27Sharrin Fuller: It seems like they took a very simple process and pushed it into whatever the hell they're doing here.
- 28:31Sharrin Fuller: Well- Am I wrong?
- 28:34Dan DeLong: If you're doing this on the same day, it is not-
- 28:36Sharrin Fuller: Jan does not want me to talk anymore, by the way.
- 28:39Sharrin Fuller: Go ahead.
- 28:40Sharrin Fuller: I'll be quiet.
- 28:42Dan DeLong: So the, reason for having it is that you want to be able to separate the two events the way that you, the way that the reality of, receiving in a different time period as getting the bill.
- 28:58Dan DeLong: Now, here we are in this demo.
- 29:01Dan DeLong: We're doing it all on the same day.
- 29:03Dan DeLong: To your point, why would I, why am I doing this today?
- 29:07Dan DeLong: Since you wouldn't be doing this today because you didn't receive the bill today.
- 29:11Dan DeLong: You would be receiving the bill or entering the bill when the bill came, whenever that came, which could be a month from now, it could be two months from now.
- 29:20Dan DeLong: It could be next week.
- 29:21Dan DeLong: Or you might have had to pre-pay for your inventory, in which case you would put in the items that you ordered on a credit card transaction or an expense- And that is gonna go to inventory offset when you've actually received it, the shipping, however long that's gonna take.
- 29:39Dan DeLong: That's when you want your inventory to your quantities to actually take place.
- 29:45Dan DeLong: Now let's change the date of the of the item receipt to last month.
- 29:51Dan DeLong: So we'll do this on April 12th.
- 29:56Dan DeLong: So we have that, and we will do this...
- 30:00Dan DeLong: Let's take a look.
- 30:01Dan DeLong: Oh, Intuit Intelligence didn't mean to ask you anything.
- 30:08Dan DeLong: So it's April 12th for the item receipt, and we have today, May 12th, for the bill.
- 30:15Dan DeLong: Now, I know we don't pro- we probably don't have the exact same items on there, but let's take a look at this Laffy Taffy assorted jars item, right?
- 30:26Dan DeLong: Go into our products and services.
- 30:31Dan DeLong: Let's see.
- 30:31Sharrin Fuller: While you're not talking for two seconds- Yeah I just realized I'm responding to Charity in here.
- 30:36Sharrin Fuller: The last time I used QuickBooks Inventory was on desktop.
- 30:39Sharrin Fuller: Ah.
- 30:40Sharrin Fuller: So in fact, QuickBooks Online did not even have an inventory module, so I always used desktop.
- 30:45Sharrin Fuller: And then when I started having clients with inventory, we used to plug in.
- 30:48Sharrin Fuller: So that is why I'm like, what are we doing here?
- 30:51Sharrin Fuller: In desktop, it was It was easy.
- 30:53Sharrin Fuller: It was the right way.
- 30:54Sharrin Fuller: So this just seems, again, like a lot of steps.
- 30:57Dan DeLong: It's an extra step, yes.
- 30:59Dan DeLong: Oh, that was...
- 31:01Dan DeLong: Dang that speech if I...
- 31:02Dan DeLong: I, gotta just to see.
- 31:04Dan DeLong: I know.
- 31:04Dan DeLong: I'm in the wrong Chrome browser.
- 31:07Dan DeLong: So let's go into here.
- 31:10Dan DeLong: Oh, no.
- 31:13Dan DeLong: Stopped.
- 31:16Dan DeLong: I can't get away.
- 31:24Dan DeLong: That went...
- 31:24Dan DeLong: Ah, my goodness.
- 31:26Dan DeLong: I can't scroll.
- 31:28Dan DeLong: All right.
- 31:32Dan DeLong: I can't get these this guy out of the way.
- 31:37Sharrin Fuller: I hate that.
- 31:38Sharrin Fuller: My Grammarly does that, too.
- 31:39Sharrin Fuller: N- T- Ch- turn off for this session.
- 31:43Sharrin Fuller: Cli- click on that down.
- 31:44Sharrin Fuller: Click, where it went.
- 31:46Sharrin Fuller: I have to do this with my Grammarly.
- 31:47Sharrin Fuller: Yes for this session.
- 31:49Sharrin Fuller: Yes for this session.
- 31:50Sharrin Fuller: Go up.
- 31:50Dan DeLong: There we
- 31:51Sharrin Fuller: go.
- 31:51Sharrin Fuller: Now it'll go away.
- 31:52Dan DeLong: Thank
- 31:52Sharrin Fuller: you.
- 31:52Sharrin Fuller: And then click that up.
- 31:54Sharrin Fuller: Click that X out, or I'm gonna go crazy.
- 31:56Sharrin Fuller: Thank you.
- 31:57Sharrin Fuller: Get rid of it.
- 31:58Sharrin Fuller: All
- 31:58Dan DeLong: right.
- 32:01Dan DeLong: So you see the this particular item the, actual quantity is being impacted on the item receipt not, the bill, right?
- 32:18Dan DeLong: So the all accounting as far as the, receiving of the, item is being impacted on the, date of the item receipt when you have that preference set to item receipts.
- 32:31Dan DeLong: So- The, where this gets people into a quandary is that if somebody has turned this on and they go right in to enter a bill, then- they're gonna have things posting to the wrong asset account- which will be inventory asset- inventory offset- not inventory asset.
- 32:52Dan DeLong: So the quantities are not gonna be right.
- 32:55Dan DeLong: And subsequently, if the qua- the cost of the item has changed, then the cost of goods sold entries are gonna be wrong because-
- 33:04Sharrin Fuller: Question
- 33:05Dan DeLong: it hasn't been received yet.
- 33:06Dan DeLong: Yes?
- 33:08Sharrin Fuller: So if something's posted at inventory offset, is that account, is that amount still available in my inventory or no?
- 33:16Sharrin Fuller: Is it, taking down my...
- 33:17Sharrin Fuller: So I had 100, I post 10 to inventory offset, is now 90 available, or is it still holding 100 until I move it out of the inventory asset?
- 33:26Dan DeLong: It is not in your inventory.
- 33:27Dan DeLong: The quantity and is in, is not in your inventory, even from the bills perspective until you have recorded an item receipt if you are using- Okay this option, right?
- 33:41Sharrin Fuller: So this- I don't think I'm dumb, but this just seems like a lot.
- 33:44Sharrin Fuller: I'm just...
- 33:45Sharrin Fuller: I'm having...
- 33:46Sharrin Fuller: I'm just glad I don't deal with inventory, so in QuickBooks Online.
- 33:49Sharrin Fuller: When, you, when you- what's a good solution to not use QuickBooks?
- 33:55Sharrin Fuller: It's, Sync it?
- 33:55Sharrin Fuller: Is that what they do?
- 33:57Dan DeLong: If you are...
- 33:59Dan DeLong: You're gonna be doing a lot of extra work if you're using an inventory management solution as, well, right?
- 34:05Dan DeLong: This is, The purpose of this is when you need to separate those two events into two events, and that's the use case for turning it on to item receipts.
- 34:16Dan DeLong: You can still use item receipts without it turning on turning on this option, and then you're back to bills, right?
- 34:28Dan DeLong: But your item receipts are not gonna impact the quantity on hand.
- 34:31Dan DeLong: So it ends up getting like this six of one, or Which option is, better?
- 34:38Dan DeLong: It depends, right?
- 34:39Dan DeLong: It depends on if you need that, right?
- 34:42Dan DeLong: So if you do need to separate those two events into two separate transactions, this works great for that.
- 34:54Dan DeLong: Now, just keeping in mind that if somebody enters a check, expense, or a bill and puts inventory items on it, that needs to have an item r- an equal and opposite item receipt, which means it, if it's Is because it's gonna be posting to this mysterious account called inventory assets- As far as what you have on hand, and it's gonna be the wrong way.
- 35:22Dan DeLong: It's gonna be the debit versus the credit, or the credit versus the debit.
- 35:25Dan DeLong: So it'll show that you have less on hand as far as the value of your inventory, because you've got this negative amount sitting in inventory offsets- which the item receipt- Can I ask
- 35:38Sharrin Fuller: you, I have a co- Yeah.
- 35:39Sharrin Fuller: Oh, sorry.
- 35:40Dan DeLong: No,
- 35:40Sharrin Fuller: go ahead.
- 35:40Sharrin Fuller: I have a couple questions that that, that are coming in that I can't answer, obviously.
- 35:45Dan DeLong: Yeah.
- 35:46Sharrin Fuller: From Jan,"I have a client that we set the inventory receiving to bills and expenses, not item receipt.
- 35:51Sharrin Fuller: Where does it post then?" It's just posting to whatever your service is set up as, right?
- 35:55Sharrin Fuller: Yes.
- 35:55Sharrin Fuller: So that's what I assume.
- 35:56Sharrin Fuller: And it- So if you have a product
- 35:57Dan DeLong: set
- 35:57Sharrin Fuller: up
- 35:57Dan DeLong: and it's
- 35:57Sharrin Fuller: gonna
- 35:57Dan DeLong: be, and it's gonna be posting based off of that bill or expense.
- 36:01Dan DeLong: Yep.
- 36:02Dan DeLong: So that- Okay that's gonna be the transactional source of truth for receiving, and, the, posting of those items to wherever they're, the items are, posting to.
- 36:14Sharrin Fuller: See, I never used item receipts for this reason.
- 36:16Sharrin Fuller: It just seemed like a lot.
- 36:17Sharrin Fuller: And then this, I think I happen to know the answer, but I'm gonna let you answer.
- 36:20Sharrin Fuller: When you go to enter the bill, does it remind you have item receipts, and can you pick yours?
- 36:25Dan DeLong: Yes, and that was, So let me go back and enter in a bill.
- 36:33Dan DeLong: Not a pay bill.
- 36:35Dan DeLong: I put in its vendor again.
- 36:38Dan DeLong: We have the drawer.
- 36:39Sharrin Fuller: Yeah, it should pop up.
- 36:40Sharrin Fuller: Yep.
- 36:40Sharrin Fuller: Oh,
- 36:41Dan DeLong: apparently
- 36:41Sharrin Fuller: that session- Just like expenses.
- 36:42Sharrin Fuller: Hey, you have a...
- 36:43Sharrin Fuller: Yeah, awesome.
- 36:44Dan DeLong: Yeah, they show up here, and then you can add them.
- 36:47Dan DeLong: Yeah.
- 36:47Dan DeLong: Add the items
- 36:48Sharrin Fuller: you can enter.
- 36:48Sharrin Fuller: So this I do I do think, I do want to commend again, I'm as, I...
- 36:52Sharrin Fuller: There is some things that Intuit does I like.
- 36:55Sharrin Fuller: I do like their auto-fill feature, and I do like this whole piece.
- 36:58Sharrin Fuller: This has made...
- 36:59Sharrin Fuller: I actually stopped using third-party bills because of this for a while,'cause I'm like, why would I?
- 37:05Sharrin Fuller: Another, can you go back and tie an item receipt to the bill?
- 37:09Sharrin Fuller: Yeah.
- 37:09Sharrin Fuller: You should be able to.
- 37:09Sharrin Fuller: If you connect it to a bill, you should be able to click into anything and it should tie it.
- 37:13Sharrin Fuller: Everything ties back via link, correct?
- 37:16Dan DeLong: Yeah what I would suggest doing is if you do have an item receipt-
- 37:19Sharrin Fuller: That was from Barb.
- 37:20Dan DeLong: Yeah.
- 37:21Dan DeLong: If you do have an item receipt already, and you, somebody entered in a bill erroneously, just deleting the bill and then re-entering a bill, and then it will then-
- 37:32Sharrin Fuller: Retie
- 37:32Dan DeLong: into
- 37:32Sharrin Fuller: the expense
- 37:33Dan DeLong: give you this option.
- 37:34Dan DeLong: Yeah.
- 37:35Dan DeLong: But I don't think you can go after the fact and, retie it to the from an
- 37:40Sharrin Fuller: existing transaction.
- 37:41Sharrin Fuller: It'll remind you.
- 37:41Sharrin Fuller: It's already here.
- 37:42Sharrin Fuller: Yeah, It'll, or it's already connected to something else, like when you try to re-undo a deposit and they're like,"No, it's connected." One last one.
- 37:50Sharrin Fuller: Charity wants to know when this feature began, as she has a client using QuickBooks Inventory, this feature.
- 37:56Dan DeLong: This feature when we last talked about it on the open tab, I think was the, our first one in, March, and I think that was part of the inventory enhancements when we were talking about sales orders and item receipts and those types of things moving average costs, the MAC options for weighted average as opposed to FIFO.
- 38:21Dan DeLong: So if you're not seeing this option in an existing client it's, typical for these types of things to start with new customers or new clients new to QuickBooks and to work them way...
- 38:36Dan DeLong: mer- work their way into existing subscriptions with whatever has been deemed as the most complicated data being last, right?
- 38:47Dan DeLong: If your client already has a, s- a significant inventory usage inside of QuickBooks Online chances are they may not even see this.
- 38:58Dan DeLong: And if they don't, then they may not see it for a while, while your other ones that might never need it they have this option all the way.
- 39:07Dan DeLong: But it's because that's typically the way that new features are, rolled out.
- 39:12Dan DeLong: New, new cl- new clients get it first, and then increasingly more complicated data sets because for, to their credit they don't wanna explode your
- 39:25Sharrin Fuller: data.
- 39:25Dan DeLong: Yeah.
- 39:25Sharrin Fuller: You...
- 39:26Sharrin Fuller: They try not to.
- 39:27Sharrin Fuller: They roll it out to us, and usually they throw it in beta and let us opt in, right?
- 39:30Sharrin Fuller: Which is, Yeah also a good thing.
- 39:31Sharrin Fuller: You know what I wish, a feature I wish Intuit would put in, is if you are an accountant, that you can turn off allowing your clients to opt in to thing.
- 39:41Sharrin Fuller: You're like,"Hey, they've already gone through it.
- 39:42Sharrin Fuller: Do not let them click in advance.
- 39:44Sharrin Fuller: Do not let them turn these things on.
- 39:46Sharrin Fuller: Do not let them use this.
- 39:47Sharrin Fuller: Stop it." I feel, back in the day, I felt like we had some of that control.
- 39:51Sharrin Fuller: I say we, I don't have clients anymore.
- 39:53Sharrin Fuller: I have one that I'm a CFO for.
- 39:55Sharrin Fuller: But but don't you feel like that...
- 39:59Sharrin Fuller: I feel like we used to be able to do it back in the day, and now in days, and clients, of course, with all the AI out there, they're like,"Oh, I can do all this now.
- 40:05Sharrin Fuller: I can just look your job up." So they're in there playing around or, QuickBooks calls them up.
- 40:10Sharrin Fuller: I'd wanna be able to be like,"No." Yeah.
- 40:13Sharrin Fuller: "Out of bounds.
- 40:13Sharrin Fuller: Get out of here.
- 40:14Sharrin Fuller: Mine." Yes.
- 40:14Sharrin Fuller: I just think that would be a good feature.
- 40:17Dan DeLong: Yeah.
- 40:17Dan DeLong: I would I would, think about maybe putting in a Zap or something like that when settings are changed, right?
- 40:25Dan DeLong: To automatically send- Ooh.
- 40:27Dan DeLong: Send them an email- I bet that's one that Make or some of those Zap- Or send you an alert.
- 40:30Dan DeLong: I'm
- 40:30Sharrin Fuller: gonna look into that.
- 40:31Dan DeLong: Yeah.
- 40:31Dan DeLong: Or maybe it up- automatically updates your client's engagement letter to if you mess with the settings, it'll cost you.
- 40:41Sharrin Fuller: Yeah.
- 40:42Sharrin Fuller: I bet you can...
- 40:43Sharrin Fuller: I don't think Zap will do that, but I bet you can write it in Make.
- 40:46Dan DeLong: Yeah, something like that.
- 40:48Dan DeLong: Now we do have some- I'm gonna
- 40:49Sharrin Fuller: try
- 40:50Dan DeLong: it Inventory resources- And sell it over at School of Bookkeeping.
- 40:53Dan DeLong: We have an Inventory Fundamentals course where we talk about what you can track in QuickBooks Online, what can you track in QuickBooks Desktop.
- 41:00Dan DeLong: And we have a workshop comparison of qui- advanced inventory with QuickBooks Desktop Enterprise versus Katana.
- 41:08Dan DeLong: And then we also have an E-commerce Fundamentals course as well, where we talk about some of the inventory concerns for those types of industries.
- 41:16Dan DeLong: So next polling question: Of your clients with inventory, what percentage use QBO for inventory management?
- 41:24Dan DeLong: Because, there, there is a finite area of workflows that QuickBooks Online will, manage, and it really falls under the category of a reseller of hard goods, meaning I buy stuff and I sell that same stuff.
- 41:45Dan DeLong: I don't do anything to that stuff between the time that I buy it and I sell it.
- 41:50Dan DeLong: And I don't need to know where it is, how much is on hand, how much might be promised for other clients.
- 41:58Dan DeLong: I don't build it into other things.
- 42:01Dan DeLong: So the reseller of goods is, the sweet spot for, QuickBooks Online for as far as inventory management is concerned.
- 42:11Dan DeLong: When you have more specific needs, like I buy in one quantity and I sell in others, or I need to know...
- 42:20Dan DeLong: I have some traceability I'm in pharmaceuticals or food or electronics where I want to trace when I bought something and who I sold it to in case there's a problem with said product, that's not where QuickBooks Online's inventory management spot shines.
- 42:41Dan DeLong: I guess that's the nicest way to put it.
- 42:44Dan DeLong: So that was a lot
- 42:47Sharrin Fuller: That was a lot.
- 42:49Dan DeLong: For one topic.
- 42:51Sharrin Fuller: Oh, are we're onto the next one?
- 42:53Sharrin Fuller: Anyhow.
- 42:53Sharrin Fuller: Yeah, it was a lot, but I feel like I think it's important.
- 42:57Sharrin Fuller: I don't know.
- 42:57Sharrin Fuller: I learned something there.
- 42:58Sharrin Fuller: Yeah.
- 42:58Sharrin Fuller: Like I said, I don't ever use...
- 43:00Sharrin Fuller: I just, I remember the last time I used inventory was desktop.
- 43:04Sharrin Fuller: Yeah.
- 43:04Dan DeLong: Well-
- 43:05Sharrin Fuller: So of course it doesn't work that way.
- 43:07Sharrin Fuller: Of course desktop was easier.
- 43:09Dan DeLong: But, now that we've talked about it, at least for the 101 participants that are, here I don't want to see anybody posting in our Facebook group about"QuickBooks is broken because a bill, I posted a bill, and it's going to this inventory offset account," right?
- 43:25Dan DeLong: So now we know that it's working as designed, it's just not working the way that you would expect it to, and that's because this feature, this this setting is turned on, and that's something that is a setting- That cannot be undone, right?
- 43:42Dan DeLong: So once you cross over that threshold and change to item receipts as your source of truth for inventory receiving, all of your inventory receiving has to be done through an item receipt, which is this is one of those things that customers can change it, but should they, right?
- 44:04Dan DeLong: So you just wanna understand the ramifications of, turning it on and what that means, right?
- 44:11Dan DeLong: So inventory offset is not a broken account.
- 44:15Dan DeLong: It's just a used account when this feature is turned on for inventory item receipts.
- 44:21Dan DeLong: There we go.
- 44:23Dan DeLong: So let's talk a little bit about desktop migration changes because as Intuit is e- exceedingly pushing, putting the pressure on desktop customers to move to QuickBooks Online, they are also s- putting a lot of effort into the desktop migration process when you move from QuickBooks Desktop to QuickBooks Online inside the product, right?
- 44:49Dan DeLong: This is not talking about migration through SaaSand or some other service.
- 44:58Dan DeLong: This is just inside of QuickBooks.
- 45:00Dan DeLong: You're in the company file.
- 45:01Dan DeLong: You and you're using the option to export to QuickBooks Online, right?
- 45:07Dan DeLong: So now more data is an option, right?
- 45:10Dan DeLong: So it used to be when I worked there, it was like 150,000 targets, which is basically the definition of what a target is, it's a transaction split, right?
- 45:21Dan DeLong: So you have a check with a five different line items on it.
- 45:27Dan DeLong: It's got five targets, right?
- 45:28Dan DeLong: So that's the splits of the check are the targets.
- 45:32Dan DeLong: So 4 million is a lot of data, right?
- 45:35Dan DeLong: If you've got a lot of transactions with a lot of line items on them 4 million is, a significant amount of, data.
- 45:45Dan DeLong: So- removing the obstacle of I can't move to QuickBooks Online because I've got too much data to move.
- 45:55Dan DeLong: Now there's 4 million targets to work with.
- 45:59Dan DeLong: Does it work every time with four 3.7 million?
- 46:03Dan DeLong: That's gonna take a long time to actually process, so we don't know, right?
- 46:07Dan DeLong: We don't...
- 46:08Dan DeLong: The most that I've done is like 2.5 million, and it took a day or day and a half to actually process, but it did work, right?
- 46:18Dan DeLong: But now something that we have talked about before in the past where, you can Move payroll a little bit more succinctly, and you can move attachments now with with the Desktop migration process.
- 46:33Dan DeLong: There's now a new wizard, a migration wizard that comes in and checks a couple things.
- 46:39Dan DeLong: Some of the things that we've seen in the past where have been a, huge challenge after or post-conversion.
- 46:50Dan DeLong: Unbilled charges is a huge,
- 46:54Sharrin Fuller: Yeah potential problem.
- 46:55Sharrin Fuller: That one doesn't come over, right?
- 46:58Dan DeLong: The challenge, and we'll talk, we'll get it, get into it a little deeper.
- 47:02Dan DeLong: When you have a time or expense that's a, that's associated with a project or a job inside of Desktop, and you haven't billed for it or and you aren't those come back up to the surface.
- 47:19Dan DeLong: So this can come in a lot of ways.
- 47:22Dan DeLong: But also inactive customers, inactive vendors, and inactive accounts gives you the opportunity to make them inactive.
- 47:31Dan DeLong: Inactive meaning that they haven't been used in the last 10 years according, or two years, according to the file checkup that it does.
- 47:40Dan DeLong: And then it also gives you some better indication of what you should be doing to maintain your file post-conversion or pre-conversion, right?
- 47:50Dan DeLong: So verifying your company data because GIGO, garbage in, garbage out.
- 47:56Dan DeLong: If you've got data that's damaged the chance of that moving over is diminished by by the fact that it's got some damage to the data, right?
- 48:08Dan DeLong: Never know what, what's, gonna occur.
- 48:11Dan DeLong: You also do have a little bit more flexibility with what you actually bring over'cause now there is an option.
- 48:19Dan DeLong: You can always bring over just lists and balances before but now when you choose that option of lists and balances, you can choose the specific lists that you wanna bring over, right?
- 48:31Dan DeLong: So this gives you a good opportunity to basically create a, shell company for, your customers, or if you have just a chart of accounts that you wanna use from Desktop, you can use that as a starter company.
- 48:46Dan DeLong: You also do have the, chart of accounts templates as an option or feature just in QuickBooks Online Accountant or Intuit Accountant Suite, excuse me- As well.
- 49:00Dan DeLong: All right.
- 49:01Dan DeLong: So unbilled purchases or expenses.
- 49:03Dan DeLong: These are expenses that are marked billable, but they were never billed inside- of QuickBooks, right?
- 49:10Dan DeLong: So it's a commonly missed workflow, right?
- 49:14Dan DeLong: They're check marked by default in Desktop, so as soon as you put an expense on a Transaction and mark it to a customer.
- 49:23Dan DeLong: I-in Desktop, it puts a check mark that it's billable and that puts it in this on-deck circle of waiting to be billed back to the customer, right?
- 49:34Dan DeLong: So your contractors who do just a, lot of time and materials and expenses and with markup that works great for them because then they can put that back onto an invoice, bill it back to the customer.
- 49:49Dan DeLong: That closes the whole loop of that workflow.
- 49:53Dan DeLong: But a lot of people my experience talking to, to, to people didn't even realize that was an option, right?
- 50:00Dan DeLong: As soon as you bring up an invoice and that window pops up and says,"Hey, you've got time and expenses or time costs to add," they just X out of that or move, forward and then just create their invoice.
- 50:13Dan DeLong: Maybe they wanna create it from the estimate instead of the, time and materials, right?
- 50:18Dan DeLong: So they wanna skip out of that.
- 50:20Dan DeLong: So they leave a lot of these unbilled expenses just sitting there because they can, right?
- 50:28Dan DeLong: So they're not intended to be used by the company.
- 50:32Dan DeLong: And so what happens is that all of those unbilled purchases, they come over and it's now a-an issue because on the Sales Overview tab, there is this section for unbilled income.
- 50:49Dan DeLong: And this is a real screenshot from a real customer because they have nine point nine million dollars in unbilled income.
- 51:00Dan DeLong: But when we look at it, it's got transactions dating ten years ago.
- 51:05Dan DeLong: Because they were the two point five million Target customer that, that was moved over, right?
- 51:13Dan DeLong: So this ends up being a, challenge or it's a nuisance, right?
- 51:17Dan DeLong: You can only tell a customer just ignore that." Because they may actually, now that they know that they can do that, they might wanna use that.
- 51:27Dan DeLong: But if they've got this h- large number of nine point nine million dollars sitting in unbilled income, they really can't make much decisions off of that because it's filled with legacy or historical data that doesn't make any sense, right?
- 51:47Dan DeLong: So what this does actually in this option during the migration, it will list,"Hey, you've got-"$9.9 million in unbilled charges, and it will do that as part of the migration wizard to mark them not billable, right?
- 52:06Dan DeLong: So that$9.9 million of unbilled charges will go away because that's what you really need to do, is correct it in Desktop before it comes over into, QuickBooks Online.
- 52:18Dan DeLong: So in one fell swoop, you can mark all of those unbilled charges.
- 52:23Dan DeLong: There will be a...
- 52:26Dan DeLong: Did I have a screenshot with it?
- 52:28Dan DeLong: No, I did not.
- 52:29Dan DeLong: Sorry.
- 52:30Dan DeLong: There is a screenshot of or the, the-- in the screen itself, it will list all four of these things, unbilled charges and customers and vendors and accounts, and you can expand on them.
- 52:42Dan DeLong: You can see the individual ones.
- 52:44Dan DeLong: You can check off the ones that you want or you can skip the whole section of that at that point in time.
- 52:52Dan DeLong: So it does give you some insight into do it.
- 52:56Dan DeLong: It's not like an all or nothing type of thing which is, actually they've actually tho-thought this through, right?
- 53:02Dan DeLong: So to be able to do that.
- 53:05Dan DeLong: Now the biggest"Oh, yeah, but," to all of this is that if they're using Payroll in QuickBooks Desktop and they are using job costing on said payroll that's gonna pose a different challenge, right?
- 53:23Dan DeLong: So that customer this is all based off of the use case of that customer with two point five million targets.
- 53:30Dan DeLong: They have$9.9 million in unbilled charges, and they were using QuickBooks Payroll and putting their job costing on those paychecks.
- 53:42Dan DeLong: Paychecks, by default, don't come over as paychecks during the conversion.
- 53:48Dan DeLong: It only brings over the current year's payroll data as, year to date so that you can move forward from the date of conversion moving forward.
- 53:57Dan DeLong: Historical paychecks, they come over as regular checks.
- 54:02Dan DeLong: That ends up causing a challenge now with the unbilled revenue because in order to maintain the job costing of the expenses versus the the costs and the income of those jobs, to maintain the stability of those reports, it brings over the checks the paychecks as checks split out by account, by, by expense account.
- 54:33Dan DeLong: And those that are posted to a job or a project, they get marked as billable.
- 54:41Dan DeLong: So as you can see here on the, screenshot, those job costed expenses get marked as billable at that point inside of QuickBooks.
- 54:52Dan DeLong: Online.
- 54:53Dan DeLong: So even though you've cleaned up the unbilled expenses or the actual unbilled expenses, the conversion ends up causing more challenges because the way that paychecks get treated as regular checks, and if they're using job costing, right?
- 55:10Dan DeLong: Now, this can be corrected with tools, and we talked about this your options with handling unbilled purchases on a Workshop Wednesday that we did, right?
- 55:22Dan DeLong: So you have this option of using Desktop or Saasant to clear the billable flag in the, in Desktop, and then use...
- 55:31Dan DeLong: Or you can use the Manage.
- 55:34Dan DeLong: Now, for this particular issue of paychecks you can, you should be able to use the QuickBooks, the QBO tools to be able to manage that.
- 55:44Dan DeLong: There's a Manage Billable Expenses tool, hidden tool inside of QuickBooks where you can mark those as unbillable at that point.
- 55:53Dan DeLong: Or you can use Saasant or Saasant.
- 55:56Dan DeLong: I'm not quite sure of the emphasis.
- 55:59Sharrin Fuller: I say Saas-ant, but, saas-ant.
- 56:02Sharrin Fuller: I also say niche.
- 56:03Dan DeLong: Yes.
- 56:05Dan DeLong: You can see those in those options.
- 56:07Dan DeLong: There's a replay there.
- 56:09Dan DeLong: And on our next QB Power Hour, we're gonna be talking about making bulk edits in QuickBooks, where you can use some of these tools inside of, QuickBooks.
- 56:19Dan DeLong: We'll talk about Right Tool.
- 56:21Dan DeLong: We'll talk about Sasa- Saasant Spreadsheet Sync what's a- what's available in the product with- and what's available outside of that as a, an accountant toolbox.
- 56:35Dan DeLong: And then here's the last thing I want to talk about with the inactivating unused list elements.
- 56:41Dan DeLong: It does give you this screen where it's, it looks at customers that are older than, that haven't been used in the last two years or c- vendors that haven't been used or accounts that haven't been used in the last two years.
- 56:55Dan DeLong: You might want to make them inactive and it does that in bulk.
- 56:59Dan DeLong: And it can be skipped.
- 57:01Dan DeLong: And more importantly, it force, it creates a backup when you do any of these things before sending it over to QuickBooks, right?
- 57:09Dan DeLong: So it'll be in the condition the raw condition of the, company file at that point in time.
- 57:18Dan DeLong: So before you even move it over, you can restore that backup automatically, right?
- 57:24Dan DeLong: So any thoughts on that Sharrin?
- 57:27Dan DeLong: I'm- I know we're gonna- we're coming up on the, top of our hour here.
- 57:31Sharrin Fuller: No, I inactivate like a mother effer, but I, am I, use a lot.
- 57:36Sharrin Fuller: So I When I open up my chart of accounts, I don't like seeing anything active.
- 57:42Sharrin Fuller: I'm, like, I'm a little bit OCD, so my P&Ls are always gorgeous.
- 57:46Sharrin Fuller: So I- Man I bulk inactivate so much.
- 57:50Sharrin Fuller: And no- nothing drives me nuts more than the accounts that they're like,"You can't get ac- inactivate this.
- 57:55Sharrin Fuller: This is required." I'm like,"I don't use it.
- 57:57Sharrin Fuller: Stop leaving inventory in my balance sheet.
- 58:00Sharrin Fuller: We're not an inventory company." ah, stop me...
- 58:03Sharrin Fuller: Ugh.
- 58:03Sharrin Fuller: So there, there are some few things that drive me nuts, but anyhow.
- 58:07Sharrin Fuller: I like this stuff.
- 58:08Sharrin Fuller: I know this stuff.
- 58:10Dan DeLong: Yeah, this is
- 58:11Sharrin Fuller: a welcome- Is there another poll question?
- 58:13Sharrin Fuller: There was, but- There is did we not get
- 58:15Dan DeLong: there?
- 58:15Dan DeLong: There is.
- 58:16Dan DeLong: There
- 58:16Sharrin Fuller: it is.
- 58:16Sharrin Fuller: Yeah.
- 58:16Sharrin Fuller: Somebody asked.
- 58:17Sharrin Fuller: I'll launch it real quick.
- 58:18Sharrin Fuller: Yeah.
- 58:18Dan DeLong: Yeah, you can go ahead and launch the, last poll question, which is- I'll launch it Our usual one.
- 58:24Dan DeLong: Just wanted to talk a little bit about the the Facebook group that we have.
- 58:28Dan DeLong: Oops.
- 58:29Dan DeLong: I'm trying to get to the right one.
- 58:31Dan DeLong: We're threatening 18,000 members in the QB power users group.
- 58:38Dan DeLong: We typically have about 20 posts or questions a day in there.
- 58:42Dan DeLong: And I was just looking at the engagement reports.
- 58:45Dan DeLong: We are about 18 or 8,000 active in a month which is, really cool, so I appreciate all of the people helping people.
- 58:55Dan DeLong: I have- it- it's really cool to see people being able to respond to each other.
- 59:03Dan DeLong: There is an Intuit presence there, but it's not designed as a way to circumvent their normal options, right?
- 59:11Dan DeLong: Because they can't track, and there's we're limited to the Facebook analytics, which is just whatever Mark Zuckerberg makes available for us to do.
- 59:25Dan DeLong: We're not- Which
- 59:25Sharrin Fuller: depends on who's in presidency at the time, on which way he's gonna lean on that.
- 59:29Sharrin Fuller: Ooh, should have muted myself.
- 59:32Dan DeLong: Finger, yeah.
- 59:34Dan DeLong: But we appreciate the people who give back as much as they take when it comes to asking questions and providing help to each other.
- 59:45Dan DeLong: Some of the more common ones that we more popular ones is we're talking about non-Intuit or QuickBooks products or Q- QuickBooks Payroll versus Gusto or ADP, have a, what's the word I'm looking for, Sharrin?
- 1:00:01Dan DeLong: I
- 1:00:01Sharrin Fuller: don't know.
- 1:00:03Dan DeLong: Objective.
- 1:00:04Dan DeLong: There.
- 1:00:04Dan DeLong: There you go.
- 1:00:04Dan DeLong: We have an objective conversation, not slanted one way or the other, because if you go into the forum the, community, the QuickBooks community everyone in all the moderators in there will be slanted one way or the other, right?
- 1:00:19Sharrin Fuller: I'm slanted one way- but it's not, it's-
- 1:00:22Dan DeLong: You're
- 1:00:23Sharrin Fuller: more tilted I'm on the pessimist side.
- 1:00:25Sharrin Fuller: My glass is just a glass.
- 1:00:27Sharrin Fuller: The liquid in it's gonna get drank or thrown out one way or the other, I
- 1:00:31Dan DeLong: used to have a shirt that said, It looked like a glass was half full beverage, and the writing was,"Optimists are half full of
- 1:00:41Sharrin Fuller: it." I'm a realist.
- 1:00:43Sharrin Fuller: It's glass.
- 1:00:44Dan DeLong: That's right.
- 1:00:44Dan DeLong: It's a glass.
- 1:00:47Dan DeLong: Yeah.
- 1:00:47Dan DeLong: So these are some of the more, more popular posts that we've, we have in there.
- 1:00:50Dan DeLong: You can...
- 1:00:51Dan DeLong: Welcome to join the Facebook group if you aren't already.
- 1:00:55Dan DeLong: And and hopefully the search works you're limited to how the search works based in Facebook.
- 1:01:04Dan DeLong: But you won't have to wait too long to, find a, an engaging post to, to comment on.
- 1:01:11Dan DeLong: So we did ask the last poll question.
- 1:01:13Dan DeLong: Good.
- 1:01:15Dan DeLong: And next time on the, QuickBooks Power Hour, we're, are gonna be talking about making bulk edits in QuickBooks.
- 1:01:22Dan DeLong: Do need to register individually, so go ahead and do that now before you forget, because that is the way that I would operate, is I would either do it on the last day or the first day, nowhere in between.
- 1:01:36Dan DeLong: Sharrin, any final thoughts for today?
- 1:01:40Sharrin Fuller: Good job, Dan.
- 1:01:41Sharrin Fuller: Thank- No, I said a lot.
- 1:01:44Sharrin Fuller: I said a lot- Yeah already.
- 1:01:47Dan DeLong: All righty.
- 1:01:48Dan DeLong: Thanks you all for joining us
- 1:01:49Sharrin Fuller: today.
- 1:01:49Sharrin Fuller: I hope I get to see everybody at Firm Growth Forum.
- 1:01:51Sharrin Fuller: How about that?
- 1:01:51Sharrin Fuller: Wait, I have a...
- 1:01:54Sharrin Fuller: I will be doing the...
- 1:01:55Sharrin Fuller: I'll be at Firm Growth, right?
- 1:01:57Sharrin Fuller: No, it's the week after.
- 1:01:58Sharrin Fuller: I was trying to think when I'm on here.
- 1:02:00Sharrin Fuller: So next week's...
- 1:02:00Sharrin Fuller: I'll hopefully see everybody at San Diego for Firm Growth Forum.
- 1:02:05Dan DeLong: There we go.
- 1:02:05Sharrin Fuller: There we go.
- 1:02:05Sharrin Fuller: Sandy's gonna be there, and I saw that James is as well.
- 1:02:10Dan DeLong: All right.
- 1:02:10Dan DeLong: We'll see you in a couple weeks on the QB Power Hour, and hope everybody has a great week, everyone.