Excel Invoice Template With Automatic Numbering Skip to main content
InvoicingTemplate.com 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, 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 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
  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 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

Soccer Shop Invoice Template

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

Bricklayer Invoice Template

Bricklaying Bill Form

This free bricklaying invoice template itemize the cost of materials and labor on two separate sections. Each section has its own tax rate and calculating formulas. It also features a bricklayer cartoon image that shows intuitively what your business is.

Simple Sample - Default Value

Simple Sample - Default Value
  • Click "Settings".
  • Go to the "Misc Data" tab.
  • Modify the default values, or change the drop-down list by clicking one of the "Edit" buttons.
  • Once finished, click the "Apply" button.

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 Uniform Invoice Software.

Boutique Bill Sample

Boutique Bill Sample

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.

Excel Quotation Template

Excel Quotation Format with Special Discounting Model

The template includes 9 columns. The first two columns are titled with "PACKAGE", under which two columns allows you to enter number of packages, and the package type that is implemented as a drop-down list with 3 options - "BOX", "S.BOX" and "GUDDI". Followed are the columns "BOX No.", "Description", "Per", "Quantity", "Unit Price", "Line Total" and "LESS".

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

Excel Payment Voucher Template

Excel Payment Voucher Template

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.

Work Invoice in Excel

Work Billing Template in Excel

The word art feature is an interesting and useful feature available in Microsoft Office programs such as Word, Excel and Power Point. The basic usage of word art is described at Insert WordArt document on Microsoft's web site. With word art, you can create fancy text effects with just a few mouse clicks. Programs like Adobe Photoshop is able to create beautiful arts of word too, the advantages of using Office's built-in word art feature are obvious - it is simple, and the result is easily editable within Excel and Word itself.

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

Sales Template with line Number

This sample invoice template was originally published as a customization sample on office-kit.com at Sample Invoice Template: Using Line# as Product IDs, where you can also find detailed steps on how to create the sample invoice template based on the default sales invoice template shipped with Uniform Invoice Software.

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

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

If you know Microsoft Excel, creating this sample invoice template from the original sample sales invoice template should be easy. If you are not, but interesting in how to do the customization, here are the processes involved in creating the sample service invoice template. The detailed tutorial on creating the sample sales invoice template can also be found at Sample Invoice Template: Using Line# as Product IDs,

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.

Job Estimate Template for Excel

Job Estimate in Excel Format

With Uniform Invoice Software, the auto-generation of invoice# (in this case, estimate# or quote#) is based on a counter stored in the backend Access database.

Donation Receipt Template for Excel

Donation Receipt Format for Excel

While not required, this form includes a "Receipt#" field on the top of the form under the "Date" field. If you have used one of our form designs for invoicing, you may know it is just the "Invoice#" field - we just place a new label "Receipt#" before the cell. So all features Uniform Invoice Software offer for the "Invoice#" field, works for the "Receipt#" field too. For example, the automatic receipt numbering feature, which generates a unique, sequential and unique based on a counter stored in the backend database. You can also retrieve information about an already-saved receipt by type in the receipt number into the "Receipt#" field.

Bill Sample with Sports Theme

Invoicing Template with Sports Theme

All templates here could be downloaded for free. You can use the templates without installing Uniform Invoice Software. For example, you can just download this "Billing Sample with Sports Theme" template, fill in your business / organization name, and then create new invoices just like filling a blank paper. The result could be either printed, or you can generate electronical PDF invoice for your sports store using Office / Excel's built feature, and then send it PDF invoice to your clients. Even the template is completely free of charge, the result is good enough that even some commercial / paid invoicing software app couldn't procedure.

Simple Invoice for Construction Business

Simple Billing Format for Contractor

Although this template is named with the word "construction" and "contractor", it could also been seen as a general service invoice template. For example, consultants, service providers, and other small businesses could use this invoicing form too. We have other layouts here on InvoicingTemplate.com too. If you charge based on hourly rates, visit Invoice Template Hourly Rate. A Handyman Invoice Template is also ready here for you.

Hotel Bill Format with Online Payment Button

Hotel Bill Format with Online Payment Button

By including the PayPal payment button on the PDF invoice (test it!), the client is able to pay you through PayPal by clicking / tapping on the PayPal button. The hyperlink takes the client to PayPal web site, with the invoice# (receipt#) and amount included as the transaction detail. This reduces typo mistakes. Being in the widely supported PDF format, the invoice and the PayPal payment button work on almost any devices today - not only Windows desktop computers, but also Mac, and even mobile phone devices. Feel free to see all our invoice templates in PDF format!

Simple Sales Invoice Template without Item Description

Simple Sales Invoice Format without Item Description

All free invoice templates designed by us at InvoicingTemplate.com are based on the default sales invoice template shipped with Uniform Invoice Software. Usually if a new invoice format does not required a field to be included in the printable invoice form, we simply move the field out of the printable area - i.e. the area with white background on the center of the Invoice worksheet. And, if a new field is required that is not defined by the default sales invoice template shipped with Uniform Invoice Software, we define a custom field. The definition of the custom fields makes sure that the newly added field will work with Uniform Invoice Software, our invoicing software that connects an Excel invoice template with a back end database.