Skip to main content
InvoicingTemplate.com main content

Summary

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 Restaurantc4097

Receipt Sample for Seafood Restaurant

"Receipt Template for Seafood Restaurant" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 99.

...(60) This food bill receipt template is created based on c4039 Restaurant Dining Invoice Template (VAT). Like the original design, this template includes the "Table#" and "Server#" fields that are useful for dinning in restaurant; the "Bill To" section also includes the "Address" field, in addition to the "Customer Name" field, so this bill format could also be used for takeaways.

...(64) Here on InvoicingTemplate.com we provides templates in Microsoft Excel format, although a PDF version is also provided with the Excel workbook template file. This PDF format, like the Receipt PDF Sample for Seafood Restaurant, is generated with Uniform Invoice Software. Today electronical bills are widely accepted. You can even add a PayPal payment button to your receipts and bills by using Uniform Invoice Software.

Service Billing Template for Germanyc4099

Service Invoicing Template for Germany

"Service Invoicing Template for Germany" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 90.

...(40) Here on InvoicingTemplate.com we adhere to a simple rule to distinguish sales vs. service - i.e. if the Excel spreadsheet template has the "Shipping Address" section, it is categorized as sales invoicing template; otherwise it is a service invoicing template.

...(82) If you install Uniform Invoice Software, this process is much easier as our Excel-based invoicing program stores a counter in the backend Access database (or SQL-Server database if you choose the highest edition). When you create invoice by clicking the "Save To DB" on the "Invoice" Excel worksheet, or click the "Save Invoice" command on the taskpane, a new invoice# / bill# is generated automatically if that cell is left blank. See invoicing template with auto-numbering for more samples on this topic.

Excel Quotation Templatec9008

Excel Quotation Format with Special Discounting Model

"Excel Quotation Template" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 90.

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

...(31) This template is created for businesses who sell goods. For a job estimating and quoting template, visit Job Estimate Template for Excel. For a general estimate template, see General Estimate Template.

...(23) "Unit Price" is a manually editable field. "Line Total" is also a calculated field, which looks like this (again, "_?" indicates line numbers):

Excel Payment Voucher Templatec5052

Payment Voucher Template

"Excel Payment Voucher Template" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 84.

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

...(35) Note that there is a default Logo image on the top of form, which you must replace with your own logo image. To do this, unprotect the Invoice worksheet, and then switch to design mode.

...(22) Once you have finished your design work for Excel Payment Voucher Template, click the Design Mode button again to exit design mode.

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

Sales Template with line Number

"Sales Template with line Number" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 78.

...(33) This sample invoice template shows automatically the line number of an item in the place of item# or product# on the invoice body. The sample demonstrates the flexibility of an Excel-formatted invoicing template.

...(59) 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#c5037

Service Template with Line Number

"Sample Service Invoice Template: Using Line Number Instead of Item#" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 74.

...(105) The difference between sales and service here on InvoicingTemplate.com is simple - if a template contains the "Ship To" section on the printable section, we call it sales invoice. If it does not contain the "Ship To" section, it is categorized as service invoice. If the form has a very special design in its layout, such as Tax bill for Printing Shop, which moves the "Ship To" section (titled with "Delivery To") to the body of the spreadsheet form, we add the template to both the sales and service category. Sample Service Invoice Template: Using Line Number Instead of Item# adheres to this rule too.

  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. On the Tools menu, click Options, and then click the View tab.
  3. Under Window options, check the Gridlines and Row & Column Headers check boxes.

...(14) To show/hide gridlines and row/column headers in Excel 2007, Excel 2010 and Excel 2013:

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 Template With Automatic Numbering with the score grade of 66.

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

...(138) Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the spreadsheet form. General Quote Template for Excel uses custom fields to implement the features that are not available in the default template shipped with the invoicing program. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, our invoicing app has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

Job Estimate Template for Excelc4084

Job Estimate in Excel Format

"Job Estimate Template for Excel" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 64.

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

...(45) 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 Excelc1004

Donation Receipt Format for Excel

"Donation Receipt Format for Excel" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 54.

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

...(61) Secondly, the receipt should include the donor's name, this is necessary in order to be legally valid. Although not required, we've placed the "Phone#", "Mobile#" fields on the top of the section outside the printable area. In case you want to include these information on the PDF donation receipt or printed receipt, you can easily move them into the "Donor" section.

Labor Invoicing Samplec4070

Labor Invoicing Sample

"Labor Billing Format for Excel" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 51.

...(54) This labor billing format for Excel is in Microsoft Excel spreadsheet "xlsx" format. A PDF format is also generated using Excel, including the document for this template. If you have Uniform Invoice Software installed, the invoicing software app is able to create PDF invoice automatically and send to your clients with simple mouse clicks.

...(88) (Note that if you have installed the latest version of our invoicing software, Uniform Invoice Software, which is able to upgrade a simple template in Microsoft Excel spreadsheet format into a complete invoicing system, you don't have to replace the logo image manually - you can replace the default logo image by clicking the "Replace Logo Image" button on the ribbon tab in Excel 2007, Excel 2010 and Excel 2013). To replace the default LOGO image in Labor Invoice Template with your own image, follow the steps below:

Bill Sample with Sports Themec4094

Invoicing Template with Sports Theme

"Bill Sample with Sports Theme" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 43.

...(38) Designed for sports shops and stores that sell sports goods, accessories and equipment, or for sports training and education organizations. Download this free billing and invoicing sample in Excel or PDF format that features a translucent sportsman background.

...(67) Like other templates here on InvoicingTemplate.com, this form layout is just one of the sample invoicing templates that demonstrating how the default template comes with Uniform Invoice Software could be customized. While the Customizing Invoice Template document describe the basic rules and principle about customization, you surely need some examples to show the results and details of customization. This is why we built the InvoicingTemplate.com web site.

Simple Invoice for Construction Businessc4046

Simple Billing Format for Contractor

"Simple Billing Format for Contractor" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 33.

...(59) Have you ever said "I need a simple invoice?" Simple Invoice for Construction Business / Simple Billing Format for Contractor might be your choice. No need to learn complex accounting and invoicing software system. The format is in MS Excel format that could be filled just like a paper form and could be easily sent as electronic PDF document.

...(70) A printable invoice for use by a general contractor in the construction industry. 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!

Hotel Bill Format with Online Payment Buttonc7030

Hotel Bill Format with PayPal Payment Button

"Hotel Bill Format with Online Payment Button" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 31.

...(98) 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 Descriptionc8002

Simple Sales Invoice Format without Item Description

"Simple Sales Invoice Format without Item Description" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 28.

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

Customization of Standard Fieldsc4108

Customization of Standard Database Fields

"Customization of Standard Database Fields" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 22.

...(79) First, make sure you have made a backup of your current database file, so that in case something goes wrong during the following steps you are able to return to the original state easily. In this sample, we'll be using c4020 Invoice Template with Long Product Description with which we show you how to customize the invoice template so that it allows you to enter more text into the description fields of the standard invoice format shipped with UIS.

...(17) See "Advanced Database Field Customization" chapter of Uniform Invoice Software documents for more information on this topic.

Proforma Invoice with Printable Earth Map Backgroundc7029

Pro-Forma Invoice with Printable Earth Map Background

"Proforma Invoice with Printable Earth Map Background" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 22.

...(85) Like our previous pro-forma invoice templates, this Proforma Invoice with Printable Earth Map Background is in Microsoft Excel format (xlsx) format too. In fact, all of our invoice templates are provided you in Excel format, although a PDF version of the invoice template is provided with each Excel invoice template too. The reason that we choose Microsoft Excel as our template format is that Microsoft Excel is very widely applied spreadsheet around the world, and has replaced Lotus 1-2-3 as the industry standard for spreadsheets.

Photography Receipt Template (Detail)c8005

Photography Receipt Template (Detail)

"Photography Receipt Template (Detail)" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 7.

...(154) Both Photography Invoicing Template (General), Photography Receipt Template (Detail) are titled with the word "Photography", yet they have very different format layout. Photography Invoicing Template (General) / Photography Billing Format (General) (c4043) was a general invoicing format that should be suitable for many business types, whether you are providing services or selling products (images). On the other hand, Photography Receipt Template (Detail) / Photography Receipt Format (Detail) (c8005) is basically suitable for businesses who print and sell images. With the rise of digital photography several years ago, photography has made rapid strides. With the passage of time photography has progressed into various fields such as photojournalism, food photography, travel photography, and many more. We design these two formats and layouts for you to choose the one you like. Note that these formats, including the PDF invoice template, are just samples on how to customize the default sales invoice template shipped with Uniform Invoice Software.

Photography Invoicing Template (General)c4043

Photography Billing Format (General)

"Photography Invoicing Template (General)" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 5.

...(44) Whether you are a freelance photographer or running a photography business, an expensive accounting software program for invoicing isn't necessary your best choice. Download the photography invoice template to request payment for photography services and related work, such as photo editing or studio rental.

...(104) Whether you are doing, graphic design, contract-based event photography, family portraits or wedding photography this invoice will work for your business. The "Description of Service Provided" section allows you to detail any information that are related to your service, such as project type, picture settings, film developing, and insurance. Because of this, this template layout is consider as "general", meaning it should could be used by any photographers and photography studios. If your photography business focuses on image printing, there is another layout here on InvoicingTemplate.com that you may like to have a look, at Photography Receipt Template (Detail) or Photography Receipt Format (Detail).

Template with Summary on Topc4003

Template with Summary on Top

"Template with Summary on Top" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 5.

...(30) This is a variant of 4 column invoice template without tax. It differs from the original by moving the summary section to the top to near the "Bill To" section.

...(64) Microsoft Excel provides handy tools for customizing the invoice form. This invoice template "Template with Summary on Top", likes many other invoice templates here on InvoicingTemplate.com, demonstrating how the template can be customized to create the format and layout you like. Your business is special, so your invoices should be. With Microsoft Excel, you can easily change the font, colors, patterns and borders etc.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c4097
Receipt Sample for Seafood Restaurant
Wednesday, November 2, 2016,
20
4
A4
Portrait
Receipt
c4099
Service Billing Template for Germany
Monday, November 21, 2016,
12
4
A4
Portrait
Service
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
c5036
Sample Sales Invoice Template: Using Line Number Instead of Item#
Wednesday, December 18, 2013,
12
5
A4
Portrait
Sales
c5037
Sample Service Invoice Template: Using Line Number Instead of Item#
Wednesday, December 18, 2013,
12
5
A4
Portrait
Service
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
c4086
Invoicing Template with Logo
Saturday, August 20, 2016,
6
4
A4
Portrait
Sales
c4094
Bill Sample with Sports Theme
Friday, October 28, 2016,
12
4
A4
Portrait
Sales
c4046
Simple Invoice for Construction Business
Thursday, November 12, 2015,
12
4
A4
Portrait
Service
c7030
Hotel Bill Format with Online Payment Button
Saturday, August 13, 2016,
12
7
A4
Portrait
Receipt
c8002
Simple Sales Invoice Template without Item Description
Friday, January 10, 2014,
30
8
A4
Portrait
Sales
c4108
Customization of Standard Fields
Thursday, March 30, 2017,
6
4
A4
Portrait
Sales
c7029
Proforma Invoice with Printable Earth Map Background
Sunday, July 10, 2016,
8
7
A4
Landscape
Pro-forma
c8005
Photography Receipt Template (Detail)
Sunday, November 8, 2015,
18
8
A4
Portrait
Receipt
c4043
Photography Invoicing Template (General)
Saturday, November 7, 2015,
12
4
A4
Portrait
Service
c4003
Template with Summary on Top
Sunday, November 3, 2013,
12
4
A4
Portrait
Service

What Is Hot

Feature Galleries