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

Invoicing Template in Eurosc4100

Invoicing Format 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.

...(56) As you can see, with Microsoft Excel it is fairly easy to change the format and layout of a form design. While there are many other templates available for billing and invoicing, like Microsoft Word or Publisher, Google Docs, OpenOffice.org, even HTML + CSS or Photoshop, it is much easier to do formatting with Microsoft Excel.

Professional Freelance Billc4047

Professional Freelance Billing Format

"Professional Freelance Bill" 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.

  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.

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

  1. Open the invoice template.
  2. Click "Invoices" on the "Invoice" ribbon tab.
  3. Click "Custom Fields".
  4. Make sure the "Database Table" field shows "Invoice Header". Click "Add Field".
  5. Enter "DiscountAmount" as "Field Name". The field name should match the cell name defined on the invoicing template. In this example, we defined cell name "oknDiscountAmount"; and thus the field name should be "DiscountAmount". It is this name that creates the relationship between an Excel cell and a database field. In other words, the name maps the cell name to a database field.
  6. Choose "Decimal" from the "Field Type" drop down list, enter "10" as "Precision", and enter "2" as "Scale". The "Precision" and "Scale" field determine how many digits, in total or after the decimal pointer, could be stored by the field. The default value of a decimal value will be zero if not defined here.
  7. Click "OK" to close the "Add New Custom Field" dialog box; Click "Close" to close the "Custom Field Manager" dialog box.

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

...(49) The definition of the database structure in Uniform Invoice Software established the "one-to-many" relationship between the "Invoice Header" (i.e. "InvIndr") and "Invoice Body" (i.e. "InvBdy") database tables. This means that, for each record in the invoice header database table, there might be one or many items belong to it.

...(76) On the other hand, the main content of the "Product" report is retrieved from the invoice body database table, adding the fields of the invoice header table to the invoice body table will create many redundant data, as they must be repeated for each item. One exception though - the definition of invoice body items must include the invoice# (InvoiceID) field, since it is the primary key of the invoice header table that identifies each uniquely.

PayPal Payment Button Using Custom Imagec3015

Excel Invoice with PayPal Payment Button Using Custom Image

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

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

...(46) Note that the PayPal hyperlink assigned to the button on the Excel spreadsheet is just a template. It will be replaced with the real payment link on a PDF invoice. However if the PDF bill is blank (i.e. no balance due), the payment button is removed.

Basic Service Bill Sample with Depositc5078

Simple Service Invoicing Template with Deposit

"Basic Service Bill Sample with Deposit" was found to be relative to Invoice Template Google Docs with the score grade of 47.

...(132) Now you can test the template to see if it works in the way you like. Since an invoice is not just a document of sales but it is essentially an accounting tool. It is utilized by an organization to make communication with the customer who is making a purchase or getting services. Every business has its own requirements regarding invoices. Fortunately, compared to Microsoft Word, or even Adobe Acrobat PDF and Photoshop, or OpenOffice programs, or some online accounting / billing or spreadsheet tools like Google Docs, Microsoft Excel wins in many areas when it comes to customizing a form. This, combined with the backend database, makes Uniform Invoice Software an ideal invoice creator for small businesses. Feel free to download and try it to see how it works for you.

Bill Format for Painting Servicec4087

Bill Format for Painting Service

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

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

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

...(56) This billing template has one tax set by default, and by assuming all items that are invoiced are taxable, it removes all the "Taxable" checkbox. The tax amount is calculated based on "oknSubtotal" (the sum of all item amounts), instead of "oknTaxableSubtotal" as found in the default invoice template shipped with Uniform Invoice Software installer program).

...(57) To setup your taxing options and rules, click the "Settings" button on the "Invoice" ribbon tab, and then click the "Settings" button, go to the "Taxes" tab, where you can find options for the number of taxes, tax names, tax rates etc. For more variants of our templates designed for special taxing requirements, visit taxing invoice templates.

Notary Invoice Templatec3007

Notary Billing Template

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

...(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 Template" was found to be relative to Invoice Template Google Docs with the score grade of 1.

...(105) Although it is easy to create the layout and format of Service VAT Invoice Template 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, Service VAT Invoice Template 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 Service VAT Invoice Template, 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
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
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
c5078
Basic Service Bill Sample with Deposit
Tuesday, February 9, 2016,
12
5
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