BoostExcel main content

Blank Service Invoice with Green Gradient Design

Template#: c2031

Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
355 KBDownload

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

Screenshot

The screen shot for Blank Service Invoice with Green Gradient Design

Detail

This applies the green gradient effects to various titles and headings, resulting in a pastel and sophisticated design. The layout supports Excel themes, so you can change the colors easily.

This template has two columns: "Description" and "Line Total". The two columns are manually editable. A "Taxable" checkbox is also provided for each item, which allows you to control separately whether each item is taxable. If all your items are taxable (or not taxable), you may not need the "Taxable" options. If this is your situation, you can easily remove the "Taxable" options and then modify the tax formula to ignore this option.

To remove the "Taxable" options, follow the steps below:

  1. Backup your template.
  2. Click the "Design Mode" button on the ribbon tab.
  3. Click a "Taxable" checkbox to select it.
  4. Hit the DEL key on your keyboard to delete the selected checkbox control.
  5. Repeat the above steps to delete other "Taxable" controls.
  6. Exit design mode and save the template.

If you want to modify the tax formula to ignore the "Taxable" options, in design mode, click to select the tax cell (which is named "oknTax1"). The Excel formula bar shows the current tax formula, like this:

=ROUND( IF ( oknTaxType=0, 0 , oknTax1Rate * ( oknLineTotalTaxable + IF( oknTaxTotalIncludingShippingCost = 0 , 0 , oknShippingCost ) ) ) , 2 )

To have it ignore the taxable options, simply replace "oknLineTotalTaxable" with "oknSubtotal", so that the formula looks like this:

=ROUND( IF ( oknTaxType=0, 0 , oknTax1Rate * ( oknSubtotal + IF( oknTaxTotalIncludingShippingCost = 0 , 0 , oknShippingCost ) ) ) , 2 )

Format and Specification

Template#c2031
Belongs to
Format (XLS or XLSX).xlsx
Columns2
Lines6
Line Height (Points)36.00
Print Area$D$4:$N$43
Papaer OrientationPortrait
Default Margins (Points)
Left50.40
Right50.40
Top66.96
Bottom75.60
PriceFree

Related

Itemized Graphic Design Invoice Thumbnail
Designer Invoice Template (Red) Thumbnail
Designer Invoice Template (Gray) Thumbnail
Creative Invoice Sample Thumbnail
5.5 Inch X 8.5 Inch: 2 Invoices On One Template Thumbnail
1/2 Page Invoice Template Thumbnail