Here are our templates closely related to Google Docs Invoice Generator.
As you can see from this simple example, it is easy and convenient to do formatting in Excel. By using various tools provided by Excel, it is not hard even for a beginner to create an amazing invoicing template. Here on InvoicingTemplate.com we are publishing sample designs so that you can use as a starting point of creating your own template. With no so much effort, you can create professional invoices that are better than many expensive invoicing applications.
As a simple customized sample of VAT invoice created for Germany (See c4098 Sales Invoicing Format for Germany and Service Billing Template for Germany), we make the currency symbol shown for the appropriate cells. This customization is easy and simple. If you are interesting in the details, here is how.
Besides modifying the formula, you'll also need to set the format of the discount cell to show as a percentage. To do this, first unprotect the Invoice worksheet by clicking the Unprotect Sheet command on the Review ribbon tab, and then right-click the Discount cell on the bottom of the invoice form and choose Format Cells. On the Number tab of the Format Cells dialog box, you can set the format of the discount cell to be a percentage value. Feel free to browse the other options available on the Format Cells dialog box, you may find it helps you a lot when you try to customized the invoice template to create your own style and layout.
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.
This template is a revised version of our Attorney Invoice Template (South Africa Currency) (c5067). It now uses a new color schema, Agency FB fonts. The client# cell is also moved out of the printable form. See the PDF invoice generated by Invoice Manager for Excel to find out what will it like when you client receive your bills.