Collaborate on Create Invoice in Google Sheets for Export with Ease Using airSlate SignNow

Create invoice in google sheets for Export

hi guys so before you stop this tutorial there's a few things i want you to remember number one is that in order to access google sheets you need to have a google account number two is the auto save function so any change or edit that you make in google sheets is automatically saved without you having to press save at all so if you do a change that you're not happy with and you can change you can change it back by pressing the undo button or the keyboard shortcut control z and number three is that this is a basic tutorial so i'm showing you a simple easy way of creating an invoice in google sheets straight from a template there's no long complicated formulas or anything like that it's a simple quick way of creating an invoice for you to use straight away so if you're ready let's get started okay so in order to access google sheets you need to be logged into your google account and then go into the apps grid in the top right hand corner it's the nine square grid here click on there and scroll down to google drive this is where all of your files are stored in the google drive so we want to create a new invoice from the template that's actually already there in google sheets so go to new go to google sheets and instead of clicking google sheets straight away go over to the arrow and you have the option of a blank spreadsheet and from a template and we want to use from a template so click on there and you will have a list of templates that are that are categorized into personal work project management and education so we want to go to the work section and there's one called invoice if you click on there and the invoice template will open up so you can see it's just a basic looking invoice and the first thing that you can do is change your company details so if you have a logo you can upload a logo image here or if it's just the name that you want to have there so for example if i wanted to upload my own logo on here i would go to insert and insert an image and you can do image in cell so i would go into there and i would upload the image from my computer and you'll see that it looks quite small so what i would do i would highlight these two cells and i would merge them together and then i would increase the height of the row just to make it a bit more visible and i would center a line as well and if you don't want it there if you want it in a different position you could just do ctrl x to cut move it across i want it over on the right hand side ctrl v to paste so then i would add in my company details here and you can then go through and change any of the colors the font size anything that you don't like about it and so the invoice here i would i would probably reduce the size of that down a little bit and submit it on i wouldn't have that so i would delete that from there invoice 4 so you put in the customer or client details here payable2 and then the name and project name i wouldn't have so the due date i would have the date in the cell next to next to the heading due date and but if you look here you can see that the two columns here are highlighted which means that these cells are merged and you can look up here and you can see that this button here is highlighted to say that the the cells are merged so if you just click on the arrow here and unmerge and then you've got the two separate cells here so now you can go in here oh it looks like these two cells emerged as well so you want to go in here and unmerge these so now you can go into this separate cell and control x to cut and control v to paste and then i would just add in a due date here and again these two cells are merged again so i would unmerge these as well and in here i would put in invoice date now you can see that this is a different format so i want to actually use the same format as this cell here so i would use what's called the format painter so what that does is you click on the cell that you want to copy go up to here and there's a little paint roller so that's format painter click once on there and then click on the saw that you actually want it to format and it will automatically change it to match that format so the invoice date here i would put in i would put in the correct date there again with the invoice number i want the invoice number to be up here as well but you can see here that these these cells are merged as well so again just unmerge them and the same with the invoice number thing there as well just unmerge so i would go in here and cut and paste so ctrl x and ctrl v again and that's probably all the changes i would make to begin with on this section here so now you get down to the section where you're adding in the actual details of the invoice itself so you have item one item two quantity unit price total price a subtotal adjustments for any adjustments made and the grand total so the first thing i would do is i'm actually based in ireland so i would want the currency to change to euros so to do that i would highlight all the cells here i would go up to the the number formatting here and click on this drop down arrow next to more formats you can see that currency is already ticked and you can see there's one here called euros if you wanted a different currency there's more formats here and you click on more currencies and that will bring up a whole load of different currencies that you can use but i went to euros so i would change this just to euro like so and that's changed the next thing i would do is when you go over to rows 22 and 24 you'll see that 23 is missing and you can see the two little arrows here so this means that this row is hidden so i would highlight and right click the mouse and go to unhide rows and just show those all the rows visible the next change i would make is this adjustments here and i wouldn't actually have that but i would have an extra row in there for tax or vat so i would have that as vat and in ireland at the moment it's um 21 so i would have that in there and then we would put in the formula that is equals the subtotal times 21 which gives us that total and then this total figure here is these two added together another way of doing that would be to insert another row below so right click on the row insert one below and here you could just say vat or tax and you could put in a percentage here instead so you could say 21 percent instead and here you could save that amount so you would do a formula here which would be the subtotal times by the percentage here and press return and that gives you the same amount so 126 and then this total here would be the subtotal plus the vat amount and press return and gives you the same figure so it's up to you how you would want to show that so if you wanted it so that um if you changed the vat rate if it went up to 23 then everything would automatically work out so that would be fine or you could have it as 20 whatever the vat rate is or the tax rate is you could automatically change it in there and it would automatically change that so that's how to change the um the totals and everything so to change the description within the actual invoice itself if you had more items that you wanted to add in you would highlight the row there and insert one above just keep doing that until you have the right amount there so you'll notice that these rows that have been added are alternating between gray and white so if you actually go up to format and you'll see one called alternating colors if you click on there and you can see that there's a gray and white alternating colors that has actually been highlighted so you can click the different colors and choose whichever one you prefer so we'll just stick with that one anyway um that's fine and then it's just a matter of adding in and the different so you can copy that down and ctrl v and then again copy and paste control number three and we'll get that one number four now obviously you'll notice that the formula hasn't been copied down so all you need to do is click on that top one there and just wait for the cursor to change by dragging the fill handle down in the bottom right hand corner and just drag that down and you'll see there and the subtotal there you'll see the formula here g19 to g25 which is here g19 to g25 so because you've inserted the extra rows in between um it's automatically the subtotal and the total sums down here have automatically moved down as well which is what you wanted so again the quantity just fill in the quantity fill in the amount and it's automatically adding up everything here so that's the basics for a simple invoice created using the template saved in google sheets um one other thing to point out is the invoice name itself up here just says invoice so you could actually rename it by renaming it the actual invoice number if you wanted or the customer name or whatever is easiest for you so if you say like invoice 12 and we'll call it and when the invoice number is 12 and you'll see here it's automatically saving to drive and the last edit was seconds ago that's what i was saying earlier about the auto save function you cannot disable that um so anytime you make any mistakes or you want to go back an action if you wanted to get rid of an action that you just did ctrl and z to undo or the undo button here so once your invoice is done you can export it as a pdf so you're saving it as a pdf so if you just go to file and download as a pdf and you can see here it shows you like a print preview of it so you can change the settings the page orientation if you wanted to fit to width you can change all your headers footers margins etc here as well but that to me looks as a basic tutorial it looks fine and then you would just go to export and that would save it as a pdf to your pc so we'll just come out of there and that's it that's how to quickly create um a simple invoice so once that's done you can then come out of it so you'll see this is actually saved now in your drive so if you wanted to create the next invoice say like invoice number 13 you could right click on here go to make a copy and this will create a copy of this invoice and then once it's copied you'll see here copy of invoice 12 right click again and rename and you can just rename it invoice 13 and ok so this is now saved as invoice 13 and then if you click into here you'll see in here it's invoice13 here and it's just a matter of overwriting the details as per your next invoice and again once the users have changed go to file download as a pdf save it as a pdf so you can see everything here export it save it as a pdf and then email it onto the customer as per normal and that's it i hope you found that helpful any questions let me know in the comments below and until next time happy learning this is xena the office dog and she would love it if you could watch this video just here or maybe even this video this video is good as well nope she actually prefers this video just here or maybe this one this one's really good actually yeah this one oh do you know what you decide