Streamline Your Workflow with Automated Invoice in Google Sheets for Education

Automated invoice in google sheets for Education

hello this is Ian from in 30 minutes guides and the author of Google Driving docs in 30 minutes I have a really neat trick to show you how to create an invoice using Google Sheets if you don't have software to create invoices such as uh QuickBooks or something like that Google Sheets actually is a template you can use I'm going to show you how to do it right now so go to Google Sheets and then look in the template Gallery if you don't see one that says invoice up here click on template gallery and then make sure that the tab up here is set to General and by the way this works on a Mac it works on Windows it works on a Chromebook as long as you can load up Google Sheets in a browser you can do this so you can see invoice is actually the first option here and this is a template and often what happens actually is if you're doing some freelance work or you're starting up Consulting and you'll get a client and says all right well submit an invoice and then I can pay you and you don't have the software set up you're not sure how to do it Google Sheets is a really good way to start especially to start small before you scale up the business so I recommend using this particular tool one thing you should do is you should make a copy right away so I'm going to call this test invoice for Acme okay and then maybe I'll say May 9th 2023. make a copy and the reason is because in case you want to make another invoice you want to use the original template not not the not the one that you've just created so so your company here so what you would do is you could say um all right so the name of this company is in 30 minutes guides all right 123 year Street your city so just fill that information in and then invoice and then when the date was submitted so what I would do here is I would type today's date so what did I say the ninth all right invoice four so here you would cut say like um you know Jill Smith company name uh Acme Inc street address you know 123 Maple Street and then the city-state zip Etc payable too here's where you would put the name of your company again so you could you could either say your name or the name of your company if your company is set up that way since many people who are just getting started with this they may be doing this just kind of like on their side it's payable directly to them so you would you would say whatever your name is so like let's say that my name is uh you know Jim McGovern so I'd put that there invoice number so I always recommend when you're getting started with invoicing just to start off sequentially so this is actually invoice zero zero zero one it's no big deal if you do this you know if you say it's zero zero zero one of course it looks like you're just starting but your client probably knows that anyways and even if even if he or she doesn't know that um you know you provided services so you can give them an invoice project name so maybe you could say you know uh spring spring tune-up okay whatever that might be and then the due date so there's a couple ways to do this you could actually select when it's due the exact date so you could say something like all right well today's the 9th the 9th of May so I'm going to say the the 9th of June the other thing that you can do is you can say you know net 30. all right and that tells them in 30 days and then here's where you would put the put the description let's say that you have more than three items what you would do is to do insert one row below and then here you would do item three whatever that is whatever the unit price is okay and then it should be able to calculate it so I can see here actually so it looks like somebody somebody created a little formula up here so maybe what you could do is actually just copy this copy this particular cell and then paste it down here yeah that's a better way to do it and then just rename this okay because all the formula is already set up there and then you can see here it's it's totaling it so let's say that you change the unit price here so let's say it's 55 dollars it adjusts everything and six hundred and ten dollars and so that then at this point like if the once the invoice is ready to go you've you know you've added enough items there you have the descriptions maybe don't call it item one item two item three just say what it is in a very short way then you're ready to submit it and what you would do to do that while it is possible to share this invoice with the person what I do recommend doing is to actually print out a copy so what you would do here is you would you know Download a pdf and then you would email it to them or you could actually print it out and then send it to them in the mail whatever works for you anyways I hope this video helped about how to customize an invoice in Google Sheets if it did please take a moment to like this video and follow me and then also if you go to in 30 minutes.com you can learn more about the series that we have besides Google Drive and docs there's other books on crowdfunding Etc this is Ian Lamont founder of in 30 minutes guides thank you so much for watching