Skip to main content main content
sharing is caring! we do appreciate your time to let others know us!



When you click the "Save Invoice" or "Save To DB" button, Invoice Manager for Excel (namely Uniform Invoice Software) generates a unique, sequential and progressive (increment) invoice / receipt number if the cell is left blank. This automatic numbering generator is based on a counter stored in the backend database. You can set the "Next Number", "Prefix" and "Numbers of Digits in ID" options on the "Database" tab of "Settings" window. Without Invoice Manager for Excel (namely Uniform Invoice Software), you have to use Excel macros, as detailed on Generate invoice numbers in Excel, or at Excel - A macro to perform the automatic numbering of invoices.

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

Receipt Sample for Seafood Restaurant

Receipt Sample for Seafood Restaurant

Unlike the c7005 hotel receipt template, this layout designed specifically for restaurants does not include fields for rooms.

  1. Click the Settings button on the "Invoice" ribbon tab.
  2. Go to the "Taxes" tab.
  3. Enter your tax name in the appropriate text box.
  4. Click "Apply".
  5. Close the "Settings" window.
  6. Save the template by clicking the "Save" button on Excel quick access toolbar.

Service Billing Template for Germany

Service Invoicing Template for Germany

As detailed at Invoicing requirements for Germany, each invoice requires its own unique identifier number - i.e. invoice number. Without Invoice Manager for Excel (namely Uniform Invoice Software) installed, you have to fill in the invoice# field manually, and you are also responsible to make sure the invoice numbers are unique.

Soccer Shop Invoice Template

Invoicing Form for Soccer Shop

This soccer shop invoice template is an updated version of cn-009 Soccer Shop Invoice Template published on our company web site The form design is a deeply customized Excel spreadsheet with 16 columns on the detail section.

Bricklayer Invoice Template

Bricklaying Bill Form

On the "Services" section, the 4 columns are titled with "Details", "Rate", "Hours" and "Amount"; on the "Parts and Materials" section, the columns are titled with "Details", "Price", "Quantity" and "Amount". If you charge only for hours worked, see invoice template for hourly work for more samples. All the itemized lines on this template have Excel formulas assigned, so that you don't have to do calculations manually, even without installing Invoice Manager for Excel (namely Uniform Invoice Software). This is a big benefit of Excel invoice templates than Word-formatted bill templates.

Simple Sample - Default Value

Simple Sample - Editable Default Value

The second category includes "Payment Term", "Shipping Method" (or "Shipping via"), "Customer Category", "Product Category" and "Sales Rep. Name". The default values of these fields can be changed manually by following the steps below.

Translation Service Receipt

Translation Service Receipt

If you need more, such as automatic numbering, tracking and logging, co-working, or even sharing via Internet so that you can work remotely, simply install Invoice Manager for Excel (namely Uniform Invoice Software).

Boutique Bill Sample

Boutique Invoice Template

We also removed / hide 3 lines from the detail section, so the template shows 9 lines only, with each line being able to show at least 2 lines of text in the "Description" field. This might be a more practical design for a store or shop.

Five Price Levels (Service, Amount)

Five Price Levels (Service, Amount)

It was created by simply moving out all the shipping-related fields, including: the "Ship To" section fields, such as Name, Address, City State and Zip, Country and Contact. The icon button for selecting shipping address should also be moved out of the printable area. Moving an ActiveX control, such as the icon button, is a bit more complex than just moving cells. To move an Active X control out of the printable area, you first need to unprotect the Invoice worksheet, this could be done by clicking the Unprotect Sheet command on the Review ribbon tab in Excel 2007, Excel 2010 and Excel 2013, or in Excel 2003 you have to click Excel menu Tools / Protection / Unprotect Sheet. You can find more samples at our featured galleries Automatic numbering on invoice template and blank invoice templates.

Sample Invoice Template

Sample Billing Form

The form bottom includes a "Terms and Conditions" section. Modify the text in this section to make it meets your business requirements.

Excel Quotation Template

Excel Quotation Format with Special Discounting Model

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 Template

Payment Voucher Template

If you use the Invoice Manager for Excel (namely Uniform Invoice Software) edition, note that the "Discount" and "Advance" are custom fields.

Work Invoice in Excel

Work Billing Template in Excel

This sample template also adds the line of "United States Federal Tax I.D." to the bottom of worker information. We also formatted several fields to show the US Dollar currency symbol, such as "Subtotal", "Tax" and "Total".

Sample Sales Invoice Template: Using Line Number Instead of Item#

Sales Template with line Number

But there are situations where you don't need the product# or item# at all. In this Sample Sales Invoice Template: Using Line Number Instead of Item# we'll assign a line number to the product# field automatically using Excel formula. It is a good example on how the default sales invoice template could be customized in the way you like.

Sample Service Invoice Template: Using Line Number Instead of Item#

Sample Service Invoice Template: Using Line Number Instead of Item#

Like what we do to all the customized invoice templates here on, we start by unprotecting the Invoice worksheet, and then display gridlines and row/column headers, and then drag the shipping fields, including the related labels, out of the printable invoice form.

General Quote Template for Excel

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.

Building Construction Bill Format

Construction Bill Format in Excel

Designed for general contractors and operative builders in the construction industry, this free building construction bill format in Excel is suitable for small businesses like family owned and operated contractor.

Job Estimate Template for Excel

Job Estimate in Excel Format

While in the Estimate Templates gallery we've already published several templates that could be used for estimating and quoting purpose, like the General Estimate Template and Telecom Consultant Estimation Template, this template differs from other in the number of columns and the layout of the form itself.

Bill Sample with Sports Theme

Bill Sample with Sports Theme

As an owner who runs a business relating to sporting, like a horse trainer, you surely want to make your invoices differ from others. We've an invoicing sample Invoice Design for Personal Trainer or Fitness Instructor (c4082) here on that is somewhat related to sporting, but you may prefer to look at another option? This one might be interesting for you.

Construction Invoice Template

How to Make a Construction Invoice

A printable invoice for use by a general contractor in the construction industry, such as basement remodeling, custom homes, deck building, foundation construction, general contracting, guesthouse design & construction, home additions, home extensions, home remodeling, modular home construction, new home construction, porch design & construction, project management, patios and retaining walls. Besides electronic format as either PDF or Excel spreadsheet (xlsx or xls) document, you can also print invoices. You need this simple invoice because you can use it anytime, anywhere. It has lines for description, quantity, rate, and amount, for both materials and labor. It automatically subtotals the items, adds sales tax and totals everything for you!