Skip to main content
InvoicingTemplate.com main content

Blank Sales Billing Format (No-tax, Long Description)c2021

Blank Sales Billing Sample (No-tax, Long Description)

"Blank Sales Billing Format (No-tax, Long Description)" was found to be relative to Invoice Template Google Docs with the score grade of 98.

...(126) By default, Microsoft Excel shows all content of a cell on a single line. This is true no matter what the data type it holds - be it text, date or numeric value. To change this default behavior, simply enable the "Wrap Text" option. To do this, first you have to unprotect the sheet, and then drag your mouse to select all the cells for which you want to set the option for, and then right-click one of the selected cells, choose Properties from the shortcut menu. This shows the Format Cells dialog box. Go to the "Alignment" tab, on the Text Control section, you will see the "Wrap Text" option. Check it, and then click "OK". This way, Excel will wrap text automatically when necessary.

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

Invoicing Template in Eurosc4100

Invoicing Template in Euros

"Invoicing Format in Euros" was found to be relative to Invoice Template Google Docs with the score grade of 75.

  1. Backup the template before you modifying the template.
  2. Click the "Design Mode" button. This unprotect the sheet, show gridlines and row / column headings.
  3. Click to select the cell that you want to show a currency symbol. Or, if you want to make the change for multiple cells, push CTRL key on keyboard and click each cell one by one.
  4. Right-click one of the selected cell and choose "Format Cells" from Excel shortcut menu.
  5. On the "Number" tab, choose "Accounting" from the "Category" list, make sure "Decimal Place" is "2", and from the "Symbol" list choose Euro.
  6. Once done, click the "Design Mode" button again to exit design mode.
  7. Save the template by clicking the "Save" button on Microsoft Excel quick access toolbar.

Professional Freelance Billc4047

Professional Freelance Bill

"Professional Freelance Billing Format" was found to be relative to Invoice Template Google Docs with the score grade of 67.

...(79) You may find many invoicing templates available here on InvoicingTemplate.com meet the above criterion, including Freelance Invoice Template, Invoice Template Hourly Rate, or visit our service invoice template category. Every business is different. You may like your invoices not only including all the required information, but also looks professional and special to your business. That is why we at InvoicingTemplate.com create this new freelance invoice template and offer you for free, Professional Freelance Bill / Professional Freelance Billing Format.

...(62) All templates available here on InvoicingTemplate.com are in Microsoft spreadsheet format, including this template - Professional Freelance Bill or Professional Freelance Billing Format. On the Internet you may find that there are freelance invoice template in Microsoft Word format or Google Docs too. But Excel formatted spreadsheet format has its unique features. For example, you can easily apply formulas to do calculations.

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 Template Google Docs with the score grade of 64.

...(18) For another invoice template sample that is designed for letterhead papers visit Simple Invoice Template for Letterhead Paper.

  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.

Hourly Invoice Templatec5022

Hourly Billing Form

"Hourly Billing Form" was found to be relative to Invoice Template Google Docs with the score grade of 63.

...(99) Near the logo image is your company information. In this section, you should detail your company/business name, address, city state and zip, contact number and Tax ID if applicable. At the right section, you may find the fields for 'invoice#' and 'invoice date'. These are two important fields that should appear on all invoices. The 'invoice#' field should be filled with a unique number - it is generally called invoice number but usually you can add prefix text to it, such as 'INV'. If you use Invoice Manager, the invoicing program will help you generate unique invoice numbers automatically.

Simple Sample - Discount Amount Fieldc4051

Simple Invoicing Template - Adding Discount Amount Field

"Simple Sample - Discount Amount Field" was found to be relative to Invoice Template Google Docs with the score grade of 55.

  1. Backup your template (If you have not done so yet).
  2. Open the template.
  3. Click the Design Mode button on the "Invoice" ribbon tab to push the button down. In design mode, Uniform Invoice Software will not response to your clicks on buttons. In design mode, it also shows the gridlines and row/column headings of your Excel worksheet.
  4. Right-click the row heading of the first tax row on the bottom of the invoicing form. This is sample, it is R35.
  5. Choose Insert from the short-cut menu. This inserts a new row above the first tax row.
  6. Enter "DISCOUNT (AMOUNT)" underneath the "SUBTOTAL" label, i.e. $J$35.
  7. Click to select the cell where the discount amount value should be entered. In this sample, you click $K$35.
  8. Enter the cell name "oknDiscountAmount" into the name box on the formula bar. All cells names that work with Uniform Invoice Software should start with the "okn" prefix, except "Print_Area" and "Print_Titltes".
  9. Right-click the cell named "oknDiscountAmount" cell at $K$35, choose Format Cells from the shortcut menu. On the Format Cells dialog box, go to the "Protection" page, clear the "Locked" property. Click "OK" to close the dialog box. By clearing the "Locked" property, the discount amount field will be manually fillable / edition when you are creating an invoice.
  10. Click to select the cell next to the label "SUBTOTAL", i.e. the cell named "oknSubtotal" at $K$34. Modify its formula to be "=SUM(oknLineTotal_1:oknLineTotal_12) - oknDiscountAmount".
  11. To deduct the discount amount from taxable amount, modify the first tax formula (cell address $K$36 to be "=ROUND(IF(oknTaxType=0,0, oknTax1Rate*(oknLineTotalTaxable - oknDiscountAmount+IF(oknTaxTotalIncludingShippingCost=0,0,oknShippingCost))),2)"; modify the second tax formula (cell address $K$37 to be "=ROUND(IF(oknTaxType<>2,0,oknTax2Rate*(oknLineTotalTaxable - oknDiscountAmount+IF(oknTaxTotalIncludingShippingCost=0,0,oknShippingCost)+IF(oknTax2IsAppliedToTax1=0,0,oknTax1))),2)".
  12. Click "Design Mode" button on the "Invoice ribbon tab again to exit design mode.
  13. Save the template by clicking the Save command on Excel quick access toolbar.

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 Invoice Template Google Docs with the score grade of 50.

  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.

PayPal Payment Button Using Custom Imagec3015

Excel Invoice with PayPal Payment Button Using Custom Image

"Excel Invoice with PayPal Payment Button Using Custom Image" was found to be relative to Invoice Template Google Docs with the score grade of 47.

...(58) If you prefer to make your invoices differ from others, like to make your business stands out from the generals, you are free to replace the default image with your own, just like you can easily replace the default logo image we used on many of our forms, by using just the built-in tools provided by Microsoft Excel.

...(46) In this example, we take c3012 Freelance Writer Invoice format as the base template and starting point, demonstrates how to replace the image using Excel. "c3012 Freelance Writer Invoice" is a service invoice template, and is one of the featured template on invoice templates for freelancers.

Bill Format for Painting Servicec4087

Invoicing Template for Painting Service

"Invoicing Template for Painting Service" was found to be relative to Invoice Template Google Docs with the score grade of 21.

...(37) Like they said, a picture is worth a thousand words. This is true even to an invoicing form such as this one designed for painters. The images easily make the form not only professional, but also elegant.

...(126) The itemized section allows you to detail the materials used and service performed. The line totals are calculated using Excel formulas. By default these columns are titled with "Quantity" and "Unit Price", but if you are working on an hourly rate basis (not project-based), such as face painting for salon and parlor people, you can easily change the titles to be "Hours" and "Hourly Rate", to do this, simply put the template into design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab (If you don't see the "Invoice" ribbon tab, make sure you have Uniform Invoice Software installed), and then type in your new column headings to replace the existing ones. You can also try our invoice templates for hours and rates.

Independent Contractor Invoicec2032

Independent Contractor Billing Format

"Independent Contractor Billing Format" was found to be relative to Invoice Template Google Docs with the score grade of 4.

  1. First backup your template. Although we are going to do a simple customization, backing up the template before modifying it is still recommended, especially if you are not very familiar with Microsoft Excel.
  2. Open the contractor invoice template as usual.
  3. Click the "Design Mode" button on the "Invoice" ribbon tab to switch the "Invoice" worksheet into design mode. This mode allows you modify the formulas, layouts and designs of the template.
  4. From the name box located on the left-end of the formula, click the "Down Arrow" to expand the list. From the bottom of the list, choose "Print_Area". Excel marks all the cells inside the printable invoice form as selected.
  5. Go to Excel "Home" ribbon tab.
  6. From the "Font" command group, pull down the font drop down list and choose the font you like. All cells that are selected (i.e. all cells that are inside the printable invoice form) will use the font you choose.
  7. Exit design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab again.
  8. Save the template by clicking the "Save" button on Microsoft Excel quick access toolbar.

Notary Invoice Templatec3007

Notary Billing Template

"Notary Invoice Template" was found to be relative to Invoice Template Google Docs with the score grade of 3.

...(58) This implementation of Notary Invoice Template / Notary Billing Template by InvoicingTemplate.com has one tax presented on the bottom of the form, which is named "TAX". If you use the Uniform Invoice Software edition of this free invoice template, you can easily change the tax name and rate, and even the number of taxes appear on the form.

...(161) If you use the Uniform Invoice Software version of Notary Invoice Template, there are additional taxing options on the Taxes tab of the Settings window. The first is the option for choosing the number of tax items; you have 3 choices - no tax, one tax and two taxes. Secondly, you can set the names and rates in percentage for each tax, such as VAT, GST or PST, or simply Sales Tax. Thirdly, there are a group of checkbox options on the dialog box, including: "Tax invoice total including shipping cost", which adds the shipping cost to the taxable amount when checked; "Tax 2 is applied to tax 1", which adds the amount of "tax 1" to the taxable amount if checked; and "tax rate can be zero", which allows you to set any of the tax rates to be the value of zero. If you modify the options on this dialog box, the spreadsheet will be changed accordingly if needed.

Service VAT Invoice Templatec4010

Service VAT Invoice Template

"Service VAT Invoice Format" was found to be relative to Invoice Template Google Docs with the score grade of 1.

...(77) As HMRC states, "If you are registered for VAT, then whenever you supply goods or services to someone else who is also registered for VAT you must give them a VAT invoice." A VAT invoice must show certain VAT details. This VAT invoice template meets the requirements detailed on the HMRC web site. A PDF version is also provided for free. You can use this VAT Service Invoice Template as a sample of your own VAT invoices.

...(58) The VAT invoice template has a special VAT Rate column placed outside of the printable VAT invoice form. This column allows you to adjust the VAT rate for each item that is being sold. Since it is placed outside of the printable VAT invoice form, it will not be included on the printed copy of your VAT invoices.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c2021
Blank Sales Billing Format (No-tax, Long Description)
Monday, November 23, 2015,
6
2
A4
Portrait
Sales
c4100
Invoicing Template in Euros
Tuesday, November 29, 2016,
12
4
A4
Portrait
Sales
c4047
Professional Freelance Bill
Friday, November 13, 2015,
6
4
A4
Portrait
Service
c4058
Simple Sample - Printing on Letterhead Paper
Thursday, February 4, 2016,
12
4
A4
Portrait
Sales
c5022
Hourly Invoice Template
Tuesday, March 28, 2017,
12
5
A4
Portrait
Service
c4051
Simple Sample - Discount Amount Field
Tuesday, January 26, 2016,
12
4
A4
Portrait
Sales
c4059
Simple Sample - Customer Name on Product Report
Friday, February 5, 2016,
12
4
A4
Portrait
Sales
c3015
PayPal Payment Button Using Custom Image
Thursday, August 11, 2016,
10
3
A4
Portrait
Service
c9007
Commercial Invoice Format with Editable Word Art Logo
Wednesday, July 13, 2016,
9
9
A4
Landscape
Pro-forma
c4087
Bill Format for Painting Service
Saturday, October 22, 2016,
8
4
Letter (8-1/2 in. x 11 in.)
Portrait
Service
c2032
Independent Contractor Invoice
Monday, July 11, 2016,
6
2
A4
Portrait
Service
c3007
Notary Invoice Template
Thursday, October 2, 2014,
12
3
A4
Portrait
Service
c4010
Service VAT Invoice Template
Monday, January 13, 2014,
12
4
A4
Portrait
Service

What Is Hot

Feature Galleries