Skip to main content
InvoicingTemplate.com main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

Screenshots and Images

The printed version.

Simple Sample - Manually Fillable Line-totals

Simple Sample - Manually Fillable Line-totals (c2028)

c2028 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open simple-invoice-template-fillable-line-total-uis.xlsx.

Simple Sample - Manually Fillable Line-totals (UIS Edition)

Simple Sample - Manually Fillable Line-totals - UIS edition

Download - Simple Sample - Manually Fillable Line-totals

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

Without database file. How to download and use

73 KBDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

297 KBDownload

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

2.79 MBDownload

Detail

The "Line-total" value could be calculated from "Quantity * Unit Price" or "Hours * Hourly Rate". This simple template shows you how to make the line-total manually fillable.

We've already seen sample on how to moving fields to create a new invoicing format in this serial of simple invoice templates. Such as with c4049 Simple Invoice Template - Moving Item# Column, we moved out the entire Item# column to create a new layout. Uniform Invoice Software is flexible enough to support this type customizations. By adjusting / customizing the formulas, it is also possible to define (or re-define) the relationship between cells.

In this sample of simple invoice template, we look at how to move out the Quantity and Unit Price column, remove the formulas of all the "Line-total" cells to make it manually fillable. With this design, the line totals will not be calculated automatically, but be filled in manually. This is useful businesses, such as service providers, who charge customers on a project-basis.

Here are the steps to do the customization.

  1. Backup the template that you want to customize. This allows you to start again if something goes wrong during the customization steps.
  2. Open the template.
  3. Switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab.
  4. Drag your mouse on all cells on the Quantity column to select the cells, ranging I21:I33. Drag on the border of the selected area and move to the new location of this column - in this sample, we choose the new location starting from X21.
  5. Do the same movement for the Unit Price column, from original address J21:J33 to the new location starting from Y21.
  6. Drag your mouse to select all the cells for the "Description" heading, including two empty cells on the same row next to the heading, ranging D21:J21. Click the "Merge and Center" button on Excel "Home" ribbon tab twice - the first click on the button unmerges the originally merged cells (i.e. the original "Description" heading), the second click on the button merges all the selected cells - this will be our new "Description" heading.
  7. Drag your mouse to select all the cells for the "oknProductName_1", including two empty cells on the same row next to "oknProductName_1", ranging from D22:J22. Click the "Merge and Center" button twice. Like the previous step, the first click unmerges originally merged cells, and the second click merges all the selected cells.
  8. Repeat the above step for all the other "oknProductName_?" cells ("?" - from 2 to 12).
  9. Drag to select all the "oknProductName_?" cells, ranging from D22 to J33. Click "Align Left" in the "Alignment" group on Excel "Home" ribbon tab.
  10. Drag mouse to select all line total cells, ranging K22:K33. Hit DEL key on keyboard to delete all the formulas assigned to these cells.
  11. Right-click one of the selected line total cells, choose Format Cells from the shortcut menu. On the Protection tab, clear the "Locked" property. This will make sure that when the worksheet is protected (i.e. when you are creating invoices), the line total cells are manually fillable / editable.
  12. Click the "Design Mode" button on the "Invoice" ribbon tab again to exit design mode.
  13. Click the Settings button on the "Invoice" ribbon tab.
  14. On the "Template" tab, check "Allow incomplete lines on invoice body" option. Click "Apply" and then "Close" to close the Settings dialog box.
  15. Save the template by clicking "Save" command on Excel quick access toolbar.

To verify the completeness of an invoice, Uniform Invoice Software checks the data entered on the form before saving an invoice. During this check, it shows warning if an invoicing item does not have "Quantity" or "Unit Price" filled in. By enabling the "Allow incomplete lines on invoice body" option, Uniform Invoice Software will save items without quantity and unit price for this simple invoice template.

Like other form designs here on InvoicingTemplate.com, Simple Invoicing Format - Manually Fillable Line-totals 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.

Format and Specification

Template#c2028
NameSimple Sample - Manually Fillable Line-totals
CategorySales Invoice Template
Release DateTuesday, February 2, 2016
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns2
Lines12
Line Height (Points)18.00
Print Area$D$2:$K$47
Printable with Papaer Size / OrientationSimple Sample - Manually Fillable Line-totals - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35