Modern Report View Updates in QuickBooks Online

Dan and Michelle will be discussing the Modern View vs the Classic View changes coming to reports updates.

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/

Transcript

Michelle Long: 0:30

Welcome everybody to another QB Power Hour. Today's topic is Modern View Reports Update. We're very glad to have you joining us today. My name is Michelle Long. I'm a CPA and an MBA in entrepreneurship, the owner of Long for Success, speaker for Intuit for, since 2007 until the end of 2023, early 2024, when Intuit is announced that they are disbanding, killing, retiring, whatever, ending the Trainer Writer Network as we all knew it and loved it. So that is great news. The end of that. So anyway, I also have an announcement at scaling New Heights that I'm having the first grand baby join our family next week on July 8th. That's part of why I'm going to the East Coast next week. And along with that, I'm retiring. Tiring. I am done. I'm hanging up my shoes and my speaker's badge or whatever. And I'm done with all this, but I'm still going to be helping Dan with Power Hours. You guys aren't getting rid of me yet. I'll still be joining in here because I still do love to talk. And I'm not going to leave Dan high and dry. I'll still be hanging around and chatting with y'all for a while.

Dan DeLong: 1:47

If one person appreciates that, it's me. But we appreciate all that you've done for the accounting industry over the course of your career and we understand that you life is taking some journeys for you and you want to spend more time with your family. And and we appreciate that and wish you all the best as that moves

Michelle Long: 2:11

forward.

Dan DeLong: 2:14

My name is Dan DeLong, owner at Danwith and School of Bookkeeping. Worked at Intuit for nearly 18 years. Co hosting today as well as the workshop Wednesday at the Britt School of Bookkeeping. And doing some tech editing duties on the QBO for Dummies. And just was asked for the QuickBooks All in One book series. Looking forward to that project as well. So a little bit of the details about the QB Power Hour every other Tuesday at noon Eastern. Our upcoming webinars, we are working with Makers Hub to be our CPE sponsor. So looking forward to having at least one each month to be able to eligible for CPE. And we'll, try that on the first of the month to make it easier as we go forward. You can always go to the website to Check out for check out upcoming events as well as QBpowerhour. com slash resources for the recordings, the PDFs, of the slides and other resources as well. Now, as we unpack and talk about the reports, which is, as I understand accountants love their reports. That's a core Offering or for service offering for accountants is the preparing of the reports and sharing that with your clients and getting insights into their, business. So modern, these modern reports changes are significant to, to accounting and accounting professionals. So if you have questions and concerns about that, please put them in the Q and a if you have general comments of. Just anything in general that doesn't relate to this particular webinar or topic that we're talking about, please put those in the chat, because there's two different ways to communicate with us. And then, of course, we also have the slides and the handouts there, which I will post in the Q& A and slides momentarily, because I cannot click and drive the slides and paste the links at the same time. Of course, we are simulcasting. It looks like we have a couple folks watching on Facebook groups or YouTube channels as well. If you are on the Facebook group, as we will put it in there, there is a QR code to allow Facebook to see the platform that we're streaming with so we can see who you are while we're streaming. While we're broadcasting, we also do have a QB Power Hour website, invite you to check that out as well. But let's just jump into it and talk about what we're going to be talking about today. We do want to recap. Some of the things that happened at Scaling New Heights, just to get an idea of of our perspective as we attended that accounting conference. And then we'll jump into the modern reports, changes and let you know what's happening with with the reports. We'll do some demonstrations, with some of those things as well. And then open it up for, Q and A. So let's first start off with our first poll. Which went somewhere. Where to go? Always a joy to find out. There we go. Okay. Did you attend scaling new heights? How many how many scaling new heights? I know they were giving like little, how many little pins that you could do Michelle, how many of have you gone to?

Michelle Long: 5:47

I have been to all of them except the one in San Antonio where I had a surgery that year and Joe gave me a pass because it was something I could not avoid. And so he still says I attended all of them. God. Yeah, he says I've been to them all.

Dan DeLong: 6:08

Okay. When I launched the poll this is actually the first time that we've had 100 percent participation in any poll. But when I launched the poll, it looks like more people came in and started attending the webinar. So we have some more people who came in while the poll was launched. But, of the folks that we're available during the launching of the poll. Everybody answered, which is great. It looks like about 10%. Went to the conference and about 88 did not go. We wanted to recap some of the things that we experienced. There was some really good. It, was long and short at the same time, which is, do you find that's the case for these conferences that you go to, Michelle, is that it just whizzes by, but then as you're doing it, it's wow, this is four or five days of of attending.

Michelle Long: 7:10

It, yes, it is. It seems oh my gosh, it's so exhausting but then you're like, oh my gosh, it's over already and it's amazing how you can go through a conference like that. It's going to be like, oh my gosh, I can't believe I didn't see you. Somebody was there, but yet you're like, you didn't run into somebody. But yet there's thousands of people there, and so it's a small event in some ways, but it's a big event in other ways. So it's, it is really a great event. And I loved hearing from so many people and seeing their posts online about I went 10 years ago and it changed my life, so for a lot of these people, it really helped change the trajectory of their practice. And their life and it helps really make a difference and an impact and I know Dan, you can speak to that from after you had left into it and you were I'm going to start my own practice, but I'm not really sure what I'm going to do. And Hector and I had talked about, Hey, Hector wants to do his own things with his webinars and start charging for them. And I didn't really want to do that, but yet I didn't really want to do power hour on my own. And I needed somebody smarter than me with that technical knowledge. And I wasn't sure what I was going to do. And. It's amazing how all of this kind of works out but going to these conferences, it's not just the things that you learn, it's the networking, and it's the people, and it's what goes on at lunch, and at dinner, and in the hallways, and at the bar, over some drinks, even if you don't drink but it's all, it's just all of the relationships. That you develop over the years and I'm going to cry and that's why it was so hard for me to tell people this is the last conference I'm probably going to because of all of the relationships and all of those people that's what really makes a difference. And that's what helps you grow your practice and that's where a lot of people realize, even though you have a practice as you're on your own. You're not alone. There's a whole tribe of people out there and that's where the Facebook group is so amazing as well. You've got this whole group of people to support you. So I think it's incredible.

Dan DeLong: 9:28

Yeah. It's it's really the, tribe of choice, right? When you go to these things and you're able to be, get some face time with people that you, Either just rarely, barely get to know or, you know of them. And and that's what's really neat for me going and supporting you and your classes that you are teaching and actually sitting down and, learning a few things from, people that you, see what they're up to, and then actually getting to to get into The whole nuts and bolts of what it is that they do. There was some great, main stage sessions and some of the, the whole thing about quantum computing and changes that come in those were types of things that kind of means that the accounting industry is, going to be disrupted whether we want it to or not, and then that's what I wanted to cover on this one. Is that technology is evolving so fast. One of the things that I was thinking of is is there a world where in, in accounting where that doesn't involve QuickBooks, right? A lot of people are, frustrated. I think that's the nicet way to put it, where the changes and the direction that Intuit and QuickBooks is heading. Is that, is there a possibility where, it doesn't involve QuickBooks? And that's where I was going around the exhibit, hall that there was, I was going to say exhibition and exhibit at the same time. Going around the exhibit hall, seeing the other ones. And of course, Intuit wasn't present because they have a policy of not attending conferences where they're not the only accounting platform there. They really didn't have to attend because there was plenty of QuickBooks logos all over the place for those exhibitors that Do integrate with QuickBooks. And so I was thinking like, would, accountants, use this as an opportunity to talk to zero or talk to accounting suite or talk to stage? It's okay, where is where is my breaking point when it comes to that? And coming from the Intuit culture and the Intuit ecosystem, QuickBooks is all I know. And I think that's very scary. I think it's to say the least of, what else is out there? Do I have the time, the energy, the effort to be able to learn something? And I'd be kidding myself if saying that it's perfect. The grass looks always greener on the other side, but really, in reality, the grass is greener where you water it. And, and it, and if if you can put some boundaries in place we use a landscaping analogy put some borders between where that grass and the weeds intersect, I think that's a better place for a lot of people, but some people are taking that exit strategy or, this is a a happening or a trigger event. That's the word I was looking for of doing something else, right? Like maybe it's, looking into fresh books or something like that, because the pricing of QuickBooks going up, maybe that's pricing them out of the clientele that they want to work with, right? And maybe there's another platform that actually does that. One of the things when, I was watching the digits, CEO on the main stage, that was starting, that was where that, that, that thought was coming from. And I went over to the, booth and I was talking with them and we're going to try to have them on the power hour as a, as a guest, there was a word I was looking to talk about the things that they were. Working on and that's where, where we're at this point is, technology going so fast that Square will have its own general ledger or other needs, other applications and some of the conversations that I was having with people about this topic was that quick, accountants, bookkeepers, practitioners, they really need something that they know and that they, can work with, and trust. And that those three things are, the caveat of all of that. If, that's QuickBooks, great. If that's Xero that's fine too. Whatever that happens, if it's Excel Spreadsheets, or as you were saying before we started, Lotus 1, 2, 3, right? Whatever you can, hold on to and use to, to prepare your your services, that is what. Make sense in the long run. What do you think, Michelle?

Michelle Long: 15:01

I agree with you that I, do hear more and more people that are looking for alternatives and things. And I do think there is a place for a scaled down, easy, just core general ledger, something with apps doing the work. And I was very impressed with digits last year, even more impressed with digits last or digits this year. And I would love to get them on. And I love Jeff. I can't remember his last name. I think it was Jeff something or another, I think was his name. But yeah, amazing. Amazing. If there's one app you guys are going to check out, Digit should be it. I think it is just incredible, but yes, I do think there's something to be said for that. And I think that's what QuickBooks online was supposed to be, to begin with was the core and then have apps that integrate with it. If you keep it simple and have the apps do all the heavy lifting, and I think they're in some ways getting away from that,

Dan DeLong: 16:05

right. Yeah, it's always this ebbs and flow, when it comes with Intuit and QuickBooks, their centralization having everything in one platform, which is, I think when you look at the desktop space with enterprise running payroll Job costing reports, inventory management, all of those things, for the, most part can be done in, inside of the QuickBooks ecosystem, inside of the company file, so you don't have to have these extra things. So there, there is a, an ebb and flow of that, where it's either All these things are going to be existing in apps that feed into QuickBooks, or some of these things are going to be inside of QuickBooks directly. And one of the things that I really it dawned on me a little bit coming from a non accountant accounting space, is when Joe got up on the first day and started talking about client accounting services or client advisory services that, that really could be divided into multiple classifications. And there was really a timeline associated with that. Like accounting and bookkeeping is more of stuff that happens in the past. Back office processing where you're doing payroll or sales and use tax or sales and local tax, accounts payable, accounts receivable processing, that's more of a present. Service offering and then the things that are future based, like the financial planning and analysis and the fractional CFO services are future based and the more that you get into the future with regards to the services that you offer. That adds a greater value to the services that, that you can charge for. And I, I was, as he was talking and unpacking all of that, I was like some of the things that I do are sprinkled across all of these. And here I am doing things more on the. On the accounting bookkeeping, because in my, mind, I want these things to be automated so that I just manage the data when they're outliers, like a, like an exception report type of thing. and, and, yeah, I find myself a victim of my own scope creep. When I, was looking at that what what has been your experience in your long tenure of those types of things, Michelle?

Michelle Long: 18:44

I totally agree with you. And I think the data management is definitely it as far as now and where we're moving forward. And yes we, definitely need to start focusing on. You know these higher level services and stuff because that's what's being automated Is the lower level and everything and that's where they were talking about the ai and what they're doing and everything And it's getting to the point where we're not even going to be doing bank cracks because it's all going to be automated You can see now where QuickBooks is even starting to put in the bank statement ending balance and statement ending date and stuff. It's even going to be reconciling that bank account for You Where we're just going to get a flag if something goes wrong and it doesn't happen. Data management is a key and that's where the financial planning and analysis fractional CFO. And there were some great nuggets of information in there. And one of the best and I just want to share this because it was so impactful and really, I'm going to leave this with you and let you think about it afterwards and then we got to get to reporting. But do you remember Sully and the plane that crashed into the river up in New York, right? So you remember the plane? Okay. And I don't remember the exact details, but it was an interview with somebody and they were talking to him about how he How did he crash the plane or whatever? And he says, I didn't, he says, I, he says, what was it? He successfully crashed the plane. And we were talking about AI and is AI going to take our jobs? And the key thing to think about is Sully knew they were going to crash the captain of the plane, knew they were going to crash. This airplane is going down. Sully thought. I'm going to crash on the river to try to save people's lives. So he thought of an option to successfully crash the plane. So he didn't successfully land the plane, he successfully crashed the plane. AI cannot do that. AI can only do based on what has been taught from history. Sully and people, us, have the brain to do the financial planning and analysis in the CFO work. We have the brain to come up with the ideas that have not been done before and to come up with the things that we need to interpret the data. AI can't do that. AI can only look at it and tell you what's been done before. That was profound. So stop worrying about AI twice as much. I love that. Think about that later. I thought that was great.

Dan DeLong: 21:41

And the other gentleman who was talking about, the fact that when you ask a machine for an answer, it has to give you some kind of answer, and sometimes that answer is just made up based off of all that it knows at the time, right? Yeah, that's the Mexican air.

Michelle Long: 22:01

Yeah, hallucinating. The rest of us call it bullshit. Yeah. They call it hallucinating. We all call it bullshit. But yeah, just make something up.

Dan DeLong: 22:13

You're definitely on the road to retirement with your loose lips now.

Michelle Long: 22:18

You just broke up, and I didn't hear any of that, but I'm sure it was, all

Dan DeLong: 22:23

Let's get to let's get to the reporting. I have another poll of how reliant are you on reports? We'll throw that pull out there. Do you use all the reports that are inside of QuickBooks or maybe you use some other reporting app because it. Report consolidations for multiple entities, or maybe you don't use reporting at all. It's not necessarily in in your scope.

Michelle Long: 22:54

And this is where, as we get into the reports and everything, if you're not using reports that much or anything, this is where, my goodness, this is the key. This is the payoff for why we do all this accounting and stuff and everything. I know the IRS says you have to do it and everything, but. This is really the key. This is what helps the owners and the management run the business, make better business decision and everything. So we really, if you're not aware of all the reports that are out there and what's available with the new reporting and all the new capabilities that are available, the new charts and graphs that are available and everything you really need to get in there and dig around and play with it. Go into the sample companies and stuff because the capabilities that we have now are really a lot more powerful and they're great reports that you can make available for your clients. And get some of that management attention by using the charts and graphs and stuff and putting them right in your management reports. So great stuff that's out here.

Dan DeLong: 23:59

And looking at the, polling here. I'm going to go ahead and end it here so I can share it. Yeah, it looks like a 74 percent of the folks who responded do all their reporting from inside of QuickBooks. This this news and the things that we're going to unpack here today about the modern versus, The classic view is definitely impacting them and will because as we're showing here on the screen, by the end of this year, 2024, this is, of course, looking in the future and we're, that's six months from now, a lot of things could change between now and then, but as of today, July 2nd. The plan is by the end of the year, 2024, all reports will be only available in the modern view, into its credit. They started this process late last year and because of feedback decided to take a little bit more time and and roll this out in, in waves. So the first batch that's going to be in this modern view makeover is what I'm seeing here class list, location lists. Most of these here are lists, which are not necessarily transaction based reports. So good news there is that they're, just really listing reports of lists to get us familiar with the reporting functionality in the customization. Where did they move the cheese as we, as I like to say if we're mouse mice in a maze and the cheese gets moved that's what's really happening here with regard to the changes of the reporting. So the class list, location list, the open invoice report payment method list, physical inventory worksheet products and service list, sales by location, the detail report. So that's the actual transaction based report, the terms list, and then transactions list by customer and by vendor. Those reports are getting, are in the first batch. Now, and then they'll move on to the next batch. So you'll see at the top, if it's one of those that can be toggled between, you'll see this, which the classic view button at the top or be able to switch back and forth between those. And we have in the slides, we do have links to a, to an Intuit article that, that lists. All of the reports, which are the reports that are only in the modern view, which of the reports are the only in the classic view and which of the reports can be toggled between the two and we'll demonstrate some of those as well. But that's something that is, that's what's happening right now. The modern report view or the custom report builder. We want to talk about this a little bit because this kind of started. Once QuickBooks Online Advanced introduced the custom report builder. And when I first saw the custom report builder, I, my, my initial feedback was like, Oh, this is like drool worthy for accountants and bookkeepers because of the way that you can, the things that you can do that classic reports didn't allow you to do. But we want to talk about, and you'll see in some of the articles where we're into it, we'll make claims that, That could be a little confusing because custom report builder is only QuickBooks Online Advanced and then there's going to be some features and functions that are only in QuickBooks Online Advanced. Online advance, but they talk about some of these things like and give the impression that if you have the modern report view and simple start, you'll be able to update a report from Excel. That's not the case from what we see today. Now, that may be different later, but as we see it today, you're going to need to use spreadsheet sync in order to do that. Though. That's only QuickBooks Online Advanced, right? So just wanted to separate those two. Modern Report View is going to be available in all versions, and you're going to have the report customizations to mirror that custom report builder on existing reports with the hope that it's faster loading time, and you can add all these reports to management reports which will be all across all versions. But the custom report builder and the functions that you'll see in QuickBooks Online Advanced only is going to be things that are going to be dealing with the spreadsheet sync integration. So when you go to export and you want to see that in inside of QuickBooks or Excel, excuse me, then that's going to require you to be on QuickBooks Online Advanced. Obviously if you're looking at the new revenue recognition reports or the fixed asset reports, those are features only in QuickBooks Online Advanced. So you're not going to see that in your other versions of QuickBooks Online Plus or Essential because those features just don't exist. But the articles don't explicitly call that out. And then the function of a pivot table. Is only in QuickBooks Online Advanced, on the reporting itself. Now, if you send it to Excel, you can add your pivot tables all you want, right? So here's this, but I like ClassicView. Like I've we're being on the other side of the Intuit phone system and being the receiver of feedback from from accountants and bookkeepers and practitioners and pro advisors. We hit, I heard this a lot, right? Anytime that there was a change, we heard from the people who liked it the way it was, right? This is not the first time that reports have got an overhaul. And every time there has been this resistance to change because nobody likes change better than accountants. That's sarcasm. And especially when you're dealing with Something that is so such a core functionality or of, your practice with reports. We talked about 74 percent of you only use QuickBooks reports as, your method of reporting. So that's, really invasive to your everyday life. So I certainly can understand that, but why make this change altogether? This is a huge overhaul, right? So this is a huge change and a shift in, in reporting. But it was built on older technology. The classic reports are just built on older technology. So here's what we wanted to talk about. And I threw a picture of Annie Oakley up here because of all the, anything you can do, I can do better from Annie, get your gun, if you're music theater people, But what, does it do? The classic doesn't do. This is, of course, an ideal state. We are in this period of time where things don't work in that ideal state and feedback is going to help get us to that ideal state. And this is terribly frustrating during this time period when your, work is going to be impacted by this because of, the impact of recordings. But the ideal state here. Faster loading time for reports. So great. We'll save seconds or however long it takes to generate those reports, user permissions are going to be able to be, more in depth. With when it comes to the access of reports. If you think about QuickBooks Enterprise, where you can get into the minutia of the different types of reports, this will allow QuickBooks and Intuit to be able to enhance those user permissions to be able to assign certain areas of reports. And, you'll be able to immediately preview or see the customizations before saving, the report. You have additional customization options like the advanced filters the data pivots, charting the data, turning it into a chart. The ability to bring in new data from QuickBooks Online or other products into a report. That is the goal of the future state of all of this. New reports like the fixed asset revenue recognition and project reports that are in QuickBooks Online advance. And then the ability to run reports from Microsoft Excel, directly from Microsoft Excel when you're using the spreadsheet. Again, we're gonna be talking about that in, as it relates to QuickBooks Online Advanced and the ability to add any report. To management report. So as you create your report packaging, you can create and customize any report and put it into the management reports. So how will I tell which one which view I will get? So when you're looking at the report list, you'll see this little magic wand that will give you an indication that it will be on this new enhanced experience or the modern view. So if you see that icon next to any report. That is going to open up by default into the new modern view. And you may have if you're in this race period where where it hasn't been completely part of that batch yet of turning into modern view only, you'll see this switch to classic view at the top. So the, you'll have that ability to to change it back and use what you know, rather than learn something new. But, the, customization is going to be broken down into three major areas. You've got the, general customization, the filtering, and the grouping. And we'll talk a little bit about that, and then Michelle will give us a nice demonstration on what what you can do inside of that as well. But the general customization is where you would set your basis. You can drag to reorder the columns you can poke the eye to hide it. And you can really frustrated into it. You can poke it as hard as you want. But this is where you put in your general general appearances, like your number formatting, the aging, the header and footer information. One thing that I did notice and talking about this with and looking at the Facebook group is the one thing that's not there is the note you could add notes in the classic view and appear at the bottom. Please put in feedback about that because that wasn't the footer. Of the classic view about that, the groupings this is one of the things that I think is really cool about the new reportings is the ability to add groups and basically create subtotals within the reporting itself and you can add different group calculations to calculate total averages or percentages based on those numeric numbers. So this is one of the things that will. When I first, again, when I first saw the custom report builder, this is pretty cool. Because that way you don't have to always send it to Excel and then have Excel do those subtotals and those types of things. So now you can do it directly or should be able to do it directly within within QuickBooks with regards to the view. And then this one of the filtering is is fantastic because one of, one of the things that Classic View didn't allow you to do is filter for something and then exclude it and Michelle will unpack that as well, but you wouldn't, you don't have the ability to find some one thing and exclude it from the report. Now you can, with the filtering and you can add multiple filters. For for all of those things and add additional and or, conditions to those filterings as well. So these are the filtering and the grouping, I think is a fantastic add to that. So we've created some resources and links. We were supposed to have Keith from Intuit joining us here today, but I don't know where he went. Ghosted me a little bit. But so I hope he's okay. But he is in the UK and I'm sure there was a time zone issue or something like that, but he had created a lot of modern view training tutorials on loom. And we, provide a link to that as well to help ease the, challenge of how do I do this from classic view to, modern view, and he's done a great job of creating those tutorials. There is a list of reports that are in modern view and those that are in classic view and those that can be switched between, and then a resource there on how to customize those reports in modern view. So real quick, before I hand things over to Michelle. I had where to go. There we go. We go. I ran. An invoice listing report, in this is the exact same company the exact same, report, in, QuickBooks Online, and I have them just being side by side comparison. Now this is inside of a QuickBooks Online accountant. So you'll see this pivot, and some of the extra things that you can do inside of QuickBooks Online Accountant that just wouldn't be there if you are in a Plus or Essentials, but this is where you can see that switch to Classic View and then scheduling the reports, adding it to management reports as well as exporting it. And then this is the run report and sync data in Excel is going to be taking you to down the path of, spreadsheet sync. And that's where you would see that as a, as an option as well. But of course we have our classic view over on the other right over on the other side. One thing that I really like about, whoop, I didn't like that, oh no, there we go. Is the resizing of the report, right? So the width of the report in classic view, depending on how many columns that you have can certainly extend off the slot off the side of the page and then, of course, now I don't have any data there because I went back, but it is, now that I've said that, I was I thought it resized everything to fit on the screen but the, sorting is right here on the column. So if you want to see things by the, due date you can just sort on that, which in over here, if you wanted to sort by that, you have to go up here and find the due date. It's never in alphabetical order. Where did it go? There it is. And then, what is ascending order and descending order? I can never remember with dates. I get a 50 50 chance to do that. And of course I picked the right one. Yay. Alright, so, those, that's a good way to get used to this This classic view versus modern view is run the report side by side and, see what you can do between the two to get yourself familiar with that. So I'm going to stop sharing and pass it over to Michelle, because she has some some demonstrative things that she was going to show us all in Scaling New Height, but Unfortunately, she was having some technical issues, and the

Michelle Long: 41:29

consummate,

Dan DeLong: 41:30

the consummate the consummate professional, I was so impressed with the way that you handled that for those that, didn't didn't attend her class, two hour class, and half of that was taken up because of a technical issue, and her whole presentation was mostly demonstration. So it's really hard to be able to demonstrate something when when you can't see it and the professionalism that you had, I think it was fantastic to see. I don't think anybody under those circumstances would have handled it as well as you did. So I appreciate everything that you. Had to go through there and I wanted to give you this opportunity to redeem yourself.

Michelle Long: 42:15

Thank You That's happened twice in all the years that I've been training for Intuit, I should say and I started in 07 for Intuit and twice have I had to go a extended period of time without the visuals without the slides and the screen working and an extended period. I'm talking more than five or 10 minutes. This was like 30, 45 minutes, oh my gosh. And when we're talking about 150 of my closest friends in there, it was awful. Anyway, thank God for Randy Johnston in the back of the room. Those that you don't know him, he's 140 years. Yeah. Thank you for stopping by the zero, but they, I good stuff. You guys haven't checked them out in a long time. Check them out Anyway, all so here we are in i'm going to move that off over to here. Here we are in a Custom report. Okay. So and let me just show you for those of you that haven't worked with custom reports yet You can start totally from scratch. If you have, let's say you have a sales rep or manager or somebody that comes to you and they give you a sheet of paper and they say, I don't see a report that has this and this, right? So they've got these columns going across these columns going down. You can do that. You can start by total blank slate here and totally start from scratch if you want to. You can come over here and search by sales and other transactions whatever it is you're looking for, journal entries, transactions, products and services, lists. You can start from blank over here. Sales, transactions, expenses, whatever. Totally start from scratch if that's what you want to do. Or, if you want to go back to your reports and you want to start with a template. Then it's got templates for you that you can start with. Yes.

Dan DeLong: 44:13

I think we're looking at your training QBOA screen I don't know if that's what you were showing.

Michelle Long: 44:18

No Thank you for sharing that you're not seeing what I wanted to see so let's stop the sharing

Dan DeLong: 44:27

Take two.

Michelle Long: 44:29

Take

Dan DeLong: 44:30

two.

Michelle Long: 44:32

Let's just do. Now let's see. I want you to see the entire screen.

Dan DeLong: 44:41

Michelle just got a brand new computer. So she is, doing all these things for the first time on this brand new computer. Another

Michelle Long: 44:51

there

Dan DeLong: 44:52

we go. Now. Yeah. Okay. So what are

Michelle Long: 44:54

you are you saying create new report?

Dan DeLong: 44:57

Yes, ma'am

Michelle Long: 44:58

Blank. Okay. So what I did is I click here under the report. I click create new report Thank you, Dan create new report You can start blank and that's what I was trying to show you is coming here And you click start by adding data columns. You can totally start from scratch if that's what you want to do. And I know there's people that want to do this. They're like, I just want to start clean and you can come in here and you can choose your sales and things from your sales transactions or other transactions. And that's where it's trying to show you, you can get journal entry, transactions, time, transactions class vendors, product services, list type of things. So you can come and start from scratch or. You can come back here and say, create a new report and start from a transaction list from sales transactions invoices. And this is what's great is if you start by invoice. And then you come in here and it gives you something to start from and then you can start customizing that By coming out and clicking, you know add columns and stuff But i'm going to go ahead and go back to reports and pick one that I already have started out here for example, I have sales by customer detail power hour demo because I've already put a bunch of stuff on it. That's the demo. As Dan mentioned to you, he already showed you a few things about different things. Let's go on in and let's go at our column. For example, because this is the meat of it, those columns that you're adding. Watch as I come in here and take some things off. For example, the product and service column. If I unclick it, It'll take that right off of there. If I wanted to add that

Dan DeLong: 46:44

The fact that it's immediate and it's contextual is really great, because one of the things that was challenging, sorry to interrupt, but I wanted to get it while, strike it while it's hot. One of the challenges of the classic reporting is that you really didn't know what filters that you would have or the columns that you would have available to display and the modern report that Will be contextual. So as soon as you choose a specific transaction type, if there is something that you cannot choose because of the way that you're bringing that in, it will just gray those out so that you can't select them as a call.

Michelle Long: 47:25

And I wanted to show you how I could search to bring that back up. I typed in product for service and it then would bring it back up for me to search for it. So when I started typing product, it would allow me to search over here and I find it other transaction in line item, it'll highlight it. And allow you to come in there and find, and then I can click to add that back. And I don't want skew numbers, so I can take that out. So you can come in here and drag and go through here and click on these and get whatever it is you want. And then I started to talk about dragging and dropping. Let me clear that out of there. When you get in here and you see the ones that you have. Let's go ahead and come back. So I've got all my different columns out here. If I come out here and I say, okay, now I see what I have. I really want to rearrange some of these. I want to see the broccoli preference in these carrots and carrots high right up in the front. And I really want to see the sales person up at the front too because that's important to me So you can click and drag and drop the grid box over here I don't know what the official name for it is. I just call it a little grid box You can move these and notice happy fun ball Broccoli preference. Do you all have those fields in your files?

Dan DeLong: 48:47

I don't think that's a default, preference I don't

Michelle Long: 48:51

think most people have that right Those are custom fields that we have created in QBO advanced. You'll see I have those over here broccoli preferences on my sales receipt and my invoice and various different Transactions once in a happy fun ball I'm not even sure what it is, but we've got it. And salesperson, when you create custom fields and QBO advanced, you have 48 of those that you can create and you can indicate if you want them on different transactions and if you want them printed or not, once you've created them and you have them on those reports. And now I got to go back to that report I had. It should have kept it up, huh? You can then customize those things. And I didn't save my customization. So it goes back to my default. You, the point is though, here's your broccoli over here. You can create custom fields for those. And let me go into one of these invoices that has broccoli on it. You can create those custom fields and now that I have that custom field I have that Field on a transaction I can filter for it on a report and I can get it out So i've got a broccoli preference a salesperson and a project manager And I can even have tags out here now. We created a custom field tag But I also have the real field tag down here And I can add a tag like to be power hour. We were talking about tags in the chat over there and you can filter for tags. Okay, so what I wanted to show you, so that's your columns. You get the idea. You can add and remove any column you want. You can sort by those columns and all that stuff. Your general options are just pretty in and out, customizing it round off by thousands your negatives, all the little customization stuff, editors and footers, things like that. But the power comes in here by filtering and by grouping. I can filter by salesperson, and here's where Dan was saying it is empty, it is not empty. It equals or it does not equal. Let's say you're looking for particular things. You could do that, but then you could also add a condition. I'm looking for the sales person maybe I'm looking for a specific sales person, or I'm looking for, it's not empty or ones that are empty. It didn't get assigned a sales rep and I want to go find those transactions so I can assign a sales rep or the sales rep and the broccoli is. Is it empty or not empty or does it contain the field of yes, And this is where though you can have multiple criteria out there Then I can also filter by those or i'm sorry That was my filter, but then I can group by those things and you can group by Let's say oops. What did I select? I didn't mean to do that group by a broccoli preference and you can total by those Edit group calculation You can total by the balance of your broccoli people, but you can total by the sales rep, you could total by sales rep, open balance. You know for whichever total or something but you guys get the idea of how complex you can get So you can add the columns you want you then can filter for specific names You can group them and here's a good example Let's say you want to look at all the open invoices and you want to filter the open invoices by sales rep So they can follow up You can then group the open invoices by customer for that sales rep and total them so the sales rep can follow up with all the customers that have open invoices. So here's just one example, and then you can also schedule this report to be sent on a regular basis. You can email it to somebody, you can add it to the management report. So you can add it to an existing management report or a new management report. Okay, so you can choose which management report you want it to go to. So you can choose where you want it to go. We've got one out there and just add it in there and that's going to be out there. You can also export it or print it. You can also save these things as a customer report. Look at them as a table view. Check this out. Chart view. Vertical bar, trend line. I used to have to send this stuff to, I had to save the report, copy and paste it into Excel, and then link it and make these charts and graphs. I used to have to do all kinds of work to make these pretty little graphs for my clients. Look how easy this is now. And you can do more customization over here and all this stuff This is so nice now and look what you can do with these charts You can export that as a png if you wanted to put it and do some other things with it And you can add this to the performance center To put it like on their dashboard if you wanted to do that for your clients as well because over there on the dashboard you can do that if I remember right you used to be able to add it over there but if not under the report and in their dash under their performance center over there. If I remember right, report.

Dan DeLong: 54:23

Got to sneak up on it.

Michelle Long: 54:25

Yeah, it's in the performance center. In there, you'll see here's the sales work thing that I just did. That little widget right there. And then you can do a little of this. You can move it, add it to the stuff out there. Anyway, that's some of that. We're out of time, but let's just share this real quickly. Your spreadsheet sync. Is so powerful. You can not only do reports over here with a live link to the data. Let me repeat that a live link to the data. It will automatically update when you update QuickBooks. It's going to update. This is only in QBO advanced. But you can run individual reports like we just talked about. You can add and edit data. Let's say somebody imported bank transactions

Dan DeLong: 55:17

to

Michelle Long: 55:17

the wrong bank account. You can change the source account. Using spreadsheet sync. That's one example of something you could do. You can do multi company reports. If you have a group of companies, such as in this example, I'd have to log in again. If you had a group of companies, only one company has to have QBO advanced. The other companies can be using Essentials, and you can run a multi company report. You can also do budgets over here now as well. You can do your budgeting in Spreadsheet Sync. So this is very powerful now your Spreadsheet Sync capabilities that you have. Dan, Five minutes left three minutes left.

Dan DeLong: 56:07

Yeah, I wanted to launch the last poll, which is after this webinar. Has your opinion changed to this topic? Probably coming in. Like, why are they doing all this stuff? Or I wasn't too impressed with with anything that was shown, but I want to. Throw that out there. I think one of the things, and you were, as you were talking about the, filtering, 1, 1 thing that's just gloss. You glossed over there. You can change the. When you're adding additional filters, like a filter 1 versus and adding another 1, you can change it from an end. So it can be all inclusive by choosing the operator of, or, not just on the filter itself, but in the condition that you're specifying now, these reports always don't look the way that we had hoped them to, right? So I know I've been trying to make a report in the class or the custom view or the modern view for a client. And I know what I want to get and I know why. And I know it's, it should be possible, but it's still not showing up the way that I would hope it to, please provide those, that, that feedback like Hector and, Alicia say on the unofficial QuickBooks podcast flood with feedback because they're not going to know what they need to fix, unless, they know they need to fix it and, feedback is the way to do that. I know that is a. That's a lame, I hate hearing it, from the outsiders perspective, but, It's it is the only way that they're going to know and that feedback needs to be actionable you know rather than just saying this is great or this sucks you know providing steps to duplicate the challenges or you know providing a video. I know keith posted a request on the qb power user facebook group that he was looking for people to be able to You know follow him Get in depth and in the weeds with this sort of thing. As into it offers these kinds of opportunities to be able to provide, the feedback just bear in mind that just because the feedback is given doesn't mean that they can create. An actionable option as soon as you as soon as you provide the feedback. It does take some time to sort through prioritize categorized and then make an action plan and and that sort of thing michelle any any closing thoughts here as we're wrapping Today's webinar

Michelle Long: 59:05

I think the most important thing is get in there and start playing with it Especially, you know on those reports with the spreadsheet sync you I if unless they changed it You couldn't play with the spreadsheet sync in the sample company file so use it, you know with another company if you're just doing reporting don't send transactions back in a real company file but you can play with it with reporting stuff and things like That's the best way to try things out is just get in there and play with it

Dan DeLong: 59:34

Exactly. So next next time on the Power Hour, we're going to be talking about some of the the QBO updates since the last time that we've had a session like that. And then we'll take some common questions, concerns from our Facebook group and walk through those as well. So hopefully you have a wonderful holiday weekend. Don't lose any appendages by setting things off, but eat lots of protein. Hamburgers, burgers, hot dogs would be great, ribs. Ribs are on

Michelle Long: 1:00:08

the agenda.

Dan DeLong: 1:00:10

All right, and we'll see you next time on the QuickBooks Power Hour. Hope everybody has a great day.