Create and Manage Your Excel Invoice Template with Database for Administration

Excel invoice template with database for Administration

hello and welcome to so maker contractor invoice template this tool mainly prepares a professional looking contractor invoice to your clients it is constructed by five parts these are a moyes customer database material database labor database and lastly payment database so let's start with customer database enter your customer details for each section the information you will input in this section will be used dynamically in the invoice if you would like to add more than 20 customer press plus sign to get additional rows so let's give an example now we may carry on with a material database enter your material details for each section once you enter the info for all the products they will be ready to be chosen dynamically on the invoice you may also press the plus sign to get additional rows so let's give an example for also the material as well let's carry on with a labor database enter your labor details for each section as you did in the previous sheets you may also press the plus sign to get additional rows and lastly the payment database enter your payment details options to be able to display it in the invoice later now your template is ready to create your invoice enter your company details and logo type the invoice number Amoy state and due date to retrieve customer information click on the cell which custome name belongs and once you select the required company the information below will be displayed automatically please don't forget not to input any data in the great gray cells to add item on the list for materials and labor choose the cell below them once you do it the price and the unit type will come up automatically the only thing that you have to do is type down quantity and hours once you type down the quantity an hour you will see the cost will be calculated dynamically and under each group you will find the sum of materials and the sum of labor the other section is not dynamic because it may contain some specific and non repetitive work enter the details of the other work write down its quantity or hour and its price so let's say other work one and let's say the quantity is 5 hours and the unit price is $20 per hour makes 100 and we can see the total other costs in the below section if you have any notes for explanation or an additional comment you may use details of services section to type in if you will apply any discount please enter the discount amount right next to the discount self just the tax rate cell ing to your own tax system choose the best payment method for your customer since you have entered your payment details to the payment database once you choose the payment method you will retrieve the information about the payment option you choose and now your invoice is ready to be printed thanks for watching and don't forget to check our other templates at .spreadsheetrepublic.com