Skip to main content
InvoicingTemplate.com main content

Invoice Template with 4 Pagesc5083

Invoicing Layout with 4 Pages

"Invoicing Layout with 4 Pages" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 97.

  1. In Windows Explorer, copy the template file "invoicetemplate4pages-uis.xlsx" to create a backup copy of the template. This ensure that you can easily return to a working state whenever something goes wrong during the following customization of the template.
  2. Open the template as usual by double-clicking it.
  3. Click the "Design" button on the "Invoice" worksheet. Note that you have to install our Excel invoicing software app in order to have Excel show the "Invoice" ribbon tab.
  4. Click to select one "Taxable" checkbox object; or push down CTRL key on your keyboard and then click several "Taxable" controls one by one to select multiple controls.
  5. Release keyboard CTRL key. Hit DEL key on keyboard. This deletes the selected objects.
  6. Repeat the above steps to delete all the other Taxable controls.
  7. The default formula for calculating tax looks like "=ROUND(IF(oknTaxType=0,0, oknTax1Rate * (oknLineTotalTaxable + IF ( oknTaxTotalIncludingShippingCost=0, 0, oknShippingCost ))), 2)", where "oknLineTotalTaxable" is the name of a hidden cell that calculates the taxable amount using Excel's array formula. Here since all the items are taxable, you modify it to be "=ROUND(IF(oknTaxType=0,0, oknTax1Rate * (oknSubtotal + IF ( oknTaxTotalIncludingShippingCost=0, 0, oknShippingCost ))), 2)". If you want to include the labor expenses (implemented as custom fields on the bottom of the invoices, which calculates labor cost from labor hours and labor hourly rate), then change the formula to "=ROUND(IF(oknTaxType=0,0, oknTax1Rate * (oknSubtotal + oknLaborTotal + IF ( oknTaxTotalIncludingShippingCost=0, 0, oknShippingCost ))), 2)".
  8. Once done, exit design mode buy clicking the "Design" button again on the "Invoice" ribbon tab.
  9. Save the template by clicking the "Save" button on Excel quick access toolbar.

3-Page Invoice Templatec5082

3-Page Invoice Template

"3-Page Invoicing Format" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 97.

...(84) As you can see from 3-Page Invoice Template, one benefit of using Excel as your invoice creator, as compared to other template formats like Microsoft Word invoice template and PDF invoice template, HTML format or even Photoshop format, is that you can easily apply formulas to do calculations. This means that, once the basic figures are entered on the form, like Quantity and Unit Price, or Hours and Hourly Rate, or Days and Daily Rate, the calculation of totals and taxes is done automatically.

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 Excel Invoice Templates Multiple Pages with the score grade of 96.

...(54) To address this issue one way is to wrap the text so that they can span several raw Excel rows. Another way described in this sample is to expand the form horizontally so that it can would be printable with landscape paper orientation. Both methods require decreasing the number of lines on the form.

  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. Go to the View tab of the Ribbon.
  3. Click Show/Hide, and then check or uncheck the Gridlines and Headings options.

...(16) The gridlines and row/column headings could help a lot when design the layout of the form.

1/2 Page Invoice Templatec4066

1/2 Page Bill Format

"1/2 Page Bill Format" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 89.

...(38) Many times you have only 1 or 2 items to bill your clients. In these situations a whole page of paper seems a waste. Here is how we implement a 1/2 page invoicing template (half page invoicing format).

...(76) This simple template sample will be created from c4051 Simple Invoicing Sample - Discount Amount Field. Like the other tutorials and samples in this serial here on InvoicingTemplate.com, we'll mainly focus on how to do the customization. You can also refer to Customizing Invoice Template for more information on the important techniques involved in the customization of our Excel billing forms. For a quick tutorial movie on creating invoice, visit the tutorial on creating an invoice.

...(12) Now let's see the steps involved to create this 1/2 page template.

2-Page Invoice Templatec5081

2-Page Invoicing Format

"2-Page Invoice Template" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 86.

...(25) The default template has 12 lines on one page. This sample template shows you a customized invoice layout that has 36 lines on two pages.

...(72) All templates here on InvoicingTemplate.com are created from the default template shipped with Uniform Invoice Software setup program. While the format and layout look very different between the templates, most of them are printable on a single page (or even 1/2 page, also see 5.5 X 8.5 - 2 Invoices On One Template). However some businesses requires more lines on each invoice, for example a store or limited company selling auto parts.

...(32) Uniform Invoice Software is able to handle this type of multiple-page invoices. This feature is even implemented since very early versions of Excel Invoice Manager (the former name of Uniform Invoice Software).

Excel Quotation Templatec9008

Excel Quotation Format with Special Discounting Model

"Excel Quotation Template" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 72.

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

...(41) The formula for "Line Total" incorporates both the auto-calculated portion, and the manually fillable field ("oknLineTotalManual_?" fields, placed outside the printable area, which means it is manually editable on creating invoices / estimations, but will not be included on printable invoices).

Excel Payment Voucher Templatec5052

Payment Voucher Template

"Excel Payment Voucher Template" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 66.

...(48) The original voucher template, Payment Voucher Template (Golden Shop), has a custom field Weight defined in both the Product and Invoice Body database tables. With this general purpose Excel Payment Voucher Template, InvoicingTemplate.com removed the Weight custom field from it and made it a general purpose voucher template.

...(100) If you don't need the LOGO image and want to delete it, simply hit the DEL key on your keyboard after you selected it with your mouse key. Deleting the LOGO image leaves an empty area to the left of the Company Information section. You may like to move the entire Company Information section to fill in the empty area. To do this: Drag your mouse to select the entire Company Information area, including Company Name, Street Address, City, ST Zip Code, etc.; Push your mouse key on the border of the selected area; drag it to the new location.

General Quote Template for Excelc2035

General Quote Format in Excel Spreadsheet Format

"General Quote Template for Excel" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 66.

...(45) This general purpose price quote template in Microsoft Excel spreadsheet format is a slightly modified version of the General Estimate Template. With this form design all fields and columns are manually editable, except the subtotal, tax and total fields that are calculated using Excel formulas.

...(78) The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as General Quote Template for Excel without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with our invoicing software installed.

Job Estimate Template for Excelc4084

Job Estimate Template for Excel

"Job Estimate in Excel Format" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 65.

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

Donation Receipt Template for Excelc1004

Donation Receipt Template for Excel

"Donation Receipt Template for Excel" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 60.

...(34) This general donation receipt template in Microsoft Excel spreadsheet format (".xlsx") includes fields for charity / organization name, address, contact information, donor name, several lines of description, an amount field, a handwriting signature field.

...(43) According to IRS Publication 1771, Charitable Contributions Substantiation and Disclosure, charitable donations are tax-deductible for the donor and reportable by the nonprofit organization. A donation receipt must include specific information about the value of the donation and what the donor received in return.

...(25) Third, it is also required to clearly describe the donation, including the date the donation was made, as well as the amount of the donation.

...(15) The receipt must also declare whether the donor received goods in return for the donation.

Labor Invoicing Samplec4070

Labor Invoicing Sample

"Labor Billing Format for Excel" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 49.

...(39) This printable labor invoice template covers job descriptions, hours, rates and total amounts, as well as the general fields for invoices such as invoice#, invoice date and payment term. It calculates taxes, subtotal, discount and total using Excel formulas.

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

Parts and Labor Invoicing Formatc4071

Parts and Labor Billing Format for Excel

"Parts and Labor Billing Format for Excel" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 47.

...(96) The tax calculation methods differs completely from the default invoice template shipped with Uniform Invoice Software, where two taxes (if two taxes are all applied / enabled for the template) are all applied to all the items listed on the template. Since this design breaks the assumption of the locations of tax cells, you cannot adjust the number of taxes using the features on the "Taxes" tab on "Settings" window inside Uniform Invoice Software. On the other hand, Uniform Invoice Software will have no problem to help you adjust the tax names and rates for you.

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 Excel Invoice Templates Multiple Pages with the score grade of 46.

...(79) On creating invoices, Excel invoice templates has many advantages over the other formats, like Microsoft Word (docx), PDF, HTML / CSS, or even Adobe Photoshop (PSD), etc. Maybe programs like Photoshop is possibly able to generate beautiful invoices (however, without a proper Photoshop-based invoice template, it is a time consuming work to do), none of the other formats could do automated calculations using formulas like Microsoft Excel, which is critical if you need to create several invoices each day.

...(15) The last step is to add the image. To do this, follow the steps below.

Appliance Repair Service Bill Templatec5020

Appliance Repair Service Invoice Template

"Appliance Repair Service Bill Template" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 41.

...(132) The template also features a default logo image on the top of the form. To replace it with your own logo image, simply click the "Replace Logo Image" button on the "Invoice" ribbon tab. The templates and forms here on InvoicingTemplates.com implement the default logo image in 3 ways - as an ActiveX Image control, an Excel / Office "Picture" object, or a Word Art object. The "Replace Logo Image" function is able to replace placeholder image implemented with the first two methods. For the third method, the Word Art way, you can either delete it or then insert your own image, or in case you don't have a satisfied logo image yet, you can simply click the Word Art object, type in your business name to use it as your logo.

Hotel Receipt Templatec7005

Hotel Receipt Template

"Hotel Receipt Template" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 38.

...(43) This templates use several custom fields that are not found in the default sales invoice template shipped with Uniform Invoice Software. The definition of the custom fields could be found by a travel to the corresponding data edit form in Uniform Invoice Software.

...(61) While there are complex and expensive hotel management software programs available, which, generally, could also produce invoices and receipts for you, this free hotel invoice template and receipt template offers a budget-free way for creating professional invoices and receipts. The intuitive blank form of this template allows you to prepare and draft your invoices and receipts without a hard learning curve.

Simple Template with Printable Watermarkc4075

Simple Format with Printable Background Image

"Simple Template with Printable Watermark" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 28.

...(40) There are still ways to create invoice template with printable background image or watermark. In this sample, we'll use c4074 Simple Invoice Format for Letterhead Paper here on InvoicingTemplate.com as the starting point and basic invoice template for demonstration purpose.

  1. As always before customizing a template you first need to back up it. To do this, simply copy the Excel template file in Windows Explorer.

    With Uniform Invoice Software installed, it is recommended to run the template in protected mode (by clicking Excel ribbon Review tab, and then click the "Protect Sheet" command, or go to the "Invoice" ribbon tab and make sure "Design Mode" is not enabled).

  2. In this sample, we need to change the design of the template. So click the "Design Mode" button on the "Invoice" worksheet to unprotect the sheet, display gridlines and row/column headings.
  3. Go to Excel "Page Layout" ribbon tab, click the expand button in the "Page Setup" group. This opens the "Page Setup" dialog box.
  4. Go to the "Header / Footer" tab.
  5. Click "Custom Header", or "Custom Footer", depending on whether you want to lay out the image from top or bottom. In this sample, we choose "Custom Header".
  6. Choose a section to place the image - "left section", "center section" or "right section". In this case, we click and choose "Center section".
  7. Click the "Insert Picture" button on the toolbar.
  8. Browse to and pick up your picture or watermark image from locally store, or download it online.
  9. The section now has a "&[Picture]" placeholder symbol. Click to select it, and then click "Format Picture" command on the toolbar (the last one).
  10. The "Format Picture" dialog box appears. Here you can set the size, scale ratio, cropping, color (automatic, grayscale, black & white and washout), brightness and contrast of the image.
  11. Once you have set the options done, click the dialog boxes.
  12. Go to Excel menu File / Print, you can see that the background image on the printed invoices (see screenshot images below). The background image / watermark will also be included in PDF invoices.
  13. To finish your design job, click the "Design Mode" button on the "Invoice" ribbon tab. Click the Save button on Excel quick access toolbar to persevere the changes.

Timesheetcm001

Timesheet

"Timesheet" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 25.

...(102) Following the Name column, there are 7 columns for you to enter hours worked each day. This is the place to record how long each employee worked for a job. After that, you see the Total Hours column. This column is calculated automatically using Excel formula, so you don't have to calculate and type it manually. The next column, Hourly Rate column, should be manually filled in. However, if you have Uniform Invoice Software installed, the Hourly Rate can be retrieved from backend database automatically. The last column on the printable form is called Total, which is also calculated using Excel formula.

Simple Consulting Invoice Templatec4034

Simple Consulting Billing Format

"Simple Consulting Billing Format" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 16.

...(34) As a consultant you need a beautiful invoicing template to bill your clients, yet the template should be simple and easy to use. Simple Consulting Invoice Template might be your choice for creating invoices.

does not include the shipping address section on the printable invoicing form. If you need the shipping address fields, try

Simple Sample - Separate City State ZIPc4081

Simple Invoice Template - Separate City State ZIP

"Simple Invoice Template - Separate City State ZIP" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 1.

  1. Backup the template before modifying it.
  2. Open it.
  3. Go to the "Invoice" ribbon tab and click the "Design Mode" button.
  4. Drag your mouse to select 3 custom fields, "oknCustomerCity" (cell address O8), "oknCustomerState" (cell address O9) and "oknCustomerZip" (cell address O10).
  5. Hit DEL key on keyboard to delete the formulas of these 3 cells.
  6. With the 3 cells / fields still selected, right-click on of the selected cell and choose "Format Cells" from the shortcut menu. This opens the "Format Cells" dialog box.
  7. Go to the "Protection" tab. Clear the "Locked" checkbox option.
  8. Click OK to close the "Format Cells" dialog box. This makes the 3 cells editable when the worksheet is protected.
  9. Now click and select the "City, State ZIP" cell in the "Bill To" section (cell address $F$11).
  10. Enter this formula for the cell: = CONCATENATE( TRIM ( oknCustomerCity ) , ", ", TRIM( oknCustomerState ), " ", TRIM ( oknCustomerZIP )). This formula combines the 3 user entered values into one readable and formal "City, State ZIP" value.
  11. Right-click selected cell ($F$11) and choose "Format Cells" from the shortcut menu.
  12. Go to the "Protection" tab.
  13. Check the "Locked" option box.
  14. Click OK to close the "Format Cells" dialog box. This make the cell not editable when the "Invoice" worksheet is protected.
  15. Exit design mode by clicking the "Design Mode" button again on Microsoft Excel ribbon tab.
  16. Save the template by clicking the Save button on Excel quick access toolbar.

Spin Button to Add or Subtract Onec4083

Sample Invoice Template with Spin Button

"Spin Button to Add or Subtract One" was found to be relative to Excel Invoice Templates Multiple Pages with the score grade of 1.

...(32) With this sample invoice template we demonstrates how to spin button, which is one of the Microsoft Forms Controls. The spin button allows you add one or subtract one from a number.

...(89) The spin button we'll use here one of the control in the "Form Controls" toolset, which is available in all the major apps in the Microsoft Office product family, like Excel (".xls" or ".xlsx"), Word (".doc" or ".docx"), Visio, Publisher, PowerPoint. Here on InvoicingTemlate.com we've already published samples on using form controls. For example, the "Taxable" checkbox could be either implemented using ActiveX control, or a form control - in the standard invoice template shipped with Uniform Invoice Software setup program, it use checkbox in the form control category.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c5083
Invoice Template with 4 Pages
Sunday, May 8, 2016,
84
5
Letter (8-1/2 in. x 11 in.)
Portrait
Sales
c5082
3-Page Invoice Template
Friday, May 6, 2016,
60
5
Letter (8-1/2 in. x 11 in.)
Portrait
Sales
c7014
Proforma Invoice Template (4th Sample, Landscape Page Orientation)
Monday, December 9, 2013,
20
7
A4
Landscape
Pro-forma
c4066
1/2 Page Invoice Template
Monday, February 29, 2016,
4
4
Letter (8-1/2 in. x 11 in.)
Portrait
Sales
c5081
2-Page Invoice Template
Wednesday, March 2, 2016,
36
5
Letter (8-1/2 in. x 11 in.)
Portrait
Sales
c9008
Excel Quotation Template
Friday, February 10, 2017,
37
9
A4
Portrait
Other
c5052
Excel Payment Voucher Template
Thursday, May 29, 2014,
12
5
A4
Portrait
Receipt
c2035
General Quote Template for Excel
Friday, August 19, 2016,
18
2
Letter (8-1/2 in. x 11 in.)
Portrait
Other
c4084
Job Estimate Template for Excel
Wednesday, August 17, 2016,
10
4
Letter (8-1/2 in. x 11 in.)
Portrait
Other
c1004
Donation Receipt Template for Excel
Monday, August 22, 2016,
8
1
A4
Portrait
Receipt
c4070
Labor Invoicing Sample
Wednesday, May 11, 2016,
8
4
A4
Portrait
Service
c4071
Parts and Labor Invoicing Format
Thursday, May 12, 2016,
18
4
A4
Portrait
Sales
c5087
Excel Shipping Invoice with Printable Truck Background Image
Friday, July 8, 2016,
16
5
A4
Portrait
Sales
c5020
Appliance Repair Service Bill Template
Thursday, August 18, 2016,
12
5
A4
Portrait
Service
c7005
Hotel Receipt Template
Monday, January 20, 2014,
12
7
A4
Portrait
Receipt
c4075
Simple Template with Printable Watermark
Tuesday, June 28, 2016,
20
4
A4
Portrait
Sales
cm001
Timesheet
Sunday, October 27, 2013,
26
x
Letter (8-1/2 in. x 11 in.)
Portrait
Other
c4034
Simple Consulting Invoice Template
Friday, November 14, 2014,
6
4
A4
Portrait
Consulting
c4081
Simple Sample - Separate City State ZIP
Tuesday, July 26, 2016,
12
4
A4
Portrait
Sales
c4083
Spin Button to Add or Subtract One
Friday, August 12, 2016,
6
4
A4
Portrait
Sales

What Is Hot

Feature Galleries