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.

Business Invoice for Netherlands

Business Invoice for Netherlands (c5147)

c5147 now includes the customized invoice template for the latest version of Invoice Manager for Excel. This is what you will see when you open businessinvoicesfree.xlsx.

Business Invoice for Netherlands (IMFE Edition)

Business Invoice for Netherlands - IMFE edition

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 want this design to be set as the default template by the installer program.

3.90 MBDownload

Without database file. How to download and use

653 KBDownload

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

1031 KBDownload

Detail

This template is created based on c5116 Business Invoice Template. It changed not only the color theme of the original template, but also the display format of the "City ZIP" field etc.

The purpose of the modifications is to make the template suitable for Netherlands-based business, according to the requirements detailed at c6009 Netherlands Sales Invoice Template.

First, we inserted a new row under the seller business information section and marked it with the text "VAT#", which meant you can enter the VAT identification number of the supplier / seller.

Secondly, we modify the display format of the original "City ZIP" line, so that it shows "ZIP city". For example: Los Angeles, 12345 in Holland it is normal to put the ZIP first and then the name of the city. For example: 12345 Los Angeles, or "1234 AA Amsterdam".

To do this, we moved the "oknWhoCityStateZIP" and "oknShipCityStateZip" cells out of the printable area. This means that, when you enter new customer information, you should always enter these two values into the cells outside of the printable area.

Then, the following formula is applied to convert "City ZIP" to "ZIP City".

=CONCATENATE(RIGHT(oknWhoCityStateZip,LEN(oknWhoCityStateZip)-FIND("^",SUBSTITUTE(oknWhoCityStateZip," ","^",LEN(oknWhoCityStateZip)-1-LEN(SUBSTITUTE(oknWhoCityStateZip," ","")))))," ",LEFT(oknWhoCityStateZip,FIND("^",SUBSTITUTE(oknWhoCityStateZip," ","^",LEN(oknWhoCityStateZip)-1-LEN(SUBSTITUTE(oknWhoCityStateZip," ",""))))-1))

Finally, in the "Bill To" and "Ship To" sections inside the printable form, the following formula is applied to show the "ZIP City" in the desired format:

=IF(ISERROR(P18),"",P18)

The tax name of this template is set to "BTW (VAT)". All the text labels on this template are still in English, instead of Dutch. If you prefer to translate the text labels, you can do this easily by type in your own text to replace the default ones in Design Mode. The sample at c6009 Netherlands Sales Invoice Template offers a complete sample for this.

Like other form designs here on InvoicingTemplate.com, Business Invoice Template for Netherlands 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#c5147
NameBusiness Invoice for Netherlands
CategorySales Invoice Template
Release DateSaturday, November 3, 2018
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns5
Lines12
Line Height (Points)18.00
Print Area$D$3:$L$46
Papaer Size / OrientationPortrait
Default Margins (Points)
Left18.00
Right18.00
Top75.60
Bottom75.60