Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Netherland Service Invoice Template 2. Double-click the downloaded file to extract all files.
  2. Open the template "netherlandservice2.xlsx" or "netherlandservice2-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

Netherland Service Invoice Template 2

Netherland Service Invoice Template 2 (c5051)

This is how the template looks like when you open the freeware template in Microsoft Excel.

Netherland Service Invoice Template 2 - freeware edition

Netherland Service Invoice Template 2 - freeware edition

The following template was designed for Uniform Invoice Software version 3.

Netherland Service Invoice Template 2 - Uniform Invoice Software V3 edition

Netherland Service Invoice Template 2 - Uniform Invoice Software V3 edition

Download Netherland Service Invoice Template 2 (c5051)

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 UIS, but are looking for additional customized templates.

311 KBDownload

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

2.79 MBDownload

Detail

Netherland Service Invoice Template 2 is created from c5050 Netherland Sales Billing Form 2. It differs from the original sales invoice template in that it does not include the shipping address section and thus is suitable for those service businesses.

Just like the original version, this service invoice template (Netherland Service Invoice Template 2) also has the VatID custom field defined in both the Customer and Invoice Header database tables. On the invoicing form, this field is named oknVatID. Note that this field should be unprotected in order to be manually editable when the invoicing form is protected. To unlock a cell / field, you should firstly unprotect the Invoice worksheet.

The protection of the "Invoice" worksheet in Netherland Service Invoice Template 2 prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the worksheet. However for the purpose of this sample, we should firstly unprotect the worksheet in Netherland Service Invoice Template 2.

The "Lock" property is a very useful feature in Excel. When you protect a worksheet such as Netherland Service Invoice Template 2, all cells are locked by default, which means that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only specific cells and ranges before you protect the "Invoice" worksheet of Netherland Service Invoice Template 2. To lock a cell or a range of cells, first drag your mouse to select the cell or cells, and then right-click one of the selected cell on the form, choose Format Cells. On the Number tab, check the "Locked" box. To unlock a cell or a range of cells, simply clear the "Locked" box.

Tip: If you create a formula for a field or a cell be sure to lock it otherwise a warning mark appears on the cell. On the other hand, if you remove a formula from a locked cell in Netherland Service Invoice Template 2, unlock the cell to make sure it is editable when Netherland Service Invoice Template 2 is protected.

Like most other invoicing templates available here on InvoicingTemplate.com, Netherland Service Billing Form 2 has a default Logo image on the top of the invoicing form. This is a placeholder of your own logo image. To replace it with your own image, you should firstly switch the template into design mode.

In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Netherland Service Invoice Template 2. Note that if you have our invoicing program installed, and you are running Excel 2007, Excel 2010 and Excel 2013, it already provides a Design Mode button on the ribbon tab, so that you don't have to switch to design mode manually. Our invoicing software is able to turn a simple spreadsheet into a powerful invoicing system, with the ability to manage customers, products, bills and payments, it also includes various tools that could help you configure the layout of your form, such as the number of taxes and tax names and rates. If you don't have our invoicing program installed, here are how you can switch to design mode manually.

  • In Excel 2003 click the Design Mode button on the Control Toolbox toolbar. Tip: If the Control Toolbox toolbar is invisible, click Excel menu View > Toolbars > Control Toolbox.
  • In Excel 2007, Excel 2010 and Excel 2013, click the Design Mode button in the Controls group of the Developer tab.

    TIP: If the Developer tab is not available in Excel 2007, do the following to display it: a) Click Microsoft Office Button, and then click Excel Options; b) In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

    Or in Excel 2010 and Excel 2013 to display the Developer tab: a) Click File > Options > Customize Ribbon; b) In the area on the right, ensure that the box next to Developer is checked; c) When you click OK, the Developer tab will appear in the ribbon.

Once you have finished your design work for Netherland Service Invoice Template 2, click the Design Mode button again to exit design mode.

You may notice that we are using a similar color schema on many invoice template here on InvoicingTemplate.com. If you are familiar with Microsoft Excel, you may already know that it is fairly easy to change the color of one or more cells. To quickly change the color schema of the invoice form, you can even change the color palette. Here is how you can do it.

  • Open Netherland Service Invoice Template 2 as usual.
  • Click Excel menu File, and then click Options.
  • Click Save.
  • Next to Choose what colors will be seen in previous versions of Excel, click Colors.
  • Click the color that you want to change - for example, the fourth on the last line, and then click Modify.
  • Specify the new color. Click OK to close the Colors dialog box.
  • Click OK to close the Color dialog box. Click OK again to close the Excel Options dialog box.

This invoice template uses Excel formulas to translate the address format, as detailed on office-kit.com at Invoice Template for Holland Clothing (Wear) Company or Shop. The office-kit.com version is also available here on InvoicingTemplate.com at Netherland Sales Invoice Template, and its service edition at Netherland Service Invoicing Template.

Like other form designs here on InvoicingTemplate.com, Netherland Service Billing Form 2 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#c5051
NameNetherland Service Invoice Template 2
CategoryService Invoice Template
Release DateSunday, May 25, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Columns5
Lines12
Line Height (Points)19.50
Print Area$F$2:$O$41
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Sample Templates