free excel invoice templates
You are here: HOME  >>>  Excel Invoice Manager

Excel Invoice Template

Version 1.3

clean and free softwareThis free invoice template provides a Fill In The Blank invoice form and is capable of creating and calculating invoices. You can easily create invoice using its true what-you-see-is-what-you-get form.

If you are running a small business and all you need is a quick way or utility to fill up invoices, this one may be the right billing tool for you.

Overview of the Invoice Template

The template shows quantity, description, price, taxable status, and amount per line. Sub-total, tax and total amount are computed from the line items automatically. It offers a true What You See Is What You Get invoice form. If you know how to use Microsoft Excel, you know how to use Excel Invoice Template. Click the following image to see a sample form.

Free Invoice Template and invoice form
Excel Invoice Template (Click to enlarge)

As an Excel workbook, all Microsoft Excel features are available to you, from simple formatting, such as replacing default fonts and colors, to more advanced moving and merging cells. For example, if you want to change the number format, text alignment, style, font, border and pattern of a certain cell, just right click the cell and choose Format Cells from the menu. Click the figure below to see how many options Microsoft Excel provides!

Free invoice template - format cell
Format cell (Click to enlarge)

Note: In this workbook all cells are identified by names, so you can move a cell inside the worksheet without breaking formulas. To move a cell, just click the cell in question to select it, and then hover your mouse on the border of the cell, drag and drop it to its new location.

Note: The template is designed in a printable way. To print, simply click Excel menu File->Print. To adjust various print options, such as paper size, paper margins and print quality, just click Excel menu File -> Page Setup.

What's New in the Latest Version

Version 1.3

Added inline instructions for customizing the invoice form.

Version 1.2

In previous versions, some cell names are hidden to simplify the lengthy name list. However, this causes inconvenience when customizing the formulas. In this new release, all cell names are visible.

Things to Do Before Using

For new users of the template, before creating invoices, here are some important options you should check.

Note: By default, the main worksheet is protected to avoid overwriting formulas accidentally. To unprotect it, click Excel menu Tools -> Protection -> Unprotect Sheet.

  • Company information
    Enter your company information in the worksheet, such as your company name, address, and contact information.
  • Logo image
    There is a logo image on the main worksheet where you can place your company logo. Please replace the default image with your own image.

After customizing the worksheet, please protect it again to avoid overwriting formulas accidentally.

The detailed steps for customizing the LOGO image are:

  1. Click the Design Mode button on the Control Toolbox toolbar. (If the Control Toolbox toolbar is not displayed, click Excel menu View -> Toolbars -> Control Toolbox).

  2. Right click the Logo image, and select Properties.

    free invoice template - customizing LOGO image

  3. Click the Picture property, and then click the ... button.

    free invoice template - LOGO image properties

  4. Browse to the folder containing your icon file. Select and open the icon file.
  5. Close the Properties window.
  6. Click the Design Mode button again to exit design mode.

If you don't want to include the logo image in your invoices, just delete the image.

Customizing the Tax System

By default, this template has two taxes. If you need to customize the tax system, please download Excel Invoice Manager. Excel Invoice Manager can help you customize invoice templates. For example, setting tax system is just one click job.

Click here to learn more about the template included in Excel Invoice Manager.

See Also

Microsoft provides a directory of free invoice templates on its own web site. They offer various free templates in Word, PowerPoint, Publisher, and of course Excel. Click the link to look for invoice template on Microsoft's free templates library.

 
EXCEL INVOICE TEMPLATE Download Zip file (37 KB) Download Excel file (77 KB)
EXCEL INVOICE MANAGER Free Download and Try (5.40 MB)
LEARN MORE Excel Invoice Manager Home What's New Difference between Editions Quick Start Introduction Setting up Company Information, Tax Invoice Template Working with Excel 2007 Installing / Upgrading Settings Workbook Taxes Misc Data Interface Database In-Cell Lookup Print Customers Creating Customer Editing Customer Customer Detail Products Creating Product Editing Product Product Detail Invoices Creating Invoice Editing Invoice Invoice Detail Payments Adding Payment Editing Payment Payment Detail Reports Generating & Printing Reports Setting Visible Columns Extracting Reports Common Tasks Using the Search Bar Using Data List Windows Importing Data into Excel Invoice Manager Networking Working with Form Properties File Free Invoice Form with Support for Incomplete Lines on Invoice Body Using Credit Note or Credit Memo Copying Report Worksheets from One Invoice Template to Another Two Versions of Customer Statement Report Custom Fields Custom Fields - Overview Custom Invoice Fields - Tutorial Customizing the Invoice Template Customizing the Invoice Template Tutorial: Creating an Invoice Template with Additional Rows Tutorial: Adding a Notes Field to Your Invoice Template Tutorial: Adding or Removing the "Same As Bill To" Button Tutorial: Adding a Clear button to the Report Worksheets Tutorial: Displaying Summary Information on Customer Statement Tutorial: Creating a Receipt Form Using Multiple-Line Address in Invoice Form Printable Invoice - Invoice Printing in a Flexible Way Adding Postcode Cells Manually to Invoice Template More Topics Registration and Services Reference
Online-Only Articles Billing Software Powered by Excel Buttons in the Template Don't Work Sample Invoice Template: Using handwriting Signature Sample Invoice Template: Using Drop-Down List Sample Invoice Template: Long Product Descriptions Sample Invoice Template: Using Line# as Product IDs How to: Password-Protecting an Invoice Template How to: Transferring Excel Invoice Manager to a New System How to: Removing Auto-created Macros from Your Invoice Template Creating a Packing Slip Template Modifying Standard Fields with Database Designer Sample Invoice Template: Replacing the Product IDs with Line Numbers Invoice Template with Support for Product-Type Specific Tax Rates Editing Paid Invoices Working with Multiple Companies or Currencies Tutorial: Adding New Fields to Reports Sample Invoice Template: Displaying 'FREE' for Zero Values Customizing Header and Footer of Printed Invoices Customizing Invoice Template for Pre-printed Invoice Forms Charging GST Tax on Shipping Cost Invoice Form with Fixed or Static Product / Service Items
Home Contact Us Privacy Link to Us
copyright © Office-Kit.com, all rights reserved