Skip to main content
InvoicingTemplate.com main content

Automotive Sample Invoice Templatec9001

Automotive Sample Invoice Format

"Automotive Sample Invoice Template" was found to be relative to Sample Invoice Templates with the score grade of 90.

Automotive Sample Invoice Template is the sample invoice template shipped with Excel Invoice Manager that demonstrating the use of custom fields.

Invoicing Sample for Cosmetics Shopsc4095

Invoicing Sample for Cosmetics Shops

"Billing Template for Cosmetics Shops" was found to be relative to Sample Invoice Templates with the score grade of 83.

Download this free Excel bill sample for vendors, stores, retailers and wholesalers that are specialized in cosmetics and makeup. The template (".xlsx" file) features auto calculation and a cosmetics background picture.

... The itemized detail section in the sample invoicing template allows you to list the products a customer purchased, for example "Dermactin-TS Collagen Gel Patches", "Dermactin-TS Anti-Wrinkle Eye Cream" etc. Whether you are a reseller or wholesaler, you can use the "Products" database table to manage your product / inventory. By default Uniform Invoice Software connects with Access database (you don't have to install Microsoft Access in order to just use the database), but Enterprise edition of Uniform Invoice Software supports SQL Server database too. For SQL Server, you can even run it online and access your data anywhere around the world via an Internet connection.

... With Uniform Invoice Software installed, there are several ways you can pick items on creating invoices.

... The second way to quickly fill in items into the invoice or bill is that you can enter the product# (this could be your SKU# or barcode retrieved with a scanner) into the "Product ID" field, which is put outside the printable form.

Proforma Invoice Template (4th Sample, Landscape Page Orientation)c7014

Proforma (4th Sample)

"Proforma Invoice Template (4th Sample, Landscape Page Orientation)" was found to be relative to Sample Invoice Templates with the score grade of 82.

... To adjust the width of one column for Proforma Invoice Template (4th Sample, Landscape Page Orientation), drag the boundary on the right side of the column heading until the column is the width that you want. To change the width of multiple columns for Proforma Invoice Template (4th Sample, Landscape Page Orientation), select the columns that you want to change, and then drag a boundary to the right of a selected column heading. To change the width of columns to fit the contents for Proforma Invoice Template (4th Sample, Landscape Page Orientation), select the column or columns that you want to change, and then double-click the boundary to the right of a selected column heading.

Bill Sample with Sports Themec4094

Bill Sample with Sports Theme

"Bill Sample with Sports Theme" was found to be relative to Sample Invoice Templates with the score grade of 81.

... All templates here could be downloaded for free. You can use the templates without installing Uniform Invoice Software. For example, you can just download this "Billing Sample with Sports Theme" template, fill in your business / organization name, and then create new invoices just like filling a blank paper. The result could be either printed, or you can generate electronical PDF invoice for your sports store using Office / Excel's built feature, and then send it PDF invoice to your clients. Even the template is completely free of charge, the result is good enough that even some commercial / paid invoicing software app couldn't procedure.

Law Firm Invoice Templatec5104

Law Office Billing Sample

"Law Office Billing Sample " was found to be relative to Sample Invoice Templates with the score grade of 79.

... Unlike c5067 Attorney Invoice Template, this law office billing template includes not only the "Bill To" section, the "Ship To" section (usually found on those sales invoice that allows you specify a different shipping address than the "Bill To" address) is kept inside the printable form, but has a new title "Rep. Of" (representative of), . This allows you to specify different parties who are responsive for paying the bill, and who is the party to the lawsuit or receives the law services.

... The "Currency" field is special on this template. It is defined as a custom field, but its value are fixed to the value "US $" by assigning it the formula ="US $" and by locking the cell. Uniform Invoice Software does not clear the cells when you click the "Clear & New" command, if the cells have formulas assigned and are locked.

Law Firm Invoice Template (Indian INR Currency)c5105

Law Firm Invoice Template (Indian INR Currency)

"Law Firm Invoice Template (Indian INR Currency)" was found to be relative to Sample Invoice Templates with the score grade of 79.

  1. First make a backup of your template and Access database file.
  2. Open the template.
  3. Click the "Design Mode" button on the "Invoice" ribbon.
  4. Go to Excel "Formulas" ribbon tab, and then click the "Name Manager" button.
  5. On the name manager dialog box, browse to and find / select the "oknShippingCost" name, click "Edit".
  6. Enter the new name "oknBankCharge".
  7. To make the bank charge column populated on reports, we also need to rename "oknRsShippingCost" to "oknRsBankCharge", rename "oknRcShippingCost" to "oknRcBankCharge", and rename "oknRrShippingCost" to "oknRrBankCharge".
  8. Click "Close" to close the name manager dialog box and return to the Excel worksheet.
  9. Exit design mode by clicking the "Design Mode" button again on the "Invoice" worksheet.

Sample Format for Job Invoicing (Tax Column)c6015

Sample Format for Job Invoicing (Tax Column)

"Sample Format for Job Invoicing (Tax Column)" was found to be relative to Sample Invoice Templates with the score grade of 77.

... In order to create such format, we split the existing "Part No." and "Description" columns, narrow these two columns to leave space for the new tax column, move the "List" (i.e. Unit Price) column so that we can place the new tax column to the right-side of the "List" column. However, before begin, we need to first unprotect the spreadsheet and display grid lines and row headings and column headings.

... To show gridlines and row/column headers in Excel 2000 - 2003:

... The last major step on creating this template is to add formulas to calculate taxes. To do this, we add the following formula to each tax cell on the detail section:

Simple Sample - Moving Balance and Payment Cellsc5075

Simple Sample Invoicing Template - Moving Cells

"Simple Sample - Moving Balance and Payment Cells" was found to be relative to Sample Invoice Templates with the score grade of 69.

... Different businesses require different invoice format and layout. While the default template shipped with Uniform Invoice Software installer program meets many business types, including home business, small business, freelancers etc., There are still many people find it does not meet their requirements exactly. So you need to customize it.

... Fortunately customizing and designing a template is not as hard as it sounds, especially with the help of Uniform Invoice Software. The main reason of this is that Microsoft Excel already provides thorough and robust form design support. Microsoft Word has this type of form design support too. But the advantages of Microsoft Excel is that doing calculation is much easier in Excel with the support for formulas, which is very helpful in invoice calculations.

... So let's see how to move the cells out of the invoicing form.

Job Invoice Sample (Taxable Column)c5057

Job Billing Sample (Taxable Column)

"Job Billing Sample (Taxable Column)" was found to be relative to Sample Invoice Templates with the score grade of 69.

... To design this invoice form layout based on its original version, we first unprotect the Invoice spreadsheet, display grid lines and row headings and column headings, switch to design mode. And then, we unmerge the "Part No." column (which comprises 4 Excel raw columns), move all the "Taxable" checkboxes to Excel column L. On each item line, merge the first 3 cells on column I, J and K to create the new "Part No." cell. Finally, replace the original label "Part No." with the new text "# / Taxable" to indicate the purpose of the taxable checkboxes. The following section describe the process in detail.

, then the checkboxes should be named with "oknWidget_" prefix, such as oknWidget_taxtable1, oknWidget_taxable2, oknWidget_taxable3...

Excel Shipping Invoice with Printable Truck Background Imagec5087

Excel Shipping Invoice with Printable Truck Background Image

"Shipping Invoice with Printable Truck Background" was found to be relative to Sample Invoice Templates with the score grade of 68.

  1. Open the "Page Setup" dialog box as described above.
  2. Go to the "header / Footer" tab.
  3. Check "Scale with document" and "Align with paper margins", and then click "Custom Header".
  4. On the "Header" dialog box, click to activate the "Center section" box.
  5. Click the "Insert Picture" button on the toolbar.
  6. Specify the picture / image you want to use, by browsing local computer, or search online.
  7. Once the picture has been specified, Excel inserts a "&[picture]" placeholder to the "Center section" box.
  8. Click to select the "&[Picture]" symbol, click the "Format Picture" button on the toolbar. This opens the "Format Picture" dialog box.
  9. On the "Size and rotate" section, set height and width of the picture to proper values. In this shipping invoice sample, the target paper is standard A4 paper (8.27 inch X 11.69 inch), so we set the image size to 6.89 inch (height) and 8 inch (width). This makes the truck image to be on the center of the printed invoice. If you are following this sample to insert your own image, you should adjust the width and height according to your own image.
  10. Go to the "Picture" tab. In the "Image Control" section, set "Brightness" to 85%, set contrast to 30%. Again, you should choose these values depending on your image colors.
  11. Click the "Compress" button to make the inserted image smaller in file size.
  12. Close the "Format Picture" dialog box.
  13. Click OK to close the "Header" dialog box.
  14. Click "Print Preview" on the "Page Setup" dialog box.
  15. Excel shows what it will like when the "Invoice" worksheet is printed.
  16. You may need to open again the "Header" dialog box to adjust the size, brightness and contrast to get a best / satisfying background image effect.
  17. Once everything is done, click "Design Mode" button on the "Invoice" ribbon tab to exit design mode.
  18. Save the template.

Cleaning Service Invoice Templatec4041

Cleaning Service Invoice Template

"Cleaning Service Invoice Template" was found to be relative to Sample Invoice Templates with the score grade of 68.

... Although this template is named Cleaning Service Invoice Template or Cleaning Service Bill Format, it could be easily adopted by many service businesses, like legal, medical or accounting, freelance work, consulting, handyman work, house cleaning and babysitting, landscaping and gardening, auto repairs, catering, child care, pet care, tutoring, and other services. Service invoice templates are used to provide service invoices by freelancers, contractors, cleaners, consultants, caterers, house cleaners, and service providing companies. If you have just started your business, for the purpose of invoicing, there is better choice than expensive and complicated service invoicing software, that is to use an invoicing template. An invoicing template offers an easy and intuitive way for invoicing, like fill in a blank paper form. So no hard learning curve will be involved.

Sample Sales Invoice Template 2c2001

Sample Sales Invoice Form 2

"Sample Sales Invoice Form 2" was found to be relative to Sample Invoice Templates with the score grade of 66.

  • In Excel 2003 click the Design Mode button on the Control Toolbox toolbar. Tip: If the Control Toolbox toolbar is invisible, click Excel menu View > Toolbars > Control Toolbox.
  • In Excel 2007, Excel 2010 and Excel 2013, click the Design Mode button in the Controls group of the Developer tab.

    TIP: If the Developer tab is not available in Excel 2007, do the following to display it: a) Click Microsoft Office Button, and then click Excel Options; b) In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

    Or in Excel 2010 and Excel 2013 to display the Developer tab: a) Click File > Options > Customize Ribbon; b) In the area on the right, ensure that the box next to Developer is checked; c) When you click OK, the Developer tab will appear in the ribbon.

... Once you have finished your design work for Sample Sales Invoice Template 2, click the Design Mode button again to exit design mode.

Sample Service Invoice Template: Fixed Itemsc5041

Sample Service Invoice Template: Fixed Items

"Sample Service Invoice Template: Fixed Items" was found to be relative to Sample Invoice Templates with the score grade of 64.

... The only difference between this customized template and the original invoice template is that there are no shipping fields in the service invoice template, whereas the sales invoice template has shipping fields defined near the "Bill To" section.

... The two standalone fields, "Ship Date" and "Ship Via", are also moved out of the printable invoice form (Although "Shipping Cost" is left on the bottom of the form). The two adjacent fields, "Terms" and "Due Date", are expanded to fill in the space left by moving out the shipping fields. To do this, we first move "Terms" (both the label and field cell) two columns left, and move "Due Date" one column left, and then select the "Terms" label and its subsequent empty cell, and then click "Merge and Center" command on Excel ribbon.

Sample Service Invoice Template: Using Handwriting Signaturec5039

Service Template with Signature

"Sample Service Invoice Template: Using Handwriting Signature" was found to be relative to Sample Invoice Templates with the score grade of 64.

... The free template is able to create professional-looking bills for you without a hard learning curve, but the Uniform Invoice Software version offers more advanced features. For example, with the freeware edition of the template you have to clear the invoice form manually to make it a blank invoice form in order to create a new invoice - that is, to delete all the existing field values, such as invoice date, invoice#, customer information etc. With the Uniform Invoice Software edition, by clicking the "Clear & New" button once, all the fields are cleared and some fields are filled with default values. For example, the "Clear & New" command fill in the invoice date field with the today's date.

Job Invoice Samplec5006

Job Billing Sample

"Job Billing Sample" was found to be relative to Sample Invoice Templates with the score grade of 63.

... The protection of the "Invoice" worksheet in Job Invoice Sample prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the worksheet. However for the purpose of this sample, we should firstly unprotect the worksheet in Job Invoice Sample.

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

Sample Sales Invoice Template: Fixed Itemsc5040

Sample Sales Invoice Template: Fixed Items

"Sales Template with Fixed Items" was found to be relative to Sample Invoice Templates with the score grade of 62.

... In some businesses the number of products or service items offered are limited, i.e. the client / customers always order the same group of products / services from the company. It would be nice to have the invoice form always leaves the item#, item description, or even item unit price there and does not change them from invoice to invoice. We call these static or fixed items because they don't change. Using static and fixed items prevent you from type or choose the same product items again and again, saving your time and avoiding typo mistakes. The fixed items even won't get cleared when you execute "Clear & New" with Uniform Invoice Software installed - it sounds interesting because the "Clear & New" command is designed to clear all the content to make it a blank invoice form for next new invoice. So how do we tell the "Clear & New" command not to touch the items that shouldn't change from invoice to invoice?

Simple Tax Invoice Sample with Tax Rate Listc4062

Simple Tax Invoicing Sample - Tax Rate List

"Simple Tax Invoice Sample with Tax Rate List" was found to be relative to Sample Invoice Templates with the score grade of 48.

... With this Simple Tax Invoice Sample with Tax Rate List, we'll create the drop down list of tax rates by using Excel's data validation features. There are already samples of using drop down list here on InvoicingTemplates.com, such as Auto Repair Invoice Template (2), which adds a "Model" drop down list to the basic template Auto Repair Invoice Template, allowing to select car or vehicle model. Note that the drop down list will not be implemented in the PDF invoice template.

  1. Back up the template.
  2. Open the template.
  3. Click the "Settings" button on the "Invoice" worksheet.
  4. Go to the "Taxes" tab.
  5. Click to select "One Tax".
  6. Change tax name to "TAX". Change Tax rate to the value that you used most often.
  7. Click "Apply". This will modify the layout of the invoicing form by hiding the second tax line, so that only one line of tax (including tax name, rate, and amount).
  8. Click the "Design Mode" button on the "Invoice" worksheet. This unprotects the spreadsheet, shows gridlines and row/column headings, and also pushes down the "Design" button on Excel "Developer" ribbon tab.
  9. Choose an empty location to place the tax rate list on the bill form. In this sample, we choose the range on the column $S and column $T.

    Move out the contents that are already on the columns, i.e. the comment text starting with "To create an invoice" etc. To do this, drag your mouse to select all the content you want to move, and then drag the border of the select area to move it to the new location.

  10. Set a slightly different background color (green - blue in this sample) for these two columns.
  11. Enter the state names on the first column. Enter the corresponding tax rates on the second column.

    For the purpose of this demonstration, we copied the tax rates from State Sales Tax Rates | Sales Tax Institute (As of 3/1/2016). . Sales and use tax rates change on a monthly basis. This chart is for informational purposes only. As the source origin statement shows, specific questions should be addressed to your tax advisor or a State Department of Revenue, such as Texas Sales Tax. The rate chart gives tax rate for the following states: Alabama, Alaska, Arizona, Arkansas, California, Colorado, Connecticut, Delaware, District of Columbia, Florida, Georgia, Hawaii, Idaho, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Carolina, North Dakota, Ohio, Oklahoma, Oregon, Pennsylvania, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin, Wyoming. No matter what business you are running - attorney / legal, medical, catering, restaurant, law firms (whether small or big), health insurance billing or statement / timesheet, car / vehicle sales, graphic designs, freelance, plumbing, marketing, business plans, accounting, house rent (yearly or monthly), or even home businesses for monthly bill, it is import for you to making taxation correct on your invoices.

  12. Move the tax name "TAX" one column left to leave a blank cell for state name. In this sample, we move the text from $I$35 to $H$35.
  13. Click to select the cell left by moving out "TAX", i.e. $I$35. Name this cell "oknTaxStateName".
  14. Switch to Excel ribbon "Data". Choose "Data Validation / Data Validation ...".
  15. On the "Data Validation" dialog box, choose "List" from the "Allow" list. Fill the address of the state name list into the "Source" box. In this case, we set it to "=$S$6:$S$56".
  16. Right-click the cell, choose "Format Cells" from the shortcut menu. Go to the "Protection" tab, clear the "Locked" option. Click "OK" to close the "Format Cells" dialog box. This makes the cell fillable when the sheet is protected (i.e. when you start to create an invoice).
  17. Right-click the tax rate cell ($J$35), choose "Format Cells" from the shortcut menu. Go to the "Protection" tab, check the "Locked" option. Click "OK" to close the "Format Cells" dialog box. This makes the cell not manually fillable as we need to fill it with a formua.
  18. Make sure the tax rate cell ($J$35) is selected. Assign it a formula - " =VLOOKUP(oknTaxStateName,S6:T56,2,FALSE)". This "VLOOKUP" formula searches for the state name on the cell named "oknTaxStateName" in the first column of our tax rate table/chart, and return the rate value on the second column. For more information about the VLOOKUP formula, refer to Microsoft document at VLOOKUP function.

    As you can see from this sample, while Microsoft Word (and other programs, like Publisher, Microsoft Works, Adobe Acrobat (PDF), or even Photoshop could be used to create beautiful invoicing forms, Excel is far more easier than others when it comes to do calculations. By using Excel formulas, you can easily define the relationship between fields for Uniform Invoice Software.

  19. Exit design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab.
  20. Click the "Invoices" button on the "Invoice" ribbon tab.
  21. Click "Custom Fields" to open the "Custom Field Manager" dialog box.
  22. Click "Add Field".
  23. Fill in the new field information: Field Name - TaxStateName; Type - "Text"; Default Value - "Alabama" (This is the name of the state that you sell to most frequently. When you click the "Clear & New" command to have the bill form ready for next invoice, the cell "oknTaxStateName" will be filled with this default value); Size - 50.
  24. Close the "Add New Field" dialog box.
  25. Close the "Custom Field Manager" dialog box.
  26. Save the template by clicking the "Save" button on Excel quick access toolbar.

Simple Sample - Adding Discount Columnc4061

Simple Invoicing Sample - Discount Column

"Simple Invoicing Sample - Discount Column" was found to be relative to Sample Invoice Templates with the score grade of 29.

... By adding the "Discount" column, we meant not only re-design the Excel spreadsheet form so that it has an additional column, by also make the newly added column work with Uniform Invoice Software -- i.e. when you click the "Save Invoice" button, the content on the "Discount" column should also be saved along with each invoicing item; if "Clear & New" command is clicked, the "Discount" column should get cleared too. This is implemented by using custom fields (user-defined fields) in Uniform Invoice Software.

  1. First, back up the Excel invoice template and database file. In this sample, we'll need to modify the database, so creating a backup of the database is necessary.
  2. Open the template.
  3. Push down the "Design Mode" button on the "Invoice" ribbon tab.
  4. This is not a required step - but you may like to try it. Go to Excel "Page Layout" tab. In the "Themes" group, click to open the "Colors" list, choose "Blue".

    As you can see, the whole invoice form now has a new color theme now. Like the themes feature in Microsoft Word, this is the quick and best (easy) way to change the look & feel of the form.

  5. Drag your mouse to select all cells on the "Description" column, including the heading, ranging from $D$21 to $D$33. Click the "Merge and Center" button on Excel "Home" ribbon tab. This unmerges all the cells on the "Description" column.
  6. Drag your mouse to select all the cells on the "Quantity" column, including the heading, ranging from $I$21 to $I$33. Push the mouse key on the border of the selected area. Without releasing the mouse key, move the entire selected area on column left (Destination: $H$21:$H$33).
  7. Now select the entire "Unit Price" column, including the heading. Drag the select area one column left. The new location of the "Unit Price" column is now $I$21:$I$33.
  8. With the new "Unit Price" column still selected, click the "Format Painter" button on Excel "Home" ribbon tab.
  9. Click the first empty cell left by moving out the "Unit Price" column, i.e. $J$21. This applies the format of the "Unit Price" column to the empty column.
  10. Drag your mouse to select all the cells on the empty column, except the heading cell, ranging from $J$22 to $J$33. Right-click one of the selected cell, choose "Format Cells" from the shortcut menu. On the "Format Cells" dialog box, go to the "Protection" tab, make sure the "Locked" property is cleared. Click OK to close the dialog box. This makes sure that the "Discount" column is manually fillable when the sheet is protected.
  11. Click to select heading cell of the empty column, i.e. $J$21. Enter the column heading text "Discount".
  12. Name the following empty cells. The names should be "oknItemDiscount_1" ($J$22), "oknItemDiscount_2" ($J$23), "oknItemDiscount_3" ($J$24) ... "oknItemDiscount_12" ($J$33).
  13. Drag your mouse to select all the cells on the "Description" heading, ranging from $D$21 to $G$21. Click "Merge and Center" on Excel "Home" ribbon tab.
  14. Repeat the above step for each line of the "Description" field. For example, select $D$22:$G$22, click "Merge and Center"; select "$D$23:$G$23", click "Merge and Center", and so on. If you are very familiar with Microsoft Excel, you can also use "Format Painter" to speed up the processing of merging.
  15. Select all the "Description" cells, ranging from $D$22 to $G$33. Click "Align Left" icon button in the "Alignment" group on Excel "Home" ribbon.

    Click to select the "Discount (Amount)" cell, $K$35. Enter a formula for this cell, "=sum (J22:J33)". Right-click the same cell $K$35 again, and choose "Format Cells" from the dialog box. Go to the "Protection" tab, checked the "Locked" property. This makes sure that the cell is not manually fillable once the sheet is protected.

  16. Now we need to create the definition of the custom field "ItemDiscount" in the database. To do this, we need to use the "Custom Field Manager" provided by Uniform Invoice Software. In order to use this tool, we have to first exit design mode by clicking the "Design Mode" button again on the "Invoice" ribbon.
  17. Click "Invoices" on the ribbon.
  18. Click "Custom Fields".
  19. From the "Database table" list, choose "Invoice Body".
  20. Click "Add Field".
  21. Enter the field definition as follows - Name: ItemDiscount; Type: Decimal; Precision: 10; Scale: 2.

    The map between an Excel cell and a database field is established by using names. For the invoice body section, all "oknItemDiscount_*" fields are mapped to the "ItemDiscount" field defined in the "Invoice Body" database table. That is, a cell should be named with "okn + Database Field Name", where we call "okn" is a prefix of the cell name.

  22. Save the template by clicking the "Save" button on Excel quick access toolbar.
  23. Now you can test the template to see if it works in the way met our plan.

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 Sample Invoice Templates with the score grade of 26.

... The detailed steps of this customization sample are shown below, with the sample template created in c4051 Simple Invoice Template - Discount Amount Field as the starting point. Note that you need have Uniform Invoice Software installed in order to follow this tutorial, which is our invoicing software app (invoicing program) that combines the power of Excel with backend database, providing features that could hardly be implemented with pure Excel only, such as management of customers, products, invoices and payments.

  1. Open the invoice template.
  2. Click the "Products" button on the "Invoice" ribbon tab.
  3. Click "Custom Fields".
  4. Click "Advanced..." button.
  5. Read the warning message on the top of the dialog box. Backup the database file.
  6. The "Database Table" list shows the table that you are currently viewing. In this sample, we choose "Product" from the list.
  7. As you can see, the "Price" field is defined as "decimal (15,6)".
  8. To change the definition of a field, first click to select the field, and then click "Customize".
  9. Once done, click "Close" to close the dialog boxes.

Simple Sample - Customer Name on Product Reportc4059

Simple Invoicing Sample - Customer Name on Product Report

"Simple Invoicing Sample - Customer Name on Product Report" was found to be relative to Sample Invoice Templates with the score grade of 23.

... In this sample, we'll take the result template built in c4051 Simple Invoice Template - Discount Amount Field as a starting point, create two custom fields, "CustomerName" and "CustomerContact" in the invoice body database table, and then add them to the product report. Note that in order to follow this tutorial, you should have Uniform Invoice Software installed, which is our invoicing software app for automated invoice processing. Download the fully functional trial version for free.

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

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c9001
Automotive Sample Invoice Template
Sunday, January 12, 2014,
28
9
A4
Portrait
Sales
c4095
Invoicing Sample for Cosmetics Shops
Saturday, October 29, 2016,
12
4
A4
Portrait
Sales
c7014
Proforma Invoice Template (4th Sample, Landscape Page Orientation)
Monday, December 9, 2013,
20
7
A4
Landscape
Pro-forma
c4094
Bill Sample with Sports Theme
Friday, October 28, 2016,
12
4
A4
Portrait
Sales
c5104
Law Firm Invoice Template
Thursday, November 24, 2016,
12
5
A4
Portrait
Service
c5105
Law Firm Invoice Template (Indian INR Currency)
Thursday, November 24, 2016,
12
5
A4
Portrait
Service
c6015
Sample Format for Job Invoicing (Tax Column)
Wednesday, June 4, 2014,
12
6
A4
Portrait
Service
c5075
Simple Sample - Moving Balance and Payment Cells
Saturday, January 23, 2016,
12
5
A4
Portrait
Sales
c5057
Job Invoice Sample (Taxable Column)
Wednesday, June 4, 2014,
12
5
A4
Portrait
Service
c5087
Excel Shipping Invoice with Printable Truck Background Image
Friday, July 8, 2016,
16
5
A4
Portrait
Sales
c4041
Cleaning Service Invoice Template
Friday, August 28, 2015,
20
4
A4
Portrait
Service
c2001
Sample Sales Invoice Template 2
Tuesday, December 17, 2013,
12
2
A4
Portrait
Sales
c5041
Sample Service Invoice Template: Fixed Items
Sunday, December 22, 2013,
12
5
A4
Portrait
Service
c5039
Sample Service Invoice Template: Using Handwriting Signature
Friday, December 20, 2013,
12
5
A4
Portrait
Service
c5006
Job Invoice Sample
Tuesday, September 16, 2014,
12
5
A4
Portrait
Service
c5040
Sample Sales Invoice Template: Fixed Items
Saturday, December 21, 2013,
12
5
A4
Portrait
Sales
c4062
Simple Tax Invoice Sample with Tax Rate List
Monday, February 8, 2016,
12
4
A4
Portrait
Sales
c4061
Simple Sample - Adding Discount Column
Sunday, February 7, 2016,
12
4
A4
Portrait
Sales
c4060
Simple Sample - Decimal Precision of Product Prices
Saturday, February 6, 2016,
12
4
A4
Portrait
Sales
c4059
Simple Sample - Customer Name on Product Report
Friday, February 5, 2016,
12
4
A4
Portrait
Sales

What Is Hot

Feature Galleries