Skip to main content
InvoicingTemplate.com main content
Sharing Is Caring! We do appreciate your time to let others know us!

Summary

GENERATOR

What is an invoice generator?

An invoice generator is a tool that helps you to generate invoices and bills easily. The easiest way to create an invoice is by using a template.

  • The template provides the basic and essential format and layout, so when creating an invoice all you need to do is to fill the blank fields.
  • Ideally the template should be able to do calculations of taxes, discounts and totals.

Our free Excel invoice generator templates published here on InvoicingTemplate.com meet the above requirements. While there are Word invoice templates available on the Internet for free, Excel is far better in doing calculations, which make our templates the ideal free invoice makers.

Why choose our invoice creator template?

Today we have hundreds originally designed templates published here on InvoicingTemplate.com.

  • Unique designs. All templates are created by our staffs.
  • Intuitive and easy to use. Our generators are designed in a what-you-see-is-what-you-get way. Creating invoices in minutes even you are new to invoicing.
  • Upgradable. If a simple invoice generator is not enough as your business grows fast, simply download and install Uniform Invoice Software. The template becomes a powerful invoicing system. Watch our movie tutorial to find out how to create invoices easily.

Best of all, if you use the Enterprise edition of Uniform Invoice Software, our invoice template is able to connect with online database. This way, the online invoice generator allows you to share data with mobile devices.

Excel Invoice Generator Template is a sub-topic of Excel Invoicing Templates . Here are our templates closely related to Excel Invoice Generator Template.

Excel Quotation Template

c9008
Excel Quotation Format with Special Discounting Model

The value of the "Quantity" is calculated using an Excel formula like this, where "_?" is the line number:

On the bottom of the form, you'll find the usual "Subtotal", "Discount" and "Total" fields. There is also the "Last Balance" field and the "Total Due" cell. The "Last Balance" cell has its field name set to "oknAccountBalance", which is filled whenever you fill in the quotation form / estimation form with an existing client by using the on-sheet picker button, you by enter the client# into the "Customer#" cell (also located outside of the printable quotation form, at $U$2). See Invoice with Previous Balance (Sales) and Invoice with Previous Balance (Service) for more information on how to show previous balance on the form. The "Total Due" is the sum of the previous account balance and the total of the current quotation.

Excel Payment Voucher Template

c5052
Payment Voucher Template

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.

General Quote Template for Excel

c2035
General Quote Format in Excel Spreadsheet Format

Since the line totals are manually editable, i.e. not calculated from hours and rate or quantity and unit price, it is more like a general invoice template.

Job Estimate Template for Excel

c4084
Job Estimate in Excel Format

On the top of the blank estimate form you see the service business name. Next to it is the highlighted "ESTIMATE#" and "ESTIMATE DATE" fields. These fields are essentially the "Invoice#" and "Invoice Date" cells that appear on most free invoice templates here on InvoicingTemplate.com.

Donation Receipt Template for Excel

c1004
Donation Receipt Format for Excel

First of all, the most important item to include on the receipts is the name and status of charity / organization name. It must be a non-profit, meaning you have 501c3 status under the federal government. In our donation receipt design, we simply used the fields that are usually for seller information, located on the top of the Excel form.

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

Labor Invoicing Sample

c4070
Labor Billing Format for Excel

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.

Parts and Labor Invoicing Format

c4071
Parts and Labor Billing Format for Excel

This free printable parts and labor billing format for Microsoft Excel shipping and delivery information, unit prices, rate, and more, as well as a box in which to note the date and invoice number. You can also download a PDF version of this template here on InvoicingTemplate.com. Unlike the our Excel labor invoice template, the detail section on this invoicing form is divided into two section, each section has its own tax rate and calculation formula.

Excel Shipping Invoice with Printable Truck Background Image

c5087
Shipping Invoice with Printable Truck Background

Fortunately it is still possible to print an image in the background of a worksheet. This technique could also implement watermark effect on your invoices, as shown in Simple Invoice Template with Printable Watermark.

Jamaica Tax Invoice Template

c5072
Jamaica Tax Billing Format

This template, Jamaica Tax Invoice Template, or Jamaica Tax Billing Format, was created with the above requirements in mind. In order to create this layout from the default template shipped with Uniform Invoice Software, we moved out the Product# (Item#) column from the detail section of the invoice form, and added a new column "Date Supplied", which is a custom field "DateSupplied" added to the "Invoice Body" database table.

Advanced Invoicing Sample - Invoiced Total in English Words

c5102
Advanced Bill Sample - Invoiced Total in English Words

In this advanced sample of creating customized invoice template, we'll use c5099 Standard Business Invoicing Template with Oval Button in the Business Invoice Templates gallery as the starting point, add the macro function "SpellNumber" to the template to show the billed amount in English words.

Proforma Invoice with Printable Earth Map Background

c7029
Pro-Forma Invoice with Printable Earth Map Background

Microsoft Excel provides powerful and flexible tools to format and present font-end data. This means we can easily design a professional and beautiful invoice layout easily with Microsoft Excel.

ABN Tax Invoice

c7028
ABN Tax Invoice

This template is a revised version of our original designs, Australian GST Invoice Template and Australian GST Invoice Template (2). With this new template, we move the ABN# field to the top of the invoice form, and also modify the layout of the form to make it looks better and works more smoothly with the latest version of Uniform Invoice Software.

South Africa Tax Invoice Template (Service)

c4037
South Africa Tax Billing Format (Service)

South Africa Tax Billing Format (Service) is a variant of South Africa Tax Invoice Template (Sales), created by removing the shipping address section from the form and thus it is suitable for service provides.

Hourly Invoice Template

c5022
Hourly Invoice Template

There are 5 columns on the body of the invoice form: #, Description, Hours, Rate and Amount. The Amount is calculated automatically using Excel formulas.

Auto Repair Service Invoice with Car Lift Background Image

c5089
Auto Repair Service Bill with Car Lift Background Image
  1. Backup the Excel template.
  2. Open the template.
  3. Click the "Design Mode" button on the "Invoice" ribbon tab to switch to design mode.
  4. Go to Excel "Page Layout" ribbon tab and click the "down arrow" button in the "Page Setup" group. This opens the "Page Setup" dialog box.
  5. Click and activate the "Header / Footer" tab.
  6. Click the "Custom Header" button.
  7. Delete all the content in the "Center section" box.
  8. Click OK on each dialog boxes to close them.
  9. Exit design mode by clicking the "Design Mode" button again on the "Invoice" ribbon tab.
  10. Save the template by clicking the "Save" button on Excel quick access toolbar.

Standard Invoice with Double Border

c5085
Standard Invoice Format with Double Border

Step 4: Drag your mouse to select all the range for the new printable form - this is the area that has one row / column expanded to the top, bottom, left, right edge of the original printable form. In this sample, we selected the area addressed at $C$2:$L$48. Now go to Excel "Page Layout" ribbon tab and from the "Page Setup" group, click "Print Area" and then "Set Print Area". This defines our new print area.

South Africa Tax Invoice Template (Sales)

c4036
South Africa Tax Invoice Template (Sales)

With this implementation of south Africa tax billing format, the shipping address is included on the format, so that the template is categorized as sales invoice template. With this tax invoice template, the prices defined on the form excluding VAT, i.e. VAT is added separated. As detailed on the SARS (South African Revenue Services) site, Value-Added Tax is commonly known as VAT. VAT is an indirect tax on the consumption of goods and services in the economy. Revenue is raised for government by requiring certain businesses to register and to charge VAT on the taxable supplies of goods and services. These businesses become vendors that act as the agent for government in collecting the VAT.

Invoice with Remittance Slip

c2030
Invoice Sample with Remittance Letter

This free sample invoice template in Excel format demonstrates how to add a remittance slip to the bottom of an existing invoicing template. The remittance slip / letter is printable with the invoice, so that the customer can be detached and sent along with the check.

Clothing Shop Receipt

c6001
Clothing Shop Receipt

Like all the other invoice template examples available here on InvoicingTemplate.com, this money receipt template and cash receipt template is also based on the default sales invoice template shipped with Uniform Invoice Software, and works with Uniform Invoice Software without any problem - plus, Uniform Invoice Software will offers features like management of customers, products, invoices and payments. The template includes the "Ship To" or "Delivery To" section, so this can also be used as a delivery receipt template. If you are looking for a guide of how to prepare money receipt, or the definition of what are cash receipts, or some samples and examples of receipts, this template answered the question in an intuitive way. The template could help you draft receipts in an easy and quick way, and it also helps you create your daily receipts in a professional way. Compared to those complex and expensive receipt or invoice software programs, this petty and free template offers you a budget-free solution - there is no fee you should pay monthly or yearly for using the free receipt template.