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.

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

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

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

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

... Like the original template c4098 Sales Invoicing Format for Germany, this template has all the labels on the service invoicing form translated into German.

... Like the original invoicing sample for Germany, this template also has all the static text labels translated into English, such as " Auftrag # Verkäufer-name Versanddatum Versandart Fälligkeitsdatum."

Excel Payment Voucher Templatec5052

Payment Voucher Template

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

... The protection of the "Invoice" worksheet in Excel Payment Voucher Template prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the worksheet. However for the purpose of this sample, we should firstly unprotect the worksheet in Excel Payment Voucher Template.

  • Right click the Logo image, and then select Properties from the menu.
  • Click the Picture property, and then click the "..." button.
  • Browse to the folder containing your icon file. Select and open the icon file.
  • Close the Properties dialog box.
  • Drag the border of the image object to resize it, if needed.

... The voucher# field is a must-filled-in field. It should be filled with a unique (and usually consecutive) value. If you use Uniform Invoice Software, the voucher# could be generated automatically by clicking the "Save To DB" button.

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

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

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

... 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 Sample Service Invoice Template: Using Line Number Instead of Item# 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 Sample Service Invoice Template: Using Line Number Instead of Item# 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 Sample Service Invoice Template: Using Line Number Instead of Item# 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.

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

... 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 Template for Excel

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

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

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

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

Donation Receipt Template for Excel

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

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

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

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

Parts and Labor Invoicing Formatc4071

Parts and Labor Billing Format for Excel

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

... For example, in the first section for labor / service, where you itemize the work or job that you have done. The default tax name is "tax 1" in this part, with the calculation formula assigned as "=ROUND(oknTax1Rate*SUM(oknLinetotal_1:oknLinetotal_6),2)"; and the formula of the total charges for labor / service is calculated with the formula "=ROUND(oknTax1+SUM(oknLinetotal_1:oknLinetotal_6),2)".

... Note that if you or your client are UK (United Kingdom)-based, your invoices must meet specific requirements as detailed on Invoicing and taking payment from customers, and our sample templates include Hourly Service Invoice Template (UK Currency) etc. For Australian-based users, note the Requirements on Issuing tax invoices, and we've built sample Excel invoice templates here on InvoicingTempte.com, including Australian GST Invoice Template, Australian GST Invoice Template (2), etc.

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.

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.

... As an owner who runs a business relating to sporting, 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 InvoicingTemplate.com that is somewhat related to sporting, but you may prefer to look at another option? This one might be interesting for you.

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

Simple Billing Format for Contractor

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

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.

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

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

... Note due to the internal hyperlink handling / caching mechanism of Microsoft Excel, the payment button does not work directly on the Excel spreadsheet template. Furthermore, the link on the Excel spreadsheet is just a template, which includes variables such as "oknBalanceDue" and "oknInvoiceID". However when generating the PDF invoice, Uniform Invoice Software will update the link to replace the variables with transaction details reflected on the current invoice - for example, the invoice# will be inserted to item description, the invoice balance will be the amount to pay.

Simple Sales Invoice Template without Item Descriptionc8002

Simple Sales Invoice Template 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.

... Please refer to Simple Service Invoice Template without Item Description to learn how we prevent the warning message shown by Uniform Invoice Software regarding the missing of a description.

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

... InvoicingTemplate.com offers you this free invoice template in Microsoft Excel spreadsheet format. Beside an ease with formatting and content order, catering invoice templates are furthermore much productive and handy to smooth your process of writing identical document for repetitive needs. If you just started a catering business, use this template as a starting point. Catering Invoice Template, or Catering Billing Format, like all the other templates available here on InvoicingTemplate.com, could be customized with various tools provided by Microsoft Excel. For example, you can change the fonts, colors, background colors etc. If you are not satisfied with a pure Excel invoicing template and need more features, like send electronic invoices in PDF format to your customer, simply install Uniform Invoice Software, which is our invoicing app that could upgrade the invoicing templates here to complete invoicing system.

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.

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

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

Photography Receipt Template (Detail)c8005

Photography Receipt Template (Detail)

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

... The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Photography Receipt Template (Detail) without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with our invoicing software installed.

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.

... Creating an invoice using Photography Invoicing Template is as easy as fill in a paper form. Our templates are offered in Microsoft Excel spreadsheet format. A PDF version, which is generated using Microsoft Excel, is also included. The template is provided free of charge, yet it produce beautiful and professional results that could be found only with some expensive invoicing software programs. However if you need more from your invoicing system, such as management of your clients / customers, reporting on sales, customers and products, simply install Uniform Invoice Software, which is our invoicing app that support all the templates you can download here on InvoicingTemplate.com.

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.

... 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
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
c4071
Parts and Labor Invoicing Format
Thursday, May 12, 2016,
18
4
A4
Portrait
Sales
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