Skip to main content
InvoicingTemplate.com main content

Sales Invoicing Format for Germanyc4098

Sales Invoicing Example for Germany

"Sales Invoicing Format for Germany" was found to be relative to Invoice Software Example Download With Client Management with the score grade of 94.

...(146) Here on InvoicingTemplate.com we've already have a category of templates for VAT invoicing at VAT Invoice Templates, which lists the Excel forms that could be used to invoicing German-based clients, this template differs from the others in that all the text labels are translated into German. As detailed at 2016 European Union VAT rates, the standard Germany VAT rates is 19% for most goods and services, although a reduced rate could be applied for some foodstuffs; water supplies; medical equipment for disabled persons; some public transport; books; newspapers and periodicals; admission to cultural events; writers and composers; agricultural supplies; hotel accommodation; admission to sports events; social services; medical and dental care. This sample template set the default rate to 19%, and assuming all items on the form are taxable. In case you need to change the tax rate with Uniform Invoice Software, follow the steps below.

...(21) This template shows no currency symbols. If you want to show the EURO symbols with certain cells, follow the steps below.

...(34) If you are not charging VAT (MwSt), you can hide the fields / cells completely by using this "Settings" box. In this case, you'll also need to add a declaration to the invoicing form,

Gemäß § 19 UStG enthält der ausgewiesene Betrag keine Umsatzsteuer.

Invoicing Format for HVAC Servicec4089

Invoicing Format for HVAC Service

"A C invoice template" was found to be relative to Invoice Software Example Download With Client Management with the score grade of 82.

...(110) Besides the usual replaceable logo image placeholder located on the top-left corner of the form layout, it also introduces a repairman image located on the top-center, which should be a suitable widget for heating, ventilation and air conditioning services. In fact you can add any images to the template by simply clicking the "Pictures" command on Excel "Insert" ribbon tab. To have the newly added image appear on UIS-generated PDF invoices and bills, you should name the image with "oknWidget" prefix. For example, in this template the repairman image is named "oknWidget_repairman". Visit Customizing Invoice Template for more information. For more samples on templates and images visit Invoice Template Images.

Bill Format for Catering and Wedding Servicec4092

Invoicing Template for Catering and Wedding Service

"Invoicing Template for Catering and Wedding Service" was found to be relative to Invoice Software Example Download With Client Management with the score grade of 81.

...(110) This template is a variant of c4045 Catering Invoice Template designed by InvoicingTemplate.com. If you compare the original version and this customized one, you'll firstly noticed we've used a new color schema for this bill format, and also there is a garland decoration on the top and bottom of the billing form. Due to addition of these widgets, this template might be a good choice for wedding or celebration events. On the other hand, templates such as c4039 Restaurant Dining Invoice Template (VAT), c7005 Hotel Receipt Template are more suitable for general events / food catering. The background image will also show on the PDF catering and wedding service invoice.

Bill Format with Modern Designc4093

Bill Format with Modern Design

"Bill Format with Modern Design" was found to be relative to Invoice Software Example Download With Client Management with the score grade of 78.

...(107) For example, with Uniform Invoice Software installed it is easier to find out all outstanding invoices and bills. Simply click the "Invoices" button on either the ribbon tab, or on the "Invoice" worksheet, a list of all invoices shows with pending (not paid) invoices marked with special colors. To find the ones that belongs to a particular customers, on the "Search Bar" choose "Customer Name" (or any other criteria available), choose the search operator such as "Start with", "Contains" or "End with", and then enter in the search keyword - as the names of the search operators suggest, you can enter only part of the customer name.

Basic Sales Invoice Template in Frenchc5065

Basic Sales Invoice Template in French

"General Sales Invoicing Form in French" was found to be relative to Invoice Software Example Download With Client Management with the score grade of 77.

  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. On the Tools menu, click Options, and then click the View tab.
  3. Under Window options, check the Gridlines and Row & Column Headers check boxes.

...(14) To show/hide gridlines and row/column headers in Excel 2007, Excel 2010 and Excel 2013:

...(127) To replace a label in English, such as "Invoice", with its French version, such as " FACTURE". With this implementation offered by InvoicingTemplate.com, we simply added a French label to its English version, so that "Invoice" on the default sales invoice template is now shown as " FACTURE/ INVOICE". The other examples are: "Bill To" becomes " Vendu à/Bill To", "Ship To" becomes "Expédié à/ Ship To", "Quantity" becomes " Qté/Qty ", "Price" becomes " Prix/Price", "Sub-Total" becomes " Sous-Total/ Sub-Total", "Paid" becomes " Payé/ Paid", "Total Due" becomes "Montant Dû/ Total Due", "THANK YOU" becomes " MERCI/ THANK YOU". The purpose of this sample is to demonstrate how easy it is to customize the our Excel invoicing templates, like what other samples on InvoicingTemplate.com show you.

Photography Invoicing Template (General)c4043

Photography Billing Format (General)

"Photography Invoicing Template (General)" was found to be relative to Invoice Software Example Download With Client Management with the score grade of 77.

...(104) Whether you are doing, graphic design, contract-based event photography, family portraits or wedding photography this invoice will work for your business. The "Description of Service Provided" section allows you to detail any information that are related to your service, such as project type, picture settings, film developing, and insurance. Because of this, this template layout is consider as "general", meaning it should could be used by any photographers and photography studios. If your photography business focuses on image printing, there is another layout here on InvoicingTemplate.com that you may like to have a look, at Photography Receipt Template (Detail) or Photography Receipt Format (Detail).

Engineering Service Billing Samplec3006

Engineering Service Billing Sample

"Engineering Service Billing Sample" was found to be relative to Invoice Software Example Download With Client Management with the score grade of 74.

...(85) Adding a custom field to the "InvBdy" database table makes it possible to save the data on the invoice spreadsheet to database when the "Save To DB" button is clicked. For example, adding the custom field "Product Type" to the "InvBdy" database table allows save the type value on the invoicing form, such as "General" or "Labor", to database when you save an invoice by clicking the "Save To DB" button. This feature is not supported in the freeware edition of Engineering Service Invoice Template.

Form with Product Categoryc5008

Template with Product Category

"Form with Product Category" was found to be relative to Invoice Software Example Download With Client Management with the score grade of 65.

...(59) If you use the freeware edition of this invoice template, you may find there is no much difference between this invoice template and the default sales invoice template shipped with Uniform Invoice Software. The only difference appears outside the printable area on the center of the form, where you can find a Product Category column near the invoice body.

...(50) "Product Category" is a standard field defined in the Product database table, but not added to the "Invoice Body" database table. So when you create an invoice with Uniform Invoice Software, the category information is not loaded along with product data, and thus not saved along with other invoice details.

Simple Sample - Decimal Precision of Product Pricesc4060

Simple Invoicing Sample - Decimal Precision of Product Prices

"Simple Sample - Decimal Precision of Product Prices" was found to be relative to Invoice Software Example Download With Client Management with the score grade of 57.

...(43) As stated earlier, in the database the underlying definition of the "Price" field allows up to 6 digits after the decimal pointer. So to have the Excel billing format show 4 digits, all we need to do is to change the display format.

...(68) As you can see from this simple invoice template sample, it is pretty easy to customize the billing form with the help of Excel of Uniform Invoice Software. Although not as big and complicated as some accounting and billing systems, such as QuickBooks, Uniform Invoice Software does provide its unique features that help you to create beautiful and professional invoice (see the PDF version too), receipt and statement.

Hourly Service Invoice Template (UK Currency)c4026

Hourly Service Invoice Template (UK Currency)

"Hourly Service Invoice Template (UK Currency)" was found to be relative to Invoice Software Example Download With Client Management with the score grade of 49.

...(41) If you know Microsoft Excel, you may already know how to change the number format so that it shows a currency symbol before the actual values. If you are not familiar with Microsoft Excel, here are the basic steps to follow.

...(27) There are many more things you can customize to create your own invoicing template with your very own style, the currency symbol is just one simple example.

...(31) If you prefer a currency-neutral version of this service invoice template, see c4025 Hourly Service Invoice Template / Hourly Service Billing Statement where the numbers are shown without any currency symbol.

Simple Sample - Customer Name on Product Reportc4059

Simple Invoicing Sample - Customer Name on Product Report

"Simple Invoicing Sample - Customer Name on Product Report" was found to be relative to Invoice Software Example Download With Client Management with the score grade of 44.

...(49) The definition of the database structure in Uniform Invoice Software established the "one-to-many" relationship between the "Invoice Header" (i.e. "InvIndr") and "Invoice Body" (i.e. "InvBdy") database tables. This means that, for each record in the invoice header database table, there might be one or many items belong to it.

...(76) On the other hand, the main content of the "Product" report is retrieved from the invoice body database table, adding the fields of the invoice header table to the invoice body table will create many redundant data, as they must be repeated for each item. One exception though - the definition of invoice body items must include the invoice# (InvoiceID) field, since it is the primary key of the invoice header table that identifies each uniquely.

Cash Payment Voucher Templatec5053

Cash Payment Voucher Template

"Cash Payment Voucher Template" was found to be relative to Invoice Software Example Download With Client Management with the score grade of 33.

...(92) Cash Payment Voucher Template contains 5 columns (item#, description, quantity, price, and amount) and no "Advance" field on the bottom of the form. The "Discount" field on the bottom of the voucher form is a custom field - meaning that the default sales invoice template (the origin of all the templates available here on InvoicingTemplate.com) does not contain this field. In order to be able to give discount to customers, all the payment voucher templates in this serials include the discount custom field, which is defined in the Invoice Header database table.

Hourly Service Billing Samplec4025

Hourly Service Billing Statement

"Hourly Service Billing Sample" was found to be relative to Invoice Software Example Download With Client Management with the score grade of 30.

...(175) This implementation of our hourly billing statement is currency-neutral - meaning it does not show currency symbol on the figures. It is suitable for many different countries and regions, such as United Kingdom (UK), France, Italy, Greece, Switzerland, Ireland, Netherlands, Denmark, Sweden, Austria, Portugal, Spain, Czech Republic, Germany, Norway, Poland, Belgium, Luxembourg, Latvia, Georgia, Romania, Finland, Estonia, Belarus, Slovakia, Lithuania, Serbia, Slovenia, Ukraine, Russia, Asia country or region like China, Taiwan, Mongolia, India, Japan, Korea, Philippines, Sri Lanka, Pakistan, Macau, Hong Kong, Malaysia, Singapore, Timor-Leste, Indonesia, Thailand, Brunei Darussalam, or Croatia, Mauritius, Maldives, Malta, Cyprus, United Arab Emirates, Saudi Arabia, Egypt, Bahrain, Qatar, Kuwait, Oman, Turkey, Bulgaria, Lebanon, South Africa, Angola, Kenya, Tanzania, Mozambique, Namibia, Nigeria, Zimbabwe, Zambia, Brazil, Barbados, Paraguay, Puerto Rico, Costa Rica, Mexico, Argentina, Venezuela, Peru, Uruguay, Chile, Panama, Aruba, Trinidad and Tobago, Colombia, Honduras, Guatemala, Bermuda, United State (US) and Canada, or Australia, New Zealand, Papua New Guinea. If you want accuracy by showing your currency symbol on the form, see the sample template at Hourly Service Billing Sample (UK Currency).

...(59) The protection of the "Invoice" worksheet in Hourly Service Billing Sample 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 Hourly Service Billing Sample.

Simple Service Invoice Template without Item Descriptionc8001

Simple Service Invoice Template without Item Description

"Simple Service Invoice Template without Item Description" was found to be relative to Invoice Software Example Download With Client Management with the score grade of 27.

...(100)Simple Sales Invoice Template without Item Description implements such as simple invoice format by moving the description column out of the printable invoice form. To make it compatible with Uniform Invoice Software (for more information about our invoicing software, click here, or here, or here) , which requires a description to be present, we assign a formula to the Description fields located outside the printable form. The Excel formula assigns the value of product# (or item#, serial#) to its Description field automatically so that Uniform Invoice Software will not display a warning message due to the missing of a description.

Template with Summary on Topc4003

Template with Summary on Top

"Template with Summary on Top" was found to be relative to Invoice Software Example Download With Client Management with the score grade of 12.

...(64) Microsoft Excel provides handy tools for customizing the invoice form. This invoice template "Template with Summary on Top", likes many other invoice templates here on InvoicingTemplate.com, demonstrating how the template can be customized to create the format and layout you like. Your business is special, so your invoices should be. With Microsoft Excel, you can easily change the font, colors, patterns and borders etc.

...(159) Moving cells and fields is also as easy as dragging and dropping. If you prefer to place a cell on a new location, firstly unprotect the Invoice worksheet, and then click to select the cell/cells, and then drag the border of the selected cell to move it to a new location you like. Uniform Invoice Software supports all these tools provided by Excel, which makes sure that you can have the invoice form you like. And, one of the great features of Uniform Invoice Software is that, you can connect the invoice template in Excel spreadsheet format to a backend database, which gives you the ability to manage large amount of data, such as customers, products, invoices and payments, in an organized manner. Simply put, Uniform Invoice Software combines the power of Excel and backend relational database, turning a simple Excel invoice template into a powerful invoicing system. Feel free to download and try the fully functional trial version.

Simple Sample - Printing on Letterhead Paperc4058

Simple Invoicing Template - Printing on Letterhead Paper

"Simple Sample - Printing on Letterhead Paper" was found to be relative to Invoice Software Example Download With Client Management with the score grade of 4.

  1. Before doing any customization, backup the template. In this case, we'll not touch the database fields / database definitions. So backing up the database file is not required.
  2. Open the template as usual.
  3. If you have Uniform Invoice Software (our Microsoft Excel-based e-billing software program / app / organizer) installed, click the "Design Mode" button.

    Otherwise, unprotect the sheet and then show gridlines and row/column headings; push down the "Design" button on Excel "Developer" ribbon tab.

  4. Move the content that will provided by the letterhead out of the printable form. In this case, we'll move the default logo image (the placeholder), company name (cell name: oknCompanyName), compay address (cell name: oknCompanyAddress), company city state zip code (cell name: oknCompanyCityStateZip), and company contact (cell name: oknCompanyContact) out of the printable section.

    To move the default logo image, click on it to select it, and then drag it to move it. Or in case you want to delete the logo image completely, hit DEL on your keyboard.

    To move the company information labels (ranging from F2 to H14 in this sample), drag your mouse to select these cells. And push your mouse key on the border of the selected area, without releasing the mouse key drag it to the new location you want to place the fields - in this case, we put it at the new location starting from $W$3.

  5. Move the big label "INVOICE", and two required fields, invoice date and invoice #, including theire labels, to proper place to leave space on the top of the form.

    In this case, we move the label "INVOICE" to row 3 and the two required fields to row 4. We also merged all the cells on row 3 by clicking the "Merge and Center" command on Excel "Home" ribbon tab to make it centered.

  6. Now adjust the height of the first line on the top of the printable form to make it equals to the height of the letterhead on your papers. One helper here is the ruler that shows when you switch to "Page Layout" view. To do this, switch to Excel "View" ribbon tab, push down the "Page Layout" button on the "Workbook Views" group. The page layout view shows a ruler that helps you to determine the height of each row. Once done, switch to normal view by pushing down the "Normal" button on the "Workbook Views" group.

    Another way to leave space on top of the form is to set margins. To do this, you first hide the empty row on the top (in this sample, row 2) by right-clicking the row header and then choose "Hide" from the shortcut menu. And then go to Excel "Page Layout" ribbon tab, choose "Margins" in the "Page Setup" group and then choose "Custom Margins..." to set the margins based on the size of the letterhead that you want to use.

  7. Once done, click the "Design Mode" button on the "Invoice" ribbon tab to exit design mode.
  8. Save the template by clicking the "Save" button on Excel quick access toolbar.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c4098
Sales Invoicing Format for Germany
Sunday, November 20, 2016,
12
4
A4
Portrait
Sales
c4089
Invoicing Format for HVAC Service
Thursday, October 20, 2016,
18
4
A4
Portrait
Service
c4092
Bill Format for Catering and Wedding Service
Wednesday, October 26, 2016,
12
4
A4
Portrait
Service
c4093
Bill Format with Modern Design
Thursday, October 27, 2016,
5
4
Letter (8-1/2 in. x 11 in.)
Portrait
Service
c5065
Basic Sales Invoice Template in French
Tuesday, September 23, 2014,
12
5
A4
Portrait
Sales
c4043
Photography Invoicing Template (General)
Saturday, November 7, 2015,
12
4
A4
Portrait
Service
c3006
Engineering Service Billing Sample
Friday, February 28, 2014,
12
3
A4
Portrait
Service
c5008
Form with Product Category
Sunday, November 10, 2013,
12
5
A4
Portrait
Sales
c4060
Simple Sample - Decimal Precision of Product Prices
Saturday, February 6, 2016,
12
4
A4
Portrait
Sales
c4026
Hourly Service Invoice Template (UK Currency)
Monday, September 29, 2014,
12
4
A4
Portrait
Service
c4059
Simple Sample - Customer Name on Product Report
Friday, February 5, 2016,
12
4
A4
Portrait
Sales
c5053
Cash Payment Voucher Template
Friday, May 30, 2014,
12
5
A4
Portrait
Receipt
c4025
Hourly Service Billing Sample
Sunday, September 28, 2014,
12
4
A4
Portrait
Service
c8001
Simple Service Invoice Template without Item Description
Thursday, January 9, 2014,
30
8
A4
Portrait
Service
c4003
Template with Summary on Top
Sunday, November 3, 2013,
12
4
A4
Portrait
Service
c4058
Simple Sample - Printing on Letterhead Paper
Thursday, February 4, 2016,
12
4
A4
Portrait
Sales

What Is Hot

Feature Galleries