Generic Invoice Format With Database Support

1. Netherland Sales Invoice Template 2

"Netherland Sales Invoice Template 2" was found to be relative to Generic Invoice Format With Database Support with the score grade of 89.

(From Detail Page - about 111 words) - The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Netherland Sales Invoice Template 2 without writing one line of programming code. For example, in this tax invoicing template named Mixed Tax Rates in an Invoice, we implement the support of mixed tax rates in the same invoice by using custom fields. The result of the customization is offered in two editions, as what we do to all the other templates available here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with Uniform Invoice Software installed.

(From Detail Page - about 63 words) - It's natural that different businesses need to detail their customer / client information on the different levels. For example, a retail shop may have to hide their customer information at all, including customer# and customer name etc.; on the other hand, a wholesale limited company or firm may need to add more details than what the default fields defined by Uniform Invoice Software.

(From Detail Page - about 102 words) - Adding a custom field to the Customer table in the database makes it possible to save the field value to database along with the other data of a customer / client. For example, adding the custom field Company Name to the Customer database table allows you to save the company name of a customer to the database when you save a customer. If you use Uniform Invoice Software version template Netherland Sales Invoice Template 2 and add the custom field to the invoice form, the value is retrieved and filled into Netherland Sales Invoice Template 2 whenever you pick up a customer.

(From Detail Page - about 22 words) - To add a custom field, let's say Customer VAT Registration No, to the Customer database table, here are the steps to follow.

LEARN MORE PDF

2. Engineering Service Invoice Template

"Engineering Service Invoice Template" was found to be relative to Generic Invoice Format With Database Support with the score grade of 83.

(From Detail Page - about 110 words) - The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Engineering Service Invoice Template without writing one line of programming code. For example, in this tax invoicing template named Mixed Tax Rates in an Invoice, we implement the support of mixed tax rates in the same invoice by using custom fields. The result of the customization is offered in two editions, as what we do to all the other templates available here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with Uniform Invoice Software installed.

(From Detail Page - about 87 words) - Adding a custom field to the Invoice Body database table makes it possible to save the data on the invoice form to database when the "Save To DB" button is clicked. For example, adding the custom field "Product Type" to the Invoice Body database table allows save the type value on the invoice 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.

(From Detail Page - about 230 words) - When working with Uniform Invoice Software version of Engineering Service Invoice Template, how does Uniform Invoice Software know to which cell when a field value write to when loading data from the database, and to which field a cell value must save when saving an invoice, a customer or a product item? That is, how does Uniform Invoice Software create the map or relationship between Excel cells on the template Engineering Service Invoice Template and database fields? The answer is by using names. For example, if the field name in the Product table in a database is "ProductType", it is writing to a cell named "oknProductType_?" (where ? is the line number of the invoicing item) when you pick up a product or item on creating an invoice, and when saving an invoice, all cells with the name "oknProductType_?" are saved to the "ProductType" field in the Invoice Body database table. By using cell names, Uniform Invoice Software allows you to move a cell on the form without breaking the feature depending on the field / cell. You can place the "Product Type" column either inside the printable area, which is printed when you issue the Print command in Excel or click the Print command on the Invoice form; or place the Product Type column outside the printable area, which will be included when you print or extract an invoice.

LEARN MORE PDF

3. Simple Sample - Using Shape Object

"Simple Invoicing Sample - Using Shape Object" was found to be relative to Generic Invoice Format With Database Support with the score grade of 70.

...(36)...

(From Detail Page - about 63 words) - Whether you are running your business as freelancer, a home business, a corporate small business, you can have your invoices differ from others and give your customer and client good impression that you are paying attention to every detail of your business, including invoicing. Shapes and images are the easy and effective way to make a difference on your business documents likes invoices.

(From Detail Page - about 53 words) - As you can see from this sample of simple invoice template, using shapes is an easy and quick to way to make a new layout. Are you interested? Download the sample template here on InvoicingTemplate.com for free. Visit Invoice Template with Remittance Slip for an invoice sample that uses images on remittance slip.

LEARN MORE PDF

4. Basic Blank Service Billing Format (No-tax, Long Description)

"Basic Blank Service Billing Layout (No-tax, Long Description)" was found to be relative to Generic Invoice Format With Database Support with the score grade of 65.

(From Detail Page - about 42 words) - Basic Blank Service Billing Format (No-tax, Long Description) is a general purpose, service-oriented invoicing template that includes two editable columns (Description, Amount) and up to 5 items on the invoice detail section. Each row allows you to enter multiple lines of text.

...(125)...

(From Detail Page - about 209 words) - The "Extract/Email" command is located on the task pane when the "Invoice" worksheet is active. It works in two ways depending on the options you set on the "Extract/Email" tab of the Settings window. Firstly, it could extract the current invoicing form - this means that, a separate Excel workbook file will be created, and it contains only the current invoice. Secondly, it could also generate electronic invoice in Adobe PDF, Excel spreadsheet or image (PNG) format, and then send the invoice to the customer - when sending the invoice, Uniform Invoice Software looks at the email field of the invoice itself, if not found then look at the customer record. The invoicing program is also able to send a BCC copy to the email address you specified on the Settings window. If any error occurred in the process of sending email, it records the error message with the invoice itself, which could be found when you open an invoice on the "Invoice Edit" window - by double clicking an invoice on the "Invoices" window, or by clicking the "View Detail" command on the task pane. On the other hand, if no error occurred in the process of sending email, the last balance due and sent date is recorded.

(From Detail Page - about 162 words) - The template offers a blank form for you to fill in. Fixed content, like your own business name, address, contact etc., are locked so that you'll not overwrite them accidentally. Fillable content, like the invoice#, invoice date, customer information, service items, etc., are unlocked so that they are editable even when the form is protected. Without Uniform Invoice Software installed, you should fill in all information by hand. With the help of Uniform Invoice Software, filling an invoice is much simpler. You'll typically start by clicking the Clear & New command, which clears the invoice form so that it is ready for you to create a new invoice. After executing the "Clear & New" command, most editable fields are blank, but some of them are filled with default values. For example, the Invoice Date will be the current date, and the Sales Rep. Name, Shipping Date, Payment Term etc., are all filled with default value (if they appear on the invoice form).

(From Detail Page - about 90 words) - Uniform Invoice Software also helps on filling other content. For example, if you click a cell inside the "Bill To" section, an in-cell pick up button appears. Clicking on this button shows a list of all active customers, which you can click to choose from. The list of customers also includes a search bar, which allows you to search by any field of a customer, such as the name, address, city state and zip, phone, country, email, and all the custom fields you defined for your customers - if any.

LEARN MORE PDF

5. Shipping Invoice Template (2)

"Freight Invoice Format (2)" was found to be relative to Generic Invoice Format With Database Support with the score grade of 50.

(From Detail Page - about 38 words) - Shipping Invoice Template (2) is a variant of Shipping Invoice Template. This customized format differs from the original invoice template in that the shipping invoices created by this template is printable on A4 paper with Landscape paper orientation.

(From Detail Page - about 42 words) - All invoice templates created and hosted here on InvoicingTemplate.com are based on the default sales invoice template shipped with Uniform Invoice Software, which is our invoicing software that is able to turn a simple Excel invoice template into a powerful invoicing program.

(From Detail Page - about 52 words) - If you are interesting in how we created this customized shipping invoice format from the original shipping invoice template, here are the steps: unprotect the Invoice worksheet, switch to design mode, display row headings and gridlines of the Excel spreadsheet, resize columns to make it printable on A4 paper in Landscape orientation.

...(61)...

(From Detail Page - about 134 words) - In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Shipping Invoice Template (2). Note that if you have our invoicing program (Uniform Invoice Software) 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 invoices 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.

  (From Detail Page - about 53 words) - 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.

  (From Detail Page - about 49 words) - 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.

...(22)...

(From Detail Page - about 11 words) - To show gridlines and row/column headers in Excel 2000 - 2003:

...(40)...

...(34)...

...(94)...

(From Detail Page - about 26 words) - Since the paper is now in landscape orientation, we need to hide some rows to make the shipping invoice template be printable on a single page.

...(217)...

(From Detail Page - about 44 words) - If you are looking for a Shipping Invoice Template in Microsoft Word format, we recommend this Excel Shipping Invoice Template instead. As you can see from the above customization procedure, it is easier to create and format the shipping invoice form in Microsoft Excel.

LEARN MORE PDF

6. Basic Blank Service Invoice Format (Two-taxes)

"Basic Blank Service Invoice Format (Two-taxes)" was found to be relative to Generic Invoice Format With Database Support with the score grade of 50.

(From Detail Page - about 53 words) - A basic and blank service invoice format could be served for many different types of businesses. While we've already published two layouts in this topic, "c2012 Basic Blank Service Format (No-tax)" and "c2013 Basic Blank Service Invoice Format (One-tax)", this format "Basic Blank Service Invoice Format (Two-taxes)" has two taxes set by default.

(From Detail Page - about 54 words) - If you need less lines but more space for each item description on your blank service invoice template, see Basic Blank Service Billing Format (No-tax, Long Description), and the one tax format at Basic Blank Service Invoicing Format (One-tax, Long Description), and the two-tax layout at Basic Blank Service Bill Format (Two-taxes, Long Description).

(From Detail Page - about 84 words) - To get paid fast and in time you have to provide a proper invoice for the service rendered. A proper invoice should contain certain required information, such as your business name and address, your client's name and address, description of the job that have done, and the amount that need to pay. Besides that, tax is one of those important things that must be properly set. Your client would not accept the invoice you send to them if the taxes are not properly configured.

(From Detail Page - about 149 words) - Depending on your local laws, and sometimes it even is depending on where your customer resides, you may charge no tax, one tax or two taxes. Setting up tax options would not be a problem if Uniform Invoice Software is already installed on your computer, as you could simply go to the Settings window and then Taxes tab to set the configurations. However if it is not, you have to unprotect the spreadsheet manually and set the tax rules manually. To simplify this procedure for those users, this template, "Basic Blank Service Invoice Format (Two-taxes)", "Basic Blank Service Invoice Format (Two-taxes)", is added here as a free downloadable template on InvoicingTemplate.com. If you have to charge two taxes, the only thing left for you to customize is entering your own company name and replacing the default logo image. To do this, you first need to unprotect the Excel spreadsheet.

(From Detail Page - about 65 words) - The protection of the Invoice worksheet in Basic Blank Service Invoice Format (Two-taxes) 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 invoice worksheet. However for the purpose of this sample, we should firstly unprotect the Invoice worksheet in Basic Blank Service Invoice Format (Two-taxes).

LEARN MORE PDF

7. Engineering Invoice Template

"Engineering Invoice Template" was found to be relative to Generic Invoice Format With Database Support with the score grade of 41.

(From Detail Page - about 41 words) - This two-column engineering invoice template is suitable for project architects & engineers who offers service to customers and has the need to bill the customers. It is another sample on customizing the default sales invoice template shipped with Uniform Invoice Software.

...(101)...

(From Detail Page - about 17 words) - For another engineering service invoice template here on InvoicingTemplate.com, please refer to Free Engineering Service Invoice Template.

...(30)...

(From Detail Page - about 59 words) - The protection of the Invoice worksheet in Engineering Invoice Template 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 invoice worksheet. However for the purpose of this sample, we should firstly unprotect the Invoice worksheet in Engineering Invoice Template.

...(133)...

• 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.

  (From Detail Page - about 53 words) - 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.

  (From Detail Page - about 49 words) - 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.

(From Detail Page - about 21 words) - Once you have finished your design work for Engineering Invoice Template, click the Design Mode button again to exit design mode.

(From Detail Page - about 86 words) - The architect/engineer invoice form / billing form, like all the other invoicing templates available here on InvoicingTemplate.com, is created based on the default sales invoice template that is included in the Uniform Invoice Software setup package. In order to create this invoicing template, we've added a number of new fields - they are called custom fields in Uniform Invoice Software. For example, the Job ID and Project Name, which are not present in the default sales invoice template, allow you to detail job and project information.

(From Detail Page - about 133 words) - Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the invoice form. Engineering Invoice Template uses custom fields to implement the features that are not available in the default sales invoice template. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, Uniform Invoice Software has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

(From Detail Page - about 109 words) - The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Engineering Invoice Template without writing one line of programming code. For example, in this tax invoicing template named Mixed Tax Rates in an Invoice, we implement the support of mixed tax rates in the same invoice by using custom fields. The result of the customization is offered in two editions, as what we do to all the other templates available here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with Uniform Invoice Software installed.

(From Detail Page - about 42 words) - Note to users of the old versions of Uniform Invoice Software (i.e. Excel Invoice Manager) - although the support for custom fields was already implemented in Excel Invoice Manager, the use of custom fields was much more simplified in Uniform Invoice Software.

...(71)...

...(34)...

...(69)...

(From Detail Page - about 25 words) - For a variant of this engineering service template that has no support for change order and has one predefined tax, please see Architect Invoice Template.

LEARN MORE PDF

8. Basic Blank Service Invoice Format (One-tax)

"Basic Blank Service Invoice Format (One-tax)" was found to be relative to Generic Invoice Format With Database Support with the score grade of 40.

...(49)...

(From Detail Page - about 72 words) - Note that a Two-tax version is also available here on InvoicingTemplate.com, at Basic Blank Service Invoice Format (Two-tax). If you need less lines but more space for each item description on your blank service invoice template, see Basic Blank Service Billing Format (No-tax, Long Description), and the one tax format at Basic Blank Service Invoicing Format (One-tax, Long Description), and the two-tax layout at Basic Blank Service Bill Format (Two-taxes, Long Description).

(From Detail Page - about 125 words) - Uniform Invoice Software is a special invoicing software app that uses Excel invoice templates as the front-end. The program is implemented as an Excel add-in program that runs inside Microsoft Excel. So after installing Uniform Invoice Software, you won't see a shortcut to the program as many other programs. What you'll see is a shortcut to the default invoicing format that is shipped with the setup program of Uniform Invoice Software. This default invoicing template is just the sample of the templates supported by Uniform Invoice Software. You can easily replace it with new templates available here on InvoicingTemplate.com. Simply download the template you like, extract the template (each template usually comes with a database file), and then double-click to open the template you like.

...(111)...

(From Detail Page - about 46 words) - This configuration procedure isn't so basic and simple for someone who are not so familiar with Excel and Uniform Invoice Software templates. To get the job even easier, we build this template "c2013 Basic Blank Service Invoice Format (One-tax)" or Basic Blank Service Invoice Layout (One-tax).

(From Detail Page - about 97 words) - Like all the other templates available here on InvoicingTemplate.com, "c2013 Basic Blank Service Invoice Format (One-tax)" could be used standalone without Uniform Invoice Software. But if Uniform Invoice Software is installed, it not only turns the simple Excel billing template into a powerful invoicing system, but also helpful commands like "Design Mode" (which unprotect the sheet and push the "design mode" button on the "Developer" ribbon tab). The trial version of Uniform Invoice Software is fully functional within the trial period, which you can download free of charge. So why don't download and give it a try?

(From Detail Page - about 58 words) - With Uniform Invoice Software installed, you can also set the tax name and rate on the Taxes tab of the Settings window. Without Uniform Invoice Software installed, to use "Basic Blank Service Invoice Format (One-tax)", you may need to firstly unprotect the "Invoice" worksheet, and then type in your tax name and rate properly in the correct cells.

LEARN MORE PDF

9. Shipping Invoice Template (1)

"Freight Invoice Format (1)" was found to be relative to Generic Invoice Format With Database Support with the score grade of 38.

...(33)...

(From Detail Page - about 11 words) - This free shipping invoice template is provided in Microsoft Excel format.

(From Detail Page - about 102 words) - Although it is easy to create the layout and format of Shipping Invoice Template (1) with Microsoft Word or other Microsoft Office programs, or even with some PDF programs, the support for Excel formulas makes doing automated calculations easy to implement and modify. For example, Shipping Invoice Template (1) uses Excel formulas extensively to do calculations whenever possible and necessary, such as the taxes, totals. If you use the Uniform Invoice Software version of Shipping Invoice Template (1), Excel formulas are also used to create the relationship between several fields, such as one field should be the sum of two other fields.

(From Detail Page - about 76 words) - This sample free shipping invoice template designed by us at InvoicingTemplate.com has two editions - the first is the freeware edition, and the second is the Uniform Invoice Software edition which must be run with our Excel Invoicing Software installed. Uniform Invoice Software has the ability to turn a simple Excel invoice template a powerful invoicing system. For example, using this Shipping Invoice Template along with Uniform Invoice Software, it becomes your powerful Shipping Billing Software.

(From Detail Page - about 51 words) - To implement the sample shipping invoice template, Invoicing Templates added a number of custom fields to the default sales invoice template that comes with the setup program of Uniform Invoice Software, including: Bill of Loading No, Destination, Cont. Type, Vessel/ Vyoage, Port of Loading, No. Of Pkgs., Gross/Net weight, Ex. Rate.

...(134)...

(From Detail Page - about 110 words) - The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Shipping Invoice Template (1) without writing one line of programming code. For example, in this tax invoicing template named Mixed Tax Rates in an Invoice, we implement the support of mixed tax rates in the same invoice by using custom fields. The result of the customization is offered in two editions, as what we do to all the other templates available here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with Uniform Invoice Software installed.

(From Detail Page - about 92 words) - These new custom fields, combined with the default fields defined by the sales invoice template, make the billing template has the ability to detail shipping company, sender, recipient, description of the goods being shipped, total items shipped in one package, cost of shipment, date of shipment, name of the company which is the manufacturer of the goods, shipment code, etc. The shipping invoice sample also defines one tax, named "Service Tax", on the bottom of the form. You can easily change the tax name and tax rate by typing whatever you like.

(From Detail Page - about 33 words) - The shipping invoices created by this shipping invoice template is printable on standard A4 paper with Portrait paper orientation. If you would like to see a Landscape version, see Shipping Invoice Template (2).

LEARN MORE PDF

10. Sales Invoice Template with Discount Percentage Column

"Sales Invoice Template with Discount Percentage Column" was found to be relative to Generic Invoice Format With Database Support with the score grade of 30.

(From Detail Page - about 38 words) - Sales Invoice Template with Discount Percentage Column is a variant of Sales Invoice Template with Discount Amount Column. It differs from the original one by changing the discount amount field to percentage field on the printable invoice form.

(From Detail Page - about 73 words) - The original sample invoice template Sales Invoice Template with Discount Amount Column defines the discount column as an amount value, i.e. the Line Total equals to Unit Price * Quantity - Discount. There are also many businesses who prefer to use a percentage discount, i.e. make the Line Total equals to Unit Price * Quantity * (1- Discount Percentage). So here is the Sales Invoice Template with Discount Percentage Column for those people.

(From Detail Page - about 70 words) - This customized sample invoice template has exactly the same layout and format as the original one. It includes "Shipping To" fields so it is also a Sales Invoice Template, except the number format of the Discount column is now a percentage, and the formula of the line total fields is changed too. Download Sales Invoice Template with Discount Percentage Column for free from the download page to see the details.

LEARN MORE PDF