RightTool is the Right Tool for Accountants (or even end users) of QBO. Hector Garcia and Mark Corum have been hard at work creating some new updates and they will be joining us to share what they have been working on.
Save $5/mo for the first year on RightTool Pro by using QBPH as the Promo code
Get the extension here
QB Power Hour is a free, biweekly webinar series for accountants, ProAdvisors, CPAs, bookkeepers and QuickBooks consultants presented by Michelle Long, CPA and Dan DeLong who are very passionate about the industry, QuickBooks and apps that integrate with QuickBooks.
Watch or listen to all of the QB Power Hours at https://www.qbpowerhour.com/blog
Register for upcoming webinars at https://www.qbpowerhour.com/
RightTool is the Right Tool for Accountants (or even end users) of QBO. Hector Garcia and Mark Corum have been hard at work creating some new updates and they will be joining us to share what they have been working on.
Save $5/mo for the first year on RightTool Pro by using QBPH as the Promo code
Get the extension here
QB Power Hour is a free, biweekly webinar series for accountants, ProAdvisors, CPAs, bookkeepers and QuickBooks consultants presented by Michelle Long, CPA and Dan DeLong who are very passionate about the industry, QuickBooks and apps that integrate with QuickBooks.
Watch or listen to all of the QB Power Hours at https://www.qbpowerhour.com/blog
Register for upcoming webinars at https://www.qbpowerhour.com/
Welcome everybody to another QB Power Hour. Michelle. 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
Michelle Long:Yeah, it's reunion day on power hours. 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. So hopefully everybody made it home safely.
Dan DeLong:Yeah. So very interesting. Nobody there was no apocalypse. 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? Yeah.
Hector Garcia:The IRS gave us a an extension. 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. So, a
Michelle Long:little, I'm going to have to get working today.
Dan 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. And he's got a lot of things to tell us. 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. Tool. Is that the way you say it, is the right tool. Tool or right tool we say. Tool app.
Hector Garcia:Tool app, tool app.
Mark Corum:Even although it is like DC comics, you say DC Comics even though it's like District Comics. Comics or something like that.
Dan DeLong:or pin number. 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. But today we really want to talk about. 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. And that's really what you've done to make people or allow people to be more efficient inside of working with QuickBooks online. Was that like the catalyst for all of this? Because you guys are like the. 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.
Hector Garcia:Yeah, I think Mark and I both share the same vision that accountants should concentrate on doing good accounting and not in clicking. 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. 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. It encapsulates all the power of what a third party tool can do. And only a small scrappy team of developers can build this quickly and efficient versus. Waiting for QuickBooks to build it. 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. We do have a full set of slides. So if you share the slides Dan, they can, we just skip the introductions. We're going to be covering a couple of things here. So first of all, how do you get started with right tool? We want to get everybody started. 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. And there's tons of efficiency improvements on the free version. You will be more likely to upgrade to pro sooner rather than later. So you just got to write tool that app forward slash free. It will forward you to the Google Chrome extension landing page. You just click on add to Chrome is going to work in Google. Chrome is going to. 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. It definitely does not work in Safari and it definitely most definitely does not work with the new QBO desktop app. Okay. 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. The QuickBooks desktop app and right tool plus Chrome or right tool plus. Microsoft edge is like the competition per se. 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. I don't know. And it's not because they have anything against us is because they would like to control that experience. The QuickBooks desktop has added. 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. If you use Google Chrome or Microsoft edge browser. So definitely check out the free edition. We have over 10, 000 down, I think it's like 16, 000 downloads at this point. We have a full YouTube channel with over a hundred videos. Explaining what every single feature and right tool does both free and pro. And we also do bi monthly bi monthly. So every two months, a webinar series, updating our users, both free and pro of all the new things that we're adding. And in some cases we'll showcase some beta, something we're like just thinking about. And then we get live feedback. I would say at this point. At the beginning, it was probably 80 percent my input, 20 percent Mark. At this point is probably 80 percent our users input. And Mark and I have maybe 10 percent each of say or what goes or it doesn't go. Our users are telling us what they want. And this app is very much crowdsourced. So that, that Facebook
Dan DeLong:group, that's what, yeah, that's one of the things that I think is well, from just what I've experienced. Yeah. 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. And then five minutes later, it
Hector Garcia:Not by, Not five minutes, but see that, see, most software companies don't have an idea. They'll have a beta and then they'll have a focus group. And then they'll try to figure out if it's a good idea or a bad idea. In this case, we're seeing live reactions from our users, from the suggestions. 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. Why would the button be on the left or the right? So a lot of this stuff is being happening on the fly with the users and the way we interact with the users. There's some emails. But the most part is the Facebook group. 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. Come from there. People will post, Hey, I'm having this problem with QuickBooks. How would you solve it? So it's not even like a right tool question. And then it gives Mark and I the opportunity to read it and go, is this something we can solve? So a lot of the solutions that we've come up with are based on like questions that weren't even about. It was more like I'm having this issue. 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. So definitely check that out. The link to the group is in the slides the link to the free versions in the slides, the YouTube channel the the link. By weekly web, by monthly webinar series. 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. And there's no per company per client, that's stuff. The most apps do where they charge you per client. There's no, no such thing. We actually don't connect. To the QuickBooks files at all. We actually don't even know how many clients you have. It's just we don't connect to QuickBooks. We work with you in your browser as a power tool, right? Like we're just a power tool. It's
Dan DeLong:like the solar glasses that everybody had to wear yesterday for the eclipse. It goes over the top of, yeah. Of, of the browser so that you can use QuickBooks safely without burning your retina.
Hector Garcia:Dan, you are so good at,
Michelle Long:yeah,
Hector Garcia:Like that. 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. com forward slash register. And you can set up a 14 day free trial risk free for the pro edition. If you want to, you don't need to register at all for the free edition. And if you have a firm with more than 20 users. We can do a custom price. Okay. Michelle, you want to add something before I jump to the demo?
Michelle Long:What's so Hector? I was just going to say one thing. First of all, I think it's amazing. 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. Gosh, this saves me X amount of hours or estimates. Do you have any kind of ballpark? No, people say it's hard to quantify.
Hector Garcia:A lot of people say hours. 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. You saved the, you saved me from a whole bunch of frustration. Which is a it's more of a qualitative term than a quantitative term. So it's and some people are saying with right tool, it makes QuickBooks pleasant again. Maybe that could be our political thing we could do. There we go. Make QuickBooks pleasant again. Yeah, so it makes QuickBooks work pleasant again because it takes away Just dreaded clicks and that sort of thing. 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. I would say that if it didn't save you at least two hours a month. you wouldn't pay the 50 a month. So I would say, I think I'm, I will gladly, I will easily say at least two hours. And Mark, I don't know if you have any other opinions on that, but I would say about that.
Mark Corum:Yeah. It's one of those things where it's across the board. 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. 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. So it is really across the board depending on how you use it.
Hector Garcia:Yeah. 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. So we're not a full replacement for Sassant or Transaction Pro at all. 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. 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. So no need for a third party app. Okay. Like half of my clients files have it. And two weeks ago, only two of my clients files had it. 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. So we're going to talk about the built in journal entry tool inside QuickBooks on journal entry import inside QuickBooks online. I'm calling it a beta. They are not calling it a beta, but I'm calling it a beta just because it just came out. And generally you can't really get QuickBooks credit for not calling. The first iterations of their things. Not a beta because most of the times they are betas, but it's worked pretty well. 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. 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. You can get to it if it's enabled in your file. You can click on the gear menu top right of the screen. And then you can click on where it says import data. And then there should be a new icon under import data called journal entry. So again, this is built into QuickBooks online. You don't need a third party app. We just need to make sure that all of our, all of the files have it. Okay. All versions. We're talking about simple start plus essentials. Like I, as far as I know, This is a new feature that works across the board, all QuickBooks files. Thank God they didn't just add it to advance because that would have made me strangle somebody. That would
Dan DeLong:go under the Hector bunkers.
Hector Garcia:That would drive me flipping bunkers. Correct. So what's really cool about this page is you get this download import guide, which is a PDF. It's like a little cheat sheet. I think it's awesome. Especially if you're training someone. On this tool, it gives you a really good visual letting Hey, this is what all the fields that can be imported into. And then it makes it very obvious for you to know how you can map your existing spreadsheet to that. Okay, so this is what what it looks like now. So this would be like a reference guide you would print out or something like that. The other really cool thing that it does is. It allows you to download a sample CSV. The sample CSV is it could be open in Excel, just a normal spreadsheet file. There's a couple of particularities on this sample CSV. Let me zoom in so you can see a little bit better. Particularity number one worth mentioning is there, there are asterisks on each of the fields that are required. So the only required fields are journal entry number, journal entry date. And the account name. 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. The other thing is worth mentioning is there is a tax code column in it. This is because they're porting this over from the UK and Canada, because you can Canada both had this feature for nine years. So this is what I mean by beta. It means that they like half implement something and then they, somebody goes on vacation and they forget. That the tax code is irrelevant for the U. S. So the template itself has this and then there's some notes about that codes. Of course, this is very obvious that they took the kind of copy and paste the U. K. Code, put it in the U. S. And started releasing it to the users. So you're going to delete this extra data. That's in here. Cause you actually don't need that. So you just delete that extra data and you delete the tax code cause you're not going to use the tax code. Of course, at some point, hopefully in the near future they'll fix this. And then it will make this conversation obsolete. I would very much like that. But for now. Just giving you some usefulness on this thing. The second, particularly on the built in template, is that the journal entry date is pre formatted with the UK format. Okay, so don't ask, again, why did they do this? Quickbooks, please. It's so easy to do the right thing. But I don't know, you get tempted to just, I will say all these things.
Mark Corum:Yeah. As a developer, I do get the date thing. It is the most annoying thing on the face of the plate. So
Hector Garcia:Hopefully they're fixing this as we speak. And, or maybe there's different versions out there. Like mine does that, but somebody else's won't who the heck knows. So you want to make sure that you have the dating correct or that you, when you do the mapping, you do the correct. A format. The date is not required on on rows two and below for every journal entry. So you can leave a blank. You could also have a date there, but keep in mind that it actually ignores it. Okay. So you could keep, you could leave a blank or you can put it across. What you can't skip is the journal entry number. The way QuickBooks knows that every line belongs to the same journal entry is if they have the same number. So having the same number is how you tell it. Especially especially if you have multiple journal entries per entry, you could just import a single one. But you can also import multiple. 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. That was, so then technically there would be a limit of 500 journal entries with two lines. Sorry. Yeah. So there is a mathematical limit. So the mathematical limit is a thousand lines, which. If you only had, two lines per journal entry, which is the minimum, then you would have 500 journal entries total. But the 500, the 1000 lines is the true entry. Then you have an account number. You can either put the account number by itself, or you can put the account the account name by itself. The whole thing goes haywire when there's both account names and account numbers. 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. Mark is shaking his head because for other tools we've had to manipulate this whole account number issue. So that's really all you need to know. The thing that I dislike About the sample is a sample. Those things give you like your own account number or your own classes or your own locations. It just gives you a random data. 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. If you export a budget example, template. It gives you your actual data. 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. To build your own journal entry. So that being said, I'm going to go ahead and delete all this data. Okay. 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. Okay. So let's say I'm just going to grab a couple of accounts here at random. Okay. I'm going to grab a couple of accounts. We'll do some with sub accounts, some without. Okay, and I'm just going to ask you to like, imagine the journal entry being a lot longer. So it makes sense why we would use import instead of just typing it manually. Okay. 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. as a whole. So that could be, one of the reasons, but there there's so many. So just imagine this is the journal entry we were trying to import. So I'll just copy this information over. So I'm going to start with journal entry number. I'm going to call this HG 040924. 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. I'll put today's date. Okay. And I'll copy this down. I don't click and drag because it's a, it'll change them for me. Like I said, you can have them in there or you can just have it on the very first line. Then the account name, this is where I'm going to bring the information that's in here. So this one is savings. This one is automobile. This one is job expenses. Okay. Pop quiz. What would be a faster way for me to get those accounts? Names into the spreadsheet,
Dan DeLong:something in the right tool,
Hector Garcia:but without right tool, without right to
Dan DeLong:export the. The report or the journal entry.
Hector Garcia:Exactly. So I would go into a transaction journal. Yeah. Transaction journal. If the, if it already exists, you got it. Yeah, exactly. 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. And then just use the data that's already in there and paste it. Now, I'm going to go ahead and let me just zoom this in for a second. 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. So I'm just going to paste that in there including the account numbers. And then again, if we have any issues with the account numbers, Being in there we'll play with it. It'll be nice for us to have that information handy. Okay. So I'm going to put 500, 500, 500, and then. 2 50, 2 50 and 1000. Okay. Alright, so again the date format, I'm using the actual American date format. 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. But in the European format, you could put it there on your normal format. And then just when you map it, you just tell it which format you're using.
Mark Corum:And I think Michael McClellan said that his version does have the actual normal United normal United States format. Yeah, exactly. So it might be depending on what your sample ends up being. You probably want to adjust for whatever that is. It
Hector Garcia:could just be classic, QuickBooks having, Different versions of QuickBooks for different people type of thing. Okay. So I'm going to put in my customer information. And same thing if you want to bring class and locations let's just do here the new construction class. So we'll copy this over and bring that over here. Okay, so you can also delete any columns you're not using. So if you're not using location, you can delete that. You don't have to have data that you're not going to import. And essentially, this is what your template would look like. Take a picture with your phone. Okay. And then once you have it all ready in here, okay, and notice that there's a master memo line and a description line. This is interesting. 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. Which is this guy over here, the bottom memo. So you actually, memo is one of those things that you also don't need to repeat across multiple lines. So this would be bottom memo, something like that. And just like the dates, you actually don't need to have the dates pass the very first line. So the memo column and the journal entry are the two that you only need to have the first line set up. Okay. So now that we have our journal in here, we have to save it as a PDF. Sorry, did I say PDF? I'm crazy. You did. You have to save it.
Dan DeLong:Like what?
Hector Garcia:Yeah. Yeah. You have to save it as a CSV. Okay. I knew it was three letters, but I got the three letters wrong. So you have to save it as a CSV. I don't even close. Yeah, I, yeah, but I got the number of letters, right? So we're going to click on the gear menu, go to import data and then go to journal entries. 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. So let me put it in the desktop, save this again, put this in the desktop, save. Okay. And then come back into QuickBooks. Pick my desktop. There's my journal that when I click on next is going to ask me to to map it. Now what's nice about this is because I used the headers from the template, then I don't have to remap it. 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. So which is my journal entry number, which is my date. But of course, I already had the headers in my template. That's the advantage of using the template as the baseline. And here is the The formatting for the date. So if you happen to be using none weird, just different European dating style you can just pick pick those here. Okay. So then we're going to go to next. And then, of course. QuickBooks, the actual export of the account name, exactly as they've chosen the reports is not acceptable in the import. Okay. Again, because QuickBooks, it's just such a, okay. That's
Dan DeLong:as the kids say, womp today.
Hector Garcia:Yeah. So a couple of so the solution for this. It's going to be either just removing account numbers all together or just using the names without the account number. So I'm going to go in, actually, I'm going to just delete all the account numbers here. So I'm deleting all the account numbers and notice I'm deleting them both from the from the beginning of the account. Name and also from every sub account. And I know some people are saying Hector, at this point, I would have just written 20 journal entries by hand by now. Yeah, I understand. But sometimes we have reallocation journal entries. We have a payroll job costing journal entries. 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. Customer names and that sort of thing. So we're going to save this as we'll do journal entry number two. And exactly what I did just to recap, what I did was I removed all the account numbers, and also I removed the spaces. Between the columns and the accounts. Just remember that sometimes those are hard to remember. Sometimes as you're cleaning up, you'll forget to delete those spaces. I know Mark and I have gone through our fair share of growing pains. With that, with importing and that sort of thing. Okay. So we'll go back here, bring the new journal entry in, click on next. Let's go to next. And now it says the accounts don't exist. Why are you being such a weirdo quick folks? Okay, let's try doing the following. It's all of them,
Dan DeLong:so it's not the fact that they're sub accounts.
Hector Garcia:Yeah, you'll see. I'm going to go to the gear menu and go to account and settings. I'm going to go into advanced and then I'm going to go into account numbers and disable them. Okay, now that's not going to delete them from your database, thank God. But Just hiding them. Okay. I don't know where I read somewhere. It's actually not here, but it's in a link somewhere where they're suggesting to turn off account numbers. Again, we mentioned at the beginning account numbers are going to throw you off in this whole thing. So we'll go to next and okay. Let's see, let's try this again. Let's go browse. Journal number two. Next. Let's go to next. And why are these accounts, why are they telling me these accounts don't exist? All right, I'll try one more thing here. We're gonna go back and let's go to Somebody's saying, Hey, you just turned off account numbers. Maybe you should do like a whole refresh of QuickBooks. That's a good idea. Should I log out, log back in? Let's just see really quick. This
Dan DeLong:is an interesting development. Hector stumped himself.
Hector Garcia:Yeah, the account numbers showing here. The immovable
Dan DeLong:object and unstoppable force have collided.
Hector 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. And let me turn. Okay. So I didn't fully turn off the account numbers. Give me a sec. Say you and Hector Garcia are working on this at the same time. This is my alter ego,
Dan DeLong:your
Hector Garcia:evil twin. I love it. Okay. Let me,
Dan DeLong:that's Hector with the goatee.
Hector Garcia:I'm going to log out for a second. Log back in. Okay. QuickBooks went haywire with me changing account numbers. Okay. So I'll log back in because they're trying
Dan DeLong:to fix it while you're talking, of course
Hector Garcia:They noticed me criticizing it at the very beginning and they're like, okay, of course. Hector, the royalty, let's fix it for him. Sure. In my dreams. That's what I do
Mark Corum:when we're on these webinars.
Hector Garcia:Okay. Let's see. All right. Okay. So now officially it's turned off. So that could have been part of the issue. It didn't fully refresh turning off the account numbers. I think this should work now. Let's see. And by the way, this should work now. It's my new slogan. I'm getting a shirt done. We're going to sell them in conferences. They're going to sell out. All right, there you go. So finally imported. So by the way, so let's just backtrack for a second. You want to turn off the account numbers. And you want to fix the chart of accounts. So the accounts, so they don't contain the numbers. That's going to be the easiest way to go about it. I just happen to have not fully saved or wait for it to refresh and recognize account numbers disappear. So I click on complete import. It does this thing. You can click on the link. And then it sends you for some reason, it sends you to some sort of report, okay, that's useless. So we're just going to click on the recent transactions button and go into journal.
Dan DeLong:I bet in the international versions it actually would take you somewhere.
Hector Garcia:Yeah. Yeah. Again it, it should work. That's sure. It's going to catch on. It's going to be, it should work this time. Okay. So here's the journal entry. See how about now? It's actually wonderful. It's a great, beautiful thing. Might be worth live troubleshooting this. Did I put classes across all lines? I did not. Okay. So it was just my journal entry. Didn't contain class across all lines. It actually did exactly what we wanted to do. There is new journal entry import. It actually works really well. My opinion, I think I think. It's 95 percent there. I think some clarity around the templates and around the account numbers would be helpful. 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. I'm going to save and open the accounts, the account numbers one more time. I'm going to click on chart of accounts. Let me hit refresh, make sure that chart of accounts comes in, hit refresh one more time. And again, I might have to log out. Log back in. Let's do a heart refresh. Okay. No. Okay. Note to self, if you ever turn off and turn on a chart account numbers, log out of QuickBooks, log back in. Cause for some reason it doesn't work quite immediately. Okay. So let's log back in and we're going to try one more thing. And this is mostly for the sake of just like live troubleshooting, how you can manage this chart of accounts. chart of account numbers situation. I'm going to show you one thing that kind of worked for us. So I'm going to show you live on the screen on that. Okay. So we're going to try, we're going to try two options here. So option number one, and let me open up the other journal entry that I had. Here we go. Okay. Let's accept the one that didn't have the numbers. Let's zoom in and see the whole thing. So option number one, I am going to try only removing the accounts. From the ones that count numbers from the one that have sub accounts, but it's going to be even weirder. I'm going to replace the number at the very beginning with the one that was the sub account. Dan, can you follow that? Because if you can't, that means I didn't explain it correctly.
Dan DeLong:Yes, you're going to take 54 to 520 and put it in the front of job expense.
Hector Garcia:Exactly. And by the way, when
Dan DeLong:I was tracking,
Hector Garcia:when somebody had into it, Was thinking about this saying, this is a great solution for users, by the way. This is awesome. 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. Can you imagine what they were smoking when that happened? When they actually, they all shake their hands together and I said, this is a good idea. All right. Anyway, so I'll import this one to 410 and then I'm going to save. So this is the first attempt that we're going to try. 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. 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.
Mark Corum:I'm not going to lie to you. I was answering a question in the problem.
Hector Garcia:All right, so there it is. 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
Dan DeLong:need to use the hierarchy of the parent sub or could you just that's what
Hector Garcia:i'm about That's about the show. So instead of having any accounts i'm just going to show You I'm just going to do account number. That makes sense. So only account number. We'll see if that one goes through that one. 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. Let's save that. And let's go back into journal entry, browse, and let's try just journal and just account numbers and go to next. Okay. There's the conclusion, folks. 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. 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. Okay. So any any thoughts or conclusions or a sense of amazement on how well designed this tool is?
Dan DeLong:Oh boy.
Mark Corum:Honestly, Every time I look at QuickBooks, I honest to God think, Man, I wish I could live up to this. And actually, you know what's funny? I do very much actually have very much respect for the people who develop QuickBooks. QuickBooks. 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.
Hector Garcia:Yeah, I think the good thing is there's actually more and more Intuit employees watching webinars, Facebook groups, this type of things. 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. So I guarantee you somebody will watch this and they'll come up with a solution for this. So in about two to three decades, you will see an update and you'll see this issue. All right. So let's move on to let's move on. That was passive aggressive
Dan DeLong:too.
Hector Garcia:All right. So we're going to move on to the solutions that we have built with right tool. There's actually two sets worth discussing. One is the free features in right tool that are related to journal entries. We're going to be focused on journal entries, a hundred percent. And then there's going to be three features, three pro features related to journal entry. So we're going to turn on journal entry, print. Export journal entry to CSV, journal entry balance visual, and show journal entry normal balances. Now I believe one of these two was was Mark's baby this was developed maybe two or three years ago. Was that the journal entry balance visual or the normal balances, correct?
Mark Corum:The normal balances as well as the journal entry print, but mostly the normal balances. The print was just more of some people asked for it, and I was like, you know what, I'll do it. And that was before we started working on WriteTool. Exactly.
Hector Garcia:So let's talk about those. So two, two actually were brought in from Mark's already pre developed idea. And then two were added in the process of Of right tool existing. Let's call it that. Okay. So once right tool is turned on and again, these are free, these are available in the free version. You don't have to pay anything. You're going to click on that little toolbox icon. I don't even know what to call that wrench and what's the best way to call that? Wrench and screwdriver tool. Yeah. Yeah. The wrench. The wrench and screwdriver icon. Sorry, my screen got zoomed in and I forgot how to zoom it out. We're cyber workers, not physical workers. Hold on a second. Okay, talk amongst yourself, my Mac went crazy.
Michelle Long:I was just posting on here. I love that it didn't work right the first time. Because when you're importing, I don't think it ever does, or it very rarely does. So I love how, you see the troubleshooting. Let me try this. Let me try that. Let's try this. Because a lot of times when you're importing data, it does not work right the first time. And you do have to troubleshoot until you get it correct, and so that is the process with importing data a lot of times. 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? 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,
Dan DeLong:And that's typically what is what kind of happens. A great point. 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? And once you have that, then it's like a, it's like an oil geyser, right? It's okay. Payday after that. So once you have that, things mapped formatted, or, something like that, then the payoff is going to be the countless.
Michelle Long:And that's where that Facebook group and the community and Mark and Hester are great resources to help. Hey, I can't get this to import. Can somebody help me? What am I doing wrong? You're not alone. That's one of the great things about having a community of your peers to help you as well.
Hector Garcia:Okay. I think I think I'm back. You can see my screen is working correctly. Yes. Okay. Okay. Yes. Give me one second. Okay. All right. So now we're going to click on the wrench and screwdriver. And then on the search settings, I'm just going to type journal entry. Okay. 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. So we're going to turn on extended print options, export journal entry to CSV, journal entry balance. And I think it was the normal balances. And that was like, I should not show him there. What's that? I have to change the. Change that right now. Okay. No, but I changed the text. So it actually says journal entry, not J E. Okay. So that's the search actually searches within the name of those. 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. So one is I'm going to go ahead and select a couple of accounts. So I'm just going through and writing a normal journal entry, the way I would do that. And then sometimes like we'll look at a journal entry and we'll forget for a second. Is this an asset? Is this a liability? Is this an expense? You have to go in and you have to look at that. And on top of that, you have to remember, which is a debit and which is a credit. 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. 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. 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. And I'm trying to increase my interest expense. 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. Okay. So now once you finish the journal entry. And or you try to save the journal entry. You should, you get an error saying the Davis and the credits don't balance. So the second feature that we added adds a little equal sign down here and it tells you how much you're off by. Okay. So it's just basically, so quick reminder, Hey, you're off by this. This is why it's not working. 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. So once you save. Your journal entry and let's just make sure I'll put I'll put a different account that's not receivable or payable. And then I'll save my journal entry and there's a couple things happening. Okay. So I got, I saved my journal entry. Now let's say I want to print this. QuickBooks Online doesn't let you print journal entries. So we're going to click on write to print. And then this is going to give me a new screen that we created. The right tool created that essentially gives you a quick preview of what this would look like. And you can save this journal entry as a PDF somewhere in your computer. So we basically developed our own version of journal entries. Let me bring it here so you can see what it looks like. In PDF format, you can print that again. This only works with with with tool enabled again, the free version. So you get to print your own journal entries. There's a setting that allows you to print it in landscape format. If you also have customer names, locations, and it's just not enough space. To have it in in in regular form in portrait portrait format. Yes. Okay. And the last thing here that we haven't covered. Okay. Yes. Export to CSV. So if I click on the export to CSV button all the way in the top it creates a CSV file for me. Let me bring this around here and I'm going to assume this in 200%. So you can see it and good news. Okay. This export, like the right tool, export to CSV exports, the account numbers in the actual format that would work via an import. So the built in reports in QuickBooks don't do that, but this CSV file does that. Why is that? Who in the world knows? We basically just copy and pasted information as is displayed on the screen. To be fair. I could argue either way why I want to see those account numbers or not. It's a different, it's a different issue altogether. 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. Okay. And then again, right here in the bottom is as a right tool print is to the left of the reverse button. That one's not red. Usually our buttons are red, but this is an example of a non red. To a button. One of the few that we don't put in red, they
Dan DeLong:don't let you touch the footer.
Hector Garcia:Yeah, the footer. It's just the contrast would be very difficult. Like it would be very difficult to put red and black. So the only solution would be to put an, like a print icon up there. 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. So this is working for now the right tool print. So we're not gonna. We're not going to mess with it.
Mark Corum:Okay. 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. And then go into the interest expense. Interest expense. Yep. Yeah. And then backspace all of it. It will actually, yeah, just delete it. 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. 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. So just a little,
Dan DeLong:a phantom total.
Hector Garcia:So a quick recap. If I want to adjust, if I want to adjust any of these numbers. I delete it, it should not delete backspace.
Mark Corum:It should backspace now. Apparently wanna do it this particular time for some reason. Oh, okay. I get why? Because it's debit. It's debit
Dan DeLong:needs.
Hector Garcia:Okay. Yeah. So if I, and the other cool thing is that if I delete. A journal entry with this feature enabled. I deleted journal entry line. 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. So it's not only in the bottom with equals is also on the live preview of any of the fields. It doesn't have to be like the last blank field or anything like that, which is awesome. Thank you very much, Mark for. For bringing that that feature in there. Okay. We don't have that much time, so we're going to cover as much as possible from the pro features. Okay. 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. And there is one more that yeah, in experiments pro reallocate in PNL. Okay. So we're going to. Click and save that. Then we're going to go back into QuickBooks online and showcase those additional right tool pro features for journal entry. So the first one that's probably the most obvious one to to showcase is getting rid of zero, zero lines. So like in this case, you see there's two lines with zeros. And of course. If you have one or two, it's quicker to just click on the little trash icon. But if you have a very long journal entry, maybe you import it, maybe you duplicated it, maybe you reversed it, whatever it is. If it has a zero, you just click on that button there that says clear zero value lines. And it somehow deletes the two for you. The, it just leaves them blank. But once you click on save. It should delete the lines out. So it leaves them blank. You click on save and it just gets rid of those lines. Okay. Many people had asked us to like the ability to resort in journal entries. We don't have that yet. We're still trying to figure out. 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. So we're working on that to see if that's something we can ever we can ever do. Yeah. And then the last final
Mark Corum:thing on the clear zero value lines, it also. Keeps whatever is the top line because this is actually a Megan Tarnow request. So it does keep the top line if it's a zero. So just be aware of that if you're using that.
Hector Garcia:Okay. 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. But she said, bottom line, if the top one's a zero, don't mess with it. Cause I might need it. I might need it just as an indicator or as a note or something like that.
Dan DeLong:It could be a use case for that to be there.
Hector Garcia:Yeah. Yeah. We should probably do a whole power hour just on like how journal entries behave in reports. 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. Okay. All right. So the last thing we're going to talk about is the sort of copy and paste feature. So imagine I'm going to export this journal entry really quick and the export. What's actually built so we can test the import. 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. So just imagine that you have your own journal entry. 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. We're our feature. We're probably not have any more need. 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. So I'm just going to make some modifications to this journal entry here. Okay. And and just assume for a second that we have a journal entry in Excel already and we used we use all the. Awesome features that Excel has like copying and pasting and find that replace and click and drag down. And we have information here, let's say about classes. 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. So I'm going to go here to save a new, so I'm going to start with a blank journal entry. And essentially what I want is I just want to copy and paste this. Into the journal entry. So I'll select everything in here, click on copy. Okay. 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. That won't work. Okay. Unfortunately, that's not how we did try that at one point. We did try that. We didn't try that. So we had this little button up there. This one doesn't have a label. It just has the standard copy icon. And you can also do control shift J. Okay. To access it. So you can either do control shift J or or click on that button. And then the journal entry pop up, the paste journal entry pop up will now allow you to paste in here. So now I can fully paste in here. So if I right click and click on paste now it gives me a preview of what's going on. Okay. If something doesn't match like for example if I have something that doesn't match, but it's approximate to something else. This will be in yellow. 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. And I'll let you know that you could check the possibilities. 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. Okay. So it'll just be black. 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. If you had an account that didn't match and then click on save, and then that would finish the journal entry. So we have one more thing to cover where we're actually on top of the hour. Unless we want to turn this into QB power hour 0. 25, we will leave a reallocate for another time. 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.
Dan DeLong:Yeah, just keep going. Last couple times we've we've run over if people got to drop off, that's totally fine. 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.
Hector Garcia:Exactly. YouTube, right? It's a YouTube. It's in the power hour power dot com website. So if you got to go, you got to go, we get it. But for the people that stay, this is going to blow your mind. If you haven't seen it yet, this is going to blow your mind. This is like truly revolutionary from the perspective of saving time. Like the few people that use this and it's very, it's sometimes a small use case. Few people that use this save hours and hours. Per month. And they have told us that thing is that it's maybe a small group of people that need this feature. So it's called reallocate for in PNL is currently under experiments, bro. This is where we put all the features are beta per se, this is our beta list of features. And this one, what allows me to do is it allows me to create a journal entry that reallocates. Amounts sitting in a class. location or customer project that has not been identified. Or one that has been identified as admin or overhead or quote to reclass in the future. 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. Any particular percentage that it's the way your business is composed. 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. So let's do an example. 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. I have an overhead class in this case, which is. Class where people were putting things under, but it's neither it's not new construction and it's not remodel. And there's also things sitting on not specified. Now I'm going to do something really quick. This actually makes it much easier to display. I'm going to edit these classes. So a new construction is. One and remodel is to get this just makes the demonstration a lot easier to display. So we'll go back and run a P and L by class. So now they're in order, right? Past one class to we have an overhead and then we have. They're not specified. Okay. And this, there's no limit on how many classes this can work on. Actually the limit is probably going to be a thousand lines in the journal entry. Whatever the math is of all the accounts, all the classes. But for now we've tried, we've had people try it with six, seven, eight classes, and it's worked just fine. So I'm going to start with overhead. I'm going to reclassify everything that's sitting in my overhead account. And I'm going to spread this across multiple classes. So I'm going to click on this reallocate button. That's to the left of the email button for the reports. Again, this is a PNL by class in classic, in a classic reports. I'm going to click on reallocate. This pop up comes up and the first thing that is asking me is, where do you want to get the values from? Do you want to get it from no class or non specified class or a specific class like this one called overhead? Give me one second. This was not showing the number. I wonder if this is going to be an issue. I just changed the name of these classes. So what I'm going to do is I'm going to do a quick refresh. Yeah, just because I just noticed that I removed that number. So I wonder if that's going to cause any issues. Maybe we'll see. So reallocate, let's get back to it. Let's check it out. 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. And right now this only works in P and L. We haven't even like. Thought about how this worked with balance sheet, but we're thinking about that too. And also you can choose the type of accounts that you want to see. 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. So that we'll pick only expenses. The only things that we're going to move we can remove account numbers if you want to. Again, this has to do with importing journal entries, all that stuff. So I'm going to keep the journal. I'm going to keep the, actually I'm gonna remove the journal entries. 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. And then it's asking me, how do you want to reallocate these? Okay. So we can do a couple of things. We can leave all the ones that are showing. 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. So that's 33, 32, 33, a third each. If I remove one of them and click on split evenly. 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. 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. Way of allocating. And of course, all this stuff is very discreet, discretional. As the accounting professional as a CFO, whatever. Sometimes you have a policy where you spread everything evenly. And sometimes you have a policy where you do some sort of proportional spread. Some of our nonprofit clients are telling us that they do spread based on Hours per employees per class. That's something you're going to have to calculate externally and figure out what those percentages look like. 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. So whatever this percentage is, you can export it. And again, it makes more sense when there's a whole bunch of a whole bunch of classes. So I'm going to, or a bunch of locations, whatever you're allocating. So let me bring this in to make this a lot bigger. So basically it's a simple template where it says percentage and class. 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. Okay just put the percentages there. And then with with that reallocation, you're going to click on choose file. And import that in. 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. So once you're done, you're going to have two choices. One, you can export to CSV and it basically just creates. A CSV file for us. Let me just zoom this in so you can see him this better. So this is option number one, just export the journal entry. Maybe the journal entry, you want to play with it in Excel or something like that. 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. I noticed that the classes are being shifted for you. And also we added notes. The notes are very clear, reallocated 35 percent to this class, 65 percent to this class. And then on the other notes as we are located from overhead or reallocated from non specified. So we pre added the notes for you. So you don't have to really mess too much with the notes. And then we have all the reallocation here. Remember, this journal entry is not going to affect your PNL. Your PNL is going to be the exact same net income. What is going to affect is your profitability per class, profitability per customer project, profitability per location. We're not changing our PNL without. These columns were changing the individual values within the cause, which is why is a journal entry within itself. It is a journal entry within the same account. 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. Because if you choose copy or clipboard instead of export to CSV. And that really should say, copy the clipboard and open new journal entry, but you don't have the space for it. So we click on copy to clipboard. Oh, he has so much
Dan DeLong:real estate in the button.
Hector Garcia:Correct. So it copies it to your clipboard and then gives you a pop up saying, Do you want to open a new journal entry? Which is typically what we're going to do. Then we click OK. It opens a new tab. with the journal entry for you. Remember that journal entry is now saved in your clipboard. Okay. So all you have to do is click on the, on that paste from Excel function I showcased earlier. And now then you come in here and you right click and paste. And now we're pasting this humongous journal entry. And then we click on paste into QuickBooks. And there's the creation of the journal entry. So
Dan DeLong:Michelle, she's clapping.
Hector Garcia:Yeah. So the first phase, the first part of the app is creating the other, the template for you. And the second part of the workflow is to actually save the journal entry for you. So you have, you, it has to be done in two steps. We cannot do this all in one step. Just, we API for that, or somehow create a bunch of delays and a bunch of macros for now. I think if you're. 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. But in either case, look, this is a super long journal entry, very precise. Okay. And then we'll just click on save. You can reverse the journal entry. You can delete the journal entry, whatever you want. 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. Then I go back into my PNL, I'm going to click on run report and essentially all of my overhead is now gone. 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. It works with customer projects as well So if you got customer projects, you can do that.
Dan DeLong:Michelle's face. I'm just looking at michelle's reaction They're like her jaw is literally on the floor
Michelle Long:God hector and mark. I just I love this. I love it. I love it. I love it. And I think of how much time this could have saved me for so many years and stuff. Oh my gosh, this is amazing. This feature right here alone is just worth it. It's incredible. You can sell just this one piece of this tool from BookuBox. Just that one feature right there. I absolutely love this. This is amazing. Michelle. 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. And how much time it's going to save. Oh, I love this.
Hector Garcia:Yeah. And what. Yeah, thank you. And worth pointing out. Okay. So we did this with a specific class overhead class. We can also do this with the ones that don't have any class. Okay. Now specify. Now, one thing I do want to point out, we are not going into every single transaction and splitting the transaction up for you. The transactions are being left intact. We're doing a full fix of this. We're basically, we're just doing a journal entry. We're cleaning it up for reports. Only for reports. Okay. Okay. And one thing to remember, and this is kind of something that we're probably, again, we probably need to save. A whole episode just to talk about how journal entries work. 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. 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. Over a hundred and forty people. Bonus power hour
Dan DeLong:plus
Hector Garcia:time. 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. Okay. Now ever since ChatGPT started existing, basically, and I started obsessing with it. I started playing with ChatGPT and trying to figure out if I can get ChatGPT to teach me how to code. Long story short, I didn't learn how to code but the chat GPT can write the code for me. 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? Literally, somebody wants to save this click save. And then reverse and then save. Okay. That was only two or three clicks. Okay. It's really not a big deal. I normally would have dismissed that and go, Hey person, don't be so lazy. Okay. That's that was like one tiny little click, but supposedly our ethos is. We'll save you clicks. We'll save you seconds. And that almost was a second. So like it qualifies, so I'm not going to bother. I'm not going to bother Mark with, Hey, go develop this button, this save and immediately reverse. So what it is, I went to chat GPT. And it's complicated. So I took the HTML code pasted in chat GPT and say, Hey, I'm trying to automate this process. I want to click save. I want to click reverse. I want to click on save again. I want to change the date. I want to do all these things. And then and then chat GPT came back and said, yeah, the code. Would look like this. 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. 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. Copy and paste that into the script section. So we come in here onto scripts. We click on add script. We paste the code. Again, you don't have to know it. 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? Tool. 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. I'll go bother Mark and Joel and Patrick, our development team and say, Hey. It looks like this is catching on. Let's build this into a hard code is into a right tool. 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. It will reverse and it will save again. And all this stuff happened without me clicking anything. 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. I told Mike, I want to play with chat GPT and a lot of the features that we have added. Has been because I play with it. 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. In the process. So that's the little bonus thing. I wanted to show you just
Dan DeLong:There's playground is what it is.
Hector Garcia:Correct. That's the play around. So I don't know if you want to run the last polling question and I'll leave. I'll let Mark point out anything that I may have missed.
Mark Corum:I think most of the time if you miss something I would point it out in the moment. So I think you're good.
Hector Garcia:And Mark, I'm very upset, Mark, that you interrupted me and you didn't let me speak at all. Honest to God, I was worried.
Michelle Long:Hector, do you even breathe? I don't breathe.
Hector Garcia:I don't breathe.
Michelle Long:You are amazing. He
Dan DeLong:can breathe in and exhale at the same time.
Michelle Long:You're amazing as always, Hector. This stuff is really great. You and Mark have done an amazing job with this. And it's just, I haven't seen it for a while some of these latest updates you guys have done. And I'll tell ya, I am very impressed. As a lot of people are saying on here, the latest stuff that you guys have been doing is just incredible. I haven't seen these latest things and I'm more impressed than ever.
Dan DeLong:And you guys have been nice enough to to offer a discount for pro for the QB power hour use community. If you use QB pH, when you activate the pro you will get a discount for that first year of using these features. So clearly. 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. Lauren said, worth every penny. Nice.
Mark Corum:Yeah just pricing in general. Very odd situation because we said, we don't connect per company, we connect per user. 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. It's a little bit more tough to justify So it's a hard thing to always get To get it. Just right.
Dan DeLong:All right, and Hector and Mark who appreciates you joining us and Donating your time here today. 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,
Michelle Long:all right, thank you everybody and dan as always thank you very much
Dan DeLong:All right. We'll see you next time on the qb power hour. Have a great day everyone.
Michelle Long:Bye everyone.