Master the Top 10 ChatGPT Plugins to Elevate Your Accounting Firm!

Okay, let's get started. Let's get started. So, for all you new people, welcome to the live stream. We have these. These are 60 minutes exactly. We'll finish on the hour and I will have a couple of short announcements to make. Then we'll get into the content for today, which is all about ChatGPT and specifically ChatGPT plugins. And what are some of the best plugins for accounting firms, for accountants, for bookkeepers. That's what we'll be talking about today. I also though have time to answer your questions about ChatGPT. So if you have any questions whatsoever, please just ask. To ask a question because you've just seen, perhaps the chat goes mad. Just put two capital Q's in front, put qq, then your question, then a question mark. It just helps them stand out so I can answer your questions. Also, don't leave it till the 59th minute to ask a question because I go through them in the order they come in. So sometimes I don't get through all the questions. If you leave it right till the end, I might not be able to answer your question. So the sooner a question pops into your mind, please just ask. I will try to answer as many as I can. Hi there, Greg from Colorado over on Facebook right now. Normally at this point, somebody does put in a dummy question with two qqs, but if that crops up at some point, I'll pull it up on the screen so you know what what a capital Q is. Anyway, I normally have. Lisa is normally here from the UK who normally does that for me, but she's not today. I wonder where Lisa is. She's missed about one session in three years. Okay, one. A couple of quick announcements. Oh, and I can see it just coming in at the moment. It'll just need my screen to refresh and I'll be able to show you Sarah just posted in a dummy question. Here it is. There you go. Ask it like that. Do you have a question with two capital Q's in front? And yeah, there's Sarah. And I'll see that. Okay, first quick announcement is those of you that come regularly will know that one of the things we do is we want to help make the world a better place. And we always make a contribution on your behalf to a worthy project somewhere around the world. And we're changing the way that we do it. This time we do it through B1G1. Amazing organization. Many of you know about B1G1. The way we're doing it now is a new feature they have which Basically means rather than us choosing which project that we are going to support, we will let you choose. And so the way this works, you'll want to get your smartphone ready. Get your smartphone ready because I'm going to show you a QR code. But also Sarah, you might want to put the link into the chat box right now. So in a minute I'll show you a QR code or use the link and it'll take you to a page that looks like this where there are four projects and you can pick the project that most resonates with you. And then whichever project you you choose, we automatically make a contribution to that project. Doesn't cost you a single penny, it costs us the money. We it's our way of making the world a better place and involving you in that process. So let me just show the QR code. If you hold your phone up to that QR code or use the link that Sarah's putting into the there straight away you'll get the screen that looks like what you can see on the right hand side. All you have to do is choose which of those projects do you want to give people 40 days access to water, for example, or perhaps it's one of the other projects. Just click on the button that most resonates with you and that's pretty much it. And it'll just confirm that you've made the contribution. It's not costing you, it's us making the contribution on your behalf to help make the world a better place. So grab that QR code or use the link that Sarah's put in into the comments and choose your project. So thank you so much for coming along for this session. Those of you who are brand new, we do this for every live stream, every webinar, for everybody who turns up, we make a contribution to a project somewhere around the world. Okay, next thing, for those of you who are brand new, if you want to go deeper with ChatGPT, we have written an ebook on it. If you want to grab your free copy of the ebook, then either with your smartphone while you've got it, there's a QR code that will take you through to where you can grab the ebook or if you prefer, the old fashioned way. I know that Sarah is going to put a link in the comments box to the ebook fairly soon. And final announcement very quickly, final one. Our next big live event is a week on Thursday, October 26th. We are running the profitable bookkeeping boot camp for the second time. It was so successful we got over 2,000 registrations and we couldn't have let we had an upper limit of a thousand. So we have got a thousand places for a free ticket for an event coming up and it's going to be me and Teresa showing you how to price, how to value price bookkeeping services. So if you've not yet been to our profitable bookkeeping boot camp, then use your QR code or use the link that Sarah is going to be putting into the chat, into the comments to register your place. We only register and then make sure that you show up on the day because we have a limit of a thousand places and we smashed that back in August when we last ran it, and we're not planning on running again this year. So that's some free training for you if you want to learn how to value price bookkeeping services, whether you're an accountant or a bookkeeper. That's going to be about three hours of live training for me and Teresa. Okay. Right, let's get into the content for today, chatgpt and actually what we'll start with is we usually start with just some latest news because as you know, this world of AI has just gone crazy. And it already kicked off in November of last year when OpenAI launched ChatGPT3 to the public. And that created a AI arms race of all the major companies developing AI at an incredible speed. If you came to our conference a couple of weeks ago, I talked a bit about the speed at which some of this technology is going. It's is scary fast and there are new things coming out every single week. There were some big, in the last couple of weeks, some very big announcements from Google who are really catching up in this space, and some really big announcements from Adobe because they're doing a lot of stuff around imaging, images, videos, all with AI. But I'm not going to go into those because partly because I prefer to focus on the stuff that's totally relevant to accountants and bookkeepers. So I'm only talking about the Adobe stuff right now. But you can if you, if you like photography, videography and stuff. There's some great stuff that they're doing and I'm not going to go to Google either. Also because actually in the last Couple of weeks, ChatGPT, OpenAI have made some huge announcements, really big announcements. They've been talking about it for a few weeks now back in September, early September and now, now they are rolling it all out. They have firstly a few weeks back they reintroduced Browse with Bing inside ChatGPT, which you may recall if you've been regular to this live stream. They had to remove that in. I think it was the end, early July, might have been. Yeah, right, the end of June, early July. They had to remove it for legal reasons because they found out that it allowed people to use Browse with Bing inside ChatGPT and and get access to articles and things that were hidden behind paywalls. Which is a shame because I found it useful to read some of the articles that normally from places like the New York Times and stuff where you normally have to pay a subscription, you could access it. So they had to close it down. They've now reintroduced it just a few weeks ago. So this Browse with Bing is back available. But then even bigger still, they introduced a couple weeks ago three new capabilities which are being rolled out to plus users over the first two weeks of October. And I now have access to all of them. So later on today I will show them to you. So we now have access to voice on iOS and Android. So you can now speak to ChatGPT and it will talk back to you. I was having some fun with that earlier because I use ChatGPT to help me learn Portuguese. I have a chat where the chat, I get it to anything. I. It knows that anything I put in English it translates to European, Portuguese and vice versa. And so I had a go at speaking into my phone earlier to get the translation and it was pretty cool. I need to change my custom instruction, but it was pretty cool. So voice on iOS and Android has just come out. Even more exciting though is they've also built in Dall E3 inside ChatGPT and Dall E3 is an image creation tool you may have heard of. Midjourney. It's OpenAI's equivalent to midjourney. It has been around for a while. Dall E3. I think that for my experimenting that Midjourney seems to be the leading tool for image creation. But Dall E3 is the version 3 is pretty good now. And even better still, you don't have to subscribe to it like you do with Midjourney, because It's actually inside ChatGPT. You have access to it with the plus account. Now, of course, that has limited use for us as accountants. But the third thing which I think is the most exciting is image input. You can now upload images if you're on A plus account. And there was a recent research report done by Microsoft where it was a huge research report. I forget how many pages, 80 pages or something. Looking at different ways that you can use image input and it was hundreds and hundreds of different ways. Some of the stuff is going to blow your mind. It opens up so many possibilities, which we'll probably have to do another session just on that at some point in the future. I did share in the Facebook group ChatGPT and AI for Accountants and bookkeepers. I hope you're in it. If not, you might want to join that. I did share something that looks something like this. This was from the Microsoft article where you can upload a number of different invoices, for example, receipts, and ask it questions. And it's pretty accurate at identifying. In this case, it was what is the sale? What is the sales tax? I did it earlier. I was playing around with it and.

I uploaded a Portuguese, because I'm in Portugal. I uploaded a Portuguese invoice I had floating around and I thought, let me see how good it is. And I asked it to tell me how much do I need to pay and what is the tax? And it knew. It knew straight away that it was Portuguese. It knew that tax in Portuguese is iva. So it correctly picked up the tax, it correctly picked up the right amount. But then I said, when do I have to make the payment by and how do I pay this invoice? And it went through to tell me exactly how to make the payments, and so on it took. It was able to read it. It was able to also research everything else it knows about Portugal and paying, making payments in Portugal. I thought it was extraordinary. Now, somebody did point out in Facebook group, quite rightly so, with the invoices. Yes, but you can use Dext and absolutely you can. And very often there are tools specific to what we want to do that are better. But I posted that just to illustrate how fast the world is moving, that, yes, you can use Dext, but you can now upload images into ChatGPT and do some extraordinary things with them and ask questions and build on further prompts. So that I think is extremely exciting. Perhaps not so much for reading receipts, because you've got perhaps Dext, although you do have to pay for that. Whereas if you've already got the plus account of ChatGPT, that's a brand new feature that's just part of the plus account. So that's some of the new announcements.

So let's get started. Let's talk about plugins. Let's go into ChatGPT Plugins. We're going to look today at 10 great plugins that you can use. Let me just first of all, talk a little bit about where plugins came from. How to access them and so on. So plugins were introduced in May 2023 and if you remember, Chat GPT 3 was open to the public in November 2022. And then they introduced Chat GPT version 4 in March of. I think it was March or February. I think it was March 2022. 2023, sorry, 2023. And then just a few weeks later, a couple of months later in May they introduced plugins. And back then, I think originally there was 80 plugins and a lot of people were saying that plugins is going to be a game changer, it's going to change everything. And potentially it could do. It could do. There were about 80 in the first release back in May 2023, there's now over a thousand. And I describe it as a bit like the early days of the Apple App Store when that first came out, that it just soon just ballooned with just now just tens, hundreds of thousands of apps. It's kind of overwhelming. Well, plugins are a bit like that. The problem with plugins is there's an overwhelming number of them and also some are amazing and some are less good. So anyway, let's talk about how you get access to it, just in case you are not sure. So I'm just going to go across to ChatGPT. I'm in ChatGPT right now and what you would need to do is, well, firstly, you have to be on the plus account. So if you're on the free account, you've only got access to ChatGPT 3.5. And hopefully by the end of today's session, I'll show you some other things that you can do within ChatGPT4 which will convince you that you probably want to upgrade at some point to Plus. It's a crazy low price considering the things that it can do for you. I had a session with some VPA members last week. We had eight VPA members came to spend a few days in Portugal and we had a morning talking about ChatGPT and everybody by the end of it was convinced they need to be using it much more because of the amazing things you can do in your firm to save you hours of time. So anyway, one of the things you'll need to do is go into the bottom right where you see the three dots on your name and you'll see Settings and Beta. And if you go to Settings and Beta, you want to go to Beta features and that's where you can turn on, browse with Bing plugins and advanced data analysis. You don't get them automatically. You have to turn them on and you might as well turn them all on. I will talk about the other two as part of this session later on, but we are going to focus on plugins for now. So you have to be part of the plus account and then you have to go and turn on plugins. Now, once you've done that, when you start a brand new chat, you will have in the top the option to use the old 3.5, which you get with the free account anyway. Or you can use ChatGPT4 and within there you have a number of options. So as you scroll down, we can use the default model of ChatGPT4, we can use Browse with Bing, we can use Advanced Data Analysis, we can use plugins and we can use the brand new Dall E3. So you've got five choices, six if you count chat GPT 3.5. And you do need to decide in advance for any chat which of them that you're going to use. You can't go backwards and forwards. We'll talk more about that later. So you would need to go into plugins. And so when you go into plugins, underneath it says, mine says no plugins enabled and the drop down box. And what you will then find is that you have a list of all the plugins that you've enabled. So you can choose the plugins you want to use within the chat and at the very end as you scroll down and mine's a long list now because I've been playing with lots of different plugins, but at the very end of the list you then get to the plugin store. And so when you click on the plugin store, this is where, a bit like the App Store, you'll now see all of the plugins and there are, I think it's now well over a thousand. And so you can either look for the popular ones or you can search for plugins. So if you want something, for example, that will help you with, perhaps if we just type in Finance, for example, you will find a whole bunch of stuff that might be related to finance. Now the problem with that is it's a little bit. It's not necessarily relevant to the sort of finance you'll want to do. It's a bit broad, but you can search for plugins in that way. There's a couple of things though that I said to you earlier when they came out in May, people said, oh, this is a game changer, it's going to open up so many possibilities. And that's certainly the case, but there are some restrictions limitations at the moment. Firstly, all of these advanced features, they're all in beta mode at the moment. They're all in beta mode. So they will get better. They're in beta. That's the first point. The second thing, if I just go back to here again, when you decide to use plugins.

And you select them, let me just go back to here. So when you're back to here and you choose to use plugins, you select which ones you want to use. Like for example, you might want to analyze PDFs for example. And you can only have three. It now says one out of three enabled. In other words, you can only use three at a time. And that means that when you are starting a new chat, you have a new task you want to do. You have to do a little bit of advanced planning if you want to use plugins, you have to think about what plugins might I possibly use? Now most of the time there's just one that I want to use and I'll just enable that one plugin. But sometimes you might want to use two or three. And if you get through a chat and you've got some plugins enabled, but then realize you want to use another plugin, then you can't add more to it. So you've got three, you've got to choose the three that you're going to use right up front. And the other thing that's a little bit frustrating about plugins, I find is that, as I say, there's over a thousand of them. It's a huge number and I've been playing with the last week different ones that are very specifically accounting related. There's not many, there's lots of great plugins. There's a limited number of accounting related ones. And some of the challenges that I found is that I might find a great plugin, but it's only specific to the US or the uk. So some of the accounting plugins are country specific, which can be frustrating. Another frustration that I find is that some of the plugins, particularly the accounting ones, you have to set up an account when you install the plugin. Most of them you just tick a box, install it and it's done. But some of them you have to set up an account and even worse, to get the output you have to pay a bit like you go and get an app, for example, from the Apple Store. And these days most apps have some sort of payment built in. Usually you pay to get extra features. In the old days, when it first came out, I remember there was some really cool apps that came out on the iPhone early on, really cool ones that you could get for free and they were great. And there still are some free ones. Procreate is my favorite app on the iPad for drawing and that is still, I think, free.

So some of them are free, some you have to pay. And the frustration I found is that sometimes you don't find out whether to pay or not until you've actually gone down the route of trying to install it. So let's talk about what I think are some of the better ones, some of the ones for you to play around with. And I specifically want to talk to you about the top 10 for accountants and bookkeepers. But because of those challenges, some are country specific and some you have to pay for. It doesn't actually, there's not actually that many. I struggle to find 10 really good ones. So I'm going to cover 10 great apps for you. They won't necessarily be accounting specific, but they will be relevant to things that you may want to do. And I'm going to start with the first one I'm going to start with is. And I just have to find it. Just bear me a second where I started my chat earlier.

This is actually a few weeks ago. So the first one I want to tell you about is one called Pluginpedia. Now this is not nothing to do with the accounting profession, but this is just quite a cool little app that you might want to use a little plugin. So Pluginpedia is a plugin to tell you what plugins to use. So I went in to ChatGPT with plugins and I installed the pluginpedia. I think it's this little funny purple icon at the top, looks like a tree to me. And I installed the plugin for Pluginpedia and what I often do. Here's a little tip for you. When you use a plugin for the first time, what you might want to do is make your first prompt something like this. This please bullet point all of the uses and functionality of the plugin Pluginpedia. Give me a little explanation on how to best use and get the most use out of that plugin because they don't often come with an instruction manual. If you want to find out how to use them, you have to go and do a Google search, see if they've got a video or something and very few do. So this I find really useful. And so it tells me that I can use this to make plugin recommendations it helps you to find plugins that can solve specific tasks or problems. It allows you to search for plugins based on various categories like finance, business, social networking, etc. So that's the Pluginpedia. So what I then did is just if I scroll down a little bit to one that's relevant for today, I went in and asked it, what are the best plugins for bookkeeping firms? And you can tell when it's using a plugin because it then says it'll say using pluginpedia. And when it's finished it says used. So there's a bit of a waiting. Sometimes with ChatGPT, it's pretty fast. But if you're using a plugin, the plugin goes away and does something. And if you click on the down arrow, usually it might be creating some code or something. So this is what it was doing. Not that we need to understand that in the slightest. I've lost that. Let me just close that.

And I don't know why in this case it then repeated this bit of it, I don't know. But it then came up with what it thought were the best plugins for bookkeeping firms. So the first one it said was Receipt Assistant, which is. This is the icon. It's for managing, reading, storing and reviewing your receipts. Now that looked quite interesting to me, but that was one that if you then want to install it, it asks you to put in your email address and a password. And because I'm not going to use this, I found when I was testing out plugins, I was just giving away my email address to so many different companies and thinking, I'm not going to use this, I'm just researching. So I didn't go deep into this one. But if that sounds something you might be interested in, you can always go to Google and find out more about Receipt Assistant. And then you can play with the plugin if you're happy to open up an account to manage, read, store and review your receipts. Next one it came up with was one called Invoice for creating professional invoices in PDF or Word format. I will talk about that in a little bit more detail in a second.

As I will with this one, because you might recognize the logo here. Avalara. If you're in the U.S. avalara is for us, calculating sales tax and looking up tax rates and so on. You may well use Avalara if you're in the U.S. well, they have a plugin as well. If you're in the us you will almost certainly want to check that out. Another one I'll come on to in a bit is Credit Yelp. Then there was one that was a plugin for SAP related questions. So that was the what it came up with pluginpedia when I asked it about the best plugins for bookkeeping firms. Now I did change that prompt and said what are the best plugins for accounting firms? And it largely came up with a similar list, but it did come up with some different ones. There was Status fund finance if you're looking for financial data tools for analyzing equities, price quotes, etc. Personally, unless you're into investing and stuff, I'm not sure that's really useful for day to day accounting work. But anyway, that's what it came up with. Fiscal Note is a US only one for accessing latest sets of legal, political and regulatory information.

Another one to do with saps calculator tools, currency converters if you have to do that regularly, and a few others. So that was the. That's the first one I want to mention. Pluginpedia you might find is a useful, free, little simple plugin where you, if you want to look for plugins within a certain thing, like plugins for accountants, plugins for finance, plugins for. I did one for personal things like travel advice or whatever, then you might find Pluginpedia useful. Let me talk a little bit about, let me go back to that Invoice one.

And.

So there are a number of plugins for creating professional looking invoices. One's called Invoice, there's Invoices, there's a Invoice Maker, there's Invoice Pilot and they might be worth checking out. I found it a little bit frustrating for a reason I'll tell you about in a second. But I got the plugin for, I think it was Invoice and I asked it the question how can I best use it? It told me what I would do, what information to give it. And then I went through the process of saying, okay, I want you to generate an invoice for me with the following details. I gave some details and so on. It then gave me the opportunity to upload a logo to put on there, which it did very successfully, or at least it seemed to. And then finally it gets to the stage where, right, I've now created your invoice and gives you a link for a download link. And when I pressed that, it then gave me the option oh, leave this one. I had to sign up straight away with Copilot, which I didn't want to do. And so that was my frustration. And when I did sign, I did start the signup process and it then said it's $9.99 a month for unlimited invoices. Well, I was just testing. I didn't want to, I didn't want to pay $9.99 just to test a single invoice. Invoice. So that's one of the frustrations again, that there are some interesting plugins and I looked at a lot of the invoice ones and they all seem to charge you 10, 10 bucks a month to be able to create invoices. So perhaps that's not so useful. So let's go on to something else. I then looked at. What did I look at next? I looked at.

In fact, let's go into. While I'm in that chat.

I did then look at Avalara. So, Avalara, my disclaimer here is this is us only, so forgive me if you are not in the U.S. but if you are, then I said, and in the US Sales tax is just crazy complicated. Using Avalara, what is the sales tax I need to charge for delivery from? And I just put an address to another address and it says, great, I've got that. And it's then went and researched Avalara. Great, I've got the sales tax information for both locations. It told me what the sales tax is in Albuquerque and San Francisco and then gave me some more explanation. And then I could have asked it more questions. And that's the great thing about ChatGPT with plugins is that you can keep on the conversation, ask for clarification, or you could put in some different locations or whatever. So the combination of, I think ChatGPT and Avalara, if you are in the US and have challenges around sales tax, I think would be really cool. That would be one of the top ones, I think, for the accounting performance.

Okay, so let's now look at another one. I'm just conscious of the time. I do want to answer questions in a bit as well. Let me just show you a couple more that I really liked. There's a lot of, a lot of plugins for helping you look at things like repayment plans on debt. And those of you that are in the Value Pricing Academy, I'm doing a session tomorrow on how you can build a debt elimination service for your clients and make a lot of money from it. So that's tomorrow's Value Pricing Academy session. Anyway, I've looked at a lot of different reviews of different tools and consistently the one that comes out top on the list is called Credit Yelp. And so the sort of thing that you can do with that, if you've got Credit Yelp, is, first of all, you have to enable the plugin, which I did. And then I said, using Credit Yelp, I want to borrow 100 grand. APR is 5.6%. I want to pay it off over 10 years. What are the monthly repayments and interest paid each year? And it went and did all the calculations for that. So if you're looking to do calculations around repayment plans and stuff, then if that's a regular thing you do for clients, then you might find Credit Yelp really useful.

Next thing I found, if you are, another interesting one that I came across a long time ago now, but I thought I'd mention it, is if you are from a sales point of view, you've got a client coming in, for example, and you want to get some information about that client, then there's a great tool that I think this came out back in April by Clearbit. Now, unfortunately, I can't show you this one because you have to have an account for this one, but it does do some really interesting things, the Clearbit plugin. So if I just pull up, if you go to their sales page, they'll do things like it will tell you which companies have visited your website. You can get all sorts of interesting data, but what I found particularly interesting was their blog post on the ChatGPT plugin. And you can do all sorts of data analysis here, particularly, for example.

Finding lists of people and companies to contact. So from a selling point of view, if you're looking for new clients or you want to, you got a prospect coming in and you want to learn more about them, you can feed it, for example, an email address and it'll tell you all the data it can get on that particular person from their email address, from the company details and so on. And I think back to when I was in practice many, many years ago, and I'd often want to get access to company data and there was often lots of subscription services. But to be able to have that built inside ChatGPT, where I can start to ask all sorts of questions and queries about a particular company, its directors, people there who are there, who are there, other contacts in their network could be really useful stuff. Okay, next one I wanted to tell you about. Now, this one's a UK only one, so I apologize. That's the problem. These aren't all universal, but I Thought I'd just mention this for the benefit of those people in the uk. And that's if you deal with taxes, if tax is your thing, or you sometimes have to reach research tax, then there's a great plugin, at least it looks really good. From my research, called Earnr E A R N R. It's the Earnr plugin. So I asked it what it does and what Earnr does. It's a UK tax assistant that offers various calculators, advisory services related to tax and accounting in England, Scotland and Wales, gave some key features and so on. And so I asked it a few questions. I asked it, using the Earn A plugin, how can a UK domicile person avoid inheritance tax, including changing their domicile of choice? Because I live in Portugal now, I'm Portuguese resident, so this is something of interest to me. And it talked about things like changing domicile choice. And I know this is right because I actually researched this myself. I understand the rules in this. I then asked the question, for example, using Erna, what expenses can I claim for working from home? And as well as giving the advice, it then gave you the links to all the government websites for finding out where it told you where it got the source of data from. So if you're in the UK and you want to do tax research, I think Earner is potentially a really useful tool. Okay, let's carry on.

There is another one if you're in the US called Fiscal Note. Fiscal Note tells you what some of the latest regulations that are coming out that might be worth checking out. But I want to wrap up with a couple of more broad areas and so that I've talked about so far, very specific things that are in finance, tax and so on, and they may be brilliant, but there are those limitations. Avalara, I think Avalara will be great if you're in the us. Earner I think would be a great tax tool if you're in the uk and there's other ones that would be great if you don't mind paying a subscription or registering an account. But let's talk about some other things that I think you'll find useful to have. Kind of must have plugins. And one of the types of plugins that you'll probably want to have access to is being able to access the web to access the Internet, because ChatGPT doesn't allow that in itself.

Subject to. You can use browse with Bing. I'll tell you about that in a short while and I'll tell you which route to go down. But there are plugins that give you web access and there are two in particular that have always been my favorite and they are Web Pilot and Link Reader. So Link Reader and Web Pilot are my two favorites. So I decided that what I would do.

As many of you know, one of the things I have is I help people with value pricing. And we have a pricing tool to enable you to price with confidence, get higher prices called effective pricing. You probably know about effective pricing you should do. And there's a website for effective pricing. So one of the things that you can do with ChatGPT is you can then start to get it to read and understand a website. And so I went in here and I did. I activated plugins, I activated Web Pilot and Link Reader and I just asked the question, read this web page and list all the benefits of this software. And I cut and paste in the web address in and it then told me it was using Web Pilot. And after a few minutes, a few seconds of doing that, it then said, benefits of effective pricing software, you can price with confidence. The software provides a system for offering clients a fixed price based on what they value, eliminating uncertainty for all clients about the cost of services, getting higher prices. Simple, easy to use using price psychology, specifying payment terms, global usability and full support. So it analyzed the full website and extracted for me that bit of information. What are the benefits of that particular piece of software? So that might be useful if you're doing research into software, apps and things. You might want it to summarize for you some of the key features or the benefits. It might be useful if you want to get some feedback on your own website. For example, there's all sorts of user cases that you could use. So if I ever want to access the Internet for anything, then webpilot is one of my two go to. Now, interestingly, as I just scroll down, I asked exactly the same thing of Link Reader, which used to be my favorite but interesting link reader said it appears that the content from the website couldn't be properly retrieved for analysis and I have no idea why. And so one of the points I wanted to raise is that I do find from time to time these, these plugins, sometimes they work really, really well and sometimes they stop working for a while. I have no idea why. Perhaps they've gone to change them and it's just not working. So it's useful to have a number of different alternatives. Hence, if you're accessing the Internet.

Having access to both Web Pilot and Link Reader, you can See which one works the best. So that's useful for accessing the Internet. Next thing that you might want to do, next thing is you might want to create some output, turn your research into.

Something else.

And somebody asked me this question last week at the Portugal retreat. My friend John, I don't know if John's here or not, but he asked, if you want to export the output into Word, then is there a good way of doing that? Because let's go back to here. If I wanted to put that in a Word document, I have two options. I can either hit up in the top right next to the thumbs up and the thumbs down, there's a little paste to clipboard icon, and I could paste that to the clipboard, or I could just grab it all and do Control C, control V and put it into a Word document. And the problem with both of those methods is, is the formatting in Word isn't always great. Sometimes it will if you copy. If you use the clipboard, it will change the headings into markup language. In other words, it'll put loads of hashtags everywhere and asterisk things for bold. And you then have to tidy up in Word. So that can be a bit of a pain. So wouldn't it be better if you could output your research into a. Into into Word? Much easier. And that's where we can then do. Let me show you this.

Is that the one I want just. But yes, yes. Okay, so if I go back to here. So there's a number of plugins for taking your content inside ChatGPT into a DOCX file, for example, a CSV file, sometimes PDF files. So you can use plugins not just to read a report or read the website, but also to then create something off the back of it. So one of the. If you want to create CSV files, there's a number of ways of doing that. I chose CSV Creator. So how can I use the plugin CSV creator? I asked that question first and it gave me some advice on the steps to use the CSV creator plugin.

So that was a whole bunch of stuff there. So imagine that you've done a prompt, you've got an output like this, and you would like this to be in a Word document. What if I want to create a Word document where I want to give this advice to my customers? I want to create a Word document and I want to do it fast. I don't want to mess around with tidying it all up and so on. So there's a number of plugins that you can use to do exactly that. So I chose Doc Maker.

There's several I could have used. So I also had DocMaker installed and I said export this chat to a Docx file. And it said, great news, I've exported our chat into a Docx file. You can download it using the link below. So we then just hit the link that it's given me and it takes me to here.

And you can see here it's preserved all of the headings. So on there's the document and then there's a really on the right hand side, there's something that is even tidier there. And then you can hit the download button and download that to your hard drive. So that's a Great tool for DocMaker if you want to create the output into a Word document. Let me go back to here because then what I did is I wanted to test out a CSV file and I'd. And so I said create a table for the 10 year period from 1980 to 1989. Let me just get rid of that for a minute. The sidebar.

Showing the year the winner of the English Premier League, that's football or soccer if you're in the US and the total number of points and the total number of goals scored. So I actually thought what it would do is it would go away and create the table inside chat GPT and I would then have to go and use DocMaker to convert the table into a CSV file or document. It chose to. So in this case it just went ahead and chose to use the plugin DocMaker. So one of the little tips for you when you're using plugins is sometimes ChatGPT won't use a plugin. It'll just go and do something if it thinks it knows the answer and bypass the plugin. Sometimes it might use a different plugin you've installed out of the three. So if you want to use a specific plugin, it's a good idea in your prompt to say that. So I so sometimes just goes and makes and chooses. So anyway, what it did is it created for me, it created for me a document, a Word document. So there's the table and on the right hand side it's nicely tidied up. So there's the Word document, the Docx file of all the winners. Some of you know that I'm a Liverpool fan, so I look back on the 1980s with some fondness because they were good times. Anyway, what I then want to do is test out the export to CSV. So I then said, create that table as a CSV file using CSV creator. So in other words, you might create some, you might get ChatGPT to do some analysis for you and create a data table, a table that you might then want to put into a CSV file to upload it as a spreadsheet, perhaps into QuickBooks. There's a video on my, on my website, on my YouTube channel somewhere where I showed how you could create a chart of accounts with ChatGPT and then you could upload it into QBO, for example. Anyway, so I want to turn that into a CSV file and so if I click that button, what it will then do is I can't show you this because it then just downloads it and stupidly I hadn't actually thought about getting ready to show you that. So I can't show you it. But anyway, that's downloaded that onto my file.

So.

So those plugins I think you'll find useful if you want to create either a Word document, a CSV file, and there are other file types as well that you can also create if you want to. Okay, that brings me on to the last app or plugin. So I want to talk to you about, because I've talked about, we've touched on a lot of plugins in the plugin, in the ChatGPT plugins and all those plugins are third party plugins. So Avalara, for example, is a third party company credit, Yelp is Clearbit and so on. So they're all third party plugins. But if I was to list my top 10 plugins and yes, I love web access, for example, with Web Pilot. But if I was to list my number one plugin, I would say it's probably OpenAI's own plugin, which they launched at the end of June. And originally back then it was called the crazy name of Code Interpreter. Code Interpreter, Why? Because Code Interpreter. Because what it essentially does is it takes your text based input and it then uses code Python code to then do the analysis, which means it's much better for doing Advanced Data Analysis, which then interestingly, a few weeks ago they renamed it, they renamed it to Advanced Data Analysis, which makes much more, much more sense because Code Interpreter is a crazy name and confusing. So Code Interpreter as it was Advanced Data Analysis. Let me just do a new chat for a second very quickly and just show you where it is. In ChatGPT4 you have advanced data analysis. This is OpenAI's own plugin. It's their own plugin and this is the most powerful plugin and I think particularly useful for us in the accounting profession because we often want to analyze data. Now, the interesting thing about Advanced Data analysis is that you can upload up to 10 files. So you can analyze, you can analyze Excel spreadsheets, you can analyze. That's just telling me it's timed out. You can analyze Excel spreadsheets, you can analyze CSV files, you can analyze PDFs, you can analyze images, video files, which is interesting. That opens up all sorts of things. But interestingly, what people don't realize is that with data analysis, advanced data analysis, you can also output to those data files. So you can create PowerPoint slides, you can create Word documents, you can create Excel files, CSV files, you can create images. There's some interesting things that you can do. So let me just show you one thing. And one of the things that I teach, as many of you know, is I teach value pricing. I teach you how to value price your services. But for people who aren't ready for value pricing yet, I teach how you can do fixed pricing with confidence. And I talk about something called regression analysis. And so one of the things I did is I went into, if I just go to here I went to create a very simple little Excel spreadsheet listing some sample clients, what my fee might have been, and the monthly transactions I might be looking to price bookkeeping services, for example, something we'll talk about in the boot camp later on next week. So make sure you grab your ticket. But anyway, very quickly, I pulled together this quick spreadsheet with.

Eight random clients. The price I might charge them for bookkeeping work, what the monthly transactions were, and I want to know how much to charge, how can I work out, how can I figure out how to do a fixed price? And one of the things that I teach is that you can create a pricing formula for fixed pricing, not for value pricing. There's no such thing as a formula for value pricing, but you can for fixed pricing. And so one of the things I teach, and I know Jim's here, that we, that Jim and I have worked on, is you can do regression analysis. So I took that Excel spreadsheet and I put it into ChatGPT, into advanced data Analysis. I uploaded the, you can see at the top, I just uploaded the spreadsheet and I firstly said, one of the interesting things you can do, a great first prompt when you use Advanced Data Analysis is explain this data. And so it went and read the Excel file and it analyzed it and said, firstly, it seems to need cleaning up, which it did in my original version. I forgot to take out blank rows and things. So it identified that it needed some cleaning up. And it also then says to properly analyze the data, some cleanup is needed. Will you like me to do that? And I said, yes, please clean it up. So remove those unnecessary rows, et cetera. So it went away and using python code, which it shows you here, it went and cleaned it up and then said yes. This data set seems to be a data set with columns for client price, monthly transactions, number of bank accounts, entity. So it understands the data, it correctly understands the Excel spreadsheet, it's able to know what it is, and so now it understands that we can ask it questions. So in this case, I asked it to carry out regression analysis based upon the price and the monthly transactions and provide a formula that can be used to calculate any price from monthly transactions. Show the regression analysis as a chart and tell me the R squared. And so it went away and it created the regression analysis, it created the formula, it did the R squared and a few other bits and pieces. So then I asked, and this is something that is interesting, I then said, can you refine the pricing formula using the sample data to take into account the number of bank accounts and trading entity? And it did exactly that and it came up with a really interesting formula. At first I didn't fully understand it. I have to scroll across. Where's the scroll bar?

Because I couldn't work out what you put in for entity. But anyway, what I then did is I then said output the cleaned up data file as a PDF. And so just to show you, it then took my Excel spreadsheet that it had cleaned up and it's a PDF that I could then download. You've got an image of the PDF and I could click that and download the PDF. And it was interesting how it actually assigned a code to the trading entity which it used in the formula. So some fascinating stuff there that if you're in the value pricing academy, I'll be teaching you more about advanced data analysis and also how to use it for helping you with pricing. But I want to just touch on that because of all the plugins, I think advanced data analysis is the best. So let me just wrap up with one final comment and then I'm going to look at. We've got got about seven or eight questions for client for question, seven or eight minutes for questions. Sorry, I don't think there's many questions that have come in, so I will carry on.

I will Carry on. If you haven't put QQ in front, I might miss your question. I think, Marianne, you didn't at first, but I now see you have, so let me answer those questions in a second. The last thing I just wanted to cover.

Is.

If I go back to here. So when you are using Chat GPT you have six choices. So and, and you'll see a lot of it's in beta. So you can use chat GPT 3.5 and that's your only option if you're on the free account. 3.5 is very, very good. There's some amazing things you can do with 3.5, particularly, as many of you know, I think it's particularly great for coming up with ideas, ideation, brainstorming. It's great for marketing, content creation and it's brilliant for business advisory if you want to run a business advisory service. They're my favorite use cases for ChatGPT. Now ChatGPT, if you upgrade to the plus account, which I think is a crazy low amount of money, is $20 month and I use it every day. I would be surprised if I don't save at least a day of time a week. I save so much time, I just, there's so many things on autopilot now. I've got prompts, standard prompts I use to create stuff and so if you use ChatGPT properly, I'd be amazed if you can't save two or three hours a month. And I don't know how much you value your time at, but to me I would happily pay 20 bucks to save two or three hours a month. I save way more than that every single week. And when you Upgrade to the plus account, you now get access to GPT4 which is a much more powerful model, will give you much better answers, particularly if you want to do things like high level stuff like marketing, business advisory services. I think the ChatGPT4 is extraordinary what you can do. And you'll see that's the default model. Now with the default model, if I just click on default, we now have, as of the last few weeks, access to upload images, attach images. This I think is extraordinary. There are so many use cases that you can use here, which I won't go through now. It's going to be another session. In fact, I was talking to Emily earlier and we might do a session on advanced uses of ChatGPT. You can upload images there. You also have browse with Bing, you have the advanced data analysis, the plugins and then of course DALL E3 for creating images. And the one challenge or the problem here is when you're about to start a new task, the question you have to ask yourself is which one's the best one? What's the best option? Because you can't chop within the context of one chat, you can't switch, you're stuck on that set of on that channel. So you have to make a decision up front. And so let's say you want to do a chat and at some point in it, you want to access the Internet. Well, if you want to access the Internet, you have two choices. You either go into plugins and you install either Web Pilot, Linked Reader or another tool that lets you access the Internet, or you use Browse with Bing, which they've recently reinstated, and they both work slightly differently.

My problem with Browse with Bing is every time I then want to do a further prompt, it seems to go off to the Internet to do it and not use ChatGPT's thinking. Whereas with the plugins using WebPiler, if all I want to do is feed it some information first from a website, I can do that and then I can ask it all sorts of questions and it then just uses Chat GPT, it doesn't go off the Internet to come up with the answer, it uses the way that I've taught it to think. But there's a choice there. Do you use browser Bing or do you use something like WebPilot? If you want to analyze a plugin, sorry, a PDF document, then you could either use a plugin for that. There's a number of plugins for analyzing PDFs, some are better than others, but also you could use advanced data analysis, which I generally find usually is better for most things, but not all things. And then of course, you could always turn the PDF into an image and use Chat GPT4 with the ability now to upload images, which is this image at the bottom left. So there are lots of different routes. And at some point I'll probably do a session where we'll go into the advanced use cases and help you to identify which route you want to go down for a specific task. But I'm conscious that we've gone on for. We've got five minutes left and I do want to answer any questions. Somebody said, what is the link for the ebook? I'm guessing Sarah's probably answered that one. Hopefully. I think Marianne that answered that question we've answered. Now, are the plugins within ChatGPT free or do they have additional charges? So you do have to have the plus account but it's only 20 bucks a month.

Within that many. Most of the plugins are free. WebPilot was free, but some of them, some of them usually the more specific things like raising invoices, they all seem to charge a fee for that. So I think most are free but some there will be a fee for.

Joe says. So there's no way I can access any plugins for the free version. No, you can't. You do have to upgrade to Plus. But.

The more you start to research what you can do with ChatGPT it is extraordinary. Some of the things that you can do, particularly if you want to grow your accounting firm with marketing, if you want to add value to your clients through business advisory, the hours it will save you, the quality of the outputs you'll get, it's worth upgrading. It's one of the best pieces of software you could possibly imagine for the hours it will save. But if you don't want to subscribe yet, start with a free one. 3.5 is still pretty good.

Crystal Robinson said what is the name of the plugin to use for lead generation? He just mentioned it around 10:34. That was Clearbit. C L E A R B I T. So one of the things that let me say what I'm gonna do but this is only for Chris is on Facebook. I can't do this on Facebook I'm afraid but I will. Perhaps Sarah can help me out. I have got YouTube open. I'm going to just put the link to the Clearbit blog. The Clearbit blog is the one that's in YouTube now. I'll just post it in the chat and that's the one that tells you about the Clear but Clearbit plugin. So you can research that bit more and decide whether or not you want to have a look further that Crystal. But I know you're on Facebook so hopefully somebody can put it in there.

David, I probably can't answer this one. He says with Clearbit can you ask create a list of name postal addresses and email addresses for new homeowners with home price? I don't know David. I've not researched it because you have to set up an account for that and I don't want to set up an account for it particularly because I wouldn't have a personal use for it.

Okay. Charla says I can't find advanced data analysis in the plugin store. That's because you won't. It's not there.

When you go to start a brand new chat then it's one that when you go to ChatGPT4 in the top right you have it drops down with a number of different options. And Advanced Data Analysis is separate to the plugin store. It's not in the plugin store because they're all third party plugins. Whereas Dall E3 is OpenAI's own product and Advanced Data Analysis is their own plugin. So it's not in the plugin store. It's just shown separately. Hope that helps. Charla.

What else?

Yeah, so I think I've answered that one.

Why is that showing?

Okay, this is awesome. Lesley uses it every single day. A lot of people in my academy use it every single day because we teach you a lot. We go really deep on it in some of our sessions like Marketing Monday and our business advisory because there are so many uses there. We have, I think one minute left.

David says Mark, do you know if Advanced Data Analysis can build formulas, Excel in particular by providing written instruction samples?

Yes, yes, I'm pretty sure it can do. It's very Advanced Data Analysis is very good. In fact, generally Speaking, I think ChatGPT is good at helping with Excel if you want to know how to create a formula. But in particular I know that Advanced Data Analysis is great for helping you with Excel. Now I know my friend Jim will say that there's now AI built into Microsoft are building AI into all their tools so you will be able to get access to that support inside Excel. But I think they're rolling the AI side out still. But yes, play around with Advanced Data Analysis. David, there's a lot of really fascinating things you can do there. I think A, we've run out of time and B, I think I've answered all the questions which is quite extraordinary. If I've missed your question, I apologize. Let me just quickly remind you before we wrap up that if, if you want to find out how to price bookkeeping services, we have a free, completely free training. Three hours of training. I think it's three hours. Yes, three hours. Me and Theresa Slack. It's October 26th, so either use your phone, your smartphone to grab that QR code or I think Sarah's put the chat in the chat somewhere. The link to get your free ticket to the profitable Bookkeeping conference. Those of you who are brand new to my live stream, remember, if you want the ebook chat GPT for accountants and bookkeepers again, you can either use the QR code or Sarah has put the link into the chat. So grab those free resources and the next live stream we are doing will be two weeks time. I think we've agreed a date. I think we said let me just check my calendar. I think we find lighter date. Next one will be. Yeah, November the second. November 2nd is the next one. I'm hoping Emma will be back and the next one. We haven't finalized the topic yet but if there's anything you want us to teach you on these live streams, then go into our Facebook group AI and ChatGPT for accountants and bookkeepers and give us some feedback and let us know what you'd like to cover in these live streams. I'm thinking that in two weeks time we might do some more advanced use of ChatGPT but let me know if there's something else that you would like that you would like to me to cover. Okay. I'm going to play with some music as I always do. Give me a chance to read all the various comments. I will see you all hopefully soon. If you're in the academy, I might see you tomorrow for profit advisory live. If not, I'll see you at the bookkeeping bootcamp next week or the next live stream in two weeks time. Bye for now.

It on someone who's indifferent he didn't love me right you told me I was blind but I never really wanted to listen.

You have been here since day one see my ups and down.

Never left my side once you st around.

I knew it was you you have been here all along you have always been the one here who knew it was you you have always been the one that true.

You have been here all along.

I never saw the signs it didn't treat me right but I just couldn't let him go you waited patiently you waited for me you show me what it was to love.

You have been here since day one.

Down.

Never left my side once you stuck around.

I knew it was you you have been here all along you have always been the one yeah who knew it was you you have always been the one.

You have been here since day one I.

Never left my sight once I.

Did it all along.