Skip to main content
InvoicingTemplate.com main content

Bill Format with Modern Designc4093

Bill Format with Modern Design

"Bill Format with Modern Design" was found to be relative to Designer Invoice Templates In Excel with the score grade of 95.

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

...(69) The logo image on the top-left corner, which shows our web site name "InvoicingTemplate.com" in an image created by using the Word Art feature of Excel. This is a placeholder image that you should replace with your own design. If you are one of those professional graphic designers / photographers that also like Excel, you make also like to replace the default background image with your own modern designs.

Designer Invoice Template (Red)c4028

Designer Billing Form (Red)

"Designer Invoice Template (Red)" was found to be relative to Designer Invoice Templates In Excel with the score grade of 78.

...(71) Here on InvoicingTemplate.com we provide nothing else but only free invoice templates in Microsoft Excel, although a PDF fillable invoice and proposal template is also provided along with each Excel spreadsheet template. Use our business invoices to bill your clients, which give your small business a polished and professional look. Easily customize this template and the others by using built-in Excel colors and themes, adding your own logo and business information.

...(77) We all know that invoices and proposals are business documents. Just because the invoice and proposal are business documents, doesn't mean it has to be boring. An invoice is usually your last contact with a client, so why not leave them with a lasting impression? Done properly, your invoice can be an effective part of your marketing strategy. Why can't your invoices and proposals reflect your branding and express your thanks to the customer for their business?

Designer Invoicing Format with Bamboo Chinese Paintingc4096

Designer Invoicing Format with Bamboo Chinese Painting

"Designer Invoicing Format with Bamboo Chinese Painting" was found to be relative to Designer Invoice Templates In Excel 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:

...(11) And then, the tax is calculated using a formula like this:

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

...(31) If all the invoiced items are taxable (or not taxable), you can safely delete all the "Taxable" checkbox controls, and then modify tax formula to this to simplify the tax calculation:

Designer Billing Format (Blue)c4029

Designer Billing Form (Blue)

"Designer Billing Format (Blue)" was found to be relative to Designer Invoice Templates In Excel with the score grade of 68.

...(113) To change the currency symbol of Designer Invoice Template (Blue), first make sure you've unprotected Designer Invoice Template (Blue) spreadsheet. Select the cells (fields) for which you want to modify the currency symbol, by dragging your mouse to select multiple cells on Designer Invoice Template (Blue), you push CTRL key on keyboard and click each cell on Designer Invoice Template (Blue) one by one, and then right-click one of the selected cell and choose Format Cells. From the Number tab, you can choose either "Currency" or "Accounting" from the Category list. Note that currency formats are used for general monetary values, you should use accounting formats to align decimal points in a column.

Designer Invoice Template (Gray)c4030

Designer Billing Form (Gray)

"Designer Invoice Template (Gray)" was found to be relative to Designer Invoice Templates In Excel with the score grade of 67.

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

Itemized Graphic Design Invoicec4044

Itemized Graphic Design Invoice

"Itemized Graphic Design Invoice" was found to be relative to Designer Invoice Templates In Excel with the score grade of 60.

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

Excel Quotation Templatec9008

Excel Quotation Template

"Excel Quotation Template" was found to be relative to Designer Invoice Templates In Excel with the score grade of 59.

...(48) The discounting calculations in this template is built specially for a real business. It may not be suitable for you, but it is a good sample on how to customize the invoice template shipped with Uniform Invoice Software. For more samples on quotations and estimations, visit Estimate Templates.

...(19) The value of the "Quantity" is calculated using an Excel formula like this, where "_?" is the line number:

...(41) The formula for "Line Total" incorporates both the auto-calculated portion, and the manually fillable field ("oknLineTotalManual_?" fields, placed outside the printable area, which means it is manually editable on creating invoices / estimations, but will not be included on printable invoices).

Excel Payment Voucher Templatec5052

Payment Voucher Template

"Excel Payment Voucher Template" was found to be relative to Designer Invoice Templates In Excel with the score grade of 55.

...(35) Note that there is a default Logo image on the top of form, which you must replace with your own logo image. To do this, unprotect the Invoice worksheet, and then switch to design mode.

...(22) Once you have finished your design work for Excel Payment Voucher Template, click the Design Mode button again to exit design mode.

  • Right click the Logo image, and then select Properties from the menu.
  • Click the Picture property, and then click the "..." button.
  • Browse to the folder containing your icon file. Select and open the icon file.
  • Close the Properties dialog box.
  • Drag the border of the image object to resize it, if needed.

General Quote Template for Excelc2035

General Quote Format in Excel Spreadsheet Format

"General Quote Template for Excel" was found to be relative to Designer Invoice Templates In Excel with the score grade of 45.

...(88) Due to this difference, it is important to clearly identify the document type on the header - whether it is a quote or an estimate. It is also useful, at least in some business areas, to include an expiry date on the document, if your prices are subject to change on the time. In this sample, we added it as a custom field "ExpiryDate". This field is defined as "text (100)" in the backend Access database, and the corresponding cell is named "oknExpiryDate" on the top quote form.

...(78) 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 General Quote Template for Excel without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with our invoicing software installed.

Job Estimate Template for Excelc4084

Job Estimate Template for Excel

"Job Estimate in Excel Format" was found to be relative to Designer Invoice Templates In Excel with the score grade of 36.

...(119) For this reason, the "ESTIMATE#" support all the features assigned to the "Invoice#" cell by Uniform Invoice Software. For example, if you click "Save To DB" or "Save Invoice", a sequential, progressive and unique estimate# is generated automatically if the "Estimate#" cell is left blank (see our gallery page at Excel Invoice Template Automatic Invoice Numbering). With pure-Excel spreadsheet solutions, this automatic numbering is not possible without using macros. To display / retrieve an existing estimate or quote, you can simply enter the estimate# into the cell. With the support from Uniform Invoice Software, the pure-Excel spreadsheet template is not only printable, but also enables features that could be hardly to implement with pure-Excel estimating and quoting software apps.

...(25) With Uniform Invoice Software, the auto-generation of invoice# (in this case, estimate# or quote#) is based on a counter stored in the backend Access database.

Donation Receipt Template for Excelc1004

Donation Receipt Format for Excel

"Donation Receipt Format for Excel" was found to be relative to Designer Invoice Templates In Excel with the score grade of 32.

...(61) Secondly, the receipt should include the donor's name, this is necessary in order to be legally valid. Although not required, we've placed the "Phone#", "Mobile#" fields on the top of the section outside the printable area. In case you want to include these information on the PDF donation receipt or printed receipt, you can easily move them into the "Donor" section.

...(25) Third, it is also required to clearly describe the donation, including the date the donation was made, as well as the amount of the donation.

...(15) The receipt must also declare whether the donor received goods in return for the donation.

Labor Invoicing Samplec4070

Labor Billing Format for Excel

"Labor Billing Format for Excel" was found to be relative to Designer Invoice Templates In Excel with the score grade of 28.

...(32) Just like most Excel sample invoicing template here on InvoicingTemplate.com, Labor Invoice Template has a logo placeholder image on the top of the form, which you can replace with your own image.

  • Right click the Logo image, and then select Properties from the menu.
  • Click the Picture property, and then click the "..." button.
  • Browse to the folder containing your icon file. Select and open the icon file.
  • Close the Properties dialog box.
  • Drag the border of the image object to resize it, if needed.

Parts and Labor Invoicing Formatc4071

Parts and Labor Billing Format for Excel

"Parts and Labor Invoicing Format" was found to be relative to Designer Invoice Templates In Excel with the score grade of 21.

...(130) Here on InvoicingTemplate.com there is at least one another invoice template that has the similar layout, which is Contractor Billing Format. In fact, this parts and labor invoice template is created based on "contractor billing format", by removing the "Date" (oknItemDate_?) column, and by adding back the "Unit Price" ("oknPrice_?") and the "Quantity" ("oknQuantity_?") column. As you can see, although we've made significant customizations to the template, Uniform Invoice Software works well with the new template. If you are looking for a billing and invoicing software for your business, make sure it is flexible enough so that it meets your special business requirements. Visit Excel Job Invoice Template, Contractor Invoice Template Free, Auto Repair Invoice Template, Plumbing Contractor Invoice Template and Contract Labor Invoice Template for more invoice template samples.

Excel Shipping Invoice with Printable Truck Background Imagec5087

Shipping Invoice with Printable Truck Background

"Excel Shipping Invoice with Printable Truck Background Image" was found to be relative to Designer Invoice Templates In Excel with the score grade of 19.

...(34) Fortunately it is still possible to print an image in the background of a worksheet. This technique could also implement watermark effect on your invoices, as shown in Simple Invoice Template with Printable Watermark.

  1. First make sure the "Invoice" worksheet is in design mode (to switch to design mode, push down the "Design Mode" button on the "Invoice" ribbon tab).
  2. And then, select "Print_Area" from the "Name" box on Excel formula bar. This selects all cells in the printable invoice form.
  3. Right-click one of the selected-cells, and choose "Format Cells". On the "Format Cells" dialog box.
  4. Go to the "Fill" tab, choose "No color", and then click OK.
  1. Again, make sure the "Invoice" worksheet is in design mode.
  2. Click to select a "pick up" (magnifying glass icons) button.
  3. Hit DEL key on keyboard.

Babysitting Invoice (Happy Kids on Earth Style)c5088

Babysitting Receipt Format (Happy Kids on Earth Style)

"Babysitting Invoice (Happy Kids on Earth Style)" was found to be relative to Designer Invoice Templates In Excel with the score grade of 18.

...(66) There's no doubt that babysitting requires skills in creativity, adventure, and play. Keep your business running successfully also requires skill. While it's the time to ask payments from parents, a well-designed invoice or receipt gives the parents an impression that you are even care about the details ignored by many other businesses, so you should be able to take good care of their babies and kids.

...(75) On revisiting the original daycare invoice template, we removed all the background settings for the range define by the "Print_Area" name. The "Print_Area" name is special name that defines what to print on a worksheet - we call this the printable invoice forms - if this cell name is missing from the worksheet, the whole worksheet is printed when you issue the "Print" command; otherwise, only the range included in the "Print_Area" definition is included.

Simple Sample - Decimal Precision of Product Pricesc4060

Simple Invoicing Sample - Decimal Precision of Product Prices

"Simple Invoicing Sample - Decimal Precision of Product Prices" was found to be relative to Designer Invoice Templates In Excel with the score grade of 12.

...(83) On the other hand, many other fields, such as line totals, subtotal, total, tax amounts, shipping cost, payment amount, balance due etc., allow only two digits after the decimal pointer - if you take a look at the formula of these cells, there is a "round" formula the make sure the result of calculation having only two digits after the decimal pointer. If you want to change this, you need to use the Advanced Database Field Customization tool provided by Uniform Invoice Software.

Auto Repair Service Invoice with Car Lift Background Imagec5089

Auto Repair Service Invoice with Car Lift Background Image

"Auto Repair Service Bill with Car Lift Background Image" was found to be relative to Designer Invoice Templates In Excel with the score grade of 10.

...(94) Uniform Invoice Software is an Excel add-in program that runs inside Excel. By connecting the front-end Excel template with a backend database (could be Microsoft Access database or SQL Server database), Uniform Invoice Software provides and powerful features that could hardly be implemented with only Excel. By seamlessly integrating Excel with backend database, Uniform Invoice Software is able to manager your data in an organized and safe way, and thus being able to offer time-saving features like automatic invoice numbering, flexible search bar that allows you to locate your data (customer, product, invoice) easily.

...(65) With this implementation, it also included a car lift image as the printable background. This makes the invoice design differs from others and tells what you do in an intuitive way. If you prefer to save some ink on printing (this won't be a problem if you send electronic PDF invoices only), you can remove the car lift image easy by following the steps below.

Simple Sample - Customer Name on Product Reportc4059

Simple Invoicing Sample - Customer Name on Product Report

"Simple Sample - Customer Name on Product Report" was found to be relative to Designer Invoice Templates In Excel with the score grade of 8.

  1. As always, first you need to back up the files that will be modified. In this case, we'll modify both the template and database files. So back up both files.
  2. Open the invoice template as usual.
  3. Click the "Invoices" button on the ribbon tab.
  4. Click "Custom Fields" on the toolbar. This opens the Custom Field Manager.
  5. From the "Database table" drop-down list, choose "Invoice Body".
  6. Click "Add Field". This opens the "Add New Custom Field" dialog box.
  7. Fill in these values - Name: CustomerName, Size: 100. Click OK. This create a custom field named "CustomerName".
  8. Click "Add Field" again. Create another custom field "CustomerContact", set field size to 100.
  9. Click "Close" to close the Custom Field Manager and return to the invoice spreadsheet form.
  10. Click the "Design Mode" button on the "Invoice" ribbon tab to switch the billing form into design mode.
  11. Now choose a place to populate the customer name and contact number on the invoice body. Note these information will not be printed, so we choose column W and column X. Enter the column heading label "Customer Name" into $W$21, and then enter "Contact" into $X$21.
  12. Name the "CustomerName" cells, ranging from W22 to W33. The names should like these - oknCustomerName_1, oknCustomerName_2, oknCustomerName_3, ... oknCustomerName_12.

    Name the "CustomerContact" cells in the same way too, ranging from X22 to X33. The names should like these - oknCustomerContact_1, oknCustomerContact_2, oknCustomerContact_3, ... oknCustomerContact_12.

  13. Assign formula to the first customer name cell (oknCustomerName_1): =if(D22="","",oknWhoName). This formulas means that, if the first Product Description cell (D22) is empty, then the current cell is empty; if the first Product Description cell is not empty, fill the current cell with the value of customer name (oknWhoName).
  14. Make sure oknCustomerName_1 ($W$22) cell is selected, push left mouse key on the fill handler (right-bottom corner) of the selection box, drag down till W33. Excel fill formulas automatically into all the other oknCustomerName_* cells.
  15. Click to select the first customer contact number cell (oknCustomerContact_1). Assign it a formula: =IF(D22="","",oknWhoPhone).
  16. Make sure oknCustomerContact_1 ($X$22) cell is selected, push left mouse key on the fill handler (right-bottom corner) of the selection box, drag down till X33. Excel fill formulas automatically into all the other oknCustomerContact_* cells.

    As you can see from this sample, it is easy to populate and calculate data using Excel formulas. While there are other tools like Microsoft Word, Adobe Acrobat or even Photoshop and some online apps like Google Docs, that could create beautiful invoice and billing forms, one of the best / big advantages of Excel is that it simplifies calculations.

  17. Click and activate the "Product Report" worksheet.
  18. Click the "Unit Cost" column heading. Quickly click "Format Painter" twice on Excel "Home ribbon tab.
  19. Click the next two cells to the right of the "Unit Cost" cell - in this case, J10 and K10 . This paste the format of the "Unit Cost" cell to J10 and K10. Press ESC on keyboard to exit the format painter.
  20. Click to select the J10 cell. Name it "oknRpCustomerName". Fill column heading into this cell like "Cust. Name". You may need to resize the column to make it wider.
  21. Click to select the K10 cell. Name it "oknRpCustomerContact".Fill column heading into this cell like "Cust. Contact". Again, you may need to resize to column to make it wider.
  22. Exit design mode by clicking the "Design Mode" button again on the "Invoice" ribbon tab.
  23. Now if you create and save a new invoice, the customer name and contact number will be saved along with each item. And if you generate a product report, the customer name and contact number will be shown on report too. Note that after adding two new columns, the "Product Report" will not be printable with the default paper size and orientation. You may like to change paper size or orientation, or hide some columns by clicking the Columns button on the Product Report worksheet.

Bill Format for Computer Repair Servicec5096

Bill Format for Computer Repair Service

"Invoicing Template for Computer Repair Service " was found to be relative to Designer Invoice Templates In Excel with the score grade of 6.

...(88) The "Bill To" section includes 6 fields - client#, name, address, city state and zip, email and phone. In many situations email is a key field now, especially if you want to send PDF invoices to your clients via email. By adding the email field to the "Bill To" section, you are able to create new customer records along with their email address populated; and besides that, it also ensure you can send a PDF version of the invoice to the customer by simply clicking the "Extract/Email" button.

Hourly Service Billing Samplec4025

Hourly Service Billing Sample

"Hourly Service Billing Sample" was found to be relative to Designer Invoice Templates In Excel with the score grade of 2.

...(112) If you are in the service business and you charge your customers based on the time (hours) spent to render the service, this template should be a welcome addition to you if you think the item-based form layout, which is implemented in the default invoicing template shipped with Uniform Invoice Software, never quite matches the nature of your business. This ready-to-use template could be your favor on creating invoices, quotes or estimates. It offers a professional yet simple Hourly Billing Sample that can help you in creating service based invoices quickly and effectively. This template is created using Microsoft xlsx format so that anyone can easily use it for his/her own purpose.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c4093
Bill Format with Modern Design
Thursday, October 27, 2016,
5
4
Letter (8-1/2 in. x 11 in.)
Portrait
Service
c4028
Designer Invoice Template (Red)
Wednesday, October 8, 2014,
6
4
A4
Portrait
Consulting
c4096
Designer Invoicing Format with Bamboo Chinese Painting
Monday, October 31, 2016,
6
4
A4
Portrait
Service
c4029
Designer Billing Format (Blue)
Monday, October 6, 2014,
6
4
A4
Portrait
Service
c4030
Designer Invoice Template (Gray)
Tuesday, October 7, 2014,
6
4
A4
Portrait
Service
c4044
Itemized Graphic Design Invoice
Monday, November 9, 2015,
16
4
A4
Portrait
Service
c9008
Excel Quotation Template
Friday, February 10, 2017,
37
9
A4
Portrait
Other
c5052
Excel Payment Voucher Template
Thursday, May 29, 2014,
12
5
A4
Portrait
Receipt
c2035
General Quote Template for Excel
Friday, August 19, 2016,
18
2
Letter (8-1/2 in. x 11 in.)
Portrait
Other
c4084
Job Estimate Template for Excel
Wednesday, August 17, 2016,
10
4
Letter (8-1/2 in. x 11 in.)
Portrait
Other
c1004
Donation Receipt Template for Excel
Monday, August 22, 2016,
8
1
A4
Portrait
Receipt
c4070
Labor Invoicing Sample
Wednesday, May 11, 2016,
8
4
A4
Portrait
Service
c4071
Parts and Labor Invoicing Format
Thursday, May 12, 2016,
18
4
A4
Portrait
Sales
c5087
Excel Shipping Invoice with Printable Truck Background Image
Friday, July 8, 2016,
16
5
A4
Portrait
Sales
c5088
Babysitting Invoice (Happy Kids on Earth Style)
Saturday, July 9, 2016,
12
5
Letter (8-1/2 in. x 11 in.)
Portrait
Service
c4060
Simple Sample - Decimal Precision of Product Prices
Saturday, February 6, 2016,
12
4
A4
Portrait
Sales
c5089
Auto Repair Service Invoice with Car Lift Background Image
Tuesday, July 12, 2016,
12
5
A4
Portrait
Service
c4059
Simple Sample - Customer Name on Product Report
Friday, February 5, 2016,
12
4
A4
Portrait
Sales
c5096
Bill Format for Computer Repair Service
Tuesday, October 18, 2016,
12
5
A4
Portrait
Service
c4025
Hourly Service Billing Sample
Sunday, September 28, 2014,
12
4
A4
Portrait
Service

What Is Hot

Feature Galleries