Skip to main content
InvoicingTemplate.com main content

Itemized Graphic Design Invoicec4044

Itemized Graphic Design Format

"Itemized Graphic Design Invoice" was found to be relative to Design A Invoice Template For Publishing Services with the score grade of 92.

...(164) Although we name this template with "graphic design", it is more like a general service invoice template that could be used by people providing freelancer work, for example web and graphic design, photography, copywriting, computer programming, website development, consulting, video production, translation. If you are a designer or writer, you surely want your invoices not only prim and proper, but also beautiful and professional. One of the major problems with invoicing is that many of the tools available make it difficult for a company to customize the invoice. There may be a set range of templates available, but these don't always work for everyone. That's why we at InvoicingTemplate.com continually release new designs that you can choose from and customize with. All template on InvoicingTemplate.com could be downloaded for free, and they are just clean Excel spreadsheet files without macros built in. They templates are not locked with password so that you can easily unprotect the sheet and customize it as per your requirements.

Bill Format with Modern Designc4093

Invoicing Template with Modern Design

"Bill Format with Modern Design" was found to be relative to Design A Invoice Template For Publishing Services with the score grade of 84.

...(114) Creating invoices is also much easier with Uniform Invoice Software installed. To create an invoice (see movie tutorial), you first click the "Clear & New" button, this clear the form - i.e. make all the fillable fields blank, some fields will have default value populated - for example, the "Invoice Date" and "Sales Rep. Name" fields will populated with their default values. You then pick up an existing customer by either using the "On-Sheet Picker" button (again, you can use the search bar on the "Customers" data list window), or enter the customer# into the correct cell to retrieve all the customer information. The "On-Sheet Picker" also works for the lined items section too.

Basic Sales Invoice Template (Light Blue)c3001

Basic Sales Invoice Template (Light Blue)

"Basic Sales Invoice Template (Light Blue)" was found to be relative to Design A Invoice Template For Publishing Services with the score grade of 80.

...(239) Moving a cell or a group of cells is easy in Excel. First, you click to select the cell or drag your mouse to select all the cells you want to move. And then, drag the border of the selected area to move it to the new location where you want to place the cell or cells. The moving content will overwrite the content in the target location, so make sure the target range is empty (not used) in Basic Sales Invoice Template (Light Blue) before doing the movement. And, if the target location contains merged cells, sometimes the movement fails. So it is also helpful to make sure the target location does not contain merged cell. If the target location Basic Sales Invoice Template (Light Blue) is overlapping the original range and the original range contains merged cells, the movement could also fail because you cannot change part of merged cell - if this happens, you need to first move the cells to a temporal location in Basic Sales Invoice Template (Light Blue) that are empty (i.e. not used), unmerge cells, and then move the cells from the temporal location to the desired location. If you need to unmerge a cell, first select it and then click the "Merge and Center" command on the Format toolbar in Excel 2003; or click the "Merge and Center" command on the Home ribbon tab in Excel 2007, 2010 and Excel 2013.

Designer Billing Format (Blue)c4029

Designer Billing Form (Blue)

"Designer Billing Format (Blue)" was found to be relative to Design A Invoice Template For Publishing Services with the score grade of 75.

...(62) All templates on InvoicingTemplate.com are professional and beautiful templates that are full editable layered pure-Excel spreadsheets. Our templates don't use macros and are not protected with passwords so that you can use all existing Excel tools to customize it - colors, fonts, borders, shapes, word arts, images, and more. Most of our templates, including this design, are printable on standard A4 paper.

...(54)Designer Invoice Template (Blue) is provided in two editions - a freeware editions of Designer Invoice Template (Blue), and a Uniform Invoice Software (UIS) edition of Designer Invoice Template (Blue). Both editions can be downloaded for free from the download page. A PDF edition is also provided at the right section of this page.

Designer Invoicing Format with Bamboo Chinese Paintingc4096

Designer Bill Template with Bamboo Chinese Painting

"Designer Invoicing Format with Bamboo Chinese Painting" was found to be relative to Design A Invoice Template For Publishing Services with the score grade of 73.

...(89) This form layout includes a column of "Taxable" checkboxes that are placed on column B - outside the printable section. Which means that, these boxes work, but will not be visible on the invoices that you print using this form (or PDF invoices created using this form). The checkbox are form controls that are named "oknWidget_taxable1, oknWidget_taxable2, oknWidget_taxable3 ... oknWidget_taxable6". Each tax box is linked to a hidden cell that are named "oknTaxable_1, oknTaxable_2, oknTaxable_3 ... oknTaxable_6". We then use an Excel array formula to calculate the taxable subtotal:

=ROUND ( IF ( oknTaxType=0,0, oknTax1Rate * ( oknLineTotalTaxable + IF ( oknTaxTotalIncludingShippingCost = 0, 0 , oknShippingCost))), 2 )

Hotel Receipt Format with Blue Gradient Designc7027

Hotel Receipt with Blue Gradient Bar

"Hotel Receipt Format with Blue Gradient Design" was found to be relative to Design A Invoice Template For Publishing Services with the score grade of 65.

  1. Backup the template (as always).
  2. Switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab. All the template here on Invoicing Template are protected by default, but with no password set. The purpose of enabling protection is to prevent end users from altering the design of the template accidently.
  3. Select all the cells on the top line that we'll marge, in this case, $D$3:$N$3.
  4. On Excel "Home" ribbon tab, click "Merge and Center".
  5. Right-click the merged cell and choose "Format Cells".
  6. Switch to the "Fill" tab.
  7. Click "Fill Effects".
  8. From "Colors" section, choose "Two colors", make the "color 1" is white and "color 2" is blue.
  9. From "Shading Style" section choose "From corner".
  10. Click one of the fill effect from the "Variants" section.
  11. Click OK to close the "Fill Effects" dialog box.
  12. Click OK to close the "Format Cells" dialog box.
  13. "Your Hotel Name" is a placeholder for your hotel / business name. Before you can create your first invoice, you need to replace it with your business name.
  14. The "RECEIPT" title is now implemented as a text box. Compared to regular text on the spreadsheet form, adding text and label using text box gives you more options on formatting and placing text. Click to select the "RECEIPT" title, the "DRAWING TOOLS / Format" ribbon tab appears, where you have full control over the style and appearance of the text box. In this sample, we simply choose one of preset WordArt Style.
  15. Once you've done customization on the hotel receipt template, click "Design Mode" button again on the "Invoice" ribbon tab to exit design mode. This protect the "Invoice" worksheet and hide gridlines and row/column headings.
  16. Click the Save button on Excel quick access toolbar to save the template.

Blank Service Invoice with Green Gradient Designc2031

Blank Service Invoice with Green Gradient Design

"Blank Service Invoice with Green Gradient Design" was found to be relative to Design A Invoice Template For Publishing Services with the score grade of 50.

...(80) This template has two columns - "Description" and "Line Total", both are manually editable when the sheet is protected. A "Taxable" checkbox is also provided for each of the invoicing item, which allows you to control separately whether each item is taxable. If all your items are taxable (or not taxable), you may not need the "Taxable" options. If this is your situation, you can easily remove the "Taxable" options and then modify the tax formula to ignore this option.

  1. Backup your template.
  2. Click the "Design Mode" button on the "Invoice" ribbon tab.
  3. Click a "Taxable" checkbox to select it.
  4. Hit the DEL key on your keyboard to delete the selected checkbox control.
  5. Repeat the above steps to delete other "Taxable" controls.
  6. Exit design mode and save the template.

Designer Invoice Template (Gray)c4030

Designer Invoice Template (Gray)

"Designer Invoice Template (Gray)" was found to be relative to Design A Invoice Template For Publishing Services with the score grade of 42.

...(85) As you can see from Designer Invoice Template (Gray), one benefit of using Excel as your invoice creator, as compared to other template formats like Microsoft Word invoice template and PDF invoice template, HTML format or even Photoshop format, is that you can easily apply formulas to do calculations. This means that, once the basic figures are entered on the form, like Quantity and Unit Price, or Hours and Hourly Rate, or Days and Daily Rate, the calculation of totals and taxes is done automatically.

Mixed Tax Rates in an Invoice (7 Columns)c5035

Mixed Tax Rates in a Form (5 Columns)

"Mixed Tax Rates in a Form (5 Columns)" was found to be relative to Design A Invoice Template For Publishing Services with the score grade of 39.

...(40) This tax invoice template named Mixed Tax Rates in an Invoice (7 Columns) is a variant of Mixed Tax Rates in an Invoice (5 Columns). It differs from the original by moving the two new columns into the printable form.

...(139) In the original version, which is named Mixed Tax Rates in an Invoice (5 Columns) here on InvoicingTemplate.com, we implemented a feature that allows you to tax different types of items with different rates on one same invoice by adding several custom fields and creating some Excel formulas. By using custom fields and Excel formulas, we can create exciting features that are not supported by the default sales invoice template that was shipped with Uniform Invoice Software. The two newly added columns, which are "Product Type" and "Applied Tax Rates", are placed outside the printable invoice form in the original version. If the product / item description text labels are short, you may like to place these two new columns inside the printable invoice form. This customized form named Mixed Tax Rates in an Invoice (7 Columns) implements this.

Five Price Percentage Levels (Service)c4015

Form with 5 Price Levels

"Five Price Percentage Levels (Service)" was found to be relative to Design A Invoice Template For Publishing Services with the score grade of 37.

...(24) This is a variant of 5 Price Levels (Sales, Amount). It is suitable for service business as it moves out all the shipping-related fields.

...(44) This customized invoice template uses the exactly same database structure and field definition as the original version. Please refer to the explanation of the original invoice template for information about the price fields and how to set up prices and discounts for your prices.

...(51) The calculation of tax in this invoice template is also similar to the implementation in the original version. As a sample on customizing the tax rules, it uses only one "taxable" checkbox on the invoice body (but outside the printable area) to control whether to calculate taxes on this invoice template.

Simple Proforma Invoicing Samplec6019

Simple Proforma Invoice Format

"Simple Proforma Invoice Format" was found to be relative to Design A Invoice Template For Publishing Services with the score grade of 26.

...(65) Once Simple Proforma Invoicing Sample is unprotected and switched into design mode, you can now move the controls to the new location you like. To do this, click to select a control, or push the CTRL on your keyboard and then select all the controls you want to move using mouse. Then, drag (one of) the select controls to move them to the new location.

...(25) Thirdly, we modify the tax formulas of the template, so that all items on the template are taxable by ignoring the state of the checkbox.

Debit Note Templatec6016

Debit Note Form

"Debit Note Template" was found to be relative to Design A Invoice Template For Publishing Services with the score grade of 25.

...(136) 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 spreadsheet form. Debit Note Template uses custom fields to implement the features that are not available in the default template shipped with the invoicing program. 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, our invoicing app 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.

Snow Removal Billing Formatc7026

Snow Plowing Invoice Template

"Snow Removal Billing Format" was found to be relative to Design A Invoice Template For Publishing Services with the score grade of 7.

...(38) There are many way to charge for the now plowing / removal service. Sometimes it is based on hours worked and hourly rate, sometimes it is simply project based. This snow plow invoice template uses the first method.

...(105) Although it is easy to create the layout and format of Snow Removal Billing Format with Microsoft Word or other Microsoft Office programs, or even with some PDF programs like Adobe Acrobat, the support for Excel formulas makes doing automated calculations easy to implement and modify. For example, Snow Removal Billing Format 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 Snow Removal Billing Format, Excel formulas are also used to create the relationship between several fields, such as one field should be the sum of two other fields.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c4044
Itemized Graphic Design Invoice
Monday, November 9, 2015,
16
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
c3001
Basic Sales Invoice Template (Light Blue)
Tuesday, April 22, 2014,
12
3
A4
Portrait
Sales
c4029
Designer Billing Format (Blue)
Monday, October 6, 2014,
6
4
A4
Portrait
Service
c4096
Designer Invoicing Format with Bamboo Chinese Painting
Monday, October 31, 2016,
6
4
A4
Portrait
Service
c7027
Hotel Receipt Format with Blue Gradient Design
Wednesday, June 29, 2016,
12
7
A4
Portrait
Receipt
c2031
Blank Service Invoice with Green Gradient Design
Thursday, June 30, 2016,
6
2
Letter (8-1/2 in. x 11 in.)
Portrait
Service
c4030
Designer Invoice Template (Gray)
Tuesday, October 7, 2014,
6
4
A4
Portrait
Service
c5035
Mixed Tax Rates in an Invoice (7 Columns)
Monday, November 25, 2013,
12
5
A4
Portrait
Sales
c4015
Five Price Percentage Levels (Service)
Thursday, November 14, 2013,
30
4
A4
Portrait
Service
c6019
Simple Proforma Invoicing Sample
Thursday, October 9, 2014,
20
6
A4
Portrait
Pro-forma
c6016
Debit Note Template
Thursday, September 18, 2014,
12
6
A4
Portrait
Other
c7026
Snow Removal Billing Format
Friday, February 26, 2016,
12
7
A4
Portrait
Service

What Is Hot

Feature Galleries