The printed version.
Simple Sample - Building & Remodeling Invoice (c4056)
c4056 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open simple-sample-template-building-remodeling-uis.xlsx.
Simple Sample - Building & Remodeling Invoice - UIS edition
You are safe to download the resources. We've added our digital signatures to the files.
Without database file. How to download and use
Download this if you have already installed UIS, but are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
To make your own template works with Uniform Invoice Software (UIS), there are a number of works to do. This simple invoice template for building & remodeling service gives a sample and details the steps.
Please also visit Construction Invoice, Simple Invoice for Construction Business and Construction Proposal Template if you are interesting in the business document formats and samples for building and remodeling service.
In the Creating and Customizing Invoice Template document, it was stated that all invoicing templates that works with UIS should be created from, or the final base template should be, the default template shipped with UIS. All templates available here (except this one) on InvoicingTemplate.com adhere to this rule.
The reason for this is that, in order to have UIS work with a template, the template must meets the requirements of UIS, including (but not limited to) many hidden fields that specify the connection with database, preference for printing, options for PDF generating and emailing etc.
So our recommendation is that, if you have a very special and private invoicing format / invoicing layout that you want to make it work with UIS, the best way to customize based on the default template shipped with the program, or based on any template that you can download here on InvoicingTemplate.com. Microsoft Excel provides handy and abundant tools for you to customizing our templates.
That has been said, if you still want to use your own template with UIS to utilize all the powerful features such as database connection, management of customers, products, invoices and payments, reporting, etc., the good news is that - it is possible, although not so easy and quick.
With this simple template sample, we details the steps and process required to integrate a building and remodeling service invoicing template with UIS. The result of this tutorial is a ready-to-use template that is suitable for businesses who offer building, construction, design, remodeling services. Download and try this template for free if you are in this business!
Let's how to make a building & remodeling invoicing sample work with UIS.
For the purpose of demonstration, in this sample we put all usually-hidden names on visible area outside the printable area, where we also put the name as clear text to the left of the defined name. For example, the cell $T$6 was named oknDatabaseName, then the text "oknDatabaseName" shows on $S$6. Since value of "oknDatabaseName" was written each time UIS connects with a database, this cell was unlocked.
|Names defined for your own company information. The report worksheets reference to these names. If omitted, you can type in the required information on report worksheets individually|
|oknCompanyName||$F$2||Yes||Your own company name|
|$F$4||Yes||company city, state and zip|
|oknCompanyContact||$F$5||Yes||company contact, email and web address|
|Name defined for hidden cells|
|$A$10||No||"Tax2 is applied to Tax1" option on Settings dialog box|
|$A$11||No||"Tax total including shipping cost" option on Settings dialog box|
|oknTax1RateDefault||$A$12||No||Tax 1 rate set on the Settings dialog box|
|oknTax2RateDefault||$A$14||No||Tax 2 rate set on the Settings dialog box|
|oknTaxType||$A$8||No||Tax type set on the Settings dialog box. Could be 0, 1 or 2|
|Visible cells. Usually put outside the printable area|
|oknDatabaseName||$N$3||No||If the template connected with a database successfully, this cell shows the database name|
|oknStatus||$N$5||No||The status of current invoice, "Pending", "Paid" or "Void"|
|oknInvoiceDate||$K$4||No||The "Clear & New" command fill the current date into this cell|
|oknInvoiceID||$K$5||No||The "Save Invoice" command fill this cell automatically if left empty. Uniform Invoice Software shows the content of an invoice if you enter an existing invoice# into this cell.|
|"Bill To" section|
|"Ship To" section|
|For the "Info line" below the "Bill To" section|
|oknOrderID||$D$19||Yes||Purchased Order Number. On the default template it is below the label "Order ID"|
|oknPaymentTerm||$J$19||Yes||If defined, Uniform Invoice Software shows "In-cell Picker" for this cell|
|oknSalesRepName||$F$19||Yes||If defined, Uniform Invoice Software shows "In-cell Picker" for this cell|
|oknShipVia||$I$19||Yes||If defined, Uniform Invoice Software shows "In-cell Picker" for this cell|
|Detail section. Each line has these names defined. For example if you have 5 lines, you need to define 5 names from oknProductID_1 to oknProductID_5, and 5 names from oknProductName_1 to oknProductName_5, and 5 names from oknLinetotal_1 to oknLinetotal_5, and so on. If you need a batch naming tool, contact us.|
|oknProductName_1||$F$22||No||Product (item) description of each item|
|oknProductID_1||$D$22||No||Product# (Item#) of each invoicing item|
|oknTaxable_1||$A$22||Yes||Each "Taxable" check box link to one of "oknTaxable_?" cell|
|oknCost_1||$B$22||Yes||"Cost" of each product item. Default is 0|
|oknSubTotal||$K$34||No||Default formua: =SUM(oknLineTotal_1:oknLineTotal_12)|
|oknTax1Name||$I$35||No||Tax 1 name defined on the Settings dialog box|
|oknTax2Name||$I$36||No||Tax 2 name defined on the Settings dialog box|
|oknTax1Rate||$J$35||No||Tax 1 rate. "Clear & New" button fill this cell with the value of oknDefaultTax1Rate|
|oknTax2Rate||$J$36||No||Tax 2 rate. "Clear & New" button fill this cell with the value of oknDefaultTax2Rate|
|oknTax1||$K$35||No||Default formula: =ROUND(IF(oknTaxType=0, 0, oknTax1Rate*(oknLineTotalTaxable+IF(oknTaxTotalIncludingShippingCost =0, 0, oknShippingCost))), 2)|
|oknTax2||$K$36||No||Default formula: =ROUND(IF(oknTaxType<>2, 0, oknTax2Rate*(oknLineTotalTaxable+IF(oknTaxTotalIncludingShippingCost =0, 0, oknShippingCost)+IF(oknTax2IsAppliedToTax1=0, 0, oknTax1))), 2)|
|oknShippingCost||$K$37||Yes||Manually fillable on creating invoice|
|oknTotal||$K$38||No||Default formua: =ROUND(oknSubTotal + oknShippingCost + IF(oknTaxType=0, 0, IF(oknTaxType=1, oknTax1, oknTax1+oknTax2)), 2)|
|oknBalanceDue||$K$40||No||Default formula: =ROUND(oknTotal-oknPayments, 2)|
|oknLineTotalTaxable||$B$34||Yes||Total amount that used when calculating tax. If omitted, your taxing formula cannot use this name. Default value is zero|
|oknPayments||$B$39||No||Total amount of payments applied / posted to this invoice.|
|oknNotes||$D$38||Yes||The "Notes" of each invoice.|
Every business is different, and we know that you want to use an invoicing form that is specific to your business. With this template sample, we copy an existing invoicing layout for a building and remodeling service business into a template built for our invoicing software, and make our invoicing program work with the new form.
Like other form designs here on InvoicingTemplate.com, Simple Sample - Building & Remodeling Service Invoice is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.
|Name||Simple Sample - Building & Remodeling Invoice|
|Category||Service Invoice Template|
|Release Date||Monday, February 1, 2016|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||20.25|
|Printable with Papaer Size / Orientation||Simple Sample - Building & Remodeling Invoice - Portrait|
|Default Margins (Points)|