Latest / QB Power Hour Podcast / 04.9.24 - RightTool Updates - Importing Journal Entries
Transcript
- 0:30Dan DeLong: Welcome everybody to another QB Power Hour.
- 0:32Dan DeLong: Michelle.
- 0:33Dan DeLong: It's so nice to see you and this is like an annual event we're having here with with mark and and hector like the reunion
- 0:43Michelle Long: Yeah, it's reunion day on power hours.
- 0:46Michelle Long: So it's a fun one today and we got lots of great stuff So i'm very glad to have everybody joining us today after the eclipse So I hope some of you were able to see it and made it home I heard there were some pretty amazing traffic jams getting home You especially on the east coast and stuff.
- 1:01Michelle Long: So hopefully everybody made it home safely.
- 1:05Dan DeLong: Yeah.
- 1:05Dan DeLong: So very interesting.
- 1:06Dan DeLong: Nobody there was no apocalypse.
- 1:08Dan DeLong: So we're, Hector with doing taxes, does that mean that everybody who procrastinated doing their taxes because they were expecting a a cataclysmic event now?
- 1:18Dan DeLong: Yeah.
- 1:19Hector Garcia: The IRS gave us a an extension.
- 1:23Hector Garcia: Just in case they actually put on the website, just in case the world is ending, you actually don't have to file your taxes.
- 1:28Hector Garcia: So, a
- 1:29Michelle Long: little, I'm going to have to get working today.
- 1:34Dan DeLong: All right we're just going to we're going to play a little audible today because we have Hector and Mark joining us and Hector loves to talk.
- 1:42Dan DeLong: And he's got a lot of things to tell us.
- 1:43Dan DeLong: So we're not gonna do our traditional slides and those types of things because we really wanna dive, almost jump right into what's changed in the right tool.
- 1:54Dan DeLong: Tool.
- 1:56Dan DeLong: Is that the way you say it, is the right tool.
- 1:58Dan DeLong: Tool or right tool we say.
- 2:01Dan DeLong: Tool app.
- 2:01Hector Garcia: Tool app, tool app.
- 2:03Mark Corum: Even although it is like DC comics, you say DC Comics even though it's like District Comics.
- 2:09Mark Corum: Comics or something like that.
- 2:12Dan DeLong: or pin number.
- 2:13Dan DeLong: If you haven't joined us before when Mark and Hector had joined us before, we will, we'll be sharing the slides of previous QB power hours and other webinars that we've done with Hector or Mark about the right tool itself.
- 2:26Dan DeLong: But today we really want to talk about.
- 2:29Dan DeLong: Just what's changed in the last year within RightTool, and that's why we wanted to have Mark and Hector come on to talk about it because we really appreciate, I think I think in the general gist of things the what you do, Hector, for the accounting community and what this tool has offered the accounting community besides the I guess the mission is saving precious seconds one click at a time.
- 2:52Dan DeLong: And that's really what you've done to make people or allow people to be more efficient inside of working with QuickBooks online.
- 3:01Dan DeLong: Was that like the catalyst for all of this?
- 3:05Dan DeLong: Because you guys are like the.
- 3:06Dan DeLong: The odd couple of accounting if you, I'm not going to say who's Felix and who's Oscar here, but this is really a unique pairing of the two of you.
- 3:16Hector Garcia: Yeah, I think Mark and I both share the same vision that accountants should concentrate on doing good accounting and not in clicking.
- 3:27Hector Garcia: It to in a million buttons to process one transaction or clicking a hundred things, to be able to reclassify or change the payee on a particular group of transactions.
- 3:38Hector Garcia: And we're going to showcase towards the end of this webinar, like a good it would be a good capstone like course on, on right tool, because there's so many moving parts on the new reallocate tool that we built.
- 3:51Hector Garcia: It encapsulates all the power of what a third party tool can do.
- 3:55Hector Garcia: And only a small scrappy team of developers can build this quickly and efficient versus.
- 4:02Hector Garcia: Waiting for QuickBooks to build it.
- 4:04Hector Garcia: So if you don't mind I'm going to share my screen Mark, I'll let you add any notes that you may have to that.
- 4:11Hector Garcia: We do have a full set of slides.
- 4:13Hector Garcia: So if you share the slides Dan, they can, we just skip the introductions.
- 4:18Hector Garcia: We're going to be covering a couple of things here.
- 4:20Hector Garcia: So first of all, how do you get started with right tool?
- 4:22Hector Garcia: We want to get everybody started.
- 4:24Hector Garcia: At least with a free version, we strongly believe that if you get accustomed to using the free version, you see all the efficiency improvements from the free version.
- 4:33Hector Garcia: And there's tons of efficiency improvements on the free version.
- 4:36Hector Garcia: You will be more likely to upgrade to pro sooner rather than later.
- 4:41Hector Garcia: So you just got to write tool that app forward slash free.
- 4:44Hector Garcia: It will forward you to the Google Chrome extension landing page.
- 4:48Hector Garcia: You just click on add to Chrome is going to work in Google.
- 4:52Hector Garcia: Chrome is going to.
- 4:53Hector Garcia: Work in, in Microsoft Edge is going to be working in other Chromium based browsers, like Brave and other ones that have come out there's so many of them, but it definitely does not work in Firefox.
- 5:07Hector Garcia: It definitely does not work in Safari and it definitely most definitely does not work with the new QBO desktop app.
- 5:14Hector Garcia: Okay.
- 5:14Hector Garcia: So if actually, if QuickBooks wants to make the QuickBooks desktop app open if, I just don't know if it's, if it was built via Chromium, but if they will do want to make it open, we will gladly add a right tool to it right now.
- 5:28Hector Garcia: The QuickBooks desktop app and right tool plus Chrome or right tool plus.
- 5:33Hector Garcia: Microsoft edge is like the competition per se.
- 5:36Hector Garcia: Like we're both battling for that attention because if QuickBooks wants people not to use right tool, they're going to continually drive people to the QBO desktop app.
- 5:45Hector Garcia: I don't know.
- 5:46Hector Garcia: And it's not because they have anything against us is because they would like to control that experience.
- 5:51Hector Garcia: The QuickBooks desktop has added.
- 5:53Hector Garcia: A couple of extra things that makes QBO a little bit more pleasant, but I don't think it's enough to be compared with the power of right tool.
- 6:01Hector Garcia: If you use Google Chrome or Microsoft edge browser.
- 6:05Hector Garcia: So definitely check out the free edition.
- 6:07Hector Garcia: We have over 10, 000 down, I think it's like 16, 000 downloads at this point.
- 6:12Hector Garcia: We have a full YouTube channel with over a hundred videos.
- 6:15Hector Garcia: Explaining what every single feature and right tool does both free and pro.
- 6:19Hector Garcia: And we also do bi monthly bi monthly.
- 6:22Hector Garcia: So every two months, a webinar series, updating our users, both free and pro of all the new things that we're adding.
- 6:29Hector Garcia: And in some cases we'll showcase some beta, something we're like just thinking about.
- 6:33Hector Garcia: And then we get live feedback.
- 6:34Hector Garcia: I would say at this point.
- 6:36Hector Garcia: At the beginning, it was probably 80 percent my input, 20 percent Mark.
- 6:40Hector Garcia: At this point is probably 80 percent our users input.
- 6:45Hector Garcia: And Mark and I have maybe 10 percent each of say or what goes or it doesn't go.
- 6:49Hector Garcia: Our users are telling us what they want.
- 6:51Hector Garcia: And this app is very much crowdsourced.
- 6:54Hector Garcia: So that, that Facebook
- 6:57Dan DeLong: group, that's what, yeah, that's one of the things that I think is well, from just what I've experienced.
- 7:02Dan DeLong: Yeah.
- 7:03Dan DeLong: Just seeing as as the right tool app has grown is the rapid iteration that you guys are able to do, I would see, Hector post, Mark, make this happen.
- 7:14Dan DeLong: And then five minutes later, it
- 7:16Hector Garcia: Not by, Not five minutes, but see that, see, most software companies don't have an idea.
- 7:22Hector Garcia: They'll have a beta and then they'll have a focus group.
- 7:24Hector Garcia: And then they'll try to figure out if it's a good idea or a bad idea.
- 7:27Hector Garcia: In this case, we're seeing live reactions from our users, from the suggestions.
- 7:32Hector Garcia: And sometimes I'll do like a screenshot of a mock up and I go, Hey, would this work and people go, wait, I don't get it.
- 7:38Hector Garcia: Why would the button be on the left or the right?
- 7:40Hector Garcia: So a lot of this stuff is being happening on the fly with the users and the way we interact with the users.
- 7:45Hector Garcia: There's some emails.
- 7:46Hector Garcia: But the most part is the Facebook group.
- 7:48Hector Garcia: So if you haven't joined, first of all, get right tool, if you don't have it, even if it's a free version and then log into the right tool, QuickBooks online users group, because you will tons of ideas.
- 8:01Hector Garcia: Come from there.
- 8:01Hector Garcia: People will post, Hey, I'm having this problem with QuickBooks.
- 8:04Hector Garcia: How would you solve it?
- 8:05Hector Garcia: So it's not even like a right tool question.
- 8:07Hector Garcia: And then it gives Mark and I the opportunity to read it and go, is this something we can solve?
- 8:12Hector Garcia: So a lot of the solutions that we've come up with are based on like questions that weren't even about.
- 8:18Hector Garcia: It was more like I'm having this issue.
- 8:20Hector Garcia: So we're trying as hard as possible to like instantly give instant gratification to our users, especially the pro users about the things that they wish QuickBooks online could do.
- 8:31Hector Garcia: So definitely check that out.
- 8:33Hector Garcia: The link to the group is in the slides the link to the free versions in the slides, the YouTube channel the the link.
- 8:39Hector Garcia: By weekly web, by monthly webinar series.
- 8:42Hector Garcia: And once you decide to go to pro is going to be 50 a month per user or 500 a year if you pay annually.
- 8:49Hector Garcia: And there's no per company per client, that's stuff.
- 8:53Hector Garcia: The most apps do where they charge you per client.
- 8:56Hector Garcia: There's no, no such thing.
- 8:58Hector Garcia: We actually don't connect.
- 8:59Hector Garcia: To the QuickBooks files at all.
- 9:00Hector Garcia: We actually don't even know how many clients you have.
- 9:03Hector Garcia: It's just we don't connect to QuickBooks.
- 9:05Hector Garcia: We work with you in your browser as a power tool, right?
- 9:09Hector Garcia: Like we're just a power tool.
- 9:10Hector Garcia: It's
- 9:10Dan DeLong: like the solar glasses that everybody had to wear yesterday for the eclipse.
- 9:14Dan DeLong: It goes over the top of, yeah.
- 9:17Dan DeLong: Of, of the browser so that you can use QuickBooks safely without burning your retina.
- 9:24Hector Garcia: Dan, you are so good at,
- 9:26Michelle Long: yeah,
- 9:27Hector Garcia: Like that.
- 9:28Hector Garcia: And in the event, and there is a a login or a upgrade button inside right tool, or you can go to right tool pro.
- 9:34Hector Garcia: com forward slash register.
- 9:36Hector Garcia: And you can set up a 14 day free trial risk free for the pro edition.
- 9:40Hector Garcia: If you want to, you don't need to register at all for the free edition.
- 9:45Hector Garcia: And if you have a firm with more than 20 users.
- 9:48Hector Garcia: We can do a custom price.
- 9:49Hector Garcia: Okay.
- 9:50Hector Garcia: Michelle, you want to add something before I jump to the demo?
- 9:53Michelle Long: What's so Hector?
- 9:53Michelle Long: I was just going to say one thing.
- 9:55Michelle Long: First of all, I think it's amazing.
- 9:57Michelle Long: And this is where I think you guys, one of the reasons you already have 16, 000 users or downloads is because you are so responsive to everybody's input and feedback and all of that stuff, that it does save such huge amounts of time when you're working in QuickBooks, do you have any estimates or have people told you.
- 10:16Michelle Long: Gosh, this saves me X amount of hours or estimates.
- 10:19Michelle Long: Do you have any kind of ballpark?
- 10:22Michelle Long: No, people say it's hard to quantify.
- 10:25Hector Garcia: A lot of people say hours.
- 10:27Hector Garcia: We don't have a number we can put in a marketing material, the way like QuickBooks does, which I think many of those things are made up by the way, with different issue, different conversation, but I think what's better is what's better is that people tell us.
- 10:42Hector Garcia: You saved the, you saved me from a whole bunch of frustration.
- 10:46Hector Garcia: Which is a it's more of a qualitative term than a quantitative term.
- 10:50Hector Garcia: So it's and some people are saying with right tool, it makes QuickBooks pleasant again.
- 10:56Hector Garcia: Maybe that could be our political thing we could do.
- 10:59Hector Garcia: There we go.
- 11:00Hector Garcia: Make QuickBooks pleasant again.
- 11:01Hector Garcia: Yeah, so it makes QuickBooks work pleasant again because it takes away Just dreaded clicks and that sort of thing.
- 11:06Hector Garcia: But I, if I had to make a guess, I would say, and I do this based on how many users we have, how many people pay for the tool.
- 11:15Hector Garcia: I would say that if it didn't save you at least two hours a month.
- 11:18Hector Garcia: you wouldn't pay the 50 a month.
- 11:20Hector Garcia: So I would say, I think I'm, I will gladly, I will easily say at least two hours.
- 11:25Hector Garcia: And Mark, I don't know if you have any other opinions on that, but I would say about that.
- 11:29Mark Corum: Yeah.
- 11:29Mark Corum: It's one of those things where it's across the board.
- 11:31Mark Corum: Yeah, some people they're like, Oh yeah, it always saves me like, a few minutes here and there, but I'm, so glad that it exists.
- 11:37Mark Corum: But then there are some people who are like, Oh yeah, I used batch enter or something like that, especially the people who like batch entering things oftentimes will tell me it's like, Oh yeah, save me like 10 hours of work this month.
- 11:49Mark Corum: So it is really across the board depending on how you use it.
- 11:54Hector Garcia: Yeah.
- 11:54Hector Garcia: And some people are saying, Hey, I'm so glad I didn't have to buy Sassant or transaction pro for this one specific task.
- 12:03Hector Garcia: So we're not a full replacement for Sassant or Transaction Pro at all.
- 12:06Hector Garcia: We're not even close to that, but the most common thing, like importing journal entries is something that we solved early on, which is a good transition to make.
- 12:15Hector Garcia: So I'm very happy to announce that not related to right tool at all, QuickBooks has finally started bringing in journal entry imports into QuickBooks online natively.
- 12:28Hector Garcia: So no need for a third party app.
- 12:29Hector Garcia: Okay.
- 12:30Hector Garcia: Like half of my clients files have it.
- 12:33Hector Garcia: And two weeks ago, only two of my clients files had it.
- 12:36Hector Garcia: So it looks like they're going to be done facing this thing in very soon, and I'm going to showcase how this works.
- 12:43Hector Garcia: So we're going to talk about the built in journal entry tool inside QuickBooks on journal entry import inside QuickBooks online.
- 12:50Hector Garcia: I'm calling it a beta.
- 12:52Hector Garcia: They are not calling it a beta, but I'm calling it a beta just because it just came out.
- 12:56Hector Garcia: And generally you can't really get QuickBooks credit for not calling.
- 13:01Hector Garcia: The first iterations of their things.
- 13:03Hector Garcia: Not a beta because most of the times they are betas, but it's worked pretty well.
- 13:07Hector Garcia: So if you actually know the direct URL, you can just paste it in there and it will open up the journal entry for you.
- 13:13Hector Garcia: As I mentioned earlier in the slides, you go into the slides, there's the journal entry the direct URL, if you want to copy and paste that, add it to your favorites, whatever it happens to be and also worth mentioning.
- 13:25Hector Garcia: You can get to it if it's enabled in your file.
- 13:28Hector Garcia: You can click on the gear menu top right of the screen.
- 13:31Hector Garcia: And then you can click on where it says import data.
- 13:33Hector Garcia: And then there should be a new icon under import data called journal entry.
- 13:38Hector Garcia: So again, this is built into QuickBooks online.
- 13:39Hector Garcia: You don't need a third party app.
- 13:41Hector Garcia: We just need to make sure that all of our, all of the files have it.
- 13:44Hector Garcia: Okay.
- 13:44Hector Garcia: All versions.
- 13:45Hector Garcia: We're talking about simple start plus essentials.
- 13:47Hector Garcia: Like I, as far as I know, This is a new feature that works across the board, all QuickBooks files.
- 13:52Hector Garcia: Thank God they didn't just add it to advance because that would have made me strangle somebody.
- 13:56Hector Garcia: That would
- 13:58Dan DeLong: go under the Hector bunkers.
- 14:00Hector Garcia: That would drive me flipping bunkers.
- 14:02Hector Garcia: Correct.
- 14:03Hector Garcia: So what's really cool about this page is you get this download import guide, which is a PDF.
- 14:08Hector Garcia: It's like a little cheat sheet.
- 14:09Hector Garcia: I think it's awesome.
- 14:09Hector Garcia: Especially if you're training someone.
- 14:11Hector Garcia: On this tool, it gives you a really good visual letting Hey, this is what all the fields that can be imported into.
- 14:17Hector Garcia: And then it makes it very obvious for you to know how you can map your existing spreadsheet to that.
- 14:23Hector Garcia: Okay, so this is what what it looks like now.
- 14:25Hector Garcia: So this would be like a reference guide you would print out or something like that.
- 14:28Hector Garcia: The other really cool thing that it does is.
- 14:30Hector Garcia: It allows you to download a sample CSV.
- 14:32Hector Garcia: The sample CSV is it could be open in Excel, just a normal spreadsheet file.
- 14:37Hector Garcia: There's a couple of particularities on this sample CSV.
- 14:40Hector Garcia: Let me zoom in so you can see a little bit better.
- 14:42Hector Garcia: Particularity number one worth mentioning is there, there are asterisks on each of the fields that are required.
- 14:50Hector Garcia: So the only required fields are journal entry number, journal entry date.
- 14:54Hector Garcia: And the account name.
- 14:56Hector Garcia: Okay, debits and credits are not required, but it would be useless to have a journal entry without them, but they're technically not required because they don't have an asterisk on them.
- 15:04Hector Garcia: The other thing is worth mentioning is there is a tax code column in it.
- 15:08Hector Garcia: This is because they're porting this over from the UK and Canada, because you can Canada both had this feature for nine years.
- 15:16Hector Garcia: So this is what I mean by beta.
- 15:17Hector Garcia: It means that they like half implement something and then they, somebody goes on vacation and they forget.
- 15:23Hector Garcia: That the tax code is irrelevant for the U.
- 15:25Hector Garcia: S.
- 15:25Hector Garcia: So the template itself has this and then there's some notes about that codes.
- 15:29Hector Garcia: Of course, this is very obvious that they took the kind of copy and paste the U.
- 15:32Hector Garcia: K.
- 15:32Hector Garcia: Code, put it in the U.
- 15:33Hector Garcia: S.
- 15:33Hector Garcia: And started releasing it to the users.
- 15:36Hector Garcia: So you're going to delete this extra data.
- 15:40Hector Garcia: That's in here.
- 15:40Hector Garcia: Cause you actually don't need that.
- 15:42Hector Garcia: So you just delete that extra data and you delete the tax code cause you're not going to use the tax code.
- 15:48Hector Garcia: Of course, at some point, hopefully in the near future they'll fix this.
- 15:51Hector Garcia: And then it will make this conversation obsolete.
- 15:55Hector Garcia: I would very much like that.
- 15:56Hector Garcia: But for now.
- 15:58Hector Garcia: Just giving you some usefulness on this thing.
- 16:01Hector Garcia: The second, particularly on the built in template, is that the journal entry date is pre formatted with the UK format.
- 16:09Hector Garcia: Okay, so don't ask, again, why did they do this?
- 16:12Hector Garcia: Quickbooks, please.
- 16:13Hector Garcia: It's so easy to do the right thing.
- 16:15Hector Garcia: But I don't know, you get tempted to just, I will say all these things.
- 16:19Mark Corum: Yeah.
- 16:19Mark Corum: As a developer, I do get the date thing.
- 16:23Mark Corum: It is the most annoying thing on the face of the plate.
- 16:28Mark Corum: So
- 16:28Hector Garcia: Hopefully they're fixing this as we speak.
- 16:30Hector Garcia: And, or maybe there's different versions out there.
- 16:32Hector Garcia: Like mine does that, but somebody else's won't who the heck knows.
- 16:36Hector Garcia: So you want to make sure that you have the dating correct or that you, when you do the mapping, you do the correct.
- 16:41Hector Garcia: A format.
- 16:42Hector Garcia: The date is not required on on rows two and below for every journal entry.
- 16:48Hector Garcia: So you can leave a blank.
- 16:49Hector Garcia: You could also have a date there, but keep in mind that it actually ignores it.
- 16:53Hector Garcia: Okay.
- 16:54Hector Garcia: So you could keep, you could leave a blank or you can put it across.
- 16:57Hector Garcia: What you can't skip is the journal entry number.
- 17:01Hector Garcia: The way QuickBooks knows that every line belongs to the same journal entry is if they have the same number.
- 17:08Hector Garcia: So having the same number is how you tell it.
- 17:11Hector Garcia: Especially especially if you have multiple journal entries per entry, you could just import a single one.
- 17:17Hector Garcia: But you can also import multiple.
- 17:19Hector Garcia: Now there's no limit on how many journal entries you can import, but there's a total of 1000 lines that you can import.
- 17:27Hector Garcia: That was, so then technically there would be a limit of 500 journal entries with two lines.
- 17:32Hector Garcia: Sorry.
- 17:32Hector Garcia: Yeah.
- 17:32Hector Garcia: So there is a mathematical limit.
- 17:34Hector Garcia: So the mathematical limit is a thousand lines, which.
- 17:36Hector Garcia: If you only had, two lines per journal entry, which is the minimum, then you would have 500 journal entries total.
- 17:41Hector Garcia: But the 500, the 1000 lines is the true entry.
- 17:45Hector Garcia: Then you have an account number.
- 17:46Hector Garcia: You can either put the account number by itself, or you can put the account the account name by itself.
- 17:56Hector Garcia: The whole thing goes haywire when there's both account names and account numbers.
- 18:01Hector Garcia: This is something that's just difficult to manage because QuickBooks Online is very inconsistent on how they do account numbering systems, especially with subaccounts.
- 18:11Hector Garcia: Mark is shaking his head because for other tools we've had to manipulate this whole account number issue.
- 18:18Hector Garcia: So that's really all you need to know.
- 18:20Hector Garcia: The thing that I dislike About the sample is a sample.
- 18:24Hector Garcia: Those things give you like your own account number or your own classes or your own locations.
- 18:29Hector Garcia: It just gives you a random data.
- 18:30Hector Garcia: So I couldn't import the sample, which is different than the balance sheet sample because in QuickBooks online, sorry, not a balance sheet, the budget.
- 18:39Hector Garcia: If you export a budget example, template.
- 18:42Hector Garcia: It gives you your actual data.
- 18:44Hector Garcia: So this, so it would be interesting if QuickBooks were able to dynamically just grab random accounts and random classes and random names and put them in there so that your entry looks like something like it's your data, but for now, this is just a template you can look at and use as a, as a guiding principle.
- 19:02Hector Garcia: To build your own journal entry.
- 19:03Hector Garcia: So that being said, I'm going to go ahead and delete all this data.
- 19:07Hector Garcia: Okay.
- 19:07Hector Garcia: And then I'm going to use current data from my QuickBooks file to build the journal entry in Excel, to use it as a sort of starting point for building the journal entry prior to bringing it into QuickBooks.
- 19:20Hector Garcia: Okay.
- 19:20Hector Garcia: So let's say I'm just going to grab a couple of accounts here at random.
- 19:24Hector Garcia: Okay.
- 19:24Hector Garcia: I'm going to grab a couple of accounts.
- 19:26Hector Garcia: We'll do some with sub accounts, some without.
- 19:30Hector Garcia: Okay, and I'm just going to ask you to like, imagine the journal entry being a lot longer.
- 19:35Hector Garcia: So it makes sense why we would use import instead of just typing it manually.
- 19:40Hector Garcia: Okay.
- 19:40Hector Garcia: There's tons of there'll be tons of reasons why somebody would prefer to bring it via import instead of manually mostly just trying to generally just avoid errors.
- 19:50Hector Garcia: as a whole.
- 19:51Hector Garcia: So that could be, one of the reasons, but there there's so many.
- 19:54Hector Garcia: So just imagine this is the journal entry we were trying to import.
- 19:57Hector Garcia: So I'll just copy this information over.
- 20:00Hector Garcia: So I'm going to start with journal entry number.
- 20:02Hector Garcia: I'm going to call this HG 040924.
- 20:08Hector Garcia: And then I'm going to copy and paste this journal entry number down across the six lines that I want to have for the same journal entry for the date.
- 20:17Hector Garcia: I'll put today's date.
- 20:20Hector Garcia: Okay.
- 20:20Hector Garcia: And I'll copy this down.
- 20:22Hector Garcia: I don't click and drag because it's a, it'll change them for me.
- 20:25Hector Garcia: Like I said, you can have them in there or you can just have it on the very first line.
- 20:29Hector Garcia: Then the account name, this is where I'm going to bring the information that's in here.
- 20:33Hector Garcia: So this one is savings.
- 20:35Hector Garcia: This one is automobile.
- 20:38Hector Garcia: This one is job expenses.
- 20:42Hector Garcia: Okay.
- 20:42Hector Garcia: Pop quiz.
- 20:44Hector Garcia: What would be a faster way for me to get those accounts?
- 20:47Hector Garcia: Names into the spreadsheet,
- 20:52Dan DeLong: something in the right tool,
- 20:53Hector Garcia: but without right tool, without right to
- 20:58Dan DeLong: export the.
- 21:00Dan DeLong: The report or the journal entry.
- 21:02Hector Garcia: Exactly.
- 21:03Hector Garcia: So I would go into a transaction journal.
- 21:06Hector Garcia: Yeah.
- 21:06Hector Garcia: Transaction journal.
- 21:07Hector Garcia: If the, if it already exists, you got it.
- 21:10Hector Garcia: Yeah, exactly.
- 21:13Hector Garcia: So you would export this transaction journal, whether it's the old, the new reports or the classic reports, export this to a CSV or to an Excel.
- 21:22Hector Garcia: And then just use the data that's already in there and paste it.
- 21:25Hector Garcia: Now, I'm going to go ahead and let me just zoom this in for a second.
- 21:29Hector Garcia: I'm going to go ahead and bring it in this way with the account numbers, just so we can see if there's any weird sort of interaction with this with the account numbers.
- 21:39Hector Garcia: So I'm just going to paste that in there including the account numbers.
- 21:42Hector Garcia: And then again, if we have any issues with the account numbers, Being in there we'll play with it.
- 21:47Hector Garcia: It'll be nice for us to have that information handy.
- 21:50Hector Garcia: Okay.
- 21:51Hector Garcia: So I'm going to put 500, 500, 500, and then.
- 21:57Hector Garcia: 2 50, 2 50 and 1000.
- 22:01Hector Garcia: Okay.
- 22:01Hector Garcia: Alright, so again the date format, I'm using the actual American date format.
- 22:06Hector Garcia: What I was telling you is the template comes in, in, in weird European format, and I call it weird, where the rest of the world calls us weird, but a different issue.
- 22:15Hector Garcia: But in the European format, you could put it there on your normal format.
- 22:19Hector Garcia: And then just when you map it, you just tell it which format you're using.
- 22:22Mark Corum: And I think Michael McClellan said that his version does have the actual normal United normal United States format.
- 22:30Mark Corum: Yeah, exactly.
- 22:31Mark Corum: So it might be depending on what your sample ends up being.
- 22:36Mark Corum: You probably want to adjust for whatever that is.
- 22:39Mark Corum: It
- 22:39Hector Garcia: could just be classic, QuickBooks having, Different versions of QuickBooks for different people type of thing.
- 22:46Hector Garcia: Okay.
- 22:46Hector Garcia: So I'm going to put in my customer information.
- 22:49Hector Garcia: And same thing if you want to bring class and locations let's just do here the new construction class.
- 22:56Hector Garcia: So we'll copy this over and bring that over here.
- 23:00Hector Garcia: Okay, so you can also delete any columns you're not using.
- 23:03Hector Garcia: So if you're not using location, you can delete that.
- 23:06Hector Garcia: You don't have to have data that you're not going to import.
- 23:09Hector Garcia: And essentially, this is what your template would look like.
- 23:12Hector Garcia: Take a picture with your phone.
- 23:13Hector Garcia: Okay.
- 23:14Hector Garcia: And then once you have it all ready in here, okay, and notice that there's a master memo line and a description line.
- 23:21Hector Garcia: This is interesting.
- 23:22Hector Garcia: So the description would be each of the lines of the journal entry, and the memo would just be the memo at the very bottom.
- 23:29Hector Garcia: Which is this guy over here, the bottom memo.
- 23:31Hector Garcia: So you actually, memo is one of those things that you also don't need to repeat across multiple lines.
- 23:36Hector Garcia: So this would be bottom memo, something like that.
- 23:40Hector Garcia: And just like the dates, you actually don't need to have the dates pass the very first line.
- 23:46Hector Garcia: So the memo column and the journal entry are the two that you only need to have the first line set up.
- 23:52Hector Garcia: Okay.
- 23:53Hector Garcia: So now that we have our journal in here, we have to save it as a PDF.
- 23:58Hector Garcia: Sorry, did I say PDF?
- 23:59Hector Garcia: I'm crazy.
- 24:00Hector Garcia: You did.
- 24:00Hector Garcia: You have to save it.
- 24:01Dan DeLong: Like what?
- 24:02Hector Garcia: Yeah.
- 24:02Hector Garcia: Yeah.
- 24:03Hector Garcia: You have to save it as a CSV.
- 24:05Hector Garcia: Okay.
- 24:05Hector Garcia: I knew it was three letters, but I got the three letters wrong.
- 24:08Hector Garcia: So you have to save it as a CSV.
- 24:10Hector Garcia: I don't even close.
- 24:11Hector Garcia: Yeah, I, yeah, but I got the number of letters, right?
- 24:14Hector Garcia: So we're going to click on the gear menu, go to import data and then go to journal entries.
- 24:19Hector Garcia: And then we're going to click on browse and we're going to go find that that journal, and of course I don't remember where I put the journal.
- 24:25Hector Garcia: So let me put it in the desktop, save this again, put this in the desktop, save.
- 24:32Hector Garcia: Okay.
- 24:33Hector Garcia: And then come back into QuickBooks.
- 24:35Hector Garcia: Pick my desktop.
- 24:36Hector Garcia: There's my journal that when I click on next is going to ask me to to map it.
- 24:41Hector Garcia: Now what's nice about this is because I used the headers from the template, then I don't have to remap it.
- 24:47Hector Garcia: So if you have your own spreadsheet that didn't use that, you have to come in here and make sure you match this up.
- 24:52Hector Garcia: So which is my journal entry number, which is my date.
- 24:54Hector Garcia: But of course, I already had the headers in my template.
- 24:56Hector Garcia: That's the advantage of using the template as the baseline.
- 24:59Hector Garcia: And here is the The formatting for the date.
- 25:03Hector Garcia: So if you happen to be using none weird, just different European dating style you can just pick pick those here.
- 25:10Hector Garcia: Okay.
- 25:11Hector Garcia: So then we're going to go to next.
- 25:13Hector Garcia: And then, of course.
- 25:15Hector Garcia: QuickBooks, the actual export of the account name, exactly as they've chosen the reports is not acceptable in the import.
- 25:22Hector Garcia: Okay.
- 25:22Hector Garcia: Again, because QuickBooks, it's just such a, okay.
- 25:26Hector Garcia: That's
- 25:26Dan DeLong: as the kids say, womp today.
- 25:28Hector Garcia: Yeah.
- 25:28Hector Garcia: So a couple of so the solution for this.
- 25:31Hector Garcia: It's going to be either just removing account numbers all together or just using the names without the account number.
- 25:39Hector Garcia: So I'm going to go in, actually, I'm going to just delete all the account numbers here.
- 25:46Hector Garcia: So I'm deleting all the account numbers and notice I'm deleting them both from the from the beginning of the account.
- 25:53Hector Garcia: Name and also from every sub account.
- 25:57Hector Garcia: And I know some people are saying Hector, at this point, I would have just written 20 journal entries by hand by now.
- 26:03Hector Garcia: Yeah, I understand.
- 26:04Hector Garcia: But sometimes we have reallocation journal entries.
- 26:06Hector Garcia: We have a payroll job costing journal entries.
- 26:09Hector Garcia: You may have all sorts of like long and complex journal entries that we were already getting this data from third party apps, and hopefully they're bringing you clean accounts and clean data.
- 26:20Hector Garcia: Customer names and that sort of thing.
- 26:22Hector Garcia: So we're going to save this as we'll do journal entry number two.
- 26:26Hector Garcia: And exactly what I did just to recap, what I did was I removed all the account numbers, and also I removed the spaces.
- 26:33Hector Garcia: Between the columns and the accounts.
- 26:35Hector Garcia: Just remember that sometimes those are hard to remember.
- 26:38Hector Garcia: Sometimes as you're cleaning up, you'll forget to delete those spaces.
- 26:41Hector Garcia: I know Mark and I have gone through our fair share of growing pains.
- 26:45Hector Garcia: With that, with importing and that sort of thing.
- 26:47Hector Garcia: Okay.
- 26:47Hector Garcia: So we'll go back here, bring the new journal entry in, click on next.
- 26:53Hector Garcia: Let's go to next.
- 26:54Hector Garcia: And now it says the accounts don't exist.
- 26:59Hector Garcia: Why are you being such a weirdo quick folks?
- 27:02Hector Garcia: Okay, let's try doing the following.
- 27:06Hector Garcia: It's all of them,
- 27:06Dan DeLong: so it's not the fact that they're sub accounts.
- 27:09Hector Garcia: Yeah, you'll see.
- 27:10Hector Garcia: I'm going to go to the gear menu and go to account and settings.
- 27:13Hector Garcia: I'm going to go into advanced and then I'm going to go into account numbers and disable them.
- 27:20Hector Garcia: Okay, now that's not going to delete them from your database, thank God.
- 27:23Hector Garcia: But Just hiding them.
- 27:24Hector Garcia: Okay.
- 27:25Hector Garcia: I don't know where I read somewhere.
- 27:26Hector Garcia: It's actually not here, but it's in a link somewhere where they're suggesting to turn off account numbers.
- 27:33Hector Garcia: Again, we mentioned at the beginning account numbers are going to throw you off in this whole thing.
- 27:37Hector Garcia: So we'll go to next and okay.
- 27:41Hector Garcia: Let's see, let's try this again.
- 27:43Hector Garcia: Let's go browse.
- 27:45Hector Garcia: Journal number two.
- 27:47Hector Garcia: Next.
- 27:48Hector Garcia: Let's go to next.
- 27:50Hector Garcia: And why are these accounts, why are they telling me these accounts don't exist?
- 27:59Hector Garcia: All right, I'll try one more thing here.
- 28:01Hector Garcia: We're gonna go back and let's go to Somebody's saying, Hey, you just turned off account numbers.
- 28:09Hector Garcia: Maybe you should do like a whole refresh of QuickBooks.
- 28:12Hector Garcia: That's a good idea.
- 28:13Hector Garcia: Should I log out, log back in?
- 28:15Hector Garcia: Let's just see really quick.
- 28:16Hector Garcia: This
- 28:17Dan DeLong: is an interesting development.
- 28:19Dan DeLong: Hector stumped himself.
- 28:21Hector Garcia: Yeah, the account numbers showing here.
- 28:23Hector Garcia: The immovable
- 28:23Dan DeLong: object and unstoppable force have collided.
- 28:27Hector Garcia: And we got so I'm going to do, I'm going to do something that's even more Quirky which which which is probably going to work.
- 28:34Hector Garcia: And let me turn.
- 28:36Hector Garcia: Okay.
- 28:36Hector Garcia: So I didn't fully turn off the account numbers.
- 28:38Hector Garcia: Give me a sec.
- 28:38Hector Garcia: Say you and Hector Garcia are working on this at the same time.
- 28:42Hector Garcia: This is my alter ego,
- 28:46Dan DeLong: your
- 28:46Hector Garcia: evil twin.
- 28:46Hector Garcia: I love it.
- 28:48Hector Garcia: Okay.
- 28:48Hector Garcia: Let me,
- 28:49Dan DeLong: that's Hector with the goatee.
- 28:51Hector Garcia: I'm going to log out for a second.
- 28:53Hector Garcia: Log back in.
- 28:54Hector Garcia: Okay.
- 28:54Hector Garcia: QuickBooks went haywire with me changing account numbers.
- 28:57Hector Garcia: Okay.
- 28:58Hector Garcia: So I'll log back in because they're trying
- 28:59Dan DeLong: to fix it while you're talking, of course
- 29:01Hector Garcia: They noticed me criticizing it at the very beginning and they're like, okay, of course.
- 29:05Hector Garcia: Hector, the royalty, let's fix it for him.
- 29:08Hector Garcia: Sure.
- 29:10Hector Garcia: In my dreams.
- 29:11Hector Garcia: That's what I do
- 29:12Mark Corum: when we're on these webinars.
- 29:13Hector Garcia: Okay.
- 29:14Hector Garcia: Let's see.
- 29:16Hector Garcia: All right.
- 29:17Hector Garcia: Okay.
- 29:17Hector Garcia: So now officially it's turned off.
- 29:18Hector Garcia: So that could have been part of the issue.
- 29:20Hector Garcia: It didn't fully refresh turning off the account numbers.
- 29:23Hector Garcia: I think this should work now.
- 29:25Hector Garcia: Let's see.
- 29:25Hector Garcia: And by the way, this should work now.
- 29:27Hector Garcia: It's my new slogan.
- 29:28Hector Garcia: I'm getting a shirt done.
- 29:30Hector Garcia: We're going to sell them in conferences.
- 29:32Hector Garcia: They're going to sell out.
- 29:33Hector Garcia: All right, there you go.
- 29:34Hector Garcia: So finally imported.
- 29:35Hector Garcia: So by the way, so let's just backtrack for a second.
- 29:38Hector Garcia: You want to turn off the account numbers.
- 29:40Hector Garcia: And you want to fix the chart of accounts.
- 29:42Hector Garcia: So the accounts, so they don't contain the numbers.
- 29:45Hector Garcia: That's going to be the easiest way to go about it.
- 29:48Hector Garcia: I just happen to have not fully saved or wait for it to refresh and recognize account numbers disappear.
- 29:54Hector Garcia: So I click on complete import.
- 29:55Hector Garcia: It does this thing.
- 29:57Hector Garcia: You can click on the link.
- 29:58Hector Garcia: And then it sends you for some reason, it sends you to some sort of report, okay, that's useless.
- 30:05Hector Garcia: So we're just going to click on the recent transactions button and go into journal.
- 30:09Dan DeLong: I bet in the international versions it actually would take you somewhere.
- 30:13Hector Garcia: Yeah.
- 30:13Hector Garcia: Yeah.
- 30:13Hector Garcia: Again it, it should work.
- 30:15Hector Garcia: That's sure.
- 30:16Hector Garcia: It's going to catch on.
- 30:16Hector Garcia: It's going to be, it should work this time.
- 30:19Hector Garcia: Okay.
- 30:19Hector Garcia: So here's the journal entry.
- 30:20Hector Garcia: See how about now?
- 30:22Hector Garcia: It's actually wonderful.
- 30:23Hector Garcia: It's a great, beautiful thing.
- 30:25Hector Garcia: Might be worth live troubleshooting this.
- 30:27Hector Garcia: Did I put classes across all lines?
- 30:29Hector Garcia: I did not.
- 30:30Hector Garcia: Okay.
- 30:30Hector Garcia: So it was just my journal entry.
- 30:32Hector Garcia: Didn't contain class across all lines.
- 30:34Hector Garcia: It actually did exactly what we wanted to do.
- 30:37Hector Garcia: There is new journal entry import.
- 30:40Hector Garcia: It actually works really well.
- 30:41Hector Garcia: My opinion, I think I think.
- 30:44Hector Garcia: It's 95 percent there.
- 30:46Hector Garcia: I think some clarity around the templates and around the account numbers would be helpful.
- 30:51Hector Garcia: One thing I do want to add and this might be to my detriment because there will be some element of winging it in the process here.
- 30:59Hector Garcia: I'm going to save and open the accounts, the account numbers one more time.
- 31:03Hector Garcia: I'm going to click on chart of accounts.
- 31:05Hector Garcia: Let me hit refresh, make sure that chart of accounts comes in, hit refresh one more time.
- 31:10Hector Garcia: And again, I might have to log out.
- 31:12Hector Garcia: Log back in.
- 31:14Hector Garcia: Let's do a heart refresh.
- 31:17Hector Garcia: Okay.
- 31:17Hector Garcia: No.
- 31:17Hector Garcia: Okay.
- 31:18Hector Garcia: Note to self, if you ever turn off and turn on a chart account numbers, log out of QuickBooks, log back in.
- 31:23Hector Garcia: Cause for some reason it doesn't work quite immediately.
- 31:27Hector Garcia: Okay.
- 31:27Hector Garcia: So let's log back in and we're going to try one more thing.
- 31:29Hector Garcia: And this is mostly for the sake of just like live troubleshooting, how you can manage this chart of accounts.
- 31:37Hector Garcia: chart of account numbers situation.
- 31:40Hector Garcia: I'm going to show you one thing that kind of worked for us.
- 31:42Hector Garcia: So I'm going to show you live on the screen on that.
- 31:47Hector Garcia: Okay.
- 31:48Hector Garcia: So we're going to try, we're going to try two options here.
- 31:50Hector Garcia: So option number one, and let me open up the other journal entry that I had.
- 31:57Hector Garcia: Here we go.
- 31:58Hector Garcia: Okay.
- 31:59Hector Garcia: Let's accept the one that didn't have the numbers.
- 32:01Hector Garcia: Let's zoom in and see the whole thing.
- 32:05Hector Garcia: So option number one, I am going to try only removing the accounts.
- 32:12Hector Garcia: From the ones that count numbers from the one that have sub accounts, but it's going to be even weirder.
- 32:19Hector Garcia: I'm going to replace the number at the very beginning with the one that was the sub account.
- 32:24Hector Garcia: Dan, can you follow that?
- 32:25Hector Garcia: Because if you can't, that means I didn't explain it correctly.
- 32:29Dan DeLong: Yes, you're going to take 54 to 520 and put it in the front of job expense.
- 32:34Hector Garcia: Exactly.
- 32:35Hector Garcia: And by the way, when
- 32:36Dan DeLong: I was tracking,
- 32:37Hector Garcia: when somebody had into it, Was thinking about this saying, this is a great solution for users, by the way.
- 32:44Hector Garcia: This is awesome.
- 32:45Hector Garcia: I'm sure a lot of our users are going to love going back and copying and pasting the account number from the front to the back.
- 32:53Hector Garcia: Can you imagine what they were smoking when that happened?
- 32:55Hector Garcia: When they actually, they all shake their hands together and I said, this is a good idea.
- 32:59Hector Garcia: All right.
- 33:00Hector Garcia: Anyway, so I'll import this one to 410 and then I'm going to save.
- 33:04Hector Garcia: So this is the first attempt that we're going to try.
- 33:06Hector Garcia: We're going to use the lowest level account number all the way in the top and then erase after the one account number, the accounts afterwards.
- 33:16Hector Garcia: And and um, Mark prevent me from a catastrophe if I forgot something in the process or was my logic right from the product, from the beginning.
- 33:25Mark Corum: I'm not going to lie to you.
- 33:26Mark Corum: I was answering a question in the problem.
- 33:31Hector Garcia: All right, so there it is.
- 33:31Hector Garcia: There's a so there's a demonstration of how that works So quickbooks will allow me to use account numbers If again, only the lowest level account number is used at the very beginning and then we'll try one more thing Which actually I have not tested So you still
- 33:47Dan DeLong: need to use the hierarchy of the parent sub or could you just that's what
- 33:53Hector Garcia: i'm about That's about the show.
- 33:54Hector Garcia: So instead of having any accounts i'm just going to show You I'm just going to do account number.
- 34:00Hector Garcia: That makes sense.
- 34:01Hector Garcia: So only account number.
- 34:03Hector Garcia: We'll see if that one goes through that one.
- 34:06Hector Garcia: I, to be honest with you, I have not tested this one, but my spider senses tell me that this should work, but let's give that a shot.
- 34:14Hector Garcia: Let's save that.
- 34:16Hector Garcia: And let's go back into journal entry, browse, and let's try just journal and just account numbers and go to next.
- 34:25Hector Garcia: Okay.
- 34:26Hector Garcia: There's the conclusion, folks.
- 34:27Hector Garcia: You have to either turn off your account numbers completely and remove account numbers from the hierarchy of your template, or turn on account numbers and use that weird.
- 34:39Hector Garcia: Workaround where you have to use the actual last last last account or lowest hierarchy account as the account number, and then erase it from the rest of the path.
- 34:51Hector Garcia: Okay.
- 34:52Hector Garcia: So any any thoughts or conclusions or a sense of amazement on how well designed this tool is?
- 35:00Dan DeLong: Oh boy.
- 35:01Mark Corum: Honestly, Every time I look at QuickBooks, I honest to God think, Man, I wish I could live up to this.
- 35:10Mark Corum: And actually, you know what's funny?
- 35:11Mark Corum: I do very much actually have very much respect for the people who develop QuickBooks.
- 35:17Mark Corum: QuickBooks.
- 35:18Mark Corum: Now admittedly, I like their old system a little bit better for QuickBooks Online rather than their new system for things, but that's just a me thing personally.
- 35:30Hector Garcia: Yeah, I think the good thing is there's actually more and more Intuit employees watching webinars, Facebook groups, this type of things.
- 35:39Hector Garcia: So this is An amazing passive aggressive way to give feedback where we just show people how frustrating it is in public and they go, yeah, you know why we should fix it.
- 35:48Hector Garcia: So I guarantee you somebody will watch this and they'll come up with a solution for this.
- 35:53Hector Garcia: So in about two to three decades, you will see an update and you'll see this issue.
- 35:59Hector Garcia: All right.
- 36:00Hector Garcia: So let's move on to let's move on.
- 36:02Hector Garcia: That was passive aggressive
- 36:03Dan DeLong: too.
- 36:03Hector Garcia: All right.
- 36:06Hector Garcia: So we're going to move on to the solutions that we have built with right tool.
- 36:11Hector Garcia: There's actually two sets worth discussing.
- 36:14Hector Garcia: One is the free features in right tool that are related to journal entries.
- 36:18Hector Garcia: We're going to be focused on journal entries, a hundred percent.
- 36:20Hector Garcia: And then there's going to be three features, three pro features related to journal entry.
- 36:25Hector Garcia: So we're going to turn on journal entry, print.
- 36:28Hector Garcia: Export journal entry to CSV, journal entry balance visual, and show journal entry normal balances.
- 36:35Hector Garcia: Now I believe one of these two was was Mark's baby this was developed maybe two or three years ago.
- 36:41Hector Garcia: Was that the journal entry balance visual or the normal balances, correct?
- 36:45Mark Corum: The normal balances as well as the journal entry print, but mostly the normal balances.
- 36:51Mark Corum: The print was just more of some people asked for it, and I was like, you know what, I'll do it.
- 36:54Mark Corum: And that was before we started working on WriteTool.
- 36:57Mark Corum: Exactly.
- 36:57Hector Garcia: So let's talk about those.
- 36:59Hector Garcia: So two, two actually were brought in from Mark's already pre developed idea.
- 37:04Hector Garcia: And then two were added in the process of Of right tool existing.
- 37:07Hector Garcia: Let's call it that.
- 37:08Hector Garcia: Okay.
- 37:09Hector Garcia: So once right tool is turned on and again, these are free, these are available in the free version.
- 37:13Hector Garcia: You don't have to pay anything.
- 37:14Hector Garcia: You're going to click on that little toolbox icon.
- 37:17Hector Garcia: I don't even know what to call that wrench and what's the best way to call that?
- 37:21Hector Garcia: Wrench and screwdriver tool.
- 37:22Hector Garcia: Yeah.
- 37:23Hector Garcia: Yeah.
- 37:23Hector Garcia: The wrench.
- 37:25Hector Garcia: The wrench and screwdriver icon.
- 37:27Hector Garcia: Sorry, my screen got zoomed in and I forgot how to zoom it out.
- 37:31Hector Garcia: We're cyber workers, not physical workers.
- 37:36Hector Garcia: Hold on a second.
- 37:40Hector Garcia: Okay, talk amongst yourself, my Mac went crazy.
- 37:43Michelle Long: I was just posting on here.
- 37:46Michelle Long: I love that it didn't work right the first time.
- 37:48Michelle Long: Because when you're importing, I don't think it ever does, or it very rarely does.
- 37:52Michelle Long: So I love how, you see the troubleshooting.
- 37:55Michelle Long: Let me try this.
- 37:56Michelle Long: Let me try that.
- 37:56Michelle Long: Let's try this.
- 37:58Michelle Long: Because a lot of times when you're importing data, it does not work right the first time.
- 38:03Michelle Long: And you do have to troubleshoot until you get it correct, and so that is the process with importing data a lot of times.
- 38:09Michelle Long: And I think that was a good learning process to try different things and Don't just give up and somebody says oh, why are you going through all this for one journal entry?
- 38:19Michelle Long: Usually if you're importing journal entries, you're not just importing one journal entry like hector said you're importing payroll You're going to be importing payroll journal entries all year long, you know So yes, you may have to troubleshoot the first time but once you get the format figured out and you get it You know troubleshoot and figure it out Then the rest of the year, you're going to be good to go, so yeah, you wouldn't do this for one J E but it's a process the first time that pays off the rest of the year that, you know,
- 38:46Dan DeLong: And that's typically what is what kind of happens.
- 38:48Dan DeLong: A great point.
- 38:49Dan DeLong: Michelle is typically is what's going to happen when you Introduce some kind of new technology inside of QuickBooks is that you're going to shift your workload to the front end of setting it up, right?
- 39:02Dan DeLong: And once you have that, then it's like a, it's like an oil geyser, right?
- 39:07Dan DeLong: It's okay.
- 39:08Dan DeLong: Payday after that.
- 39:11Dan DeLong: So once you have that, things mapped formatted, or, something like that, then the payoff is going to be the countless.
- 39:30Michelle Long: And that's where that Facebook group and the community and Mark and Hester are great resources to help.
- 39:38Michelle Long: Hey, I can't get this to import.
- 39:40Michelle Long: Can somebody help me?
- 39:41Michelle Long: What am I doing wrong?
- 39:42Michelle Long: You're not alone.
- 39:43Michelle Long: That's one of the great things about having a community of your peers to help you as well.
- 39:50Hector Garcia: Okay.
- 39:50Hector Garcia: I think I think I'm back.
- 39:51Hector Garcia: You can see my screen is working correctly.
- 39:55Hector Garcia: Yes.
- 39:56Hector Garcia: Okay.
- 39:57Hector Garcia: Okay.
- 39:58Hector Garcia: Yes.
- 39:59Hector Garcia: Give me one second.
- 40:01Hector Garcia: Okay.
- 40:02Hector Garcia: All right.
- 40:02Hector Garcia: So now we're going to click on the wrench and screwdriver.
- 40:06Hector Garcia: And then on the search settings, I'm just going to type journal entry.
- 40:10Hector Garcia: Okay.
- 40:10Hector Garcia: And then basically it's going to give me all the things that contain the word journal entry, either in the description or in the name of the, in the name of the tool itself.
- 40:20Hector Garcia: So we're going to turn on extended print options, export journal entry to CSV, journal entry balance.
- 40:27Hector Garcia: And I think it was the normal balances.
- 40:30Hector Garcia: And that was like, I should not show him there.
- 40:31Hector Garcia: What's that?
- 40:32Hector Garcia: I have to change the.
- 40:34Hector Garcia: Change that right now.
- 40:35Hector Garcia: Okay.
- 40:36Hector Garcia: No, but I changed the text.
- 40:37Hector Garcia: So it actually says journal entry, not J E.
- 40:39Hector Garcia: Okay.
- 40:40Hector Garcia: So that's the search actually searches within the name of those.
- 40:42Hector Garcia: So now I'm going to go back and open up a journal entry and you're going to see, once you turn these features on you're going to see a new buttons pop up in the journal entry and just refresh here for a second, and those buttons indicate the new The new features that have been enabled.
- 41:00Hector Garcia: So one is I'm going to go ahead and select a couple of accounts.
- 41:05Hector Garcia: So I'm just going through and writing a normal journal entry, the way I would do that.
- 41:11Hector Garcia: And then sometimes like we'll look at a journal entry and we'll forget for a second.
- 41:15Hector Garcia: Is this an asset?
- 41:16Hector Garcia: Is this a liability?
- 41:17Hector Garcia: Is this an expense?
- 41:18Hector Garcia: You have to go in and you have to look at that.
- 41:20Hector Garcia: And on top of that, you have to remember, which is a debit and which is a credit.
- 41:23Hector Garcia: So this little button up there that has the The top and the down arrow, click on that, it gives you basically a little phantom cheat sheet where it basically reminds you, what type of account this is.
- 41:35Hector Garcia: If this is normally a debit account or a credit account, I know we're all accountants that we're supposed to memorize this, but sometimes, it just, it's a really nice, I think to have in there.
- 41:43Hector Garcia: So as you write the journal entry and you're putting here, yeah, I'm trying to increase my accounts payable and yes, I'm trying to reduce my checking account and have to reduce my, student subscriptions.
- 41:55Hector Garcia: And I'm trying to increase my interest expense.
- 41:57Hector Garcia: So just having the arrows there showing you what things are supposed to be, it's just a good indication of how you're going to function moving forward.
- 42:05Hector Garcia: Okay.
- 42:05Hector Garcia: So now once you finish the journal entry.
- 42:08Hector Garcia: And or you try to save the journal entry.
- 42:10Hector Garcia: You should, you get an error saying the Davis and the credits don't balance.
- 42:13Hector Garcia: So the second feature that we added adds a little equal sign down here and it tells you how much you're off by.
- 42:21Hector Garcia: Okay.
- 42:21Hector Garcia: So it's just basically, so quick reminder, Hey, you're off by this.
- 42:25Hector Garcia: This is why it's not working.
- 42:27Hector Garcia: And essentially then you'll know to take that number and put it here to to remind you to to basically wrap up your journal entry.
- 42:35Hector Garcia: So once you save.
- 42:37Hector Garcia: Your journal entry and let's just make sure I'll put I'll put a different account that's not receivable or payable.
- 42:43Hector Garcia: And then I'll save my journal entry and there's a couple things happening.
- 42:46Hector Garcia: Okay.
- 42:46Hector Garcia: So I got, I saved my journal entry.
- 42:48Hector Garcia: Now let's say I want to print this.
- 42:50Hector Garcia: QuickBooks Online doesn't let you print journal entries.
- 42:52Hector Garcia: So we're going to click on write to print.
- 42:54Hector Garcia: And then this is going to give me a new screen that we created.
- 42:57Hector Garcia: The right tool created that essentially gives you a quick preview of what this would look like.
- 43:02Hector Garcia: And you can save this journal entry as a PDF somewhere in your computer.
- 43:06Hector Garcia: So we basically developed our own version of journal entries.
- 43:11Hector Garcia: Let me bring it here so you can see what it looks like.
- 43:14Hector Garcia: In PDF format, you can print that again.
- 43:17Hector Garcia: This only works with with with tool enabled again, the free version.
- 43:21Hector Garcia: So you get to print your own journal entries.
- 43:23Hector Garcia: There's a setting that allows you to print it in landscape format.
- 43:26Hector Garcia: If you also have customer names, locations, and it's just not enough space.
- 43:31Hector Garcia: To have it in in in regular form in portrait portrait format.
- 43:35Hector Garcia: Yes.
- 43:35Hector Garcia: Okay.
- 43:36Hector Garcia: And the last thing here that we haven't covered.
- 43:38Hector Garcia: Okay.
- 43:39Hector Garcia: Yes.
- 43:39Hector Garcia: Export to CSV.
- 43:40Hector Garcia: So if I click on the export to CSV button all the way in the top it creates a CSV file for me.
- 43:47Hector Garcia: Let me bring this around here and I'm going to assume this in 200%.
- 43:53Hector Garcia: So you can see it and good news.
- 43:56Hector Garcia: Okay.
- 43:57Hector Garcia: This export, like the right tool, export to CSV exports, the account numbers in the actual format that would work via an import.
- 44:09Hector Garcia: So the built in reports in QuickBooks don't do that, but this CSV file does that.
- 44:15Hector Garcia: Why is that?
- 44:16Hector Garcia: Who in the world knows?
- 44:18Hector Garcia: We basically just copy and pasted information as is displayed on the screen.
- 44:23Hector Garcia: To be fair.
- 44:24Hector Garcia: I could argue either way why I want to see those account numbers or not.
- 44:28Hector Garcia: It's a different, it's a different issue altogether.
- 44:31Hector Garcia: But for, because it's not really consistent for import, at least our CSV export, As the way the tool is built now, the built in import tool, it allows you to import that.
- 44:43Hector Garcia: Okay.
- 44:44Hector Garcia: And then again, right here in the bottom is as a right tool print is to the left of the reverse button.
- 44:49Hector Garcia: That one's not red.
- 44:50Hector Garcia: Usually our buttons are red, but this is an example of a non red.
- 44:55Hector Garcia: To a button.
- 44:55Hector Garcia: One of the few that we don't put in red, they
- 44:57Dan DeLong: don't let you touch the footer.
- 44:59Hector Garcia: Yeah, the footer.
- 45:01Hector Garcia: It's just the contrast would be very difficult.
- 45:03Hector Garcia: Like it would be very difficult to put red and black.
- 45:05Hector Garcia: So the only solution would be to put an, like a print icon up there.
- 45:09Hector Garcia: But we've had so many issues with having just so many icons up there and the feedback buttons and stuff getting in the way.
- 45:14Hector Garcia: So this is working for now the right tool print.
- 45:17Hector Garcia: So we're not gonna.
- 45:18Hector Garcia: We're not going to mess with it.
- 45:19Mark Corum: Okay.
- 45:19Mark Corum: And one more thing, by the way, on that last one that you had on that last journal entry one of the things about the journal balance that is at least one of my favorite things about it, and it's a small thing, but what you'll notice is if you change like the opening balance equity, if you change it to, yeah, that it's fine.
- 45:36Mark Corum: And then go into the interest expense.
- 45:38Mark Corum: Interest expense.
- 45:39Mark Corum: Yep.
- 45:39Mark Corum: Yeah.
- 45:40Mark Corum: And then backspace all of it.
- 45:42Mark Corum: It will actually, yeah, just delete it.
- 45:45Mark Corum: You'll actually have a placeholder in there that will tell you what that particular amount needs to be in order to balance it out.
- 45:52Mark Corum: So it just makes it so that it's, because at the bottom it says 200, 000, but if you're editing something after the fact, this gives you a little bit more insight without having to do calculations on what you actually need to put in.
- 46:05Mark Corum: So just a little,
- 46:07Dan DeLong: a phantom total.
- 46:08Hector Garcia: So a quick recap.
- 46:09Hector Garcia: If I want to adjust, if I want to adjust any of these numbers.
- 46:12Hector Garcia: I delete it, it should not delete backspace.
- 46:17Mark Corum: It should backspace now.
- 46:18Mark Corum: Apparently wanna do it this particular time for some reason.
- 46:22Mark Corum: Oh, okay.
- 46:23Mark Corum: I get why?
- 46:23Mark Corum: Because it's debit.
- 46:24Mark Corum: It's debit
- 46:25Dan DeLong: needs.
- 46:26Hector Garcia: Okay.
- 46:26Hector Garcia: Yeah.
- 46:26Hector Garcia: So if I, and the other cool thing is that if I delete.
- 46:30Hector Garcia: A journal entry with this feature enabled.
- 46:32Hector Garcia: I deleted journal entry line.
- 46:34Hector Garcia: The fact that your phantom grade out amount that shows in there, that one 55 is actually what you will need to balance that journal entry out.
- 46:42Hector Garcia: So it's not only in the bottom with equals is also on the live preview of any of the fields.
- 46:47Hector Garcia: It doesn't have to be like the last blank field or anything like that, which is awesome.
- 46:51Hector Garcia: Thank you very much, Mark for.
- 46:53Hector Garcia: For bringing that that feature in there.
- 46:55Hector Garcia: Okay.
- 46:56Hector Garcia: We don't have that much time, so we're going to cover as much as possible from the pro features.
- 47:01Hector Garcia: Okay.
- 47:02Hector Garcia: So the pro features that we're going to showcase in this case is going to be the copy Excel to transactions, the clear zero lines button.
- 47:13Hector Garcia: And there is one more that yeah, in experiments pro reallocate in PNL.
- 47:18Hector Garcia: Okay.
- 47:18Hector Garcia: So we're going to.
- 47:19Hector Garcia: Click and save that.
- 47:20Hector Garcia: Then we're going to go back into QuickBooks online and showcase those additional right tool pro features for journal entry.
- 47:27Hector Garcia: So the first one that's probably the most obvious one to to showcase is getting rid of zero, zero lines.
- 47:34Hector Garcia: So like in this case, you see there's two lines with zeros.
- 47:38Hector Garcia: And of course.
- 47:39Hector Garcia: If you have one or two, it's quicker to just click on the little trash icon.
- 47:43Hector Garcia: But if you have a very long journal entry, maybe you import it, maybe you duplicated it, maybe you reversed it, whatever it is.
- 47:51Hector Garcia: If it has a zero, you just click on that button there that says clear zero value lines.
- 47:55Hector Garcia: And it somehow deletes the two for you.
- 47:58Hector Garcia: The, it just leaves them blank.
- 47:59Hector Garcia: But once you click on save.
- 48:01Hector Garcia: It should delete the lines out.
- 48:02Hector Garcia: So it leaves them blank.
- 48:04Hector Garcia: You click on save and it just gets rid of those lines.
- 48:06Hector Garcia: Okay.
- 48:07Hector Garcia: Many people had asked us to like the ability to resort in journal entries.
- 48:11Hector Garcia: We don't have that yet.
- 48:12Hector Garcia: We're still trying to figure out.
- 48:13Hector Garcia: If we even can do that, but that has to be one of the most requested features is to be able to resort in a journal entry.
- 48:19Hector Garcia: So we're working on that to see if that's something we can ever we can ever do.
- 48:23Hector Garcia: Yeah.
- 48:23Hector Garcia: And then the last final
- 48:24Mark Corum: thing on the clear zero value lines, it also.
- 48:27Mark Corum: Keeps whatever is the top line because this is actually a Megan Tarnow request.
- 48:32Mark Corum: So it does keep the top line if it's a zero.
- 48:34Mark Corum: So just be aware of that if you're using that.
- 48:36Hector Garcia: Okay.
- 48:37Hector Garcia: And there's a long philosophical conversation we can have about that and why that is has to do with source and headers and details.
- 48:45Hector Garcia: But she said, bottom line, if the top one's a zero, don't mess with it.
- 48:48Hector Garcia: Cause I might need it.
- 48:50Hector Garcia: I might need it just as an indicator or as a note or something like that.
- 48:54Dan DeLong: It could be a use case for that to be there.
- 48:56Hector Garcia: Yeah.
- 48:57Hector Garcia: Yeah.
- 48:57Hector Garcia: We should probably do a whole power hour just on like how journal entries behave in reports.
- 49:02Hector Garcia: Because if we, if you go down the rabbit hole, you will understand why that top line sometimes needs to be set up in a certain way.
- 49:09Hector Garcia: Okay.
- 49:10Hector Garcia: All right.
- 49:10Hector Garcia: So the last thing we're going to talk about is the sort of copy and paste feature.
- 49:15Hector Garcia: So imagine I'm going to export this journal entry really quick and the export.
- 49:19Hector Garcia: What's actually built so we can test the import.
- 49:22Hector Garcia: Other people have found the export to be useful for all other situations, but essentially the reason why the export exists is so we can have a template for like our own template for the import.
- 49:34Hector Garcia: So just imagine that you have your own journal entry.
- 49:38Hector Garcia: And again, if once QuickBooks gets their built in QBO journal entry, Feature in check and the stuff is working the way it's supposed to work.
- 49:46Hector Garcia: We're our feature.
- 49:48Hector Garcia: We're probably not have any more need.
- 49:50Hector Garcia: Per se, but the nice thing about our feature is that instead of you having to save the CSV file and map it, you can just do a copy and paste type action, sometimes that's easier and or neater for some people.
- 50:03Hector Garcia: So I'm just going to make some modifications to this journal entry here.
- 50:08Hector Garcia: Okay.
- 50:09Hector Garcia: And and just assume for a second that we have a journal entry in Excel already and we used we use all the.
- 50:16Hector Garcia: Awesome features that Excel has like copying and pasting and find that replace and click and drag down.
- 50:22Hector Garcia: And we have information here, let's say about classes.
- 50:26Hector Garcia: So I'll bring this over here and let's say, again, we have, we already have predetermined a journal entry with all this information.
- 50:34Hector Garcia: So I'm going to go here to save a new, so I'm going to start with a blank journal entry.
- 50:38Hector Garcia: And essentially what I want is I just want to copy and paste this.
- 50:42Hector Garcia: Into the journal entry.
- 50:43Hector Garcia: So I'll select everything in here, click on copy.
- 50:46Hector Garcia: Okay.
- 50:46Hector Garcia: Just a regular as if it was a regular copy and paste, come back into QuickBooks online and no, I can't just paste in here.
- 50:53Hector Garcia: That won't work.
- 50:54Hector Garcia: Okay.
- 50:54Hector Garcia: Unfortunately, that's not how we did try that at one point.
- 50:58Hector Garcia: We did try that.
- 50:59Hector Garcia: We didn't try that.
- 51:00Hector Garcia: So we had this little button up there.
- 51:01Hector Garcia: This one doesn't have a label.
- 51:03Hector Garcia: It just has the standard copy icon.
- 51:06Hector Garcia: And you can also do control shift J.
- 51:08Hector Garcia: Okay.
- 51:08Hector Garcia: To access it.
- 51:09Hector Garcia: So you can either do control shift J or or click on that button.
- 51:14Hector Garcia: And then the journal entry pop up, the paste journal entry pop up will now allow you to paste in here.
- 51:21Hector Garcia: So now I can fully paste in here.
- 51:23Hector Garcia: So if I right click and click on paste now it gives me a preview of what's going on.
- 51:28Hector Garcia: Okay.
- 51:29Hector Garcia: If something doesn't match like for example if I have something that doesn't match, but it's approximate to something else.
- 51:36Hector Garcia: This will be in yellow.
- 51:38Hector Garcia: And if you can see color, you're going to see that sort of gray exclamation or that light color exclamation mark right next to it.
- 51:46Hector Garcia: And I'll let you know that you could check the possibilities.
- 51:51Hector Garcia: Of these accounts, and it's because, CH is containing these other accounts and you can select the one that is supposed to be and if nothing makes sense, like this doesn't match anything on your chart of accounts, it would be read with an X on it, letting you know, hey, if you try to import that, it will be essentially it would just be black.
- 52:07Hector Garcia: Okay.
- 52:07Hector Garcia: So it'll just be black.
- 52:09Hector Garcia: So just to give an example, to show you that I click paste in QuickBooks and it basically makes it feel like you did a copy and paste, it's not really a copy and paste, but for the user, and it's really, it's like a copy and paste, then you can save put the right account.
- 52:22Hector Garcia: If you had an account that didn't match and then click on save, and then that would finish the journal entry.
- 52:28Hector Garcia: So we have one more thing to cover where we're actually on top of the hour.
- 52:32Hector Garcia: Unless we want to turn this into QB power hour 0.
- 52:36Hector Garcia: 25, we will leave a reallocate for another time.
- 52:40Hector Garcia: Or if you guys want to maybe wrap it up for the people that have to leave and do some extra bonus, we can do that as well.
- 52:47Dan DeLong: Yeah, just keep going.
- 52:48Dan DeLong: Last couple times we've we've run over if people got to drop off, that's totally fine.
- 52:52Dan DeLong: We will have the supports available for replay, so if you do need to come back later and skip ahead to the top of the hour.
- 52:59Hector Garcia: Exactly.
- 53:00Hector Garcia: YouTube, right?
- 53:01Hector Garcia: It's a YouTube.
- 53:02Hector Garcia: It's in the power hour power dot com website.
- 53:05Hector Garcia: So if you got to go, you got to go, we get it.
- 53:08Hector Garcia: But for the people that stay, this is going to blow your mind.
- 53:10Hector Garcia: If you haven't seen it yet, this is going to blow your mind.
- 53:12Hector Garcia: This is like truly revolutionary from the perspective of saving time.
- 53:17Hector Garcia: Like the few people that use this and it's very, it's sometimes a small use case.
- 53:21Hector Garcia: Few people that use this save hours and hours.
- 53:24Hector Garcia: Per month.
- 53:25Hector Garcia: And they have told us that thing is that it's maybe a small group of people that need this feature.
- 53:29Hector Garcia: So it's called reallocate for in PNL is currently under experiments, bro.
- 53:34Hector Garcia: This is where we put all the features are beta per se, this is our beta list of features.
- 53:40Hector Garcia: And this one, what allows me to do is it allows me to create a journal entry that reallocates.
- 53:50Hector Garcia: Amounts sitting in a class.
- 53:53Hector Garcia: location or customer project that has not been identified.
- 53:59Hector Garcia: Or one that has been identified as admin or overhead or quote to reclass in the future.
- 54:07Hector Garcia: And instead of you having to go into each of the transactions and divide the transaction by three, because you have to be classes or three locations or divided by.
- 54:15Hector Garcia: Any particular percentage that it's the way your business is composed.
- 54:20Hector Garcia: You can simply run this tool that reallocate from PNL and basically creates the journal entry for you to automatically reallocate everything that's sitting there.
- 54:31Hector Garcia: So let's do an example.
- 54:32Hector Garcia: So I'm going to run a regular PNL on classic reports, and then I'm going to do a PNL by class and click on run report classic situation with classics.
- 54:41Hector Garcia: I have an overhead class in this case, which is.
- 54:46Hector Garcia: Class where people were putting things under, but it's neither it's not new construction and it's not remodel.
- 54:53Hector Garcia: And there's also things sitting on not specified.
- 54:57Hector Garcia: Now I'm going to do something really quick.
- 54:59Hector Garcia: This actually makes it much easier to display.
- 55:02Hector Garcia: I'm going to edit these classes.
- 55:04Hector Garcia: So a new construction is.
- 55:06Hector Garcia: One and remodel is to get this just makes the demonstration a lot easier to display.
- 55:15Hector Garcia: So we'll go back and run a P and L by class.
- 55:18Hector Garcia: So now they're in order, right?
- 55:19Hector Garcia: Past one class to we have an overhead and then we have.
- 55:23Hector Garcia: They're not specified.
- 55:24Hector Garcia: Okay.
- 55:24Hector Garcia: And this, there's no limit on how many classes this can work on.
- 55:27Hector Garcia: Actually the limit is probably going to be a thousand lines in the journal entry.
- 55:31Hector Garcia: Whatever the math is of all the accounts, all the classes.
- 55:34Hector Garcia: But for now we've tried, we've had people try it with six, seven, eight classes, and it's worked just fine.
- 55:39Hector Garcia: So I'm going to start with overhead.
- 55:41Hector Garcia: I'm going to reclassify everything that's sitting in my overhead account.
- 55:45Hector Garcia: And I'm going to spread this across multiple classes.
- 55:49Hector Garcia: So I'm going to click on this reallocate button.
- 55:51Hector Garcia: That's to the left of the email button for the reports.
- 55:55Hector Garcia: Again, this is a PNL by class in classic, in a classic reports.
- 55:59Hector Garcia: I'm going to click on reallocate.
- 56:00Hector Garcia: This pop up comes up and the first thing that is asking me is, where do you want to get the values from?
- 56:06Hector Garcia: Do you want to get it from no class or non specified class or a specific class like this one called overhead?
- 56:13Hector Garcia: Give me one second.
- 56:15Hector Garcia: This was not showing the number.
- 56:16Hector Garcia: I wonder if this is going to be an issue.
- 56:17Hector Garcia: I just changed the name of these classes.
- 56:19Hector Garcia: So what I'm going to do is I'm going to do a quick refresh.
- 56:23Hector Garcia: Yeah, just because I just noticed that I removed that number.
- 56:26Hector Garcia: So I wonder if that's going to cause any issues.
- 56:28Hector Garcia: Maybe we'll see.
- 56:30Hector Garcia: So reallocate, let's get back to it.
- 56:32Hector Garcia: Let's check it out.
- 56:32Hector Garcia: Now the number showing, so let's go from overhead and this is showing me a preview of all the dollar amounts that are sitting in my overhead class for this period in accrual basis in this case.
- 56:45Hector Garcia: And right now this only works in P and L.
- 56:46Hector Garcia: We haven't even like.
- 56:47Hector Garcia: Thought about how this worked with balance sheet, but we're thinking about that too.
- 56:51Hector Garcia: And also you can choose the type of accounts that you want to see.
- 56:53Hector Garcia: So let's say I only really want to see expense accounts, or I only want to see other income accounts, or I only want to see whatever it is.
- 56:59Hector Garcia: So that we'll pick only expenses.
- 57:01Hector Garcia: The only things that we're going to move we can remove account numbers if you want to.
- 57:05Hector Garcia: Again, this has to do with importing journal entries, all that stuff.
- 57:08Hector Garcia: So I'm going to keep the journal.
- 57:09Hector Garcia: I'm going to keep the, actually I'm gonna remove the journal entries.
- 57:12Hector Garcia: The account numbers for now, then I'm going to go to select all in the top so I can select which accounts I want to reallocate, click on next.
- 57:21Hector Garcia: And then it's asking me, how do you want to reallocate these?
- 57:24Hector Garcia: Okay.
- 57:24Hector Garcia: So we can do a couple of things.
- 57:26Hector Garcia: We can leave all the ones that are showing.
- 57:28Hector Garcia: So like overhead is already showing there, but just as an example, if I click on split evenly, it'll just split by the number of classes that I have.
- 57:37Hector Garcia: So that's 33, 32, 33, a third each.
- 57:40Hector Garcia: If I remove one of them and click on split evenly.
- 57:44Hector Garcia: It will do 50 50 and depending on the period, if I have a particular number of expenses or or cost of goods sold, depending on the period, and then I can use any of these totals as the indicator to help me figure out what percentages I want to use.
- 58:02Hector Garcia: So I could click on split proportionally again, and so it will use your total sales, your total expenses, your net income, whatever indicator you want to use to have a more proportional.
- 58:12Hector Garcia: Way of allocating.
- 58:13Hector Garcia: And of course, all this stuff is very discreet, discretional.
- 58:16Hector Garcia: As the accounting professional as a CFO, whatever.
- 58:19Hector Garcia: Sometimes you have a policy where you spread everything evenly.
- 58:22Hector Garcia: And sometimes you have a policy where you do some sort of proportional spread.
- 58:27Hector Garcia: Some of our nonprofit clients are telling us that they do spread based on Hours per employees per class.
- 58:34Hector Garcia: That's something you're going to have to calculate externally and figure out what those percentages look like.
- 58:40Hector Garcia: If you have a lot of classes, one of the things that's very nice that we recently added is there's a little button here that says export percentage to CSV.
- 58:48Hector Garcia: So whatever this percentage is, you can export it.
- 58:50Hector Garcia: And again, it makes more sense when there's a whole bunch of a whole bunch of classes.
- 58:55Hector Garcia: So I'm going to, or a bunch of locations, whatever you're allocating.
- 58:59Hector Garcia: So let me bring this in to make this a lot bigger.
- 59:02Hector Garcia: So basically it's a simple template where it says percentage and class.
- 59:06Hector Garcia: So if you want to build your own percentage and class table, just export the current one that it has and do your own thing here.
- 59:14Hector Garcia: Okay just put the percentages there.
- 59:16Hector Garcia: And then with with that reallocation, you're going to click on choose file.
- 59:21Hector Garcia: And import that in.
- 59:22Hector Garcia: And this was some people were telling us that they have their own reallocation tables and and they don't want to go in there and type it by hand every time it's a custom one, so we can use the import export feature to do that.
- 59:33Hector Garcia: So once you're done, you're going to have two choices.
- 59:36Hector Garcia: One, you can export to CSV and it basically just creates.
- 59:40Hector Garcia: A CSV file for us.
- 59:41Hector Garcia: Let me just zoom this in so you can see him this better.
- 59:44Hector Garcia: So this is option number one, just export the journal entry.
- 59:48Hector Garcia: Maybe the journal entry, you want to play with it in Excel or something like that.
- 59:53Hector Garcia: To bring it back in, or maybe you just want to preview it before you're imported, really the use case is really up to you.
- 1:00:00Hector Garcia: I noticed that the classes are being shifted for you.
- 1:00:03Hector Garcia: And also we added notes.
- 1:00:04Hector Garcia: The notes are very clear, reallocated 35 percent to this class, 65 percent to this class.
- 1:00:10Hector Garcia: And then on the other notes as we are located from overhead or reallocated from non specified.
- 1:00:14Hector Garcia: So we pre added the notes for you.
- 1:00:16Hector Garcia: So you don't have to really mess too much with the notes.
- 1:00:21Hector Garcia: And then we have all the reallocation here.
- 1:00:23Hector Garcia: Remember, this journal entry is not going to affect your PNL.
- 1:00:26Hector Garcia: Your PNL is going to be the exact same net income.
- 1:00:29Hector Garcia: What is going to affect is your profitability per class, profitability per customer project, profitability per location.
- 1:00:37Hector Garcia: We're not changing our PNL without.
- 1:00:41Hector Garcia: These columns were changing the individual values within the cause, which is why is a journal entry within itself.
- 1:00:47Hector Garcia: It is a journal entry within the same account.
- 1:00:50Hector Garcia: So once you have that journal entry, then you can use the built in QuickBooks feature to import if you want to, or, of course, we're going to encourage you to use the one that we have with right tool.
- 1:01:01Hector Garcia: Because if you choose copy or clipboard instead of export to CSV.
- 1:01:06Hector Garcia: And that really should say, copy the clipboard and open new journal entry, but you don't have the space for it.
- 1:01:12Hector Garcia: So we click on copy to clipboard.
- 1:01:14Hector Garcia: Oh, he has so much
- 1:01:15Dan DeLong: real estate in the button.
- 1:01:16Hector Garcia: Correct.
- 1:01:17Hector Garcia: So it copies it to your clipboard and then gives you a pop up saying, Do you want to open a new journal entry?
- 1:01:22Hector Garcia: Which is typically what we're going to do.
- 1:01:24Hector Garcia: Then we click OK.
- 1:01:25Hector Garcia: It opens a new tab.
- 1:01:26Hector Garcia: with the journal entry for you.
- 1:01:28Hector Garcia: Remember that journal entry is now saved in your clipboard.
- 1:01:31Hector Garcia: Okay.
- 1:01:32Hector Garcia: So all you have to do is click on the, on that paste from Excel function I showcased earlier.
- 1:01:38Hector Garcia: And now then you come in here and you right click and paste.
- 1:01:42Hector Garcia: And now we're pasting this humongous journal entry.
- 1:01:46Hector Garcia: And then we click on paste into QuickBooks.
- 1:01:48Hector Garcia: And there's the creation of the journal entry.
- 1:01:51Hector Garcia: So
- 1:01:52Dan DeLong: Michelle, she's clapping.
- 1:01:53Hector Garcia: Yeah.
- 1:01:53Hector Garcia: So the first phase, the first part of the app is creating the other, the template for you.
- 1:01:59Hector Garcia: And the second part of the workflow is to actually save the journal entry for you.
- 1:02:03Hector Garcia: So you have, you, it has to be done in two steps.
- 1:02:06Hector Garcia: We cannot do this all in one step.
- 1:02:08Hector Garcia: Just, we API for that, or somehow create a bunch of delays and a bunch of macros for now.
- 1:02:14Hector Garcia: I think if you're.
- 1:02:16Hector Garcia: If you're in the position to do this type of work, you're probably going to be slick enough to be able to press all these buttons.
- 1:02:22Hector Garcia: But in either case, look, this is a super long journal entry, very precise.
- 1:02:27Hector Garcia: Okay.
- 1:02:27Hector Garcia: And then we'll just click on save.
- 1:02:29Hector Garcia: You can reverse the journal entry.
- 1:02:30Hector Garcia: You can delete the journal entry, whatever you want.
- 1:02:33Hector Garcia: Way for us to undo the way transaction process and allow you to undo an entry because again we're not connecting this via the API.
- 1:02:42Hector Garcia: Then I go back into my PNL, I'm going to click on run report and essentially all of my overhead is now gone.
- 1:02:48Hector Garcia: All the overhead bye bye overhead is now gone and it's now put in inside each of the each of the classes the way it's supposed to be and again, it works with locations.
- 1:02:58Hector Garcia: It works with customer projects as well So if you got customer projects, you can do that.
- 1:03:02Dan DeLong: Michelle's face.
- 1:03:04Dan DeLong: I'm just looking at michelle's reaction They're like her jaw is literally on the floor
- 1:03:09Michelle Long: God hector and mark.
- 1:03:11Michelle Long: I just I love this.
- 1:03:13Michelle Long: I love it.
- 1:03:13Michelle Long: I love it.
- 1:03:14Michelle Long: I love it.
- 1:03:14Michelle Long: And I think of how much time this could have saved me for so many years and stuff.
- 1:03:19Michelle Long: Oh my gosh, this is amazing.
- 1:03:21Michelle Long: This feature right here alone is just worth it.
- 1:03:25Michelle Long: It's incredible.
- 1:03:27Michelle Long: You can sell just this one piece of this tool from BookuBox.
- 1:03:31Michelle Long: Just that one feature right there.
- 1:03:33Michelle Long: I absolutely love this.
- 1:03:35Michelle Long: This is amazing.
- 1:03:36Michelle Long: Michelle.
- 1:03:38Michelle Long: Not only for not everybody's talking about nonprofits there, but not just nonprofits, but also for those construction clients that are allocating overhead to the job, when you want to allocate owner's time to the jobs, when you want to allocate those nonprofits, the overhead to the job, anything that you're wanting to allocate, Oh my gosh, this is so incredible.
- 1:03:58Michelle Long: And how much time it's going to save.
- 1:03:59Michelle Long: Oh, I love this.
- 1:04:02Hector Garcia: Yeah.
- 1:04:02Hector Garcia: And what.
- 1:04:03Hector Garcia: Yeah, thank you.
- 1:04:04Hector Garcia: And worth pointing out.
- 1:04:05Hector Garcia: Okay.
- 1:04:05Hector Garcia: So we did this with a specific class overhead class.
- 1:04:08Hector Garcia: We can also do this with the ones that don't have any class.
- 1:04:11Hector Garcia: Okay.
- 1:04:11Hector Garcia: Now specify.
- 1:04:12Hector Garcia: Now, one thing I do want to point out, we are not going into every single transaction and splitting the transaction up for you.
- 1:04:19Hector Garcia: The transactions are being left intact.
- 1:04:21Hector Garcia: We're doing a full fix of this.
- 1:04:23Hector Garcia: We're basically, we're just doing a journal entry.
- 1:04:25Hector Garcia: We're cleaning it up for reports.
- 1:04:27Hector Garcia: Only for reports.
- 1:04:28Hector Garcia: Okay.
- 1:04:29Hector Garcia: Okay.
- 1:04:29Hector Garcia: And one thing to remember, and this is kind of something that we're probably, again, we probably need to save.
- 1:04:35Hector Garcia: A whole episode just to talk about how journal entries work.
- 1:04:37Hector Garcia: But once you turn on the ability to do adjusting entries, which you don't see here, cause I'm not logged in as an accountant, then you can create you can create an adjusting entry and then you can pick, whether you want to see the PNL with the journal, with the adjusting or without the adjusting.
- 1:04:53Hector Garcia: Something that we don't have a chance to get into, but I do want to show you one more thing, and this is a bonus is we still have.
- 1:04:59Hector Garcia: Over a hundred and forty people.
- 1:05:01Hector Garcia: Bonus power hour
- 1:05:02Dan DeLong: plus
- 1:05:02Hector Garcia: time.
- 1:05:03Hector Garcia: So this is a feature that's been pretty quiet just because you have to be like a super uber nerd to play with this feature, which is called the scripts.
- 1:05:11Hector Garcia: Okay.
- 1:05:12Hector Garcia: Now ever since ChatGPT started existing, basically, and I started obsessing with it.
- 1:05:17Hector Garcia: I started playing with ChatGPT and trying to figure out if I can get ChatGPT to teach me how to code.
- 1:05:24Hector Garcia: Long story short, I didn't learn how to code but the chat GPT can write the code for me.
- 1:05:29Hector Garcia: One of the, one of the, one of the things that people were asking, for example, is, Hector, could you add a button that will save this transaction, reverse it, and then save it for me?
- 1:05:39Hector Garcia: Literally, somebody wants to save this click save.
- 1:05:43Hector Garcia: And then reverse and then save.
- 1:05:46Hector Garcia: Okay.
- 1:05:46Hector Garcia: That was only two or three clicks.
- 1:05:48Hector Garcia: Okay.
- 1:05:48Hector Garcia: It's really not a big deal.
- 1:05:49Hector Garcia: I normally would have dismissed that and go, Hey person, don't be so lazy.
- 1:05:53Hector Garcia: Okay.
- 1:05:53Hector Garcia: That's that was like one tiny little click, but supposedly our ethos is.
- 1:05:59Hector Garcia: We'll save you clicks.
- 1:06:00Hector Garcia: We'll save you seconds.
- 1:06:01Hector Garcia: And that almost was a second.
- 1:06:04Hector Garcia: So like it qualifies, so I'm not going to bother.
- 1:06:07Hector Garcia: I'm not going to bother Mark with, Hey, go develop this button, this save and immediately reverse.
- 1:06:13Hector Garcia: So what it is, I went to chat GPT.
- 1:06:16Hector Garcia: And it's complicated.
- 1:06:16Hector Garcia: So I took the HTML code pasted in chat GPT and say, Hey, I'm trying to automate this process.
- 1:06:21Hector Garcia: I want to click save.
- 1:06:22Hector Garcia: I want to click reverse.
- 1:06:23Hector Garcia: I want to click on save again.
- 1:06:24Hector Garcia: I want to change the date.
- 1:06:25Hector Garcia: I want to do all these things.
- 1:06:26Hector Garcia: And then and then chat GPT came back and said, yeah, the code.
- 1:06:30Hector Garcia: Would look like this.
- 1:06:31Hector Garcia: And then what I do was called I created what's called a book Marklet format, which is essentially what we allowed to do in the script section.
- 1:06:40Hector Garcia: So if you actually have if you actually have the code, which in the slides here, where it says bonus, the code is here for you, you literally would have to just copy and paste that code from the slides.
- 1:06:53Hector Garcia: Copy and paste that into the script section.
- 1:06:56Hector Garcia: So we come in here onto scripts.
- 1:06:57Hector Garcia: We click on add script.
- 1:06:59Hector Garcia: We paste the code.
- 1:07:00Hector Garcia: Again, you don't have to know it.
- 1:07:01Hector Garcia: You don't have to know any code for now, but then once you start nerding out, getting into chat, GPT and how to build codes for you, you can build your own scripts inside, right?
- 1:07:10Hector Garcia: Tool.
- 1:07:10Hector Garcia: And then you can start experimenting things and come back to us and get Hector, look what I built and then we'll, once we have time, we'll go out.
- 1:07:18Hector Garcia: I'll go bother Mark and Joel and Patrick, our development team and say, Hey.
- 1:07:22Hector Garcia: It looks like this is catching on.
- 1:07:23Hector Garcia: Let's build this into a hard code is into a right tool.
- 1:07:26Hector Garcia: So we'll call this save and reverse journal entry, something like that, we save it, and then while you're in a journal entry, just watch single click, I click on the on, on my script, it will save.
- 1:07:39Hector Garcia: It will reverse and it will save again.
- 1:07:41Hector Garcia: And all this stuff happened without me clicking anything.
- 1:07:44Hector Garcia: So again, probably not like the most powerful time saving feature, but it's just a good illustration on what we built that in and the reason why script was built, it was for me.
- 1:07:54Hector Garcia: I told Mike, I want to play with chat GPT and a lot of the features that we have added.
- 1:07:58Hector Garcia: Has been because I play with it.
- 1:08:00Hector Garcia: I add the feature, then I send the code over to Mark and then Mark figures out whether the code can be worked verbatim or does it need to be reworked, but at least I work out all the logic and all the kinks.
- 1:08:11Hector Garcia: In the process.
- 1:08:12Hector Garcia: So that's the little bonus thing.
- 1:08:14Hector Garcia: I wanted to show you just
- 1:08:15Dan DeLong: There's playground is what it is.
- 1:08:17Hector Garcia: Correct.
- 1:08:17Hector Garcia: That's the play around.
- 1:08:19Hector Garcia: So I don't know if you want to run the last polling question and I'll leave.
- 1:08:21Hector Garcia: I'll let Mark point out anything that I may have missed.
- 1:08:25Mark Corum: I think most of the time if you miss something I would point it out in the moment.
- 1:08:29Mark Corum: So I think you're good.
- 1:08:31Hector Garcia: And Mark, I'm very upset, Mark, that you interrupted me and you didn't let me speak at all.
- 1:08:39Hector Garcia: Honest to God, I was worried.
- 1:08:41Michelle Long: Hector, do you even breathe?
- 1:08:44Michelle Long: I don't breathe.
- 1:08:46Hector Garcia: I don't breathe.
- 1:08:48Michelle Long: You are amazing.
- 1:08:49Michelle Long: He
- 1:08:50Dan DeLong: can breathe in and exhale at the same time.
- 1:08:55Michelle Long: You're amazing as always, Hector.
- 1:08:57Michelle Long: This stuff is really great.
- 1:08:59Michelle Long: You and Mark have done an amazing job with this.
- 1:09:01Michelle Long: And it's just, I haven't seen it for a while some of these latest updates you guys have done.
- 1:09:05Michelle Long: And I'll tell ya, I am very impressed.
- 1:09:08Michelle Long: As a lot of people are saying on here, the latest stuff that you guys have been doing is just incredible.
- 1:09:12Michelle Long: I haven't seen these latest things and I'm more impressed than ever.
- 1:09:17Dan DeLong: And you guys have been nice enough to to offer a discount for pro for the QB power hour use community.
- 1:09:23Dan DeLong: If you use QB pH, when you activate the pro you will get a discount for that first year of using these features.
- 1:09:31Dan DeLong: So clearly.
- 1:09:32Dan DeLong: If you're not saving the time with what you just did, just demonstrated with the reallocation a little extra savings that first year to get used to these things, and then boom, next year you're all off and off to the races.
- 1:09:47Dan DeLong: Lauren said, worth every penny.
- 1:09:49Dan DeLong: Nice.
- 1:09:51Mark Corum: Yeah just pricing in general.
- 1:09:53Mark Corum: Very odd situation because we said, we don't connect per company, we connect per user.
- 1:09:59Mark Corum: So it's it's a tough balance because there are some people who get, in excess of the subscription cost of value back and there's other people who are just getting started and they're still in their Empathy infancy in their business and it's like it's a little bit more.
- 1:10:13Mark Corum: It's a little bit more tough to justify So it's a hard thing to always get To get it.
- 1:10:18Mark Corum: Just right.
- 1:10:20Dan DeLong: All right, and Hector and Mark who appreciates you joining us and Donating your time here today.
- 1:10:27Dan DeLong: I know you guys are super busy And we really appreciate everything that you do for the accounting community as well because this allows some people to Make what was it again is make quickbooks pleasurable again Yes,
- 1:10:46Michelle Long: all right, thank you everybody and dan as always thank you very much
- 1:10:51Dan DeLong: All right.
- 1:10:51Dan DeLong: We'll see you next time on the qb power hour.
- 1:10:53Dan DeLong: Have a great day everyone.
- 1:10:55Michelle Long: Bye everyone.