Collaborate on Google Sheets Invoice Generator for Building Services with Ease Using airSlate SignNow

Google sheets invoice generator for Building services

hello i'm melvin from creative now in this video we'll be introducing our creative invoice generator system which we believe that this will be able to help small businesses in their documentation work you could look at the description section to move around to different sections of this video since the rise of e-commerce platform like amazon lazada shopi we receive many feedbacks from michael or small businesses that they have issue or not sure how to generate receipt invoices for their sold products that is the reason we introduce creative invoice generator system this creative invoice generator system is built on google sheets and is aimed for micro and small businesses so that you don't have to subscribe to costly invoicing system that has a lot of features that you don't really need this is fairly easy and straightforward to use you can use this as part of the e-commerce system which might not have official receipts or invices for customer or you can use it for other platform or offline transaction such as your own shop or even sales from whatsapp [Music] these sheets consist of simple automation such save as pdf save as record add google contacts and email to customer which we will cover it in the demo section afterwards if you require more advanced features such as inventory management customer records sale records income and expenses records so and so forth please write in the comment section below so that we will complete the development of a complete all-in-one system as soon as possible which will be sold separately let's continue with our installation process on creative invoice generator system first go to creative dot page dot link slash invoice and you should be arriving this page before i begin the installation process please make sure that you purchase the add-on from our shop which is shop.creativenow.com or shopping malaysia [Music] after purchasing the system you should be receiving one email stating that your access has been granted to your email address and once you receive this email you can proceed to the installation after arriving the creative.page.linkslash invoice follow the steps stated inside the web and you should be [Music] having a complete system set up for you to use without further ado i'll walk you through the step-by-step installation process for the first step press on the make the copy orange add button on the right after that click on the make a copy at this step you are copying the whole creative invoice generator system to your google drive and if you don't have a google drive or gmail account feel free to look under the description section and we'll be providing a link which a video that dedicates to you on how to create a new gmail account [Music] so you should be getting this system in your google drive and upon complete copy you should see enter passcode to process pop-up box for the next step make sure to copy the google sheet url which located at the above the web browser the one that i highlighted [Music] after that go to creative dot page dot link slash generate and if you don't have x you are the first time to access our passcode generating system you should be seeing this page click on the review permission and select the account that you have provided during your checkout for this system and if you see this page don't worry click on the small advanced button below scroll down to the bottom and click on go to undated projects go through the permission needed and click on allow [Music] after the authorization successful you should be reaching the page that allows you to enter your google sheet url and if you see this page don't worry click on refresh and if you keep seeing the same access error page feel free to contact us so paste the google sheet url that you have complete copied earlier and click on submit [Music] so once the passcode has been generated please copy down the passcode and then paste on this box and click on yes you should be receiving a verified pop-up box and if you don't have any pop-up box the verified box is not there just refresh your sheet [Music] and once the enter of passcode pop up is there paste the passcode inside the box and click on yes [Music] so once the passcode has been verified you may continue to use the google sheet as long as you like [Music] so before the automation can be worked please authorize it by clicking on save as pdf so you will see this authorization required pop-up box click on continue select the email account that you are using and repeat the step like just now click on advanced scroll to the bottom and click on go to creative invoice generator read through the permission needed and click on allow [Music] and once authorization is successful you can use the automation inside this google sheet now let's begin with creative invoice generator system demo or user guide so go back to your creative invoice generator system so with this system the first thing you can do is you can change this type of document to receipt quotation or purchase order by clicking on the wording so in this demo i'm going to use invoice wording the second thing that you'll need to do is to change the information on the right hand side so you need to you can fill in your company registration number your company name business address contact number email and so on on the right hand side so for example i can fill in my company name as my company abc if you have company logo you can change it by clicking on the logo button three dots on top right and then click on replace the image to your company logo and if you don't have any logo you can just delete [Music] it so coming up the next thing will be you'll need to fill in the company the customer's company name or customer name on the bill to section so just fill in whatever info that you have from the customer customer contact customer email address and so on so i can fill in like company xyz so the address i'll fill a sample address [Music] for a contact number you so these are all the examples for the email address i'm going to put a test email address so these two will be very important for you if you wish to use the add google contacts or email to customer function the date will be mostly today or you can change the date to any date that you wish to put and for the invoice number you can customize it as like as long as you like so some of them do have some prefix on their invoice number based on your company and some of them just have the numbering so this one will be ing to your requirement for your company next one will be adding the product code description quantity on your invoice so example for this item one i'll be adding the product as item a description probably creative invoice system so for the quantity you can put three and then for the unit price would be price of one unit of this item so if i'm pricing this item as five then you'll be 15 for quantity of 3 and you can put any discount that you like so if you put it as discount 1 then the amount would be 14 and the other thing i would like to share with you is if you are not from malaysia and you would like to change the currency to your country's currency just select all the currency part click on format numbers more format more currency and you can choose whatever currency that you like for example i wish to change it to us dollar so i just look at the us dollar sign and click apply you will automatically change it to the currency of your country so let's continue on this you can add add or delete whatever item that you like so if you have only two items you can just delete the rest and if you are adding more item please add it between item one and item 5 so that the formula would be added correctly so to see whether if the form formula is added correctly look at the total and the total should be the sum of all this item from h24 cell to h31 and if your item is not added in please change the formula to add in [Music] so let's continue if you have any text you can just directly put that here for example if you had you have digital text you can put it as six percent of digital tax and what's the how much are you charging for the shipping so you can just i just put a number for you guys to look at it so let me do it for more items [Music] so no discount okay so after adding all this item after adding all this item you can put a small note here or you can delete from it so for your note here you are you can put it as how do customer pay for you or how long is the invoice valid so on and so forth so if you are not adding any notes you can delete this section okay so now i'd like to show you the first function that automation that this invoicing system has is the safespdf so when you click on save as pdf you will show now downloading and then if you have a pop-up blog please allow it so you click on it again and the file will be saved as pdf in your computer so if you click on it so if you click on it you will see the pdf version of this invoice saved in your computer so the next thing you can do is you can put your pdf in your cloud storage system or for your own reference and for the next part save to record the second function this will help you to save a record to the record tab so that you remember that i have sent this invoice to the customer and it will help you to record down every information such as the total price total discount shipping fee tax and so on to which customer [Music] and when is the date generated for this invoice so this helps you in bookkeeping allow you to have better records of your invoice [Music] so on the next function if you are going to email a pdf copy to your customer without downloading it then you can click on the third function email to customer for this function to work make sure that your b20 make sure that your b20 column or cell is added with the customer's email address only then you can use the third function click on the email to customer it will directly bring you to the draft of your gmail with all the information the invoice attached as pdf to the draft email as shown in my screen so you have all the information filled in correctly or template from there you can customize or add any wordings that you would like before sending it to the customer and if you can't see this small pop-up pop-up window you can go to the draft and click on the draft so if you are you are you are seeing this type of interface instead of the pop-up you can go to the draft and click on it so it will be the same so you can add whatever information that you like before sending it to customer so when you are ready just press send and it will automatically email to the customer so as you can see [Music] the email looks like this so when customers click on it they are able to see the pdf copy of the invoice so let's go back to the invoice generator system [Music] the fourth function that i would like to introduce you is add to google contacts so in this function you can add customers email address and contact number directly to your google contact so let me demo it you just click on add google contacts and you should see that company xyz or the your customer's name has been added in google to contacts to look at the information you can go to context.google.com or if you can't remember you can go to your google drive and then look at the nine dots on the right and search for the contact and click on it so it's the same so you can see there's a label named creative invoice that will be the contacts that you added using our system so you can see the customer name or customer company name is there with their email and phone number so this automation helps you to simplify adding context customers contact into into your google contacts and if you sync your google contacts to your phone or other devices you should be seeing this contact appearing in your phone as well or other devices as well [Music] and for the last function clear customer data this will help you to clear every data that you have regarding to this customer so clicking on it will help you to make it a reset so that every item has been reset to their initial condition except for your company information [Music] and if you realize after pressing the reset button the invoice number will helps you automatically to add one on top so that if you are going for running number you don't have to change it again so that's all for my demo and if you are interested please purchase this system and make your life easier your business better thank you for watching you