Maximize Your Team's Efficiency with a Google Sheets Invoice Template Free for Teams

Google sheets invoice template free for teams

in today's video I'm going to show you how to use the invoice template here in Google Sheets so when invoice is a document issued by a seller to a buyer that itemizes and Records transaction for goods or services it includes details such as the list of products or services that were provided the quantity and the price the total amount due and the information about both the buyer and the seller so I'm going to show you first where to find this template so first what you're going to do is to go to your Google Drive once you're in your Google Drive we're going to proceed to our Google apps right here once you click on that here are the different apps that you can use or that are provided by Google and if we scroll down there you have our sheets if you click on this you will be redirected to the sheets interface right here where you can see your past spreadsheets and your templates at the top now if you click on the template Gallery you can see all the templates that are available for you to choose from now our invoice template is right here under the work category and you'll see the template named invoice if you click on it it will redirect you to that new spreadsheet available for you to quickly edit and make your own so to edit any part of this template all you have to do would be to double click on that space and start typing so here this is the name of your company or if it's not a company if you're a professional you can just type in your name right here you also include the address if you want to some other contact details if you have an email you can add that right here that's totally up to you under our invoice we have the date now to edit this we can simply remove that part and now this time if we double click on it again it now becomes a valid date that we can simply edit with this popup calendar right here so you can choose the year the day and the month by simply clicking on this calendar right here now for the invoice for this is going to be your customer or your buyer you can have their whole name their company their address and other contact details that's totally up to you which details of your buyer you want to include in this invoice now if there are some parts that you don't really need to be in this invoice like for this one it's not really relevant you can simply select it and delete there we have it also this one there we go for the invoice number let's say you've already issued plenty of invoices before then you can simply continue entering your invoice number right here but let's say this is the first invoice that you'll be issuing to a buyer you can have this edited as 0000001 if you want that like so if we press enter you'll see that it goes back to just number one if you want those zeros included what we can do is to format this as a plain text so select that cell go to format in the menu bar select number and select plain text on the right so after formatting that we're going to try that again we're going to add five zeros right here or maybe six then the number one to indicate that this is our first invoice if we press enter this time those zeros stay in place so that's a little hack for you on how to add your zeros before your numbers here in Google Sheets next one for due date again if you want to edit that just double click on it and here we have again our popup calendar choose your date once you're done you can move on to other details here we have in our description where we're going to itemize the products or the services that we've offered to our buyer so we have item number one you can put in here let's say you've sold this person or this company some products let's say some beauty products for example lipstick color number one with with a quantity of let's say 200 and for each item it's actually sold for $10 if we press enter the template automatically computes your totals so if we double click on this you'll see that we have the function product with our cell selected right here that's going to be e19 and f19 so the product would be $2,000 and for the next one let's say another item would be eyes shadow palette number three put a space there again edit our quantity to let's say 150 press enter again it automatically calculates your total for this one but we're going to edit the price to $30 press enter there you have it so we have the description for the product or the service this can be anything depending on what you're offering the quantity the number of products that were sold and the unit price the price per item that was sold and the total price again has been calculated automatically with our subtotal we have some adjustments right here now if you don't have any adjustments you can simply delete that and there you have it let's put that zero 0 no deductions or any addition to our total amount which is $6,500 and there you have it so you have that simple invoice template that you can easily make your own easily edit all you have to do is double click on it once you're done you can simply go to print go to file select print and there you have your invoice so that's how easy it is to use the invoice template here in Google Sheets thanks for watching if you found this video helpful do leave a like And subscribe for more helpful videos see you on the next one