Skip to main content
InvoicingTemplate.com main content

Excel Quotation Templatec9008

Excel Quotation Format with Special Discounting Model

"Excel Quotation Format with Special Discounting Model" was found to be relative to Excel Hourly Timesheet Template For Canada with the score grade of 95.

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

...(31) This template is created for businesses who sell goods. For a job estimating and quoting template, visit Job Estimate Template for Excel. For a general estimate template, see General Estimate Template.

...(15) The "LESS" is also a manually editable field, which is designed as a percentage value.

Excel Payment Voucher Templatec5052

Payment Voucher Template

"Excel Payment Voucher Template" was found to be relative to Excel Hourly Timesheet Template For Canada with the score grade of 83.

...(213) InvoicingTemplate.com also offers the Uniform Invoice Software version of this Excel Payment Voucher Template / receipt template. The Uniform Invoice Software version is also free if you have Uniform Invoice Software installed, and it has exactly the same layout as the freeware edition of the Payment Voucher Template, but with many buttons on it, such as "Clear & New", "Save To DB", "Exact / Email", "Print". Uniform Invoice Software, as the name suggests, is our invoicing software that has the ability to make any invoicing templates available here on InvoicingTemplate.com a complete invoicing program that is able to manage customers, products, invoices and payments. For example, if you click the "Clear & New" button, the payment voucher form is cleared and is ready for you to enter a new payment voucher, with several fields filled with default data - for example, the current date is filled into the "Date" field. If you click "Save To DB", the current voucher is saved to backend database and a voucher# is generated automatically. If you click "Exact / Email", a standard Excel spreadsheet is created and the current voucher is copied to the newly created Excel spreadsheet file, which you can email to your client. You can also create a PDF voucher document using Microsoft Excel.

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

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 Excel Hourly Timesheet Template For Canada with the score grade of 83.

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

PayPal Payment Button Using Custom Imagec3015

PayPal Payment Button Using Custom Image

"Excel Invoice with PayPal Payment Button Using Custom Image" was found to be relative to Excel Hourly Timesheet Template For Canada with the score grade of 76.

...(51) You can easily add the PayPal payment button to the templates available here on InvoicingTemplate.com, by simply clicking "Add / Update PayPal Button" on the "Invoice" ribbon tab. The default button is one of the standard PayPal payment images, which might look familiar to many people who do online transactions frequently.

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

General Quote Template for Excelc2035

General Quote Template for Excel

"General Quote Template for Excel" was found to be relative to Excel Hourly Timesheet Template For Canada with the score grade of 74.

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

Labor Invoicing Samplec4070

Labor Billing Format for Excel

"Labor Billing Format for Excel" was found to be relative to Excel Hourly Timesheet Template For Canada with the score grade of 55.

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

Job Estimate Template for Excelc4084

Job Estimate Template for Excel

"Job Estimate in Excel Format" was found to be relative to Excel Hourly Timesheet Template For Canada with the score grade of 52.

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

PDF Invoice with PayPal Buttonc5093

PayPay Payment Button on PDF Invoices

"PDF Invoice with PayPal Button" was found to be relative to Excel Hourly Timesheet Template For Canada with the score grade of 50.

  • Open your invoicing template as usual.
  • Click the "Add / Update PayPal Button" command on the "Invoice" ribbon tab.
  • Enter your PayPal account email address in the first text box. Note this is the account where your customer will send money to. So double check it to make sure it is correctly.
  • In the "Information sent to PayPal" section, you'll find 3 fields.
    • Item name: This field describes why the customer is paying you. The default value for this field is "Invoice Number: oknInvoiceID", where "oknInvoiceID" will be replaced with real invoice numbers when a PDF invoice is generated. You can include your company / business name here. For example, it could be "ABC Company Invoice Number: oknInvoiceID".
    • Currency: This field should specify the 3-letter currency code to use. The default currency is "USD". It is implemented as a drop-down selection list. Note that UIS does not convert currency automatically. So make sure this choice in this field matches the currency used on your invoices.
    • Amout: By default this field is "oknBalanceDue". This will be the balance of the invoice that is being created. On generating a PDF invoice, UIS replace this with the value of the "oknBalanceDue" cell.
  • Click "Test" to open a browser window to verify what you customers will see when they click he PayPal payment button on your invoices. In this test link, "oknInvoiceID" will be replaced with "INV100", the amount will show "123.00".
  • Click "Add / Update PayPal button" to add the PayPal button to your Excel invoice template.
  • The template is now switched to design mode with the new payment button selected. You can move it to a proper location by dragging and dropping, or resize it by dragging the border of the button image.
  • Once done, switch off design mode by clicking the "Design Mode" button again.
  • Save the template by clicking the Save button on Excel quick access toolbar.

...(28)Click here to view the sample PDF invoice that includes a PayPal payment button. Feel free to browse our gallery of our PDF invoice formats generated with UIS.

Invoice Template with 4 Columnsc4001

4-Column Invoice Template

"Invoice Template with 4 Columns" was found to be relative to Excel Hourly Timesheet Template For Canada with the score grade of 48.

...(76) This invoice template is originally published on our oldest web site, office-kit.com, as a sample in the member area. We published it here on InvoicingTemplate.com for you to choose. The layout of this invoice template is similar to the default sales invoice template shipped with Uniform Invoice Software (originally named Excel Invoice Manager). The most noticeable difference is that with this template we moved out the "Product#" column, leaving more space for the product description column.

...(45) The template has one tax set on the bottom of the invoice form. If you have Uniform Invoice Software installed, you can easily change it to two-tax or non-tax by clicking the Settings button on the Invoice worksheet, and then go to the Taxes tab.

Invoice and Packing List on Separate Worksheetc4080

Invoice and Packing List on Separate Worksheet

"Invoice and Packing Slip on Separate Worksheet" was found to be relative to Excel Hourly Timesheet Template For Canada with the score grade of 42.

...(32) In this sample, we use Invoice and Packing List on Same Form (c4078) as the basic invoice template, move the packing list to a separate form. The main steps are illustrated below.

...(115) Packing list and invoice are closely related business documents, yet there are significant differences between the two, in both the recipients of the document, the contents each document show include. A packing list is designed to aid recipients of the shipment in confirming that all items that were supposed to be included in the shipment have actually arrived. While slip designs vary somewhat, most will include a description of each item included, as well as the quantity of each item shipped. On the other hand, an invoice goes to the person responsible for paying the bill. The invoice is the bill for purchasing from your company and the notice to the customer to pay you.

Advanced Invoicing Sample - Macro-Enabled Invoicing Templatec5101

Advanced Bill Sample - Macro-Enabled Billing Template

"Advanced Invoicing Sample - Macro-Enabled Invoicing Template" was found to be relative to Excel Hourly Timesheet Template For Canada with the score grade of 42.

...(59) Uniform Invoice Software supports all the Excel file formats, including the traditional ".xls" and ".xla" formats, and the new ".xlsx" (Excel XML-based file format), ".xlsm" (Excel XML-based and macro-enabled file format), and ".xlsb" (Excel Binary (or BIFF12) file format). ".xlsx" are now the most widely used workbook file format. Feel free to see our Invoice Template ".xlsx" topic page.

...(27) The sample invoice template used here is c5099 Standard Business Invoicing Template. See our business invoice templates for more samples that are most closely related to "BUSINESS".

Sales Invoice Form with Discount Percentagec5033

Sales Invoice Form with Discount Percentage

"Sales Invoice Template - Discount Percentage" was found to be relative to Excel Hourly Timesheet Template For Canada with the score grade of 35.

...(100) The invoice template has one tax set by default. You can change the tax name and rate by just typing in your own tax name and rate. If you need other taxing types and have Uniform Invoice Software installed, simply click the Settings button and then go to the Taxes tab, choose from Non-Tax, One-Tax and 2-Taxes. You can also set tax names and rates on this dialog box. Several other options, such as "tax invoice total including shipping cost", "tax 2 is applied to tax 1" and "Tax rate can be zero", are also available on this dialog box.

Real Estate Agent Invoice Templatec4035

Real Estate Manager Billing Form

"Real Estate Manager Billing Form" was found to be relative to Excel Hourly Timesheet Template For Canada with the score grade of 34.

...(31) This invoice template is designed for real estate agent or manager. On the "Bill To" section there is a "site" custom field that allows you detail critical information about the transaction.

...(58) The other two custom fields on the form include "Site Code" and "Project". The 4 columns on the invoice detail section include "Description", "Quantity", "Unit Price" and "Amount". Each row on the invoice body section allows about 3 lines of text. The text on the item cells are formatted as left alignment on horizontal, and middle on vertical.

Telecom Consultant Estimation Templatec3005

Telecom Consultant Estimate Form

"Telecom Consultant Estimate Form" was found to be relative to Excel Hourly Timesheet Template For Canada with the score grade of 32.

...(59) The protection of the "Invoice" worksheet in Telecom Consultant Estimation Template 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 Telecom Consultant Estimation Template.

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

Bike Shop Invoice Templatec4069

Bike Shop Invoice Template

"Bike Shop Invoice Template" was found to be relative to Excel Hourly Timesheet Template For Canada with the score grade of 24.

...(129) For a simple example, without Uniform Invoice Software installed, to create a new invoice you have to clear the fields manually, one by one. If Uniform Invoice Software is installed, clearing the template (make the template ready for next new invoice) is as simple as clicking the "Clear & New" command. Without Uniform Invoice Software, you have to number your invoices manually (i.e. assign each invoice a unique, continuous number. This is not as easy as it sounds; with Uniform Invoice Software installed, you don't have worry about these things because invoice numbering is handled by the Excel invoicing app automatically - when you click "Save Invoice" and left the "Invoice#" cell blank, a new invoice number is generated automatically based on the previous number stored in the database.

Invoicing Template in Eurosc4100

Invoicing Format in Euros

"Invoicing Format in Euros" was found to be relative to Excel Hourly Timesheet Template For Canada with the score grade of 24.

  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.

Simple 2-Column Sales Invoice Samplec2002

Simple 2-Column Sales Invoice Form

"Simple 2-Column Sales Invoice Sample" was found to be relative to Excel Hourly Timesheet Template For Canada with the score grade of 3.

...(61) The protection of the "Invoice" worksheet in Simple 2-Column Sales 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 Simple 2-Column Sales Invoice Sample.

...(23) Once you have finished your design work for Simple 2-Column Sales Invoice Sample, click the Design Mode button again to exit design mode.

Independent Contractor Invoicec2032

Independent Contractor Billing Format

"Independent Contractor Billing Format" was found to be relative to Excel Hourly Timesheet Template For Canada with the score grade of 1.

...(90) However if you install Uniform Invoice Software, the pure-Excel invoice template becomes a powerful invoicing software, offering a number of powerful time-saving features, such as automated invoice numbering (generate unique and sequential invoice numbers based on previous invoice#); quick and easy picker for customers, products and invoices using any criteria available that enables you to locate the data you want to use in no time; and the flexible reporting features, with which you can have sales report, product report, customer statement, payment report etc. with just a few mouse clicks.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c9008
Excel Quotation Template
Friday, February 10, 2017,
37
9
A4
Portrait
Other
c4086
Invoicing Template with Logo
Saturday, August 20, 2016,
6
4
A4
Portrait
Sales
c5052
Excel Payment Voucher Template
Thursday, May 29, 2014,
12
5
A4
Portrait
Receipt
c5087
Excel Shipping Invoice with Printable Truck Background Image
Friday, July 8, 2016,
16
5
A4
Portrait
Sales
c3015
PayPal Payment Button Using Custom Image
Thursday, August 11, 2016,
10
3
A4
Portrait
Service
c2035
General Quote Template for Excel
Friday, August 19, 2016,
18
2
Letter (8-1/2 in. x 11 in.)
Portrait
Other
c4070
Labor Invoicing Sample
Wednesday, May 11, 2016,
8
4
A4
Portrait
Service
c4084
Job Estimate Template for Excel
Wednesday, August 17, 2016,
10
4
Letter (8-1/2 in. x 11 in.)
Portrait
Other
c5093
PDF Invoice with PayPal Button
Wednesday, August 10, 2016,
12
5
A4
Portrait
Sales
c4001
Invoice Template with 4 Columns
Friday, November 1, 2013,
12
4
A4
Portrait
Sales
c4080
Invoice and Packing List on Separate Worksheet
Sunday, July 10, 2016,
20
4
A4
Portrait
Sales
c5101
Advanced Invoicing Sample - Macro-Enabled Invoicing Template
Sunday, November 20, 2016,
12
5
A4
Portrait
Sales
c5033
Sales Invoice Form with Discount Percentage
Friday, November 22, 2013,
12
5
A4
Portrait
Sales
c4035
Real Estate Agent Invoice Template
Monday, July 20, 2015,
10
4
A4
Portrait
Service
c3005
Telecom Consultant Estimation Template
Wednesday, February 26, 2014,
10
3
A4
Portrait
Consulting
c4069
Bike Shop Invoice Template
Tuesday, May 10, 2016,
12
4
A4
Portrait
Sales
c4100
Invoicing Template in Euros
Tuesday, November 29, 2016,
12
4
A4
Portrait
Sales
c2002
Simple 2-Column Sales Invoice Sample
Monday, February 24, 2014,
12
2
A4
Portrait
Sales
c2032
Independent Contractor Invoice
Monday, July 11, 2016,
6
2
A4
Portrait
Service

What Is Hot

Feature Galleries