Create Your Individual Invoice Template for Administration Effortlessly

Individual invoice template for Administration

hello everyone I have created an invoice management template in Google Sheets and Google app script to manage my invoices flexibly fast and easily at the top of the right corner I have included three buttons such as dashboard clients and invoice generator the dashboard button is this tab that is currently on the client tab includes the recording of new clients and viewing the list of clients and the invoice generator is the list of clients and articles included to generate invoices below or three score card charts total clients recorded through the client button total products including the number of products SL articles that have been recorded and total invoices that include the invoices recorded below is the table chart including the list of the invoices with the details and the total amount at the right corner is the column chart that includes the recorded clients based on the business type let me authorize the script first to proceed further by clicking on the client button it will redirect to the client sheet it includes the drop- down list and it will give all the business type lists that the recorded clients and the list will appear in the table Below in the right corner there is a button that will open the pop-up screen to record a new client in front here is the data button that will open the table with the complete clients list the third button is invoice generator it includes the drop- down clients list to select there are several buttons in the right corner with different functions the first right button opens the popup screen to add a new product all the products will be listed in the Blue Table below the second button redirects the screen to the print imv tab which will pull the details from this tab and prepare the invoice template ready for print the third button redirects to the products list to change the status if the client has paid unpaid or partly paid invoices fourth button includes a popup screen to record the details of the invoice it will pull the client information and generate data in the below table that will be pulled in the print EnV tab the last button includes the details list of whom we are preparing the invoice to let's first record one client and then let's create a new record for one new invoice the client that we have just recorded will be listed in the drop- down list as a company name we should primarily select the client and then create a new invoice for that client all the details from the client tab will be pulled to the table below we can add multiple invoices for the same client or switch to a different client the mandatory is to select a checkbox to identify which invoice we want to update with the products then we click on the primary button at the end of the page it will open the popup screen to add a new product we need to fill description quantity and unit quantity price we can add multiple products for each invoice that we checked with the checkbox if we want to add products to another invoice we need to change the check box to the desired invoice and then fill out the details of the product for each invoice it will give the total invoice amount that we have just added to each invoice separately if we finish the list of articles that we are or have been selling to the client we click on the second button and it will redirect us to print EnV all the details will be pulled to the print EnV tab it will be identified as invoice unpaid where you can easily change the status to the partly paid or invoice paid by the client the changes can be done through the product list tab mentioned in the invoice generator tab in the dashboard you will notice the updates to the scorecard chart table and column chart if you have any questions or any feedback let me know in the comment below