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.

...(45) This template set the tax name to "VAT". You can easily change this by following the steps below if Uniform Invoice Software is already installed on your system (Uniform Invoice Software requires Windows from XP to 10, with Excel / Office from 2003 and later).

Service Billing Template for Germanyc4099

Service Billing Template for Germany

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

...(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 Format with Special Discounting Model" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 90.

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

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

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

...(100) If you don't need the LOGO image and want to delete it, simply hit the DEL key on your keyboard after you selected it with your mouse key. Deleting the LOGO image leaves an empty area to the left of the Company Information section. You may like to move the entire Company Information section to fill in the empty area. To do this: Drag your mouse to select the entire Company Information area, including Company Name, Street Address, City, ST Zip Code, etc.; Push your mouse key on the border of the selected area; drag it to the new location.

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

Sales Template with line Number

"Sample Sales 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 78.

...(160) Most invoice templates available here on InvoicingTemplate.com have a Product # (or sometimes titled "Product ID" or "Item#") column on the invoice body. If you are using Uniform Invoice Software, our invoicing software and billing software that uses Excel invoice templates as it's front-end, the product# or item# is a required field that is used to uniquely identify a product or an item. With the product# or item# field, Uniform Invoice Software is able to save the description, unit price and all the other related information into database, so that you can retrieve these type of information by entering the product# or item#, without typing the same description, unit price etc. again and again. So in most cases if the product# or item# column is not required to display on the printable invoice form, we move it out of the printable form, instead of delete it. The product# field also helps in generating the product report in Uniform Invoice Software.

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

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

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

...(67) 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,

...(16) The gridlines and row/column headings could help a lot when design the layout of the form.

General Quote Template for Excelc2035

General Quote Template for Excel

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

...(123) As an Excel spreadsheet template, we use Excel formulas to calculate subtotal, tax and total. For example, for the subtotal field, the Excel formula assigned to the subtotal field is "=SUM(oknLinetotal_1:oknLinetotal_22)". This is one of the big advantages of using Excel spreadsheet templates. While you can create beautiful and professional forms too using Microsoft Word, Publisher, PowerPoint or even Adobe Photoshop, it is much easier when you need to do some calculations. This ability, combined with custom fields (user-defined fields) supported by Uniform Invoice Software, resulting extremely flexible form designs, as you can see from the samples online here on InvoicingTemplate.com. Or see the PDF quotation sample to find out what it will like when your customer receive the quotation created using UIS.

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.

...(119) For this reason, the "ESTIMATE#" support all the features assigned to the "Invoice#" cell by Uniform Invoice Software. For example, if you click "Save To DB" or "Save Invoice", a sequential, progressive and unique estimate# is generated automatically if the "Estimate#" cell is left blank (see our gallery page at Excel Invoice Template Automatic Invoice Numbering). With pure-Excel spreadsheet solutions, this automatic numbering is not possible without using macros. To display / retrieve an existing estimate or quote, you can simply enter the estimate# into the cell. With the support from Uniform Invoice Software, the pure-Excel spreadsheet template is not only printable, but also enables features that could be hardly to implement with pure-Excel estimating and quoting software apps.

Donation Receipt Template for Excelc1004

Donation Receipt Template for Excel

"Donation Receipt Template 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.

...(25) Third, it is also required to clearly describe the donation, including the date the donation was made, as well as the amount of the donation.

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

Labor Invoicing Samplec4070

Labor Billing Format for Excel

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

...(100) If you don't need the LOGO image and want to delete it, simply hit the DEL key on your keyboard after you selected it with your mouse key. Deleting the LOGO image leaves an empty area to the left of the Company Information section. You may like to move the entire Company Information section to fill in the empty area. To do this: Drag your mouse to select the entire Company Information area, including Company Name, Street Address, City, ST Zip Code, etc.; Push your mouse key on the border of the selected area; drag it to the new location.

Bill Sample with Sports Themec4094

Invoicing Template with Sports Theme

"Invoicing Template 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 PayPal Payment Button" was found to be relative to Excel Invoice Template With Automatic Numbering with the score grade of 31.

...(98) The form layout of this template is based on c7005 Hotel Receipt Template published here on InvoicingTemplate.com. As the original design, it includes 7 columns - "Room #", "Name", "Check in", "Check out", "# of Nites". "Price / Nite", "Line Total". The automatic calculation of the subtotals, totals, taxes are done using Excel formulas. This is one of the big advantages of Excel spreadsheet templates - you can use formulas to do calculations. While it is easy to do document formatting in Microsoft Word too, the auto calculation of Excel spreadsheet makes it much easier to create invoices.

Simple Sales Invoice Template without Item Descriptionc8002

Simple Sales Invoice Format without Item Description

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

...(242) Moving a cell or a group of cells is easy in Excel. First, you click to select the cell or drag your mouse to select all the cells you want to move. And then, drag the border of the selected area to move it to the new location where you want to place the cell or cells. The moving content will overwrite the content in the target location, so make sure the target range is empty (not used) in Simple Sales Invoice Template without Item Description before doing the movement. And, if the target location contains merged cells, sometimes the movement fails. So it is also helpful to make sure the target location does not contain merged cell. If the target location Simple Sales Invoice Template without Item Description is overlapping the original range and the original range contains merged cells, the movement could also fail because you cannot change part of merged cell - if this happens, you need to first move the cells to a temporal location in Simple Sales Invoice Template without Item Description that are empty (i.e. not used), unmerge cells, and then move the cells from the temporal location to the desired location. If you need to unmerge a cell, first select it and then click the "Merge and Center" command on the Format toolbar in Excel 2003; or click the "Merge and Center" command on the Home ribbon tab in Excel 2007, 2010 and Excel 2013.

Catering Invoice Templatec4045

Catering Invoice Template

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

...(130) In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Catering Invoice Template. Note that if you have our invoicing program installed, and you are running Excel 2007, Excel 2010 and Excel 2013, it already provides a Design Mode button on the ribbon tab, so that you don't have to switch to design mode manually. Our invoicing software is able to turn a simple spreadsheet into a powerful invoicing system, with the ability to manage customers, products, bills and payments, it also includes various tools that could help you configure the layout of your form, such as the number of taxes and tax names and rates. If you don't have our invoicing program installed, here are how you can switch to design mode manually.

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.

...(105) This sample, Proforma Invoice with Printable Earth Map Background, is based on c7014 Proforma Invoice Template (4th Sample, Landscape Page Orientation). This new version differs from the original one in that we've released all unnecessary button from the invoice form, replaced all ActiveX "Taxable" checkboxes with form controls, etc. However the most noticeable change is that we've add an earth map background image to the printable form (it will also be included in the auto-generated PDF proforma invoices too). Again, each of our template on InvoicingTemplate.com includes a PDF invoice template. Feel free to visit our PDF invoice templates to find out more invoice samples.

Photography Receipt Template (Detail)c8005

Photography Receipt Format (Detail)

"Photography Receipt Format (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.

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

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

...(159) Moving cells and fields is also as easy as dragging and dropping. If you prefer to place a cell on a new location, firstly unprotect the Invoice worksheet, and then click to select the cell/cells, and then drag the border of the selected cell to move it to a new location you like. Uniform Invoice Software supports all these tools provided by Excel, which makes sure that you can have the invoice form you like. And, one of the great features of Uniform Invoice Software is that, you can connect the invoice template in Excel spreadsheet format to a backend database, which gives you the ability to manage large amount of data, such as customers, products, invoices and payments, in an organized manner. Simply put, Uniform Invoice Software combines the power of Excel and backend relational database, turning a simple Excel invoice template into a powerful invoicing system. Feel free to download and try the fully functional trial version.

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
c4045
Catering Invoice Template
Tuesday, November 10, 2015,
12
4
A4
Portrait
Receipt
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