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

Create invoice in google sheets for Accounting

in this video you'll learn how to create an invoice just like this one for your own business and share it with your clients right from your phone or laptop and the best news is we're using 100% free tool so make sure to pay extra attention to the second part of this video because that's when we'll be turning this normal cani invoice into a practically automated one that does any calculations for you so welcome to the code of female excellence and and let's get started so step number one is choosing the style of your invoice in Cana and you may choose any cell that you like but for the purpose of this tutorial we'll be using this free template that I'm linking down below for you you can see that at the top right corner of this template there's an area for your logo so all you need to do is upload your logo into your canva library click it and place it right where you want it to go you can then delete any placeholders underneath it by going to position layers and deleting the placeholder and for this part it might be better to keep your guides on mainly because it's easier to see see if the alignment is right so to show or hide your guides in canva just go to file settings and click show rulers and guides now at the top of your invoice is your client's name and contact information so just make sure to come back to this and fill it out right before sending your invoice a super helpful tip here is having a document with all your business information so you can simply copy and paste things more easily you can copy and paste your name or the name of your business your business address your email or phone number and then copy and paste your payment information which is what your client will use to pay for this invoice so make sure to include details like the name of your bank the account holder name name which you can check with your bank but it's usually your name or the name of your business and your bank account number then you can start adding your invoice items so go right ahead and add your first item then add its price the quantity which is how many of this product or service you client is purchasing from your business now if you have more than one product or service to include in this invoice you can add them as well next you can delete any text or values that you won't be using and if you want to learn how to manually calculate your invoice field each time you send an invoice this part of the video will be very useful for you but if you want your invoice to automatically do any calculations for you you can click on the timestamp below and go straight to that section so to calculate the sub totals for each item simply multiply your unit price by the quantity and the result is your subtotal for that item next to calculate this subtotal right here we'll be adding each subtotal from the items that we just calculated for this example we have one item price at $100 and on line two we have two units of our second item priced at $100 each so $100 plus $200 gives us a sub total of $300 before tax now if there's any tax to be collected we can calculate it too but if there's no tax I'll also be teaching you how to adjust your invoice for that in a few moments now this may be different depending on where you live so make sure to do your research about any tax regulations and requirements you have to comply with so for example if we have to add an 8% tax all we need to do is take our subtotal amount and multiply it by 0.0 and the value of our tax so we'll just multiply 300 which is our subtotal before tax by 0.08 our tax value and this gives us a tax amount of $24 so we'll be typing that in the tax field and now to calculate our grand total we'll just be adding our subtotal before Tax Plus the tax that we just calcul calculated and that gives us our grand total which is $324 and if you live somewhere where you're not required to collect any tax with your sales you can easily adjust your invoice by just copying this total sale right here and pasting it on this other cell right here and your grand total will be ready you can then delete these two rows by pressing shipped on your keyboard then selecting them clicking on these three dots right here and selecting the delete two rows you can also delete this subtotal right here and you'll be ready to continue now you can add your invoice number and the date of your invoice and if you've given your client any payment or credit terms which is the amount of days that they have before paying for your invoice you can specify that right here but if you want your client to pay for this invoice right away you can just use the same date for the invoice and it's due date and if you want to add your name with a thank you right here you can do that by simply clicking and typing your name in the placeholder and now your canva invoice is ready to be sent to your client all you need to do is Click Share download select your file type which is usually a PDF file and download on your phone you can repeat the same process just tap the option to share download select your file type and tap download so are you ready to make your way into a beautiful world where you can just type your amounts and your invoice magically does any calculations and math work for you so we just created our invoice using canva and now we're ready to turn it into a self- calculating one so head on over to the link below where you'll find this ready to go Google sheets online template now all you need to do is copy and paste your business information onto your Sheets file and maybe you'll notice that your cells have lost their formatting when you did this but this is easily fixable by just selecting this upper cell right above your new El then selecting this spaint format tool right here and then dragging the original formatting onto the business details that you just pasted then copy and paste your invoice items and you can use that same trick right here and their prices then you can delete any unnecessary Fields so to automatically calculate each subtotal we'll just delete the zero value that we have and simply type the equal sign on your keyboard now select your unit price then type the asterisk symbol which is a multiply sign in Google Sheets and Excel then click on the quantity of your first item and just hit enter to get this first subtotal so for your next subtotal just repeat the steps once again select the price of your second item then the asterisk or star symbol the quantity of your second item and hit enter and if for example you have any more items on your invoice you can also use the super quick trick by selecting the bottom right corner of this subtotal and dragging it until all your subtotals have been calculated now to sum all your subtotals just go to the subtotal cell right here delete the zero value and type the equal symbol and then just drag it across your entire sub totals column and your subtotal line should now be ready then we'll calculate our tax and we'll do this by selecting this cell right here next to tax delete any values in it and type the equal symbol then selecting the subtotal cell right above it then the asterisk symbol and then type 0.0 and the value of our tax so for this example if we're using using an 8% tax we'll be typing the number eight and hit enter to calculate our tax to calculate your grand total just go to the cell right next to Total delete any values in it then click the subtotal right above it and then type the plus symbol on your keyboard and click this tax value that we just calculated and hit enter so your invoice Cal calculations are now ready and all there's left to do is add your logo by going to this upper menu right here click insert image insert image over cells then just drag and drop your logo right here place it where you want it to go and delete the logo placeholder then just copy and paste your invoice number the date of your invoice and the payment date you can type your name right here on top of the thank you message and now your invoice is ready to be shared with your client just go to the upper menu right here click file download select your file type which is usually a PDF file and if your layout looks a bit off simply adjust your margin settings to narrow or wide depending on your case and on scale click fit to page and click export and to do this this from your phone just tap the three dots at the upper right corner of your screen select share and Export select save as select PDF document and okay and if you don't see the option to share it from here you can also check your Google drive files just tap the three dots now next to your invoice file and then tap the option send a copy and simply select how you want to share your invoice and now you're ready to write a polite message to your client saying hey how's everything going here's my invoice I'm happy to answer any questions for you and there you have it your beautiful self- calculating invoice that automatically does any repetitive math work for you if you have any questions or this didn't work right for you please please share any questions in the comment section down below and if you found this video helpful please consider liking sharing and subscribing to kitty mle for more tutorials like this one [Music]