InvoicingTemplate.com main content

Download

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

721 KBDownload

Download this if you want this design to be set as the default template by the installer program.

5.87 MBDownload

Screenshots and Images

The printed version.

Simple Sample - Building & Remodeling Invoice

Open the template in Excel.

Simple Sample - Building & Remodeling Invoice (IMFE Edition)

Detail

To make your own template works with Invoice Manager for Excel (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.

  1. First create a folder on Windows desktop or inside "My Documents". This will be our working folder.
  2. Copy 3 files to this folder: your own template (in this case, building-remodeling-service.xls), the default template comes with UIS (invoice.xlsx), the default database file comes with UIS (sample.mdb - but we renamed it to c4056.mdb for the purpose of publishing this document on InvoicingTemplate.com).
  3. Open invoice.xlsx.
  4. Open building-remodeling-service.xls.
  5. Click to select the invoice.xlsx template. Right-click the worksheet name "invoice" on the bottom of the spreadsheet window. Choose "Delete" from the shortcut menu. This deletes the worksheet from the template.
  6. Switch to building-remodeling-service.xls.
  7. Right-click the worksheet name on the bottom of the spreadsheet window. Choose "Move or Copy" from the shortcut menu. From the "Move selected sheets to book" list choose "invoice.xlsx", from the "Before Sheet" list choose "Sales Report", and then click OK to copy the sheet.
  8. Close building-remodeling-service.xls without saving it.
  9. Go to invoice.xlsx. Rename the copied worksheet sheet to "invoice" - To do this, double-click the sheet name on the bottom of the spreadsheet, and then enter the new name "invoice".
  10. Now comes the most time-consuming part - name the cells. There are several rules here.
    • All cells / fields that should be saved to database must have a name (How?).
    • UIS has its own name list for the Invoice worksheet, some of them are required (cannot be omitted). See the table below. The default template shipped with our invoicing software is also embed into the "default template" worksheet, which you can click to open to better understanding this table.
    • If a cell name required by UIS should not appear on your printed invoices, put it outside the printable area. For example, we put "oknSubtotal", "oknShippingCost" and all tax cells outside the printable area. Since this building and remodeling service business does not these fields.
    • If you need a field that is not in the UIS name list, define it as custom field. For example, the "Location" field is not in the name list defined by UIS. This is added to the "Invoice Header" as a custom field, with "oknLocation" as its cell name and "Location" as the database field name.
    • All cells that should be manually fillable / editable / changeable on creating invoices must be unlocked; cells has formulas assigned must be locked. For example, on the detail section the fields on the "Line-total" column are all locked; all the other fields on "Product#", "Quantity", "Price" and "Description" columns are unlocked. (See Lock and Unlock Cells)

    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.

  11. Once you have all the cells correctly named, save the template, exit Excel and reopen the template. Test it.

 

NameAddressOmit?Comment
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$2YesYour own company name
oknCompany
CityStateZip
$F$4Yescompany city, state and zip
oknCompanyContact$F$5Yescompany contact, email and web address
Name defined for hidden cells
oknTax2Is
AppliedToTax1
$A$10No"Tax2 is applied to Tax1" option on Settings dialog box
oknTaxTotal
IncludingShippingCost
$A$11No"Tax total including shipping cost" option on Settings dialog box
oknTax1RateDefault$A$12NoTax 1 rate set on the Settings dialog box
oknTax2RateDefault$A$14NoTax 2 rate set on the Settings dialog box
oknTaxType$A$8NoTax type set on the Settings dialog box. Could be 0, 1 or 2
Visible cells. Usually put outside the printable area
oknDatabaseName$N$3NoIf the template connected with a database successfully, this cell shows the database name
oknStatus$N$5NoThe status of current invoice, "Pending", "Paid" or "Void"
Heading cells
oknInvoiceDate$K$4NoThe "Clear & New" command fill the current date into this cell
oknInvoiceID$K$5NoThe "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
oknWhoAddress$F$10Yes
oknWhoCityStateZip$F$11Yes
oknWhoZipPostcode$F$12Yes
oknWhoCountry$F$13Yes
oknWhoPhone$F$14Yes
oknWhoEmail$F$15Yes
oknWhoName$F$9NoCustomer Name
oknWhoID$F$16NoCustomer#
"Ship To" section
oknShipAddress$J$10Yes
oknShipCityStateZip$J$11Yes
oknShipZipPostcode$J$12Yes
oknShipCountry$J$13Yes
oknShipContact$J$14Yes
oknShipName$J$9Yes
For the "Info line" below the "Bill To" section
oknOrderID$D$19YesPurchased Order Number. On the default template it is below the label "Order ID"
oknPaymentTerm$J$19YesIf defined, Invoice Manager for Excel shows "In-cell Picker" for this cell
oknDueDate$K$19Yes
oknShipDate$H$19Yes
oknSalesRepName$F$19YesIf defined, Invoice Manager for Excel shows "In-cell Picker" for this cell
oknShipVia$I$19YesIf defined, Invoice Manager for Excel 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$22NoProduct (item) description of each item
oknQuantity_1$I$22No
oknPrice_1$J$22No
oknLineTotal_1$K$22No
oknProductID_1$D$22NoProduct# (Item#) of each invoicing item
oknTaxable_1$A$22YesEach "Taxable" check box link to one of "oknTaxable_?" cell
oknCost_1$B$22Yes"Cost" of each product item. Default is 0
Bottom section.
oknSubTotal$K$34NoDefault formua: =SUM(oknLineTotal_1:oknLineTotal_12)
oknTax1Name$I$35NoTax 1 name defined on the Settings dialog box
oknTax2Name$I$36NoTax 2 name defined on the Settings dialog box
oknTax1Rate$J$35NoTax 1 rate. "Clear & New" button fill this cell with the value of oknDefaultTax1Rate
oknTax2Rate$J$36NoTax 2 rate. "Clear & New" button fill this cell with the value of oknDefaultTax2Rate
oknTax1$K$35NoDefault formula: =ROUND(IF(oknTaxType=0, 0, oknTax1Rate*(oknLineTotalTaxable+IF(oknTaxTotalIncludingShippingCost =0, 0, oknShippingCost))), 2)
oknTax2$K$36NoDefault formula: =ROUND(IF(oknTaxType<>2, 0, oknTax2Rate*(oknLineTotalTaxable+IF(oknTaxTotalIncludingShippingCost =0, 0, oknShippingCost)+IF(oknTax2IsAppliedToTax1=0, 0, oknTax1))), 2)
oknShippingCost$K$37YesManually fillable on creating invoice
oknTotal$K$38NoDefault formua: =ROUND(oknSubTotal + oknShippingCost + IF(oknTaxType=0, 0, IF(oknTaxType=1, oknTax1, oknTax1+oknTax2)), 2)
oknBalanceDue$K$40NoDefault formula: =ROUND(oknTotal-oknPayments, 2)
oknLineTotalTaxable$B$34YesTotal amount that used when calculating tax. If omitted, your taxing formula cannot use this name. Default value is zero
oknPayments$B$39NoTotal amount of payments applied / posted to this invoice.
oknNotes$D$38YesThe "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.

Format and Specification

Template#c4056
NameSimple Sample - Building & Remodeling Invoice
CategoryService Invoice Template
Release DateMonday, February 1, 2016
Format (XLS or XLSX).xlsx
Columns4
Lines16
Line Height (Points)20.25
Print Area$B$2:$L$50
Papaer Size / OrientationPortrait
Default Margins (Points)
Left36.00
Right36.00
Top36.00
Bottom72.00
PriceFree (0.00 USD)
SystemWindows 7 and later, and Excel 2007 and later.

Samples

Thumbnail for Simple Sample - Total Quantity on Sales Report
Thumbnail for Simple Sample - Moving Balance and Payment Cells
Thumbnail for Simple Sample - Moving Item# Column
Thumbnail for Simple Sample - Using Currency Symbol
Thumbnail for Simple Sample - Discount Amount Field
Thumbnail for Simple Sample - Moving Taxable Controls
Thumbnail for Simple Sample - Changing Paper Size