Invoice Definitions

1. Service Invoice with Profit Calculation

"Service Invoicing Form with Profit Calculation" was found to be relative to Invoice Definitions with the score grade of 84.

(From Detail Page - about 43 words) - Service Invoice with Profit Calculation is a variant of Sales Invoice Template with Profit Calculation. The printing result is exactly same as the service invoice template here on InvoicingTemplate.com, but it has the ability to calculate profit based on the cost you enter.

(From Detail Page - about 26 words) - This variant format is created based on the Sales Invoice Template with Profit Calculation, by moving the entire shipping address section out of the print area.

(From Detail Page - about 143 words) - The printable area, or print area, is the area with white background on the center of the Service Invoice with Profit Calculation spreadsheet. By default Microsoft Excel prints the entire worksheet when you issue the print command, but if the worksheet has a print area defined, such as what we do for Service Invoice with Profit Calculation, only the print area will print. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet again. If you need to recreate the print area definition, here are what to do: On the "Invoice" worksheet of the Service Invoice with Profit Calculation, select the cells that you want to define as the print area; On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

(From Detail Page - about 148 words) - There are other variants and designs here on InvoicingTemplate.com too. For example, Sales Invoice Template with Profit and Taxable Column offers a similar invoicing form as Sales Invoice Template with Profit Calculation, but added a "Taxable" column on the printable area. And Service Invoice Template with Profit and Taxable Column offers a similar invoicing form as Service Invoice Template with Profit Calculation but with a "Taxable" column on the printable invoice design. As the name implies, the "Taxable" column is a checkbox column, which is placed outside the printable area on most invoice designs here on InvoicingTemplate.com. Microsoft Excel provides powerful features that let you easily customize the forms, such as adjust the fonts / colors, or even moving cells and controls. Uniform Invoice Software uses Excel templates and its front-end, allowing you leverage the full power of Microsoft Excel, the most used spreadsheet program around the world.

(From Detail Page - about 67 words) - Our service invoice templates offers budget-friendly solutions for service companies, consultants, and freelancers, such as plumbing or handyman or rental of trucks. You need an invoice that will make your business look professional and is easy to use. We have many invoices to choose from, so if the download on this page isn't what you need, browse our other invoice templates or tell us what you need.

read more download format pdf

2. Simple Invoice Template - Discount Percentage Field

"Simple Invoice Template - Discount Percentage Field" was found to be relative to Invoice Definitions with the score grade of 62.

(From Detail Page - about 25 words) - Giving discount on a percentage basis is a common practice in many businesses. This simple invoice template demonstrates how to add the fields / feature.

(From Detail Page - about 108 words) - With c4051 Simple Invoice Template - Discount Amount Field, we learnt how to add a discount amount field, where the discount amount is subtracted directly from "Subtotal" by using Excel formulas. This new simple invoice template will be based on c4051 Simple Invoice Template - Discount Amount Field, and by adding a discount percentage field, you enter the discount percentage instead of discount amount, and then calculate the discount amount based on discount percentage by using Excel formula. This sample, just like other invoicing templates and forms available here on InvoicingTemplate.com, demonstrates how flexibility it could be by using Excel and Uniform Invoice Software as your invoicing tool.

(From Detail Page - about 48 words) - The implementation of c4051 Simple Invoice Template - Discount Amount Field adds the discount amount field on the bottom of the form at J35 and K35. In this new sample, we'll add percentage fields on the same row but before the discount amount fields, at G35 and H35.

(From Detail Page - about 14 words) - Now let's look at the steps required to add the new Discount Percentage field.

1. First, back up the template and database file. You can do this by simply copying the files in Windows Explorer.

   (From Detail Page - about 45 words) - Unlike the other pure Excel-based invoicing solutions, Uniform Invoice Software stores data (customers, products, invoices and payments) in a backend database. So you need to back up the database before modifying its structure or definitions (like in this sample, we'll add the discount percentage field).

2. Open your invoice template in Microsoft Excel.
3. Click the "Design Mode" button on the "Invoice" ribbon tab.
4. Click cell G35, enter the text label "DISCOUNT PERCENTAGE". You may like to make the cell format "Right-aligned" so that the text won't cover the next cell H35. To do this, with G35 still selected, click the "Align Right" button in the "Alignment" group on the "Home" ribbon tab.
5. Click to select the cell H35. Enter the cell name "oknDiscountPercentage" into the name box on the left-side of Excel formula bar.
6. Right-click the same cell, and choose Format Cells from the shortcut menu. On the "Format Cells" dialog box, go to the "Protection" tab and clear the "Locked" property.

   (From Detail Page - about 37 words) - A locked cell is not manually editable / fillable when the worksheet is protected. So we have to clear the "Locked" property because on creating invoices we need to be able to fill in the percentage value.

   (From Detail Page - about 35 words) - Now go to the "Number" tab of the "Format Cells" dialog box. From the "Category" list choose "Percentage". Adjust the "Decimal Place" if you like. In this sample, we just keep the default value "2".

   Click OK to close the "Format Cells" dialog box.

7. Click the "oknDiscountAmount" cell at K35, modify its formula to be "=ROUND( SUM ( oknLineTotal_1:oknLineTotal_12 ) * oknDiscountPercentage,2)".
8. Right-click the K35 cell and choose "Format Cells" dialog box. Go to the "Protection" tab. Check the "Locked" property. Since we're calculating discount amount using a formula, so there is no need to make it manually fillable or editable on creating invoices. By enabling the "Locked" property, we prevent breaking the formula accidently by manually entering values into this cell on creating invoices.

   (From Detail Page - about 27 words) - We've already added proper formulas for both tax cells that consider the discount on tax calculations. So in this sample we won't customize the tax formulas again.

9. Now exit design mode by clicking the "Design Mode" button again on the "Invoice" ribbon tab because we need the Custom Field Manager to modify the database to create the new percentage field.
10. Click the "Invoices" button on the "Invoice" ribbon tab.
11. Click "Custom Fields".
12. On the "Custom Field Manager" dialog box, make sure "Invoice Header" is selected on the "Database Table" list. Click "Add Field" to open the "Add New Custom Field" dialog box.
13. Fill in these values - Field Name: DiscountPercentage; Type: Decimal; Precision: 6; Scale: 4.

    (From Detail Page - about 52 words) - Note that the field name ("DiscountPercentage") must match the cell name defined on the "Invoice" spreadsheet. Uniform Invoice Software determines which database field to store each cell value by using names. It is the names (Excel cell name and database field name) creates the relationship between an Excel cell and database field.

    (From Detail Page - about 33 words) - Also note since we allow 2 digits after the decimal place on the "oknDiscountPercentage" field, the "Scale" of this custom field must be 4 or greater in order to store the value completely.

14. Click OK to close the "Add New Custom Field" dialog box.
15. Click "Close" to close the custom field manager dialog box.
16. Click the "Save" button on Excel quick access toolbar to save the customized template.

read more download format pdf

3. Simple Sample - Printing on Letterhead Paper

"Simple Invoicing Template - Printing on Letterhead Paper" was found to be relative to Invoice Definitions with the score grade of 13.

(From Detail Page - about 37 words) - Do you want to print your invoices on company letterhead / business letterhead papers? It is easy to do. This simple invoice template demonstrates how to customize a template so that it is suitable for letterhead papers.

(From Detail Page - about 119 words) - Nothing says "I'm official" like business letterhead. Printing invoices and quotes on papers with letterhead makes them look professional. The letterhead could include a logo, company slogan, name, address and contact information, as well as other personalized text. Compared to online web-based billing solutions (even those open source solutions), one of the advantages of a template (including those based on Google Docs) is easy-customizing. While we've already have invoice samples / forms and solutions on moving fields, moving columns, adding fields, moving controls which shows how to move the tax boxes, changing paper size, changing print orientation, and more, with this simple invoice template tutorial we'll look at how to customize an invoicing form for papers with letter head.

(From Detail Page - about 119 words) - With most designs, letterheads usually put on top of papers. It is common for attorney / legal, medical, catering, restaurant, law firms (whether small or big), health insurance billing or statement / timesheet, graphic design, freelance, plumbing, marketing, business plans, accounting, house rent (yearly or monthly), or even home businesses for monthly bill. So in this free receipt / bill sample, we assume that the company or business uses papers with letterhead on top (click the screenshots for a quick review), and the letter head including business logo, company name, address, slogan, and contact information - so to customize an invoicing layout / billing format for printing, we'll first move these information out of the printable form / definition.

(From Detail Page - about 29 words) - In this example, which you can download for free, we use the simple invoice templates created with c4051 Simple Invoice Template - Discount Amount Field as the starting point.

...(497)...

(From Detail Page - about 52 words) - In real world you may have to print several times and adjust the size of the margins (or the height of the top-empty row) according the print result to archive the best result. Once you have it correctly set, your invoices will look not only professional, but also being a brand recognition.

read more download format pdf